Jump to content
  • 0

Nu se schimba pretul de la /bizfee

Jimmi

Asked by Jimmi,

 Share

Question

Jimmi Proficient

Jimmi

Posted
Posted

Problema intalnita (descriere):ă:Am trecut biz-urile si sbiz-urile pe mysql.Acum cand folosesc /bizfee nu se mai actualizeaza pretul de intrare in biz/sbiz.
Ero(area / rile) / warning-(ul / urile):
Imagini / Video (optional):-
Ati incercat sa rezolvati singur?:Da

[15:26:45] >> mysql_query( Connection handle: 1 )
[15:26:45] CMySQLHandler::Query(SELECT * FROM `sbizz` ORDER BY `ID`) - Successfully executed.
[15:26:45] >> mysql_store_result( Connection handle: 1 )
[15:26:45] CMySQLHandler::StoreResult() - Result was stored.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_query( Connection handle: 1 )
[15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_query( Connection handle: 1 )
[15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Car Rent LS', `Extortion` = 'Jimmi', EntX = 564.715026, EntY = -1293.530029, EntZ = 17.248199, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 5000000, EPrice = 2000, Till = 10650, Locked = 0, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_query( Connection handle: 1 )
[15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Car Rent LV', `Extortion` = 'No-one', EntX = 2200.639892, EntY = 1394.219970, EntZ = 11.062500, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 2000000, EPrice = 2000, Till = 0, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_query( Connection handle: 1 )
[15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Phone Company', `Extortion` = 'No-one', EntX = 1327.930053, EntY = -1558.560058, EntZ = 13.546899, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 11, Price = 3000000, EPrice = 1, Till = 25525, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_query( Connection handle: 1 )
[15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Gas Company LS', `Extortion` = 'No-one', EntX = 1000.109985, EntY = -920.078002, EntZ = 42.328098, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 20000000, EPrice = 15, Till = 1897065, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_query( Connection handle: 1 )
[15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Electrica', `Extortion` = 'No-one', EntX = 1329.920043, EntY = -985.466979, EntZ = 33.896598, ExitX = -959.643981, ExitY = 1955.949951, ExitZ = 9.000000, Level = 10, Price = 23000000, EPrice = 2, Till = 142335145, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_query( Connection handle: 1 )
[15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gas Company LV', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 23000000, EPrice = 2, Till = 27540000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 300 WHERE ID = 6) - Successfully executed.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_query( Connection handle: 1 )
[15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Las Venturas', `Extortion` = 'No-one', EntX = 2079.500000, EntY = 2046.040039, EntZ = 11.057900, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 23000000, EPrice = 5, Till = 2001200000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_query( Connection handle: 1 )
[15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Los Santos', `Extortion` = 'No-one', EntX = 845.726013, EntY = -1045.329956, EntZ = 25.441999, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 5000000, EPrice = 5, Till = 0, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_query( Connection handle: 1 )
[15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Kart Racing', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 1500, Till = 24330700, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_query( Connection handle: 1 )
[15:26:46] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Paintball', `Extortion` = 'No-one', EntX = 1310.160034, EntY = -1367.180053, EntZ = 13.522800, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 4000, Till = 1345381, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed.
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )
[15:26:46] >> mysql_retrieve_row( Connection handle: 1 )

Liniile de cod / sursa / script-ul(obligatoriu):
if(strcmp(cmd, "/bizfee", true) == 0)
{
    if(IsPlayerConnected(playerid))
    {
        new bouse = PlayerInfo[playerid][pPbiskey];
        new query[256];
        if (bouse == 255) return SendClientMessage(playerid, COLOR_GRAD2, "   Nu detii o afacere !");
        tmp = strtok(cmdtext, idx);
        if(!strlen(tmp)) return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Folosire:{FFFFFF} /bizfee [EntranceFee]");
        if(strval(tmp) < 0 || strval(tmp) > 2000) return SendClientMessage(playerid, COLOR_WHITE, "Suma minima este de $0, suma maxima este de $2000.");
        if (bouse >= 100)
        {
            if(bouse == 102)
            {
                if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Phone Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; }
            }
            if(bouse == 103)
            {
                if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Gas Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; }
            }
            if(bouse == 104)
            {
                if(strval(tmp) > 0 && strval(tmp) < 101) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Electricity Company: {FFFFFF} /bizfee poate fi maxim 100!"); return 1; }
            }
            if(bouse == 106 || bouse == 107)
            {
                if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}CNN: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; }
            }
            SBizzInfo[bouse-100][sbEntranceCost] = strval(tmp);
            format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", SBizzInfo[bouse-100][sbEntranceCost]);
            OnPropUpdate();
            SendClientMessage(playerid, COLOR_WHITE, string);
        }
        else
        {
            if(bouse >= 5 && bouse <= 11 || bouse >= 19 && bouse <= 25)
            {
                if(strval(tmp) > 0 && strval(tmp) < 501) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}24/7: {FFFFFF} /bizfee poate fi maxim 500!"); return 1; }
            }
            BizzInfo[bouse][bEntranceCost] = strval(tmp);
            format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", BizzInfo[bouse][bEntranceCost]);
            OnPropUpdate();
            SendClientMessage(playerid, COLOR_WHITE, string);
            format(query,sizeof(query),"UPDATE `bizz` SET `ePrice`='%s'",BizzInfo[bouse][bEntranceCost]);
             mysql_query(query);
        }
    }
    return 1;
}
Link to comment
Share on other sites

30 answers to this question

Recommended Posts

  • 0
WopsS Grand Master

WopsS

Posted
Posted

Scoate

format(query,sizeof(query),"UPDATE `bizz` SET `ePrice`='%s'",BizzInfo[bouse][bEntranceCost]);
mysql_query(query);

din acel else si pune-o in afara.

Asta

format(query,sizeof(query),"UPDATE `bizz` SET `ePrice`='%s'",BizzInfo[bouse][bEntranceCost]);

inlocuieste-o cu

format(query,sizeof(query),"UPDATE `bizz` SET `ePrice`='%s' WHERE `ID` = '%i'",BizzInfo[bouse][bEntranceCost], bouse);

Pentru ca trebuie sa stii ce afacere vrei s-o actualizezi sa nu faci asta la toate.

Link to comment
Share on other sites
  • 0
Jimmi Proficient

Jimmi

Posted
  • Author
Posted

Tot nu se schimba pretul si in server_log

[16:53:13] [debug] Run time error 4: "Array index out of bounds"
[16:53:13] [debug]  Accessing element at index 106 past array upper bound 99
[16:53:13] [debug] AMX backtrace:
[16:53:13] [debug] #0 002c1130 in public OnPlayerCommandPerformed (playerid=0, cmdtext[]=@0732a578 "/bizfee 3", success=0) at C:\Users\Jimmi\Desktop\93.119.25.182-7777\gamemodes\RunStrike.pwn:41673
[16:53:13] [debug] #1 native CallLocalFunction () from samp-server.exe
[16:53:13] [debug] #2 00028344 in public OnPlayerCommandText (playerid=0, cmdtext[]=@0732a54c "/bizfee 3") at C:\Users\Jimmi\Desktop\93.119.25.182-7777\pawno\include\zcmd.inc:108

mysql_log
[16:53:13] CMySQLHandler::Query(SELECT * FROM `sbizz` ORDER BY `ID`) - Successfully executed.

[16:53:13] >> mysql_store_result( Connection handle: 1 )

[16:53:13] CMySQLHandler::StoreResult() - Result was stored.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_query( Connection handle: 1 )

[16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_query( Connection handle: 1 )

[16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Car Rent LS', `Extortion` = 'Jimmi', EntX = 564.715026, EntY = -1293.530029, EntZ = 17.248199, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 5000000, EPrice = 2000, Till = 10650, Locked = 0, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_query( Connection handle: 1 )

[16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Car Rent LV', `Extortion` = 'No-one', EntX = 2200.639892, EntY = 1394.219970, EntZ = 11.062500, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 2000000, EPrice = 2000, Till = 0, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_query( Connection handle: 1 )

[16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Jimmi', `Message` = 'Phone Company', `Extortion` = 'No-one', EntX = 1327.930053, EntY = -1558.560058, EntZ = 13.546899, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 11, Price = 3000000, EPrice = 1, Till = 25525, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_query( Connection handle: 1 )

[16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Gas Company LS', `Extortion` = 'No-one', EntX = 1000.109985, EntY = -920.078002, EntZ = 42.328098, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 20000000, EPrice = 15, Till = 2083155, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_query( Connection handle: 1 )

[16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Electrica', `Extortion` = 'No-one', EntX = 1329.920043, EntY = -985.466979, EntZ = 33.896598, ExitX = -959.643981, ExitY = 1955.949951, ExitZ = 9.000000, Level = 10, Price = 23000000, EPrice = 2, Till = 142335145, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_query( Connection handle: 1 )

[16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gas Company LV', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 23000000, EPrice = 3, Till = 27540000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 300 WHERE ID = 6) - Successfully executed.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_query( Connection handle: 1 )

[16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Las Venturas', `Extortion` = 'No-one', EntX = 2079.500000, EntY = 2046.040039, EntZ = 11.057900, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 23000000, EPrice = 5, Till = 2001200000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_query( Connection handle: 1 )

[16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Los Santos', `Extortion` = 'No-one', EntX = 845.726013, EntY = -1045.329956, EntZ = 25.441999, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 5000000, EPrice = 5, Till = 0, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_query( Connection handle: 1 )

[16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Kart Racing', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 1500, Till = 24330700, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_query( Connection handle: 1 )

[16:53:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Paintball', `Extortion` = 'No-one', EntX = 1310.160034, EntY = -1367.180053, EntZ = 13.522800, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 4000, Till = 1345381, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed.

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )

[16:53:13] >> mysql_retrieve_row( Connection handle: 1 )
Eu dau sa schimb pretul de intrare al unui bizz nu stiu de ce apare in mysql_log sbiz. Comanda /bizfee 
    if(strcmp(cmd, "/bizfee", true) == 0)
{
    if(IsPlayerConnected(playerid))
    {
        new bouse = PlayerInfo[playerid][pPbiskey];
        new query[256];
        if (bouse == 255) return SendClientMessage(playerid, COLOR_GRAD2, "   Nu detii o afacere !");
        tmp = strtok(cmdtext, idx);
        if(!strlen(tmp)) return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Folosire:{FFFFFF} /bizfee [EntranceFee]");
        if(strval(tmp) < 0 || strval(tmp) > 2000) return SendClientMessage(playerid, COLOR_WHITE, "Suma minima este de $0, suma maxima este de $2000.");
        if (bouse >= 100)
        {
            if(bouse == 102)
            {
                if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Phone Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; }
            }
            if(bouse == 103)
            {
                if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Gas Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; }
            }
            if(bouse == 104)
            {
                if(strval(tmp) > 0 && strval(tmp) < 101) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Electricity Company: {FFFFFF} /bizfee poate fi maxim 100!"); return 1; }
            }
            if(bouse == 106 || bouse == 107)
            {
                if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}CNN: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; }
            }
            SBizzInfo[bouse-100][sbEntranceCost] = strval(tmp);
            format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", SBizzInfo[bouse-100][sbEntranceCost]);
            OnPropUpdate();
            SendClientMessage(playerid, COLOR_WHITE, string);
        }
        else
        {
            if(bouse >= 5 && bouse <= 11 || bouse >= 19 && bouse <= 25)
            {
                if(strval(tmp) > 0 && strval(tmp) < 501) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}24/7: {FFFFFF} /bizfee poate fi maxim 500!"); return 1; }
            }
            BizzInfo[bouse][bEntranceCost] = strval(tmp);
            format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", BizzInfo[bouse][bEntranceCost]);
            OnPropUpdate();
            SendClientMessage(playerid, COLOR_WHITE, string);
        }
               format(query,sizeof(query),"UPDATE `bizz` SET `ePrice`='%s' WHERE `ID` = '%i'",BizzInfo[bouse][bEntranceCost], bouse);
             mysql_query(query);
    }
    return 1;
}
Link to comment
Share on other sites
  • 0
Jimmi Proficient

Jimmi

Posted
  • Author
Posted

Aici ?

public LoadBizz()
{
	new biss;
    new result[100],index = 0;
    new query[256];
	format(query, sizeof(query), "SELECT * FROM `bizz` ORDER BY `bizz`.`ID` ASC");
	mysql_query(query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        biss++;
		index++;
        new i = index;
        mysql_get_field("Owned", result);			BizzInfo[i][bOwned] = strval(result);
        mysql_get_field("Owner", result);			strmid(BizzInfo[i][bOwner], result, 0, 32, 32);
        mysql_get_field("Message", result);			strmid(BizzInfo[i][bMessage], result, 0, 60, 60);
        mysql_get_field("Extortion", result);       strmid(BizzInfo[i][bExtortion], result, 0, 32, 32);
        mysql_get_field("EntX", result);			BizzInfo[i][bEntranceX] = floatstr(result);
    	mysql_get_field("EntY", result);			BizzInfo[i][bEntranceY] = floatstr(result);
        mysql_get_field("EntZ", result);			BizzInfo[i][bEntranceZ] = floatstr(result);
        mysql_get_field("ExitX", result);			BizzInfo[i][bExitX] = floatstr(result);
    	mysql_get_field("ExitY", result);			BizzInfo[i][bExitY] = floatstr(result);
        mysql_get_field("ExitZ", result);			BizzInfo[i][bExitZ] = floatstr(result);
        mysql_get_field("Level", result);			BizzInfo[i][bLevelNeeded] = strval(result);
        mysql_get_field("Price", result);			BizzInfo[i][bBuyPrice] = strval(result);
        mysql_get_field("EPrice", result);			BizzInfo[i][bEntranceCost] = strval(result);
        mysql_get_field("Till", result);			BizzInfo[i][bTill] = strval(result);
        mysql_get_field("Locked", result);			BizzInfo[i][bLocked] = strval(result);
        mysql_get_field("Interior", result);		BizzInfo[i][bInterior] = strval(result);
        mysql_get_field("Products", result);		BizzInfo[i][bProducts] = strval(result);
        mysql_get_field("MaxProducts", result);		BizzInfo[i][bMaxProducts] = strval(result);
        mysql_get_field("ProductPrice", result);	BizzInfo[i][bPriceProd] = strval(result);
	}
	mysql_free_result();
	printf("%d bizz-uri create. (Daca apare 0 = Nu are conectiunea la baza de date)", index);
	return 1;
}

public LoadSBizz()
{
	new sbiss;
    new result[100],index = 0;
    new query[256];
	format(query, sizeof(query), "SELECT * FROM `sbizz`");
	mysql_query(query);
    mysql_store_result();
    while(mysql_retrieve_row())
    {
        sbiss++;
		index++;
		new i = index;
        mysql_get_field("Owned", result);			SBizzInfo[i][sbOwned] = strval(result);
        mysql_get_field("Owner", result);			strmid(SBizzInfo[i][sbOwner], result, 0, 32, 32);
        mysql_get_field("Message", result);			strmid(SBizzInfo[i][sbMessage], result, 0, 60, 60);
        mysql_get_field("Extortion", result);       strmid(SBizzInfo[i][sbExtortion], result, 0, 32, 32);
        mysql_get_field("EntX", result);			SBizzInfo[i][sbEntranceX] = floatstr(result);
    	mysql_get_field("EntY", result);			SBizzInfo[i][sbEntranceY] = floatstr(result);
        mysql_get_field("EntZ", result);			SBizzInfo[i][sbEntranceZ] = floatstr(result);
        mysql_get_field("ExitX", result);			SBizzInfo[i][sbExitX] = floatstr(result);
    	mysql_get_field("ExitY", result);			SBizzInfo[i][sbExitY] = floatstr(result);
        mysql_get_field("ExitZ", result);			SBizzInfo[i][sbExitZ] = floatstr(result);
        mysql_get_field("Level", result);			SBizzInfo[i][sbLevelNeeded] = strval(result);
        mysql_get_field("Price", result);			SBizzInfo[i][sbBuyPrice] = strval(result);
        mysql_get_field("EPrice", result);			SBizzInfo[i][sbEntranceCost] = strval(result);
        mysql_get_field("Till", result);			SBizzInfo[i][sbTill] = strval(result);
        mysql_get_field("Locked", result);			SBizzInfo[i][sbLocked] = strval(result);
        mysql_get_field("Interior", result);		SBizzInfo[i][sbInterior] = strval(result);
        mysql_get_field("Products", result);		SBizzInfo[i][sbProducts] = strval(result);
        mysql_get_field("MaxProducts", result);		SBizzInfo[i][sbMaxProducts] = strval(result);
        mysql_get_field("ProductPrice", result);	SBizzInfo[i][sbPriceProd] = strval(result);
	}
	mysql_free_result();
	printf("%d sbizz-uri create. (Daca apare 0 = Nu are conectiunea la baza de date", index);
	return 1;
}

sau te referi la onpropupdate?

Link to comment
Share on other sites
  • 0
WopsS Grand Master

WopsS

Posted
Posted

Tu de ce acolo ai variabila bouse care memoreaza o valoare mai mare decat 99?

Sincer, nu stiu ce ai facut acolo ... Nu prea am cum sa te ajut. Doar ca problema este ca tu accesezi o valoare mai mare decat trebuie in vectorul tau.

Link to comment
Share on other sites
  • 0
Jimmi Proficient

Jimmi

Posted
  • Author
Posted

Ceva de genul.

enum bInfo
{
    bOwned,
	bOwner[64],
	bMessage[128],
	bExtortion[MAX_PLAYER_NAME],
	Float:bEntranceX,
	Float:bEntranceY,
	Float:bEntranceZ,
	Float:bExitX,
	Float:bExitY,
	Float:bExitZ,
	bLevelNeeded,
	bBuyPrice,
	bEntranceCost,
	bTill,
	bLocked,
	bInterior,
	bProducts,
	bMaxProducts,
	bPriceProd,
};
new BizzInfo[100][bInfo];

 

Link to comment
Share on other sites
  • 0
WopsS Grand Master

WopsS

Posted
Posted

Modifica

new BizzInfo[100][bInfo];

in

new BizzInfo[200][bInfo];

Dar daca ai zis ca ai 24 de afaceri in baza de date, nu inteleg de ce tu depasesti limita cu ID-ul 106, nu stiu daca se va schimba sigur.

 

Poti sa-mi arati putin si

OnPropUpdate

?

Link to comment
Share on other sites
  • 0
Jimmi Proficient

Jimmi

Posted
  • Author
Posted

Ma duc in game dau bizfee la un biz si in mysql log apare

[12:44:58] CMySQLHandler::Query(SELECT * FROM `sbizz` ORDER BY `ID`) - Successfully executed.
[12:44:58] >> mysql_store_result( Connection handle: 1 )
[12:44:58] CMySQLHandler::StoreResult() - Result was stored.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_query( Connection handle: 1 )
[12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_query( Connection handle: 1 )
[12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Car Rent LS', `Extortion` = 'Jimmi', EntX = 564.715026, EntY = -1293.530029, EntZ = 17.248199, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 5000000, EPrice = 2000, Till = 10650, Locked = 0, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_query( Connection handle: 1 )
[12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Car Rent LV', `Extortion` = 'No-one', EntX = 2200.639892, EntY = 1394.219970, EntZ = 11.062500, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 2000000, EPrice = 2000, Till = 2000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_query( Connection handle: 1 )
[12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Jimmi', `Message` = 'Phone Company', `Extortion` = 'No-one', EntX = 1327.930053, EntY = -1558.560058, EntZ = 13.546899, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 11, Price = 3000000, EPrice = 1, Till = 25554, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_query( Connection handle: 1 )
[12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Gas Company LS', `Extortion` = 'No-one', EntX = 1000.109985, EntY = -920.078002, EntZ = 42.328098, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 20000000, EPrice = 15, Till = 2839920, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_query( Connection handle: 1 )
[12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Electrica', `Extortion` = 'No-one', EntX = 1329.920043, EntY = -985.466979, EntZ = 33.896598, ExitX = -959.643981, ExitY = 1955.949951, ExitZ = 9.000000, Level = 10, Price = 23000000, EPrice = 2, Till = 142335145, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_query( Connection handle: 1 )
[12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gas Company LV', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 23000000, EPrice = 2, Till = 27540000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 300 WHERE ID = 6) - Successfully executed.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_query( Connection handle: 1 )
[12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Las Venturas', `Extortion` = 'No-one', EntX = 2079.500000, EntY = 2046.040039, EntZ = 11.057900, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 23000000, EPrice = 5, Till = 2001200000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_query( Connection handle: 1 )
[12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Los Santos', `Extortion` = 'No-one', EntX = 845.726013, EntY = -1045.329956, EntZ = 25.441999, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 5000000, EPrice = 5, Till = 110, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_query( Connection handle: 1 )
[12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Kart Racing', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 1500, Till = 24330700, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_query( Connection handle: 1 )
[12:44:58] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Paintball', `Extortion` = 'No-one', EntX = 1310.160034, EntY = -1367.180053, EntZ = 13.522800, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 4000, Till = 1345381, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed.
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:58] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(UPDATE `players` SET `Money`='9010044' WHERE `username`='Jimmi') - Successfully executed.
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(SELECT * FROM `sbizz` ORDER BY `ID`) - Successfully executed.
[12:44:59] >> mysql_store_result( Connection handle: 1 )
[12:44:59] CMySQLHandler::StoreResult() - Result was stored.
[12:44:59] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed.
[12:44:59] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Car Rent LS', `Extortion` = 'Jimmi', EntX = 564.715026, EntY = -1293.530029, EntZ = 17.248199, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 5000000, EPrice = 2000, Till = 10650, Locked = 0, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed.
[12:44:59] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Car Rent LV', `Extortion` = 'No-one', EntX = 2200.639892, EntY = 1394.219970, EntZ = 11.062500, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 2000000, EPrice = 2000, Till = 2000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed.
[12:44:59] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Jimmi', `Message` = 'Phone Company', `Extortion` = 'No-one', EntX = 1327.930053, EntY = -1558.560058, EntZ = 13.546899, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 11, Price = 3000000, EPrice = 1, Till = 25554, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed.
[12:44:59] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Gas Company LS', `Extortion` = 'No-one', EntX = 1000.109985, EntY = -920.078002, EntZ = 42.328098, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 20000000, EPrice = 15, Till = 2839920, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed.
[12:44:59] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Electrica', `Extortion` = 'No-one', EntX = 1329.920043, EntY = -985.466979, EntZ = 33.896598, ExitX = -959.643981, ExitY = 1955.949951, ExitZ = 9.000000, Level = 10, Price = 23000000, EPrice = 2, Till = 142335145, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed.
[12:44:59] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gas Company LV', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 23000000, EPrice = 2, Till = 27540000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 300 WHERE ID = 6) - Successfully executed.
[12:44:59] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Las Venturas', `Extortion` = 'No-one', EntX = 2079.500000, EntY = 2046.040039, EntZ = 11.057900, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 23000000, EPrice = 5, Till = 2001200000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed.
[12:44:59] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Los Santos', `Extortion` = 'No-one', EntX = 845.726013, EntY = -1045.329956, EntZ = 25.441999, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 5000000, EPrice = 5, Till = 110, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed.
[12:44:59] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:44:59] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Kart Racing', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 1500, Till = 24330700, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed.
[12:44:59] >> mysql_retrieve_row( Connection handle: 1 )
[12:44:59] >> mysql_query( Connection handle: 1 )
[12:45:00] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Paintball', `Extortion` = 'No-one', EntX = 1310.160034, EntY = -1367.180053, EntZ = 13.522800, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 4000, Till = 1345381, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed.
[12:45:00] >> mysql_retrieve_row( Connection handle: 1 )
[12:45:00] >> mysql_retrieve_row( Connection handle: 1 )
Link to comment
Share on other sites
  • 0
Jimmi Proficient

Jimmi

Posted
  • Author
Posted 
public OnPropUpdate()
{
        new File: file2;
        new string[ 256 * 10 ];
        new idx;
        new index = 0;
        new query[256];
        format(query, sizeof(query), "SELECT * FROM `sbizz` ORDER BY `ID`");
        mysql_query(query);
        mysql_store_result();
        idx = 0;
        while(mysql_retrieve_row())
        {
            index++;
            idx = index - 1;
            format( string, sizeof(string), "UPDATE `sbizz` SET `Owned` = %d, `Owner` = '%s', `Message` = '%s', `Extortion` = '%s', EntX = %f, EntY = %f, EntZ = %f, ExitX = %f, ExitY = %f, ExitZ = %f, Level = %d, Price = %d, EPrice = %d, Till = %d, Locked = %d, Interior = %d, Products = %d, MaxProducts = %d, ProductPrice = %d WHERE ID = %d",
            SBizzInfo[idx][sbOwned],
            SBizzInfo[idx][sbOwner],
            SBizzInfo[idx][sbMessage],
            SBizzInfo[idx][sbExtortion],
            SBizzInfo[idx][sbEntranceX],
            SBizzInfo[idx][sbEntranceY],
            SBizzInfo[idx][sbEntranceZ],
            SBizzInfo[idx][sbExitX],
            SBizzInfo[idx][sbExitY],
            SBizzInfo[idx][sbExitZ],
            SBizzInfo[idx][sbLevelNeeded],
            SBizzInfo[idx][sbBuyPrice],
            SBizzInfo[idx][sbEntranceCost],
            SBizzInfo[idx][sbTill],
            SBizzInfo[idx][sbLocked],
            SBizzInfo[idx][sbInterior],
            SBizzInfo[idx][sbProducts],
            SBizzInfo[idx][sbMaxProducts],
            SBizzInfo[idx][sbPriceProd],
            idx);
            mysql_query(string);
   }
   while(mysql_retrieve_row())
   {
      index++;
      idx = index - 1;
      format( string, sizeof(string), "UPDATE `bizz` SET `Owned` = %d, `Owner` = '%s', `Message` = '%s', `Extortion` = '%s', EntX = %f, EntY = %f, EntZ = %f,ExitX = %f, ExitY = %f, ExitZ = %f, Level = %d, Price = %d, EPrice = %d, Till = %d, Locked = %d, Interior = %d, Products = %d, MaxProducts = %d, ProductPrice = %d WHERE ID = %d",
      BizzInfo[idx][bOwned],
      BizzInfo[idx][bOwner],
      BizzInfo[idx][bMessage],
      BizzInfo[idx][bExtortion],
      BizzInfo[idx][bEntranceX],
      BizzInfo[idx][bEntranceY],
      BizzInfo[idx][bEntranceZ],
      BizzInfo[idx][bExitX],
      BizzInfo[idx][bExitY],
      BizzInfo[idx][bExitZ],
      BizzInfo[idx][bLevelNeeded],
      BizzInfo[idx][bBuyPrice],
      BizzInfo[idx][bEntranceCost],
      BizzInfo[idx][bTill],
      BizzInfo[idx][bLocked],
      BizzInfo[idx][bInterior],
      BizzInfo[idx][bProducts],
      BizzInfo[idx][bMaxProducts],
      BizzInfo[idx][bPriceProd],
      idx);
       mysql_query(string);


   }
    idx = 1;
   while (idx < sizeof(GangInfo))
   {
      new coordsstring[256];
      format(coordsstring, sizeof(coordsstring), "%d,%d,%d\n",
      GangInfo[idx][gID],//
      GangInfo[idx][gFaction],
      GangInfo[idx][gHours]);//
      if(idx == 1)
      {
         file2 = fopen("Configs/gangzones.cfg", io_write);
      }
      else
      {
         file2 = fopen("Configs/gangzones.cfg", io_append);
      }
      fwrite(file2, coordsstring);
      idx++;
      fclose(file2);
   }
    idx = 2;
   while (idx < sizeof(Bank))
   {
      new coordsstring[256];
      format(coordsstring, sizeof(coordsstring), "%d,%d\n",
      Bank[idx][bankID],//
      Bank[idx][bankHours]);//
      if(idx == 1)
      {
         file2 = fopen("Configs/bank.cfg", io_write);
      }
      else
      {
         file2 = fopen("Configs/bank.cfg", io_append);
      }
      fwrite(file2, coordsstring);
      idx++;
      fclose(file2);
   }
   return 1;
}

 

Link to comment
Share on other sites
  • 0
WopsS Grand Master

WopsS

Posted
Posted

Fii atent, mai jos ai functia explicata.

public OnPropUpdate()
{
	new File: file2;
	new string[256 * 10];
	new idx;
	new index = 0;
	new query[256];
	format(query, sizeof(query), "SELECT * FROM `sbizz` ORDER BY `ID`");
	mysql_query(query);
	mysql_store_result();
	idx = 0;
	while (mysql_retrieve_row())
	{
		index++;
		idx = index - 1;
		format(string, sizeof(string), "UPDATE `sbizz` SET `Owned` = %d, `Owner` = '%s', `Message` = '%s', `Extortion` = '%s', EntX = %f, EntY = %f, EntZ = %f, ExitX = %f, ExitY = %f, ExitZ = %f, Level = %d, Price = %d, EPrice = %d, Till = %d, Locked = %d, Interior = %d, Products = %d, MaxProducts = %d, ProductPrice = %d WHERE ID = %d",
			   SBizzInfo[idx][sbOwned],
			   SBizzInfo[idx][sbOwner],
			   SBizzInfo[idx][sbMessage],
			   SBizzInfo[idx][sbExtortion],
			   SBizzInfo[idx][sbEntranceX],
			   SBizzInfo[idx][sbEntranceY],
			   SBizzInfo[idx][sbEntranceZ],
			   SBizzInfo[idx][sbExitX],
			   SBizzInfo[idx][sbExitY],
			   SBizzInfo[idx][sbExitZ],
			   SBizzInfo[idx][sbLevelNeeded],
			   SBizzInfo[idx][sbBuyPrice],
			   SBizzInfo[idx][sbEntranceCost],
			   SBizzInfo[idx][sbTill],
			   SBizzInfo[idx][sbLocked],
			   SBizzInfo[idx][sbInterior],
			   SBizzInfo[idx][sbProducts],
			   SBizzInfo[idx][sbMaxProducts],
			   SBizzInfo[idx][sbPriceProd],
			   idx);
		mysql_query(string);
	}
	mysql_free_result();

	format(query, sizeof(query), "SELECT * FROM `bizz` ORDER BY `ID`"); // Selectezi din tabelul "bizz". Tu inainte nu faceai asta.
	mysql_query(query); // Executi interogarea de mai sus.
	mysql_store_result(); // Pastrezi datele despre interogare.
	idx = 0;
	index = 0;
	while (mysql_retrieve_row()) // Incepi si mergi prin toate rezultatele interogarii.
	{
		index++;
		idx = index - 1;
		format(string, sizeof(string), "UPDATE `bizz` SET `Owned` = %d, `Owner` = '%s', `Message` = '%s', `Extortion` = '%s', EntX = %f, EntY = %f, EntZ = %f,ExitX = %f, ExitY = %f, ExitZ = %f, Level = %d, Price = %d, EPrice = %d, Till = %d, Locked = %d, Interior = %d, Products = %d, MaxProducts = %d, ProductPrice = %d WHERE ID = %d",
			   BizzInfo[idx][bOwned],
			   BizzInfo[idx][bOwner],
			   BizzInfo[idx][bMessage],
			   BizzInfo[idx][bExtortion],
			   BizzInfo[idx][bEntranceX],
			   BizzInfo[idx][bEntranceY],
			   BizzInfo[idx][bEntranceZ],
			   BizzInfo[idx][bExitX],
			   BizzInfo[idx][bExitY],
			   BizzInfo[idx][bExitZ],
			   BizzInfo[idx][bLevelNeeded],
			   BizzInfo[idx][bBuyPrice],
			   BizzInfo[idx][bEntranceCost],
			   BizzInfo[idx][bTill],
			   BizzInfo[idx][bLocked],
			   BizzInfo[idx][bInterior],
			   BizzInfo[idx][bProducts],
			   BizzInfo[idx][bMaxProducts],
			   BizzInfo[idx][bPriceProd],
			   idx);
		mysql_query(string);


	}
	mysql_free_result();
	idx = 1;
	while (idx < sizeof(GangInfo))
	{
		new coordsstring[256];
		format(coordsstring, sizeof(coordsstring), "%d,%d,%d\n",
			   GangInfo[idx][gID],//
			   GangInfo[idx][gFaction],
			   GangInfo[idx][gHours]);//
		if (idx == 1)
		{
			file2 = fopen("Configs/gangzones.cfg", io_write);
		}
		else
		{
			file2 = fopen("Configs/gangzones.cfg", io_append);
		}
		fwrite(file2, coordsstring);
		idx++;
		fclose(file2);
	}
	idx = 2;
	while (idx < sizeof(Bank))
	{
		new coordsstring[256];
		format(coordsstring, sizeof(coordsstring), "%d,%d\n",
			   Bank[idx][bankID],//
			   Bank[idx][bankHours]);//
		if (idx == 1)
		{
			file2 = fopen("Configs/bank.cfg", io_write);
		}
		else
		{
			file2 = fopen("Configs/bank.cfg", io_append);
		}
		fwrite(file2, coordsstring);
		idx++;
		fclose(file2);
	}

	return 1;
}

 

Link to comment
Share on other sites
  • 0
Jimmi Proficient

Jimmi

Posted
  • Author
Posted

Mersi ca mi-ai explicat.Acuma cand dau /bizfee se reincarca si biz-urile dar pretul ramane aceleasi.Poate fi de la comanda /bizfee?

if(strcmp(cmd, "/bizfee", true) == 0)
{
    if(IsPlayerConnected(playerid))
    {
        new bouse = PlayerInfo[playerid][pPbiskey];
        new query[256];
        if (bouse == 255) return SendClientMessage(playerid, COLOR_GRAD2, "   Nu detii o afacere !");
        tmp = strtok(cmdtext, idx);
        if(!strlen(tmp)) return SendClientMessage(playerid, COLOR_WHITE, "{00FF00}Folosire:{FFFFFF} /bizfee [EntranceFee]");
        if(strval(tmp) < 0 || strval(tmp) > 2000) return SendClientMessage(playerid, COLOR_WHITE, "Suma minima este de $0, suma maxima este de $2000.");
        if (bouse >= 100)
        {
            if(bouse == 102)
            {
                if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Phone Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; }
            }
            if(bouse == 103)
            {
                if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Gas Company: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; }
            }
            if(bouse == 104)
            {
                if(strval(tmp) > 0 && strval(tmp) < 101) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}Electricity Company: {FFFFFF} /bizfee poate fi maxim 100!"); return 1; }
            }
            if(bouse == 106 || bouse == 107)
            {
                if(strval(tmp) > 0 && strval(tmp) < 51) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}CNN: {FFFFFF} /bizfee poate fi maxim 50!"); return 1; }
            }
            SBizzInfo[bouse-100][sbEntranceCost] = strval(tmp);
            format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", SBizzInfo[bouse-100][sbEntranceCost]);
            OnPropUpdate();
            SendClientMessage(playerid, COLOR_WHITE, string);
        }
        else
        {
            if(bouse >= 5 && bouse <= 11 || bouse >= 19 && bouse <= 25)
            {
                if(strval(tmp) > 0 && strval(tmp) < 501) { } else { SendClientMessage(playerid, COLOR_WHITE, "{0066FF}24/7: {FFFFFF} /bizfee poate fi maxim 500!"); return 1; }
            }
            BizzInfo[bouse][bEntranceCost] = strval(tmp);
            format(string, sizeof(string), "Pretul de intrare a fost setat pe $%d.", BizzInfo[bouse][bEntranceCost]);
            OnPropUpdate();
            SendClientMessage(playerid, COLOR_WHITE, string);
        }
               format(query,sizeof(query),"UPDATE `bizz` SET `ePrice`='%s' WHERE `ID` = '%i'",BizzInfo[bouse][bEntranceCost], bouse);
             mysql_query(query);
    }
    return 1;
}
Link to comment
Share on other sites
  • 0
Jimmi Proficient

Jimmi

Posted
  • Author
Posted

Am pus chestia aia crezand ca de aceea nu se modifica pretul de intrare.Totusi la fel nu se schimba.

mysql_log

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:12] CMySQLHandler::Query(SELECT * FROM `sbizz` ORDER BY `ID`) - Successfully executed.

[14:59:12] >> mysql_store_result( Connection handle: 1 )

[14:59:12] CMySQLHandler::StoreResult() - Result was stored.

[14:59:12] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed.

[14:59:12] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Car Rent LS', `Extortion` = 'Jimmi', EntX = 564.715026, EntY = -1293.530029, EntZ = 17.248199, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 5000000, EPrice = 2000, Till = 10650, Locked = 0, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed.

[14:59:12] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Car Rent LV', `Extortion` = 'No-one', EntX = 2200.639892, EntY = 1394.219970, EntZ = 11.062500, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 5, Price = 2000000, EPrice = 2000, Till = 2000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed.

[14:59:12] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Jimmi', `Message` = 'Phone Company', `Extortion` = 'No-one', EntX = 1327.930053, EntY = -1558.560058, EntZ = 13.546899, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 11, Price = 3000000, EPrice = 1, Till = 25554, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed.

[14:59:12] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 1, `Owner` = 'Trickster.', `Message` = 'Gas Company LS', `Extortion` = 'No-one', EntX = 1000.109985, EntY = -920.078002, EntZ = 42.328098, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 20000000, EPrice = 15, Till = 2839920, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed.

[14:59:12] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Electrica', `Extortion` = 'No-one', EntX = 1329.920043, EntY = -985.466979, EntZ = 33.896598, ExitX = -959.643981, ExitY = 1955.949951, ExitZ = 9.000000, Level = 10, Price = 23000000, EPrice = 2, Till = 142335145, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed.

[14:59:12] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gas Company LV', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 12, Price = 23000000, EPrice = 1, Till = 27540000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 300 WHERE ID = 6) - Successfully executed.

[14:59:12] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Las Venturas', `Extortion` = 'No-one', EntX = 2079.500000, EntY = 2046.040039, EntZ = 11.057900, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 23000000, EPrice = 5, Till = 2001200000, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed.

[14:59:12] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'CNN Los Santos', `Extortion` = 'No-one', EntX = 845.726013, EntY = -1045.329956, EntZ = 25.441999, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 15, Price = 5000000, EPrice = 5, Till = 110, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed.

[14:59:12] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:12] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Kart Racing', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 1500, Till = 24330700, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed.

[14:59:12] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:12] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `sbizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Paintball', `Extortion` = 'No-one', EntX = 1310.160034, EntY = -1367.180053, EntZ = 13.522800, ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 20, Price = 23000000, EPrice = 4000, Till = 1345381, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_free_result( Connection handle: 1 )

[14:59:13] CMySQLHandler::FreeResult() - Result was successfully free'd.

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(SELECT * FROM `bizz` ORDER BY `ID`) - Successfully executed.

[14:59:13] >> mysql_store_result( Connection handle: 1 )

[14:59:13] CMySQLHandler::StoreResult() - Result was stored.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = '', `Message` = '', `Extortion` = '', EntX = 0.000000, EntY = 0.000000, EntZ = 0.000000,ExitX = 0.000000, ExitY = 0.000000, ExitZ = 0.000000, Level = 0, Price = 0, EPrice = 0, Till = 0, Locked = 0, Interior = 0, Products = 0, MaxProducts = 0, ProductPrice = 0 WHERE ID = 0) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gun Shop Los Santos', `Extortion` = 'No-one', EntX = 1791.689941, EntY = -1164.030029, EntZ = 23.828100,ExitX = 315.769989, ExitY = -143.354003, ExitZ = 999.601989, Level = 15, Price = 23000000, EPrice = 2000, Till = 2296568, Locked = 0, Interior = 7, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 1) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gun Shop Las Venturas', `Extortion` = 'No-one', EntX = 2187.060058, EntY = 1113.650024, EntZ = 12.653800,ExitX = 285.815002, ExitY = -86.461402, ExitZ = 1001.520019, Level = 10, Price = 15000000, EPrice = 2000, Till = 2296568, Locked = 1, Interior = 4, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 2) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Restaurant Los Santos', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000,ExitX = -794.939025, ExitY = 489.848999, ExitZ = 1376.199951, Level = 5, Price = 5000000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 1, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 3) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7 Benzinarie LS', `Extortion` = 'No-one', EntX = 0.000000, EntY = 0.000000, EntZ = 999.000000,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 2500000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 4) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 1, `Owner` = 'AndyTLV', `Message` = '24/7 Fish LS', `Extortion` = 'No-one', EntX = 388.040008, EntY = -1897.229980, EntZ = 7.835939,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 2500000, EPrice = 5, Till = 2296568, Locked = 0, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 5) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 1, `Owner` = 'Jimmi', `Message` = '24/7 Mall', `Extortion` = 'No-one', EntX = 1154.400024, EntY = -1440.229980, EntZ = 15.801600,ExitX = 1156.750000, ExitY = -1440.270019, ExitZ = 15.798100, Level = 5, Price = 2500000, EPrice = 5, Till = 2296593, Locked = 0, Interior = 0, Products = 95, MaxProducts = 500, ProductPrice = 100 WHERE ID = 6) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7', `Extortion` = 'No-one', EntX = 1315.430053, EntY = -898.622985, EntZ = 39.578098,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 2500000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 7) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7 ', `Extortion` = 'No-one', EntX = 841.130981, EntY = -1596.540039, EntZ = 13.546899,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 2500000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 8) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Sex Shop', `Extortion` = 'No-one', EntX = 1087.680053, EntY = -922.481018, EntZ = 43.390598,ExitX = -100.555999, ExitY = -24.326700, ExitZ = 1000.719970, Level = 5, Price = 500000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 3, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 9) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 1, `Owner` = 'The_Edic', `Message` = 'Sex Shop 24/7', `Extortion` = 'No-one', EntX = 1833.099975, EntY = -1842.510009, EntZ = 13.578100,ExitX = -100.555999, ExitY = -24.326700, ExitZ = 1000.719970, Level = 5, Price = 500000, EPrice = 5, Till = 2296568, Locked = 0, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 10) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Cluckin Bell Grove Stree', `Extortion` = 'No-one', EntX = 2420.370117, EntY = -1508.959960, EntZ = 24.000000,ExitX = 364.950988, ExitY = -11.041299, ExitZ = 1001.849975, Level = 5, Price = 500000, EPrice = 5, Till = 2296568, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 11) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Cluckin Bell T.C.C', `Extortion` = 'No-one', EntX = 927.765991, EntY = -1352.810058, EntZ = 13.343799,ExitX = 364.950988, ExitY = -11.041299, ExitZ = 1001.849975, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 12) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Burger Shot Plaja LS', `Extortion` = 'No-one', EntX = 810.973999, EntY = -1616.229980, EntZ = 13.546899,ExitX = 363.265991, ExitY = -74.840202, ExitZ = 1001.510009, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 13) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Well Stacked Pizza', `Extortion` = 'No-one', EntX = 2104.699951, EntY = -1807.130004, EntZ = 13.575900,ExitX = 372.351013, ExitY = -132.964004, ExitZ = 1001.489990, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 0, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 14) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7 ', `Extortion` = 'No-one', EntX = 2884.860107, EntY = 2453.639892, EntZ = 11.069000,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 15) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7 ', `Extortion` = 'No-one', EntX = 2546.520019, EntY = 1972.010009, EntZ = 10.820300,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 16) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7 Burger Shot LV', `Extortion` = 'No-one', EntX = 2452.429931, EntY = 2064.399902, EntZ = 10.820300,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 17) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7', `Extortion` = 'No-one', EntX = 2247.739990, EntY = 2397.070068, EntZ = 10.820300,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 18) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7', `Extortion` = 'No-one', EntX = 2097.620117, EntY = 2224.310058, EntZ = 11.023400,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 19) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = '24/7', `Extortion` = 'No-one', EntX = 1937.150024, EntY = 2307.149902, EntZ = 10.820300,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 20) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Pay N Spray', `Extortion` = 'No-one', EntX = 1034.750000, EntY = -1028.189941, EntZ = 32.101600,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 7500000, EPrice = 15, Till = 2296568, Locked = 1, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 21) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:13] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Gungame Arena', `Extortion` = 'No-one', EntX = 1965.800048, EntY = 1623.219970, EntZ = 12.862099,ExitX = -25.884500, ExitY = -185.869003, ExitZ = 1003.549987, Level = 5, Price = 5000000, EPrice = 15, Till = 2296568, Locked = 0, Interior = 17, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 22) - Successfully executed.

[14:59:13] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:13] >> mysql_query( Connection handle: 1 )

[14:59:14] CMySQLHandler::Query(UPDATE `bizz` SET `Owned` = 0, `Owner` = 'The State', `Message` = 'Casino Las Venturas', `Extortion` = 'No-one', EntX = 2020.160034, EntY = 1007.739990, EntZ = 10.820300,ExitX = 2018.579956, ExitY = 1017.750000, ExitZ = 996.875000, Level = 5, Price = 5000000, EPrice = 15, Till = 2296568, Locked = 0, Interior = 10, Products = 100, MaxProducts = 500, ProductPrice = 100 WHERE ID = 23) - Successfully executed.

[14:59:14] >> mysql_retrieve_row( Connection handle: 1 )

[14:59:14] >> mysql_free_result( Connection handle: 1 )

[14:59:14] CMySQLHandler::FreeResult() - Result was successfully free'd.

 

Link to comment
Share on other sites
  • 0
WopsS Grand Master

WopsS

Posted
Posted

A, m-am prins.

Fii atent.

La SBizz tu scazi ID-ul din joc cu 100 (SBizzInfo[bouse-100][sbEntranceCost] = strval(tmp);). Asa ca m-am uitat la eroarea ta care ti-o dade acu ID-ul mai mare si am vazut ID-ul 106 am verificat log-urile pe care le-ai dat si am vazut ca ai afacerea cu ID-ul 6 asa ca, in comanda /bizfee modifica

BizzInfo[bouse][bEntranceCost] = strval(tmp);

in

BizzInfo[bouse - 100][bEntranceCost] = strval(tmp); // Scazi 100 din ID-ul afacerii si ajungi la ID-ul 6.


 

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to question listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.