[ABD] Advertisement Manager (MMW)

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Chrisjustinparr
Registered User
Posts: 29
Joined: Fri May 13, 2005 5:06 pm

Post by Chrisjustinparr »

Thank you for working on this! I have been waiting for this forever. Right now I'm using the inline ads mod.
djsclaus
Registered User
Posts: 101
Joined: Mon Nov 15, 2004 3:07 am

Post by djsclaus »

Oh, and i don't think 4 tables would be that bad. The server executes it in one script anyway, and you could even include an install file that automatically does the SQL coding so you don't have to mess with PHPMyAdmin

But, i would agree with a few that simpler is better :)
-SV-
Registered User
Posts: 39
Joined: Tue Aug 23, 2005 9:41 am

Post by -SV- »

LimitForums wrote: for the ads table i would probably go with this:-
  • phpbb_ads
  • ad_id
  • ad_type
  • ad_position
  • ad_name
  • ad_description
  • ad_link
  • ad_image
  • ad_expires
  • ad_enabled
  • phpbb_ads_statistics
  • stat_id
  • ad_id
  • user_id
  • user_ip
  • stat_date

Ah! Thank you. You just gave me an idea, and a different direction to take this in.

Here's how the table structure is looking atm:

Code: Select all

CREATE TABLE ads (
ad_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ad_type ENUM('Banner', 'Textad', 'Affiliate'), # -- Affiliate - I.E: YPN or Adsense -- #
ad_position ENUM('Header', 'Footer', 'Sidebar'),
ad_name VARCHAR(100) NOT NULL,
ad_description VARCHAR(100) NOT NULL,
ad_link VARCHAR(100) NOT NULL,
ad_image VARCHAR(100) NULL,
ad_code TEXT NULL,
ad_expires INT UNSIGNED NOT NULL,
ad_enabled ENUM('Yes', 'No')
);

CREATE TABLE ads_statistics (
stat_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
ad_id INT UNSIGNED NOT NULL,
user_id INT UNSIGNED NOT NULL,
user_ip CHAR(8) NOT NULL,
stat_date INT UNSIGNED NOT NULL
);
GameraFan
Registered User
Posts: 20
Joined: Mon Jan 30, 2006 9:41 pm

Post by GameraFan »

I'll second the suggestion to add a weight field so that certain ads can be shown more often than others.
LimitForums
Registered User
Posts: 533
Joined: Tue Sep 03, 2002 11:01 am
Location: UK
Contact:

Post by LimitForums »

If you want any help on this mod feel free to give me a shout.
-SV-
Registered User
Posts: 39
Joined: Tue Aug 23, 2005 9:41 am

Post by -SV- »

Hey ya'll

Thought i'd post a little 'update'. I've been busy the past week or so, so haven't got to work on this MOD much, however, I expect to be able to release some code here for testing in about a week. I know that alot of folks want this type of MOD, i've even gotten a few emails about it (:|), just understand I have a lot going on and sometimes my paid projects have priority over my phpBB MODS ;)

Thanks,
Eric
User avatar
Elias
Registered User
Posts: 5137
Joined: Sat Feb 25, 2006 4:31 pm
Location: In the Water!
Name: Elias

Post by Elias »

Would be nice if you can set a timer to a Banner. Sends you a PM telling you it will expire in X days. So you can get ready to re-new it.

Like that you can advertise other people for X days and for X money...
"Mystery creates wonder, and wonder is the basis of man's desire to understand." - Neil Armstrong
|Installing Extensions|Writing Extensions|Extension Validation Policy|
Offering private web hosting. Contact me for details.
User avatar
vrflyer
Registered User
Posts: 503
Joined: Mon Feb 17, 2003 8:27 pm

Post by vrflyer »

Intrested & intresting indeed, keeping eye on this one... 8)
Always Under Construction !
-SV-
Registered User
Posts: 39
Joined: Tue Aug 23, 2005 9:41 am

Post by -SV- »

Hey everyone,

I'm sad to say that I will be abandoning the development of this MOD. :( I hate to do this, I really do -- even more so because I've not even released any code, and this is one of the MODS Most Wanted.

I've just got so much going on right now - that there is no way I can work on this MOD at the moment; or any other of my MODS that I have released in the MODDB. (Not to say I'm abandoning those - but they are fine at the moment and can wait on features).

Perhaps it's time I take a break from coding in general, after finishing up a few of my latest projects.

For anyone willing to take up this MOD (I believe I've seen a few who posted in this thread stating they'd be willing to help ;) ) - feel free to. Hopefully someone can come up with something better than I ever could have.

Regards,
-SV-
User avatar
harishkumar09
Registered User
Posts: 163
Joined: Mon Feb 06, 2006 5:37 pm
Location: Bengaluru
Contact:

Post by harishkumar09 »

This is too bad.Many would like to monetize their boards atleast for hosting fees.I hope somebody will take it up and give it to us.
Love & Regards,
Harish Kumar.
MarkTheDaemon
Former Team Member
Posts: 2770
Joined: Thu Oct 20, 2005 2:42 am
Location: United Kingdom
Name: Mark Barnes

Post by MarkTheDaemon »

-SV-: If you wish to continue development of this MOD feel free to contact me to get this thread unlocked.


Mark
Locked

Return to “[2.0.x] MODs in Development”