vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   [PROBLEM WITH CODE!] ShowProfilePic in Online.php (https://vborg.vbsupport.ru/showthread.php?t=96015)

Gio~Logist 09-10-2005 09:34 PM
[PROBLEM WITH CODE!] ShowProfilePic in Online.php
 
I tried the following code, however, it did not work.

PHP Code:
$allusers = $DB_site->query("
    SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, 
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    ". iif($show['profilepic'], ',customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline') . "        
    FROM " . TABLE_PREFIX . "session AS session
    ". iif($show['profilepic'], "LEFT JOIN " . TABLE_PREFIX . "customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) ") . "
    ". iif($vboptions['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ."
    WHERE session.lastactivity > $datecut
        ". iif(!$vboptions['WOLguests'], " AND session.userid = user.userid", "") ."
    ORDER BY $sqlsort $sortorder
");

        if ($show['profilepic'])
        {
            $userinfo['profilepic'] = "<img src=\"image.php?u=$userinfo[userid]&amp;type=profile&amp;dateline=$userinfo[profilepicdateline]\" alt=\"\" title=\"$userinfo[username]'s picture\" border=\"0\" />";
        }
        else
        {
            $userinfo['profilepic'] = '&nbsp;not showing';
        } 
Any ideas?

Marco van Herwaarden 09-11-2005 05:22 AM
Well with the code above, you have not read a single row from the database. :D

bigcurt 09-11-2005 05:28 AM
rofl xD

~Curt

Gio~Logist 09-11-2005 05:33 AM
Quote:
Originally Posted by MarcoH64
Well with the code above, you have not read a single row from the database. :D

Lmfao that was kind of funny.. what do you mean?

Andreas 09-11-2005 05:33 AM
... and even if you did it would't work properly as you don't take storage method into account.

Gio~Logist 09-11-2005 05:38 AM
Quote:
Originally Posted by KirbyDE
... and even if you did it would't work properly as you don't take storage method into account.

I'm using vb3.0.8 and i'm using database storage, not file storage. It's for my site.

Colin F 09-12-2005 10:10 AM
It would probably be easiest to start coding that again.

You're not even fetching the results of the query.
Additionally, the variables $show and $userinfo don't just fill themselves you know :)

Gio~Logist 09-12-2005 06:27 PM
I'm not worried abut this any longer i figured it out :-D

What im REALLY CONCERNED ABOUT NOW.. is making is so that instead of showing it in ABC order.. how can i make it in order from what time they logged in?


All times are GMT. The time now is 07:04 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.01117 seconds
  • Memory Usage 1,734KB
  • 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_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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