Toplist

[derekivey]

Toplist
Developer: derekivey (https://vborg.vbsupport.ru/member.php?u=81169)
Version: 2.0.0
vBulletin Version: 3.5.5 (Seems to work fine on 3.6.0)
File Edits: 0
Template Edits: 2 (Optional)
New Phrases: 294
Uses Plugins: Yes!
Difficulty: Easy

Description: This hack adds a Toplist to your forums. You can choose in the AdminCP whether to rank the sites by their In hits or their Out hits. It is fully phrased to make it easy to translate to another language if you need to. The users are able to add a site, edit, or delete their site if they added it. The Administrators can Edit the users' sites or Delete them.
This hack is for vBulletin 3.5.5.

*** I Strongly Recommend That You Backup Your Database Before Installing/Upgrading This Hack! ***

Planned features for a later release:

Add Image Storage Setting (hot linking or upload)
Add Stats Page [ Will be released later ]
Add API to get site info onto non-vB pages and other vB pages.
Add Site Comment System
Fix bug with & not being allowed in URLs [ Done ]
Add Setting to choose where to put Toplist Sites Marquee
Whatever else is suggestedChange Log
The change log is now available here (http://www.derek.spacialhosting.com/?page=product&id=1#changelog).

Screen Shots
I have added screen shots of this hack in action below.
More screenshots are located here (http://www.derek.spacialhosting.com/?page=product&id=1#screenshots).

Demo
You can find demo information here (http://www.derek.spacialhosting.com/?page=product&id=1#demo).

Translations
You can find a French translation of this hack here (https://vborg.vbsupport.ru/showpost.php?p=1175049&postcount=1448).

For a How To on Editing the Dynamic Image, See this Post (https://vborg.vbsupport.ru/showpost.php?p=885450&postcount=450).

Please click Install you installed this hack.


Thanks!

[Chroder]

Excellent work Derek :)

[derekivey]

Thanks! Also, Thanks for all your help :)

[jugo]

GREAT!!! Finally!!! This is what i've beenw aiting for...thanks.

Question...does this hack generate code to include in the listed site to count the hits?

[concepts]

when does it generate whether someone has clicked into the site? I clicked on both sites, looked around then came back to the toplists and the hit #'s were still the same?

[derekivey]

GREAT!!! Finally!!! This is what i've beenw aiting for...thanks.

Question...does this hack generate code to include in the listed site to count the hits?
Yes, when they add a site it shows them the html code to add to their site.

when does it generate whether someone has clicked into the site? I clicked on both sites, looked around then came back to the toplists and the hit #'s were still the same?

It only counts the out clicks if they user is logged in. I did this to prevent cheating. I might add the option to allow out clicks from guests in the next version. The in hits should have counted, it saves the IP address of the person who clicked in on the site and stops counting if their ip is already in the database for that site.

[jesus likes pie]

Hi derek! It's ATI! *waves*

What is this meant to....do.....is it for like...affiliates or something? I don't really understand.

EDIT: Is this the hack you didn't tell anyone on IRC about?

[concepts]

hmmm, well the in-clicks didn't count on either site I viewed.. don't get me wrong, I love this hack! and I already clicked install and downloaded it, but before putting this up, I want to make sure it actually works.. the in-clicks should count towards user clicks right?

for example: the traffic surfer links does not refresh at all it was 1 in 1 out before I clicked, 1 in 1 out after I clicked (4 times to make sure)

however this http://www.modbb.com/toplist.html although a phpbb, which I expect was the muse for this mod, auto updates on refresh (although its unfair because a user can click multiple times...

please clarify any errors?

Edit*
and what exactly is an in/out hit (Stupid Question, I know)
In hit - someone clicks the site link from the outside.
Out - when they leave the site?

[derekivey]

The one on my other site (ModBB) is someone elses mod.

The out hits don't count for guests. But for the in hits did you go to a link like this?

http://www.trafficsurfer.net/in.php?id=4 (thats for the ModBB site).

I just did it while being a guest and it counted it for me.

[derekivey]

Hi derek! It's ATI! *waves*

What is this meant to....do.....is it for like...affiliates or something? I don't really understand.
It lets the users add their site to it and people can look at it and if they are interested in a site they can click the link and be redirected to that site. The site gets ranked on hits into the forum or hits out to the user's site.


EDIT: Is this the hack you didn't tell anyone on IRC about?

No...

[concepts]

okay, installed at www.supaleague.com/board/toplist.php this works perfectly!

sorry for the confusion!

[derekivey]

No problem, glad you like it :)

[Peace_Hope]

That hack still needs a little work in my opinoin, like for instance, maybe have it so that the link that shows up for the user to put on their site should have a link saying:

Click Here to vote for our site over at xxxx.

with xxxx being the site with the toplist.

Just my ideas.

[jugo]

That hack still needs a little work in my opinoin, like for instance, maybe have it so that the link that shows up for the user to put on their site should have a link saying:

Click Here to vote for our site over at xxxx.

with xxxx being the site with the toplist.

Just my ideas.


That's easy just have to make a change to one file:

in add_site.php, change this to whatever you want the code to be:

$html = "{$vbphrase['toplist_add_successful']}<br />
{$vbphrase['toplist_html_code_message']}:<br />
<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'>{$_POST['name']}</a></textarea>";


i am going to add something to mine that will allow me to specify the image to use. and maybe with a little GD code, it will display the current ranking on the image....

hmmmm....this is going to be fun.

[derekivey]

That's easy just have to make a change to one file:

in add_site.php, change this to whatever you want the code to be:

$html = "{$vbphrase['toplist_add_successful']}<br />
{$vbphrase['toplist_html_code_message']}:<br />
<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'>{$_POST['name']}</a></textarea>";


i am going to add something to mine that will allow me to specify the image to use. and maybe with a little GD code, it will display the current ranking on the image....

hmmmm....this is going to be fun.

If you get something like that working, please share it :). I want to add something like that, where they can select a image that shows their current ranking.

Thanks :)

[rblaze]

Haha nice hack guys

Amazing what can be done when y'all aren't playing CS:S XD

Cya in #vbfans

~Blaze

[JubeiSaotome]

A perfect addition to my forum. Thanks.

[Snake]

What a great toplist hack. Thanks bro! :)

