function ProcessMessageTags($t, $m, $dbh) { //updates tags for a given message //$t = comma separated list of tags //$m = message id //$dbh = database connection if ($t != "") { $tagList = array(); $tagList = explode(",", $t); if (sizeof($tagList) > 0) { for ($i = 0; $i < sizeof($tagList); $i++) { $newTag = trim(strtolower($tagList[$i])); $newTag = str_replace(".", "", $newTag); if ($newTag != "") { $tagId = GetTagIDFromName($newTag, $dbh); if ($tagId == -1) { $query = "INSERT INTO tag (tag_name) VALUES ('" . $newTag . "')"; $result = mysql_query($query, $dbh); $query = "SELECT LAST_INSERT_ID()"; $result = mysql_query($query, $dbh); $row = mysql_fetch_array($result, MYSQL_NUM); $tagId = $row[0]; $query = "INSERT INTO tag_x_message (tag_id, message_id, from_mobile) VALUES ({$tagId},{$m},1)"; $result = mysql_query($query, $dbh); } else { if (!TagExistsInMessage($tagId, $m, $dbh)) { $query = "INSERT INTO tag_x_message (tag_id, message_id, from_mobile) VALUES ({$tagId},{$m},1)"; $result = mysql_query($query, $dbh); } } } } } } }
function UpdateTags($dbh, $m, $tags) { $query = "DELETE FROM tag_x_message WHERE message_id = {$m}"; $result = mysql_query($query, $dbh); $tagList = explode(",", $tags); if (sizeof($tagList) > 0) { for ($i = 0; $i < sizeof($tagList); $i++) { $newTag = trim(strtolower($tagList[$i])); $newTag = str_replace(".", "", $newTag); if ($newTag != "") { $idTag = GetTagIDFromName($newTag, $dbh); if ($idTag == -1) { $query = "INSERT INTO tag (tag_name) VALUES ('{$newTag}')"; $result = mysql_query($query, $dbh); $query = "SELECT LAST_INSERT_ID()"; $result = mysql_query($query, $dbh); $row = mysql_fetch_array($result, MYSQL_NUM); $idTag = $row[0]; } $query = "INSERT INTO tag_x_message (tag_id, message_id) VALUES ({$idTag},{$m})"; $result = mysql_query($query, $dbh); } } } }
if (isset($_POST['add'])) { $id = $_POST['tag']; if ($id > 0) { $query = "SELECT tag_name FROM tag WHERE tag_id = {$id}"; } else { $query = "SELECT tag_group_name FROM tag_group WHERE tag_group_id = ({$id}*-1)"; } $result = mysql_query($query, $dbh); $row = mysql_fetch_array($result, MYSQL_NUM); $name = $row[0]; $query = "INSERT INTO tag_x_language VALUES (NULL,{$id},0,'{$name}')"; $result = mysql_query($query, $dbh); } else { if (isset($_POST['add_new'])) { $tag = $_POST['new_tag']; $id = GetTagIDFromName($tag, $dbh); if ($id == -1) { $query = "INSERT INTO tag (tag_name) VALUES ('{$tag}')"; $result = mysql_query($query, $dbh); $id = mysql_insert_id(); $query = "INSERT INTO tag_x_language VALUES (NULL,{$id},0,'{$tag}')"; $result = mysql_query($query, $dbh); } else { $query = "SELECT tag_id FROM tag_x_language WHERE tag_id = {$id}"; $result = mysql_query($query, $dbh); if (mysql_num_rows($result) > 0) { } else { $query = "INSERT INTO tag_x_language VALUES (NULL,{$id},0,'{$tag}')"; $result = mysql_query($query, $dbh); } }