vb.org Archive
Page 6 of 8 « First 45 6 78
Show 40 post(s) from this thread on one page

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)

venomx 11-13-2004 07:13 PM
Where can I find it?

mholtum 11-18-2004 12:45 PM
The install went easy but when running the sql querry I get error 1064 ARGH!

Scerina 11-19-2004 03:20 AM
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

mholtum 11-19-2004 04:58 AM
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

mholtum 11-19-2004 05:25 AM
Ok, I got it working! http://www.ravensrealm.net/forum/affiliates.php

Scerina 11-19-2004 07:55 AM
Is anyone else havin problem with this mySQL Query:

INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'saved_affiliate_x_successfully', '<i>{1}\'s</i> has been updates!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_successfully', '<i>{1}</i> has been deleted!', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'deleted_affiliate_x_unsuccessfully', '<i>{1}</i> was not deleted due to your choice selection.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'inserted_affiliate_x_successfully', '<i>{1}</i> 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', '<i>{1}</i> was updated successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('-1', 'updated_affiliate_type_unsuccessfully', 'The type was <u>not</u> 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', '<i>{1}</i> was added to the database successfully.', '9000');
INSERT INTO phrase (languageid,varname,text,phrasetypeid) VALUES ('0', 'approved_affiliate_x_successfully', '<i>{1}</i> 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???

NightWalk8r 11-28-2004 04:15 PM
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.

bandare 12-15-2004 12:08 PM
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!

bandare 12-16-2004 12:34 PM
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?

Deviant++ 01-26-2005 08:35 AM
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

AN-net 01-26-2005 01:13 PM
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;)

Deviant++ 01-26-2005 02:57 PM
okay I got queries done..

Deviant++ 01-27-2005 05:09 AM
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..

Deviant++ 01-28-2005 04:00 AM
Bah, had to hardcode it to get it working..

:disappointed: wouldn't take prefix's otherwise..

Soto 02-09-2005 08:04 PM
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.

Soto 02-09-2005 09:30 PM
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 :D

Soto 02-10-2005 10:14 PM
Is anyone else having a problem where "hits in" doesn't seem to be working?

Everything else works, except for hits in.

Any ideas?

Royalridge 02-28-2005 11:49 AM
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.

Royalridge 02-28-2005 12:01 PM
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.

venomx 02-28-2005 07:46 PM
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?

agiacosa 03-04-2005 02:05 PM
I installed this hack on a 3.0.6 site. Everything installed fine. The problem is that when I add an affiliate, it doesn't show up in the affiliate index page. Everything else seems to happen. Email is sent to affiliate, it shows approved in AdminCP, etc.

What could it be?

AN-net 03-04-2005 04:50 PM
the affiliatemust be approved and active;)

agiacosa 03-04-2005 08:37 PM
It is.

AN-net 03-04-2005 08:48 PM
are sure that it is both because that active and approved are separate and that would be the only reason it would not show up.

slow56k 03-05-2005 01:46 PM
Hi,

I've installed everything as per instructions but when I come to run the queries I get an error. Any help is appreciated.

PHP Code:
 DROP TABLE IF EXISTS affiliates;
CREATE TABLE affiliates (
     affiliate_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)
); 
PHP 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 near ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL auto_increment,
' at line 1 

slow56k 03-05-2005 02:12 PM
Typical - as soon as I asked for help I found the answer. Thanks for the hack!!

mikaelweb 03-22-2005 05:02 PM
This hack is posted on difrent forum at this time

venomx 03-22-2005 05:09 PM
huh?

Guest190829 03-22-2005 06:23 PM
Take the link out and report it to vbulletin.

venomx 03-31-2005 01:14 PM
Hmm on my WOL I am getting this...
Unknown Location
/forums/affiliatein.php?do=image&a=1

I made all the edits in the files.. what do I need to do?

Also are we to get an email when people submit a site? I dont get one to tell me I have to go and approve a site..

Moncal 04-01-2005 01:56 AM
Great hack! Thanks.

m0nde 04-06-2005 06:30 AM
Great hack!

I just installed this hack and found an error in affiliateadmin.php which wouldn't let me modify the cantview field in affiliates_settings.
Quote:
cantview='$canrview',
I changed this to the code below and it worked.
Quote:
cantview='$cantview',
I can't seem to get the pagination system working at all, though.
It simply won't show the previous and next dialogues if they're needed.

I currently have 7 affiliates in my database and the only way to view these guys is to set the per page setting to 10.

Please help.

The module can be found at http://www.bostonlove.org/forums/affiliate.php

playstation 04-09-2005 04:49 PM
I have installed this hack and can add affiliates fine,but when the other party get the e-mail.with my image link they get this-

Please put the following code on the page/link you provided our database with. Code: <a href="http://www.playstation-elite.co.uk/forum/affiliatein.php?do=redirect&a=8"><img src="http://www.playstation-elite.co.uk/forum/affiliatein.php?do=image&a=8" border="0"></a> OR use this: <a href="http://www.playstation-elite.co.uk/forum/affiliatein.php?do=redirect&a=8">PlayStation-Elite</a>

But there is no banner image showing up on their site. :ermm:

LEAD_WEIGHT 04-20-2005 11:49 PM
When will this be upgraded to vb3.x.x

venomx 04-20-2005 11:59 PM
It is.....

m0nde 04-21-2005 04:06 AM
Quote:
Originally Posted by LEAD_WEIGHT
When will this be upgraded to vb3.x.x
I'm using it with vBulletin 3.0.7 and it works fine.

poolking 04-21-2005 04:38 AM
LEAD_WEIGHT,

Look at what version of vbulletin this is intended for, it is already intended for 3.x.x also look at which forum it is in, that should give you a clue as well.

LEAD_WEIGHT 04-21-2005 04:51 AM
Quote:
Originally Posted by poolking
LEAD_WEIGHT,

Look at what version of vbulletin this is intended for, it is already intended for 3.x.x also look at which forum it is in, that should give you a clue as well.
vB Version: 3.0.0 Mod Version: 2.00 Supported
DB Changes
Installer included

Release: 28. Mar 2004 Installs: 115
Last Update: 15. Apr 2004 Rating:

I think those glasses are too dark for u maybe a shade lighter would help unless u see vb3.x.x cause I see vb3.0.0 :ermm:
Your quick poolking :glasses:

Could some ask AN-net if he like to relinquish this hack so some Coder could updated or change how it is setup.

poolking 04-21-2005 04:58 AM
excuse me 3.x.x that you are referring to includes 3.0.0 all the way upto the current version of vbulletin which is 3.0.7.

agiacosa 04-21-2005 10:11 PM
Quote:
Originally Posted by poolking
excuse me 3.x.x that you are referring to includes 3.0.0 all the way upto the current version of vbulletin which is 3.0.7.
Anyone find a solution to FireFox redirect problems? The solution in the past post doesn't work for me.


All times are GMT. The time now is 04:49 AM.
Page 6 of 8 « First 45 6 78
Show 40 post(s) from this thread on one page

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.01551 seconds
  • Memory Usage 1,866KB
  • 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
  • (15)bbcode_code_printable
  • (2)bbcode_html_printable
  • (2)bbcode_php_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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