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

Threaded Mode
help Vehicle load has flood!
TheNerka
Huge Clucker
***
Posts: 241
Threads: 58
Joined: Aug 2013
Reputation: 0
#1

13.09.2014, 08:11
Hello how to fix flood got vehicles 50+ per second but in mysql is 1 car

OnGameModeInit:

Код:
mysql_tquery(Mysql_users, "SELECT * FROM "MASINU_LENTELE"", "LoadVehicleData", "", "");
Load:

Код:
forward LoadVehicleData();
public LoadVehicleData()
{
    AntiDeAMX();
    new rows, fields;
    cache_get_data(rows, fields);
    if(rows)
    {
        for(new i=0; i<MAX_CARS; i++)
        {
            VehicleData[i][Model] = cache_get_field_content_int(0, "Model", Mysql_users);
            VehicleData[i][PositionX] = cache_get_field_content_float(0, "PositionX", Mysql_users);
            VehicleData[i][PositionY] = cache_get_field_content_float(0, "PositionY", Mysql_users);
            VehicleData[i][PositionZ] = cache_get_field_content_float(0, "PositionZ", Mysql_users);
            VehicleData[i][PositionA] = cache_get_field_content_float(0, "PositionA", Mysql_users);

            VehicleData[i][Color1] = cache_get_field_content_int(0, "Color1", Mysql_users);
            VehicleData[i][Color2] = cache_get_field_content_int(0, "Color2", Mysql_users);
            Masinos[i] = CreateVehicle(VehicleData[i][Model], VehicleData[i][PositionX], VehicleData[i][PositionY],VehicleData[i][PositionZ], VehicleData[i][PositionA], VehicleData[i][Color1], VehicleData[i][Color2], 3600000);
        }
    }
    return 1;
}
Max cars is 100 very need fast
Find
Reply
TheNerka
Huge Clucker
***
Posts: 241
Threads: 58
Joined: Aug 2013
Reputation: 0
#2

13.09.2014, 09:23
......
Find
Reply
TheNerka
Huge Clucker
***
Posts: 241
Threads: 58
Joined: Aug 2013
Reputation: 0
#3

13.09.2014, 10:05
help.
Find
Reply
mamorunl
High-roller
*****
Posts: 1,938
Threads: 16
Joined: Feb 2007
Reputation: 0
#4

13.09.2014, 10:22
https://sampwiki.blast.hk/wiki/MySQL/R33...ld_content_int

The first parameter is the row. You are specifying row 0 all the time.

Change the 0 to i and you're done.

Also: Don't bump every hour.
Find
Reply
TheNerka
Huge Clucker
***
Posts: 241
Threads: 58
Joined: Aug 2013
Reputation: 0
#5

13.09.2014, 10:40
Код:
forward LoadVehicleData();
public LoadVehicleData()
{
    AntiDeAMX();
    new rows, fields;
    cache_get_data(rows, fields);
    if(rows)
    {
        for(new i=0; i<MAX_CARS; i++)
        {
            VehicleData[i][Model] = cache_get_field_content_int(0, "Model", Mysql_users);
            VehicleData[i][PositionX] = cache_get_field_content_float(0, "PositionX", Mysql_users);
            VehicleData[i][PositionY] = cache_get_field_content_float(0, "PositionY", Mysql_users);
            VehicleData[i][PositionZ] = cache_get_field_content_float(0, "PositionZ", Mysql_users);
            VehicleData[i][PositionA] = cache_get_field_content_float(0, "PositionA", Mysql_users);

            VehicleData[i][Color1] = cache_get_field_content_int(0, "Color1", Mysql_users);
            VehicleData[i][Color2] = cache_get_field_content_int(0, "Color2", Mysql_users);
            Masinos[i] = CreateVehicle(VehicleData[i][Model], VehicleData[i][PositionX], VehicleData[i][PositionY],VehicleData[i][PositionZ], VehicleData[i][PositionA], VehicleData[i][Color1], VehicleData[i][Color2], 3600000);
        }
    }
    return 1;
}
what 0 change?
Find
Reply
TheNerka
Huge Clucker
***
Posts: 241
Threads: 58
Joined: Aug 2013
Reputation: 0
#6

13.09.2014, 11:22
my load print:

Код:
[14:13:12] [0] - CreateVehicle(411, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [1] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [2] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [3] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [4] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [5] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [6] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [7] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [8] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [9] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [10] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [11] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [12] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [13] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [14] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [15] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [16] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [17] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [18] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [19] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [20] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [21] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [22] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [23] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [24] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [25] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [26] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [27] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [28] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [29] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [30] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [31] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [32] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [33] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [34] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [35] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [36] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [37] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [38] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [39] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [40] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [41] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [42] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [43] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [44] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [45] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [46] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [47] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [48] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [49] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [50] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [51] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [52] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [53] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [54] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [55] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [56] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [57] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [58] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [59] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [60] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [61] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [62] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [63] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [64] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [65] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [66] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [67] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [68] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [69] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [70] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [71] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [72] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [73] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [74] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [75] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [76] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [77] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [78] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [79] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [80] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [81] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [82] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [83] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [84] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [85] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [86] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [87] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [88] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [89] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [90] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [91] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [92] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [93] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [94] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:12] [95] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:13] [96] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:13] [97] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:13] [98] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
[14:13:13] [99] - CreateVehicle(0, 5.000000, 10.000000, 15.000000, 20.000000, 5, 25, 1)
print code:

Код:
printf("[%i] - CreateVehicle(%i, %f, %f, %f, %f, %i, %i, 1)",i, VehicleData[i][Model], VehicleData[i][PositionX], VehicleData[i][PositionY],VehicleData[i][PositionZ], VehicleData[i][PositionA], VehicleData[i][Color1], VehicleData[i][Color2]);
Find
Reply
mamorunl
High-roller
*****
Posts: 1,938
Threads: 16
Joined: Feb 2007
Reputation: 0
#7

13.09.2014, 17:11
Read my post again. I even put up a link to the article on the wiki.
Find
Reply
TheNerka
Huge Clucker
***
Posts: 241
Threads: 58
Joined: Aug 2013
Reputation: 0
#8

13.09.2014, 17:58
Im fixed. Require if(rows) change to if(cache_num_rows) and other rows changed MAX_CARS no need

Ps: Chat with phone
Find
Reply
mamorunl
High-roller
*****
Posts: 1,938
Threads: 16
Joined: Feb 2007
Reputation: 0
#9

13.09.2014, 18:03
I was talking about this line: cache_get_field_content_int(0, "Model", Mysql_users);

That 0 needed to be replaced. Not the if(rows)
Find
Reply
TheNerka
Huge Clucker
***
Posts: 241
Threads: 58
Joined: Aug 2013
Reputation: 0
#10

13.09.2014, 18:04
I'm 0 changed to i

but have other error on the house system:

http://imgur.com/Bw95mI8

this undefined symbols text is House name

code:

Код:
format(string2, sizeof(string2), "Namas Nr. %i parduodamas\n %s\nNamo savininkas: %s\nNamo kaina: %i\nSpauskite ENTER kad nusipirkti.", HouseData[i][ID], HouseData[i][Pavadinimas], HouseData[i][Savininkas], HouseData[i][Namokaina]);
                PickupData[i][Namas] = CreatePickup(1273, 1, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ], -1);
                Create3DTextLabel(string2, -1, HouseData[i][PositionX], HouseData[i][PositionY], HouseData[i][PositionZ]+0.75, 40.0, 0, 0);
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