<?php
/**
* upgrader to version 2.0.4
*/
define('NO_TEMPLATE',true);
$CALL_SYSTEM = array();
$CALL_SYSTEM['SECTION'] = true;
include('../common.php');
class PowerBBTHETA extends PowerBBInstall
{
var $_TempArr = array();
var $_Masseges = array();
function CheckVersion()
{
global $PowerBB;
return ($PowerBB->_CONF['info_row']['MySBB_version'] == '2.0.3') ? true : false;
}
function UpdateVersion()
{
global $PowerBB;
$update = $PowerBB->DB->sql_query("UPDATE " . $PowerBB->table['info'] . " SET value='2.0.4' WHERE var_name='MySBB_version'");
return ($update) ? true : false;
}
function CreateEmailed()
{
global $PowerBB;
$this->_TempArr['CreateArr'] = array();
$this->_TempArr['CreateArr']['table_name'] = $PowerBB->table['emailed'];
$this->_TempArr['CreateArr']['fields'] = array();
$this->_TempArr['CreateArr']['fields'][] = 'id INT( 9 ) NOT NULL AUTO_INCREMENT PRIMARY KEY';
$this->_TempArr['CreateArr']['fields'][] = 'user_id int( 9 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'subject_title VARCHAR( 200 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'section_title VARCHAR( 200 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'subject_id int( 9 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'section_id int( 9 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = "autosubscribe int(1) NOT NULL DEFAULT '0'";
$create = $this->create_table($this->_TempArr['CreateArr']);
return ($create) ? true : false;
}
function CreateVisitor()
{
global $PowerBB;
$this->_TempArr['CreateArr'] = array();
$this->_TempArr['CreateArr']['table_name'] = $PowerBB->table['visitor'];
$this->_TempArr['CreateArr']['fields'] = array();
$this->_TempArr['CreateArr']['fields'][] = 'id INT( 9 ) NOT NULL AUTO_INCREMENT PRIMARY KEY';
$this->_TempArr['CreateArr']['fields'][] = 'lang_id int( 9 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'ip VARCHAR( 100 ) NOT NULL';
$create = $this->create_table($this->_TempArr['CreateArr']);
return ($create) ? true : false;
}
function CreateAward()
{
global $PowerBB;
$this->_TempArr['CreateArr'] = array();
$this->_TempArr['CreateArr']['table_name'] = $PowerBB->table['award'];
$this->_TempArr['CreateArr']['fields'] = array();
$this->_TempArr['CreateArr']['fields'][] = 'id INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY';
$this->_TempArr['CreateArr']['fields'][] = 'award VARCHAR( 200 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'award_path VARCHAR( 250 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'username VARCHAR( 100 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'user_id int( 9 ) NOT NULL';
$create = $this->create_table($this->_TempArr['CreateArr']);
return ($create) ? true : false;
}
function CreateAdsense()
{
global $PowerBB;
$this->_TempArr['CreateArr'] = array();
$this->_TempArr['CreateArr']['table_name'] = $PowerBB->table['adsense'];
$this->_TempArr['CreateArr']['fields'] = array();
$this->_TempArr['CreateArr']['fields'][] = 'id INT( 9 ) NOT NULL AUTO_INCREMENT PRIMARY KEY';
$this->_TempArr['CreateArr']['fields'][] = 'name VARCHAR( 100 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'adsense text NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'home int( 9 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'forum int( 9 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'topic int( 9 ) NOT NULL';
$create = $this->create_table($this->_TempArr['CreateArr']);
return ($create) ? true : false;
}
function CreateFriends()
{
global $PowerBB;
$this->_TempArr['CreateArr'] = array();
$this->_TempArr['CreateArr']['table_name'] = $PowerBB->table['friends'];
$this->_TempArr['CreateArr']['fields'] = array();
$this->_TempArr['CreateArr']['fields'][] = 'id INT( 9 ) NOT NULL AUTO_INCREMENT PRIMARY KEY';
$this->_TempArr['CreateArr']['fields'][] = 'username VARCHAR( 100 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'userid_friend int( 9 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'username_friend VARCHAR( 100 ) NOT NULL';
$this->_TempArr['CreateArr']['fields'][] = 'approval int( 1 ) NOT NULL';
$create = $this->create_table($this->_TempArr['CreateArr']);
return ($create) ? true : false;
}
function AddCharactersKeywordSsearch()
{
global $PowerBB;
$insert = $PowerBB->DB->sql_query('INSERT INTO ' . $PowerBB->table['info'] . " SET var_name='characters_keyword_search',value='3'");
return ($insert) ? true : false;
}
function AddFloodSearch()
{
global $PowerBB;
$insert = $PowerBB->DB->sql_query('INSERT INTO ' . $PowerBB->table['info'] . " SET var_name='flood_search',value='40'");
return ($insert) ? true : false;
}
function AddActivateEmailed()
{
global $PowerBB;
$insert = $PowerBB->DB->sql_query('INSERT INTO ' . $PowerBB->table['info'] . " SET var_name='allowed_emailed',value='1'");
return ($insert) ? true : false;
}
function AddActivateEmailedPM()
{
global $PowerBB;
$insert = $PowerBB->DB->sql_query('INSERT INTO ' . $PowerBB->table['info'] . " SET var_name='allowed_emailed_pm',value='1'");
return ($insert) ? true : false;
}
function AddRewriteRule()
{
global $PowerBB;
$insert = $PowerBB->DB->sql_query('INSERT INTO ' . $PowerBB->table['info'] . " SET var_name='rewriterule',value='0'");
return ($insert) ? true : false;
}
function AddSiteMap()
{
global $PowerBB;
$insert = $PowerBB->DB->sql_query('INSERT INTO ' . $PowerBB->table['info'] . " SET var_name='sitemap',value='0'");
return ($insert) ? true : false;
}
function ChangeAwayMsg()
{
global $PowerBB;
$change = $PowerBB->DB->sql_query("ALTER TABLE " . $PowerBB->table['member'] . " CHANGE away_msg away_msg VARCHAR( 255 ) NOT NULL");
return ($change) ? true : false;
}
function ChangeLangValue()
{
global $PowerBB;
$change = $PowerBB->DB->sql_query("ALTER TABLE " . $PowerBB->table['member'] . " CHANGE lang lang int(9) NOT NULL DEFAULT '1'");
return ($change) ? true : false;
}
function AddIpaddressBan()
{
global $PowerBB;
$change = $PowerBB->DB->sql_query("ALTER TABLE " . $PowerBB->table['banned'] . " ADD ip VARCHAR( 100 ) NOT NULL");
return ($change) ? true : false;
}
function AddReasonBan()
{
global $PowerBB;
$change = $PowerBB->DB->sql_query("ALTER TABLE " . $PowerBB->table['banned'] . " ADD reason VARCHAR( 255 ) NOT NULL");
return ($change) ? true : false;
}
function AddLastSearchTime()
{
global $PowerBB;
$this->_TempArr['AddArr'] = array();
$this->_TempArr['AddArr']['table'] = $PowerBB->table['member'];
$this->_TempArr['AddArr']['field_name'] = 'lastsearch_time';
$this->_TempArr['AddArr']['field_des'] = 'varchar(15) NOT NULL';
$add = $this->add_field($this->_TempArr['AddArr']);
unset($this->_TempArr['AddArr']);
return ($add) ? true : false;
}
function AddPmEmailed()
{
global $PowerBB;
$this->_TempArr['AddArr'] = array();
$this->_TempArr['AddArr']['table'] = $PowerBB->table['member'];
$this->_TempArr['AddArr']['field_name'] = 'pm_emailed';
$this->_TempArr['AddArr']['field_des'] = "int(1) NOT NULL DEFAULT '0'";
$add = $this->add_field($this->_TempArr['AddArr']);
unset($this->_TempArr['AddArr']);
return ($add) ? true : false;
}
function AddPmWindow()
{
global $PowerBB;
$this->_TempArr['AddArr'] = array();
$this->_TempArr['AddArr']['table'] = $PowerBB->table['member'];
$this->_TempArr['AddArr']['field_name'] = 'pm_window';
$this->_TempArr['AddArr']['field_des'] = "int(1) NOT NULL DEFAULT '1'";
$add = $this->add_field($this->_TempArr['AddArr']);
unset($this->_TempArr['AddArr']);
return ($add) ? true : false;
}
function ChangeLangInfo()
{
global $PowerBB;
$update = $PowerBB->info->UpdateInfo(array('value'=>'1','var_name'=>'def_lang'));
return ($update) ? true : false;
}
}
$PowerBB->install = new PowerBBTHETA;
$PowerBB->html->page_header('Ù
Ø¹Ø§ÙØ¬ ترÙÙØ© Ø¨Ø±ÙØ§Ù
ج Ù
ÙØªØ¯Ùات PBBoard 2.0.4');
$logo = $PowerBB->html->create_image(array('align'=>'right','alt'=>'PowerBB','src'=>'../logo.jpg','return'=>true));
$PowerBB->html->open_table('100%',true);
$PowerBB->html->cells($logo,'header_logo_side');
if (!$PowerBB->install->CheckVersion())
{
$PowerBB->html->cells('اصدار ØºÙØ± صØÙØ','main1');
$PowerBB->html->close_table();
$PowerBB->functions->errorstop('ÙØ±Ø¬Ù Ø§ÙØªØÙÙ Ù
٠اÙÙ ÙÙ
ت بتشغÙÙ ØªØØ¯Ùثات upg_203.php');
$PowerBB->html->close_table();
}
if ($PowerBB->_GET['step'] == 0)
{
$PowerBB->html->close_p();
$PowerBB->html->close_table();
$PowerBB->html->cells('Ø§ÙØªØ±ÙÙØ© Ø¥ÙÙ Ø§ÙØ¥ØµØ¯Ø§Ø± 2.0.4 Ù
Ù Ø¨Ø±ÙØ§Ù
ج PBBoard','main1');
$PowerBB->html->close_p();
$PowerBB->html->close_table();
$PowerBB->html->make_link('Ø§ÙØ®Ø·ÙÙ Ø§ÙØ£ÙÙÙ -> Ø£Ø¯Ø®Ø§Ù Ø§ÙØ¥Ø³ØªØ¹ÙاÙ
ات','?step=1');
}
if ($PowerBB->_GET['step'] == 1)
{
$PowerBB->html->cells('عÙ
ÙÙØ§Øª Ø§ÙØ§Ø¶Ø§ÙÙ','main1');
$PowerBB->html->close_table();
$p[1] = $PowerBB->install->AddCharactersKeywordSsearch();
$msgs[1] = ($p[1]) ? 'تÙ
Ø¥ÙØ´Ø§Ø¡ ØÙÙ characters_keyword_search' : 'ÙÙ
ÙØªÙ
Ø¥ÙØ´Ø§Ø¡ ØÙÙ characters_keyword_search';
$p[2] = $PowerBB->install->AddFloodSearch();
$msgs[2] = ($p[2]) ? 'تÙ
Ø§Ø¶Ø§ÙØ© ØÙÙ ØªØØ¯Ùد اÙÙÙØª بÙÙ Ù٠عÙ
ÙÙØ© Ø¨ØØ«' : 'ÙÙ
ÙØªÙ
Ø§Ø¶Ø§ÙØ© ØÙÙ ØªØØ¯Ùد اÙÙÙØª بÙÙ Ù٠عÙ
ÙÙØ© Ø¨ØØ«';
$p[3] = $PowerBB->install->AddActivateEmailed();
$msgs[3] = ($p[3]) ? 'تÙ
Ø§Ø¶Ø§ÙØ© ØÙ٠اÙ
ÙØ§ÙÙØ© ØªÙØ¹ÙÙ ÙØªØ¹Ø·ÙÙ Ø§ÙØ§Ø´ØªØ±Ø§Ùات Ø§ÙØ¨Ø±ÙØ¯ÙØ©' : 'ÙÙ
ÙØªÙ
Ø§Ø¶Ø§ÙØ© ØÙ٠اÙ
ÙØ§ÙÙØ© ØªÙØ¹ÙÙ ÙØªØ¹Ø·ÙÙ Ø§ÙØ§Ø´ØªØ±Ø§Ùات Ø§ÙØ¨Ø±ÙØ¯ÙØ©';
$p[4] = $PowerBB->install->AddActivateEmailedPM();
$msgs[4] = ($p[4]) ? 'تÙ
Ø§Ø¶Ø§ÙØ© ØÙ٠اÙ
ÙØ§ÙÙØ© ØªÙØ¹ÙÙ ÙØªØ¹Ø·Ù٠إرسا٠اشعار Ø¨Ø±ÙØ¯Ù Ø¨ÙØ¬Ùد Ø±Ø³Ø§ÙØ© خاصة Ø¬Ø¯ÙØ¯Ø©' : 'ÙÙ
ÙØªÙ
Ø§Ø¶Ø§ÙØ© ØÙ٠اÙ
ÙØ§ÙÙØ© ØªÙØ¹ÙÙ ÙØªØ¹Ø·Ù٠إرسا٠اشعار Ø¨Ø±ÙØ¯Ù Ø¨ÙØ¬Ùد Ø±Ø³Ø§ÙØ© خاصة Ø¬Ø¯ÙØ¯Ø©';
$p[5] = $PowerBB->install->AddRewriteRule();
$msgs[5] = ($p[5]) ? 'تÙ
Ø§Ø¶Ø§ÙØ© ØÙ٠تØÙÙÙ Ø§ÙØ±Ùابط Ù
Ù html Ø¥ÙÙ php ÙØ§ÙØ¹ÙØ³' : 'ÙÙ
ÙØªÙ
Ø§Ø¶Ø§ÙØ© ØÙ٠تØÙÙÙ Ø§ÙØ±Ùابط Ù
Ù html Ø¥ÙÙ php ÙØ§ÙØ¹ÙØ³';
$p[6] = $PowerBB->install->AddSiteMap();
$msgs[6] = ($p[6]) ? 'تÙ
Ø§Ø¶Ø§ÙØ© ØÙÙ Ù
ÙÙØ¯ Ø§ÙØ®Ø±Ø§Ø¦Ø·' : 'ÙÙ
ÙØªÙ
Ø§Ø¶Ø§ÙØ© ØÙÙ Ù
ÙÙØ¯ Ø§ÙØ®Ø±Ø§Ø¦Ø·';
$PowerBB->html->open_p();
foreach ($msgs as $msg)
{
$PowerBB->html->p_msg($msg);
}
$PowerBB->html->close_p();
$PowerBB->html->close_table();
$PowerBB->html->make_link('Ø§ÙØ®Ø·ÙÙ Ø§ÙØ«Ø§ÙÙØ© -> Ø£Ø¯Ø®Ø§Ù Ø§ÙØ¥Ø³ØªØ¹ÙاÙ
ات','?step=2');
}
if ($PowerBB->_GET['step'] == 2)
{
$PowerBB->html->cells('عÙ
ÙÙØ§Øª Ø§ÙØ§Ø¶Ø§ÙÙ','main1');
$PowerBB->html->close_table();
$p[7] = $PowerBB->install->ChangeAwayMsg();
$msgs[7] = ($p[7]) ? 'تÙ
تغÙÙØ± ØØ¬Ù
ØÙ٠سبب Ø§ÙØºÙاب' : 'ÙÙ
ÙØªÙ
تغÙÙØ± ØØ¬Ù
ØÙ٠سبب Ø§ÙØºÙاب';
$p[8] = $PowerBB->install->AddLastSearchTime();
$msgs[8] = ($p[8]) ? 'تÙ
Ø§Ø¶Ø§ÙØ© ØÙ٠إدخا٠ÙÙØª آخر عÙ
ÙÙØ© Ø¨ØØ« ÙÙØ¹Ø¶Ù' : 'ÙÙ
ÙØªÙ
Ø§Ø¶Ø§ÙØ© ØÙ٠إدخا٠ÙÙØª آخر عÙ
ÙÙØ© Ø¨ØØ« ÙÙØ¹Ø¶Ù';
$p[9] = $PowerBB->install->AddPmEmailed();
$msgs[9] = ($p[9]) ? 'تÙ
Ø§Ø¶Ø§ÙØ© ØÙÙ ØªÙØ¹ÙÙ Ø§Ø³ØªÙØ§Ù
اشعار Ø¨Ø±ÙØ¯Ù Ø¨ÙØ¬Ùد Ø±Ø³Ø§ÙØ© خاصة Ø¬Ø¯ÙØ¯Ø©' : 'ÙÙ
ÙØªÙ
Ø§Ø¶Ø§ÙØ© ØÙÙ ØªÙØ¹ÙÙ Ø§Ø³ØªÙØ§Ù
اشعار Ø¨Ø±ÙØ¯Ù Ø¨ÙØ¬Ùد Ø±Ø³Ø§ÙØ© خاصة Ø¬Ø¯ÙØ¯Ø©';
$p[10] = $PowerBB->install->AddIpaddressBan();
$msgs[10] = ($p[10]) ? 'تÙ
Ø§Ø¶Ø§ÙØ© ØÙÙ ØØ¸Ø± Ø¹ÙØ§ÙÙÙ Ø§ÙØ¢ÙØ¨Ù Ø¢Ø¯Ø±ÙØ³' : 'ÙÙ
ÙØªÙ
Ø§Ø¶Ø§ÙØ© ØÙÙ ØÙÙ ØØ¸Ø± Ø¹ÙØ§ÙÙÙ Ø§ÙØ¢ÙØ¨Ù Ø¢Ø¯Ø±ÙØ³';
$p[11] = $PowerBB->install->AddReasonBan();
$msgs[11] = ($p[11]) ? 'تÙ
Ø§Ø¶Ø§ÙØ© ØÙ٠سبب ØØ¸Ø± Ø§ÙØ¢ÙبÙ' : 'ÙÙ
ÙØªÙ
Ø§Ø¶Ø§ÙØ© ØÙ٠سبب ØØ¸Ø± Ø§ÙØ¢ÙبÙ';
$p[12] = $PowerBB->install->ChangeLangValue();
$msgs[12] = ($p[12]) ? 'تÙ
ØªØºÙØ± ÙÙÙ
Ø© ØÙ٠اÙÙØºØ© Ø§ÙØ¥ÙØªØ±Ø§Ø¶ÙØ© بجدÙÙ Ø§ÙØ£Ø¹Ø¶Ø§Ø¡ Ø¥Ù٠اÙÙÙÙ
Ø© 1' : 'ÙÙ
ÙØªÙ
تغÙÙØ± ÙÙÙ
Ø© ØÙ٠اÙÙØºØ© Ø§ÙØ¥ÙØªØ±Ø§Ø¶ÙØ© بجدÙÙ Ø§ÙØ£Ø¹Ø¶Ø§Ø¡ Ø¥Ù٠اÙÙÙÙ
Ø© 1';
$PowerBB->html->open_p();
foreach ($msgs as $msg)
{
$PowerBB->html->p_msg($msg);
}
$PowerBB->html->close_p();
$PowerBB->html->close_table();
$PowerBB->html->make_link('Ø§ÙØ®Ø·ÙÙ Ø§ÙØ«Ø§Ùثة -> Ø£Ø¯Ø®Ø§Ù Ø§ÙØ¥Ø³ØªØ¹ÙاÙ
ات','?step=3');
}
if ($PowerBB->_GET['step'] == 3)
{
$PowerBB->html->cells('عÙ
ÙÙØ§Øª Ø§ÙØ§Ø¶Ø§ÙÙ','main1');
$PowerBB->html->close_table();
$p[13] = $PowerBB->install->ChangeLangInfo();
$msgs[13] = ($p[13]) ? 'تÙ
تغÙÙØ± ÙÙÙ
Ø© ØÙ٠اÙÙØºØ© Ø§ÙØ¥ÙØªØ±Ø§Ø¶ÙØ© Ù
Ù Ø§ÙØ§Ø³Ù
Ø¥ÙÙ Ø§ÙØ±ÙÙ
' : 'ÙÙ
ÙØªÙ
ÙÙÙ
Ø© ØÙ٠اÙÙØºØ© Ø§ÙØ¥ÙØªØ±Ø§Ø¶ÙØ© Ù
Ù Ø§ÙØ§Ø³Ù
Ø¥ÙÙ Ø§ÙØ±ÙÙ
';
$p[14] = $PowerBB->install->AddPmWindow();
$msgs[14] = ($p[14]) ? 'تÙ
Ø§Ø¶Ø§ÙØ© ØÙÙ ØªÙØ¹ÙÙ Ø§Ø³ØªÙØ§Ù
اشعار Ø¨Ø±ÙØ¯Ù Ø¨ÙØ¬Ùد Ø±Ø³Ø§ÙØ© خاصة Ø¬Ø¯ÙØ¯Ø©' : 'ÙÙ
ÙØªÙ
Ø§Ø¶Ø§ÙØ© ØÙÙ ØªÙØ¹ÙÙ Ø§Ø³ØªÙØ§Ù
اشعار Ø¨Ø±ÙØ¯Ù Ø¨ÙØ¬Ùد Ø±Ø³Ø§ÙØ© خاصة Ø¬Ø¯ÙØ¯Ø©';
$PowerBB->html->open_p();
foreach ($msgs as $msg)
{
$PowerBB->html->p_msg($msg);
}
$PowerBB->html->close_p();
$PowerBB->html->close_table();
$PowerBB->html->make_link('Ø§ÙØ®Ø·ÙÙ Ø§ÙØ±Ø§Ø¨Ø¹Ø© ÙØ§ÙØ£Ø®ÙØ±Ø© -> اتÙ
اÙ
Ø§ÙØªØ±ÙÙØ©','?step=4');
}
elseif ($PowerBB->_GET['step'] == 4)
{
$PowerBB->html->cells('Ø§ÙØ®Ø·ÙØ© اÙÙÙØ§Ø¦ÙØ©','main1');
$PowerBB->html->close_table();
$PowerBB->install->CreateEmailed();
$PowerBB->install->CreateVisitor();
$PowerBB->install->CreateAward();
$PowerBB->install->CreateAdsense();
$PowerBB->install->CreateFriends();
$NewVersion = $PowerBB->install->UpdateVersion();
$PowerBB->html->open_p();
$PowerBB->html->p_msg('تÙ
Ø§ÙØªØ±ÙÙØ© Ø¥ÙÙ Ø§ÙØ£ØµØ¯Ø§Ø± 2.0.4 Ø¨ÙØ¬Ø§Ø');
$PowerBB->html->close_p();
$PowerBB->html->open_p();
$PowerBB->html->make_link('Ø§ÙØ¨Ø¯Ø£ Ø¨Ø§ÙØªØ±ÙÙØ© Ø¥ÙÙ Ø§ÙØ¥ØµØ¯Ø§Ø± 2.0.5','upg_205.php?step=1');
$PowerBB->html->close_p();
}
?>