[Jackieboyhd]

I am just trying to code a basic vip script, but i can't even compile it because of this error.

Here's the code that gives the error:

format(string, sizeof(string), "UPDATE `uyeler` SET vip = %d WHERE k_adi = '%s'", "1" , plname);
--->> mysql_query(string); <<---

Thank you all for your help.

[Dayrion]

Код:

mysql_query(MySQL:handle, const query[], bool:use_cache = true)

In red, is what you are missing. If you don't know what is it, you may check some basic tutorial about MySQL for SAMP

[Jackieboyhd]

Every tutorial on the internet , It is always like this; mysql_query(string); . But I can't get rid of this error.
Here's all my code;

Quote:

#include <a_samp> #include <a_mysql> #include <sscanf> #include <zcmd> #define HOST "localhost" #define SUSER "root" #define PASS "123" #define DB "area51"

Quote:

public OnGameModeInit() { mysql_connect("HOST", "USER", "DB", "PASS"); return 1; }

Quote:

CMD: setvip(playerid, params[]) { new targetid, query[126], pName[MAX_PLAYER_NAME]; if(sscanf(params, "ud",targetid)) { SendClientMessage(playerid, COLOR_ERROR, "{6EF83C}Kullanım:{FFFFFF} /setvip [playerid]"); return 1; } if(IsPlayerConnected(targetid)) { GetPlayerName(targetid, pName, sizeof(pName)); format(query, sizeof(query), "UPDATE `uyeler` SET vip = '%d', WHERE k_adi = '%s'", 1, pName); mysql_query(query); <-- error 35: argument type mismatch (argument 1) } return 1; }

What should I change here ?

[ISmokezU]

PHP код:

//Assume You're using 39
new mysql;
CMD:setvip(playerid, params[])
{
    new targetid, query[126], pName[MAX_PLAYER_NAME];
    if(targetid == INVALID_PLAYER_ID) return SendClientMessage(playerid, COLOR_ERROR, "Invalid Player!");// A player could either be Connect/Disconnected.
    if(sscanf(params, "ud",targetid)) return SendClientMessage(playerid, COLOR_ERROR, "{6EF83C}Kullanım:{FFFFFF} /setvip [playerid]");
    GetPlayerName(targetid, pName, sizeof(pName));
    mysql_format(mysql, query, sizeof(query), "UPDATE uyeler SET vip = %d, WHERE k_adi = '%s'", 1, pName);// '' is more for %e and %s not %d. 
    mysql_tquery(mysql, query, "", "");
    return 1;
}] 


[Dayrion]

Quote:

Originally Posted by ISmokezU PHP код: //Assume You're using 39 new mysql; CMD:setvip(playerid, params[]) {     new targetid, query[126], pName[MAX_PLAYER_NAME];     if(targetid == INVALID_PLAYER_ID) return SendClientMessage(playerid, COLOR_ERROR, "Invalid Player!");// A player could either be Connect/Disconnected.     if(sscanf(params, "ud",targetid)) return SendClientMessage(playerid, COLOR_ERROR, "{6EF83C}Kullanım:{FFFFFF} /setvip [playerid]");     GetPlayerName(targetid, pName, sizeof(pName));     mysql_format(mysql, query, sizeof(query), "UPDATE uyeler SET vip = %d, WHERE k_adi = '%s'", 1, pName);// '' is more for %e and %s not %d.      mysql_tquery(mysql, query, "", "");     return 1; }]

You forget the MySQL tag.

PHP код:

new MySQL:mysql 


[Jackieboyhd]

Thank you both so much for your help. Now I can compile and start the server but when I use /setvip 0
the server console says

Quote:

sscanf warning: Format specifier does not match parameter count.

and it doesn't update the vip field to 1. By the way I'm using R34

[grymtn]

Код:

CMD: setvip(playerid, params[])
{
new targetid, query[126], pName[MAX_PLAYER_NAME];
if(sscanf(params, "ud",targetid)) //you asked sscanf to enter two params u and d (user id and integer) but you only asked for targetid where is your viplevel ?
{
SendClientMessage(playerid, COLOR_ERROR, "{6EF83C}Kullanım:{FFFFFF} /setvip [playerid]");
return 1;
}
if(IsPlayerConnected(targetid))
{
GetPlayerName(targetid, pName, sizeof(pName)); 
format(query, sizeof(query), "UPDATE `uyeler` SET vip = '%d', WHERE k_adi = '%s'", 1, pName);
mysql_query(query); <-- error 35: argument type mismatch (argument 1)
}
return 1;
}

you asked sscanf to enter two params u and d (user id and integer) but you only asked for targetid where is your viplevel ? by the way if you ask me this in turkish in pm i can answer you in turkish too forum bans language other than english inside the posts

[ISmokezU]

Quote:

Originally Posted by Dayrion You forget the MySQL tag. PHP код: new MySQL:mysql

R39 doesn't require one.

PHP код:

new mysql; 
CMD:setvip(playerid, params[]) 
{ 
    new targetid, query[126], pName[MAX_PLAYER_NAME]; 
    if(targetid == INVALID_PLAYER_ID) return SendClientMessage(playerid, COLOR_ERROR, "Invalid Player!");
    if(sscanf(params, "i", targetid)) return SendClientMessage(playerid, COLOR_ERROR, "{6EF83C}Kullanım:{FFFFFF} /setvip [playerid]"); 
    GetPlayerName(targetid, pName, sizeof(pName)); 
    mysql_format(mysql, query, sizeof(query), "UPDATE uyeler SET vip = %d, WHERE k_adi = '%s'", 1, pName);
    mysql_tquery(mysql, query, "", ""); 
    return 1; 
}] 


[Jackieboyhd]

Now it doesn't give any errors but when i make myself vip it doesn't do anything at all. No errors, no reaction, nothing. No change in the database aswell.
It doesn't even warn when i use the wrong id.

Quote:

if(targetid == INVALID_PLAYER_ID) return SendClientMessage(playerid, COLOR_ERROR, "Invalid Player!");