Raised This Month: $12 Target: $400
 3% 

Advanced Bans (Real Time) by Exolent


Post New Thread Reply   
 
Thread Tools Display Modes
Cd5ssmffan
BANNED
Join Date: Feb 2017
Location: GB
Old 06-19-2018 , 14:31   Re: Advanced Bans (Real Time) by Exolent
Reply With Quote #1431

@ZEDD you shouldnt have deleted your post, it could have helped someone else lol. Still no matter what I do SQL is not working for me (even after i fixed the issue with my web server) so I'm just going to see if I can get my web server to read /data/advanced_bans.txt
Do you think this is a good idea? Would any security issues appear?
Cd5ssmffan is offline
Send a message via ICQ to Cd5ssmffan Send a message via AIM to Cd5ssmffan Send a message via Yahoo to Cd5ssmffan Send a message via Skype™ to Cd5ssmffan
ZEDD_Intensity
Senior Member
Join Date: Jun 2016
Old 06-19-2018 , 17:05   Re: Advanced Bans (Real Time) by Exolent
Reply With Quote #1432

Quote:
Originally Posted by Cd5ssmffan View Post
@ZEDD you shouldnt have deleted your post, it could have helped someone else lol. Still no matter what I do SQL is not working for me (even after i fixed the issue with my web server) so I'm just going to see if I can get my web server to read /data/advanced_bans.txt
Do you think this is a good idea? Would any security issues appear?
Hi,

That post was basically nothing but the most excruciatingly inflated tutorial for changing new query[512] to query[1024], you can try exactly that in the threaded version as well. And make sure ya keep looking at the errors.

Sometimes, many hosts have max_connections_per_hour limits on how much data is circulated around the network and that might even be causing it and I know it because I had that exact same problem and when I inquired about it, they asked for upgrading my subscription for 'additional' $29.99 a month and that's when I knew was the right time to switch datacenters. Now we run pretty much everything on standalone servers, but just so ya know, I had enough trouble with setting this plugin up with SQL, but once it worked on a specific setting, it slides at butter-pace.

PS, for getting the web-server to read your txt doesn't sound right. What is your intention, are you trynna host a Banlist for your servers on your website?
  • Are you sure that you have your GameServer's IP Addreess whitelisted in your remote SQL?
  • Verify that you're running AMX Mod X version 1.8.1 or higher?
  • Is advanced_bans_sql.amxx at the top of your plugins.ini?
  • Did you check the output of amx_modules if MySQL is running?
  • If it's running, did you verify that you've entered the correct database login in your /configs/sql.cfg?
  • Does the plugin even create the table "advanced_bans" in your database?
If not, whitelist your own public IP address onto your MySQL server and try connecting using MySQL Workbench just for "testing" your connection. It should break errors down to you for what is wrong and should get you somewhere but not lost at the end of the day.

I'm attaching the exact version of SQLBans that I'm using right now, that works like a charm for me at least. Before you replace yours with the attachment, make sure ya verify the questions above as sometimes, when humans get too tired of errors, they miss the most common and obvious fixes. If you have other plugins using the same exact SQL Database, try temporarily pausing them and just give your server a restart with just advanced_bans_sql and see how it behaves.

Hope some of the above helps ya out.

Kind Regards,
ZEDD
Attached Files
File Type: sma Get Plugin or Get Source (advanced_bans_sql.sma - 456 views - 44.9 KB)
__________________

Last edited by ZEDD_Intensity; 06-19-2018 at 17:25.
ZEDD_Intensity is offline
Cd5ssmffan
BANNED
Join Date: Feb 2017
Location: GB
Old 06-21-2018 , 02:51   Re: Advanced Bans (Real Time) by Exolent
Reply With Quote #1433

Quote:
Originally Posted by ZEDD_Intensity View Post
Hi,
Hope some of the above helps ya out.

Kind Regards,
ZEDD
I have already tried everything but it doesn't work. I'm going to try to move everything to one single machine (there would be some small security issue if I didnt) but then I would be able to access the file directly.

