No NPC's

[Moonbay]

I know some 1 can help with this1. Log in, character is up and working, just no npc's any where. please help
:man:

 

[Moonbay]

1)alter table creature_proto change health minhealth int(30) unsigned not null;
2)alter table creature_proto add column maxhealth int(30) unsigned not null after minhealth;
3)update creature_proto set maxhealth=minhealth;
4)alter table creature_proto change level minlevel int(30) unsigned not null;
5)alter table creature_proto add column maxlevel int(30) unsigned not null after minlevel;
6)update creature_proto set maxlevel=minlevel;
7)alter table creature_proto add column invisibility_type int(30) unsigned not null;
8)alter table creature_proto add column death_state int(30) unsigned not null;

I did this ,but I'm not sure what to do at steps 3 & 6, {what to do or how to do it}.
FYI: I'm using SQLyog61EntTrial.exe to do this.

 

[jab416171]

just go to sqlyog, select the right database, and put this in the "Query" window. Right-click, execute query, execute all queries.

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;