[skiplovebra]

Mistake No. 1

Code:

sscanf warning: Format specifier does not match parameter count.

in command

Code:

CMD:docarrest(playerid, params[])
{
	if(!IsACop(playerid)) SendClientMessageEx(playerid, COLOR_GREY, "Ban khong phai la LEO faction. ");
	else if(!IsAtArrestPoint(playerid, 2)) SendClientMessageEx(playerid, COLOR_GREY, "Ban khong o diem bat giu tai DOC." );

	else
	{
   		new
     		moneys,
       		time,
			string[256];

        new suspect = GetClosestPlayer(playerid);
  		if(sscanf(params, "dddd", moneys, time)) SendClientMessageEx(playerid, COLOR_GREY, "SU DUNG: /docarrest [fine] [minutes]");
		else if(!(1 <= moneys <= 250000)) SendClientMessageEx(playerid, COLOR_GREY, "Phat tien ngoi tu khong duoi $1 va tren $250,000.");
		else if(!(1 <= time <= 120)) SendClientMessageEx(playerid, COLOR_GREY, "Thoi gian ngoi tu khong duoi 1 va tren 120 phut - co the dua nguoi do toi tu de co them thoi gian  giam giu.");
		else if(!IsPlayerConnected(suspect)) SendClientMessageEx(playerid, COLOR_GREY, "nguoi choi khong hop le.");
		else if(!ProxDetectorS(5.0, playerid, suspect)) SendClientMessageEx(playerid, COLOR_GREY, "Ban phai o gan nghi pham.");
		else if(PlayerInfo[suspect][pWantedLevel] < 1 && PlayerInfo[playerid][pMember] != 12) SendClientMessageEx(playerid, COLOR_GREY, "Nguoi do phai co it nhat 1 cap do truy na");
		else {
			SetPVarInt(playerid, "Arrest_Price", moneys);
			SetPVarInt(playerid, "Arrest_Time", time);
			SetPVarInt(playerid, "Arrest_Suspect", suspect);
			SetPVarInt(playerid, "Arrest_Type", 2);
			format(string, sizeof(string), "Hay viet mot bao cao ngan gon ve viec bat giu %s va nhung hanh dong do.\n\nBao cao phai co it nhat 30 ki tu va nhieu nhat la 128 ki tu.", GetPlayerNameEx(suspect));
			ShowPlayerDialog(playerid, DIALOG_ARRESTREPORT, DIALOG_STYLE_INPUT, "Bao cao bat giu", string, "Gui di", "");
	    }
	}
	return 1;
}

second offense

Code:

[09/04/2016 18:26:06] [MySQL] Query Error - (ErrorID: 1064) (Handle: 1)
[09/04/2016 18:26:06] [MySQL] Check mysql_log.txt to review the query that threw the error.
[09/04/2016 18:26:06] Dumping query from 2016/4/9 (18:26:6)

Mieu ta: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' - Ai vi pham SA THAI', `Allegiance` = 1, `Bug` = 255, `Radio` = 0, `DeptRadi' at line 1 (index 0). Query:


[09/04/2016 18:26:06] UPDATE `groups` SET `Type` = 3, `Name` = 'FDSA', `MOTD` = 'Khong [/nos]; Khong duoc lay SHOTGUN; 10 10 phai xin phep; Han che them '))' - Ai vi pham SA THAI', `Allegiance` = 1, `Bug` = 255, `Radio` = 0, `DeptRadio` = 0, `IntRadio` = 6, `GovAnnouncement` = 6, `FreeNameChange` = 255, `DutyColour` = 16737894, `RadioColour` = 16737894, `Stock` = 10000, `CrateX` = '-1484.43', `CrateY` = '1681.81', `CrateZ` = '18.25', `SpikeStrips` = 255, `Barricades` = 255, `Cones` = 255, `Flares` = 1, `Barrels` = 3, `Budget` = 290480616, `BudgetPayment` = 80000, LockerCostType = 2, `CratesOrder` = '0', `CrateIsland` = '255', `GarageX` = '1569.00', `GarageY` = '-2173.00', `GarageZ` = '14.00', `Rank0` = 'Thuc tap vien', `Rank1` = 'Tro ly bac si', `Rank2` = 'Bac si', `Rank3` = 'Bac si nghiep du', `Rank4` = 'Bac si truong', `Rank5` = 'Pho truong khoa', `Rank6` = 'Truong Khoa', `Rank7` = 'Thu Ky vien truong', `Rank8` = 'Pho vien truong', `Rank9` = 'Vien Truong', `Rank0Pay` = 2100, `Rank1Pay` = 5000, `Rank2Pay` = 10000, `Rank3Pay` = 2
[09/04/2016 18:26:06] 0000, `Rank4Pay` = 25000, `Rank5Pay` = 30000, `Rank6Pay` = 35000, `Rank7Pay` = 40000, `Rank8Pay` = 50000, `Rank9Pay` = 90000, `Div1` = 'CMD', `Div2` = 'Cuu Hoa', `Div3` = 'PDT', `Div4` = 'Hang Khong', `Div5` = 'IA', `Div6` = 'Cuu tro', `Div7` = 'FIRE', `Div8` = 'EMS', `Div9` = 'Honorary', `Div10` = 'Thuc Tap Sinh', `Gun1` = 6, `Cost1` = 0, `Gun2` = 43, `Cost2` = 0, `Gun3` = 25, `Cost3` = 3000, `Gun4` = 46, `Cost4` = 0, `Gun5` = 42, `Cost5` = 0, `Gun6` = 0, `Cost6` = 0, `Gun7` = 0, `Cost7` = 0, `Gun8` = 0, `Cost8` = 0, `Gun9` = 0, `Cost9` = 0, `Gun10` = 0, `Cost10` = 0, `Gun11` = 0, `Cost11` = 0, `Gun12` = 0, `Cost12` = 0, `Gun13` = 0, `Cost13` = 0, `Gun14` = 0, `Cost14` = 0, `Gun15` = 0, `Cost15` = 0, `Gun16` = 0, `Cost16` = 0 WHERE `id` = 17

Mysql_log

Code:

21:00:18] [ERROR] CMySQLQuery::Execute[OnQueryFinish] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' - Ai vi pham SA THAI', `Allegiance` = 1, `Bug` = 255, `Radio` = 0, `DeptRadi' at line 1

