Fields in various base modules are not listed as an integer/binary

[yuliu]

It has a default value of 1. https://github.com/mybb/merge-system/blob/d453ec2b922a088cfa41a81753c37b7f038ecb77/resources/modules/forums.php#L35

But not listed in the $integer_fields array in /resources/modules/forums.php.

[yuliu]

Similarly, here's a list of fields that haven't been categorized in corresponding base modules (the types are from MySQL's table definitions):

Integer fields

• Usergroups (usergroups)

  • canviewboardclosed (tinyint(1))
  • modposts (tinyint(1))
  • modthreads (tinyint(1))
  • mod_edit_posts (tinyint(1))
  • modattachments (tinyint(1))
  • canviewdeletionnotice (tinyint(1))
  • cansendemailoverride (tinyint(1))
  • maxemails (int unsigned)
  • emailfloodtime (int unsigned)
  • canbypasseventmod (tinyint(1))
  • canmoderateevents (tinyint(1))
  • canbereported (tinyint(1))
  • canchangewebsite (tinyint(1))
  • candeletereputations (tinyint(1))
  • canwarnusers (tinyint(1))
  • canreceivewarnings (tinyint(1))
  • maxwarningsday (int unsigned)
  • canmodcp (tinyint(1))
  • showinbirthdaylist (tinyint(1))
  • canoverridepm (tinyint(1))
  • canusesigxposts (smallint unsigned)
  • signofollow (tinyint(1))
  • edittimelimit (int unsigned)
  • maxposts (int unsigned)
  • showmemberlist (tinyint(1))
  • canmanageannounce (tinyint(1))
  • canmanagemodqueue (tinyint(1))
  • canmanagereportedcontent (tinyint(1))
  • canviewmodlogs (tinyint(1))
  • caneditprofiles (tinyint(1))
  • canbanusers (tinyint(1))
  • canviewwarnlogs (tinyint(1))
  • canuseipsearch (tinyint(1))

• Users (users)

  • threadnum (int unsigned)
  • buddyrequestspm (tinyint(1))
  • buddyrequestsauto (tinyint(1))
  • loginlockoutexpiry (int unsigned)
  • sourceeditor (tinyint(1))

• Forums (forums / categories)

  • allowvideocode (tinyint(1))
  • requireprefix (tinyint(1))
  • deletedthreads (int unsigned)
  • deletedposts (int unsigned)

• Forum Permissions (forumperms)

  • fid (int unsigned)
  • canonlyreplyownthreads (tinyint(1))
  • canviewdeletionnotice (tinyint(1))
  • modposts (tinyint(1))
  • modthreads (tinyint(1))
  • mod_edit_posts (tinyint(1))
  • modattachments (tinyint(1))

• Threads (threads)

  • deletedposts (int unsigned)

• Polls (polls)

  • maxoptions (smallint unsigned)

• Poll Votes (pollvotes)

  • pid (int unsigned)

• Moderators (moderators)

  • cansoftdeleteposts (tinyint(1))
  • canrestoreposts (tinyint(1))
  • cansoftdeletethreads (tinyint(1))
  • canrestorethreads (tinyint(1))
  • candeletethreads (tinyint(1))
  • canviewunapprove (tinyint(1))
  • canviewdeleted (tinyint(1))
  • canstickunstickthreads (tinyint(1))
  • canapproveunapprovethreads (tinyint(1))
  • canapproveunapproveposts (tinyint(1))
  • canapproveunapproveattachs (tinyint(1))
  • canmanagepolls (tinyint(1))
  • canpostclosedthreads (tinyint(1))
  • canusecustomtools (tinyint(1))
  • canmanageannouncements (tinyint(1))
  • canmanagereportedposts (tinyint(1))
  • canviewmodlog (tinyint(1))

• Private Messages (privatemessages)

  • smilieoff (tinyint(1))

Binary fields

• Poll Votes (pollvotes)
  • ipaddress (varbinary(16))