Re:avatar表示

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17

<?php
function smarty_modifier_xoops_user_avatarize($uid)
{
    global $xoopsDB;
    
    $sql = "SELECT user_avatar
            FROM ".$xoopsDB->prefix('users')."
            WHERE uid=".intval($uid);
    $result = $xoopsDB->query($sql);
    
    $user_avatar = '';
    while ( $dbdat = $xoopsDB->fetchArray($result)){
        $user_avatar = htmlspecialchars($dbdat['user_avatar']);
    }
        return XOOPS_UPLOAD_URL . "/" . $user_avatar;
}
?>