[BloodyFlo]

When someone change password in game with command /changepass and select "%S" as a new password server OR say on /report "%S" the server shut down. How i can resolve that problem?

[Shinja]

Show commands and log, and use crashdetect if you don't already have

[BloodyFlo]

Quote:

Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3.7-R2, ©2005-2015 SA-MP Team [18:41:42] filterscripts = "" (string) [18:41:42] [18:41:42] Server Plugins [18:41:42] -------------- [18:41:42] Loading plugin: mysql.dll [18:41:42] >> plugin.mysql: R39-3 successfully loaded. [18:41:42] Loaded. [18:41:42] Loading plugin: sscanf.dll [18:41:42] [18:41:42] =============================== [18:41:42] sscanf plugin loaded. [18:41:42] Version: 2.8.1 [18:41:42] © 2012 Alex "******" Cole [18:41:42] =============================== [18:41:42] Loaded. [18:41:42] Loading plugin: streamer.dll [18:41:42] *** Streamer Plugin v2.7.9 by Incognito loaded *** [18:41:42] Loaded. [18:41:42] Loaded 3 plugins. [18:41:42] [18:41:42] Ban list [18:41:42] -------- [18:41:42] Loaded: samp.ban [18:41:42] [18:41:42] [18:41:42] Filterscripts [18:41:42] --------------- [18:41:42] Loaded 0 filterscripts. [18:41:42] Turfs: 24 [18:41:42] 162 - Objects. [18:41:42] 17 - Pickups. [18:41:42] OnGameModeInit Loaded [18:41:42] Script loaded - Blurred RPG BLRD RPG v1.1.6 [18:41:42] Number of vehicle models: 123 [18:41:42] Houses: 70 [18:41:42] Bussines: 8 [18:41:42] Dynamic Factions: 14 [18:41:42] ================================================== ================== [18:41:42] Error ID: 1146, Error: Table 'proiect.clans' doesn't exist [18:41:42] Callback: LoadClanInfo [18:41:42] gQuery: SELECT * FROM `clans` [18:41:42] ================================================== ================== [18:41:42] Cars: 6 [18:41:42] Stocks: 5 [18:41:43] [connection] 188.25.156.249:53194 requests connection cookie. [18:41:44] [connection] incoming connection: 188.25.156.249:53194 id: 0 [18:41:45] [join] BloodyFlo has joined the server (0:188.25.156.249) [18:41:50] HelloBot: BloodyFlo has just logged in. [18:41:50] HelloBot: BloodyFlo has just logged in. [18:41:50] HelloBot: BloodyFlo has just logged in. [18:41:50] HelloBot: BloodyFlo has just logged in. [18:41:50] BloodyFlo has been connected to the server (IP: 188.25.156.249). [18:41:50] ================================================== ================== [18:41:50] Error ID: 1054, Error: Unknown column 'OnlineToday' in 'field list' [18:41:50] Callback: [18:41:50] gQuery: UPDATE `users` SET `Status` = '1', `OnlineToday` = '1', `OnlineThisWeek` = '1', `LastIP` = '188.25.156.249' WHERE `id` = '1' [18:41:50] ================================================== ================== [18:41:50] ================================================== ================== [18:41:50] Error ID: 1146, Error: Table 'proiect.friends' doesn't exist [18:41:50] Callback: [18:41:50] gQuery: UPDATE `friends` SET `Status` = '1' WHERE `FriendID` = '1' [18:41:50] ================================================== ==================

Here don t say anything

Quote:

CMD:changepass(playerid,params[]) { if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first."); if(IsPlayerConnected(playerid)) { if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first."); ShowPlayerDialog(playerid, DIALOG_NEWPASS,DIALOG_STYLE_INPUT, "Change password:","Type in box your new password:","Done","Close"); return 1; } return 1; }

Quote:

CMD:report(playerid, params[]) { if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to login first."); if(IsPlayerConnected(playerid)) { ShowPlayerDialog(playerid, DIALOG_REPORT1, DIALOG_STYLE_LIST, "Report", "Contul meu este spart sau blocat\nRaporteaza DM\nRaporteaza un cheater\nIntrebari despre donatii\nSunt blocat/Cad prin mapa\nVreau sa fac o afacere si am nevoie de ajutor\nAlta problema", "OK", "Inchide"); } return 1; }

[Shinja]

You have many errors in mysql, tables not exists, unknown columns...

[Spenker]

In "OnDialogResponse" put:

Код HTML:

if(strfind(inputtext, "%", true) != -1)
{
    SendClientMessage(playerid, -1, "Incorrect character.");
    return 1;
}

[BloodyFlo]

But this problem is not from SQL