Table Structure (ranks and banlist)

Posted: Wed Mar 08, 2006 9:31 am

I noticed when comparing the phpBB tables and the phpNuke tables that two of them are different.

phpNuke adds a field 'rank_max' to the ranks table. This does not seem to be used in the code at all.

phpNuke also adds several fields to the banlist table. `ban_time` `ban_expire_time` `ban_by_userid` `ban_priv_reason` `ban_pub_reason_mode` `ban_pub_reason`

I cannot find any mods that use them, nor how this got into phpNuke in the first place. It is included in the 60-65.php upgrade script, so it looks like it may have been a part of BBToNuke from the start. For what reason, I have no idea.

I removed those fields and don't seem to have any problems. If someone could try and confirm this, I'd appreciate it. Smile

Site Admin Joined: Jun 04, 2004 Posts: 6433

Nice... I wonder how many more extras we'd find if we checked carefully. Thanks, evaders99!

Posted: Wed Mar 08, 2006 10:24 pm

The thing is that it screws up my phpBB to phpNuke script that I wrote Wink

I didn't find the other ones out there to be efficient.
Had to create a special case of this issue, removing the table fields before transfering the data.

Overall, its probably not a big concern.. unless you are really lacking disk space for the database or have millions of ranks and bans Wink

Posted: Fri Mar 10, 2006 12:59 pm

Since I'm done testing and everything runs, I'm releasing it here
[ Only registered users can see links on this board! Get registered or login! ]

Hope people find it useful