31.12.2012, 00:20
Hello!
I am creating a MySQL server from scratch, however I've run into a problem. My server crashes when I try to log in after I have restarted it. However, if I drop my playerdata table and I register and relog and then log in, it works. But as soon as I restart the server, server starts crashing when I log in.
My OnPlayerConnect:
I am creating a MySQL server from scratch, however I've run into a problem. My server crashes when I try to log in after I have restarted it. However, if I drop my playerdata table and I register and relog and then log in, it works. But as soon as I restart the server, server starts crashing when I log in.
Код:
[02:28:12] Incoming connection: 127.0.0.1:52572 [02:28:12] [join] Alex_Shock has joined the server (0:127.0.0.1) [02:28:12] SELECT IP FROM `playerdata` WHERE user = 'Alex_Shock' LIMIT 1 [02:28:12] results stored [02:28:12] register.. [02:28:23] UPDATE playerdata SET score=0, money=0, posx=1642.760986, posy=-2322.437744, posz=13.382812, skin=0, vw=0, interior=0, faction=0, factionrank=0, admin=0 WHERE user='Alex_Shock' [02:28:23] [part] Alex_Shock has left the server (0:1) left the server.. rejoined the server [02:28:56] Incoming connection: 127.0.0.1:57569 [02:28:56] [join] Alex_Shock has joined the server (0:127.0.0.1) [02:28:56] SELECT IP FROM `playerdata` WHERE user = 'Alex_Shock' LIMIT 1 [02:28:56] results stored [02:28:56] fetching ip... [02:28:56] ip fetched.. [02:28:56] Login dialog.. [02:28:59] SELECT * FROM playerdata WHERE user = 'Alex_Shock' Worked fine... Restarting... [02:37:52] Number of vehicle models: 12 [02:37:55] Incoming connection: 127.0.0.1:56678 [02:38:07] Incoming connection: 127.0.0.1:56681 [02:38:08] [join] Alex_Shock has joined the server (0:127.0.0.1) [02:38:08] SELECT IP FROM `playerdata` WHERE user = 'Alex_Shock' LIMIT 1 [02:38:08] results stored [02:38:08] fetching ip... [02:38:08] [debug] Server crashed while executing rp.amx [02:38:08] [debug] AMX backtrace: [02:38:08] [debug] #0 native mysql_fetch_field_row () [10006700] from mysql.DLL [02:38:08] [debug] #1 00004578 in public Itter_OnPlayerConnect () from rp.amx [02:38:08] [debug] #2 native CallLocalFunction () [00472c00] from samp-server.exe [02:38:08] [debug] #3 00001b80 in public OnPlayerConnect () from rp.amx [02:38:08] [debug] System backtrace: [02:38:08] [debug] #0 1000952e in ?? () from C:\Users\Christian\Desktop\MySQL Server\plugins\mysql.DLL [02:38:08] [debug] #1 100067d3 in ?? () from C:\Users\Christian\Desktop\MySQL Server\plugins\mysql.DLL [02:38:08] [debug] #2 004010b6 in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #3 5f1739e2 in AmxCallback () from C:\Users\Christian\Desktop\MySQL Server\plugins\crashdetect.DLL [02:38:08] [debug] #4 5f175e26 in amx_Exec () from C:\Users\Christian\Desktop\MySQL Server\plugins\crashdetect.DLL [02:38:08] [debug] #5 5f16bf3f in crashdetect::DoAmxExec () from C:\Users\Christian\Desktop\MySQL Server\plugins\crashdetect.DLL [02:38:08] [debug] #6 5f173a0e in AmxExec () from C:\Users\Christian\Desktop\MySQL Server\plugins\crashdetect.DLL [02:38:08] [debug] #7 00472f0e in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #8 004010b6 in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #9 5f1739e2 in AmxCallback () from C:\Users\Christian\Desktop\MySQL Server\plugins\crashdetect.DLL [02:38:08] [debug] #10 5f175e26 in amx_Exec () from C:\Users\Christian\Desktop\MySQL Server\plugins\crashdetect.DLL [02:38:08] [debug] #11 5f16bf3f in crashdetect::DoAmxExec () from C:\Users\Christian\Desktop\MySQL Server\plugins\crashdetect.DLL [02:38:08] [debug] #12 5f173a0e in AmxExec () from C:\Users\Christian\Desktop\MySQL Server\plugins\crashdetect.DLL [02:38:08] [debug] #13 0046d620 in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #14 00466bdf in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #15 004931b6 in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #16 77b7e023 in ?? () from C:\Windows\SysWOW64\ntdll.dll [02:38:08] [debug] #17 769114dd in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #18 00493271 in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #19 0048e524 in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #20 458d5151 in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #21 15ff50f8 in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #22 004a60c4 in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #23 8bf8458b in ?? () from C:\Users\Christian\Desktop\MySQL Server\samp-server.exe [02:38:08] [debug] #24 76911826 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #25 76932754 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #26 7692d4c4 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #27 76912d1c in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #28 76935fa5 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #29 76914608 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #30 7691e2a9 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #31 769140bc in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #32 769943af in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #33 7692f792 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #34 769153ae in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #35 76913f3c in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #36 769118f1 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #37 769154ee in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #38 769141d8 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #39 76995e32 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #40 76995d49 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #41 76937347 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #42 769134b5 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #43 769116c5 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #44 769b7339 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #45 76911136 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #46 76917a17 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #47 769187b1 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #48 7691326c in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #49 769189f1 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #50 7691e319 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #51 7693d4e6 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #52 76911328 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #53 769b6f6b in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #54 76913baa in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #55 76913c3a in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #56 76932b1c in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #57 7693d065 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #58 769111e0 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #59 769117b9 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #60 7693bc21 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #61 7693d191 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #62 7691179c in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #63 7692d5cd in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #64 76915171 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #65 76911946 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #66 7693824e in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #67 76911462 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #68 769945bf in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #69 769151cb in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #70 769151b3 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #71 7691e349 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #72 7691e331 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #73 769114b1 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #74 76914442 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #75 769149b2 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #76 76914347 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #77 76937717 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #78 77b7e046 in ?? () from C:\Windows\SysWOW64\ntdll.dll [02:38:08] [debug] #79 769114c9 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #80 77b924f1 in ?? () from C:\Windows\SysWOW64\ntdll.dll [02:38:08] [debug] #81 7693d1b3 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #82 77ba7fdc in ?? () from C:\Windows\SysWOW64\ntdll.dll [02:38:08] [debug] #83 76911450 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #84 7691588e in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #85 769179f8 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #86 76911245 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #87 7692d7ea in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #88 76911809 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #89 7693a82a in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #90 7693a941 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #91 7698d929 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #92 76915189 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #93 7691cb11 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #94 76913511 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #95 76910e00 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #96 76913597 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #97 76914a15 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #98 7691186e in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #99 76911856 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #100 7693d1dc in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #101 76914995 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #102 769111a9 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #103 76913567 in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #104 769114fb in ?? () from C:\Windows\syswow64\kernel32.dll [02:38:08] [debug] #105 77b8302a in ?? () from C:\Windows\SysWOW64\ntdll.dll
pawn Код:
public OnPlayerConnect(playerid)
{
SetPlayerColor(playerid, 0xFFFFFF00);
SpawnPlayer(playerid);
new query[200], pname[24];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "SELECT IP FROM `playerdata` WHERE user = '%s' LIMIT 1", pname);
mysql_query(query);
print(query);
mysql_store_result();
print("results stored");
new rows = mysql_num_rows();
if(!rows)
{
print("register..");
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Register","Your user is {FF0000}not{FFFFFF} registered! Please {0000FF}register{FFFFFF} with a password below!","Register","Cancel"); //Shows our register dialog :).
}
if(rows == 1)
{
new IP[2][16];
print("fetching ip...");
mysql_fetch_field_row(IP[0],"IP");
GetPlayerIp(playerid, IP[1], 16);
print("ip fetched..");
if(strlen(IP[0]) != 0 && !strcmp(IP[0], IP[1], true))
{
MySQL_Login(playerid);
print("MySQL login..");
}
else if(!strlen(IP[0]) || strcmp(IP[0], IP[1], true))
{
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login","Your user is {FF0000}registered{FFFFFF}! Please {0000FF}login{FFFFFF} with your password below!","Login","Cancel"); //Shows our login dialog :).
IsRegistered[playerid] = 1;
print("Login dialog..");
}
}
mysql_free_result();
return 1;
}