Topic: Ultimate Profile

[Kindred]

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)