[jesus likes pie]

Haha nice hack guys

Amazing what can be done when y'all aren't playing CS:S XD

Cya in #vbfans

~Blaze

ha...derek doesn't play CS:S :P

Chroder does though. So do I, but my hacks are newbish and most of the time useless. Oh well :)

See ya around blaze.

-ATI4EVER

[The Realist]

How can you change the code so that members have the opertunity to list more than one site. And whats needed so that admin can manually add a site via admincp.

Laters

[Suzie]

How can you change the code so that members have the opertunity to list more than one site. And whats needed so that admin can manually add a site via admincp.

Laters

I need this as well.

[yahoooh]

i am using vBulletin 3.0.9 , i wait the port thanx

[ThePimp]

Is there a way to require a recip? Possibly a bit of code that reads the "Added" page and scans for a recip link on the page, and denies the site addition if one doesn't exist?

Most TopLists work off of the principal of getting more IN links, and if there isn't a check for recips, it will get cumbersome to try to keep up with all of the links and checking to be sure they don't remove your link.

Just a suggestion.

[azmi]

*installed* the hack - thanks for sharing!

but how about the incoming link?
it is only linked to the forum and not to the toplist !
is there any way to change it?

if you show for something how to make the Link with a button:
http://www.aardvarkind.com/

[derekivey]

Hey,

I'll try and release a new version in a few days to have most of those changes. Keep posting your ideas/suggestions, it helps me out a lot. Also ThePimp, I am looking into adding that feature as well.

[derekivey]

ThePimp, I'm not quite sure how to do that part, sorry.

[Allan]

no work with BBcode for description, damage :(

Suggestions, after add a site, a button is missing to return to toplist ;)

[derekivey]

Ok Thank You for telling me about the button missing. Also, why would you need BBCode for the description of the site?

[Allan]

Ok Thank You for telling me about the button missing. Also, why would you need BBCode for the description of the site?

To put in fat or italic for example, for a description, it is always useful ;)

ps: Attach Files, the french language :)

[derekivey]

Ok, I'll look into it and see if I can add it. Also, thanks for translating it :). I will add it and give you credit for it.

[Mr Chad]

In.php isnt redirecting

[derekivey]

Should be. I've tested it on my test site and my live site...

[Mr Chad]

mine is just stopping, like it will credit for the redirect but it will stay at a blank page saying in the title redirexcting while the load is done.

[derekivey]

Can you give me your url, so I can take a look?

Thanks,
Derek

[ctsolutions]

@derekivey

I think your zip file is corrupt cose in "toplist.php" I have no "Add Site/Delete Site" link.

if($filename == 'toplist.php'){
$userinfo['activity'] = 'Viewing Toplist';
} elseif($filename == 'add_site.php') {
$userinfo['activity'] = 'Adding Site to Toplist';
} elseif($filename == 'delete_site.php') {
$userinfo['activity'] = 'Deleting Site from Toplist';
} elseif($filename == 'out.php') {
$userinfo['activity'] = 'Viewing Site';
}





Mike

[derekivey]

Nope, it's not corrupt. I just downloaded it. Everything is there. Maybe try downloading it again and reuploading the files in the upload folder.

[Ramsesx]

Thank you for this nice modification derekivey, but also I wish to can add sites from the acp or user more than only one site.

[derekivey]

Yeah, I'm going to add those features in the next release.

[ctsolutions]

Nope, it's not corrupt. I just downloaded it. Everything is there. Maybe try downloading it again and reuploading the files in the upload folder.


Sorry, I have not see at the very bottom of the page the Add Site Link

I change the "toplist" template to be able to add sites on the top of the page:

find:


href="http://www.trafficsurfer.net">Derek Ivey</a></div></td>
</tr>



afther that add:

<a href="$vboptions[bburl]/add_site.php">$vbphrase[toplist_add_site]</a> |
<a href="$vboptions[bburl]/delete_site.php">$vbphrase[toplist_delete_site]




Thanks
Mike

[derekivey]

Sorry, I have not see at the very bottom of the page the Add Site Link

I change the "toplist" template to be able to add sites on the top of the page:

find:


href="http://www.trafficsurfer.net">Derek Ivey</a></div></td>
</tr>



afther that add:

<a href="$vboptions[bburl]/add_site.php">$vbphrase[toplist_add_site]</a> |
<a href="$vboptions[bburl]/delete_site.php">$vbphrase[toplist_delete_site]




Thanks
Mike

Ok, great. Glad you got it fixed.

[Swindont]

how can i make it so when users are on topsites on user online it says that and not unknown location?

[Mr Chad]

how can i make it so when users are on topsites on user online it says that and not unknown location?

I got it to work, very nice.

[derekivey]

how can i make it so when users are on topsites on user online it says that and not unknown location?

Huh? It should say that already... See screenshot below.

[Allan]

Suggestion: it would be well to be able to edit its site (description, url, buttons url) ;)

[derekivey]

Suggestion: it would be well to be able to edit its site (description, url, buttons url) ;)

You mean allow the user to edit their site? I plan to add that feature in the next release.

[Daniel]

This is great, thanks!

But where can I edit the "add site" page? I see it says $html - where can I find that?

[derekivey]

You would have to open add_site.php and edit the $html variable in it. The code is there.

[Daniel]

Thanks. Where would I go in add_site.php to edit this though. It's once the site has been submitted, and gives the code to put on their site.
ie:
<a href='http://www.mysite.com/forum/in.php?id=2' target='_BLANK'>MySite.com</a>

[Allan]

You mean allow the user to edit their site ?

yes :)

[derekivey]

Thanks. Where would I go in add_site.php to edit this though. It's once the site has been submitted, and gives the code to put on their site.
ie:
<a href='http://www.mysite.com/forum/in.php?id=2' target='_BLANK'>MySite.com</a>

Find:
$html = "{$vbphrase['toplist_add_successful']}<br />
{$vbphrase['toplist_html_code_message']}:<br />
<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'>{$_POST['name']}</a></textarea>";


And just change:

<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'>{$_POST['name']}</a></textarea>


To what ever you want.

Hope this helps.

Derek

[JonnyQuest]

adding categories for sites would be great as well.
nice work.

[derekivey]

Thanks for the suggestion, I will take a look into adding those.

[Floris]

Nice hack Derek! :)

[derekivey]

Thanks Floris :). What all did you want me to add to the Toplist Rules box? I forgot most of it lol.

[derekivey]

Hack Updated to Version 1.0.1. Please see first post for more info. Be sure to follow the Upgrade Instructions really close so that you don't lose the sites in your Toplist when you upgrade. If you have any problems with the hack please post here.

Derek

[Allan]

I am going to take charge of the french translation ;)

[derekivey]

Great Allan Thanks :)

[divided_by_fear]

question on a new install when i goto the add_site page you get a error on internet explorer in the task bar....

Line: 1502
Char:4
Error:Object dosen't support this property or method
Code:0
then it has your sites url /add_site.php

any way to fix that?

[Allan]

French Language for new version:)

[divided_by_fear]

lol does the french version give you that error too?

[Allan]

No error for me, work perfectly with IE and FF

[divided_by_fear]

yeah must be something in his code cause on the add_site page i get that error

[derekivey]

question on a new install when i goto the add_site page you get a error on internet explorer in the task bar....

Line: 1502
Char:4
Error:Object dosen't support this property or method
Code:0
then it has your sites url /add_site.php

any way to fix that?

I'll take a look at that and see whats causing that error. I myself haven't gotten that error, so I'll take a look.

Also, Thanks Alan for ReTranslating this :).

Derek

[derekivey]

Ok, I think I have narrowed it down to the Toplist Rules being the cause of it. I am going to look at it and see what is wrong.

[azmi]

great Hack , derekivey (*updated*)

in ACP -> options -> change site -> Description
can you make the field having a break in the text?
try it for example:
top topsite....the best site....top topsite....the best site....top topsite....the best site....top topsite....the best site....you will have a very large site :ermm:
in the field , i manually edit a "<br>" after 30 signs.

and:
when you give only a "www.yoursite.com" as URL, you will have a wrong site.
is there any way to let the script look for a "http://" before the "www" ?

[derekivey]

great Hack , derekivey (*updated*)

in ACP -> options -> change site -> Description
can you make the field having a break in the text?
try it for example:
you will have a very large site :ermm:
in the field , i manually edit a "<br>" after 30 signs.

and:
when you give only a "www.yoursite.com" as URL, you will have a wrong site.
is there any way to let the script look for a "http://" before the "www" ?

Yeah,

I'll add the http:// part, but I don't understand what you mean about the first part lol.

Derek

[azmi]

Yeah,
I'll add the http:// part, but I don't understand what you mean about the first part lol.
Derek

this problem

[divided_by_fear]

derekivey did you ever figure out what was giving that error in the task bar?

[derekivey]

The Javascript error? No I didn't I'm still looking into it :(

[divided_by_fear]

yeah i may install it again and see if i can look at it... im just trying to get use to vbulletin... but am pretty good with nuke :)

[derekivey]

yeah i may install it again and see if i can look at it... im just trying to get use to vbulletin... but am pretty good with nuke :)

Ok, Great.

[uzman59]

i have a question about in.php can i change somewhere for ex. when i added site, this hack give a link but only a link i want to link and little toplist pic.

[derekivey]

Please see this post. https://vborg.vbsupport.ru/showpost.php?p=802882&postcount=50

[uzman59]

Please see this post. https://vborg.vbsupport.ru/showpost.php?p=802882&postcount=50
i think you didnt understand me becasu i want it for ex
a user add his site to my toplist add.site.php give him to a link but only a link i want add site.php give a image link

[derekivey]

i think you didnt understand me becasu i want it for ex
a user add his site to my toplist add.site.php give him to a link but only a link i want add site.php give a image link

Yeah, just find that and replace it with the image link code I guess. Or do you mean a dynamic image that shows the rank and stuff?

[derekivey]

For it to give a image link just do this...

Find:

$html = "{$vbphrase['toplist_add_successful']}<br />

{$vbphrase['toplist_html_code_message']}:<br />

<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'>{$_POST['name']}</a></textarea>";



Change:



<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'>{$_POST['name']}</a></textarea>



To:



<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'><img src='IMAGEURL' border='0'></a></textarea>



Of course change IMAGEURL to the URL of an image you want them to add to their site.

[uzman59]

<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'>{$_POST['name']}</a></textarea>

where will i add image kod?

[derekivey]

No, your supposed to find that and replace it with this:


<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'><img src='IMAGEURL' border='0'></a></textarea>


And replace IMAGEURL with the url of the imge you want them to use.

[uzman59]

No, your supposed to find that and replace it with this:


<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'><img src='IMAGEURL' border='0'></a></textarea>


And replace IMAGEURL with the url of the imge you want them to use.
thanks derek

[derekivey]

No Problem :).

Also, in case anyone is interested, there is a German translation of my hack here (http://www.vbhacks-germany.com/forum/showthread.php?t=2132).
Special thanks to Hellraider from vbhacks-germany for translating it :).

[Hellraider]

Hope that helps our german users to use this fine hack in their native language :)

Thanks for your permission to translate and thanks for linking to vBHacks-Germany (http://www.vbhacks-germany.com).

[derekivey]

No Problem :)

[uzman59]

No Problem :)
sorry but i have a question :)
i did everthink it had done but my users add their sites to toplist.they put my toplist code you know.it is okey but their users click my toplist code a site opens and says:redirecting..... but it dont redirect

[derekivey]

Can you give me a URL to your site? Also, did you set the redirect URL in the AdminCP under Toplist Options?

[derekivey]

Version 1.0.2 has been released. Please see the first post to see what has been changed.

