>>--ARROW ADS---> Hack

[trafix]

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 (http://www.atmyparty.com/network/)

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]

admin_mod

[trafix]

admin

[trafix]

forum

[trafix]

finnaly...member stats

[sabret00the]

nice hack dude (Y)

[Dean C]

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

Regards

- miSt

[trafix]

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

[Davey]

Nice idea trafix.
Thanks.

Dave.

PS:
* Davey clicks install :)

[trafix]

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

Davey, let me know how it installs.

[KarateKid]

good work :)

[trafix]

Glad you like it!

[Rose]

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

[Dean C]

Good good trafix ;)

* Mist is tempted to install (will investigate further tomorrow) :)

- miSt

[GoTTi]

your instructions are missing something.

where it says:

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

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

below

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

[USODJA]

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]

I also have no banners showing on forum home!

[USODJA]

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

[trafix]

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]

you can fix the excess quirie problem by removing
//############### >>--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]

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]

Today at 09:00 PM trafix said this in Post #21 (https://vborg.vbsupport.ru/showthread.php?postid=379953#post379953)
you can fix the excess quirie problem by removing
//############### >>--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]

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

ICQ is on!

[trafix]

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

[trafix]

Today at 06:27 AM Da_GoTTi said this in Post #16 (https://vborg.vbsupport.ru/showthread.php?postid=379804#post379804)
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
CREATE TABLE `ads` (
`id` int(11) NOT NULL auto_increment,
`url_to_banner` varchar(255) NOT NULL default '',
`redirector_url` varchar(255) NOT NULL default '',
`height` int(11) NOT NULL default '0',
`width` int(11) NOT NULL default '0',
`banner_text` varchar(255) NOT NULL default '0',
`guestclicks` int(11) NOT NULL default '0',
`userclicks` int(11) NOT NULL default '0',
`views` int(11) NOT NULL default '0',
`reportuserid` int(11) NOT NULL default '0',
`forumidnum` varchar(4) NOT NULL default '0',
`pagename` varchar(255) NOT NULL default '',
`pagenamedesc` varchar(255) NOT NULL default '',
`bannerbank` int(2) NOT NULL default '0',
`client` varchar(255) NOT NULL default '',
`active` smallint(2) NOT NULL default '1',
`addate` int(10) unsigned NOT NULL default '0',
`origdate` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)

no.2
CREATE TABLE `adsclicks` (
`userid` int(11) NOT NULL default '0',
`bannerid` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
PRIMARY KEY (`userid`,`bannerid`)

[trafix]

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

has anybody else had problems with it??

[GoTTi]

yea gotta add:


) TYPE=MyISAM;


to the bottom ;p)


CREATE TABLE `ads` (
`id` int(11) NOT NULL auto_increment,
`url_to_banner` varchar(255) NOT NULL default '',
`redirector_url` varchar(255) NOT NULL default '',
`height` int(11) NOT NULL default '0',
`width` int(11) NOT NULL default '0',
`banner_text` varchar(255) NOT NULL default '0',
`guestclicks` int(11) NOT NULL default '0',
`userclicks` int(11) NOT NULL default '0',
`views` int(11) NOT NULL default '0',
`reportuserid` int(11) NOT NULL default '0',
`forumidnum` varchar(4) NOT NULL default '0',
`pagename` varchar(255) NOT NULL default '',
`pagenamedesc` varchar(255) NOT NULL default '',
`bannerbank` int(2) NOT NULL default '0',
`client` varchar(255) NOT NULL default '',
`active` smallint(2) NOT NULL default '1',
`addate` int(10) unsigned NOT NULL default '0',
`origdate` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;



CREATE TABLE `adsclicks` (
`userid` int(11) NOT NULL default '0',
`bannerid` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
PRIMARY KEY (`userid`,`bannerid`)
) TYPE=MyISAM;

[GoTTi]

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

it has made my forum wider then it should be

[GoTTi]

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

It makes 2 links.

[GoTTi]

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]

send a link to your forum via pm

[trafix]

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

[trafix]

no..only Y! and ICQ

[GoTTi]

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

[GoTTi]

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]

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]

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.

<br><smallfont>$showsponsorforumbit

[GoTTi]

br was removed, gap is still there.

[trafix]

zip file updated!

[Xyphen]

