Most current Burbank sql files and how to edit sql

burbank.sql


That is the most recent verison, it will have all the correct posisitions for the npc's and ent id's for the doors



1st open the money tables and delete all the entries


now open the property table

This is to reset all the properties back to new.


Look at this picture to get an idea of the layout




you want to go along the tab with the owner name and find all the properties that have a name other than the origonal name.
eg. Burbank Police Department, Hideout #3, Kwik-E-Mart



Now that you have found them delete the name and leave it blank, the next field over has a steam id, delete it.

If the owner gave out keys to anyone, it will be in the tab access, delete those too.

Last thing you will want to do is set the price for the property so it can be purchased again.

The next tab over should have a 0 in it, change it to what ever price you want it to sell for.



Now that you know the basics of the property table in sql, you can edit names and prices of the properties. Remember to always make a back-up file befor you start messing around with it though.

Thanks Don, this should save some settings up if i ever want to set up a server to muck around on.

Is this public?

yes

awesome