[eric0279]

It's strange :

error :

L 10/14/2012 - 13:491: SourceMod error session started L 10/14/2012 - 13:491: Info (map "c8m1_apartment") (file "errors_20121014.log") L 10/14/2012 - 13:491: [l4d_stats.smx] Fast query failed! (Error = "Table 'web_1441.players' doesn't exist") Query = "SELECT * FROM players WHERE 1 = 2" L 10/14/2012 - 13:491: [l4d_stats.smx] Database is missing required table or tables. L 10/14/2012 - 13:491: [SM] Plugin encountered error 25: Call was aborted L 10/14/2012 - 13:491: [SM] Native "SetFailState" reported: Connecting to database failed. Read error log for further details. L 10/14/2012 - 13:491: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 10/14/2012 - 13:491: [SM] [0] Line 846, F:\SRCDS\l4d2\left4dead2\left4dead2\addons\so urcemod\scripting\l4d_stats.sp::OnConfigsExec uted()

Execute http://my_domain.net/l4d2/install.php

Table 'l4d2_maps' already exists Table 'l4d2_players' already exists Table 'l4d2_timedmaps' already exists Table 'l4d2_settings' already exists Table 'l4d2_server_settings' already exists Table 'ip2country' already exists Table 'ip2country_locations' already exists Table 'ip2country_blocks' already exists blablabla............

database.cfg :

"Databases"
{
    "driver_default"        "mysql"

    "l4dstats"
    {
        "driver"            "default" // or tested mysql
        "host"                "web-1.jsigames.net"
        "database"            "web_1441"
        "user"                "my_user"
        "pass"                "my_pass"
    }
    "sourcebans"
    {
        "driver"            "default"
        "host"                "web-1.jsigames.net"
        "database"            "my_bdd"
        "user"                "my_user"
        "pass"                "my_pass"
        //"timeout"            "0"
        "port"                "3306"
    }
    
    "default"
    {
        "driver"            "default"
        "host"                "localhost"
        "database"            "sourcemod"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }

    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
}

Dump bdd from my phpmyadmin :
Removed

config.php :

$mysql_server = "web-1.jsigames.net";
$mysql_db = "web_1441";
$mysql_user = "my_user";
$mysql_password = "my_pass";
$mysql_tableprefix = "l4d2_";

// MySQL information for IP to Country DB
// Fill this information only if a separate database is used
$mysql_ip2c_server = "";
$mysql_ip2c_db = "";
$mysql_ip2c_user = "";
$mysql_ip2c_password = "";
$mysql_ip2c_tableprefix = "";

a suggestion?


on the website, I have no error on the connection to the MySQL server and my GSP allows connections between the web server and the game server

[muukis]

Originally Posted by eric0279 a suggestion?

You have set a table prefix ("l4d2_") in your web config but not in the plugin config.

Your plugin is looking for a "players" table:
Table 'web_1441.players' doesn't exist
while your database has "l4d2_players" table:
CREATE TABLE IF NOT EXISTS `l4d2_players`

Fix: Edit your plugin CVAR for table prefix value to "l4d2_".

[eric0279]

Hello,


Thank you, I'm confused ...

Are you planning a multi language?

[muukis]

Originally Posted by eric0279 Are you planning a multi language?

I have thought about it, but it'll be too much work which I just don't think I have the time for. Not now, but maybe in the future?

[eric0279]

ok thank you

[eric0279]

Hello,

you is it possible to use HTML tags in game?

Here's how my motd is displayed on my server:

 <a href="http://www.gametracker.com/server_info/91.121.231.225:27015/" target="_blank"><img src="http://cache.www.gametracker.com/server_info/91.121.231.225:270

the message is too large and it is truncated by the game.

Thanks for answer.

I think if we can disable the motd in game, I would look cvar, no problem ;)

[muukis]

Originally Posted by eric0279 Hello, you is it possible to use HTML tags in game? Here's how my motd is displayed on my server: <a href="http://www.gametracker.com/server_info/91.121.231.225:27015/" target="_blank"><img src="http://cache.www.gametracker.com/server_info/91.121.231.225:270 the message is too large and it is truncated by the game. Thanks for answer. I think if we can disable the motd in game, I would look cvar, no problem ;)

HTML tags in game? Yes and no. Sure you can write messages that contain HTML tags, but the game does not recognize them as other than plain text. If you want to display some gametracker info on your web stats page, I'd suggest modifying the page directly and not using MOTD for it.

CVAR 63. l4d_stats_announcemotd (default = "1") Announce the message of the day for the joining players

[eric0279]

ok thank you.

[eric0279]

Hello,

Why is this not working?

PHP Code:

Format(Value, sizeof(Value), "Visitez notre site %s \npour voir les statistiques complètes", URL); 


The return line is not working and the rest of the text is not displayed.


I think I roved response, hud text is limited

[eric0279]

Solved :

PHP Code:

StatsPrintToChat(data, "You have earned \x04%i \x01points for Protecting \x05%i friendlies\x01!", Score, ProtectedFriendlies); 


returns 1 instead of the pseudo or it returns the number of survivors protected?



and this error :

L 10/23/2012 - 19:48:41: [SM] Native "VFormat" reported: Client index 1 is invalid L 10/23/2012 - 19:48:41: [SM] Displaying call stack trace for plugin "l4d_stats.smx": L 10/23/2012 - 19:48:41: [SM] [0] Line 11225, F:\SRCDS\l4d2\left4dead2\left4dead2\addons\so urcemod\scripting\l4d_stats.sp::StatsPrintToC hatAll() L 10/23/2012 - 19:48:41: [SM] [1] Line 1549, F:\SRCDS\l4d2\left4dead2\left4dead2\addons\so urcemod\scripting\l4d_stats.sp::timer_Protect edFriendly()

Solved