Scripting/Squirrel/Functions/mysql num rows: Difference between revisions

From Vice City Multiplayer
Jump to navigation Jump to search
Caution icon
This wiki is using an old backup from 2020
Some information may be old/missing
(Created page with "Returns the number of rows selected from a query. == Syntax == <pre>mysql_num_rows( query );</pre> == Arguments == * ''string'' '''query''' - The name of the previously ex...")
 
No edit summary
 
(3 intermediate revisions by 2 users not shown)
Line 7: Line 7:
== Arguments ==
== Arguments ==


* ''string'' '''query''' - The name of the previously executed query.
* '''query''' - The name of the previously executed query.


== Example ==
== Example ==
Line 13: Line 13:
<source lang=squirrel>function onPlayerJoin()
<source lang=squirrel>function onPlayerJoin()
{
{
query<- mysql_query(vcmpdb, "SELECT * FROM bans WHERE IP = '"+player.IP+"'");
local query<- mysql_query(vcmpdb, "SELECT * FROM bans WHERE IP = '"+player.IP+"'");
if (mysql_num_rows(query)==0)
if (mysql_num_rows(query)==0)
{
{
Line 20: Line 20:
else player.Kick();
else player.Kick();
}</source>
}</source>
== Related Functions ==
{{Scripting/Squirrel/Functions/MySQL Functions}}
[[Category:Scripting/Squirrel/Functions/Mysql_Functions]]

Latest revision as of 18:28, 30 January 2017

Returns the number of rows selected from a query.

Syntax

mysql_num_rows( query );

Arguments

  • query - The name of the previously executed query.

Example

function onPlayerJoin()
{
local query<- mysql_query(vcmpdb, "SELECT * FROM bans WHERE IP = '"+player.IP+"'");
if (mysql_num_rows(query)==0)
{
ClientMessage("Welcome.",player,255,255,255);
}
else player.Kick();
}

Related Functions