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

Threaded Mode
Why wont this work?
Luis-
High-roller
*****
Posts: 3,934
Threads: 353
Joined: Jan 2010
Reputation: 0
#1

02.12.2011, 10:16
( Последний раз редактировалось Luis-; 04.12.2011 в 20:35. )
pawn Код:
stock LoadCars()
{
    new query[250];
    new VehicleID;
    format(query, sizeof(query), "SELECT * FROM `vehicles` ORDER BY `vehicles`.`Model` ASC LIMIT " #MAX_CARS "");
    mysql_query(query);
    print(query);
    new line[400], sdata[24], data[7], Float:fdata[4];
    mysql_store_result();
    while(mysql_fetch_row(line))
    {
        sscanf(line, "p<|>ddffffds[24]", data[0], data[1], fdata[0], fdata[1], fdata[2], fdata[3], data[2], sdata);
        CarInfo[cars][vID] = data[0];
        CarInfo[cars][vModel] = data[1];
        CarInfo[cars][vX] = fdata[0];
        CarInfo[cars][vY] = fdata[1];
        CarInfo[cars][vZ] = fdata[2];
        CarInfo[cars][vA] = fdata[3];
        CarInfo[cars][vPrice] = data[2];
        strcat(CarInfo[cars][vOwner], sdata, sizeof(sdata));
        
        cars++;
        print(line);
        
        VehicleID = CreateVehicle(CarInfo[cars][vModel], CarInfo[cars][vX], CarInfo[cars][vY], CarInfo[cars][vZ], CarInfo[cars][vA], random(151), random(151), -1);
        printf("X %f, Y %f, Z %f, A %f", CarInfo[cars][vX], CarInfo[cars][vY], CarInfo[cars][vZ], CarInfo[cars][vA]);
        CreateRandomNumberPlate(VehicleID);
    }
    printf("Loaded Vehicles: %d.", cars);
    mysql_free_result();
    return 1;
}
Updated code.

It just wont load any of the information.
Find
Reply
Luis-
High-roller
*****
Posts: 3,934
Threads: 353
Joined: Jan 2010
Reputation: 0
#2

02.12.2011, 11:41
Need this doing quick.
Find
Reply
oliverrud
Huge Clucker
****
Posts: 415
Threads: 66
Joined: Apr 2009
Reputation: 0
#3

02.12.2011, 11:53
Need to see more of the code.
Find
Reply
Luis-
High-roller
*****
Posts: 3,934
Threads: 353
Joined: Jan 2010
Reputation: 0
#4

02.12.2011, 11:53
Why? That's the code which isn't working, the rest it working.
Find
Reply
[L3th4l]
Unregistered
 
#5

02.12.2011, 11:55
Stop with the ignorance, post more code, that doesn't help at all. ( Whole callback + enum )
Reply
Luis-
High-roller
*****
Posts: 3,934
Threads: 353
Joined: Jan 2010
Reputation: 0
#6

02.12.2011, 12:01
Well, I am wanting to do it the same way with all of my other codes so posting all of the codes wouldn't help.

pawn Код:
stock LoadCars()
{
    new query[250];
    format(query, sizeof(query), "SELECT * FROM `vehicles` ORDER BY `vehicles`.`ID` ASC LIMIT " #MAX_CARS "");
    mysql_query(query);
    new line[250];
    mysql_store_result();
    while(mysql_fetch_row(line))
    {
    
        sscanf(line, "e<p<|>ddffffds[20]>", CarInfo[cars]);
        new VehicleID = CreateVehicle(CarInfo[cars][vModel], CarInfo[cars][vX], CarInfo[cars][vY], CarInfo[cars][vZ], CarInfo[cars][vA], random(151), random(151), -1);
        cars++;
        CreateRandomNumberPlate(VehicleID);
        printf("X: %f, Y: %f, Z: %f, A: %f.", CarInfo[cars][vX], CarInfo[cars][vY], CarInfo[cars][vZ], CarInfo[cars][vA]);
    }
    printf("Loaded Vehicles: %d.", cars);
    mysql_free_result();
    return 1;
}
pawn Код:
enum vInfo
{
    vID,
    vModel,
    Float:vX,
    Float:vY,
    Float:vZ,
    Float:vA,
    vOwner[MAX_PLAYER_NAME],
    vPrice,
}


new CarInfo[MAX_CARS][vInfo];
Find
Reply
Scenario
Godfather
*****
Posts: 7,801
Threads: 187
Joined: Feb 2010
Reputation: 0
#7

02.12.2011, 12:06
pawn Код:
sscanf(line, "e>p<|>ddffffds[20]>", CarInfo[cars]);
It should be:

pawn Код:
sscanf(line, "p<|>ddffffds[20]>", CarInfo[cars]);
Also, notice how in the "sscanf" line you are doing "CarInfo[cars]", you may want to actually list out ever single variable in that line because when I do it like that, it doesn't work. So, for example:

pawn Код:
sscanf(line, "e<p<|>ddffffds[20]>", CarInfo[cars][vID], CarInfo[cars][vModel]);
That's an example, you'll have to finish it off bud.
Find
Reply
Luis-
High-roller
*****
Posts: 3,934
Threads: 353
Joined: Jan 2010
Reputation: 0
#8

02.12.2011, 12:37
I've updated the debug prints a little but here is the log for it;
Код:
[13:40:11] Placeholder: 1, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:11] Placeholder: 2, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:11] Placeholder: 3, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:11] Placeholder: 4, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:11] Placeholder: 5, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 6, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 7, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 8, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 9, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 10, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 11, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 12, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 13, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 14, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 15, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 16, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 17, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 18, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 19, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 20, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 21, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 22, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 23, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 24, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 25, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 26, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 27, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 28, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 29, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 30, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 31, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 32, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 33, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 34, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 35, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 36, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 37, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 38, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 39, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 41, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 42, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 44, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 45, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 46, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 47, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 48, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 49, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 50, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 51, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 52, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 53, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 54, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 55, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 56, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 64, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 65, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 66, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 67, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 68, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 69, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 70, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 71, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 72, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 73, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 74, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 75, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 76, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 77, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 78, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 79, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 80, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 81, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 82, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 83, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 84, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 85, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 86, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 87, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 88, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 89, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 90, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 91, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 92, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 93, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 94, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 95, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 96, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 97, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 98, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 99, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 100, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 101, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 102, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 104, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Placeholder: 105, ID: 0, X: 0.000000, Y: 0.000000, Z: 0.000000, A: 0.000000.
[13:40:12] Loaded Vehicles: 95.
[13:40:12] sscanf warning: String buffer overflow.
There is also a sscanf warning and I have no idea what is causing it.

It's confusing me how nothing it loading.
Find
Reply
Luis-
High-roller
*****
Posts: 3,934
Threads: 353
Joined: Jan 2010
Reputation: 0
#9

02.12.2011, 16:46
Anyone want to look at this?
Find
Reply
Vince
Spam Machine
*****
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0
#10

02.12.2011, 17:12
You mis-ordered your specifiers. Look at the sscanf line and then look at your enum, particularly the last two specifiers.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


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