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>

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

where does the code for function.txt go?

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?

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

find in topsites_admin.php
and replace with

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

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"

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

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.

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

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