Mysql problem - 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 (
/showthread.php?tid=307540)
Mysql problem -
Tanush123 - 30.12.2011
pawn Код:
CMD:oskin(playerid,params[])
{
new oskin1,oskin2;
if(PlayerInfo[playerid][Member] == -255) return 0;
CheckMySQL();
format(str, sizeof(str), "SELECT * FROM orgs WHERE Orgid = '%d'",orgid);
mysql_query(str);
mysql_store_result();
while(mysql_retrieve_row())
{
mysql_fetch_field_row(str,"Skin1"); oskin1 = strval(str);
mysql_fetch_field_row(str,"Skin2"); oskin2 = strval(str);
if(GetPlayerSkin(playerid) == oskin1)
{
SetPlayerSkin(playerid,oskin2);
}
else if(GetPlayerSkin(playerid) == oskin2)
{
SetPlayerSkin(playerid,oskin1);
}
}
mysql_free_result();
return 1;
}
Well nothing happens when i does /oskin? im noob in mysql still so can you guys help
Re: Mysql problem -
FireCat - 30.12.2011
Not very efficient cuz it's late and Im tired...
pawn Код:
CMD:oskin(playerid,params[])
{
new oskin1,oskin2;
if(PlayerInfo[playerid][Member] == -255) return 0;
CheckMySQL();
format(str, sizeof(str), "SELECT Skin1 FROM orgs WHERE Orgid = '%d'",orgid);
mysql_query(str);
mysql_store_result();
oskin1 = mysql_fetch_int(str);
mysql_free_result();
format(str, sizeof(str), "SELECT Skin2 FROM orgs WHERE Orgid = '%d'",orgid);
mysql_query(str);
mysql_store_result();
oskin2 = mysql_fetch_int(str);
if(GetPlayerSkin(playerid) == oskin1)
{
SetPlayerSkin(playerid,oskin2);
}
else if(GetPlayerSkin(playerid) == oskin2)
{
SetPlayerSkin(playerid,oskin1);
}
}
mysql_free_result();
return 1;
}
Re: Mysql problem -
Tanush123 - 01.01.2012
pawn Код:
D:\Users\Tanush\Desktop\SA-MP SERVERS\SA-MP Server Stunt\gamemodes\server.pwn(4382) : error 035: argument type mismatch (argument 1)
D:\Users\Tanush\Desktop\SA-MP SERVERS\SA-MP Server Stunt\gamemodes\server.pwn(4387) : error 035: argument type mismatch (argument 1)
pawn Код:
first error: oskin1 = mysql_fetch_int(str);
second error: oskin2 = mysql_fetch_int(str);
Re: Mysql problem -
THE_KNOWN - 01.01.2012
pawn Код:
CMD:oskin(playerid,params[])
{
new oskin1,oskin2;
if(PlayerInfo[playerid][Member] == -255) return 0;
CheckMySQL();
format(str, sizeof(str), "SELECT Skin1 FROM orgs WHERE Orgid = %d",orgid);
mysql_query(str);
mysql_store_result();
oskin1 = mysql_fetch_int();
mysql_free_result();
format(str, sizeof(str), "SELECT Skin2 FROM orgs WHERE Orgid = %d",orgid);
mysql_query(str);
mysql_store_result();
oskin2 = mysql_fetch_int();
if(GetPlayerSkin(playerid) == oskin1)
{
SetPlayerSkin(playerid,oskin2);
}
else if(GetPlayerSkin(playerid) == oskin2 || GetPlayerSkin(playerid) != oskin1)
{
SetPlayerSkin(playerid,oskin1);
}
}
mysql_free_result();
return 1;
}
Re: Mysql problem -
Tanush123 - 01.01.2012
thanks