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?

PM sent.

All works fine now, thanks to Andrew's prompt help :)

And now something more general:

If users want to download a file using some download manager, they can copy the link but then the Save File name the manager gives is local_links.php, yet the file is actually the chosen file. Is there a way to go around this and give the real file name?

Also: currently people with dl managers can't resume the downloads, is there anything that can be done about this?


And another issue:

It would be nice if there was a way to mass-change permissions of links in a single category... I did a test run and now have to manually change some 20 links :)))

@AndrewD : This is a great hack. I just have a quick question, for example I have some media file (.wma, .wmv) and I mask the link with this hack. When my user want to dload the media file, they have to do right click --> save target as... otherwise if they click on the link, it will auto pop up the window media.
So my question is how can I change to direct dload when I just left click mouse to the link?

Thanks inadvance.

Thanks for your remarks. I struggled with a similar problem with Adobe Acrobat. If you edit the file local_links_include.php, you'll find the following lines:

Try commenting out the first 'define' and uncomment the second so that it looks like this:

This should do what you want - I've tried it with mp3 files using IE and Firefox - but some combinations of browsers and plug ins may cause other problems.

I tried this using the LeechGet download manager www.leechget.net. It correctly catches and creates the filename. I imagine some download managers insist on using the linkname as filename (which of course points to the script) rather than the information which the script correctly provides.

If you really want to make this work with all download managers, then I think you will have to set force_redirect to 2 on the links admin page. However, this will create two new problems which may or may not be important to you - the location of all your links will become completely visible and the hit counter will not work.

In the next version, I'll make it possible for certain usergroups to mass change the permissions of entries within a category.

Hi AnDrewD!

Thanks for the reply, I did try your suggestion but it didn't work. Usually when you click on link mp3 the Windown Media will not start automatically but with files are .wmv, .wma it does.

Maybe you can take a look and help me out to solve this problem ?? I am sure many other users who use and love this hack also want the samething as I do.

Thank u.

Ps: mayb this will help you some: http://www.hotscripts.com/Detailed/34430.html

I think you can solve the problem by going to your normal VB admin page, Attachments, Extensions and Sizes, and adding a new attachment type. Specify the extension as wma and the Mime Type as "Content-type: application/force-download" (no quotes)

Awsome, it works. All bow down to u. A big thank from my community.

** Post deleted - beta 1.55 now available

I have it installed and translated to Turkish perfectly.Working very good.
The only problem is the local file root. In no condition I got this working but having no problem in anything else. Perfect Job Andrew.

AndrewD, I have a stupid question. I tried to read the instructions and I tried to review the code but am still not sure.

Let's pretend I have a message board with five forums and each forum has a different moderator. Can I give each forum its own "category" and set it so that forum's moderator must manage all incoming links/files in that category? In other words, each moderator would care about his/her area and not be bothered with the rest.

Not a stupid question. Currently, there is no distinction between moderators of different categories - either you can moderate (i.e. everything) or you can't (i.e. nothing). It would not be very difficult to change this in the way you suggest (i.e so that moderation was also linked to the category forum) - how big a deal is this to anyone?

Excellent. Although I'll probably wait for the official release. :) I won't lose anything after upgrading, right?

If you email me a) your full VB phrase translations and b) the translations you made for this hack, I'll make sure that you don't lose anything.

Works perfectly, thanks.

Installed it last night and it works great. :) Thanks for the nice hack and easy to follow instructions.

I know it does not explicitly say but I want to confirm if this Mod works with MySql v3.23??

if anyone has it running on MySql3.2x..do let me know.

thanks

I meant the uploaded links. :) Don't worry about the translations, I'll redo them manually, not much work as I did only a few pages. :)

The hack installer checks that you have MySQL version 3.23.23 or higher. It will not work with anything earlier. It will work fine with 3.23.23, etc, although it handles searches differently with version 3 than with version 4 (Boolean mode, if that means anything to you).

Good luck

Then you will be able to upgrade without problems. There is a minor bug on the admin pages of the available 1.52 , which will be fixed with the next upload this weekend.

Oh wow! I love this hack! THANK YOU SO MUCH!

I had a table full of categorized link items already and wanted to migrate it into Links 1.51 so that it could become the foundation of my collection. It was a duplicated system up to this point where people would use a forum for URL discussion and I was manually updating a table with phpmyadmin. Anyway, this solution fixes all that.

So I wrote my own php script to import the stuff and I figured I'd share it here in case anyone else has to do something similar.

1. First, use the Links interface to create enough categories to match the ones you were using before;
2. Then, run a script sort of like the one I've included before to get the toc and linkslinks tables populated with stuff. I used a counter for the key indices and ignored whatever indices I had. I made my items query from newest to oldest (using whatever key IDs I had), as I didn't want to populate Links with older links at the top of pages. I used my own user account for the userid, and a datestamp from a manual link entry to generate the integer for the time.
3. Although I did notice Links recount how many items were in each category and update the Category records while testing and clicking around, I did it manually anyway by querying (through phpmyadmin) with WHERE catid='n' (cat number) or whatever to get a count for how many items had imported into each category.
4. Edit category records and insert the actual count of items imported for each.

All of this is a sloppy way of doing it and it shows that I'm a little new to all this. I couldn't get phpmyadmin to generate a CSV file while escaping the commas in my news article quotes, and it was tricking imports into thinking a grammatical comma was defining a new field, and it just wouldn't work.

I then had trouble with apostrophes from words like can't, so I had to use the addslashes() function on the titles and descriptions I was importing.

But it worked, and very well. I was able to populate Links with about 400 links, all into the right categories. Here's the ugly amateurish php script with some extra echo commands I used for testing. You can omit those:
Hope this is useful to somebody.

Attached are FROM (the original news/links database) and TO (Links 1.51) screen caps.

I noted earlier that mass move of links to a different category or mass change of permissions would be very welcome, is there any hope of seeing this in the future? :)

Mass change of permissions is already coded for release in v1.55; I missed the request for mass move, but will give that some thought.

I have a simple question

How can I remove the image on the section place.

For example on a HD links database I run: http://www.juicyduff.com/forum/local...=links&catid=2

The avatar at the top messes things up and I don't want it to be there, how would I make it NOT display there?

"Avatars [img(removethis)]http://www.juicyduff.com/dloadz/avatars/wellysm/2.gif[/img(removethis)]" - Also, that displays on the title at the top near forum navigation ... I want that removed too.

BTW - AWESOME HACK!

Thanks.

Put your image tag into the category description (if you want it to appear in the category listings) or into the extended description (if you want it to show up only in the category itself). Don't put it into the category name.

Hi Andrew,

Perhaps I was too vague and should make myself more clear:

Sorry, but the 2 solutions failed to solve the problem:

Bascically, I want the avatar to remain where it is on the front page but its image NOT be displayed how it is in the link above but to remain where it is.

Here is the main page: http://www.juicyduff.com/forum/local_links.php

You can see that the "wallpapers" images is moved, basically I only want the thumbnails to be on the left handside (category) and no where else.

Thanks, your help is appreciated...

Then you will have to edit a couple of the templates, links_main and links_catbit. links_main is the one that gives you the category title near the top of the page and links_catbit gives you the listing of categories within a page. There are three bits of information that you play with: the category name, its description and its extended description.

As you observe, if you put an image tag (or any other tag) into the category name, then the tag also shows up in the navigation bar as text. (I'll see if I can check for that condition and remove it, but I need to be careful that I don't kill anything else in the process.)

What you could do (easier if you are the only person creating categories on your board) is use the description or its extended description purely to hold the bbcode image tage, and modify the template accordingly.

For example. you could use the description to hold only the image tag and put the accompanying text into the extended description. So, you might edit these lines in the links_main template:

replacing $viewcatname by $viewcatdesc $viewcatname

You would also have to make a similar change in the links_catbit template, where the three variables are $catname, $catdesc amd $cattext.

Good luck

Unfortunately that didn't work :(