Log in

View Full Version : Db changes for Live client


Bigpull
07-12-2003, 02:01 PM
I can't seem to find the post these were discussed in, so i start a new one cause i suck like that...


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

tcsmyworld
07-12-2003, 06:29 PM
are these changes just for the few servers running 44LC?
or are these changes that need to be implemented to 44 release DB's?

Bigpull
07-13-2003, 10:07 AM
The new stuff. 0.5.0-dr1, soon to be on sf cvs.

(Sometime hopefully this week)
Whats on sf now will have it's version bumped to 0.4.5, and go out as a bugfix/landmark. Then 0.5.0 will be uploaded, please note it's not ready for mass consumption.

tcsmyworld
07-13-2003, 10:11 AM
Thanks BigPull , I read in development forum of other DB changes to be implemented , are they still in the works?