Light Hope Database developed by Eatos.The blizlike database for Arcemu
 
HomeCalendarFAQSearchMemberlistUsergroupsRegisterLog in

Share | 
 

 creature spawn bug fix

Go down 
AuthorMessage
Suenc

avatar

Posts : 9
Join date : 2010-07-11

PostSubject: creature spawn bug fix   Wed Jul 14, 2010 11:58 pm

just run this query in world database

-- Moving death_state into creature_spawns table
ALTER TABLE `creature_spawns` ADD `death_state` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `standstate`;
ALTER TABLE `creature_staticspawns` ADD `death_state` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `standstate`;
UPDATE creature_spawns cs INNER JOIN creature_proto cp ON cs.Entry = cp.Entry SET cs.death_state = cp.death_state;
ALTER TABLE `creature_proto` DROP `death_state`;
Back to top Go down
View user profile
 
creature spawn bug fix
Back to top 
Page 1 of 1
 Similar topics
-
» Large, Strange Sea Creature Found In Persian Gulf
» Bitten by Cat/Fox (Unknown Creature in General)
» Descole's Office (The Ministry of Magic, London- Creature control/Auror area )
» Seeing Huge Spiders and Crab Like Creature
» swinging from vines and vine like creature.

Permissions in this forum:You cannot reply to topics in this forum
Light Hope Database :: Light hope Database :: Bug reports-
Jump to: