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 ^_^

[Darkwaltz4]

This should satisfy you, and no I havent tested it :-p

put this in any file which has access to the forums' global.php

to call it, use this:

$variable = topsites_stats();

and this creates a variable with 17 bits of information, in the following format
$variable[rank][info]

so, to get the 1st site's title, its

$variable[1][site_title]

make sense? for details on what is made available, look at the function yourself.
ADDS TWO QUERIES to the place you call it.

also, it does as many sites as you have in your perpage option. so, if you have 5 sites per page, itll have up to 5 ranks. i have mine set to 10, so i would have 10 ranks available. to use this to create a link on the title, it would look something like this:

1) <a href='topsites_hit.php?action=out&siteid=$variable[1][siteid]' target='_blank'>$variable[1][site_title]</a>

[5GB]

Database error in vBulletin Control Panel 2.3.3:

Invalid SQL: UPDATE topsites_options SET display='2',active='0',require='1',hitson='0',butt ons='http://YOURSITE/topsites/buttons',arrows='http://YOURSITE/topsites',perpage='10',totalbuttons='10',daytime=' 1',htmlallowed='<b><u><i>',bhe ight='31',bwidth='88',bborder='0',resolve='0',rank by='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='0',buttons='http://YOURSITE/topsites/button

mysql error number: 1064

i have this problem.. any idea???

[AN-net]

where does the code for function.txt go?

[AN-net]

one of the sites on my top list keeps saying -=bad url=- in site url in acp and also how do i change who the email is sent by for registration and emails?

[Darkwaltz4]

5GB, you are probably using a newer version of mysql and need a better query :-p

find in topsites_admin.php

PHP Code:

if ($action=="dooptions") {
  $DB_site->query("UPDATE topsites_options SET display='$display',active='$active',require='$require',hitson='$hitson',buttons='$buttons',arrows='$arrows',perpage='$perpage',totalbuttons='$totalbuttons',daytime='$daytime',htmlallowed='$htmlallowed',bheight='$bheight',bwidth='$bwidth',bborder='$bborder',resolve='$resolve',rankby='$rankby'");
  echo "<p>Options Updated!</p>";
  $action = "options";
} 


and replace with

PHP Code:

if ($action=="dooptions") {
  $DB_site->query("UPDATE topsites_options SET display='$display',active='$active','require'='$require',hitson='$hitson',buttons='$buttons',arrows='$arrows',perpage='$perpage',totalbuttons='$totalbuttons',daytime='$daytime',htmlallowed='$htmlallowed',bheight='$bheight',bwidth='$bwidth',bborder='$bborder',resolve='$resolve',rankby='$rankby'");
  echo "<p>Options Updated!</p>";
  $action = "options";
} 


also, the function should go into any page you wish to use it on. so if you want it on yuor index, put it on index.php. on top of all the threads? showthread.php

you get the idea

[Darkwaltz4]

if its listing a bad url, then the person who set it set a url which does not exist.

and the email is the $technicalemail var set in config.php, if you want to change it to something else, look through topsites_member.php and topsites_admin.php for $technicalemail, and replace it with "whatever@somewhere.com"

[AN-net]

well the url the member is putting is correct. its http://www.gamersxtc.net

[Darkwaltz4]

well it checks the url using fopen()

it doesnt remove the url from the account, only replaces it with 'bad url' in the acp when you look at the account. sometimes if your site is slow, fopen will time out and just return false to the opening of the site.

[AN-net]

ok thanks darkwaltz4 but im getting confused with the virtual stats. do i put the code in functions.txt in global.php?

[Darkwaltz4]

:-p you put them wherever you plan to use them...

if you wanted to have use of the function on the index page, then place the function in index.php, and also in there, put this line $variable = topsites_stats();

then, in your templates, you can list the top 5 sites like this:

<b>Top 5 Sites!</b><br>
1) <b><a href='$variable[1][site_url]' target='_blank'>$variable[1][site_title]</a></b><br>
2) <b><a href='$variable[2][site_url]' target='_blank'>$variable[2][site_title]</a></b><br>
3) <b><a href='$variable[3][site_url]' target='_blank'>$variable[3][site_title]</a></b><br>
4) <b><a href='$variable[4][site_url]' target='_blank'>$variable[4][site_title]</a></b><br>
5) <b><a href='$variable[5][site_url]' target='_blank'>$variable[5][site_title]</a></b><br>