Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vB Affiliates v.2 Details »»
vB Affiliates v.2
Version: 2.00, by AN-net AN-net is offline
Developer Last Online: Jan 2010 Show Printable Version Email this Page

Version: 3.0.0 Rating:
Released: 03-27-2004 Last Update: 04-14-2004 Installs: 110
DB Changes
 
No support by the author.

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)

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #212  
Old 01-26-2005, 01:13 PM
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
Location: AnimationTalk.com
Posts: 2,367
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Deviant++
What exactly is the difference between this and vb3 affiliates hack ..


this is the second version cause it's vb affliates v.2 ?


also, I can't run a single query this is what all it's saying

Code:
vBulletin Message 
An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL a


Code:
An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_records (
record_id int(10) NOT N
Code:
An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_records (
record_id int(10) NOT N
Code:
An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_settings (
active tinyint(4) NOT
Code:
An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates_types (
id int(10) NOT NULL auto_
Code:
An error occurred while attempting to execute your query. The following information was returned. 
error number: 1064 
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VA


NOTE : I am on windows 2003 server on plesk 6.5
try running it one query at a time
Reply With Quote
  #213  
Old 01-26-2005, 02:57 PM
Deviant++'s Avatar
Deviant++ Deviant++ is offline
 
Join Date: Sep 2004
Posts: 137
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

okay I got queries done..
Reply With Quote
  #214  
Old 01-27-2005, 05:09 AM
Deviant++'s Avatar
Deviant++ Deviant++ is offline
 
Join Date: Sep 2004
Posts: 137
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Invalid SQL: SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,tota lrating,totalvotes FROM vb3_affiliates LEFT JOIN affiliates_types ON affiliates.type = affiliates_types.id WHERE active='1' AND approved='1' ORDER BY sitename DESC LIMIT 0,5
mysql error: Table 'dvdb.affiliates_types' doesn't exist

the tables threre..

I tried putting vb3_ ( which is my prefix ) on all of them or alterntively one by one, not making any difference..
Reply With Quote
  #215  
Old 01-28-2005, 04:00 AM
Deviant++'s Avatar
Deviant++ Deviant++ is offline
 
Join Date: Sep 2004
Posts: 137
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Bah, had to hardcode it to get it working..

:disappointed: wouldn't take prefix's otherwise..
Reply With Quote
  #216  
Old 02-09-2005, 08:04 PM
Soto Soto is offline
 
Join Date: Dec 2004
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by BBCVman
OK, I have reinstalled the whole program. Now if you go and check it out, click on the link or banner that i have added to the affiliate program. its now not redirecting anywhere!
THis is what its doing:
Code:
http://www.bodybuildingcentral.net/forums/www.bodybuildingcentral.net
<-- as you can see its adding my site url again at the end! Then it goes to a 404 error page.

Here is the site and its set so guests can enter
www.bodybuildingcentral.net

thanks for any help on this, Im trying to get things rollin as fast as I can....
I'm having the same problem. When an affiliate is clicked it adds the affiliate url to my forum url so gives a 404.

Any ideas what's causing this, and how do I correct it. This is a great mod and I really want to work with it.
Reply With Quote
  #217  
Old 02-09-2005, 09:30 PM
Soto Soto is offline
 
Join Date: Dec 2004
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ahhhh my fault, what an idiot I am! I checked the affiliate details in the the admincp and it was because I'd preapproved an affilitate without http:// at the beginning of the url. Changed that and now it works like a dream.

I made the board redirect template change mentioned earlier for better compatibility with Firefox - it works well, although in some cases you have to manually click "proceed" but it's a small price to pay.

Thanks so much for this.

Also, some people were asking how to make affiliates open in a new window. I made the following edits to allow that:

Basically in each case it's a case of adding target="blank" where ever needed - to save people the time of wading through the template files I've added a text file for the edits.

Can we get an affiliate thread going? We can really use this hack to its full potential then
Reply With Quote
  #218  
Old 02-10-2005, 10:14 PM
Soto Soto is offline
 
Join Date: Dec 2004
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is anyone else having a problem where "hits in" doesn't seem to be working?

Everything else works, except for hits in.

Any ideas?
Reply With Quote
  #219  
Old 02-28-2005, 11:49 AM
Royalridge Royalridge is offline
 
Join Date: Oct 2004
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Out of the zip there is a serious functionality problem, links to sites in the "Top (X) Affiliates" section link directly to the site and bypass the "Links Out" counting. There is a fix that requires one query modification to affilate.php and a change to affiliate_topbits template.
Reply With Quote
  #220  
Old 02-28-2005, 12:01 PM
Royalridge Royalridge is offline
 
Join Date: Oct 2004
Posts: 29
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Niggles:
  • Administrator should be able to specify what page incoming hits are directed to rather than a force into the affiliate list. (I know this can be done through editing the affiliatein.php but ideally should be through control panel)
  • Use of the re-direction template on hits in and out looks messy and should have a control panel option to disable.
Reply With Quote
  #221  
Old 02-28-2005, 07:46 PM
venomx's Avatar
venomx venomx is offline
 
Join Date: Apr 2002
Location: Pennsylvania USA
Posts: 441
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Royalridge
Out of the zip there is a serious functionality problem, links to sites in the "Top (X) Affiliates" section link directly to the site and bypass the "Links Out" counting. There is a fix that requires one query modification to affilate.php and a change to affiliate_topbits template.
And the fix is?
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 01:53 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04553 seconds
  • Memory Usage 2,320KB
  • Queries Executed 28 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (7)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete