tags

<?php

 

include('.LINK/core.php');

include('LINK/session.php');

 

$key = $_GET['key'];

$tag = FilterText($_POST['tagName']);

 

$tmp = mysql_query("SELECT * FROM user_tags WHERE user_id = '".$my_id."' LIMIT 20") or die(mysql_error());

$tag_num = mysql_num_rows($tmp);

 

$randomq[] = "Escolha: Globo, SBT ou BAND?";

$randomq[] = "Qual seu ator preferido?";

$randomq[] = "Qual sua atriz preferida?";

$randomq[] = "Prefere futebol ou basquete?";

$randomq[] = "Qual seu Staff favorito?";

$randomq[] = "Qual sua música favorita?";

$randomq[] = "Qual é sua estação do ano preferida?";

$randomq[] = "Qual sua banda preferida?";

$randomq[] = "Você não pode viver sem qual programa de televisão?";

$randomq[] = "Que instrumento musical gostaria de tocar?";

$randomq[] = "Escolha: Pizza, Hamburguer ou Hot-Dog?";

$randomq[] = "O esporte que você mais gosta";

$randomq[] = "Para ir à festas, você veste...";

$randomq[] = "Qual seu filme predileto?";

$randomq[] = "Cachorros, Gatos ou algo mais exótico?";

$randomq[] = "Vermelho, Azul, Rosa, ou outra cor?";

$randomq[] = "O que acha do Vure Hotel?";

$randomq[] = "Escolha: Rock, Pop ou Rap?";

$randomq[] = "Qual palavra lhe define?";

$randomq[] = "Filmes de terror ou comédia?";

$randomq[] = "Fala outro idioma?";

$randomq[] = "O melhor jogador de futebol do Mundo é...";

$randomq[] = "Qual seu mobi preferido?";

 

srand ((double) microtime() * 1000000);

$chosen = rand(0,count($randomq)-1);

 

if($key == "remove"){

 

mysql_query("DELETE FROM user_tags WHERE tag = '".$tag."' AND user_id = '".$my_id."' LIMIT 1") or die(mysql_error());

echo "SUCCESS";

 

} elseif($key == "p_remove"){ ?>

 

<div id="profile-tags-container">

 

<?php mysql_query("DELETE FROM user_tags WHERE tag = '".$tag."' AND user_id = '".$my_id."' LIMIT 1") or die(mysql_error());

$get_tags = mysql_query("SELECT * FROM user_tags WHERE user_id = '" . $my_id . "' ORDER BY id LIMIT 25") or die(mysql_error());

$rows = mysql_num_rows($get_tags);

 

if($rows > 0){

while ($row = mysql_fetch_assoc($get_tags)){

printf(" <span class=\"tag-search-rowholder\">

<a href=\"".$path."tag/%s\" class=\"tag-search-link tag-search-link-%s\"

>%s</a><img border=\"0\" class=\"tag-delete-link tag-delete-link-%s\" onMouseOver=\"this.src='".$path."web-gallery/images/buttons/tags/tag_button_delete_hi.gif'\" onMouseOut=\"this.src='".$path."web-gallery/images/buttons/tags/tag_button_delete.gif'\" src=\"".$path."web-gallery/images/buttons/tags/tag_button_delete.gif\"

/></span>", $row['tag'], $row['tag'], $row['tag'], $row['tag']);

}

} else {

echo "Sem Etiquetas";

}

 

echo "\n <img id=\"tag-img-added\" border=\"0\" src=\"".$path."web-gallery/images/buttons/tags/tag_button_added.gif\" style=\"display:none\"/>

</div>";

 

} elseif($key == "p_list"){ ?>

 

<div id="profile-tags-container">

 

<?php mysql_query("DELETE FROM user_tags WHERE tag = '".$tag."' AND user_id = '".$my_id."' LIMIT 1") or die(mysql_error());

$get_tags = mysql_query("SELECT * FROM user_tags WHERE user_id = '" . $my_id . "' ORDER BY id LIMIT 25") or die(mysql_error());

$rows = mysql_num_rows($get_tags);

 

if($rows > 0){

while ($row = mysql_fetch_assoc($get_tags)){

printf(" <span class=\"tag-search-rowholder\">

<a href=\"".$path."tag/%s\" class=\"tag-search-link tag-search-link-%s\"

>%s</a><img border=\"0\" class=\"tag-delete-link tag-delete-link-%s\" onMouseOver=\"this.src='".$path."web-gallery/images/buttons/tags/tag_button_delete_hi.gif'\" onMouseOut=\"this.src='".$path."web-gallery/images/buttons/tags/tag_button_delete.gif'\" src=\"".$path."web-gallery/images/buttons/tags/tag_button_delete.gif\"

/></span>", $row['tag'], $row['tag'], $row['tag'], $row['tag']);

}

} else {

echo "Sem Etiquetas";

}

 

echo "\n <img id=\"tag-img-added\" border=\"0\" src=\"".$path."web-gallery/images/buttons/tags/tag_button_added.gif\" style=\"display:none\"/>

</div>";

 

} elseif($key == "add"){

 

$tag = strtolower(FilterText($_POST['tagName']));

$filter = preg_replace("/[^a-z\d]/i", "", $tag);

 

if(strlen($tag) < 2 || $filter !== $tag || strlen($tag) > 20){

echo "invalidtag"; exit;

} else {

$check = mysql_query("SELECT * FROM user_tags WHERE user_id = '".$my_id."' AND tag = '".$tag."' LIMIT 1") or die(mysql_error());

$num = mysql_num_rows($check);

if($num > 0){

echo "invalidtag"; exit;

} else {

if($tag_num > 20){

echo "invalidtag"; exit;

} else {

mysql_query("INSERT INTO user_tags (user_id,tag) VALUES ('".$my_id."','".$tag."')");

echo "valid"; exit;

}

}

}

 

} elseif($key == "mytagslist"){ ?>

 

<div class="habblet" id="my-tags-list">

<ul class="tag-list make-clickable">

<?php while($row = mysql_fetch_assoc($tmp)){

printf("<li><a href=\"".$path."tag/%s\" class=\"tag\" style=\"font-size:10px\">%s</a>\n

<a class=\"tag-remove-link\"\n

title=\"Remover\"\n

href=\"#\"></a></li>\n", $row['tag'], $row['tag']);

}

echo "</ul>";

if($tag_num < 20){

echo " <form method=\"post\" action=\"tag_ajax.php?key=add\" onsubmit=\"TagHelper.addFormTagToMe();return false;\" >

<div class=\"add-tag-form clearfix\">

<a class=\"new-button\" href=\"#\" id=\"add-tag-button\" onclick=\"TagHelper.addFormTagToMe();return false;\"><b>Agregar YoSoy</b><i></i></a>

<input type=\"text\" id=\"add-tag-input\" maxlength=\"20\" style=\"float: right\"/>

<em class=\"tag-question\"><br>" . $randomq[$chosen] . "</em>

</div>

<div style=\"clear: both\"></div>

</form>";

}

echo " </div>

 

<script type=\"text/javascript\">

 

TagHelper.setTexts({

tagLimitText: \"Apague algumas Etiquetas para adicionar novas, pois você atingiu o limite máximo de Etiquetas\",

invalidTagText: \"Etiqueta inválida\",

buttonText: \"OK\"

});

TagHelper.bindEventsToTagLists();

 

</script>\n";

 

}

?>