vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   vB Affiliates for 3.5 (https://vborg.vbsupport.ru/showthread.php?t=96485)

ReadOrDie 09-25-2005 05:49 PM

Quote:

Originally Posted by Danny.VBT
In Admin Cp- > Affiliate Setting -> Set that the affiliate section is enabled.

Could you be more specific? Or provide screenshots? Because I'm looking everywhere in the Admin CP and I can't find something that says "Affiliate Setting"

Guest190829 09-26-2005 01:22 AM

AdminCP -> Affiliates -> General Settings -> Is the Affiliates Addon Active? If not, no one can view this addon - > Set to yes

If you can't see Affiliates category in the admincp, make sure you upload the cpnav_affiliates.xml file to your includes/xml directory.

Guest190829 09-26-2005 01:25 AM

Okay, thanks to Dark_Wizard for updating the xml product, the hack has been updated to BETA 1.0.5.

This fixes the various problems with installation/uninstallation, and it also should fix the "TABLE_PREFIX" problem.

( I did a find/replace to take the spaces away)

ReadOrDie 09-26-2005 02:42 AM

Now I'm getting this error: Parse error: parse error, unexpected ',' in /www/g/************/htdocs/forum/admincp/affiliateadmin.php on line 193

Guest190829 09-26-2005 03:19 AM

Hm...I don't see anything wrong with that line, nor did I make any changes to it. Can you post line 193 of the file on here, so I can take a look?

Is anyone else having this problem?

Impreza04 09-26-2005 02:22 PM

Everything is working on my test board apart from when trying to view affiliate.php

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT FROM vb_ affiliates_settings;

MySQL Error  Table 'integram_crg.vb_' doesn't exist
Error Number : 1146
Date         : Monday, September 26th 2005 @ 04:22:45 PM 

EDIT: Actually I see the problem myself and its fixed..
PHP Code:

//################## Begin Settings###################//
$setting$db->query_first("SELECT * FROM " TABLE_PREFIX ." affiliates_settings"); 

Has a space..
Replace with
PHP Code:

//################## Begin Settings###################//
$setting$db->query_first("SELECT * FROM " TABLE_PREFIX ."affiliates_settings"); 

Lets try on my real board


The disabled message
"Sorry but the affiliate section of the siteis currently disabled."
Needs a space between site and is :rolleyes:

and
PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM vB_affiliates LEFT JOIN vB_affiliates_types 
                                        ON affiliates
.type affiliates_types.id 
                                        WHERE active
='1' AND approved='1' 
                                        
ORDER BY sitename DESC 
                                        LIMIT 0
,20;

MySQL Error  Unknown table 'affiliates' in on clause
Error Number 
1109
Date         
MondaySeptember 26th 2005 09:05:35 AM
Script       
http://www.playstation-racing.co.uk/forum/affiliate.php?do=listaffiliates 


ReadOrDie 09-26-2005 07:07 PM

Quote:

Originally Posted by Danny.VBT
Hm...I don't see anything wrong with that line, nor did I make any changes to it. Can you post line 193 of the file on here, so I can take a look?

Is anyone else having this problem?

I don't get what you mean...

Dark_Wizard 09-26-2005 07:46 PM

Quote:

Originally Posted by Danny.VBT
Okay, thanks to Dark Visor for updating the xml product, the hack has been updated to BETA 1.0.5.

This fixes the various problems with installation/uninstallation, and it also should fix the "TABLE_PREFIX" problem.

( I did a find/replace to take the spaces away)

LOL...close enough. Although Dark Visor may like it... ;)

loneranger 09-26-2005 07:48 PM

Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,tota  lrating,totalvotes 
                                        FROM vB_affiliates LEFT JOIN vB_affiliates_types 
                                        ON affiliates.type = affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY sitename DESC 
                                        LIMIT 0,20;

MySQL Error  : Unknown table 'affiliates' in on clause

i am getting this error too is there a solution yet as i need this

ReadOrDie 09-26-2005 07:59 PM

This hack is becomming very troublesome...


All times are GMT. The time now is 09:21 PM.

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.01398 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
  • (1)bbcode_code_printable
  • (4)bbcode_php_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