wow very nice and useful hack, keep it up!

[trafix]

Today at 11:01 AM AViO 07 said this in Post #40 (https://vborg.vbsupport.ru/showthread.php?postid=380393#post380393)
wow very nice and useful hack, keep it up!


Thanks for your kind words, i have been getting heaps of great feedback on this one :) I used to use phpadsnew, fantastic software but was sort of confusing and took me ages to add a new banner and I couldnt put up with it anymore.
Its a shame that they are not doing "hack of the month" at the moment :(

[trafix]

Don't forget to click on INSTALL

[ricoche]

Wow, another excellent hack!! Actually I've been interested in something like this for a long time.

Everything installed perfectly too.

Thanks Trafix for yet another wonderful hack! I must say your choice of projects has been excellent.

Take it easy,

Ricoche

[NuclioN]

Great addition ;) Clicks install

When you add a banner on forum id, i see that the banner shows up in each forum but with just the 'Please support our sponsors' text. How you make it so this banner will only show up in the forum that is specified?

--oops-- i've found it. Just don't add it to the bannerbank. :)

[NuclioN]

--edit-- problem solved. I shall now reply after counting to 10 :p

[trafix]

oh you are funny

[PurpleCow]

hello,

Does this work only for banner ??

Can I also run HTML ads using this hack ??

Thanks

[trafix]

ummm, at the moment it only displays images of any size...

[PurpleCow]

could you come up with a addon for handling HTML ads also ??

Thanks much

[dirtymerc]

I have had the worst expierence I have ever had installing a hack with yours. For the first time I forgot to back things up and now my whole site has been down for about 15 hours. For my users, thats terrible.

I cant figure out how to fix this error in my mysql.

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT * FROM ads WHERE pagename='index.php'
mysql error: Unknown column 'pagename' in 'where clause'

mysql error number: 1054

Date: Saturday 12th of April 2003 11:48:16 AM
Script: http://www.wrxyz.com/forums/forums/
Referer: http://www.wrxyz.com/

I even tried upgrading to vbulletin2.3.0 from 2.2.9 to try and see if it would work. But to my luck it didnt. I have no clue what to do, im not sure why the script is going to wrxyz.com/forums/forums/ Thats not even a directory. Please help me.

[dirtymerc]

Trafix or anyone if you have aim please im me at: x1nsaneity . I am having the worst time right now, my marketing ad companies are emailing me asking where the site is, and I dont know what to say.

[trafix]

Have you run the qury from the admin folder,
This performs database changes required by the addow hack

[trafix]

sorry i dont have aim

[dirtymerc]

Yeah I did, but I was already karatekids hack and had banners and an ads in my db. So I dropped the existing one to add yours, and then thats when all the problems started.

[dirtymerc]

trafix, is there anyone I can contact without vb.org?? I really need some help

[dirtymerc]

................................................no thing......................... .............. bump

[trafix]

Although it's based on karate kids hack, all the coding and data base tables are different. Try dropping the banner tables again and make sure that karate kids has been dropped as well. I am really not sure what else to suggest. Try this and see how it goes. Just double check the coding has been added correctly to the files and templates.
Regards
Trafix.

[Imprezer]

Installed and so far so good.

Can I have 2 diff banners rotating in one forum?

Thank you!

[trafix]

As you add banners, to make them rotate within "unsponsored" forums, you must add them to the banner bank.
If you are wanting "2" sponsored banners to rotate in one forum, no, it's not set up for that. Just the one banner will be displayed for sponsored areas.
Regards
Trafix.

[Imprezer]

Arg!

Too bad. This is a great hack but I think that to make it the ultimate hack, single forum banner rotation is needed.

Since this hack can already rotate random banners throughout the whole site, it cannot be too hard to set it up to rotate selected banners in selected forums.

[trafix]

hmmm....your right, it should be easy...let me put it together (soon)

[GoTTi]

dunno if it matters much but:

in template modifiy in your instructions, you have:


**********************************
OPEN Forum Home Page Templates: forumhome_forumbit_level2_post
**********************************

------------------
Find
------------------

<normalfont><b>$forum[title]</b></normalfont></a>

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

<normalfont><b>$forum[title]</b></normalfont></a><br><smallfont> $showsponsorforumbit</smallfont>

**********************************
OPEN Forum Home Page Templates: forumhome_forumbit_level2_post
**********************************


this code:

]</b></normalfont></a><br><smallfont> $showsponsorforumbit</smallfont>

has a spacr in:

<smallfont> $showsponsorforumbit

should be: <smallfont>$showsponsorforumbit

[GoTTi]

how do i take that extra space out of the forum again? I 4got lol

[GoTTi]

im having a problem with the rotation of the banners...

its like...only showing 1 banner instead of going threw the list...even when i click refresh...

any ideas?

[Imprezer]

Read back a page.

Only one banner will show in a selected forum unless you place them in the banner bank, but then they will randomly rotate in random "unsponsored" forums.

[GoTTi]

yea i got them all in teh banner bank, but only like 1 is showing out of 5 or 6

[Imprezer]

Oh, nm, then. Sorry. Can't help ya here. ;)

[solent]

everything worked liked a charm except this problem see attchament.

well i dont know which template to edit to fix it so if you could please tell me where to look and what to fix in order to get the margins right i will really appricate it.

By the way that is one excellent hack. very good job trafix. keep it up :D :D :D

[kingd]

Is it possible to show two different banners simultaneous with this hack?

[trafix]

ummm, probibly yes would require some further modification. Are you looking for another banner in the footer???? obviously spocered forums and files would have to be the same banner. I will look into it for you, it shouldnt be too dificult though

[kingd]

I was looking in having 2 banners in the header

thanks a million

[SpeedStreet]

Trafix,

I got it installed, and it is working great. I'm not running the 'Sponsored By' link in the main index, for fear of mass query buildup.

However, the ads only appear to be showing up in my Forumhome...nowhere else. I have $showthisad2 in my header, and $showthisad in the appropriate places. I'd like all ads that are in my bannerbank to rotate throughout my entire forum, am I going about it the right way?

http://www.speedstreet.org/forums

[trafix]

Ok the banner is showing on all pages except the forums. I checked your search, who online page etc and the banner is there but not in the forums.....ummmm you said that you feft out coding to avoid excess quiries.. this is your problem as the templates are there in the forums its just not showing the banner.. I suggest that you replace the code to the forumdisplay.php and showthread.php. Please see earlier posts (maybe first page) I made a suggestion to USODJA on what to remove to avoid the quiries.

[SpeedStreet]

Right-o.

I do in fact have the code for showthread and forumdisplay added...I only removed said code for index.php.

I'll check again, to be sure, but I am pretty sure it is there.

Does $showthisad overide $showthisad2?

[GoTTi]

got a problem pal....

I noticed today that Guest users can see the userreport.php threw the site, and can reset all the stats on each banner.

That is no good dude and needs to be fixed. I removed the 0 from the User Group, and it puts it right back in.

[trafix]

thanks Da_GoTTi,

Bug fixed, see first post

[GoTTi]

noticed another problem....

when a sponsor is placed on a forum...the forum is accessed, the banner displays in the forum...

now the problem:

it doesnt hold in the threads! it shows the random banners in the threads inside the sponsored forum. It should have the sponsored forum inside the threads where the forum is placed right?

[trafix]

I have had a surf around my site and noticed that when you click on the "goto last post" go button on the forum list, the banner does not show when you get there......

The ulr link os correct when i look at the source code of the forum home, here is an example of complete source code from http://www.atmyparty.com/network/forumdisplay.php?forumid=20

The code in blue is the thread title and contains the forumid no. and displays the sponsorship banner at the top when clicked on.

However the red code is the lastpost title / go button link and also contains the forumid no. BUT when clicked on the forumis part of the link is not in the ulr address when the page is displayed ........ Something somewhere is stripping it thus a random banner is displayed instead of the sponsorship banner.

I cant find where this stripping is taking place or why .... can anyone assist?

<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td valign="top"><img src="images_party/off.gif" border="0" alt=""></td>
<td><img src="images_party/clear.gif" width="9" height="1" alt=""></td>
<td> <a href="forumdisplay.php?forumid=27"><font face="verdana, arial, helvetica" size="2" ><b>Crowd Con. - Questions & Support</b></font></a> (0 users browsing)<br><a href="http://www.atmyparty.com/network/click.php?bannerid=6" target="_blank"><font face="verdana,arial,helvetica" size="1" color="#FF0000" ><b>Sponsored by Wizid Pty Ltd</b></font></a><font face="verdana,arial,helvetica" size="1" > </font><br>
<font face="verdana,arial,helvetica" size="1" ></font></td>
</tr>
</table>
</td>
<td bgcolor="#CCFFFF"><font face="verdana, arial, helvetica" size="2" >3</font></td>
<td bgcolor="#FFFFCC"><font face="verdana, arial, helvetica" size="2" >1</font></td>
<td bgcolor="#CCFFFF"><font face="verdana,arial,helvetica" size="1" > <table cellpadding="0" cellspacing="0" border="0" width="100%" id="ltlink"><tr align="right">
<td nowrap><font face="verdana,arial,helvetica" size="1" ><b> <a href="showthread.php?forumid=27&goto=lastpost">Any Questions Or Queries, Pl...</a></b><br>10-04-2003 <font color="#000088">01:31 AM</font><br>
by <a href="member.php?action=getinfo&find=lastposter"><b>The4Gotton1</b></a></font></td>
<td nowrap>&nbsp;<a href="showthread.php?forumid=27&goto=lastpost"><img src="images_party/lastpost.gif" border="0" alt="Go to last post"></a></td>
</tr></table>

Other reasons for the sponsorship banner not being displayed would be due to the links in the templates

Suggestion:

Do a template search for
threadid=$thread and make sure that &forumid=$forumid has been included in the link.
you might have to use &forumid=$XXX[forumid]
Depending on the template and the db variables ...i am currently going through me site to fix the bugs and will update file then they are ironed out.

All input is welcome!

[Greivog]

How do i get the Banners to be displayed at random on the pages?

I have them added to the banner bank, but it only displayes one of the banners no matter how many times i visit the page?

Any suggestions

You can View it at

Http://www.uk-muscle.co.uk

Cheers

Paul

[trafix]

Paul ... the banners currently showing at the top of pages are not produces by arrow ads .... remove your current banners to start with.

add the $showthisadd and $showthisadd2 as instructed in the directions ....

this should fix your problem

PS i love the pig

[RetroDreams]

For those of you who have this installed... is this working well for you? I'm tempted to install, but need to verify that it works well and without sacrificing the speed of my site.

Comments and feedback appreciated.

[RetroDreams]

Trafix,

I installed your hack without any problems. I made the edits as posted on page 1 to eliminate the extra queries (as I have many forums) - so now everything works semi-okay.

I don't get any banners in the Forumdisplay and showthread pages at all when I use the tag in my $header template as opposed to in the actual page after the $header... Why is that? I'd really prefer it this way so the design of my page wouldn't be compromised.

Also, the banner is in the bannerbank. How could I mod it so this could be done?

http://www.basketballboards.net/forum/images/wanted.gif - How I want it to look.

http://www.basketballboards.net/forum/images/unwanted.gif - How it looks.

[Koutaru]

I would also like something for the header before I install this :)

BTW, how many queries does this add? Oo;?

[solent]

Yesterday at 12:59 AM RetroDreams said this in Post #81 (https://vborg.vbsupport.ru/showthread.php?postid=393904#post393904)
For those of you who have this installed... is this working well for you? I'm tempted to install, but need to verify that it works well and without sacrificing the speed of my site.

Comments and feedback appreciated.

dude traffix is your man. i have it installed and it works like a charm. no problems at all. it doesnt slow my boards, and i must say is one of the coolest hacks i have install in my boards. if you need to have ads and using banners in your vb this is the best one. have try them all. have even try 3rd party but this one. omg it owns especially the administration you have.

i would recommend installing this one 100%

[Anjie]

I installed, and I must say it is simply awesome. I did remove the sponsored by under the names on forumhome, but that was more for asthetics than anything else. It did not slow the forum down at all.
The one thing that I did notice is that unless you specify a banner for a forum, the banner bank will show the last banner you put into the bank the most. 75% of the time or more. I would love to see the banners rotate within a page view rather than on page load and randomized.
Other than that, once a banner is specified to a forum it works like a charm! One of the absolute best I must say. We've actually had an advertiser tell us they even liked it! Doesn't get much better than that.
I did some changing of font colors and the like, but nothing really to change the program on its own merits. All in all a 5 star program for sure!
If you would like to see this program in action working quite well, here it is: http://www.theladiesconnection.com/vbulletin/upload/index.php just click on any forum, and there it will be.
Also one of the absolute best for support and assistance around! Can't say enough about this program and the creator!! :D :banana:

[vB-Host.com]

trafix, can this be used as a footer banner throughout one's site?

[trafix]

Sorry, I havnt responded sooner guys!

Firstly, thanks for your raves :)

@ vb-host

Year sure you can put them at the top and the bottom if you want!

Its just a matter if where you put the strings "$showthisad" and "$showthisad2"

@ RetroDreams

Sorry i mis-understood your earlier point.
NO, banners dont self rotate in forums, i left this out on purpose as it realy guves advertising clients fasle stats. say somebody is surfing around your site and the phone rings ... he is talking for an hour, your window is still open but he might bo off elsewhere doing other things on the internet .... what happens...the banners still rotate and clock up the impressions .... but the guy on the phone isnt looking at it. it is my opionion that this provides you advertisers with fasle stats.

I intend to do a version 2 of this in the future, but I have spent the last 2 weeks on my VB Trader hack and stage i is so close to being released, i cant wait :) (its bloody huge)

[RetroDreams]

No, I wasn't talking about rotating... I just wanted to know why I couldn't use it in the header as opposed to not in the header? The ads don't show up when I place the $showthisad in the header... it's just blank.

See my pictures for what I'm talking about.

[Guidster]

Ok, first off, great hack! I think this is probably one of the finest hacks yet! Simple, elegant and EXTREMELY effective. Thanks.

Guidster clicks install!!

[Guidster]

Trafix,
I sent you a PM about the possibility of integrating Arrow Ads into the Xenon/Skuzzy search engine spider archive to take advantage of the product exposure this would make possible.

Anyone else share this thought that it would be a excellent place to capitalize on the raw traffic brought to the site by the search engines and spiders? On my forums, this would mean that a couple of thousand unique visitors would view the ad and mostly unregistered traffic at that!

[trafix]

Firstly, im sorry for not giving replies here for a while as i have been so flat out on VB TRADER.

@ Guidster

Did you manage to fix your problem??

Secondly, I want to thank everyone for their responses and great raves :)

The future of Arrow Ads.....

I am planning some big things for arrow ads..

1) Change the banner url to image upload instead of direct link.

2) Make the banner modifyable by the advertiser. They will be able to activate / de-activate the banner of change the banner image if required.

3) The intergration of VB Trader. I will build an addon so members can pay by Paypal for their advertising costs and then once they have paid, they will then be able to upload their banner to the arrow ads system so once they have finished the banner will be automaticly added to the banner bank :)

Less work and more money for you :cool:

If they want to sponsor a foum or php file you will still have to do that manualy.

Trafix

[Guidster]

I was not really reporting a problem, I am just trying to integrate Arrow Ads into the Archive Hack by Xenon and Skuzzy as I get at least 1000 visitors to my archive per day. These are views and potential clicks that I would like to capitalize on.

This hack uses a couple of php files to feed search engine spiders .html instead of dynamic content. As a result, many people come to the archive. Just trying to leverage some more exposure for my advertisers.

Thanks,

[trafix]

Ok I will look into that intergration with the next version of arrow ads :)

With the intergration of VB Trader and arrow ads simply means that I have to do some updating of the arrow ads code.

Arrow Ads will still be free

The intergration coding to allow your members to buy, upload and activate their own banners will all be added to VB Trader.

[DannyITR]

I have a problem. I don't want any forum specific banners. I added them all to the banenr bank it doesn't rotate evenly at all. Can you help me? I have another VB where it does work fine so I know I installed it correctly. Could another hack be affecting it? I made sure to completely remove VB_Advert Management.

The whole reason I installed this hack was because the VB_Advert management stopped rotating the ads. I'm so frustrated right now.

My board is http://forums.montrealracing.com

Thanks

[DannyITR]

Here is a sample of stats for about 2 hours:

http://forums.montrealracing.com/images/misc/arrow1.jpg


http://forums.montrealracing.com/images/misc/arrow2.jpg

[trafix]

hmmm,

Ok so you have 1 version working properly and another that is not .....

I dont think it would be affected by other hacks.

