Reseting DB problem with houses and player items

bury

Excellent OT User
Joined
Jul 27, 2008
Messages
373
Reaction score
8
I've a problem with two tables.

First one: I dont know how to remove house owners and all the items in the houses. The table "tile_items" it's empty. And in the table "houses" I've set owners = 0 in all the table, but ingame there are some doors that still says "someone owns this house".

Also I've truncate the table player_items, because I want all players starts from level 8 without the items they had etc, but I want them to have the first player items (items that are on the script firstitems, crocodile boots, normal backpack etc).

Do you know how can I do it?

Thanks!
 

Webtimize

Pro Grammer
Joined
Oct 3, 2011
Messages
478
Reaction score
144
Location
The Netherlands
Try truncating and make your server repopulate the houses table upon startup. Make sure your server is offline while truncating.

Starter items are given upon first login. I believe you'll have to reset the lastlogin/lastlogout for every character to achieve that.
 
OP
bury

bury

Excellent OT User
Joined
Jul 27, 2008
Messages
373
Reaction score
8
I shutdown the server and truncated the "house" table. It got repopulated in the startup but all houses keep the items. What is more strange, some house's doors say: nobody owns this house (and shows the price) but other doors says: playerx owns this house. LOL

tile_items table is empty. Maybe house_data?
 
OP
bury

bury

Excellent OT User
Joined
Jul 27, 2008
Messages
373
Reaction score
8
Ok. Truncating the db player_storage the firstitems.lua script works with all players.

Also I could get all the houses cleaned by removing house_data tables and maybe tile_store too.
 
Top