[xikkub]

Why does it say I am not allowed to connect to my own database?

[muukis]

Originally Posted by xikkub The server is running on my own machine. I guess I should contact myself and see what is going wrong.

You are hosting the game and the MySQL at the same (your own) computer?
Unless you have modified and compiled the source yourself, your ChatLog plugin connects to your default database. Check the "default" settings in your /addons/sourcemod/configs/databases.cfg. In there you should have something like this:

    "default"
    {
        "driver"            "default"
        "host"                "127.0.0.1"
        "database"            "<database>"
        "user"                "<username>"
        "pass"                "<password>"
    }

Then check your MySQL user settings for <username>. It should be something like:

mysql> select * from mysql.user where User = '<username>';
+-----------+-------------+-------------------------------------------+...
| Host      | User        | Password                                  |...
+-----------+-------------+-------------------------------------------+...
| localhost | <username>  | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |...
+-----------+-------------+-------------------------------------------+...
1 row in set

mysql> select * from mysql.db where Db = '<database>' and User = '<username>';
+-----------+--------------+------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| Host      | Db           | User       | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Execute_priv |
+-----------+--------------+------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| localhost | <database>   | <username> | Y           | Y           | Y           | Y           | Y           | Y         | Y          | Y               | Y          | Y          | Y                     | Y                | Y                | Y              | Y                   | Y                  | Y            |
+-----------+--------------+------------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
1 row in set

Are they like so?

[xikkub]

Thanks muukis. That fixed it for me. The only problem now is that I get this message when I load the chatlogex.php page.

Notice: Undefined index: mark in C:\wamp\www\cssource\chatlogex.php on line 85

Line 85 happens to be this:
if ($mark = $_GET['mark'] + 0):

Apart from that, everything works fine. The chat display is smooth and operational, but that php error scares me.

[muukis]

Try downloading the latest version from the web interface. I added a small check that should fix the error you are having:

if (isset($_GET['mark']) && $mark = $_GET['mark'] + 0):

As an alternative, you should also be able to "fix" your problem by reconfiguring your PHP. Check this out: http://fi2.php.net/error_reporting

[xikkub]

Your modification worked perfectly! Thanks for the link, too, I will definitely look into it to know whats going on .

[Chris-_-]

Care to log sm_csay commands :p?

[muukis]

Originally Posted by Chris-_- Care to log sm_csay commands :p?

Is that this:

sm_csay <message> Message is sent to all players in the center of the screen

[xikkub]

Originally Posted by muukis Is that this:

Yes.

[muukis]

Small update (v1.3.4):
- Messages delivered using admin commands sm_say an sm_csay are now logged (regardless of the cvar sm_chatlogex_srvmsgs state). The web interface will show these messages in different color and tagged with [ADMIN].
- There is no L4D specific installment anymore - I hope it works for other games as well.
- Hopefully fixed the bug of connecting players not showing on map start.

[waertf]

i found that my time is less than 8 hours ,how can i fix that? thx
my local time is GMT+8