[|PJ| Shorty]

you can set the access level for the commands per define.
if you set the access level to ADMIN_ALL (0), yes, it could (will) be spammed

[|PJ| Shorty]

update to 0.96RC2

- fixed a bug if steambans not running
- online compiling didn´t worked: fixed

[Rafael]

I'm Having a problem with this plugin. It can't connect to the MySQL server.
Using AMXX 1.76d
Here are some outputs:

amxx list:

      [ 41] HLTV_Report             0.96RC1  |PJ|ShOrTy        hltv_report.amx  error    
         ( 41) Error: Could not connect to SQL database.
         41 plugins, 40 running

amxx modules:

    name                    version  author               status     
          [ 1] Ham Sandwich            1.8      AMX Mod X Dev Team   running    
          [ 2] Fun                     1.76     AMX Mod X Dev Team   running    
          [ 3] Engine                  1.76     AMX Mod X Dev Team   running    
          [ 4] FakeMeta                1.76d    AMX Mod X Dev Team   running    
          [ 5] CStrike                 1.76     AMX Mod X Dev Team   running    
          [ 6] CSX                     1.76c    AMX Mod X Dev Team   running    
          [ 7] MySQL                   1.76b    AMX Mod X Dev Team   running    
          [ 8] SQLite                  1.76b    AMX Mod X Dev Team   running    
          [ 9] Sockets                 1.76     HLSW Dev Team        running    
         9 modules, 9 correct

log error output:

[AMXX] Plugin ("hltv_report.amxx") is setting itself as failed.
[AMXX] Plugin says: Could not connect to SQL database.
[AMXX] Run time error 1 (plugin "hltv_report.amxx") - forced exit

What Could not connect to SQL database means?
1. The plugin didin't find a database running at the IP contained in sql.cfg file?
2. The connection request was refused [wrong username/password] by the web host?
3. The connection timed out?

Also, I've contacted my gamehost and they did a traceroute to my webhost. Everything went fine. So, I guess that there aren't any problems between them (the plugin should be able to connect to the DB).

I've allowed the gameserver IP in Remote MySQL, so the plugin should connect to my DB.

Just to inform that the web part of the plugin is running without problems, I assume.
(http://sodteam.890m.com/hltv)

Please, help me.

[|PJ| Shorty]

your sql data in file /configs/hltv_report/sql.cfg is correct?

make also update to 0.96RC2

other plugins with sql working fine?

[Rafael]

Originally Posted by |PJ| Shorty your sql data in file /configs/hltv_report/sql.cfg is correct? make also update to 0.96RC2 other plugins with sql working fine?

This is the first plugin that uses sql I run.
I think that my files are already updated...

The plugins contains #include <sqlx>. So, sqlx is mysql or sqllite module?
Do I need to use amx_sql_type <value> ?

[YamiKaitou]

sqlx is both. It all depends on how the plugin sets the affinity.

[|PJ| Shorty]

only for testing, deactivate the sqlite module, and see if it´s working.
check if your mysql server is accessable from an extern host.

[Gizmo]

Looks like it does almost the same things as my Report abuse plugin does but i have not updated that in very long time

http://forums.alliedmods.net/showthread.php?t=42751

[|PJ| Shorty]

you are right, looks like the same. didn´t seen yours before

[Perfect Team]

Hello All !
How edit this plugin to be HLTV always connected (24/7) - and no disconnect ?

Regards
Perfect Team Root

P S Sry for my english