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)

kingady 08-18-2004 01:06 PM

ive fixedi t ;p thanks alot, great script

AndrewD 08-18-2004 04:38 PM

Quote:

Originally Posted by kingady
ive fixedi t ;p thanks alot, great script

Good, and good luck!

animehawk 08-19-2004 10:50 AM

Anderew, Great mod, It's exactly what i'm looking for to manage my downloads. I do have a small problem. I installed this mod late last night and seem to be running into an error.
http://www.animesanction.net/testsit...tion=jump&id=1 That is the link to the only link i have posted thus far and it just brings up a blank page. It is a local download and it does display the size of the file in the links table.
http://www.animesanction.net/testsit...ocal_links.php

The file type is setup in my admincp.

AndrewD 08-19-2004 10:54 AM

Quote:

Originally Posted by animehawk
Anderew, Great mod, It's exactly what i'm looking for to manage my downloads. I do have a small problem. I installed this mod late last night and seem to be running into an error.
http://www.animesanction.net/testsit...tion=jump&id=1 That is the link to the only link i have posted thus far and it just brings up a blank page. It is a local download and it does display the size of the file in the links table.
http://www.animesanction.net/testsit...ocal_links.php

The file type is setup in my admincp.

PM me an admin userid and pwd for your test board, as I can't tell anything without looking a bit deeper

animehawk 08-19-2004 11:45 AM

Thanks a bunch for your help. I have PM'd the requested info.

BioVader 08-20-2004 09:56 AM

AndrewD,
I've installed this program as a way to offer downloads on my site for registered users. Also as a way to keep people from linking my downloads to their site and chewing up my bandwidth....

The Categories work fine but I'm limited with only 5 downloads showing up per Category. I've tried changing the links_per_page to a higher number but it still only shows 5 links.... Now I have these set up with a forum permission which only allows registered users to view. Do you have any idea on how to fix this?

Here is a link to my Links Directory (File Downloads)

http://team-undercover.com/forums/local_links.php?

AndrewD 08-20-2004 10:05 AM

Quote:

Originally Posted by BioVader
AndrewD,
I've installed this program as a way to offer downloads on my site for registered users. Also as a way to keep people from linking my downloads to their site and chewing up my bandwidth....

The Categories work fine but I'm limited with only 5 downloads showing up per Category. I've tried changing the links_per_page to a higher number but it still only shows 5 links.... Now I have these set up with a forum permission which only allows registered users to view. Do you have any idea on how to fix this?

Here is a link to my Links Directory (File Downloads)

http://team-undercover.com/forums/local_links.php?

I see what you mean - but you've changed the templates? Have you removed the pagenav?

can you also try going into your main admincp/thread display options and change the number of posts per page and see what that does

BioVader 08-20-2004 09:03 PM

I change the settings in the admincp options but it's still the same...
This is what links_main looks like.....

PHP Code:

 <if condition="$viewcatname">
<
table class="tborder" cellpadding="$stylevar[cellpadding]cellspacing="$stylevar[cellspacing]border="0" width="100%" align="center">
<
tr align="center">
    <
td class="tcat" align="center"><strong>$viewcatname</strong>
    <if 
condition="$catclosed != 0"><span class="smallfont">[closed]</span></if>
    </
td>
</
tr><tr>
    <
td class="alt1" align="center"><span class="smallfont"><if condition="$show['member']"><b>You are ready to download</a></b>
        </if>
        <if 
condition="$show['registerbutton']"><b>You must first <a href="register.php?$session[sessionurl]">$vbphrase[register]</abefore you can download files. </b>
        </if></
span></td>
</
tr>
</
table>
<
br />
</if>
<if 
condition="$catlistbit">
<
table class="tborder" cellpadding="$stylevar[cellpadding]cellspacing="$stylevar[cellspacing]border="0" width="100%" align="center">
<
tr align="center">
    <
td class="tcat" align="center" width="20%"><strong>Category</strong></td>
    <
