vb.org Archive
Page 22 of 29 « First 122021 22 2324 Last »
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)

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?


All times are GMT. The time now is 03:01 AM.
Page 22 of 29 « First 122021 22 2324 Last »
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.01669 seconds
  • Memory Usage 1,751KB
  • 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
  • (7)bbcode_code_printable
  • (3)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