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)

LeeWicKeD 02-23-2005 07:37 PM

@Xtrm2Matt

Quote:

Originally Posted by AndrewD
You create (or choose) a forum on your board, and give that forum the permissions you want to use for the file (for example, only registered users can view posts in the forum). Then you associate the file with the forum. You do this within the form for adding or editing the link. You can do the same for categories.

If you want to apply this condition to every new file you make available, then on the links admin page, you set that forum to be the default forum for new links/categories.


Xtrm2Matt 02-23-2005 08:35 PM

Thanks :)

cclaerhout 02-24-2005 08:58 AM

Thanks for this hack. It's really good.

I've translated it into french (only the user visible part). I've also made a little style modification. Hope you'll like it :-)

Zain Jaffer 02-25-2005 08:53 PM

I'm getting a "status unknown" for all of the dloadz atm, what's going on?

http://www.juicyduff.com/forum/local_links.php

Dep 02-25-2005 09:42 PM

get a small problem when i tried to install

Error

SQL-query:

--
-- Table structure for table `local_linkslink`
--
CREATE TABLE `local_linkslink` (
`linkid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`linkname` varchar( 255 ) NOT NULL default '',
`linkdesc` text NOT NULL ,
`linkurl` text NOT NULL ,
`linkhits` mediumint( 8 ) unsigned NOT NULL default '0',
`linkforum` smallint( 5 ) NOT NULL default '0',
`linkcheck` int( 10 ) unsigned NOT NULL default '0',
`linkstatus` int( 10 ) NOT NULL default '0',
`linkdate` int( 10 ) NOT NULL default '0',
`linkusername` text NOT NULL ,
`linkuserid` int( 10 ) NOT NULL default '0',
`linkmoderate` int( 2 ) NOT NULL default '0',
`linkmoddate` int( 10 ) NOT NULL default '0',
`linkreviewfreq` smallint( 5 ) NOT NULL default '0',
PRIMARY KEY ( `linkid` ) ,
FULLTEXT KEY `namedesc` ( `linkname` , `linkdesc` )
) TYPE = MYISAM AUTO_INCREMENT =1

MySQL said: Documentation
#1283 - Column 'linkname' cannot be part of FULLTEXT index

any ideas how to fix it plz

taxfree 02-26-2005 12:03 AM

Excellent hack! Just got a quick question for you (don't we all?). I'm using this as a URL link manager for my reciprocal links. Right now, the links are all pointing to an internal link, like http://www.mydomain.com/forum/local_...tion=jump&id=3. Is there a for the link to show the actual link? My link exchange partners won't be too pleased when they find their inbound links gone.

AndrewD 02-27-2005 10:36 AM

Quote:

Originally Posted by Zain Jaffer
I'm getting a "status unknown" for all of the dloadz atm, what's going on?

http://www.juicyduff.com/forum/local_links.php

The hack only checks the availability/size of your links/files at certain times. For simple links or for downloadable files which are obviously within the file structure of your own web server (i.e. have no URL associated with them), this happens when the entry is set up. However, if it is a download which involves a URL, the check happens the first time someone (including possibly yourself) accesses it, because the check involves reading the whole file from the remote site.

I've just done this to one of your entries that was showing "status unknown". After accessing it and refreshing the links page, the description has changed to saying [52 kbytes] i.e. the file size.

If you don't like this behaviour, you can always edit the links_linkbit template. Find and delete the line which reads as follows:

Code:

<if condition="$linkstatus==0"> [$vbphrase[ll_unknown_status]]</if>

AndrewD 02-27-2005 10:46 AM

Quote:

Originally Posted by taxfree
Excellent hack! Just got a quick question for you (don't we all?). I'm using this as a URL link manager for my reciprocal links. Right now, the links are all pointing to an internal link, like http://www.mydomain.com/forum/local_...tion=jump&id=3. Is there a for the link to show the actual link? My link exchange partners won't be too pleased when they find their inbound links gone.

There's an easy but not perfect way, and a less easy way which I could include in the next release if you prefer.

The easy way is to go to the links admin page and change the setting of force_redirect to 2. This makes all your links completely visible, but it has the side effect that the hit counter no longer works.

An alternative is to edit the links_linkbit template. Find the line which reads
Code:

<if condition="$linkurl"><a href="local_links.php?action=jump&amp;id=$linkid" target="_blank"></if>$linkname<if condition="$linkurl"></a></if>
Before the text target="_blank", insert title="$linkurl", i.e.

Code:

<if condition="$linkurl"><a href="local_links.php?action=jump&amp;id=$linkid" title="$linkurl" target="_blank"></if>$linkname<if condition="$linkurl"></a></if>
That way, the actual url will become a pop-up when someone hovers over the link.

Please note that this will make the location of all your links and downloads visible, so you will not be able to hide things.

AndrewD 02-27-2005 10:47 AM

Quote:

Originally Posted by Dep
get a small problem when i tried to install

Error

SQL-query:

--
-- Table structure for table `local_linkslink`
--
CREATE TABLE `local_linkslink` (
`linkid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`linkname` varchar( 255 ) NOT NULL default '',
`linkdesc` text NOT NULL ,
`linkurl` text NOT NULL ,
`linkhits` mediumint( 8 ) unsigned NOT NULL default '0',
`linkforum` smallint( 5 ) NOT NULL default '0',
`linkcheck` int( 10 ) unsigned NOT NULL default '0',
`linkstatus` int( 10 ) NOT NULL default '0',
`linkdate` int( 10 ) NOT NULL default '0',
`linkusername` text NOT NULL ,
`linkuserid` int( 10 ) NOT NULL default '0',
`linkmoderate` int( 2 ) NOT NULL default '0',
`linkmoddate` int( 10 ) NOT NULL default '0',
`linkreviewfreq` smallint( 5 ) NOT NULL default '0',
PRIMARY KEY ( `linkid` ) ,
FULLTEXT KEY `namedesc` ( `linkname` , `linkdesc` )
) TYPE = MYISAM AUTO_INCREMENT =1

MySQL said: Documentation
#1283 - Column 'linkname' cannot be part of FULLTEXT index


any ideas how to fix it plz

Hello, what version of MySQL are you using?

Dep 02-27-2005 01:46 PM

version 4.1.9


All times are GMT. The time now is 10:51 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.01776 seconds
  • Memory Usage 1,752KB
  • 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
  • (3)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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