vb.org Archive
Page 9 of 34 « First 78 9 101119 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)

ReadOrDie 09-28-2005 07:10 PM
Quote:
Originally Posted by Danny.VBT
What page are you getting that error? I think I filtered out a integer type variable, that's what is causing the error.
I'm getting the error when I try to update the usergroups. It happens right after I press "update"

bi11i 09-28-2005 07:15 PM
Another problem I'm having is the displaying of $bbuserinfo in the error message I received concerning insufficient privilges. Is global.php missing from somewhere? It looks to be in the two affiliate files. Any ideas?
Quote:
$bbuserinfo[username], you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account. Use the contact form to find out why.

bi11i 09-28-2005 07:22 PM
Quote:
Originally Posted by Hawkbizkit
oh dummy me i read your error wrong sorry well i would say try this code

Find: (should be around line 307ish in affiliates.php)
PHP Code:
            $faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM " . TABLE_PREFIX . "affiliates AS affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types  AS affiliates_type
                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY $by $in 
                                        LIMIT $limitvalue,$perpage"
                                        ); 
Replace with:
PHP Code:
            $faffiliate=$db->query_read("SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,sitedesc,clicksout,clicksin,totalrating,totalvotes 
                                        FROM " . TABLE_PREFIX . "affiliates LEFT JOIN " . TABLE_PREFIX . "affiliates_types 
                                        ON " . TABLE_PREFIX . "affiliates.type = " . TABLE_PREFIX . "affiliates_types.id 
                                        WHERE active='1' AND approved='1' 
                                        ORDER BY $by $in 
                                        LIMIT $limitvalue,$perpage"
                                        ); 
Thats how i have my code setup and it is working just fine and when i tried it your way it doesn't work...
I've got this with your new modification:
Quote:
Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT affiliate_id,sitename,siteurl,buttonurl,name,id,si tedesc,clicksout,clicksin,tota lrating,totalvotes
FROM opio_affiliates LEFT JOIN opio_affiliates_types
ON opio_affiliates.type = opio_affiliates_types.id
WHERE active='1' AND approved='1'
ORDER BY sitename DESC
LIMIT 0,5;

MySQL Error : Unknown column 'tota' in 'field list'
Error Number : 1054
Date : Wednesday, September 28th 2005 @ 02:17:58 PM
Script : http://forum.opiophile.org/affiliate...listaffiliates
Referrer : http://forum.opiophile.org/affiliate.php
IP Address : 192.168.0.110
Username : bi11i
Classname : vB_Database_MySQLi

bi11i 09-28-2005 07:30 PM
Quote:
Originally Posted by bi11i
I've got this with your new modification:
I managed to correct the totalrating line.

On to the next problem:

I added an affiliate via the Admin Panel. It doesn't show. So I need to approve it via the admin panel? I'm not sure why this would be, but after I do approve it, get this error:
Code:
Warning: mail() [function.mail]: SMTP server response: 503 No recipient(s). in \admincp\affiliateadmin.php on line 191
The email fields are filled out, plus it went way too quick to have gotten that info from my mailserver.

The the other problem is that if an image is not added to an affiliate, I get the old x'd out box. Any way to fix that?

Also, shouldn't the affiliates open up in a new window?

Last, wouldn't it be best to include an if statement in the navbar for when the affiliates is turned off?

Guest190829 09-28-2005 08:56 PM
Quote:
Originally Posted by ReadOrDie
I'm getting the error when I try to update the usergroups. It happens right after I press "update"
Try rebuilding the bitfields manually through the admincp. I'm going to open my test board with this on, along with a bug tracker so I can easily find all the bugs..Also, I will post an update right now...

Guest190829 09-28-2005 11:06 PM
Please submit all bugs to

http://www.dev.tobroadway.com/forum/vbugs.php

You do not have to register to post bugs...

ReadOrDie 09-29-2005 02:07 AM
I'm still getting this error:
Quote:
Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 628
Whatever it is, it has something to do with classcore.php...

Hawkbizkit 09-29-2005 02:42 AM
Quote:
Originally Posted by bi11i
I've got this with your new modification:
dangit i don't know why but each time i post something using the PHP tags it wants to add a space somewhere where it should not.....meaning fix this space it added in the first line..

edit dangit it still keeps adding the space just try replacing it with this page
or just in the first line fix the space between tota lrating to totalrating

Guest190829 09-29-2005 02:55 AM
Quote:
Originally Posted by ReadOrDie
I'm still getting this error:

Whatever it is, it has something to do with classcore.php...
Did you try manually rebuilding the bitfields via the Admin Cp Option? It seems like it isn't doing it now..

Impreza04 09-29-2005 05:25 AM
Cheers that new file worked..

One small thing though:
Uncached templates: affiliate_list (1)
Uncached templates: affiliate_listbits (1)


All times are GMT. The time now is 12:24 PM.
Page 9 of 34 « First 78 9 101119 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.01409 seconds
  • Memory Usage 1,763KB
  • 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
  • (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)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