Housing System using instance

[sikiro]

would it be possible to create housing  using instance system i know there is a very old housing system arround but it required adding duplicate maps to the game and it was very time consuming.  i am terrible at scripting but i do understand how it works if you can point me in the right direction i can most likely finish it or add to it.

[sikiro]

Bump?

[Skorm]

This is something I though about doing a long time ago but I wanted to add much more to it. In any case this is a request that I won't be undertaking.

[sikiro]

awww alright well can you at least point me in the right direction as to getting it started. i am not the best at scripting but if iget an idea on how to sort out the houses etc i can do the rest.

[Zell]

I made a House System like that and a can tell you that is not a simple thing for a beginner. A lot of situations that can bug and exploits depending of your server confs (no warp and etc).
 

 

[sikiro]

i understand the risks but i will never learn if i dont try i asked for some guidance plus yours is very complex with construction i dont need any of that to begin at least.

Edited March 13, 2017 by sikiro

[Skorm]

8 hours ago, Zell said:

I made a House System like that and a can tell you that is not a simple thing for a beginner. A lot of situations that can bug and exploits depending of your server confs (no warp and etc).

Pretty cool results. : )

[Zell]

20 hours ago, sikiro said:

i understand the risks but i will never learn if i dont try i asked for some guidance plus yours is very complex with construction i dont need any of that to begin at least.

Actually create a instance attached to a player and manipulate it is easy. What is your difficult?

[sikiro]

how can i permanently attach it to a player.

 

[Skorm]

4 hours ago, sikiro said:

how can i permanently attach it to a player.

 

You don't you either use variables or an sql table with all the players specifics like, locations, house, and all that other junk. Then use that information to dynamically build the house when the instance is created.

[sikiro]

sounds very confusing T_T ill look into it i have never done any sql work before. thank you!

Edited March 14, 2017 by sikiro

[Zell]

My table structure for house system is something like this:

Table: house

char_id       = Id of a char (Primary Key)
id                = House ID
status         = 1 if placed and 0 if not
map            = Map name
x                 = X (/where)
y                 = Y (/where)
intance_id =  instance id
 

[sikiro]

aah makes it easier so far ive been able to create the instance now to learn how to save data to sql and extract it ! ive also noticed there is a housing script you have been hiding Skorm! and i like the idea of renting and selling wouild be it be posible to fix up a bit and making it instance based? 

 

http://upaste.me/acb21058336c53f2b

Edited March 17, 2017 by sikiro

[Skorm]

On 3/16/2017 at 8:44 PM, sikiro said:

aah makes it easier so far ive been able to create the instance now to learn how to save data to sql and extract it ! ive also noticed there is a housing script you have been hiding Skorm! and i like the idea of renting and selling wouild be it be posible to fix up a bit and making it instance based? 

 

http://upaste.me/acb21058336c53f2b

Oh yeah I was trying to do some cheeky stuff to save the houses information and all that junk. It's buggy but I'll probably see if I can't fix it up tomorrow. I don't know about the instance bit. Sure it wouldn't be very hard but I don't really see the point.

[sikiro]

omg would be awsome i think the reasoning behind the instances is to prevent duplicating maps.

[Skorm]

14 hours ago, sikiro said:

omg would be awsome i think the reasoning behind the instances is to prevent duplicating maps.

Here is a "working version" there are still some bugs that I'm aware of but I really don't feel like spending anymore time on this script. If I was to make an instance house system I would start from the ground up.
http://upaste.me/71e44369959bcfea1

[sikiro]

@zell so i have been working on concepts and getting things to work the way i want them to so progress is good is there any posibility for you to show me an example of  the sql bit of pulling info for a player house and as well as when they buy one inputing the information. so far i can teleport to the house and add remove npcs but it is temporary sadly.