1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Mysql cars loading
Ectazy
Big Clucker
***
Posts: 100
Threads: 24
Joined: Feb 2011
Reputation: 0
#1

09.03.2013, 17:33
( Последний раз редактировалось Ectazy; 10.03.2013 в 08:33. )
Hi all, I have a problem with mysql cars loading (saving okay), loading right here, cars not loading:
Код:
	new Table = 0;
	for(new v; v < MAX_VEHICLES; v++)
	{
	format(query, 1024,"SELECT * FROM "SQL_CARTABLE" WHERE ID = '%d'", v);
	mysql_query(query);
	mysql_store_result();
 	if(Table == 0)
 	{
 	if(mysql_num_rows() != 0)
 	{
 	Table = 1;
 	}
 	else
	{
	Table = 2;
	}
	}
	}
	
	if(Table == 1)
	{
	for(new v; v < MAX_VEHICLES; v++)
	{
	format(query, 1024,"SELECT * FROM "SQL_CARTABLE" WHERE ID = '%d'", v);
	mysql_query(query);
	mysql_store_result();
 	if(mysql_num_rows() != 0)
 	{
 	new model, vehicle, Float:CarFloat[5], tune[13];
	mysql_fetch_field("Owner", sql);
	format(vInfo[v][Owner], MAX_PLAYER_NAME, "%s", sql);
	mysql_fetch_field("Model", sql); model = strval(sql);
        mysql_fetch_field("X", sql); CarFloat[0] = floatstr(sql);
        mysql_fetch_field("Y", sql); CarFloat[1] = floatstr(sql);
        mysql_fetch_field("Z", sql); CarFloat[2] = floatstr(sql);
        mysql_fetch_field("Angle", sql); CarFloat[3] = floatstr(sql);
        mysql_fetch_field("HP", sql); CarFloat[4] = floatstr(sql);
        mysql_fetch_field("Fuel", vInfo[v][Fuel]);
	mysql_fetch_field("Color1", vInfo[v][Color1]);
	mysql_fetch_field("Color2", vInfo[v][Color2]);
        mysql_fetch_field("Lock", sql);
	if(strval(sql) == 1)
	{
	vInfo[v][Lock] = true;
	}
	else
	{
	vInfo[v][Lock] = false;
	}
	if(model > 399)
	{
	if(model == 599 || model == 598 || model == 523 || model == 416 ||
	model == 438 || model == 420 || model == 403 || model == 456 ||
	model == 498 || model == 591 || model == 584 || model == 587 ||
	model == 521 || model == 578 || model == 493 || model == 512 ||
	model == 525 || model == 448 || model == 519 || model == 472 ||
	model == 408 || model == 431 || model == 437)
	{
	vehicle = CreateVehicle(model, CarFloat[0], CarFloat[1], CarFloat[2], CarFloat[3], vInfo[v][Color1], vInfo[v][Color2], 60*30);
	}
	else
	{
	vehicle = CreateVehicle(model, CarFloat[0], CarFloat[1], CarFloat[2], CarFloat[3], vInfo[v][Color1], vInfo[v][Color2], -1);
	}
	mysql_fetch_field("Paintjob", sql); if(strval(sql) > 0) ChangeVehiclePaintjob(vehicle, strval(sql)-1);
	mysql_fetch_field("Interior", sql); vInfo[vehicle][Interior] = strval(sql); LinkVehicleToInterior(vehicle, strval(sql));
	mysql_fetch_field("Tune0", sql); tune[0] = strval(sql);
	mysql_fetch_field("Tune1", sql); tune[1] = strval(sql);
	mysql_fetch_field("Tune2", sql); tune[2] = strval(sql);
	mysql_fetch_field("Tune3", sql); tune[3] = strval(sql);
	mysql_fetch_field("Tune4", sql); tune[4] = strval(sql);
	mysql_fetch_field("Tune5", sql); tune[5] = strval(sql);
	mysql_fetch_field("Tune6", sql); tune[6] = strval(sql);
	mysql_fetch_field("Tune7", sql); tune[7] = strval(sql);
	mysql_fetch_field("Tune8", sql); tune[8] = strval(sql);
	mysql_fetch_field("Tune9", sql); tune[9] = strval(sql);
	mysql_fetch_field("Tune10", sql); tune[10] = strval(sql);
	mysql_fetch_field("Tune11", sql); tune[11] = strval(sql);
	mysql_fetch_field("Tune12", sql); tune[12] = strval(sql);
	AddVehicleComponent(vehicle, tune[0]);
	AddVehicleComponent(vehicle, tune[1]);
	AddVehicleComponent(vehicle, tune[2]);
	AddVehicleComponent(vehicle, tune[3]);
	AddVehicleComponent(vehicle, tune[4]);
	AddVehicleComponent(vehicle, tune[5]);
	AddVehicleComponent(vehicle, tune[6]);
	AddVehicleComponent(vehicle, tune[7]);
	AddVehicleComponent(vehicle, tune[8]);
	AddVehicleComponent(vehicle, tune[9]);
	AddVehicleComponent(vehicle, tune[10]);
	AddVehicleComponent(vehicle, tune[11]);
	AddVehicleComponent(vehicle, tune[12]);
	}
	format(query, 1024, "DELETE FROM "SQL_CARTABLE" WHERE ID = '%d'", vehicle);
	mysql_query(query);
	mysql_free_result();
	SaveVehicle(vehicle);
	}
	}
	}
	else if(Table == 2)
	{
	new vehicle;
	/* Job cars */
	vehicle = CreateVehicle(599,-1400.697,2659.695,56.073,90.0,-1,-1,60*30); //Police Ranger
	SaveVehicle(vehicle);
	vehicle = CreateVehicle(599,-1400.697,2653.398,56.073,89.0,-1,-1,60*30); //Police Ranger
	SaveVehicle(vehicle);
	vehicle = CreateVehicle(598,-1400.697,2647.201,56.073,89.0,-1,-1,60*30); //LVPD
	SaveVehicle(vehicle);
	vehicle = CreateVehicle(598,-1400.667,2640.842,56.073,89.0,-1,-1,60*30); //LVPD
	SaveVehicle(vehicle);
	}
	for(new i=0;i<MAX_VEHICLES;i++) vInfo[i][Fuel] = 100;
