vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Links and Files Database (https://vborg.vbsupport.ru/showthread.php?t=60403)

LoOnEyToOnZ 04-26-2004 04:29 AM

Quote:

Originally Posted by AndrewD
Indeed I am...

Ah.... I hope you dont mind but is there a ETA for the new version ?

AndrewD 04-26-2004 07:35 AM

Quote:

Originally Posted by LoOnEyToOnZ
Ah.... I hope you dont mind but is there a ETA for the new version ?

Ah, but maybe I do mind ;)

I hope to have version 1.2 released, at least in beta form, within a couple (=2) weeks.

1.2 will have moderation and a standard interface to the portals. It will probably have an accompanying harvester to trawl through the forum posts for links.

And that, my friends, will be that for the time being...

Wolfy.2k 04-26-2004 05:57 PM

Quote:

Originally Posted by AndrewD
Not at all...

You go to the Links Home, (../local_links.php) then on the left hand drop down menu for this hack, there should be two items - Home and Create Subcategory.

After you have created your first category, then extra items will appear on that drop down menu to allow you to create links.

ty m8

Ian Emu-UK 04-26-2004 11:50 PM

Hi, thanks for taking the trouble to making this hack for vB3, it's great, a nice addition to my site :)

One thing that could improve it though is a addition to the "functions_online.php" that showed viewing links instead of "unknown location" and the url to the page.

Probably really easy for a coder such as yourself, but for an novice like me, it's far too advanced :)

AndrewD 04-27-2004 04:30 AM

Quote:

Originally Posted by Ian Emu-UK
Hi, thanks for taking the trouble to making this hack for vB3, it's great, a nice addition to my site :)

One thing that could improve it though is a addition to the "functions_online.php" that showed viewing links instead of "unknown location" and the url to the page.

Probably really easy for a coder such as yourself, but for an novice like me, it's far too advanced :)

Thanks for your remarks.

I'm probably a little tired, but I'm not sure what you're asking for? Are you wanting full information on the linked urls or to include the information on who is online?

Ian Emu-UK 04-27-2004 08:20 AM

Quote:

Originally Posted by AndrewD
Thanks for your remarks.

I'm probably a little tired, but I'm not sure what you're asking for? Are you wanting full information on the linked urls or to include the information on who is online?

Right not it says:

Quote:

Unknown Location
/forum/local_links.php?action=links
on who's online when someone is browing the main links page.

if it said

Quote:

Viewing link directory
(Link to directory main page or the exact catergory they are looking at)

AndrewD 04-27-2004 08:21 AM

Quote:

Originally Posted by Ian Emu-UK
Right not it says:



on who's online when someone is browing the main links page.

if it said

OK, I'll investigate. I'd removed the "who's online" information from our site's forums, so had not noticed that message.

Skyline_GT 04-27-2004 08:24 AM

I wonder can you make a list of changes for the next version?
also please try to add the status bar (I mean when you download files) to this hack:D

Thanks.

AndrewD 04-27-2004 08:25 AM

Quote:

Originally Posted by Skyline_GT
I wonder can you make a list of changes for the next version?
also please try to add the status bar (I mean when you download files) to this hack:D

Thanks.

I've explained what I'm planning to do. Please don't push too far or I may lose interest.

Ian Emu-UK 04-27-2004 09:03 AM

Quote:

Originally Posted by AndrewD
OK, I'll investigate. I'd removed the "who's online" information from our site's forums, so had not noticed that message.

Thanks :)

AndrewD 04-27-2004 06:36 PM

Quote:

Originally Posted by Ian Emu-UK
Thanks :)

THis is not a straightforward thing to fix without changing standard VB code, which is something I am trying hard to avoid.

However, you can try editing the phrase called unknown_location (go into the admincp, languages and phrases, search in phrases). If you change the text from "Unknown location" to "Viewing" then you get very close to what you want.

Ian Emu-UK 04-27-2004 09:01 PM

Well, thanks for looking anyway and I'll try what you suggested as it's certainly better then "Unknown location" ;)