td class="tcat"><strong>&nbsp;Description</strong></td>
</
tr>
$catlistbit
</table>
<
br />
</if>            
<if 
condition="$linklistbit">
<
table cellpadding="0" cellspacing="0" border="0" width="100%" style="margin-bottom:3px">
<
tr valign="bottom">
<
td align="$stylevar[right]">
<if 
condition="$show['pagenav']">$pagenav</if>&nbsp;
<if 
condition="$searchnav">
<
span class="smallfont">sort by 
<a href="local_links.php?catid=$viewcatid&amp;page=$pagenumber&amp;sort=N">title</a>&nbsp;
<
a href="local_links.php?catid=$viewcatid&amp;page=$pagenumber&amp;sort=d">date</a>&nbsp;
<
a href="local_links.php?catid=$viewcatid&amp;page=$pagenumber&amp;sort=h">hits</a>
</
span>
</if>
</
td>
</
tr>
</
table>
<
table class="tborder" cellpadding="$stylevar[cellpadding]cellspacing="$stylevar[cellspacing]border="0" width="100%" align="center">
<
tr align="center">
    <
td class="tcat" align="center" width="20%"><strong>Files</strong></td>
    <
td class="tcat"><strong>&nbsp;Description</strong></td>
</
tr>
$linklistbit
</table>
<if 
condition="$show['pagenav']">
<
table cellpadding="0" cellspacing="0" border="0" width="100%" style="margin-top:3px">
<
tr valign="bottom">
    <
td align="$stylevar[right]">$pagenav</td>
</
tr>
</
table>
</if>
<
br />
</if> 

And the original I started with...
PHP Code:

<if condition="$viewcatname">
<
table class="tborder" cellpadding="$stylevar[cellpadding]cellspacing="$stylevar[cellspacing]border="0" width="100%" align="center">
<
tr align="center">
    <
td class="tcat" align="center"><strong>$viewcatname</strong>
    <if 
condition="$catclosed != 0"><span class="smallfont">[closed]</span></if>
    </
td>
</
tr><tr>
    <
td class="alt1"><span class="smallfont">$viewcattext</span></td>
</
tr>
</
table>
<
br />
</if>
<if 
condition="$catlistbit">
<
table class="tborder" cellpadding="$stylevar[cellpadding]cellspacing="$stylevar[cellspacing]border="0" width="100%" align="center">
<
tr align="center">
    <
td class="tcat" align="center" width="20%"><strong>Category</strong></td>
    <
td class="tcat"><strong>&nbsp;Description</strong></td>
</
tr>
$catlistbit
</table>
<
br />
</if>            
<if 
condition="$linklistbit">
<
table cellpadding="0" cellspacing="0" border="0" width="100%" style="margin-bottom:3px">
<
tr valign="bottom">
<
td align="$stylevar[right]">
<if 
condition="$show['pagenav']">$pagenav</if>&nbsp;
<if 
condition="$searchnav">
<
span class="smallfont">sort by 
<a href="local_links.php?catid=$viewcatid&amp;page=$pagenumber&amp;sort=N">title</a>&nbsp;
<
a href="local_links.php?catid=$viewcatid&amp;page=$pagenumber&amp;sort=d">date</a>&nbsp;
<
a href="local_links.php?catid=$viewcatid&amp;page=$pagenumber&amp;sort=h">hits</a>
</
span>
</if>
</
td>
</
tr>
</
table>
<
table class="tborder" cellpadding="$stylevar[cellpadding]cellspacing="$stylevar[cellspacing]border="0" width="100%" align="center">
<
tr align="center">
    <
td class="tcat" align="center" width="20%"><strong>Entry</strong></td>
    <
td class="tcat"><strong>&nbsp;Description</strong></td>
</
tr>
$linklistbit
</table>
<if 
condition="$show['pagenav']">
<
table cellpadding="0" cellspacing="0" border="0" width="100%" style="margin-top:3px">
<
tr valign="bottom">
    <
