Jump to content

SpriteTV

Membru
 View Profile  See their activity

  • Posts

    65

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Posts posted by SpriteTV

  3. Problema nu se salveaza rob points la payday.

    in Ajutor Scripting

    Posted · Edited by SpriteTV

    Acum 30 minute, AlexxAdv a spus:

    Verifica daca ai gm bigzone,  Update(i, pRobx);

    si vezi unde ai

     

    case pRobx: daca ai UPDATE `users` SET `Rob` sau cum ai tu ='%d'

    Sa fie egal cu %d deoarece %d reprezinta numar.

    Sa nu ai %f sau alte chestii. Si vezi cum e facut tabelul in baza de date, sa nu fie conform conditiei pe 0, doar il adaugi Rob sau cum e salvat in baza de date.

     

    Da, alta rezolvare ar fi sa verifici cum e tabelul in baza de date in care trebuie sa se salveze ca poate in gm ai update users set `rob1` dar in baza de date este rob. Si mai vezi daca este where name='%s' pnormalname. etc.

     

    Ca am patit acu 2 zile nu mi se salva cand dadeam /getjob si nu aveam WHERE `name`='%s' aveam WHERE `name`='s' si nu vedeam % ala si nu ii dadeam de cap, deci uitate foarte atent. Astea sunt rezolvarile, altele nu cred...

    am gm bigzone dar adus intr`o stare mult avansata si facut pe include-uri.

    dar mai bagat rau inceata cu baza de date

  4. Problema nu se salveaza rob points la payday.

    in Ajutor Scripting

    Posted · Edited by SpriteTV

    Salut am si eu problema urmatoare nu mi-se salveaza rob points-ul si nu inteleg care ar fi problema daca se poate sa ma ajute cineva. 

    public PayDay()
{
	new string[128],
		str[256],
		string3[256],
		interest,
		account[MAX_PLAYERS],
		hour,
		minn,
		sec,
		ye,
		mo,
		da,
		rent[MAX_PLAYERS],
		hourscount;
	gettime(hour,minn,sec);
	getdate(ye, mo, da);
	if(RestartTimer == 1)
	{
		SendClientMessageToAll(COLOR_YELLOW, "---- SERVER RESTART ----");
		SendClientMessageToAll(COLOR_RED2, "The server will be restarted in 60 seconds.");
		foreach(new x : Player)
		{
			Update(x, pPayDayx);
			Update(x, pPayCheckx);
			Update(x, pFpunishx);
			Update(x, pConnectTimex);
			Update(x, pBank);
			Update(x, pCashx);
			Update(x, pExpx);
			Update(x, pJailTimex);
			Update(x, pLevelx);
			Update(x, pRob);
		}
		iGMXTick = 60;
		iGMXTimer = SetTimer("restartTimer", 1000, true);
		RestartTimer = 0;
	}
	foreach(new i : Player)
	{
		if(IsPlayerConnected(i))
		{
		    if(PlayerInfo[i][pLevel] >= 0)
		    {
            	new wakaname[25];
                GetPlayerName(i,wakaname,sizeof(wakaname));
			    if(MoneyMessage[i]==1)
				{
				    SendClientMessage(i, COLOR_LIGHTRED, "You failed to pay your debt, Jail time.");
                    new rand;
					rand = random(sizeof(gRandomJailSpawns));
					SetPlayerInterior(i, 6);
					SetPlayerPosEx(i,gRandomJailSpawns[rand][0],gRandomJailSpawns[rand][1],gRandomJailSpawns[rand][2]);
		            PlayerInfo[i][pJailed] = 1;
		            ResetPlayerWeaponsEx(i);
		            ResetPlayerWeapons(i);
					WantedPoints[i] = 0;
					PlayerInfo[i][pJailTime] = 240;
					format(string, sizeof(string), "You are jailed for %d seconds. Bail: Unable", PlayerInfo[i][pJailTime]);
					SendClientMessage(i, COLOR_LIGHTBLUE, string);
					ResetPlayerCash(i);
					GivePlayerCash(i, 10000);
					Update(i, pCashx);
					Update(i,pJailedx);
					Update(i,pJailTimex);
					TogglePlayerControllable(i, 0);
					SetTimerEx("UnFreezeStation", 1000, false, "i", i);
				}
				new key = PlayerInfo[i][pPhousekey];
				if(key != 999)
				{
					rent[i] = HouseInfo[key][hRent];
					if(rent[i] > GetPlayerCash(i) && strcmp(PlayerInfo[i][pNormalName], HouseInfo[key][hOwner], false) == 0)
					{
						PlayerInfo[i][pPhousekey] = 999;
						Update(i,pPhousekeyx);
					}
					HouseInfo[key][hTakings] += rent[i];
				    mysql_format(SQL,str,sizeof(str),"UPDATE `houses` SET `Takings`='%d' WHERE `ID`='%d'",HouseInfo[key][hTakings],key);
				    mysql_tquery(SQL,str,"","");
				}
				new tmpintrate;
				if(PlayerInfo[i][pPremiumAccount] > 0)
				{
					tmpintrate = 2;
	    			new bonus = PlayerInfo[i][pPayCheck] / 2;
				    PlayerInfo[i][pPayCheck] += bonus;
				}
				else
				{
					tmpintrate = 1;
				}
				account[i] = PlayerInfo[i][pAccount];
				Tax += TaxValue;
    			PlayerInfo[i][pAccount] -= TaxValue;
				new checks = PlayerInfo[i][pPayCheck];
    			PlayerInfo[i][pAccount] += checks;
				interest = (PlayerInfo[i][pAccount]/1000)*(tmpintrate);
				new finalinterest,stringore[128];
				new Float:timee,Float:timee2;
				SendClientMessage(i, COLOR_TEAL, "----------------------------------------------------------------------------");
				SendClientMessage(i, COLOR_WHITE, "Your paycheck has arrived; please visit the bank to withdraw your money.");
				PlayerInfo[i][pConnectTime] += PlayerInfo[i][pPayDay] / 3600.0;
				timee = PlayerInfo[i][pPayDay] / 3600.0;
				timee2 = PlayerInfo[i][pPayDay] / 60.0;
				finalinterest = interest;
				if(PlayerInfo[i][pPayDay] > 1801)
				{
					PlayerInfo[i][pGiftTime] += 40;
					Update(i, pGiftTimex);
					SS(i,COLOR_LIGHTBLUE, "Ai primit 40 gift points pentru ca ai jucat 1801 secunde.","You recieved 40 gift points because you played 1801 seconds.");
				}
				else {
					PlayerInfo[i][pGiftTime] += 20;
					Update(i, pGiftTimex);
					SS(i,COLOR_LIGHTBLUE, "Ai primit 20 gift points pentru ca nu ai jucat 1801 secunde.","You recieved 20 gift points because you not played 1801 seconds.");
				}
				if(PlayerInfo[i][pMember] != 0)
				{
					PlayerInfo[i][pPaydayON]++;
					Update(i, pPaydayONx);
				}
				if(PlayerInfo[i][pLeader] > 0)
				{
					GivePlayerCash(i, 50000);
					format(string, sizeof(string), "Ai primit salariul de leader ($50000).");
					format(stringore, sizeof(stringore), "You recieved the leader salary ($50000).");
					SS(i, COLOR_LIGHTBLUE, string, stringore);
				}
				if(PlayerInfo[i][pHelper] > 0)
				{
					GivePlayerCash(i, 50000);
					format(string, sizeof(string), "Ai primit salariul de helper ($50000).");
					format(stringore, sizeof(stringore), "You recieved the helper salary ($50000).");
					SS(i, COLOR_LIGHTBLUE, string, stringore);
				}
				Update(i, pCashx);
				PlayerInfo[i][pPayDay] = 0;
				hourscount++;
				if(PlayerInfo[i][pLanguage] == 1)
				{
					format(stringore, sizeof(stringore), "You received %.2f hours played (%d minutes).",timee,floatround(timee2));
				}
				else
				{
					format(stringore, sizeof(stringore), "Ai primit %.2f ore jucate (%d minute).",timee,floatround(timee2));
				}
				SendClientMessage(i, COLOR_WHITE, stringore);
				if(PlayerInfo[i][pRob] < 20)
    			{
       				PlayerInfo[i][pRob]++;
       				Update(i, pRob);
           		}
           		else
           		{
           		    SS(i, COLOR_WHITE, "Nu ai primit niciun rob/free point pentru ca ai deja 20 rob/free points.", "No rob points for you! You have too many rob/free points. You can't store more than 20 rob/free points.");
				    Update(i, pRob);
				}
				PlayerInfo[i][pExp] += 1;
				PlayerInfo[i][pAccount] += finalinterest;
				/*format(string, sizeof(string), "Paycheck: $%s | Bank balance: $%s | Bank interest: $%s | Tax: $%s (10 percent)", FormatNumber(checks), FormatNumber(PlayerInfo[i][pAccount]), FormatNumber(finalinterest), FormatNumber(TaxValue));
				SendClientMessage(i, COLOR_GREY, string);
				format(string3, sizeof(string3), "Rent: $%s | Total earnings: $%d", FormatNumber(rent[i]), checks-TaxValue);
				SendClientMessage(i, COLOR_GREY, string3);
				SendClientMessage(i, COLOR_TEAL, "----------------------------------------------------------------------------");*/
				//PayDaYTD {2b87ff}
			    format(string3, sizeof(string3), "PAYDAY:~n~Minute jucate: +%d~n~Paycheck: $%s ~n~ Bank balance: $%s ~n~ Bank interest: $%s ~n~ Tax: $%s (10 percent)~n~Rent: $%s | Total earnings: $%d",PlayerInfo[i][pPayDay]/60+1, FormatNumber(checks), FormatNumber(PlayerInfo[i][pAccount]), FormatNumber(finalinterest), FormatNumber(TaxValue), FormatNumber(rent[i]), checks-TaxValue);
			    PlayerTextDrawSetString(i, PayDayTD, string3);
			    PlayerTextDrawShow(i, PayDayTD);
			    format(string, sizeof(string), "~y~payday");
			    GameTextForPlayer(i, string, 5000, 1);
				format(string, sizeof(string), "~g~payday");
				GameTextForPlayer(i, string, 5000, 1);
				if(PlayerInfo[i][pRollPoints] < 100) PlayerInfo[i][pRollPoints] +=20, Update(i, pRollPointsx);
				format(string, sizeof(string), "Roll Points: %d/100", PlayerInfo[i][pRollPoints]);
				SCM(i, COLOR_LIGHTGREEN3, string);
				if(PlayerInfo[i][pCarLicT] > 0)
				{
					PlayerInfo[i][pCarLicT] -= 1;
					if(PlayerInfo[i][pCarLicT] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de condus a expirat, poti merge la DMV pentru a obtine alta.","* Your driving licence was expired, you can go to the DMV to get another.");
				}
				if(PlayerInfo[i][pFlyLicT] > 0)
				{
					PlayerInfo[i][pFlyLicT] -= 1;
					if(PlayerInfo[i][pFlyLicT] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de zburat a expirat, poti obtine alta contactand un instructor [/instructors].","* Your flying licence was expired, you can get antoher contacting a instructor [/instructors].");
				}
				if(PlayerInfo[i][pBoatLicT] > 0)
				{
					PlayerInfo[i][pBoatLicT] -= 1;
					if(PlayerInfo[i][pBoatLicT] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de barci a expirat, poti obtine alta contactand un instructor [/instructors].","* Your boat licence was expired, you can get antoher contacting a instructor [/instructors].");
				}
				if(PlayerInfo[i][pGunLicT] > 0)
				{
					PlayerInfo[i][pGunLicT] -= 1;
					if(PlayerInfo[i][pGunLicT] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de arme a expirat, poti obtine alta contactand un instructor [/instructors].","* Your weapon licence was expired, you can get antoher contacting a instructor [/instructors].");
				}
				if(PlayerInfo[i][pFpunish] > 0)
				{
					PlayerInfo[i][pFpunish]--;
		 		}
		 		if(PlayerInfo[i][pFpunish] < 0)
		 		{
	    			PlayerInfo[i][pFpunish] = 0;
				}
				if(PlayerInfo[i][pCarLicSuspend] > 0)
				{
					PlayerInfo[i][pCarLicSuspend]--;
					Update(i, pCarLicSuspendx);
					if(PlayerInfo[i][pCarLicSuspend] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de condus a fost confiscata recent, acum poti merge iar la DMV pentru a obtine alta.","* Your driving licence was confiscated recently, now you can go to the DMV to get another.");
				}
				if(PlayerInfo[i][pGunLicSuspend] > 0)
				{
					PlayerInfo[i][pGunLicSuspend]--;
					Update(i, pGunLicSuspendx);
					if(PlayerInfo[i][pGunLicSuspend] == 0) SS(i, COLOR_YELLOW, "* Licenta ta de arme a fost confiscata recent, acum poti contacta un instructor pentru a obtine alta [/instructors].","* Your weapon licence was confiscated recently, now you can get antoher contacting a instructor [/instructors].");
				}
				PlayerInfo[i][pPayCheck] = 0;
				new month, day, inserted, dx;
				format(str, sizeof(str), "SELECT * FROM `timeplayed` WHERE `pid`='%d'", PlayerInfo[i][pSQLID]);
				new Cache: xd = mysql_query(SQL, str);
				if(cache_get_row_count() > 0)
				{
					for(new d, js = cache_get_row_count (); d != js; ++d)
					{
						month = cache_get_field_content_int(d, "month");
						day = cache_get_field_content_int(d, "day");
						if(day == da && month == mo)
						{
							inserted = 1;
						}
					}
				}
				else
				{
					mysql_format(SQL, str, sizeof(str), "INSERT INTO `timeplayed` (`pid`,`time`,`month`,`day`,`year`,`unixtime`) VALUES ('%d','%d','%s%d','%s%d','%d','%d')", PlayerInfo[i][pSQLID], OnlineTimeToday[i], ((mo < 10) ? ("0") : ("")), mo, ((da < 10) ? ("0") : ("")), da, ye, gettime());
					mysql_tquery(SQL, str, "", "");
					dx = 1;
					OnlineTimeToday[i] = 0;
					Update(i, pOnlineTimeTodayx);
				}
				cache_delete(xd);
				if(dx == 0)
				{
					if(inserted == 1)
					{
						mysql_format(SQL, str, sizeof(str), "UPDATE timeplayed SET time = time+%d WHERE month = %d AND day = %d AND pid = %d", OnlineTimeToday[i], mo, da, PlayerInfo[i][pSQLID]);
						mysql_tquery(SQL, str, "", "");
						OnlineTimeToday[i] = 0;
						Update(i, pOnlineTimeTodayx);
					}
					else
					{
						mysql_format(SQL, str, sizeof(str), "INSERT INTO `timeplayed` (`pid`,`time`,`month`,`day`,`year`,`unixtime`) VALUES ('%d','%d','%s%d','%s%d','%d','%d')", PlayerInfo[i][pSQLID], OnlineTimeToday[i], ((mo < 10) ? ("0") : ("")), mo, ((da < 10) ? ("0") : ("")), da, ye, gettime());
						mysql_tquery(SQL, str, "", "");
						OnlineTimeToday[i] = 0;
						Update(i, pOnlineTimeTodayx);
					}
				}
				UpdateProgressBar(i); 
			}
		}
	}
	format(str, sizeof(str), "INSERT INTO `toph` (`ponline`,`hour`) VALUES ('%d','%s%d:00')", GetOnLinePlayers(), ((hour < 10) ? ("0") : ("")), hour);
	mysql_query(SQL, str);
	mysql_query(SQL, "DELETE FROM `toph` ORDER BY `id` ASC limit 1");
	format(str, sizeof(str), "SELECT * FROM `timeonline` WHERE m = %d AND y = %d",mo,ye);
	new Cache: result = mysql_query(SQL, str);
	if(cache_get_row_count() >= 1)
	{
		mysql_format(SQL,str,sizeof(str),"UPDATE timeonline SET hoursplayed = hoursplayed+%d WHERE m = %d AND y = %d",hourscount,mo,ye);
		mysql_tquery(SQL,str,"","");
	}
	cache_delete(result);
	SetTimer("hidePayDay", 10000, false);
	return 1;
}

     

  8. Problema /asellbiz si /asellhouse

    in Ajutor Scripting

    Posted

    Acum 6 ore, Banditul a spus: 
    
CMD:asellbiz(playerid, params[])
{
    if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first.");
    if(IsPlayerConnected(playerid))
    {
        new house;
        if(sscanf(params, "d", house)) return SendClientMessage(playerid, 0xFFFFFFFF, "{FF9900}Scrie: {33CCFF}/asellbiz <Biz ID>");
        if (PlayerInfo[playerid][pAdmin] >= 5)
        {
            new ownerh[64],
                field[128],
                str2[256];
            format(field,128,"SELECT `Owner` FROM `bizz` WHERE `ID`='%d'",house);
            new Cache: result = mysql_query(SQL,field);

            if(cache_num_rows())
            {
                cache_get_field_content(0, "Owner", ownerh);

            }
            cache_delete(result)
            BizzInfo[house][bLocked] = 0;
            BizzInfo[house][bOwned] = 0;
            strmid(BizzInfo[house][bOwner], "The State", 0, strlen("The State"), 255);
            PlayerPlaySound(playerid, 1052, 0.0, 0.0, 0.0);
            GameTextForPlayer(playerid, "~w~You have sold this property", 10000, 3);
            mysql_format(SQL,str2,sizeof(str2),"UPDATE `bizz` SET `Locked`='0',`Owned`='0',`Owner`='The State' WHERE `ID`='%d'",house);
            mysql_tquery(SQL,str2,"","");
            mysql_format(SQL,str2,sizeof(str2),"UPDATE users SET `Bizz`='255' WHERE `name`='%s'",ownerh);
            mysql_tquery(SQL,str2,"","");
            OnPropTextdrawUpdate(2, house);
            return 1;
        }
        else return SendClientMessage(playerid, COLOR_WHITE, "{5CAD5C}Error: Your admin level isn't high enough to use this command.");
    }
    return 1;
}
CMD:asellhouse(playerid, params[])
{
    if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first.");
    if(IsPlayerConnected(playerid))
    {
        new house;
        if(sscanf(params, "d", house)) return SendClientMessage(playerid, 0xFFFFFFFF, "{FF9900}Scrie: {33CCFF}/asellhouse <House ID>");
        if (PlayerInfo[playerid][pAdmin] >= 5)
        {
            new ownerh[64],
                field[128],
                str2[256];
            format(field,128,"SELECT `Owner` FROM `houses` WHERE `ID`='%d'",house);
            new Cache: result = mysql_query(SQL,field);

            if(cache_num_rows())
            {
                cache_get_field_content(0, "Owner", ownerh);

            }
            cache_delete(result)
            HouseInfo[house][hHel] = 0;
            //HouseInfo[house][hArm] = 0;
            HouseInfo[house][hLock] = 0;
            HouseInfo[house][hOwned] = 0;
            strmid(HouseInfo[house][hOwner], "The State", 0, strlen("The State"), 255);
            PlayerPlaySound(playerid, 1052, 0.0, 0.0, 0.0);
            mysql_format(SQL,str2,sizeof(str2),"UPDATE `houses` SET `Hel`='0',`Arm`='0',`Lockk`='0',`Owned`='0',`Owner`='The State' WHERE `ID`='%d'",house);
            mysql_tquery(SQL,str2,"","");
            mysql_format(SQL,str2,sizeof(str2),"UPDATE users SET `House`='999' WHERE `name`='%s'",ownerh);
            mysql_tquery(SQL,str2,"","");
            OnPropTextdrawUpdate(1, house);
            return 1;
        }
        else
        {
            SendClientMessage(playerid, COLOR_WHITE, "{5CAD5C}Error: Your admin level isn't high enough to use this command.");
        }
    }
    return 1;
}

    Asta daca folosesti r39 

    Primesc asta acu

C:\Users\SpriteTV\Desktop\GameModeRPG\gamemodes\RP-RPG.pwn(38077) : error 001: expected token: ";", but found "-identifier-"
C:\Users\SpriteTV\Desktop\GameModeRPG\gamemodes\RP-RPG.pwn(38114) : error 001: expected token: ";", but found "-identifier-"
Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase


2 Errors.
[Finished in 20.4s]

Linile is astea
BizzInfo[house][bLocked] = 0;
HouseInfo[house][hHel] = 0;

     

  10. Bluffs V2

    in Gamemode-uri

    Posted

    Acum 2 ore, Ionut_WS a spus:

    Unde setezi banii la clan, în clans? 

    pai asta tu trebuie sa sti ca doar tu ai construit acest sistem ... nu noi

     eu m-am uitat peste tot nu i-am dat de rezolvare...

  11. Bluffs V2

    in Gamemode-uri

    Posted

    Acum 2 ore, CSORIN a spus:

    unele locatii din /gps nu sunt unde ar trebui, 

    cand iei obiectele de la quest acestea nu dispar si ramane si minimap-ul ala galben

    uneori nu iti arata detaliile despre vehicul cand intri in el

    clan tagul nu ramene salvat, masiniile de la clan si banii dar in baza de date sunt

    daca setezi bani din baza de date la clan in joc arata ca ai 0

    pe panel la statistici factiune e ceva in neregula  

    Raport de Activitate

    Raportul tau de activitate va fi procesat pe data de 01/01/1970 in jurul orei 00:00
    kills/deaths: 0/-5


     

    Rank up

    Vei primi rank (DOAR RESETARE RAPORT) pe data de 01/01/1970 in jurul orei 00:00 daca vei avea raportul complet
    la admin panel la factiuni cu lider nu le arata pe cele ce au lider si la cele fara lider arata toate factiunile
    daca esti helper si admin pe panel iti arata ca esti doar admin
    cand vrei sa faci o reclamatie iti zice ca acel player nu exista
    la leader panel nu se salveaza daca pui intrebarile si acolo scrie Aplicatiile se deschid/inchid direct din joc folosind comanda /togapps
    dar in gm nu exista acea comanda
    •  
    si mai sunt buguri dar nu-mi aduc aminte

    Eu in partial am rezolvat probleme doar ca si eu am problemele astea.

    clan tagul nu ramene salvat, masiniile de la clan si banii dar in baza de date sunt

    daca setezi bani din baza de date la clan in joc arata ca ai 0

    cand iei obiectele de la quest acestea nu dispar si ramane si minimap-ul ala galben

    dar nu vrea sa ofere ajutor.

    Restu le-am rezolvat eu dar astea nu am reusit sa le rezolv.... si la ajutor nici unu nu raspunde...

     

  12. Problema /asellbiz si /asellhouse

    in Ajutor Scripting

    Posted

    • Username :SpriteTV
    • Problema întâlnită:primesc niste erori de la mysql dar nu inteleg care ii treaba. 
    • Detalii despre problemă:mysql_store_result mysql_retrieve_row mysql_fetch_field_row
    • Ce ai încercat să faci înainte să postezi?: Nu am incercat ca nu cunosc bine problema ca nu le am cu mysql-ul chiar asa de bine.
    • Cod sursa (recomandat pastebin.com) :   erori. https://pastebin.com/vGiTq4rk comenzile.https://pastebin.com/vW8sN14k
    • Alte detalii : help plz.

  13. Ajutor clan seif problema

    in Ajutor Scripting

    Posted

    Acum 31 minute, Banditul a spus:

    Din ce am inteles cat timp serverul ruleaza totul este ok, daca dai restart banii clanului dispar dar raman in baza de date. La o singura chestie ma pot gandi sincer 

    
ClanInfo[i][cClanID]                      = cache_get_field_content_int(x, "clanID");

     Cand incarci asta din baza de date corespunde cu id-ul clanului tau? 

    Pentru ca la singura chestie la care ma pot gandi este faptul ca datele clanului tau(poate o parte din ele) au datele  altui clan pentru ca nu vad un alt motiv pentru care nu ti s-ar incarca banii din baza de date care se salveaza corect

    pai singura functie pe care o am este asta 

    public ClanUpdate(clanid, type)
{
	new var[356];
	switch(type)
	{
		case ClanSafex:
		{
			mysql_format(SQL, var, sizeof(var), "UPDATE `clans` SET `clanSeif`='%d' WHERE `clanID`='%d'",ClanInfo[clanid][cClanSeif], clanid);
			mysql_tquery(SQL,var,"","");
		}
	}
	return 1;
}

    Folosesc gm-ul bluffs v2 alui ionut. dar nu inteleg care ii treaba.

    Gen cat servar-ul ruleaza ok fara restar bani se incarc in in dialog si in baza de date.

    Dupa restart pe dialog nu mai apar bani. ma duc dau la un job ceva si bani care se iau din job se reseteaza in baza de date gen eu iau 300$ si in baza de date se pune 300$ dar ti-am spus dupa restart la fel face.

  14. problema mysql_log help

    in Ajutor Scripting

    Posted

    Chiar acum, Banditul a spus:

    Atunci inseamna ca spre exemplu  

    
ClanInfo[i][cClanID]                    = cache_get_field_content_int(x, "clanID");

    X in cazul acesta incearca sa aceseze un row care nu se afla in baza de date si nu are de unde extrage cache(nu se incarca nimic din baza de date referitor la acel row(x))

    rezolvat ms bro. erea de o functie facuta de mine aiurea poate imi poti oferi rezolvarea la clan seif ca acolo chiar nu am gasit rezolvarea pwp

  15. Ajutor clan seif problema

    in Ajutor Scripting

    Posted

    Bun sa zic ca in partial cred ca mi-am dat seama care ar fi problema.

    Daca nu dau restart la server raman bani apar tot-ul bine dar daca dau restart la server imi seteaza iara 0 cand dau sa vad bani dar in baza de date apar bani nu inteleg care ar fi problema... 

    Dar dupa ce ma duc la un job si primesc bani aia in baza de date se seteaza bani de iam primit acu.

    dar eu am functia asta creata dar degeba. 

    public ClanUpdate(clanid, type)
{
	new var[356];
	switch(type)
	{
		case ClanSafex:
		{
			mysql_format(SQL, var, sizeof(var), "UPDATE `clans` SET `clanSeif`='%d' WHERE `clanID`='%d'",ClanInfo[clanid][cClanSeif], clanid);
			mysql_tquery(SQL,var,"","");
		}
	}
	return 1;
}

     

     

  16. problema mysql_log help

    in Ajutor Scripting

    Posted

    Acum 46 minute, Banditul a spus:

    Ai cumva un mysql_tquery care cheama LoadClanInfo sau doar ai pusa functia la OnGamemodeInit fara sa fie chemat vreun query care sa selecteze datele din tabelu de clanuri? 

    Pentru ca asta sugereaza warningu. Sau mai poate inseamna ca acel row pe care vrei sa il incarci pe server nu exista in baza de date

    am doar mysql_tquery(SQL, "SELECT * FROM `clans`", "LoadClanInfo", ""); la LoadSystems

  18. problema mysql_log help

    in Ajutor Scripting

    Posted

  19. Ajutor clan seif problema

    in Ajutor Scripting

    Posted · Edited by SpriteTV

    Acum 17 ore, valivaly96 a spus:

    Deci sunt 2 variante: Cand depui/scoti bani din seif nu faci update sau nu e facut bine in baza de date

    SAU: Cand incarci tabelul din baza de date aferent clanurilor nu incarci si banii din seif(sau poate nu e scris corect row-ul)

    Bun sa zic ca in partial cred ca mi-am dat seama care ar fi problema.

    Daca nu dau restart la server raman bani apar tot-ul bine dar daca dau restart la server imi seteaza iara 0 cand dau sa vad bani dar in baza de date apar bani nu inteleg care ar fi problema... 

    Dar dupa ce ma duc la un job si primesc bani aia in baza de date se seteaza bani de iam primit acu.

    Acum 16 ore, ScriptarFals a spus:

    Arată-ne dialogul și punel sub formă de cod aici. 

    public LoadClanInfo()
{
    clanss = cache_num_rows();
    for(new i = 1; i <= clanss; i++)
    {
        new x = i - 1;
        ClanInfo[i][cClanID]                      = cache_get_field_content_int(x, "clanID");
        ClanInfo[i][cClanExpire]                  = cache_get_field_content_int(x, "clanExpire");
        ClanInfo[i][cClanActive]                  = cache_get_field_content_int(x, "clanActive");
        ClanInfo[i][cClanSlots]                  = cache_get_field_content_int(x, "clanSlots");
        ClanInfo[i][cClanSeif]                  = cache_get_field_content_int(x, "clanSeif");
        cache_get_field_content(x, "clanName", ClanInfo[i][cClanName], SQL, 130);
        cache_get_field_content(x, "clanColor", ClanInfo[i][cClanColor], SQL, 130);
        cache_get_field_content(x, "clanMOTD", ClanInfo[i][cClanMOTD], SQL, 130);
           cache_get_field_content(x, "clanTag", ClanInfo[i][cClanTag], SQL, 130);
        cache_get_field_content(x, "clanRankName7", ClanInfo[i][cClanRankName7], SQL, 130);
        cache_get_field_content(x, "clanRankName6", ClanInfo[i][cClanRankName6], SQL, 130);
        cache_get_field_content(x, "clanRankName5", ClanInfo[i][cClanRankName5], SQL, 130);
        cache_get_field_content(x, "clanRankName4", ClanInfo[i][cClanRankName4], SQL, 130);
        cache_get_field_content(x, "clanRankName3", ClanInfo[i][cClanRankName3], SQL, 130);
        cache_get_field_content(x, "clanRankName2", ClanInfo[i][cClanRankName2], SQL, 130);
        cache_get_field_content(x, "clanRankName1", ClanInfo[i][cClanRankName1], SQL, 130);
        LoadClanCar(i);
    }
    printf("[LOADING] %d clans loaded.", clanss);
}
                              
                              public ClanUpdate(clanid, type)
{
	new var[356];
	switch(type)
	{
		case ClanSafex:
		{
			mysql_format(SQL, var, sizeof(var), "UPDATE `clans` SET `clanSeif`='%d' WHERE `clanID`='%d'",ClanInfo[clanid][cClanSeif], clanid);
			mysql_tquery(SQL,var,"","");
		}
	}
	return 1;
}
                              
                              
                case pClanDepx:
				{
					mysql_format(SQL, var, sizeof(var), "UPDATE `users` SET `ClanDep`='%d' WHERE `name`='%s'",PlayerInfo[playerid][pClanDep], PlayerInfo[playerid][pNormalName]);
					mysql_tquery(SQL,var,"","");
				}

     

  21. Ajutor clan seif problema

    in Ajutor Scripting

    Posted

    Salut am si eu o problema cu clan seif .

    Problema sta in felu urmator.

    Bani din cate vad mi urca in baza de date. Dar cand dau sa vad in joc bani clanului imi zice ca sunt 0. Si nu vad nimic gresit aici. 

    case 4:
						{
							new strings[512],string2[256];
							format(strings,sizeof(strings),"{FFFFFF}For deposit money in clan safe is necessary to work at server's jobs.\n{FFFFFF}10 percent of the money you earn will be deposited in clan safe.\n");
							format(string2,sizeof(string2),"{FFFFFF}You don't loose money, the money added in clan safe are the server's money.\n{FFFFFF}Current balance: %s$.\n{FF0000}Nobody can take money from the safe box.",FormatNumber(ClanInfo[PlayerInfo[playerid][pClan]][cClanSeif]));
							strcat(strings, string2);
							ShowPlayerDialog(playerid, DIALOG_CLAN_SAFE, DIALOG_STYLE_MSGBOX, "Clan Safe Box",strings, "Ok", "Back");
						}

     

  22. Bluffs V2

    in Gamemode-uri

    Posted · Edited by SpriteTV

    La 06.08.2018 la 17:32, Ionut_WS a spus:

    Salut, eu sunt Ionut si in acest topic va voi oferii accesul oficial la noua versiune a gamemode-ului Bluffs, ca in topicul anterior vreau sa mentionez ca am inceput de la gamemode-ul postat de Droom pentru ca mi-a placut structurarea lui, insa de la versiunea lui pana la ultima s-au schimbat multe, ce sa mai, acum la ultima versiune e mai mult nou, mai mult edit. 

    Pentru inceput, o sa va zic doar o parte din lucruri pentru ca stiu ca va plictisiti usor:

    - raport/rank up automat la factiuni

    - sistemului de clan i-a fost acordat un update prin adaugarea seifului pentru clan si vehiculelor pentru clan (PS: daca vreti sa afisati cati bani a depus fiecare in clan, aveti variabila creata, doar cat o treceti la afisarea membrilor "pClanDep")

    - design-ul pe panel a fost modificat si modificate unele functii, adaugat pe la profil niste functii noi, vedeti voi

    - reparate destul de multe bug uri

    Desigur, au fost mai multe lucruri facute, insa sincer acum sunt entuiziasmat ca am terminat sistemul la clanuri si nu mi le mai amintesc pe toate, dar am facut destul de multe lucruri interesante de la ultimul update, daca veti deschide si veti vrea sa faceti o diferenta, este enorm de sesizabila. 

    Nu uitati sa dati un +1 daca va place si astfel voi stii daca sa mai editez pentru viitor, asta o fac oricum din placere, insa daca eu tot nu imi deschid server de samp pentru ca nu am timp de administrare, macar sa aiba cineva pe mana un asa gamemode.

    google drive download: https://drive.google.com/file/d/1m3Fv-u39u87IOuBzFCJgLVMPBbEB5zE0/view

    ZippyshareDownload: https://www32.zippyshare.com/v/1uskQ3tO/file.html

    girlshare download: http://www.girlshare.ro/3490160092.1

    Virustotal: https://www.virustotal.com/#/url/60f7783dadcaeb1f6b6d5a707f6d3be2703d3ff31f16ff5c9f5c53d99666b50a/detection (acum e link bun la virustotal)

    Poze: Nu am mai facut, insa daca ati mai luat gm-uri de la mine, stiti cum sta treaba.

    Sper sa va placa, succes cu el daca aveti planuri mari ;)!

    Salut ionut foarte frumos edit.

    Dar am si eu o problema si nu stiu sa o rezolv daca ma`i putea ajuta ti-s ramane dator toata viata.

    1 CLAN-TAG-UL BANI DIN SAFEBOX SI MASINILE NU RAMAN SALVATE DUPA IESIREA DUPA SERVER

    mysql_log 

    Logging started at 05:34, 16.08.2018
