function mysupport_do_install() { global $db, $cache, $mysupport_uninstall_confirm_override; // this is so we override the confirmation when trying to uninstall, so we can just run the uninstall code $mysupport_uninstall_confirm_override = true; mysupport_do_uninstall(); mysupport_table_columns(1); if (!$db->table_exists("mysupport")) { $db->write_query("\r\n\t\t\tCREATE TABLE " . TABLE_PREFIX . "mysupport (\r\n\t\t\t\t`mid` SMALLINT(5) NOT NULL AUTO_INCREMENT PRIMARY KEY ,\r\n\t\t\t\t`type` VARCHAR(20) NOT NULL ,\r\n\t\t\t\t`name` VARCHAR(255) NOT NULL ,\r\n\t\t\t\t`description` VARCHAR(500) NOT NULL,\r\n\t\t\t\t`extra` VARCHAR(255) NOT NULL\r\n\t\t\t) ENGINE = MYISAM ;\r\n\t\t"); } $settings_group = array("name" => "mysupport", "title" => "MySupport Settings", "description" => "Settings for the MySupport plugin.", "disporder" => "28", "isdefault" => "no"); $db->insert_query("settinggroups", $settings_group); mysupport_import_settings(); mysupport_do_templates(1); mysupport_stylesheet(1); // insert some default priorities $priorities = array(); $priorities[] = array("type" => "priority", "name" => "Low", "description" => "Low priority threads.", "extra" => "ADCBE7"); $priorities[] = array("type" => "priority", "name" => "Normal", "description" => "Normal priority threads.", "extra" => "D6ECA6"); $priorities[] = array("type" => "priority", "name" => "High", "description" => "High priority threads.", "extra" => "FFF6BF"); $priorities[] = array("type" => "priority", "name" => "Urgent", "description" => "Urgent priority threads.", "extra" => "FFE4E1"); foreach ($priorities as $priority) { $db->insert_query("mysupport", $priority); } mysupport_insert_task(); // set some values for the staff groups $update = array("canmarksolved" => 1, "canmarktechnical" => 1, "canseetechnotice" => 1, "canassign" => 1, "canbeassigned" => 1, "cansetpriorities" => 1, "canseepriorities" => 1, "canmanagesupportdenial" => 1); $db->update_query("usergroups", $update, "gid IN ('3','4','6')"); change_admin_permission("config", "mysupport", 1); $cache->update_forums(); $cache->update_usergroups(); mysupport_cache(); }
function cloudflare_deactivate() { global $db, $mybb; include MYBB_ROOT . "/inc/adminfunctions_templates.php"; find_replace_templatesets("postbit", "#" . preg_quote('{$post[\'cloudflare_spam\']}') . "#i", '', 0); find_replace_templatesets("postbit_classic", "#" . preg_quote('{$post[\'cloudflare_spam\']}') . "#i", '', 0); find_replace_templatesets('footer', '#<!-- End powered by --><cfb>#', '<!-- End powered by -->'); $db->delete_query("templates", "title = 'cloudflare_postbit_spam'"); change_admin_permission("cloudflare", "", -1); }
function upgrade11_run() { newpoints_add_setting('newpoints_income_referral', 'income', 'Per Referral', 'Amount of points received everytime a user is referred. (the referred user is who receives the points)', 'text', '5', 12); change_admin_permission("newpoints", "upgrades", 1); newpoints_remove_templates("'newpoints_donate'"); newpoints_add_template('newpoints_donate', ' <html> <head> <title>{$lang->newpoints} - {$lang->newpoints_donate}</title> {$headerinclude} </head> <body> {$header} <table width="100%" border="0" align="center"> <tr> <td valign="top" width="180"> <table border="0" cellspacing="{$theme[\'borderwidth\']}" cellpadding="{$theme[\'tablespace\']}" class="tborder"> <tr> <td class="thead"><strong>{$lang->newpoints_menu}</strong></td> </tr> {$options} </table> </td> <td valign="top"> <form action="newpoints.php" method="POST"> <input type="hidden" name="postcode" value="{$mybb->post_code}"> <input type="hidden" name="action" value="do_donate"> <table border="0" cellspacing="{$theme[\'borderwidth\']}" cellpadding="{$theme[\'tablespace\']}" class="tborder"> <tr> <td class="thead" colspan="2"><strong>{$lang->newpoints_donate}</strong></td> </tr> <tr> <td class="trow1" width="50%"><strong>{$lang->newpoints_user}:</strong><br /><span class="smalltext">{$lang->newpoints_user_desc}</span></td> <td class="trow1" width="50%"><input type="text" name="username" value="{$user[\'username\']}" class="textbox"></td> </tr> <tr> <td class="trow2" width="50%"><strong>{$lang->newpoints_amount}:</strong><br /><span class="smalltext">{$lang->newpoints_amount_desc}</span></td> <td class="trow2" width="50%"><input type="text" name="amount" value="" class="textbox"></td> </tr> <tr> <td class="trow1" width="50%"><strong>{$lang->newpoints_reason}:</strong><br /><span class="smalltext">{$lang->newpoints_reason_desc}</span></td> <td class="trow1" width="50%"><input type="text" name="reason" value="" class="textbox"></td> </tr> <tr> <td class="tfoot" width="100%" colspan="2" align="center"><input type="submit" name="submit" value="{$lang->newpoints_submit}"></td> </tr> </table> </form> </td> </tr> </table> {$footer} </body> </html>'); }
function akismet_deactivate() { global $db, $mybb; include MYBB_ROOT . "/inc/adminfunctions_templates.php"; find_replace_templatesets("postbit", "#" . preg_quote('{$post[\'button_spam\']}') . "#i", '', 0); find_replace_templatesets("postbit_classic", "#" . preg_quote('{$post[\'button_spam\']}') . "#i", '', 0); $db->delete_query("templates", "title = 'akismet_postbit_spam'"); change_admin_permission('forum', 'akismet', -1); }
function newpoints_plugin_deactivate() { global $db, $mybb; newpoints_remove_templates("'newpoints_postbit','newpoints_profile','newpoints_donate','newpoints_donate_inline','newpoints_statistics','newpoints_statistics_richest_user','newpoints_statistics_donation','newpoints_no_results','newpoints_option','newpoints_home'"); newpoints_undo_template_edits(); //Change admin permissions change_admin_permission("newpoints", false, -1); change_admin_permission("newpoints", "plugins", -1); change_admin_permission("newpoints", "settings", -1); change_admin_permission("newpoints", "log", -1); change_admin_permission("newpoints", "maintenance", -1); change_admin_permission("newpoints", "forumrules", -1); change_admin_permission("newpoints", "grouprules", -1); change_admin_permission("newpoints", "stats", -1); change_admin_permission("newpoints", "upgrades", -1); }
function ougc_pages_uninstall() { global $db, $PL, $cache; ougc_pages_pl_check(); // Drop DB entries $db->drop_table('ougc_pages'); $db->drop_table('ougc_pages_categories'); $PL->cache_delete('ougc_pages'); $PL->settings_delete('ougc_pages'); $PL->templates_delete('ougcpages'); // Delete version from cache $plugins = (array) $cache->read('ougc_plugins'); if (isset($plugins['pages'])) { unset($plugins['pages']); } if (!empty($plugins)) { $cache->update('ougc_plugins', $plugins); } else { $PL->cache_delete('ougc_plugins'); } // Remove administrator permissions change_admin_permission('config', 'ougc_pages', -1); }
function automedia_deactivate() { global $db, $mybb, $cache; change_admin_permission('tools', 'automedia', -1); automedia_cache(true); /** * * Restore templates * **/ require_once MYBB_ROOT . "/inc/adminfunctions_templates.php"; find_replace_templatesets("usercp_nav_misc", "#" . preg_quote('</a></td></tr><tr><td class="trow1 smalltext"><a href="usercp.php?action=userautomedia" class="usercp_nav_item usercp_nav_options">{$lang->av_ucp_menu}') . "#s", '', '', false); find_replace_templatesets("usercp_nav_misc", "#" . preg_quote('<tr><td class="trow1 smalltext"><a href="usercp.php?action=userautomedia" class="usercp_nav_item usercp_nav_options">AutoMedia</a></td></tr>') . "#s", '', '', false); // Delete master templates for upgrade $db->delete_query("templategroups", "prefix = 'automedia'"); $db->delete_query("templates", "title LIKE 'automedia_%' AND sid='-2'"); }
function replyban_deactivate() { global $db; $db->delete_query("templates", "title IN('moderation_replyban','moderation_replyban_bit','moderation_replyban_no_bans','moderation_replyban_liftlist','showthread_replybanlink')"); include MYBB_ROOT . "/inc/adminfunctions_templates.php"; find_replace_templatesets("showthread", "#" . preg_quote('{$replybanlink}') . "#i", '', 0); change_admin_permission('tools', 'replybans', -1); }
function edithistory_deactivate() { global $db; $db->delete_query("settings", "name IN('editmodvisibility','editrevert','editsperpages','edithistorychar')"); $db->delete_query("settinggroups", "name IN('edithistory')"); $db->delete_query("templates", "title IN('edithistory','edithistory_nohistory','edithistory_item','edithistory_item_revert','edithistory_item_readmore','postbit_edithistory','edithistory_comparison','edithistory_view')"); rebuild_settings(); include MYBB_ROOT . "/inc/adminfunctions_templates.php"; find_replace_templatesets("postbit", "#" . preg_quote('{$post[\'edithistory\']}') . "#i", '', 0); find_replace_templatesets("postbit_classic", "#" . preg_quote('{$post[\'edithistory\']}') . "#i", '', 0); change_admin_permission('tools', 'edithistory', -1); }
function upgrade17_dbchanges5() { global $db, $output, $mybb, $cache; if (file_exists(MYBB_ROOT . $mybb->config['admin_dir'] . "/inc/functions.php")) { require_once MYBB_ROOT . $mybb->config['admin_dir'] . "/inc/functions.php"; } else { if (file_exists(MYBB_ROOT . "admin/inc/functions.php")) { require_once MYBB_ROOT . "admin/inc/functions.php"; } else { $output->print_error("Please make sure your admin directory is uploaded correctly."); } } $output->print_header("Performing Queries"); echo "<p>Performing necessary upgrade queries..</p>"; flush(); $db->update_query("spiders", array('name' => 'Bing'), "name='MSN Search'"); $db->update_query("spiders", array('useragent' => 'Googlebot', 'name' => 'Google'), "useragent='google'"); $db->update_query("spiders", array('useragent' => 'Teoma', 'name' => 'Ask.com'), "useragent='ask jeeves'"); $db->delete_query("spiders", "name='Hot Bot'"); $db->update_query("spiders", array('useragent' => 'archive_crawler', 'name' => 'Internet Archive'), "name='Archive.org'"); $db->update_query("spiders", array('name' => 'Alexa Internet'), "useragent='ia_archiver'"); $db->delete_query("spiders", "useragent='scooter'"); $db->update_query("spiders", array('useragent' => 'Slurp'), "name='Yahoo!'"); $query = $db->simple_select("spiders", "COUNT(*) as numexists", "useragent='twiceler'"); if ($db->fetch_field($query, "numexists") == 0) { $db->insert_query("spiders", array('name' => "Cuil", 'useragent' => 'twiceler')); } $query = $db->simple_select("spiders", "COUNT(*) as numexists", "useragent='Baiduspider'"); if ($db->fetch_field($query, "numexists") == 0) { $db->insert_query("spiders", array('name' => "Baidu", 'useragent' => 'Baiduspider')); } $db->update_query("attachtypes", array('mimetype' => 'application/x-httpd-php'), "extension='php'"); $db->update_query("attachtypes", array('mimetype' => 'text/html'), "extension='htm'"); $db->update_query("attachtypes", array('mimetype' => 'text/html'), "extension='html'"); $db->update_query("attachtypes", array('mimetype' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'), "extension='docx'"); $db->update_query("attachtypes", array('mimetype' => 'application/vnd.ms-excel'), "extension='xls'"); $db->update_query("attachtypes", array('mimetype' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'), "extension='xlsx'"); $db->update_query("attachtypes", array('mimetype' => 'application/vnd.ms-powerpoint'), "extension='ppt'"); $db->update_query("attachtypes", array('mimetype' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation'), "extension='pptx'"); $cache->update_moderators(); $db->update_query("themes", array('allowedgroups' => 'all'), "allowedgroups='' OR allowedgroups IS NULL"); // Add permissions for all of our new ACP pages change_admin_permission('config', 'thread_prefixes'); change_admin_permission('tools', 'file_verification'); change_admin_permission('tools', 'statistics'); $contents .= "Click next to continue with the upgrade process.</p>"; $output->print_contents($contents); global $footer_extra; $footer_extra = "<script type=\"text/javascript\">\$(document).ready(function() { var button = \$('.submit_button'); if(button) { button.val('Automatically Redirecting...'); button.prop('disabled', true); button.css('color', '#aaa'); button.css('border-color', '#aaa'); document.forms[0].submit(); } });</script>"; $output->print_footer("17_dbchanges6"); }
function ougc_awards_uninstall() { global $db, $PL, $cache; ougc_awards_pl_check(); // Drop DB entries $db->drop_table('ougc_awards'); $db->drop_table('ougc_awards_users'); !$db->field_exists('ougc_awards', 'users') or $db->drop_column('users', 'ougc_awards'); $PL->settings_delete('ougc_awards'); $PL->templates_delete('ougcawards'); // Delete version from cache $plugins = (array) $cache->read('ougc_plugins'); if (isset($plugins['awards'])) { unset($plugins['awards']); } if (!empty($plugins)) { $cache->update('ougc_plugins', $plugins); } else { $PL->cache_delete('ougc_plugins'); } // Remove administrator permissions change_admin_permission('tools', 'ougc_awards', -1); }
function upgrade17_dbchanges5() { global $db, $output, $mybb, $cache; if (file_exists(MYBB_ROOT . $mybb->config['admin_dir'] . "/inc/functions.php")) { require_once MYBB_ROOT . $mybb->config['admin_dir'] . "/inc/functions.php"; } else { if (file_exists(MYBB_ROOT . "admin/inc/functions.php")) { require_once MYBB_ROOT . "admin/inc/functions.php"; } else { $output->print_error("Upewnij się, że katalog /admin został poprawnie załadowany na serwer."); } } $output->print_header("Wykonywanie zapytań"); echo "<p>Trwa wykonywanie wymaganych zapytań do bazy danych...</p>"; flush(); $db->update_query("spiders", array('name' => 'Bing'), "name='MSN Search'"); $db->update_query("spiders", array('useragent' => 'Googlebot', 'name' => 'Google'), "useragent='google'"); $db->update_query("spiders", array('useragent' => 'Teoma', 'name' => 'Ask.com'), "useragent='ask jeeves'"); $db->delete_query("spiders", "name='Hot Bot'"); $db->update_query("spiders", array('useragent' => 'archive_crawler', 'name' => 'Internet Archive'), "name='Archive.org'"); $db->update_query("spiders", array('name' => 'Alexa Internet'), "useragent='ia_archiver'"); $db->delete_query("spiders", "useragent='scooter'"); $db->update_query("spiders", array('useragent' => 'Slurp'), "name='Yahoo!'"); $query = $db->simple_select("spiders", "COUNT(*) as numexists", "useragent='twiceler'"); if ($db->fetch_field($query, "numexists") == 0) { $db->insert_query("spiders", array('name' => "Cuil", 'useragent' => 'twiceler')); } $query = $db->simple_select("spiders", "COUNT(*) as numexists", "useragent='Baiduspider'"); if ($db->fetch_field($query, "numexists") == 0) { $db->insert_query("spiders", array('name' => "Baidu", 'useragent' => 'Baiduspider')); } $db->update_query("attachtypes", array('mimetype' => 'application/x-httpd-php'), "extension='php'"); $db->update_query("attachtypes", array('mimetype' => 'text/html'), "extension='htm'"); $db->update_query("attachtypes", array('mimetype' => 'text/html'), "extension='html'"); $db->update_query("attachtypes", array('mimetype' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'), "extension='docx'"); $db->update_query("attachtypes", array('mimetype' => 'application/vnd.ms-excel'), "extension='xls'"); $db->update_query("attachtypes", array('mimetype' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'), "extension='xlsx'"); $db->update_query("attachtypes", array('mimetype' => 'application/vnd.ms-powerpoint'), "extension='ppt'"); $db->update_query("attachtypes", array('mimetype' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation'), "extension='pptx'"); $cache->update_moderators(); $db->update_query("themes", array('allowedgroups' => 'all'), "allowedgroups='' OR allowedgroups IS NULL"); // Add permissions for all of our new ACP pages change_admin_permission('config', 'thread_prefixes'); change_admin_permission('tools', 'file_verification'); change_admin_permission('tools', 'statistics'); $contents .= "Naciśnij przycisk Dalej, aby kontynuować proces aktualizacji.</p>"; $output->print_contents($contents); global $footer_extra; $footer_extra = "<script type=\"text/javascript\">window.onload = function() { var button = \$\$('.submit_button'); if(button[0]) { button[0].value = 'Automatyczne przekierowanie...'; button[0].disabled = true; button[0].style.color = '#aaa'; button[0].style.borderColor = '#aaa'; document.forms[0].submit(); }}</script>"; $output->print_footer("17_dbchanges6"); }
function asb_deactivate() { // remove the permissions change_admin_permission('config', 'asb', -1); }