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.
but nothing was been fix'd for me.
Код 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;
}