Code cleanup post R_0
diff --git a/aptana_global/.cvsignore b/aptana_global/.cvsignore
deleted file mode 100644
index a8dbdb8..0000000
--- a/aptana_global/.cvsignore
+++ /dev/null
@@ -1 +0,0 @@
-eclipse.org-common
diff --git a/aptana_global/aptana.inc.php b/aptana_global/aptana.inc.php
deleted file mode 100755
index 275db58..0000000
--- a/aptana_global/aptana.inc.php
+++ /dev/null
@@ -1,114 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
- *    Eclipse Foundation
-*******************************************************************************/
-define('BABEL_BASE_DIR', "../");
-define('USE_PHOENIX', true);
-

-
-# Load up Phoenix classes
-$App;
-if(USE_PHOENIX) {
-	require_once(BABEL_BASE_DIR . '/eclipse.org-common/system/app.class.php');
-	require_once(BABEL_BASE_DIR . "/eclipse.org-common/system/nav.class.php");
-	require_once(BABEL_BASE_DIR . "/eclipse.org-common/system/menu.class.php");
-	$App = new App(); 	
-	$Nav	= new Nav();	
-	$Menu 	= new Menu();
-}

-$GLOBALS['g_LOADTIME'] = microtime();

-require("utils.inc.php");

-session_name(COOKIE_SESSION);

-session_start();

-extract($_SESSION);

-

-

-function InitPage($page) {

-  $lastPage = GetSessionVar('s_pageName');

-  $userName = GetSessionVar('s_userName');

-  

-  if (empty($GLOBALS['page']))

-	  $GLOBALS['page'] = '';

-		

-  if (($lastPage != $_SERVER['PHP_SELF']) AND ($lastPage != "login"))

-    SetSessionVar('s_pageLast',$lastPage);

-  SetSessionVar('s_pageName',$GLOBALS['page']);
-  
-  sqlOpen(NULL);

-  if (!$userName && isset($_COOKIE[COOKIE_REMEMBER])) {
-  	# Try to fetch username from session
-  	$session = new sessions_iu(0);
-
-  	if(!$session->validate()) {

-    	SetSessionVar('s_pageLast',$GLOBALS['page']);

-    	exitTo("login.php");
-  	}
-  	else {
-  		$user = new users_iu(0);
-  		$user->sqlLoad($session->_userid);
-  		# hack! Not every one has a username
-  		SetSessionVar("s_userName",  str_replace("@", ".", $user->_email));
-  	}

-  }

-  

-  $GLOBALS['g_PHPSELF']  = $GLOBALS['page'];

-  $GLOBALS['g_PAGE']     = $page;

-  $GLOBALS['g_SITEURL']  = $_SERVER['HTTP_HOST'];

-  $GLOBALS['g_SITENAME'] = substr($GLOBALS['g_SITEURL'],0,strlen($GLOBALS['g_SITEURL'])-4);

-  $GLOBALS['g_TITLE']    = $GLOBALS['g_SITENAME'];

-  $GLOBALS['g_ERRSTRS']  = array("","","","","","","","","","","",);

-  // $GLOBALS['g_MAINMENU'] = buildMainMenu($page,$userName);

-  $GLOBALS['DEBUG']      = "";

- 

-  // Build left nav

-  // $GLOBALS['g_LEFTNAV'] = "&nbsp;";

-

-  // Build rite nav/ad

-  // $GLOBALS['g_RITENAV'] = "&nbsp;";

-

-}

-

-

-function buildMainMenu($page,$username) {

-  $menu  = "";

-  $mLeft = array("news"      => "news",

-                 "airports"  => "airports",

-                 "directory" => "directory",

-                 "databases" => "databases",

-                 "forsale"   => "for sale",

-                 "forums"    => "forums",

-                 "aboutus"   => "about us");

-                 

-  if (empty($username))

-    $mRite = array("register" => "register","login" => "login");

-  else

-    $mRite = array("profile" => "$username profile","logout" => "logout");

-

-

-  foreach ($mLeft as $link => $name) {

-    $menu .= "<td class='menu mro" . (($page==$link)?"s":"") . "'" .

-             " onmouseover='mr(this);' " . 

-             " onmouseout='mr(this);' " .

-             " onclick=url('/$link')>$name</td>\n";             

-  }

-  $menu .= "<td class='wfull'></td>\n";

-  foreach ($mRite as $link => $name) {

-    $menu .= "<td class='menu mro" . (($page==$link)?"s":"") . "'" .

-             " onmouseover='mr(this);' " . 

-             " onmouseout='mr(this);' " .

-             " onclick=url('/$link')>$name</td>\n";             

-  }

-  

-  

-  return $menu;

-}

-

-?>
\ No newline at end of file
diff --git a/aptana_global/base.conf b/aptana_global/base.conf
deleted file mode 100755
index f9dff19..0000000
--- a/aptana_global/base.conf
+++ /dev/null
@@ -1,6 +0,0 @@
-; Turboflix db config file

-

-db_read_host=localhost

-db_read_user=go

-db_read_pass=123Babe1

-db_read_name=babel
\ No newline at end of file
diff --git a/aptana_global/code/confirm.code.php b/aptana_global/code/confirm.code.php
deleted file mode 100755
index c6f96c3..0000000
--- a/aptana_global/code/confirm.code.php
+++ /dev/null
@@ -1,63 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-
-
-// ------...------...------...------...------...------...------...------...------...------...------
-require_once(BABEL_BASE_DIR."aptana.inc.php");
-// ------...------...------...------...------...------...------...------...------...------...------
-
-extract(LoadVars());
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function LoadVars() {
-  InitPage("confirm");
-  $errStrs = $GLOBALS['g_ERRSTRS'];
-  
-  $dat = array();
-  $dat['key']     = (isset($_POST['key'])?$_POST['key']:(isset($_GET['key'])?$_GET['key']:""));

-  $dat['codeStr'] = (isset($_POST['code'])?$_POST['code']:"");

-
-  if (!empty($dat['key'])) { //}isset($_POST['postIT'])) {
-    //if (!strlen($dat['codeStr']))

-    //  $errStrs[1] .= "&nbsp;required";

-    //else if (!validateCode(GetSessionVar('s_code'),$dat['codeStr'])) {

-    //  $errStrs[1]    .= "please enter in the string below";

-    //  $dat['codeStr'] = ClearSessionVar('s_code');

-    //}

-    
-    if (!strlen($dat['key']))
-      $errStrs[0] .= "&nbsp;required";
-    else {
-      $user = new users_iu(0);
-			$rec = $user->sqlRec("SELECT * FROM {SELF} WHERE code='{$dat['key']}'");
-      if (empty($rec)) 
-        $errStrs[0] .= "&nbsp;invalid code";
-      else if (strlen(!$errStrs[1])) {
-        if (!$user->sqlLoad($rec->id))
-          exitTo("error.pp","e_code","1012");
-        $user->_type   = 1;
-        $user->_status = 1;
-				$user->_code   = '';
-        $user->selfPost();
-        exitTo("registration_done.php");
-      }
-    }
-  }
-  $GLOBALS['g_ERRSTRS'] = $errStrs;
-  $dat['codePng'] = '';//getRegCodePict();

-  return $dat;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/code/login.code.php b/aptana_global/code/login.code.php
deleted file mode 100755
index 9137bab..0000000
--- a/aptana_global/code/login.code.php
+++ /dev/null
@@ -1,84 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
- * 	  Eclipse Foundation
-*******************************************************************************/
-error_reporting(E_ALL);
-require_once(BABEL_BASE_DIR."aptana.inc.php");
-
-
-extract(LoadVars());
-
-function LoadVars() {
-
-  InitPage("login");
-  $dat = array();
-
-  $post_username = (isset($_POST['username'])?$_POST['username']:"");
-  $post_password = (isset($_POST['password'])?$_POST['password']:"");
-  $post_remember = (isset($_POST['remember'])?$_POST['remember']:"");
-  
-  if (!empty($_POST['postIT'])) {
-    loginUser($post_username,$post_password,$post_remember);
-  }
-
-  $dat['post_username'] = $post_username;
-  $dat['post_password'] = $post_password;
-  $dat['post_remember'] = ($post_remember?"checked":"");
-  return $dat;
-}
-
-function loginUser($username,$password,$remember) {
-  unset($_SESSION['s_userAcct']);
-  unset($_SESSION['s_userName']);
-  unset($_SESSION['s_userType']);
-
-  $errStrs = $GLOBALS['g_ERRSTRS'];
-  if (empty($username))
-    $errStrs[1] = "&nbsp;required";
-  if (empty($password))
-    $errStrs[2] = "&nbsp;required";
-
-  if (!$errStrs[1] && !$errStrs[2]) {
-    $errStrs[0] = "Invalid username/password";
-    $user = new users_iu(0);
-    if ($user->findUser($username,$password)) {
-    
-      //switch ($user->_status) {
-      //  case 0: // not yet confirmed
-      //    $errStrs[0] = "your account has not yet been confirmed";
-      //    break;
-      //  case 1:
-          if ($remember) {
-          	$session = new sessions_iu(0);
-          	$session->create($user->_id);
-
-            $cookieName  = COOKIE_REMEMBER;
-            $cookieValue = $session->encode_remember();
-            setcookie($cookieName,$cookieValue,time()+3600*24*365,"/");
-          }
-          SetSessionVar("s_userAcct" ,"$user->_id");
-          SetSessionVar("s_userName","$user->_username");
-          //SetSessionVar("s_userType","$user->_type");
-          $errStrs[0] = "";
-          $lastURL    = GetSessionVar('s_pageLast');
-          exitTo("intro.php");
-      //    break;
-      //  default:
-      //    $errStrs[0] = "unknown status";
-      //}
-    }		
-  }
-  $GLOBALS['g_ERRSTRS'] = $errStrs;
-}
-
-
-
-?>
diff --git a/aptana_global/code/logout.code.php b/aptana_global/code/logout.code.php
deleted file mode 100755
index 1e0fdca..0000000
--- a/aptana_global/code/logout.code.php
+++ /dev/null
@@ -1,30 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- * 	  Eclipse Foundation - Initial API and implementation
-*******************************************************************************/
-require_once(BABEL_BASE_DIR."aptana.inc.php");
-
-extract(LoadVars());
-
-function LoadVars() {
-  
-  InitPage("login");
-  logoutUser();
-}
-
-function logoutUser() {
-  $session = new sessions_iu(0);
-  $session->destroy();
-  setcookie(COOKIE_REMEMBER, "", -36000, "/");
-}
-
-
-
-?>
diff --git a/aptana_global/code/register.code.php b/aptana_global/code/register.code.php
deleted file mode 100755
index 25c8a65..0000000
--- a/aptana_global/code/register.code.php
+++ /dev/null
@@ -1,85 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-
-/**
- * @deprecated
- */
-exit;
-
-// ------...------...------...------...------...------...------...------...------...------...------
-require_once(BABEL_BASE_DIR."aptana.inc.php");
-// ------...------...------...------...------...------...------...------...------...------...------
-
-extract(LoadVars());
-
-
-$hoursCombo = "";
-for ($x=1;$x<=40;$x++) {
-  $selected    = (($users_hours_per_week==$x)?"Selected":"");
-  $hoursCombo .= "<option value='$x' $selected>$x</option>\n";
-}
-
-
-$langs = new languages_iu(0);
-$langs->sqlList("SELECT * FROM {SELF} ORDER BY name");
-$langCombo = "<option value='0'>Select Language</option>\n";
-while ($langs->sqlNext())
-  if ($langs->_id > 1) {
-    $selected   = (($users_primary_language_id==$langs->_id)?"Selected":"");
-    $langCombo .= "<option value='$langs->_id' $selected>$langs->_name</option>\n";
-  }
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function LoadVars() {
-  InitPage("register");
-  $user = new users_iu(0);
-  $pass1  = (isset($_POST['password_plain'])?$_POST['password_plain']:"");
-  $pass2 = (isset($_POST['password_confirm'])?$_POST['password_confirm']:"");
-
-  if (isset($_POST['postIT'])) {
-    if ($user->formRegValidate($_POST,$pass1,$pass2)) {
-      addUser($user,$pass1);
-      exitTo("registration_done.php?code=1");
-    }
-  }
-  $dat = $user->PostDATA();
-  $dat['password_plain']   = $pass1;
-  $dat['password_confirm'] = $pass2;
-
-  return $dat;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function addUser($user,$pass) {
-  //require_once("aptana/email.inc.php");
-  //$user->_type     = 0;
-  //$user->_status   = 0;
-  //$user->_code     = guidNbr();
-  //$user->_password = $user->sqlGetPassword($user->_password);
-  # $user->_password_salt = hash("crc32", $pass);
-  $user->_password_salt = crc32($pass);
-  # $user->_password_hash = hash("sha256", $pass . $user->_password_salt);
-  $user->_password_hash = sha1($pass . $user->_password_salt);
-  $user->_updated_on    = "NOW()";
-  $user->_created_on    = "NOW()";
-  if (!$user->selfPost())
-      exitTo("registration_done.php?code=2");
-  //  emailUser($user->_email,"reg_confirm",array("code" => $user->_code,"email" => $user->_email));
-  //else 
-//    exitTo("/error","e_code","1011");
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/consts.inc.php b/aptana_global/consts.inc.php
deleted file mode 100755
index 53d1752..0000000
--- a/aptana_global/consts.inc.php
+++ /dev/null
@@ -1,21 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/

-// ------...------...------...------...------...------...------...------...------...------...------

-// Log files

-define("LOG2USER"  ,1);

-define("LOG2ERROR" ,2);

-define("LOG2DEBUG" ,3);

-define("TRACELVL"  ,3);

-// ------...------...------...------...------...------...------...------...------...------...------

-

-?>
\ No newline at end of file
diff --git a/aptana_global/email.inc.php b/aptana_global/email.inc.php
deleted file mode 100755
index b38b77e..0000000
--- a/aptana_global/email.inc.php
+++ /dev/null
@@ -1,81 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function emailUser($userEmail,$template,$extra=NULL) {
-  $siteName = (empty($GLOBALS['g_SITENAME'])?"Aptana"    :$GLOBALS['g_SITENAME']);
-  $siteURL  = (empty($GLOBALS['g_SITEURL']) ?"aptana.com":$GLOBALS['g_SITEURL']);
-  // Get the all the templates
-  //   email.body is the email header + MIME template
-  //   where the HTM and TEXT version is inserted
-  $body = file_get_contents(BABEL_BASE_DIR."emails/email.body",true);
-  $html = file_get_contents("aptana_global/emails/$template.html",true);
-  $html = str_replace("\${g_SITENAME}",$siteName,$html);
-  $html = str_replace("\${g_SITEURL}" ,$siteURL,$html);
-  $text = file_get_contents("aptana_global/emails/$template.text",true);
-  $text = str_replace("\${g_SITENAME}",$siteName,$text);
-  $text = str_replace("\${g_SITEURL}" ,$siteURL,$text);
-
-  // build the reply-to field - use full name where possible
-  $replyTo = "";
-  if (eregi("<reply_to>.*</reply_to>",$html,$reg))
-    $replyTo = substr($reg[0],10,strlen($reg[0])-21);
-
-  // pull the subject/from name/address from the html template
-  $subject = "<subject>";
-  if (eregi("<subject>.*</subject>",$html,$reg))
-    $subject = substr($reg[0],9,strlen($reg[0])-19);
-
-  $fromName = $siteName;
-  if (eregi("<from_name>.*</from_name>",$html,$reg))
-    $fromName = substr($reg[0],11,strlen($reg[0])-23);
-
-  $fromAddr = "dontreply@" . $siteURL;
-  if (eregi("<from_address>.*</from_address>",$html,$reg))
-    $fromAddr = substr($reg[0],14,strlen($reg[0])-29);
-
-  // skip the header vars.
-  if (eregi("<html>.*",$html,$reg))
-    $html = $reg[0];
-  $html = str_replace("=","=3D",$html);
-
-  // Do the header/MIME replacements
-  $msg = str_replace("\${FROM_NAME}",$fromName,$body);
-  $msg = str_replace("\${FROM_ADDRESS}",$fromAddr,$msg);
-  $msg = str_replace("\${SUBJECT}",$subject,$msg);
-  $msg = str_replace("\${REPLY_TO}",$replyTo,$msg);
-
-  $msg = str_replace("\${EMAIL_TEXT}",$text,$msg);
-  $msg = str_replace("\${EMAIL_HTML}",$html,$msg);
-
-  // Replace content editors vars
-  $msg = str_replace("\${email}",$userEmail,$msg);
-
-  // Replace passed in dev vars
-  if (isset($extra)) {
-    foreach ($extra as $key => $val)
-      $msg = str_replace("\${{$key}}",$val,$msg);
-  }
-
-  $pos = strpos($msg,"\n\n")+2;
-  $hdr = substr($msg,0,$pos);
-  $msg = substr($msg,$pos);
-
-  mail($userEmail,$subject,$msg,$hdr);
-  debugLog("emailed: $userEmail [$template]");
-
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-?>
\ No newline at end of file
diff --git a/aptana_global/emails/email.body b/aptana_global/emails/email.body
deleted file mode 100644
index c64cb1a..0000000
--- a/aptana_global/emails/email.body
+++ /dev/null
@@ -1,24 +0,0 @@
-From: "${FROM_NAME}" <${FROM_ADDRESS}>
-Reply-To: ${REPLY_TO}
-MIME-Version: 1.0
-Content-Type: multipart/alternative;
-        boundary="----=_NextPart_000_001B_01C44228.573124A0"
-X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
-
-This is a multi-part message in MIME format.
-
-------=_NextPart_000_001B_01C44228.573124A0
-Content-Type: text/plain;
-        charset="iso-8859-1"
-Content-Transfer-Encoding: quoted-printable
-
-${EMAIL_TEXT}
-
-------=_NextPart_000_001B_01C44228.573124A0
-Content-Type: text/html;
-        charset="iso-8859-1"
-Content-Transfer-Encoding: quoted-printable
-
-${EMAIL_HTML}
-
-------=_NextPart_000_001B_01C44228.573124A0--
diff --git a/aptana_global/foot.php b/aptana_global/foot.php
deleted file mode 100755
index 8b9aaf0..0000000
--- a/aptana_global/foot.php
+++ /dev/null
@@ -1,17 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-

-include(BABEL_BASE_DIR . '/eclipse.org-common/themes/Phoenix/footer.php');
-$App = new App();

-

-?>
\ No newline at end of file
diff --git a/aptana_global/head.php b/aptana_global/head.php
deleted file mode 100755
index 9c23c39..0000000
--- a/aptana_global/head.php
+++ /dev/null
@@ -1,27 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-if(USE_PHOENIX) {
-	include(BABEL_BASE_DIR . '/eclipse.org-common/themes/Phoenix/header.php');
-	include(BABEL_BASE_DIR . '/eclipse.org-common/themes/Phoenix/menu.php');
-	include(BABEL_BASE_DIR . '/eclipse.org-common/themes/Phoenix/nav.php');
-}
-?>
-
-<link href='aptana.css' rel="stylesheet">
-
-<script src='js/yui2.3.1/yahoo/yahoo.js' type='text/javascript'></script>
-<script src='js/yui2.3.1/dom/dom/js' type='text/javascript'></script>
-<script src='js/yui2.3.1/event/event.js' type='text/javascript'></script>
-<script src='js/yui2.3.1/connection/connectons.js' type='text/javascript'></script>
-<script src='js/yui2.3.1/logger/logger.js' type='text/javascript'></script>
-
diff --git a/aptana_global/htaccess b/aptana_global/htaccess
deleted file mode 100644
index 2882645..0000000
--- a/aptana_global/htaccess
+++ /dev/null
@@ -1,12 +0,0 @@
-RewriteEngine On
-RewriteBase /
-
-#Rewrite www.domain.com to domain.com
-#RewriteCond %{HTTP_http://squawking1200.com} ^www\.(.*)
-#RewriteRule ^(.*)       http://%1/$1 [R,L]
-
-# if file exists, do NOT redirect
-RewriteCond %{REQUEST_FILENAME} -f
-RewriteRule ^.*$ - [L]
-# else redirect everything to squawk.php
-RewriteRule (.*)    rewriter.php
diff --git a/aptana_global/public/.cvsignore b/aptana_global/public/.cvsignore
deleted file mode 100644
index a8dbdb8..0000000
--- a/aptana_global/public/.cvsignore
+++ /dev/null
@@ -1 +0,0 @@
-eclipse.org-common
diff --git a/aptana_global/public/.htaccess b/aptana_global/public/.htaccess
deleted file mode 100644
index 03cc8bb..0000000
--- a/aptana_global/public/.htaccess
+++ /dev/null
@@ -1,12 +0,0 @@
-RewriteEngine On
-RewriteBase /
-
-# Rewrite www.domain.com to domain.com
-#RewriteCond %{HTTP_http://squawking1200.com} ^www\.(.*)
-#RewriteRule ^(.*)       http://%1/$1 [R,L]
-
-# if file exists, do NOT redirect
-RewriteCond %{REQUEST_FILENAME} -f
-RewriteRule ^.*$ - [L]
-# else redirect everything to squawk.php
-RewriteRule (.*)    rewriter.php
diff --git a/aptana_global/public/aptana.css b/aptana_global/public/aptana.css
deleted file mode 100755
index fd78497..0000000
--- a/aptana_global/public/aptana.css
+++ /dev/null
@@ -1,269 +0,0 @@
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-body {
-  min-width: 640px;
-  font-family: verdana,arial;
-  margin: 0;
-  padding: 0;
-  background: #FFFFFF;
-  font-size:12px;
-}

-
-.babel-container{
-	margin-right: 20px;
-  	background-color: #dddddd;
-}
-
-.logout{
-	float: right;
-	}
-
-input {
-	font-family: verdana,arial;
-	font-size:11px;
-	margin: 2px 2px 2px 2px;
-}
-
-
-a {
-  text-decoration: none;
-	color: #3E71FA;

-	font-weight: bold;

-	font-size: 14;

-}
-
-
-
-tr { vertical-align:top; }
-
-#title {
-  color:#405066;
-  font-size:16pt;
-  border-bottom:solid 1px #800000;
-  margin: 20px 0px 20px 0px;
-}
-
-
-#formLbl {
-  text-align:right;
-  color:#555599;
-  vertical-align:top;
-}
-
-#formLblSmall {
-  text-align:right;
-  color:#555599;
-  vertical-align:top;
-  font-size:7pt;
-}
-
-#formEdt {
-  width:100px;
-  vertical-align:top;
-}
-
-#formNote {
-  font-size:8pt;
-  color:#888888;
-  padding-bottom: 8px;
-  font-family: arial;
-}
-
-#formErr {
-  font-size:8pt;
-  font-weight:bold;
-  color:#882222;
-  width:90%;
-}
-
-
-
-
-
-#newshead {
-  font-family:Verdana;
-  font-size:14px;
-}
-
-#newsuser {
-  padding:0px 10px 1px 10px;
-  font-family:tahoma,arial; 
-  color:#666688;
-  font-size:11px;
-  vertical-align:top;
-}
-#newsuserTxt {
-  display:inline;
-  vertical-align:top;
-}
-#newsuserImg {
-  border:solid 1px #ccccdd;
-}
-
-
-#newspost {
-  padding:0px 10px 0px 10px;
-  color:#333333;
-  font-family:tahoma,tahoma,arial;
-  font-size:13px;
-  text-align:justify;
-}
-
-#newslink {
-  padding:6px 10px 0px 10px;
-  color:#777777;
-  font-family:tahoma,arial;
-  font-size:11px;
-}
-
-#newsrow1 {
-  background-color:#f8f8f8;
-  border-bottom:solid 1px #eeeeee;
-  padding:4px;
-}
-
-#newsrow2 {
-  background-color:#f8f8f8;
-  border-bottom:solid 1px #eeeeee;
-  padding:4px;
-}
-
-.graph {
- position:relative;
- top:0px;
- left:0px;
- background-color:#aaccaa;
- height:14px;
- width:0px;
- padding:0px;
- }
-
-
-.graphOut {
- position:relative;
- top:0px;
- left:0px;
- height:14px;
- width:0px;
- padding:0px;
- }
- 
- 
-.projSel {
- position:relative;
- top:0px;
- left:0px;
- height:14px;
- width:220px;
- padding:0px;
- color:#fffc0d;
- background-image: url(imgs/selected.gif);
- }
- 
- .entryDone {
- top:0px;
- left:0px;
- background-color:#aaccaa;
- height:14px;
- padding:0px;
- padding-left:4px;
- width:100%;
- overflow:hidden
- }
- .entryUnDone {
- top:0px;
- left:0px;
- background-color:#ffffff;
- height:14px;
- padding:0px;
- padding-left:4px;
- width:100%;
- overflow:hidden
- }
- 
- 
- .entryHi1 {
-  left:0px;
-  height:14px;
-  padding-left:4px;
-  overflow:hidden;
- }
- 
- .entryHi2 {
-  left:0px;
-  height:14px;
-  padding-left:4px;
-  overflow:hidden;
- }
- 
- .entrySel1 {
- position:relative;
- top:0px;
- left:0px;
- height:14px;
- width:100%;
- padding:0px;
- padding-left:4px;
- color:#fffc0d;
- background-image: url(imgs/selected.gif);
- overflow:hidden;
- }
- 
- .entrySel2 {
- position:relative;
- top:0px;
- left:0px;
- height:14px;
- width:100%x;
- padding:0px;
- color:#fffc0d;
- background-image: url(imgs/selected.gif);
- overflow:hidden;
- }
- 
- .ss {
-	color:#333333;
-  text-decoration: none;
-  display:block;
-  width:100%;
-  height:100%;
-	padding: 2 0 0 0;
-	border-right: solid 1px #f0f0f0;
-	border-bottom: solid 1px #f0f0f0;
-	font-weight:normal;
-}
-:hover.ss {
-  background-image: url(imgs/rollover.gif);
-	color:#444444;
-	border-right: solid 1px #cccccc;
-	border-bottom: solid 1px #cccccc;
-}
-:visited.ss {
-	color:#333333;
-}
-
-
-
-.userPanel {

-text-align: right;
-padding-top:14px;

-width: 100%;

-height: 49px;

-font-size: 14px;

-color: #ffffff;

-background-image: url(imgs/background-header-tile.gif);

-background-repeat: repeat-x;

-background-attachment: scroll;

-background-x-position: 0%;

-background-y-position: 0%;

-}
-
diff --git a/aptana_global/public/confirm.php b/aptana_global/public/confirm.php
deleted file mode 100755
index 7e010be..0000000
--- a/aptana_global/public/confirm.php
+++ /dev/null
@@ -1,45 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/