Derek

[Daniel]

I get the error:
Warning: getimagesize(fgf): failed to open stream: No such file or directory in /add_site.php on line 64

How would I go about fixing that?

[derekivey]

What did you type in the image field?

[uzman59]

Can you give me a URL to your site? Also, did you set the redirect URL in the AdminCP under Toplist Options?
thank you very much derek :squareeyed:

[derekivey]

thank you very much derek :squareeyed:

Did you get it working uzman59?

[uzman59]

Did you get it working uzman59?

it is working well now thanks again

[funinthesun]

OK, this is going to sound like a really dumb question but when it says to upload all of the files in the upload folder, where do you upload them to? Do you put the ones in the admincp folder for example into the admincp folder on your server etc? :confused:

[derekivey]

Yes, the admincp files go into the admincp folder, same with the includes folder etc.

[funinthesun]

Installed! Thank you! It's just what I was looking for! Thank you! :)

[Ramsesx]

nice now, thank you derekivey .
But one bug is there, if I change an entry and save, it is shows everytime in the html code box for putting on the web site the "id=1" .
And one more question, is it possible to disable html in the site description field?
Thank you

[derekivey]

Yes, I will add an option to disable the HTML in the description, and name. I'll take a look into the bug you found.

[derekivey]

Hi,

I'm unable to find that bug. Can you please show me what you mean? Perhaps take a screenshot or something?

Thanks,
Derek

[King Kovifor]

Nice Hack

[davidw]

<font color="SeaGreen">* christianb subscribes to this thread</font>

[Allan]

French Language for v1.0.2 :)

A suggestion for the next version, if you add to phrases, made a mark in your file xml to know of or the new phrases begins, it helps for the translations ;)

[derekivey]

What do you mean make a mark? I'm kind of confused lol.

Thanks,
Derek

[Allan]

news version = news phrase

exemple:

