if (!class_exists('titania_type_translation')) { require TITANIA_ROOT . 'includes/types/translation.php'; } // Give founders access to run this if (phpbb::$user->data['user_type'] != USER_FOUNDER) { titania::needs_auth(); } // Hopefully this helps @set_time_limit(0); // Delete all translations $contrib = new titania_contribution(); $sql = 'SELECT * FROM ' . TITANIA_CONTRIBS_TABLE . ' WHERE contrib_type = ' . TITANIA_TYPE_TRANSLATION; $result = phpbb::$db->sql_query($sql); while ($row = phpbb::$db->sql_fetchrow($result)) { $contrib->__set_array($row); $contrib->delete(); } phpbb::$db->sql_freeresult($result); // All the language packs we'll need, we wont transfer inactive ones, they need to be cleaned up anyways $sql = 'SELECT * FROM lang_packs WHERE display > 0 AND version = 3'; $result = $db->sql_query($sql); // All the authors we'll need $sql2 = 'SELECT * FROM lang_packs_authors WHERE lang_id IN ( SELECT lang_id FROM lang_packs WHERE display > 0 ) '; $authors = $db->sql_fetchrowset($db->sql_query($sql2)); $i = 0; while ($row = $db->sql_fetchrow($result)) { $permalink = titania_url::url_slug($row['english_name']); $conflict = $cnt = false; do { $permalink_test = $cnt !== false ? $permalink . '_' . $cnt : $permalink; $sql = 'SELECT contrib_id FROM ' . TITANIA_CONTRIBS_TABLE . '