-require_once("aptana_global/code/confirm.code.php");

-

-// ------...------...------...------...------...------...------...------...------...------...------
-include("aptana_global/head.php");
-echo <<< toTheEnd

-<form method="post">
-<div id="title">Email Confirmation</div>
-
-
-<table cellspacing=4 cellpadding=0 >
-<tr>

-  <td id="formLbl">          key:</td>

-  <td><input type="text" style="width:215px;" name="key"  value="$key"     /><p /></td>

-  <td id="formErr">{$g_ERRSTRS[0]}&nbsp;</td>
-</tr>

-<!--
-<tr>

-  <td id="formLbl">are&nbsp;you&nbsp;human:</td>

-  <td><input type="text" style="width:215px;" name="code" value="$codeStr" />     </td>

-  <td id="formErr">{$g_ERRSTRS[1]}&nbsp;</td>
-</tr>

--->
-<tr><td id="formLbl"></td><td><img src="/img/$codePng"><p /></td></tr>

-
-<tr><td></td><td><input type="submit" name="postIT" value="confirm" style="font-size:14px;"/><br /><br /></td></tr>
-</table>
-</form>
-
-toTheEnd;
-include("aptana_global/foot.php");
-
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/public/confirmation_sent.php b/aptana_global/public/confirmation_sent.php
deleted file mode 100755
index 4989efe..0000000
--- a/aptana_global/public/confirmation_sent.php
+++ /dev/null
@@ -1,36 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-require_once("aptana_global/aptana.inc.php");
-InitPage('confirmation_sent');
-$email = GrabSessionVar('s_code');
-// ------...------...------...------...------...------...------...------...------...------...------
-
-include("aptana_global/head.php");
-echo <<< toTheEnd
-
-<div style="height:74px;"></div>
-
-A confirmation email has been send to <span style="color:#222288;">$email</span> Please 
-follow the enclosed instructions to complete your account registration.<p /><br /><br />
-<a href='/index.php'>return to home page</a>
-<p /><br /><br />
-Thank you for using $g_SITENAME.<br />
-&nbsp;&nbsp;&nbsp;&nbsp;- The Crew
-
-toTheEnd;
-include("aptana_global/foot.php");
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-?>
\ No newline at end of file
diff --git a/aptana_global/public/edit.php b/aptana_global/public/edit.php
deleted file mode 100755
index e5ab95d..0000000
--- a/aptana_global/public/edit.php
+++ /dev/null
@@ -1,120 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/

-// if not logged in redirect to login page

-// otherwise show choices

-require_once("aptana_global/aptana.inc.php");

-require_once("aptana_global/agent.inc.php");

-// ------...------...------...------...------...------...------...------...------...------...------

-// should move this out of here

-InitPage("export");

-

-$project_name = (isset($_POST['project_name'])?$_GET['project_name']:'');

-//$package_name = (isset($_POST['package_name'])?$_GET['package_name']:'');

-$entry_name   = (isset($_POST['entry_name'])?$_GET['entry_name']:'');

-$entry_value  = (isset($_POST['entry_value'])?$_GET['entry_value']:'');

-//$repo_path    = (isset($_POST['repo_path'])?$_GET['repo_path']:'');

-$lang_code    = (isset($_POST['lang_code'])?$_GET['lang_code']:'en');

-$lang_id      = 0;

-

-

-/*

-$lang_code  = "pt";

-$project_name = "Aptana Unified Editor";

-$entry_name = "FileContextManager_RemovingFileContext";

-$entry_value = "Removendo o caminho: {0}";

-*/

-

-$cmd = "SELECT * FROM languages WHERE iso_code='$lang_code'";

-if ($qry = mysql_query($cmd)) {

-  if ($rec = mysql_fetch_object($qry)) {

-    $lang_id = $rec->id;

-  }

-}

-

-

-if (strlen($lang_code)<1 || $lang_id <= 1) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>invalid language code</error>\n";

-  exit;

-}

-

-if (empty($project_name)) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>no project_name</error>\n";

-  exit;

-}

-

-

-if (empty($entry_name)) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>no entry_name</error>\n";

-  exit;

-}

-

-

-if (empty($entry_value)) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>no entry_value</error>\n";

-  exit;

-}

-

-

-$cmd = "SELECT * FROM projects WHERE name='$project_name'";

-if ($qry = mysql_query($cmd)) {

-  $rec = mysql_fetch_object($qry);

-}

-

-if (empty($rec)) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>unknown project</error>\n";

-  exit;

-}

-

-

-$project_id = $rec->id;

-unset($rec);

-

-$cmd = "SELECT * FROM entries WHERE language_id=1 AND name='$entry_name'";

-if ($qry = mysql_query($cmd)) {

-  $rec = mysql_fetch_object($qry);

-}

-

-if (empty($rec)) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>unknown entry</error>\n";

-  exit;

-}

-

-

-$entry = new entries_iu(0);

-$entry->sqlLoad("language_id=$lang_id AND project_id=$project_id AND name='$entry_name'");

-

-$entry->_name        = $entry_name;

-$entry->_value       = $entry_value;

-$entry->_language_id = $lang_id;

-$entry->_project_id  = $project_id;

-

-$entry->selfPost();

-

-

-echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-echo "<success>1</success>\n";

-

-

-// ------...------...------...------...------...------...------...------...------...------...------

-

-echo <<< toTheEnd

-toTheEnd;

-

-// ------...------...------...------...------...------...------...------...------...------...------

-?>
\ No newline at end of file
diff --git a/aptana_global/public/export.php b/aptana_global/public/export.php
deleted file mode 100755
index 5657e5b..0000000
--- a/aptana_global/public/export.php
+++ /dev/null
@@ -1,104 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/

-// if not logged in redirect to login page

-// otherwise show choices

-require_once("aptana_global/aptana.inc.php");

-require_once("aptana_global/agent.inc.php");

-// ------...------...------...------...------...------...------...------...------...------...------

-// should move this out of here

-InitPage("export");

-

-$lang_code = (isset($_GET['lang'])?$_GET['lang']:'');

-$format    = 'xml';

-

-$entry_rec = new entries_iu(0);

-$lang_rec  = new languages_iu(0);

