Mysql problem. Need help - Printable Version

Mysql problem. Need help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql problem. Need help (/showthread.php?tid=556464)

Mysql problem. Need help - an4rei - 10.01.2015

Hello , I'm trying to update an column with some given data but it doesn't work.

Код:

                        new string1[256];
	                format(string1, sizeof(string1), "UPDATE players SET `Approved`='%s' WHERE `Name` = '%s'",tmp, giveplayer);
                        mysql_query(string1);

Re: Mysql problem. Need help - bgedition - 10.01.2015

Try with this:

pawn Код:

new query[300];
mysql_format(/*YOUR MYSQL HANDLE*/, query, sizeof(query), "UPDATE players SET `Approved`='%s' WHERE `Name` = '%s'",tmp, giveplayer);
mysql_tquery(/*YOUR MYSQL HANDLE*/, query, "", "");

Re: Mysql problem. Need help - an4rei - 10.01.2015

Kinda new to mysql things.

What am I supposed to write instead of

Quote:

/*YOUR MYSQL HANDLE*/

and between

Quote:

"", "");

Re: Mysql problem. Need help - Riddick94 - 10.01.2015

What MySQL version do you use?

Re: Mysql problem. Need help - an4rei - 10.01.2015

Quote:

Originally Posted by Riddick94

What MySQL version do you use?

MYSQL R5

Re: Mysql problem. Need help - bgedition - 10.01.2015

Update your mysql plugin and then use this:
Example for "/*YOUR MYSQL HANDLE*/":

pawn Код:

#define mysql_host "127.0.0.1"
#define mysql_user "root"
#define mysql_password "" 
#define mysql_database "samp"

new mysql_handle;

public OnGameModeInit() {
    mysql_hadle = mysql_connect(mysql_host, mysql_user, mysql_database, mysql_password);
    return 1;
}

and this is not necessarily:
"", "");

Re: Mysql problem. Need help - an4rei - 10.01.2015

Did the next thing:

defined host , user , etc. then

pawn Код:

new mysql_handle; //at the begining of the .pawn file

public OnGameModeInit()
{
    mysql_handle = mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
    //mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
    mysql_debug(1);
//just the part with mysql from onGamemodeInit()

//then , like 2000 lines after

                        new query[300];
                        mysql_format(mysql_handle, query, sizeof(query), "UPDATE players SET `Approved`='%s' WHERE `Name` = '%s'",tmp, giveplayer);
                        mysql_tquery(mysql_handle, query, "", "");

and got the next errors:

Quote:

error 017: undefined symbol "mysql_format"
error 017: undefined symbol "mysql_tquery"
warning 204: symbol is assigned a value that is never used: "mysql_handle"

Re: Mysql problem. Need help - an4rei - 10.01.2015

Also , I've updated to the newest mysql version R39-2

Re: Mysql problem. Need help - bgedition - 10.01.2015

EDIT: I don't know what is wrong.

Post your problem in MYSQL topic

Re: Mysql problem. Need help - an4rei - 10.01.2015

Well , damn.

I had to restart pawno and then re-compile.... got tons of errors.

Quote:

C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(400

: error 017: undefined symbol "mysql_store_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(4009) : error 017: undefined symbol "mysql_num_rows"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(4040) : error 017: undefined symbol "mysql_store_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(4041) : error 017: undefined symbol "mysql_num_rows"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(4043) : error 017: undefined symbol "mysql_free_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(404

: error 017: undefined symbol "mysql_free_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(4060) : error 017: undefined symbol "mysql_store_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(4061) : error 017: undefined symbol "mysql_num_rows"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(4063) : error 017: undefined symbol "mysql_free_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(406

: error 017: undefined symbol "mysql_free_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(764

: error 017: undefined symbol "mysql_store_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(7649) : error 017: undefined symbol "mysql_num_rows"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(7651) : error 017: undefined symbol "mysql_fetch_row"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(7697) : error 017: undefined symbol "mysql_free_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(7967) : error 017: undefined symbol "mysql_store_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(796

: error 017: undefined symbol "mysql_num_rows"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(7970) : error 017: undefined symbol "mysql_fetch_row"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(7981) : error 017: undefined symbol "mysql_free_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(8059) : error 017: undefined symbol "mysql_store_result"
C:\Users\user\Desktop\New folder (5)\gamemodes\pfew.pwn(8060) : error 017: undefined symbol "mysql_num_rows"