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:

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:

    </td>
</tr>
</table>

</form>

</div>
$spacer_close

BEFORE THIS, ADD:

    </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:

    </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

[hugh_]

Can we see a screenshot or example?

Thanks...

hugh

[robert_2004]

screenshot added to orginal post.
It doesn't help much - as my event listing template is modified a great deal.

[finn snor]

Great have been looking for this for a long time..Can it be made conditional so only admin can see views ?

[robert_2004]

Yes, to only allow certain usergroups, use the following code:

usergroups 6 and 5 are admin and super moderators, respectively.

<if condition="is_member_of($bbuserinfo, 6, 5) OR $show['admincplink']">
<tr>
	<td>
	<strong>Viewed</strong>: $eventinfo[hits] times	
	</td>
</tr>
</if>

[snowname]

The database function works on 4.1.3.