[dubzee]

Originally Posted by dubzee cool, can I run spcomp from the console? sorry for the n00b questions! lol.. I've noticed I can't run spcomp from console, if I use the compiler on here http://www.sourcemod.net/compiler.php will the stats plugin still work??

Ignore this guys... I just downloaded the windows version of source mod and compiled the .sp file on my machine here @ work then uploaded the .smx file back to my server!

I'll test it tonight and let you know how I get on!! THANKS!

[dubzee]

Just letting you know its working!!

http://www.dubzee.com

[hetfiel]

Hi, i have a problem running this plugin.
when i run the servers, dont load it and says:
[SM] unable to load extension "clientprefs.ext.dll" could no find "clientprefs.ext" or "default" database config

[NVS Envy]

Hello MSSleeper

First of all top marks to you for this plugin. I have been using version 1 for a few weeks now and everyone loves it.

Things have been going well until I updated to the latest version today.

At first it looked fine after following your instructions.

But i find that my Awards page is now empty. I replaced my web part of the plugin with my older backup and the awards have come back. I repeated the upgrade process once again and again no awards are showing. They do show however if you look at individual player stats.

I have reverted back to my backups for now as the information shows.

Any ideas where i may have gone wrong ?

Many thanks

Envy

http://www.nvs.inx-gaming.co.uk/l4dstats/playerlist.php

[Sk93]

Hi,

First of all - great plugin!

However, I'm having a bit of trouble getting the webstats to show.

I'm running win2k3 with PHP 5.2.8 (through IIS) and MySQL 5.1.
The database is getting populated with stats quite nicely (both tables) and in-game "top10" and "rank" work perfectly.

Yet, if I load up the stats page, it ALWAYS comes up blank.
I get the header / background / side menu / etc
but no actual stats.

Any idea?

site: http://stats.fiendishgames.co.uk

[ApocalypseDan]

Originally Posted by Sk93 Hi, First of all - great plugin! However, I'm having a bit of trouble getting the webstats to show. I'm running win2k3 with PHP 5.2.8 (through IIS) and MySQL 5.1. The database is getting populated with stats quite nicely (both tables) and in-game "top10" and "rank" work perfectly. Yet, if I load up the stats page, it ALWAYS comes up blank. I get the header / background / side menu / etc but no actual stats. Any idea? site: http://stats.fiendishgames.co.uk

at a glance it looks like the database is not sending the information to the web page have you configed your config.php correctly
and have you configered your
the reason i asked is when i set up mine one files mentioned

Host "localhost" when i changed it to my website ip Host "217.163.bla.bla"
that sorted it .But if your plugin is working and it keeps adding your scores together and your web stats pages is installed .then it must be a conecction issus between the DB and Your web site.

Ok I have just checked witch file it is i changed my localhost to my Ip and it is in the database.cfg file in

left4dead/addon/sourcemod/config/database.cfg
in this file check that you have at the bottom

"Databases"
{
"driver_default" "mysql"

"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"
}

"l4dstats"
{
"driver" "mysql"
"host" "216.139.203.70" here it used to be localhost
"database" "dont need to know"
"user" "dont need to know"
"pass" "dont need to know"
}

the reason it has to be like that is that the host for the stats is your web site . I hope this is of help and that you soon get it working .
I have it running on 2 out of my 3 servers and they both have there own DB and own web page for them selfs
as one server is 24/7 expert and one is fun server wher spawning weapons and zombies is a common thing it allows us to keep a true leaders board with out any one stats padding as they have a server to pad in if they wish to do that

[Sk93]

There's no issue between the plugin and the database - that's writing in the entries just fine (and it's pulling them back fine too. eg: "rank" and "top10" work perfectly)

the website's "config.php" is configured as follows:

 
// MySQL information for L4D Stats DB
$mysql_server = "127.0.0.1";
$mysql_user = "l4dstats";
$mysql_password = "*****";
$mysql_db = "l4dstats";

And the SourceMod's database.cfg looks like this:

 "l4dstats"
 {
     "driver"              "mysql"
     "host"                "127.0.0.1"
     "database"            "l4dstats"
     "user"                "l4dstats"
     "pass"                "*****"
 }

I've worked it out (so far) to be something wrong with the templates.
If I modify index.php to include this line:

echo "site:". $site_name;
$tpl->set("site_name", $site_name); // Site name

It echoes out site name - but sitename doesn't appear in the actual template output...
I think it's loosing all its vars somewhere along the way?


EDIT: it's definately not a DB connection issue... inserting

echo mysql_num_rows($result);

under the first sql query in index.php returns the correct number of rows each time the page is loaded...

[Sk93]

HAHA! Cracked it!

You're using <? as the opener for PHP tags instead of the full <?php.

My website wasn't working, as I have the PHP directive "short_open_tag" set to off.

Whilst it's not too much of an issue for me to switch it off for this site, can I recommend you switch to using the full tags?

The reason for it is that with "short_open_tag" turned on, php will try and interprit things it shouldn't, such as XML tags such as "<?xml version="1.0"?>" etc etc.


Also, "short_open_tag" is set to "off" as default since php 5.1 and there's quite a few people asking for it to be removed completely from v6...


anyways.. up and working now

[spliffa]

hi msleeper

haveing an issue when changing campaign. Each changes duplicates the chatmessages. as in screens below we changed campaign twice, so there are always 3 identical lines. does not appear on all commands.



is this only a display error or does it actually counts points 3x?


feature request: would it be possible to integrate a php page which has summary info about the top5 players in different categories. for expample top5 headshotters, most kills, headshot %, points, most revives. This would be great to place as motd!

thanks in advance

[saklyes]

We have a problem with this plugin.
I dont know that we make to this plugin workit.
The error is this...

[SM] unable to load extension "clientprefs.ext.dll" could no find "clientprefs.ext" or "default" database config

Any one have an idea??

Thanks.