public static function getCustomUserFieldsArray() { $dbc = XenForo_Application::get('db'); $q = $dbc->fetchRow("SELECT `data_value`\n\t\t\t\t\t\t\t FROM `xf_data_registry`\n\t\t\t\t\t\t\t WHERE `data_key` = 'languages';"); unset($dbc); $q = $q['data_value']; $oq = unserialize($q)[1]['phrase_cache']; $q = array('username' => 'User name', 'gender' => 'Gender', 'location' => 'Location', 'homepage' => 'Home Page', 'occupation' => 'Occupation', 'about' => 'About Me', 'signature' => 'Signature'); $k = array_keys($oq); for ($i = 0; $i < count($k); $i++) { if (ProfileNdx_indexer_shared::startsWith($k[$i], 'user_field_')) { $str = $k[$i]; $len = count($str); $str = substr($str, 11); $q[$str] = $oq['user_field_' . $str]; } } unset($k); unset($oq); return $q; }