Raised This Month: $140 Target: $400
 35% 

Advanced Bans (Real Time) by Exolent


Post New Thread Reply   
 
Thread Tools Display Modes
ZEDD_Intensity
Senior Member
Join Date: Jun 2016
Location: New York
Old 07-03-2018 , 17:15   Re: Advanced Bans (SQL) | for WEBSITE / PHP
Reply With Quote #1441

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 #1442

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.
sigerman
Senior Member
Join Date: Aug 2013
Location: Argentina, Bs.As.
Old 07-28-2018 , 12:14   Re: Advanced Bans (Real Time) by Exolent
Reply With Quote #1443

ZEDD_Intensity your php works fine!

Just a little detail, the bans are put in the list the oldest up and the newest down (permanent and temporal bans)
Would be great if it were upside down

Anyways, I'm already using your php, and I love It
______________________
Nevermind, you already told why you didn't organize them! Sorry!

https://forums.alliedmods.net/showpo...postcount=1426

(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.)

Last edited by sigerman; 07-28-2018 at 12:20. Reason: Clarifying
sigerman is offline
Marin Vojnic
Junior Member
Join Date: Jul 2010
Old 07-30-2018 , 17:32   Re: Advanced Bans (SQL) | for WEBSITE / PHP
Reply With Quote #1444

Quote:
Originally Posted by mimos04 View Post
Done that at the 1st place and success.

if using domain is it supported?
Help me pls for ativate this script. I'm everithing input on the script. My sql pass and other, that will be see :

$sql_host = "iphosting"; // leave blank for localhost
$sql_user = "apbhqcom_testban";
$sql_pass = "xxxx";
$sql_db = "apbhqcom_testban";

SERVER SQL:
amx_sql_host "IPHOSTING"
amx_sql_user "apbhqcom_testban"
amx_sql_pass "xxxx"
amx_sql_db "apbhqcom_testban"
amx_sql_table "admins"
amx_sql_type "mysql"

And when I use php, I dont see anything, only "This page isnít working". Error say me this:
[30-Jul-2018 23:28:41 Europe/ PHP Fatal error: Call to undefined function mysqli_connect() in /home/xxx/xxx/xxx/advanced_bans.php on line 53

Why he dont want connected with my database?
Marin Vojnic is offline
ZEDD_Intensity
Senior Member
Join Date: Jun 2016
Location: New York
Old 07-30-2018 , 22:49   Re: Advanced Bans (Real Time) by Exolent
Reply With Quote #1445

Quote:
Originally Posted by sigerman View Post
ZEDD_Intensity your php works fine!


Quote:
Originally Posted by Marin Vojnic View Post
Help me pls for ativate this script. I'm everithing input on the script. My sql pass and other, that will be see :
Error say me this:
[30-Jul-2018 23:28:41 Europe/ PHP Fatal error: Call to undefined function mysqli_connect() in /home/xxx/xxx/xxx/advanced_bans.php on line 53
Hey there,

This error usually occurs when your webserver doesnít have mysqli extention installed/enabled. Please verify itís installation.
If youíre not sure how to do it, please contact your administrator/host and he should get it all ready for you.

Warm Regards,
ZEDD
__________________
ZEDD_Intensity is offline
Marin Vojnic
Junior Member
Join Date: Jul 2010
Old 07-31-2018 , 12:02   Re: Advanced Bans (Real Time) by Exolent
Reply With Quote #1446

Quote:
Originally Posted by ZEDD_Intensity View Post




Hey there,

This error usually occurs when your webserver doesn’t have mysqli extention installed/enabled. Please verify it’s installation.
If you’re not sure how to do it, please contact your administrator/host and he should get it all ready for you.

Warm Regards,
ZEDD
OMG I'm totali idiot. That be a night when try taht. Now I custom ativated my PHP version and activated msqly Thank you very very much

But now I see that script not worky great. Dont have pagination, but I activated in script. And other name in list I dont see... Hmm IDK why, but we have this http://www.apb-hq.com/ban and working great, but IDK how create pagination

Last edited by Marin Vojnic; 07-31-2018 at 12:07.
Marin Vojnic is offline
thEsp
Member
Join Date: Aug 2017
Location: Gjilan,Kosova (Albania)
Old 07-31-2018 , 12:17   Re: Advanced Bans (Real Time) by Exolent
Reply With Quote #1447

Good Job exolent!
I tried this on my server and It actually works
__________________
VB.NET Professionalist
#Shqipe
thEsp is offline
Marin Vojnic
Junior Member
Join Date: Jul 2010
Old 07-31-2018 , 15:11   Re: Advanced Bans (Real Time) by Exolent
Reply With Quote #1448

Quote:
Originally Posted by thEsp View Post
Good Job exolent!
I tried this on my server and It actually works
What is works? I tested work, but php script not regular. See my page, why dont see "player name" and Player SteamID/IP?
Marin Vojnic is offline
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 08:23.


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