YaBB SE Community

Development => Completed mods => Topic started by: Spaceman-Spiff on June 27, 2003, 04:22:14 PM

Title: [Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on June 27, 2003, 04:22:14 PM
ID: More More Stats
Version: 1.1

Mod Info:
This mod adds more stuff into the [more stats] page:
Top 10 Positive Karma (if karma is enabled)
Top 10 Negative Karma (if karma is enabled)
Top 10 Topic Starter
Top 10 Online Time (need online time mod (http://www.yabbse.org/community/index.php?thread=24329&start=30#msg183591))

Download:
BoardMod File (http://www.spiff.xtram.com/ysemods/More_More_Stats_v1.1.zip)

Available Translations:
-

Screenshot:
(http://www.spiff.xtram.com/images/more_more_stats.png)

BoardMod Installation Instructions:
1. Run this .mod file in BoardMod
2. Upload the changed files (language files and Stats.php)

Changelogs:
Ver 1.1:
all stats have show/hide option
added negative karma & online time

If you have good suggestions on what should be added more into the More Stats page, go ahead and reply to this topic.

You can also add your own stats if you know some PHP and SQL. It's not that hard.
Title: Re:[Done 1.5.x] More More Stats
Post by: PC-Link on June 28, 2003, 12:54:17 AM
How about:

Top Ten Most Times Connected To Forum.

or

Top Ten Visitors.

Good Luck,
PC Link
Title: Re:[Done 1.5.x] More More Stats
Post by: loudog on June 28, 2003, 01:29:08 AM
Thanks for the topic starter mod, this is what I've been waiting for, a way to see who's really creating new and interesting topics. Now I will do contest that include these people, as a reward for the hard work in surfing for new topics. Thanks for the great mod!!!! ;D
Title: Re:[Done 1.5.x] More More Stats
Post by: Gere on June 28, 2003, 03:19:40 AM
Installed and works fine, TOP 10 posters of the month would be great but I think its not possible.
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on June 28, 2003, 10:16:16 AM
How about:

Top Ten Most Times Connected To Forum.
or
Top Ten Visitors.
yabbse doesn't log the online time, but there's a mod that does that...
visitors: yabbse also doesn't log guests that visited the forum

Quote
TOP 10 posters of the month
this might work...
Title: Re:[Done 1.5.x] More More Stats
Post by: A.M.A. on June 28, 2003, 10:27:39 AM
::..|YaGMbSS|..::
Yet another Great Mod by Spaceman Spiff. Thanks SS for all the hard work.
Title: Re:[Done 1.5.x] More More Stats
Post by: PunkDeath on June 28, 2003, 10:58:27 AM
Ok I installed it and I got this error
Parse error: parse error, unexpected $ in /home/virtual/site2/fst/var/www/html/english.lng on line 1602

So I unistalled it and now i get this error
Parse error: parse error, unexpected $ in /home/virtual/site2/fst/var/www/html/english.lng on line 1608


Can anybody help me?
Title: Re:[Done 1.5.x] More More Stats
Post by: oldiesmann on June 28, 2003, 11:44:56 AM
Hmmm... Post lines 1605-1610 of your english.lng file please... Looks like a simple error, but I can't really tell you what to do to fix it without seeing the english.lng file.
Title: Re:[Done 1.5.x] More More Stats
Post by: PunkDeath on June 28, 2003, 12:23:29 PM
Can't seem to find it... it only goes up to line like 1400 something...
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on June 28, 2003, 02:07:02 PM
weird...
if u haven't installed any other mods, i recommend you to use a fresh english.lng file and reinstall the mod...
Title: Re:[Done 1.5.x] More More Stats
Post by: PunkDeath on June 28, 2003, 02:41:24 PM
weird...
if u haven't installed any other mods, i recommend you to use a fresh english.lng file and reinstall the mod...

I fixed the problem... for some odd reason on my FTP there are these apache logs that are taking up 25MB+ of space and when I installed the mod and re uploaded the files the whole file didn't get uploaded... when we get somebody to get rid of the damn Apache Files I'll try again and see if it works.
Title: Re:[Done 1.5.x] More More Stats
Post by: Aeon on June 28, 2003, 02:42:56 PM
about Top 10 Topic Starter ,
it could encourage stupid users to start flooding and spamming in the forum ...

but the Karma thing is GREAT ;)
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on June 28, 2003, 02:54:14 PM
::..|YaGMbSS|..::
Yet another Great Mod by Spaceman Spiff. Thanks SS for all the hard work.
thanks :)

about Top 10 Topic Starter ,
it could encourage stupid users to start flooding and spamming in the forum ...

but the Karma thing is GREAT ;)
if you want, it's easy to change them into Top 10 Karma and Top 10 Negative Karma ;)
Title: Re:[Done 1.5.x] More More Stats
Post by: PunkDeath on June 28, 2003, 02:55:52 PM
::..|YaGMbSS|..::
Yet another Great Mod by Spaceman Spiff. Thanks SS for all the hard work.
thanks :)

about Top 10 Topic Starter ,
it could encourage stupid users to start flooding and spamming in the forum ...

but the Karma thing is GREAT ;)
if you want, it's easy to change them into Top 10 Karma and Top 10 Negative Karma ;)