-$lang_rec->sqlLoad("iso_code",$lang_code);

-
-if (!$lang_rec->_id) {
-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
-  echo "<error>language not found</error>\n";
-  exit;
-}
-
-
-$lang_name = $lang_rec->_name;

-$file_name = $lang_name . "_Translation.xml";

-

-$path = array();

-$cmd = "SELECT * FROM entries WHERE language_id=1";

-$qry = mysql_query($cmd);

-while ($rec = mysql_fetch_object($qry)) {

-  $path[$rec->name] = $rec->repo_path;

-}

-

-$cmd       = "SELECT entries.name AS entry," .

-             "       entries.value AS value," .

-             "       projects.name AS name, " .

-             "       projects.package_name AS package," .

-             "       projects.id AS id" .

-             "  FROM entries,projects " .

-             " WHERE projects.id=entries.project_id " .

-             "   AND language_id=" . $lang_rec->_id .

-             " ORDER BY projects.id";

-$qry = mysql_query($cmd);

-
-header("Pragma: no-cache");

-header("Content-Type: application/xml");

-header("Content-Disposition: attachment; filename=$file_name");

-

-echo <<< toTheEnd

-<?xml version="1.0" encoding="UTF-8"?>

- <translation>

- <language>$lang_name</language>
- <iso_name>$lang_code</iso_name>
- <projects>

-

-toTheEnd;

-

-$proj_id = 0;

-while ($entry = mysql_fetch_object($qry)) {

-  if (strlen($entry->value) < 1)
-    continue;
-  if ($entry->id != $proj_id) {

-    if ($proj_id) {

-      echo "   </entries>\n";
-      echo "  </project>\n";
-    }

-    $proj_id = $entry->id;

-    echo "  <project>\n";
-    echo "   <name>$entry->name</name>\n";
-    echo "   <entries>\n";
-  }

-  $entry_rec->sqlLoad("name='$entry->entry' AND language_id=1");

-  echo "   <entry>\n";
-  echo "     <name>$entry->entry</name>\n";
-  echo "     <value>\n";
-  echo "      <![CDATA[$entry->value]]>\n";
-  echo "     </value>\n";
-  echo "     <file>" . $path[$entry->entry] . "</file>\n";
-  echo "    </entry>\n";
-}

-

-// ------...------...------...------...------...------...------...------...------...------...------

-

-echo <<< toTheEnd

-   </entries>
-  </project>
- </projects>
-</translation>

-

-toTheEnd;

-

-// ------...------...------...------...------...------...------...------...------...------...------

-?>
\ No newline at end of file
diff --git a/aptana_global/public/export.php.sav b/aptana_global/public/export.php.sav
deleted file mode 100755
index 03a2cb5..0000000
--- a/aptana_global/public/export.php.sav
+++ /dev/null
@@ -1,99 +0,0 @@
-<?php

-/*******************************************************************************

- * Copyright (c) 2007 Eclipse Foundation and others.

- * All rights reserved. This program and the accompanying materials

- * are made available under the terms of the Eclipse Public License v1.0

- * which accompanies this distribution, and is available at

- * http://www.eclipse.org/legal/epl-v10.html

- *

- * Contributors:

- *    Paul Colton (Aptana)- initial API and implementation

-

-*******************************************************************************/

-// if not logged in redirect to login page

-// otherwise show choices

-require_once("aptana_global/aptana.inc.php");

-require_once("aptana_global/agent.inc.php");

-// ------...------...------...------...------...------...------...------...------...------...------

-// should move this out of here

-InitPage("export");

-

-$lang_code = (isset($_GET['lang'])?$_GET['lang']:'');

-$format    = 'xml';

-

-$entry_rec = new entries_iu(0);

-$lang_rec  = new languages_iu(0);

-$lang_rec->sqlLoad("iso_code",$lang_code);

-

-if (!$lang_rec->_id) {

-  echo "language not found";

-  exit;

-}

-$lang_name = $lang_rec->_name;

-$file_name = $lang_name . "_Translation.xml";

-

-$path = array();

-$cmd = "SELECT * FROM entries WHERE language_id=1";

-$qry = mysql_query($cmd);

-while ($rec = mysql_fetch_object($qry)) {

-  $path[$rec->name] = $rec->repo_path;

-}

-

-$cmd       = "SELECT entries.name AS entry," .

-             "       entries.value AS value," .

-             "       projects.name AS name, " .

-             "       projects.package_name AS package," .

-             "       projects.id AS id" .

-             "  FROM entries,projects " .

-             " WHERE projects.id=entries.project_id " .

-             "   AND language_id=503 " .

-             " ORDER BY projects.id";

-$qry = mysql_query($cmd);

-

-header("Pragma: no-cache");

-header("Content-Type: application/xml");

-header("Content-Disposition: attachment; filename=$file_name");

-

-echo <<< toTheEnd

-<?xml version="1.0" encoding="UTF-8"?>

- <translation>

- <language>$lang_name</language>
- <iso_name>$lang_code</iso_name>
- <projects>

-

-toTheEnd;

-

-$proj_id = 0;

-while ($entry = mysql_fetch_object($qry)) {

-  if ($entry->id != $proj_id) {

-    if ($proj_id) {

-      echo "   </entries>\n";
-      echo "  </project>\n";
-    }

-    $proj_id = $entry->id;

-    echo "  <project>\n";
-    echo "   <name>$entry->name</name>\n";
-    echo "   <entries>\n";
-  }

-  $entry_rec->sqlLoad("name='$entry->entry' AND language_id=1");

-  echo "   <entry>\n";
-  echo "     <name>$entry->entry</name>\n";
-  echo "     <value>\n";
-  echo "      <![CDATA[$entry->value]]>\n";
-  echo "     </value>\n";
-  echo "     <file>" . $path[$entry->entry] . "</file>\n";
-  echo "    </entry>\n";
-}

-

-// ------...------...------...------...------...------...------...------...------...------...------

-

-echo <<< toTheEnd

-   </entries>
-  </project>
- </projects>
-</translation>

-

-toTheEnd;

-

-// ------...------...------...------...------...------...------...------...------...------...------

-?>
\ No newline at end of file
diff --git a/aptana_global/public/get_entries.php b/aptana_global/public/get_entries.php
deleted file mode 100755
index da5a642..0000000
--- a/aptana_global/public/get_entries.php
+++ /dev/null
@@ -1,59 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/

-// if not logged in redirect to login page

-// otherwise show choices

-require_once("../aptana.inc.php");

-// ------...------...------...------...------...------...------...------...------...------...------

-// should move this out of here

-InitPage("get_projects");

-

-$lang  = $_GET['lang'];

-$proj  = $_GET['proj'];

-$entr  = new entries_iu(0);

-

-$done = array();

-$entr->sqlList("select name from entries where project_id=$proj and language_id=$lang");
-

-while ($entr->sqlNext()) {

-  $done[$entr->_name] = 1;

-}

-

-$entr->sqlList("select name from entries where project_id=$proj AND language_id=1 AND value>''"); // group by name order by name");

-echo "<table cellspacing=0 cellpadding=0 border=0 style='width:321px;font-size:8pt;'>\n";

-echo "<tr><td></td></tr>";

-$x = 1;

-while ($entr->sqlNext()) {

-  $name  = trim($entr->_name);

-  $id    = (empty($entr->_id)?"0":$entr->_id);

-  if (isset($done[$entr->_name])) {

-    echo "<tr><td style='border-bottom:solid 1px #aaa;'> ";

-    echo "    <a class=ss href='#' onmousedown='selEntry($id,$x);' onmouseover='ratoverE($x);' onmouseout='ratoutE($x);'> ";

-    echo "    <div id=myEdiv$x class=entryDone>$name</div></a></td></tr>\n";

-  }

-  else {

-    echo "<tr><td style='border-bottom:solid 1px #aaa;'> ";

-    echo "    <a class=ss href='#' onmousedown='selEntry($id,$x);' onmouseover='ratoverE($x);' onmouseout='ratoutE($x);'> ";

-    echo "    <div id=myEdiv$x class=entryUnDone>$name</div></a> </td></tr>\n";

- }

-    $x++;

-}

-echo "</table>\n";

-

-

-/*

-

-alert("There was a problem retrieving the XML data:\n" + req.statusText);

-*/

-// ------...------...------...------...------...------...------...------...------...------...------

-

-?>
\ No newline at end of file
diff --git a/aptana_global/public/get_entry.php b/aptana_global/public/get_entry.php
deleted file mode 100755
index 7f3629f..0000000
--- a/aptana_global/public/get_entry.php
+++ /dev/null
@@ -1,143 +0,0 @@
-<?php

-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// if not logged in redirect to login page

-// otherwise show choices
-

-require_once("../aptana.inc.php");

-// ------...------...------...------...------...------...------...------...------...------...------

-// should move this out of here

-InitPage("get_entry");

-

-$langID  = $_GET['lang'];

-$projID  = $_GET['proj'];

-$entryN  = $_GET['entry'];

-$nextId  = 0;

-$nextIdx = 1;

-$entr  = new entries_iu(0);

-

-

-

-

-$entr->sqlList("select name from entries where project_id=$projID AND language_id=1 AND value>''"); // group by name order by name");

-$x = 1;

-$idIdx = array();

-while ($entr->sqlNext()) {

-  $id    = (empty($entr->_id)?"0":$entr->_id);

-  $idIdx[$x] = $id;

-  if ($nextIdx == $x)

-    $nextId  = $id;

-  $x++;

-  if ($entr->_name == $entryN) {

-    $nextIdx = $x;

-  }

-}

-

-$entr->sqlLoad("name='$entryN' AND project_id=$projID AND language_id=$langID");

-

-if ($entr->_language_id && ($entr->_language_id!=$langID))

-exit;

-if ($entr->_project_id && ($entr->_project_id!=$projID))

-exit;

-

-$entr->_language_id = $langID;

-$entr->_project_id  = $projID;

-

-$english = new entries_iu(0);

-$english->sqlLoad("name='$entryN' AND project_id=$projID AND language_id=1");

-

-$isEmpty = "no";

-if ($entr->_id == 0) {

-  $entr->_name        = $entryN;

-  $entr->_language_id = $langID;

-  $entr->_project_id  = $projID;

-$isEmpty = "yes";

-  

-}

-

-

-$proj = new projects_iu($projID);

-$pname  = trim(strlen($proj->_name)?$proj->_name:$proj->_package_name);

-

-$sel0 = ($entr->_rating==0?"selected":"");

-$sel1 = ($entr->_rating==1?"selected":"");

-$sel2 = ($entr->_rating==2?"selected":"");

-$sel3 = ($entr->_rating==3?"selected":"");

-$sel4 = ($entr->_rating==4?"selected":"");

-$sel5 = ($entr->_rating==5?"selected":"");

-

-echo <<< toTheEnd

-

-

-<table cellspacing=10 cellpadding=2 border=0>

-<tr>

-<td id="formLblSmall">Project</td>

-<td>$pname</td>

-</tr>  

-  

-<tr>

-<td id="formLblSmall">Entry&nbsp;Name</td>

-<td style='border:solid 1px #333377;color:#000000;'>$english->_name</td>

-</tr>  

-

-<tr>

-<td id="formLblSmall"></td>

-<td style='font-size:7pt;border:solid 1px #bbb;color:#666666;background:#efefef;'>The entry name is split into two parts. The part before the underscore '_' is the name of the class in Aptana. Use this to help guide you where this item is used in code. The part ofter the underscore is an abbreviated name to help find this item easily in a list.</td>

-</tr>  

-

-

-

-<tr>

-<td id="formLblSmall">English&nbsp;Text</td>

-<td style='border:solid 1px #333377;color:#000099;'>$english->_value</td>

-</tr>  

-

-<tr>

-<td id="formLblSmall">Translation</td>

-<td><textarea id=ctrl1 rows='4' style='width:100%;' onKeyPress="dirty();">$entr->_value</textarea></td>

-</tr>  

-

-<tr>

-<td id="formLblSmall"></td>

-<td style='font-size:7pt;border:solid 1px #bbb;color:#666666;background:#efefef;'>If the original text has tokens in it '{0}', make sure that the translated text contains the same tokens.</td>

-</tr>  

-

-<tr>

-<td id="formLblSmall">Quality&nbsp;rating</td>

-<td style='font-size:7pt;border:solid 1px #bbb;background:#ffffff;'> 

-<select id=ctrl2 onchange="dirty();">

-<option value='0' $sel0> </option>

-<option value='1' $sel1>1</option>

-<option value='2' $sel2>2</option>

-<option value='3' $sel3>3</option>

-<option value='4' $sel4>4</option>

-<option value='5' $sel5>5</option>

-</select>

-  Please give this entry a 1-5 stars rating.</td>

-</tr>  

-

-<tr>

-<td id="formLblSmall"></td>

-<td><input type='button' name='save' value='Save Translation' onclick="PostEntry();">&nbsp;&nbsp;

-<input type='button' name='next' value='Next' onclick="selEntry($nextId,$nextIdx);">

-</td>

-</tr>  

-

-  

-</table>  

-

-

-toTheEnd;

-

-// ------...------...------...------...------...------...------...------...------...------...------

-

-?>
\ No newline at end of file
diff --git a/aptana_global/public/get_projects.php b/aptana_global/public/get_projects.php
deleted file mode 100755
index a114ff1..0000000
--- a/aptana_global/public/get_projects.php
+++ /dev/null
Binary files differ
diff --git a/aptana_global/public/gget_projects.php b/aptana_global/public/gget_projects.php
deleted file mode 100755
index 6ffffbd..0000000
--- a/aptana_global/public/gget_projects.php
+++ /dev/null
Binary files differ
diff --git a/aptana_global/public/imgs/background-header-tile.gif b/aptana_global/public/imgs/background-header-tile.gif
deleted file mode 100644
index b50a79a..0000000
--- a/aptana_global/public/imgs/background-header-tile.gif
+++ /dev/null
Binary files differ
diff --git a/aptana_global/public/imgs/background-header.gif b/aptana_global/public/imgs/background-header.gif
deleted file mode 100644
index ed707b8..0000000
--- a/aptana_global/public/imgs/background-header.gif
+++ /dev/null
Binary files differ
diff --git a/aptana_global/public/imgs/get-started.gif b/aptana_global/public/imgs/get-started.gif
deleted file mode 100644
index c91b856..0000000
--- a/aptana_global/public/imgs/get-started.gif
+++ /dev/null
Binary files differ
diff --git a/aptana_global/public/imgs/p.gif b/aptana_global/public/imgs/p.gif
deleted file mode 100644
index 35d42e8..0000000
--- a/aptana_global/public/imgs/p.gif
+++ /dev/null
Binary files differ
diff --git a/aptana_global/public/imgs/rollover.gif b/aptana_global/public/imgs/rollover.gif
deleted file mode 100644
index 979c1e7..0000000
--- a/aptana_global/public/imgs/rollover.gif
+++ /dev/null
Binary files differ
diff --git a/aptana_global/public/imgs/selected.gif b/aptana_global/public/imgs/selected.gif
deleted file mode 100644
index 4761c02..0000000
--- a/aptana_global/public/imgs/selected.gif
+++ /dev/null
Binary files differ
diff --git a/aptana_global/public/imgs/spinner.gif b/aptana_global/public/imgs/spinner.gif
deleted file mode 100644
index deac700..0000000
--- a/aptana_global/public/imgs/spinner.gif
+++ /dev/null
Binary files differ
diff --git a/aptana_global/public/import.php b/aptana_global/public/import.php
deleted file mode 100755
index d4270f0..0000000
--- a/aptana_global/public/import.php
+++ /dev/null
@@ -1,125 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/

-// if not logged in redirect to login page

-// otherwise show choices

-require_once("aptana_global/aptana.inc.php");

-require_once("aptana_global/agent.inc.php");

-// ------...------...------...------...------...------...------...------...------...------...------

-// should move this out of here

-InitPage("export");

-

-

-$project_name = (isset($_POST['project_name'])?$_GET['project_name']:'');

-$package_name = (isset($_POST['package_name'])?$_GET['package_name']:'');

-$entry_name   = (isset($_POST['entry_name'])?$_GET['entry_name']:'');

-$entry_value  = (isset($_POST['entry_value'])?$_GET['entry_value']:'');

-$repo_path    = (isset($_POST['repo_path'])?$_GET['repo_path']:'');

-$lang_code    = (isset($_POST['lang'])?$_GET['lang']:'en');

-$lang_id      = 0;

-/* testing

-$project_name = "Aptana FTP Synchronization Provider";

-$package_name = "com.aptana.ide.syncing.ftp";

-$entry_name   = "FtpVirtualFileManager_PathCanBeEmpty";

-$entry_value  = "path cannot be empty or null.";

-$repo_path    = "src/com/aptana/ide/io/ftp/messages.properties";

-*/

-

-

-$cmd = "SELECT * FROM languages WHERE iso_code='$lang_code'";

-if ($qry = mysql_query($cmd)) {

-  if ($rec = mysql_fetch_object($qry)) {

-    $lang_id = $rec->id;

-  }

-}

-

-

-if ($lang_id != 1) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>invalid language code</error>\n";

-  exit;

-}

-

-if (empty($project_name)) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>no project_name</error>\n";

-  exit;

-}

-if (empty($package_name)) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>no package_name</error>\n";

-  exit;

-}

-if (empty($entry_name)) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>no entry_name</error>\n";

-  exit;

-}

-if (empty($entry_value)) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>no entry_value</error>\n";

-  exit;

-}

-if (empty($repo_path)) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>no repo_path</error>\n";

-  exit;

-}

-

-$cmd = "SELECT * FROM projects WHERE name='$project_name'";

-if ($qry = mysql_query($cmd)) {

-  if (!($rec = mysql_fetch_object($qry))) {

-    $inCmd = "INSERT INTO projects SET name='$project_name',package_name='$package_name',updated_on=NOW(),created_on=NOW()";

-    if (mysql_query($inCmd)) {

-      //if ($qry = mysql_query($cmd))

-      //  $rec = mysql_fetch_object($qry);

-    }

-  }

-}

-

-if (empty($rec)) {

-  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-  echo "<error>error finding project</error>\n";

-  exit;

-}

-

-

-$entry = new entries_iu(0);

-$entry->sqlLoad("language_id=1 AND project_id=$rec->id AND name='$entry_name'");

-

-if ($entry->_id && ($entry->_value != $entry_value)) {

-  $cmd = "DELETE FROM entries WHERE language_id>1 AND project_id='" . $rec->id . "' AND name='$entry_name'";

-  //mysql_query($cmd);

-}

-

-

-$entry->_name        = $entry_name;

-$entry->_value       = $entry_value;

-$entry->_repo_path   = $package_name . "/" . $repo_path;

-$entry->_language_id = "1";

-$entry->_project_id  = $rec->id;

-

-

-$entry->selfPost();

-

-

-echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";

-echo "<success>1</success>\n";

-

-

-// ------...------...------...------...------...------...------...------...------...------...------

-

-echo <<< toTheEnd

-toTheEnd;

-

-// ------...------...------...------...------...------...------...------...------...------...------

-?>
\ No newline at end of file
diff --git a/aptana_global/public/index.html b/aptana_global/public/index.html
deleted file mode 100755
index 6e4d7e9..0000000
--- a/aptana_global/public/index.html
+++ /dev/null
@@ -1,7 +0,0 @@
-<html>
-<body>
-
-Aptana
-
-</body>
-</html>
diff --git a/aptana_global/public/index.php b/aptana_global/public/index.php
deleted file mode 100644
index 92034ec..0000000
--- a/aptana_global/public/index.php
+++ /dev/null
@@ -1,136 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-$pageTitle = "Babel";
-$pageKeywords = "";
-
-require_once("../aptana.inc.php");
-
-// ------...------...------...------...------...------...------...------...------...------...------
-// should move this out of here
-InitPage("login");
-$welcome = "";
-if (isset($_SESSION['s_userName']))
-  $welcome = "Welcome back " . $_SESSION['s_userName'];
-else {
-	header("Location: login.php");
-	exit;
-}
-
-$user  = new users_iu($s_userAcct);
-$langs = new languages_iu(0);
-$langs->sqlList("SELECT * FROM {SELF} ORDER BY name");
-
-$langSel = (isset($_POST['language_id'])?$_POST['language_id']:$user->_primary_language_id);
-$langCombo = "\n";
-while ($langs->sqlNext())
-  if ($langs->_id > 1) {
-    $selected   = (($langSel==$langs->_id)?"Selected":"");
-    $langCombo .= "<option value='$langs->_id' $selected>$langs->_name</option>\n";
-  }
-
-
-$borderC  = "#777799";
-
-$agent = $_SERVER['HTTP_USER_AGENT'];
-$overFlow = ((eregi("microsoft internet explorer", $agent))?"":"overflow:auto");
-
-/*
-<p />

-$welcome

-<p />

-

-<a href='logout.php'>Logout</a>

-*/  

-// ------...------...------...------...------...------...------...------...------...------...------

-
-# TODO: move all this JS to a .js file
-require_once(BABEL_BASE_DIR . 'head.php');

-echo <<< toTheEnd

-

-

-<div id="maincontent">
-
-<div id="midcolumn">
-
-<h1>$pageTitle</h1>
-<h2 id='logout'><a href="logout.php">logout</a></h2>
-

-<!--   huh?   
--->

-
-<script>window.onload="langChange($langSel)"</script>
-

-<div class='babel-container'>

-

-	<table cellspacing=0 cellpadding=0 border=0>

-		<tr>

-  			<td style='width:200px'><img src='imgs/p.gif' width=200 height=1px></td>

-  			<td style='width:325px'><img src='imgs/p.gif' width=325 height=1px></td>

-  			<td style='width:100%' ></td>

-		</tr>

-

-		<tr>  

-		  <td style='width:200px;border:solid 1px $borderC;'>
-		  

-		    <table cellspacing=0 cellpadding=0 border=0>

-    			<tr>
-    				<td style='padding:4px 4px 0px 4px;'>&nbsp;<b>Translate from English to:</b></td>
-    			</tr>

-    			<tr>
-    				<td style='padding:4px;'>

-        				<select id="language_id" name="language_id" style='width:210px;' onchange="langChange(this.value);">$langCombo</select>

-    				</td>
-    			</tr>

-    		</table>

-    

-    		<table cellspacing=0 cellpadding=0 border=0>

-    			<tr>
-    				<td style='padding:4px;border-top:solid 1px $borderC;'>&nbsp;<b>Select a Project</b></td>
-    			</tr>

-    			<tr>
-    				<td style='width:220px;padding:0px;'>

-				    	<div id=projDiv name=projDiv style='width:220px;overflow:hidden;border-top:solid 1px #bbb;background-color:#fff;'></div>

-		   	    	</td>
-		   	    </tr>

-    		</table>

-  		  </td>

-

-  		  <td style='width:325px;border-top:solid 1px $borderC;border-bottom:solid 1px $borderC;'>

-	    	<table cellspacing=0 cellpadding=0 border=0>

-    			<tr><td style='width:2px'><img src='imgs/p.gif' width=2 height=47px></td></tr>

-    			<tr><td style='padding:5px;'>&nbsp;<b>Select an Entry</b></td></tr>

-    			<tr>
-    				<td style='width:325px;'>
-    					<div id=entryDiv name=entryDiv style='$overFlow;width:325px;height:500px;border-top:solid 1px #bbb;background-color:#fff;'>    

-    					</div>

-    				</td>
-    			</tr>
-   		 	</table>

-  		  </td>  

-

-  		  <td style='width:100%;border:solid 1px $borderC;padding:10px;' >

-  				<div id=entryEdit name=entryEdit >

-    				<div style='width:300px;'></div>

-  				</div>
-  		 </td>
-  	</tr>

-  
-</table>
-  
-</div>
-
-</div> </div>
-

-toTheEnd;

-require_once(BABEL_BASE_DIR.'foot.php');

-?>
\ No newline at end of file
diff --git a/aptana_global/public/intro.php b/aptana_global/public/intro.php
deleted file mode 100755
index 8fb26ab..0000000
--- a/aptana_global/public/intro.php
+++ /dev/null
@@ -1,33 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/

-$pageTitle = "Welcome to Babel";
-$pageKeywords = "";
-
-require_once("../aptana.inc.php");
-require_once(BABEL_BASE_DIR . 'head.php');
-
-echo <<< toTheEnd
-<div id="maincontent">
-<div id="midcolumn">
-
-<h1>$pageTitle</h1>
-<p>Welcome to Babel. Babel is designed to ease the process

-of translating Eclipse into another language.</p>

-<p>Ready to begin translating? <a href='index.php'>Let's go!</a></p>

-</div>

-</div>
-</div>

-

-toTheEnd;

-require_once('../foot.php');    

-?>
\ No newline at end of file
diff --git a/aptana_global/public/js/babel.js b/aptana_global/public/js/babel.js
deleted file mode 100644
index 2089668..0000000
--- a/aptana_global/public/js/babel.js
+++ /dev/null
@@ -1,209 +0,0 @@
-var req;
-var reqID;
-var lang;
-var projID   = 0;
-var projIdx  = 0;
-var projWid  = 0;
-var entryID  = 0;
-var entryIdx = 0;
-var isDirty  = false;
-
-function ratover(idx) {
-  divItem = document.getElementById('myPdiv' + idx);
-  if (divItem.className != "projSel")
-    divItem.className = "graphOut";
-}
-
-function ratout(idx) {
-  divItem = document.getElementById('myPdiv' + idx);
-  if (divItem.className != "projSel")
-    divItem.className = "graph";
-  
-}
-
-function ratoverE(idx) {
-  divItem = document.getElementById('myEdiv' + idx);
-  if (divItem.className == "entryDone")
-    divItem.className = "entryHi1";
-  else if (divItem.className == "entryUnDone")
-    divItem.className = "entryHi2";
-}
-
-function ratoutE(idx) {
-  divItem = document.getElementById('myEdiv' + idx);
-  if (divItem.className == "entryHi1")
-    divItem.className = "entryDone";
-  else if (divItem.className == "entryHi2")
-    divItem.className = "entryUnDone";
-}
-
-
-
-function langChange(l) {
-  if (isDirty) {
-    if (confirm("Save changes to this entry?"))
-      PostEntry();
-  }
-  lang = l;
-  resetEntryEdit(lang,0);
-  resetEntryList(lang,0);
-  resetProjectList(lang);
-}
-
-
-function selProj(id,idx) {
-  if (isDirty) {
-    if (confirm("Save changes to this entry?"))
-      PostEntry();
-  }
-  if (projIdx) {
-    if (divItem = document.getElementById('myPdiv' + projIdx)) {
-      divItem.className = "graph";
-      divItem.style.width = projWid;
-    }
-  }
-  projIdx = idx;
-  projID  = id
-  if (divItem = document.getElementById('myPdiv' + projIdx)) {
-    projWid = divItem.style.width;
-    divItem.className = "projSel";
-    divItem.style.width = "220px";
-  }
-  resetEntryList(lang,projID);
-  resetEntryEdit(lang,0);
-}
-
-function selEntry(id,idx) {
-  if (isDirty) {
-    if (confirm("Save changes to this entry?"))
-      PostEntry();
-  }
-  if (entryIdx) {
-    if (divItem = document.getElementById('myEdiv' + entryIdx)) {
-      if ((divItem.className == "entrySel1") || (divItem.className == "entryDone")) 
-        divItem.className = "entryDone";
-      else 
-        divItem.className = "entryUnDone";
-    }
-  }
-  entryIdx = idx;
-  if (divItem = document.getElementById('myEdiv' + entryIdx)) {
-    if ((divItem.className == "entryDone") || (divItem.className == "entryHi1"))
-      divItem.className = "entrySel1";
-    else 
-      divItem.className = "entrySel2";
-    entryID = divItem.innerHTML;
-  }
-  resetEntryEdit(lang,1);    
-
-}
-
-function PostEntry() {
-  ctrl1 = "";
-  ctrl2 = "";
-  if (divItem = document.getElementById('ctrl1'))
-    ctrl1 = divItem.value;
-  if (divItem = document.getElementById('ctrl2')) 
-    ctrl2 = divItem.value;
-  isDirty = false;
-  loadXMLDoc("post_entry.php?lang=" + lang + "&proj=" + projID + "&entry=" + entryID + "&ctrl2=" + ctrl2 + "&ctrl1=" + ctrl1,4);
-}
-
-
-
-function resetEntryEdit(l,id) {
-  if (id) {
-    if (lang && projID && entryIdx && (divItem = document.getElementById('entryEdit')))
-      divItem.innerHTML = "<div style='height:489px;'><center><p /><br /><br /><br /><img src='imgs/spinner.gif'><br />loading...</center>";
-    loadXMLDoc("get_entry.php?lang=" + lang + "&proj=" + projID + "&entry=" + entryID,3);
-  } 
-  else {
-    if (divItem = document.getElementById('entryEdit'))
-      divItem.innerHTML = "";    
-  }
-  isDirty = false;
-}
-
-
-function resetEntryList(l,p) {
-  entryID  = 0;
-  entryIdx = 0;
-  if (p == 0) {
-    divItem = document.getElementById('entryDiv');
-    divItem.innerHTML = "";
-  }
-  else {
-    if (divItem = document.getElementById('entryDiv'))
-      divItem.innerHTML = "<div style='height:489px;'><center><p /><br /><br /><br /><img src='imgs/spinner.gif'><br />loading...</center>";
-    loadXMLDoc("get_entries.php?lang=" + l + "&proj=" + p,2);
-  }
-}
-
-
-
-
-
-function resetProjectList(l) {
-  projID = 0;
-  if (divItem = document.getElementById('projDiv'))
-    divItem.innerHTML = "<div style='height:489px;'><center><p /><br /><br /><br /><img src='imgs/spinner.gif'><br />loading...</center>";
-  loadXMLDoc("get_projects.php?lang=" + l,1);
-}
-
-
-
-
-
-function processReqChange() {
-  if (req.readyState == 4) {
-    if (req.status == 200) {
-      if (reqID == 1) {
-        if (divItem = document.getElementById('projDiv'))
-        divItem.innerHTML = req.responseText;    
-        
-      }
-      else if (reqID == 2) {
-        if (divItem = document.getElementById('entryDiv'))
-        divItem.innerHTML = req.responseText;    
-      }
-      else if (reqID == 3) {
-        if (divItem = document.getElementById('entryEdit'))
-        divItem.innerHTML = req.responseText;    
-        
-      }
-      else if (reqID == 4) {
-        
-        
-      }
-    }
-    else {
-      ; //
-    }
-  }
-}
-
-
-function loadXMLDoc(url,id) {
-  reqID = id;
- 
-  if (window.XMLHttpRequest) {
-    req = new XMLHttpRequest();
-    req.onreadystatechange = processReqChange;
-    req.open('GET', url, true);
-    req.send(null);
-  }
-  else if (window.ActiveXObject) {
-    req = new ActiveXObject('Msxml2.XMLHTTP');
-    if (req) {
-      req.onreadystatechange = processReqChange;
-      req.open('GET', url, true);
-      req.send();
-    }
-  }
-}
-
-
-function dirty() {
-  isDirty = true;
-}
-
diff --git a/aptana_global/public/login.php b/aptana_global/public/login.php
deleted file mode 100755
index c62039e..0000000
--- a/aptana_global/public/login.php
+++ /dev/null
@@ -1,67 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
- *    Eclipse Foundation
-*******************************************************************************/
-
-$pageTitle = "Babel Login";
-$pageKeywords = "translation,language,nlpack,pack,eclipse,babel";
-
-require_once("../aptana.inc.php");
-require_once(BABEL_BASE_DIR . 'code/login.code.php');

-require_once(BABEL_BASE_DIR . 'head.php');
-
-# TODO: finish the intro text
-

-echo <<< toTheEnd
-<div id="maincontent">
-<div id="midcolumn">
-

-<h1>$pageTitle</h1>
-<p>Welcome to Babel - the Eclipse translation tool. TODO: Explain what this is and how to use.  Link to Privacy/Terms?</p>
-
-<p>Use your Bugzilla e-mail address and 
-password to login. If you don't have a Bugzilla account, you can <a href="https://bugs.eclipse.org/bugs/createaccount.cgi">create one here</a>.</p>

-<form method="post">

-

-<table cellspacing=4 cellpadding=0 border=0>

-<tr><td></td><td id="formErr" colspan=2 style="color:red;">{$GLOBALS['g_ERRSTRS'][0]}&nbsp;</td></tr>

-<tr>

-  <td id="formErr" style='width:100px;'>&nbsp;</td>

-  <td id="formLbl">Email:</td><td style='text-align:left;'><input type="text" name="username" value="$post_username" size="42" maxlength="255" /></td>

