mysql_format into variable. - Printable Version

mysql_format into variable. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql_format into variable. (/showthread.php?tid=583432)

mysql_format into variable. - k2168 - 28.07.2015

Hi, I'm tryna make a new house system. so, here's my question.

I'm tryna get a minimum of id and maximum of id from the house table.

So, I made two variables for minimum and maximum. and, is it possible to put the mysql_format into the variables? If yes, could you give me some examples?

Re: mysql_format into variable. - Lorenc_ - 28.07.2015

http://stackoverflow.com/questions/1...as-a-min-value

Does this seem relevant? I'm sure there is a max value to tag with it.

Not sure about putting mysql_format into the variables, didn't really understand

Re: mysql_format into variable. - k2168 - 28.07.2015

Quote:

Originally Posted by Lorenc_

http://stackoverflow.com/questions/1...as-a-min-value

Does this seem relevant? I'm sure there is a max value to tag with it.

Not sure about putting mysql_format into the variables, didn't really understand

Thanks, anyway.

I meant.. like..

Код:

new min = mysql_format(blah.. blah.., "SELECT...");

can i put the mysql_format into variable like that? sorry for my english.

Re: mysql_format into variable. - Lorenc_ - 28.07.2015

Nah, you need to fetch the values through the callback by the looks. That function appears to only be a function that formats a query into a string.

pawn Код:

new query[128];
mysql_format(MySQL, query, sizeof(query), "SELECT * FROM `%s` WHERE `bar` = '%e' AND `foobar` = '%f' LIMIT %d", "foobar", "escape'me\"please", 1.2345, 1337);
// the variable 'query' contains now the formatted query (including the escaped string)
mysql_tquery(MySQL, query, "OnStuffSelected", "");

taken from https://sampwiki.blast.hk/wiki/MySQL/R33

Therefore, it should look similar to this (untested, might work tho):

pawn Код:

// query somewhere
mysql_tquery(MySQL, "SELECT MIN(`column`) as `min_val` FROM `table`", "OnStuffSelected", "");

// callback
public OnStuffSelected()
{
    new
        rows, fields;

    cache_get_data(rows, fields);

    if(rows) {
        new minval = cache_get_row_int(0, "min_val"); // 0 = first row
        // do stuff
    }
}

Re: mysql_format into variable. - k2168 - 29.07.2015

Quote:

Originally Posted by Lorenc_

Nah, you need to fetch the values through the callback by the looks. That function appears to only be a function that formats a query into a string.

pawn Код:

new query[128];
mysql_format(MySQL, query, sizeof(query), "SELECT * FROM `%s` WHERE `bar` = '%e' AND `foobar` = '%f' LIMIT %d", "foobar", "escape'me\"please", 1.2345, 1337);
// the variable 'query' contains now the formatted query (including the escaped string)
mysql_tquery(MySQL, query, "OnStuffSelected", "");

taken from https://sampwiki.blast.hk/wiki/MySQL/R33

Therefore, it should look similar to this (untested, might work tho):

pawn Код:

// query somewhere
mysql_tquery(MySQL, "SELECT MIN(`column`) as `min_val` FROM `table`", "OnStuffSelected", "");

// callback
public OnStuffSelected()
{
    new
        rows, fields;

    cache_get_data(rows, fields);

    if(rows) {
        new minval = cache_get_row_int(0, "min_val"); // 0 = first row
        // do stuff
    }
}

Thanks, I was always wondering about that. thanks for helping me out.

Also, could I two mysql_format and tquery like this?

pawn Код:

stock LoadHouses()
{
    new query[120];
    
    mysql_format(g_Handle, query, sizeof(query), "SELECT * FROM `houses`");
    mysql_tquery(g_Handle, query, "OnLoadHouses", "");
    return 1;
}

public OnLoadHouses()
{

        mysql_tquery(MySQL, "SELECT MIN(`column`) as `min_val` FROM `table`", "OnStuffSelected", "");

    for(new i = 0; i < cache_get_row_count(); i++)
    {
        g_HouseInfo[i][house_ID]            = cache_get_field_content_int(i, "H_ID");
            blahh....
        }
}

public OnStuffSelected()
{
    new
        rows, fields;

    cache_get_data(rows, fields);

    if(rows) {
        new minval = cache_get_row_int(0, "min_val"); // 0 = first row
        // do stuff
    }
}