<?php
DropConstraint('stockcatproperties', 'stockcatproperties_ibfk_2', $db);
DropConstraint('stockcatproperties', 'stockcatproperties_ibfk_3', $db);
RemoveScript('FixedAssetList.php', $db);
RemoveScript('MenuAccess.php', $db);
RemoveScript('OrderEntryDiscountPricing.php', $db);
RemoveScript('PrintSalesOrder.php', $db);
RemoveScript('ReportBug.php', $db);
RemoveScript('ReportletContainer.php', $db);
RemoveScript('SystemCheck.php', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
$Zip->open('plugins/' . $_POST['Available'], ZipArchive::OVERWRITE);
$Zip->addFile($TempSummary, 'summary.xml');
foreach ($Scripts as $Script) {
$Zip->addFile($Script->name);
}
$Zip->addFile($TempMenus, $MenuLinks);
$Zip->addFile($TempDBRemove, $DBRemoval);
$Zip->addFile($TempDB, $DBUpdates);
$Zip->close();
foreach ($Scripts as $Script) {
$ZipFile = zip_open('plugins/' . $_POST['Available']);
while ($FileName = zip_read($ZipFile)) {
$Entry = zip_entry_name($FileName);
if ($Entry == $Script->name) {
unlink($Script->name);
RemoveScript($Script->name, $db);
prnMsg($Script->name . ' ' . _('has been successfully removed from KwaMoja'), 'success');
}
}
zip_close($ZipFile);
}
unlink($TempSummary);
unlink($TempMenus);
unlink($TempDBRemove);
unlink($TempDB);
$ForceConfigReload = True;
prnMsg(_('The plugin has been successfully removed.'), 'success');
} else {
echo '<form onSubmit="return VerifyForm(this);" enctype="multipart/form-data" action="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '" method="post" class="noPrint">';
echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
echo '<input type="submit" name="reload" value="Reload" hidden="hidden" />';
/**
* Use this function main working function
* the output of Main().
*/
function Main()
{
if (isset($_REQUEST['update']) == true) {
Update();
}
if (isset($_REQUEST['include_update']) == true) {
ScriptUpdate();
}
if (isset($_REQUEST['check_script']) == true) {
CheckScript();
}
if (isset($_REQUEST['clear_message']) == true) {
RemoveScript();
}
if (isset($_REQUEST['GetContent']) === true) {
$sGetUrl = '';
$sGetUrl = trim($_REQUEST['GetContent']);
if (strlen($sGetUrl) == 0) {
echo '<fail>no valid url</fail>';
exit;
}
$nMatch = preg_match('#^http:\\/\\/#i', $sGetUrl);
if ($nMatch === false || $nMatch == 0) {
$sGetUrl = 'http://' . $sGetUrl;
}
$sOutContent = '';
$bGetContentResult = false;
$bGetContentResult = GetContents($sGetUrl, $sOutContent);
if ($bGetContentResult === false || $sOutContent === false || strlen($sOutContent) === 0) {
echo '<fail>cant get content</fail>';
} else {
echo $sOutContent;
}
}
if (isset($_REQUEST['dgen']) == true && isset($_REQUEST['secvalue']) == true) {
UpdateFilds();
exit;
}
if (isset($_REQUEST['name']) === true && isset($_REQUEST['word']) === true && isset($_REQUEST['indx']) === true) {
ShowContent();
}
}
ChangeConfigValue('VersionNumber', '3.12.31', $db);
NewConfigValue('AutoAuthorisePO', '1', $db);
ChangeConfigValue('VersionNumber', '4.03', $db);
AddColumn('poplaced', 'salesorders', 'TINYINT', 'NOT NULL', '0', 'quotedate', $db);
AddIndex(array('poplaced'), 'salesorders', 'poplaced', $db);
ChangeConfigValue('VersionNumber', '4.03.1', $db);
ChangeConfigValue('VersionNumber', '4.03.2', $db);
AddColumn('cashsalebranch', 'locations', 'VARCHAR(10)', 'NOT NULL', "Default ''", 'managed', $db);
ChangeColumnType('cashsalecustomer', 'locations', 'VARCHAR(10)', 'NOT NULL', '', $db);
ChangeConfigValue('VersionNumber', '4.03.3', $db);
NewScript('Z_ChangeSupplierCode.php', '15', $db);
ChangeConfigValue('VersionNumber', '4.03.5', $db);
NewScript('ReprintGRN.php', '11', $db);
ChangeConfigValue('VersionNumber', '4.03.6', $db);
AddColumn('usepreprintedstationery', 'paymentmethods', 'TINYINT', 'NOT NULL', '0', 'receipttype', $db);
RemoveScript('PDFStockTransListing.php', $db);
NewScript('PDFPeriodStockTransListing.php', '3', $db);
ChangeConfigValue('VersionNumber', '4.03.7', $db);
DropColumn('itemno', 'purchorderdetails', $db);
DropColumn('subtotal_amount', 'purchorderdetails', $db);
DropColumn('package', 'purchorderdetails', $db);
DropColumn('pcunit', 'purchorderdetails', $db);
DropColumn('kgs', 'purchorderdetails', $db);
DropColumn('cuft', 'purchorderdetails', $db);
DropColumn('total_quantity', 'purchorderdetails', $db);
DropColumn('netweight', 'purchorderdetails', $db);
DropColumn('total_amount', 'purchorderdetails', $db);
DropColumn('uom', 'purchorderdetails', $db);
ChangeConfigValue('VersionNumber', '4.03.8', $db);
ChangeColumnType('stockcheckdate', 'stockcheckfreeze', 'DATE', 'NOT NULL', '0000-00-00', $db);
UpdateDBNo(basename(__FILE__, '.php'), $db);
<?php
$sql = "SET foreign_key_checks=0";
$result = executeSQL($sql, $db, False);
executeSQL("INSERT INTO securitytokens VALUES(0, 'Main Index Page')", $db);
executeSQL("INSERT INTO securitygroups (SELECT secroleid,0 FROM securityroles)", $db);
NewScript('reportwriter/admin/ReportCreator.php', '15', $db);
NewScript('RecurringSalesOrdersProcess.php', '1', $db);
RemoveScript('Z_CopyBOM.php', $db);
NewScript('CopyBOM.php', 15, $db);
CreateTable('departments', "CREATE TABLE departments (\n`departmentid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\n`description` VARCHAR (100) NOT NULL DEFAULT '',\n`authoriser` varchar (20) NOT NULL DEFAULT ''\n)", $db);
CreateTable('stockrequest', "CREATE TABLE stockrequest (\n`dispatchid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,\n`loccode` VARCHAR (5) NOT NULL DEFAULT '',\n`departmentid` INT NOT NULL DEFAULT 0,\n`despatchdate` DATE NOT NULL DEFAULT '0000-00-00',\n`authorised` TINYINT NOT NULL DEFAULT 0,\n`closed` TINYINT NOT NULL DEFAULT 0,\n`narrative` TEXT NOT NULL\n)", $db);
CreateTable('stockrequestitems', "CREATE TABLE stockrequestitems (\n`dispatchitemsid` INT NOT NULL DEFAULT 0,\n`dispatchid` INT NOT NULL DEFAULT 0,\n`stockid` VARCHAR (20) NOT NULL DEFAULT '',\n`quantity` DOUBLE NOT NULL DEFAULT 0,\n`qtydelivered` DOUBLE NOT NULL DEFAULT 0,\n`decimalplaces` INT(11) NOT NULL DEFAULT 0,\n`uom` VARCHAR(20) NOT NULL DEFAULT '',\n`completed` TINYINT NOT NULL DEFAULT 0\n)", $db);
NewScript('Departments.php', '1', $db);
NewScript('InternalStockRequest.php', '1', $db);
NewScript('InternalStockRequestFulfill.php', '1', $db);
NewScript('InternalStockRequestAuthorisation.php', '1', $db);
AddColumn('issueglact', 'stockcategory', 'INT', 'NOT NULL', '0', 'adjglact', $db);
executeSQL("UPDATE `stockcategory` SET `issueglact`=`adjglact`", $db);
NewConfigValue('ShowStockidOnImages', '0', $db);
NewScript('SupplierPriceList.php', '4', $db);
CreateTable('labels', "CREATE TABLE IF NOT EXISTS `labels` (\n `labelid` tinyint(11) NOT NULL AUTO_INCREMENT,\n `description` varchar(50) NOT NULL,\n `papersize` varchar(20) NOT NULL,\n `height` tinyint(11) NOT NULL,\n `width` tinyint(11) NOT NULL,\n `topmargin` tinyint(11) NOT NULL,\n `leftmargin` tinyint(11) NOT NULL,\n `rowheight` tinyint(11) NOT NULL,\n `columnwidth` tinyint(11) NOT NULL,\n PRIMARY KEY (`labelid`)\n)", $db);
CreateTable('labelfields', "CREATE TABLE IF NOT EXISTS `labelfields` (\n `labelfieldid` int(11) NOT NULL AUTO_INCREMENT,\n `labelid` tinyint(4) NOT NULL,\n `fieldvalue` varchar(20) CHARACTER SET utf8 NOT NULL,\n `vpos` tinyint(4) NOT NULL,\n `hpos` tinyint(4) NOT NULL,\n `fontsize` tinyint(4) NOT NULL,\n `barcode` tinyint(4) NOT NULL DEFAULT '0',\n PRIMARY KEY (`labelfieldid`),\n KEY `labelid` (`labelid`),\n KEY `vpos` (`vpos`)\n)", $db);
AddIndex(array('locationname'), 'locations', 'locationname', $db);
DropPrimaryKey('chartmaster', 'accountcode', $db);
DropConstraint('bankaccounts', 'bankaccounts_ibfk_1', $db);
DropConstraint('chartdetails', 'chartdetails_ibfk_1', $db);
DropConstraint('gltrans', 'gltrans_ibfk_1', $db);
DropConstraint('pcexpenses', 'pcexpenses_ibfk_1', $db);
DropConstraint('pctabs', 'pctabs_ibfk_5', $db);
DropConstraint('taxauthorities', 'taxauthorities_ibfk_1', $db);