OGT 04-27-2004 11:08 PM

Quote:

Originally Posted by Ian Emu-UK
Right not it says:



on who's online when someone is browing the main links page.

if it said

To get links to show up in who's online follow the directions in the second half of this post, replacing test with local_links.php

AndrewD 04-28-2004 04:24 AM

Quote:

Originally Posted by OGT
To get links to show up in who's online follow the directions in the second half of this post, replacing test with local_links.php

Thanks for pointing this out. :tired:

Natch 04-29-2004 03:39 AM

Also note that the Admin is the only one who sees "unknown location" - regular users see "Viewing Forum" or something similar ...

hopester 04-29-2004 09:48 AM

Quote:

Originally Posted by AndrewD
I've released (see first post) a new beta version fixing/dealing with several requests in this thread:

- snip
- progress information for downloads of local files

Did you ever get this feature working Andrew as I've never seen it work on mine or anyone elses site?

Thanks

AndrewD 04-29-2004 11:48 AM

Quote:

Originally Posted by hopester
Did you ever get this feature working Andrew as I've never seen it work on mine or anyone elses site?

Thanks

Yes, I'm not sure what's going on for you guys. This works fine for me.

Our downloads are all pdfs. Clicking on an entry in the links/files database on our site opens the standard Internet Explorer "save as" dialogue, then gives a progress bar as the file is downloaded, indicating size and estimated time remaining.

Exactly the same thing happens with Mozilla Firefox - Save As dialogue, then progress bar.

Any more information that might be helpful in tracking this down?

hopester 04-29-2004 12:02 PM

I just checked your site, the one thing that jumped out at me was the file sizes shown, in my version no file sizes are shown. I'll pm you a link.

Thanks for your help

AndrewD 04-29-2004 05:22 PM

Quote:

Originally Posted by hopester
I just checked your site, the one thing that jumped out at me was the file sizes shown, in my version no file sizes are shown. I'll pm you a link.

Thanks for your help

Tell me - have you set you your links as relative or absolute urls? I suspect you've entered full urls in the form http://www.site.com/directory/file. When you use that format, the code bypasses the file size check (because it assumes that it will have to read the entire file to find out how big it is - it's not smart enough to recognise that the file is on the local file system).

If you use a relative url, e.g /directory/file, then the code simply checks the file size and reports it to the user. THis also makes it possible to give the proper progress bar during the download.

hopester 04-29-2004 05:42 PM

It still fails both ways but using relative it also fails the link test as well. I'll pm you an admin login so you can see the link types.

Highlander 04-30-2004 04:58 AM

can i user also external link ?
or only own uploads?
so it would be able to post drivers with 20MB and more.. wich isnt posoble in mysql

and how about the file system?
is there no matter how i save attachments?
files ode rdatabase ?

greets

Sam FT 04-30-2004 05:16 AM

Well I am having this problem when I go to add links. First of all I install the LInks/Files database hack with no problem. Nothing was changed in the templates.

Anyway I create a Sub-category without any problems. So I at the window, Add/Edit Link, adding in the info Title, URL, etc. When I get to the Categories part it is already highlighted the category I already want and in. So when I click submit button I am taking back to that sub directory and the link that I just created isn't there. So I go the the Administrator Links or Link Administration and I see the # flagged links available and click on available link. Which gives me a list of all the links I have created plus the link I just created. So I click on the edit link next to that new link and sure enough is doesn't have a Category highlight even thou I had highlighted the first time.

So am I doing something wrong...why isn't it when I create a link the link doesn't assoisate itself with the category I pick when I do so to begin with.

AndrewD 04-30-2004 06:13 AM

Quote:

Originally Posted by hopester
It still fails both ways but using relative it also fails the link test as well. I'll pm you an admin login so you can see the link types.

I've logged in and fixed all your links. These now show the size and you (or at least I) get a progress bar when downloading.

Local downloadable files (i.e. those with recognised mimetypes) are specified starting at the web root, i.e. /file is expected to be in the top directory (not your forum directory), /dir/file should be in the "dir" subdirectory of your top directory. The current code is not happy to be given filenames which use ".." type directories - I may change that with the next release.