Yeah I was about to ask something similar to that... I just want the Top 10 Topic Starters... would it be easy to make it not install the Top 10 Karma because at my board we do not use Karma.
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on June 28, 2003, 03:33:51 PM
i see... i'll try to make checkboxes to show/hide certain stats in the next version...
Title: Re:[Done 1.5.x] More More Stats
Post by: PunkDeath on June 28, 2003, 03:52:26 PM
i see... i'll try to make checkboxes to show/hide certain stats in the next version...

Yeah that would be a great idea... can't wait for the next version!
Title: Re:[Done 1.5.x] More More Stats
Post by: Surfy on June 29, 2003, 06:15:03 AM
Great Mod  :D

If i want to use the "Onlinetime" instead of Karma (i dont use them), what should i do?

It would be great if someone could poste me the code  :)



Surfy
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on June 29, 2003, 11:07:11 AM
first of all, you need to install the Profile Online Time mod, then I'll give u the code...
Title: Re:[Done 1.5.x] More More Stats
Post by: Webby on June 29, 2003, 03:48:08 PM
I have this one installed, would be nice ;)
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on June 29, 2003, 05:12:52 PM
I have this one installed, would be nice ;)
ok, will be included in the next version
Title: Re:[Done 1.5.x] More More Stats
Post by: Surfy on June 29, 2003, 05:41:41 PM
first of all, you need to install the Profile Online Time mod, then I'll give u the code...


wow, thank you. The Onlinetime_mod is installed  :D  I hope you post soon  :D

Surfy
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on June 29, 2003, 08:01:24 PM
released v1.1, changes:
modified around 1/2 of the Stats.php source
all stats have show/hide option
added negative karma & online time

i haven't test it in a clean board yet, so tell me if there's something wrong...
Title: Re:[Done 1.5.x] More More Stats
Post by: PunkDeath on June 29, 2003, 09:05:05 PM
released v1.1, changes:
modified around 1/2 of the Stats.php source
all stats have show/hide option
added negative karma & online time

i haven't test it in a clean board yet, so tell me if there's something wrong...

WoW the mod is really nice... great job!
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on June 30, 2003, 09:43:18 AM
its better if you post that in Online Time's topic o_O
Title: Re:[Done 1.5.x] More More Stats
Post by: Gere on June 30, 2003, 10:54:03 AM
I couldnt find it.  :P


EDIT: Oh, it was on the 17th page and over 6 months old. Is there another thread that I've missed.
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on June 30, 2003, 11:01:17 AM
i couldn't find it too yesterday when making this topic :P
can u give me the link pls...
and is the mod author still active?
Title: Re:[Done 1.5.x] More More Stats
Post by: Gere on June 30, 2003, 12:58:18 PM
http://www.yabbse.org/community/index.php?board=158;action=display;threadid=7991

the author doesnt seem to be active
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on June 30, 2003, 01:30:45 PM
thx

vorapoap (vory) was last active on Fri Nov 08, 2002
hmm... maybe i should ask him if i can upgrade his mod...
Title: Re:[Done 1.5.x] More More Stats
Post by: Surfy on July 01, 2003, 03:42:25 AM

thank you for this great addons  :-*

Someone from the German Mod Team has upgradet this Mod, you can look here:

http://www.yabbse.org/community/index.php?board=171;action=display;threadid=23758

Surfy
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on July 03, 2003, 12:53:03 AM
can anyone confirm if the German version is working fine or not? or should i try to contact vory to ask if i should upgrade his mod?
Title: Re:[Done 1.5.x] More More Stats
Post by: BigMike on July 03, 2003, 03:02:52 AM
Hey Spaceman-Spiff,

I saw your reply on the other post; thanks!

I installed it and it lists the first 10 members in alphabetical order  :-\
Not quite right...

I've got 1.5.4 with Supermod and More More Stats installed. Everything is in great working order before this one.

I did the query and checked my tables and its all good there..

Any ideas?


BigMike
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on July 03, 2003, 10:36:54 AM
which stats show the first 10 members in alphabetical order?
can i have a link?
Title: Re:[Done 1.5.x] More More Stats
Post by: Wiziwig on July 03, 2003, 06:00:45 PM
No Surfy, someone in the german forum posted the most recent converted mod and that conversion was done by me for YabbSE Pre-1.5.1 R40, I had given up further coversion development of that mod after the release of YabbSE 1.5.1. Reason, The mod no longer worked. Why? It no longer read or calculated the time values from logonline. Why? Something that YabbSE Changed in the logging functions.



