Reply to thread

Message

<blockquote data-quote="Evilsmoothie" data-source="post: 370291" data-attributes="member: 28136">In my view, it makes no sense to intentionally set a person in need of help on the wrong path. Don't be such an ass.In regards to &quot;how could you even run that&quot;, I hope Im not misinterpreting you .. but this is how[PHP]public static function getStaff($rank)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(DB::getInstance()-&gt;query(&quot;SELECT * FROM users WHERE rank = $rank&quot;)-&gt;count())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oddEven = &quot;odd&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getStaff = DB::getInstance()-&gt;query(&quot;SELECT * FROM users WHERE rank = $rank ORDER BY id ASC&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; foreach($getStaff-&gt;results() as $staff) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($oddEven == &quot;#F5F5F5&quot;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oddEven = &quot;#FFFFFF&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oddEven = &quot;#F5F5F5&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($staff-&gt;online == 1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $onlineStatus = &quot;&lt;img src='{site_url}/library/templates/tmp/images/staff/online.gif'&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $onlineStatus = &quot;&lt;img src='{site_url}/library/templates/tmp/images/staff/offline.gif'&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;table width=&quot;100%&quot; style=&quot;padding: 2px; background-color: ' . $oddEven . ';&quot;&gt;&lt;tbody&gt;&lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;middle&quot; width=&quot;25&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;width: 54px; height: 54px; margin-top:-10px; float: left; background: url(https://www.habbo.com.tr/habbo-imaging/avatarimage?figure=' . $staff-&gt;look . '&amp;amp;gesture=sml&amp;amp;size=m&amp;amp;headonly=1);&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;b style=&quot;font-size: 110%;&quot;&gt;' . $staff-&gt;username . '&lt;/b&gt; &lt;font size=&quot;1&quot;&gt;&lt;/a&gt;' . $staff-&gt;position . '&lt;/font&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Motto: &lt;i&gt;' . $staff-&gt;motto . '&lt;/i&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Last seen: ' . Light::time_elapsed_string($staff-&gt;last_online) . '&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;top&quot; style=&quot;float: right;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' . $onlineStatus . '&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;div class=&quot;habblet box-content&quot; style=&quot;margin-top:-5px;&quot;&gt;&lt;i&gt;There are no staff members in this category.&lt;/i&gt;&lt;/div&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }[/PHP]The code isn't very pretty - but whatever. It's mine and does the job I need it to. To clearify I do &lt;?php Light::getStaff(9); ?&gt; on the staff page when I need to. Simple and keeps my tpls pretty and organised. On top of that it yields a very neat result <img src="http://i.imgur.com/z32tBLo.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /> Now that we've settled that the code works - go away unless you're going to help TS.</blockquote>

[QUOTE="Evilsmoothie, post: 370291, member: 28136"] In my view, it makes no sense to intentionally set a person in need of help on the wrong path. Don't be such an ass. In regards to "how could you even run that", I hope Im not misinterpreting you .. but this is how [PHP]public static function getStaff($rank) { if(DB::getInstance()->query("SELECT * FROM users WHERE rank = $rank")->count()) { $oddEven = "odd"; $getStaff = DB::getInstance()->query("SELECT * FROM users WHERE rank = $rank ORDER BY id ASC"); foreach($getStaff->results() as $staff) { if($oddEven == "#F5F5F5") { $oddEven = "#FFFFFF"; } else { $oddEven = "#F5F5F5"; } if($staff->online == 1) { $onlineStatus = "<img src='{site_url}/library/templates/tmp/images/staff/online.gif'>"; } else { $onlineStatus = "<img src='{site_url}/library/templates/tmp/images/staff/offline.gif'>"; } echo '<table width="100%" style="padding: 2px; background-color: ' . $oddEven . ';"><tbody><tr> <td valign="middle" width="25"> <div style="width: 54px; height: 54px; margin-top:-10px; float: left; background: url(https://www.habbo.com.tr/habbo-imaging/avatarimage?figure=' . $staff->look . '&gesture=sml&size=m&headonly=1);"></div> </td> <td valign="top"> ' . $staff->username . ' </a>' . $staff->position . ' Motto: ' . $staff->motto . ' Last seen: ' . Light::time_elapsed_string($staff->last_online) . ' </td> <td valign="top" style="float: right;"> ' . $onlineStatus . ' </td> </tr></tbody></table>'; } } else { echo '<div class="habblet box-content" style="margin-top:-5px;">There are no staff members in this category.</div>'; } }[/PHP] The code isn't very pretty - but whatever. It's mine and does the job I need it to. To clearify I do <?php Light::getStaff(9); ?> on the staff page when I need to. Simple and keeps my tpls pretty and organised. On top of that it yields a very neat result [IMG]http://i.imgur.com/z32tBLo.png[/IMG] Now that we've settled that the code works - go away unless you're going to help TS. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members