D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(83) : error 017: undefined symbol "mysql_query" D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(114) : error 017: undefined symbol "mysql_query" D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(153) : error 017: undefined symbol "mysql_query" D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(175) : error 017: undefined symbol "mysql_query" D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(178) : error 017: undefined symbol "mysql_query" D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(217) : error 017: undefined symbol "mysql_query" D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(251) : error 017: undefined symbol "mysql_query" D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(427) : error 017: undefined symbol "mysql_query" D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(454) : error 017: undefined symbol "mysql_query" D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(465) : error 017: undefined symbol "mysql_query" Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 10 Errors.
// This is a comment
// uncomment the line below if you want to write a filterscript
//#define FILTERSCRIPT
#include <a_samp>
#include <a_mysql>
#include <zcmd>
#include <sscanf2>
#define mysql_host "127.0.0.1" //Has to be a string
#define mysql_user "root" //Has to be a string
#define mysql_password "" //There is none for wamp unless you set one.
#define mysql_database "sa-mp" //Has to be a string
#define COL_GREEN "{6EF83C}"
#define COL_RED "{F81414}"
#define COL_BLUE "{00C0FF}"
#define embed_blue "{00C0FF}"
#define embed_red "{FF0000}"
#define embed_white "{FFFFFF}"
#define embed_green "{33FF33}"
#define embed_yellow "{E8D04C}"
#define embed_grey "{C0C0C0}"
#define embed_orange "{FF9900}"
#define embed_pink "{FF66FF}"
#define embed_lblue "{00AFFF}"
#define embed_sw "{ED136A}"
#define ERROR 0xFF0000AA
#define SYSTEM 0x375FFFFF
#define blue 0x375FFFFF
#define red 0xFF0000FF
#define white 0xFFFFFFFF
#define green 0x33FF33FF
#define yellow 0xFFFF00FF
#define grey 0xC0C0C0FF
#define orange 0xFF9900FF
#define pink 0xFF66FFFF
new IsRegistered[MAX_PLAYERS];
new Pname[24];
new MoneyGiven[MAX_PLAYERS];
new Logged[MAX_PLAYERS];
new AdminL[MAX_PLAYERS];
new Banned[MAX_PLAYERS];
new Kills[MAX_PLAYERS];
new Deaths[MAX_PLAYERS];
public OnFilterScriptInit()
{
print("\n--------------------------------------");
print(" Blank Filterscript by your name here");
print("--------------------------------------\n");
return 1;
}
public OnFilterScriptExit()
{
return 1;
}
main()
{
print("\n----------------------------------");
print(" SA-MP Border Attacks");
print("----------------------------------\n");
}
public OnGameModeInit()
{
mysql_connect(mysql_host, mysql_user, mysql_database, mysql_password);
mysql_query("CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(41), score INT(20), money INT(20), IP VARCHAR(16), level INT(20), ban INT(20), kills INT(20), deaths INT(20))");
//Fields:
//Field Name - Use - Type
//user- Player Name - String
//password- Players password - String
//score - Players score - int
//money - Players Cash - int
//IP - Players IP - int
SetGameModeText("Border Line");
AddPlayerClass(281,1524.9503,-1677.9791,5.8906,270.5254,31,200,29,120,22,50); // Police
return 1;
}
public OnGameModeExit()
{
return 1;
}
public OnPlayerRequestClass(playerid, classid)
{
//Your code for Requesting class
return 1;
}
public OnPlayerConnect(playerid)
{
MoneyGiven[playerid] = -1;
new query[200], pName[MAX_PLAYER_NAME],string[140];
TogglePlayerSpectating(playerid,0);
GetPlayerName(playerid, pName,sizeof(pName));
format(query, sizeof(query), "SELECT IP FROM `playerdata` WHERE user = '%s' LIMIT 1", pName);
mysql_query(query);
mysql_store_result();
new rows = mysql_num_rows();
if(!rows)
{
format(string, sizeof(string), "{FFFFFF}Welcome "COL_BLUE"%s(%d){FFFFFF} to the server, you're "COL_RED"not{FFFFFF} registered\n\nPlease log in by inputting your password.", pName, playerid);
ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_INPUT, "Register",string,"Register","Cancel"); //Shows our register dialog :).
}
if(rows == 1)
{
new IP[2][16];
mysql_fetch_field_row(IP[0],"IP");
GetPlayerIp(playerid, IP[1], 16);
if(strlen(IP[0]) != 0 && !strcmp(IP[0], IP[1], true))
{
MySQL_Login(playerid);
}
else if(!strlen(IP[0]) || strcmp(IP[0], IP[1], true))
{
format(string, sizeof(string), "{FFFFFF}Welcome "COL_BLUE"%s(%d){FFFFFF} to the server, you're registered\n\nPlease log in by inputting your password.", pName, playerid);
ShowPlayerDialog(playerid, 15500, DIALOG_STYLE_INPUT, "Login",string,"Login","Cancel");
IsRegistered[playerid] = 1;
}
}
mysql_free_result();
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
if(Logged[playerid] == 1)
{
new score = GetPlayerScore(playerid);
new money = GetPlayerMoney(playerid);
new query[200], pname[24];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "UPDATE playerdata SET score=%d, money=%d, level=%d, ban=%d, kills=%d, deaths=%d WHERE user='%s'", score, money, pname);
mysql_query(query);
}
return 1;
}
public OnPlayerSpawn(playerid)
{
if(MoneyGiven[playerid] != -1)
{
GivePlayerMoney(playerid, MoneyGiven[playerid]);
MoneyGiven[playerid] = -1;
}
return 1;
}
public OnPlayerDeath(playerid, killerid, reason)
{
new str[128];
Kills[killerid]++;
Deaths[playerid]++;
format(str, sizeof(str), "UPDATE `playerdata` SET `kills` = %d WHERE `User` = '%s'", Kills[killerid], PlayerName(killerid));
mysql_query(str);
format(str, sizeof(str), "UPDATE `playerdata` SET `deaths` = %d WHERE `User` = '%s'", Deaths[playerid], PlayerName(playerid));
mysql_query(str);
return 1;
}
public OnVehicleSpawn(vehicleid)
{
return 1;
}
public OnVehicleDeath(vehicleid, killerid)
{
return 1;
}
public OnPlayerText(playerid, text[])
{
return 1;
}
public OnPlayerCommandText(playerid, cmdtext[])
{
return 0;
}
CMD:setlevel(playerid, params[])
{
new
id,
level,
str[158]
;
if(AdminL[playerid] >= 5 || IsPlayerAdmin(playerid))
{
if(sscanf(params, "ui", id, level))
{
return SendClientMessage(playerid, 0x0FB4F5FF, "Usage: /setlevel (playerid) (level)") &&
SendClientMessage(playerid, 0x7EF50FFF, "Function: Set a person a admin");
}
if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, 0xF50F35FF, "ERROR: That is a invalid player ID");
format(str, sizeof(str), "UPDATE `playerdata` SET `level` = %d WHERE `User` = '%s'", level, PlayerName(id));
mysql_query(str);
format(str, sizeof(str), ""embed_sw"[ADMIN]"embed_white"Administrator "embed_sw"%s "embed_white"has made "embed_sw"%s "embed_blue"(%d) "embed_white"admin level "embed_orange"%d"embed_white"!", PlayerName(playerid), PlayerName(id), id, level);
SendClientMessageToAll(0xF5C70FFF, str);
AdminL[playerid] = level;
}
else SendClientMessage(playerid, 0xF50F35FF, "ERROR: You are not a level 5 admin!");
return 1;
}
CMD:ban(playerid,params[])
{
new
id,
str[128],
reason[74]
;
if(AdminL[playerid] >=3)
{
if(sscanf(params,"uS(No Reason)[78]", id, reason)) return SendClientMessage(playerid, yellow, "[Usage]"embed_grey "/ban [Part Of Name/ID] [Reason]");
if(!IsPlayerConnected(id)) return SendClientMessage(playerid, red, "[ERROR]"embed_grey "That player is not connected");
format(str, sizeof(str),""embed_sw"[ADMIN]"embed_white"You are banned by admin "embed_blue"%s "embed_white"for: {ED136A}%s", PlayerName(playerid), reason);
SendClientMessage(id, white, str);
format(str, sizeof(str),""embed_sw"[ADMIN]"embed_white"You banned "embed_blue"%s "embed_white"for: {ED136A}%s", PlayerName(id), reason);
SendClientMessage(playerid, white, str);
format(str, sizeof(str),""embed_sw"[ADMIN]"embed_white"Admin "embed_blue"%s "embed_white"banned "embed_blue"%s "embed_white"for: {ED136A}%s",PlayerName(playerid),PlayerName(id), reason);
SendClientMessageToAll( white, str);
Ban(id);
Banned[id] = 1;
format(str, sizeof(str), "UPDATE `playerdata` SET `ban` = %d WHERE `User` = '%s'", Banned[id], PlayerName(id));
mysql_query(str);
}
else SendClientMessage(playerid, 0xF50F35FF, "ERROR: You are not a level 3 admin!");
return 1;
}
public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
return 1;
}
public OnPlayerExitVehicle(playerid, vehicleid)
{
return 1;
}
public OnPlayerStateChange(playerid, newstate, oldstate)
{
return 1;
}
public OnPlayerEnterCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveCheckpoint(playerid)
{
return 1;
}
public OnPlayerEnterRaceCheckpoint(playerid)
{
return 1;
}
public OnPlayerLeaveRaceCheckpoint(playerid)
{
return 1;
}
public OnRconCommand(cmd[])
{
return 1;
}
public OnPlayerRequestSpawn(playerid)
{
return 1;
}
public OnObjectMoved(objectid)
{
return 1;
}
public OnPlayerObjectMoved(playerid, objectid)
{
return 1;
}
public OnPlayerPickUpPickup(playerid, pickupid)
{
return 1;
}
public OnVehicleMod(playerid, vehicleid, componentid)
{
return 1;
}
public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
return 1;
}
public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
return 1;
}
public OnPlayerSelectedMenuRow(playerid, row)
{
return 1;
}
public OnPlayerExitedMenu(playerid)
{
return 1;
}
public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
return 1;
}
public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
return 1;
}
public OnRconLoginAttempt(ip[], password[], success)
{
return 1;
}
public OnPlayerUpdate(playerid)
{
return 1;
}
public OnPlayerStreamIn(playerid, forplayerid)
{
return 1;
}
public OnPlayerStreamOut(playerid, forplayerid)
{
return 1;
}
public OnVehicleStreamIn(vehicleid, forplayerid)
{
return 1;
}
public OnVehicleStreamOut(vehicleid, forplayerid)
{
return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
if(dialogid == 15000)
{
if(response)
{
if(!strlen(inputtext) || strlen(inputtext) > 100)
{
new string[150],pName[MAX_PLAYER_NAME];
GetPlayerName(playerid,pName,sizeof(pName));
format(string, sizeof(string), "{FFFFFF}Welcome "COL_BLUE"%s(%d){FFFFFF} to the server, you're "COL_RED"not{FFFFFF} registered\n\nPlease log in by inputting your password.", pName, playerid);
SendClientMessage(playerid, 0xFF0000, "{ED478A}[INFO]{FFFFFF}You must insert a password between 1-100 characters!");
ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_INPUT, "{FFFFFF}Register",string,"Register","Cancel");
}
else if(strlen(inputtext) > 0 && strlen(inputtext) < 100)
{
new escpass[100];
mysql_real_escape_string(inputtext, escpass);
MySQL_Register(playerid, escpass);
}
}
if(!response)
{
new string[150],pName[MAX_PLAYER_NAME];
GetPlayerName(playerid,pName,sizeof(pName));
format(string, sizeof(string), "{FFFFFF}Welcome "COL_BLUE"%s(%d){FFFFFF} to the server, you're "COL_RED"not{FFFFFF} registered\n\nPlease log in by inputting your password.", pName, playerid);
SendClientMessage(playerid, 0xFF0000, "{ED478A}[INFO]{FFFFFF}You must register before logging in!");
ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_INPUT, "{FFFFFF}Register",string,"Register","Cancel");
}
}
if(dialogid == 15500)
{
if(!response)
{
new string[120],pName[MAX_PLAYER_NAME];
GetPlayerName(playerid,pName,sizeof(pName));
SendClientMessage(playerid, 0xFF0000, "{ED478A}[INFO]{FFFFFF}You must login before you spawn!");
format(string, sizeof(string), "{FFFFFF}Welcome "COL_BLUE"%s(%d){FFFFFF} to the server, you're registered\n\nPlease log in by inputting your password.", pName, playerid);
ShowPlayerDialog(playerid, 15500, DIALOG_STYLE_INPUT, "{FFFFFF}Login",string,"Login","Cancel");
}
if(response)
{
new query[200], pName[MAX_PLAYER_NAME], escapepass[100];
GetPlayerName(playerid, pName, sizeof(pName));
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);
if(!numrows)
{
new string[120];
format(string, sizeof(string), "{FFFFFF}Welcome "COL_BLUE"%s(%d){FFFFFF} to the server, you're registered\n\nPlease log in by inputting the correct password.", pName, playerid);
ShowPlayerDialog(playerid, 15500, DIALOG_STYLE_INPUT, "Login",string,"Login","Cancel"); //Shows our login dialog :).
SendClientMessage(playerid, 0xFF0000, "{ED478A}[INFO]{FFFFFF}Incorrect password!"); //Sends the client a error message
}
mysql_free_result();
}
}
return 1;
}
public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
return 1;
}
stock MySQL_Register(playerid, passwordstring[])
{
new query[200], pname[24], IP[16];
GetPlayerName(playerid, pname, 24);
GetPlayerIp(playerid, IP, 16);
format(query, sizeof(query), "INSERT INTO playerdata (user, password, score, money, IP, level, ban, kills, deaths) VALUES('%s', SHA1('%s'), 0, 0, '%s', 0, 0, 0, 0)", pname, passwordstring, IP);
mysql_query(query);
SendClientMessage(playerid, -1, "{ED478A}[INFO]{FFFFFF}You have been registered on this server!");
Logged[playerid] = 1;
return 1;
}
stock MySQL_Login(playerid)
{
new query[300], pname[24], savingstring[20];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "SELECT * FROM playerdata WHERE user = '%s'", pname);
mysql_query(query);
mysql_store_result();
while(mysql_fetch_row_format(query,"|"))
{
mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
mysql_fetch_field_row(savingstring, "level"); AdminL[playerid] = strval(savingstring);
mysql_fetch_field_row(savingstring, "ban"); Banned[playerid] = strval(savingstring);
mysql_fetch_field_row(savingstring, "kills"); Kills[playerid] = strval(savingstring);
mysql_fetch_field_row(savingstring, "deaths"); Deaths[playerid] = strval(savingstring);
}
mysql_free_result();
SendClientMessage(playerid, -1, "{ED478A}[INFO]{FFFFFF}You have been logged in!");
Logged[playerid] = 1;
if(Banned[playerid] == 1)
{
SendClientMessage(playerid, -1, "{ED478A}[ANTI-CHEAT]{FFFFFF}You have been already banned!");
Kick(playerid);
}
return 1;
}
stock PlayerName(playerid)
{
GetPlayerName(playerid, Pname, 24);
return Pname;
}
-------------------------- SA-MP Server: 0.3e Exception At Address: 0x71B2B9F0 Module: (MSVCR90.dll) Registers: EAX: 0x004AEFB8 EBX: 0x03238F74 ECX: 0x61746544 EDX: 0x0269DBB8 ESI: 0x0018E96C EDI: 0x01DA2840 EBP: 0x0018E930 ESP: 0x0018E924 EFLAGS: 0x00010246 Stack: +0000: 0x71BA5DB4 0x61746544 0x01DA2840 0x0018E964 +0010: 0x002D952E 0x61746544 0x355E9A3C 0x0018E96C +0020: 0x03238F74 0x0269DBB8 0x71BA72AA 0x00000000 +0030: 0x00000000 0x0018E9C8 0x002D9FFD 0x00000000 +0040: 0x0018E9D4 0x002D67D3 0x002D9EDB 0x00005049 +0050: 0x0018E9D4 0x002D67AF 0x0018E9A0 0x00000002 +0060: 0x0000000F 0x355E9A8C 0x00000001 0x0018E96C +0070: 0x029DFB70 0x0018F06C 0x0018E96C 0xFFFFFFFF +0080: 0x00005049 0x002D88EF 0x002DD180 0x00000001 +0090: 0x00000002 0x0000000F 0x355E9A8C 0x0269DBB8 +00A0: 0x00000000 0x0018F06C 0x002DA150 0x00000000 +00B0: 0x0323F894 0x004010B6 0x01DA2840 0x0324E95C +00C0: 0x03241C00 0x00402B63 0x01DA2840 0x00000015 +00D0: 0x0018EA0C 0x0324E95C 0x0018EEA4 0x00000000 +00E0: 0x0324EFC4 0x01DA2840 0x0000CD74 0x0000CD6C +00F0: 0x0000CD5C 0x0000D3B8 0x0000943C 0x0000D3A8 +0100: 0x0000943C 0x03238F74 0x03241C00 0x00000000 +0110: 0x03238668 0x00008C8C 0x0047256E 0x01DA2840 +0120: 0x0018EE94 0x0000002A 0x00470069 0x41435353 +0130: 0x4F5F464E 0x616C506E 0x43726579 0x656E6E6F -------------------------- Loaded Modules: samp-server.exe A: 0x00400000 - 0x004EE000 (D:\SWAT\samp03dsvr_win32(1)\samp-server.exe) ntdll.dll A: 0x778A0000 - 0x77A20000 (C:\Windows\SysWOW64\ntdll.dll) kernel32.dll A: 0x763D0000 - 0x764D0000 (C:\Windows\syswow64\kernel32.dll) KERNELBASE.dll A: 0x762B0000 - 0x762F6000 (C:\Windows\syswow64\KERNELBASE.dll) SHELL32.dll A: 0x75280000 - 0x75EC9000 (C:\Windows\syswow64\SHELL32.dll) msvcrt.dll A: 0x76320000 - 0x763CC000 (C:\Windows\syswow64\msvcrt.dll) SHLWAPI.dll A: 0x76560000 - 0x765B7000 (C:\Windows\syswow64\SHLWAPI.dll) GDI32.dll A: 0x75F00000 - 0x75F90000 (C:\Windows\syswow64\GDI32.dll) USER32.dll A: 0x76E40000 - 0x76F40000 (C:\Windows\syswow64\USER32.dll) ADVAPI32.dll A: 0x76A80000 - 0x76B20000 (C:\Windows\syswow64\ADVAPI32.dll) sechost.dll A: 0x76300000 - 0x76319000 (C:\Windows\SysWOW64\sechost.dll) RPCRT4.dll A: 0x76990000 - 0x76A80000 (C:\Windows\syswow64\RPCRT4.dll) SspiCli.dll A: 0x74F90000 - 0x74FF0000 (C:\Windows\syswow64\SspiCli.dll) CRYPTBASE.dll A: 0x74F80000 - 0x74F8C000 (C:\Windows\syswow64\CRYPTBASE.dll) LPK.dll A: 0x750E0000 - 0x750EA000 (C:\Windows\syswow64\LPK.dll) USP10.dll A: 0x76F40000 - 0x76FDD000 (C:\Windows\syswow64\USP10.dll) WSOCK32.dll A: 0x72180000 - 0x72187000 (C:\Windows\system32\WSOCK32.dll) WS2_32.dll A: 0x765D0000 - 0x76605000 (C:\Windows\syswow64\WS2_32.dll) NSI.dll A: 0x75FE0000 - 0x75FE6000 (C:\Windows\syswow64\NSI.dll) WINMM.dll A: 0x710B0000 - 0x710E2000 (C:\Windows\system32\WINMM.dll) IMM32.DLL A: 0x75020000 - 0x75080000 (C:\Windows\system32\IMM32.DLL) MSCTF.dll A: 0x76C50000 - 0x76D1C000 (C:\Windows\syswow64\MSCTF.dll) sscanf.dll A: 0x10000000 - 0x1000C000 (D:\SWAT\samp03dsvr_win32(1)\plugins\sscanf.dll) MSVCR100.dll A: 0x6AA90000 - 0x6AB4F000 (C:\Windows\system32\MSVCR100.dll) streamer.dll A: 0x6ABD0000 - 0x6AC0B000 (D:\SWAT\samp03dsvr_win32(1)\plugins\streamer.dll) MSVCP90.dll A: 0x71BA0000 - 0x71C2E000 (C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCP90.dll) MSVCR90.dll A: 0x71AF0000 - 0x71B93000 (C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_50934f2ebcb7eb57\MSVCR90.dll) mysql.dll A: 0x002D0000 - 0x002E3000 (D:\SWAT\samp03dsvr_win32(1)\plugins\mysql.dll) LIBMYSQL.dll A: 0x02760000 - 0x028A1000 (D:\SWAT\samp03dsvr_win32(1)\LIBMYSQL.dll) NLAapi.dll A: 0x71050000 - 0x71060000 (C:\Windows\system32\NLAapi.dll) mswsock.dll A: 0x70F40000 - 0x70F7C000 (C:\Windows\System32\mswsock.dll) DNSAPI.dll A: 0x6D430000 - 0x6D474000 (C:\Windows\system32\DNSAPI.dll) winrnr.dll A: 0x71040000 - 0x71048000 (C:\Windows\System32\winrnr.dll) napinsp.dll A: 0x71030000 - 0x71040000 (C:\Windows\system32\napinsp.dll) pnrpnsp.dll A: 0x71010000 - 0x71022000 (C:\Windows\system32\pnrpnsp.dll) WLIDNSP.DLL A: 0x70FE0000 - 0x71007000 (C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live\WLIDNSP.DLL) PSAPI.DLL A: 0x77870000 - 0x77875000 (C:\Windows\syswow64\PSAPI.DLL) wshbth.dll A: 0x70FD0000 - 0x70FDD000 (C:\Windows\system32\wshbth.dll) rasadhlp.dll A: 0x70F80000 - 0x70F86000 (C:\Windows\system32\rasadhlp.dll) wshtcpip.dll A: 0x70F30000 - 0x70F35000 (C:\Windows\System32\wshtcpip.dll) IPHLPAPI.DLL A: 0x72CE0000 - 0x72CFC000 (C:\Windows\system32\IPHLPAPI.DLL) WINNSI.DLL A: 0x72D50000 - 0x72D57000 (C:\Windows\system32\WINNSI.DLL)
|
Download the R6 plugin or try to replace mysql_query with mysql_function_query
Because in R7 Plugin the mysql_query was removed or replaced with mysql_function_query. |
mysql_function_query(dbHandle,"CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(41), score INT(20), money INT(20), IP VARCHAR(16), level INT(20), ban INT(20), kills INT(20), deaths INT(20))","","");
D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(83) : error 017: undefined symbol "dbHandle"
new dbHandle;
mysql_function_query(dbHandle,"CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(41), score INT(20), money INT(20), IP VARCHAR(16), level INT(20), ban INT(20), kills INT(20), deaths INT(20))","","");
D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(85) : error 035: argument type mismatch (argument 3)
mysql_function_query(dbHandle,"CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(41), score INT(20), money INT(20), IP VARCHAR(16), level INT(20), ban INT(20), kills INT(20), deaths INT(20))",false,"");
|
mysql_function_query( connectionHandle, query[], bool:cache, callback[], format[], {Float,_}:... )
|