td align="$stylevar[right]">$pagenav</td>
</
tr>
</
table>
</if>
<
br />
</if> 


darkmage 08-21-2004 02:49 AM

I have an idea / rant....

It would be great if you could make a type of comment system for the links system. Such as,

when you submit a new link it makes a post in the forum if you want it to with the title of the file you submitted and in the post it will include the description. I think that would be a great idea! ^_^

I'm just dreaming though, that sounds a bit much to ask for. But if you made something like that to add on to this, I would be very happy. =)

AndrewD 08-21-2004 04:23 AM

Quote:

Originally Posted by darkmage
I have an idea / rant....

It would be great if you could make a type of comment system for the links system. Such as,

when you submit a new link it makes a post in the forum if you want it to with the title of the file you submitted and in the post it will include the description. I think that would be a great idea! ^_^

I'm just dreaming though, that sounds a bit much to ask for. But if you made something like that to add on to this, I would be very happy. =)

I think this is a great idea, it's just a matter of finding the time... Soon!

lmongello 08-22-2004 02:18 AM

Having problems and need to uninstall. Can you provide detailed instructions on how to do so and what I need to remove?

Thank you!! :)

AndrewD 08-22-2004 10:02 AM

Quote:

Originally Posted by lmongello
Having problems and need to uninstall. Can you provide detailed instructions on how to do so and what I need to remove?

Thank you!! :)

Rerun the installation script - it has an uninstall option

AndrewD 08-22-2004 10:08 AM

Beta version 1.30 uploaded. Please test and report.

Wildthinks 08-22-2004 06:49 PM

Hi,
is possible, that the preview is a flash (swf) or is hard to code?
Thank you
Thomas

AndrewD 08-24-2004 04:08 AM

Quote:

Originally Posted by Wildthinks
Hi,
is possible, that the preview is a flash (swf) or is hard to code?
Thank you
Thomas

I'd rather not get into handling Flash - it's not something I know anything about.

AndrewD 08-24-2004 04:09 AM

Quote:

Originally Posted by AndrewD
Beta version 1.30 uploaded. Please test and report.

Re-uploaded beta 1.30 - small bug corrected in the error handling code

SteveK 08-24-2004 05:45 AM

AndrewD-

Should line 2270 in local_links.php:

PHP Code:

ORDER BY sequence 

be changed to :

PHP Code:

ORDER BY adminid 

??

SteveK

AndrewD 08-24-2004 01:57 PM

Quote:

Originally Posted by SteveK
AndrewD-

Should line 2270 in local_links.php:

PHP Code:

ORDER BY sequence 

be changed to :

PHP Code:

ORDER BY adminid 

??

SteveK

No, it should be sequence - :ermm: if you are having problems, have you remembered to run the updated installation script to upgrade your database?

SteveK 08-24-2004 02:17 PM

Quote:

Originally Posted by AndrewD
No, it should be sequence - :ermm: if you are having problems, have you remembered to run the updated installation script to upgrade your database?

Thanks, you are right. I did run the upgrade.... just against the wrong database. And when I got the error, I searched for the term in the install file but somehow missed it.

So far, no other problems. Haven't tried the import feature.

Thanks for your work.

SteveK

neroflorida 08-29-2004 08:57 PM

I just installed this today. After entering about 100 links - many of which are cross-referenced, I discovered a bug with the multiple category assignments.

Entries under a category that are assigned to one or more other categories will appear a distance of at least one page apart from the orignal entry under the category.

For instance:
Link x is assigned to Categories A,B,C

For each category {A,B,C}, link x will appear once for each reference minus one in the tloc. (AxA, AxB; BxA, BxB; CxA, CxB) I assume that the minus one is the occurance of viewed category = catid.

Each occurance will appear a distance of 1 page apart. (I have not found instances where AxA, AxB appear on the same page under A, but will generally appear +1 pages apart.)

http://neroflorida.com/vb/local_link...links&catid=20 <-- a good example. There are 16 links under this category. The category is set to display 10 links per page. The actual number of pages is 3.2 (Should be 1.6 pages)

