modules/item/view.psp doesn't work properly on RE website

[gladio78]

Unfortunately in a RE website it doesn't show which mob drop the item correctly because it checks in the PRE-RE table

FluxCP/modules/item/view.php

Line 55 in 430d493

$fromTables = array("{$server->charMapDatabase}.mob_db", "{$server->charMapDatabase}.mob_db2");

should be (tested it work):

if($server->isRenewal) {
$fromTables = array("{$server->charMapDatabase}.mob_db_re", "{$server->charMapDatabase}.mob_db2_re");
} else {
$fromTables = array("{$server->charMapDatabase}.mob_db", "{$server->charMapDatabase}.imob_db2");
}

[CyberDevil75]

I confirm the existence of this bug and that the fix indicated by gladio78 works perfectly.
I also confirm that this bug is in 2 other files:

/module/logdata/pick.php - line 73
/modules/logdata/zeny.php - line 65

Tnx a lot Gladio!