[an4rei]

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);

[bgedition]

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, "", "");

[an4rei]

Kinda new to mysql things.

What am I supposed to write instead of

Quote:

/*YOUR MYSQL HANDLE*/

and between

Quote:

"", "");

[Riddick94]

What MySQL version do you use?

[an4rei]

Quote:

Originally Posted by Riddick94 What MySQL version do you use?

MYSQL R5

[bgedition]

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:
"", "");

[an4rei]

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"

[an4rei]

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

[bgedition]

EDIT: I don't know what is wrong.

Post your problem in MYSQL topic

[an4rei]

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"