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

[tromboneguy007]

Thank you x6x6x6x for your help. As I mentioned I am new to this so I appreciate the patience.

I will keep plugging away on it. I am trying the rev47 of the DB, so hopefully that will help.

[Porthorion]

keazain it would be a big help if you made a video of this on youtube on how to set it up it would help me so much if you would thankyou or Heph

[necro4lif3]

How do I get into the DB for like accounts and such?

[keazain]

later we will add a video of how to do it, only now we got a readme in our treat of how to !

necro> download our DB Editors and use ex. sqlylog for editing your db

[Mango Jerry]

Hi Keazain.
There's a problem for the Ascent Core's to Read the DBC Files.

Edit:

Please host he Maps and the VMaps to your Official Website to, please.
My Download Speed is very bad on Filekeeper.

[twidget]

keazain and all...

been out of town a few days... what is the best wrkign world at this time??? i am going to try Whydb right now. Also, are there any updates to the cores that have gotten instances up in northrend working??

Also, where is the link to the fun server??? i looked thinking it would be up now, is it? i may have missed it..

[keazain]

Hi Twidget, fun & pvp repack is up, just below t7 hear pictures for download. My own FUN Extreme is up before im going to bed today and, whydb is NOT the best for wotlk server, just for you to know

Hephaestus, hi m8, im making the best arcemu core you can get now and after that im making my own modified ascent core etc. with all works in it... maps, vmasp have to wait a little time yet, i have to see how mutch traffic those make first

[twidget]

Hi Twidget, fun & pvp repack is up, just below t7 hear pictures for download. My own FUN Extreme is up before im going to bed today and, whydb is NOT the best for wotlk server, just for you to know

Hephaestus, hi m8, im making the best arcemu core you can get now and after that im making my own modified ascent core etc. with all works in it... maps, vmasp have to wait a little time yet, i have to see how mutch traffic those make first

in your opinion what is the best world DB to use?

[keazain]

absolutely NCDB and sunplusplus updated thats the most ready wotlk server you get pt.

[Mango Jerry]

I recommend NCDB.

[twidget]

I recommend NCDB.

I was installing the SQL from the 03.01.2009 Rev.47 - NCDB rev.47!

and when i got to changeset_43.sql i got an error pasted at end of this post... so i tried to load the world.. and got a creature table error, and there are no mobs in the world... Any ideas???


It completes 6675 queries and 12073 kb of the 12118kb

Query:
REPLACE INTO worldmap_info
(entry, screenid, type, maxplayers, minlevel, repopx, repopy, repopz, repopentry, area_name, flags, cooldown, lvl_mod_a, required_quest, required_item, heroic_keyid_1, heroic_keyid_2, viewingDistance, required_checkpoint)
VALUES
(0, 0, 0, 0, 1, 0, 0, 0, 0, "Eastern Kingdoms", 1, 0, 0, 0, 0, 0, 0, 800, 0)

Error occured at:2009-01-03 19:23:00
Line no.:4
Error Code: 1046 - No database selected

Query:
create table temp select entry, item, count(*) from vendors group by entry, item having count(*) > 1

Error occured at:2009-01-03 19:23:35
Line no.:31
Error Code: 1050 - Table 'temp' already exists

Query:
DROP TABLE IF EXISTS `quests_emotes`

Error occured at:2009-01-03 20:16:57
Line no.:2
Error Code: 1046 - No database selected

Query:
DROP TABLE IF EXISTS `areatrigger_involvedrelation`

Error occured at:2009-01-03 20:18:36
Line no.:22
Error Code: 1046 - No database selected

Query:
REPLACE into `loot_milling`(`item_entry`,`itemid`,`percentchance`,`heroicpercentchance`,`minc ount`,`maxcount`,`ffa_loot`) values (765,39151,100,0,2,3,0),(765,4604,0.6,0,1,2,0),(2447,39151,100,0,2,4,0),(2447,46 04,0.6,0,1,2,0),(2449,39151,100,0,2,4,0),(2449,4604,1.2,0,1,2,0),(2450,39334,100 ,0,2,4,0),(2450,43103,24.18,0,1,3,0),(2450,4605,1.7,0,1,2,0),(2450,43557,0.005,0 ,1,1,0),(2450,39151,0.005,0,3,3,0),(22710,39151,100,0,2,3,0),(785,39334,95.37,0, 2,3,0),(785,43103,23.95,0,1,3,0),(785,39151,4.63,0,2,4,0),(785,4604,1.62,0,1,2,0 ),(2452,39334,100,0,2,4,0),(2452,43103,23.92,0,1,3,0),(2452,4605,1.46,0,1,2,0),( 2452,43557,0.02,0,1,1,0)

