/** * Get tag IDs by tag names * * @param mixed $tag_names * @param mixed $ugrID */ function tagGetByName($system, $tag_names, $isadd, $ugrID = null) { if (!$ugrID) { $ugrID = $system->get_user_id(); } if (!$ugrID) { return null; } if (is_string($tag_names)) { $tag_names = explode(",", $tag_names); } $tag_ids = array(); foreach ($tag_names as $tag_name) { $tag_name = preg_replace('/\\s+/', ' ', trim($tag_name)); if (strlen($tag_name) > 0) { $res = mysql__select_value($system->get_mysqli(), 'select tag_ID from usrTags where lower(tag_Text)=lower("' . $system->get_mysqli()->real_escape_string($tag_name) . '") and tag_UGrpID=' . $ugrID); if ($res) { array_push($tag_ids, $res); } else { if ($isadd) { $res = tagSave($system, array('tag_UGrpID' => $ugrID, 'tag_Text' => $tag_name)); if ($res) { array_push($tag_ids, $res); } } } } } $tag_ids = array_unique($tag_ids, SORT_NUMERIC); return $tag_ids; }
if (!$system->init(@$_REQUEST['db'])) { //get error and response $response = $system->getError(); } 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']);