<phrase name="toplist_url_of_image"><![CDATA[URL de l'image (Optionel)]]></phrase>
<phrase name="toplist_username"><![CDATA[Nom Utilisateur]]></phrase>
<phrase name="toplist_width_and_height_too_big"><![CDATA[D?soler, l'image ne peut ?tre ajouter ! La largeur et la hauteur d?passe la limite autoris?. Essayer de nouveau.]]></phrase>
<phrase name="toplist_width_too_big"><![CDATA[D?soler, l'image ne peut ?tre ajouter ! La largeur d?passe la limite autoris?. Essayer de nouveau.]]></phrase>
<phrase name="toplist_yes"><![CDATA[Oui]]></phrase>
// addon phrase for Toplist version 1.0.8
<phrase name="toplist_exemple><![CDATA[exemple]]></phrase>
etc .....
............
</phrasetype>

[derekivey]

Ok, Good Idea Allan, I'll try and do that on newer releases.

Thanks,
Derek

[Sean James]

Find:
$html = "{$vbphrase['toplist_add_successful']}<br />
{$vbphrase['toplist_html_code_message']}:<br />
<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'>{$_POST['name']}</a></textarea>";


And just change:

<textarea cols='40' rows='4'><a href='{$vbulletin->options['bburl']}/in.php?id={$sr['id']}' target='_BLANK'>{$_POST['name']}</a></textarea>


To what ever you want.

Hope this helps.

Derek



these modications r made in the add_site.php?
Because i cannot find anything that resembles this

[Sean James]

its all good, the modifications need to be made in the Toplist_HTML_Code template.

Very nice script *clicks install*

[derekivey]

Yeah sorry about that. I moved the hard coded html into templates.

Derek

[divided_by_fear]

derekivey now does this only show a link back to the site now? or will it display there button so they can link the button? and if it does display a button how and where do i put my button link?

[derekivey]

It only shows a link, but you can edit the HTML to have it show a button instead. Just edit the Toplist_HTML_Code template and replace:


<a href="$vboptions[bburl]/in.php?id=$sr[id]" target="_BLANK">$_POST[sitename]</a>


With:


<a href="$vboptions[bburl]/in.php?id=$sr[id]" target="_BLANK"><img src="path_to_image" border="0"></a>

Of course, don't forget to replace path_to_image with the url of the image.

Derek

[Xtrato]

Hey when i install the whole thing and later i wana use a different template do i need to reinstall this or no? I know how to add the links so thats not my worry

Thanks..

[derekivey]

vBulletin adds the templates I believe, so it should be added to the new template.

[divided_by_fear]

derekivey i did that it worked wonderful... one more thing how could i add a table like you have when it shows the code but one above it and have that just show the image they are going to use? so basiclly have it like you do now with with another table above the link with the button inside no code showing there only the code showing on the table below...

[Xtrato]

Derek if i wanted to add like a text box(to explain how the toplist works) above the top the header(the header says blahblahblah Toplist) how could I do that and what codes :S :squareeyed:

[puertoblack2003]

Great Hack *********INSTALLED**********

[CAL]

AM I doing something wrong here?

I want non members to be able to add sites too. ie just guests.

Can this be done?

[derekivey]

Derek if i wanted to add like a text box(to explain how the toplist works) above the top the header(the header says blahblahblah Toplist) how could I do that and what codes :S :squareeyed:

You mean you want to put it right beside your forums name Topist?

AM I doing something wrong here?

I want non members to be able to add sites too. ie just guests.

Can this be done?

No, that is currently not a feature. I might add it in an upcoming release.

[divided_by_fear]

how code i show the image above the code... basiclly have another table above it showing what they are linking(ex. the button in a table above just showing the image) to make it clearer have 2 tables one with image and the one on the bottom like it is now with the code?

[Xtrato]

You mean you want to put it right beside your forums name Topist?



No i basically want a text box above the "forumname Toplist" line.

make sense??

Also can you make a feature to approve or decline toplists

And also you know when someone registers a toplist and gets there link for the toplist. How can i change that to give a link that shows a image like a image 88x31 that says Vote toplist. Or even show me where the code is so i can change it

THANKS SO MUCH!

[loonytune15]

Great Hack, better than the affiliates system i was going to use.

Hope to see the options flagged for a later release installed soon.

[derekivey]

how code i show the image above the code... basiclly have another table above it showing what they are linking(ex. the button in a table above just showing the image) to make it clearer have 2 tables one with image and the one on the bottom like it is now with the code?
Just edit the Toplist_HTML_Code template, and change:

<textarea cols="40" rows="4"><a href="$vboptions[bburl]/in.php?id=$sr[id]" target="_BLANK">$_POST[sitename]</a></textarea>

To:

<img src="URL_To_Image" border="0" /><br />
<textarea cols="40" rows="4"><a href="$vboptions[bburl]/in.php?id=$sr[id]" target="_BLANK">$_POST[sitename]</a></textarea>

That should work, don't forget to change URL_To_Image to the url of your image.


No i basically want a text box above the "forumname Toplist" line.

make sense??

You could edit the Toplist template and after:

$navbar

Add:

<textarea cols="40" rows="5">Text</textarea>


Also can you make a feature to approve or decline toplists

Yes, I will add that to my to do list for this.

And also you know when someone registers a toplist and gets there link for the toplist. How can i change that to give a link that shows a image like a image 88x31 that says Vote toplist. Or even show me where the code is so i can change it

You can edit the Toplist_HTML_Code template to change it.

[divided_by_fear]

thanks alot.... yeah that feature to approve or decline would be nice...

[derekivey]

Ok, I'll try to release another version soon with that included.

[Sean James]

Yeah sorry about that. I moved the hard coded html into templates.

Derek

np dude ;)

I have just updated and now get a white page when i add a new link.

http://www.bluepearl-design.com/forums/add_site.php

How would i go about fixing this?
I have already tried re-installing but this hasnt helped.

[derekivey]

Hi,

I registered at your forums (derekivey) and I was able to add a site. Are you still having problems?

Derek

[divided_by_fear]

derekivey what was included in the update yesterday if you dont mind?

[Xtrato]

You can edit the Toplist_HTML_Code template to change it.

Where do i edit that?

[divided_by_fear]

in ur admin cp then go to Styles & Templates and edit template... then that template

[derekivey]

derekivey what was included in the update yesterday if you dont mind?


I didn't update anything yesterday, I just updated my post to add stuff to the to do list.

By the way, version 1.0.3 should be released either tonight or tomorrow.

[Brandon Sheley]

Very nice will install, and added my site to your toplist :D
thx for this hack, hopefully it'll help me get more traffic to :D

* Brandon Sheley clicks install

how can i moderate new links added ? ilooked in vboptions and toplist and didn't see it, maybe I'm overlooking it

[derekivey]

Hi,

That feature is in version 1.0.3. I will be releasing that version later tonight.

[Brandon Sheley]

ah, right on,, will it be hard to upgrade ?

[divided_by_fear]

will we lose sites when updating?

[derekivey]

Version 1.0.3 Released.

You will not lose your sites as long as you select yes for overwrite when importing the product.
DO NOT UNINSTALL IT FIRST! ALL YOU HAVE TO DO IS REIMPORT IT AND SELECT OVERWRITE.

[divided_by_fear]

sweet so its like a 2 second job then lol... one other thing since i added a image to the code will that change at all?

[derekivey]

sweet so its like a 2 second job then lol... one other thing since i added a image to the code will that change at all?

Nope, there are no changes to that template. So it should still be intact. Also don't forget to upload the new files.

[divided_by_fear]

ok np ty very much... and thanks for supporting your mod since most around vbulletin seem to be just making them and giving no support

[derekivey]

Lol, No Problem :).

[divided_by_fear]

damn man its nice you could basiclly use this as affilates too since the affilates for 3.5.1 dont work well... great job bro........wow i like the random site too

[divided_by_fear]

hey quick question do you use vbadvanced? i think this would be nice on a random module on main page?

[derekivey]

hey quick question do you use vbadvanced? i think this would be nice on a random module on main page?

No I haven't used it. I will install it later on my test board and try making a module for it. I'll let you know if I have any luck.

Derek

[divided_by_fear]

yeah man damn with you christmas is coming early lol ... thanks for all your hard work and support...

[opelgtman]

When I add a site, it leads me to a blank page when I hit submit. The site will be in the database and show if I go back to the toplist but it never shows the html code.

http://messageboard.gulfcoastbands.com/toplist.php

[derekivey]

When I add a site, it leads me to a blank page when I hit submit. The site will be in the database and show if I go back to the toplist but it never shows the html code.

http://messageboard.gulfcoastbands.com/toplist.php

Hi,

I just tried it and didn't run into that problem. Try clearing your cache maybe.

Derek

[derekivey]

divided_by_fear, please try the attached module I made and let me know if it works ok for you.

I tried it on my test board and it appears to be working. Once you let me know it works, I'll release it in the appropriate forum here.

Just import the .module file, it should install the template and stuff. Let me know if you have problems.

Thanks,
Derek

[divided_by_fear]

yeah just like that but it makes it huge maybe put the info to the site on top and the hits below if you can take a look it makes the blocks wider

http://img468.imageshack.us/img468/6379/module8hd.th.jpg (http://img468.imageshack.us/my.php?image=module8hd.jpg)

[derekivey]

Actually, I had set it up to be in the center. Do you have space to put it in the center?

[divided_by_fear]

np man thank you very much... thanks for doing it

[divided_by_fear]

also one other thing is there anyway to cache that block?
Uncached templates: Toplist_1 (8)

[derekivey]

So it's working now?

Yeah, I'm looking into the caching problem. I'll post back when I have a fix.

[derekivey]

Ok, its fixed now. Please import this module file instead...

[divided_by_fear]

ok np ill try it right now ty

[divided_by_fear]

its almost the same thing let me look at the template and see

[derekivey]

I think you have to edit the module settings in the AdminCP and select Center Column instead of right.

[divided_by_fear]

can u post me what ur using in the template cause the block is working great its just the template part

[derekivey]

I made the template called toplist_random_site_module and it has this in it:

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr align="center">
<td class="tcat" colspan="5">{$vbphrase['toplist_random_site']}</td>
</tr>
<tr align="center">
<td class="thead" width="20">$vbphrase[toplist_rank]</td>
<td class="thead">$vbphrase[toplist_site_name_and_description]</td>
<td class="thead" width="88">$vbphrase[toplist_button]</td>
<td class="thead" width="50">$vbphrase[toplist_in]</td>
<td class="thead" width="50">$vbphrase[toplist_out]</td>
</tr>
<if condition="$num_rows >= 1">
<tr align="center">
<td class="alt2">$rand_rank</td>
<td class="alt1"><a href="$vboptions[bburl]/out.php?id=$randsite[id]" target="_BLANK">$randsite[name]</a><br />$randsite[description]<br /></td>
<td class="alt2" width="88">$image</td>
<td class="alt1" width="50">$randsite[in]</td>
<td class="alt2" width="50">$randsite[out]</td>
</tr>
<else />
<tr align="center">
<td class="alt1" colspan="5">$vbphrase[toplist_none]</td>
</tr>
</if>

<tr align="center">
<td class="thead" colspan="5"><div class="smallfont">
&nbsp;
</div>
</td>
</tr>
</table>

[divided_by_fear]

ok yeah cause i had to use my moms to import it lol i opened another module up before in wordpad now i cant figure out how to change it back so i can import from this pc lol

[divided_by_fear]

still the same thing goes big not as wide though

[derekivey]

Hmm, the one I uploaded should work, but for some reason you have it set to be in the right column. Try editing it in the AdminCP and change the Column setting to Center Column.

Hmm, want to make my username an admin real quick so I can take a look? (username is derekivey).

[divided_by_fear]

hmm im wondeing if you could do it like the random arcade kinda might give you a better thing to go by also you proably could take out the in and out hits and the rank

[derekivey]

Looks like you got it now...

[divided_by_fear]

ok made it the center works great how could i add it so its just like a vbulletin block how you can make it smaller like they use the java or something

[derekivey]

Yeah, I forgot about that, let me look and see how you do that.

[divided_by_fear]

ok np lol im lookin too lol i like it though it looks nice lol can almost turn that into a banner exchange lol sell space there lol

[divided_by_fear]

i have to upload the module again... unless i can get it to change back to what ever it is before i right clicked on it and opened it with notepad... anyword on how to change it back from notepad?

[derekivey]

Ok, try this one lol. Remember to change the column to Center.

[divided_by_fear]

ok ill have to import it in the morning ill let you know though... thank you very much for all your work... cause i cant get it to change back to a module lol when i take it out of zip its a text file and i cant get it back to a module lol so ill have to use the other pc in the morning

[derekivey]

It should still import fine. The extension is probably hidden.

[divided_by_fear]

ok i set it up looks good just has like a double bar on it on the top take a look not cached too

[divided_by_fear]

see where it says Random Site how can i remove that part? then it would be perfect

edit oppps aybe not the up and down dont work on it

[derekivey]

Hi,

Sorry about that lol. Import this module file. I forgot to edit the file to change the name of the template. Then, you can delete the toplist_random_site_module template because I have renamed it to adv_portal_toplist_random_site.

Everything should work now when you import this file instead.

Derek

[divided_by_fear]

how do i delete that template? also works perfect though

[derekivey]

Clicking revert does it. Glad its working now :)

[divided_by_fear]

one last thing would you mind twlling me how i could rename it to supporters? unless u dont want me too... this way people know what it is more... is there a phrase u have to edit if you do mind?

[divided_by_fear]

lol now im being a pain lol in the future ones too maybe on the mod its self use that script that made it open and close on the topliste random and the one that has them listed like if you go to my site you know the code you just added to that one to make it colaspe add it on the 2 blocks on toplist.php

[divided_by_fear]

i removed the button off the main page just incase there site goes down.. this way it wont lag my site on dial up users opening it

[derekivey]

Yeah, I plan to add a uploading feature to the Toplist so it doesn't link to their sites. I just don't know how vBulletin does it yet lol.

To remove the button, just edit the adv_portal_toplist_random_site template and delete

<td class="alt2" width="88">$image</td>

[divided_by_fear]

yeah that would be nice i just shut there buttons off on main page... this way it dont show the buttons... did you see what i was talking about on the main page for this about the collapse maybe add that to the toplist page for the random and the part where the sites are listed?

[VAN]

A question and a suggestion...

1: Does this include pagination of any kind, or will the list just keep growing and growing?

2: It would be nice to see you include categories. Admin would create link categories (member sites, funny sites, adult sites, etc., and the submitter would choose which category to place their link. This would also make it easier on people viewing the links since they could simply avoid categories that did not interest them. Should be a simple addition. I'll add it myself tonight, but it would be nice to have it in the official release. ;)

3: Bonus suggestion! It would look a heck of a lot cleaner if you left-justified the links and descriptions. Center-aligned columnar text is difficult to read.

Nice work!

[derekivey]

Yes, has pagination. Also, I'll take a look into adding that category feature and making the links and descriptions be aligned on the left side.

Derek

[derekivey]

yeah that would be nice i just shut there buttons off on main page... this way it dont show the buttons... did you see what i was talking about on the main page for this about the collapse maybe add that to the toplist page for the random and the part where the sites are listed?

Yeah, I will probably add that also to the main Toplist.

[divided_by_fear]

that would be sweet... hey if you get free wanted to see if you could help me on something... hit me up on my site with a pm or on here with a pm

[FleaBag]

Hey nice hack! Installing now. Out of interest why the number of different .php files? I would have thought they could all be in the same one? I'm not being picky, I just have enough files in the root as it is! ;) Thanks! :)

[funinthesun]

How can I change the title in the navbar to 'Links' instead of 'Toplist' as this makes it easier for my members :)

[derekivey]

Don't know lol. I might try combining some of the files in the next version, like the in and out.php files. Also probably the add_site, delete_site and edit_site files. Look for this in the next version :)

[Brandon Sheley]

updated with no problems,, thank you :)

[divided_by_fear]

derekivey you should put a link in this description with the addon module for vbadvanced... this way more people can grab it...

[derekivey]

It's shown in the first post in the box called addons. Do you mean the description in the readme file?

[michaelbenson]

Is it possible for the outbound site URLs to actually link to their destinated target and not some insite .php redirection page?

[derekivey]

I don't think so, because it wouldn't be able to count the in or out hit...

[divided_by_fear]

It's shown in the first post in the box called addons. Do you mean the description in the readme file?

no i didnt see it on here on the description of this mod... i figured it would allow more people to find it easier

[Brandon Sheley]

most admins know where the addons are located ;)

Add-Ons
Toplist Random Site vBadvanced Module
i seen it :p

[derekivey]

I'm not going to bother adding it to the readme lol. I'm too lazy to reupload it :p

[Allan]

Current translation ...... ;)

