External Link

Hi, this is my first vB hack so please be patient

This allows you to use a board as a link (UB2k users know this feature). When you set a board as a link every user who joins the board will be redirected to this url

See it in action: http://foren.letzplay.de (german) the last boards are redirections.

This hack has been tested on vB 2.0.1 and vB 2.0.3 but other users have it running on 2.2.1, too.

Please post questions, inspirations and problems in this thread (not per email or pm). Thank you.

New version 1.1a fixed online

Just fixed that one bug in the install description. No need to upgrade if version 1.1a is already running

New version 1.1a online

Fixed a bug that meaned the hit counter didn't work correctly.

There is an update script and an update manual in the zip.

New version 1.1 online

New features: Hit counter, seperate templates, you can define your own target tag

There is an update script and an update manual in the zip.

Download it here

[AS_Eagle_1]

Works Great THY !!!

Hi,

wow, I was missing that function!
Great description and hack file btw.

But I have a problem:
I went throught your description (thanks for the german one) and did it twice - still got db errors when inserting a forum with link.

Database error in vBulletin Control Panel: Invalid SQL: INSERT INTO forum
(forumid,styleid,title,description,active,displayo rder,parentid,
parentlist,allowposting,cancontainthreads,daysprun e,newpostemail,newthreademail,
moderatenew,allowhtml,allowbbcode,allowimages,allo wsmilies,allowicons,
styleoverride,allowratings,countposts,moderateatta ch,link)
VALUES
(NULL,'2','Who is who','Who is who','1','6','-1',
'','1','1','30','','',
'0','0','1','0','1','1',
'0','1','1','0','http://www.de','linktarget='_blank')
mysql error: You have an error in your SQL syntax near '_blank')' at line 10
mysql error number: 1064
Date: Saturday 14th of July 2001 06:53:29 PM
Script: /forum/admin/forum.php

Now what I wonder while looking at the SQL code is the following:

Line 142ff in forum.php / Line 38 of your info.txt

  $DB_site->query("INSERT INTO forum  (...)
                     (...)styleoverride,allowratings,countposts,moderateattach,link)
                     VALUES
                     (...)'$styleoverride','$allowratings','$countposts','$moderateattach','".addslashes($link)."','linktarget='$linktarget')");

Every field has a name and a value, but the linktarget.
After moderateattach is link, but no linktarget though there is a value 'linktarget='$linktarget'

Secondly the value 'linktarget='$linktarget' irritates me, I am not into php, but from my perl days IIRC the quoting looks weird.

Thanks for a hint,
-Tom

Okay, it works now (I think)

I edited the SQL Query in forum.php (142ff) and changed it to:

  $DB_site->query("INSERT INTO forum
                      (forumid,styleid,title,description,active,displayorder,parentid,
                       parentlist,allowposting,cancontainthreads,daysprune,newpostemail,newthreademail,
                       moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons,
                       styleoverride,allowratings,countposts,moderateattach,link,linktarget)
                   VALUES
                      (NULL,'$styleset','".addslashes($title)."','".addslashes($description)."','$isactive','$displayorder','$parentid',
                       '','$allowposting','$cancontainthreads','$daysprune','".addslashes($newpostemail)."','".addslashes($newthreademail)."',
                       '$moderatenew','$aallowhtmlcode','$aallowbbcode','$aallowimgcode','$aallowsmilies','$aallowicons',
                       '$styleoverride','$allowratings','$countposts','$moderateattach','".addslashes($link)."','$linktarget')");
  $forumid=$DB_site->insert_id();

I added linktarget and changed 'linktarget='$linktarget' to '$linktarget', now it looks okay for me in the db.

Is this correct?
Thanks,
-Tom

P.S. @AS_Eagle_1: How did it work for you

[GameCrash]

Which version did you use? 1.0, 1.1 or 1.1a?

Hi,
I used extlink11a.zip, especially info.deutsch.txt
-Tom

[GameCrash]

Okay, it was simply a bug in the info.deutsch.txt and info.english.txt

I have changed this two files and re-uploaded it but I did not create a new release, I think if someone else has installed the old 1.1a your description will help...

O.k., thanks for the great hack,
works like a treat!
thx,
-Tom

Works in 2.0.3
thx,
-Tom

[Thomas P]

...and in 2.2.0
-Tom

[orca]

Originally posted by GameCrash
Okay, it was simply a bug in the info.deutsch.txt and info.english.txt

I have changed this two files and re-uploaded it but I did not create a new release, I think if someone else has installed the old 1.1a your description will help...

Well, I downloaded the file today and the bug reported by ThomasP is still there. After editing, it worked again.