Last edited by Cd5ssmffan; 06-21-2018 at 03:14.
Cd5ssmffan is offline
Send a message via ICQ to Cd5ssmffan Send a message via AIM to Cd5ssmffan Send a message via Yahoo to Cd5ssmffan Send a message via Skype™ to Cd5ssmffan
Old 06-21-2018, 06:32
ZEDD_Intensity
This message has been deleted by ZEDD_Intensity. Reason: sane
mimos04
Junior Member
Join Date: Apr 2011
Old 07-03-2018 , 15:04   Re: Advanced Bans (SQL) | for WEBSITE / PHP
Reply With Quote #1434

Quote:
Originally Posted by ZEDD_Intensity View Post
Greetings,

2018, but if someone still needs it, here's a BugFixed/Edited version for Advanced_Bans.php for advanced_bans_sql users. Originally made/postedby cRaNnK on GitHub. Whenever I've seen someone asking about a php code for advanced_bans, they've always been given the link to AMXBans, even though the guy(like me) never wanted to use AMXBans. cRaNnk's code had a Bunch of errors as well and I decided to editit for my servers to match my preferences.
  • EDIT THE LIST TITLE ON LINE 15 : $sname. I know there are a bunch of other $snames, but edit only the one at LINE 15.
  • The file is set to sort bans according to the ban times from Longest to Shortest and then Permanent Bans. So all Permas will always be at the end. I wanted to sort the bans from newest to oldest, but I couldn't find any field that sent a detail for when the ban was issued, like a BanID or something.
  • Admin SteamIDs are masked with the format : STEAM_0.1.***.***. Hyperlink to visit admin's steam profile from maskedIDs removed. All bans by your server/rcon won't have anything in the Admin SteamID Field.
  • Added Search Feature based on letters. This is why I didn't add sorting with name. Type "A" in the search field and it'll show only the banned names starting with A.
  • All warnings/errors fixed. You won't see an error unless you decide to turn the code upside down or heavily/aggressively/wildly edit it. There always used to be an "Undefined : "page" and "s" Notice, which won't go away until another page for bans was created - Fixed and Hidden.
  • Default table-name that the script will query is "advanced_bans". If you've edited the source and changed the name, edit Line 16.

If you're running your SQLDatabase on the same server as your website, leave the Line 2 : $sql_host = ""; BLANK. Putting your actual host-address there will cause "Access Denied" Warning. Also remember to Whitelist your GameServer IP in your Remote SQL if haven't done already and using for the first time. Failing to do that will deny your access to database connection and "error" the plugin.

The COLORS of the table is what I use, because I've embedded the whole page in my website and it has it's own background image, so that cherry red with white color looks kinda cute altogether. To edit colors yourself, Just Ctrl+F "color" and look around to make sure you're editing the right color. Visit this website to know the #C0D3S of your favourite colors.

I'm NOT willing to edit the php any further 'for anyone', so I hope you find someone to do it if you need anything majorly changed.

Hope this helps.

Regards,
ZEDD

Attachment Updated :
  • Previous code had Code Injection Vulnerabilities. Fixed!
Updated again :
  • When you ban an IP Address, it's gonna approach an array that isn't set and echoes an error. Fixed!
are this working?
mimos04 is offline
ZEDD_Intensity
Senior Member
Join Date: Jun 2016
Old 07-03-2018 , 15:28   Re: Advanced Bans (SQL) | for WEBSITE / PHP
Reply With Quote #1435

Quote:
Originally Posted by mimos04 View Post
are this working?
Hey,

Ofcourse it is, If I post something that big, it wouldn't be there if it wasn't working.

Give it a try yourself, Click here.

Regards,
ZEDD
__________________
ZEDD_Intensity is offline
mimos04
Junior Member
Join Date: Apr 2011
Old 07-03-2018 , 15:51   Re: Advanced Bans (SQL) | for WEBSITE / PHP
Reply With Quote #1436

Quote:
Originally Posted by ZEDD_Intensity View Post
Hey,

Ofcourse it is, If I post something that big, it wouldn't be there if it wasn't working.

Give it a try yourself, Click here.

