Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 271415" data-attributes="member: 36373"><p>oops use this code instead:</p><p></p><p>[CODE]&lt;?php</p><p>$user = dbquery(&quot;SELECT * FROM users WHERE id = '&quot; . USER_ID . &quot;'&quot;);</p><p>$userAccount = mysql_fetch_assoc($user);</p><p>?&gt;</p><p>&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp;&nbsp; </p><p>&nbsp; &nbsp; &lt;div class=&quot;cbb clearfix pixellightblue &quot;&gt;</p><p>&nbsp; &nbsp; &lt;h2 class=&quot;title&quot;&gt;Add Tags!&lt;/h2&gt;</p><p>&nbsp; &nbsp; &lt;div class=&quot;box-content&quot;&gt;</p><p>&nbsp;&nbsp; </p><p>&nbsp; &nbsp; &lt;?php</p><p>&nbsp; if(isset($_POST['tag']))</p><p>{</p><p>&nbsp; $tag = filter($_POST['tag']);</p><p>&nbsp; &nbsp; $exits = dbquery(&quot;SELECT null FROM user_tags WHERE tag='&quot;.$tag.&quot;' AND user_id ='&quot;.USER_ID.&quot;'&quot;);</p><p>&nbsp; $exits2 = dbquery(&quot;SELECT null FROM user_tags WHERE user_id ='&quot;.USER_ID.&quot;'&quot;);</p><p>&nbsp;</p><p>&nbsp; &nbsp; if(strlen($tag) &lt; 1 || strlen($tag) &gt; 10)</p><p>&nbsp; &nbsp; {</p><p>&nbsp; echo '&lt;center&gt;&lt;div class=&quot;rounded rounded-red&quot;&gt;&lt;strong&gt;The Tag must be between 1 - 10 characters.&lt;/strong&gt;&lt;/div&gt;&lt;/center&gt;';</p><p>&nbsp; }elseif (mysql_num_rows($exits2) &gt; 8)</p><p>&nbsp; &nbsp; {</p><p>&nbsp; echo '&lt;center&gt;&lt;div class=&quot;rounded rounded-red&quot;&gt;&lt;strong&gt;You have reached your max amount&lt;/strong&gt;&lt;/div&gt;&lt;/center&gt;';</p><p>&nbsp; }elseif (mysql_num_rows($exits) &gt; 0)</p><p>&nbsp; &nbsp; {</p><p>&nbsp; echo '&lt;center&gt;&lt;div class=&quot;rounded rounded-red&quot;&gt;&lt;strong&gt;You have that tag already!&lt;/strong&gt;&lt;/div&gt;&lt;/center&gt;';</p><p>&nbsp; }else</p><p>&nbsp; {</p><p>&nbsp; dbquery(&quot;INSERT INTO user_tags (user_id,tag) VALUES ('&quot;.USER_ID.&quot;','&quot;.$tag.&quot;')&quot;);</p><p>&nbsp; echo '&lt;center&gt;&lt;div class=&quot;rounded rounded-green&quot;&gt;&lt;strong&gt;Tag Added!&lt;/strong&gt;&lt;/div&gt;&lt;/center&gt;';</p><p>&nbsp; &nbsp; }</p><p>&nbsp; &nbsp; &nbsp; &nbsp; }</p><p>&nbsp; &nbsp; ?&gt;</p><p>&nbsp;&nbsp; </p><p>&nbsp; &nbsp; &lt;div style=&quot;text-align: left;&quot;&gt;</p><p>&nbsp; &nbsp; &lt;div style=&quot;padding:5px&quot;&gt;&lt;center&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &lt;form name=&quot;form&quot; action=&quot;&quot; method=&quot;post&quot;&gt;</p><p>&nbsp; &nbsp; &lt;span title=&quot;tag&quot;&gt;Enter Tag: &lt;/span&gt;&lt;br /&gt;</p><p>&nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;tag&quot; /&gt;&lt;br /&gt;&lt;br /&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; value=&quot;Add Tag&quot; class=&quot;submit&quot;&gt;&lt;/center&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &lt;/form&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }&lt;/script&gt;</p><p>&lt;/div&gt;</p><p>&lt;/div&gt;</p><p>&lt;/div&gt;&lt;/div&gt;</p><p>&lt;/div&gt;[/CODE]</p><p></p><p>Added: Can't have the same tag, Max tags: 8</p></blockquote><p></p>

[QUOTE="JayC, post: 271415, member: 36373"] oops use this code instead: [CODE]<?php $user = dbquery("SELECT * FROM users WHERE id = '" . USER_ID . "'"); $userAccount = mysql_fetch_assoc($user); ?> <div class="habblet-container "> <div class="cbb clearfix pixellightblue "> <h2 class="title">Add Tags!</h2> <div class="box-content"> <?php if(isset($_POST['tag'])) { $tag = filter($_POST['tag']); $exits = dbquery("SELECT null FROM user_tags WHERE tag='".$tag."' AND user_id ='".USER_ID."'"); $exits2 = dbquery("SELECT null FROM user_tags WHERE user_id ='".USER_ID."'"); if(strlen($tag) < 1 || strlen($tag) > 10) { echo '<center><div class="rounded rounded-red"><strong>The Tag must be between 1 - 10 characters.</strong></div></center>'; }elseif (mysql_num_rows($exits2) > 8) { echo '<center><div class="rounded rounded-red"><strong>You have reached your max amount</strong></div></center>'; }elseif (mysql_num_rows($exits) > 0) { echo '<center><div class="rounded rounded-red"><strong>You have that tag already!</strong></div></center>'; }else { dbquery("INSERT INTO user_tags (user_id,tag) VALUES ('".USER_ID."','".$tag."')"); echo '<center><div class="rounded rounded-green"><strong>Tag Added!</strong></div></center>'; } } ?> <div style="text-align: left;"> <div style="padding:5px"><center> <form name="form" action="" method="post"> <span title="tag">Enter Tag: </span><br /> <input type="text" name="tag" /><br /><br /> <input type="submit" value="Add Tag" class="submit"></center> </form> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script> </div> </div> </div></div> </div>[/CODE] Added: Can't have the same tag, Max tags: 8 [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members