Banner ad on forum Home

[Beermonster]

Adapted from "Add a banner image to each forum" script by Harrybutt
https://vborg.vbsupport.ru/showthread.php?t=61555

This modification will add an image banner with link and text to each forum you choose, and display it in on your forumhome, you can have a different banner for each forum with additional text above the banner like Sponsored by or affiliated with, or you can choose to have no text.

I have used 100x25px images for the example screen shot, but you can use what ever size you like, but remember it will effect the way your forum looks.

Hope people find this usful, this is my first hack as I'm still a big noob when it come's to hacking :)

Opps sorry made a slight error in the dir name, it's fixed now :)


For 3.5.x look here (https://vborg.vbsupport.ru/showthread.php?t=93673)

[Logik]

Nice little hack...Could be used.

[poetic]

Nice, I like this. :)

[synwave]

Excellent...I've been waiting for this!

Thanks :)

[Sketch]

Can you HTL it, please? ;) If you do I'll install it.

Aaron

[synwave]

Excuse my ignorance guys.....but what is HTL?

Cheers,
Synwave

[Beermonster]

Excuse my ignorance guys.....but what is HTL?


Cheers,
Synwave

hack Tracking Log
https://vborg.vbsupport.ru/showthread.php?t=60735&highlight=HTL

I would if I could but like I said I'm a total noob at this, I will have a look in to it and see if I can :)

[Sketch]

I'll try and convert it for you. I need the practice.

Aaron

[Beermonster]

I'll try and convert it for you. I need the practice.

Aaron

Go for it :) I don't have HTL installed, so I've never played with it.

[Sketch]

Almost there. Inquiring about some roadblocks I'm running into but hopefully something soon. You should check the HTL. It's great. I'm only installing hacks using it and my goal is to use it to write hacks (though this is the first one I'm trying to put into HTL as if I'm writing it)...

Aaron

[webrats]

would be cool if we could have both hack on the same admin page say small banner for forum home
and big banner for top of forums

[Beermonster]

would be cool if we could have both hack on the same admin page say small banner for forum home
and big banner for top of forums


You can all you need to do is install them both ;)

[hooolala]

what does add field to forum table means?

[Beermonster]

what does add field to forum table means?

You need to go to phpmyadmin and Run SQL query/queries on database just paste this code in the box and press "go"


ALTER TABLE `forum` ADD `fhbanner` VARCHAR( 50 ) NOT NULL AFTER `description` ;
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanner` ;
ALTER TABLE `forum` ADD `fhmessage` VARCHAR( 50 ) NOT NULL AFTER `fhbannerlink` ;

[sneakyc2e]

I did the banner hack and checked it three times to make sure I did every thing right and the banner is not showing up. Everything shows up in the user cp fine. This is the first time I have run a sql query but I went back to phpmyadmin and they show in there.

Any ideas. I really need this hack and it looks awesome in your screenshots.

I am on vBulletin Version 3.0.1

Thanks,
Dan

[Beermonster]

I did the banner hack and checked it three times to make sure I did every thing right and the banner is not showing up. Everything shows up in the user cp fine. This is the first time I have run a sql query but I went back to phpmyadmin and they show in there.

Any ideas. I really need this hack and it looks awesome in your screenshots.

I am on vBulletin Version 3.0.1

Thanks,
Dan

I've sent you a pm, not sure what could be wrong, AFAIK no one else has had problems

[sneakyc2e]

Any ideas?

[paul_r]

just ran the query and heres what i got

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanne' at line 1

any ideas ? :ermm: :surprised:

[Beermonster]

I don't think you've pasted it in right, if you look at it it says "NOT NULL AFTER `fhbanne' " it should be fhbanner

[paul_r]

i dont think so m8

here the query error window copied and pasted ;)



Query
ALTER TABLE `forum` ADD `fhbanner` VARCHAR( 50 ) NOT NULL AFTER `description` ;
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanner` ;
ALTER TABLE `forum` ADD `fhmessage` VARCHAR( 50 ) NOT NULL AFTER `fhbannerlink`



vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanne' at line 1

[Beermonster]

i dont think so m8

here the query error window copied and pasted ;)



Query
ALTER TABLE `forum` ADD `fhbanner` VARCHAR( 50 ) NOT NULL AFTER `description` ;
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanner` ;
ALTER TABLE `forum` ADD `fhmessage` VARCHAR( 50 ) NOT NULL AFTER `fhbannerlink`



