Run time error 4: "Array index out of bounds"
#1

Код HTML:
[16:31:47] [debug] Run time error 4: "Array index out of bounds"
[16:31:47] [debug]   Accessing element at index 8 past array upper bound 7
[16:31:47] [debug] Backtrace:
[16:31:47] [debug] #0  000f6d2c in public OnQueryFinish () from vx-rp.amx
[16:31:47] [debug] Run time error 4: "Array index out of bounds"
[16:31:47] [debug]   Accessing element at index 6 past array upper bound 5
[16:31:47] [debug] Backtrace:
[16:31:47] [debug] #0  000f5458 in public OnQueryFinish () from vx-rp.amx
Hi friends,
I've got a problem with my server 'cause, when I started it, in my chatlogs appeare these problems and after a few minutes, it crash.
I looked for something in sa-mp.com and I found it this topic https://sampforum.blast.hk/showthread.php?tid=321919 but nothing was been fix'd for me.

Here you are my OnQueryFinish callback:
Код HTML:
public OnQueryFinish(query[], resultid, extraid, connectionHandle) {
	switch(resultid) {
	    case THREAD_TIMESTAMP_CONNECT: {
			mysql_store_result();

			if(mysql_num_rows() == 0)
			    return SendClientMessage(extraid, COLOR_GENANNOUNCE, ""EMBED_WHITE"Benvenuto nel server!");

            GetPlayerName(extraid, GetPlayerNameEx(extraid), MAX_PLAYER_NAME);

			mysql_fetch_row_format(result);
			format(szMessage, sizeof(szMessage), ""EMBED_WHITE"Bentornato %s, la tua ultima connessione и stata %s.", GetPlayerNameEx(extraid), result);
			SendClientMessage(extraid, COLOR_DARKGREY, szMessage);

  			if(playerVariables[extraid][pGroup] >= 1) {
			    format(szMessage, sizeof(szMessage), ""EMBED_WHITE"%s и entrato nel server.", GetPlayerNameEx(extraid));
			    SendToGroup(playerVariables[extraid][pGroup], COLOR_LEMON, szMessage);

		        format(szMessage, sizeof(szMessage), "Bacheca di fazione: "EMBED_WHITE"%s", groupVariables[playerVariables[extraid][pGroup]][gGroupMOTD]);
		        SendClientMessage(extraid, COLOR_GENANNOUNCE, szMessage);
         	}

         	mysql_free_result();
		}
		case THREAD_LAST_CONNECTIONS: {
			mysql_store_result();

			if(mysql_num_rows() < 1)
			    return SendClientMessage(extraid, COLOR_GREY, "Non sei stato connesso abbastanza.");

    		format(szPointlesslyLarge, sizeof(szPointlesslyLarge), "Ultima ~5 tua connessione:\n");
			while(mysql_fetch_row_format(result)) {
			    for(new i = 0; i < strlen(result); i++) if(result[i] == '|') result[i] = ' ';
			    format(szPointlesslyLarge, sizeof(szPointlesslyLarge), "%s\n%s", szPointlesslyLarge, result);
			}

			ShowPlayerDialog(extraid, 0, DIALOG_STYLE_MSGBOX, "{FF0000}SERVER:{FFFFFF} Connection log", szPointlesslyLarge, "OK", "");

			mysql_free_result();
		}
	    case THREAD_CHECK_PLAYER_NAMES: {
	        mysql_store_result();

	        if(mysql_num_rows() == 0)
	            return SendClientMessage(extraid, COLOR_GREY, "Non risultano changename per questo player.");

			new
			    iNCID,
			    szOldName[MAX_PLAYER_NAME],
			    szTime[20],
			    szNewName[MAX_PLAYER_NAME];

			format(szPointlesslyLarge, sizeof(szPointlesslyLarge), "Changename:\n");
            while(mysql_fetch_row_format(result)) {
                sscanf(result, "p<|>ds[24]s[24]s[20]", iNCID, szOldName, szNewName, szTime);
                format(szPointlesslyLarge, sizeof(szPointlesslyLarge), "%s\n- (%d) Name: %s (changed from %s, %s)", szPointlesslyLarge, iNCID, szNewName, szOldName, szTime);
            }

            ShowPlayerDialog(extraid, 0, DIALOG_STYLE_MSGBOX, "{FF0000}SERVER:{FFFFFF} Changename", szPointlesslyLarge, "OK", "");

			mysql_free_result();
	    }
	    case THREAD_LOAD_ATMS: {
			mysql_store_result();

			new
			    x;

			while(mysql_retrieve_row()) {
			    mysql_get_field("atmId", result);
			    x = strval(result);

				mysql_get_field("atmPosX", result);
				atmVariables[x][fATMPos][0] = floatstr(result);

				mysql_get_field("atmPosY", result);
				atmVariables[x][fATMPos][1] = floatstr(result);

				mysql_get_field("atmPosZ", result);
				atmVariables[x][fATMPos][2] = floatstr(result) - 0.7;

				mysql_get_field("atmPosRotX", result);
				atmVariables[x][fATMPosRot][0] = floatstr(result);

				mysql_get_field("atmPosRotY", result);
				atmVariables[x][fATMPosRot][1] = floatstr(result);

				mysql_get_field("atmPosRotZ", result);
				atmVariables[x][fATMPosRot][2] = floatstr(result);

				atmVariables[x][rObjectId] = CreateDynamicObject(2942, atmVariables[x][fATMPos][0], atmVariables[x][fATMPos][1], atmVariables[x][fATMPos][2], atmVariables[x][fATMPosRot][0], atmVariables[x][fATMPosRot][1], atmVariables[x][fATMPosRot][2], -1, -1, -1, 500.0);
				//CreateDynamicObject(2618, x, y, z, rx, ry, rz, -1, -1, -1, 500.0);
			}

			mysql_free_result();
		}
	    case THREAD_CHANGE_SPAWN: {
			SendClientMessage(extraid, COLOR_WHITE, "Hai cambiato con successo lo spawn dei nuovi players & skin.");
			GetPlayerName(extraid, szPlayerName, MAX_PLAYER_NAME);
			format(szMessage, sizeof(szMessage), "[ADMIN]: %s ha appena cambiato lo spawn dei nuovi players & skin.", szPlayerName);
			submitToAdmins(szMessage, COLOR_HOTORANGE);
		}
     	case THREAD_CHECK_ACCOUNT_USERNAME: {
	    	mysql_store_result();
			if(mysql_num_rows() == 0) {

			    if(!IsPlayerConnected(extraid))
					return mysql_free_result(); // Incase they're disconnected since... Sometimes queries F*"!%$" up.

			    new
					charCounts[5];

				GetPlayerName(extraid, szPlayerName, MAX_PLAYER_NAME);

				for(new n; n < MAX_PLAYER_NAME; n++) {
					switch(szPlayerName[n]) {
						case '[', ']', '.', '$', '(', ')', '@', '=': charCounts[1]++;
						case '_': charCounts[0]++;
						case '0' .. '9': charCounts[2]++;
						case 'a' .. 'z': charCounts[3]++;
						case 'A' .. 'Z': charCounts[4]++;
					}
				}
				if(charCounts[0] == 0 || charCounts[0] >= 3) {
					SendClientMessage(extraid, COLOR_GREY, "[ERRORE]: Il tuo nome и invalido. {FFFFFF}Usa un nome RolePlay tipo: Marco_Rossi.");
					Kick(extraid);
				}
				else if(charCounts[1] >= 1) {
					SendClientMessage(extraid, COLOR_GREY, "[ERRORE]: Il tuo nome и invalido, contiene simboli. {FFFFFF}Usa un nome RolePlay tipo: Marco_Rossi.");
					Kick(extraid);
				}
				else if(charCounts[2] >= 1) {
					SendClientMessage(extraid, COLOR_GREY, "[ERRORE]: Il tuo nome и invalido, contiene numeri. {FFFFFF}Usa un nome RolePlay tipo: Marco_Rossi.");
					Kick(extraid);
				}
				else {
					SendClientMessage(extraid, COLOR_GENANNOUNCE, "Il tuo account non и registrato e quindi non puoi giocare. Per giocare devi registrare un account sull' UCP");
     				SendClientMessage(extraid, COLOR_GENANNOUNCE, "che puoi trovare all' indirizzo http://www.project-ls.com");
     				Kick(extraid);
     				/*
			        SendClientMessage(extraid, COLOR_GENANNOUNCE, "{CC0000}Benvenuto su "SERVER_NAME"!.");
			        SendClientMessage(extraid, COLOR_GENANNOUNCE, "{FF6600}Il tuo account non sembra essere registrato. Inserisci la password qui sotto per registrarti.");

        			ShowPlayerDialog(extraid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "{FFEE00}R{FFFFFF}egistrazione", "Benvenuto a bordo, su "SERVER_NAME"!.\n\nInserisci la password desiderata qui sotto!", "Registrati", "Cancella");
           			CloseTestoPaginaIniziale(extraid);
              		PlayAudioStreamForPlayer(extraid, "http://project-ls.com/musica/Sigla.mp3");
        			SetPlayerCameraPos(extraid, 1643.6548,-1619.6299,120.2176);
        			SetPlayerCameraLookAt(extraid, 1584.2513,-1457.1102,140.9319);*/
				}
   			}
			else {
			    if(!IsPlayerConnected(extraid))
					return mysql_free_result();

				ShowPlayerDialog(extraid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Bentornato su "SERVER_NAME"!.\n\nDigita la tua password qui sotto.!", "Login", "Cancella");
				CloseTestoPaginaIniziale(extraid);
    			PlayAudioStreamForPlayer(extraid, "http://project-ls.com/musica/Sigla.mp3");
    			SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
	    		SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
	    		SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
	    		SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
	    		SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
			    SendClientMessage(extraid, 0xDEEE20FF, " ");
				SetPlayerCameraPos(extraid, 1643.6548,-1619.6299,120.2176);
			    SetPlayerCameraLookAt(extraid, 1584.2513,-1457.1102,140.9319);

			    SendClientMessage(extraid, COLOR_GENANNOUNCE, "{CC0000}Benvenuto su "SERVER_NAME"!.");
    			SendClientMessage(extraid, COLOR_GENANNOUNCE, "{FF6600}Attualmente il tuo account и registrato. Inserisci i dati qui sotto per loggare.");
                playerVariables[extraid][pFirstLogin] = 0;
			}

			mysql_free_result();
		}
		case THREAD_MOBILE_HISTORY: {
			mysql_store_result();

			if(mysql_num_rows() > 0) {
			    new
			        iLoop,
			        szGet[128],
			        szCat[512];

       			while(mysql_retrieve_row()) {
			        if(iLoop == 0)
						format(szCat, sizeof(szCat), "\n");

					mysql_get_field("phoneAction", szGet);
					format(szCat, sizeof(szCat), "%s%s\n", szCat, szGet);
			        iLoop++;
			    }

			    mysql_free_result();
			    return ShowPlayerDialog(extraid, DIALOG_MOBILE_HISTORY, DIALOG_STYLE_LIST, "Telefono: Cronologia", szCat, "Indietro", "");
			} else {
			    return ShowPlayerDialog(extraid, DIALOG_MOBILE_HISTORY, DIALOG_STYLE_LIST, "Telefono: Cronologia", "Spiacenti, non c'и nessuna cronologia dell'utilizzo del telefono.", "Indietro", "");
			}
		}
		case THREAD_MOBILE_LIST_CONTACTS: {
			mysql_store_result();

			if(mysql_num_rows() > 0) {
			    new
			        iLoop,
			        szGet[3][64],
			        iNum[2],
			        szCat[512];

			    while(mysql_retrieve_row()) {
			        if(iLoop == 0)
			            format(szCat, sizeof(szCat), "\n{FFFFFF}");

					mysql_get_field("contactName", szGet[0]);
					mysql_get_field("contactAdded", szGet[1]);
					mysql_get_field("contactAddee", szGet[2]);

					iNum[0] = strval(szGet[1]);
					iNum[1] = strval(szGet[2]);

					format(szCat, sizeof(szCat), "%s%s "EMBED_GREY"(#%d){FFFFFF}\n", szCat, szGet[0], iNum[0]);

			        iLoop++;
			    }

				mysql_free_result();

				return ShowPlayerDialog(extraid, DIALOG_MOBILE_HISTORY, DIALOG_STYLE_LIST, "Telefono: Lista contatti", szCat, "Indietro", "");
			} else {
			    return ShowPlayerDialog(extraid, DIALOG_MOBILE_HISTORY, DIALOG_STYLE_LIST, "Telefono: Lista contatti", "Non hai nessun contatto.", "Indietro", "");
			}
		}
		case THREAD_CHECK_PLATES: {
		    mysql_store_result();

		    mysql_retrieve_row();

		    if(mysql_num_rows() > 0) {
		        mysql_free_result();
			    return ShowPlayerDialog(extraid, DIALOG_LICENSE_PLATE, DIALOG_STYLE_INPUT, "Immatricolazione targa veicolo.", "{FFFFFF}[ERRORE]:"EMBED_GREY" La targa da te scelta giа esiste. Scegline un'altra.{FFFFFF}\n\nScegli, ora, la tua targa. \n\nSegui le due opzioni:\n- La targa deve essere unica\n- La targa puт essere alfanumerica, ma deve consistere in soli 7 caratteri e includere uno spazio.", "Select", "");
		    }

		    GetPVarString(extraid, "plate", playerVariables[extraid][pCarLicensePlate], 32);
		    DeletePVar(extraid, "plate");

		    SendClientMessage(extraid, COLOR_WHITE, "La targa da te selezionata и stata correttamente applicata al tuo veicolo.");

		    SetVehicleNumberPlate(playerVariables[extraid][pCarID], playerVariables[extraid][pCarLicensePlate]);
		    SetPlayerVirtualWorld(extraid, 0);
		    SetVehicleVirtualWorld(playerVariables[extraid][pCarID], GetVehicleVirtualWorld(playerVariables[extraid][pCarID])+1);
		    SetVehicleVirtualWorld(playerVariables[extraid][pCarID], GetVehicleVirtualWorld(playerVariables[extraid][pCarID])-1);
			mysql_free_result(); // Aspetta. Mettiamo una parola che ci porti qui. -> MITOSKING
		}
		case THREAD_CHECK_CREDENTIALS: {
		    mysql_store_result();

			if(!IsPlayerConnected(extraid)) return mysql_free_result(); // Incase they're disconnected since... Sometimes queries F*"!%$" up.

			if(mysql_num_rows() == 0) { // INCORRECT PASSWORD!1

				SetPVarInt(extraid, "LA", GetPVarInt(extraid, "LA") + 1);

				new
					string[128],
					playerIP[32];

				if(GetPVarInt(extraid, "LA") > MAX_LOGIN_ATTEMPTS) {
					SendClientMessage(extraid, COLOR_RED, "Hai usato tutti i tentativi di login disponibili.");
					GetPlayerIp(extraid, playerIP, sizeof(playerIP));

					GetPlayerName(extraid, GetPlayerNameEx(extraid), MAX_PLAYER_NAME);
					format(string, sizeof(string), "[WARNING]: {FFFFFF}IP %s и stato bannato.(%d tre tentativi password errati %s).", playerIP, MAX_LOGIN_ATTEMPTS, GetPlayerNameEx(extraid));
					submitToAdmins(string, COLOR_HOTORANGE);

					IPBan(playerIP, "Hai superato il tentativo di login massimi.");
					Kick(extraid);
					return 1;

				}
			    else {
					ShowPlayerDialog(extraid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Benvenuto su "SERVER_NAME" Server.\n\nInserisci la tua password qui sotto per loggare.", "Login", "Cancella");
					PlayAudioStreamForPlayer(extraid, "http://project-ls.com/musica/Sigla.mp3");
					format(string, sizeof(string), "Password errata. Ti rimangono %d tentativi per loggare.", MAX_LOGIN_ATTEMPTS - GetPVarInt(extraid, "LA"));
					SendClientMessage(extraid, COLOR_HOTORANGE, string);
					playerVariables[extraid][pFirstLogin] = 0;
					return 1;
				}
			}
			else {
			    clearScreen(extraid);
			    DeletePVar(extraid, "LA");

				mysql_retrieve_row();

				mysql_get_field("playerBanned", result);

				if(strval(result) >= 1) {

					new
						playerIP[32],
						string[120];

				    SendClientMessage(extraid, COLOR_RED, "Sei bannato da questo server.");

					GetPlayerIp(extraid, playerIP, sizeof(playerIP));
					GetPlayerName(extraid, szPlayerName, MAX_PLAYER_NAME);

					format(string, sizeof(string), "[WARNING]: {FFFFFF}%s has attempted to evade their account ban (using IP %s).", szPlayerName, playerIP);
					submitToAdmins(string, COLOR_HOTORANGE);

					format(string, sizeof(string), "Attempted ban evasion (%s).", szPlayerName);

					IPBan(playerIP, string);
					Kick(extraid);
				}

                CloseTestoPaginaIniziale(extraid);
                CloseWideScreen(extraid);
                StopAudioStreamForPlayer(extraid);

				playerVariables[extraid][pBanned] = strval(result);

				mysql_get_field("playerPassword", playerVariables[extraid][pPassword]);

                mysql_get_field("playerEmail", playerVariables[extraid][pEmail]);

                mysql_get_field("playerSkin", result);
                playerVariables[extraid][pSkin] = strval(result);

                mysql_get_field("playerMoney", result);
                playerVariables[extraid][pMoney] = strval(result);

                mysql_get_field("playerBankMoney", result);
                playerVariables[extraid][pBankMoney] = strval(result);

                mysql_get_field("playerPosX", result);
                playerVariables[extraid][pPos][0] = floatstr(result);

                mysql_get_field("playerPosY", result);
                playerVariables[extraid][pPos][1] = floatstr(result);

                mysql_get_field("playerPosZ", result);
                playerVariables[extraid][pPos][2] = floatstr(result);

                mysql_get_field("playerHealth", result);
                playerVariables[extraid][pHealth] = floatstr(result);

                mysql_get_field("playerArmour", result);
                playerVariables[extraid][pArmour] = floatstr(result);

				mysql_get_field("playerVIP", result);
                playerVariables[extraid][pVIP] = strval(result);

                mysql_get_field("playerSeconds", result);
                playerVariables[extraid][pSeconds] = strval(result);

                mysql_get_field("playerAdminLevel", result);
                playerVariables[extraid][pAdminLevel] = strval(result);

                mysql_get_field("playerAccent", playerVariables[extraid][pAccent]);

	            mysql_get_field("playerInterior", result);
	            playerVariables[extraid][pInterior] = strval(result);

	            mysql_get_field("playerVirtualWorld", result);
	            playerVariables[extraid][pVirtualWorld] = strval(result);

                mysql_get_field("playerID", result);
                playerVariables[extraid][pInternalID] = strval(result);

				mysql_get_field("playerCarLicensePlate", playerVariables[extraid][pCarLicensePlate]);

                mysql_get_field("playerJob", result);
                playerVariables[extraid][pJob] = strval(result);

                mysql_get_field("playerWeapon0", result);
                playerVariables[extraid][pWeapons][0] = strval(result);

                mysql_get_field("playerWeapon1", result);
                playerVariables[extraid][pWeapons][1] = strval(result);

                mysql_get_field("playerWeapon2", result);
                playerVariables[extraid][pWeapons][2] = strval(result);

                mysql_get_field("playerWeapon3", result);
                playerVariables[extraid][pWeapons][3] = strval(result);

                mysql_get_field("playerWeapon4", result);
                playerVariables[extraid][pWeapons][4] = strval(result);

                mysql_get_field("playerWeapon5", result);
                playerVariables[extraid][pWeapons][5] = strval(result);

                mysql_get_field("playerWeapon6", result);
                playerVariables[extraid][pWeapons][6] = strval(result);

                mysql_get_field("playerWeapon7", result);
                playerVariables[extraid][pWeapons][7] = strval(result);

                mysql_get_field("playerWeapon8", result);
                playerVariables[extraid][pWeapons][8] = strval(result);

                mysql_get_field("playerWeapon9", result);
                playerVariables[extraid][pWeapons][9] = strval(result);

				mysql_get_field("playerWeapon10", result);
                playerVariables[extraid][pWeapons][10] = strval(result);

				mysql_get_field("playerWeapon11", result);
                playerVariables[extraid][pWeapons][11] = strval(result);

				mysql_get_field("playerWeapon12", result);
                playerVariables[extraid][pWeapons][12] = strval(result);

				mysql_get_field("playerJobSkill1", result);
                playerVariables[extraid][pJobSkill][0] = strval(result);

				mysql_get_field("playerJobSkill2", result);
                playerVariables[extraid][pJobSkill][1] = strval(result);

				mysql_get_field("playerMaterials", result);
                playerVariables[extraid][pMaterials] = strval(result);

                mysql_get_field("playerDroga", result);
                playerVariables[extraid][pDroga] = strval(result);

                mysql_get_field("playerAssegni", result);
                playerVariables[extraid][pAssegni] = strval(result);

				mysql_get_field("playerGroup", result);
                playerVariables[extraid][pGroup] = strval(result);

                mysql_get_field("playerIllegal",result);
                playerVariables[extraid][pIllegal] = strval(result);

				mysql_get_field("playerGroupRank", result);
                playerVariables[extraid][pGroupRank] = strval(result);

                mysql_get_field("playerGangRank", result);
                playerVariables[extraid][pGangRank] = strval(result);

				mysql_get_field("playerHours", result);
                playerVariables[extraid][pPlayingHours] = strval(result);

                mysql_get_field("playerWarning1", playerVariables[extraid][pWarning1]);
                mysql_get_field("playerWarning2", playerVariables[extraid][pWarning2]);
                mysql_get_field("playerWarning3", playerVariables[extraid][pWarning3]);

				mysql_get_field("playerHospitalized", result);
                playerVariables[extraid][pHospitalized] = strval(result);

				mysql_get_field("playerAdminName", playerVariables[extraid][pAdminName]);

				mysql_get_field("playerFirstLogin", result);
				playerVariables[extraid][pFirstLogin] = strval(result);

				mysql_get_field("playerGender", result);
				playerVariables[extraid][pGender] = strval(result);

				mysql_get_field("playerPrisonID", result);
                playerVariables[extraid][pPrisonID] = strval(result);

				mysql_get_field("playerPrisonTime", result);
                playerVariables[extraid][pPrisonTime] = strval(result);

                mysql_get_field("playerRicoveratoID", result);
                playerVariables[extraid][pRicoveratoID] = strval(result);

                mysql_get_field("playerTempoRicovero", result);
                playerVariables[extraid][pTempoRicovero] = strval(result);

                mysql_get_field("playerDrogato", result);
                playerVariables[extraid][pDrogato] = strval(result);

                mysql_get_field("playerPhoneNumber", result);
                playerVariables[extraid][pPhoneNumber] = strval(result);

                mysql_get_field("playerPhoneBook", result);
                playerVariables[extraid][pPhoneBook] = strval(result);

                mysql_get_field("playerHelperLevel", result);
                playerVariables[extraid][pHelper] = strval(result);

                mysql_get_field("playerDropCarTimeout", result);
                playerVariables[extraid][pDropCarTimeout] = strval(result);

                mysql_get_field("playerRope", result);
                playerVariables[extraid][pRope] = strval(result);

                mysql_get_field("playerBls", result);
                playerVariables[extraid][pBls] = strval(result);

                mysql_get_field("playerPortoArmi", result);
                playerVariables[extraid][pPortoArmi] = strval(result);

                mysql_get_field("playerLicenzaT", result);
                playerVariables[extraid][pLicenzaT] = strval(result);

                mysql_get_field("playerLicenzaA", result);
                playerVariables[extraid][pLicenzaA] = strval(result);

                mysql_get_field("playerPatenteA", result);
                playerVariables[extraid][pPatenteA] = strval(result);

                mysql_get_field("playerPatenteB", result);
                playerVariables[extraid][pPatenteB] = strval(result);

                mysql_get_field("playerPatenteC", result);
                playerVariables[extraid][pPatenteC] = strval(result);

                mysql_get_field("playerPatenteD", result);
                playerVariables[extraid][pPatenteD] = strval(result);

                mysql_get_field("playerVolo", result);
                playerVariables[extraid][pVolo] = strval(result);

                mysql_get_field("playerLicenzaK", result);
                playerVariables[extraid][pLicenzaK] = strval(result);

                mysql_get_field("playerAdminDuty", result);
                playerVariables[extraid][pAdminDuty] = strval(result);

                mysql_get_field("playerCrimes", result);
                playerVariables[extraid][pCrimes] = strval(result);

                mysql_get_field("playerArrests", result);
                playerVariables[extraid][pArrests] = strval(result);

                mysql_get_field("playerWarrants", result);
                playerVariables[extraid][pWarrants] = strval(result);

                mysql_get_field("playerLevel", result);
                playerVariables[extraid][pLevel] = strval(result);

                mysql_get_field("playerAge", result);
                playerVariables[extraid][pAge] = strval(result);

                mysql_get_field("playerCarModel", result);
                playerVariables[extraid][pCarModel] = strval(result);

                mysql_get_field("playerCarMod0", result);
                playerVariables[extraid][pCarMods][0] = strval(result);

                mysql_get_field("playerCarMod1", result);
                playerVariables[extraid][pCarMods][1] = strval(result);

                mysql_get_field("playerCarMod2", result);
                playerVariables[extraid][pCarMods][2] = strval(result);

                mysql_get_field("playerCarMod3", result);
                playerVariables[extraid][pCarMods][3] = strval(result);

                mysql_get_field("playerCarMod4", result);
                playerVariables[extraid][pCarMods][4] = strval(result);

                mysql_get_field("playerCarMod5", result);
                playerVariables[extraid][pCarMods][5] = strval(result);

                mysql_get_field("playerCarMod6", result);
                playerVariables[extraid][pCarMods][6] = strval(result);

                mysql_get_field("playerCarMod7", result);
                playerVariables[extraid][pCarMods][7] = strval(result);

                mysql_get_field("playerCarMod8", result);
                playerVariables[extraid][pCarMods][8] = strval(result);

                mysql_get_field("playerCarMod9", result);
                playerVariables[extraid][pCarMods][9] = strval(result);

                mysql_get_field("playerCarMod10", result);
                playerVariables[extraid][pCarMods][10] = strval(result);

                mysql_get_field("playerCarMod11", result);
                playerVariables[extraid][pCarMods][11] = strval(result);

                mysql_get_field("playerCarMod12", result);
                playerVariables[extraid][pCarMods][12] = strval(result);

                mysql_get_field("playerCarPosX", result);
                playerVariables[extraid][pCarPos][0] = floatstr(result);

                mysql_get_field("playerCarPosY", result);
                playerVariables[extraid][pCarPos][1] = floatstr(result);

                mysql_get_field("playerCarPosZ", result);
                playerVariables[extraid][pCarPos][2] = floatstr(result);

                mysql_get_field("playerCarPosZAngle", result);
                playerVariables[extraid][pCarPos][3] = floatstr(result);

                mysql_get_field("playerCarColour1", result);
                playerVariables[extraid][pCarColour][0] = strval(result);

                mysql_get_field("playerCarColour2", result);
                playerVariables[extraid][pCarColour][1] = strval(result);

                mysql_get_field("playerCarPaintJob", result);
                playerVariables[extraid][pCarPaintjob] = strval(result);

                mysql_get_field("playerCarLock", result);
                playerVariables[extraid][pCarLock] = strval(result);

                mysql_get_field("playerFightStyle", result);
                playerVariables[extraid][pFightStyle] = strval(result);

                mysql_get_field("playerCarWeapon1", result);
                playerVariables[extraid][pCarWeapons][0] = strval(result);

                mysql_get_field("playerCarWeapon2", result);
                playerVariables[extraid][pCarWeapons][1] = strval(result);

                mysql_get_field("playerCarWeapon3", result);
                playerVariables[extraid][pCarWeapons][2] = strval(result);

                mysql_get_field("playerCarWeapon4", result);
                playerVariables[extraid][pCarWeapons][3] = strval(result);

                mysql_get_field("playerCarWeapon5", result);
                playerVariables[extraid][pCarWeapons][4] = strval(result);

                mysql_get_field("playerCarStereo", result);
                playerVariables[extraid][pCarStereo] = strval(result);

                mysql_get_field("playerCarAlarm", result);
                playerVariables[extraid][pCarAlarm] = strval(result);

                mysql_get_field("playerCarTrunk1", result);
                playerVariables[extraid][pCarTrunk][0] = strval(result);

                mysql_get_field("playerCarTrunk2", result);
                playerVariables[extraid][pCarTrunk][1] = strval(result);

                mysql_get_field("playerPhoneCredit", result);
                playerVariables[extraid][pPhoneCredit] = strval(result);

                mysql_get_field("playerWalkieTalkie", result);
                playerVariables[extraid][pWalkieTalkie] = strval(result);

                mysql_get_field("playerValigetta", result);
                playerVariables[extraid][pValigetta] = strval(result);

                mysql_get_field("playerSigaretta", result);
                playerVariables[extraid][pSigaretta] = strval(result);

                mysql_get_field("playerEBook", result);
                playerVariables[extraid][pEBook] = strval(result);

                mysql_get_field("playerOcchiali", result);
                playerVariables[extraid][pOcchiali] = strval(result);

                mysql_get_field("playerCappelli", result);
                playerVariables[extraid][pCappelli] = strval(result);

                mysql_get_field("playerMaschera", result);
                playerVariables[extraid][pMaschera] = strval(result);

                mysql_get_field("playerBandana", result);
                playerVariables[extraid][pBandana] = strval(result);

                mysql_get_field("player******", result);
                playerVariables[extraid][p******] = strval(result);

                mysql_get_field("playerIPod", result);
                playerVariables[extraid][pIPod] = strval(result);

                mysql_get_field("playerGPS", result);
                playerVariables[extraid][pGPS] = strval(result);

                mysql_get_field("playerNotes", result);
                playerVariables[extraid][pNotes] = strval(result);

                mysql_get_field("ChatOOCStatus", result);
                playerVariables[extraid][pChatOOCStatus] = strval(result);

				GetPlayerName(extraid, playerVariables[extraid][pNormalName], MAX_PLAYER_NAME);

				GetPlayerIp(extraid, playerVariables[extraid][pConnectionIP], 32);

				playerVariables[extraid][pStatus] = 1;

				format(result, sizeof(result), "SELECT `conTS` FROM `playerconnections` WHERE `conPlayerID` = '%d' ORDER BY `conId` DESC LIMIT 1", playerVariables[extraid][pInternalID]);
				mysql_query(result, THREAD_TIMESTAMP_CONNECT, extraid);

				format(result, sizeof(result), "INSERT INTO playerconnections (conName, conIP, conPlayerID) VALUES('%s', '%s', %d)", playerVariables[extraid][pNormalName], playerVariables[extraid][pConnectionIP], playerVariables[extraid][pInternalID]);
				mysql_query(result, THREAD_RANDOM);

				format(result, sizeof(result), "UPDATE playeraccounts SET playerStatus = '1' WHERE playerID = '%d'", playerVariables[extraid][pInternalID]);
				mysql_query(result, THREAD_RANDOM);

			    if(playerVariables[extraid][pFirstLogin] >= 1) {
					return initiateTutorial(extraid);
				}

                SetSpawnInfo(extraid, 0, playerVariables[extraid][pSkin], playerVariables[extraid][pPos][0], playerVariables[extraid][pPos][1], playerVariables[extraid][pPos][2], 0, 0, 0, 0, 0, 0, 0);
				SpawnPlayer(extraid);

	         	if(playerVariables[extraid][pWarrants] > 0) {
	         	    SetPlayerWantedLevel(extraid, playerVariables[extraid][pWarrants]);
	         	    SendClientMessage(extraid, COLOR_HOTORANGE, "Sei ancora ricercato! La tua fedina penale и stata ripristinata.");
	         	}

	         	format(szQueryOutput, sizeof(szQueryOutput), "SELECT * FROM `banksuspensions` WHERE `playerID` = %d", playerVariables[extraid][pInternalID]);
				mysql_query(szQueryOutput, THREAD_BANK_SUSPENSION, extraid);

	         	if(playerVariables[extraid][pCarModel] > 0)
					SpawnPlayerVehicle(extraid);

				if(playerVariables[extraid][pLevel] > 0)
				    SetPlayerScore(extraid, playerVariables[extraid][pLevel]);

				if(playerVariables[extraid][pAdminDuty] == 1 && playerVariables[extraid][pAdminLevel] < 1) {
					playerVariables[extraid][pAdminLevel] = 0;
					playerVariables[extraid][pAdminDuty] = 0;
					format(playerVariables[extraid][pAdminName], MAX_PLAYER_NAME, "(null)");
					SendClientMessage(extraid, COLOR_HOTORANGE, "Non sei piщ un amministratore.");
				}

				if(playerVariables[extraid][pAdminLevel] > 0 && playerVariables[extraid][pAdminDuty] > 1)
				    SetPlayerName(extraid, playerVariables[extraid][pAdminName]);
			}

			mysql_free_result();
		}
		case THREAD_BANK_SUSPENSION: {
			mysql_store_result();

			if(mysql_num_rows() < 1)
			    return 1;

			mysql_retrieve_row();

			mysql_get_field("suspensionReason", result);
			SetPVarString(extraid, "BSuspend", result);

			mysql_get_field("suspendeeID", result);
			mysql_free_result();

			format(szQueryOutput, sizeof(szQueryOutput), "SELECT `playerName` FROM `playeraccounts` WHERE `playerID` = %d", strval(result));
			mysql_query(szQueryOutput);
			mysql_store_result();
			mysql_retrieve_row();

			mysql_get_field("playerName", result);
			SetPVarString(extraid, "BSuspendee", result);

			mysql_free_result();
		}
		/*case THREAD_CHECK_PLAY: {
  			mysql_store_result();

			if(!IsPlayerConnected(extraid))
			return mysql_free_result(); // Incase they're disconnected since... Sometimes queries F*"!%$" up.

			if(mysql_num_rows() == 0) {
			SendClientMessage(extraid, COLOR_RED, "Questo utente non и registrato crea il tuo player nell' ucp su http://www.project-ls.it .");
			Kick(extraid);
			}else if(mysql_num_rows() >= 1) {
			mysql_retrieve_row();
			mysql_get_field("playerPlay", result);
			mysql_free_result();
			if(strval(result) == 1)
			{
 			return 1;
			}else if(strval(result) == 0){
			SendClientMessage(extraid, COLOR_RED, "Questo utente non и ancora stato abilitato, attendi che un Tester accetti il tuo modulo.");
			return Kick(extraid);
			}
			}
			mysql_free_result();
		}*/

		case THREAD_CHECK_BANS_LIST: {
		    mysql_store_result();

			if(!IsPlayerConnected(extraid))
				return mysql_free_result(); // Incase they're disconnected since... Sometimes queries F*"!%$" up.

		    if(mysql_num_rows() >= 1) {
				SendClientMessage(extraid, COLOR_RED, "Risulti bannato dal server. Rilogga oppure spegni e riaccendi il tuo modem dopo 15 secondi.");
				Kick(extraid);
			}
		    else {
				new
			        playerEscapedName[MAX_PLAYER_NAME],
			        queryUsername[100];

			    GetPlayerName(extraid, szPlayerName, MAX_PLAYER_NAME);
			    mysql_real_escape_string(szPlayerName, playerEscapedName);

				// Continue with the rest of the auth code...
			    format(queryUsername, sizeof(queryUsername), "SELECT `playerName` FROM `playeraccounts` WHERE `playerName` = '%s'", playerEscapedName);
			    mysql_query(queryUsername, THREAD_CHECK_ACCOUNT_USERNAME, extraid);
		    }

		    mysql_free_result();
		}
		case THREAD_BAN_PLAYER: {
			new
			    queryString[128];

			format(queryString, sizeof(queryString), "UPDATE playeraccounts SET playerBanned = '1' WHERE playerID = '%d'", playerVariables[extraid][pInternalID]);
			mysql_query(queryString, THREAD_FINALIZE_BAN, extraid);
		}
		case THREAD_FINALIZE_BAN: return Kick(extraid);
		case THREAD_CHECK_PLAYER_NAME_BANNED: {
			mysql_store_result();

			if(mysql_num_rows() >= 1) {
			    new
			        queryString[128];

				format(queryString, sizeof(queryString), "DELETE FROM bans WHERE playerNameBanned = '%s'", playerVariables[extraid][pNameUnbanning]);
				mysql_query(queryString, THREAD_FINALIZE_UNBAN, extraid);
			}
			else {
			    SendClientMessage(extraid, COLOR_GREY, "Il nome del player non risulta bannato.");
			}

			mysql_free_result();
		}
		case THREAD_FINALIZE_UNBAN: {
		    new
		        action[128];

		    GetPlayerName(extraid, szPlayerName, MAX_PLAYER_NAME);
		    SendClientMessage(extraid, COLOR_WHITE, "L'unban и avvenuto correttamente.");

			format(action, sizeof(action), "[ADMIN INFO]: {FFFFFF}%s ha sbannato il player %s.", GetPlayerNameEx(extraid), playerVariables[extraid][pNameUnbanning]);

			submitToAdmins(action, COLOR_HOTORANGE);
		    adminLog(action);

		    format(action, sizeof(action), "UPDATE playeraccounts SET playerBanned = '0' WHERE playerName = '%s'", playerVariables[extraid][pNameUnbanning]);
		    mysql_query(action);
		}
		case THREAD_INITIATE_HOUSES: {
			mysql_store_result();

			new
			    x;

			while(mysql_retrieve_row()) {
				mysql_get_field("houseID", result);
				x = strval(result);

				mysql_get_field("houseExteriorPosX", result);
				houseVariables[x][hHouseExteriorPos][0] = floatstr(result);

				mysql_get_field("houseExteriorPosY", result);
				houseVariables[x][hHouseExteriorPos][1] = floatstr(result);

				mysql_get_field("houseExteriorPosZ", result);
				houseVariables[x][hHouseExteriorPos][2] = floatstr(result);

				mysql_get_field("houseInteriorPosX", result);
				houseVariables[x][hHouseInteriorPos][0] = floatstr(result);

				mysql_get_field("houseInteriorPosY", result);
				houseVariables[x][hHouseInteriorPos][1] = floatstr(result);

				mysql_get_field("houseInteriorPosZ", result);
				houseVariables[x][hHouseInteriorPos][2] = floatstr(result);

				mysql_get_field("houseInteriorID", result);
				houseVariables[x][hHouseInteriorID] = strval(result);

				mysql_get_field("houseExteriorID", result);
				houseVariables[x][hHouseExteriorID] = strval(result);

				mysql_get_field("houseOwner", houseVariables[x][hHouseOwner]);

				mysql_get_field("housePrice", result);
				houseVariables[x][hHousePrice] = strval(result);

				mysql_get_field("houseLocked", result);
				houseVariables[x][hHouseLocked] = strval(result);

				mysql_get_field("houseMoney", result);
				houseVariables[x][hMoney] = strval(result);

				mysql_get_field("houseWeapon1", result);
				houseVariables[x][hWeapons][0] = strval(result);

				mysql_get_field("houseWeapon2", result);
				houseVariables[x][hWeapons][1] = strval(result);

				mysql_get_field("houseWeapon3", result);
				houseVariables[x][hWeapons][2] = strval(result);

				mysql_get_field("houseWeapon4", result);
				houseVariables[x][hWeapons][3] = strval(result);

				mysql_get_field("houseWeapon5", result);
				houseVariables[x][hWeapons][4] = strval(result);

				mysql_get_field("houseWardrobe1", result);
				houseVariables[x][hWardrobe][0] = strval(result);

				mysql_get_field("houseWardrobe2", result);
				houseVariables[x][hWardrobe][1] = strval(result);

				mysql_get_field("houseWardrobe3", result);
				houseVariables[x][hWardrobe][2] = strval(result);

				mysql_get_field("houseWardrobe4", result);
				houseVariables[x][hWardrobe][3] = strval(result);

				mysql_get_field("houseWardrobe5", result);
				houseVariables[x][hWardrobe][4] = strval(result);

				mysql_get_field("houseMaterials", result);
				houseVariables[x][hMaterials] = strval(result);

				if(!strcmp(houseVariables[x][hHouseOwner], "Nessuno", true) && strlen(houseVariables[x][hHouseOwner]) >= 1) {
				    /*new
				        labelString[96];

				    if(houseVariables[x][hHouseLocked] == 1) {
				    	format(labelString, sizeof(labelString), "Casa %d\nPrezzo: $%d\n\nChiusa", x, houseVariables[x][hHousePrice]);
				    }
				    else {
				        format(labelString, sizeof(labelString), "Casa %d\nPrezzo: $%d\n\nPremi ~k~~VEHICLE_ENTER_EXIT~ per entrare.", x, houseVariables[x][hHousePrice]);
				    }

				    houseVariables[x][hLabelID] = CreateDynamic3DTextLabel(labelString, COLOR_DARKYELLOW, houseVariables[x][hHouseExteriorPos][0], houseVariables[x][hHouseExteriorPos][1], houseVariables[x][hHouseExteriorPos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 10.0);*/
					houseVariables[x][hPickupID] = CreateDynamicCP(houseVariables[x][hHouseExteriorPos][0], houseVariables[x][hHouseExteriorPos][1], houseVariables[x][hHouseExteriorPos][2], 1.0, -1,-1,-1,8.0);
				}
				else {
				    /*new
				        labelString[96];

				    if(houseVariables[x][hHouseLocked] == 1) {
				    	format(labelString, sizeof(labelString), "Casa %d\nProprietario: %s\n\nChiusa", x, houseVariables[x][hHouseOwner]);
				    }
				    else {
				        format(labelString, sizeof(labelString), "Casa %d\nProprietario: %s\n\nPremi ~k~~VEHICLE_ENTER_EXIT~ per entrare.", x, houseVariables[x][hHouseOwner]);
				    }

				    houseVariables[x][hLabelID] = CreateDynamic3DTextLabel(labelString, COLOR_DARKYELLOW, houseVariables[x][hHouseExteriorPos][0], houseVariables[x][hHouseExteriorPos][1], houseVariables[x][hHouseExteriorPos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 10.0);*/
				    houseVariables[x][hPickupID] = CreateDynamicCP(houseVariables[x][hHouseExteriorPos][0], houseVariables[x][hHouseExteriorPos][1], houseVariables[x][hHouseExteriorPos][2], 1.0, -1,-1,-1,8.0);
				}

				systemVariables[houseCount]++;
			}

			printf("[script] %d houses loaded.", systemVariables[houseCount]);

			mysql_free_result();
		}

		case THREAD_INITIATE_BUSINESSES: {
			mysql_store_result();

			new
			    x;

			while(mysql_retrieve_row()) {
				mysql_get_field("businessID", result);
				x = strval(result);

				mysql_get_field("businessName", businessVariables[x][bName]);

				mysql_get_field("businessOwner", businessVariables[x][bOwner]);

				mysql_get_field("businessType", result);
				businessVariables[x][bType] = strval(result);

				mysql_get_field("businessExteriorX", result);
				businessVariables[x][bExteriorPos][0] = floatstr(result);

				mysql_get_field("businessExteriorY", result);
				businessVariables[x][bExteriorPos][1] = floatstr(result);

				mysql_get_field("businessExteriorZ", result);
				businessVariables[x][bExteriorPos][2] = floatstr(result);

				mysql_get_field("businessInteriorX", result);
				businessVariables[x][bInteriorPos][0] = floatstr(result);

				mysql_get_field("businessInteriorY", result);
				businessVariables[x][bInteriorPos][1] = floatstr(result);

				mysql_get_field("businessInteriorZ", result);
				businessVariables[x][bInteriorPos][2] = floatstr(result);

				mysql_get_field("businessInterior", result);
				businessVariables[x][bInterior] = strval(result);

				mysql_get_field("businessLock", result);
				businessVariables[x][bLocked] = strval(result);

				mysql_get_field("businessPrice", result);
				businessVariables[x][bPrice] = strval(result);

				mysql_get_field("businessVault", result);
				businessVariables[x][bVault] = strval(result);

				mysql_get_field("businessMagazzino", result);
				businessVariables[x][bMagazzino] = strval(result);

				mysql_get_field("businessMiscX", result);
				businessVariables[x][bMiscPos][0] = floatstr(result);

				mysql_get_field("businessMiscY", result);
				businessVariables[x][bMiscPos][1] = floatstr(result);

				mysql_get_field("businessMiscZ", result);
				businessVariables[x][bMiscPos][2] = floatstr(result);

				switch(businessVariables[x][bLocked]) {
					case 1: {
					    if(!strcmp(businessVariables[x][bOwner], "Nessuno", true)) {
							format(result, sizeof(result), "%s\nIn vendita\nPrezzo: $%d (/comprabiz)\n\n(Chiuso)", businessVariables[x][bName], businessVariables[x][bPrice]);
						}
						else {
						    format(result, sizeof(result), "%s\nProprietario: %s\n\nChiuso", businessVariables[x][bName], businessVariables[x][bOwner]);
						}
					}
					case 0: {
					    if(!strcmp(businessVariables[x][bOwner], "Nessuno", true)) {
							format(result, sizeof(result), "%s\nIn vendita\nPrezzo: $%d (/comprabiz)\n\nPremi ~k~~VEHICLE_ENTER_EXIT~ per entrare", businessVariables[x][bName], businessVariables[x][bPrice]);
						}
						else {
						    format(result, sizeof(result), "%s\nProprietario: %s\n\nPremi ~k~~VEHICLE_ENTER_EXIT~ per entrare", businessVariables[x][bName], businessVariables[x][bOwner]);
						}
					}
				}

				businessVariables[x][bLabelID] = CreateDynamic3DTextLabel(result, COLOR_DARKYELLOW, businessVariables[x][bExteriorPos][0], businessVariables[x][bExteriorPos][1], businessVariables[x][bExteriorPos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 10.0);
				businessVariables[x][bPickupID] = CreateDynamicPickup(1239, 23, businessVariables[x][bExteriorPos][0], businessVariables[x][bExteriorPos][1], businessVariables[x][bExteriorPos][2], 0, 0, -1, 250);
				systemVariables[businessCount]++;
			}

			mysql_free_result();
		}
  case THREAD_INITIATE_BUILDINGS: {
			mysql_store_result();

			new
			    x;

			while(mysql_retrieve_row()) {
			    mysql_get_field("buildingID", result);
			    x = strval(result);

			    mysql_get_field("buildingName", buildingVariables[x][blName]);

			    mysql_get_field("buildingExteriorX",result);
			    buildingVariables[x][blExteriorPos][0] = floatstr(result);

			    mysql_get_field("buildingExteriorY", result);
				buildingVariables[x][blExteriorPos][1] = floatstr(result);

				mysql_get_field("buildingExteriorZ", result);
				buildingVariables[x][blExteriorPos][2] = floatstr(result);

				mysql_get_field("buildingInteriorX", result);
				buildingVariables[x][blInteriorPos][0] = floatstr(result);

				mysql_get_field("buildingInteriorY", result);
				buildingVariables[x][blInteriorPos][1] = floatstr(result);

				mysql_get_field("buildingInteriorZ", result);
				buildingVariables[x][blInteriorPos][2] = floatstr(result);

				mysql_get_field("buildingInterior", result);
				buildingVariables[x][blInterior] = strval(result);

				mysql_get_field("buildingLocked", result);
				buildingVariables[x][blLocked] = strval(result);

				switch(buildingVariables[x][blLocked]) {
					case 1: {

						    format(result, sizeof(result), "%s\n\nChiusa", buildingVariables[x][blName]);
					}
					case 0: {

						    format(result, sizeof(result), "%s\n\nPremi ~k~~VEHICLE_ENTER_EXIT~ per entrare", buildingVariables[x][blName]);
					}
				}

				buildingVariables[x][blLabelID] = CreateDynamic3DTextLabel(result, COLOR_DARKYELLOW, buildingVariables[x][blExteriorPos][0], buildingVariables[x][blExteriorPos][1], buildingVariables[x][blExteriorPos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 10.0);
				buildingVariables[x][blPickupID] = CreateDynamicPickup(1239, 23, buildingVariables[x][blExteriorPos][0], buildingVariables[x][blExteriorPos][1], buildingVariables[x][blExteriorPos][2], 0, 0, -1, 250);
				systemVariables[buildingCount]++;
			}

			mysql_free_result();
		}
  case THREAD_INITIATE_INDUSTRIES: {
			mysql_store_result();

			new
			    x;

			while(mysql_retrieve_row()) {
				mysql_get_field("industriaID", result);
				x = strval(result);

				mysql_get_field("industriaName", industriaVariables[x][iName]);

				mysql_get_field("industriaOwner", industriaVariables[x][iOwner]);

				mysql_get_field("industriaType", result);
				industriaVariables[x][iType] = strval(result);

				mysql_get_field("industriaExteriorX", result);
				industriaVariables[x][iExteriorPos][0] = floatstr(result);

				mysql_get_field("industriaExteriorY", result);
				industriaVariables[x][iExteriorPos][1] = floatstr(result);

				mysql_get_field("industriaExteriorZ", result);
				industriaVariables[x][iExteriorPos][2] = floatstr(result);

				mysql_get_field("industriaInteriorX", result);
				industriaVariables[x][iInteriorPos][0] = floatstr(result);

				mysql_get_field("industriaInteriorY", result);
				industriaVariables[x][iInteriorPos][1] = floatstr(result);

				mysql_get_field("industriaInteriorZ", result);
				industriaVariables[x][iInteriorPos][2] = floatstr(result);

				mysql_get_field("industriaInterior", result);
				industriaVariables[x][iInterior] = strval(result);

				mysql_get_field("industriaLock", result);
				industriaVariables[x][iLocked] = strval(result);

				mysql_get_field("industriaPrice", result);
				industriaVariables[x][iPrice] = strval(result);

				mysql_get_field("industriaVault", result);
				industriaVariables[x][iVault] = strval(result);

				mysql_get_field("industriaMagazzino", result);
				industriaVariables[x][iMagazzino] = strval(result);

				switch(industriaVariables[x][iLocked]) {
					case 1: {
					    if(!strcmp(industriaVariables[x][iOwner], "Nessuno", true)) {
							format(result, sizeof(result), "%s\nIn vendita\nPrezzo: $%d\n\nChiusa", industriaVariables[x][iName], industriaVariables[x][iPrice]);
						}
						else {
						    format(result, sizeof(result), "%s\nProprietario: %s\n\nChiusa", industriaVariables[x][iName], industriaVariables[x][iOwner]);
						}
					}
					case 0: {
					    if(!strcmp(industriaVariables[x][iOwner], "Nessuno", true)) {
							format(result, sizeof(result), "%s\nIn vendita\nPrezzo: $%d\n\nPremi ~k~~VEHICLE_ENTER_EXIT~ per entrare", industriaVariables[x][iName], industriaVariables[x][iPrice]);
						}
						else {
						    format(result, sizeof(result), "%s\nProprietario: %s\n\nPremi ~k~~VEHICLE_ENTER_EXIT~ per entrare", industriaVariables[x][iName], industriaVariables[x][iOwner]);
						}
					}
				}

				industriaVariables[x][iLabelID] = CreateDynamic3DTextLabel(result, COLOR_DARKYELLOW, industriaVariables[x][iExteriorPos][0], industriaVariables[x][iExteriorPos][1], industriaVariables[x][iExteriorPos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 10.0);
				industriaVariables[x][iPickupID] = CreateDynamicPickup(1239, 23, industriaVariables[x][iExteriorPos][0], industriaVariables[x][iExteriorPos][1], industriaVariables[x][iExteriorPos][2], 0, 0, -1, 250);
				systemVariables[industriaCount]++;
			}

			mysql_free_result();
		}
		case THREAD_INITIATE_GANGS: {
			mysql_store_result();

			new
			    x;

			while(mysql_retrieve_row()) {
				mysql_get_field("gangsID", result);
				x = strval(result);

				mysql_get_field("gangsName", gangsVariables[x][gName]);

				mysql_get_field("gangsOwner", gangsVariables[x][gOwner]);

				mysql_get_field("gangsExteriorX", result);
				gangsVariables[x][gExteriorPos][0] = floatstr(result);

				mysql_get_field("gangsExteriorY", result);
				gangsVariables[x][gExteriorPos][1] = floatstr(result);

				mysql_get_field("gangsExteriorZ", result);
				gangsVariables[x][gExteriorPos][2] = floatstr(result);

				mysql_get_field("gangsInteriorX", result);
				gangsVariables[x][gInteriorPos][0] = floatstr(result);

				mysql_get_field("gangsInteriorY", result);
				gangsVariables[x][gInteriorPos][1] = floatstr(result);

				mysql_get_field("gangsInteriorZ", result);
				gangsVariables[x][gInteriorPos][2] = floatstr(result);

				mysql_get_field("gangsInterior", result);
				gangsVariables[x][gInterior] = strval(result);

				mysql_get_field("gangsLock", result);
				gangsVariables[x][gLocked] = strval(result);

				mysql_get_field("gangsPrice", result);
				gangsVariables[x][gPrice] = strval(result);

				mysql_get_field("gangsVault", result);
				gangsVariables[x][gVault] = strval(result);

				mysql_get_field("gangsGangster", result);
				gangsVariables[x][gGangster] = strval(result);

				switch(gangsVariables[x][gLocked]) {
					case 1: {
					    if(!strcmp(gangsVariables[x][gOwner], "Nessuno", true)) {
							format(result, sizeof(result), "%s\nIn vendita\nPrezzo: $%d\n\nChiusa", gangsVariables[x][gName], gangsVariables[x][gPrice]);
						}
						else {
						    format(result, sizeof(result), "%s\n\nChiusa", gangsVariables[x][gName]);
						}
					}
					case 0: {
					    if(!strcmp(gangsVariables[x][gOwner], "Nessuno", true)) {
							format(result, sizeof(result), "%s\nIn vendita\nPrezzo: $%d\n\nPremi ~k~~VEHICLE_ENTER_EXIT~ per entrare", gangsVariables[x][gName], gangsVariables[x][gPrice]);
						}
						else {
						    format(result, sizeof(result), "%s\n\nPremi ~k~~VEHICLE_ENTER_EXIT~ per entrare", gangsVariables[x][gName]);
						}
					}
				}

				gangsVariables[x][gLabelID] = CreateDynamic3DTextLabel(result, COLOR_DARKYELLOW, gangsVariables[x][gExteriorPos][0], gangsVariables[x][gExteriorPos][1], gangsVariables[x][gExteriorPos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 10.0);
				gangsVariables[x][gPickupID] = CreateDynamicPickup(1314, 23, gangsVariables[x][gExteriorPos][0], gangsVariables[x][gExteriorPos][1], gangsVariables[x][gExteriorPos][2], 0, 0, -1, 250);
				systemVariables[gangsCount]++;
			}

			mysql_free_result();
		}
		case THREAD_INITIATE_VEHICLES: {
			mysql_store_result();

			new
			    x,
				bool: success = true;

			while(mysql_retrieve_row()) {
			    mysql_get_field("vehicleID", result);
			    x = strval(result);

				if(systemVariables[vehicleCounts][0] + systemVariables[vehicleCounts][1] + systemVariables[vehicleCounts][2] < MAX_VEHICLES) {
					mysql_get_field("vehicleModelID", result);
					vehicleVariables[x][vVehicleModelID] = strval(result);

					mysql_get_field("vehiclePosX", result);
					vehicleVariables[x][vVehiclePosition][0] = floatstr(result);

					mysql_get_field("vehiclePosY", result);
					vehicleVariables[x][vVehiclePosition][1] = floatstr(result);

					mysql_get_field("vehiclePosZ", result);
					vehicleVariables[x][vVehiclePosition][2] = floatstr(result);

					mysql_get_field("vehiclePosRotation", result);
					vehicleVariables[x][vVehicleRotation] = floatstr(result);

					mysql_get_field("vehicleGroup", result);
					vehicleVariables[x][vVehicleGroup] = strval(result);

					mysql_get_field("vehicleJob", result);
					vehicleVariables[x][vVehicleJob] = strval(result);

					mysql_get_field("vehicleCol1", result);
					vehicleVariables[x][vVehicleColour][0] = strval(result);

					mysql_get_field("vehicleCol2", result);
					vehicleVariables[x][vVehicleColour][1] = strval(result);

					/*if(vehicleVariables[x][vVehicleColour][0] < 0) {
						vehicleVariables[x][vVehicleColour][0] = random(126);
					}
					if(vehicleVariables[x][vVehicleColour][1] < 0) {
						vehicleVariables[x][vVehicleColour][1] = random(126);
					}*/

					vehicleVariables[x][vVehicleScriptID] = CreateVehicle(vehicleVariables[x][vVehicleModelID], vehicleVariables[x][vVehiclePosition][0], vehicleVariables[x][vVehiclePosition][1], vehicleVariables[x][vVehiclePosition][2], vehicleVariables[x][vVehicleRotation], vehicleVariables[x][vVehicleColour][0], vehicleVariables[x][vVehicleColour][1], 60000);

					switch(vehicleVariables[x][vVehicleModelID]) { // OnVehicleSpawn has some annoying glitches with this!1. Should fix.
						case 427, 428, 432, 601, 528: SetVehicleHealth(vehicleVariables[x][vVehicleScriptID], 5000.0);
					}
					systemVariables[vehicleCounts][0]++;
				}
				else {
					success = false;
					printf("Hai raggiunto il limite del veicolo. (MODEL %d, VEHICLEID %d, MAXIMUM %d, TYPE STATIC) [01x08]", vehicleVariables[x][vVehicleModelID], x, MAX_VEHICLES);
				}
			}
			if(success) printf("[SCRIPT] %d veicoli caricati.", systemVariables[vehicleCounts][0]);
			mysql_free_result();
		}
		case THREAD_INITIATE_JOBS: {
			mysql_store_result();

			new
			    labelString[96],
			    x;

			while(mysql_retrieve_row()) {

			    mysql_get_field("jobID", result);
			    x = strval(result);

			    mysql_get_field("jobType", result);
			    jobVariables[x][jJobType] = strval(result);

			    mysql_get_field("jobDuty", result);
			    jobVariables[x][jJobDuty] = strval(result);

			    mysql_get_field("jobPositionX", result);
			    jobVariables[x][jJobPosition][0] = floatstr(result);

			    mysql_get_field("jobPositionY", result);
			    jobVariables[x][jJobPosition][1] = floatstr(result);

			    mysql_get_field("jobPositionZ", result);
			    jobVariables[x][jJobPosition][2] = floatstr(result);

			    mysql_get_field("jobName", jobVariables[x][jJobName]);

			    format(labelString, sizeof(labelString), "Lavoro %s\nUsa /getjob", jobVariables[x][jJobName]);

			    jobVariables[x][jJobPickupID] = CreateDynamicPickup(1239, 23, jobVariables[x][jJobPosition][0], jobVariables[x][jJobPosition][1], jobVariables[x][jJobPosition][2], 0, -1, -1, 50);
				jobVariables[x][jJobLabelID] = CreateDynamic3DTextLabel(labelString, COLOR_DARKYELLOW, jobVariables[x][jJobPosition][0], jobVariables[x][jJobPosition][1], jobVariables[x][jJobPosition][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 50.0);
			}

			mysql_free_result();
		}
		case THREAD_INITIATE_GROUPS: {
		    mysql_store_result();

			new
			    labelString[96],
			    x;

			while(mysql_retrieve_row()) {
			    mysql_get_field("groupID", result);
			    x = strval(result);

			    mysql_get_field("groupName", groupVariables[x][gGroupName]);

			    mysql_get_field("groupType", result);
			    groupVariables[x][gGroupType] = strval(result);

			    mysql_get_field("groupHQExteriorPosX", result);
			    groupVariables[x][gGroupExteriorPos][0] = floatstr(result);

			    mysql_get_field("groupHQExteriorPosY", result);
			    groupVariables[x][gGroupExteriorPos][1] = floatstr(result);

			    mysql_get_field("groupHQExteriorPosZ", result);
			    groupVariables[x][gGroupExteriorPos][2] = floatstr(result);

			    mysql_get_field("groupHQInteriorPosX", result);
			    groupVariables[x][gGroupInteriorPos][0] = floatstr(result);

			    mysql_get_field("groupHQInteriorPosY", result);
			    groupVariables[x][gGroupInteriorPos][1] = floatstr(result);

			    mysql_get_field("groupHQInteriorPosZ", result);
			    groupVariables[x][gGroupInteriorPos][2] = floatstr(result);

			    mysql_get_field("groupHQInteriorID", result);
			    groupVariables[x][gGroupHQInteriorID] = strval(result);

			    mysql_get_field("groupHQLockStatus", result);
			    groupVariables[x][gGroupHQLockStatus] = strval(result);

			    mysql_get_field("groupSafeMoney", result);
			    groupVariables[x][gSafe][0] = strval(result);

			    mysql_get_field("groupSafeMats", result);
			    groupVariables[x][gSafe][1] = strval(result);

			    mysql_get_field("groupSafeDroga", result);
			    groupVariables[x][gSafe][2] = strval(result);

			    mysql_get_field("groupSafeMerce", result);
			    groupVariables[x][gSafe][3] = strval(result);

			    mysql_get_field("groupSafePosX", result);
			    groupVariables[x][gSafePos][0] = floatstr(result);

			    mysql_get_field("groupSafePosY", result);
			    groupVariables[x][gSafePos][1] = floatstr(result);

			    mysql_get_field("groupSafePosZ", result);
			    groupVariables[x][gSafePos][2] = floatstr(result);

			  /*  mysql_get_field("groupSafePot", result);
			    groupVariables[x][gSafe][2] = strval(result);

			    mysql_get_field("groupSafeCocaine", result);
			    groupVariables[x][gSafe][3] = strval(result); Drugs are out for now. */

			    mysql_get_field("groupMOTD", groupVariables[x][gGroupMOTD]);

			    mysql_get_field("groupRankName1", groupVariables[x][gGroupRankName1]);
			    mysql_get_field("groupRankName2", groupVariables[x][gGroupRankName2]);
			    mysql_get_field("groupRankName3", groupVariables[x][gGroupRankName3]);
			    mysql_get_field("groupRankName4", groupVariables[x][gGroupRankName4]);
			    mysql_get_field("groupRankName5", groupVariables[x][gGroupRankName5]);
			    mysql_get_field("groupRankName6", groupVariables[x][gGroupRankName6]);
		     	mysql_get_field("groupRankName7", groupVariables[x][gGroupRankName7]);
		      	mysql_get_field("groupRankName8", groupVariables[x][gGroupRankName8]);
			    mysql_get_field("groupRankName9", groupVariables[x][gGroupRankName9]);
   				mysql_get_field("groupRankName10", groupVariables[x][gGroupRankName10]);
       			mysql_get_field("groupRankName11", groupVariables[x][gGroupRankName11]);
          		mysql_get_field("groupRankName12", groupVariables[x][gGroupRankName12]);

				switch(groupVariables[x][gGroupHQLockStatus]) {
			    	case 0: format(labelString, sizeof(labelString), "%s\n\nPremi ~k~~VEHICLE_ENTER_EXIT~ per entrare.", groupVariables[x][gGroupName]);
			    	case 1: format(labelString, sizeof(labelString), "%s\n\n(Chiuso)", groupVariables[x][gGroupName]);
			    }

				groupVariables[x][gGroupPickupID] = CreateDynamicPickup(1239, 23, groupVariables[x][gGroupExteriorPos][0], groupVariables[x][gGroupExteriorPos][1], groupVariables[x][gGroupExteriorPos][2], 0, -1, -1, 10);
				groupVariables[x][gGroupLabelID] = CreateDynamic3DTextLabel(labelString, COLOR_DARKYELLOW, groupVariables[x][gGroupExteriorPos][0], groupVariables[x][gGroupExteriorPos][1], groupVariables[x][gGroupExteriorPos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 2.0);

				format(labelString, sizeof(labelString), "%s\nGroup Safe", groupVariables[x][gGroupName]);

				groupVariables[x][gSafePickupID] = CreateDynamicPickup(1239, 23, groupVariables[x][gSafePos][0], groupVariables[x][gSafePos][1], groupVariables[x][gSafePos][2], GROUP_VIRTUAL_WORLD+x, groupVariables[x][gGroupHQInteriorID], -1, 10);
				groupVariables[x][gSafeLabelID] = CreateDynamic3DTextLabel(labelString, COLOR_DARKYELLOW, groupVariables[x][gSafePos][0], groupVariables[x][gSafePos][1], groupVariables[x][gSafePos][2], 100, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, GROUP_VIRTUAL_WORLD+x, groupVariables[x][gGroupHQInteriorID], -1, 2.0);
			}

		    mysql_free_result();
		}
		case THREAD_INITIATE_ASSETS: {
			mysql_store_result();

			new
			    x;

			while(mysql_retrieve_row()) {
			    mysql_get_field("assetID", result);
			    x = strval(result);

			    mysql_get_field("assetValue", result);
			    assetVariables[x][aAssetValue] = strval(result);

			    mysql_get_field("assetName", assetVariables[x][aAssetName]);
			}

			mysql_free_result();
		}
	}

	return 1;
}
Reply
#2

Update
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)