[splatterladder] Board > VSP Stats and...

[splatterladder] Board > --:: RtCW/ET ::-- > RtCW/ET - Servers > RtCW/ET - Serveradmin-Lounge

Annoyer13

Dec 3 2009, 02:59 PM

Hello,
well I didn't know where to make this topic, so I decide to open that here.
I've got two questions. Well, I've got my VSP stats, but Awards don't show, I tried with few installations and different server.log files, but it still don't work. What's wrong and how can I fix that?
Second, I found interesing vsp stats combined with .sl stats - http://dawgs.wdhut.com I'm not sure that's their own modification or that combination is possible to download somewhere?
Regards,

Krauersaut

Dec 3 2009, 04:33 PM

QUOTE (Annoyer13 @ Dec 3 2009, 02:59 PM)

Hello,
well I didn't know where to make this topic, so I decide to open that here.
I've got two questions. Well, I've got my VSP stats, but Awards don't show, I tried with few installations and different server.log files, but it still don't work. What's wrong and how can I fix that?
Second, I found interesing vsp stats combined with .sl stats - http://stats.wolfteam.pl/ I'm not sure that's their own modification or that combination is possible to download somewhere?
Regards,

Are we talking about this servermonitor?

Click to view attachment

To get that on your vsp, you would probably need to edit a template file of vsp, adding this code: http://forum.splatterladder.com/index.php?showtopic=3131

Annoyer13

Dec 3 2009, 07:12 PM

Nope, I mean that http://stats.wolfteam.pl/splatterladder.php stats in my second question.

Terror Time

Dec 3 2009, 07:18 PM

The awards code is this:

CODE

<table class='form' align='center' cellpadding=0 cellspacing=0 border=0 style="width:90%;width:100%">
<tr><td class='body' style="padding:0px">
<div class="content"> <table class='table' style="width:100%" cellpadding=0 cellspacing=0>
 <tr>
 <td style="text-align:center;padding:3px">Mr. Hopper! played on Servers: 6 <a href="/?mod=playerinfo&idx=27945" TITLE="momo">Momo</a></td>
 <td class="leftborder leftborder" style="text-align:center;padding:3px">Damn, I'm good! best map rating: 26.52 <a href="/?mod=playerinfo&idx=36014138" TITLE="*pimp*k.lista">*Pimp*K.LisTa</a> in <a href="/?mod=sessioninfo&idx=153410122">MML Minas T...</a></td>
 <td class="leftborder leftborder" style="text-align:center;padding:3px">Call me god! best overall rating: 22.16 <a href="/?mod=playerinfo&idx=37394842" TITLE=".be|itry...">.Be|iTry...</a></td>
 <td class="leftborder leftborder" style="text-align:center;padding:3px">U don't have a woman? most time played: 10.4 hrs <a href="/?mod=playerinfo&idx=22766" TITLE="Vash">vASh</a></td>
 <td class="leftborder leftborder" style="text-align:center;padding:3px">The best place <a href="/?mod=serverinfo&idx=484793" TITLE="F|A RECRUITING XP SAVE">F|A RECRUITING XP ...</a></td>
 </tr>
 </table>
</div></td></tr>
<tr><td id='foot'>Awards for assigned players! (last 24 hours) +++ Last calculated: Dec 03 2009 at 07:42 +++ <a class="help" href="http://wiki.splatterladder.com/Awards/en" target="help">sl.Wiki</a></td></tr>
</table>

You would need to update it daily.

Annoyer13

Dec 3 2009, 09:33 PM

Terror Time, thanks, but where to put this code? Info which file?

Annoyer13

Dec 4 2009, 12:16 PM

Damn, I didn't mean that, I mean this awards from vsp stats. Something is wrong wth them, because in simple installation they're not working.

Krauersaut

Dec 4 2009, 03:05 PM

QUOTE (Annoyer13 @ Dec 4 2009, 12:16 PM)

Damn, I didn't mean that, I mean this awards from vsp stats. Something is wrong wth them, because in simple installation they're not working.

Are we talking about this column?

Click to view attachment

Annoyer13

Dec 4 2009, 08:37 PM

Yes, exactly.

RaNGe

Dec 29 2009, 03:34 PM

QUOTE (Annoyer13 @ Dec 4 2009, 09:37 PM)

Yes, exactly.

You are suffering problems with the awards, right?

Are you getting this?

CODE

generateAwards: Generating Awards...done

Annoyer13

Dec 29 2009, 04:08 PM

QUOTE (RaNGe @ Dec 29 2009, 03:34 PM)

QUOTE (Annoyer13 @ Dec 4 2009, 09:37 PM)

Yes, exactly.

You are suffering problems with the awards, right?

Are you getting this?

CODE

generateAwards: Generating Awards...done

Yeah, this text shows when I'm updating my stats. It says 'done', but awards don't show on the main vsp stats page. And nowhere else, ofc.

daredevil

Dec 30 2009, 06:23 AM

It's mysql bug. We had same issue i guess. It happens on new version of MySQl since VPS was designed when version 4.0 was around or so.

http://stats.emsgaming.com/pub/themes/bismarck/index.php

Try this changes and let me know:

edit vsp.php
search for:

CODE

set awardID=

replace with:

CODE

set `sql`='',name='',awardID=

search for:

CODE

sql=

replace with:

CODE

`sql`=

edit sql/mysql.inc.php
search for:

CODE

,sql

replace with:

CODE

,`sql`

edit pub/themes/bismarck/awardstat.php
search for:

CODE

select sql

replace with:
Code:

CODE

select `sql`

Annoyer13

Dec 30 2009, 04:11 PM

Still don't work

As you can see at http://stats.wdhut.com/pub/themes/bismarck...cfg-default.php

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.