Current job on view user

[Shakeynath]

I just took a look at the [mccode] Crime Count : A very simple mod that allows you to view your crimes succeeded, Crimes Failed & Total Crimes.

I tried adding another one too my view user that shows users what current job i am on and also the rank name. Now i have added this too my view user

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

But this only shows the job ID, How would i be able to change this too the actual name of the job ?

[Maniak]

Wrong section; but I think that you'd need to match $r['job'] to the job ID in jobs table. Unsure, but it might be a Left Join query?

[Equinox]

$Job = mysql_fetch_array(mysql_query("SELECT `jNAME` FROM `jobs` WHERE (`jID` = ".$ir['job'].")"));

echo 'Current job : '.$Job['jName'].'';

That should do it

Or there should be a LEFT JOIN query at the top, include jNAME in it and then echo out '.$r['jNAME'].' or something similar to what you have done

[Jordan Palmer]

I'm sure someone already made this a while back, Have you tried searching for it?

[sniko]

I made it but you probably wouldn't be able to find it or it would be hard to due to its under my old account which got deleted Sniko`

[Jordan Palmer]

Well I did a quick search and come up with a few results..

 

Job Display in viewuser [MCV2]