Thanks,

-Kris

zerinS4 09-06-2004 02:19 PM

Installed 1.30, so far so good.

Warlord 09-06-2004 08:49 PM

Nice Hack..

*clicks install*

How can I enable html in the descriptions?

vb code seems to work though..

AndrewD 09-07-2004 04:21 AM

Quote:

Originally Posted by Warlord
Nice Hack..

*clicks install*

How can I enable html in the descriptions?

vb code seems to work though..

HTML in descriptions and titles is deliberately disabled. vb code works properly. Is this a big issue? - it's not that hard to modify

AndrewD 09-13-2004 06:06 PM

Version 1.35 uploaded for beta test

new:
- what's hot/what's new added to search code and header template
- jump syntax extended to allow action=jump&link="catname/linkname" for direct lookup and jump
- fix to pagination bug with multiple category assignments
- option to display file type icon in linkbit
- included code to build forum list (in case user has opted to turn this off)
- added admin options to force a redirect rather than read/rewrite (lower bandwidth/cpu at cost of exposing link source and no control over headers)

Reports please

SandsUSA 09-13-2004 09:07 PM

Quote:

Originally Posted by AndrewD
Version 1.35 uploaded for beta test

new:
- what's hot/what's new added to search code and header template
- jump syntax extended to allow action=jump&link="catname/linkname" for direct lookup and jump
- fix to pagination bug with multiple category assignments
- option to display file type icon in linkbit
- included code to build forum list (in case user has opted to turn this off)
- added admin options to force a redirect rather than read/rewrite (lower bandwidth/cpu at cost of exposing link source and no control over headers)

Reports please

Wow, this is looking really good! Can't wait for the next "stable" release....

Code Monkey 09-18-2004 06:05 AM

Great addition to my site. Thanks a bunch. It would be nice if it showed as a proper destination in "who's online." Instead of "Unknown Location."

Anyway, keep up the good work.

AndrewD 09-18-2004 02:23 PM

Quote:

Originally Posted by JumpD
Great addition to my site. Thanks a bunch. It would be nice if it showed as a proper destination in "who's online." Instead of "Unknown Location."

Anyway, keep up the good work.

Thanks.

To achieve this, you have to modify includes/functions_online.

See https://vborg.vbsupport.ru/showpost....10&postcount=1 for instructions. I do mention this in the instructions :)

dethfire 09-18-2004 02:25 PM

1.35 works great on 3.0.3, no problems yet

Code Monkey 09-18-2004 04:58 PM

Quote:

Originally Posted by AndrewD
To achieve this, you have to modify includes/functions_online.

See https://vborg.vbsupport.ru/showpost....10&postcount=1 for instructions. I do mention this in the instructions :)

Thanks. I am new to VB and had been wondering how to do this. :D

sinclac 09-20-2004 04:11 AM

Quote:

Originally Posted by AndrewD
Version 1.35 uploaded for beta test

new:
- what's hot/what's new added to search code and header template
- jump syntax extended to allow action=jump&link="catname/linkname" for direct lookup and jump
- fix to pagination bug with multiple category assignments
- option to display file type icon in linkbit
- included code to build forum list (in case user has opted to turn this off)
- added admin options to force a redirect rather than read/rewrite (lower bandwidth/cpu at cost of exposing link source and no control over headers)

Reports please

When i try to upgrade it says it can't find the tables in the database but they are there.

AndrewD 09-20-2004 05:27 AM

Quote:

Originally Posted by sinclac
When i try to upgrade it says it can't find the tables in the database but they are there.

Did you change the table prefix? - the code by default assumes that the tables are called local_xxx. If you change this prefix, you need to edit both local_links.php and local_links_install.php accordingly. See instructions.

Let me know if this doesn't work for you.

???`S?LV?R???` 09-20-2004 11:04 AM