vBulletin Message
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanne' at line 1


There's no ; at the end of the last line, it should be
ALTER TABLE `forum` ADD `fhbanner` VARCHAR( 50 ) NOT NULL AFTER `description` ;
ALTER TABLE `forum` ADD `fhbannerlink` VARCHAR( 250 ) NOT NULL AFTER `fhbanner` ;
ALTER TABLE `forum` ADD `fhmessage` VARCHAR( 50 ) NOT NULL AFTER `fhbannerlink` ;

but you are still missing the r in the error, try deleting fhbanner, fhbannerlink & fhmessage tables and run the query again, are you using phpmyadmin or admincp? also did you do a standard install of vb? or did you give the tables a prefix?

[paul_r]

ahh forund the problem in myphp

forum didnt exist so i had to change it to vb3_forum

workes a treat

thanks

www.mx5roadsters.com/forums

:D

[Beermonster]

ahh forund the problem in myphp

forum didnt exist so i had to change it to vb3_forum

workes a treat

thanks

www.mx5roadsters.com/forums

:D


np glad you got it working, feel free to click install ;)

[sneakyc2e]

Sent you a pm.

Dan

[sneakyc2e]

file uploaded.

Dan

[sneakyc2e]

Pmed ya again.
Thanks,
Dan

[sneakyc2e]

Thanks for going way beyond supporting me on this one bro. Clicking Install.

Dan

[Jpax]

I installed everything and checked over all the lines, i get absoulty nothing that comes up. i can see the feilds were i can add the links and text but when i add them nothing happens. Right now i am using a dev folder so the url for the images are /dev/html/forum/admincp/images/fhbanner/ssbanner.gif
but i can see the pic but if i put it in the url what am i doing wrong? :ermm:

[Jpax]

never mind im an idiot, you have to lok in the admin pannel to add the files and links. GezzUuZZz this is awesome!

[sam]

Add these phrases:

Varname:
fhbanner

text:
Postbits Banner Image<br>(Places a image on your forum postbits) EX: banner.jpg

Varname:
fhbannerlink

text:
Postbits Banner Image Link<br>(http://www.yoursite.com)

Varname:
fhmessage

text:
Postbits Banner text i.e. Sponsored By or Affiliate with

Where i should put those phases and HOW?

any help please?

[Beermonster]

Where i should put those phases and HOW?

any help please?

Go to AdminCP then Languages & Phrases/phrase manager, then add new phrase

[RichieBoy67]

Can you use google adsence with this somehow???

[Beermonster]

Can you use google adsence with this somehow???

I'm sure it could be modified to retrieve HTML files rather that pictures, but I'm not sure about using both together, after all you only usually have one Google ad account.

[RichieBoy67]

I do have only one google ad account but I use the ad code on all my sites. Seems to work.. I would like to use google ad sence buttons. I think they would fit perfectly.

How hard would it be to mod this???

Thanks

[Beermonster]

Sorry I was thinking I was replying to my rotating banner mod, it's been a long day :surprised:

I will have a look at it for you see what I can do :)

[RichieBoy67]

No Problem..lol

Thanks so much for helping! :)

Great Hack BTW

[Crinos]

I do have only one google ad account but I use the ad code on all my sites. Seems to work.. I would like to use google ad sence buttons. I think they would fit perfectly.Doesn't the Adsense TOS specifically state that there can be only one instance of their ads per page?

[RichieBoy67]

I'm not really sure but why would they care? When ever somebody clicks they are making much more than us???

Unfortunatly I do not have any paid advertisers yet other than Google...

[veedee]

Good hack but I get this message when I try to add a banner to my main forum.

Database error in vBulletin 3.0.3:

Invalid SQL: UPDATE forum SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'General',
description = 'Post general bike related questions, and join in the banter!',
fhbanner = 'test.jpg',
fhbannerlink = '',
fhmessage = '',
link = '',
displayorder = '1',
daysprune = '1',
parentid = '24',
newpostemail = '',
newthreademail = '',
styleid = '0',
password = '',
options = '97991',
parentlist = '1,24,-1'
WHERE forumid=1
mysql error: Unknown column 'fhbanner' in 'field list'

mysql error number: 1054

[Beermonster]

Check your mysql table it looks like you don't have fhbanner in it, also do your forum tables have a prefix on them?

[WreckRman2]

Beermonster, Is there any way to modify this hack to just it to display forum specfic banner ads that show on top of ceratin forums?

[Beermonster]

Beermonster, Is there any way to modify this hack to just it to display forum specfic banner ads that show on top of ceratin forums?

You've lose me, each forum can have it's own ad displayed

[WreckRman2]

What I meant was to be displayed on top of each forum listing as well as on every thread under that forum. I've just finished up my doings thanks in great part to your hack. If you like I will gladly share it with you. My little variation works directly with phpAdsnew so that tracking can be done on the ads.

Here is an example:

http://www.rcflying.net/images/example.jpg

It shows a very large banner, 700x125 is what I am using.

[Dennis B]

Beermonster,

This works like a charm on my forums for users with IE, but users with Nescape browsers are reporting that the ad doesn't align correctly. I have verified that myself, please check out the attachment. Any way to correct this?

[Dead End Society]

Sorry for not knowing everything, I have installed about 5 hacks already, but am having problems understanding what to do for the first part of this hack, where it is asking me to add field to the forum table and the "Run Query" part.

Can someone be a little more clear for me?

[Dennis B]

Cavs,

You need to login to your database and run those queries there.
Alternatively you may try to run them in your admincp if you have the appropriate privileges set.

[Dead End Society]

^ I still have no clue what to do though, that's doing nothing for me. Remember, I'm a raw newbie. How do I run them? Where exactly are they?

[Beermonster]

Sorry for not knowing everything, I have installed about 5 hacks already, but am having problems understanding what to do for the first part of this hack, where it is asking me to add field to the forum table and the "Run Query" part.

Can someone be a little more clear for me?

The query needs to be run in mysql, go to phpmyadmin choose your database, then click on the sql tab you will then see a box that says Run SQL query/queries on database just paste the contents in to it and press go :)

[ricoracing]

if I'm the admin and Im' in the adminCP panel and go down to import and maint.

I then tell it to execute SQL query and it says I don't have access. HOw is that when I am the admin of the site.

I also can't do it from the hosting center when I go to the mysql option.

I"m also a newbie and have no idea of what's going on.. LOL

I think once i get the tables setup I"ll be fine.. :ermm:

[Beermonster]

If your hosting has cpanel click on the mysql icon then scroll down to the bottom and you will see a link to phpmysql click on that and it will take you to another page, there you can choose your database and them run the query.


As for not being able to run it from admincp I think, and I might be wrong, but edit your includes/config.php and find
// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
you will see $canrunqueries = '1';
If you setup the forum then you should be user #1 but if someone set it up for you then made you a member you will have a different number.
Also make sure $superadministrators in the same file has your number in it.

Hope that works for you :)

[Kwak]

Using this modification hack, could you make the image link appear in this spot?

[Beermonster]

Using this modification hack, could you make the image link appear in this spot?


Yes you would just need to alter it slightly

[Kwak]

If anyone know how to do (see the attachment #51) the alteration for this hack, please let us know. Thanks a lot.

[roundhost]

If anyone know how to do (see the attachment #51) the alteration for this hack, please let us know. Thanks a lot.

I am interested in this too, i am going to try, but dont blame me if i cant do it! lol

[roundhost]

I am guessing it simply requires that the template edit as to where the ads are posted is moved into the category part rather than the forum part, i shall try to get it working ;)

[Kwak]

I am guessing it simply requires that the template edit as to where the ads are posted is moved into the category part rather than the forum part, i shall try to get it working ;)
Thanks roundhost. Hope it works out. If anyone else knows how to, let us know. :squareeyed:

[bdjncox]

Any progress from anyone on adding this to the category bar instead of the forum bar?

[ht330]

Can someone help me here? I've followed every instruction, and can't see the banner. I've also rebuilt the styles and Forum information. What could I be missing?

[ht330]

You can all you need to do is install them both ;)
Where do I get the AdminCP file to administer the banner files?

[Beermonster]

Where do I get the AdminCP file to administer the banner files?


forum & moderators/forum manager then choose the forum you want to add the banner to, have a look at the attachments in the first post

[ht330]

forum & moderators/forum manager then choose the forum you want to add the banner to, have a look at the attachments in the first post

Got it. The data is in there correctly, but I still don't see the banner. Is there a cache that needs to get updated or something? If I view source of the HTML, I don't see any reference to my jpg file...

[Beermonster]

Got it. The data is in there correctly, but I still don't see the banner. Is there a cache that needs to get updated or something? If I view source of the HTML, I don't see any reference to my jpg file...


Nothing needs updating, double check the installation see if you have missed anything, if your still having problems I will install it for you.

[CarolinaKid]

I have sent a pm to the own of this hack...With a edit i done to allow this to work in the Categrory either top left or right or both and bottom left or right or both. If he aproves and see's no peoblems with it then you may have you hack edit :rolleyes:

[CarolinaKid]

chech this out might be useful. https://vborg.vbsupport.ru/showthread.php?t=69749

[nnjj.net]

I tried to do it on 3.3, its not working
check attach image

[Beermonster]

I tried to do it on 3.3, its not working
check attach image

You haven't installed it correctly

[nnjj.net]

ok I did modify the mistakes, but after I put the bannar I can't open any forum and the posts is 0

see attcahed

[Edisonian]

Could either of you [Beermonster or CarolinaKid] help me install the hack that adds the mini-banner graphic to the category header? I can pay you a small fee via PayPal. Please PM and let me know.

[Beermonster]

Could either of you [Beermonster or CarolinaKid] help me install the hack that adds the mini-banner graphic to the category header? I can pay you a small fee via PayPal. Please PM and let me know.


Yes not a problem, pm sent

[[email protected] vbmenu_register("postmenu_572461", true);]

OK, I have been using this hack without problems. Well Done !!

Question......I have tried to have a sponsor image on a sub-forum that is not displayed on the forumhome. No joy. How can I get this to work on other forums that are sub forums?

I have my main forum sponsored by one company. Then on the sub forum I want another image. Can this be done?

[Beermonster]

OK, I have been using this hack without problems. Well Done !!

Thanks, please click install then ;)


I have my main forum sponsored by one company. Then on the sub forum I want another image. Can this be done?

Yes it can be but basically it would be another hack as you would need another set of boxes to put your details in etc.

[Spinball]

Hi Beermonster,
there is a Firefox and Opera incompatibility in your code.
As it stands, in those browsers, the banners are displayed in the middle of the column rather than right justified. This is because your table HTML is wrong.
Instead of

<if condition="$forum['fhbanner']">
<table align="right" border="0"><div align="center" valign="top">...
...</div></table>
</if>

You should have
<if condition="$forum['fhbanner']">
<table align="right" border="0"><tr><td align="center" valign="top">...
...</td></tr></table>
</if>

This fixes the problem. All tables should have a TR and TD in them.

[Beermonster]

Hi Beermonster,
there is a Firefox and Opera incompatibility in your code.


Thanks for the update :)

[[email protected] vbmenu_register("postmenu_573934", true);]

Thanks, please click install then ;)



Yes it can be but basically it would be another hack as you would need another set of boxes to put your details in etc.

Install clicked ! Thanks for a wonderful hack !

Now can you help me with this other set of code? I would appreciate it beyond words. You guys that do this stuff are unreal and deserve lots of credit !

You say I need another set of boxes to put details in, but the boxes are already there in my control panel under the sub forum. It's just when I plug in info, it isn't displayed. What do you say? Help out a friend. :)

[Beermonster]

Install clicked ! Thanks for a wonderful hack !

Now can you help me with this other set of code? I would appreciate it beyond words. You guys that do this stuff are unreal and deserve lots of credit !

You say I need another set of boxes to put details in, but the boxes are already there in my control panel under the sub forum. It's just when I plug in info, it isn't displayed. What do you say? Help out a friend. :)

OK I've quicky done it, you do need another box if you are displaying a different banner, like I said I've quickly done this and I've also had a couple of beers but I think it works :)



// Adds fields to forum table.

Run Query:
ALTER TABLE `forum` ADD `fhbanner2` VARCHAR( 50 ) NOT NULL AFTER `description` ;
ALTER TABLE `forum` ADD `fhbannerlink2` VARCHAR( 250 ) NOT NULL AFTER `fhbanner2` ;
ALTER TABLE `forum` ADD `fhmessage2` VARCHAR( 50 ) NOT NULL AFTER `fhbannerlink2` ;

------------------------------

Find in: admincp/forum.php

print_textarea_row($vbphrase['description'], 'forum[description]', $forum['description']);


below add:

print_input_row($vbphrase['fhbanner2'], 'forum[fhbanner2]', $forum['fhbanner2']);
print_input_row($vbphrase['fhbannerlink2'], 'forum[fhbannerlink2]', $forum['fhbannerlink2']);
print_input_row($vbphrase['fhmessage2'], 'forum[fhmessage2]', $forum['fhmessage2']);

Find:
$forum['description'] = convert_to_valid_html($forum['description']);

below add:
$forum['fhbanner2'] = convert_to_valid_html($forum['fhbanner2']);
$forum['fhbannerlink2'] = convert_to_valid_html($forum['fhbannerlink2']);
$forum['fhmessage2'] = convert_to_valid_html($forum['fhmessage2']);
---------------------------------

Edit Template : forumhome_forumbit_level1_post

Find:
<tbody>
<tr align="center">
<td class="alt1Active" colspan="2" align="$stylevar[left]" id="f$forum[forumid]">

below add:

<!-- Ad Banner Start -->
<table align="right" width="15%" border="0">
<div align="center" valign="top" valign="top">
<if condition="$forum['fhbanner2']"><font size="1">$forum[fhmessage2]</font><br><a href="http://$forum[fhbannerlink2]" target="_blank"><img src="images/fhbanner/$forum[fhbanner2]" alt="$forum[fhbannerlink2]" border="0" /></a></div></if></table>
<!-- Ad Banner end -->



--------------------------------------------
Add these phrases:

Varname:
fhbanner2

text:
Banner 2

Varname:
fhbannerlink2

text:
Banner 2 Link

Varname:
fhmessage2

text:
Postbits 2 Banner text i.e. Sponsored By or Affiliate with

--------------------------------------------
Then,

Create a "fhbanner2" folder EX: $vbhome/images/fhbanner

[[email protected] vbmenu_register("postmenu_573972", true);]

I'm not sure you understand what I'm trying to do.

Go to www.sportbikes.ws and look at the "Pocketbike" forum. I have a sponsor already there. Done deal...happy.

Now go into that forum http://www.sportbikes.ws/forumdisplay.php?f=103 and you'll see a sub forum "FAQ". That's were I want to put the second sponsor. I put the one you see there now just using some html to get by.

In the admincp, if I go into that FAQ sub forum, I see all the fields that I do on the main forumhome page.

Is this your understanding? Maybe I'm the one needing to have a few beers. :)

Thanks for the help !!

[Gottcha]

Been messing with this for awhile now and cant get it to run......can someone help installl or install it for me.....followed all the steps and banners not showing up.

[CSS59]

How do i run query? I dont know how to do the first step

do i need to do anything diff for 3.0.3?

[Beermonster]

How do i run query? I dont know how to do the first step

do i need to do anything diff for 3.0.3?

You need to run the query in mysql, you can do that using phpmyadmin, if you have cpanel hosting there will be a link to it from there, or you can also run then from within the admincp providing you have the right permissions set for it.

[MajorFm.com]

Can the banners be set so they expire after a period of time or even better...

Can the advertiser sign up, upload their banner, pay for the time requested, and it simply sits in admincp waiting a simple accept link (banner approval)

The admin clicks the link and the banner is added for the time paid for...

[Beermonster]

Can the banners be set so they expire after a period of time or even better...

Can the advertiser sign up, upload their banner, pay for the time requested, and it simply sits in admincp waiting a simple accept link (banner approval)

The admin clicks the link and the banner is added for the time paid for...

not in this hack

[Viks]

A very useful modification. ++

Would like to request to update instructions to add code for Mozilla / Netscape browsers.

overall +++

[Q-v-n-s-Q]

Nice hacks <3

[bumwrap]

There is a Firefox and Opera incompatibility in your code.
As it stands, in those browsers, the banners are displayed in the middle of the column rather than right justified. This is because your table HTML is wrong.

That didn't work. I tried it 3 times. Totally messed it up. I changed it back. Any other codes to help.

[Protoman]

bump, code for the table display does not work in mozilla or opera still. fix on page 5 doesn't work.

[Shackbase]

hows this work for 3.0.7 and instead of banner images - is it possible to just have it say:

sponsored by: NAME/Link here ?

--Tone

[Protoman]

I installed it on 3.0.7 without fault other than the browser problems. keeping me from using it.

I "think" this should work.. haven't tried it.. but you would use the banner image field.
you'd enter 'Oogle' in the image link field and you'd see this on your page.
ie( "Sponsored by" Oogle (http://www.google.com))


In template forumhome_forumbit_level2_post,

find:
<!-- Ad Banner Start -->
<table align="right" width="15%" border="0">
<div align="center" valign="top" valign="top">
<if condition="$forum['fhbanner']"><font size="1">$forum[fhmessage]</font><br><a href="http://$forum[fhbannerlink]" target="_blank"><img src="images/fhbanner/$forum[fhbanner]" alt="$forum[fhbannerlink]" border="0" /></a></div></if></table>
<!-- Ad Banner end -->

replace with:
<!-- Ad Banner Start -->
<table align="right" width="15%" border="0">
<div align="center" valign="top" valign="top">
<if condition="$forum['fhbanner']"><font size="1">$forum[fhmessage]<a href="http://$forum[fhbannerlink]" target="_blank">$forum[fhbanner]</a></div></if></font></table>
<!-- Ad Banner end -->

[Shackbase]

wow - thank you - I might give that a whirl...

what are the browser problems you mentioned above?

--Tone

[pcoskat]

If anyone know how to do (see the attachment #51) the alteration for this hack, please let us know. Thanks a lot.
This is my preference, too.

Can it be done for 3.0.7. Please let me know.

[bumwrap]

bump, code for the table display does not work in mozilla or opera still. fix on page 5 doesn't work.

[EchoZA]

Just installed on 3.0.7, double checked everything and still nothing displaying in sub forums? Any ideas?

[artonex]

Yes i would like to know if this works on vb 3.0.7 without any problems.

[Beermonster]

Just installed on 3.0.7, double checked everything and still nothing displaying in sub forums? Any ideas?

AFAIK there shouldn't be any problem, if you want me to look at it I will, apart from that not sure what to sugest

[grecostimpy]

any word on making this work with Firefox/Netscape?

[LuBi]

any word on making this work with Firefox/Netscape?

http://www.suprascene.com/tmp/notinmozilla.jpg

any fix? i need to go live and i love this hack. it seems like a simple table issue.. but I dunno.

[EchoZA]

You can all you need to do is install them both ;)

When you say both! Which 2 are you refering too?

[jimnyc]

Not sure what I missed as I went step by step with this hack and everything went without a hitch. I'm looking everywhere in the AdminCP and I can't find where you control this hack. What could I have missed that would keep it from showing in my CP?

Thanks!

[jimnyc]

Not sure what I missed as I went step by step with this hack and everything went without a hitch. I'm looking everywhere in the AdminCP and I can't find where you control this hack. What could I have missed that would keep it from showing in my CP?

Thanks!

I've triple checked every step and all seems to have went well, yet I still can't find the options in the AdminCP. Has anyone else gotten this to work in version 3.0.6?

Thanks!

[LuBi]

ok i'll just say it.

Admin CP > Forums & Moderators > Forum Manager > Edit Forum

now there's two ways you could have figured this out.

A.) looking at the second attached picture

B.) remembering you edited admincp/forum.php

glad i could help :ermm:

now can anyone figure out a Mozilla fix for this hack? :squareeyed:

[jimnyc]

ok i'll just say it.

Admin CP > Forums & Moderators > Forum Manager > Edit Forum

now there's two ways you could have figured this out.

A.) looking at the second attached picture

B.) remembering you edited admincp/forum.php

glad i could help :ermm:


I checked there at least a dozen times and the banner options just don't appear when I choose edit forum. What could I have done wrong that it doesn't even show in the CP?

[LuBi]

I checked there at least a dozen times and the banner options just don't appear when I choose edit forum. What could I have done wrong that it doesn't even show in the CP?

honestly not much, admincp/forum.php is the only file to edit.. So you've got 3 queries to run, 1 file to add to twice, 1 template to add to, and 3 phrases to add. Then all you do is make a dir "fhbanner" in your forums /images folder..

[enginethatcan't]

getting this error when I hit save in the admin cp

Invalid SQL: UPDATE forum SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Anabolics 101 - Sponsored by AG-Guys.com',
description = 'The only place for the most up to date, hardcore enhancement information.
<br><font color=\"9D0000\">Sponsored by</font><a href=\"http://www.AG-Guys.com
\"><b>
</b> AG-Guys.com --- Cialis, Viagra, Liquidex, Clen, T3 and more!
</a>',
fhbanner = 'ag.gif',
fhbannerlink = 'www.ag-guys.com',
fhmessage = 'Sponsored by',
link = '',
displayorder = '1',
daysprune = '-1',
parentid = '3',
newpostemail = '',
newthreademail = '',
styleid = '0',
password = '',
options = '89799',
parentlist = '4,3,-1'
WHERE forumid=4
mysql error: Unknown column 'fhbanner' in 'field list'

mysql error number: 1054

Date: Monday 27th of June 2005 02:29:48 PM
Script: http://www.anabolicevolution.com/admincp/forum.php
Referer: http://www.anabolicevolution.com/admincp/forum.php?do=edit&forumid=4&s=
Username: ********
IP Address: **.***.***.***.*

[Beermonster]

getting this error when I hit save in the admin cp

Invalid SQL: UPDATE forum SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Anabolics 101 - Sponsored by AG-Guys.com',
description = 'The only place for the most up to date, hardcore enhancement information.
<br><font color=\"9D0000\">Sponsored by</font><a href=\"http://www.AG-Guys.com
\"><b>
</b> AG-Guys.com --- Cialis, Viagra, Liquidex, Clen, T3 and more!
</a>',
fhbanner = 'ag.gif',
fhbannerlink = 'www.ag-guys.com',
fhmessage = 'Sponsored by',
link = '',
displayorder = '1',
daysprune = '-1',
parentid = '3',
newpostemail = '',
newthreademail = '',
styleid = '0',
password = '',
options = '89799',
parentlist = '4,3,-1'
WHERE forumid=4
mysql error: Unknown column 'fhbanner' in 'field list'

mysql error number: 1054

Date: Monday 27th of June 2005 02:29:48 PM
Script: http://www.anabolicevolution.com/admincp/forum.php
Referer: http://www.anabolicevolution.com/admincp/forum.php?do=edit&forumid=4&s=
Username: ********
IP Address: **.***.***.***.*

Are you sure you have ran the sql query correct? it's saying that one of the fields isn't there

[csidlernet]

coolies thanks
/me hits install

[veedee]

Does anyone know if this will work for 3.5.1 ?

[Beermonster]

Does anyone know if this will work for 3.5.1 ?

Check my sig for details ;)

[Howdy]

I have it working on 3.53. Just had to change the admincp slightly from this in the directions:

Find:
$forum['description'] = convert_to_valid_html($forum['description']);

below add:
$forum['fhbanner'] = convert_to_valid_html($forum['fhbanner']);
$forum['fhbannerlink'] = convert_to_valid_html($forum['fhbannerlink']);
$forum['fhmessage'] = convert_to_valid_html($forum['fhmessage']);

to this -->
below add (instead of above):
$forum['fhbanner'] = str_replace('&amp;', '&', $forum['fhbanner']);
$forum['fhbannerlink'] = str_replace('&amp;', '&', $forum['fhbannerlink']);
$forum['fhmessage'] = str_replace('&amp;', '&', $forum['fhmessage']);

[Beermonster]

I have it working on 3.53. Just had to change the admincp slightly from this in the directions:

Find:
$forum['description'] = convert_to_valid_html($forum['description']);

below add:
$forum['fhbanner'] = convert_to_valid_html($forum['fhbanner']);
$forum['fhbannerlink'] = convert_to_valid_html($forum['fhbannerlink']);
$forum['fhmessage'] = convert_to_valid_html($forum['fhmessage']);

to this -->
below add (instead of above):
$forum['fhbanner'] = str_replace('&amp;', '&', $forum['fhbanner']);
$forum['fhbannerlink'] = str_replace('&amp;', '&', $forum['fhbannerlink']);
$forum['fhmessage'] = str_replace('&amp;', '&', $forum['fhmessage']);


Or you could have just installed the 3.5.x plugin found here (https://vborg.vbsupport.ru/showthread.php?t=93673) ;)

[Howdy]

yea I just saw that... :D

[[email protected] vbmenu_register("postmenu_1144399", true);]

Anyone know if this would work on 3.6.3 or better ? Maybe a similar hack somewhere else ?

[siliconfinance]

how about 3.6.8 PL2