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

Share
 

 creature spawn bug fix

Go down 
AuthorMessage
Suenc

Suenc

Posts : 9
Join date : 2010-07-11

creature spawn bug fix Empty
PostSubject: creature spawn bug fix   creature spawn bug fix EmptyWed 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

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