home *** CD-ROM | disk | FTP | other *** search
/ PC World 2008 February (DVD) / PCWorld_2008-02_DVD.iso / v cisle / PHP / PHP.exe / EasyPHP-2.0b1-setup.exe / {app} / sqlitemanager / main.php < prev    next >
Encoding:
PHP Script  |  2006-04-18  |  7.0 KB  |  189 lines
  1. <?php
  2. /**
  3. * Web based SQLite management
  4. * @package SQLiteManager
  5. * @author FrΘdΘric HENNINOT
  6. * @version $Id: main.php,v 1.45 2006/04/14 20:18:23 freddy78 Exp $ $Revision: 1.45 $
  7. */
  8.  
  9. session_start();
  10. ob_start();
  11. include_once "include/defined.inc.php";
  12. include_once INCLUDE_LIB."config.inc.php";
  13.  
  14. if(ADVANCED_EDITOR && file_exists(SPAW_PATH."spaw_control.class.php") 
  15.     && isset($_COOKIE["SQLiteManager_HTMLon"]) && !$_COOKIE["SQLiteManager_HTMLon"]) {
  16.     $spaw_root = SPAW_PATH;
  17.     $spaw_dir = str_replace($_SERVER["DOCUMENT_ROOT"], "", $spaw_root);
  18.     $spaw_base_url = "http://".$_SERVER["HTTP_HOST"].$spaw_dir;
  19.     include_once SPAW_PATH."spaw_control.class.php";
  20. }
  21. if(JSCALENDAR_USE && file_exists(JSCALENDAR_PATH . 'calendar.php')) {
  22.         include_once JSCALENDAR_PATH . 'calendar.php';
  23.         $GlobalCalendar = new DHTML_Calendar(JSCALENDAR_PATH, $langSuffix, 'calendar-win2k-1', false);
  24. } 
  25. if(empty($dbsel) && ( !isset($GLOBALS["action"]) || ($GLOBALS["action"]!="auth") || (($GLOBALS["action"]=="auth") && !$SQLiteManagerAuth->isAdmin()) )){
  26. displayHeader("main");
  27. ?>
  28. <h2 class="sqlmVersion"><?php echo $traduct->get(2)." ".SQLiteManagerVersion ?></h2>
  29.     <h4 class="serverInfo"><?php echo $traduct->get(3)." ".$SQLiteVersion ?> / <?php echo $traduct->get(150)." ".phpversion() ?></h4>
  30.     <?php if(READ_ONLY) echo '<table width="80%" align="center"><tr><td style="font-size: 10px; border: 1px solid red; color: red; align: center">'.$traduct->get(154).'</td></tr></table>'; ?>
  31.  
  32.     <table align="center" cellspacing="0" cellpadding="0" class="home">
  33.         <tr>
  34.             <td class="boxtitle">SQLite
  35.             </td>
  36.             <td class="boxtitlespace"> 
  37.             </td>
  38.             <td class="boxtitle">SQLiteManager
  39.             </td>
  40.         </tr>
  41.         <tr>
  42.             <td style="white-space: nowrap"><?php include INCLUDE_LIB."add_database.php"; ?></td>
  43.             <td class="space"> </td>
  44.             <td align="left" style="white-space: nowrap"><form action="main.php" method="POST">
  45.                 <table align="center" cellspacing="10" cellpadding="0">
  46.                 <tr><td style="white-space: nowrap"><?php echo $traduct->get(141); ?> : </td>
  47.                 <td><select name="Langue" onChange="submit()"><?php echo getAvailableLanguage(); ?></select></td></tr>
  48.                 <tr><td style="white-space: nowrap"><?php echo $traduct->get(142); ?> : </td>
  49.                 <td><select name="Theme" onChange="submit()"><?php echo getAvailableTheme(); ?></select></td></tr>
  50.                 </table>
  51.         </form>
  52.                      » <a href="http://www.sqlite.org/" target="docs" class="Browse"><?php echo $traduct->get(4); ?></a>
  53.                 <br> » <a href="http://www.sqlite.org/lang.html" target="docs" class="Browse"><?php echo $traduct->get(5); ?></a>
  54.                 <br> » <a href="http://www.sqlitemanager.org" target="docs" class="Browse"><?php echo $traduct->get(231); ?></a>
  55.             </td>
  56.         </tr>
  57.         <tr>
  58.             <td> </td>
  59.             <td class="space"> </td>
  60.               <td>
  61.                 <?php if(WITH_AUTH){ ?> <hr style="border: 1px dashed blue"> <?php } ?>
  62.                 <div style="text-align:left; padding:5px;">
  63.                 <?php if(!READ_ONLY && WITH_AUTH && $SQLiteManagerAuth->isAdmin()) { ?>
  64.                 » <a href="?action=auth" class="Browse"><?php echo $traduct->get(156); ?></a>
  65.                 <?php } ?>
  66.                 <?php if(!READ_ONLY && WITH_AUTH && ALLOW_CHANGE_PASSWD) {
  67.                     if($GLOBALS["action"] != "passwd") { ?>
  68.                 <br>» <a href="main.php?action=passwd" class="Browse"><?php echo $traduct->get(157); ?></a><br><br>
  69.                     <?php } else {
  70.                     // manage passwd
  71.                     echo "<blockquote>";
  72.                     $SQLiteManagerAuth->changePasswd();
  73.                     echo "</blockquote>";
  74.                     } }
  75.                     if(WITH_AUTH){
  76.                     ?>
  77.                 » <a href="index.php?action=logout" target="_parent" class="Browse"><?php echo $traduct->get(158); ?></a>
  78.                     <?php } ?>
  79.                 </div>
  80.             </td>
  81.         </tr>
  82.     </table>
  83. <?php
  84. } elseif(!isset($GLOBALS["action"]) || ($GLOBALS["action"]!="auth")) {
  85.     // gestion de la base selectionnΘ
  86.     include_once INCLUDE_LIB."SQLiteDbConnect.class.php";
  87.     $tempDir = dirname($tabInfoDb['location']);
  88.     if($tempDir == '.') $baseLocation = DEFAULT_DB_PATH . $tabInfoDb['location'];
  89.     else $baseLocation = $tabInfoDb['location'];
  90.     $workDb = &new SQLiteDbConnect($baseLocation);
  91.     
  92.     displayHeader("main");
  93.  
  94.     displayMenuTitle();    
  95.  
  96.     $workDb->includeUDF();
  97.     if(ALLOW_FULLSEARCH){
  98.         include_once INCLUDE_LIB."sqlite_fulltextsearchex.class.php";
  99.         $sqlite_fts = new sqlite_fulltextsearchex ();
  100.         $sqlite_fts->register ($workDb->connId);
  101.         $sqlite_fts->use_against_cache = true; 
  102.     }
  103.     
  104.     switch($action){
  105.         case '':
  106.         case 'properties':
  107.         default:
  108.             if($workDb->isReadable()) {
  109.                 if($table || $TableName) $fileProp = 'tableproperties';
  110.                 elseif($view || $ViewName || isset($_POST['ViewName'])) $fileProp = 'viewproperties';
  111.                 elseif($trigger || $TriggerName) $fileProp = 'triggerproperties';
  112.                 elseif($function) $fileProp = 'functproperties';
  113.                 else $fileProp = 'dbproperties';
  114.                 if (isset($GLOBALS['plugin'])) {
  115.                     include_once 'plugins/'.$GLOBALS['plugin'].'/'.(isset($GLOBALS['file'])?$GLOBALS['file']:'plugin').'.php';
  116.                     if (isset($GLOBALS["action"]) && function_exists('plugin_'.$GLOBALS["action"])) {
  117.                     $function = 'plugin_'.$GLOBALS["action"];
  118.                     $function();
  119.                     break;
  120.                     }
  121.                 }
  122.                 include_once INCLUDE_LIB.$fileProp.'.php';
  123.             }
  124.             break;
  125.         case 'browseItem':
  126.             if($workDb->isReadable()) include INCLUDE_LIB.'browse.php';
  127.             break;
  128.         case 'sql':
  129.             if($workDb->isReadable()) {
  130.                 include INCLUDE_LIB.'sql.php';
  131.                 if ($_SERVER['REQUEST_METHOD'] == 'POST')
  132.                   echo "<script  type=\"text/javascript\">parent.left.location='left.php?dbsel=".$GLOBALS["dbsel"]."';</script>";
  133.             }
  134.             break;
  135.         case "export":
  136.             if($workDb->isReadable()) {
  137.                 include_once INCLUDE_LIB."SQLiteExport.class.php";
  138.                 $export =& new SQLiteExport($workDb);            
  139.             }
  140.             break;
  141.         case "del":
  142.             $query = "DELETE FROM database WHERE id=".$dbsel.";";
  143.             if($dbsel) {
  144.                 $db->query($query);
  145.                 // Remove attached databases
  146.                 $db->query("DELETE FROM attachment WHERE base_id=".$dbsel." OR attach_id=".$dbsel.";");                
  147.             }                
  148.             $redirect = "<script  type=\"text/javascript\">parent.location='index.php';</script>";
  149.             break;
  150.         case "add_view":
  151.             if($workDb->isReadable()) {
  152.                 $action = "add";
  153.                 include_once INCLUDE_LIB."viewproperties.php";
  154.             }                
  155.             break;
  156.         case "add_trigger":
  157.             if($workDb->isReadable()) {
  158.                 $action = "add";
  159.                 include_once INCLUDE_LIB."triggerproperties.php";
  160.             }
  161.             break;
  162.         case "add_function":
  163.             if($workDb->isReadable()) {
  164.                 $action = "add";
  165.                 include_once INCLUDE_LIB."functproperties.php";
  166.             }
  167.             break;
  168.         case "options":
  169.             if($workDb->isReadable()) {
  170.                 include_once INCLUDE_LIB."SQLiteDbOption.class.php";
  171.                 $Option =& new SQLiteDbOption($workDb);
  172.                 if ($_SERVER['REQUEST_METHOD'] == 'POST' || (isset($_REQUEST['attach_action']) && $_REQUEST['attach_action']=='del'))
  173.                   echo "<script  type=\"text/javascript\">parent.left.location='left.php?dbsel=".$GLOBALS["dbsel"]."';</script>";            
  174.             }
  175.             break;
  176.     }
  177.     
  178. } elseif(isset($GLOBALS["action"]) && ($GLOBALS["action"]=="auth")){
  179.     displayHeader("main");
  180.     $SQLiteManagerAuth->manageAuth();
  181. }
  182.  
  183. if(isset($redirect) && !empty($redirect)){
  184.         ob_end_clean();
  185.         echo $redirect;
  186. }
  187. @ob_end_flush();
  188. ?>
  189.