Fixed "start_zones"

[Avatarius]

CVS (Original) database.cpp -> Line 12815

if (RunQuery(query, MakeAnyLenString(&query, "SELECT x,y,z,zone_id FROM start_zones WHERE player_choice=%i and player_class=%i and player_deity=%i and player_race=%i", in_cc->start_zone, in_cc->class_, in_cc->deity, in_cc->race), errbuf, &result)) {

CVS (Original) databse.cpp -> Line 12819

if (mysql_num_rows(result) == 4) {

			row = mysql_fetch_row(result);

			in_pp->x = atoi(row[0]);

			in_pp->y = atoi(row[1]);

			in_pp->z = atoi(row[2]);

			in_pp->zone_id = atoi(row[3]);

			mysql_free_result(result);

			return true;

		}

My suggestion:

	if (RunQuery(query, MakeAnyLenString(&query, "SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE player_choice=%i and player_class=%i and player_deity=%i and player_race=%i", in_cc->start_zone, in_cc->class_, in_cc->deity, in_cc->race), errbuf, &result)) {
        
		safe_delete_array(query);

		if (mysql_num_rows(result) != 0) {

			row = mysql_fetch_row(result);

			in_pp->y = atoi(row[0]);

			in_pp->x = atoi(row[1]);
			
			in_pp->z = atoi(row[2]);
			
			in_pp->zone_id = atoi(row[3]);

			in_pp->bind_zone_id = atoi(row[4]);

			mysql_free_result(result);

			return true;

		}

MYSQL Table for "start_zones" must be changed also:

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',
 bind_id int(4) NOT NULL default '0',
 player_choice int(2) NOT NULL default '0',
 player_class int(2) NOT NULL default '0',
 player_deity int(4) NOT NULL default '0',
 player_race int(4) NOT NULL default '0'
) TYPE=MyISAM;

-- Values for Human Wizards

INSERT INTO start_zones VALUES (314,-653,3.75,1,2,1,12,396,1);
INSERT INTO start_zones VALUES (138,-710,17.75,9,9,4,12,396,1);
INSERT INTO start_zones VALUES (309,-353,-38.22,45,2,1,12,201,1);
INSERT INTO start_zones VALUES (-38,-250,-94.22,10,9,4,12,206,1);
INSERT INTO start_zones VALUES (314,-653,-3.75,1,2,1,12,207,1);
INSERT INTO start_zones VALUES (138,-710,17.75,9,9,4,12,204,1);
INSERT INTO start_zones VALUES (138,-710,17.75,9,9,4,12,208,1);
INSERT INTO start_zones VALUES (314,-653,-3.75,1,2,1,12,212,1);
INSERT INTO start_zones VALUES (314,-653,-3.75,1,2,1,12,213,1);
INSERT INTO start_zones VALUES (138,-710,-17.75,9,9,4,12,213,1);

and it works

--kathgar: I added [CODE] tags