[SQL]: Creature_Spawn Table Errors/More

[QQrofl]

If you get any errors once you download a repack or compile you a new core, just query these sql files:

I'm getting tired of searching on arcemu for these, so i posted them on here to be a lazy searcher.


The sqls will fix the following errors:
- One of your creature_spawns table has the wrong column count.
arcemu has skipped loading this table in order to avoid crashing.
Please correct this, if you do not no spawns will show.

- Once you create a character it will no longer crash the server.

SQLS:

UPDATE items SET bagfamily = 0 WHERE bagfamily = 8192;
UPDATE items SET bagfamily = 8192 WHERE entry IN
(37836, 43308, 44990, 43589, 20558, 42425, 29024,
41596, 43016, 20559, 20560, 43228, 40753, 40752,
45624, 29434 );

ALTER TABLE `guilds` DROP COLUMN `bankTabCount`;

alter table `characters` add column active_cheats int(10) unsigned not null default 0 after xp;

alter table `playercreateinfo` add column taximask text(255);

-- human
update `playercreateinfo` set taximask="2" where race=1;
-- orc (2), troll (8)
update `playercreateinfo` set taximask="4194304" where race in (2, 8);
-- dwarf (3), gnome (7)
update `playercreateinfo` set taximask="32" where race in (3, 7);
-- night elf
update `playercreateinfo` set taximask="100663296" where race=4;
-- undead
update `playercreateinfo` set taximask="1024" where race=5;
-- tauren
update `playercreateinfo` set taximask="2097152" where race=6;
-- blood elf
update `playercreateinfo` set taximask="0 0 131072" where race=10;
-- draenei
update `playercreateinfo` set taximask="0 0 536870912" where race=11;

-- death knight
update `playercreateinfo` set taximask="4294967295 4093640703 830406655 0 33570816 1310944

Once you're down doing the updates run this:

Creature_Spawn bat update. (http://www.filefront.com/14144833/ArcEmu%20DB%20Updater.bat)

[Brianplast]

nice:D

[Sanghilia]

+rep :)

[QQrofl]

Thanks. :)

[Leah]

I dont get it :b.

Just want me to copy the things you wrote and save as .sql, and then execute it in the database? s:

[QQrofl]

IF you get errors. Like so:

Query these IF you get the following errors:

One of your creature_spawns table has the wrong column count.
arcemu has skipped loading this table in order to avoid crashing.
Please correct this, if you do not no spawns will show.

- Once you create a character the server will crash.

[st23]

Fascinating.

[Leah]

Dont get it, haha

[arjo112]

Just want me to copy the things you wrote and save as .sql, and then execute it in the database? s:


Yes :)

And nice work !

[QQrofl]

Thanks all.

[ivlonsterr]

didnt fix mine QQrofl Q.Q i copied all the stuff and saved it as a .sql, executed it into the database and i start up the server and still has error...what am i doing wrong?

-Edit-

I have 10 pass and 4 fail

[Err] 1146 - Table 'world.guilds' doesn't exist
[Err] ALTER TABLE `guilds` DROP COLUMN `bankTabCount`;
[Err] 1146 - Table 'world.characters' doesn't exist
[Err] alter table `characters` add column active_cheats int(10) unsigned not null default 0 after xp;
[Err] 1060 - Duplicate column name 'taximask'
[Err] alter table `playercreateinfo` add column taximask text(255);
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"4294967295 4093640703 830406655 0 33570816 1310944' at line 2
[Err] -- death knight
update `playercreateinfo` set taximask="4294967295 4093640703 830406655 0 33570816 1310944
[Msg] Finished - Unsuccessfully

What it tells me for the 4 that failed.

[QQrofl]

What emulator do you use? Plus don't query them all at once, just do one at a time.

[sr71_blkbird]

ya i have no idea how to do this is there an easier way to explain how to edit these or w/e im a noob when it comes to this stuff