vb.org Archive - Statistics Modifications - Top Thank Earners (monthly stats) for non-vb pages

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Statistics Modifications - Top Thank Earners (monthly stats) for non-vb pages (https://vborg.vbsupport.ru/showthread.php?t=146277)

Top Thank Earners (monthly stats) for non-vb pages

Top Thank Earners (monthly stats) for non-vb pages
Version: 1.02
Author: LBmtb[/email]
Last updated: May 3nd, 2007

DESCRIPTION:

This displays the top X thank earners in X month. The X's are configurable. You can have multiple tables in a single page. For example: you can have "Top 20 in May 2007" and have "Top 5 in April 2007" or any other combination you can think of.

The table it produces is a plain jane table but can be styled with CSS. The table's class is "top_thanks" and the rows have alternating classes ("odd" and "even") in case you want to do alternating colors for the rows. Here's what it looks like:

HTML Code:

<table width="100%" cellpadding="0" cellspacing="0" summary="two months ago" class="top_thanks">

<th scope="col">Position</th><th scope="col">Username</th><th scope="col">Thanks Earned</th>

<tr class="odd">

<td scope="row">1</td>

<td><a href="http://localhost/forum/member.php?u=610">Winston</a></td>

<td><a href="http://localhost/forum/search.php?do=findthanks&u=610">97</a></td>

</tr>                                                

<tr class="even">

<td scope="row">2</td>

<td><a href="http://localhost/forum/member.php?u=191">LBmtb</a></td>

<td><a href="http://localhost/forum/search.php?do=findthanks&u=191">71</a></td>

</tr>

</table>

vbSEO URLs and caching the queries are both optional. By default they are not used. Please see #3 of the instructions.

If using the caching technique ... the queries are cached for an hour to speed up the page and reduce server load. For more on the PEAR cacheing stuff, read this: http://books.google.com/books?id=iUf...rRRQ#PPA272,M1

A basic understanding of PHP (or be able to follow directions very well) will help a lot here.

VERSION HISTORY:

1.00: Initial release
1.01: Made using the cached technique optional.
1.02: Cleaned stuff up. Made it a bit easier to use and configure.

REQUIREMENTS:

1) Pear must be setup on your server to use the cached technique. You MIGHT need to do an ini_set() to get the Cache/DB.php available to you.
2) vbSEO is optional. See instructions for how to get vbSEO'ized member urls.
3) Abe's Post Thank You Hack. You may download it here: https://vborg.vbsupport.ru/showthread.php?t=122944
4) The page you use this on needs to have a php extension or if it's html, parse it as php (you can set this in htaccess)

INSTALLATION INSTRUCTIONS:

1) Open thanks1-02.php and fill in variables under "FILL IN STUFF BELOW, mk?"

2) Upload thanks1-02.php to your site (same directory where your top thank earner page will be)

3) On the stats page, add the following somewhere before the stats and change first two variables if you'd like:

PHP Code:


		
			
<?php

// change to true if you wish to use either of the following ...

$vbseo_urls = false;

$cached_technique = false;



if ($cached_technique)

{

    require 'Cache/DB.php';

}



if ($vbseo_urls)

{

    include_once "forum/includes/functions_vbseo.php"; 

}



require "thanks1-02.php";

?>

4) Wherever you want a top thank earners table to appear, put in the following code and configure it a bit (look over the comments):

PHP Code:


		
			
<?php



// NOTE: "$thisMonth" variable should be different for each table you're making (each instance of thanks class)



    $thisMonth = new thanks($start_epoch,$end_epoch); 

    /*    

         $start_epoch (optional): Epoch timestamp of time for earliest thanks (beginning of month usually). Defaults to beginning of current month.

         $end_epoch (optional): Epoch timestamp of time for latest thanks (end of month usually). Defaults to end of current month.

    */

    

    $thisMonth->grab_n_sort($string,$vbseo_url,$cached_technique); 

    /*

        $string (required): Any variable name in form of a string (should be different for each table) 

    */

    

    $thisMonth->print_chart($top_x,$table_summary); 

    /*

        $top_x: is top x thanks earners to show in number format

        $table_summary: for the table's summary attribute

    */

?>

The previous make a table for the current month. For months other then the current month...
thanks() takes two optional arguments. Those arguments are epoch values for the beginning and end of a different month.

