Loading business with MySQL
#4

You are the MAN! Very very thanks! ++ REP
only the icons (pickups) that no longer appear, because companies are being born after the functions are performed addstaticpickup and create3dtext = / have any idea how can I arrange this?


I did so to save: worked perfectly here.
pawn Код:
forward SaveBizz();
public SaveBizz()
{
    new rows, fields,TotalBusinesses;
    cache_get_data(rows, fields);
    while(TotalBusinesses < rows)
    {
        new Str[484];
        format(Str,231,"UPDATE `empresas` SET `Vendida`='%i',`Dono`='%s',`Mensagem`='%s',`Extorcao`='%s',`EntradaX`='%f',`EntradaY`='%f',`EntradaZ`='%f',",BizzInfo[TotalBusinesses][bOwned],BizzInfo[TotalBusinesses][bOwner],BizzInfo[TotalBusinesses][bMessage],
        BizzInfo[TotalBusinesses][bExtortion],BizzInfo[TotalBusinesses][bEntranceX],BizzInfo[TotalBusinesses][bEntranceY],BizzInfo[TotalBusinesses][bEntranceZ]);
        format(Str,484,"%s`SaidaX`='%f',`SaidaY`='%f',`SaidaZ`='%f',`LevelNecessario`='%i',`PrecoCompra`='%i',`EntradaCusto`='%i',`Till`='%i',`Trancada`='%i',`Interior`='%i' WHERE `ID`='%i'",Str,BizzInfo[TotalBusinesses][bExitX],BizzInfo[TotalBusinesses][bExitY],
        BizzInfo[TotalBusinesses][bExitZ],BizzInfo[TotalBusinesses][bLevelNeeded],BizzInfo[TotalBusinesses][bBuyPrice],BizzInfo[TotalBusinesses][bEntranceCost],BizzInfo[TotalBusinesses][bTill],BizzInfo[TotalBusinesses][bLocked],BizzInfo[TotalBusinesses][bInterior],TotalBusinesses);
        mysql_function_query(Connect, Str, false, "","");
        TotalBusinesses++;
    }
    printf("%d businesses saved",TotalBusinesses);
    return 1;
}
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: 1 Guest(s)