Raised This Month: $ Target: $400
 0% 

SQL Help\code


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 03-09-2009 , 11:43   SQL Help\code
Reply With Quote #1

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.
__________________
Bugsy is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:53.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode