EQEmulator Forums - Fixed "start

CVS (Original) database.cpp -> Line 12815

Code:

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

Code:

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:

Code:

        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:

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',

 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