[DEV] phpBB Adsense Revenue Sharing Mod2

[ehoward2]

MOD Title: phpBB Adsense Revenue Sharing Mod2
MOD Description: Allow users to serve Adsense ads on threads they start
MOD Version: 0.03

MOD Download: DOWNLOAD 0.03

I am improving this MOD that is now considered abandoned.

It would not work with the current version of phpBB so I made it work.

I am not a programmer. I just played around until things worked. There may be security issues with what I changed. There may be security issues with the original code. This is not supported by me. I am just sharing it.

I have a demo forum with ADMIN access set up at:
http://demo.saturnet.net/phpbb/
Login: demo
Passwod: password

[ehoward2]

not needed anymore

[MHobbit]

It looks like the original author has abandoned this MOD... ThinkBling, the author, hasn't posted here since October 4, 2004. As such, I'm considering this MOD abandoned, and locking this topic.

ThinkBling, if you come back and wish to continue development of this MOD, don't hesitate to contact me regarding this.

That was the reason I locked it, obvious as it was.

Note that you really shouldn't take over this MOD without first attempting to consult the original MOD author.

Also, you need to add a topic prefix, in accordance with the MODs in Development forum rules here. In addition, you should remove the MOD install script from your post and offer it as a separate textfile download; you should also follow our MOD Template, and utilize the "MOD Author:" line rather than your custom "REVISIONS BY:" line.

[ehoward2]

I have an actual working forum at http://forums.saturnet.net/phpbb/index.php

I am thinking about adding some stuff like stats, an easier way to change the percentage of userads shown and any other good ideas, on to this package and re-rolling it if there is interest.

[ehoward2]

I was just trying to help other people trying to get this to work.

If you want to lock or delete this, feel free to.

It looks like the original author has abandoned this MOD... ThinkBling, the author, hasn't posted here since October 4, 2004. As such, I'm considering this MOD abandoned, and locking this topic.

ThinkBling, if you come back and wish to continue development of this MOD, don't hesitate to contact me regarding this.

That was the reason I locked it, obvious as it was.

Note that you really shouldn't take over this MOD without first attempting to consult the original MOD author.

Also, you need to add a topic prefix, in accordance with the MODs in Development forum rules here. In addition, you should remove the MOD install script from your post and offer it as a separate textfile download; you should also follow our MOD Template, and utilize the "MOD Author:" line rather than your custom "REVISIONS BY:" line.

[MHobbit]

No, I'm not saying I want to lock this or anything. Please note what I said previously, since you intend to take over this MOD and update it for 2.0.18.

[Hac]

Hey howard,
Why have you removed this line from the page_header file. I'm not that much programmer either but I think this is control structure tells the program to put the user ads on viewtopic only.

Code: Select all

if ($PageName == "viewtopic.php" &&
      $board_config['ad_enabled'] == "1" &&
      rand(0, 1) == 1)[/code]

[quote]
The other thing is ad_profile_validate.php needs a line changed.

To post the correct userdata to the SQL database from the Profile page, you need change:

Code:

//Get the user ID.
  $user_id = intval($HTTP_POST_VARS['id']);


to

Code:

//Get the user ID.
  $user_id = intval($userdata['user_id'] );
[/quote]

I am still getting the SQL error. Plz somebody tell me the fiels I need to create in my DB.

Thanks for all the help.

[ehoward2]

I did remove it because the variable $PageName was not getting filled.

However, if $FirstPoster is zero, it runs the default ad so I don't need the page name like the original author coded the php script to.

What SQL error are you getting?

Hey howard,
Why have you removed this line from the page_header file. I'm not that much programmer either but I think this is control structure tells the program to put the user ads on viewtopic only.

Code: Select all

if ($PageName == "viewtopic.php" &&
      $board_config['ad_enabled'] == "1" &&
      rand(0, 1) == 1)[/code]

[quote]The other thing is ad_profile_validate.php needs a line changed.

To post the correct userdata to the SQL database from the Profile page, you need change:

Code:

//Get the user ID.
  $user_id = intval($HTTP_POST_VARS['id']);


to

Code:

//Get the user ID.
  $user_id = intval($userdata['user_id'] );
[/quote]

I am still getting the SQL error. Plz somebody tell me the fiels I need to create in my DB.

Thanks for all the help.

[Hac]

This is what I'm getting on clicking the setup adsense in the user profile page:

Code: Select all

Could not select default dateformat

DEBUG MODE

SQL Error : 1146 Table 'hac_buddville.phpbb_buddad_user' doesn't exist

SELECT * FROM phpbb_buddad_user WHERE user_id = 2
Line : 26
File : ad_profile.php


[ehoward2]

I don't know why it's trying to get "phpbb_buddad_user" You must have changed names around.

The struct named by the SQL commands included with the original mod created phpbb_ad_user and that's what I am still going by with the code I'm sharing.

Code: Select all

CREATE TABLE `phpbb_ad_user` (
  `user_id` mediumint(9) NOT NULL default '0',
  `ad_client_id` varchar(25) default '',
  `ad_channel` varchar(25) default '',
  PRIMARY KEY  (`user_id`)
);


I think you should do a fresh phpbb 2.0.18 install and install the mod clean to it.

This is what I'm getting on clicking the setup adsense in the user profile page:

Code: Select all

Could not select default dateformat

DEBUG MODE

SQL Error : 1146 Table 'hac_buddville.phpbb_buddad_user' doesn't exist

SELECT * FROM phpbb_buddad_user WHERE user_id = 2
Line : 26
File : ad_profile.php


[Hac]

Thanks a lot for the SQL query man. It worked beuatifully. Thanks a lot. And yes I did change the prefix to phpbb_budd . And I don't need a new installation anyways coz there are so many modifications I made to the code Thanks a lot and keep it up. Plz check this page and tell me if you see the ads: http://timemachine.frih.net/Buddville/viewtopic.php?t=4

[Hac]

And I'd also like to add that in these lines:

Code: Select all

$sql = "SELECT * ".
          "FROM phpbb_users ".
           "WHERE user_id = $FirstPoster";
         
    if ( !($result = $db->sql_query($sql)) )
    {
      echo($sql);
          }
    $user_row = $db->sql_fetchrow($result);
         
    if ($user_row['user_posts'] > $board_config['ad_min_posts'])
    {

      //Get the previous settings if they exist.
      $sql = "SELECT * ".
             "FROM phpbb_ad_user ".
             "WHERE user_id = $FirstPoster";


the 'phpbb_users' and 'phpbb_ad_user links work if and only if the prefix given by the user is "phpbb_" . If you give a prefix like 'phpbb_yorname' to your tables then you should change it accordinly to the above lines.

- Hac

[ehoward2]

Hey, no problem man. I've been mooching off the open source community for too long without contributing. I'm glad it works.

Thanks a lot for the SQL query man. It worked beuatifully. Thanks a lot. And yes I did change the prefix to phpbb_budd . And I don't need a new installation anyways coz there are so many modifications I made to the code Thanks a lot and keep it up. Plz check this page and tell me if you see the ads: http://timemachine.frih.net/Buddville/viewtopic.php?t=4

[Hac]

I've been mooching off the open source community for too long without contributing.

Guess the feeling is mutual . You use any IM's BTW. Can I have your id?

[yexusbeliever]

Can you explain to me how this mod works? I am not getting the idea of it.