Error occured at:2009-01-03 21:38:22
Line no.:26689
Error Code: 1054 - Unknown column 'item_entry' in 'field list'

Query:
REPLACE into `loot_milling`(`item_entry`,`itemid`,`percentchance`,`heroicpercentchance`,`minc ount`,`maxcount`,`ffa_loot`) values (765,39151,100,0,2,3,0),(765,4604,0.6,0,1,2,0),(2447,39151,100,0,2,4,0),(2447,46 04,0.6,0,1,2,0),(2449,39151,100,0,2,4,0),(2449,4604,1.2,0,1,2,0),(2450,39334,100 ,0,2,4,0),(2450,43103,24.18,0,1,3,0),(2450,4605,1.7,0,1,2,0),(2450,43557,0.005,0 ,1,1,0),(2450,39151,0.005,0,3,3,0),(22710,39151,100,0,2,3,0),(785,39334,95.37,0, 2,3,0),(785,43103,23.95,0,1,3,0),(785,39151,4.63,0,2,4,0),(785,4604,1.62,0,1,2,0 ),(2452,39334,100,0,2,4,0),(2452,43103,23.92,0,1,3,0),(2452,4605,1.46,0,1,2,0),( 2452,43557,0.02,0,1,1,0)

Error occured at:2009-01-03 21:39:43
Line no.:26689
Error Code: 1054 - Unknown column 'item_entry' in 'field list'

Query:
REPLACE INTO `loot_milling` (`item_entry`,`itemid`,`percentchance`,`mincount`,`maxcount`) VALUES
('765','39151','100','2','3'),('765','4604','0.607930732741','1','2')

Error occured at:2009-01-03 21:40:06
Line no.:4
Error Code: 1054 - Unknown column 'item_entry' in 'field list'

Query:
REPLACE INTO `loot_milling` (`item_entry`,`itemid`,`percentchance`,`mincount`,`maxcount`) VALUES
('765','39151','100','2','3'),('765','4604','0.607930732741','1','2')

Error occured at:2009-01-03 21:50:18
Line no.:4
Error Code: 1054 - Unknown column 'item_entry' in 'field list'

Query:
REPLACE into `loot_milling`(`item_entry`,`itemid`,`percentchance`,`heroicpercentchance`,`minc ount`,`maxcount`,`ffa_loot`) values (765,39151,100,0,2,3,0),(765,4604,0.6,0,1,2,0),(2447,39151,100,0,2,4,0),(2447,46 04,0.6,0,1,2,0),(2449,39151,100,0,2,4,0),(2449,4604,1.2,0,1,2,0),(2450,39334,100 ,0,2,4,0),(2450,43103,24.18,0,1,3,0),(2450,4605,1.7,0,1,2,0),(2450,43557,0.005,0 ,1,1,0),(2450,39151,0.005,0,3,3,0),(22710,39151,100,0,2,3,0),(785,39334,95.37,0, 2,3,0),(785,43103,23.95,0,1,3,0),(785,39151,4.63,0,2,4,0),(785,4604,1.62,0,1,2,0 ),(2452,39334,100,0,2,4,0),(2452,43103,23.92,0,1,3,0),(2452,4605,1.46,0,1,2,0),( 2452,43557,0.02,0,1,1,0)

Error occured at:2009-01-03 21:52:54
Line no.:26689
Error Code: 1054 - Unknown column 'item_entry' in 'field list'

[Mango Jerry]

The Queries dosn't fit to your Database.
These Queries dosn't support your Database (Revision)

[twidget]

The Queries dosn't fit to your Database.
These Queries dosn't support your Database (Revision)

So what database should i be using to add the NCDB stuff??? I am using the

ARCEMU CORE:

03.01.2009 Rev.1974

I am deleting the world_blizz DB out of my server, and importing the database.sql from the NCDB rev.47 then going to try the changesets on that... am i on the right track with that?

Thanks...

[Mango Jerry]

Yes, try doing that, Twidget.
If it dosn't work, try to get WhyDB.

[tromboneguy007]

Thank you x6x6x6x for your help. As I mentioned I am new to this so I appreciate the patience.

I will keep plugging away on it. I am trying the rev47 of the DB, so hopefully that will help.

I can't seem to get anything to work. No matter what core, or DB revision I use, I keep getting the same error. I have tried a different computer with XP instead of vista, still no luck.

I am not sure what else to do....anyone have suggestions?