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);
}
}