The only thing I could put it down to is maybe the version of php that the server is running.

The system on my site works fine, however others have reported similar problems as you have. The version of php running ion the server could affect the random adility but im not totly sure.

[PurpleCow]

trafix : Can you give the hack capability to serve HTML ads also ?? like the ones we see on site point forums.

[trafix]

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 .

[kcradio]

The last thing you need to do is add this code to link to your stats page,

<a href="userreport.php?s=$session[sessionhash]">Add Stats</a>

---- What is this and where does it go?

[trafix]

ok this is a link to where banner owners can view their banner stats.

you can put this whereever you like, maybe in the use cp or the footer. Maybe you have a list of members links.

[Dribbles]

Is there a way I can use a simple code to place banners anywhere I want instead of fixed positions? ie- something like $bannerhere ... that way I can sort of mix them up using the same code in between posts, in the header, and even use the sig mod to add them to some usergroups' sigs.

For instance, I see:

$showsponsorforumbit
$showthisad

Is $showthisad just the universal code for the banner bank? I won't be using forum sponsors, forum-specific banners, etc etc. Just a banner bank with maybe a rotation of 8-10 banners. Is $showthisad the only one I need to add to the header, postbit, sigs, etc etc? thanks :)

[trafix]

you can ust the "$showthisad2" anywhere (in theory)

[Dribbles]

thanks :) $showthisad2 with a 2 at the end as opposed to the $showthisad one?

[trafix]

yep the same string as you put in the header

[Dribbles]

thnx a million

[DannyITR]

i found this. Mabye it has something to do with my randomization problem.


http://www.mysql.com/doc/en/Mathematical_functions.html
"As of MySQL 3.23.52, MySQL changed the way
RAND() functions, such that you MUST supply a
SEED to get an actual random number. If you do
not, each new connection will return close to the
same number as the previous new connection. An
example to test this would be to run the follow
command multiple times in a row. mysql -u
username -p -e'select rand()' A basic way to seed
this would be to run RAND(NOW())."

... maybe that's why !?

i tried it manually with rand(now()) and it always returns ad # 11 .. so
that's no good either

[DannyITR]

anyone?

[DannyITR]

It was my mysql version.

Are there banner hack for VB3 betta?

[trafix]

apparently...

VB3 Gold may have optional banners advertising

[DannyITR]

Do you think this hack can be adapted to vb3?

[sumofallfears]

i just have one question. what is the forum id for the index.php page?

I want to have a banner placed at the main index.php page when users enter the forum.

[fly]

The last thing you need to do is add this code to link to your stats page,

<a href="userreport.php?s=$session[sessionhash]">Add Stats</a>

What does this mean?

EDIT: And how can I move where the ad is at? I'd like it to be in the right corner, above the buttons.

[sumofallfears]

i just have one question. what is the forum id for the index.php page?

I want to have a banner placed at the main index.php page when users enter the forum.
never mind i firgured it out. I thought the banner would be placed in the forum in which the sponsor was placed.

[dcevoclub]

so there is no banner option for vb3 yet?

[Max Power69]

I am trying to install this hack and I keep running into this error:

Parse error: parse error, unexpected $ in /home/tony/www/xxxxxx.net/forums/admin/arrowadsquery.php on line 62

I have gone over everything at least 10 times and I just can't figure out what I am doing wrong. Any help would be appreciated.

Thanks

[Greivog]

Is there a way to make this show random banners?

Thanks

Paul

[trafix]

so there is no banner option for vb3 yet?
No i will not be porting this for vb3 ..... It is roumered that vb3 gold will have banners as a standard feature :)

[kctalker]

with the rumor squashed, any chance of getting this for VB3 or someone that had permission that has already done it?

[trafix]

with the rumor squashed, any chance of getting this for VB3 or someone that had permission that has already done it?
hmmm, i can think about it ... but my paying clients come first, I have quite a bit on atm

[WickedVixsen]

I have this installed and it worked great for awhile, but now all my banners are showing up as red x's - any idea why it might be doing this ?

I've checked and the links to the banners are valid - even tried adding a new banner in a forum and it still comes up as a red x

[GregFromWASP]

Installed today, Working great so far.

~Thanks!

[GregFromWASP]

Im having a problem figuring out how to add sponsors to forums. How do you know which forum is what ID #????