stock SQL_RegisterAccount(name[], password[]) // Emmet
{
new query[256];
format(query, sizeof(query), "INSERT INTO `Accounts` (`Username`, `Password`) VALUES('%s', '%s')", name, password);
db_query(AccountDB, query);
return 1;
}
if(dialogid == 2) //REGISTER
{
if(gPlayerLogged[playerid] == 1)
{
ClearChatbox(playerid, 100);
SendClientMessage(playerid, COLOR_WHITE, "SERVER: You are already logged in.");
return 1;
}
if(response)
{
if(strlen(inputtext) >= 50)
{
DisplayDialogForPlayer(playerid, 2); //register
ClearChatbox(playerid, 100);
SendClientMessage(playerid, COLOR_WHITE, "SERVER: Password is too long.");
return 0;
}
new sendername[MAX_PLAYER_NAME];
GetPlayerName(playerid, sendername, sizeof(sendername));
new namestring = strfind(sendername, "_", true);
if(namestring == -1)
{
SendClientMessage(playerid, COLOR_YELLOW, "Your name must be in the Firstname_Lastname format - Please re-log with a name such as John_Smith");
SetTimerEx("GettingKicked", 2000, false, "i", playerid);
//ShowPlayerDialog(playerid,CNAME_DIALOG,DIALOG_STYLE_INPUT, "RP Name-change.", "Please input a RP name with the Firstname_Lastname format", "Okay", "Cancel");
return 1;
}
else
{
if(!strlen(inputtext))
{
DisplayDialogForPlayer(playerid, 2); //register
SendClientMessage(playerid, COLOR_WHITE, "SERVER: You must enter a password.");
return 1;
}
if (SQL_AccountExists(sendername))
{
SendClientMessage(playerid, COLOR_YELLOW, "That name is already taken, please choose a different one.");
return 1;
}
new tmppass[64];
strmid(tmppass, inputtext, 0, strlen(inputtext), 255);
//PlayAudioStreamForPlayer(playerid,"https://dl.dropboxusercontent.com/u/54373498/Ye%20Scallywag.mp3");
PlayAudioStreamForPlayer(playerid,"https://dl.dropboxusercontent.com/u/54373498/Jay%20Rock%20%26quot%3BHood%20Gone%20Love%20It%26quot%3B%20Music%20Video.mp3");
ClearChatbox(playerid, 100);
//FadeColorForPlayer(playerid,0,0,0,255,0,0,0,0,15,0);
OnPlayerRegister(playerid,tmppass);
OnPlayerLogin(playerid,tmppass);
//SendClientMessage(playerid, COLOR_YELLOW, "Account registered, you have been logged in automatically.");
}
}
else
{
DisplayDialogForPlayer(playerid, 2); //register
}
}
if(dialogid == 1) //LOGIN
{
if(gPlayerLogged[playerid] == 1)
{
SendClientMessage(playerid, COLOR_WHITE, "SERVER: You are already logged in.");
return 1;
}
if(response)
{
if(!strlen(inputtext))
{
ClearChatbox(playerid, 100);
DisplayDialogForPlayer(playerid, 1); //login
SendClientMessage(playerid, COLOR_WHITE, "SERVER: You must enter a password.");
return 1;
}
if(strlen(inputtext) >= 50)
{
ClearChatbox(playerid, 100);
DisplayDialogForPlayer(playerid, 1); //login
SendClientMessage(playerid, COLOR_WHITE, "SERVER: Password is too long.");
return 0;
}
new tmppass[64];
//Store Player ID & TMP pass in echo to find string used to crash server
new playername[MAX_PLAYER_NAME];
strmid(tmppass, inputtext, 0, strlen(inputtext), 255);
GetPlayerName(playerid, playername, sizeof(playername));
//FadeColorForPlayer(playerid,0,0,0,0,0,0,0,255,15,0);
if(strlen(playername) == 3)
{
SendClientMessage(playerid, COLOR_LIGHTRED, "Sorry, that name is too short, please change it.");
SetTimerEx("GettingKicked", 2000, false, "i", playerid);
return 1;
}
OnPlayerLogin(playerid,tmppass);
}
else
{
DisplayDialogForPlayer(playerid, 1); //login
}
}
stock OnPlayerLogin(playerid, password[])
{
new
data[256],
string[128],
playername[24],
DBResult:result;
GetPlayerName(playerid, playername, sizeof(playername));
if (!gPlayerLogged[playerid])
{
Encrypt(password);
format(string, sizeof(string), "SELECT * FROM `Accounts` WHERE `Username` = '%s' AND `Password` = '%s'", playername, password);
result = db_query(AccountDB, string);
if (db_num_rows(result) != 0)
{
format(PlayerInfo[playerid][pKey], 128, password);
db_get_field_assoc(result, "Level", data, sizeof(data)); PlayerInfo[playerid][pLevel] = strval(data);
db_get_field_assoc(result, "AdminLevel", data, sizeof(data)); PlayerInfo[playerid][pAdmin] = strval(data);
db_get_field_assoc(result, "Band", data, sizeof(data)); PlayerInfo[playerid][pBand] = strval(data);
db_get_field_assoc(result, "PermaBand", data, sizeof(data)); PlayerInfo[playerid][pPermBand] = strval(data);
db_get_field_assoc(result, "Warnings", data, sizeof(data)); PlayerInfo[playerid][pWarns] = strval(data);
db_get_field_assoc(result, "TruckerCooldown", data, sizeof(data)); PlayerInfo[playerid][pTruckerCooldown] = strval(data);
db_get_field_assoc(result, "Disabled", data, sizeof(data)); PlayerInfo[playerid][pDisabled] = strval(data);
db_get_field_assoc(result, "DonateRank", data, sizeof(data)); PlayerInfo[playerid][pDonateRank] = strval(data);
db_get_field_assoc(result, "ATMExterior", data, sizeof(data)); PlayerInfo[playerid][ATMExterior] = strval(data);
db_get_field_assoc(result, "ATMID", data, sizeof(data)); PlayerInfo[playerid][ATMID] = strval(data);
db_get_field_assoc(result, "MAPBExterior", data, sizeof(data)); PlayerInfo[playerid][MAPBExterior] = strval(data);
db_get_field_assoc(result, "GSTATIONExterior", data, sizeof(data)); PlayerInfo[playerid][GSTATIONExterior] = strval(data);
db_get_field_assoc(result, "HSSignExterior", data, sizeof(data)); PlayerInfo[playerid][HSSignExterior] = strval(data);
db_get_field_assoc(result, "MAPBID", data, sizeof(data)); PlayerInfo[playerid][MAPBID] = strval(data);
db_get_field_assoc(result, "GSTATIONID", data, sizeof(data)); PlayerInfo[playerid][GSTATIONID] = strval(data);
db_get_field_assoc(result, "HSSignID", data, sizeof(data)); PlayerInfo[playerid][HSSignID] = strval(data);
db_get_field_assoc(result, "VIPJoinDate", data, sizeof(data)); strmid(PlayerInfo[playerid][pVIPJoinDate], data, 0, strlen(data), 255);
db_get_field_assoc(result, "VIPExpDate", data, sizeof(data)); strmid(PlayerInfo[playerid][pVIPExpDate], data, 0, strlen(data), 255);
db_get_field_assoc(result, "FactionBanned", data, sizeof(data)); PlayerInfo[playerid][pFactionBanned] = strval(data);
db_get_field_assoc(result, "LaserOwner", data, sizeof(data)); PlayerInfo[playerid][pLaserOwner] = strval(data);
db_get_field_assoc(result, "BanAppealer", data, sizeof(data)); PlayerInfo[playerid][pBanAppealer] = strval(data);
db_get_field_assoc(result, "FCard", data, sizeof(data)); PlayerInfo[playerid][pFcard] = strval(data);
db_get_field_assoc(result, "dExtX", data, sizeof(data)); PlayerInfo[playerid][dExtX] = floatstr(data);
db_get_field_assoc(result, "dExtY", data, sizeof(data)); PlayerInfo[playerid][dExtY] = floatstr(data);
db_get_field_assoc(result, "dExtZ", data, sizeof(data)); PlayerInfo[playerid][dExtZ] = floatstr(data);
db_get_field_assoc(result, "GangMod", data, sizeof(data)); PlayerInfo[playerid][pGangMod] = strval(data);
db_get_field_assoc(result, "Famed", data, sizeof(data)); PlayerInfo[playerid][pFamed] = strval(data);
db_get_field_assoc(result, "FactionMod", data, sizeof(data)); PlayerInfo[playerid][pFactionMod] = strval(data);
db_get_field_assoc(result, "UpgradePoints", data, sizeof(data)); PlayerInfo[playerid][gPupgrade] = strval(data);
db_get_field_assoc(result, "ConnectedTime", data, sizeof(data)); PlayerInfo[playerid][pConnectTime] = strval(data);
db_get_field_assoc(result, "Registered", data, sizeof(data)); PlayerInfo[playerid][pReg] = strval(data);
db_get_field_assoc(result, "Sex", data, sizeof(data)); PlayerInfo[playerid][pSex] = strval(data);
db_get_field_assoc(result, "House", data, sizeof(data)); PlayerInfo[playerid][pPhousekey] = strval(data);
db_get_field_assoc(result, "InGarage", data, sizeof(data)); PlayerInfo[playerid][InGarage] = strval(data);
db_get_field_assoc(result, "HouseExterior", data, sizeof(data)); PlayerInfo[playerid][HouseExterior] = strval(data);
db_get_field_assoc(result, "HouseInterior", data, sizeof(data)); PlayerInfo[playerid][HouseInterior] = strval(data);
db_get_field_assoc(result, "hIntID", data, sizeof(data)); PlayerInfo[playerid][hIntID] = strval(data);
db_get_field_assoc(result, "CarTime", data, sizeof(data)); PlayerInfo[playerid][pCarTime] = strval(data);
db_get_field_assoc(result, "Developer", data, sizeof(data)); PlayerInfo[playerid][pDeveloper] = strval(data);
db_get_field_assoc(result, "Mapper", data, sizeof(data)); PlayerInfo[playerid][pMapper] = strval(data);
db_get_field_assoc(result, "Division", data, sizeof(data)); PlayerInfo[playerid][pDivision] = strval(data);
db_get_field_assoc(result, "Tester", data, sizeof(data)); PlayerInfo[playerid][pTester] = strval(data);
db_get_field_assoc(result, "hExtID", data, sizeof(data)); PlayerInfo[playerid][hExtID] = strval(data);
db_get_field_assoc(result, "hExtX", data, sizeof(data)); PlayerInfo[playerid][hExtX] = floatstr(data);
db_get_field_assoc(result, "hExtY", data, sizeof(data)); PlayerInfo[playerid][hExtY] = floatstr(data);
db_get_field_assoc(result, "hExtZ", data, sizeof(data)); PlayerInfo[playerid][hExtZ] = floatstr(data);
db_get_field_assoc(result, "hIntX", data, sizeof(data)); PlayerInfo[playerid][hIntX] = floatstr(data);
db_get_field_assoc(result, "hIntY", data, sizeof(data)); PlayerInfo[playerid][hIntY] = floatstr(data);
db_get_field_assoc(result, "hIntZ", data, sizeof(data)); PlayerInfo[playerid][hIntZ] = floatstr(data);
db_get_field_assoc(result, "Inbuilding", data, sizeof(data)); PlayerInfo[playerid][Inbuilding] = strval(data);
db_get_field_assoc(result, "buildingExterior", data, sizeof(data)); PlayerInfo[playerid][buildingExterior] = strval(data);
db_get_field_assoc(result, "buildingInterior", data, sizeof(data)); PlayerInfo[playerid][buildingInterior] = strval(data);
db_get_field_assoc(result, "cIntID", data, sizeof(data)); PlayerInfo[playerid][cIntID] = strval(data);
db_get_field_assoc(result, "cIntID", data, sizeof(data)); PlayerInfo[playerid][cIntID] = strval(data);
db_get_field_assoc(result, "cExtX", data, sizeof(data)); PlayerInfo[playerid][cExtX] = floatstr(data);
db_get_field_assoc(result, "cExtY", data, sizeof(data)); PlayerInfo[playerid][cExtY] = floatstr(data);
db_get_field_assoc(result, "cExtZ", data, sizeof(data)); PlayerInfo[playerid][cExtZ] = floatstr(data);
db_get_field_assoc(result, "Inmotel", data, sizeof(data)); PlayerInfo[playerid][Inmotel] = strval(data);
db_get_field_assoc(result, "motelExterior", data, sizeof(data)); PlayerInfo[playerid][motelExterior] = strval(data);
db_get_field_assoc(result, "motelInterior", data, sizeof(data)); PlayerInfo[playerid][motelInterior] = strval(data);
db_get_field_assoc(result, "mIntID", data, sizeof(data)); PlayerInfo[playerid][mIntID] = strval(data);
db_get_field_assoc(result, "mIntID", data, sizeof(data)); PlayerInfo[playerid][mIntID] = strval(data);
db_get_field_assoc(result, "mExtX", data, sizeof(data)); PlayerInfo[playerid][mExtX] = floatstr(data);
db_get_field_assoc(result, "mExtY", data, sizeof(data)); PlayerInfo[playerid][mExtY] = floatstr(data);
db_get_field_assoc(result, "mExtZ", data, sizeof(data)); PlayerInfo[playerid][mExtZ] = floatstr(data);
db_get_field_assoc(result, "mIntX", data, sizeof(data)); PlayerInfo[playerid][mIntX] = floatstr(data);
db_get_field_assoc(result, "mIntY", data, sizeof(data)); PlayerInfo[playerid][mIntY] = floatstr(data);
db_get_field_assoc(result, "mIntZ", data, sizeof(data)); PlayerInfo[playerid][mIntZ] = floatstr(data);
db_get_field_assoc(result, "cIntX", data, sizeof(data)); PlayerInfo[playerid][cIntX] = floatstr(data);
db_get_field_assoc(result, "cIntY", data, sizeof(data)); PlayerInfo[playerid][cIntY] = floatstr(data);
db_get_field_assoc(result, "cIntZ", data, sizeof(data)); PlayerInfo[playerid][cIntZ] = floatstr(data);
db_get_field_assoc(result, "BriefCase", data, sizeof(data)); PlayerInfo[playerid][pBriefCase] = strval(data);
db_get_field_assoc(result, "BCash", data, sizeof(data)); PlayerInfo[playerid][pBCash] = strval(data);
db_get_field_assoc(result, "BCrack", data, sizeof(data)); PlayerInfo[playerid][pBCrack] = strval(data);
db_get_field_assoc(result, "BPot", data, sizeof(data)); PlayerInfo[playerid][pBPot] = strval(data);
db_get_field_assoc(result, "TrashSkill", data, sizeof(data)); PlayerInfo[playerid][pTrashSkill] = strval(data); // Trashman
db_get_field_assoc(result, "Debarrel", data, sizeof(data)); PlayerInfo[playerid][pDebarrel] = strval(data);
db_get_field_assoc(result, "AKbarrel", data, sizeof(data)); PlayerInfo[playerid][pAKbarrel] = strval(data);
db_get_field_assoc(result, "CSGbarrel", data, sizeof(data)); PlayerInfo[playerid][pCSGbarrel] = strval(data);
db_get_field_assoc(result, "Destock", data, sizeof(data)); PlayerInfo[playerid][pDestock] = strval(data);
db_get_field_assoc(result, "AKstock", data, sizeof(data)); PlayerInfo[playerid][pAKstock] = strval(data);
db_get_field_assoc(result, "CSGstock", data, sizeof(data)); PlayerInfo[playerid][pCSGstock] = strval(data);
db_get_field_assoc(result, "PlayerVehicleModel1", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicleModel1] = strval(data);
db_get_field_assoc(result, "PlayerVehicleFacing1", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicleFacing1] = floatstr(data);
db_get_field_assoc(result, "PlayerVehicle1Color", data, sizeof(data)); PlayerInfo[playerid][pPlayerVehicle1Color] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1Color2", data, sizeof(data)); PlayerInfo[playerid][pPlayerVehicle1Color2] = strval(data);
db_get_field_assoc(result, "PlayerVehiclePosX1", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosX1] = floatstr(data);
db_get_field_assoc(result, "PlayerVehiclePosY1", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosY1] = floatstr(data);
db_get_field_assoc(result, "PlayerVehiclePosZ1", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosZ1] = floatstr(data);
db_get_field_assoc(result, "PlayerVehicle1PaintJob", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1PaintJob] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1Nos", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1Nos] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot0", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot0] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot1", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot1] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot2", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot2] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot3", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot3] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot4", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot4] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot5", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot5] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot6", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot6] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot7", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot7] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot8", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot8] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot9", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot9] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot10", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot10] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot11", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot11] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot12", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot12] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1ModSlot13", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1ModSlot13] = strval(data);
db_get_field_assoc(result, "VehLock1", data, sizeof(data)); PlayerInfo[playerid][pVehLock1] = strval(data);
db_get_field_assoc(result, "VehLocked1", data, sizeof(data)); PlayerInfo[playerid][pVehLocked1] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1VirWorld", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1VirWorld] = strval(data);
db_get_field_assoc(result, "PlayerVehicle1Interior", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle1Interior] = strval(data);
db_get_field_assoc(result, "PlayerVehicleModel2", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicleModel2] = strval(data);
db_get_field_assoc(result, "PlayerVehicleFacing2", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicleFacing2] = floatstr(data);
db_get_field_assoc(result, "PlayerVehicle2Color", data, sizeof(data)); PlayerInfo[playerid][pPlayerVehicle2Color] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2Color2", data, sizeof(data)); PlayerInfo[playerid][pPlayerVehicle2Color2] = strval(data);
db_get_field_assoc(result, "PlayerVehiclePosX2", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosX2] = floatstr(data);
db_get_field_assoc(result, "PlayerVehiclePosY2", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosY2] = floatstr(data);
db_get_field_assoc(result, "PlayerVehiclePosZ2", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosZ2] = floatstr(data);
db_get_field_assoc(result, "PlayerVehicle2PaintJob", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2PaintJob] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2Nos", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2Nos] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot0", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot0] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot1", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot1] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot2", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot2] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot3", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot3] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot4", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot4] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot5", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot5] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot6", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot6] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot7", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot7] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot8", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot8] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot9", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot9] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot10", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot10] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot11", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot11] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot12", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot12] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2ModSlot13", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2ModSlot13] = strval(data);
db_get_field_assoc(result, "VehLock2", data, sizeof(data)); PlayerInfo[playerid][pVehLock2] = strval(data);
db_get_field_assoc(result, "VehLocked2", data, sizeof(data)); PlayerInfo[playerid][pVehLocked2] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2VirWorld", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2VirWorld] = strval(data);
db_get_field_assoc(result, "PlayerVehicle2Interior", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle2Interior] = strval(data);
db_get_field_assoc(result, "PlayerVehicleModel3", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicleModel3] = strval(data);
db_get_field_assoc(result, "PlayerVehicleFacing3", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicleFacing3] = floatstr(data);
db_get_field_assoc(result, "PlayerVehicle3Color", data, sizeof(data)); PlayerInfo[playerid][pPlayerVehicle3Color] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3Color2", data, sizeof(data)); PlayerInfo[playerid][pPlayerVehicle3Color2] = strval(data);
db_get_field_assoc(result, "PlayerVehiclePosX3", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosX3] = floatstr(data);
db_get_field_assoc(result, "PlayerVehiclePosY3", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosY3] = floatstr(data);
db_get_field_assoc(result, "PlayerVehiclePosZ3", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosZ3] = floatstr(data);
db_get_field_assoc(result, "PlayerVehicle3PaintJob", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3PaintJob] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3Nos", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3Nos] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot0", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot0] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot1", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot1] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot2", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot2] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot3", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot3] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot4", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot4] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot5", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot5] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot6", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot6] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot7", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot7] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot8", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot8] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot9", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot9] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot10", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot10] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot11", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot11] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot12", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot12] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3ModSlot13", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3ModSlot13] = strval(data);
db_get_field_assoc(result, "VehLock3", data, sizeof(data)); PlayerInfo[playerid][pVehLock3] = strval(data);
db_get_field_assoc(result, "VehLocked3", data, sizeof(data)); PlayerInfo[playerid][pVehLocked3] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3VirWorld", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3VirWorld] = strval(data);
db_get_field_assoc(result, "PlayerVehicle3Interior", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle3Interior] = strval(data);
db_get_field_assoc(result, "PlayerVehicleModel4", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicleModel4] = strval(data);
db_get_field_assoc(result, "PlayerVehicleFacing4", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicleFacing4] = floatstr(data);
db_get_field_assoc(result, "PlayerVehicle4Color", data, sizeof(data)); PlayerInfo[playerid][pPlayerVehicle4Color] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4Color2", data, sizeof(data)); PlayerInfo[playerid][pPlayerVehicle4Color2] = strval(data);
db_get_field_assoc(result, "PlayerVehiclePosX4", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosX4] = floatstr(data);
db_get_field_assoc(result, "PlayerVehiclePosY4", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosY4] = floatstr(data);
db_get_field_assoc(result, "PlayerVehiclePosZ4", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosZ4] = floatstr(data);
db_get_field_assoc(result, "PlayerVehicle4PaintJob", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4PaintJob] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4Nos", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4Nos] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot0", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot0] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot1", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot1] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot2", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot2] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot3", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot3] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot4", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot4] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot5", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot5] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot6", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot6] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot7", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot7] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot8", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot8] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot9", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot9] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot10", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot10] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot11", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot11] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot12", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot12] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4ModSlot13", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4ModSlot13] = strval(data);
db_get_field_assoc(result, "VehLock4", data, sizeof(data)); PlayerInfo[playerid][pVehLock4] = strval(data);
db_get_field_assoc(result, "VehLocked4", data, sizeof(data)); PlayerInfo[playerid][pVehLocked4] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4VirWorld", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4VirWorld] = strval(data);
db_get_field_assoc(result, "PlayerVehicle4Interior", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle4Interior] = strval(data);
db_get_field_assoc(result, "PlayerVehicleModel5", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicleModel5] = strval(data);
db_get_field_assoc(result, "PlayerVehicleFacing5", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicleFacing5] = floatstr(data);
db_get_field_assoc(result, "PlayerVehicle5Color", data, sizeof(data)); PlayerInfo[playerid][pPlayerVehicle5Color] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5Color2", data, sizeof(data)); PlayerInfo[playerid][pPlayerVehicle5Color2] = strval(data);
db_get_field_assoc(result, "PlayerVehiclePosX5", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosX5] = floatstr(data);
db_get_field_assoc(result, "PlayerVehiclePosY5", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosY5] = floatstr(data);
db_get_field_assoc(result, "PlayerVehiclePosZ5", data, sizeof(data)); PlayerInfo[playerid][PlayerVehiclePosZ5] = floatstr(data);
db_get_field_assoc(result, "PlayerVehicle5PaintJob", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5PaintJob] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5Nos", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5Nos] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot0", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot0] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot1", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot1] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot2", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot2] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot3", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot3] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot4", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot4] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot5", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot5] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot6", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot6] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot7", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot7] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot8", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot8] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot9", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot9] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot10", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot10] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot11", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot11] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot12", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot12] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5ModSlot13", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5ModSlot13] = strval(data);
db_get_field_assoc(result, "VehLock5", data, sizeof(data)); PlayerInfo[playerid][pVehLock5] = strval(data);
db_get_field_assoc(result, "VehLocked5", data, sizeof(data)); PlayerInfo[playerid][pVehLocked5] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5VirWorld", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5VirWorld] = strval(data);
db_get_field_assoc(result, "PlayerVehicle5Interior", data, sizeof(data)); PlayerInfo[playerid][PlayerVehicle5Interior] = strval(data);
db_get_field_assoc(result, "Age", data, sizeof(data)); PlayerInfo[playerid][pAge] = strval(data);
db_get_field_assoc(result, "RPBoost", data, sizeof(data)); PlayerInfo[playerid][pRPBoost] = strval(data);
db_get_field_assoc(result, "Origin", data, sizeof(data)); PlayerInfo[playerid][pOrigin] = strval(data);
db_get_field_assoc(result, "Muted", data, sizeof(data)); PlayerInfo[playerid][pMuted] = strval(data);
db_get_field_assoc(result, "Respect", data, sizeof(data)); PlayerInfo[playerid][pExp] = strval(data);
db_get_field_assoc(result, "Money", data, sizeof(data)); PlayerInfo[playerid][pCash] = strval(data);
db_get_field_assoc(result, "CasinoWinnings", data, sizeof(data)); PlayerInfo[playerid][pCasinoWinnings] = strval(data);
db_get_field_assoc(result, "Bank", data, sizeof(data)); PlayerInfo[playerid][pAccount] = strval(data);
db_get_field_assoc(result, "Crimes", data, sizeof(data)); PlayerInfo[playerid][pCrimes] = strval(data);
db_get_field_assoc(result, "Accent", data, sizeof(data)); strmid(Accent[playerid], data, 0, strlen(data), 255);
db_get_field_assoc(result, "Kills", data, sizeof(data)); PlayerInfo[playerid][pKills] = strval(data);
db_get_field_assoc(result, "Deaths", data, sizeof(data)); PlayerInfo[playerid][pDeaths] = strval(data);
db_get_field_assoc(result, "CHits", data, sizeof(data)); PlayerInfo[playerid][pCHits] = strval(data);
db_get_field_assoc(result, "FHits", data, sizeof(data)); PlayerInfo[playerid][pFHits] = strval(data);
db_get_field_assoc(result, "Arrested", data, sizeof(data)); PlayerInfo[playerid][pArrested] = strval(data);
db_get_field_assoc(result, "Phonebook", data, sizeof(data)); PlayerInfo[playerid][pPhoneBook] = strval(data);
db_get_field_assoc(result, "HouseTicket", data, sizeof(data)); PlayerInfo[playerid][pHouseTicket] = strval(data);
db_get_field_assoc(result, "BusinessTicket", data, sizeof(data)); PlayerInfo[playerid][pBusinessTicket] = strval(data);
db_get_field_assoc(result, "VehicleTicket", data, sizeof(data)); PlayerInfo[playerid][pVehicleTicket] = strval(data);
db_get_field_assoc(result, "GateTicket", data, sizeof(data)); PlayerInfo[playerid][pGateTicket] = strval(data);
db_get_field_assoc(result, "GarageTicket", data, sizeof(data)); PlayerInfo[playerid][pGarageTicket] = strval(data);
db_get_field_assoc(result, "BoomBox", data, sizeof(data)); PlayerInfo[playerid][pBoomBox] = strval(data);
db_get_field_assoc(result, "LottoNr", data, sizeof(data)); PlayerInfo[playerid][pLottoNr] = strval(data);
db_get_field_assoc(result, "Fishes", data, sizeof(data)); PlayerInfo[playerid][pFishes] = strval(data);
db_get_field_assoc(result, "BiggestFish", data, sizeof(data)); PlayerInfo[playerid][pBiggestFish] = strval(data);
db_get_field_assoc(result, "Job", data, sizeof(data)); PlayerInfo[playerid][pJob] = strval(data);
db_get_field_assoc(result, "Job2", data, sizeof(data)); PlayerInfo[playerid][pJob2] = strval(data);
db_get_field_assoc(result, "Paycheck", data, sizeof(data)); PlayerInfo[playerid][pPayCheck] = strval(data);
db_get_field_assoc(result, "HeadValue", data, sizeof(data)); PlayerInfo[playerid][pHeadValue] = strval(data);
db_get_field_assoc(result, "BHHeadValue", data, sizeof(data)); PlayerInfo[playerid][pBHHeadValue] = strval(data);
db_get_field_assoc(result, "Jailed", data, sizeof(data)); PlayerInfo[playerid][pJailed] = strval(data);
db_get_field_assoc(result, "JailedReason", data, sizeof(data)); strmid(PlayerInfo[playerid][pJailedReason], data, 0, strlen(data), 255);
db_get_field_assoc(result, "JailTime", data, sizeof(data)); PlayerInfo[playerid][pJailTime] = strval(data);
db_get_field_assoc(result, "Gun parts", data, sizeof(data)); PlayerInfo[playerid][pMats] = strval(data);
db_get_field_assoc(result, "Pot", data, sizeof(data)); PlayerInfo[playerid][pPot] = strval(data);
db_get_field_assoc(result, "Paper", data, sizeof(data)); PlayerInfo[playerid][pPaper] = strval(data);
db_get_field_assoc(result, "Bong", data, sizeof(data)); PlayerInfo[playerid][pBong] = strval(data);
db_get_field_assoc(result, "Pipe", data, sizeof(data)); PlayerInfo[playerid][pPipe] = strval(data);
db_get_field_assoc(result, "Crack", data, sizeof(data)); PlayerInfo[playerid][pCrack] = strval(data);
db_get_field_assoc(result, "Leader", data, sizeof(data)); PlayerInfo[playerid][pLeader] = strval(data);
db_get_field_assoc(result, "Member", data, sizeof(data)); PlayerInfo[playerid][pMember] = strval(data);
db_get_field_assoc(result, "FMember", data, sizeof(data)); PlayerInfo[playerid][pFMember] = strval(data);
db_get_field_assoc(result, "Rank", data, sizeof(data)); PlayerInfo[playerid][pRank] = strval(data);
db_get_field_assoc(result, "Bizz", data, sizeof(data)); PlayerInfo[playerid][pPbiskey] = strval(data);
db_get_field_assoc(result, "Garage", data, sizeof(data)); PlayerInfo[playerid][pGarageKey] = strval(data);
db_get_field_assoc(result, "House", data, sizeof(data)); PlayerInfo[playerid][pHouseKey] = strval(data);
db_get_field_assoc(result, "HouseII", data, sizeof(data)); PlayerInfo[playerid][pHouseKey2] = strval(data);
db_get_field_assoc(result, "HouseIII", data, sizeof(data)); PlayerInfo[playerid][pHouseKey3] = strval(data);
db_get_field_assoc(result, "HouseIIII", data, sizeof(data)); PlayerInfo[playerid][pHouseKey4] = strval(data);
db_get_field_assoc(result, "GarageII", data, sizeof(data)); PlayerInfo[playerid][pGarageKey2] = strval(data);
db_get_field_assoc(result, "GateKey", data, sizeof(data)); PlayerInfo[playerid][pGateKey] = strval(data);
db_get_field_assoc(result, "GateKeyIA", data, sizeof(data)); PlayerInfo[playerid][pGateKey2] = strval(data);
db_get_field_assoc(result, "GateKeyIB", data, sizeof(data)); PlayerInfo[playerid][pGateKey3] = strval(data);
db_get_field_assoc(result, "GateKeyIC", data, sizeof(data)); PlayerInfo[playerid][pGateKey4] = strval(data);
db_get_field_assoc(result, "GateKeyID", data, sizeof(data)); PlayerInfo[playerid][pGateKey5] = strval(data);
db_get_field_assoc(result, "GateKeyIE", data, sizeof(data)); PlayerInfo[playerid][pGateKey6] = strval(data);
db_get_field_assoc(result, "GateKeyIF", data, sizeof(data)); PlayerInfo[playerid][pGateKey7] = strval(data);
db_get_field_assoc(result, "GateKeyIG", data, sizeof(data)); PlayerInfo[playerid][pGateKey8] = strval(data);
db_get_field_assoc(result, "GateKeyIH", data, sizeof(data)); PlayerInfo[playerid][pGateKey9] = strval(data);
db_get_field_assoc(result, "GateKeyII", data, sizeof(data)); PlayerInfo[playerid][pGateKey10] = strval(data);
db_get_field_assoc(result, "InBusiness", data, sizeof(data)); PlayerInfo[playerid][InBusiness] = strval(data);
db_get_field_assoc(result, "BusinessExterior", data, sizeof(data)); PlayerInfo[playerid][BusinessExterior] = strval(data);
db_get_field_assoc(result, "BusinessInterior", data, sizeof(data)); PlayerInfo[playerid][BusinessInterior] = strval(data);
db_get_field_assoc(result, "bIntID", data, sizeof(data)); PlayerInfo[playerid][bIntID] = strval(data);
db_get_field_assoc(result, "bIntID", data, sizeof(data)); PlayerInfo[playerid][bIntID] = strval(data);
db_get_field_assoc(result, "bExtX", data, sizeof(data)); PlayerInfo[playerid][bExtX] = floatstr(data);
db_get_field_assoc(result, "bExtY", data, sizeof(data)); PlayerInfo[playerid][bExtY] = floatstr(data);
db_get_field_assoc(result, "bExtZ", data, sizeof(data)); PlayerInfo[playerid][bExtZ] = floatstr(data);
db_get_field_assoc(result, "bIntX", data, sizeof(data)); PlayerInfo[playerid][bIntX] = floatstr(data);
db_get_field_assoc(result, "bIntY", data, sizeof(data)); PlayerInfo[playerid][bIntY] = floatstr(data);
db_get_field_assoc(result, "bIntZ", data, sizeof(data)); PlayerInfo[playerid][bIntZ] = floatstr(data);
db_get_field_assoc(result, "DetSkill", data, sizeof(data)); PlayerInfo[playerid][pDetSkill] = strval(data);
db_get_field_assoc(result, "SexSkill", data, sizeof(data)); PlayerInfo[playerid][pSexSkill] = strval(data);
db_get_field_assoc(result, "BoxSkill", data, sizeof(data)); PlayerInfo[playerid][pBoxSkill] = strval(data);
db_get_field_assoc(result, "LawSkill", data, sizeof(data)); PlayerInfo[playerid][pLawSkill] = strval(data);
db_get_field_assoc(result, "MechSkill", data, sizeof(data)); PlayerInfo[playerid][pMechSkill] = strval(data);
db_get_field_assoc(result, "JackSkill", data, sizeof(data)); PlayerInfo[playerid][pJackSkill] = strval(data);
db_get_field_assoc(result, "CarSkill", data, sizeof(data)); PlayerInfo[playerid][pCarSkill] = strval(data);
db_get_field_assoc(result, "NewsSkill", data, sizeof(data)); PlayerInfo[playerid][pNewsSkill] = strval(data);
db_get_field_assoc(result, "DrugsSkill", data, sizeof(data)); PlayerInfo[playerid][pDrugsSkill] = strval(data);
db_get_field_assoc(result, "ArmsSkill", data, sizeof(data)); PlayerInfo[playerid][pArmsSkill] = strval(data);
db_get_field_assoc(result, "SmugglerSkill", data, sizeof(data)); PlayerInfo[playerid][pSmugglerSkill] = strval(data);
db_get_field_assoc(result, "FishSkill", data, sizeof(data)); PlayerInfo[playerid][pFishSkill] = strval(data);
db_get_field_assoc(result, "FightingStyle", data, sizeof(data)); PlayerInfo[playerid][pFightingStyle] = strval(data);
db_get_field_assoc(result, "pHealth", data, sizeof(data)); PlayerInfo[playerid][pHealth] = floatstr(data);
db_get_field_assoc(result, "pArmor", data, sizeof(data)); PlayerInfo[playerid][pArmor] = floatstr(data);
db_get_field_assoc(result, "pSHealth", data, sizeof(data)); PlayerInfo[playerid][pSHealth] = strval(data);
db_get_field_assoc(result, "Int", data, sizeof(data)); PlayerInfo[playerid][pInt] = strval(data);
db_get_field_assoc(result, "Local", data, sizeof(data)); PlayerInfo[playerid][pLocal] = strval(data);
db_get_field_assoc(result, "VirtualWorld", data, sizeof(data)); PlayerInfo[playerid][pVirtualWorld] = strval(data);
db_get_field_assoc(result, "Model", data, sizeof(data)); PlayerInfo[playerid][pModel] = strval(data);
db_get_field_assoc(result, "Tikis", data, sizeof(data)); PlayerInfo[playerid][pTikis] = strval(data);
db_get_field_assoc(result, "Clothes", data, sizeof(data)); PlayerInfo[playerid][pClothes] = strval(data);
db_get_field_assoc(result, "PhoneNr", data, sizeof(data)); PlayerInfo[playerid][pPnumber] = strval(data);
db_get_field_assoc(result, "Apartment", data, sizeof(data)); PlayerInfo[playerid][pPaptkey] = strval(data);
db_get_field_assoc(result, "ATMcard", data, sizeof(data)); PlayerInfo[playerid][pATMcard] = strval(data);
db_get_field_assoc(result, "GreenCard", data, sizeof(data)); PlayerInfo[playerid][pGreenCard] = strval(data);
db_get_field_assoc(result, "SocialNumber", data, sizeof(data)); PlayerInfo[playerid][pSocialNumber] = strval(data);
db_get_field_assoc(result, "CarLic", data, sizeof(data)); PlayerInfo[playerid][pCarLic] = strval(data);
db_get_field_assoc(result, "FlyLic", data, sizeof(data)); PlayerInfo[playerid][pFlyLic] = strval(data);
db_get_field_assoc(result, "BoatLic", data, sizeof(data)); PlayerInfo[playerid][pBoatLic] = strval(data);
db_get_field_assoc(result, "FishLic", data, sizeof(data)); PlayerInfo[playerid][pFishLic] = strval(data);
db_get_field_assoc(result, "GunLic", data, sizeof(data)); PlayerInfo[playerid][pGunLic] = strval(data);
db_get_field_assoc(result, "Gun0", data, sizeof(data)); PlayerInfo[playerid][pGun0] = strval(data);
db_get_field_assoc(result, "Gun1", data, sizeof(data)); PlayerInfo[playerid][pGun1] = strval(data);
db_get_field_assoc(result, "Gun2", data, sizeof(data)); PlayerInfo[playerid][pGun2] = strval(data);
db_get_field_assoc(result, "Gun3", data, sizeof(data)); PlayerInfo[playerid][pGun3] = strval(data);
db_get_field_assoc(result, "Gun4", data, sizeof(data)); PlayerInfo[playerid][pGun4] = strval(data);
db_get_field_assoc(result, "Gun5", data, sizeof(data)); PlayerInfo[playerid][pGun5] = strval(data);
db_get_field_assoc(result, "Gun6", data, sizeof(data)); PlayerInfo[playerid][pGun6] = strval(data);
db_get_field_assoc(result, "Gun7", data, sizeof(data)); PlayerInfo[playerid][pGun7] = strval(data);
db_get_field_assoc(result, "Gun8", data, sizeof(data)); PlayerInfo[playerid][pGun8] = strval(data);
db_get_field_assoc(result, "Gun9", data, sizeof(data)); PlayerInfo[playerid][pGun9] = strval(data);
db_get_field_assoc(result, "Gun10", data, sizeof(data)); PlayerInfo[playerid][pGun10] = strval(data);
db_get_field_assoc(result, "Gun11", data, sizeof(data)); PlayerInfo[playerid][pGun11] = strval(data);
db_get_field_assoc(result, "Gun12", data, sizeof(data)); PlayerInfo[playerid][pGun12] = strval(data);
db_get_field_assoc(result, "CarTime", data, sizeof(data)); PlayerInfo[playerid][pCarTime] = strval(data);
db_get_field_assoc(result, "DrugsTime", data, sizeof(data)); PlayerInfo[playerid][pDrugsTime] = strval(data);
db_get_field_assoc(result, "LawyerTime", data, sizeof(data)); PlayerInfo[playerid][pLawyerTime] = strval(data);
db_get_field_assoc(result, "LawyerFreeTime", data, sizeof(data)); PlayerInfo[playerid][pLawyerFreeTime] = strval(data);
db_get_field_assoc(result, "MechTime", data, sizeof(data)); PlayerInfo[playerid][pMechTime] = strval(data);
db_get_field_assoc(result, "SexTime", data, sizeof(data)); PlayerInfo[playerid][pSexTime] = strval(data);
db_get_field_assoc(result, "PayDay", data, sizeof(data)); PlayerInfo[playerid][pPayDay] = strval(data);
db_get_field_assoc(result, "PayDayHad", data, sizeof(data)); PlayerInfo[playerid][pPayDayHad] = strval(data);
db_get_field_assoc(result, "CDPlayer", data, sizeof(data)); PlayerInfo[playerid][pCDPlayer] = strval(data);
db_get_field_assoc(result, "Dice", data, sizeof(data)); PlayerInfo[playerid][pDice] = strval(data);
db_get_field_assoc(result, "Screw", data, sizeof(data)); PlayerInfo[playerid][pScrew] = strval(data);
db_get_field_assoc(result, "Rope", data, sizeof(data)); PlayerInfo[playerid][pRope] = strval(data);
db_get_field_assoc(result, "Demagazine", data, sizeof(data)); PlayerInfo[playerid][pDemagazine] = strval(data);
db_get_field_assoc(result, "CSGmagazine", data, sizeof(data)); PlayerInfo[playerid][pCSGmagazine] = strval(data);
db_get_field_assoc(result, "AKmazagine", data, sizeof(data)); PlayerInfo[playerid][pAKmagazine] = strval(data);
db_get_field_assoc(result, "Cigars", data, sizeof(data)); PlayerInfo[playerid][pCigars] = strval(data);
db_get_field_assoc(result, "GoldBars", data, sizeof(data)); PlayerInfo[playerid][pGoldBars] = strval(data);
db_get_field_assoc(result, "Sprunk", data, sizeof(data)); PlayerInfo[playerid][pSprunk] = strval(data);
db_get_field_assoc(result, "WT", data, sizeof(data)); PlayerInfo[playerid][pWT] = strval(data);
db_get_field_assoc(result, "WTc", data, sizeof(data)); PlayerInfo[playerid][pWTc] = strval(data);
db_get_field_assoc(result, "Bombs", data, sizeof(data)); PlayerInfo[playerid][pBombs] = strval(data);
db_get_field_assoc(result, "Scope", data, sizeof(data)); PlayerInfo[playerid][pScope] = strval(data);
db_get_field_assoc(result, "OwnsMask", data, sizeof(data)); PlayerInfo[playerid][pOwnsMask] = strval(data);
db_get_field_assoc(result, "Wins", data, sizeof(data)); PlayerInfo[playerid][pWins] = strval(data);
db_get_field_assoc(result, "Loses", data, sizeof(data)); PlayerInfo[playerid][pLoses] = strval(data);
db_get_field_assoc(result, "Tutorial", data, sizeof(data)); PlayerInfo[playerid][pTut] = strval(data);
db_get_field_assoc(result, "OnDuty", data, sizeof(data)); PlayerInfo[playerid][pOnDuty] = strval(data);
db_get_field_assoc(result, "Hospital", data, sizeof(data)); PlayerInfo[playerid][pHospital] = strval(data);
db_get_field_assoc(result, "Adjustable", data, sizeof(data)); PlayerInfo[playerid][pAdjustable] = strval(data);
db_get_field_assoc(result, "Married", data, sizeof(data)); PlayerInfo[playerid][pMarried] = strval(data);
db_get_field_assoc(result, "MarriedTo", data, sizeof(data)); strmid(PlayerInfo[playerid][pMarriedTo], data, 0, strlen(data), 255);
db_get_field_assoc(result, "NormalName", data, sizeof(data)); strmid(PlayerInfo[playerid][pNormalName], data, 0, strlen(data), 255);
db_get_field_assoc(result, "AdminName", data, sizeof(data)); strmid(PlayerInfo[playerid][pAdminName], data, 0, strlen(data), 255);
db_get_field_assoc(result, "HelperName", data, sizeof(data)); strmid(PlayerInfo[playerid][pHelperName], data, 0, strlen(data), 255);
db_get_field_assoc(result, "AdminDuty", data, sizeof(data)); PlayerInfo[playerid][pAdminDuty] = strval(data);
db_get_field_assoc(result, "ContractBy", data, sizeof(data)); strmid(PlayerInfo[playerid][pContractBy], data, 0, strlen(data), 255);
db_get_field_assoc(result, "IP", data, sizeof(data)); strmid(PlayerInfo[playerid][pIP], data, 0, strlen(data), 255);
db_get_field_assoc(result, "WantedLevel", data, sizeof(data)); PlayerInfo[playerid][pWantedLevel] = strval(data);
db_get_field_assoc(result, "NewbieMuted", data, sizeof(data)); PlayerInfo[playerid][pNewbieMuted] = strval(data);
db_get_field_assoc(result, "RHMuted", data, sizeof(data)); PlayerInfo[playerid][prhmuted] = strval(data);
db_get_field_assoc(result, "SafeSpawn", data, sizeof(data)); PlayerInfo[playerid][pSafeSpawn] = strval(data);
db_get_field_assoc(result, "ReportMuted", data, sizeof(data)); PlayerInfo[playerid][pReportMuted] = strval(data);
db_get_field_assoc(result, "AdvertisetMuted", data, sizeof(data)); PlayerInfo[playerid][pAdvertiseMuted] = strval(data);
db_get_field_assoc(result, "SPos_x", data, sizeof(data)); PlayerInfo[playerid][pSPos_x] = floatstr(data);
db_get_field_assoc(result, "SPos_y", data, sizeof(data)); PlayerInfo[playerid][pSPos_y] = floatstr(data);
db_get_field_assoc(result, "SPos_z", data, sizeof(data)); PlayerInfo[playerid][pSPos_z] = floatstr(data);
db_get_field_assoc(result, "SPos_r", data, sizeof(data)); PlayerInfo[playerid][pSPos_r] = floatstr(data);
db_get_field_assoc(result, "HelperLevel", data, sizeof(data)); PlayerInfo[playerid][pHelper] = strval(data);
db_get_field_assoc(result, "Mask", data, sizeof(data)); HasBoughtMask[playerid] = strval(data);
db_get_field_assoc(result, "AidKit", data, sizeof(data)); PlayerInfo[playerid][pAidKit] = strval(data);
db_get_field_assoc(result, "Blindfolds", data, sizeof(data)); PlayerInfo[playerid][pBlindfolds] = strval(data);
db_get_field_assoc(result, "Speedo", data, sizeof(data)); gSpeedo[playerid] = strval(data);
db_get_field_assoc(result, "Seeds", data, sizeof(data)); PlayerInfo[playerid][pSeeds] = strval(data);
}
else
{
db_free_result(result);
SendClientMessage(playerid, COLOR_RED, "SERVER: The Password You have Entered Does not Match your Name - You have Been Kicked For That.");
SetTimerEx("GettingKicked", 2000, false, "i", playerid);
return 1;
}
db_free_result(result);
}
if(PlayerInfo[playerid][pPermBand] == 1)
{
new banstring[256];
format(banstring,sizeof(banstring),"{AA3333}AdmCmd{FFFF00}: %s Has been Banned by Black Hunter , Reason : Attempting to log into a Perma-Banned account.",PlayerName(playerid));
SendClientMessageToAll(COLOR_LIGHTRED,banstring);
SetTimerEx("GettingBanned", 2000, false, "i", playerid);
}
if(PlayerInfo[playerid][pBand] == 3)
{
new banstring[256];
format(banstring,sizeof(banstring),"{AA3333}AdmCmd{FFFF00}: %s Has Been Banned by Black Hunter , Reason : Attempting to log into a Banned account.",PlayerName(playerid));
SendClientMessageToAll(COLOR_LIGHTRED,banstring);
SetTimerEx("GettingBanned", 2000, false, "i", playerid);
}
if(PlayerInfo[playerid][pDisabled] == 1) //account disabled
{
SendClientMessage(playerid, COLOR_RED, "SERVER : Your account has been disabled by an executive adminstrator - Open a thread at www.UG-RP.com inorder to discuss this problem.");
SetTimerEx("GettingKicked", 2000, false, "i", playerid);
}
if(PlayerInfo[playerid][pReg] == 0)
{
PlayerInfo[playerid][pLevel] = 1;
PlayerInfo[playerid][pAccount] = 5000;
PlayerInfo[playerid][pReg] = 1;
}
//format(string, sizeof(string), "~w~Welcome ~n~~y~ %s", PlayerName(playerid));
//GameTextForPlayer(playerid, string, 5000, 1);
SendClientMessage(playerid, COLOR_YELLOW, motd);
/*if(PlayerInfo[playerid][pAdmin] > 0)
{
new duty[30];
if(PlayerInfo[playerid][pAdminDuty] == 1)
{
duty = "Yes";
}
else
{
duty = "No";
}
format(string, sizeof(string), "Authorized as a level %d administrator (DUTY: %s)",PlayerInfo[playerid][pAdmin],duty);
SendClientMessage(playerid, COLOR_WHITE,string);
}*/
if(PlayerInfo[playerid][pFMember] < 255)
{
format(string, sizeof(string), "Family MOTD: %s", FamilyInfo[PlayerInfo[playerid][pFMember]][FamilyMOTD]);
SendClientMessage(playerid, COLOR_YELLOW, string);
}
if(PlayerInfo[playerid][PlayerVehicleModel1] != 0)
{
//vehicle
CreatePlayerVehicle(playerid,1);
}
if(PlayerInfo[playerid][PlayerVehicleModel2] != 0)
{
//vehicle
CreatePlayerVehicle(playerid,2);
}
if(PlayerInfo[playerid][PlayerVehicleModel3] != 0)
{
//vehicle
CreatePlayerVehicle(playerid,3);
}
if(PlayerInfo[playerid][PlayerVehicleModel4] != 0)
{
//vehicle
CreatePlayerVehicle(playerid,4);
}
if(PlayerInfo[playerid][PlayerVehicleModel5] != 0)
{
//vehicle
CreatePlayerVehicle(playerid,5);
}
ResetPlayerMoney(playerid);
GivePlayerMoney(playerid,PlayerInfo[playerid][pCash]);
SetPlayerVirtualWorld(playerid, PlayerInfo[playerid][pVirtualWorld]);
SetPlayerFightingStyle(playerid, PlayerInfo[playerid][pFightingStyle]);
new plrIP[16];
GetPlayerIp(playerid, plrIP, sizeof(plrIP));
strmid(PlayerInfo[playerid][pIP], plrIP, 0, strlen(plrIP), 255);
PlayerInfo[playerid][pAdjustable] = 0;
InitLockDoors(playerid);
gPlayerLogged[playerid] = 1;
LoadPlayerClothing(playerid);
return 1;
}