vBTopSite

vBTopSite - Used from 2.2.9 - 2.3.3, should work on all 2.x

Description: Topsites script for people who's sites revolve around vbulletin.

This script I actually wrote several months ago, and now I finally decided to release them on vb.org.
There are some things which I have not included in this version, but they will be released here as I am satisfied with them:
All functions appearing in 'Useful Admin Functions' in the ACP
Everything else works. ^_^ now anyway, features...


Topsites Features: [in no order, partial list]

• Works with all vb things, like it shuts off with your forums, and Banned people have no access.
• Secure Member Panel
• Seperate Member Base, user need not be joined to forums to join/view topsites
• Secure Retrieval System
• Stats rendered in real-time
• 'Today' Reset system
• Customizable stat display in the sitecell template. [instructions for that if you ask me]
• Tracks 12 stats, rankable by 9
• Not a 'clicking required' topsites, displaying buttons earns hits
• E-mail verification system
• Allow certain HTML in description
• Display filters for accounts which arent displaying the button
• Comprehensive who's online locations

Admin Features: [in no order, partial list]

• Topsites active y/n
• Hit accruing active y/n
• E-mail verification required (activation) y/n
• Urls to buttons, arrows (for placing buttons remotely even)
• Length of 'day' for reset purposes, 1 for daily, 0 to disable
• Allowed HTML in description (blank for full stripping)
• Option to resolve bad button urls -> replacing them with the rank button
• Display filter (explained in the acp, or ask me for more details)
• Set which stat to rank by
• Edit/delete sites
• SEARCH site database
• Editing page features links to view submitted button, auto-checks validity of urls
• Automatic emailing script: send to specific site/all sites/inactivated sites/activated sites
• Displays stats [but not allowing editing]
• View topsites from acp
• **Force 'day' reset of unreset sites
• **Force 'day' reset particular site
• **Force 'day' reset of ALL sites
• **Prune sites which joined from DATE, from all sites/inactivated/activated
• **Clean up IP table of old hits/hits from pruned sites
• **Flush hits from particular site
• **Flush hits from site older than DATE

** = Will be appearing on vb.org shortly.

It is advised anyone who uses this hack, to click install, because of the nice updating thing i can do,
and like i said, there will be updates in a little while.

LIVE VERSION: http://forums.ffgon.com/topsites.php
Feel free to join if you are a Final Fantasy site ^_^ [ignore the popups, they dont appear if you are logged into the forums]
MORE:
http://www.animationation.net/community/topsites.php
http://www.bluelaguna.net/forum/topsites.php
http://www.orbsydia.com/forum/topsites.php

anyway, i might post screenshots, but the admin stuff isnt much to see, i basically just explained it up there ^ :-p
If you have any questions, etc, post them

FYI: a more advanced script is in the works by me, which will be free from vbulletin and including many more features,
like a user rating/comment system. This will be 10$ or so, and more details are available if you pm me (dont discuss it here)

Thank you for using this hack! i know i dont usually post my stuff, well here you go ^_^

[AN-net]

i get this error when i put the $variable = topsites_stats(); after the code from function.txt

error:

Fatal error: Call to a member function on a non-object in /home/anima823/public_html/community/index.php on line 23

[Darkwaltz4]

oh, i think i know what the problem is

in the function, after

