Quote:
Originally Posted by Bugsy
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.