Raised This Month: $ Target: $400
 0% 

Help: A small bansync script (ala AMXBans) using SQL


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
GHW_Chronic
SourceMod Donor
Join Date: Sep 2004
Location: Texas
Old 03-25-2006 , 07:51  
Reply With Quote #2

its obviously going into the else statement
Code:
        if (equal(player_steamid,"STEAM_ID_LAN")) {         else {

so thus you are then trying to send a blank query to MySQL. Put it in the if statement.

And you have
Code:
new query[1024] format(query,1024,"SELECT * FROM arctic_bans WHERE ip='%s'", player_ip)
should be
Code:
format(query,1023,"SELECT * FROM arctic_bans WHERE ip='%s'", player_ip)
and also 1024 characters long might be a bit too long for this. I would use 64:
Code:
new query[64] format(query,63,"SELECT * FROM arctic_bans WHERE ip='%s'", player_ip)
GHW_Chronic is offline
Send a message via AIM to GHW_Chronic
 



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 16:44.


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