-  <td id="formErr" style='width:100px; color:red;'>{$GLOBALS['g_ERRSTRS'][1]}&nbsp;</td>

-</tr>

-<tr>

-  <td id="formErr" style='width:100px;'>&nbsp;</td>

-  <td id="formLbl">Password:</td><td style='text-align:left;'><input type="password" name="password" value="$post_password" size="42" maxlength="255"/> <a href="https://bugs.eclipse.org/bugs/index.cgi?GoAheadAndLogIn=1#forgot">Forgot my password</a></td>

-  <td id="formErr" style='width:100px; color:red;'>{$GLOBALS['g_ERRSTRS'][2]}&nbsp;</td>

-</tr>

-<tr>

-  <td id="formErr" style='width:100px;'>&nbsp;</td>

-  <td></td><td style='text-align:left;'><input type="checkbox" name="remember" value="1" $post_remember />remember me </td>

-</tr>

-<tr>

-  <td id="formErr" style='width:100px;'>&nbsp;</td>

-  <td></td><td style='text-align:left;'><input type="submit" name="postIT" value="Login" style="font-size:14px;" /></td></tr>

-</table>

-</form>

-</div><div id="rightcolumn">
-
-<div class="sideitem">
-	<h6>Related Linkx</h6>
-	<ul>
-		<li><a href="//www.eclipse.org/babel/">Babel project home</a></li>
-	</ul>
-</div>
-</div>

-</div>

-toTheEnd;

-require_once(BABEL_BASE_DIR.'foot.php');    

-?>
\ No newline at end of file
diff --git a/aptana_global/public/logout.php b/aptana_global/public/logout.php
deleted file mode 100755
index fc1091b..0000000
--- a/aptana_global/public/logout.php
+++ /dev/null
@@ -1,17 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
- *    Eclipse Foundation
-*******************************************************************************/

-require_once("../aptana.inc.php");
-require_once(BABEL_BASE_DIR . 'code/logout.code.php');

-$lastURL = GetSessionVar('s_pageLast');

-exitTo("" . ($lastURL?$lastURL:"index.php"));

-?>
\ No newline at end of file
diff --git a/aptana_global/public/post_entry.php b/aptana_global/public/post_entry.php
deleted file mode 100755
index 8bb9ba9..0000000
--- a/aptana_global/public/post_entry.php
+++ /dev/null
@@ -1,66 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/

-// if not logged in redirect to login page

-// otherwise show choices

-require_once("aptana_global/aptana.inc.php");

-// ------...------...------...------...------...------...------...------...------...------...------

-// should move this out of here

-InitPage("get_entry");

-

-$langID  = $_GET['lang'];

-$projID  = $_GET['proj'];

-$entryN  = $_GET['entry'];

-$ctrl1   = $_GET['ctrl1'];

-$ctrl2   = $_GET['ctrl2'];

-$entr    = new entries_iu(0);

-

-$entr->sqlLoad("name='$entryN' AND project_id=$projID AND language_id=$langID");

-

-if ($entr->_language_id && ($entr->_language_id!=$langID))

-exit;

-if ($entr->_project_id && ($entr->_project_id!=$projID))

-exit;

-

-$entr->_language_id = $langID;

-$entr->_project_id  = $projID;

-$entr->_rating      = $ctrl2;

-$entr->_value       = $ctrl1;

-$entr->_name        = $entryN;

-$entr->_user_id     = $s_userAcct;

-$entr->_updated_on  = date("Y:m:d");

-$entr->_updated_at  = date("H:i:s");

-if ($entr->_id == 0) {

-$entr->_created_on  = date("Y:m:d");

-$entr->_created_at  = date("H:i:s");

-}

-

-if (($langID>1) && (trim($ctrl1) == '')) {

-  if ($entr->_id)

-    $entr->sqlCmd("DELETE FROM {SELF} WHERE id='" . $entr->_id . "'");

-  exit;

-}

-

-

-echo $entr->selfPost();

-print_r( $entr );

-echo <<< toTheEnd

-

-$langID $projID  $entryN  $ctrl2 $ctrl1

-

-

-

-toTheEnd;

-

-// ------...------...------...------...------...------...------...------...------...------...------

-

-?>
\ No newline at end of file
diff --git a/aptana_global/public/privacy.php b/aptana_global/public/privacy.php
deleted file mode 100755
index 7b968ba..0000000
--- a/aptana_global/public/privacy.php
+++ /dev/null
@@ -1,27 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-require_once("aptana_global/aptana.inc.php");
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-include("aptana_global/head.php");
-echo <<< toTheEnd
-
-
-toTheEnd;
-include("aptana_global/foot.php");
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-?>
\ No newline at end of file
diff --git a/aptana_global/public/register.php b/aptana_global/public/register.php
deleted file mode 100755
index 33f09e4..0000000
--- a/aptana_global/public/register.php
+++ /dev/null
@@ -1,106 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-
-/**
- * @deprecated
- */
-header("Location: index.php");
-exit;
-
-require_once("../aptana.inc.php");
-error_reporting(E_ALL);
-

-require_once(BABEL_BASE_DIR."code/register.code.php");

-

-// ------...------...------...------...------...------...------...------...------...------...------

-include(BABEL_BASE_DIR."head.php");
-
-
-$users_first_name = stripslashes($users_first_name);
-$users_last_name = stripslashes($users_last_name);
-

-echo <<< toTheEnd

-

-<center>

-<form method="post">

-<div id="title">Create Your Aptana Global Account - It's Free!</div>

-

-<table cellspacing=4 cellpadding=0>

-

-<tr>

-  <td id="formLbl">first name:</td>

-  <td><input type="edit" name='{$users_first_name_name}' id='{$users_first_name_name}' value="{$users_first_name}"/></td>

-  <td id="formErr" colspan=2>{$errStr3}&nbsp;</td>

-<tr>

-  <td id="formLbl">last name:</td>

-  <td><input type="edit" name='{$users_last_name_name}' id='{$users_last_name_name}' value="{$users_last_name}"/></td>

-  <td id="formErr" colspan=2>{$errStr4}&nbsp;</td>

-</tr>

-

-<tr>

-  <td id="formLbl">username:</td>

-  <td id="formEdt"><input type="text" name='{$users_username_name}' id='{$users_username_name}' value="{$users_username}"/></td>

-  <td id="formErr">{$errStr0}&nbsp;</td>

-</tr>

-<tr><td></td><td id="formNote" colspan=2>Alphanumeric only. Must be between 6 and 16 characters.</td></tr>

-

-<tr>

-  <td id="formLbl">email:</td>

-  <td><input type="edit" name='{$users_email_name}' id='{$users_email_name}'value="{$users_email}"/></td>

-  <td id="formErr">{$errStr1}&nbsp;</td>

-</tr>

-<tr><td></td><td id="formNote" colspan=2>Required for account confirmation. We protect your personal<br />information. See our <a href="/privacy.php">privacy policy</a>.</td></tr>

-

-

-<tr>

-  <td id="formLbl">password:</td>

-  <td><input type="password" name='password_plain' id='password_plain' value="{$password_plain}"/></td>

-  <td id="formErr" colspan=2>{$errStr2}&nbsp;</td>

-<tr>

-  <td id="formLbl">verify:</td>

-  <td><input type="password" name="password_confirm" id="password_confirm" value="{$password_confirm}"/></td>

-</tr>

-<tr><td></td><td id="formNote" colspan=2>At least 6 characters long..</td></tr>

-

-

-

-<tr>

-  <td id="formLbl">primary&nbsp;translation&nbsp;language:</td>

-  <td>

-<select id="{$users_primary_language_id_name}" name="{$users_primary_language_id_name}">

-$langCombo

-</select>

-  </td>

-  <td id="formErr" colspan=2>{$errStr5}&nbsp;</td>

-<tr>

-  <td id="formLbl">hours per week:</td>

-  <td>

-<select id="{$users_hours_per_week_name}" name="{$users_hours_per_week_name}">

-$hoursCombo

-</select>  

-  </td>

-  <td id="formErr" colspan=2>&nbsp;</td>

-</tr>

-

-

-

-<tr><td></td><td><br><input type="submit" name="postIT" value="create account"/><br /><br /></td></tr>

-

-</table>

-</form>

-</center>

-toTheEnd;

-include(BABEL_BASE_DIR."foot.php");

-

-// ------...------...------...------...------...------...------...------...------...------...------

-?>
\ No newline at end of file
diff --git a/aptana_global/public/registration_done.php b/aptana_global/public/registration_done.php
deleted file mode 100755
index aaafe17..0000000
--- a/aptana_global/public/registration_done.php
+++ /dev/null
@@ -1,51 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-require_once(BABEL_BASE_DIR."aptana.inc.php");
-InitPage("registration_done");
-
-$code = (isset($_GET['code'])?$_GET['code']:0);
-// ------...------...------...------...------...------...------...------...------...------...------
-
-include("aptana_global/head.php");
-if ($code == 2) {
-echo <<< toTheEnd
-
-<div style="height:74px;"></div>
-
-<p>There was an error creating your account. Please contact tech support.
-<p /><br /><br />
-Thank you for using $g_SITENAME.<br />
-&nbsp;&nbsp;&nbsp;&nbsp;- The Crew<br /><br />
-
-toTheEnd;
-}
-else
-{
-echo <<< toTheEnd
-
-<div style="height:74px;"></div>
-
-<p>Congratulations! You have successfully completed the 
-registration process. Just <a href="/login.php">login</a> to start using and 
-contributing to {$g_SITENAME}.<p /><br /><br />
-Thank you for using $g_SITENAME.<br />
-&nbsp;&nbsp;&nbsp;&nbsp;- The Crew<br /><br />
-
-toTheEnd;
-}
-include("aptana_global/foot.php");
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-?>
\ No newline at end of file
diff --git a/aptana_global/public/rewriter.php b/aptana_global/public/rewriter.php
deleted file mode 100755
index fa48674..0000000
--- a/aptana_global/public/rewriter.php
+++ /dev/null
@@ -1,40 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/

-// ------...------...------...------...------...------...------...------...------...------...------

-

-if (!empty($_SERVER['REQUEST_URI'])) {

-  $uri = $_SERVER['REQUEST_URI'];

-  if ($pos = strpos($uri,"export_data"))  {

-    $lang = substr($uri,$pos+12,2);

-    header("Location: /export.php?lang=$lang");

-    exit;

-  }

-  if ($pos = strpos($uri,"entry/add"))  {

-    header("Location: /import.php");

-    exit;

-  }

-  if ($pos = strpos($uri,"entry/edit"))  {

-    header("Location: /edit.php");

-    exit;

-  }

-}

-

-  header("Location: /index.php");

-  exit;

-

-

-

-echo "<br>file not found";

-

-// ------...------...------...------...------...------...------...------...------...------...------

-?>
\ No newline at end of file
diff --git a/aptana_global/public/test.php b/aptana_global/public/test.php
deleted file mode 100755
index 4dbd046..0000000
--- a/aptana_global/public/test.php
+++ /dev/null
@@ -1,36 +0,0 @@
-#!/usr/bin/php

-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/

-// if not logged in redirect to login page

-// otherwise show choices

-require_once("aptana_global/aptana.inc.php");

-// ------...------...------...------...------...------...------...------...------...------...------

-// should move this out of here

-InitPage("get_entry");

-

-$langID  = $_GET['lang'];

-$projID  = $_GET['proj'];

-$entryN  = $_GET['entry'];

-$nextId  = 0;

-$nextIdx = 1;

-$entr  = new entries_iu(0);

-

-

-$cmd = " select * from entries where language_id=490 and name='PreferenceInitializer_IntitialFileContents'";

-

-$qry = mysql_query($cmd);

-$row = mysql_fetch_object($qry);

-echo $row->value;

-// ------...------...------...------...------...------...------...------...------...------...------

-

-?>
\ No newline at end of file
diff --git a/aptana_global/scripts/sql_create.php b/aptana_global/scripts/sql_create.php
deleted file mode 100755
index 2a4bfb4..0000000
--- a/aptana_global/scripts/sql_create.php
+++ /dev/null
@@ -1,142 +0,0 @@
-#!/usr/local/bin/php
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-ini_set("error_prepend_string","");

-ini_set("error_append_string","");
-require_once(BABEL_BASE_DIR."utils.inc.php");

-// ------...------...------...------...------...------...------...------...------...------...------
-
-$databases  = array("aptana");
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-$tables = array(
-
-// ------...------...------...------...------...------...------...------...------...------...------
-  "user" => array (
-      "id"            => "`id` int(8) unsigned NOT NULL auto_increment",
-
-      "username"      => "`username` varchar(16) binary default NULL",
-      "password"      => "`password` varchar(41) binary default NULL",
-      "email"         => "`email` varchar(48) default NULL",
-
-      "first_name"    => "`first_name` varchar(24) default NULL",
-      "last_name"     => "`last_name` varchar(24) default NULL",
-
-      "created"       => "`created` timestamp default CURRENT_TIMESTAMP",
-      "login"         => "`login` datetime default NULL",
-      "code"          => "`code` char(32) default NULL",
-
-      "type"          => "`type` tinyint(1) unsigned NOT NULL default '0'",
-      "status"        => "`status` tinyint(1) unsigned NOT NULL default '0'",
-
-      "INDEX 1"    => "UNIQUE `user_key` (`username`)",
-  ),
-// ------...------...------...------...------...------...------...------...------...------...------
-// ------...------...------...------...------...------...------...------...------...------...------
-

-);  // eof - $tables

-