Code:

[17:06:21] [ERROR] CMySQLQuery::Execute[OnQueryFinish] - (error #1065) Query was empty

someone please help me please , sorry bad enlights

[Xabi]

Quote:

if(sscanf(params, "dddd", moneys, time)) SendClientMessageEx(playerid, COLOR_GREY, "SU DUNG: /docarrest [fine] [minutes]");

You need just "dd" there

Quote:

[09/04/2016 18:26:06] UPDATE `groups` SET `Type` = 3, `Name` = 'FDSA', `MOTD` = 'Khong [/nos]; Khong duoc lay SHOTGUN; 10 10 phai xin phep; Han che them '))' - Ai vi pham SA THAI', `Allegiance` = 1, `Bug` = 255, `Radio` = 0, `DeptRadio` = 0, `IntRadio` = 6, `GovAnnouncement` = 6, `FreeNameChange` = 255, `DutyColour` = 16737894, `RadioColour` = 16737894, `Stock` = 10000, `CrateX` = '-1484.43', `CrateY` = '1681.81', `CrateZ` = '18.25', `SpikeStrips` = 255, `Barricades` = 255, `Cones` = 255, `Flares` = 1, `Barrels` = 3, `Budget` = 290480616, `BudgetPayment` = 80000, LockerCostType = 2, `CratesOrder` = '0', `CrateIsland` = '255', `GarageX` = '1569.00', `GarageY` = '-2173.00', `GarageZ` = '14.00', `Rank0` = 'Thuc tap vien', `Rank1` = 'Tro ly bac si', `Rank2` = 'Bac si', `Rank3` = 'Bac si nghiep du', `Rank4` = 'Bac si truong', `Rank5` = 'Pho truong khoa', `Rank6` = 'Truong Khoa', `Rank7` = 'Thu Ky vien truong', `Rank8` = 'Pho vien truong', `Rank9` = 'Vien Truong', `Rank0Pay` = 2100, `Rank1Pay` = 5000, `Rank2Pay` = 10000, `Rank3Pay` = 2

Remove the '))' at `MOTD` = 'Khong [/nos]; Khong duoc lay SHOTGUN; 10 10 phai xin phep; Han che them '))' - Ai vi pham SA THAI'

[skiplovebra]

Quote:

Originally Posted by Xabi You need just "dd" there Remove the '))' at `MOTD` = 'Khong [/nos]; Khong duoc lay SHOTGUN; 10 10 phai xin phep; Han che them '))' - Ai vi pham SA THAI'

Thanks My Bro

Code:

[17:06:21] [ERROR] CMySQLQuery::Execute[OnQueryFinish] - (error #1065) Query was empty

help me please !

[skiplovebra]

help

[skiplovebra]

help

[Konstantinos]

Escape the strings before you pass them in queries.

[skiplovebra]

Quote:

Originally Posted by Konstantinos Escape the strings before you pass them in queries.

Can you guide me did not understand much more

[Konstantinos]

Use mysql_format instead format and specifier '%e' instead of '%s'

[iKevin]

mysql_real_escape_string before you put the strings inot the queries of the db.

[Sew_Sumi]

He's using a leaked script, don't help him.