Advertisement:

Author Topic: Ultimate Profile  (Read 793260 times)

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 59,864
  • 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.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."