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

Threaded Mode
Cars wont spawn
Tanush123
High-roller
*****
Posts: 1,022
Threads: 207
Joined: Aug 2011
Reputation: 0
#1

01.01.2012, 21:50
Under OnGameModeInit i added
pawn Код:
for(new i = 0;i<MAX_ORGS;i++)
    {
        CheckMySQL();
        format(str,sizeof(str),"SELECT * FROM orgs WHERE Orgid = '%d'",i);
        mysql_query(str);
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            mysql_fetch_row_format(drow, "|");
            explode(drow, field, "|");
            OrgInfo[i][Car1] = CreateVehicle(OrgInfo[i][Car1] = strval(field[12]),OrgInfo[i][Car1] = strval(field[20]),OrgInfo[i][Car1] = strval(field[28]),OrgInfo[i][Car1] = strval(field[36]),OrgInfo[i][Car1] = strval(field[44]),OrgInfo[i][Car1] = strval(field[52]),OrgInfo[i][Car1] = strval(field[53]),-1);
            OrgInfo[i][Car2] = CreateVehicle(OrgInfo[i][Car2] = strval(field[13]),OrgInfo[i][Car2] = strval(field[21]),OrgInfo[i][Car2] = strval(field[29]),OrgInfo[i][Car2] = strval(field[37]),OrgInfo[i][Car2] = strval(field[45]),OrgInfo[i][Car2] = strval(field[52]),OrgInfo[i][Car1] = strval(field[53]),-1);
            OrgInfo[i][Car3] = CreateVehicle(OrgInfo[i][Car3] = strval(field[14]),OrgInfo[i][Car3] = strval(field[22]),OrgInfo[i][Car3] = strval(field[30]),OrgInfo[i][Car3] = strval(field[38]),OrgInfo[i][Car3] = strval(field[46]),OrgInfo[i][Car3] = strval(field[52]),OrgInfo[i][Car1] = strval(field[53]),-1);
            OrgInfo[i][Car4] = CreateVehicle(OrgInfo[i][Car4] = strval(field[15]),OrgInfo[i][Car4] = strval(field[23]),OrgInfo[i][Car4] = strval(field[31]),OrgInfo[i][Car4] = strval(field[39]),OrgInfo[i][Car4] = strval(field[47]),OrgInfo[i][Car4] = strval(field[52]),OrgInfo[i][Car1] = strval(field[53]),-1);
            OrgInfo[i][Car5] = CreateVehicle(OrgInfo[i][Car5] = strval(field[16]),OrgInfo[i][Car5] = strval(field[24]),OrgInfo[i][Car5] = strval(field[32]),OrgInfo[i][Car5] = strval(field[40]),OrgInfo[i][Car5] = strval(field[48]),OrgInfo[i][Car5] = strval(field[52]),OrgInfo[i][Car1] = strval(field[53]),-1);
            OrgInfo[i][Car6] = CreateVehicle(OrgInfo[i][Car6] = strval(field[17]),OrgInfo[i][Car6] = strval(field[25]),OrgInfo[i][Car6] = strval(field[33]),OrgInfo[i][Car6] = strval(field[41]),OrgInfo[i][Car6] = strval(field[49]),OrgInfo[i][Car6] = strval(field[52]),OrgInfo[i][Car1] = strval(field[53]),-1);
            OrgInfo[i][Car7] = CreateVehicle(OrgInfo[i][Car7] = strval(field[18]),OrgInfo[i][Car7] = strval(field[26]),OrgInfo[i][Car7] = strval(field[34]),OrgInfo[i][Car7] = strval(field[42]),OrgInfo[i][Car7] = strval(field[50]),OrgInfo[i][Car7] = strval(field[52]),OrgInfo[i][Car1] = strval(field[53]),-1);
            OrgInfo[i][Car8] = CreateVehicle(OrgInfo[i][Car8] = strval(field[19]),OrgInfo[i][Car8] = strval(field[27]),OrgInfo[i][Car8] = strval(field[35]),OrgInfo[i][Car8] = strval(field[43]),OrgInfo[i][Car8] = strval(field[51]),OrgInfo[i][Car8] = strval(field[52]),OrgInfo[i][Car1] = strval(field[53]),-1);
            OrgInfo[i][Genre] = strval(field[2]);
        }
    }
