Thanks.

I'll have a look at the links showing up more than once - I think that is down to SQL's ORDER BY RAND() which dowsn't guarantee uniqueness - so needs an extra filter.

I hijacked the portal settings for other purposes - categories_seen_on_portal has no effect in the main hack. (The portal code was written by Natch, and an updated version of it, get_hotlinks.php - is in the natch subdirectory).

You can use the "SELECT DISTINCT" instead of just "SELECT"... should do the trick :D

Indeed, thanks. Had just to check that this worked ok on a complex join and that there weren't other cases where we wanted duplication. It does and there weren't ;).

Version 1.51 is now the supported release. See first post in thread.

Upgrade went without a hitch .. :)

.. and I can't find anything to say!

[high]* Slave goes off to have a think ..[/high]

Ok .. had a think .. feature requests .. :)

Allow users to comment on links
Show -> New Comments
Allow users to subscribe to categories (if new link added they get an email)
Show -> Subscribed Categories
Allow users to subscribe to links (if link gets updated they get an email)
Show -> Subscribed Links
Show -> What's updated
Instead of "rated 5 star" .. have a pic of 5 stars (use the same gfx that vb does?)
Pick link rating from a dropdown menu instead of links 1/2/3/4/5
In Category column if a category has a new link or sub-cat this is highlighted next to the category name

I think that should keep you going .. but only if you want to :)

Ha, Ha.... I do try to live a life, you know. Actually some of these have already been suggested, thought about, done...

>Allow users to comment on links
>Show -> New Comments
>Allow users to subscribe to categories (if new link added they get an email)
>Show -> Subscribed Categories
>Allow users to subscribe to links (if link gets updated they get an email)
>Show -> Subscribed Links

These have been long-standing suggestions. I've given them some thought but would require quite a lot of effort to implement properly.

>Show -> What's updated

OK, will think about this

>Instead of "rated 5 star" .. have a pic of 5 stars (use the same gfx that vb does?)

Someone's already shown how to do this. It's a simple edit of the linkrate template.

>Pick link rating from a dropdown menu instead of links 1/2/3/4/5

You could probably achieve this also with the linkrate template

>In Category column if a category has a new link or sub-cat this is highlighted next to the category name

This already happens - categories with new entries appear in bold.

heh .. well I did say I could't find anything to say :) .. I did read through the thread when I first saw the hack and subconsciously must of know some of these had been mentioned before ..

Ok .. nps .. always good to know someone else wants them though :p

Cool .. thanks :)

Really? I don't remember that .. I'll have another look through the thread ..

[high]* Slave slaps his head ..
[/high]
Of course it does .. completely forgot :)

Installed fine, but when I tried to add a cathegory, filled the "add cathegory" form, pressed "confirm" and... nothing? Tried several times, no result. What could it be?

vb 3.0.3 with the security patch.

I need more information - this doesn't happen to me with a completely new installation. Maybe you can PM me with you board details and an account with admin privs?