Forum Display Enhancements - Forum Sponsor

Forum Sponsor
Made by Adrian at Dreamit.co.uk
Tested on 3.6.1

Hey,

I seen a few people wanting a modification like this, this adds some fields in the Edit Forum Options, and allows you add a forum sponsor.

It's a pritty basic mod'.
I didn't want to spend alot of time on it, it does the functions people wanted.

See the screenshots to get a better understanding.

Installation
Import product-sponsor.xml

Done.

Template Edit
Open Forum Display templates > FORUMDISPLAY

Find:

$navbar

Add after:

<if condition="$foruminfo['sponsorenabled'] == 1">
<table width="100%" class="tborder" border="0" align="center">
  <tr>
    <td class="alt1"><table width="100%" border="0" cellspacing="5">
      <tr>
        <td width="10" rowspan="2" valign="middle"><div align="center"><a href="$foruminfo[sponsorlink]"><img src="$foruminfo[sponsorimage]" alt="$foruminfo[sponsorname] Image" border="0"></a></div></td>
        <td valign="top"><div align="left"><strong><a href="$foruminfo[sponsorlink]">$foruminfo[sponsorname]</a></strong></div></td>
      </tr>
      <tr>
        <td valign="top"><div align="left">$foruminfo[sponsordescription]</div></td>
      </tr>
    </table></td>
  </tr>
</table>
<br>
</if>

Done.

A quick install.

If you use this, please click installed.

Thanks.

Adrian

[ccmoon]

Found it! thanks Adrian.

[John1uk]

Adrian....is there anway i can centre the image and text...please click here and you will see what i mean.

the image is a lot smaller and the text shoves to the side with the image, i think it would look better if image and text could move over a little.

[Ricsca]

E' possibile avere pi? pubblicit??

Ad esempio:

[drumsy]

It would be nice to not display a red X if I don't specify an image.

[bada_bing]

Wow this is a great mod.. Tried to install it on my vb 3.5.3 site and got a database error when trying to install the plugin so I just exited out hope it didnt add anything to my database... Any chance on making this work for all the 3.5.x users

This is the error generated.. Seeing this did I damage my database? and if so how do I revert what was just entered? SIte seems to work fine

Database error in vBulletin 3.5.3:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Forum Sponsor', 'forumadmin_edit_form', 'print_yes_no_row($vbphrase[\'sponsorenabled\'], \'forum[sponsorenabled]\', $forum[\'sponsorenabled\']);\r\nprint_input_row($vbphrase[\'sponsorname\'], \'forum[sponsorname]\', $forum[\'sponsorname\']); \r\nprint_input_row($vbphrase[\'sponsorlink\'], \'forum[sponsorlink]\', $forum[\'sponsorlink\']);\r\nprint_input_row($vbphrase[\'sponsorimage\'], \'forum[sponsorimage]\', $forum[\'sponsorimage\']);\r\nprint_textarea_row($vbphrase[\'sponsordescription\'], \'forum[sponsordescription]\', $forum[\'sponsordescription\']);', 'sponsor');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Thursday, October 12th 2006 @ 09:46:19 PM

[perfphysio]

Excellent and simple hack, much appreciated. Installed without any problem on 3.6.2

I would however love a small addition or two:

1. The ability to open the links in a new window
2. A stats collection to count how many times it was clicked (i know that is a bit more work)
3. The ability to set more than one image and therefore more than one link or the ability to random select from a few sponsors that you set up in the same way you do now.
4. A choice of text alignment for the image, title and description e.g. left,right centre

But this in itself is an excellent starting point.

I also agree with the request to be able to pu a sponsor over an individual thread, e.g. Maybe an article was donated and you wish to promote the person who provided the copy. This too would be an awesone addition

[vphost]

Originally Posted by perfphysio

1. The ability to open the links in a new window

I haven't had a chance to test this out yet, but basing on what you said and the screenshot, can't you add target="_blank" into your a href?

[bada_bing]

Originally Posted by bada_bing

Wow this is a great mod.. Tried to install it on my vb 3.5.3 site and got a database error when trying to install the plugin so I just exited out hope it didnt add anything to my database... Any chance on making this work for all the 3.5.x users

This is the error generated.. Seeing this did I damage my database? and if so how do I revert what was just entered? SIte seems to work fine

Database error in vBulletin 3.5.3:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Forum Sponsor', 'forumadmin_edit_form', 'print_yes_no_row($vbphrase[\'sponsorenabled\'], \'forum[sponsorenabled]\', $forum[\'sponsorenabled\']);\r\nprint_input_row($vbphrase[\'sponsorname\'], \'forum[sponsorname]\', $forum[\'sponsorname\']); \r\nprint_input_row($vbphrase[\'sponsorlink\'], \'forum[sponsorlink]\', $forum[\'sponsorlink\']);\r\nprint_input_row($vbphrase[\'sponsorimage\'], \'forum[sponsorimage]\', $forum[\'sponsorimage\']);\r\nprint_textarea_row($vbphrase[\'sponsordescription\'], \'forum[sponsordescription]\', $forum[\'sponsordescription\']);', 'sponsor');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Thursday, October 12th 2006 @ 09:46:19 PM

Can someone help me please

[perfphysio]

Originally Posted by vphost

I haven't had a chance to test this out yet, but basing on what you said and the screenshot, can't you add target="_blank" into your a href?

No the field does not accept this html in it. In fact anything I tried by means of code in the link field disables that from working. So this is not a solution

[Mr Pink]

Great mod. Maybe I will use it. Thanks.