-// ------...------...------...------...------...------...------...------...------...------...------
-// ------...------...------...------...------...------...------...------...------...------...------
-// ------...------...------...------...------...------...------...------...------...------...------
-
-initConnect();
-foreach ($databases as $db) {
-  echo "\nbuilding $db database\n";
-  initDB($db);
-  foreach ($tables as $table => $def)
-    buildTable($table,$def);
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function buildTable($table,$def) {
-  echo "    table $table\n";
-  
-  $fldList = array();
-  $fldLast = "";
-  $autoKey = "";
-  $fldNew  = current($def);
-
-  // Force create table - will fail if exists but thats ok.
-  if (strstr($fldNew,"auto_increment"))
-    $autoKey = ",PRIMARY KEY  (`" . getColName($fldNew) . "`)";
-  mysql_query("CREATE TABLE `$table` ( $fldNew $autoKey ) TYPE=MyISAM CHARSET=latin1;");

-  

-

-  // Grab a list of existing fields.
-  if ($qry = mysql_query("SHOW COLUMNS FROM $table")) {
-    while ($row = mysql_fetch_assoc($qry)) {
-      $fldList[$row['Field']] = 1;
-    }
-  }
-

-  foreach ($def as $fldOld => $fldDef) {

-    if (substr($fldOld,0,5) == "INDEX") {

-      $cmd = "ALTER TABLE `$table` ADD $fldDef";

-      @mysql_query($cmd);

-      //echo mysql_error() . "\n";

-    }

-    else {

-      $fldNew  = getColName($fldDef);

-

-      if (($exists = isset($fldList[$fldOld])) == false)

-        if (($exists = isset($fldList[$fldNew])) == true)

-          $fldOld = $fldNew;

-

-      $cmdHow  = ($exists?"CHANGE COLUMN `$fldOld`":"ADD COLUMN");

-      $cmdPos  = ($fldLast?"AFTER $fldLast":"FIRST");

-      $cmd     = "ALTER TABLE `$table` $cmdHow $fldDef $cmdPos";

-      $fldLast = $fldNew;

-      mysql_query($cmd);

-

-      echo "        " . ($exists?"changing":"adding") . " $fldNew\t$cmd\n";

-    }

-  }

-  //echo mysql_error() . "\n";

-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function getColName($str) {
-  $delimit = substr($str,0,1);
-  if (($delimit == "'") || ($delimit == "`"))
-    $str  = substr($str,1);

-  else

-    $delimit = " ";

-  return substr($str,0,strpos($str,$delimit));
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function initConnect() {
-  sqlOpen(NULL);	
-//  if (!@mysql_connect("localhost","webphp","sabref86")) {
-//   echo "\n\tUnable to connect to mySQL server!\n";
-//    exit;
-//  }
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function initDB($db) {
-  mysql_query("CREATE DATABASE IF NOT EXISTS $db");
-  if (!mysql_select_db($db)) {
-    echo "\n\tUnable to select database: $db!\n";
-    exit;
-  }
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/cXSQL.class.php b/aptana_global/sql/cXSQL.class.php
deleted file mode 100755
index e89d9aa..0000000
--- a/aptana_global/sql/cXSQL.class.php
+++ /dev/null
@@ -1,738 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-
-class cXSQL {
-  public $sql_Tab = "";
-  public $sql_Qry = 0;
-  public $sql_Cnt = 0;
-  public $sql_Nbr = 0;
-  public $sql_Dif = 0;
-  public $sql_Dlt = 0;
-  public $pag_Srt = "";
-  public $pag_Whr = "";
-  public $pag_Asc = 1;
-  public $pag_Cnt = 0;
-  public $pag_Rec = 0;
-  public $pag_Nbr = 0;
-  public $pag_Amt = 0;
-  public $pag_Def = 0;
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-final function cXSQL($arg) {
-  $this->sql_Tab = substr(get_class($this),0,strlen(get_class($this))-3);
-
-  if (!$arg)
-    return;
-
-  if (func_num_args() == 1)
-    $this->sqlLoad($arg);
-  else if (func_num_args() == 2) {
-    $arg1 = func_get_arg(0);
-    $arg2 = func_get_arg(1);
-    $this->sqlLoad($arg1,$arg2);
-  }
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function sqlCmd($cmd) {
-  $cmd = str_replace("{SELF}",$this->sql_Tab,$cmd);
-  $cmd = str_replace("{SELFID}",$this->_id,$cmd);
-  $qry = @mysql_query($cmd);
-  if (!$qry)
-    dump(LOG2ERROR,mysql_error() . "\n\t$cmd\n");
-  return $qry;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function sqlQry($cmd) {
-  $this->sql_Qry = $this->sqlCmd($cmd);
-  $this->sql_Cnt = @mysql_num_rows($this->sql_Qry);
-  return $this->sql_Qry;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function sqlRec($cmd) {
-  if ($qry = $this->sqlCmd($cmd))
-    if ($rec = mysql_fetch_object($qry)) {
-      return $rec;
-	  }
-  return 0;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function sqlLoad($arg) {
-
-  if (is_array($arg)) {
-    $rec = $arg;
-  }
-  else {
-    if (is_numeric($arg))
-      $arg = "SELECT * FROM {SELF} WHERE id='$arg'";
-    else if (func_num_args() == 1)
-      $arg = "SELECT * FROM {SELF} WHERE $arg";
-    else if (func_num_args() == 2) {
-      $arg1 = func_get_arg(0);
-      $arg2 = func_get_arg(1);
-      $arg = "SELECT * FROM {SELF} WHERE $arg1='$arg2'";
-    }
-    if (!($qry = $this->sqlQry($arg)))
-      return false;
-
-    if (!($rec = mysql_fetch_assoc($qry)))
-      return false;
-  }
-
-  if ($vars = get_object_vars($this)) {
-    foreach ($rec as $key => $val) {
-      $val = htmlspecialchars($val);
-      $key = "_" . $key;
-      eval("\$this->$key = \$val;");
-    }
-  }    
-  return true;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function sqlList($cmd) {
-  $this->sql_Nbr = 0;
-  $this->sqlQry($cmd);
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function sqlNext() {
-  if ($this->sql_Qry && ($rec = mysql_fetch_assoc($this->sql_Qry))) {
-    $this->sql_Nbr++;
-    return $this->sqlLoad($rec);
-  }
-  return false;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function sqlGetCnt($cmd) {
-  if ($qry = $this->sqlCmd($cmd))
-    if ($rec = mysql_fetch_array($qry)) {
-      return $rec[0];
-    }
-  return 0;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function sqlUpdate($sets) {
-  if (!$this->_id) {
-    $this->sqlCmd("INSERT INTO {SELF} SET $sets");
-    $this->_id = mysql_insert_id();
-    $this->sqlLoad($this->_id);
-  }
-  else if (isset($sets) && strlen($sets)) {
-    $this->sqlCmd("UPDATE {SELF} SET $sets WHERE id={SELFID}");
-    $this->sqlLoad($this->_id);
-  }
-  return $this->_id;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function sqlTouch($fld) {
-  if ($this->_id) {
-    $this->sqlCmd("UPDATE {SELF} SET $fld=NOW() WHERE id='$this->_id'");
-    $this->sqlLoad($this->_id);
-  }
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function sqlGetPassword($str) {
-  if ($rec = $this->sqlRec("SELECT PASSWORD('$str') AS password"))
-    return $rec->password;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function sqlReplace() {
-  $sets = "";
-  foreach (get_object_vars($this) as $key => $val)  {
-    if (($key{0} != "_") || ($key == '_created'))
-      continue;
-    if (($key = substr($key,1)) == "id") 
-      continue;
-    $sets = $this->addSET($sets,$key,$val);
-  }
-  if ($this->sqlCmd("REPLACE INTO {SELF} SET $sets")) {
-    debugLog("REPLACE INTO {SELF} SET $sets");
-    $this->_id = mysql_insert_id();
-    $this->sqlLoad($this->_id);
-    return true;
-  }
-  return false;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function formDifArray($_POST) {
-  $ary = array();
-
-  foreach (get_object_vars($this) as $key => $val)  {
-    $postKey = $this->sql_Tab . $key;
-
-    if ($key{0} != "_")
-      continue;
-    if ($key == "_id") 
-      continue;
-
-    if (isset($_POST[$postKey])) {
-      //debugLog("+++++++++  $postKey");
-      $postVal = trim($_POST[$postKey]);
-    }
-    else if (isset($_POST["un_$postKey"])) {
-      //debugLog("=========  $postKey");
-      $postVal = trim($_POST["un_$postKey"]);
-    }
-    else  {
-      //debugLog("---------  $postKey");
-      continue;
-    }
-
-    if ($postVal != $val)
-      $ary[substr($key,1)] = $postVal;
-  }
-  return $ary;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function addSET($sets,$key,$val) {
-  if (!isset($sets))
-    $sets = "";
-  $val = esc_str($val);
-  if ($val == "NOW()")
-    $sets .= ($sets?",":"") . "$key=$val";
-  else
-    $sets .= ($sets?",":"") . "$key='$val'";
-  return $sets;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function selfPost() {
-  $sets = "";
-  foreach (get_object_vars($this) as $key => $val)  {
-    if ($key{0} != "_")
-      continue;
-    if (($key = substr($key,1)) == "id") 
-      continue;
-    $sets = $this->addSET($sets,$key,$val);
-  }
-  return $this->sqlUpdate($sets);
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-// ------...------...------...------...------...------...------...------...------...------...------
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function formBuildData($post) {
-  $ary = array();
-
-  foreach (get_object_vars($this) as $key => $val)  {
-    // only add db fields - which start with and '_'
-    if ($key{0} != "_") 
-      continue;
-    $fld = "$this->sql_Tab$key";
-
-    if (!empty($post[$fld]))
-      $val = $post[$fld];
-
-    $ary["{$fld}_name"] = $fld;
-    $ary[$fld] = str_replace("\"","&quot;",($val?$val:""));
-
-    if (is_numeric($val)) {
-      $nbr = ($val?$val:"0");
-      $ary[$fld]               = $nbr;
-      $ary["{$fld}_check"]     = ($val?"checked":"");
-      $ary["{$fld}_radio$nbr"] = "checked";
-      $ary["{$fld}_combo$nbr"] = "selected";
-      $ary["{$fld}_uncheck"]   = "<input type='hidden' name='un_$fld' value='0'>";
-    }
-  }
-  return $ary;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function formHandleCmd($cmd,$lastPage,$idName) {
-  $retVal = true;
-
-  if ($cmd == 'cancel')
-    exitTo($lastPage);
-
-  if ($cmd == 'apply')
-    return $this->formSavePost();
-
-  if (($cmd == 'save') && ($retVal = $this->formSavePost()))
-    exitTo($lastPage);
-  
-  if (($cmd == 'new') && ($retVal = $this->formSavePost())) {
-    SetSessionVar($idName,0);
-    exitTo($lastPage);
-  }
-
-  if (($cmd == 'next') && ($retVal = $this->formSavePost())) {
-    SetSessionVar($idName,getCookie('id'));
-    exitTo($GLOBALS['g_PHPSELF']);
-  }
-
-  if (($cmd == 'prev') && ($retVal = $this->formSavePost())) {
-    SetSessionVar($idName,getCookie('id'));
-    exitTo($GLOBALS['g_PHPSELF']);
-  }
-
-  if ($cmd == 'delete') {
-  }
-
-  return $retVal;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function formSavePost() {
-  if ($this->formValidate()) {
-    $sets = "";
-    $this->sql_Dif = $this->formDifArray($_POST);
-    foreach ($this->sql_Dif as $key => $val)
-      $sets = $this->addSET($sets,$key,$val);
-    return $this->sqlUpdate($sets);
-  }
-  return false;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-
-function formGatherData($_POST) {
-  $this->sql_Dif = $this->formDifArray($_POST);
-  foreach ($this->sql_Dif as $key => $val)
-    eval("\$this->_$key = \$val;");
-  return $this->_id;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function formValidate() {
-  return true;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function paginateHTML($pageAmt) {
-  $link = "";
-
-  // It all fits on one page so no pagination needed;
-  if ($this->pag_Rec<=$pageAmt)
-    return $link;
-
-  // If view all (or 1000 max) offer to return to page mode
-  if (($pageAmt < $this->pag_Amt) && ($this->pag_Rec<1000)) {
-    $link .= "<table class=page cellspacing=0 cellpadding=0><tr>\n";
-    $link .= "<td class='pagemenu mgryro' onmouseover='menuro(this);' onmouseout='menuro(this);' ";
-    $link .= "onclick=\"return rwc('c_pageAmt','$pageAmt');\">View&nbsp;Pages";
-    $link .= "</td></tr></table>\n";
-    return $link;
-  }
-
-  $link = "<div class=pages>\n";
-  $tmpl = "<a class='pagemenu mgryro%s' onclick=\"return rwc('c_pageNbr','%d');\">%s</a>\n";
-  $blnk = "<a class='pagemenu mgryro%s'>%s</a>\n";
-
-  $cnt = $this->pag_Cnt;
-  $beg = max($this->pag_Nbr-5,0);
-  $end = min($this->pag_Nbr+5,$cnt-3);
-  
-  
-  if ($end-$beg < 10)
-    $beg = max(0,($beg-(10-($end-$beg)))); 
-  if ($end-$beg < 10)
-    $end = min($cnt,($beg+13)); 
-
-
-  $link .= sprintf($tmpl,"",0,"Prev");
-  for ($i=0;($i<3)&&($i<$cnt);$i++)
-    if ($i == $this->pag_Nbr)
-      $link .= sprintf($blnk,"sel",($i+1));
-    else
-      $link .= sprintf($tmpl,"",$i,($i+1) ); 
-    
-  if ($beg>3)      
-    $link .= "<span>...</span>\n";
-
-  for ($i=max($i,$beg);$i<min($end,$cnt);$i++)
-    if ($i == $this->pag_Nbr)
-      $link .= sprintf($blnk,"sel",($i+1));
-    else
-      $link .= sprintf($tmpl,"",$i,($i+1) ); 
-    
-  if ($end<$cnt-3)      
-    $link .= "<span>...</span>\n";
-
-  for ($i=$cnt-3;$i<$cnt;$i++)
-    if ($i == $this->pag_Nbr)
-      $link .= sprintf($blnk,"sel",($i+1));
-    else
-      $link .= sprintf($tmpl,"",$i,($i+1) ); 
-  $link .= sprintf($tmpl,"",($cnt-1),"Next");  
-  $link .= "</div>\n";
-    
-/*    
-//  $link = "<table class=page cellspacing=0 cellpadding=0><tr>\n";
-//  $tmpl = "<td class='mntd menu mgryro%s' onmouseover='menuro(this);' onmouseout='menuro(this);' onclick=\"return rwc('c_pageNbr','%d');\">%s</td>\n";
-//  $blnk = "<td  class='mntd menu mgryro%s'>%s</td>\n";
-
-  if ($this->pag_Nbr>8)      
-    $link .= "<td class='mntd menu'>...</td>\n";
-
-  for ($i=max(0,($this->pag_Nbr-5));($i<$this->pag_Nbr+5)&&($i<$this->pag_Cnt);$i++)
-    if ($i == $this->pag_Nbr)
-      $link .= sprintf($blnk,"sel",($i+1));
-    else
-      $link .= sprintf($tmpl,"",$i,($i+1));
-
-  if (($this->pag_Nbr) < ($this->pag_Cnt-8))      
-    $link .= "<td class='mntd menu'>...</td>\n";
-  for ($i=max(($this->pag_Nbr+5),($this->pag_Cnt-3));$i<$this->pag_Cnt;$i++)
-    $link .= sprintf($tmpl,"",$i,($i+1));
-*/
-//  for ($i=0;$i<$this->pag_Cnt;$i++) {
-//    $link .= sprintf($tmpl,"",$i,($i+1));
-//  }
-  
-/*
-  $x = max(0,($this->pag_Nbr-2));
-  $x = min($x,max(0,($this->pag_Cnt-5)));
-  $link .= sprintf($tmpl,"",0,"<");
-  for ($i=$x;($i<($x+5))&&($i<$this->pag_Cnt);$i++) {
-    if ($i == $this->pag_Nbr)
-      $link .= sprintf($blnk,"sel",($i+1));
-    else
-      $link .= sprintf($tmpl,"",$i,($i+1));
-  }
-  $link .= sprintf($tmpl,"",($this->pag_Cnt-1),">");
-*/
-
-  
-//  $link .= "<td class='mntd menu mgryro' onmouseover='menuro(this);' onmouseout='menuro(this);' ";
-//  $link .= "onclick=\"return rwc('c_pageAmt','0');\">View&nbsp;All</td>\n";
-//  $link .= "</tr></table>\n";
-  return $link;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function paginateLoad($defSort,$where) {
-  // Grab View All/ View Paginated cookie
-  if (isset($_COOKIE['c_pageAmt'])) {
-    $this->pag_Amt = getCookie('c_pageAmt');
-    unset($_COOKIE['c_pageNbr']);
-    $this->pag_Nbr = 0;
-  }
-  if ($this->pag_Amt == 0)
-    $this->pag_Amt = 1000;  
-
-  // Grab Sort by cookie
-  if (isset($_COOKIE['c_sortOn'])) {
-    $srt = getCookie('c_sortOn');
-    if ($this->pag_Srt == $srt) {
-      $this->pag_Asc = !$this->pag_Asc;
-    }
-    else 
-       $this->pag_Asc = true;
-    $this->pag_Srt = $srt;
-    $this->pag_Nbr = 0;
-  }
-  else if (empty($this->pag_Srt))
-    $this->pag_Srt = $defSort;
-
-  if (empty($this->pag_Whr))
-    $this->pag_Whr = $where;   
-  else if ($this->pag_Whr != $where)
-    $this->pag_Whr = $where;   
-  
-  // Grab Page number cookie
-  if (isset($_COOKIE['c_pageNbr']))
-    $this->pag_Nbr = getCookie('c_pageNbr');
-
-  // Refresh Page count
-  $cmd = "SELECT COUNT(id) FROM {SELF}" . (($this->pag_Whr)?" WHERE $this->pag_Whr":"");
-  $this->pag_Rec = $this->sqlGetCnt($cmd);
-  $this->pag_Cnt = ceil($this->pag_Rec/max(1,$this->pag_Amt));
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function paginate($pageAmt,$defSort,$where) {
-  // Should handle all prev|next page sort of table list views
-  //   $pageAmt - number of rows per pages
-  //   $defSort - default sort field
-  //   $where   - where clause
-
-  $this->pag_Amt = $pageAmt;  
-  if ($page = GetSessionVar("s_pageX$this->sql_Tab"))
-    list($this->pag_Srt,$this->pag_Asc,$this->pag_Nbr,$this->pag_Amt,$this->pag_Whr) = split(":",$page);
-  $this->paginateLoad($defSort,$where);
-  SetSessionVar("s_pageX$this->sql_Tab","$this->pag_Srt:" . (empty($this->pag_Asc)?"0":"1") . ":$this->pag_Nbr:$this->pag_Amt:$this->pag_Whr");
-
-  $retVal = array();
- 
-  if ($this->pag_Srt) {
-    // So we don't get 'not defined' errors
-    foreach (get_object_vars($this) as $key => $val)  {
-      if ($key{0} == "_")
-        $retVal["sort$key"] = "";
-    }
-    // Set the class name (sortUp/sortDn) for the current $sort_field    
-    if (($pos = strpos(($key = $this->pag_Srt),",")) > 0)
-      $key = substr($key,0,$pos);
-    $retVal["sort_$key"] = "sort" . ($this->pag_Asc?"Up":"Dn");
-  }
-  $retVal["sort_link"] = $this->paginateHTML($pageAmt);
-  return $retVal;
-}
-
-
-// ------...------...------...------...------...------...------...------...------...------...------
-/*
-function prevNext($id,$pageAmt,$defSort,$where) {
-  // Should handle all prev|next page sort of table list views
-  //   $pageAmt - number of rows per pages
-  //   $defSort - default sort field
-  //   $where   - field for where clause
-
-  if ($page = GetSessionVar("s_pageX$this->sql_Tab"))
-    list($this->pag_Srt,$this->pag_Asc,$this->pag_Nbr,$this->pag_Amt) = split(":",$page);
-  $this->paginateLoad($defSort,$where);
-  SetSessionVar("s_pageX$this->sql_Tab","$this->pag_Srt:" . (empty($this->pag_Asc)?"0":"1") . ":$this->pag_Nbr:$this->pag_Amt");
-
-  $retVal = array();
- 
-  if ($this->pag_Srt) {
-    // So we don't get 'not defined' errors
-    foreach (get_object_vars($this) as $key => $val)  {
-      if ($key{0} == "_")
-        $retVal["sort$key"] = "";
-    }
-    // Set the class name (sortUp/sortDn) for the current $sort_field    
-    if (($pos = strpos(($key = $this->pag_Srt),",")) > 0)
-      $key = substr($key,0,$pos);
-    $retVal["sort_$key"] = "sort" . ($this->pag_Asc?"Up":"Dn");
-  }
-  $retVal["sort_link"] = $this->paginateHTML($pageAmt);
-  return $retVal;
-}
-*/
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function format_date($fmt,$dat) {
-  if (is_numeric($fmt)) {
-  }
-  else {
-    if (empty($dat))
-      return "";
-    if (($dat == "0000-00-00") || ($dat == "0000-00-00 00:00:00"))
-      return "";
-    return date($fmt,strtotime($dat));
-  }
-}
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-/*
-
-// ------...------...------...------...------...------...------...------...------...------...------
-// ------...------...------...------...------...------...------...------...------...------...------
-///DETETE DE:LETETE
-function formPost($_POST) {
-  $sets = "";
-  $this->sql_Dif = $this->formDifArray($_POST);
-  foreach ($this->sql_Dif as $key => $val) {
-    $sets = $this->addSET($sets,$key,$val);
-  }
-  return $this->sqlUpdate($sets);
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function GetDATA($_POST) {
-  $this->sql_Dif = $this->formDifArray($_POST);
-  foreach ($this->sql_Dif as $key => $val) 
-    eval("\$this->_$key = \$val;"); 
-  return $this->_id;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function SetDATA() {
-  if (count($this->sql_Dif)) {
-    $sets = "";
-    foreach ($this->sql_Dif as $key => $val)
-      $sets = $this->addSET($sets,$key,$val);
-    $this->_id = $this->sqlUpdate($sets);
-  }
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function PostSAVE($cmd,$lastPage,$idName) {
-  // remove after replaced with formHandleCmd
-  switch ($cmd) {
-    case 'apply':
-      return $this->SaveDATA();
-      break;
-
-    case 'save':
-      if ($this->SaveDATA())
-        exitTo($lastPage);
-      break;
-
-    case 'cancel':
-      exitTo($lastPage);
-      break;
-
-    case 'new':
-      if ($this->SaveDATA()) {
-        SetSessionVar($idName,0);
-        exitTo($GLOBALS['g_PHPSELF']);
-      }
-      break;
-
-    case 'delete':
-      break;
-
-    case 'prev':
-      if ($this->SaveDATA()) {
-        SetSessionVar($idName,getCookie('id'));
-        exitTo($GLOBALS['g_PHPSELF']);
-      }
-      break;
-
-    case 'next':
-      if ($this->SaveDATA()) {
-        SetSessionVar($idName,getCookie('id'));
-        exitTo($GLOBALS['g_PHPSELF']);
-      }
-      break;
-    default:
-      return true;
-  }
-  return false;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function PostDATA2() {
-  //remove after replaced by builodformdata
-  $ary = array();
-
-  if (func_num_args() == 1) 
-    $post = func_get_arg(0);
-
-  foreach (get_object_vars($this) as $key => $val)  {
-    if ($key{0} != "_")
-      continue;
-
-    $base                 = "form_$this->sql_Tab$key";
-    $ary[$base . "_name"] = $this->sql_Tab . $key;
-
-    if (!empty($post["$this->sql_Tab$key"]))
-      $val = $post["$this->sql_Tab$key"];
-
-    if (is_numeric($val)) {
-      $nbr = ($val?$val:"0");
-      $ary[$base]                = $nbr;
-      $ary[$base . "_check"]     = ($val?"checked":"");
-      $ary[$base . "_radio$nbr"] = "checked";
-      $ary[$base . "_combo$nbr"] = "selected";
-      $ary[$base . "_uncheck"]   = "<input type='hidden' name='un_" . $this->sql_Tab . $key . "' value='0'>";
-    }
-    else {
-      $ary[$base] = str_replace("\"","&quot;",($val?$val:""));
-    }
-  }
-  return $ary;
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-
-function clear() {
-  foreach (get_object_vars($this) as $key => $val)  {
-    if ($key{0} != "_")
-      continue;
-    eval("\$this->$key = '';");
-  }
-}
-*/
-// ------...------...------...------...------...------...------...------...------...------...------
-// ------...------...------...------...------...------...------...------...------...------...------
-
-// ------...------...------...------...------...------...------...------...------...------...------
-}
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/entries_ia.class.php b/aptana_global/sql/entries_ia.class.php
deleted file mode 100644
index 80d52c5..0000000
--- a/aptana_global/sql/entries_ia.class.php
+++ /dev/null
@@ -1,23 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-class entries_ia extends entries_iu {
-// ------...------...------...------...------...------...------...------...------...------...------
-
-
-
-
-// ------...------...------...------...------...------...------...------...------...------...------
-}
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/entries_iu.class.php b/aptana_global/sql/entries_iu.class.php
deleted file mode 100644
index 2f5fc8f..0000000
--- a/aptana_global/sql/entries_iu.class.php
+++ /dev/null
@@ -1,23 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-class entries_iu extends entries_ix {
-// ------...------...------...------...------...------...------...------...------...------...------
-
-
-
-
-// ------...------...------...------...------...------...------...------...------...------...------
-}
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/entries_ix.class.php b/aptana_global/sql/entries_ix.class.php
deleted file mode 100644
index 8e74245..0000000
--- a/aptana_global/sql/entries_ix.class.php
+++ /dev/null
@@ -1,31 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-
-class entries_ix extends cXSQL  {
-  public $_id          = '';
-  public $_name        = '';
-  public $_value       = '';
-  public $_rating      = '0';
-  public $_repo_path   = '';
-  public $_language_id = '0';
-  public $_project_id  = '0';
-  public $_user_id     = '0';
-  public $_updated_on  = '';
-  public $_updated_at  = '';
-  public $_created_on  = '';
-  public $_created_at  = '';
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/languages_ia.class.php b/aptana_global/sql/languages_ia.class.php
deleted file mode 100644
index b61cca9..0000000
--- a/aptana_global/sql/languages_ia.class.php
+++ /dev/null
@@ -1,23 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-class languages_ia extends languages_iu {
-// ------...------...------...------...------...------...------...------...------...------...------
-
-
-
-
-// ------...------...------...------...------...------...------...------...------...------...------
-}
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/languages_iu.class.php b/aptana_global/sql/languages_iu.class.php
deleted file mode 100644
index 576c6de..0000000
--- a/aptana_global/sql/languages_iu.class.php
+++ /dev/null
@@ -1,23 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-class languages_iu extends languages_ix {
-// ------...------...------...------...------...------...------...------...------...------...------
-
-
-
-
-// ------...------...------...------...------...------...------...------...------...------...------
-}
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/languages_ix.class.php b/aptana_global/sql/languages_ix.class.php
deleted file mode 100644
index e189b16..0000000
--- a/aptana_global/sql/languages_ix.class.php
+++ /dev/null
@@ -1,26 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-
-class languages_ix extends cXSQL  {
-  public $_id         = '';
-  public $_name       = '';
-  public $_iso_code   = '';
-  public $_updated_on = '';
-  public $_updated_at = '';
-  public $_created_on = '';
-  public $_created_at = '';
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/projects_ia.class.php b/aptana_global/sql/projects_ia.class.php
deleted file mode 100644
index b1f7f69..0000000
--- a/aptana_global/sql/projects_ia.class.php
+++ /dev/null
@@ -1,23 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-class projects_ia extends projects_iu {
-// ------...------...------...------...------...------...------...------...------...------...------
-
-
-
-
-// ------...------...------...------...------...------...------...------...------...------...------
-}
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/projects_iu.class.php b/aptana_global/sql/projects_iu.class.php
deleted file mode 100644
index 033c8c0..0000000
--- a/aptana_global/sql/projects_iu.class.php
+++ /dev/null
@@ -1,23 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-class projects_iu extends projects_ix {
-// ------...------...------...------...------...------...------...------...------...------...------
-
-
-
-
-// ------...------...------...------...------...------...------...------...------...------...------
-}
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/projects_ix.class.php b/aptana_global/sql/projects_ix.class.php
deleted file mode 100644
index 4e2e299..0000000
--- a/aptana_global/sql/projects_ix.class.php
+++ /dev/null
@@ -1,26 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-
-class projects_ix extends cXSQL  {
-  public $_id           = '';
-  public $_name         = '';
-  public $_package_name = '';
-  public $_updated_on   = '';
-  public $_updated_at   = '';
-  public $_created_on   = '';
-  public $_created_at   = '';
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/schema_info_ia.class.php b/aptana_global/sql/schema_info_ia.class.php
deleted file mode 100644
index 3e804eb..0000000
--- a/aptana_global/sql/schema_info_ia.class.php
+++ /dev/null
@@ -1,23 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-class schema_info_ia extends schema_info_iu {
-// ------...------...------...------...------...------...------...------...------...------...------
-
-
-
-
-// ------...------...------...------...------...------...------...------...------...------...------
-}
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/schema_info_iu.class.php b/aptana_global/sql/schema_info_iu.class.php
deleted file mode 100644
index aea984f..0000000
--- a/aptana_global/sql/schema_info_iu.class.php
+++ /dev/null
@@ -1,23 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-class schema_info_iu extends schema_info_ix {
-// ------...------...------...------...------...------...------...------...------...------...------
-
-
-
-
-// ------...------...------...------...------...------...------...------...------...------...------
-}
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/schema_info_ix.class.php b/aptana_global/sql/schema_info_ix.class.php
deleted file mode 100644
index c9ce5e9..0000000
--- a/aptana_global/sql/schema_info_ix.class.php
+++ /dev/null
@@ -1,20 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-
-class schema_info_ix extends cXSQL  {
-  public $_version = '';
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/sessions_ia.class.php b/aptana_global/sql/sessions_ia.class.php
deleted file mode 100644
index 1c17458..0000000
--- a/aptana_global/sql/sessions_ia.class.php
+++ /dev/null
@@ -1,23 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-class sessions_ia extends sessions_iu {
-// ------...------...------...------...------...------...------...------...------...------...------
-
-
-
-
-// ------...------...------...------...------...------...------...------...------...------...------
-}
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/sessions_iu.class.php b/aptana_global/sql/sessions_iu.class.php
deleted file mode 100644
index 0a110f8..0000000
--- a/aptana_global/sql/sessions_iu.class.php
+++ /dev/null
@@ -1,88 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
- *    Eclipse Foundation
-*******************************************************************************/
-
-class sessions_iu extends sessions_ix {
-	
-	function validate() {
-	  $cookie = (isset($_COOKIE[COOKIE_REMEMBER])?$_COOKIE[COOKIE_REMEMBER]:"");
-      $rValue = 1;
-	  
-      if (strpos($cookie,":")) {
-        // Check for remember cookie and get user info if set
-        list($nbr,$gid) = $this->decode_remember($cookie);
-        if ( (!$this->sqlLoad("gid", $gid)) 
-        	|| $gid != $this->_gid
-        	|| $this->getSubnet() != $this->_subnet) {
-        	# Failed - no such session, or session no match.  Need to relogin
-        	setcookie(COOKIE_REMEMBER, "", -36000, "/");
-        	$rValue = 0;
-        }
-        else {
-        	# Update the session updated_at
-        	$this->sqlTouch("updated_at");
-        	$this->maintenance();
-        }
-        SetSessionVar('s_userAcct', $this->_userid);
-        return $rValue;
-      }
-	}
-
-	function destroy() {
-	  $cookie = (isset($_COOKIE[COOKIE_REMEMBER])?$_COOKIE[COOKIE_REMEMBER]:"");
-      $rValue = 1;
-	  
-      if (strpos($cookie,":")) {
-        // Check for remember cookie and get user info if set
-        list($nbr,$gid) = $this->decode_remember($cookie);
-        if($nbr) {
-        	# TODO: untaint
-        	$sql = "DELETE FROM sessions WHERE userid = " . $nbr;
-        	sqlQuery($sql);
-        	unset($_SESSION['s_userAcct']);
-  			unset($_SESSION['s_userName']);
-  			unset($_SESSION['s_userType']);
-        }
-      }
-	}
-	
-	function create($_userid) {
-		$this->_userid 	= $_userid;
-		$this->_gid 	= guidNbr();
-		$this->_subnet 	= $this->getSubnet();
-		$this->_updated_at = "NOW()";
-		
-		$this->selfPost();
-	}
-	
-	function maintenance() {
-		# Delete sessions older than 14 days
-		$this->sqlCmd("DELETE FROM {SELF} WHERE updated_at < DATE_SUB(NOW(), INTERVAL 14 DAY)");
-	}
-		
-	function getSubnet() {
-		# return class-c subnet
-		return substr($_SERVER['REMOTE_ADDR'], 0, strrpos($_SERVER['REMOTE_ADDR'], ".")) . ".0";
-	}
-	
-    function encode_remember() {
-      $code = ($this->_userid+111) . ":" . $this->_gid;
-      return $code;
-    }
-    
-    function decode_remember($remember) {
-      list($nbr,$gid) = split(":",$remember);
-      $nbr  = $nbr-111;
-      return array($nbr,$gid);
-    }
-}
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/sessions_ix.class.php b/aptana_global/sql/sessions_ix.class.php
deleted file mode 100644
index e80e1ee..0000000
--- a/aptana_global/sql/sessions_ix.class.php
+++ /dev/null
@@ -1,23 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
- *    Eclipse Foundation
-*******************************************************************************/
-
-
-class sessions_ix extends cXSQL  {
-  public $_id         = '';
-  public $_userid     = '';
-  public $_gid		  = '';
-  public $_subnet     = '';
-  public $_updated_at = '';
-}
-
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/users_ia.class.php b/aptana_global/sql/users_ia.class.php
deleted file mode 100644
index 1a88c87..0000000
--- a/aptana_global/sql/users_ia.class.php
+++ /dev/null
@@ -1,18 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-class users_ia extends users_iu {
-	
-}
-
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/users_iu.class.php b/aptana_global/sql/users_iu.class.php
deleted file mode 100755
index 59ff1ab..0000000
--- a/aptana_global/sql/users_iu.class.php
+++ /dev/null
@@ -1,97 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
- *    Eclipse Foundation 
-*******************************************************************************/
-
-class users_iu extends users_ix {
-  public $errStrs;
-
-
-function PostDATA($post=NULL) {
-  $dat = cXSQL::formBuildData($post);
-  for ($i=0;$i<max(6,count($this->errStrs));$i++)
-    $dat["errStr$i"] = (isset($this->errStrs[$i])?$this->errStrs[$i]:"&nbsp");
-  return $dat;
-}
-
-
-function formRegValidate($_POST,$pass1,$pass2) {
-  $this->formGatherData($_POST);
-  // username
-  if (!strlen($this->_username))
-    $this->errStrs[0] = "required";
-  else if (strlen($this->_username) < 6)
-    $this->errStrs[0] = "must be at least 6 chars long";
-  else if (strlen($this->_username) > 16)
-    $this->errStrs[0] = "must be less than 16 chars long";
-  else if (eregi('[^a-z0-9]',$this->_username,$regs))
-    $this->errStrs[0] = "invalid character(s) - [" . (($regs[0]==' ')?"space":$regs[0]) . "]";
-  else if ($rec = $this->sqlRec("SELECT * FROM {SELF} WHERE username='$this->_username'"))
-    $this->errStrs[0] = "&lsquo;$this->_username&rsquo; is unavailable";
-
-  // email
-  $regexp = "^([_a-z0-9-]+)(\.[_a-z0-9-]+)*@([a-z0-9-]+)(\.[a-z0-9-]+)*(\.[a-z]{2,4})$";
-  if (!strlen($this->_email))
-    $this->errStrs[1] = "required";
-  else if (!eregi($regexp,$this->_email))
-    $this->errStrs[1] = "invalid email address";
-
-  // password
-  if (!strlen($pass1))
-    $this->errStrs[2] = "required";
-  else if (strlen($pass1) < 6)
-    $this->errStrs[2] = "must be at least 6 chars long";
-  else if ($pass2 != $pass2)
-    $this->errStrs[2] = "passwords do not match";
-
-  if (!strlen($this->_first_name))
-    $this->errStrs[3] = "required";
-  if (!strlen($this->_last_name))
-    $this->errStrs[4] = "required";
-
-  if ($this->_primary_language_id <= 0)
-    $this->errStrs[5] = "required";
-
-
-  if (count($this->errStrs))
-    return false;
-  return true;
-}
-
-
-function findUser($str,$password) {
-  $name = $this->addSET("","username",$str);
-  $mail = $this->addSET("","email",$str);
-  //$pass = (!empty($password)?"AND (PASSWORD('$password')=password OR password='$password')":"");
-  // using a different DB that hashes the password differently
-  $this->sqlLoad("($name OR $mail)");
-  if ($this->sql_Cnt != 1) {
-    $this->_id = 0;
-  }
-  
-  # we don't use the username, so replace it with the email address
-  # same algorithm here as the wiki
-  $this->_username = str_replace("@", ".", $this->_email);
-
-  # Typical Bugzilla algorithm
-  if ($this->_password_hash != $password) {
-    if (!(crypt($password, $this->_password_hash) == $this->_password_hash)) {
-      $this->_id = 0;
-    }
-  }
-  
-  debugLog("Found user: " . $this->_username . ":" . "********");
-  return $this->_id;
-}
- 
-
-}
-?>
\ No newline at end of file
diff --git a/aptana_global/sql/users_ix.class.php b/aptana_global/sql/users_ix.class.php
deleted file mode 100644
index 7ef314d..0000000
--- a/aptana_global/sql/users_ix.class.php
+++ /dev/null
@@ -1,31 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-// ------...------...------...------...------...------...------...------...------...------...------
-
-class users_ix extends cXSQL  {
-  public $_id                  = '';
-  public $_username            = '';
-  public $_first_name          = '';
-  public $_last_name           = '';
-  public $_email               = '';
-  public $_primary_language_id = '0';
-  public $_hours_per_week      = '0';
-  public $_password_hash       = '';
-  public $_updated_on          = '';
-  public $_updated_at          = '';
-  public $_created_on          = '';
-  public $_created_at          = '';
-}
-
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/test.php b/aptana_global/test.php
deleted file mode 100755
index b8cc9a9..0000000
--- a/aptana_global/test.php
+++ /dev/null
@@ -1,47 +0,0 @@
-#!/usr/local/bin/php
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
-
-*******************************************************************************/
-$hashes = hash_algos();
-
-foreach ($hashes as $hash) {
-  print "$hash\n";
-  $val = hash("$hash","mustang"); // . "FvPEUG0X");
-  //if (strlen($val) == 64)
-    echo "$val\n\n";
-}  
-  
-  
-  /*
-  
-  
-INSERT INTO users SET 
-username='eddieroh',
-first_name='eddie',
-last_name='rohwedder',
-email='eddie_roh@yahoo.com',
-primary_language_id='494',
-hours_per_week='17',
-password_salt='',
-password_hash='',
-updated_on='',
-updated_at='',
-created_on='',
-created_at='',
-type='0',
-status='0',
-code='933b8a5ac8df8bd59918f9dd3ca35959',created=NOW()  
-  
-  */
-
-// ------...------...------...------...------...------...------...------...------...------...------
-?>
\ No newline at end of file
diff --git a/aptana_global/utils.inc.php b/aptana_global/utils.inc.php
deleted file mode 100644
index 1256f9e..0000000
--- a/aptana_global/utils.inc.php
+++ /dev/null
@@ -1,273 +0,0 @@
-<?php
-/*******************************************************************************
- * Copyright (c) 2007 Eclipse Foundation and others.
- * All rights reserved. This program and the accompanying materials
- * are made available under the terms of the Eclipse Public License v1.0
- * which accompanies this distribution, and is available at
- * http://www.eclipse.org/legal/epl-v10.html
- *
- * Contributors:
- *    Paul Colton (Aptana)- initial API and implementation
- *    Eclipse Foundation
-*******************************************************************************/

-require_once("consts.inc.php");
-define("COOKIE_REMEMBER","cBABEL");

-define("COOKIE_SESSION" ,"sBABEL");

-

-
-function __autoload($class_name) {
-  require_once(BABEL_BASE_DIR."sql/$class_name.class.php");

-}
-
-

-function SetSessionVar($varName,$varVal) {
-  global $_SESSION;
-
-  $GLOBALS[$varName]  = $varVal;

-  $_SESSION[$varName] = $varVal;

-  return $varVal;

-}
-

-

-function GetSessionVar($varName) {

-  if (isset($_SESSION[$varName]))

-    return $_SESSION[$varName];

-  return 0;

-}

-

-

-function ClearSessionVar($varName) {

-  if (isset($_SESSION[$varName]))

-    unset($_SESSION[$varName]);

-  if (isset($GLOBALS[$varName]))

-    unset($GLOBALS[$varName]);

-  return "";

-}

-

-

-function GrabSessionVar($varName) {

-  $retVal = GetSessionVar($varName);

-  ClearSessionVar($varName);

-  return $retVal;

-}

-

-

-function esc_str($str) {

-  $str = str_replace("%","#",$str);

-  $str = str_replace("{SELF","{ SELF",$str);

-  return mysql_escape_string($str);

-}

-
-
-function debugLog($str) {
-  dump(LOG2DEBUG,$str);
-}
-
-
-
-function errorLog($str) {
-  dump(LOG2ERROR,$str);
-}
-

-
-function userLog($str) {
-  dump(LOG2USER,$str);
-}
-

-
-function dump($where,$str) {
-  switch ($where) {
-    case LOG2USER:

-      log2File("php_user.log",$str,"#");

-      break;

-    case LOG2ERROR:

-      log2File("php_error.log",$str,"*");

-      break;

-    case LOG2DEBUG:

-      log2File("php_debug.log",$str,"-");

-      break;

-  }

-}
-
-
-function log2File($fileName,$str,$delim) {
-  $fileName = "/var/log/" . $fileName;
-  $date     = date('D.M.d H:i:s');
-  $date     = date('H:i:s Y.m.d');
-  $addr     = getenv("REMOTE_ADDR");
-  $acct     = GetSessionVar('c_acctID');
-  $user     = GetSessionVar('c_userID');
-

-//  $file = fopen($fileName,"a+");

-//  fwrite($file,"$date $addr [$acct:$user] $delim $str\n");

-//  fclose($file);

-}
-
-
-function getHtmlTmpl($fileName) {
-  $html = file_get_contents($fileName);
-  $html = str_replace("\"","\\\"",$html);
-  return $html;
-}
-
-
-function sqlOpen($database) {

-
-  if (!($ini = @parse_ini_file('base.conf'))) {
-    errorLog("Failed to find/read database conf file - aborting.");

-    exitTo("error.php?errNo=101300","error: 101300 - database conf can not be found");
-  }
-  //$ini['db_read_pass'] = "aptana$$1";
-  
-  if (!mysql_connect($ini['db_read_host'],$ini['db_read_user'],$ini['db_read_pass'])) {

-    errorLog("Failed attempt to connect to server - aborting.");
-    exitTo("/error.php?errNo=101301","error: 101301 - data server can not be found");
-  }

-
-  if (empty($database))

-    $database = $ini['db_read_name'];
-  if (isset($database)) {
-    if (!mysql_select_db($database)) {

-      errorLog("Failed attempt to open database: $database - aborting \n\t" . mysql_error());
-      exitTo("/error.php?errNo=101303","error: 101303 - unknown database name");
-    }
-  }

-}
-
-function sqlClose() {
-	mysql_close();
-}
-
-
-function sqlQuery($cmd) {
-  if (!($qry = mysql_query($cmd))) 
-    errorLog($cmd . "\n" . mysql_error());
-  return $qry;
-}
-
-
-function sqlGetRec($statement) {
-  if ($qry = sqlQuery($statement)) {
-    if ($rec = mysql_fetch_assoc($qry))
-      return $rec;
-  }
-  else
-    errorLog($statement . "\n" . mysql_error());
-  return 0;
-
-}
-
-
-function sqlGetCnt($statement) {
-  if ($qry = sqlQuery($statement)) {
-    if ($rec = mysql_fetch_array($qry))
-      return $rec[0];
-  }
-  else
-    errorLog($statement . "\n" . mysql_error());
-  return 0;
-
-}
-
-
-function exitTo() {
-  sqlClose();
-  if (func_num_args() == 1) {

-    $url = func_get_arg(0);

-    header("Location: $url");
-    exit;
-  }

-  else if (func_num_args() == 2) {

-    $url  = func_get_arg(0);

-    $arg1 = func_get_arg(1);

-    SetSessionVar("errStr",$arg1);

-    header("Location: $url");
-    exit;
-  }
-  else if (func_num_args() == 3) {

-    $url  = func_get_arg(0);

-    $arg1 = func_get_arg(1);

-    $arg2 = func_get_arg(2);

-    SetSessionVar($arg1,$arg2);

-    header("Location: $url");
-    exit;
-  }
-}
-
-
-function flushTo() {
-  if (func_num_args() == 1) {

-    $url = func_get_arg(0);

-    //debugLog("exitTo: $url");

-    header("Location: $url");
-    flush();
-    ob_flush();
-    ob_end_flush();
-  }
-  if (func_num_args() == 3) {

-    $url  = func_get_arg(0);

-    $arg1 = func_get_arg(1);

-    $arg2 = func_get_arg(2);

-    //debugLog("exitTo: $url");

-    SetSessionVar($arg1,$arg2);

-    header("Location: $url");
-    flush();
-    ob_flush();
-    ob_end_flush();
-  }
-}
-
-
-function getCookie($name) {
-  $retVal = "";
-  if (isset($_COOKIE[$name])) {
-    $retVal = $_COOKIE[$name];
-    setcookie($name,"",time()-3600,"/");
-    unset($_COOKIE[$name]);
-    //userLog("$name = $retVal");
-  }
-  return $retVal;
-}
-
-

-function isValidDate($dat) {

-  if (empty($dat) || (substr($dat,0,10) == "0000-00-00"))

-    return true;

- if ((strlen($dat)<10) || (strlen($dat)>10))

-   return false;

- if (substr_count($dat,"/")!=2)

-   return false;

- list($mon,$day,$yer) = @split("/",$dat);

- if (($mon < 1) || ($mon > 12))

-   return false;

- if (($day < 1) || ($day > 31))

-   return false;

- if (($yer < 1901) || ($yer > 2200))

-   return false;

- return true;

-}

-
-
-function GetFormID($idStr) {
-  if ($idNbr = getCookie("c_$idStr"))
-    SetSessionVar("s_$idStr",($idNbr == -1)?0:$idNbr);
-  return GetSessionVar("s_$idStr");
-}

-
-

-function guidNbr() {

-  return md5(uniqid(rand(),true));

-}
-
-
-function guidStr() {
-  $str = strtoupper(md5(uniqid(rand(),true)));
-  $str = substr($str,0,8) . "-" .
-         substr($str,8,4) . "-" .
-         substr($str,12,4). "-" .
-         substr($str,16,4). "-" .
-         substr($str,20);
-  return $str;
-}
-
-?>
\ No newline at end of file
diff --git a/babel-setup.sql b/babel-setup.sql
index 1e7499c..4e3d50d 100644
--- a/babel-setup.sql
+++ b/babel-setup.sql
@@ -261,11 +261,6 @@
   KEY `primary_language_id` (`primary_language_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
-insert into languages values(null, "en", null, "English", 1);
-
-
-insert into projects values("eclipse", 1);
-
 
 
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -278,3 +273,72 @@
 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
+
+
+
+
+
+/*
+Babel data
+User: babel@eclipse.org
+pass: password
+*/
+
+insert into profiles set login_name = "test", cryptpassword = "", realname = "tester", disabledtext = false, mybugslink = 1, extern_id = 1, disable_mail = false;
+insert into users set userid = 1, username = "babel@eclipse.org",first_name="babel",last_name="fish",email="babel@eclipse.org",primary_language_id = "",password_hash = "HSD9a.ShTTdvo", is_committer = true;
+insert into projects set project_id = 'eclipse', is_active = 1 ;
+INSERT INTO `languages` VALUES (1,'en',NULL,'English',1),
+(2,'fr',NULL,'French',1),
+(3,'ja',NULL,'Japanese',1),
+(4,'de',NULL,'German',1),
+(5,'es',NULL,'Spanish',1),
+(7,'it',NULL,'Italian',1),
+(8,'ja',NULL,'Japanese',1),
+(9,'ko',NULL,'Korean',1),
+(10,'pt','Brazil','Portuguese',1),
+(11,'zh','Simplified','Chinese',1),
+(12,'zh','Traditional','Chinese',1),
+(13,'cs',NULL,'Czech',1),
+(14,'hu',NULL,'Hungarian',1),
+(15,'pl',NULL,'Polish',1),
+(16,'ru',NULL,'Russian',1),
+(17,'da',NULL,'Russian',1),
+(18,'nl',NULL,'Dutch',1),
+(19,'fi',NULL,'Finnish',1),
+(20,'el',NULL,'Greek',1),
+(21,'no',NULL,'Norwegian',1),
+(22,'pt',NULL,'Portuguese',1),
+(23,'sv',NULL,'Swedish',1),
+(24,'tr',NULL,'Turkish',1),
+(25,'ar',NULL,'Arabic',1),
+(26,'he',NULL,'Hebrew',1);
+insert into project_versions set project_id = "eclipse", version = "3.4", is_active = 1;
+
+
+/* MAP INPUTS */
+insert into map_files values ("eclipse", "3.4", "ant.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/ant.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "base.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/base.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "compare.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/compare.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "core-hpux.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-hpux.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "core-macosx.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-macosx.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "core-qnx.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-qnx.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "core-variables.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core-variables.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "core.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/core.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "doc.map","http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/doc.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "equinox-incubator.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/equinox-incubator.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "feature.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/feature.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "jdtapt.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtapt.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "jdtcore.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtcore.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "jdtdebug.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtdebug.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "jdtui.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/jdtui.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "orbit.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/orbit.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "pde.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/pde.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "rcp.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/rcp.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "releng.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/releng.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "swt.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/swt.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "team.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/team.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "testframework.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/testframework.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "text.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/text.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "ui.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/ui.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "update.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/update.map?view=co", 1);
+insert into map_files values ("eclipse", "3.4", "userassist.map", "http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.releng/maps/userassist.map?view=co", 1);
\ No newline at end of file
diff --git a/classes/base.conf b/classes/base.conf
index 3c1c0ac..3f3a823 100644
--- a/classes/base.conf
+++ b/classes/base.conf
@@ -1,6 +1,8 @@
-; Turboflix db config file
+; Babel server config file
 
 db_read_host=localhost
-db_read_user=go
-db_read_pass=123Babe1
-db_read_name=babel
\ No newline at end of file
+db_read_user=babel
+db_read_pass=babelpassword
+db_read_name=babel
+
+context=dev
diff --git a/html/eclipse.org-common/.project b/html/eclipse.org-common/.project
deleted file mode 100644
index d6e216a..0000000
--- a/html/eclipse.org-common/.project
+++ /dev/null
@@ -1,11 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<projectDescription>
-	<name>eclipse.org-common</name>
-	<comment></comment>
-	<projects>
-	</projects>
-	<buildSpec>
-	</buildSpec>
-	<natures>
-	</natures>
-</projectDescription>