[T0pAz]

Can someone tell me what's wrong in here and is there any workaround to fix it?

pawn Код:

stock GetDataInt(tablename[], dataname[], targetname[], targetvalue[])
{
    new res;
    format(largestr, sizeof(largestr), "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", dataname, tablename, targetname, targetvalue);
    mysql_function_query(connectionHandle, largestr, true, "DataInt", "d", res);
    return res;
}
forward DataInt(&refint);
public DataInt(&refint)
{
    new
        rows,
        fields,
        storage[MAX_DATA]
    ;
    cache_get_data(rows, fields, connectionHandle);
    if(!rows)
        return cellmin;
    cache_get_row(0, 0, storage, connectionHandle);
    refint = strval(storage);
    return 1;
}

[Unte99]

pawn Код:

new res;
format(largestr, sizeof(largestr), "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", dataname, tablename, targetname, targetvalue);

What's this ? You are trying to format an integer ? Also different names - res and largestr.

[T0pAz]

Quote:

Originally Posted by Unte99 pawn Код: new res; format(largestr, sizeof(largestr), "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", dataname, tablename, targetname, targetvalue); What's this ? You are trying to format an integer ? Also different names - res and largestr.

lolwut?

[Unte99]

Lets make it even more simplier:

Do you know how to format a string ?

[T0pAz]

Quote:

Originally Posted by Unte99 Lets make it even more simplier: Do you know how to format a string ?

There is no problem on formatting the string. The problem is on the reference.

[T0pAz]

Sorry for bumping, but I've tried this and it's still not working.

pawn Код:

stock GetDataInt(tablename[], dataname[], targetname[], targetvalue[])
{
    new res[MAX_DATA];
    format(largestr, sizeof(largestr), "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", dataname, tablename, targetname, targetvalue);
    mysql_function_query(connectionHandle, largestr, true, "DataInt", "s", res);
    return strval(res);
}
forward DataInt(data[]);
public DataInt(data[])
{
    new
        rows,
        fields,
        storage[MAX_DATA]
    ;
    cache_get_data(rows, fields, connectionHandle);
    if(!rows)
        return cellmin;
    cache_get_row(0, 0, storage, connectionHandle);
    format(data, MAX_DATA, "%s", storage);
    return 1;
}

[T0pAz]

Is it a mysql bug?

[T0pAz]

Sorry for bumping again, but is the mysql plugin version r7 really stable? I've seen many bugs including crashes, enormous amount of memory usage and this bug.

[T0pAz]

Last bump.

[Tigerkiller]

try using r6 version