|
Originally Posted by Kelbac
 I don't know things about MySQL , but you can just use Y_INI or something..
|
|
Originally Posted by NLFMaster
Show us your server_log.txt
|
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R4, ©2005-2014 SA-MP Team [13:34:27] password = "" (string) [13:34:27] [13:34:27] Server Plugins [13:34:27] -------------- [13:34:27] Loading plugin: mysql.so [13:34:27] > MySQL plugin R6 successfully loaded. [13:34:27] Loaded. [13:34:27] Loaded 1 plugins. [13:34:27] [13:34:27] Filterscripts [13:34:27] --------------- [13:34:27] Loading filterscript 'UltraHost.amx'... [13:34:27] Loaded 1 filterscripts. [13:34:27] ---------------------------------- [13:34:27] S4S Open world Deathmatch [13:34:27] ---------------------------------- [13:34:27] Number of vehicle models: 32 [13:34:52] [join] [WTF]DedSec has joined the server
|
Originally Posted by Gaurav_Rawat
Use crash detect plugin to look for errors.
|
---------- Loaded log file: "server_log.txt". ---------- SA-MP Dedicated Server ---------------------- v0.3z-R4, ©2005-2014 SA-MP Team [16:37:14] password = "" (string) [16:37:14] [16:37:14] Server Plugins [16:37:14] -------------- [16:37:14] Loading plugin: mysql.so [16:37:14] > MySQL plugin R6 successfully loaded. [16:37:14] Loaded. [16:37:14] Loading plugin: crashdetect.so [16:37:14] CrashDetect v4.15.1 is OK. [16:37:14] Loaded. [16:37:14] Loaded 2 plugins. [16:37:14] [16:37:14] Filterscripts [16:37:14] --------------- [16:37:14] Loading filterscript 'UltraHost.amx'... [16:37:14] Loaded 1 filterscripts. [16:37:14] ---------------------------------- [16:37:14] S4S Open world Deathmatch [16:37:14] ---------------------------------- [16:37:14] Number of vehicle models: 32 [16:37:43] Incoming connection: 176.205.59.94:49914 [16:37:43] [join] [WTF]DedSec has joined the server (0:176.205.59.94) [16:38:08] [debug] Server crashed while executing s4sdm.amx [16:38:08] [debug] AMX backtrace: [16:38:08] [debug] #0 native mysql_fetch_field_row () from mysql.so [16:38:08] [debug] #1 000167c0 in ?? (0) from s4sdm.amx [16:38:08] [debug] #2 0001027c in public OnDialogResponse (0, 12348, 1, -1, 175952) from s4sdm.amx [16:38:09] [debug] Native backtrace: [16:38:09] [debug] #0 b6a74e8b in _ZN10StackTraceC1EPv () from plugins/crashdetect.so [16:38:09] [debug] #1 b6a6dbcf in _ZN11CrashDetect20PrintNativeBacktraceERSoPv () from plugins/crashdetect.so [16:38:09] [debug] #2 b6a6edbc in _ZN11CrashDetect20PrintNativeBacktraceEPv () from plugins/crashdetect.so [16:38:09] [debug] #3 b6a6f226 in _ZN11CrashDetect11OnExceptionEPv () from plugins/crashdetect.so [16:38:09] [debug] #4 b6a74adc in ?? () from plugins/crashdetect.so [16:38:09] [debug] #5 b777c40c in ?? () [16:38:09] [debug] #6 b7543f36 in ?? () from /lib/i386-linux-gnu/i686/cmov/libc.so.6 [16:38:09] [debug] #7 b771e073 in _ZNKSs7compareEPKc () from /usr/lib/i386-linux-gnu/libstdc++.so.6 [16:38:09] [debug] #8 b74b3973 in _ZN13CMySQLHandler10FetchFieldESs () from plugins/mysql.so [16:38:09] [debug] #9 b74b8820 in _ZN7Natives23n_mysql_fetch_field_rowEP6tagAMXPi () from plugins/mysql.so [16:38:09] [debug] #10 08094054 in ?? () from ./sampsvr-port_5068 [16:38:09] [debug] #11 b6a7094b in _ZN11CrashDetect13DoAmxCallbackEiPiS0_ () from plugins/crashdetect.so [16:38:09] [debug] #12 b6a738f8 in ?? () from plugins/crashdetect.so [16:38:09] [debug] #13 b6a77916 in amx_Exec () from plugins/crashdetect.so [16:38:09] [debug] #14 b6a6fbe6 in _ZN11CrashDetect9DoAmxExecEPii () from plugins/crashdetect.so [16:38:09] [debug] #15 b6a73659 in ?? () from plugins/crashdetect.so [16:38:09] [debug] #16 080a524f in ?? () from ./sampsvr-port_5068 [16:38:09] [debug] #17 080b11c4 in ?? () from ./sampsvr-port_5068 [16:38:09] [debug] #18 08071b38 in ?? () from ./sampsvr-port_5068 [16:38:09] [debug] #19 08071c32 in ?? () from ./sampsvr-port_5068 [16:38:09] [debug] #20 0807bb80 in ?? () from ./sampsvr-port_5068 [16:38:09] [debug] #21 080ad3bd in ?? () from ./sampsvr-port_5068 [16:38:09] [debug] #22 080ad562 in ?? () from ./sampsvr-port_5068 [16:38:09] [debug] #23 080a88ce in ?? () from ./sampsvr-port_5068 [16:38:09] [debug] #24 b74dae66 in __libc_start_main () from /lib/i386-linux-gnu/i686/cmov/libc.so.6 [16:38:09] [debug] #25 0804b4d1 in ?? () from ./sampsvr-port_5068
case DIALOG_LOGIN:
{
if(!response)
{
SendClientMessage(playerid, RED, "You must login before you spawn!");
ShowDialog(playerid, DIALOG_LOGIN);
}
if(response)
{
new query[200], pname[24], escapepass[100];
GetPlayerName(playerid, pname, 24);
mysql_real_escape_string(inputtext, escapepass);
format(query, sizeof(query), "SELECT `user` FROM playerdata WHERE user = '%s' AND password = SHA1('%s')", pname, escapepass);
mysql_query(query);
mysql_store_result();
new numrows = mysql_num_rows();
if(numrows == 1)
{
MySQL_Login(playerid);
Muted[playerid] = 0;
SendClientMessage(playerid, GREEN, "You have successfully logged in");
new string[256];
Clan[playerid] = pInfo[playerid][pClan];
}
