I reseted lvs on my ot. Now all houses say "It belongs to house xxx. . owns it" how

[Luciano]

how can i reset houses?
PMA comand?
cuz it keep that . :S

 

[Luciano]

srry - i reseted chars + accs ;p

 

[JoccE]

Empty the House table and House_items table

 

[Luciano]

hey can someone give me comand for MPA to do this:
put everyone lv 1 with 1000 mana and 1000 health

hm so i need do 1 per one? no PMA comand?

 

[JoccE]

If you mean that every player will get lvl 1 with 1k hp / mana
then this is the query

UPDATE players
SET level = 1, healthmax = 1000, manamax= 1000, mana = 1000, health = 1000

 

[Luciano]

BUMP - still need query to reset houses //

 

[JoccE]

DELETE FROM `houses`

There you have

 

[Luciano]

srry - i need empty house and house_item;p

 

[JoccE]

just do the same again but house_item instead of house -.-

 

[koob]

UPDATE houses SET owner=0;