#1

Код:
.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.
8738 -
Код:
mysql_query(sqlQuery, THREAD_REGISTER, playerid);
CODE -
Код:
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;
}
7895 -
Код:
mysql_query(sqlQuery, THREAD_SAVEBAN, playerid);
CODE -
Код:
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;
}
9246 to 9287 -
Код:
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;
}
Reply
#2

Oh boy your code is quite a mess.

PHP код:
new sqlQuery[700], desc[64]; mysql_real_escape_string(HouseInfo[houseid][hDiscription],desc);
    
format(sqlQuerysizeof(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(sqlQuerysizeof(sqlQuery), "%s, `Owner`='%s', `Description`='%s', `Price`='%d', `Health`='%d', `Armour`='%d', `Interior`='%d', `Locked`='%d'"sqlQueryHouseInfo[houseid][hOwner],desc,HouseInfo[houseid][hValue],HouseInfo[houseid][hHel],HouseInfo[houseid][hArm],HouseInfo[houseid][hInt], HouseInfo[houseid][hLock]);
    
format(sqlQuerysizeof(sqlQuery), "%s, `Owned`='%d', `RentPrice`='%d', `Rentable`='%d', `Takings`='%d', `LevelNeeded`='%d', `World`='%d', `Setted`='%d', `ExVW`='%d', `ExINT`='%d' WHERE HouseID='%d'"sqlQueryHouseInfo[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(sqlQueryTHREAD_SAVEHOUSEShouseid); 
Useless 2 formats, when you format, you are setting the value for that string, you need to execute queries too. Also for mysql you'd need to use mysql_format instead of regular format.

PHP код:
mysql_query(sqlQueryTHREAD_SAVEHOUSEShouseid); 
Invalid mysql_query usage. Correct:
PHP код:
mysql_query(connectionhandlequery[]) 
PHP код:
return mysql_query("SELECT * FROM `samp_houses`"THREAD_LOADHOUSES); 
Once again, misuse of mysql_query.

There is most likely alot more broken with your code, but there's no point in looking further.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)