0) { //phpbb connector must have been previously installed echo "phpBB Connector has been previously installed... Converting cb_phpbbid field to cb_forumid (CB Connector format)"; //copy cb_phpbbid to cb_forumid //then delete the cb_phpbbid column //assuming cb_forumid is new lets drop that column and rename the cb_phpbbid to cb_forumid $sql = "SHOW COLUMNS FROM #__comprofiler LIKE 'cb_forumid'"; $results = getDBlist($sql, $database); if (count($results)>0) { $sql = "ALTER TABLE #__comprofiler DROP COLUMN cb_forumid"; insertDB($sql, $database); echo "cb_forumid field dropped (so it can rename cb_phpbbid)"; } $sql = "ALTER TABLE #__comprofiler CHANGE cb_phpbbid cb_forumid varchar(255)"; insertDB($sql, $database); $return .= "cb_phpbbid field renamed to cb_forumid"; //cleanup jos_comprofiler_fields $sql = "DELETE FROM #__comprofiler_fields WHERE name='cb_phpbbid'"; insertDB($sql, $database); $return .= "comprofiled_fields table cleaned up"; $return .= "Upgrade Completed Successfully!"; } if ($sameDBCheck) { //do check for phpbb_users table $return .= ""; } $return .= "CB Connector installed correctly!"; return $return; } ?>