[X3 Release] Keazain`s Latest Compiles and Converted NCDB & Logon DB ready for use!

[keazain]

closed! only at my own place

Regards from Keazain

[eluzai777]

I havent tried any of the 19xx Arcemus. Ive been using 1897 mainly because i havent been able to get the 19xx revs to work. Im guessing they are not compatible with the ncdbs ive been using(42 - 46). I will give this one a try.

Do you know if any class spells have been fixed or updated? Im interested the most in a core rev that have class spells and talents working since those cant be fixed or updated through the database.

[Fugunsk]

I have a problem, base is not installed!

[eluzai777]

Ok i was just installing the database with Navicat lite 8 and im getting an error.

[Err] 2006 - MySQL server has gone away
[Err] /*Data for the table `creature_names` */

insert into `creature_names`(`entry`,`name`,`subname`,`info_str`,`Flags1`,`type`,`family`,`r ank`,`unk4`,`spelldataid`,`male_displayid`,`female_displayid`,`male_displayid2`, `female_displayid2`,`unknown_float1`,`unknown_float2`,`civilian`,`leader`) values (0,'Spawn Point (Only GM can see it)','','',0,1,0,3,0,0,262,0,0,0,1,1,NULL,0),(1,'Waypoint (Only GM can see it)','Visual','',5242886,8,8,0,0,0,10045,0,0,0,1,1,NULL,0),(3,'Flesh Eater','','',0,6,0,0,0,0,987,0,0,0,1.02,1,NULL,0),(6,'Kobold Vermin','','',0,7,0,0,0,0,10913,0,0,0,1,1,NULL,0),(19,'Benny Questgiver','NPC','',0,7,0,0,0,0,6074,0,0,0,1,1,NULL,0),(29,'Kanrethad','Master of Death','',0,7,0,0,0,0,25275,0,0,0,1250,1,NULL,0),(30,'Forest Spider','','',1,1,3,0,0,5880,382,0,0,0,1,1,NULL,0),(31,'Furbolg','','',0,0,0,0,0 ,0,145,0,0,0,1,1,NULL,0),(36,'Harvest Golem','','',32768,9,0,0,0,0,367,0,0,0,1,1,NULL,0),(38,'Defias Thug','','',0,7,0,0,0,0,5035,5036,0,0,1,1,NULL,0),(40,'Kobold Miner','','',0,7,0,0,0,0,373,0,0,0,1,1,NULL,0),(43,'Mine Spider','','',1,1,3,0,0,10495,368,0,0,0,1,1,NULL,0),(46,'Murloc Forager','','',0,7,0,0,0,0,441,0,0,0,1,1,NULL,0),(48,'Skeletal Warrior','','',0,6,0,0,0,0,200,0,0,0,1.02,1,NULL,0),(49,'Lesser Succubus','','',0,3,0,0,0,0,159,0,0,0,1,1,NULL,0),(54,'Corina Steele','Weaponsmith','',0,7,0,0,0,0,1287,0,0,0,1,1,NULL,0),(55,'Mean Ed the Blacksmith','','',0,7,0,0,0,0,17,0,0,0,1,1,NULL,0),(60,'Ruklar the Trapper','','',0,7,0,0,0,0,2153,0,0,0,1,1,NULL,0),(61,'Thuros Lightfingers','','',0,7,0,4,0,0,3341,0,0,0,1,1,NULL,0),(62,'Gug Fatcandle','','',0,7,0,0,0,0,26,0,0,0,1,1,NULL,0),(65,'Peasant Woman','','',0,7,0,0,0,0,13,0,0,0,1,1,NULL,0),(66,'Tharynn Bouden','Trade Supplies','',0,7,0,0,0,0,1298,0,0,0,1,1,NULL,0),(67,'[UNUSED] Marlon Darnik','Grocer','',0,7,0,0,0,0,23,0,0,0,1,1,NULL,0),(68,'Stormwind City Guard','','Directions',0,7,0,0,0,0,3167,5446,0,0,1.5,1,NULL,0),(69,'Timber Wolf','','',1,1,1,0,0,13060,604,0,0,0,1,1,NULL,0),(70,'[UNUSED] Lower Class Citizen','','',0,7,0,0,0,0,13,0,0,0,1,1,NULL,0),(71,'Rankist','','',0,0,0,0,0,0, 137,0,0,0,1,1,NULL,0),(72,'[UNUSED] Antaris the Trader','','',0,7,0,0,0,0,19,0,0,0,1.2,1,NULL,0),(73,'Veraina the Apothecary','Questgiver','',0,7,0,0,0,0,15,0,0,0,1.15,1,NULL,0),(74,'Kurran Steele','Cloth & Leather Armor Merchant','',0,7,0,0,0,0,1289,0,0,0,1,1,NULL,0),(75,'[UNUSED] Vashaum Nightwither','','',0,7,0,0,0,0,166,0,0,0,1,1,NULL,0),(78,'Janos Hammerknuckle','Weaponsmith','',0,7,0,0,0,0,3275,0,0,0,1,1,NULL,0),(79,'Narg the Taskmaster','','',0,7,0,4,0,0,774,0,0,0,1.3,1,NULL,0),(80,'Kobold Laborer','','',0,7,0,0,0,0,365,0,0,0,1,1,NULL,0),(81,'[UNUSED] Luglar the Clogger','','',0,7,0,0,0,0,371,0,0,0,1,1,NULL,0),(82,'Crazy Leonetti','','',0,7,0,0,0,0,16,0,0,0,1,1,NULL,0),(87,'Forest Troll Berserker','','',0,7,0,0,0,0,167,0,0,0,1,1,NULL,0),(89,'Infernal','','',0,3,19,0 ,0,0,169,0,0,0,1.9,1,NULL,0),(90,'Sea Giant','','',0,5,0,0,0,0,791,0,0,0,1,1,NULL,0),(92,'Rock Elemental','','',0,4,0,0,0,0,171,0,0,0,1.15,1,NULL,0),(93,'Centaur','','',0,0,0, 0,0,0,172,0,0,0,1,1,NULL,0),(94,'Defias Cutpurse','','',0,7,0,0,0,0,2361,2362,0,0,1,1,NULL,0),(95,'Defias Smuggler','','',0,7,0,0,0,0,4418,4419,0,0,1,1,NULL,0),(97,'Riverpaw Runt','','',0,7,0,0,0,0,10791,0,0,0,1,1,NULL,0),(98,'Riverpaw Taskmaster','','',0,7,0,0,0,0,376,0,0,0,1,1,NULL,0),(99,'Morgaine the Sly','','',0,7,0,4,0,0,3320,0,0,0,1,1,NULL,0),(100,'Gruff Swiftbite','','',0,7,0,4,0,0,175,0,0,0,1,1,NULL,0),(102,'Bronze Dragonspawn','','',0,0,0,0,0,0,177,0,0,0,1,1,NULL,0),(103,'Garrick Padfoot','','',0,7,0,0,0,0,2073,0,0,0,1,1,NULL,0),(105,'Tall Strider','','',0,0,12,0,0,0,178,0,0,0,1,1,NULL,0),(106,'Kodo Beast','','',0,1,0,0,0,0,179,0,0,0,1,1,NULL,0),(107,'Raptor','','',1,1,11,0,0,0, 180,0,0,0,1,1,NULL,0),(108,'Green Dragonspawn','','',0,0,0,0,0,0,181,0,0,0,1,1,NULL,0),(109,'White Dragonspawn','','',0,0,0,0,0,0,182,0,0,0,1,1,NULL,0),(111,'Priest','','',0,7,0,0 ,0,0,20,0,0,0,1,1,NULL,0),(112,'Priestess','','',0,7,0,0,0,0,14,0,0,0,1,1,NULL,0 ),(113,'Stonetusk Boar','','',1,1,5,0,0,9081,503,0,0,0,1,1,NULL,0),(114,'Harvest Watcher','','',0,9,0

[Zombienation]

The error you are getting is "MySQL server has gone away" and thats the same error I'm getting, but it obviously hasnt gone away seeing as its up right now.

[keazain]

eluzai777> yes its a big problem by those dump files, i will make a new dump and put it up instedt of this
and all 1940 and up is very stable and yes spells etc is more than updated, only some few bugs left by this time

[Fugunsk]

I really want to run the server and the database does not fill! What should I do?

[Fugunsk]

Tell me please what needs to be coasting to work with the kernel rev1943 base NCDB rev46 if I can not fill 47

[keazain]

i will make a mysql data dir now and upload for you, then you just have to copy this to your mysql datadir and run server

[Jonthe838]

Realy nice thread +Rep do the new arcemu rev work with the DB's? and do u have any sql-update file becous i already have a db ^^

[keazain]

MySql data dir is now uploaded, check the pink download! just unzip, copy to your mysql data dir and start server

[keazain]

tomorow i will release X3 updater from my own dev.

[keazain]

yes, the new arcemu is working fine with all NCDB DB from rev. 30 and up

[eluzai777]

Ok i downloaded mysql data and when extracted with winrar i get another error

! C:\Users\Administrator\Desktop\mysql_data_dir.rar: CRC failed in world_blizz\loot_creatures.MYI. The file is corrupt
! C:\Users\Administrator\Desktop\mysql_data_dir.rar: Unexpected end of archive

[Fugunsk]

And you can tell there are any changes in the structure of DK