Example 1: For stats from two months ago, do this:

PHP Code:


		
			
$start_epoch = mktime(0, 0, 0, (date(m)-2), 1, date(Y));  // epoch for beginning of month

    $end_epoch = mktime(23, 59, 0, (date(m)-1), 0, date(Y));  // epoch for end of month



    $twoMonthsAgo = new thanks($start_epoch,$end_epoch);

Example 2: For stats one month ago:

PHP Code:


		
			
$start_epoch = mktime(0, 0, 0, (date(m)-1), 1, date(Y)); // beginning of month epoch ex. 01/01/07 12:00 AM

    $end_epoch = mktime(23, 59, 0, (date(m)), 0, date(Y)); // end of month epoch ex. 01/31/07 11:59 PM



    $oneMonthAgo = new thanks($start_epoch,$end_epoch);

DEMO:

http://www.socaltrailriders.org/top-thanks.php

HELP/TROUBLESHOOTING:

I will try and support this mod as much as time allows on the vBulletin.org thread. Customizations to your own website can be done for a fee. PM me about that if necessary.

COPYRIGHT:

Please do not remove the copyright from the script.

DONATE:

If you use and appreciate this script, please say thank you by donating something: Donate

1st post reserved just in case.

what i want! perfect

nice hack but doesnt work for me

Quote:

Originally Posted by tanyeri24 (Post 1239985)

nice hack but doesnt work for me

Any error? Where are you stuck?

i getting this error on my self created php file:

Code:

Warning: mkdir(/usr/www/users/xxx/db_cache/): Keine Berechtigung in /usr/local/lib/php/Cache/Container/file.php on line 339



Fatal error: Call to undefined function: query() in /usr/local/lib/php/Cache/DB.php on line 189

The first part of your error is the script running into a problem when trying to make the db_cache folder. It creates that folder inside of the directory that your using the script and it holds the files with the cached queries. I actually also ran into the problem too and instead of f'ing with it, I just created it myself. That's probably the easiest thing to do. And then I chmod'd it 777.

The second part of your error has to do with the query. Might be fixed after the db_cache folder is made.

Would you or anyone else want an option to use the regular (non-caching) way of querying the database? It'll avoid that db_cache folder problem.

hi thanks for yer message. I created the folder (and chmod), now the error message is reduced:

Code:

Fatal error: Call to undefined function: query() in /usr/local/lib/php/Cache/DB.php on line 189

Possible to put this in the forumhome somehow ?

.

What kind of queries are involved here and can I alter it to update cache like every 12 hours instead? I just get a little worried since I have over 1.3 million "thanks" issued on my board. Thanks for any advice you may be able to give.

Its working for you?

Quote:

Originally Posted by tanyeri24 (Post 1241022)

Its working for you?

I made a new version of it. Hopefully it's easier to use and configure. By default vbSEO URLs and using the cached queries technique is turned off. Make sure you read the instructions.

Let me know if that works for ya! :)

Quote:

Originally Posted by RMS-Chef (Post 1240959)

The query is:

Code:

SELECT p.username, p.userid

FROM {$this->db_prefix}post_thanks t INNER JOIN {$this->db_prefix}post p 

ON t.postid = p.postid 

WHERE t.date BETWEEN ". $this->beginning ." AND ". $this->end_month ."

ORDER BY date DESC

You CAN change the option for how long it takes to refresh the query. You'd have to supply constructor arguments to the class when you create the instance of it (in the php file). For a thourough rundown on what arguments it takes and how to do it, check out this link. It's on the last paragraph of page 272 and then beginning of the next page.

Let me know if you need help with that. Good luck!

hey nice work, i always like to see more hacks for non vb pages. ill give this a go another day tho. thanks.

Quote:

Originally Posted by LBmtb (Post 1241049)

Hi thanks for update. I get only a blank page with the codes in 3). At 4) I've again error code like this:

Code:

Fatal error: Cannot instantiate non-existent class: thanks in /usr/www/users/xxx/xxx.php on line 5

