How to convert this to MySQL r39-6>?

How to convert this to MySQL r39-6>? - 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: How to convert this to MySQL r39-6>? (/showthread.php?tid=627695)

How to convert this to MySQL r39-6>? - Belengher - 31.01.2017

Hi all,

How to convert this to MySQL R39-6?
\

Quote:

public MySQLCheckClan(sqlclanname[])
{
new query[128];
new escstr[MAX_PLAYER_NAME];
mysql_real_escape_string(sqlclanname, escstr);
format(query, sizeof(query), "SELECT `ID` FROM clans WHERE `Tag` = '%s'", escstr);
mysql_query(SQL,query);
mysql_store_result();
if (mysql_num_rows()==0)
{
mysql_free_result();
return 0;
}
else
{
new strid[32];
new intid;
mysql_fetch_row(strid);
intid = strval(strid);
mysql_free_result();
return intid;
}
}

Re: How to convert this to MySQL r39-6>? - Belengher - 31.01.2017

UP......??

Re: How to convert this to MySQL r39-6>? - AndreiWow - 31.01.2017

Why don't you use r41-2?

Re: How to convert this to MySQL r39-6>? - Belengher - 31.01.2017

Romanian SRL hosting not support R40+...

Only < 39-6...

Re: How to convert this to MySQL r39-6>? - AndreiWow - 31.01.2017

Quote:

Originally Posted by Belengher

Romanian SRL hosting not support R40+...

Only < 39-6...

Then I recommend you buying from gazduirejocuri.ro or zeroping.

Re: How to convert this to MySQL r39-6>? - Rdx - 31.01.2017

Код:

public MySQLCheckClan(sqlclanname[])
{
	new query[128];
	new escstr[MAX_PLAYER_NAME];
	new rows, fields;
	mysql_real_escape_string(sqlclanname, escstr, SQL, MAX_PLAYER_NAME);
	format(query, sizeof(query), "SELECT `ID` FROM clans WHERE `Tag` = '%s'", escstr);
	mysql_query(SQL, query);
	
	cache_get_data(rows, fields);

	if (!rows)
	{
		return 0;
	}
	else
	{
		new intid = cache_get_row_int(0, 0);
		return intid;
	}
}