Jobs on view user

[Saberman]

can any one modify this for me so i can view jobs on view user

 

 $qqery= $db->query(sprintf("SELECT u.`userid`, u.`username`, u.`level`, u.`money`, u.`crystals`, u.`laston`, u.`lastip`, u.`energy`, u.`will`, u.`maxwill`, u.`brave`, u.`maxbrave`, u.`maxenergy`, u.`hp`, u.`maxhp`, u.`location`, u.`hospital`, u.`jail`, u.`jail_reason`, u.`fedjail`, u.`user_level`, u.`gender`, u.`daysold`, u.`signedup`, u.`gang`, u.`donatordays`, u.`email`, u.`display_pic`, u.`duties`, u.`staffnotes`, u.`hospreason`, u.`lastip_login`, u.`lastip_signup`, u.`last_login`, u.`friend_count`, u.`enemy_count`, u.`sig`, u.`married`, c.`cityid`, c.`cityname`, h.`hID`, h.`hNAME`, h.`hWILL`, g.`gangID`, g.`gangNAME`, f.`fed_userid`, f.`fed_days`, f.`fed_jailedby`, f.`fed_reason`, uu.`userid` AS `fed_jailer_id`, uu.`username` AS `fed_jailer` FROM `users` u LEFT JOIN `cities` c ON u.`location` = c.`cityid` LEFT JOIN `houses` h ON u.`maxwill` = h.`hWILL` LEFT JOIN `gangs` g ON g.`gangID` = u.`gang` LEFT JOIN `fedjail` f ON f.`fed_userid` = u.`userid` LEFT JOIN `users` uu ON f.`fed_jailedby` = uu.`userid` WHERE u.`userid` = '%u'", $_GET['u']));[/code

[Magictallguy]

Re: Jobs on view user

 

<?php
$qqery = $db->query(sprintf(
"SELECT `u`.*, `c`.`cityid`, `c`.`cityname`, `h`.`hID`, `h`.`hNAME`, `h`.`hWILL`, `g`.`gangID`, `g`.`gangNAME`, `f`.*, `uu`.`userid` AS `fed_jailer_id`, `uu`.`username` AS `fed_jailer`, `j`.`jNAME`, `jr`.`jrNAME` " .
"FROM `users` `u` " .
"LEFT JOIN `cities` `c` ON (`u`.`location` = `c`.`cityid`) " .
"LEFT JOIN `houses` `h` ON (`u`.`maxwill` = `h`.`hWILL`) " .
"LEFT JOIN `gangs` `g` ON (`g`.`gangID` = `u`.`gang`) " .
"LEFT JOIN `fedjail` `f` ON (`f`.`fed_userid` = `u`.`userid`) " .
"LEFT JOIN `users` `uu` ON (`f`.`fed_jailedby` = `uu`.`userid`) " .
"LEFT JOIN `jobs` `j` ON (`j`.`jID` = `u`.`job`) " .
"LEFT JOIN `jobranks` `jr` ON (`jr`.`jrID` = `u`.`jobrank`) " .
"WHERE (`u`.`userid` = %u)", abs(@intval($_GET['u']))));

[Saberman]

Re: Jobs on view user

Thank you +1