Originally Posted by
Hardball
This is an outstanding release. I am curious though. Obviously you have added custom fields to the database? So exactly which tables did you alter and what did you add to them? Also another question I have is exactly what do we do with the "custom" folder and the "web" folder that come in the download link?
There is one new table in the char database. It contains all info related to land properties.
Code:
CREATE TABLE `player_real_estate` (
`accountid` int(11),
`ownerguid` int(11),
`guildid` int(11),
`mapid` int(11),
`positionX` float,
`positionY` float,
`positionZ` float,
`lenghtX` float,
`lenghtY` float,
`lease_start` int(11),
`lease_exp` int(11),
`pvp` int(11),
`earned` int(11)
)
The world database also has 1 new table. Since players can learn any spell, the system needs to keep track of spells that a class can normaly use. This way the system can block or allow uber spells depending on the player's location and land permissions. I'm sure there's a better way to achieve that goal, but that's what I came with. There's a script in the custom folder that fills that table using data directly from wowhead. The best is to grab the table contents from this distribution.
Code:
CREATE TABLE `spell_class` (
`spellid` int(11) default NULL,
`classid` int(11) default NULL
)
The account table of the logon database has 1 added field in this distribution. That has nothing to do with the land stuff. This is to implement a system that forces players to vote for globalwow on voting sites
Players need to vote every 12 hours to use the GM commands inside the game.
Code:
`lastvote` timestamp,
--------------------
The custom folder is a bunch of utility shit scripts I put together over the time. There is one to level up all NPC to 60+. There is one that runs every day that frees expired lands. Look inside before using.
The web folder has the files for the voting system and the files for the landmap app. Again look inside before using. GlobalWow.net landmap