Scripting/Squirrel/Functions/mysql num rows: Difference between revisions
Jump to navigation
Jump to search
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...") |
|||
| 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) | ||
{ | { | ||
Revision as of 11:12, 28 September 2015
Returns the number of rows selected from a query.
Syntax
mysql_num_rows( query );
Arguments
- string 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();
}