vb.org Archive - vB Affiliates v.2

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - vB Affiliates v.2 (https://vborg.vbsupport.ru/showthread.php?t=63044)

Where can I find it?

The install went easy but when running the sql querry I get error 1064 ARGH!

Oh, what an awesome hack! Could someone please install this for me please????? If you can help me, please email me at: Pandora@Sweet-November.Net

Thanx in advance

Ok, I was ablew to get all of the queries to work except the first one. When I run it I get this error:

Code:

SQL-query: 



CREATE TABLE affiliatesaffiliate_id int( 10 ) NOT NULL AUTO_INCREMENT ,

sitename varchar( 50 ) NOT NULL ,

siteurl varchar( 250 ) NOT NULL ,

sitedesc mediumtext NOT NULL ,

buttonurl varchar( 150 ) NOT NULL ,

TYPE tinyint( 4 ) NOT NULL ,

email varchar( 250 ) NOT NULL ,

clicksout int( 20 ) NOT NULL ,

clicksin int( 20 ) NOT NULL ,

active tinyint( 4 ) NOT NULL ,

totalrating bigint( 20 ) NOT NULL ,

totalvotes bigint( 20 ) NOT NULL ,

approved tinyint( 4 ) NOT NULL ,

PRIMARY KEY ( affiliate_id ) ,

KEY sitename( sitename ) ,

KEY siteurl( siteurl ) ,

KEY email( email )

Code:

MySQL said:  



#1064 - 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 'affiliate_id int(10) NOT NULL auto_increment,

     sitename varch

Is anyone else havin problem with this mySQL Query:

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_x_successfully', '{1}\'s has been updates!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_successfully', '{1} has been deleted!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_unsuccessfully', '{1} was not deleted due to your choice selection.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_successfully', '{1} has been successfully added to the data base.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_unsuccessfully', 'This affiliates could not be added to the database because you either did not enter an affiliate name or an affiliate url or an affiliate email.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_settings_successfully', 'Settings for Affiliates Addon Updated.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_successfully', '{1} was updated successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_unsuccessfully', 'The type was not updated because the types name was left blank.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_unsuccessfully', 'This type/category was not added to the database due to the name of this type/category not being filled in.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_type_successfully', '{1} was added to the database successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('0', 'approved_affiliate_x_successfully', '{1} has been approved successfully and an email has been dispatched to its admin\'s email.', '9000');

For some odd reason, it won't let me run this query...can someone help me???

i cant get this to work right. Please help me out.
I have it in a module for CMPS too.

here's the link to the module. http://www.anim3.com
here's the link to the main affiliate page http://www.anim3.com/forums/affiliat...listaffiliates

If you click on the link, it wouldnt work for some reason.

I'd like to get that vbadvanced mod if you can make it accessible pls.....

----------------------------------------------------

I have a problem. If I try to click on any of the affiliates links in that section, it just hangs rather than going to the webpage of the affilliate.... what is going wrong?

It keeps adding lots of hits to the affilliate link but doesnt actually go there until I hit the proceed button manually....

pls help!

Quote:

Originally Posted by bondjetta

After speaking with Ianomed about this he pointed out some problems with the template STANDARD_REDIRECT and Firefox...as a result I've found (at least a temporary fix) a fix for this...go to your STANDARD_REDIRECT template and change:

HTML Code:

                else

                {

                        clearTimeout(timerID);

                        window.status = "";

                        window.location = "$js_url";

                }

to:

HTML Code:

                else

                {

                        clearTimeout(timerID);

                        window.status = "";

                        window.location = "$url";

                }

I'm testing it across a few different browsers right now, i'll post if i find any irregularities, but at least the URL's are forwarding now (making this module useful again ;))

I am still trying to fix this problem for my affiliates section and firefox/mozilla users.... I cant find the template STANDARD REDIRECT......... pls help.......

is this the only fix for the redirection fault for affiliates V2?

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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_code_printable (2)bbcode_html_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01393 seconds Memory Usage 1,758KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_code_printable (2)bbcode_html_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: