VSP Stats and... Options

[Annoyer13]

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,

This post has been edited by Annoyer13: Oct 26 2017, 06:39 PM

[Krauersaut]

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?

 vspsl.png ( 127.47K ) Number of downloads: 87


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]

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

[Terror Time]

The awards code is this:

CODE

<!-- Begin Form -->

<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"><b>Mr. Hopper!</b><br>played on Servers:&nbsp;6<br><a href="/?mod=playerinfo&idx=27945" TITLE="momo"><span style="color:#FFFFFF">Momo</span></a></td>
        <td class="leftborder leftborder" style="text-align:center;padding:3px"><b>Damn, I'm good!</b><br>best map rating: <b>26.52</b><br><a href="/?mod=playerinfo&idx=36014138" TITLE="*pimp*k.lista"><span style="color:#FFFFFF"><span style="color:#585858"><span style="color:#007FFF">*<span style="color:#585858">Pimp<span style="color:#007FFF">*<span style="color:#585858">K<span style="color:#007FFF">.<span style="color:#585858">LisTa</span></span></span></span></span></span></span></span></a> in <a href="/?mod=sessioninfo&idx=153410122"><span style="color:#FFFFFF">MML&nbsp;Minas&nbsp;T...</span></a></td>
        <td class="leftborder leftborder" style="text-align:center;padding:3px"><b>Call me god!</b><br>best overall rating: <b>22.16</b><br><a href="/?mod=playerinfo&idx=37394842" TITLE=".be|itry..."><span style="color:#FFFFFF"><span style="color:#585858">.<span style="color:#FFFFFF">B<span style="color:#585858">e<span style="color:#FFFFFF">|<span style="color:#585858">i<span style="color:#FFFFFF">T<span style="color:#585858">r<span style="color:#FFFFFF">y<span style="color:#585858">...</span></span></span></span></span></span></span></span></span></span></a></td>
        <td class="leftborder leftborder" style="text-align:center;padding:3px"><b>U don't have a woman?</b><br>most time played: 10.4 hrs<br><a href="/?mod=playerinfo&idx=22766" TITLE="Vash"><span style="color:#FFFFFF"><span style="color:#7F7F7F">v<span style="color:#FFFFFF">A<span style="color:#7F007F">S<span style="color:#FFFFFF">h</span></span></span></span></span></a></td>
        <td class="leftborder leftborder" style="text-align:center;padding:3px"><b>The best place</b><br><a href="/?mod=serverinfo&idx=484793" TITLE="F|A RECRUITING XP SAVE"><span style="color:#FFFFFF"><span style="color:#FF0000">F<span style="color:#FFFFFF">|<span style="color:#FF0000">A&nbsp;<span style="color:#FFFFFF">RECRUITING&nbsp;<span style="color:#FF0000">XP&nbsp;...</span></span></span></span></span></span></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>
<!-- End Form -->

You would need to update it daily.

This post has been edited by Terror Time: Dec 3 2009, 07:18 PM

[Annoyer13]

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

[Annoyer13]

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]

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?

 vspawards.png ( 60.86K ) Number of downloads: 89

[Annoyer13]

Yes, exactly.

[RaNGe]

Yes, exactly.

You are suffering problems with the awards, right?

Are you getting this?

CODE

generateAwards: Generating Awards...done

[Annoyer13]

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]

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]

Still don't work As you can see at http://stats.wdhut.com/pub/themes/bismarck...cfg-default.php