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
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 ==

Revision as of 11:12, 28 September 2015

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();
}