Monthly Target: $400 Donations: $282
 70% 

[L4D & L4D2] Custom Player Stats v1.4B121


Post New Thread Reply   
 
Thread Tools Display Modes
RainMaker
New Member
Join Date: Jan 2010
Location: Denmark
Old 01-08-2011 , 10:29   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #1151

Hi
I am setting up this stats for my l4d2 server.
But i always get this error, and its not working.
The error is :

L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] FetchOverrides() query failed: SELECT type, name, flags FROM sm_overrides
L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] Query error: Table 'l4dstats.sm_overrides' doesn't exist
L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] FetchGroups() query failed: SELECT flags, name, immunity_level FROM sm_groups
L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] Query error: Table 'l4dstats.sm_groups' doesn't exist
L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] FetchUsers() query failed: SELECT id, authtype, identity, password, flags, name, immunity FROM sm_admins
L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] Query error: Table 'l4dstats.sm_admins' doesn't exist

I did install from the web with install.php, and that works fine.

What do i do wrong, i tryed to reinstall 5 times now ;(

Hope you can help me.

Btw its an Debian server.
RainMaker is offline
Send a message via MSN to RainMaker Send a message via Skype™ to RainMaker
muukis
Veteran Member
Join Date: Apr 2009
Old 01-08-2011 , 10:54   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #1152

Quote:
Originally Posted by Isador View Post
Hello i have problem. I want rank on my server but dont want (or need) have showed it anywhere on websites. Just want to type !rank in game and see how much points and what rank i have.


So i downloaded this , extract and have problems with running.
When i want to load this plugin it say i missing clientprefs.ext and clientprefs.txt

Where i should get this files? Please can somebody help me ?

when i type "sm plugins list" its says

<FAILED> "Custom Player Stats"

And when i try to load it manualy. I type "sm plugins load l4d_stats.smx" and than it say:

- [SM] Plugin l4d_stats.smx failed to load. Required extension "Client Preferences" file
<"clientprefs.ext"> not running.



----- Edit (hour later)
Well it now load successfully. But when someone log in on server it will crash! (just custom player status plugin)

there is picture what it say when i try load it manualy back.



Suggestions ?
Your database is not properly installed: It is missing at least players table. You can read that from the server console output you've included in your post. Make sure you have fully prepared the database before running the stats plugin.

Quote:
Originally Posted by Dude View Post
Hi all!

I thank the author for this great addition (stats)!

If you want players steamcommunity avatars, ranking etc. on your own stats web site like this:

player php sample

find in player.php this:

PHP Code:
if (mysql_num_rows($result) > 0)
{
    
$playername htmlentities($row['name'], ENT_COMPAT"UTF-8");
    
    
$timesrow mysql_fetch_array(mysql_query("SELECT COUNT(*) AS times FROM " $mysql_tableprefix "timedmaps WHERE steamid = '" $id "'"));
    
$times $timesrow['times']; 
and just after put this code:
PHP Code:
$xml simplexml_load_file('http://steamcommunity.com/profiles/'.getfriendid($row['steamid']).'?xml=1');

foreach (
$xml->avatarMedium as $foo
    {
    
$Avatar "<img src=".$foo."> ";
    }

foreach (
$xml->steamRating as $foo
    {
    
$SRank "</br><small><small><b>Steam Rating:</b> $foo </small></small>";
    }
    
$xml simplexml_load_file('http://steamcommunity.com/profiles/'.getfriendid($row['steamid']).'/stats/L4D2/?xml=1');

foreach (
$xml->stats->lifetime as $foo
    {
    
$TTima "&nbsp;&nbsp;<small><small><b>Total time played:</b> $foo->timeplayed</small></small>";
    }

foreach (
$xml->stats->lifetime as $foo
    {
    
$PHour "&nbsp;&nbsp;<small><small><b>Kills per hour:</b> $foo->killsperhour</small></small>";
    } 
then replace lines:

PHP Code:
    $tpl->set("title""Viewing Player: " $playername); // Window title
    
$tpl->set("page_heading""Viewing Player: " $playername); // Page header 
with this:
PHP Code:
    $tpl->set("title""Viewing Player: " $playername); // Window title
    
$tpl->set("page_heading""" $Avatar $playername $SRank $TTima $PHour); // Page header 
Enjoy!
That's pretty neat. I'll include something like that in the next web stats release.

Quote:
Originally Posted by RainMaker View Post
Hi
I am setting up this stats for my l4d2 server.
But i always get this error, and its not working.
The error is :

L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] FetchOverrides() query failed: SELECT type, name, flags FROM sm_overrides
L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] Query error: Table 'l4dstats.sm_overrides' doesn't exist
L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] FetchGroups() query failed: SELECT flags, name, immunity_level FROM sm_groups
L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] Query error: Table 'l4dstats.sm_groups' doesn't exist
L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] FetchUsers() query failed: SELECT id, authtype, identity, password, flags, name, immunity FROM sm_admins
L 01/08/2011 - 16:23:26: [admin-sql-prefetch.smx] Query error: Table 'l4dstats.sm_admins' doesn't exist

I did install from the web with install.php, and that works fine.

What do i do wrong, i tryed to reinstall 5 times now ;(

Hope you can help me.

Btw its an Debian server.
Those errors do not originate from the stats plugin. That is output of [admin-sql-prefetch.smx] -plugins error logs.
__________________
Monster Hunter

Though certainly not superhuman, the man's prowess inspires an excess of whispered rumors. But those rumors remain in the realm of speculation.
muukis is offline
RainMaker
New Member
Join Date: Jan 2010
Location: Denmark
Old 01-08-2011 , 12:51   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #1153

Quote:
Originally Posted by muukis View Post
Those errors do not originate from the stats plugin. That is output of [admin-sql-prefetch.smx] -plugins error logs.
Do you know how to fix that problem ?
RainMaker is offline
Send a message via MSN to RainMaker Send a message via Skype™ to RainMaker
muukis
Veteran Member
Join Date: Apr 2009
Old 01-08-2011 , 14:01   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #1154

Quote:
Originally Posted by RainMaker View Post
Do you know how to fix that problem ?
Sorry, I have no knowledge on that subject. You should ask the author of that plugin? Somehow it looks to me like it's part of SourceMod, but like I said, I have no knowledge on how it is supposed to be configured or what is required for it to work properly?
__________________
Monster Hunter

Though certainly not superhuman, the man's prowess inspires an excess of whispered rumors. But those rumors remain in the realm of speculation.
muukis is offline
RainMaker
New Member
Join Date: Jan 2010
Location: Denmark
Old 01-08-2011 , 14:18   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #1155

OKay, but how comes i get this then :
L 01/08/2011 - 20:15:14: [l4d_stats.smx] Databases.cfg missing 'l4dstats' entry!

I did fill the databases.cfg file, with same info that i use for the web page
I dont get it
RainMaker is offline
Send a message via MSN to RainMaker Send a message via Skype™ to RainMaker
muukis
Veteran Member
Join Date: Apr 2009
Old 01-08-2011 , 14:50   Re: [L4D & L4D2] Custom Player Stats v1.4B101
Reply With Quote #1156

Quote:
Originally Posted by RainMaker View Post
OKay, but how comes i get this then :
L 01/08/2011 - 20:15:14: [l4d_stats.smx] Databases.cfg missing 'l4dstats' entry!

I did fill the databases.cfg file, with same info that i use for the web page
I dont get it
Me neither!

If you have a proper stats entry at your cfg, it's really a mystery. But before leaving it all to the status of mystery, I suggest you do a double check on your cfg's and then again, if it does not work. A tip that might help (don't take this the wrong way): Before editing the databases.cfg, try to understand how the curly brackets work, how they are positioned and what information lays under what level of depth of the curly brackets.

Example:
Code:
Level: ROOT
{
      Level: 1
      {
           Level: 2
           {
           }
      }
}
__________________
Monster Hunter

Though certainly not superhuman, the man's prowess inspires an excess of whispered rumors. But those rumors remain in the realm of speculation.

Last edited by muukis; 01-08-2011 at 14:58.
muukis is offline
muukis
Veteran Member
Join Date: Apr 2009
Old 01-10-2011 , 04:14   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1157

Uploaded new versions for both plugin and web stats... finally! Sorry for not being able to deliver anything better at the moment.

I have to admit that the final push that fired my enthusiasm towards the project was done by Dude and the post that was made by him. Well, I already had some stuff done here and there, like most of the Message Of The Day feature and some other stuff. Still, I thank you for that, Dude!

Lets look what was done in the update - It's not much...

The Plugin:
- Added sound effects on Boomer Perfect Blindness, Hunter Death From Above, Tank Bulldozer and Charger Scattering Ram.
- Added couple of checks to i.e. prevent leaving players to cause errors on logs.
- Added new administrator console command: sm_rank_motd <message>. Using this command an administrator with a GENERIC flag can set a new Message Of The Day, which is then displayed on the web stats or the in-game MOTD, if the server is configured so. Plans are to display the message to all players when connecting or when new MOTD is set.
- Hopefully improved All Survivors Down detection, and by "hopefully" I mean that hopefully I did not break the current detection system.
- New CVAR: l4d_stats_enable. Enable/Disable all stat tracking.

The Web Stats:
- New page: motd.php. See attachments for example.
- Added Steam player profile information view. This includes player avatars.
- Added more rows on each rank awards (configurable) in addition to Most Efficient Player award (=PPM).
- Added modifiable Timed Maps display. In some cases, when a large number of recorded times have been developed by the players, the page might get timed out. In that case the Timed Maps page can be partially removed (configurable) so that it cannot be accessed using parameterless entry.
- New configurables to config.php:
PHP Code:
// How many top players would you like to show on the awards page on each award?
// Note! You should set this value to at least 1.
$award_display_players 3;

// Show/hide link for the timed maps (also disables the page for parameterless use)
$timedmaps_show_all False;

// Allow reading of player Steam profile (overrides all avatar related if set to False)
// Warning! Setting value to true can slow loading of some pages.
$steam_profile_read True;

// Show/hide player avatars (overrides all other avatar related if set to False)
$players_avatars_show True;

// Show/hide online player avatars
// Warning! Setting value to true will slow down the index page some, depending how
// many players are currently online.
$players_online_avatars_show False;

// Number of players to show additional info at Top 10 -players list (set to 0 to disable)
// Shows player avatar and some other information.
// Warning! Setting a number higher than 0 (zero) will slow every page load a little.
$top10players_additional_info 0;

// Show Message Of The Day in each page
$show_motd True
It is possible that I have forgotten something interesting and/or otherwise important. I will get back to you if I find something to tell you. I hope you like it!
Attached Thumbnails
Click image for larger version

Name:	motd.png
Views:	288
Size:	55.2 KB
ID:	80482   Click image for larger version

Name:	player.jpg
Views:	217
Size:	85.0 KB
ID:	80483  
__________________
Monster Hunter

Though certainly not superhuman, the man's prowess inspires an excess of whispered rumors. But those rumors remain in the realm of speculation.

Last edited by muukis; 01-10-2011 at 13:34.
muukis is offline
rava
Senior Member
Join Date: Aug 2009
Old 01-10-2011 , 08:30   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1158

Hello,

Question: I see nothing in Timed Maps why? thank you help

[see here]
__________________
rava is offline
muukis
Veteran Member
Join Date: Apr 2009
Old 01-10-2011 , 09:06   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1159

Quote:
Originally Posted by rava View Post
Hello,

Question: I see nothing in Timed Maps why? thank you help

[see here]
Not quite sure, but it seems your Timed Maps table is empty? You have only versus players in your ranks? Versus gamemode does not save map times.

You are, at least partially using the latest web stats I uploaded today, am I right? If so, you should merge the templates! There are some mods and some completely new templates you need to upload.

EDIT: No, I don't think you are using the new version. Then it's just because your server plays 2 team gamemodes, in which the timed maps is disabled. The time is so much depending on the team infected, that I don't think it's comparable. The updated version allows you to disable the timed maps link from the layout.
__________________
Monster Hunter

Though certainly not superhuman, the man's prowess inspires an excess of whispered rumors. But those rumors remain in the realm of speculation.

Last edited by muukis; 01-10-2011 at 09:09.
muukis is offline
Dude
Junior Member
Join Date: Dec 2010
Old 01-10-2011 , 12:00   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1160

Timed Maps = Survival. Name on stats site should be changed to SURVIVAL mode
__________________
Gamers Community: gamesteams.com/Dude.html
Dudeists Steam Gropup server with stats http://left4bowl.clanservers.com
Dude is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 22:05.


Powered by vBulletin®
Copyright ©2000 - 2015, vBulletin Solutions, Inc.
Theme made by Freecode