Jump to content

Snikos Advanced houses - viewuser error after install


Recommended Posts

EDIT: Nevermind I just missed to include maxwill_before in my query. Duh.

Hey guys so I got snikos property mod and it works great apart from on view user.

When I go to viewuser I get this:

Sorry, we could not find a user with that ID, check your source.

It's clearly just a sql error but it's been racking at my brains for a good 2 hours.

Here's my query

$q =
                   "SELECT *
                   FROM `users` `u`
                   INNER JOIN `cities` AS `c`
                   ON `u`.`location` = `c`.`cityid`
                   INNER JOIN `houses` AS `h`
                   ON `u`.`maxwill` = h.`hWILL`
                   LEFT JOIN `gangs` AS `g`
                   ON `g`.`gangID` = `u`.`gang`
                   LEFT JOIN `fedjail` AS `f`
                   ON `f`.`fed_userid` = `u`.`userid`
                   WHERE `u`.`userid` = {$_GET['u']}");
   if ($db->num_rows($q) == 0)
       echo 'Sorry, we could not find a user with that ID, check your source.';


In globals I have this:

if ($housequery)
$is=$db->query("SELECT u.*,us.*,h.* FROM users u LEFT JOIN
userstats us ON
u.userid=us.userid LEFT JOIN
houses h ON h.hWILL=
WHERE u.userid=$userid");

   $is =
                   "SELECT `u`.*, `us`.*
                    FROM `users` AS `u`
                    INNER JOIN `userstats` AS `us`
                    ON `u`.`userid`=`us`.`userid`
                    WHERE `u`.`userid` = {$userid}
                    LIMIT 1");
$ir = $db->fetch_row($is);
if(array_key_exists('hNAME', $ir)) {
$ir['hNAME'] = ($ir['houseid_row'] > 0) ? get_house_name_by_row($ir['houseid_row']) :

The error only shows if the player is using a house from the new property system.

If anyone can help me out that'd be great! :D

Edited by Zettieee
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...