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);
}