thank you for this great addons  :-*

Someone from the German Mod Team has upgradet this Mod, you can look here:

http://www.yabbse.org/community/index.php?board=171;action=display;threadid=23758

Surfy
Title: Re:[Done 1.5.x] More More Stats
Post by: Surfy on July 03, 2003, 07:43:55 PM

the German Version works well !


Surfy
Title: Re:[Done 1.5.x] More More Stats
Post by: BigMike on July 04, 2003, 11:36:42 PM
which stats show the first 10 members in alphabetical order?

The Top 10 Online Time list.....and right now I've lost the controls in the admin. I think I uploaded an old copy or something. I will turn it back on tomorrow.

Quote
can i have a link?
http://board.marlincrawler.com/index.php?board=;action=stats

Regards,
BigMike
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on July 07, 2003, 01:59:56 PM
i suppose you've removed the online time top 10
well, it won't work properly if you haven't installed the online time mod
Title: Re:[Done 1.5.x] More More Stats
Post by: BiErLeEuW on July 07, 2003, 03:07:48 PM
i hope this is intergrade in 1.6 where you can set all the options on or off
Title: Re:[Done 1.5.x] More More Stats
Post by: Gere on July 08, 2003, 10:22:35 AM

the German Version works well !


Surfy
Can you send me your subs.php file so I can see how you changed the code because I couldnt find the .mod files strings in my subs.php
Title: Re:[Done 1.5.x] More More Stats
Post by: Surfy on July 15, 2003, 05:48:37 PM

It would be cool, if the Mod made some things more:

Top 10 Smilie`s
Top 10 PM Writer

Total sendet PMs (all User)

And an option to get other lookout for the grafics  :-*
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on July 15, 2003, 06:16:30 PM
it will be hard to keep track smilies use
also IM senders, since an IM can be deleted
well, the IM one can be done if you add a column in members table for numbers of IM sent, and incriment it everytime someone sends an IM (works like num of posts)
Title: Re:[Done 1.5.x] More More Stats
Post by: Surfy on July 16, 2003, 01:35:10 AM
the IM one can be done if you add a column in members table for numbers of IM sent, and incriment it everytime someone sends an IM (works like num of posts)

Cool! Does it work too for a statistic, which person gets how much PM`s?

Surfy
Title: Re:[Done 1.5.x] More More Stats
Post by: sctster on January 11, 2004, 12:10:02 AM
the online time mod is VERY hard to find, i've been trying for quite a while and am hitting a bunch of broken links.  If anyone has the zip, please email it to me or post it here.
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on January 19, 2004, 06:23:00 PM
i cant find the link myself, but here's the file (http://www.spiff.xtram.com/ysemods/ProfileOnlineTime.zip)
for some reason i have 2 versions, just try each one and see which one works...

<id>
Online Time Mod
</id>

<version>
v1.0 YSE 1.5.1
</version>

<mod info>
This mod will display the online time on the profile page and member list.

*** Run these queries first ***

ALTER TABLE yabbse_members ADD COLUMN onlineTime bigint DEFAULT 0;
UPDATE yabbse_members SET onlineTime = 0;
</mod info>

<author>
Originally by Vorapoap Lohwongwatana for 1.4.1 Re-written for YSE 1.5.1 by wiziwig
</author>
Title: Re:[Done 1.5.x] More More Stats
Post by: Thomas on February 01, 2004, 06:59:41 PM
Hi

I get this errormessage:

Unknown column 'onlineTime' in 'field list'
Fil: /home/dykkesid/www/forum/Sources/Profile.php
Linje: 892

Ideas?

/Thomas
Title: Re:[Done 1.5.x] More More Stats
Post by: Shadow's Pawn on February 02, 2004, 04:43:40 AM
Did you install the Online Time mod?

If so, you must run the query to add the field 'onlineTime' to the members table.
Title: Re:[Done 1.5.x] More More Stats
Post by: Thomas on February 02, 2004, 12:19:57 PM
I installed the mod and have run the query....

It still wount work... :'(


/thomas
Title: Re:[Done 1.5.x] More More Stats
Post by: Spaceman-Spiff on February 02, 2004, 05:23:00 PM
hmm... you can disable the online time one if it doesnt work for you...
Title: Re:[Done 1.5.x] More More Stats
Post by: Shadow's Pawn on February 03, 2004, 10:06:22 PM
Hi

I get this errormessage:

Unknown column 'onlineTime' in 'field list'
Fil: /home/dykkesid/www/forum/Sources/Profile.php
Linje: 892

Ideas?

/Thomas