Regards,
ZEDD
i've try it, my setup are like this, hlds server and the mysql server are on the same server, the php file im putting it on my webhost. i've try the sql advanced ban ure post before, thanks to it thats working. btw back to the php file, i check on the mysql database advanced_bans data success between mysql server and hlds, but the php seem not working.
mimos04 is offline
ZEDD_Intensity
Senior Member
Join Date: Jun 2016
Old 07-03-2018 , 16:29   Re: Advanced Bans (SQL) | for WEBSITE / PHP
Reply With Quote #1437

Quote:
Originally Posted by mimos04 View Post
i've try it, my setup are like this, hlds server and the mysql server are on the same server, the php file im putting it on my webhost. i've try the sql advanced ban ure post before, thanks to it thats working. btw back to the php file, i check on the mysql database advanced_bans data success between mysql server and hlds, but the php seem not working.
Hey,

From what I understand of what you described, you've gotta leave the field $sql_host blank, Just like this :
PHP Code:
$sql_host ""
Regards,
ZEDD
__________________

Last edited by ZEDD_Intensity; 07-03-2018 at 16:32.
ZEDD_Intensity is offline
mimos04
Junior Member
Join Date: Apr 2011
Old 07-03-2018 , 16:51   Re: Advanced Bans (SQL) | for WEBSITE / PHP
Reply With Quote #1438

Quote:
Originally Posted by ZEDD_Intensity View Post
Hey,

From what I understand of what you described, you've gotta leave the field $sql_host blank, Just like this :
PHP Code:
$sql_host ""
Regards,
ZEDD
mysql server (on dedicated server) and the php file (i put on the webhosting) are not on the same server which is different ip. btw in mysql i already give webhosting ip access to the advanced_bans mysql database. i've no idea what is the problem. still no success yet.
mimos04 is offline
ZEDD_Intensity
Senior Member
Join Date: Jun 2016
Old 07-03-2018 , 17:15   Re: Advanced Bans (SQL) | for WEBSITE / PHP
Reply With Quote #1439

Quote:
Originally Posted by mimos04 View Post
mysql server (on dedicated server) and the php file (i put on the webhosting) are not on the same server which is different ip. btw in mysql i already give webhosting ip access to the advanced_bans mysql database. i've no idea what is the problem. still no success yet.
So, your HLDS and Database is on same server.
And, Website on a different server. Right?

Then go to your ~/amxmodx/configs/sql.cfg and set
PHP Code:
 amx_sql_host    "127.0.0.1" 
 
amx_sql_type    "mysql" 
Add your Webhost's IP Address to your Database server's Remote SQL/Whitelist.

Check your ~/amxmodx/logs folder for any possible SQLQuery errors, if not, try amx_ban or amx_addban a client and rush to check if the ban actually gets written in your advanced_bans table.

And else, set the php host to
PHP Code:
 $sql_host "mysql server-hostname/IP"
Hope this helps.
__________________

Last edited by ZEDD_Intensity; 07-03-2018 at 17:19.
ZEDD_Intensity is offline
mimos04
Junior Member
Join Date: Apr 2011
Old 07-03-2018 , 17:26   Re: Advanced Bans (SQL) | for WEBSITE / PHP
Reply With Quote #1440

Quote:
Originally Posted by ZEDD_Intensity View Post
So, your HLDS and Database is on same server.
And, Website on a different server. Right?

Then go to your ~/amxmodx/configs/sql.cfg and set
PHP Code:
 amx_sql_host    "127.0.0.1" 
 
amx_sql_type    "mysql" 
Add your Webhost's IP Address to your Database server's Remote SQL/Whitelist.

Check your ~/amxmodx/logs folder for any possible SQLQuery errors, if not, try amx_ban or amx_addban a client and rush to check if the ban actually gets written in your advanced_bans table.
Done that at the 1st place and success.
Quote:
Originally Posted by ZEDD_Intensity View Post
And else, set the php host to
PHP Code:
 $sql_host "mysql server-hostname/IP"
if using domain is it supported?
mimos04 is offline
Old 07-03-2018, 17:47
ZEDD_Intensity
This message has been deleted by ZEDD_Intensity.
Reply


Thread Tools
Display Modes

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 14:17.


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