function topsites_stats() {

put:

global $DB_site;

should work then (i havent tested any of this)

[AN-net]

ok i no longer get an error but now on my forum home where i put the variable for site title of which ever is rank #1 i get this:

Array[site_title]

[Darkwaltz4]

$topsites_array[#][siteid]
$topsites_array[#][site_url]
$topsites_array[#][site_title]
$topsites_array[#][site_webmaster]
$topsites_array[#][site_description]
$topsites_array[#][today_in]
$topsites_array[#][today_out]
$topsites_array[#][today_unique]
$topsites_array[#][today_hits]
$topsites_array[#][total_in]
$topsites_array[#][total_out]
$topsites_array[#][total_hits]
$topsites_array[#][total_unique]
$topsites_array[#][average_unique]
$topsites_array[#][average_out]
$topsites_array[#][average_hits]
$topsites_array[#][average_in]

make sure your typing it right in your templates: from $variable = topsites_stats();
the the title of the first should be $variable[1][site_title]

[AN-net]

this is wut i put in my forumhome template:
$variable[1][site_title]

[Darkwaltz4]

why dont you just try doing this...remove the function, remove the line, and put this where you originally had the line:

PHP Code:

    $today = date("m-d-y");
    $maketime = explode("-", $today);
    $today = mktime( 0,0,0,$maketime[0],$maketime[1],$maketime[2]);

    $options = $DB_site->query_first("SELECT * FROM topsites_options");
    $resetlast = $today-(($options[daytime]-1)*86400);

    if($options[display]==3) {
        $allmembers = $DB_site->query("SELECT * FROM topsites_sites WHERE active>0 AND totalhits>0 ORDER BY $options[rankby] DESC LIMIT $options[perpage]");
    } elseif($options[display]==2) {
        $allmembers = $DB_site->query("SELECT * FROM topsites_sites WHERE active>0 AND lastreset>=$resetlast ORDER BY $options[rankby] DESC LIMIT $options[perpage]");
    } else {
        $allmembers = $DB_site->query("SELECT * FROM topsites_sites WHERE active>0 ORDER BY $options[rankby] DESC LIMIT $options[perpage]");
    }

    $fn = 1;
    while($site = $DB_site->fetch_array($allmembers)) {

    $daysjoined = ceil((($today - $site[joindate]) / 86400)+1);

    if(!eregi("^http://",$site[siteurl])) {
    $site[siteurl] = "http://".$site[siteurl];
    }

    $topsites_array[$fn][siteid]         = $site[siteid];
    $topsites_array[$fn][site_url]         = $site[siteurl];
    $topsites_array[$fn][site_title]     = $site[sitetitle];
    $topsites_array[$fn][site_webmaster]     = $site[webmaster];
    $topsites_array[$fn][site_description]     = $site[sitedescription];
    $topsites_array[$fn][today_in]         = $site[todayin];
    $topsites_array[$fn][today_out]         = $site[todayout];
    $topsites_array[$fn][today_unique]     = $site[todayunique];
    $topsites_array[$fn][today_hits]     = $site[todayhits];
    $topsites_array[$fn][total_in]         = $site[totalin];
    $topsites_array[$fn][total_out]         = $site[totalout];
    $topsites_array[$fn][total_hits]     = $site[totalhits];
    $topsites_array[$fn][total_unique]     = $site[totalunique];
    $topsites_array[$fn][average_unique]     = floor( $site[totalunique] / $daysjoined );
    $topsites_array[$fn][average_out]     = floor( $site[totalout] / $daysjoined );
    $topsites_array[$fn][average_hits]     = floor( $site[totalhits] / $daysjoined );
    $topsites_array[$fn][average_in]     = floor( $site[totalin] / $daysjoined );

    $fn++;
    } 


then you can use the array $topsites_array, the same way you previously were using $variable

[AN-net]

hmm, i keep getting ARRAY[site_title]

[Darkwaltz4]

hmm ill install this somewhere and see how it works. watch for me to edit this post with my findings

EDIT: i just tried both the function method and the straight method. both worked perfectly.....show me the code you have in your template (a larger portion of it)

[5GB]

Database error in vBulletin Control Panel 2.3.3:

Invalid SQL: UPDATE topsites_options SET display='2',active='1','require'='1',hitson='1',bu tton s='http://forums.sgwdc.com/images/sgwdc/topsite/',arrows='http://forum.sgwdc.com/images/sgwdc/topsite',perpage='10',totalbuttons='10',da ytime='1',htmlallowed='<b><u><i>',bheight='31',bwi dth='88', bborder='0',resolve='0',rankby='todayunique'
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''require'='1',hitson='1',button s='http://forums.sgwdc.com/ima

mysql error number: 1064

Date: Sunday 04th of January 2004 02:40:54 PM
Script: http://forums.sgwdc.com//admin/topsites_admin.php
Referer: http://forums.sgwdc.com/admin/topsit...ction=options&


After i edited.. =x please help

[Darkwaltz4]

sorry, i gave you the wrong quotes for the require section...

(maybe i should change the column for that...its caused too many issues :-p)

anyway, change (what you have) 'require'=
to `require`=
(the backwards apostraphe..not sure what its called) also, when your done, if you give me your link ill add it to the first post ^_^