1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
MySQL problem
Sanady
High-roller
*****
Posts: 1,174
Threads: 251
Joined: May 2012
Reputation: 0
#1

29.07.2012, 09:00
Hello.I loaded MySQL but it`s giving me those errors
Код:
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.
Here is Pawno code
pawn Код:
// 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;
}
-Please help me.Thanks
Find
Reply
Sanady
High-roller
*****
Posts: 1,174
Threads: 251
Joined: May 2012
Reputation: 0
#2

29.07.2012, 09:13
Can anyone help me..I need this fast.(sorry for double posting but I need to fix it fast!)
Find
Reply
Sanady
High-roller
*****
Posts: 1,174
Threads: 251
Joined: May 2012
Reputation: 0
#3

29.07.2012, 10:54
Anyone can help me??(Sorry bumping but need this fast!!)

Crash info
Код:


--------------------------

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)
Find
Reply
TheDeath
Big Clucker
***
Posts: 136
Threads: 42
Joined: Jan 2011
Reputation: 0
#4

29.07.2012, 10:57
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.
Find
Reply
Sanady
High-roller
*****
Posts: 1,174
Threads: 251
Joined: May 2012
Reputation: 0
#5

29.07.2012, 11:08
Quote:
Originally Posted by TheDeath
Посмотреть сообщение
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.
But When I change to mysql_function_query I need to rescript whole register system with admin system too?
Find
Reply
Sanady
High-roller
*****
Posts: 1,174
Threads: 251
Joined: May 2012
Reputation: 0
#6

29.07.2012, 11:24
This is problem
pawn Код:
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))","","");
Error
Код:
D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(83) : error 017: undefined symbol "dbHandle"
Please Help me!
Find
Reply
Mark™
Unregistered
 
#7

29.07.2012, 11:27
pawn Код:
new dbHandle;
Reply
Sanady
High-roller
*****
Posts: 1,174
Threads: 251
Joined: May 2012
Reputation: 0
#8

29.07.2012, 11:30
Now this one:
pawn Код:
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))","","");
ERROR:
Код:
D:\SWAT\samp03dsvr_win32(1)\gamemodes\MySQLtest.pwn(85) : error 035: argument type mismatch (argument 3)
-Help me please!!
Find
Reply
Mark™
Unregistered
 
#9

29.07.2012, 11:33
Check the third parameter.

mysql_function_query( connectionHandle, query[], bool:cache, callback[], format[], {Float,_}:... )

pawn Код:
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,"");
Reply
Sanady
High-roller
*****
Posts: 1,174
Threads: 251
Joined: May 2012
Reputation: 0
#10

29.07.2012, 11:34
Quote:
Originally Posted by Xtreme_playa
Посмотреть сообщение
mysql_function_query( connectionHandle, query[], bool:cache, callback[], format[], {Float,_}:... )
What that connectionHandle means?...This new MySQL update is big sh*t!!!
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 3 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help