Can i reset all house's ?

[Teddy]

On my server player wanna have reset in house's `?
is that possible ? to make all house's "no body live here" ? and all item's go to house owners dp..

 

[Agraeln]

I think u can do it in database manager ;P Go to Phpmyadmin and try to do it man

 

[Keiro]

you can delete one by one on ur DB , house_list, or u can making a query to delete all the owners , also clean items

 

[Teddy]

you can delete one by one on ur DB , house_list, or u can making a query to delete all the owners , also clean items

and how do i do that :O

 

[Keiro]

go to ur database....click on house_list.......and u will see all the houses of ur server that have a OWNER , then if u delete them by clicking the red X , they will stay as "nobody own this house"

 

[Teddy]

and item'S?

 

[Keiro]

items are saved on house_data i guess...., u need to clean both, if u want empty houses with no owner ;P , if u clean house_list , houses will stay with "nobody" but items inside....

test this with one house ;P

 

[Keiro]

ok no...not in house_data , ill check this myself and ill give u an answer in few minutes, if none answers before.


EDIT:

you need to clean House_list to clean invited player list on houses, with aleta sio.

and in "houses" are saved the houses....where it says OWNER , u need to put a 0 , 0=nobody own house

if it says 7, is cuz player id 7 , owns the house

SERVER NEEDS TO BE OFFLINE to changge OWNER ID to houses


about the items on houses...idk...im searching

 

[Keiro]

UPDATE houses SET owner = 0 WHERE id > 0


use that on ur DB , put it on SQL , it will set all houses owner in 0 = nobody own house

made by pitufo

edit:sry triple post :S forgot about the one above T_T

 

[Serginov]

But the items will still be in the houses..

 

[Keiro]

yes....i helped in what i could

 

[Teddy]

any good commands ? or script for this ?

 

[JDB]

Set houses to nothing then clean map? :huh:

 

[Teddy]

lol JDB ?
i wanna reset all house so its no owner and all item's that are in the house go to owner's DP

 

[JDB]

oh, I thought you just wanted to clear all houses xd

 

[Teddy]

oh, I thought you just wanted to clear all houses xd

aha naa but thx for a try i rep you xd

 

[EvulMastah]

Well, wont items be transfered to the original owner when you set reset house owners?

 

[Nikkster]

Remove all the text in your houses.xml? and also the ones you are having in your database.