AndrewD 04-30-2004 06:16 AM

Quote:

Originally Posted by Sam FT
Well I am having this problem when I go to add links. First of all I install the LInks/Files database hack with no problem. Nothing was changed in the templates.

Anyway I create a Sub-category without any problems. So I at the window, Add/Edit Link, adding in the info Title, URL, etc. When I get to the Categories part it is already highlighted the category I already want and in. So when I click submit button I am taking back to that sub directory and the link that I just created isn't there. So I go the the Administrator Links or Link Administration and I see the # flagged links available and click on available link. Which gives me a list of all the links I have created plus the link I just created. So I click on the edit link next to that new link and sure enough is doesn't have a Category highlight even thou I had highlighted the first time.

So am I doing something wrong...why isn't it when I create a link the link doesn't assoisate itself with the category I pick when I do so to begin with.

Not sure what your problem is - I had a look at your site and I can see a number of links that seem to work ok.

AndrewD 04-30-2004 06:45 AM

Quote:

Originally Posted by Highlander
can i user also external link ?
or only own uploads?
so it would be able to post drivers with 20MB and more.. wich isnt posoble in mysql

and how about the file system?
is there no matter how i save attachments?
files ode rdatabase ?

greets

You can use this hack to provide links to files on any machine that is accessible via the internet. They do not need to be uploaded onto your own site. The normal approach would be to provide a link to a file held within the file system of the target host, so indeed you can provide entries to large drivers.

This hack does not provide any facility to upload the files - you have to do that another way. It also does not store the files in the database - it simply stores the information on the file.

The only comment on this is that the facility to report file sizes and track download progress is *not* available if you identify the file using a ful url, i.e. http://site/directory/file. This facility only works if the file is held on your own host and is identified using a local file name.

Sam FT 05-01-2004 02:41 AM

Quote:

Originally Posted by AndrewD
Not sure what your problem is - I had a look at your site and I can see a number of links that seem to work ok.

Well that is after I have reassicate the links to the proper sub directories. If I gave you access could you take a look at it?

Just email me......admin at full-throttle.us

Thanks

Seany 05-02-2004 03:50 PM

Sorry, but I don't have the time to look through the whole 26 pages for my answer. :P

My question is are the downloads directly linked to link on the downloads page, or can you have the links lead to a page where there is editable information about the download, like download info or special instructions of the kind?

Thanks!

AndrewD 05-02-2004 06:52 PM

Quote:

Originally Posted by Seany
Sorry, but I don't have the time to look through the whole 26 pages for my answer. :P

My question is are the downloads directly linked to link on the downloads page, or can you have the links lead to a page where there is editable information about the download, like download info or special instructions of the kind?

Thanks!

Well, maybe I don't have time either!

Each link has a name and associated information (each of which can contain standard vbulletin bbcodes), can be associated with one or many categories and can be protected by being associated with a forum. All of this can be edited.

You could have found that out without reading 26 pages.

Seany 05-02-2004 08:14 PM

Thanks... I installed it and got it working perfectly, and it does exactly what I want it to be able to do. Thanks!

/me clicks Install

baqai 05-02-2004 08:50 PM

love the hack, only problem is that is there any way to show it on the nav bar on top?

AndrewD 05-03-2004 05:48 AM

Quote:

Originally Posted by baqai
love the hack, only problem is that is there any way to show it on the nav bar on top?

Yes - you have to edit the navbar template to get the results you want. The attached example puts an entry just to the left of the FAQ button. Just experiment to get the effect you want.

baqai 05-03-2004 11:03 AM

thanks a lot working fine now :) :) :)

PranK 05-03-2004 11:50 AM

/me clicks install

nice work! thank you!

Christian

PranK 05-03-2004 11:53 AM

btw - extremely nice 'instructions.txt' - very well laid out with lots of info!!

Thanks again,

Christian

Acido 05-03-2004 03:31 PM

AndrewD, is there a way to display the rates of the links? I only can see the options to rate, but i'm confused about where the rates are displayed...

