I am trying to convert my VAC ban status plugin (see sig) from using nVault to SQLx. I have no experience in SQL and do not want to experiment with it on peoples servers. Is the AMX-X SQL protocol identical to that used by Windows? If so I could research it myself. The usage I need is fairly basic:
For each player, I need the following data, using the players STEAMID or IP as the lookup key:
0/1
[ban status] 12353543
[time-stamp]
What I need help with:
- Setting up the db for fresh plugin installs
- How to look up an entry using steamid\ip and retrieve the respective ban status and timestamp.
- How to create an entry using items noted above
- How to delete an entry
- How to update an item (ie, suppose someone connects and their time-stamp has expired, instead of deleting the entry and creating a new one, just update the ban status and timestamp)
+karma to anyone who can help
Note: Yes, I have read the tutorial by hawk but that looks more geared towards people that already know SQL.
__________________