Reply to thread

Message

<blockquote data-quote="Ben144" data-source="post: 467795" data-attributes="member: 73963"><p>Hey i am recreating the jobs page on the FluxRP CMS and am trying to pull the relevant data from the rp_jobs table, but i am having no luck as when i want to display the owners name, then i put owner_id, but it only displays the owners id and not their full username. The same goes for the avatar it isn't pulling the owner's avatar look ect.</p><p></p><p>[ATTACH=full]12061[/ATTACH]</p><p></p><p>[CODE]&lt;div class=&quot;corporation-index-grid&quot;&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;corp&quot;&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;content-box&quot;&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $badgepath = &quot;{url}/fluxweb/corps/&quot;;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $q = mysql_query(&quot;SELECT * FROM rp_jobs WHERE type = 'skilled' AND hidden = 0 &quot;);</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row = mysql_fetch_assoc($q))</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;div class='title'&gt;&quot; . $row['name'] . &quot; &lt;span class='title-small float-right'&gt;&lt;small&gt;20 employees&lt;/small&gt;&lt;/span&gt;&lt;/div&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class='box-content d-flex justify-content-center align-items-center p-0'&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class='' style='margin-left: -15px;'&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class='manager-wrapper'&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img src='https://www.habbo.nl/habbo-imaging/avatarimage?figure=&quot;.$owner['look'].&quot;&amp;amp;direction=2&amp;amp;gesture=sml&amp;amp;size=l'&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class='mr-auto'&gt;Managed by &lt;strong&gt;&quot;.$owner['username'].&quot;&lt;/strong&gt;&lt;/div&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class='pr-3'&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img class='corporation-badge' src='&quot; . $badgepath . $row['badge'] . &quot;.gif'&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class='pr-3 d-flex'&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class='mr-1'&gt;&lt;a class='button blue pr-1' href=&quot; . JobsView() . $row['id'] . &quot;'&gt;View &lt;i class='far fa-arrow-alt-circle-right'&gt;&lt;/i&gt;&lt;/a&gt;&lt;/div&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class='ml-1'&gt; &lt;a class='button discord' href=''&gt;&lt;i class='fab fa-discord'&gt;&lt;/i&gt;&lt;/a&gt;&lt;/div&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&quot;;</p><p>&nbsp; &nbsp; &nbsp; &nbsp; }</p><p>&nbsp; &nbsp; &nbsp; &nbsp; </p><p>&nbsp; &nbsp; </p><p>&nbsp; &nbsp; ?&gt;</p><p>&nbsp; &nbsp; &lt;/div&gt;</p><p>&nbsp; &nbsp; &lt;/div&gt;</p><p>&nbsp; &nbsp; &lt;/div&gt;</p><p>&nbsp; &nbsp; &lt;/div&gt;[/CODE]</p><p></p><p>Any help appreciated and thanks in advance</p></blockquote><p></p>

[QUOTE="Ben144, post: 467795, member: 73963"] Hey i am recreating the jobs page on the FluxRP CMS and am trying to pull the relevant data from the rp_jobs table, but i am having no luck as when i want to display the owners name, then i put owner_id, but it only displays the owners id and not their full username. The same goes for the avatar it isn't pulling the owner's avatar look ect. [ATTACH type="full"]12061[/ATTACH] [CODE]<div class="corporation-index-grid"> <div class="corp"> <div class="content-box"> <?php $badgepath = "{url}/fluxweb/corps/"; $q = mysql_query("SELECT * FROM rp_jobs WHERE type = 'skilled' AND hidden = 0 "); while($row = mysql_fetch_assoc($q)) { echo "<div class='title'>" . $row['name'] . " <span class='title-small float-right'><small>20 employees</small></span></div> <div class='box-content d-flex justify-content-center align-items-center p-0'> <div class='' style='margin-left: -15px;'> <div class='manager-wrapper'> <img src='https://www.habbo.nl/habbo-imaging/avatarimage?figure=".$owner['look']."&direction=2&gesture=sml&size=l'> </div> </div> <div class='mr-auto'>Managed by <strong>".$owner['username']."</strong></div> <div class='pr-3'> <img class='corporation-badge' src='" . $badgepath . $row['badge'] . ".gif'> </div> <div class='pr-3 d-flex'> <div class='mr-1'><a class='button blue pr-1' href=" . JobsView() . $row['id'] . "'>View <i class='far fa-arrow-alt-circle-right'></i></a></div> <div class='ml-1'> <a class='button discord' href=''><i class='fab fa-discord'></i></a></div> </div> </div>"; } ?> </div> </div> </div> </div>[/CODE] Any help appreciated and thanks in advance [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members