[TheProphet]

Great thanks m8, thumbs up, this is just what i needed...

[trackpads]

I am getting this error when I import the product and cannot figure out why:

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'toplist_enabled',
'toplist_options',
'1',
'1',
'free',
'yesno',
10,
0,
1,
'toplist'
),
(
'disabled_message',
'toplist_options',
'The Toplist is Currently Disabled. Please Come Back Later.',
'The Toplist is Currently Disabled. Please Come Back Later.',
'free',
'textarea',
20,
0,
1,
'toplist'
),
(
'rank_by_in',
'toplist_options',
'1',
'1',
'free',
'yesno',
30,
0,
1,
'toplist'
),
(
'toplist_count_out_from_guests',
'toplist_options',
'0',
'0',
'free',
'yesno',
40,
0,
1,
'toplist'
),
(
'toplist_limit_out_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
50,
0,
1,
'toplist'
),
(
'toplist_out_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
60,
0,
1,
'toplist'
),
(
'toplist_limit_in_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
70,
0,
1,
'toplist'
),
(
'toplist_in_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
80,
0,
1,
'toplist'
),
(
'toplist_allowed_user_groups',
'toplist_options',
'2,5,6,7',
'2,5,6,7',
'free',
'',
90,
0,
1,
'toplist'
),
(
'toplist_allow_member_edit',
'toplist_options',
'1',
'1',
'free',
'yesno',
100,
0,
1,
'toplist'
),
(
'toplist_allowed_to_moderate',
'toplist_options',
'5,6,7',
'5,6,7',
'free',
'',
110,
0,
1,
'toplist'
),
(
'',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_disable_html',
'toplist_options',
'1',
'1',
'free',
'yesno',
130,
0,
1,
'toplist'
),
(
'toplist_moderate_sites',
'toplist_options',
'0',
'0',
'free',
'yesno',
140,
0,
1,
'toplist'
),
(
'toplist_email_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
150,
0,
1,
'toplist'
),
(
'toplist_email_users',
'toplist_options',
'1',
'1',
'free',
'',
160,
0,
1,
'toplist'
),
(
'toplist_pm_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
170,
0,
1,
'toplist'
),
(
'toplist_pm_from_user',
'toplist_options',
'1',
'1',
'free',
'',
180,
0,
1,
'toplist'
),
(
'toplist_pm_users',
'toplist_options',
'1',
'1',
'free',
'',
190,
0,
1,
'toplist'
),
(
'sites_per_page',
'toplist_options',
'15',
'15',
'free',
'',
200,
0,
1,
'toplist'
),
(
'toplist_in_redirect_url',
'toplist_options',
'',
'',
'free',
'',
210,
0,
1,
'toplist'
),
(
'toplist_number_of_sites',
'toplist_options',
'1',
'1',
'free',
'',
220,
0,
1,
'toplist'
),
(
'toplist_max_height',
'toplist_options',
'31',
'31',
'free',
'',
230,
0,
1,
'toplist'
),
(
'toplist_max_width',
'toplist_options',
'88',
'88',
'free',
'',
240,
0,
1,
'toplist'
);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Date : Thursday, November 24th 2005 @ 10:07:17 AM
Script : http://www.trackpads.com/forum/.../plugin.php
Referrer : http://www.trackpads.com/forum/.../plugin.php?do=productadd
IP Address : 68.47.97.220
Username : Hannibal
Classname : vb_database