Well when i first use
pawn Код:
CMD:setoveh(playerid,params[])
{
    if(!IsPlayerAdmin(playerid)) return 0;
    if(sscanf(params,"ii",orgid,cars)) return SendClientMessage(playerid,grey,"USAGE: /setoveh [orgid] [car 1-8]");
    if(cars < 1) return SendClientMessage(playerid,red,"ERROR: Available Cars 1-8");
    if(cars > 8) return SendClientMessage(playerid,red,"ERROR: Available Cars 1-8");
    CheckMySQL();
    format(query,sizeof(query),"SELECT * FROM orgs WHERE Orgid = %d",orgid);
    mysql_query(query);
    mysql_store_result();
    if(GetPlayerState(playerid) != PLAYER_STATE_DRIVER) return SendClientMessage(playerid,red,"You aren't in any vehicle.");
    GetVehiclePos(GetPlayerVehicleID(playerid),X,Y,Z);
    GetVehicleZAngle(GetPlayerVehicleID(playerid),A);
    if(mysql_num_rows() != 0)
    {
        if(cars == 1)
        {
            mysql_free_result();
            CheckMySQL();
            format(query,sizeof(query),"UPDATE orgs SET Model1 = %d,X1 = %f,Y1 = %f,Z1 = %f WHERE Orgid = %d",GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,orgid);
            mysql_query(query);
            mysql_store_result();
            OrgInfo[orgid][Car1] = CreateVehicle(GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,-1,-1,-1);
        }
        if(cars == 2)
        {
            mysql_free_result();
            CheckMySQL();
            format(query,sizeof(query),"UPDATE orgs SET Model2 = %d,X2 = %f,Y2 = %f,Z2 = %f WHERE Orgid = %d",GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,orgid);
            mysql_query(query);
            mysql_store_result();
            OrgInfo[orgid][Car2] = CreateVehicle(GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,-1,-1,-1);
        }
        if(cars == 3)
        {
            mysql_free_result();
            CheckMySQL();
            format(query,sizeof(query),"UPDATE orgs SET Model3 = %d,X3 = %f,Y3 = %f,Z3 = %f WHERE Orgid = %d",GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,orgid);
            mysql_query(query);
            mysql_store_result();
            OrgInfo[orgid][Car3] = CreateVehicle(GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,-1,-1,-1);
        }
        if(cars == 4)
        {
            mysql_free_result();
            CheckMySQL();
            format(query,sizeof(query),"UPDATE orgs SET Model4 = %d,X4 = %f,Y4 = %f,Z4 = %f WHERE Orgid = %d",GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,orgid);
            mysql_query(query);
            mysql_store_result();
            OrgInfo[orgid][Car4] = CreateVehicle(GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,-1,-1,-1);
        }
        if(cars == 5)
        {
            mysql_free_result();
            CheckMySQL();
            format(query,sizeof(query),"UPDATE orgs SET Model5 = %d,X5 = %f,Y5 = %f,Z5 = %f WHERE Orgid = %d",GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,orgid);
            mysql_query(query);
            mysql_store_result();
            OrgInfo[orgid][Car5] = CreateVehicle(GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,-1,-1,-1);
        }
        if(cars == 6)
        {
            mysql_free_result();
            CheckMySQL();
            format(query,sizeof(query),"UPDATE orgs SET Model6 = %d,X6 = %f,Y6 = %f,Z6 = %f WHERE Orgid = %d",GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,orgid);
            mysql_query(query);
            mysql_store_result();
            OrgInfo[orgid][Car6] = CreateVehicle(GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,-1,-1,-1);
        }
        if(cars == 7)
        {
            mysql_free_result();
            CheckMySQL();
            format(query,sizeof(query),"UPDATE orgs SET Model7 = %d,X7 = %f,Y7 = %f,Z7 = %f WHERE Orgid = %d",GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,orgid);
            mysql_query(query);
            mysql_store_result();
            OrgInfo[orgid][Car7] = CreateVehicle(GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,-1,-1,-1);
        }
        if(cars == 8)
        {
            mysql_free_result();
            CheckMySQL();
            format(query,sizeof(query),"UPDATE orgs SET Model8 = %d,X8 = %f,Y8 = %f,Z8 = %f WHERE Orgid = %d",GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,orgid);
            mysql_query(query);
            mysql_store_result();
            OrgInfo[orgid][Car8] = CreateVehicle(GetVehicleModel(GetPlayerVehicleID(playerid)),X,Y,Z,A,-1,-1,-1);
        }
        format(str,sizeof(str),"You have set this vehicle has orgid %d",orgid);
        SendClientMessage(playerid,COLOR_YELLOW,str);
        DestroyVehicle(GetPlayerVehicleID(playerid));
    }
    else
    {
        SendClientMessage(playerid,red,"ERROR: This Organization ID is not used.");
    }
    return 1;
}
It goes fine but when i restart the cars wont load
Find
Reply
Tanush123
High-roller
*****
Posts: 1,022
Threads: 207
Joined: Aug 2011
Reputation: 0
#2

02.01.2012, 18:00
bump
Find
Reply
Tanush123
High-roller
*****
Posts: 1,022
Threads: 207
Joined: Aug 2011
Reputation: 0
#3

03.01.2012, 16:20
bump
Find
Reply
Tanush123
High-roller
*****
Posts: 1,022
Threads: 207
Joined: Aug 2011
Reputation: 0
#4

04.01.2012, 16:29
bump
Find
Reply
jaskiller
Big Clucker
***
Posts: 72
Threads: 29
Joined: Dec 2011
Reputation: 0
#5

04.01.2012, 16:41
I never use explode but I suggest you to use a_mysql and sscanf2 very fast and easy.

solution for you probleme : in format if you put '' it mean it is a string so %d not '%d'

format(str,sizeof(str),"SELECT * FROM orgs WHERE Orgid = '%d'",i);
Find
Reply
Tanush123
High-roller
*****
Posts: 1,022
Threads: 207
Joined: Aug 2011
Reputation: 0
#6

04.01.2012, 16:43
i do use those -_-
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