vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   query not working right (https://vborg.vbsupport.ru/showthread.php?t=137134)

harmor19 01-21-2007 12:55 PM
query not working right
 
Here is the code

PHP Code:
 ########################## Displays Hosted Users ############################
if($_REQUEST['do'] == "users")
{
    
    ($hook = vBulletinHook::fetch_hook('hosting_users_start')) ? eval($hook) : false;  
    
    if(($permissions['hostingpermissions'] & $vbulletin->bf_ugp['hostingpermissions']['canviewuserlist'] == 0))
    {
        eval(standard_error(fetch_error('cannot_view_user_list')));
    }
    
    
    // Default page variables
    $perpage = $vbulletin->input->clean_gpc('r', 'perpage', TYPE_UINT);
    $pagenumber = $vbulletin->input->clean_gpc('r', 'pagenumber', TYPE_UINT); 
    
    $hosted = $db->query_first("
        SELECT COUNT(`planid`) AS `hosted`
        FROM `" . TABLE_PREFIX . "user` WHERE planid > '0'
    ");  
    
    sanitize_pageresults($hosted['hosted'], $pagenumber, $perpage, 100, 25);
    
     $limitlower = ($pagenumber - 1) * $perpage + 1;
    $limitupper = $pagenumber * $perpage;
    if ($limitupper > $hosted['hosted'])
    {
        // Too many for upper limit
        $limitupper = $hosted['hosted'];
        if ($limitlower > $hosted['hosted'])
        {
            // Too many for lower limit
            $limitlower = $hosted['hosted'] - $perpage;
        }
    }
    if ($limitlower <= 0)
    {
        // Can't have negative or null lower limit
        $limitlower = 1;
    }  
    
    $getlinks = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE planid > '0' LIMIT " . ($limitlower - 1) . ", $perpage");
    while($user = $db->fetch_array($getlinks))
    {
        if(can_admin_hosting())
        {
            $canadminhosting = 1;
        }
        
        eval('$member_links .= "' . fetch_template('hosting_member_links_list') . '";');
    }
    
    $pagenav = construct_page_nav($pagenumber, $perpage, $hosted['hosted'], 'hosting.php?' . $vbulletin->session->vars['sessionurl'] . 'do=users');  
    
    $navbits = array(); 
    $navbits[$parent] = 'Member Links';

    $navbits = construct_navbits($navbits);
    eval('$navbar = "' . fetch_template('navbar') . '";');
    
    ($hook = vBulletinHook::fetch_hook('hosting_users_complete')) ? eval($hook) : false; 
    
    eval('print_output("' . fetch_template('hosting_member_links') . '");');
} 
What it's supposed to do is list the users where "planid" is greater than 0 but there's a little problem. If your "planid" has never been changed then you won't show up in the list but if it was changed then changed back to zero then you still show up in the list. I don't know what's going on.

Attilitus 01-21-2007 03:25 PM
Modify the default value in your database to be 0. Or is that already the case?

Code Monkey 01-21-2007 04:27 PM
Try not wrapping your integers in quotes. Mysql may be viewing 0 as a string.

harmor19 01-21-2007 08:59 PM
I fixed it. I was looking at the wrong thing. When I make a search I didn't add the condition "planid > 0"

I changed
PHP Code:
 $getsite = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE username LIKE \"%".$db->escape_string($vbulletin->GPC['searchstring'])."%\""); 
To
PHP Code:
 $getsite = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE username LIKE \"%".$db->escape_string($vbulletin->GPC['searchstring'])."%\" AND planid > 0 "); 


All times are GMT. The time now is 02:09 AM.

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.01773 seconds
  • Memory Usage 1,743KB
  • 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
  • (3)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete