vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Put Adsense Banners in Your Archive (https://vborg.vbsupport.ru/showthread.php?t=100299)

kenji4861 09-20-2006 08:10 AM

Just wanted to say I'm getting the same error. I'm running 3.5.4

Quote:

Originally Posted by puregraf
hi i went to import product and i got this error can you help?



### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Archive Bottom', 'archive_complete', '$output.=\'\r\n<div align=\"center\" style=\"padding:4px; overflow: hidden;\\\">\r\n<script type=\"text/javascript\"><!--\r\ngoogle_ad_client = \"pub-7556473518368210\";\r\ngoogle_ad_width = 728;\r\ngoogle_ad_height = 90;\r\ngoogle_ad_format = \"728x90_as\";\r\ngoogle_ad_type = \"text_image\";\r\ngoogle_ad_channel =\"\";\r\n//--></script>\r\n<script type=\"text/javascript\"\r\n src=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\">\r\n</script>\r\n</div>\r\n</td><td width=\"15%\" valign=\"top\">\r\n<script type=\"text/javascript\"><!--\r\ngoogle_ad_client = \"pub-7556473518368210\";\r\ngoogle_ad_width = 120;\r\ngoogle_ad_height = 600;\r\ngoogle_ad_format = \"120x600_as\";\r\ngoogle_ad_type = \"text_image\";\r\ngoogle_ad_channel =\"\";\r\n//--></script>\r\n<script type=\"text/javascript\"\r\n src=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\">\r\n</script>\r\n</td>\r\n</tr>\r\n</table>\r\n\r\n\';', 'amykhar_11072005');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Monday, September 18th 2006 @ 06:30:35 PM
Script : http://www.puregraffiti.com/graffiti...ncp/plugin.php
Referrer : http://www.puregraffiti.com/graffiti...?do=productadd
IP Address : *****
Username : puregraffiti
Classname : vb_database


kenji4861 09-20-2006 08:15 AM

Ok, I got it fixed. At least for Version 3.5.4, use the file I attached.

http://www.spoofee.com/forums/archive

Thanks Amy!

Quote:

Originally Posted by puregraf
hi i went to import product and i got this error can you help?



### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'Archive Bottom', 'archive_complete', '$output.=\'\r\n<div align=\"center\" style=\"padding:4px; overflow: hidden;\\\">\r\n<script type=\"text/javascript\"><!--\r\ngoogle_ad_client = \"pub-7556473518368210\";\r\ngoogle_ad_width = 728;\r\ngoogle_ad_height = 90;\r\ngoogle_ad_format = \"728x90_as\";\r\ngoogle_ad_type = \"text_image\";\r\ngoogle_ad_channel =\"\";\r\n//--></script>\r\n<script type=\"text/javascript\"\r\n src=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\">\r\n</script>\r\n</div>\r\n</td><td width=\"15%\" valign=\"top\">\r\n<script type=\"text/javascript\"><!--\r\ngoogle_ad_client = \"pub-7556473518368210\";\r\ngoogle_ad_width = 120;\r\ngoogle_ad_height = 600;\r\ngoogle_ad_format = \"120x600_as\";\r\ngoogle_ad_type = \"text_image\";\r\ngoogle_ad_channel =\"\";\r\n//--></script>\r\n<script type=\"text/javascript\"\r\n src=\"http://pagead2.googlesyndication.com/pagead/show_ads.js\">\r\n</script>\r\n</td>\r\n</tr>\r\n</table>\r\n\r\n\';', 'amykhar_11072005');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Monday, September 18th 2006 @ 06:30:35 PM
Script : http://www.puregraffiti.com/graffiti...ncp/plugin.php
Referrer : http://www.puregraffiti.com/graffiti...?do=productadd
IP Address : *****
Username : puregraffiti
Classname : vb_database


puregraf 09-27-2006 09:25 PM

thank you!!!!

MRGTB 01-16-2007 08:42 PM

How can you add a conditional to this hack so the adsence banners will only be shown to certain usergroups you choose:

IE: Usergroups 1,3,4

Can this be done, or does it not recognize conditionals because it's in the archive pages.

amykhar 01-16-2007 08:49 PM

You can check for usergroup memberships, but not with template conditional syntax.

MRGTB 01-16-2007 08:53 PM

So does that mean you could not use this for example to show the banners to just 3 usergroups then.

Code:

<if condition="is_member_of($bbuserinfo, 1, 3, 4)">
As I'm not sure what you meant in your last post. If that would work, I'm not sure were I would add the code though exactly in the XML file.

amykhar 01-16-2007 09:01 PM

In the plugin, you could use
Code:

if(is_member_of($vbulletin->userinfo,1,3,4)){
}

around any instance of the ad banners. I don't bother with it because my members don't use the archives.

MRGTB 01-16-2007 09:15 PM

yea I know what you mean about members not using the archives, I thoguht about that also. But I think I would still rather exclude the banners from them anyway just in-case. As you never know.

So that code you posted above, would I just wrap that around the adsence code only.

Would it then look like this:

Code:

if(is_member_of($vbulletin->userinfo,1,3,4)){
}

Adsence code
</if>


Greek76 03-21-2007 08:43 AM

Mine only shows in the footer it wont show anywhere else. Any ideas? thanks

BigJimTheLug 03-26-2007 03:15 AM

This is a great modification. Thanks.

Please be sure to remove the author's Google Adsense code and place your Google Adsense code on this modification.

If you are unsure how to do this, download this modification and open it with notepad.

Then look for her codes and replace them with yours.

Thank you.


All times are GMT. The time now is 08:13 PM.

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.01207 seconds
  • Memory Usage 1,746KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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