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

Threaded Mode
MySQL issue.
Dayrion
High-roller
*****
Posts: 1,915
Threads: 64
Joined: Jan 2016
Reputation: 0
#1

11.12.2016, 14:49
Hii'.
Firstly, I asking you if it's a good way to do that :
PHP код:
    ...
    mysql_pquery(MySQL, "SELECT * FROM Tag", "OnTagCount", "");    // count number of tag saved
    return 1;
}
PUBLIC:OnTagCount()
{
    new rows;
    cache_get_row_count(rows);
    for(new i=1; i <= rows; i++)
    {
        mysql_pquery(MySQL, "SELECT * FROM Tag WHERE `SQLIB` = '%i'", "OnTagLoading", "i", i); // load each of them
    }
    printf("- Chargement terminй. %i tag chargй.", TagNumber);
}
PUBLIC:OnTagLoading(tagid)
{
    cache_get_value_name_int(0, "ID", p_Tag[tagid][tID]);
    cache_get_value_name_int(0, "SQLIB", p_Tag[tagid][tSQLIB]);
    cache_get_value(0, "Owner", p_Tag[tagid][tOwner]);
... 
If not, please tell me how I should do that.
Secondly, I've these errors:
Код:
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_float: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
[16:40:21] [plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')
Find
Reply
Vince
Spam Machine
*****
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0
#2

11.12.2016, 14:56
You already have the entire result set at your disposal in OnTagCount so there is absolutely NO need to send any further queries at that point. Everything in OnTagLoading can be placed inside the loop in OnTagCount. Replace row 0 with row i and tagid with i. Also rows start at 0.
Find
Reply
X337
Gangsta
*****
Posts: 872
Threads: 25
Joined: Sep 2014
Reputation: 0
#3

11.12.2016, 14:58
Why not just:
Код:
    ...
    mysql_pquery(MySQL, "SELECT * FROM Tag", "OnTagCount", "");    // count number of tag saved
    return 1;
}

PUBLIC:OnTagCount()
{
    new rows, x;
    cache_get_row_count(rows);
    for(new i; i < rows; i++) // loop to fetch all rows
    {
        x = i + 1; // x is to be used as p_Tag index, since your code tell that it's from 1. If it's from 0, just use i as index and remove x variable.
        cache_get_value_name_int(i, "ID", p_Tag[x][tID]);
        cache_get_value_name_int(i, "SQLIB", p_Tag[x][tSQLIB]);
        cache_get_value(i, "Owner", p_Tag[x][tOwner]);
    }
    printf("- Chargement terminй. %i tag chargй.", TagNumber);
}
Find
Reply
Dayrion
High-roller
*****
Posts: 1,915
Threads: 64
Joined: Jan 2016
Reputation: 0
#4

11.12.2016, 19:07
Lol, I'm so stupid.
Thanks you.
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