vb Ad Management

This is the 3.5 version of the already existing product for 3.6. Read all about the features it in that thread:

https://vborg.vbsupport.ru/showthread.php?t=131150

This is exactly the same, but compatible with 3.5 versions of vBulletin.

[ski diva]

I uninstalled and then re-installed, and seem to be having an installation problem.

This is what I get after I hit "import."

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO Myname_plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'vB Ad Management - Template Cache', 'cache_templates', '\r\nif ($vbulletin->options[\'adintegrate_onoff\'])\r\n{\r\n if ($vbulletin->options[\'adintegrate_footer_onoff\'])\r\n {\r\n $adtemplates[] = \'footer_advertisement\';\r\n }\r\n \r\n if ($vbulletin->options[\'adintegrate_forumbit_onoff\'])\r\n {\r\n $adtemplates[] = \'forumbit_advertisement\';\r\n }\r\n \r\n if ($vbulletin->options[\'adintegrate_header_onoff\'])\r\n {\r\n $adtemplates[] = \'header_advertisement\';\r\n }\r\n \r\n if ($vbulletin->options[\'adintegrate_leftcolumn_onoff\'])\r\n {\r\n $adtemplates[] = \'leftcolumn_advertisement\';\r\n } \r\n \r\n if ($vbulletin->options[\'adintegrate_announcements_onoff\'] || $vbulletin->options[\'adintegrate_pms_onoff\'] || $vbulletin->options[\'adintegrate_posts_onoff\'])\r\n {\r\n if ($vbulletin->options[\'legacypostbit\'])\r\n { \r\n $adtemplates[] = \'postbit_legacy_advertisement\';\r\n }\r\n else\r\n {\r\n $adtemplates[] = \'postbit_advertisement\';\r\n }\r\n }\r\n \r\n if ($vbulletin->options[\'adintegrate_rightcolumn_onoff\'])\r\n {\r\n $adtemplates[] = \'rightcolumn_advertisement\';\r\n } \r\n \r\n if ($vbulletin->options[\'adintegrate_threadbit_onoff\'])\r\n {\r\n $adtemplates[] = \'threadbit_advertisement\';\r\n }\r\n \r\n if (count($adtemplates) > 0)\r\n {\r\n $globaltemplates = array_merge($globaltemplates, $adtemplates);\r\n }\r\n}\r\n', 'adintegrate_rt');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Thursday, December 21st 2006 @ 01:20:36 PM
Script : http://www.MYFORUMNAME/admincp/plugin.php
Referrer : http://www.MYFORUMNAME/testforum/adm...?do=productadd

Classname : vb_database

I don't know what this means or how it can be fixed. Any ideas?

Thanks

[RedTyger]

It means you're trying to install the 3.6 version on a 3.5 forum, which won't work.

[ski diva]

AHA!!!!!!!

Thanks.

[ski diva]

Now we're getting somewhere!!!!! It installed fine and it's showing up in the AdminCP and everything! Woo-hooo!

But on to other problems. I have zero coding experience, and when it asks to put in the code for the ad, I'm putting in something like this:

http://www.MYFORUMNAME.com/images/ads/ADNAME.gif

That didn't work. So I tried this:

<a href="http://www.MYFORUMNAME.com/images/ads/ADNAME.gif"></a>

And that didn't work, either.

What am I doing wrong? What should I be putting in, code-wise?

Again, thanks for your help. And sorry for my complete incompetence.

[RedTyger]

What are you trying to achieve? This will give you an image that is linked to somewhere else.

<a href="http://www.MYFORUMNAME.com/LINKTOPAGE">
<img src="http://www.MYFORUMNAME.com/LINKTOPICTURE" alt="" border="0" /></a>

[ski diva]

Thanks! It worked! Just what I needed.

[RedTyger]

Be sure to click install to the right of the mod description in the first post above so you receive update notifications.

[ski diva]

Done and thanks for all your help! This is a great hack, and you've been very supportive.

A couple more questions:

1) Is there a way to make different header & footer ads for each forum?

2) I'm having trouble with the left column ad. I currently have what's essentially a two column layout: the narrower left column has forum stats above text google adsense ads, the wider, right column has the actual forum stuff (threads, etc). When I use your code (and get rid of the google adsense, since I want to replace it with my own ads), I get a third column to the left of the existing left column, and the right column essentially collapses -- the footer moves above it and it's just a mess.

Any ideas what I'm doing wrong?

[RedTyger]

Originally Posted by ski diva

Done and thanks for all your help! This is a great hack, and you've been very supportive.

A couple more questions:

1) Is there a way to make different header & footer ads for each forum?

2) I'm having trouble with the left column ad. I currently have what's essentially a two column layout: the narrower left column has forum stats above text google adsense ads, the wider, right column has the actual forum stuff (threads, etc). When I use your code (and get rid of the google adsense, since I want to replace it with my own ads), I get a third column to the left of the existing left column, and the right column essentially collapses -- the footer moves above it and it's just a mess.

Any ideas what I'm doing wrong?

1) Not in such a way as you could manage them like you can now, no. It would have to be manual template edits, there's lots of information about that both here and on the vbulletin.com forums.

2) If it's a custom layout I couldn't guess how to fix it, you'd have to get someone to give it some personal attention probably. Could try asking the author of the theme the best way to add columns? They're are a pain in the behind to do even on the default layout. You're not doing anything wrong, it's just the way it works. Sorry.

[lefteris]

Hi all

I have install the plugin and setup it normally.

I have setup the script Code given to me from google adsense but the plugin not showing to any thread/forum/topic anything.
I have put the forumid into the plugin but nothing....

What am i wrong?
my website is www.gsmforum.gr/forum/

At the footer i have put the adsense code manually and it works.
I put the following code into the script

<script type="text/javascript"><!--
google_ad_client = "pub-6439519209298156";
google_ad_width = 336;
google_ad_height = 280;
google_ad_format = "336x280_as";
google_ad_type = "text";
google_ad_channel = "";
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

Regards
Lefteris