:erm: :o :(

Got it working for 1 month, however I'm experiencing probs when i want to display 2 months or more (PHP NOOB here:o )

Code for 1 month (working)

Code:

<?php

// change to true if you wish to use either of the following ...

$vbseo_urls = false;

$cached_technique = false;



if ($cached_technique)

{

        require 'Cache/DB.php';

}



if ($vbseo_urls)

{

        include_once "forum/includes/functions_vbseo.php"; 

}



require "thanks1-02.php";

?>

<?php

// NOTE: "$thisMonth" variable should be different for each table you're making (each instance of thanks class)

//        $string (required): Any variable name in form of a string (should be different for each table)  





// 2 months ago

$start_epoch = mktime(0, 0, 0, (date(m)-2), 1, date(Y));  // epoch for beginning of month 

$end_epoch = mktime(23, 59, 0, (date(m)-1), 0, date(Y));  // epoch for end of month 



$twoMonthsAgo = new thanks($start_epoch,$end_epoch);

$twoMonthsAgo ->grab_n_sort($string,$vbseo_url,$cached_technique); 

$twoMonthsAgo ->print_chart(10,$table_summary);

        

?>

Code for 2 months (results in blank page)

Code:

<?php

// change to true if you wish to use either of the following ...

$vbseo_urls = false;

$cached_technique = false;



if ($cached_technique)

{

        require 'Cache/DB.php';

}



if ($vbseo_urls)

{

        include_once "forum/includes/functions_vbseo.php"; 

}



require "thanks1-02.php";

?>

<?php

// NOTE: "$thisMonth" variable should be different for each table you're making (each instance of thanks class)

//        $string (required): Any variable name in form of a string (should be different for each table)  





// 2 months ago

$start_epoch = mktime(0, 0, 0, (date(m)-2), 1, date(Y));  // epoch for beginning of month 

$end_epoch = mktime(23, 59, 0, (date(m)-1), 0, date(Y));  // epoch for end of month 



$twoMonthsAgo = new thanks($start_epoch,$end_epoch);

$twoMonthsAgo ->grab_n_sort($string,$vbseo_url,$cached_technique); 

$twoMonthsAgo ->print_chart(10,$table_summary);

        

// 1 month ago        

$start_epoch = mktime(0, 0, 0, (date(m)-1), 1, date(Y)); // beginning of month epoch ex. 01/01/07 12:00 AM 

$end_epoch = mktime(23, 59, 0, (date(m)), 0, date(Y)); // end of month epoch ex. 01/31/07 11:59 PM 



$oneMonthAgo = new thanks($start_epoch,$end_epoch);  

$oneMonthsAgo ->grab_n_sort($string,$vbseo_url,$cached_technique); 

$oneMonthsAgo ->print_chart(10,$table_summary);

?>

What am I doing wrong?
I guess it has something to do with the $string ?
What should i use in stead of $string for the other months,....?
tia

Solved like this,
is this a good code?

Code:

// This month 

$string = 'thismonth';

$thisMonth = new thanks($start_epoch,$end_epoch);  

$thisMonth->grab_n_sort($string,$vbseo_url,$cached_technique);  

$thisMonth->print_chart(10,$table_summary); 



// 1 month ago

$start_epoch = mktime(0, 0, 0, (date(m)-1), 1, date(Y));  // epoch for beginning of month 

$end_epoch = mktime(23, 59, 0, (date(m)), 0, date(Y));  // epoch for end of month 

$string = 'oneMonthsAgo';



$twoMonthsAgo = new thanks($start_epoch,$end_epoch);

$twoMonthsAgo ->grab_n_sort($string,$vbseo_url,$cached_technique); 

$twoMonthsAgo ->print_chart(10,$table_summary);



// 2 months ago

$start_epoch = mktime(0, 0, 0, (date(m)-2), 1, date(Y));  // epoch for beginning of month 

$end_epoch = mktime(23, 59, 0, (date(m)-1), 0, date(Y));  // epoch for end of month 

$string = 'twoMonthsAgo';



$oneMonthsAgo = new thanks($start_epoch,$end_epoch);

$oneMonthsAgo ->grab_n_sort($string,$vbseo_url,$cached_technique); 

$oneMonthsAgo ->print_chart(10,$table_summary);

when it'll be in alpha stage?
:D

What would you change to make it "thanks gave" instead of "thanks earned"?

what about server load ?

is it optimalized mod ?

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01335 seconds Memory Usage 1,833KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (1)bbcode_html_printable (4)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (23)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: