vB Affiliates v.2
 

vB Affiliates v.2

Author: Antonbomb22

Description:
Now add,manage,display all your communties/boards affiliates in a simple and organized fashion.

Features:
-Administration Panel
-multiple affilliates
-image button verification
-modules
-top listing
-types/categories
-reporting system
-rating system
-in and out clicking system
-redirects
-delay system
-disclaimers
-extremely customizeable
-display options
-pagination
-approval system
-usergroup permissions
-active system
-image buttons

Changes from Version 1:
-administration intergrated better
-added a delay system
-added a report system
-4 new modules
-display options
-pagination
-click in features with buttons so affiliates may link back
-cached templates
-quicked load speeds
-image button verification
-more options
-approval system
-usergroup permissions

Known Bugs:
-if an affiliates site goes down completely the verification/validation system will report errors

Some notes(usually rare):
-server load may increase a little bit if you have all modules active
-load time may a little bit increase if you have image validation on

Live Demo:
http://www.animationation.net/community/affiliate.php
http://www.game-realms.net/vb/affili...listaffiliates

Offical Support/Suggestion forum: http://www.animationation.net/commun...splay.php?f=58

plz click install;)

Enjoy;)

edit:
attachment updated, wrong queries for upgrade instruct.
updated zip file with new template edit
updated zip file with new affiliate.php
update zip file with new queries
Those who has alrdy downloaded follow the following links for file updates:
https://vborg.vbsupport.ru/showpost.php?p=491667
https://vborg.vbsupport.ru/showpost.php?p=491675
https://vborg.vbsupport.ru/showpost.php?p=496126
updated zip file with few fixes(4/14/04)

Interesting hack... not sure if ill use it yet though since theres still a few bugs.

I was looking at the edits to functions_online.php and they appeared to only be for making it so that people show up in the Who's Online list. Is this correct? What happens if I don't edit this file? Also, you note of potential high load, can you give any more details as to how big the load increase is? What is the main cause of it? How much do you have to turn off to drop the load?

Thanks! Been following your hack closely and will likely install assuming its not going to drown my server - I run a pretty large board.

Perfect solution to my problem! I'll install this!

the load isnt to great like say 2.42 >> 2.36 and like that. to lessen the server load i would either turn off image button validation or one or two of modules. the server load isnt that great but i think i owe it to the users to advise them of this:)
but this isnt always necessary, cause extra server load rarely occurs

the server load question was answered above

editing functions_online.php enables you and users who are viewing the who's online list will display Viewing Affiliate List, View Affiliate Index, Applying for Affiliation etc.. if you dont edit it will place the name of the file their viewing and saying its an unknown location. i did this so it looks better for boards/communities using this addon/hack

You're missing " . TABLE_PREFIX ." in all the files. You're doing a great job on this one so far.. Keep up the great work! ;)

2.42 seems fairly high. I usually am below that with 300 people on my board. Load really depends on server specs however. Can you tell me how many queries are called on the various functions?

Has this Hack had the Bugs worked out of it? Has anyone installed it with NO problems?

I'm having quite a few problems with the SQL.

When i try:

ALTER TABLE affiliates_settings ADD perpage int(3) NOT NULL, ADD bbsmilies tinyint(4) NOT NULL, ADD bbimage tinyint(4) NOT NULL, ADD moment tiny(4) NOT NULL, ADD most_hitsout tinyint(4) NOT NULL, ADD most_hitsin tinyint(4) NOT NULL, ADD most_votes tinyint(4) NOT NULL, ADD imagelink varchar(250) NOT NULL, ADD senderemail varchar(255) NOT NULL, ADD module_position tinyint(4) NOT NULL, ADD cantview varchar(50) NOT NULL, ADD cantapply varchar(50) NOT NULL, ADD cantrate varchar(50) NOT NULL, ADD disclaimer tinyint(4) NOT NULL, ADD validate tinyint(4) NOT NULL, ADD reporting tinyint(4) NOT NULL, ADD reportemail varchar(255) NOT NULL, ADD cantreport varchar(50) NOT NULL, ADD delay int(3) NOT NULL;,

I get: When i try:

ALTER TABLE affiliates CHANGE `clicks` `clicksout` INT( 20 ) DEFAULT '0' NOT NULL ;
ALTER TABLE affiliates2 ADD clicksin INT(20) DEFAULT '0' NOT NULL, ADD approved tinyint(4) NOT NULL;

I get:


And where do i edit this? ::

Also, what title can my Shedule Task be? As i tried Affiliate, and a numbe rof others, and it keep saying:
Please help, as i really wnat this hack.

try these 2 new queries:
[sql]
ALTER TABLE affiliates_settings ADD perpage int(3) NOT NULL, ADD bbsmilies tinyint(4) NOT NULL, ADD bbimage tinyint(4) NOT NULL, ADD moment tinyint(4) NOT NULL, ADD most_hitsout tinyint(4) NOT NULL, ADD most_hitsin tinyint(4) NOT NULL, ADD most_votes tinyint(4) NOT NULL, ADD imagelink varchar(250) NOT NULL, ADD senderemail varchar(255) NOT NULL, ADD module_position tinyint(4) NOT NULL, ADD cantview varchar(50) NOT NULL, ADD cantapply varchar(50) NOT NULL, ADD cantrate varchar(50) NOT NULL, ADD disclaimer tinyint(4) NOT NULL, ADD validate tinyint(4) NOT NULL, ADD reporting tinyint(4) NOT NULL, ADD reportemail varchar(255) NOT NULL, ADD cantreport varchar(50) NOT NULL, ADD delay int(3) NOT NULL;
[/sql]
and
[sql]
ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL ;
ALTER TABLE affiliates2 ADD clicksin INT(20) DEFAULT '0' NOT NULL, ADD approved tinyint(4) NOT NULL;
[/sql]

for the template edit, those changes need to be made in the AFFILIATE template.

im not sure what your putting for your cron so can you post the title your giving the scheduled task?

Sorry for this problem and oh yes, zip has been updated:)

for those who have already downloaded, here is an updated upgrade_instruct.txt

First query worked, but the second one didnt and i got this back:

SQL-query :

ALTER TABLE affiliates CHANGE clicks clicksout INT( 20 ) NOT NULL

MySQL said:

Unknown column 'clicks' in 'affiliates'

Also, what title can i use for the scheduled task?

i named my scheduled task: Empty Affiliates Records

for query there must be sumthing wrong with your table, because in the original version of this there was a clicks column in the affiliates table. i even ran that query on a test table.

well this hack doesnt require table prefixes since the queries and the creation of tables dont use any;)

the minimum queries with all modules off,validation off, and bb code parse off, is 11 queries(base is usally 8). With everything on the maximum is 22. with the 4 new modules off you have about 14 queries. Validation doesnt add query just a rarely shown extra load time and server load. so basically with all the enhanced features off you cut the queries in half. this is why i made this hack so customizable so you can out fit it to your boards needs:)

each module adds about 1 query

Err, im a big novice, on hacks. So, how can i fix this?

kk, i've sorted that out.

But look: http://www.game-realms.net/vb/affili...ates&styleid=5 and http://www.game-realms.net/vb/affili...ates&styleid=6 and http://www.game-realms.net/vb/affili...ates&styleid=3

There very distorted, how do i fix that??

Also, whats that error at the top?

Also, im still having that problem, that i cant add any affiliates. :(.

I get this:

to fix the table run this query:
[sql]
ALTER TABLE affiliates ADD clicksout INT( 20 ) NOT NULL;
[/sql]

i dont understand wut u mean by distorted?

for the error, you must setup your settings and perpage values via admincp. you are getting that error because you dont have a perpage value set:)

you must provide an email,name, url for the site

My admincp. Do you have Any IMs, so i can show you?

i just ran the query you said, to try and fix the erro and i got this::

Error

SQL-query :

ALTER TABLE affiliates ADD clicksout INT( 20 ) NOT NULL

MySQL said:

Duplicate column name 'clicksout'

And how do i do this?

r u running a fresh install or an upgrade?

you go to your administration control panel and click general settings, under that there is a setting that says # of affiliates per page next to it is a drop down menu of #'s you must choose one and also set up your other settings then click update for it take affect.

sorry i left a template edit.

for those who have alrdy downloaded, download this new upgrade_instruct.txt

zip updated with new upgrade_instruct.txt

i have updated the affiliate.php file so it works with the new approval system. sry for the inconvience.

updated file has been attached for those who have alrdy downloaded

all problems/bugs so far have been solved. if anyone else has any questions,concerns, or problems please post them here or at the offical support forums. thanks and sry for any inconvience:)

Thanks its now working, You've been a great help

Erm. All is good. Except, is there a way, if a an affiliate doesnt have a button and you dont put one in, is there anyway, you can get rid of the broken image?

use validation. it replaces it with another image if that field is left blank

And how do i that? lol

admincp->affiliates->general settings->validate image buttons

any other questions or problems dont be afraid to ask:)

Just a thought -- have you thought about combining this with one of the javascript external data syndication tools (like RSS) so that afflilates would actually display the RSS instead of just a banner? This could be a great way to help encourage syndication of boards content.

hmm i look into that even though i dont know much about rss syndication;)

You did a very good job with this one.. I like it. I've modified some of it to suit my own needs though (i.e. you don't always get an error message for clicking out more than once in the set time, the count just doesn't increase).

Also, I've made it so that when my image is displayed on an affiliate's site, it shows up in Who's Online as a guest (or the member's name if they're registered and their cookies haven't expired). It doesn't currently show the name of the site that the image is displaying on, but when I get a chance (not sure when though), I'll be making the $userinfo['where'] variable show a link to the affiliate's site.

This is one of the best affiliate systems I've seen here and has quite a bit of potential. :up:

oh yeah ive noticed that who's online problem but i wasnt sure what to do with it, especially what to name it, if you want to give me some suggestions what to name it, i can surely code it for u;)

I'd orgiginally made it so that it wouldn't show up in the Who's Online, but then got to thinking. I'd like for it to show up there and display that the user's browsing an affiliates site as the $userinfo['action'] and to have the site's name, if a valid (i.e. approved and active) affiliate, display the site's name with a link to it as the $userinfo['where']. So, I changed it back to display in the Who's Online and set it to show "Browsing Affiliate Site", but still need to make the site's name and link show yet..

thats a good idea, ill try to find time to code it;)

i have updated the upgrade instructions again. Please download the attached the filed.

I don't think mine is sending the emails for approval. Does it send the email at a certain time or something? If not mine isn't working right :(