[harbu]

Ok, im trying to convert twilight suzukas buggy The Specialists Economy mod amxx conversion into a working stable version. I was doing ok going to do the dbi_nextrow function, i went to check the amxmodx function library too see if anything is different and i saw this note "Unlike the AMX Mod SQL interfaces, you pass a result handle instead of an SQL handle. "
For backwards compatibility, if nothing is specifed, it will default to a global pointer.
Returns 0 on failure or end of result list.

Im not positvily sure what this means?Do u have to create a new result variable at the beginning? Do u have to use dbi_nextrow(result)?
What u put in the result variable? The last query u made or what?

public death_msg(id) {
    if(!get_cvar_num("economy_deathpenalty")) return PLUGIN_CONTINUE;
    new dead = read_data(2);
    new authid[33];
    new amount = (get_cvar_num("economy_deathpenalty"))
    amount = amount * 100
    get_user_authid(dead,authid,32);
    new query[256];
    format(query, 255, "UPDATE money SET balance=balance-%i WHERE steamid='%s'",amount,authid);
    server_print("[TSX] Sending query: %s",query);
    mysql_query(mysql,query);
    format(query,255,"SELECT balance FROM money WHERE steamid='%s'",authid);
    mysql_query(mysql,query);
    new Str[256];
    if(mysql_nextrow(mysql) > 0){
        mysql_getfield(mysql,1,Str,255);
        new balance = str_to_num(Str);

Im very sorry if this has been asked/mentioned somewhere already...

[devicenull]

Look
here
and
here

If they dont answer your questions, let me know

[harbu]

ok, well i think i got some information from those. Heres how i think it should go, probaly wrong but please check...

public death_msg(id)    {
    if(!get_cvar_num("economy_deathpenalty")) return PLUGIN_CONTIUNE
    new dead = read_data(2)
    new authid[33]
    new amount = (get_cvar_num("economy_deathpenalty"))
    amount = amount *100
    get_user_authid(dead,authid,32)
    new query[256]
    format(query, 255, "UPDATE money SET balance=balance-%i WHERE steamid='%s'",amount,authid)
    server_print("[TEM] Sending query: %s", query)
    result = dbi_query(dbc,query)
    new Str[256]
    if(dbi_nextrow(result) > 0) {
    dbi_field(result,1,Str,255)

[harbu]

*BUMP*

[devicenull]

That looks fine.
Just make sure dbc is a connection to a database