I can't seem to find the post these were discussed in, so i start a new one cause i suck like that...
Code:
CREATE TABLE start_zones (
x float NOT NULL default '0',
y float NOT NULL default '0',
z float NOT NULL default '0',
zone_id int(4) NOT NULL default '0',
player_deity int(4) NOT NULL default '0',
player_race int(4) NOT NULL default '0',
player_class int(2) NOT NULL default '0',
player_choice int(2) NOT NULL default '0'
bind_x float NOT NULL default '0',
bind_y float NOT NULL default '0',
bind_z float NOT NULL default '0',
) TYPE=MyISAM;
Most of that should be straight forward enough, I'll describe player_choice
// 0 = Odus
// 1 = qeynos, 2 = Halas 3 = rivervale, 4 = freeport, 5 = neriak, 6 = Gukta/Grobb, 7 = Ogguk
// 8 = kaladim, 9 = gfay, 10 = felwith, 11 = Akanon, 12 = cabalis
// 13 = Sharval