View Single Post
  #122  
Old 06-18-2003, 12:45 PM
The_Wanderer's Avatar
The_Wanderer The_Wanderer is offline
 
Join Date: Dec 2002
Posts: 100
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

that shouldnt be a problem...

FIND:
PHP Code:
SELECT 
  user
.avatarid AS a_id,
  
avatar.avatarpath AS a_path,
  
customavatar.userid AS c_id,
  
customavatar.dateline AS dateline,
  
profiletagboard.msg AS msg,
  
profiletagboard.fromuserid AS fromuserid,
  
profiletagboard.touserid AS touserid,
  
user.username AS username,
  
user.userid AS userid,
  
user.usertitle AS title,
  
profiletagboard.id AS id 


  FROM avatar
,customavatar,profiletagboard

  LEFT JOIN user ON user
.userid=profiletagboard.fromuserid

  WHERE 
  touserid
='$userinfo[userid]' AND user.avatarid=avatar.avatarid 
  
OR touserid='$userinfo[userid]' AND user.avatarid='0' AND user.userid=customavatar.userid
  
OR touserid='$userinfo[userid]' AND user.avatarid='0' AND user.userid!=customavatar.userid

  GROUP BY msg ORDER BY id DESC 
and replace with: (2 times)

PHP Code:
SELECT 
  profiletagboard
.msg AS msg,
  
profiletagboard.fromuserid AS fromuserid,
  
profiletagboard.touserid AS touserid,
  
user.username AS username,
  
user.userid AS userid,
  
user.usertitle AS title,
  
profiletagboard.id AS id 


  FROM profiletagboard

  LEFT JOIN user ON user
.userid=profiletagboard.fromuserid

  WHERE 
  touserid
='$userinfo[userid]' 
  
GROUP BY msg ORDER BY id DESC 
FIND and delete: (2 times)
PHP Code:
if ($result[a_id] == "0" AND $result[c_id] == "$result[userid]") {
    
$tbavatar="avatar.php?userid=$result[userid]&dateline=$result[dateline]";
    };
    if (
$result[a_id] == "0" AND $result[c_id] != "$result[userid]") {
    
$tbavatar="avatar.php?userid=$result[userid]&dateline=$result[dateline]";
    };
    if (
$result[a_id] != "0") {
    
$tbavatar="$result[a_path]";
    }; 
I haven't tested this but i think it works
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01278 seconds
  • Memory Usage 1,804KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete