Example #1
0
/**
 * Add a LINK between TAGS and a URL
 */
function _AddLink($f_szUrl, $f_szTitle, $f_szTags)
{
    global $db;
    $szUrl = trim($f_szUrl);
    $arrTags = unaliasTags(explode(' ', str_replace('/', ' ', valid_tags($f_szTags))));
    $szTitle = trim($f_szTitle);
    if (!$arrTags || !$szUrl) {
        return 'ERROR:' . __LINE__;
    }
    // Add url
    $iUrlId = AddUrl($szUrl, $szTitle);
    foreach ($arrTags as $szTag) {
        // Add tag
        $iTagId = AddTag($szTag);
        // Insert relation
        try {
            $db->insert('l_links', array('url_id' => $iUrlId, 'tag_id' => $iTagId, 'utc_added' => time()));
        } catch (db_exception $ex) {
        }
    }
    return 'OK';
}
Example #2
0
function CreateNewGroup(&$db, $group_name)
{
    $sql = "INSERT INTO `url_group` (`group_name`) VALUES('" . $group_name. "')";
    return (false != $db->runSql( $sql ));
}

$mysql = new SaeMysql();

if(!empty($_POST))
{
    if ($group_id && isset($_POST['add_urls']))
    {
        $url_array = explode("\n", $_POST['add_urls']);
        for ($i = 0; $i < sizeof($url_array); $i++)
        {
            AddUrl($mysql, $url_array[$i], $group_id);
        }
    }
    elseif ($group_id && isset($_POST['remove_urls']))
    {
        $url_array = explode("\n", $_POST['remove_urls']);
        for ($i = 0; $i < sizeof($url_array); $i++)
        {
            RemoveUrl($mysql, $url_array[$i], $group_id);
        }
    }
    elseif ($group_id && isset($_POST['remove_url_ids']))
    {
        $url_id_array = explode("\n", $_POST['remove_url_ids']);
        for ($i = 0; $i < sizeof($url_id_array); $i++)
        {