MySQL Question

[iViscosity]

So I'm new to MySQL (and MySQLOO for gmod) and I'm writing up an addon that will utilize this. It syncs bans between servers, using a MySQL database. Let's say for example, my script runs a query:

Code: Lua

1. "SELECT * FROM bsync_bans WHERE steamid = %s"

(The query is then string.format'd with the player's SID)


Table setup:

Code: Lua

1. [[
2.  
3.         CREATE TABLE IF NOT EXISTS bsync_bans(        
4.         steamid VARCHAR( 255 ) NOT NULL,
5.         nick VARCHAR( 255 ) NOT NULL,
6.         admin VARCHAR( 255 ) NOT NULL,
7.         unban VARCHAR( 255 ) NOT NULL,
8.         reason VARCHAR( 255 ) NOT NULL,
9.         time VARCHAR( 255 ) NOT NULL,
10.         PRIMARY KEY ( steamid )
11.     )
12. ]]

So let's say for example a player joins. A PlayerInitialSpawn hook checks if the player is in the database anywhere, and if they are, it will ban them. But if they aren't, will the query throw an error, or throw an empty table? I assume that it would throw an error, but I haven't had a chance to test it myself yet, but I'm going to do so in a few hours once I have the chance.

[captain1342]

You need a check if there was no or an empty response and No it doesen't throw an error it just gives an empty response.

I made such a script actually

[iViscosity]

Good to know. I also have another question about ULib. I know there is the ULibCommandCalled to check if a command is called, but what about the specific "ULib.ban" (or addBan or kickban)? Is there a way to check for the call on these and not the "ulx ban" (or "ulx banid") commands?


EDIT: Never mind, I found it.