XoopsModules25x / smallworld

 * @param $msg_id_fk

 * @return bool|int false if not found, integer of uid otherwise

 */

function smallworld_getOwnerFromComment($msg_id_fk)

{

    $owner = false;

    /** @todo looks like this should have LIMIT set to 1 to reduce execution time & possible ambiguity */

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

    $result = $GLOBALS['xoopsDB']->queryF($sql);

    while (false !== ($r = $GLOBALS['xoopsDB']->fetchArray($result))) {

        $owner = $r['uid_fk'];

    }

    return $owner;

}

/**

 * Get username from userID

 * @param $id

 * @return mixed

 */

function smallworldCheckPriv($id)

{

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

    $result = $GLOBALS['xoopsDB']->queryF($public);

    while (false !== ($row = $GLOBALS['xoopsDB']->fetchArray($result))) {

        $priv = $row['priv'];

    }

    return $priv;

}

/**

 * Function to calculate remaining seconds until user's birthday

 * @param int $userid

 * @return bool|string  false if no image found

 */

function smallworld_getRndImg($userid)

{

    $sql    = 'SELECT imgname FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_images')

            . ' WHERE userid = ' . (int)$userid . ' AND time BETWEEN UNIX_TIMESTAMP( ) - 3000 AND UNIX_TIMESTAMP() ORDER BY rand() LIMIT 1';

    $result = $GLOBALS['xoopsDB']->queryF($sql);

    while (false !== ($r = $GLOBALS['xoopsDB']->fetchArray($result))) {

        $img = $r['imgname'];

    }

    if (!empty($img)) {

        return $img;

    }

    return false;

}

/**

 * Get url of smallworld

 * @param $name

 * @return array @users

 */

function smallworld_getUidFromName($name)

{

    $id     = [];

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

    $result = $GLOBALS['xoopsDB']->queryF($sql);

    while (false !== ($r = $GLOBALS['xoopsDB']->fetchArray($result))) {

        $id = $r['userid'];

    }

    return $id;

}

/**

 * Extract users from @tags