BETA release: HLStats 1.50beta

Banana · **Posted:** Tue Mar 03, 2009 10:35 am

well i'm proud to announce the beta release of the next version of HLStats.

see attached file for download.

Please remeber this is a beta release. There could and are bugs.

Any problem you may find, report to this thread here. Only here will be answered.

Changelog so far:

Code:

1.50 (TBA)
*) New: EloRating system. Can be activated and used sperate it along with the existing (thx to HampusW)
*) New: Beta support for Zombie Panic
*) New: IngamePoints option in hlstats.conf allows to de/active the skill report at kill/frag (thx to  Schlesie)
*) New: Beta gamesupport for L4D
*) New: At server configuration you can enter the default map. This map is used
      if HLStats is unable to determine the map.
*) New: /skill and /pskill now reports the KpD too. (Feature request: 2556961 )
*) Fixed: there were still some php short tags in some scripts (thx to psychonic and enemy)
*) Fixed: Missing semicolon on hlstats-resolv.pl (thx to  freaker)
*) Fixed: Missing & at the hlstats.sh script (thx to Shakal)
*) Fixed: Possible error in query (sig.php) and include path(xml.php) (thx to Andre86)
*) Fixed: Error for connects flash as no player data was in events table
*) Fixed: tf2 gamesupport file
*) Changed: Improvements to the flash charts
*) Changed: SQl Improvements to the database and queries which speeds at large amount of data
*) Changed: hlstats.pl prints only info with -d
*) Changed: hls_skill and hls_pskill are now skill and pskill
*) Changed: Improved support for utf-8
*) Changed: Improved base sql file. WARNING it will only work with mysql 4.1.x and newer
*) Changed: DB Error shows only error and no user information
*) Changed: Simplified the db class, since we only support mysql
*) Changed: cleaned code base and now using PHP 5
*) Added: sm_psay for a private say command with sourceMod (thx to unkraut)
*) Added: a not to the installer, to activate cookies

What I need from you is:

- Test this as much as you can, every failure you may find will improve HLStats.
- If you can provide map and weapon pics for l4d and zps
- test and give feedback to the new rating system (see below)

Main change:
The EloRating system developed by HampusW.
For further information about what the ranking system is go here:
viewtopic.php?f=16&t=1018

To active and use the new system change the value for ELORATING on hlstats.conf.inc.php to 1 (value 2 is not really working yet) and the value for EloRating to 1 in hlstats.conf
You must active this on both files and restart hlstats.pl

Please make sure you run this with some players and days. Since the system needs more data to work with and more time to display results.

You can also run this beta at the same time with your current installation. Just use a different db_prefix and a differen port.

that is all for now.

thx for your support and input.
banana

Badi · **Posted:** Tue Mar 03, 2009 9:18 pm

1.
Check for writeability on a non existent file does not work on w2k3/IIS6.

Code:

$fhConfWeb = is_writeable("../hlstatsinc/hlstats.conf.inc.php");

2.

Code:

Use this file and move it to the location of your daemon folder and overwrite the existing configuration file.

There is no existing hlstats.conf. This could be misleading.

3.

Add new game (TF2)

Code:

Database Error

Error Diagnostic:
Bad query.

Server Error: (1265) Data truncated for column 'for_PlayerPlayerActions' at row 1

Last SQL Query:

INSERT INTO hlstats_Actions VALUES(NULL, 'tf2', 'flagevent_captured', 2, 0, '', 'Flagevent - Captured', '1', '', '', '');

This could be a my.ini - thing (mysql 5.1.31).

Ok...wait...

Mysql 5.1 does not like the empty fields in

Code:

'Flagevent - Captured', '1', '', '', '');

If I use

Code:

'Flagevent - Captured', '1', '0', '0', '0');

it works.

The fields are designed as "NOT NULL", so it leads to this error.

4.

Game Settings /servers

Code:

ERROR
Database Error

Error Diagnostic:
Bad query.

Server Error: (1054) Unknown column 'defaultMap' in 'field list'

Last SQL Query:


      SELECT
         serverId,
         address,
         port,
         name,
         publicaddress,
         statusurl,
         rcon_password,
         defaultMap
      FROM
         hlstats_Servers
      WHERE
         game='tf2'
      ORDER BY
         address ASC,
         port ASC
   

I guess this is because of the first db error...

Badi

Banana · **Posted:** Tue Mar 03, 2009 10:01 pm

Quote:

1.
Check for writeability on a non existent file does not work on w2k3/IIS6.

whoops my fault

Quote:

There is no existing hlstats.conf. This could be misleading.

so there is no hlstats.conf in web/install ?

Quote:

Add new game (TF2)

new one.

Quote:

Game Settings /servers

hmm, there is something missing....

Badi · **Posted:** Tue Mar 03, 2009 10:20 pm

Quote:

so there is no hlstats.conf in web/install ?

It is in web/install, but not in the daemon folder and you told us to "overwite" it in the daemon folder.

Replacing

Code:

Use this file and move it to the location of your daemon folder and overwrite the existing configuration file.

with something like this

Use this file and move it into your daemon folder.

would fix this I think

.

Quote:

Add new game (TF2)
new one.

What do you mean?

Badi

Banana · **Posted:** Tue Mar 03, 2009 10:22 pm

Quote:

with something like this

Use this file and move it into your daemon folder.

ahh ok. changed.

Quote:

What do you mean?

this is a new error. but I fixed this already as you posted.
there where values missing in the query

I've updated the file. please download again.

Badi · **Posted:** Wed Mar 04, 2009 8:43 pm

Ok, Adding games works now, but when i try to add a server this error still pops up:

Code:

Database Error

Error Diagnostic:
Bad query.

Server Error: (1054) Unknown column 'defaultMap' in 'field list'

Last SQL Query:


      SELECT
         serverId,
         address,
         port,
         name,
         publicaddress,
         statusurl,
         rcon_password,
         defaultMap
      FROM
         hlstats_Servers
      WHERE
         game='tf2'
      ORDER BY
         address ASC,
         port ASC
   

Banana · **Posted:** Wed Mar 04, 2009 9:19 pm

eh....I'm getting old....

limburatorul · **Posted:** Sun Mar 22, 2009 2:29 am

Hi, glad to see that the in game skill announce finally got reality.
Does it need anything else activated or exec-ed? I can see in hlstats.pl log

Code:

2009-03-22 02:47:23:     xxx:27015 - E011: "fane.patent" <P:1,U:16,W:fane.patent,T:TERRORIST> triggered "Spawned_With_The_Bomb"
2009-03-22 02:47:23:      xxx:27015 - E020: OK Rcon from "xxx", pw "xxx": "hls_psay 16 "You got 2 points.""
2009-03-22 02:47:48:      xxx:27015 - E011: "fane.patent" <P:1,U:16,W:fane.patent,T:TERRORIST> triggered "Planted_The_Bomb"
2009-03-22 02:47:48:      xxx:27015 - E020: OK Rcon from "xxx", pw "xxx": "hls_psay 16 "You got 15 points.""

but nothing apears in game
Do i need to ad sourcemod?

thanks

Banana · **Posted:** Tue Mar 24, 2009 12:46 pm

well this is a "bug"

I need to extend this, since it uses some "wrong" rcon command.

limburatorul · **Posted:** Tue Mar 24, 2009 1:15 pm

Banana wrote:

well this is a "bug"

I need to extend this, since it uses some "wrong" rcon command.

i see, and while you're at it. in the last few days i noticed that it only sayd + and - 0.0 points. this means no point modifier what so ever. regardless for being killed or killing someone.
might wanna look at that.

Banana · **Posted:** Tue Mar 31, 2009 4:49 pm

thx for this info

someone · **Posted:** Tue May 19, 2009 3:26 am

"new"-server query protocol?
it seems that valve changed some stuff, so my old hlstats cant query the server live anymore.

was this changed in 1.50?
what exactly was changed?

i dont want to throw away my hlstats for this change as ive rewritten it nearly from scratch

Banana · **Posted:** Tue May 19, 2009 7:51 am

Quote:

"new"-server query protocol?
it seems that valve changed some stuff, so my old hlstats cant query the server live anymore.

jup this one was also difficult for myself.
but hell I don't even remeber it now what it was exactly...

Quote:

was this changed in 1.50?
what exactly was changed?

well see at the first post, the changelog.
But the really details, well there were so much I can't tell you anymore.
I could make some diff from the svn log, but I don't know if this will help you

BETA release: HLStats 1.50beta

Who is online