AndrewD 05-03-2004 05:04 PM

Quote:

Originally Posted by Acido
AndrewD, is there a way to display the rates of the links? I only can see the options to rate, but i'm confused about where the rates are displayed...

You spotted this about five minutes before I did. I managed to destroy the ratings display in version 1.10 by missing out a dollar sign.

If you want to fix this, edit local_links.php, line 169
PHP Code:

if (!links_rate_set

and put a dollar sign in front of links_rate_set.

Sorry about that.

The Geek 05-04-2004 01:12 PM

Superb add on.
Would be nice for the ratings to come up as stars, and if the user already rated for them not to be able to rate again.
O, would be nice for hyperlinks and email addresses to be parsed automatically. There is no easy way to add email addresses to an entry.

well done.

AndrewD 05-04-2004 01:15 PM

Quote:

Originally Posted by the nail geek
Superb add on.
Would be nice for the ratings to come up as stars, and if the user already rated for them not to be able to rate again.
O, would be nice for hyperlinks and email addresses to be parsed automatically. There is no easy way to add email addresses to an entry.

well done.

Thanks - it is not hard to change the template to display stars (I think someone already sorted that out - will try to track it down) - if someone tries to vote a second time, this is allowed, but it cancels their previous vote, i.e. their vote only gets counted once.

The Geek 05-04-2004 09:13 PM

Quote:

Originally Posted by AndrewD
Thanks - it is not hard to change the template to display stars (I think someone already sorted that out - will try to track it down) - if someone tries to vote a second time, this is allowed, but it cancels their previous vote, i.e. their vote only gets counted once.

As a workaround for that (only wanted people to vote once) I did the following:

Changed the query in get_linklistbit to this:
PHP Code:

    $query "
        SELECT link.linkid AS linkid, link.linkname AS linkname, link.linkuserid AS linkuserid,
            link.linkusername AS linkusername, link.linkurl AS linkurl, link.linkdesc AS linkdesc,
            link.linkhits AS linkhits, link.linkstatus AS linkstatus, link.linkdate AS linkdate, linkrate.linkvote
        FROM "
.THIS_TABLE."linkslink AS link
        LEFT JOIN "
.THIS_TABLE."linksltoc AS ltoc
        ON link.linkid = ltoc.linkid
        LEFT  OUTER  JOIN local_linksrate AS linkrate
        ON ( ( link.linkid = linkrate.linkid ) AND ( linkrate.linkuserid =" 
intval($bbuserinfo['userid']) ." ) )
            
$squery
        ORDER BY linkname
        "


Then under this:
PHP Code:

            $linknew iif($bbuserinfo['lastvisit'] < $myrow['linkdate'],1,0); 

I stuck this:
PHP Code:

            $linkvoted=intval($myrow["linkvote"]); 

Then in the list_linkbit template, I changed
PHP Code:

<if condition="$links_permissions[can_rate_link]"

To this:
PHP Code:

<if condition="$links_permissions[can_rate_link] AND $linkvoted==0"

May not be the best, but thought I would post it in case anyone else wanted it. As for the star, tmeplate thing... I didnt look in the 27 page thread here, but you are right... its about as easy as could be.

Just change the lins_ratebit template to this:
PHP Code:

<br />&nbsp;<br /><img src="images/rating/rating_$linkrate.gif"

Kick ass mod m8.

AndrewD 05-06-2004 05:37 PM

Quote:

Originally Posted by the nail geek
Superb add on.
Would be nice for the ratings to come up as stars, and if the user already rated for them not to be able to rate again.
O, would be nice for hyperlinks and email addresses to be parsed automatically. There is no easy way to add email addresses to an entry.

well done.

I think you added the second point after I blinked :) I missed it first time round.

You're right that a link has to be a file or an http link - it does not recognise ftps, mailtos etc. But you can add mailtos in the description, simply by using the email bbcode


All times are GMT. The time now is 09:12 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02366 seconds
  • Memory Usage 1,869KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (7)bbcode_php_printable
  • (26)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete