vb.org Archive - [HTL] and [TEXT] - Ads Management (Customized for vbAdvanced)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)

- - [HTL] and [TEXT] - Ads Management (Customized for vbAdvanced) (https://vborg.vbsupport.ru/showthread.php?t=64297)

Sketch

04-22-2004 10:00 PM

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

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

Sketch

04-23-2004 06:16 PM

Screenshots

Sketch

04-23-2004 06:53 PM

PHP files left out. New zip uploaded.

FleaBag

04-24-2004 05:07 AM

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

Sketch

04-24-2004 02:52 PM

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

Sketch

04-24-2004 03:03 PM

Ergh. Forgot one step.

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

PHP Code:


		
			
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:

PHP Code:


		
			
$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

04-24-2004 03:04 PM

Nice!!

I downloaded and will play with this today.

:):

Sketch

04-24-2004 05:03 PM

Uploaded updates and a new feature

Pro	04-25-2004 03:15 AM

Quote:

Originally Posted by Sketch

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

04-26-2004 12:51 AM

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

04-26-2004 06:35 PM

Quote:

Originally Posted by Sketch

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

Sketch

04-26-2004 07:00 PM

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

04-30-2004 03:45 PM

This looks great, any goetargeting planned?

Sketch

04-30-2004 06:39 PM

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

InsaneContender

05-02-2004 03:40 PM

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

Sketch

05-02-2004 04:12 PM

Insane,

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

Aaron

globalstrata

06-08-2004 10:55 PM

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

06-13-2004 09:49 AM

any updates on this hack?

bandit022

07-11-2004 10:21 PM

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

i could definately use a hack that does such.

-jeff

KW802

08-10-2004 03:52 AM

Quote:

Originally Posted by Sketch

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

10-10-2004 04:03 PM

what i put in the module fields for CMPS?

integra99

10-10-2004 06:20 PM

Check out phpadsnew for a good list of features :)

Blam Forumz

10-10-2004 08:19 PM

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

10-25-2004 02:17 PM

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

I dunno where to put

$sponsors = create_ad();

Blam Forumz

10-31-2004 06:31 PM

bump

Blam Forumz

11-08-2004 05:57 AM

bump ><

Benj	11-08-2004 08:49 AM

this looks cool, looking forward to the new features

joeychgo

11-19-2004 09:54 PM

what happened to this???

Takamine334

11-26-2004 10:15 PM

Is there something like this for just the regular forumhome?

All times are GMT. The time now is 04:44 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01091 seconds Memory Usage 1,774KB 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 (2)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (29)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: