House Auction system for WEB

[Paxton]

Hi there.

I will be developing auction system for Modern AAC, housing of course.

Unfortunately, I'm not so into Tibia and I don't really know how it should workd. I've checked the database most of the tables are self explanatory, but not all of them.


Houses Table
id - we know.
world_id - we know
owner - ID of the player
paid - If it's been paid? What is the value 1 or 0?
warnings - explain this please
lastwarning - and this
name - name of the house?
town - ID of the town?
size - how many sqms ?
price - price for what? overall?
rent - how much is the rent?
doors - amount of doors?
beds - amount of beds?
tiles - how many sqms again?
guild - if it's guild house or not? what is the value? 1 or 0?
clear - is it empty?

Another question. Only the guild owner can buy guild house right? Is there any difference?

House auctions table
house_id - ID of the house in houses table?
world_id - we know
player_id - ID of player currently bidding?
bid - how much he is bidding?
limit - Got no idea what it is
endtime - ending of auctions in UNIX timestamp?

What do I have to clean in database to make the house free? Or what makes it free?

Thanks

 

[Xampy]

Houses Table
id - ID of the house
world_id - world id
owner - ID of the player
paid - i dont know
warnings - i dont know
lastwarning - i dont know
name - name of the house, yes
town - ID of the town, yes
size - how many walkable-sqms
price - depending on "housePriceEachSquare" config.lua value (if size = 100 and housePriceEachSquare = 500 || price = 100*500)
rent - i dont know
doors - amount of doors, yes
beds - amount of beds, yes
tiles - how many sqms (including non-walkable: beds, dustbin, etc)
guild - if it's guild house or not? what is the value? 1 or 0? - idk, but i think so, yes
clear - is it empty? - idk

About house_auctions, I don't know XD.

Good luck !

What do I have to clean in database to make the house free? Or what makes it free?

Free of owning (Nobody owns this house)?
With server offline:

UPDATE `houses` SET `owner` = 0, `lastwarning` = 0 WHERE `id` = XX;

And, if online, the unique option is changing it ingame (I think).

 

[stian]

paid - Date the house was paid.
warnings - How many "rent overdue" warning does this house have
lastwarning - When was the last warning given.
rent - if you choose rent mode in config, then this is simply, the rent to pay each time.

That should cover them all

 

[Pitufo™]

To know more about how auction system works go to tibia.wikia:

House - TibiaWiki - Quests, Items, Spells, and more

Edit: My Firefox lagged and i double posted, sorry, you can delete this one if you can.

 

[Pitufo™]

Here you can learn more about how the auction system works:

House - TibiaWiki - Quests, Items, Spells, and more

About the database tables and columns i really dont know since i never bought one.

 

[Paxton]

Are you guys sure the value of guild is 1 or 0?