XoopsModules25x / smallworld

     * @param int $userid

     * @return int

     */

    public function count($userid)

    {

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

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

        return $GLOBALS['xoopsDB']->getRowsNum($result);

    }

}

     * saveImage function

     * @param $values

     */

    public function saveImage($values)

    {

        $myts   = \MyTextSanitizer::getInstance();

        $sql    = 'INSERT INTO ' . $GLOBALS['xoopsDB']->prefix('smallworld_images') . ' VALUES (' . $values . ')';

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

        return $result;

    }

    /**

     * DeleteImage function

     * @param int    $userid

     * @param string $imagename

     */

    public function deleteImage($userid, $imagename)

    {

        $myts   = \MyTextSanitizer::getInstance();

        $sql    = 'DELETE FROM ' . $GLOBALS['xoopsDB']->prefix('smallworld_images') . " WHERE imgname = '" . stripslashes($imagename) . "' AND userid='" . (int)$userid . "'";

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

        return $result;

    }

    /**

     * handlePosts function