XoopsModules25x / smallworld

 * @param int $userid

 * @returns string

 */

function smallworld_getRndImg($userid)

{

    global $xoopsDB;

    $sql    = 'SELECT imgname FROM ' . $xoopsDB->prefix('smallworld_images') . ' WHERE userid = ' . $userid . ' AND time BETWEEN UNIX_TIMESTAMP( ) - 3000 AND UNIX_TIMESTAMP() ORDER BY rand() LIMIT 1';

    $result = $xoopsDB->queryF($sql);

    while ($r = $xoopsDB->fetchArray($result)) {

        $img = $r['imgname'];

    }

    if (!empty($img)) {

        return $img;

    } else {

        return false;

    }

}

/**

 * @Get url of smallworld

 * @param $msg_id_fk

 * @return mixed

 */

function Smallworld_getOwnerFromComment($msg_id_fk)

{

    global $xoopsDB;

    $sql    = 'SELECT uid_fk FROM ' . $xoopsDB->prefix('smallworld_messages') . " WHERE msg_id = '" . $msg_id_fk . "'";

    $result = $xoopsDB->queryF($sql);

    while ($r = $xoopsDB->fetchArray($result)) {

        $owner = $r['uid_fk'];

    }

    return $owner;

}

// Get username from userID

/**

 * @param $userID

 * @return mixed

 */

function Smallworld_getName($userID)

{

    global $xoopsUser, $xoopsDB;

    $sql    = 'SELECT username FROM ' . $xoopsDB->prefix('smallworld_user') . " WHERE userid = '" . (int)$userID . "'";

    $result = $xoopsDB->queryF($sql);

    while ($row = $xoopsDB->fetchArray($result)) {

        $name = $row['username'];

    }

    return $name;

}

// Check if user has been taken down for inspection by admin

// Userid = user id of user to check

 * @param $id

 * @return mixed

 */

function smallworldCheckPriv($id)

{

    global $xoopsDB;

    $public = 'SELECT priv FROM ' . $xoopsDB->prefix('smallworld_messages') . ' WHERE msg_id = ' . $id . '';

    $result = $xoopsDB->queryF($public);

    while ($row = $xoopsDB->fetchArray($result)) {

        $priv = $row['priv'];

    }

    return $priv;

}

// Function to calculate remaining seconds until user's birthday

// Input $d : date('Y-m-d') format

 * @param $name

 * @return array @users

 */

function smallworld_getUidFromName($name)

{

    global $xoopsDB;

    $sql    = 'SELECT userid FROM ' . $xoopsDB->prefix('smallworld_user') . " WHERE username = '" . $name . "'";

    $result = $xoopsDB->queryF($sql);

    while ($r = $xoopsDB->fetchArray($result)) {

        $id = $r['userid'];

    }

    return $id;

}

/**

 * Extract users from @tags