[QUICK HELP]Problems with creating variable
#1

Hello dear people from SAMP forum,this time I realy need your help.Look at this:
[code]
LoadPlayer(playerid)
{
debug("MySQL Report: Funkcija se pokrenula...");
new resultline[1024];
debug("MySQL Report: Resultline ucitan...");
new data[174][128];
debug("MySQL Report: Data ucitan...");
MySQLFetchRow(PlayerInfo[playerid][pSQLID], resultline, TABLE_PLAYERS);
debug("MySQL Report: Red odvojen...");
explode(data, resultline, "|");
debug("MySQL Report: Igrac se poceo loadati...");

PlayerInfo[playerid][pSQLID] = strval(data[0]);
strmid(PlayerInfo[playerid][pName], data[1], 0, strlen(data[1]), 12;
strmid(PlayerInfo[playerid][pPassword], data[2], 0, strlen(data[2]), 12;
strmid(PlayerInfo[playerid][pEMail], data[3],0, strlen(data[3]), 12;
strmid(PlayerInfo[playerid][pIPAddress], data[4], 0, strlen(data[4]), 12;
strmid(PlayerInfo[playerid][pDisplayName], data[5], 0, strlen(data[5]), 12;
strmid(PlayerInfo[playerid][pRegistrationDate], data[6], 0, strlen(data[6]), 12;
SetPVarInt(playerid, "Sex", strval(data[7]));
SetPVarInt(playerid, "Origin", strval(data[8]));
SetPVarInt(playerid, "Age", strval(data[9]));
PlayerInfo[playerid][pActivated] = booltrval(data[10]);
SetPVarInt(playerid, "Registered", strval(data[11]));
PlayerInfo[playerid][pTutorial] = booltrval(data[12]);
PlayerInfo[playerid][pLevel] = strval(data[13]);
SetPVarInt(playerid, "Admin", strval(data[14]));
SetPVarInt(playerid, "GameMaster", strval(data[15]));
PlayerInfo[playerid][pKicks] = strval(data[16]);
PlayerInfo[playerid][pBans] = strval(data[17]);
SetPVarInt(playerid, "Warns", strval(data[18]));
PlayerInfo[playerid][pBanned] = booltrval(data[19]);
SetPVarInt(playerid, "DonateRank", strval(data[20]));
SetPVarInt(playerid, "Upgrades", strval(data[21]));
SetPVarInt(playerid, "ConnectTime", strval(data[22]));
SetPVarInt(playerid, "Muted", strval(data[23]));
SetPVarInt(playerid, "Respects", strval(data[24]));
SetPVarInt(playerid, "Money", strval(data[25]));
PlayerInfo[playerid][pAccount] = strval(data[26]);
SetPVarInt(playerid, "Crimes", strval(data[27]));
SetPVarInt(playerid, "Arrested", strval(data[28]));
SetPVarInt(playerid, "WantedDeaths", strval(data[29]));
SetPVarInt(playerid, "Phonebook", strval(data[30]));
SetPVarInt(playerid, "Fishes", strval(data[31]));
SetPVarInt(playerid, "BiggestFish", strval(data[32]));
SetPVarInt(playerid, "Job", strval(data[33]));
SetPVarInt(playerid, "HeadValue", strval(data[34]));
SetPVarInt(playerid, "Jailed", strval(data[35]));
SetPVarInt(playerid, "JailTime", strval(data[36]));
PlayerInfo[playerid][pDrugs] = strval(data[37]);
PlayerInfo[playerid][pLeader] = strval(data[38]);
PlayerInfo[playerid][pMember] = strval(data[39]);
SetPVarInt(playerid, "Rank", strval(data[40]));
PlayerInfo[playerid][pChar] = strval(data[41]);
SetPVarInt(playerid, "ContractTime", strval(data[42]));
SetPVarInt(playerid, "DetSkill", strval(data[43]));
SetPVarInt(playerid, "SexSkill", strval(data[44]));
SetPVarInt(playerid, "LawSkill", strval(data[45]));
SetPVarInt(playerid, "MechSkill", strval(data[46]));
SetPVarInt(playerid, "NewsSkill", strval(data[47]));
SetPVarInt(playerid, "FishSkill", strval(data[48]));
PlayerInfo[playerid][pSHealth] = floatstr(data[49]);
PlayerInfo[playerid][pHealth] = floatstr(data[50]);
PlayerInfo[playerid][pInt] = strval(data[51]);
SetPVarInt(playerid, "CrashedVW", strval(data[52]));
SetPVarInt(playerid, "Local", strval(data[53]));
PlayerInfo[playerid][pTeam] = strval(data[54]);
SetPVarInt(playerid, "Model", strval(data[55]));
SetPVarInt(playerid, "PhoneNumber", strval(data[56]));
SetPVarInt(playerid, "HouseKey", strval(data[57]));
SetPVarInt(playerid, "JobKey", strval(data[58]));
SetPVarInt(playerid, "BizKey", strval(data[59]));
SetPVarInt(playerid, "CarLic", strval(data[60]));
SetPVarInt(playerid, "FlyLic", strval(data[61]));
SetPVarInt(playerid, "BoatLic", strval(data[62]));
SetPVarInt(playerid, "FishLic", strval(data[63]));
SetPVarInt(playerid, "GunLic", strval(data[64]));
SetPVarInt(playerid, "Gun1", strval(data[65]));
SetPVarInt(playerid, "Gun2", strval(data[66]));
SetPVarInt(playerid, "Gun3", strval(data[67]));
SetPVarInt(playerid, "Gun4", strval(data[68]));
SetPVarInt(playerid, "Gun5", strval(data[69]));
SetPVarInt(playerid, "Melee", strval(data[70]));
SetPVarInt(playerid, "MaskID", strval(data[71]));
SetPVarInt(playerid, "Strength", strval(data[72]));
SetPVarInt(playerid, "Ammo1", strval(data[73]));
SetPVarInt(playerid, "Ammo2", strval(data[74]));
SetPVarInt(playerid, "Ammo3", strval(data[75]));
SetPVarInt(playerid, "Ammo4", strval(data[76]));
SetPVarInt(playerid, "Ammo5", strval(data[77]));
SetPVarInt(playerid, "FreeWorks", strval(data[78]));
SetPVarInt(playerid, "Helmet", strval(data[79]));
SetPVarInt(playerid, "FishingRod", strval(data[80]));
SetPVarInt(playerid, "RuletMoney", strval(data[81]));
SetPVarInt(playerid, "CarTime", strval(data[82]));
SetPVarInt(playerid, "PayDay", strval(data[83]));
SetPVarInt(playerid, "PayDayHad", strval(data[84]));
SetPVarInt(playerid, "CDPlayer", strval(data[85]));
SetPVarInt(playerid, "Wins", strval(data[86]));
SetPVarInt(playerid, "Loses", strval(data[87]));
SetPVarInt(playerid, "TraderPerk", strval(data[88]));
SetPVarInt(playerid, "RPPassed", strval(data[89]));
SetPVarInt(playerid, "Fuel", strval(data[90]));
SetPVarInt(playerid, "Married", strval(data[91]));
strmid(PlayerInfo[playerid][pMarriedTo], data[92], 0, strlen(data[92]), 24);
SetPVarInt(playerid, "Passport", strval(data[93]));
SetPVarInt(playerid, "Watch", strval(data[94]));
SetPVarInt(playerid, "Tools", strval(data[95]));
SetPVarFloat(playerid, "LastX", floatstr(data[96]));
SetPVarFloat(playerid, "LastY", floatstr(data[97]));
SetPVarFloat(playerid, "LastZ", floatstr(data[98]));
SetPVarInt(playerid, "Crashed", strval(data[99]));
SetPVarFloat(playerid, "TempHealth", floatstr(data[101]));
SetPVarFloat(playerid, "TempArmour", floatstr(data[102]));
SetPVarInt(playerid, "pMayorTeam", strval(data[103]));
SetPVarFloat(playerid, "M1_x", floatstr(data[104]));
SetPVarFloat(playerid, "M1_y", floatstr(data[105]));
SetPVarFloat(playerid, "M1_z", floatstr(data[106]));
SetPVarFloat(playerid, "M2_x", floatstr(data[107]));
SetPVarFloat(playerid, "M2_y", floatstr(data[108]));
SetPVarFloat(playerid, "M2_z", floatstr(data[109]));
SetPVarFloat(playerid, "M3_x", floatstr(data[110]));
SetPVarFloat(playerid, "M3_y", floatstr(data[111]));
SetPVarFloat(playerid, "M3_z", floatstr(data[112]));
SetPVarFloat(playerid, "M4_x", floatstr(data[113]));
SetPVarFloat(playerid, "M4_y", floatstr(data[114]));
SetPVarFloat(playerid, "M4_z", floatstr(data[115]));
SetPVarFloat(playerid, "M5_x", floatstr(data[116]));
SetPVarFloat(playerid, "M5_y", floatstr(data[117]));
SetPVarFloat(playerid, "M5_z", floatstr(data[118]));
SetPVarInt(playerid, "CrashInt", strval(data[119]));
SetPVarInt(playerid, "FightStyle", strval(data[120]));
SetPVarInt(playerid, "PayDayMoney", strval(data[121]));
SetPVarInt(playerid, "Voted", strval(data[122]));
strmid(PlayerInfo[playerid][pNote1], data[123], 0, strlen(data[123]), 12;
SetPVarInt(playerid, "Note1s", strval(data[124]));
strmid(PlayerInfo[playerid][pNote2], data[125], 0, strlen(data[125]), 12;
SetPVarInt(playerid, "Note2s", strval(data[126]));
strmid(PlayerInfo[playerid][pNote3], data[127], 0, strlen(data[127]), 12;
SetPVarInt(playerid, "Note3s", strval(data[128]));
strmid(PlayerInfo[playerid][pNote4], data[129], 0, strlen(data[129]), 12;
SetPVarInt(playerid, "Note4s", strval(data[130]));
strmid(PlayerInfo[playerid][pNote5], data[131], 0, strlen(data[131]), 12;
SetPVarInt(playerid, "Note5s", strval(data[132]));
SetPVarInt(playerid, "Goods", strval(data[133]));
SetPVarInt(playerid, "Mask", strval(data[134]));
SetPVarInt(playerid, "StealTime", strval(data[135]));
SetPVarInt(playerid, "Inection", strval(data[136]));
SetPVarInt(playerid, "StealSkill", strval(data[137]));
SetPVarInt(playerid, "MParts", strval(data[138]));
SetPVarInt(playerid, "IParts", strval(data[139]));
SetPVarInt(playerid, "Toolkit", strval(data[140]));
SetPVarInt(playerid, "TookCredit", strval(data[140]));
SetPVarInt(playerid, "Rate", strval(data[141]));
SetPVarInt(playerid, "Kosa", strval(data[142]));
SetPVarInt(playerid, "MustRead", strval(data[143]));
SetPVarInt(playerid, "ShareKey", strval(data[144]));
SetPVarInt(playerid, "PDStatsArrest", strval(data[145]));
SetPVarInt(playerid, "PDStatsMats", strval(data[146]));
SetPVarInt(playerid, "PDStatsDrug", strval(data[147]));
SetPVarInt(playerid, "PDStatsTicket", strval(data[148]));
SetPVarInt(playerid, "PDStatsTicketMoney", strval(data[149]));
SetPVarInt(playerid, "pMobileMoney", strval(data[150]));
SetPVarInt(playerid, "KickReason", strval(data[151]));
SetPVarInt(playerid, "DutySystem", strval(data[152]));
SetPVarInt(playerid, "Bomb", strval(data[153]));
SetPVarFloat(playerid, "BombX", floatstr(data[154]));
SetPVarFloat(playerid, "BombY", floatstr(data[155]));
SetPVarFloat(playerid, "BombZ", floatstr(data[156]));
SetPVarInt(playerid, "BombE", strval(data[157]));
SetPVarInt(playerid, "BombCar", strval(data[158]));
SetPVarInt(playerid, "pPublicCredit", strval(data[159]));
SetPVarInt(playerid, "DrugUsed", strval(data[160]));
SetPVarInt(playerid, "Ovisnik", strval(data[161]));
SetPVarInt(playerid, "DrugIndicator", strval(data[161]));
SetPVarInt(playerid, "Ciggaretes", strval(data[162]));
SetPVarInt(playerid, "Lighter", strval(data[163]));
SetPVarInt(playerid, "TakenDrugs", strval(data[164]));
SetPVarInt(playerid, "TakenWeps", strval(data[165]));
SetPVarInt(playerid, "GunPackage1", strval(data[166]));
SetPVarInt(playerid, "GunPackage2", strval(data[167]));
SetPVarInt(playerid, "GunPackage3", strval(data[168]));
SetPVarInt(playerid, "Drug1", strval(data[169]));
SetPVarInt(playerid, "Drug2", strval(data[170]));
SetPVarInt(playerid, "Drug3", strval(data[171]));
SetPVarInt(playerid, "Drug4", strval(data[172]));
SetPVarInt(playerid, "Drug5", strval(data[173]));


mysql_free_result();
return 1;
}
new data[174][128];

I can't create this variable,so I can't load any variables from my MySQL database.How can I fix this?I need help as soon as possible.Thanks!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)