Why does it show the source of the download when I set it to a remote site? (it doesn't show when the file is stored on the local website though)? And is there any way to fix this?

sinclac 09-20-2004 12:24 PM

Quote:

Originally Posted by AndrewD
Did you change the table prefix? - the code by default assumes that the tables are called local_xxx. If you change this prefix, you need to edit both local_links.php and local_links_install.php accordingly. See instructions.

Let me know if this doesn't work for you.

No i have changed nothing, if i look in the DB the tables are as you said they should be.

AndrewD 09-20-2004 03:52 PM

Quote:

Originally Posted by sinclac
No i have changed nothing, if i look in the DB the tables are as you said they should be.

I need to have a look at your board - can you set me up an account with admin privs and PM them to me?

AndrewD 09-20-2004 04:07 PM

Quote:

Originally Posted by ???`S?LV?R???`
Why does it show the source of the download when I set it to a remote site? (it doesn't show when the file is stored on the local website though)? And is there any way to fix this?

I need a bit more information - what type of file/do you have a mimetype set up for that type on your board admincp/have you set the links admin to use force_redirect?

Basically, this hack provides two ways of accessing downloads.
Either
- the file has a recognised mimetype and (you are running version 1.30 or less) or (you are running version 1.35 and force_redirect=0 on your admin page)
or
- one of those conditions does not apply.

In the first case, the download is handled on the server by successively reading then rewriting chuncks of data to the user.
In the second case, the download is handled by telling the client browser to redirect to the file.

The first hides the source, the second does not (and cannot).

???`S?LV?R???` 09-20-2004 05:42 PM

I forgot to add the file type for it (mp3) but now that I have that setup, it's trying to display the mp3 in the browser (coding) instead of prompting for a download.....

I'm running 1.35
I have it set to force_redirect=0

???`S?LV?R???` 09-20-2004 05:48 PM

nevermind i figured out how to fix this.... i had to set the content type on the mp3 to the same as that it has on zip, and now it's prompting for download instead of trying to display its coding in the browser....
thanks for the response though :)

Snatch 09-20-2004 08:03 PM

I have one error. If a user post a link and i klick on moderate Links the link schows in on the Modpage. But if i klick in the link to moderate him i get this error.


Code:

Datenbankfehler in vBulletin 3.0.3:

Ungueltige SQL-Abfrage:
mysql error: Query was empty

mysql error number: 1065

Datum: 20.09.2004 22:57:57
Skript: http://www.celebritymarkt.de/local_links.php?action=modcat&catid=2
Referer: http://www.celebritymarkt.de/local_links.php?action=mod
Benutzername: Snatch
IP-Adresse: 213.23.58.128


sinclac 09-20-2004 08:46 PM

Quote:

Originally Posted by AndrewD
I need to have a look at your board - can you set me up an account with admin privs and PM them to me?

I just PMed you

AndrewD 09-21-2004 04:07 PM

Quote:

Originally Posted by Snatch
I have one error. If a user post a link and i klick on moderate Links the link schows in on the Modpage. But if i klick in the link to moderate him i get this error.


Code:

Datenbankfehler in vBulletin 3.0.3:

Ungueltige SQL-Abfrage:
mysql error: Query was empty

mysql error number: 1065

Datum: 20.09.2004 22:57:57
Skript: http://www.celebritymarkt.de/local_links.php?action=modcat&catid=2
Referer: http://www.celebritymarkt.de/local_links.php?action=mod
Benutzername: Snatch
IP-Adresse: 213.23.58.128


Thanks for pointing this out - and sorry. There's a bug in local_links.php. Line 1225 in version 1.35 / line 1123 in version 1.30 reads:
PHP Code:

list ($linklistbit$nhits)  = get_linklistbit($squery""19999991); 

It should read
PHP Code:

list ($linklistbit$nhits)  = get_linklistbit($query""19999991); 



All times are GMT. The time now is 09:28 AM.

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.03466 seconds
  • Memory Usage 1,938KB
  • 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
  • (2)bbcode_code_printable
  • (8)bbcode_php_printable
  • (20)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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