In callback "LoadDynamicFactions"
Time	Function	Status	Message
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin0")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin1")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin2")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin3")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin4")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin5")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin6")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin7")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin8")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype
05:34:54	CMySQLResult::GetRowDataByName	WARNING	field not found ("Skin9")
05:34:54	cache_get_field_content_int	ERROR	invalid datatype

     

    Load LoadDynamicFactions 

    public LoadDynamicFactions()
{
	factionss = cache_num_rows();
	new string[310];
    for(new i = 1; i <= factionss; i++)
    {
		new f = i - 1;
		DynamicFactions[i][fID]                 = cache_get_field_content_int(f, "ID");
        cache_get_field_content(f, "Name", DynamicFactions[i][fName], SQL, 130);
		DynamicFactions[i][fcX]                 = cache_get_field_content_float(f, "X");
   	    DynamicFactions[i][fcY]                 = cache_get_field_content_float(f, "Y");
    	DynamicFactions[i][fcZ]                 = cache_get_field_content_float(f, "Z");
    	DynamicFactions[i][fceX]                = cache_get_field_content_float(f, "eX");
   	    DynamicFactions[i][fceY]                = cache_get_field_content_float(f, "eY");
    	DynamicFactions[i][fceZ]                = cache_get_field_content_float(f, "eZ");
    	DynamicFactions[i][fSafePos][0]			= cache_get_field_content_float(f, "SafePos1");
    	DynamicFactions[i][fSafePos][1]			= cache_get_field_content_float(f, "SafePos2");
    	DynamicFactions[i][fSafePos][2]			= cache_get_field_content_float(f, "SafePos3");
    	DynamicFactions[i][fMats]               = cache_get_field_content_int(f, "Mats");
    	DynamicFactions[i][fInterior]           = cache_get_field_content_int(f, "Interior");
    	DynamicFactions[i][fVirtual]            = cache_get_field_content_int(f, "Virtual");
    	DynamicFactions[i][fMapIcon]            = cache_get_field_content_int(f, "MapIcon");
    	DynamicFactions[i][fLocked]            	= cache_get_field_content_int(f, "Locked");
    	DynamicFactions[i][fDrugs]              = cache_get_field_content_int(f, "Drugs");
    	DynamicFactions[i][fBank]               = cache_get_field_content_int(f, "Bank");
    	DynamicFactions[i][fPickupIDD]          = cache_get_field_content_int(f, "PickupID");
        cache_get_field_content(f, "Anunt", DynamicFactions[i][fAnn], SQL, 130);
    	DynamicFactions[i][fWin]                = cache_get_field_content_int(f, "Win");
    	DynamicFactions[i][fLost]               = cache_get_field_content_int(f, "Lost");
    	DynamicFactions[i][fMaxMembers]         = cache_get_field_content_int(f, "MaxMembers");
		DynamicFactions[i][fMinLevel]         	= cache_get_field_content_int(f, "MinLevel");
    	DynamicFactions[i][fApplication]        = cache_get_field_content_int(f, "Application");
		cache_get_field_content(f, "Rank1", DynamicFactions[i][fRankName1], SQL, 130);
		cache_get_field_content(f, "Rank2", DynamicFactions[i][fRankName2], SQL, 130);
		cache_get_field_content(f, "Rank3", DynamicFactions[i][fRankName3], SQL, 130);
		cache_get_field_content(f, "Rank4", DynamicFactions[i][fRankName4], SQL, 130);
		cache_get_field_content(f, "Rank5", DynamicFactions[i][fRankName5], SQL, 130);
		cache_get_field_content(f, "Rank6", DynamicFactions[i][fRankName6], SQL, 130);
		cache_get_field_content(f, "Rank7", DynamicFactions[i][fRankName7], SQL, 130);
		for(new c; c < 10; c++)
		{
			new s[10];
			format(s, sizeof(s),"Skin%d",c);
			FactionSkin[i][c] = cache_get_field_content_int(f, s);
		}
		switch(DynamicFactions[i][fLocked]) {
	    	case 0: format(string, sizeof(string), "%s's HQ", DynamicFactions[i][fName]);
	    	case 1: format(string, sizeof(string), "%s's HQ\n\n(locked)", DynamicFactions[i][fName]);
	    }
	   	DynamicFactions[i][fPickupID] = CreateDynamicPickup(DynamicFactions[i][fPickupIDD], 23, DynamicFactions[i][fceX], DynamicFactions[i][fceY], DynamicFactions[i][fceZ], 0, -1, -1, 10);
		DynamicFactions[i][fLabelID] = CreateDynamic3DTextLabel(string, COLOR_COOLBLUE, DynamicFactions[i][fceX], DynamicFactions[i][fceY], DynamicFactions[i][fceZ], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 25.0);
		if(DynamicFactions[i][fMapIcon] != 0) CreateDynamicMapIcon(DynamicFactions[i][fceX],DynamicFactions[i][fceY],DynamicFactions[i][fceZ],DynamicFactions[i][fMapIcon],0,-1,-1,-1,750.0); //Bank
		format(string, sizeof(string), "%s\nGroup Safe", DynamicFactions[i][fName]);
		DynamicFactions[i][fSafePickupID] = CreateDynamicPickup(1274, 23, DynamicFactions[i][fSafePos][0], DynamicFactions[i][fSafePos][1], DynamicFactions[i][fSafePos][2], DynamicFactions[i][fVirtual], DynamicFactions[i][fInterior], -1, 50);
		DynamicFactions[i][fSafeLabelID] = CreateDynamic3DTextLabel(string, COLOR_YELLOW, DynamicFactions[i][fSafePos][0], DynamicFactions[i][fSafePos][1], DynamicFactions[i][fSafePos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, DynamicFactions[i][fVirtual], DynamicFactions[i][fInterior], -1, 20.0);
	}
	printf("[LOADING] %d groups loaded.", factionss);
	return 1;
}

     

  23. Problema /createbiz

    in Ajutor Scripting

    Posted

    Iar cand uplodez baza de la comanda cu bizurile din baza original primesc urmatoarea eroare  la incarcare 

    SQL query:


--
-- Dumping data for table `bizz`
--

INSERT INTO `bizz` (`ID`, `Owned`, `Owner`, `Message`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Sbiz`, `Type`, `Locked`, `Interior`, `Virtual`, `Prices`) VALUES
(1, 1, 'LegendSK', 'Banca LS', 1462.49, -1012.63, 26.8438, 2306, -16, 27, 15, 40000000, 500, 3702000, 0, 1, 0, 0, 0),
(2, 1, 'MIRCESCU', 'Gun Shop LS', 1367.99, -1279.75, 13.5469, 316, -142, 1000, 15, 40000000, 2500, 127500, 0, 2, 0, 7, 0),
(3, 0, 'The State', 'Alhambra', 1836.09, -1682.5, 13.3624, 493.46, -24.0736, 1000.68, 15, 60000000, 500, 0, 0, 3, 0, 17, 0),
(4, 0, 'The State', 'Cluckin Bell', 2102.38, 2228.72, 11.0234, 364.942, -11.0787, 1001.85, 15, 40000000, 500, 1000, 0, 14, 0, 9, 0),
(5, 0, 'The State', 'Bar ', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 15, 40000000, 500, 0, 0, 3, 0, 2, 0),
(6, 0, 'The State', 'CLUB ', 2309.85, -1643.54, 14.827, -794.942, 490.782, 1376.2, 15, 50000000, 500, [...]
MySQL said: Documentation

#1136 - Column count doesn't match value count at row 1

     

  24. Problema /createbiz

    in Ajutor Scripting

    Posted

    Revin cu problema legata de /createbiz @Banditul problema este in felu urmator pub baza de date biz originala a sv nu mai merge comanda pun baza lui de date originala merge comanda.

    Baza de date + Originala a sv  

    --
-- Table structure for table `bizz`
--

CREATE TABLE `bizz` (
  `ID` int(11) NOT NULL,
  `Owned` int(2) NOT NULL,
  `Owner` varchar(25) NOT NULL DEFAULT 'The State',
  `Message` varchar(50) NOT NULL,
  `EntranceX` float NOT NULL,
  `EntranceY` float NOT NULL,
  `EntranceZ` float NOT NULL,
  `ExitX` float NOT NULL,
  `ExitY` float NOT NULL,
  `ExitZ` float NOT NULL,
  `LevelNeeded` int(11) NOT NULL DEFAULT '15',
  `BuyPrice` int(11) NOT NULL DEFAULT '40000000',
  `EntranceCost` int(11) NOT NULL DEFAULT '5',
  `Till` int(11) NOT NULL,
  `Sbiz` int(2) NOT NULL,
  `Type` int(3) NOT NULL,
  `Locked` int(11) NOT NULL,
  `Interior` int(11) NOT NULL,
  `Virtual` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bizz`
--

INSERT INTO `bizz` (`ID`, `Owned`, `Owner`, `Message`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Sbiz`, `Type`, `Locked`, `Interior`, `Virtual`) VALUES
(1, 1, 'LegendSK', 'Banca LS', 1462.49, -1012.63, 26.8438, 2306, -16, 27, 15, 40000000, 500, 3702000, 0, 1, 0, 0, 0),
(2, 1, 'MIRCESCU', 'Gun Shop LS', 1367.99, -1279.75, 13.5469, 316, -142, 1000, 15, 40000000, 2500, 127500, 0, 2, 0, 7, 0),
(3, 0, 'The State', 'Alhambra', 1836.09, -1682.5, 13.3624, 493.46, -24.0736, 1000.68, 15, 60000000, 500, 0, 0, 3, 0, 17, 0),
(4, 0, 'The State', 'Cluckin Bell', 2102.38, 2228.72, 11.0234, 364.942, -11.0787, 1001.85, 15, 40000000, 500, 1000, 0, 14, 0, 9, 0),
(5, 0, 'The State', 'Bar ', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 15, 40000000, 500, 0, 0, 3, 0, 2, 0),
(6, 0, 'The State', 'CLUB ', 2309.85, -1643.54, 14.827, -794.942, 490.782, 1376.2, 15, 50000000, 500, 0, 0, 3, 0, 1, 0),
(7, 0, 'The State', 'Sex Shop', 1087.63, -923.003, 43.3906, -100.403, -24.3921, 1000.72, 15, 40000000, 500, 500, 0, 4, 0, 3, 0),
(8, 1, 'BoyManN_', 'Casino LV', 2019.6, 1007.68, 10.8203, 2015.45, 1017.09, 996.875, 15, 40000000, 500, 1000, 0, 5, 0, 10, 1),
(9, 0, 'The State', 'GunShop LS', 1791.71, -1163.6, 23.8281, 316, -142, 1000, 15, 40000000, 500, 9400, 0, 2, 0, 7, 1),
(10, 0, 'The State', '24/7', 1352.16, -1759.17, 13.5078, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 9550, 0, 6, 0, 18, 0),
(11, 0, 'The State', '24/7', 999.932, -919.889, 42.3281, -31.0246, -91.3283, 1003.55, 15, 57000000, 500, 500, 0, 6, 0, 18, 1),
(12, 0, 'The State', '24/7', 1833.14, -1842.5, 13.5781, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 53450, 0, 6, 0, 18, 2),
(13, 0, 'The State', '24/7', 1929.37, -1776.14, 13.5469, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 0, 0, 6, 0, 18, 3),
(14, 0, 'The State', '24/7', 1315.7, -898.097, 39.5781, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 8650, 0, 6, 0, 18, 4),
(15, 0, 'The State', 'Burger Shot', 1199.38, -919.098, 43.1152, 363.134, -74.8469, 1001.51, 15, 45000000, 500, 800, 0, 7, 0, 10, 0),
(16, 0, 'The State', 'Burger Shot', 810.737, -1616.19, 13.5469, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 500, 0, 7, 0, 10, 1),
(17, 0, 'The State', 'Burger Shot', 2472.79, 2034.26, 11.0625, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 2),
(18, 0, 'The State', 'Burger Shot', 1158.14, 2072.27, 11.0625, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 3),
(19, 0, 'The State', 'Burger Shot', 2170.06, 2795.64, 10.8203, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 4),
(20, 0, 'The State', 'Burger Shot', 1872.71, 2071.67, 11.0625, 363.134, -74.8469, 1001.51, 15, 40000000, 500, 0, 0, 7, 0, 10, 5),
(21, 0, 'The State', 'Banca LV', 2194.99, 1676.89, 12.3672, 2306, -16, 27, 15, 40000000, 500, 0, 0, 1, 0, 0, 1),
(22, 0, 'The State', 'GunShop LV', 2556.62, 2063.98, 11.0995, 316, -142, 1000, 15, 40000000, 500, 0, 0, 2, 0, 7, 2),
(23, 0, 'The State', 'Sex Shop LV', 2515.95, 2297.69, 10.8203, -100.403, -24.3921, 1000.72, 15, 40000000, 500, 0, 0, 4, 0, 3, 1),
(24, 0, 'The State', '24/7', 2637.61, 1129.28, 11.1797, -31.0246, -91.3283, 1003.55, 15, 40000000, 500, 500, 0, 6, 0, 18, 5),
(25, 0, 'The State', 'Gym LS', 2229.22, -1721.89, 13.5671, 772.112, -3.89865, 1000.73, 15, 40600000, 500, 0, 0, 8, 0, 5, 0),
(26, 0, 'The State', 'Pizza', 2104.57, -1806.67, 13.5547, 372.54, -133.009, 1001.49, 15, 45000000, 500, 0, 0, 9, 0, 5, 6),
(27, 0, 'The State', 'Banca LS', 1102.91, -1440.13, 15.7969, 2306, -16, 27, 15, 55000000, 500, 1000, 0, 1, 0, 0, 2),
(28, 0, 'The State', 'Tasteaza [/ad] LvL 5', 1168.43, -1489.36, 22.757, 0, 0, 0, 15, 40000000, 500, 0, 1, 15, 1, 0, 0),
(29, 0, 'The State', 'Binco', 2102.56, 2257.37, 11.0234, 207.738, -109.02, 1005.13, 15, 45000000, 500, 2500, 0, 11, 0, 15, 2),
(30, 0, 'The State', 'Zip', 499.936, -1359.74, 16.2911, 161.391, -93.1592, 1001.8, 15, 40000000, 500, 120000, 0, 11, 0, 18, 0),
(31, 0, 'The State', 'Rent Car', 563.145, -1289.79, 17.2482, 0, 0, 0, 15, 40000000, 500, 1400, 1, 10, 1, 0, 0),
(32, 0, 'The State', 'Zip', 1456.98, -1138.04, 23.9778, 161.391, -93.1592, 1001.8, 15, 40000000, 500, 1000, 0, 11, 0, 18, 1),
(33, 0, 'The State', 'Gas Station', 1941.6, -1764.74, 13.6406, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0),
(34, 0, 'The State', 'PNS', 723.409, -463.627, 16.3359, 0, 0, 0, 15, 57000000, 500, 0, 1, 13, 1, 0, 0),
(35, 0, 'The State', 'PNS', 2072.57, -1828.03, 13.5469, 0, 0, 0, 15, 50000000, 500, 1500, 1, 13, 1, 0, 0),
(36, 1, 'Fiv3$eveN.)', 'PNS', 1034.7, -1028.1, 32.1016, 0, 0, 0, 15, 40000000, 500, 9000, 1, 13, 1, 0, 0),
(37, 1, 'SpriteTv', 'PNS', 485.37, -1733.32, 11.094, 0, 0, 0, 15, 40000000, 500, 6500, 1, 13, 1, 0, 0),
(38, 0, 'The State', 'Mod Shop', 1037.11, -1025.04, 32.1016, 0, 0, 0, 15, 68000000, 500, 3500, 1, 16, 1, 0, 0),
(39, 0, 'The State', 'Mod Shop', 2650.33, -2021.76, 14.1766, 0, 0, 0, 15, 40000000, 500, 0, 1, 16, 1, 0, 0),
(40, 0, 'The State', 'PNS', 1966.45, 2156.36, 10.8203, 0, 0, 0, 15, 40000000, 500, 1000, 1, 13, 1, 0, 0),
(41, 0, 'The State', 'PNS', -94.1097, 1109.86, 19.7422, 0, 0, 0, 15, 40000000, 500, 0, 1, 13, 1, 0, 0),
(42, 0, 'The State', 'Gas Station', 1012.9, -935.545, 42.1797, 0, 0, 0, 15, 40000000, 500, 2300, 1, 12, 1, 0, 0),
(43, 0, 'The State', 'Gas Station', 701.554, -567.347, 16.1459, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0),
(44, 0, 'The State', 'Gas Station', -78.6301, -1169.16, 2.1491, 0, 0, 0, 15, 60000000, 500, 0, 1, 12, 1, 0, 0),
(45, 0, 'The State', 'Gas Station', 2646.33, 1101.31, 10.9609, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0),
(46, 0, 'The State', 'Gas Station', 2139.81, 2753.5, 10.8203, 0, 0, 0, 15, 60000000, 500, 0, 1, 12, 1, 0, 0),
(47, 0, 'The State', 'Gas Station', 2207.51, 2482.56, 10.8203, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0),
(48, 0, 'The State', 'Gas Station', 1604.09, 2204.47, 10.8203, 0, 0, 0, 15, 50000000, 500, 0, 1, 12, 1, 0, 0),
(49, 0, 'The State', 'Gas Station', 2122.56, 914.539, 10.8203, 0, 0, 0, 15, 40000000, 500, 1140, 1, 12, 1, 0, 0),
(50, 0, 'The State', 'Gas Station', 638.368, 1683.78, 7.1875, 0, 0, 0, 15, 40000000, 500, 0, 1, 12, 1, 0, 0),
(51, 0, 'The State', 'Mod Shop', 2392.17, 1042.01, 10.8203, 0, 0, 0, 15, 350000000, 500, 0, 1, 16, 1, 0, 0),
(52, 0, 'The State', 'CNN LV', 2079.2, 2045.07, 11.0579, 0, 0, 0, 15, 40000000, 500, 0, 1, 15, 0, 0, 0),
(53, 0, 'The State', 'Binco', 2244.38, -1665.16, 15.4766, 207.738, -109.02, 1005.13, 15, 40000000, 500, 11500, 0, 11, 0, 15, 1),
(54, 0, 'The State', 'Cluckin Bell', 172.527, 1176.09, 14.7645, 364.942, -11.0787, 1001.85, 15, 40000000, 500, 0, 0, 14, 0, 9, 1);

-- --------------------------------------------------------

     

    Baza de date a comenzi din gm-ul nephrite. 

    -- phpMyAdmin SQL Dump
-- version 4.8.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 15, 2018 at 01:05 AM
-- Server version: 10.1.34-MariaDB
-- PHP Version: 7.2.7

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `bazadedate`
--

-- --------------------------------------------------------

--
-- Table structure for table `bizz`
--

CREATE TABLE `bizz` (
  `ID` int(11) NOT NULL,
  `Owned` int(2) NOT NULL,
  `Owner` varchar(25) NOT NULL DEFAULT 'The State',
  `Message` varchar(50) NOT NULL,
  `EntranceX` float NOT NULL,
  `EntranceY` float NOT NULL,
  `EntranceZ` float NOT NULL,
  `ExitX` float NOT NULL,
  `ExitY` float NOT NULL,
  `ExitZ` float NOT NULL,
  `LevelNeeded` int(11) NOT NULL DEFAULT '15',
  `BuyPrice` int(11) NOT NULL DEFAULT '20000000',
  `EntranceCost` int(11) NOT NULL DEFAULT '5',
  `Till` int(11) NOT NULL,
  `Sbiz` int(2) NOT NULL,
  `Type` int(3) NOT NULL,
  `Locked` int(11) NOT NULL,
  `Interior` int(11) NOT NULL,
  `Virtual` int(11) NOT NULL,
  `Prices` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bizz`
--
ALTER TABLE `bizz`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bizz`
--
ALTER TABLE `bizz`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

     

    Comanda  

    CMD:createbiz(playerid, params[]) {
	if(PlayerInfo[playerid][pAdmin] < 6) return 1;
	new type, value, level, idd = bussines+1, Float: Pos[3], query[256];
	if(sscanf(params, "iii", type, value, level)) {
		SCM(playerid, COLOR_GREY, "Syntax: {FFFFFF}/createbiz <type> <value> <level>");
		SCM(playerid, COLOR_GREY, "(1) Banca, (2) Gun Shop, (3) Club, (4) Sex Shop, (5) Casino, (6) 24/7, (7) Burger Shot, (8) Gym");
		SCM(playerid, COLOR_GREY, "(9) Pizza, (11) Binco, (12) Gas Station, (13) PNS*, (14) Cluckin Bell, (15) CNN, (16) Tuning*");
		return 1;
	}
	if(type == 10 || type < 1) return SCM(playerid, COLOR_GREY, "Invalid type!");
	GetPlayerPos(playerid, Pos[0], Pos[1], Pos[2]);
	switch(type) {
		case 1: {
			format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '2306', '-16', '27', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
			BizzInfo[idd][bExitX] = 2306; BizzInfo[idd][bExitY] = -16; BizzInfo[idd][bExitZ] = 27;
		}
		case 2: {
			format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '316', '-142', '1000', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
			BizzInfo[idd][bExitX] = 316; BizzInfo[idd][bExitY] = -142; BizzInfo[idd][bExitZ] = 1000;
		}
		case 3: {
			format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '-794.942', '490.782', '1376.2', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
			BizzInfo[idd][bExitX] = -794.942; BizzInfo[idd][bExitY] = 490.782; BizzInfo[idd][bExitZ] = 1376.2;
		}
		case 4: {
			format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '-100.403', '-24.3921', '1000.72', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
			BizzInfo[idd][bExitX] = -100.403; BizzInfo[idd][bExitY] = -24.3921; BizzInfo[idd][bExitZ] = 1000.72;
		}
		case 5: {
			format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '2015.45', '1017.09', '996.875', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
			BizzInfo[idd][bExitX] = 2015.45; BizzInfo[idd][bExitY] = 1017.09; BizzInfo[idd][bExitZ] = 996.875;
		}
		case 6: {
			format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '-31.0246', '-91.3283', '1003.55', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
			BizzInfo[idd][bExitX] = -31.0246; BizzInfo[idd][bExitY] = -91.3283; BizzInfo[idd][bExitZ] = 1003.55;
		}
		case 7: {
			format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '363.134', '-74.8469', '1001.51', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
			BizzInfo[idd][bExitX] = 363.134; BizzInfo[idd][bExitY] = -74.8469; BizzInfo[idd][bExitZ] = 1001.51;
		}
		case 8: {
			format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '772.112', '-3.89865', '1000.73', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
			BizzInfo[idd][bExitX] = 772.112; BizzInfo[idd][bExitY] = -3.89865; BizzInfo[idd][bExitZ] = 1000.73;
		}
		case 9: {
			format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '372.54', '-133.009', '1001.49', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
			BizzInfo[idd][bExitX] = 372.54; BizzInfo[idd][bExitY] = -133.009; BizzInfo[idd][bExitZ] = 1001.49;
		}
		case 11: {
			format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '207.738', '-109.02', '1005.13', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
			BizzInfo[idd][bExitX] = 207.738; BizzInfo[idd][bExitY] = -109.02; BizzInfo[idd][bExitZ] = 1005.13;
		}
		case 12: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
		//case 13: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
		case 14: {
			format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Interior`) VALUES ('%f', '%f', '%f', '364.942', '-11.0787', '1001.85', '%d', '%d', '%d', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
			BizzInfo[idd][bExitX] = 364.942; BizzInfo[idd][bExitY] = -11.0787; BizzInfo[idd][bExitZ] = 1001.85;
		}
		case 15: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
		case 16: format(query, sizeof(query), "INSERT INTO `bizz` (`EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `Type`, `Sbiz`) VALUES ('%f', '%f', '%f', '0', '0', '0', '%d', '%d', '%d', '1', '%d')", Pos[0], Pos[1], Pos[2], level, value, type, BizInteriorID(type));
	}
	mysql_tquery(SQL, query, "", "");
	format(query, sizeof(query), "UPDATE `bizz` SET `Virtual`='%d' WHERE `ID`='%d'", idd, idd);
	mysql_tquery(SQL, query, "", "");

	BizzInfo[idd][bEntranceX] = Pos[0];
	BizzInfo[idd][bEntranceY] = Pos[1];
	BizzInfo[idd][bEntranceZ] = Pos[2];
	BizzInfo[idd][bBuyPrice] = value;
	BizzInfo[idd][bLevelNeeded] = level;
	BizzInfo[idd][bVirtual] = idd;
	BizzInfo[idd][bType] = type;
	BizzInfo[idd][bInterior] = BizInteriorID(type);
	if(type >= 12 && type != 14) BizzInfo[idd][bSbiz] = 1;

	new PropertyString[256];
	DestroyDynamic3DTextLabel(BizzLabel[idd]);
	format(PropertyString, sizeof(PropertyString),"{023d00}%s \n{EEEEEE}Business {023d00}#%d \n{0068CF}This Business is for sale(/buybusiness) ! \n {EEEEEE}Price: {023d00}%s \n{EEEEEE}Level: {023d00}%d %s",BizzInfo[idd][bMessage],idd,FormatNumber(BizzInfo[idd][bBuyPrice]),BizzInfo[idd][bLevelNeeded]);
	BizzLabel[idd] = CreateDynamic3DTextLabel(PropertyString ,0x0066FFCC,BizzInfo[idd][bEntranceX], BizzInfo[idd][bEntranceY], BizzInfo[idd][bEntranceZ],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0);
	CreateDynamicPickup(1239, 1, BizzInfo[idd][bEntranceX], BizzInfo[idd][bEntranceY], BizzInfo[idd][bEntranceZ]);
	pickups++;
	bussines++;

	if(BizzInfo[idd][bType] == 1) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],52,0,-1,-1,-1,750.0); //Bank
	if(BizzInfo[idd][bType] == 2) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],18,0,-1,-1,-1,750.0); //GunShop
	if(BizzInfo[idd][bType] == 3) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],49,0,-1,-1,-1,750.0); //Bars
	if(BizzInfo[idd][bType] == 4) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],38,0,-1,-1,-1,750.0); //Sex Shop
	if(BizzInfo[idd][bType] == 5) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],25,0,-1,-1,-1,750.0); //Casino
	if(BizzInfo[idd][bType] == 6) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],17,0,-1,-1,-1,750.0); //24/7
	if(BizzInfo[idd][bType] == 7) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],10,0,-1,-1,-1,750.0); //Burger Shot
	if(BizzInfo[idd][bType] == 8) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],54,0,-1,-1,-1,750.0); //Gym
	if(BizzInfo[idd][bType] == 9) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],29,0,-1,-1,-1,750.0); //Pizza
	if(BizzInfo[idd][bType] == 10) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],51,0,-1,-1,-1,750.0); //Rent Car
	if(BizzInfo[idd][bType] == 11) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],45,0,-1,-1,-1,750.0); //Clothes
	if(BizzInfo[idd][bType] == 12) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],27,0,-1,-1,-1,750.0); //Gas Station
	if(BizzInfo[idd][bType] == 13) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],63,0,-1,-1,-1,750.0); //PNS
	if(BizzInfo[idd][bType] == 14) CreateDynamicMapIcon(BizzInfo[idd][bEntranceX],BizzInfo[idd][bEntranceY],BizzInfo[idd][bEntranceZ],14,0,-1,-1,-1,750.0); //Cluckin Bell

	new string[128];
	format(string, sizeof(string), "[@@ %d @@]%f, %f, %f, [$%s, %d lvl, %d int, %d type]", idd, Pos[0], Pos[1], Pos[2], FormatNumber(value), level, BizInteriorID(type), type);
	SCM(playerid, COLOR_YELLOW, string);
	return 1;
}

function BizInteriorID(type) {
	new x;
	switch(type) {
		case 1: x = 0;
		case 2: x = 7;
		case 3: x = 1;
		case 4: x = 3;
		case 5: x = 10;
		case 6: x = 18;
		case 7: x = 10;
		case 8: x = 5;
		case 9: x = 5;
		case 11: x = 15;
		case 12..13: x = 0;
		case 15..16: x = 0;
		case 14: x = 9;
	}
	return x;
}

     

    Aveti si pentru mine o rezolvare va rog

×
×
  • 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.