Problem MYSQL R7 - 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: Problem MYSQL R7 (/showthread.php?tid=452059)
+- 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: Problem MYSQL R7 (/showthread.php?tid=452059)
Problem MYSQL R7 - HitnKill - 19.07.2013
Hi, i want to upgrade my mysql plugin R6 to R7, i want to do it gradually. I want to use cache but not directly for try my query.
Exemply why this query don't work? I read to this post https://sampforum.blast.hk/showthread.php?tid=56564 mysql_num_rows it's okay on R7.
PHP код:
GetUserCreate(playerid)
{
new query[130];
format(query,sizeof(query),"SELECT PlayerID FROM `comptes` WHERE Pseudo = '%s' LIMIT 1",GetPlayerNameEx(playerid));
mysql_function_query(ConnexionBDD, query, false, "", "");
mysql_store_result();
if(mysql_num_rows() > 0)
{
return 1;
}
mysql_free_result();
return 0;
}
Quote:
|
[20:41:00] Passing query SELECT PlayerID FROM `comptes` WHERE Pseudo = 'Soze' LIMIT 1 | [20:41:00] ProcessQueryThread() - Query was successful. (SELECT PlayerID FROM `dm_comptes` WHERE Pseudo = 'Soze' LIMIT 1) [20:41:00] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick() |
Re: Problem MYSQL R7 - arakuta - 20.07.2013
R7 doesn't need to store or free the result.
You get the result in a response callback.
pawn Код:
mysql_function_query(handle,query,cacheing??,"responsecallback","arguments",Mixed{...)
pawn Код:
mysql_function_query(MySQL_Handle,"SELECT * FROM `users` WHERE ip="127.0.0.1",true,"r@MySQL_IPs","ds",playerid,"127.0.0.1");
pawn Код:
public r@MySQL_IPs(playerid,ip[])
{
new rows,fields,pip[16],text[24];
cache_get_data(rows,fields,handle);
if(rows)
{
SendClientMessage(playerid,-1,"Players with IP '127.0.0.1':");
for(new f; f = fields; ++f)
{
cache_get_field_content(0,"name",pip,handle);
format(text,sizeof text,"%s",pip);
SendClientMessage(playerid,-1,text);
}
}
else
return SendClientMessage(playerid,-1,"No player with this IP.");
return 1;
}
Re : Problem MYSQL R7 - HitnKill - 20.07.2013
Ok thanks, on R7 we are forced to use cache_get_data and other... we can't use the old script?
Re: Re : Problem MYSQL R7 - arakuta - 20.07.2013
Quote:
|
Originally Posted by HitnKill
 Ok thanks, on R7 we are forced to use cache_get_data and other... we can't use the old script?
|
This can help you
https://sampforum.blast.hk/showthread.php?tid=337810
Re : Problem MYSQL R7 - HitnKill - 20.07.2013
I have an idea for don't change all my script with this vR7 MYSQL.
Example my old function
PHP код:
R6
if(IPBanned(plrip) > 0)
{
// code....
}
IPBanned(ip[])
{
new query[100],ipexist;
format(query,sizeof(query),"SELECT IP FROM `dm_bans` WHERE IP = '%s' LIMIT 1",ip);
mysql_query(query);
mysql_store_result();
new rows = mysql_num_rows();
if(rows > 0) ipexist = 1;
else ipexist = 0;
mysql_free_result();
return ipexist;
}
PHP код:
R7
if(IPBanned(plrip,0) > 0)
{
// code...
}
forward IPBanned(ip[],ID);
public IPBanned(ip[],ID)
{
if(ID == 0)
{
new query[100];
format(query,sizeof(query),"SELECT IP FROM `dm_bans` WHERE IP = '%s' LIMIT 1",ip);
mysql_function_query(ConnexionBDD, query, true, "IPBanned", "si",ip,1);
}
else
{
new rows,fields,ipexist;
cache_get_data(rows, fields);
if(rows > 0) ipexist = 1;
else ipexist = 0;
return ipexist;
}
return 1;
}