Raised This Month: $ Target: $400
 0% 

SQL Get column as cvar.


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Bugsy
AMX Mod X Moderator
Join Date: Feb 2005
Location: NJ, USA
Old 12-24-2015 , 11:16   Re: SQL Get column as cvar.
Reply With Quote #4

Can you show me how your table is designed? Your query can be made better.

SELECT '%s' FROM `licenses` WHERE 1

I would do something like

SELECT * FROM tblLicenses WHERE ServerIP='%s'

No results means unlicensed. Or if you have a column that holds a license status (0/1) for if you withdraw a license without deleting the record from the table you can then check that.

Where does a cvar come into play?
__________________

Last edited by Bugsy; 12-24-2015 at 11:22.
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 18:07.


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