Where did you run the query?  Can you open up phpmyadmin and check the member's table to make sure that there is a field called onlineTime in the member's table?
Title: Re:[Done 1.5.x] More More Stats
Post by: Thomas on February 06, 2004, 08:03:00 PM
Hi

I had changed the prefix of my database to something other than yabbse. When I changed this - the update worked.

/Thomas
Title: Re:[Done 1.5.x] More More Stats
Post by: Thomas on February 06, 2004, 08:16:26 PM
Hi again

A couple of questions.

Why doesent my profilpage show som tome after online time:
http://www.dykkesiden.com/forum/index.php?action=viewprofile;user=admin

My stats page looks like this:
http://www.dykkesiden.com/forum/index.php?board=;action=stats
Is this right? I should probably stand on the top, but the otheres is definataly wrong...

/Thomas
Title: Re:[Done 1.5.x] More More Stats
Post by: Shadow's Pawn on February 06, 2004, 09:18:05 PM
That's because the online time mod doesn't work with the current version of yabbse.
Title: Re:[Done 1.5.x] More More Stats
Post by: bluesyrio on February 11, 2004, 09:27:22 AM
Does anyone know if there are plans to make the online time mod compatible with 1.5.5?
Title: Re:[Done 1.5.x] More More Stats
Post by: Shadow's Pawn on February 11, 2004, 05:30:46 PM
Please check the Online Time thread.

http://www.yabbse.org/community/index.php?thread=7991

There is a fix.
Title: Re:[Done 1.5.x] More More Stats
Post by: Shadow's Pawn on February 11, 2004, 08:54:08 PM
This might just be my forums, but the stats for Top 10 Online Time doesn't display properly on any of my forums or on my test forum.  The stats just stack the times onto the people below them, so it looks like this:

Joe       1 hour 2 minutes
Brian     1 hour 2 minutes 1 hour 1 minute
Craig     1 hour 2 minutes 1 hour 1 minute 1 hour
Larry     1 hour 2 minutes 1 hour 1 minute 1 hour 20 minutes

Etc.

Just thought I would let you know.  I fixed it on mine but it was a sloppy solution, in my opinion, so I'm declining to post it so that you can post a more graceful solution to this.
Title: Re:[Done 1.5.x] More More Stats
Post by: dvucko on February 12, 2004, 03:37:12 AM
This might just be my forums, but the stats for Top 10 Online Time doesn't display properly on any of my forums or on my test forum.  The stats just stack the times onto the people below them, so it looks like this:

Joe       1 hour 2 minutes
Brian     1 hour 2 minutes 1 hour 1 minute
Craig     1 hour 2 minutes 1 hour 1 minute 1 hour
Larry     1 hour 2 minutes 1 hour 1 minute 1 hour 20 minutes

Etc.

Just thought I would let you know.  I fixed it on mine but it was a sloppy solution, in my opinion, so I'm declining to post it so that you can post a more graceful solution to this.

Use this code in Stats.php:  ;)
Code: [Select]
   // Top 10 Online Time
   if ($modSettings['stats_top_online_time'] == 1)
   {
      $stats_request = mysql_query("SELECT memberName, realName, onlineTime FROM {$db_prefix}members WHERE onlineTime > 0 ORDER BY onlineTime DESC LIMIT 10;") or database_error(__FILE__, __LINE__);
      while ($stats_rows = mysql_fetch_array($stats_request))
      {
         $onlineTime = "";
         $temptime = floor($stats_rows['onlineTime']/3600);
         $request3[0]=$stats_rows['onlineTime'];
         if ($temptime > 0) {
            $onlineTime = "$temptime {$txt['ontime2']}";
            if ($temptime > 1)  $onlineTime .= $txt['ontime5'];
            $request3[0] = $request3[0]%(3600*$temptime);
         }
         $temptime = floor($request3[0]/60);
         if ($temptime > 0) {
            $onlineTime .= " $temptime {$txt['ontime3']}";
            if ($temptime > 1)  $onlineTime .= $txt['ontime5'];
            $request3[0] = $request3[0]%(60*$temptime);
         }
         if ($memsettings[28] > 0) {
            $onlineTime .= " $request3[0] {$txt['ontime4']}";
            if ($temptime > 1)  $onlineTime .= $txt['ontime5'];
         }
         $euser = urlencode($stats_rows['memberName']);
         $displayStats[$counter]['contents'] .= '<tr>
                              <td><font size="2"><a href="' . $scripturl . '?action=viewprofile;user=' . $euser . '">' . $stats_rows['realName'] . '</a></font></td>
                              <td align="right"><font size="2">' . $onlineTime . '</font></td>
                           </tr>';
      }
      $displayStats[$counter]['title'] = $txt['yse_stats_18'];
      $displayStats[$counter]['icon'] = 'stats_posters.gif';
      $counter++;
   }