vb.org Archive - vB Affiliates for 3.5

Page 7 of 34

« First

Last »

Show 40 post(s) from this thread on one page

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)

Dark_Wizard

09-26-2005 09:43 PM

Quote:

Originally Posted by ReadOrDie

This hack is becomming very troublesome...

Try this file overwriting the one you have now..

Guest190829

09-26-2005 09:58 PM

Quote:

Originally Posted by Dark_Wizard

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

Lol, Sorry I changed I the it, and put you as a supporter. Is their a Dark Visor on vb.org?

And to everyone getting annoyed, or irratated by the errors and updates of the hack. Please realize that this is only in the BETA stages without these errors the hack would not progress!

Hawkbizkit

09-26-2005 10:28 PM

Quote:

Originally Posted by loneranger

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

very simple fix on line 309 in the affiliate.php change this

PHP Code:


		
			
                                        ON affiliates.type = affiliates_types.id

with this

PHP Code:


		
			
                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id

Dark_Wizard

09-26-2005 11:00 PM

I have already changed the file in the post above and it's better to do it this way:

PHP Code:


		
			
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,tota    lrating,totalvotes  

                                        FROM vB_affiliates AS affiliates LEFT JOIN vB_affiliates_types  AS affiliates_type

                                        ON affiliates.type = affiliates_types.id  

                                        WHERE active='1' AND approved='1'  

                                        ORDER BY sitename DESC  

                                        LIMIT 0,20;

Impreza04

09-27-2005 05:11 AM

Nope sorry. None of those fixes work. Same error still occurs :ermm:

Guest190829

09-27-2005 05:10 PM

This should be a simple fix, by combining both of the suggested fixes..I'll do this later tonight and upgrade the hack with the new affiliate file.

ReadOrDie

09-27-2005 10:39 PM

delete this post plz.

ReadOrDie

09-27-2005 10:42 PM

Sorry about that, It's working now. I reinstalled the adminaffiliate.php thing! I'm clicking install!

ReadOrDie

09-27-2005 10:48 PM

Now it says I don't have permission...How do I not have permission? I'm the administrator. When I click on the affiliates in the forum it says you may not have enough priviledges blah blah blah...

Guest190829

09-28-2005 12:24 AM

You have to set permissions in the usergroup manager

All times are GMT. The time now is 11:43 AM.

Page 7 of 34

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01435 seconds Memory Usage 1,749KB 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 (3)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
Messages: