Location: PHPKode > projects > WorkOrder TS > workorder-ts/setup_files/uninstall.php
<?PHP $inc_dir='../include/';require $inc_dir.'config-user.inc.php';require $inc_dir.'conn-string-user.inc.php';require $inc_dir.'workorder_function_general.inc.php';$CONF=_OFB10($inc_dir);$_jIOL6=$CONF['TablePrefix'];$sql="SHOW TABLES FROM $db_user LIKE '$_jIOL6%'";$_j6f0I=mysql_query($sql);if (!$_j6f0I) { echo "DB Error, could not list tables\n";echo 'MySQL Error: '.mysql_error();exit;} $_joi6O=NULL;for( $x=0;$row=mysql_fetch_row($_j6f0I);$x++) { $_joi6O.='<input name="DropTable'.$x.'" value="'.$row[0].'" type="checkbox">'.$row[0].'<br />';$_joLQJ=$x;} ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Uninstall</title> <link href="setup.css" rel="stylesheet" type="text/css" /> <script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script> <link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css"> <?PHP require_once 'javascript_error.inc.php';?> <script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script> <link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" /> </head> <body class="twoColElsLt"> <div id="container"> <div id="sidebar1"> <h3>Info Bar:</h3> <p>This side bar is here to provide you with additional setup information.</p> </div> <div id="mainContent"> <form enctype="multipart/form-data" action="uninstall_drop.php" method="POST"> <h2>WorkOrder TS Uninstall<br /> <br /> </h2> <span class="SmallTableText">Here you can uninstall the entire program or only delete individual tables.<br /> Some options require the root database account,all options require the username and password of an active WorkOrder TS system user.</span><br /> <table width="100%" border="1" cellspacing="0.5" cellpadding="0.5"> <tr> <td width="32%" class="SmallTableText">WorkOrder TS Admin Username:</td> <td width="68%"> <input name="txtAdminUser" type="text" id="txtAdminUser" value="admin" size="30" maxlength="30" /> </td> </tr> <tr> <td class="SmallTableText">WorkOrder TS Admin Password:</td> <td> <input name="txtAdminPassword" type="text" id="txtAdminPassword" size="30" /> </td> </tr> </table> <p> <input name="DropDatabaseAndAccounts" value="1" type="checkbox"> <span class="SmallTableText">Delete the entire database (<?PHP echo($db_user);?>) and all user accounts.Do not use this if you have other tables in this database! (requires root info).<br /> </span> <input name="DropTablesOnly" value="1" type="checkbox"> <span class="SmallTableText">Delete all tables created by WorkOrder TS.This will require the WorkOrder TS admin password.Use this on a webhosting account where a database user name and password is provided by the hosting company.</span><br /> <input name="DropDatabaseOnly" value="1" type="checkbox"> <span class="SmallTableText">Delete the entire database (<?PHP echo($db_user);?>) but keep all user accounts.Do not use this if you have other tables in this database! (requires root info-ADVANCED USERS).</span><br /> <input name="DropAccountsOnly" value="1" type="checkbox"> <span class="SmallTableText">Delete only the WorkOrder TS user accounts.(requires root info-ADVANCED USERS).</span></p> <table width="100%" border="1" cellpadding="0" cellspacing="0"> <tr> <td class="SmallTableText">Database User Name (root):</td> <td><input size="30" name="db_un_root" /></td> </tr> <tr> <td class="SmallTableText">Database User Password:</td> <td><input size="30" name="db_pw_root" /></td> </tr> </table><br /> <input type="hidden" name="DropThisDB" value="<?PHP echo($db_user); ?>" /> <input value="Uninstall Selected" type="submit"> <hr /> <p><span class="SmallTableText">Below you can delete individual tables from <?PHP echo($db_user);?> instead of wiping the entire database.Please select the tables to delete.</span><br /> <?PHP echo($_joi6O);?> <input type="hidden" name="TableCount" value="<?PHP echo($_joLQJ); ?>" /> </p> <input value="Uninstall Selected" type="submit"> </form><p>&nbsp;</p> </div> <div class="footer"> <div align="center" class="SmallTableText"><a href="../setup.php">Back To Main Page</a></div> </div><br class="clearfloat" /> </div> </body> </html>
Return current item: WorkOrder TS