thanks!

[derekivey]

Do you already have this hack installed? That error means those settings exist already.

[trackpads]

Do you already have this hack installed? That error means those settings exist already.

I thought the same thing even though I didnt. I had the affiliate hack installed but removed it aswell as installed this one and then removed it too just to see if I could clear it.

I looked in phpmyadmin for any of those variables in the settings table but found nothing. Any idea what else I should check?

Thanks again for the help,

-Jason

[trackpads]

Just checked the table and this is the first one that didnt get put in and there is no duplicate:

(
'toplist_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),

Any ideas?

[trackpads]

Just checked the table and this is the first one that didnt get put in and there is no duplicate:

(
'toplist_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),

Any ideas?

Found it!

Wierd though, one of the varnames in my settings table was blank? That was what was breaking the import of this product.

All works now.

thanks!!

[derekivey]

Try executing this query in phpmyadmin or the query page in the vB AdminCP, and see if it returns anything.

SELECT * FROM setting WHERE varname='toplist_enabled'

Derek

EDIT: Ok lol, glad you got it to work :)

[trackpads]

Try executing this query in phpmyadmin or the query page in the vB AdminCP, and see if it returns anything.

SELECT * FROM setting WHERE varname='toplist_enabled'

Derek

EDIT: Ok lol, glad you got it to work :)

Thank you for the help, this is a really, really nice hack. Kudos!!!

[derekivey]

Thanks :) Glad you like it!

Derek

[Benj]

this might have been suggested but how about instead of just showing html code for linking to the toplist (vb) site you show other code as well for images that the vb site admin has uploaded. so for example the admin can upload 6 or 7 promotional images. then when a user has finished adding there site they have the option to copy a simply text link as well as in link with the admins promotional images


hope u understand me


cheers :D

