[HTL] and [TEXT] - Ads Management (Customized for vbAdvanced)

[Sketch]

Version: 1.0.2b
vB-version: 3.0.0
Developer: Sketch
Install difficulty: Easy
File edits: 7
Template edits: 1

Description of the Hack:
This Hack was designed to allow sponsors to be listed and clickthroughs tracked. The hack is limited in scope in that it does not yet monitor IPs or take image uploads. Features will be added in later releases

Recent Updates:
24 April 2004
-Errant function call fixed
-Click-through report Added
25 April 2004
-Scheduled Task Support allowing Admin to designate intervals for featured sponsor


HACK INSTALLATION DETAILS:
New files for this Hack:
admincp/adsmanagement.php
sponsor.php
includes/cron/adscron.php

Files modified for this Hack:
includes/adminfunctions.php
includes/function.php
admincp/index.php
adv_index.php (vbAdvanced index) - strictly optional


Templates modified for this Hack:
index_custom2 (optional)

New DB tables for this Hack:
ads_sponsors

DB Tables modified for this Hack:
usergroup
language

New DB columns for this Hack:
language.phrasegroup_ads



This post was generated by the Hack Tracking Log (https://vborg.vbsupport.ru/showthread.php?t=60735)

[Sketch]

Screenshots

[Sketch]

PHP files left out. New zip uploaded.

[FleaBag]

This is excellent, thanks. I'll get this installed now. :)

[Sketch]

Already working on some addedfunctionality. I'll let you know more. Please report any bugs you find.

[Sketch]

Ergh. Forgot one step.

Open includes/functions:
GO TO END BEFORE ?> AND ADD


function create_ad()
{
global $DB_site;
$sponsor = $DB_site->query("SELECT * FROM ads_sponsors ORDER BY RAND(NOW()) LIMIT 1");
$sponsor = $DB_site->fetch_array($sponsor);
return $sponsor;
}

You can call this add on any page by doing:

$sponsors = create_ad(); and the referring to the field values of the database by $sponsors[id], $sponsors[sponsor], $sponsors[www], $sponsors[logo], $sponsors[clicks].

Hope that helps

[Christine]

Nice!!

I downloaded and will play with this today.

:):

[Sketch]

Uploaded updates and a new feature

[Pro]

Uploaded updates and a new feature
hmmm... sounds interesting. I think i'll wait for a few days before i get to this though. Sounds nice though!

[Sketch]

Okay no problem. ;) I understand but I could use people to beta test and let me know if theres problems - not to mention additional features that other admins might want but I haven't considered because I don't need them.

At any rate, beta3 is now live and updated. New feature for this release is tying the ads rotation in with the cron system to allow Admin to designate duration of time for each featured ad.

Aaron

[CarolinaKid]

Okay no problem. ;) I understand but I could use people to beta test and let me know if theres problems - not to mention additional features that other admins might want but I haven't considered because I don't need them.

At any rate, beta3 is now live and updated. New feature for this release is tying the ads rotation in with the cron system to allow Admin to designate duration of time for each featured ad.

Aaron
Getting this error when trying to delete any ideas Could not find ads_sponsors with ads_sponsorsid = 1.

[Sketch]

That id of number 1 should be in your database ads_sponsors table. If you want me to look, pm me your server/mysql info....

[gmarik]

This looks great, any goetargeting planned?

[Sketch]

No, I don't see a purpose for geotargetting in this hack. Maybe you have an idea I haven't thought of though?

[InsaneContender]

Can you limit this to which usergroups see the ad and which ones do not? If so, I would definatly use this.

[Sketch]

Insane,

Feel free to modify it. I might do that later, but I'm not feeling it right now. :)

Aaron

[globalstrata]

Awesome!! :banana:

Here are some features that I think it would be really beneficial:

1. Capability to tie the advertisement to a user, so for example user1 wants me to advertise his site, then in the Admin CP, I add the Ad Name, URL, picture and User1. Then User1 can see in his own User CP, how many clicks his advertisement has had.

2. In addition, it would be beneficial to have a field for charges, so say that I charge user1 $10 per month to advertise, then every month, few days in advanced, the user is either PM, emailed or both with an invoice or a link to cancel advertisement.

3. Category field -> that way one can specify what category is show on which page

4. Minimum and Maximum impressions -> a way to define amount of impressions that will be done for the Ad. This way, this way the system can stop showing certain images when the maximum is reached and this way allow other images to be shown more often.

5. Random Generator Ads. It will need to be programmed taken into consideration #3 and #4 above.

Insane's idea sound really good too!

Hope this helps,

Gladys

[Osterling]

any updates on this hack?

[bandit022]

i would really like to see globalstrata's suggestions put to use!

i could definately use a hack that does such.

-jeff

[KW802]

No, I don't see a purpose for geotargetting in this hack. Maybe you have an idea I haven't thought of though? Regional advertising for businesses who aren't national. :nervous:

[Blam Forumz]

what i put in the module fields for CMPS?

[integra99]

Check out phpadsnew for a good list of features :)

[Blam Forumz]

-_- I wanted to know if this could work with vba CMPS as I ave it installed, just that i cant get the last 2 steps done

[Blam Forumz]

I dont get it, how can i put this on the FORUMHOME template?

I dunno where to put

$sponsors = create_ad();

[Blam Forumz]

bump

[Blam Forumz]

bump ><

[Benj]

this looks cool, looking forward to the new features

[joeychgo]

what happened to this???

[Takamine334]

Is there something like this for just the regular forumhome?