Loading business with MySQL
#3

pawn Код:
mysql_function_query(Connect, "SELECT * FROM `empresas`", true, "LoadBizz", "");

forward LoadBizz();
public LoadBizz()
{
    new rows, fields,temp[26],TotalBusinesses;
    cache_get_data(rows, fields);
    while(TotalBusinesses < rows)
    {
        cache_get_row(TotalBusinesses, 0, temp), BizzInfo[TotalBusinesses][bOwned] = strval(temp);
        cache_get_row(TotalBusinesses, 1, temp), format(BizzInfo[TotalBusinesses][bOwner],26,temp);
        cache_get_row(TotalBusinesses, 2, temp), format(BizzInfo[TotalBusinesses][bMessage],26,temp);
        cache_get_row(TotalBusinesses, 3, temp), BizzInfo[TotalBusinesses][bExtortion] = strval(temp);
        cache_get_row(TotalBusinesses, 4, temp), BizzInfo[TotalBusinesses][bEntranceX] = floatstr(temp);
        cache_get_row(TotalBusinesses, 5, temp), BizzInfo[TotalBusinesses][bEntranceY] = floatstr(temp);
        cache_get_row(TotalBusinesses, 6, temp), BizzInfo[TotalBusinesses][bEntranceZ] = floatstr(temp);
        cache_get_row(TotalBusinesses, 7, temp), BizzInfo[TotalBusinesses][bExitX] = floatstr(temp);
        cache_get_row(TotalBusinesses, 8, temp), BizzInfo[TotalBusinesses][bExitY] = floatstr(temp);
        cache_get_row(TotalBusinesses, 9, temp), BizzInfo[TotalBusinesses][bExitZ] = floatstr(temp);
        cache_get_row(TotalBusinesses, 10, temp), BizzInfo[TotalBusinesses][bLevelNeeded] = strval(temp);
        cache_get_row(TotalBusinesses, 11, temp), BizzInfo[TotalBusinesses][bBuyPrice] = strval(temp);
        cache_get_row(TotalBusinesses, 12, temp), BizzInfo[TotalBusinesses][bEntranceCost] = strval(temp);
        cache_get_row(TotalBusinesses, 13, temp), BizzInfo[TotalBusinesses][bTill] = strval(temp);
        cache_get_row(TotalBusinesses, 14, temp), BizzInfo[TotalBusinesses][bLocked] = strval(temp);
        cache_get_row(TotalBusinesses, 15, temp), BizzInfo[TotalBusinesses][bInterior] = strval(temp);
        TotalBusinesses++;
    }
    printf("%d businesses loaded",TotalBusinesses);
    return 1;
}
You can put the query in OnGameModeInit after you connect to the database and delete LoadBizz(); (if there is any)
Reply


Messages In This Thread
Loading business with MySQL - by iryston - 18.11.2013, 23:18
Re: Loading business with MySQL - by iryston - 19.11.2013, 13:04
Re: Loading business with MySQL - by InfiniTy. - 19.11.2013, 13:26
Re: Loading business with MySQL - by iryston - 19.11.2013, 14:47

Forum Jump:


Users browsing this thread: 3 Guest(s)