InfoPath Code - Loop through items in a secondary data source from a SharePoint List

The article linked below demonstrates using JScript or VBScript, how to loop through items in a secondary data source until one is found which either contains a specific value, or has a specific value for a known attribute.

InfoPath - Update Repeating Elements in a Secondary Data Source

Fix Corrupt Table in PhpBB3 MySQL Database - Grant Administrator/Founder using PhpMyAdmin

• How to fix corrupt table in PhpBB3 Database using PhpMyAdmin (phpbb_users table corrupt in PhpBB3 forum).
• How to add a forum administrator/founder using PhpMyAdmin.

PhpBB3 is used for a forum application. The forums were all working fine until I started receiving the following SQL error when trying to access the forum website:

Can't open file: 'phpbb_users.MYI'. (errno: 145) [1016]

The users table in the database had become corrupt or deadlocked.