/** * 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'; }
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++) {