XoopsModules25x / smallworld

     * @param  int    $userID

     * @return string

     */

    function getName($userID){

        global $xoopsUser, $xoopsDB;

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

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

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

            $name = $row['username'];

        }

        return $name;

    }

    /**

     * @Check if user is follower

* Return owner of thread (original poster)

* Return Integer

*/

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

function Smallworld_getName($userID)

}

// Get username from userID

function Smallworld_getName($userID)

{

    global $xoopsUser, $xoopsDB;

    $sql = "SELECT username FROM ".$xoopsDB->prefix('smallworld_user')." WHERE userid = '".intval($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

}

//Check privacy settings in permapage

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 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 $txt

     * @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