Adsense Revenue Sharing Mod for 8.2

[tinus2]

I've been following closely to your instructions without checking on the actual backup site. When trying to access it, I now get the error database pligg.link missing.

I tracked that error down to this modification

Originally Posted by Dravis

Approximately line 192 (in the read() function):

$id = $this->id;
//***** PlugIM.com mod: Adsense Revenue Sharing
//if(($link = $db->get_row("SELECT links.*, users.user_login, users.user_email FROM links, users WHERE link_id = $id AND user_id=link_author"))) {
if(($link = $db->get_row("SELECT links.*, users.user_login, users.user_email, users.google_adsense_id, users.google_adsense_channel, users.google_adsense_percent FROM links, users WHERE link_id = $id AND user_id=link_author"))) {
//***** End PlugIM.com mod 

Whenever I uncomment the modification, it works again... so I tried to alter your mod with the way the script looks in my pligg release:

//if(($link = $db->get_row("SELECT " . table_links . ".*, " . table_users . ".user_login, " . table_users . ".user_email FROM " . table_links . ", " . table_users . " WHERE link_id = $id AND user_id=link_author"))) {
if(($link = $db->get_row("SELECT links.*, users.user_login, users.user_email, users.google_adsense_id, users.google_adsense_channel, users.google_adsense_percent FROM links, users WHERE link_id = $id AND user_id=link_author"))) {

Still, I am getting nowhere - any hints?

[kbeeveer46]

tinus2, what version of Pligg are you running?

[tinus2]

kbeeveer46, I am running Beta 9.1 02.18.2007 - the latest release.

Thanks for looking into this!

[tinus2]

I believe this is the way it should look like - haven't tested it on different profiles, though:

//***** Begin Adsense Revenue Sharing MOD
//if(($link = $db->get_row("SELECT " . table_links . ".*, " . table_users . ".user_login, " . table_users . ".user_email FROM " . table_links . ", " . table_users . " WHERE link_id = $id AND user_id=link_author"))) {
if(($link = $db->get_row("SELECT " . table_links . ".*, " . table_users . ".user_login, " . table_users . ".google_adsense_id, " . table_users . ".google_adsense_channel, " . table_users . ".google_adsense_percent, " . table_users . ".user_email FROM " . table_links . ", " . table_users . " WHERE link_id = $id AND user_id=link_author"))) {

As it is early in the morning here, I will follow up late this day... please let me know if everything looks right, I am unfortunately by no means a coder

[kbeeveer46]

Are you trying to install Adsense Revenue Sharing? This should already be installed. All you have to do is enable it in admin > modules management.

[peppolone]

I want the ads appears only if the user submit a story from his site. How can i do?
I thought something like

	// make sure the url_short is the same of the user homepage
	if (strcasecmp($tpl->get_template_vars("url_short"), $tpl->get_template_vars("user_url")) != 0){
		$tpl->assign($params['assign'], 0);
		return;

How can i put the user_url here, because it isn't in the link_summary.
Sorry for my english.

[pligger1]

I'm using Pligg 9.5 (Yget Template) and How do I modify the placement of ads for Revenue sharing? Right now they appear bellow comments and I want to have them above Comments.

[Rob472]

Thanks for developing a great mod. I will be implementing this within the next couple of days.

How hard would it be to add something to this mod where it will also show ads for users that have commented on a story. For example, I would like the person who posted the story to get 50% of the ad displays and any users who posted comments on the story could share another 10-25% of the ad displays. I get some decent traffic but I am having problems trying to get users to post comments and I think that this feature would help a lot.

[yagami]

I'm running the v9.9 and I've some problem getting adsense revenue sharing to work.
I've posted a thread here:
Adsense revenue sharing not working (my adsense id disapear)
Please help me, please.
No one wants to help me, why ?