Advertisement:

Author Topic: Ultimate Profile  (Read 791317 times)

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 59,394
  • Gender: Male
    • Kindred-999 on GitHub
Re: Ultimate Profile
« Reply #3220 on: July 10, 2020, 04:01:29 PM »
This mod DOES work on 2.0.17 with no errors.
There are some tweaks needed, however.

(There may be some additional changes needed to the installer - specifically for mysqli and a missing column)

first, the change for mysqli in Subs-Members.php (after the mod is installed)

just noticed some mysqli db_fetch_assoc errors appearing when deleting members


this change is needed to make the mod code updated for mysqli compatability (and thus working on 2.0.15)

Code: (in Subs-Members.php) [Select]
$smcFunc['db_query']('', '
SELECT ID_PICTURE
FROM {db_prefix}profile_pictures
WHERE id_member IN ({array_int:users})',
array(
'users' => $users,
)
);

require_once($sourcedir . '/Profile-Pictures.php');
while ($row = $smcFunc['db_fetch_assoc']($request)) {
delete_picture($row['ID_PICTURE']);
}

Code: (change to) [Select]
//modified Ultimate Profile mod for mysqli updates
$request = $smcFunc['db_query']('', '
SELECT ID_PICTURE
FROM {db_prefix}profile_pictures
WHERE id_member IN ({array_int:users})',
array(
'users' => $users,
)
);

require_once($sourcedir . '/Profile-Pictures.php');
while ($row = $smcFunc['db_fetch_assoc']($request)) {
delete_picture($row['ID_PICTURE']);
}
$smcFunc['db_free_result']($request);


there may be other places that similar updates need to be made, but I haven't triggered them yet.

I also removed the tables in the mod and converted them to divs.
(this version also has a block for the SMF-Trader system)
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.