[quark]

UPDATED

< Plugin >
* 0.4 - Removed Server ID.
- Set Server IP as Primary key.
- Changed way to get Server IP.
- Added maxplayers.
- Fixed Player count. ( Testing. )
* 0.5 - Added log to amx.
- Fixed server IP.

< Php Script >
*0.4 - Added IP/MaxPlayers.

[kwpd]

ty
+karma

[kwpd]

FIX plz

PHP Code:

public client_connect(player)
{
    /* When user connect it will count 1 more in variable, */
    /*          and update the players in the Table        */
    g_iPlayers++;
    UpdateqSiPlayers();
    /* ----------------------- */
} 


FOR

PHP Code:

public client_putinserver(player)
{
    /* When user connect it will count 1 more in variable, */
    /*          and update the players in the Table        */
    g_iPlayers++;
    UpdateqSiPlayers();
    /* ----------------------- */
} 


[quark]

I'm tired of amxx. It's not funny anymore. But maybe i'll release next verion tomorrow.

[Eckat]

I've been working to get that running quite a while now. For some reason I encounter this error every time I startup the server.

PHP Code:

Executing AMX Mod X Configuration File
L 01/05/2014 - 13:04:01: [AMXX] Plugin ("qServerinfo.amxx") is setting itself as failed.
L 01/05/2014 - 13:04:01: [AMXX] Plugin says: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 01/05/2014 - 13:04:01: [AMXX] Run time error 1 (plugin "qServerinfo.amxx") - forced exit 


From my feelings, I am almost certain having everything configured correctly. The amxx.cfg contains the lines:

qSi_host "localhost" // Host
qSi_user "<myuser>" // db username
qSi_pass "<mypass>" // db password
qSi_db "amx" // db name
qSi_sid "1" // Server ID

There is a number of other plugins also accessing the database. Could that be the reason for the unsuccessful connection?

Thanks in advance for any comment!

[YamiKaitou]

Use 127.0.0.1 for qSi_host instead

[Eckat]

Originally Posted by YamiKaitou Use 127.0.0.1 for qSi_host instead

I also tried that earlier. Unfortunately this doesn't solve the issue.

[YamiKaitou]

Originally Posted by Eckat I also tried that earlier. Unfortunately this doesn't solve the issue.

Then complain to your host

[Eckat]

The solution was to redirect to the socket manually via

ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

which ended up in a login error, which brought me to enter the details directly into the .sma as follows

PHP Code:

        /*     Register Cvars       */
        g_pcvarHost = register_cvar( "qSi_host", "localhost", FCVAR_PROTECTED );
        g_pcvaruUser = register_cvar( "qSi_user", "<myuser>", FCVAR_PROTECTED );
        g_pcvarPass = register_cvar( "qSi_pass", "<mypass>", FCVAR_PROTECTED );
        g_pcvarDB = register_cvar( "qSi_db", "amx", FCVAR_PROTECTED );
        /*  ----------------------------------------------------------------------------------  */ 


All is now up and running.

/shrug

[quark]

oh this plugin... I have new versions on my pc. I'll try to upload it tomorow