Thanks for the HELP!
Find
Reply
Ectazy
Big Clucker
***
Posts: 100
Threads: 24
Joined: Feb 2011
Reputation: 0
#2

10.03.2013, 08:34
Up..
Find
Reply
Smally
Huge Clucker
****
Posts: 400
Threads: 11
Joined: Jul 2011
Reputation: 0
#3

10.03.2013, 12:16
I take it compiles fine? Have you defined SQL_CARTABLE? Although I have a feeling that might be causing the problem, if you've done all these try adding some prints in so you can check the command line.
Find
Reply
Ectazy
Big Clucker
***
Posts: 100
Threads: 24
Joined: Feb 2011
Reputation: 0
#4

10.03.2013, 14:40
Yes, it compiles fine. SQL_CARTABLE are defined. I try add print there:
Код:
new Table;
for(new v; v < MAX_VEHICLES; v++)
{
Table = 0;
format(query, 1024,"SELECT * FROM "SQL_CARTABLE" WHERE ID = '%d'", v);
mysql_query(query);
mysql_store_result();
if(Table == 0)
{
if(mysql_num_rows() != 0)
{
Table = 1;
print("Table 1);
}
else
{
Table = 2;
print("Table 2");
}
}
}
Server log:
Код:
[16:56:32] Table 2
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 2
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 1
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
[16:56:32] Table 2
It something wrong?
Find
Reply
Ectazy
Big Clucker
***
Posts: 100
Threads: 24
Joined: Feb 2011
Reputation: 0
#5

11.03.2013, 10:16
Up..
Find
Reply
Knappen
Huge Clucker
****
Posts: 251
Threads: 24
Joined: Apr 2007
Reputation: 0
#6

11.03.2013, 11:41
Give me a minute, and I'll see what I can do.

EDIT:

pawn Код:
new Table = 0;
    format(query, 1024,"SELECT * FROM "SQL_CARTABLE"");
    mysql_query(query);
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        if(Table == 0)
        {   
            Table = 1;
        }
        else
        {
            Table = 2;
        }
    }   
    if(Table == 1)
    {
        while(mysql_retrieve_row())
        {
            new model, vehicle, locked, Float:CarFloat[5], tune[13];
            
            // Vehicle
            mysql_get_field("Owner", vInfo[vehicle][Owner]);
            mysql_get_field("Model", sql); model = strval(sql);
            mysql_get_field("X", sql); CarFloat[0] = floatstr(sql);
            mysql_get_field("Y", sql); CarFloat[1] = floatstr(sql);
            mysql_get_field("Z", sql); CarFloat[2] = floatstr(sql);
            mysql_get_field("Angle", sql); CarFloat[3] = floatstr(sql);
            mysql_get_field("HP", sql); CarFloat[4] = floatstr(sql);
            mysql_get_field("Fuel", sql); vInfo[vehicle][Fuel] = strval(sql);
            mysql_get_field("Color1", sql); vInfo[vehicle][Color1] = strval(sql);
            mysql_get_field("Color2", sql); vInfo[vehicle][Color2] = strval(sql);
            mysql_get_field("Lock", sql); locked = strval(sql);
            if(locked == 1)
            {
                vInfo[vehicle][Lock] = true;
            }   
            else
            {
                vInfo[vehicle][Lock] = false;
            }   
            if(model > 399)
            {
                if(model == 599 || model == 598 || model == 523 || model == 416 ||
                model == 438 || model == 420 || model == 403 || model == 456 ||
                model == 498 || model == 591 || model == 584 || model == 587 ||
                model == 521 || model == 578 || model == 493 || model == 512 ||
                model == 525 || model == 448 || model == 519 || model == 472 ||
                model == 408 || model == 431 || model == 437)
                {   
                    vehicle = CreateVehicle(model, CarFloat[0], CarFloat[1], CarFloat[2], CarFloat[3], vInfo[v][Color1], vInfo[v][Color2], 60*30);
                }   
                else
                {
                    vehicle = CreateVehicle(model, CarFloat[0], CarFloat[1], CarFloat[2], CarFloat[3], vInfo[v][Color1], vInfo[v][Color2], -1);
                }
            }
            
            // Components
            mysql_get_field("Paintjob", sql); if(strval(sql) > 0) ChangeVehiclePaintjob(vehicle, strval(sql)-1);
            mysql_get_field("Interior", sql); vInfo[vehicle][Interior] = strval(sql); LinkVehicleToInterior(vehicle, strval(sql));
            mysql_get_field("Tune0", sql); tune[0] = strval(sql);
            mysql_get_field("Tune1", sql); tune[1] = strval(sql);
            mysql_get_field("Tune2", sql); tune[2] = strval(sql);
            mysql_get_field("Tune3", sql); tune[3] = strval(sql);
            mysql_get_field("Tune4", sql); tune[4] = strval(sql);
            mysql_get_field("Tune5", sql); tune[5] = strval(sql);
            mysql_get_field("Tune6", sql); tune[6] = strval(sql);
            mysql_get_field("Tune7", sql); tune[7] = strval(sql);
            mysql_get_field("Tune8", sql); tune[8] = strval(sql);
            mysql_get_field("Tune9", sql); tune[9] = strval(sql);
            mysql_get_field("Tune10", sql); tune[10] = strval(sql);
            mysql_get_field("Tune11", sql); tune[11] = strval(sql);
            mysql_get_field("Tune12", sql); tune[12] = strval(sql);
            
            AddVehicleComponent(vehicle, tune[0]);
            AddVehicleComponent(vehicle, tune[1]);
            AddVehicleComponent(vehicle, tune[2]);
            AddVehicleComponent(vehicle, tune[3]);
            AddVehicleComponent(vehicle, tune[4]);
            AddVehicleComponent(vehicle, tune[5]);
            AddVehicleComponent(vehicle, tune[6]);
            AddVehicleComponent(vehicle, tune[7]);
            AddVehicleComponent(vehicle, tune[8]);
            AddVehicleComponent(vehicle, tune[9]);
            AddVehicleComponent(vehicle, tune[10]);
            AddVehicleComponent(vehicle, tune[11]);
            AddVehicleComponent(vehicle, tune[12]);
            vehicle++;
        }
        mysql_free_result();
    }
    else if(Table == 2)
    {
        new vehicle;
        /* Job cars */
        vehicle = CreateVehicle(599,-1400.697,2659.695,56.073,90.0,-1,-1,60*30); //Police Ranger
        SaveVehicle(vehicle);
        vehicle = CreateVehicle(599,-1400.697,2653.398,56.073,89.0,-1,-1,60*30); //Police Ranger
        SaveVehicle(vehicle);
        vehicle = CreateVehicle(598,-1400.697,2647.201,56.073,89.0,-1,-1,60*30); //LVPD
        SaveVehicle(vehicle);
        vehicle = CreateVehicle(598,-1400.667,2640.842,56.073,89.0,-1,-1,60*30); //LVPD
        SaveVehicle(vehicle);
    }
    for(new i=0;i<MAX_VEHICLES;i++) vInfo[i][Fuel] = 100;
I've always used something like this when working with MySQL, and it has always worked great. This was just a quick edit, so sorry if I made any mistakes. If it works as it should, please take some time to look through it and see what I did.
Find
Reply
Ectazy
Big Clucker
***
Posts: 100
Threads: 24
Joined: Feb 2011
Reputation: 0
#7

11.03.2013, 17:05
Thanks, but I get many errors:
undefined symbol "mysql_get_field" and undefined symbol "mysql_retrieve_row".
Find
Reply
Ectazy
Big Clucker
***
Posts: 100
Threads: 24
Joined: Feb 2011
Reputation: 0
#8

07.04.2013, 09:44
/\
l
l
Find
Reply
Ectazy
Big Clucker
***
Posts: 100
Threads: 24
Joined: Feb 2011
Reputation: 0
#9

08.04.2013, 17:55
UP..
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help