
Originally Posted by
Julian_X
if this only wrks for TN8 it's outta date then
but, it's possible to convert code to work with actual database
Code:
ALTER TABLE `creature_proto` CHANGE health minhealth int(30) unsigned not null;
ALTER TABLE `creature_proto` ADD column maxhealth int(30) unsigned not null after minhealth;
UPDATE `creature_proto` SET maxhealth=minhealth;
ALTER TABLE `creature_proto` CHANGE level minlevel int(30) unsigned not null;
ALTER TABLE `creature_proto` ADD column maxlevel int(30) unsigned not null after minlevel;
UPDATE `creature_proto` SET maxlevel=minlevel;
ALTER TABLE `creature_proto` ADD column invisibility_type int(30) unsigned not null;
ALTER TABLE `creature_proto` ADD column death_state int(30) unsigned not null;