vb.org Archive - Event Views Counter

This addon allows you to display the number of hits/views a calendar event has received.
It also inserts the eventid into the user's session, so they cannot refresh multiple times to boost the view count.

Thanks to tnguy3n with his post here

STEP 1 - MySQL modification:

Code:

ALTER TABLE event ADD hits INT(7) NOT NULL;

STEP 2 - calendar.php
FIND [line 134]

PHP Code:


		
			
($hook = vBulletinHook::fetch_hook('calendar_start')) ? eval($hook) : false;

if ($vbulletin->GPC['week'])
{
    $_REQUEST['do'] = 'displayweek';
}

BELOW, ADD:

PHP Code:


		
			
// Event Views Counter - by Robert_2004
// https://vborg.vbsupport.ru/showthread.php?t=1067471

    /*
     * Comparision done between the host info in the session object.
     * If the eventid is not stored in the session, that means the 
     * event hasn't been visited and therefore add it as a hit 
     * and update the table.
      */

$_SESSION['eventidsvisited'] = isset($_SESSION['eventidsvisited'])?$_SESSION['eventidsvisited']:array();
$eventids_exists = array_search($vbulletin->GPC['eventid'], $_SESSION['eventidsvisited']);

if ( $eventids_exists == 0) {
    $_SESSION['eventidsvisited'][] = $vbulletin->GPC['eventid'];
    $db->query_write("
             UPDATE " . TABLE_PREFIX . "event 
              SET hits=hits+1
              WHERE eventid=" . $vbulletin->GPC['eventid']);          
}

Save and upload.

STEP 3 - template modification
edit template "calendar_showeventsbit"

FIND:

Code:

    </td>

</tr>

</table>



</form>



</div>

$spacer_close

BEFORE THIS, ADD:

Code:

    </td>

</tr>

<tr>

    <td>

    <!-- // Event Views Counter - by Robert_2004 -->

    <!-- // https://vborg.vbsupport.ru/showthread.php?t=1067471 -->

    <strong>Viewed</strong>: $eventinfo[hits] times

so it should look like:

Code:

    </td>

</tr>

<tr>

    <td>

    <strong>Viewed</strong>: $eventinfo[hits] times    

    </td>

</tr>

</table>



</form>



</div>

$spacer_close

and that *should* be everything - i can't think of anything else that was needed.

if you use - please click INSTALL

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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:

X vBulletin 3.8.12 by vBS Debug Information

Page Generation 0.01241 seconds
Memory Usage 1,734KB
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
(5)bbcode_code_printable
(2)bbcode_php_printable
(1)footer
(1)gobutton
(1)header
(1)headinclude
(6)option
(1)post_thanks_navbar_search
(1)printthread
(6)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:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01241 seconds Memory Usage 1,734KB 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 (5)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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: