vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   >>--ARROW ADS---> Hack (https://vborg.vbsupport.ru/showthread.php?t=51380)

trafix 04-08-2003 10:00 PM

>>--ARROW ADS---> Hack
 
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.

trafix 04-09-2003 10:52 AM

admin_mod

trafix 04-09-2003 10:52 AM

admin

trafix 04-09-2003 10:54 AM

forum

trafix 04-09-2003 10:55 AM

finnaly...member stats

sabret00the 04-09-2003 11:01 AM

nice hack dude (Y)

Dean C 04-09-2003 11:34 AM

Good hack - did you ask karatekid's permission though ;)

Regards

- miSt

trafix 04-09-2003 11:44 AM

karatekid and I have been exchanging pm's for the last week :)

Davey 04-09-2003 02:27 PM

Nice idea trafix.
Thanks.

Dave.

PS:
[high]* Davey clicks install :)[/high]

trafix 04-09-2003 02:35 PM

I almost forgot to thank Xennon for his helpfull pointers :)

Davey, let me know how it installs.

KarateKid 04-09-2003 02:48 PM

good work :)

trafix 04-09-2003 02:54 PM

Glad you like it!

Rose 04-09-2003 03:13 PM

Your demo link has a typo in it (a comma instead of a period). Very nice hack. :D

Dean C 04-09-2003 03:33 PM

Good good trafix ;)

[high]* Mist is tempted to install (will investigate further tomorrow) :)
[/high]

- miSt

GoTTi 04-09-2003 06:17 PM

your instructions are missing something.

where it says:
PHP Code:

**********************************
OPEN Show Thread Templates showthread
**********************************
------------------
Find
------------------

$header

------------------
REPLACE with
------------------

$header
$showthisad

**********************************
SAVE Show Thread Templates showthread
**********************************


------------------
Add this at the bottom
------------------

$showthisad2

**********************************
SAVE header template
********************************** 

i think you forgot to put
PHP Code:

**********************************
OPEN Show Thread Templates header
********************************** 

below
PHP Code:

**********************************
SAVE Show Thread Templates showthread
********************************** 


USODJA 04-09-2003 07:00 PM

I have wierd spacing in my descriptions, I notice you don't have any sponsored forums with descriptions at your site, I moved the code below description, but my forum home looks wierd!

USODJA 04-09-2003 07:36 PM

I also have no banners showing on forum home!

USODJA 04-09-2003 08:25 PM

I also went from 36 to 72 queries on the main forum!

trafix 04-10-2003 12:02 AM

USODJA

The amount of quiries have increased as the hack is checking each forum that is listed on the forum home for posible sponsors.

Descriptions are for sponsored php files...and used to let the advertiser know exactly where his ads are showing....We all know that memberlist.php is for the members list, it just simplifies it for your advertisers in the stats view area. There is no need for description of sponsored forums as the hack generates the forum title and provides a link to it in the stats area

No banner on forum home page.....i will investigate.

Da_GoTTi

im not sure why you are having problems with the quirie script but i will put together a text incert version for you soon.

Re instructions....sorry yes i will also ament that in the zip soon as well.

Rose

Thanks.....link fixed

miSt

Where are you having problems?

trafix 04-10-2003 12:06 AM

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

USODJA 04-10-2003 12:06 AM

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!

USODJA 04-10-2003 12:08 AM

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.....

trafix 04-10-2003 12:15 AM

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

ICQ is on!

trafix 04-10-2003 12:19 AM

as for the no banners on forum home...you missed adding "$showthisad2" to your header template.....working now!

trafix 04-10-2003 02:13 AM

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`) 


trafix 04-10-2003 03:44 AM

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

has anybody else had problems with it??

GoTTi 04-10-2003 08:11 AM

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


GoTTi 04-10-2003 08:28 AM

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

it has made my forum wider then it should be

GoTTi 04-10-2003 08:29 AM

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

It makes 2 links.

GoTTi 04-10-2003 08:43 AM

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...

trafix 04-10-2003 08:43 AM

send a link to your forum via pm

trafix 04-10-2003 08:49 AM

if you have double links you must have added the $showsponsorforumbit call twice in the template accedently

trafix 04-10-2003 08:57 AM

no..only Y! and ICQ

GoTTi 04-10-2003 08:59 AM

i see multiple $showsponsorforumbit in templates, ill redo templates and see if that works.

GoTTi 04-10-2003 09:07 AM

ok got it to work...

there is 1 space though in the Sponsor by area on the forum...how do i remove that space?

GoTTi 04-10-2003 09:09 AM

OH...and in your instructions, you have problem...example:

**********************************
OPEN Forum Display Templates: forumdisplay_forumbit_level1_post
**********************************

**********************************
OPEN Forum Display Templates: forumdisplay_forumbit_level2_post
**********************************

you have open twice back to back, it should say SAVE after the command is inserted into the templates

trafix 04-10-2003 09:15 AM

ok...thanks fixed the instal instructions

as for the gap

remove the break tag in each template...i will amend the zip with this adjustment.

PHP Code:

<br><smallfont>$showsponsorforumbit 


GoTTi 04-10-2003 09:19 AM

br was removed, gap is still there.

trafix 04-10-2003 09:56 AM

zip file updated!

Xyphen 04-10-2003 11:07 PM

wow very nice and useful hack, keep it up!


All times are GMT. The time now is 05:50 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.01493 seconds
  • Memory Usage 1,877KB
  • 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
  • (11)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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