Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vB Affiliates v.2 Details »
vB Affiliates v.2
Mod Version: 2.00, by AN-net (Member) AN-net is offline
Developer Last Online: Jan 2010 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.0.0 Rating: (2 votes - 5.00 average) Installs: 110
Released: 28 Mar 2004 Last Update: 15 Apr 2004 Downloads: 168
Not Supported DB Changes  

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:
http://www.vbulletin.org/forum/showpost.php?p=491667
http://www.vbulletin.org/forum/showpost.php?p=491675
http://www.vbulletin.org/forum/showpost.php?p=496126
updated zip file with few fixes(4/14/04)

Download Now

Only licensed members can download files, Click Here for more information.

Supporters / CoAuthors

Screenshots

Click image for larger version

Name:	vBaffiliate_addaff.gif
Views:	2127
Size:	19.1 KB
ID:	17614   Click image for larger version

Name:	vBaffiliate_addtype.gif
Views:	1161
Size:	8.7 KB
ID:	17615   Click image for larger version

Name:	vBaffiliate_editaff1.gif
Views:	1389
Size:	34.5 KB
ID:	17616   Click image for larger version

Name:	vBaffiliate_editaff2.gif
Views:	1101
Size:	29.3 KB
ID:	17617  

Click image for larger version

Name:	vBaffiliate_edittype.gif
Views:	1060
Size:	11.3 KB
ID:	17618   Click image for larger version

Name:	vBaffiliate_manageaff.gif
Views:	906
Size:	10.7 KB
ID:	17619   Click image for larger version

Name:	vBaffiliate_managetype.gif
Views:	1097
Size:	13.1 KB
ID:	17620   Click image for larger version

Name:	vBaffiliate_settings1.gif
Views:	1112
Size:	36.6 KB
ID:	17621  

Click image for larger version

Name:	vBaffiliate_settings2.gif
Views:	1629
Size:	34.3 KB
ID:	17622  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
vB Affiliates for 3.5 Danny.VBT Modification Graveyard 330 23 Mar 2007 02:44

Comments
  #2  
Old 28 Mar 2004, 03:41
`SLVR`'s Avatar
`SLVR` `SLVR` is offline
 
Join Date: Aug 2003
Interesting hack... not sure if ill use it yet though since theres still a few bugs.
Reply With Quote
  #3  
Old 28 Mar 2004, 04:44
JonnyQuest JonnyQuest is offline
 
Join Date: Nov 2001
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.
Reply With Quote
  #4  
Old 28 Mar 2004, 04:53
Gio Takahashi's Avatar
Gio Takahashi Gio Takahashi is offline
 
Join Date: Jul 2003
Location: Cape Coral
Real name: Don K
Perfect solution to my problem! I'll install this!
Reply With Quote
  #5  
Old 28 Mar 2004, 05:07
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
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

Last edited by AN-net; 28 Mar 2004 at 05:14.
Reply With Quote
  #6  
Old 28 Mar 2004, 05:35
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
Originally Posted by JonnyQuest
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.
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
Reply With Quote
  #7  
Old 28 Mar 2004, 07:32
Pikok Pikok is offline
 
Join Date: Jul 2002
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!

Last edited by Pikok; 28 Mar 2004 at 08:53.
Reply With Quote
  #8  
Old 28 Mar 2004, 07:55
JonnyQuest JonnyQuest is offline
 
Join Date: Nov 2001
Originally Posted by AN-net
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
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?
Reply With Quote
  #9  
Old 28 Mar 2004, 10:28
BlackxRam BlackxRam is offline
 
Join Date: Aug 2003
Has this Hack had the Bugs worked out of it? Has anyone installed it with NO problems?
Reply With Quote
  #10  
Old 28 Mar 2004, 13:07
BarHopper BarHopper is offline
 
Join Date: Mar 2003
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:
Originally Posted by My SQL
SQL-query :

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

MySQL said:


You have an error in your SQL syntax near 'tiny( 4 ) NOT NULL ,
ADD most_hitsout tinyint( 4 ) NOT NULL ,
ADD most_h' at line 4
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:

Originally Posted by MySQL
SQL-query :

ALTER TABLE affiliates CHANGE `clicks` `clicksout` INT( 20 ) DEFAULT '0' NOT NULL

MySQL said:


Unknown column 'clicks' in 'affiliates'

And where do i edit this? ::

Originally Posted by Affiiliate Install file
-----------------------------------
Find:
<table class="galcat" style="border: 1px solid;" align="center" width="100%">
-----------------------------------
Replace with:
<table class="tcat" style="border: 1px solid;" align="center" width="100%">
-----------------------------------
Also, what title can my Shedule Task be? As i tried Affiliate, and a numbe rof others, and it keep saying:
Invalid title Specified
Please help, as i really wnat this hack.
Reply With Quote
  #11  
Old 28 Mar 2004, 15:14
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
try these 2 new queries:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

and

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


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
Attached Files
File Type: txt upgrade_instruct.txt (19.7 KB, 26 views)

Last edited by AN-net; 28 Mar 2004 at 15:21.
Reply With Quote
  #12  
Old 28 Mar 2004, 15:22
BarHopper BarHopper is offline
 
Join Date: Mar 2003
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?
Reply With Quote
  #13  
Old 28 Mar 2004, 15:43
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
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.
Reply With Quote
  #14  
Old 28 Mar 2004, 15:49
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
Originally Posted by Pikok
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!
well this hack doesnt require table prefixes since the queries and the creation of tables dont use any
Reply With Quote
  #15  
Old 28 Mar 2004, 15:56
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
Originally Posted by JonnyQuest
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?
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

Last edited by AN-net; 28 Mar 2004 at 16:03.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 22:00.

Layout Options | Width: Wide Color: