Raised This Month: $ Target: $400
 0% 

SQL Get column as cvar.


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
XmasterOfficial
Junior Member
Join Date: Oct 2014
Old 12-27-2015 , 17:44   Re: SQL Get column as cvar.
Reply With Quote #5

Quote:
Originally Posted by Bugsy View Post
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?
This is the database. Is just for test. There would be only IPs in that table.
postimg . org/image/xr7zxuqbt/6d5156f3/

I set a variable "unlicensed = 1" at the beginning so the plugin will check if that variable is 1 and if it is 1 then it will say that the server is not authorised to use this plugin bla bla. However the script above should check at the beginning if the server IP is inside the table and if it is then it should set unlicensed to 0.

Last edited by XmasterOfficial; 12-27-2015 at 17:48.
XmasterOfficial 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