help - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: help (/showthread.php?tid=595536)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: help (/showthread.php?tid=595536)
help - Infinity001 - 04.12.2015
Код:
.SRP.pwn(7895) : error 035: argument type mismatch (argument 1) .SRP.pwn(8738) : error 035: argument type mismatch (argument 1) .SRP.pwn(9246) : error 035: argument type mismatch (argument 1) .SRP.pwn(9254) : error 035: argument type mismatch (argument 1) .SRP.pwn(9266) : error 035: argument type mismatch (argument 1) .SRP.pwn(9267) : error 035: argument type mismatch (argument 1) .SRP.pwn(9268) : error 035: argument type mismatch (argument 1) .SRP.pwn(9269) : error 035: argument type mismatch (argument 1) .SRP.pwn(9270) : error 035: argument type mismatch (argument 1) .SRP.pwn(9271) : error 035: argument type mismatch (argument 1) .SRP.pwn(9272) : error 035: argument type mismatch (argument 1) .SRP.pwn(9273) : error 035: argument type mismatch (argument 1) .SRP.pwn(9274) : error 035: argument type mismatch (argument 1) .SRP.pwn(9275) : error 035: argument type mismatch (argument 1) .SRP.pwn(9276) : error 035: argument type mismatch (argument 1) .SRP.pwn(9277) : error 035: argument type mismatch (argument 1) .SRP.pwn(9278) : error 035: argument type mismatch (argument 1) .SRP.pwn(9279) : error 035: argument type mismatch (argument 1) .SRP.pwn(9280) : error 035: argument type mismatch (argument 1) .SRP.pwn(9281) : error 035: argument type mismatch (argument 1) .SRP.pwn(9282) : error 035: argument type mismatch (argument 1) .SRP.pwn(9283) : error 035: argument type mismatch (argument 1) .SRP.pwn(9284) : error 035: argument type mismatch (argument 1) .SRP.pwn(9285) : error 035: argument type mismatch (argument 1) .SRP.pwn(9286) : error 035: argument type mismatch (argument 1) .SRP.pwn(9287) : error 035: argument type mismatch (argument 1) Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 26 Errors.
Код:
mysql_query(sqlQuery, THREAD_REGISTER, playerid);
Код:
stock OnPlayerRegister(playerid, password[])
{
LogCallback("OnPlayerRegister");
if(IsPlayerConnected(playerid))
{
new
sqlQuery[500],
playername3[MAX_PLAYER_NAME],
password2 = num_hash(password),
playersip[24],
randphone = 100000 + random(899999), //minimum 1000 max 9999 //giving one at the start
registered[24];
new y,m,d,h,mi,s;
getdate(y,m,d); gettime(h,mi,s);
format(registered,sizeof(registered), "%d/%d/%d at %d:%d:%d",d,m,y,h,mi,s);
GetPlayerName(playerid, playername3, sizeof(playername3));
GetPlayerIp(playerid, playersip, sizeof(playersip));
format(sqlQuery, sizeof(sqlQuery), "INSERT INTO samp_users SET `Username`='%s', `Password`='%d', `PhoneNr`='%d', `IP`='%s', `RegistredDate`='%s'", playername3, password2, randphone, playersip, registered);
mysql_query(sqlQuery, THREAD_REGISTER, playerid);
}
LogCallback("OnPlayerRegister");
return 1;
}
Код:
mysql_query(sqlQuery, THREAD_SAVEBAN, playerid);
Код:
stock ScriptBan(playerid,adminid,reason[])
{
LogCallback("ScriptBan");
new playersip[34], sqlQuery[500], escreason[128];
GetPlayerIp(playerid,playersip,sizeof(playersip)); mysql_real_escape_string(reason,escreason);
format(sqlQuery, sizeof(sqlQuery), "INSERT INTO samp_bans SET `IP`=INET_ATON('%s'), `BannedBy`='%s', `BanReason`='%s', BanName='%s'", playersip, PlayerName(adminid), escreason, PlayerName(playerid));
mysql_query(sqlQuery, THREAD_SAVEBAN, playerid);
ServerKick(playerid);
LogCallback("ScripBan");
return 1;
}
Код:
stock LoadHouses() { return mysql_query("SELECT * FROM `samp_houses`", THREAD_LOADHOUSES); }
stock FullHouseSave(houseid) // MYSQL HOUSES
{
new sqlQuery[700], desc[64]; mysql_real_escape_string(HouseInfo[houseid][hDiscription],desc);
format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Entrance_X`='%f', `Entrance_Y`='%f', `Entrance_Z`='%f', `Exit_X`='%f', `Exit_Y`='%f', `Exit_Z`='%f'", HouseInfo[houseid][hEntrancex],HouseInfo[houseid][hEntrancey],HouseInfo[houseid][hEntrancez],HouseInfo[houseid][hExitx],HouseInfo[houseid][hExity], HouseInfo[houseid][hExitz]);
format(sqlQuery, sizeof(sqlQuery), "%s, `Owner`='%s', `Description`='%s', `Price`='%d', `Health`='%d', `Armour`='%d', `Interior`='%d', `Locked`='%d'", sqlQuery, HouseInfo[houseid][hOwner],desc,HouseInfo[houseid][hValue],HouseInfo[houseid][hHel],HouseInfo[houseid][hArm],HouseInfo[houseid][hInt], HouseInfo[houseid][hLock]);
format(sqlQuery, sizeof(sqlQuery), "%s, `Owned`='%d', `RentPrice`='%d', `Rentable`='%d', `Takings`='%d', `LevelNeeded`='%d', `World`='%d', `Setted`='%d', `ExVW`='%d', `ExINT`='%d' WHERE HouseID='%d'", sqlQuery, HouseInfo[houseid][hOwned],HouseInfo[houseid][hRent],HouseInfo[houseid][hRentabil],HouseInfo[houseid][hTakings],HouseInfo[houseid][hLevel],HouseInfo[houseid][hWorld],HouseInfo[houseid][hSetted], HouseInfo[houseid][hExVW], HouseInfo[houseid][hExINT], houseid);
mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid);
return 1;
}
stock SaveHouse(houseid, statid) // MYSQL HOUSES
{
new
sqlQuery[256],
message[64]
;
switch(statid)
{
case 1: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Entrance_X`='%f', `Entrance_Y`='%f', `Entrance_Z`='%f' WHERE HouseID='%d'", HouseInfo[houseid][hEntrancex],HouseInfo[houseid][hEntrancey],HouseInfo[houseid][hEntrancez], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 2: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Exit_X`='%f', `Exit_Y`='%f', `Exit_Z`='%f', `Interior`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hExitx],HouseInfo[houseid][hExity],HouseInfo[houseid][hExitz],HouseInfo[houseid][hInt], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 3: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Owner`='%s' WHERE HouseID='%d'", HouseInfo[houseid][hOwner], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 4: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Description`='%s' WHERE HouseID='%d'", HouseInfo[houseid][hDiscription], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 5: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Price`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hValue], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 6: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Health`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hHel], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 7: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Armour`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hArm], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 8: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Interior`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hInt], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 9: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Locked`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hLock], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 10: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Owned`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hOwned], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 11: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `RentPrice`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hRent], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 12: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Rentable`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hRentabil], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 13: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Takings`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hTakings], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 14: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `LevelNeeded`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hLevel], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 15: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `World`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hWorld], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 16: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Setted`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hSetted], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 17: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Drugs`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hDrugs], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 18: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Materials`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hMaterials], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 19: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Weapon1`='%d', `Ammo1`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hWeapon1], HouseInfo[houseid][hAmmo1], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 20: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Weapon2`='%d', `Ammo2`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hWeapon2], HouseInfo[houseid][hAmmo2], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 21: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Weapon3`='%d', `Ammo3`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hWeapon3], HouseInfo[houseid][hAmmo3], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 22: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Weapon4`='%d', `Ammo4`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hWeapon4], HouseInfo[houseid][hAmmo4], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 23: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Weapon5`='%d', `Ammo5`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hWeapon5], HouseInfo[houseid][hAmmo5], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 24: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Weapon6`='%d', `Ammo6`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hWeapon6], HouseInfo[houseid][hAmmo6], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 25: { mysql_real_escape_string(HouseInfo[houseid][hMessage],message); format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Message`='%s' WHERE HouseID='%d'", message, houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 26: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `ExVW`='%d', `ExINT`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hExVW], HouseInfo[houseid][hExINT], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 27: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Seeds`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hDrugs][0], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 28: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `BWeed`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hDrugs][1], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 29: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Weed`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hDrugs][2], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 30: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `BCoke`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hDrugs][3], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 31: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `CCoke`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hDrugs][4], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 32: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Coke`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hDrugs][5], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 33: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `BCrack`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hDrugs][6], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
case 34: { format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Crack`='%d' WHERE HouseID='%d'", HouseInfo[houseid][hDrugs][7], houseid); mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid); }
}
return 1;
}
Re: help - CmZxC - 04.12.2015
Oh boy your code is quite a mess.
PHP код:
new sqlQuery[700], desc[64]; mysql_real_escape_string(HouseInfo[houseid][hDiscription],desc);
format(sqlQuery, sizeof(sqlQuery), "UPDATE `samp_houses` SET `Entrance_X`='%f', `Entrance_Y`='%f', `Entrance_Z`='%f', `Exit_X`='%f', `Exit_Y`='%f', `Exit_Z`='%f'", HouseInfo[houseid][hEntrancex],HouseInfo[houseid][hEntrancey],HouseInfo[houseid][hEntrancez],HouseInfo[houseid][hExitx],HouseInfo[houseid][hExity], HouseInfo[houseid][hExitz]);
format(sqlQuery, sizeof(sqlQuery), "%s, `Owner`='%s', `Description`='%s', `Price`='%d', `Health`='%d', `Armour`='%d', `Interior`='%d', `Locked`='%d'", sqlQuery, HouseInfo[houseid][hOwner],desc,HouseInfo[houseid][hValue],HouseInfo[houseid][hHel],HouseInfo[houseid][hArm],HouseInfo[houseid][hInt], HouseInfo[houseid][hLock]);
format(sqlQuery, sizeof(sqlQuery), "%s, `Owned`='%d', `RentPrice`='%d', `Rentable`='%d', `Takings`='%d', `LevelNeeded`='%d', `World`='%d', `Setted`='%d', `ExVW`='%d', `ExINT`='%d' WHERE HouseID='%d'", sqlQuery, HouseInfo[houseid][hOwned],HouseInfo[houseid][hRent],HouseInfo[houseid][hRentabil],HouseInfo[houseid][hTakings],HouseInfo[houseid][hLevel],HouseInfo[houseid][hWorld],HouseInfo[houseid][hSetted], HouseInfo[houseid][hExVW], HouseInfo[houseid][hExINT], houseid);
mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid);
PHP код:
mysql_query(sqlQuery, THREAD_SAVEHOUSES, houseid);
PHP код:
mysql_query(connectionhandle, query[])
PHP код:
return mysql_query("SELECT * FROM `samp_houses`", THREAD_LOADHOUSES);
There is most likely alot more broken with your code, but there's no point in looking further.