Esempio n. 1
0
/**
 * Replace old tags with new one and delete old ones
 *
 * @param mixed $system
 * @param mixed $tag_ids - to be replaced and deleted
 * @param mixed $tag_id_new
 * @param mixed $ugrID
 */
function tagReplace($system, $tag_ids, $tag_id_new, $ugrID = null)
{
    $ugrID = $system->is_admin2($ugrID);
    if (!$ugrID) {
        $system->addError(HEURIST_REQUEST_DENIED);
        return false;
    } else {
        if (is_string($tag_ids)) {
            $tag_ids = explode(",", $tag_ids);
        }
        if (is_array($tag_ids) && count($tag_ids) > 0 && intval($tag_id_new)) {
            $mysqli = $system->get_mysqli();
            $query = 'select count(*) from usrTags where tag_ID in (' . $tag_id_new . ',' . implode(', ', $tag_ids) . ') and tag_UGrpID=' . $ugrID;
            $cnt = mysql__select_value($mysqli, $query);
            if ($cnt != count($tag_ids) + 1) {
                $system->addError(HEURIST_INVALID_REQUEST, "Not found all tags");
                return false;
            }
            //add new links
            $query = 'insert ignore into usrRecTagLinks (rtl_RecID, rtl_TagID) ' . 'select distinct rtl_RecId, ' . $tag_id_new . ' from usrRecTagLinks where rtl_TagID in (' . implode(', ', $tag_ids) . ')';
            $res = $mysqli->query($query);
            $res = $mysqli->query($query);
            if ($res) {
                $cnt = $mysqli->affected_rows;
                //delete old ones
                $res = tagDelete($system, $tag_ids, $ugrID);
                if (is_numeric($res) && $res > 0) {
                    return array('tags_deleted' => $res, 'taglinks_replased' => $cnt);
                } else {
                    return false;
                }
            } else {
                $system->addError(HEURIST_DB_ERROR, "Cannot replace tag links", $mysqli->error);
                return false;
            }
        } else {
            $system->addError(HEURIST_INVALID_REQUEST);
            return false;
        }
    }
}
Esempio n. 2
0
} else {
    $mysqli = $system->get_mysqli();
    if ($system->get_user_id() < 1) {
        $response = $system->addError(HEURIST_REQUEST_DENIED);
    } else {
        $action = @$_REQUEST['a'];
        // || @$_REQUEST['action'];
        // call function from db_record library
        // these function returns standard response: status and data
        // data is recordset (in case success) or message
        $res = false;
        if ($action == "add" || $action == "save") {
            $res = tagSave($system, $_REQUEST);
        } else {
            if ($action == "delete" && @$_REQUEST['ids']) {
                $res = tagDelete($system, $_REQUEST['ids'], @$_REQUEST['UGrpID']);
            } else {
                if ($action == "search" && @$_REQUEST['UGrpID']) {
                    $res = tagGetByRecords($system, @$_REQUEST['info'] != "short", @$_REQUEST['recIDs'], @$_REQUEST['UGrpID']);
                    if (is_array($res)) {
                        $res['recIDs'] = @$_REQUEST['recIDs'];
                    }
                    /*
                    $res = tagGetByUser($system, false, $_REQUEST['UGrpID']);
                    */
                } else {
                    if ($action == "replace" && @$_REQUEST['UGrpID']) {
                        $res = tagReplace($system, $_REQUEST['ids'], $_REQUEST['new_id'], @$_REQUEST['UGrpID']);
                    } else {
                        if ($action == "rating") {
                            $res = bookmarkRating($system, @$_REQUEST['recIDs'], @$_REQUEST['rating'], @$_REQUEST['UGrpID']);