Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
>>--ARROW ADS---> Hack Details »»
>>--ARROW ADS---> Hack
Version: 1.00, by trafix trafix is offline
Developer Last Online: Jul 2008 Show Printable Version Email this Page

Version: 2.3.x Rating:
Released: 04-08-2003 Last Update: Never Installs: 32
 
No support by the author.

Arrow ads is based on and uses some original coding from
VB Banner Control 1.2 created by KarateKid. Thanks mate!

Why Arrow ads? This is the first VB hack that gives you total
control of advertising and sponsorship banners
How long does it take you to add a new banner using your conventional
banner software? It will only take you 30 seconds with Arrow Ads.
Arrow ads also supports mulitpule campaigns.

1) Forum targeting
This gives you the ability to target a nominated forum, arrow ads will automaticly place the
required banner at the top of the sponsored thread list and at the top of every thread within that thread.
It will also add a "Sponsored by xxx" in the forum display list under the title of each sponsored forum.
You can also add these banners to the bannerbank.

2) File tergeting
With this feature you can add sponsorship banners to the top of nominated files eg. usercp.php etc.
the required banner will be displayed at the top of each page of that area.
You can also add these banners to the bannerbank.

If a forum or file is not sponsored a random banner will be displayed from the bannerbank.

3) Bannerbank
If you have an advertiser that just wabts their banner on your site but not sponsoring a page or file,
just select "add to bannerbank" and the ad will be displayed at random if an area of the site is not sopnsored.

ADMIN FEATURES
1) Add
2) Modify
3) Search
4) Stats

In the admin you can view
guestclicks ( how many not logged in guests clicked on the banner )
userclicks ( which user has clicked how often on which banner )
views ( how often is the banner viewed )
date that the banner was added
date that the stats were reset
to save deleting, you can activate or deactivate a banner at amy time.

MEMBER FEATURES
View guestclicks, userclicks and total impressions. Also displays the status of each banner
including:

This Banner is campaign No. 3 and,
was added ~ Today.
was last reset ~ Today.
is Active.
is included in the bannerbank.
is displayed in the US Crowd control forum / directory. (with link to the forum)
or
is displayed in the Members List area (with link to the file)

Members can also reset their banner stats at any time as required.

DEMO: atmyparty.com

SCREENSHOT: Next posts

REQUIREMENTS:

4 X php file alteration
1 X database query
7 X new templates
4 X template modifications

INSTALATION TIME: aprox. 20 - 30 min

Tested on 2.3.0 but should work on all versions.

Don't forget to click on INSTALL
UPDATE - BIG FIX - 24/04/03
Bug fixed - this now stops guests from entering the ad stats area.
Please download the zip again and replace the userreport.php file
UPDATE - changes- 26/05/03
Basicly we are changing the "date added" to "date expired"
to upgrade will take you 5 mins. This is being done to make it easies to see when your ads expire and will be required for the new Arrow ads / VB Trader intergration hack to allow banners to be auto active upon payment via paypal .

~ This hack is Copyright ~
Please note that I reserve the right to code and release this hack for VB3, I have not and will not grant permission for anyone else to code this hack for VB3.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #22  
Old 04-10-2003, 12:06 AM
USODJA's Avatar
USODJA USODJA is offline
 
Join Date: Dec 2002
Location: Arnprior, Ontario, Canada
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No my main forum descriptions are spreading out, if you would turn your ICQ on I could explain better, I have removed most of them to clean it up!
Reply With Quote
  #23  
Old 04-10-2003, 12:08 AM
USODJA's Avatar
USODJA USODJA is offline
 
Join Date: Dec 2002
Location: Arnprior, Ontario, Canada
Posts: 36
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 09:00 PM trafix said this in Post #21
you can fix the excess quirie problem by removing
PHP Code:
//############### >>--Arrow Ads--> by Trafix #############
$showadforumbit $DB_site->query_first("SELECT * FROM ads WHERE forumidnum=$forum[forumid]");
    if (empty(
$showadforumbit[forumidnum])) {
  
$showsponsorforumbit="";
} else {    
if (
$showadforumbit['active'] == 1) {
$showsponsorforumbit="<br><a href=\"click.php?bannerid=$showadforumbit[id]\" target=\"_blank\"><smallfont color=\"#FF0000\" ><b>Sponsored by $showadforumbit[client]</b></smallfont></a>";
}else {
$showsponsorforumbit="";
}

from the index.php

But That would remove the sponsoring of forums right.....
Reply With Quote
  #24  
Old 04-10-2003, 12:15 AM
trafix's Avatar
trafix trafix is offline
 
Join Date: Dec 2002
Location: Australia
Posts: 1,021
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

it would remove the "sponsored by xxxxx" in the forum list yes.

ICQ is on!
Reply With Quote
  #25  
Old 04-10-2003, 12:19 AM
trafix's Avatar
trafix trafix is offline
 
Join Date: Dec 2002
Location: Australia
Posts: 1,021
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

as for the no banners on forum home...you missed adding "$showthisad2" to your header template.....working now!
Reply With Quote
  #26  
Old 04-10-2003, 02:13 AM
trafix's Avatar
trafix trafix is offline
 
Join Date: Dec 2002
Location: Australia
Posts: 1,021
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Today at 06:27 AM Da_GoTTi said this in Post #16
im having a problem running the SQL file...

can you put it in a txt for me what needs to be ran please.
no.1
PHP Code:
CREATE TABLE `ads` (
`
idint(11NOT NULL auto_increment,
`
url_to_bannervarchar(255NOT NULL default '',
`
redirector_urlvarchar(255NOT NULL default '',
`
heightint(11NOT NULL default '0',
`
widthint(11NOT NULL default '0',
`
banner_textvarchar(255NOT NULL default '0',
`
guestclicksint(11NOT NULL default '0',
`
userclicksint(11NOT NULL default '0',
`
viewsint(11NOT NULL default '0',
`
reportuseridint(11NOT NULL default '0',
`
forumidnumvarchar(4NOT NULL default '0',
`
pagenamevarchar(255NOT NULL default '',
`
pagenamedescvarchar(255NOT NULL default '',
`
bannerbankint(2NOT NULL default '0',
`
clientvarchar(255NOT NULL default '',
`
activesmallint(2NOT NULL default '1',
`
addateint(10unsigned NOT NULL default '0',
`
origdateint(10unsigned NOT NULL default '0',
PRIMARY KEY (`id`) 
no.2
PHP Code:
CREATE TABLE `adsclicks` (
`
useridint(11NOT NULL default '0',
`
banneridint(11NOT NULL default '0',
`
clicksint(11NOT NULL default '0',
PRIMARY KEY (`userid`,`bannerid`) 
Reply With Quote
  #27  
Old 04-10-2003, 03:44 AM
trafix's Avatar
trafix trafix is offline
 
Join Date: Dec 2002
Location: Australia
Posts: 1,021
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

what happens when you try to run the quirie.php?

has anybody else had problems with it??
Reply With Quote
  #28  
Old 04-10-2003, 08:11 AM
GoTTi GoTTi is offline
 
Join Date: Jun 2002
Posts: 1,346
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

yea gotta add:

PHP Code:
TYPE=MyISAM
to the bottom ;p)

PHP Code:
CREATE TABLE `ads` (
`
idint(11NOT NULL auto_increment,
`
url_to_bannervarchar(255NOT NULL default '',
`
redirector_urlvarchar(255NOT NULL default '',
`
heightint(11NOT NULL default '0',
`
widthint(11NOT NULL default '0',
`
banner_textvarchar(255NOT NULL default '0',
`
guestclicksint(11NOT NULL default '0',
`
userclicksint(11NOT NULL default '0',
`
viewsint(11NOT NULL default '0',
`
reportuseridint(11NOT NULL default '0',
`
forumidnumvarchar(4NOT NULL default '0',
`
pagenamevarchar(255NOT NULL default '',
`
pagenamedescvarchar(255NOT NULL default '',
`
bannerbankint(2NOT NULL default '0',
`
clientvarchar(255NOT NULL default '',
`
activesmallint(2NOT NULL default '1',
`
addateint(10unsigned NOT NULL default '0',
`
origdateint(10unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
TYPE=MyISAM
PHP Code:
CREATE TABLE `adsclicks` (
`
useridint(11NOT NULL default '0',
`
banneridint(11NOT NULL default '0',
`
clicksint(11NOT NULL default '0',
PRIMARY KEY (`userid`,`bannerid`)
TYPE=MyISAM
Reply With Quote
  #29  
Old 04-10-2003, 08:28 AM
GoTTi GoTTi is offline
 
Join Date: Jun 2002
Posts: 1,346
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is the forum shot without the banner added...

it has made my forum wider then it should be
Reply With Quote
  #30  
Old 04-10-2003, 08:29 AM
GoTTi GoTTi is offline
 
Join Date: Jun 2002
Posts: 1,346
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is what it looks like after I add the banner to the forum.

It makes 2 links.
Reply With Quote
  #31  
Old 04-10-2003, 08:43 AM
GoTTi GoTTi is offline
 
Join Date: Jun 2002
Posts: 1,346
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok im a putz, I see why it @ the top..cuz its a sponsored forum...duh...

so my only problem i see is the double links on the forums that are being displayed...
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:14 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06806 seconds
  • Memory Usage 2,356KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (6)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete