Well I'll be damned... that was EXACTLY it.
Go to modules\item and look for a file called index.php
You're going to look for something like this in that file (I used notepad):
try {
if($server->isRenewal) {
$fromTables = array("{$server->charMapDatabase}.item_db_re", "{$server->charMapDatabase}.item_db2_re");
} else {
$fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db2");
}
I changed it to this and it worked:
if($server->isRenewal) {
$fromTables = array("{$server->charMapDatabase}.item_db_re_compat", "{$server->charMapDatabase}.item_db2_re_compat");
} else {
$fromTables = array("{$server->charMapDatabase}.item_db_compat", "{$server->charMapDatabase}.item_db2_compat");
}
*** EDIT 2 ***
You also gotta do the same for a file called view.php inside of: modules\character
Go to the following line:
if($server->isRenewal) {
$fromTables = array("{$server->charMapDatabase}.item_db_re", "{$server->charMapDatabase}.item_db2_re");
$mobdb = array("mob_db_re","mob_db2_re");
} else {
$fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db2");
Then change it to:
if($server->isRenewal) {
$fromTables = array("{$server->charMapDatabase}.item_db_re_compat", "{$server->charMapDatabase}.item_db2_re_compat");
$mobdb = array("mob_db_re","mob_db2_re");
} else {
$fromTables = array("{$server->charMapDatabase}.item_db_compat", "{$server->charMapDatabase}.item_db2_compat");
*** EDIT 3 ***
LoL... found another... view.php inside of: modules\item
Went to the following line:
if($server->isRenewal) {
$fromTables = array("{$server->charMapDatabase}.item_db_re", "{$server->charMapDatabase}.item_db2_re");
$mobdb = array("mob_db_re","mob_db2_re");
} else {
$fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db2");
$mobdb = array("mob_db","mob_db2");
And then changed it:
if($server->isRenewal) {
$fromTables = array("{$server->charMapDatabase}.item_db_re_compat", "{$server->charMapDatabase}.item_db2_re_compat");
$mobdb = array("mob_db_re","mob_db2_re");
} else {
$fromTables = array("{$server->charMapDatabase}.item_db_compat", "{$server->charMapDatabase}.item_db2_compat");
$mobdb = array("mob_db","mob_db2");
There's an obvious pattern here... so if you find a broken item link, just keep following the path...