[derekivey]

That can easily be added by tweaking the Toplist_HTML_Code template and changing it to be like you want. I think I am just going to keep it the same for now. But if you want to change it on yours feel free to.

Derek

[loonytune15]

Is there a way to have a box on the forumhome thats shows random toplists sites?

[derekivey]

Yeah, I'll try and make an addon tonight. Where would you like to see it at on the forum home?

[Xtrato]

bottom in a hor. scrolling bar.

[derekivey]

Like under the Whats Going on? Box?

[Xtrato]

yea like under the birthdays ect.

It would scroll the images (linked) across the page in a box. I think that would be a nice addon.

[derekivey]

Wait, so you just want a part that scrolls the images in the Toplist?

[Xtrato]

yea and maybe if no image, the name of the site and its linked to that site thru the out.php thing.

[derekivey]

Ok, I'll try and make that.

[Xtrato]

Ok great!

Also Bump this amazing hack to the first page :D

[derekivey]

I'll try and get to it tomorrow, I have been really busy with school this week :(.

[bitblaster]

I have installed this.

If I may make a suggestion....

Could you have another update for game servers, to check the status, and possibly only show online servers?

Thanks for the mod!

[derekivey]

Hi,

I'm not sure how to do this, sorry :(

[derekivey]

Version 1.0.4 is now out.

Please see the first post for what's new.

Follow the readme file closely to avoid losing the sites in your Toplist...

Derek

[divided_by_fear]

the rating system dont see to work for me gives me a error...

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT * FROM toplist_ratings WHERE site_id='2' && username='MindWalker';

MySQL Error : Table '*************.toplist_ratings' doesn't exist
Error Number : 1146
Date : Sunday, December 4th 2005 @ 09:40:03 PM
Script : /toplist.php?do=rate&id=2
Referrer :
IP Address :
Username :
Classname : vb_database

[divided_by_fear]

its the way you have the sql set up with table_prefix it dont work on my sql i suppose cause it didnt alter the tables

[derekivey]

Hold on, I think I forgot to add the SQL code for that database to the install code, I'll update the zip file in a second.

[divided_by_fear]

ok np thank you very much

[derekivey]

Ok, redownload the zip file and try importing it again, don't forget to hit yes for overwrite.

[divided_by_fear]

kk one sec ill try

[derekivey]

You might get an error in that one, if so please redownload and import the new .xml file. I was missing a " in the install code.

[divided_by_fear]

nope did the same thing... i did overwrite and all...

[derekivey]

Try the file I just uploaded please.

[divided_by_fear]

nah its still giving the same error

[derekivey]

Hmm I'll take a look and get back to you in a few mins.

[divided_by_fear]

ok np this is the error it gives

Invalid SQL:
SELECT * FROM toplist_ratings WHERE site_id='2' && username='MindWalker';

MySQL Error : Table '*******_**********.toplist_ratings' doesn't exist

[derekivey]

Ok, try again please.

If it doesn't work, just execute this query in the AdminCP:

CREATE TABLE `".TABLE_PREFIX."toplist_ratings` (
`id` int(10) NOT NULL auto_increment,
`site_id` int(10) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`rating` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

[divided_by_fear]

it wont even let me do it through php admin

#1103 - Incorrect table name '".TABLE_PREFIX."toplist_ratings'

[divided_by_fear]

is there a way i can do it with out the table prefix

[derekivey]

Yeah remove ".TABLE_PREFIX." it wont work in phpmyadmin b/c TABLE_PREFIX is part of vB.

[divided_by_fear]

ok one sec let me try

[divided_by_fear]

ok it opens up the ratings box but once i subit it gives another error let me try to do the tables manually or if you code post the tables that would be great

[derekivey]

ALTER TABLE `toplist_sites` ADD `rating_total` INT( 10 ) DEFAULT '0' NOT NULL AFTER `out`;

ALTER TABLE `toplist_sites` ADD `votes` INT( 10 ) DEFAULT '0' NOT NULL AFTER `rating_total`;

ALTER TABLE `toplist_sites` ADD `rating_average` INT( 10 ) DEFAULT '0' NOT NULL AFTER `votes`;


There you go :)

[divided_by_fear]

working great thank you one thing i went to rate my site before this fix but its not showing now can i make that show?

[divided_by_fear]

nm lol i got it thank you so much... now how could i add the rating to the random site module lol...sorry for asking so much

[derekivey]

I'll update that module tomorrow, I have to go now. It's late here.

Derek

[loonytune15]

Was the add-on for the forum home added into this release?

[divided_by_fear]

no it wasnt...

[loonytune15]

I have updated and cant see any probs so far, though i am hoping the add-on for the forum home will be added in soon.

I'd like it to include an option on how many will scroll and so forth.

[divided_by_fear]

if you start getting into scrolling stuff that really slows sites down... i would def. uninstall if this goes scroilling....

[loonytune15]

No just an option to include it, naturally you can turn it off if you dont want it on. Or even if it included a box at the bottom that changes the affiliate every 10 seconds or so..

[Snake]

Hey I got a little feature-suggestion:

-Commenting system

[divided_by_fear]

No just an option to include it, naturally you can turn it off if you dont want it on. Or even if it included a box at the bottom that changes the affiliate every 10 seconds or so..


why wouldnt you just go with it like he has it on the vbadvanced module each time you refresh it shows a different site... cause when you have it changeing like that it will slow things down

[divided_by_fear]

Hey I got a little feature-suggestion:

-Commenting system


yeah that would really be nice to see... this way other users can basiclly see what they think and feel about the other site

[Stephen3]

request for category , porsible ??

[pauloo]

request for category , porsible ??

Good idea :nervous: ,I want too a category

Than you for this good hack !

[Snake]

Yeah site category (such as Gaming, Movies, etc) - that would be nice too!

[derekivey]

Category system is on my list of things to add. I also plan to add an option that allows you to add a random site to the forum home, note this will be optional and can be turned off in the AdminCP.

[divided_by_fear]

yeah it has came a long way since i first installed it doing nice work....