[Exolent[jNr]]

Originally Posted by LaineN Exolent, you can maybe add like in amxbans so you can look on the web who is banned It's really nice!

I'm sure you could just use a PHP script to load the bans and display them onto a website.

[KadiR]

have some1 got a php script for it here? that will be awesome

maybe you can add a banner over your banlist ( like amxbans )

[LaineN]

Would be very nice I don't know PHP :/

[Reaper2331]

there has already been a online ban list in this topic. it is not from exolent but from someone else, idk who.

[EDIT]
I have attached the php script that was in this topic before.

just change these to your FTP info

PHP Code:

//VARS
$ftp_ip="";
$ftp_user="";
$ftp_pass="";
$ftp_log_path="cstrike/addons/amxmodx/data/advanced_bans.txt";
$temporary_file="bans.tmp";
//END VARS 


[/EDIT]

an Example of this PHP script can be found here
On my Website

[alexinno]

Originally Posted by Exolent[jNr] I'm learning! Try this one.

did that and i get the same result ... plugin working and

L 05/30/2009 - 09:16:34: [advanced_bans_sql.amxx] Failed to create table for ban
s: You have an error in your SQL syntax; check the manual that corresponds to yo
ur MySQL server version for the right syntax to us

[ussamkusser]

Hi Exolent,
at first: sorry for my bad english.
Here now my little problem:
Today I have tried to use your fine plugin.
But I do not find the BAN_HISTORY_MMDDYYYY.log in the place addons/amxmodx/logs.
I can't find this file nowhere. But the plugin is working.
I have tested to ban myself for 5 minutes and it works well - but no BAN_HISTORY_MMDDYYYY.log was created.
What is going wrong in that case?
I use the "advanced_bans" version 0.8 and not the sql-version.
I don't have changed anything in the original file.
It would be nice if you could help me and
Thx for your help!!!!!!!!

ussam

[Exolent[jNr]]

Originally Posted by alexinno did that and i get the same result ... plugin working and L 05/30/2009 - 09:16:34: [advanced_bans_sql.amxx] Failed to create table for ban s: You have an error in your SQL syntax; check the manual that corresponds to yo ur MySQL server version for the right syntax to us

This is stupid. I'll keep trying.

Originally Posted by ussamkusser Hi Exolent, at first: sorry for my bad english. Here now my little problem: Today I have tried to use your fine plugin. But I do not find the BAN_HISTORY_MMDDYYYY.log in the place addons/amxmodx/logs. I can't find this file nowhere. But the plugin is working. I have tested to ban myself for 5 minutes and it works well - but no BAN_HISTORY_MMDDYYYY.log was created. What is going wrong in that case? I use the "advanced_bans" version 0.8 and not the sql-version. I don't have changed anything in the original file. It would be nice if you could help me and Thx for your help!!!!!!!! ussam

When you ban yourself, use amx_banlist to see if you were actually banned.


EDIT: Here is a new sql version:

<Check later post>

[alexinno]

Originally Posted by Exolent[jNr] This is stupid. I'll keep trying. EDIT: Here is a new sql version:

the same thing ->

[Exolent[jNr]]

Okay, now I feel like an idiot.
The problem was that the formatted query didn't hold the whole query, so it was cut off at the end.
Therefore, the SQL server thought the syntax was incorrect.

Try this version:

[alexinno]

Originally Posted by Exolent[jNr] Okay, now I feel like an idiot. The problem was that the formatted query didn't hold the whole query, so it was cut off at the end. Therefore, the SQL server thought the syntax was incorrect. Try this version:

This time it's working
just one thing , if you created allready the table in mysql with the old one chage

#define KEY_NAME        "victim_name"
#define KEY_STEAMID        "victim_steamid"

with

#define KEY_NAME        "name"
#define KEY_STEAMID        "steamid"