Reply to thread

Message

<blockquote data-quote="Meap" data-source="post: 280247" data-attributes="member: 1553">This is a code to fetch badges for a staff page but the problem I have is it doesnt choose the 5 Im wearing, it chooses 1 or 2 of them and displays that badge, 2 or 3 times so for example, Im wearing 5 different badges but on staff page, badge 1 is showing up twice and badge 2 is showing up 3 times, can anyone help?[PHP]$query_badges = Core::$DB-&gt;prepare(&quot;SELECT * FROM user_badges WHERE user_id = '&quot;.$rank_user['id'].&quot;' AND badge_slot &gt; 0 ORDER BY badge_slot LIMIT 5&quot;)-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($query_badges-&gt;num_rows == 0)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; self::$staff_containers = self::$staff_containers.'&lt;div&gt;&lt;i&gt;&lt;ubuntu&gt;'.Template::$language['have_no_badges'].'&lt;/ubuntu&gt;&lt;/i&gt;&lt;/div&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($badges = $query_badges-&gt;fetch_assoc()){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; self::$staff_containers = self::$staff_containers.'&lt;img style=&quot;margin-top: -5px; margin-bottom: 5px; margin-right: 10px; float: left;&quot; src=&quot;'.Core::$Config['badge']['url'].$badges['badge_id'].'.gif&quot;&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; self::$staff_containers = self::$staff_containers.'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }[/PHP]</blockquote>

[QUOTE="Meap, post: 280247, member: 1553"] This is a code to fetch badges for a staff page but the problem I have is it doesnt choose the 5 Im wearing, it chooses 1 or 2 of them and displays that badge, 2 or 3 times so for example, Im wearing 5 different badges but on staff page, badge 1 is showing up twice and badge 2 is showing up 3 times, can anyone help? [PHP]$query_badges = Core::$DB->prepare("SELECT * FROM user_badges WHERE user_id = '".$rank_user['id']."' AND badge_slot > 0 ORDER BY badge_slot LIMIT 5")->execute(); if($query_badges->num_rows == 0) { self::$staff_containers = self::$staff_containers.'<div><ubuntu>'.Template::$language['have_no_badges'].'</ubuntu></div>'; } while($badges = $query_badges->fetch_assoc()){ self::$staff_containers = self::$staff_containers.'<img style="margin-top: -5px; margin-bottom: 5px; margin-right: 10px; float: left;" src="'.Core::$Config['badge']['url'].$badges['badge_id'].'.gif">'; } self::$staff_containers = self::$staff_containers.' </div> </div> '; }[/PHP] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members