Advanced PHP Website is down

It's been down for a couple of days now. I wouldn't care, except that I'm right in the middle of implementing my first grid on my first Joomla site. Nothing like shutting the door on the learning curve.

HLEBOEUF implemented the Advanced PHP Datagrid within Joomla using JUMI. He posted some code on the apphp forums, which I can see in the cached view:

Code

id;

 
   if ($myid > 0)

   {

      $db->setQuery("SELECT secu_id FROM `dwe_sec_user` WHERE `secm_id`=".$thismodule." AND `jusr_id`=".$myid." LIMIT 1");

      $result = $db->loadResult();

      if ($result > 0)  /* Just an extra security to check if this user is allowed to run this module, nog all our editors may run all grids */

      {

         header("content-type: text/html; charset=utf-8");

 
         define ("DATAGRID_DIR", "../datagrid/");

         define ("PEAR_DIR", "../datagrid/pear/");

 
         require_once(DATAGRID_DIR.'datagrid.class.php');

         require_once(PEAR_DIR.'PEAR.php');

         require_once(PEAR_DIR.'DB.php');

 
         $DB_USER='xxx';

         $DB_PASS='xxx';

         $DB_HOST='xxxl';

         $DB_NAME='xxx';

 
         ob_start();

         $db_conn = DB::factory('mysql');

         $result_conn = $db_conn->connect(DB:<img src="http://www.joobb.org/components/com_joobb/assets/emotions/skype/skype_0110-tongueout.gif" title="Tongue Out" alt="Tongue Out" class="jbEmotion" />arseDSN('mysql://'.$DB_USER.':'.$DB_PASS.'@'.$DB_HOST.'/'.$DB_NAME));

         if(DB::isError($result_conn)){ die($result_conn->getDebugInfo()); }

 
         $sql =   "SELECT ...";

 
         /* ?option=com_jumi&fileid=3&Itemid=57 */

         $http_get_vars = array("option", "fileid", "Itemid");

         $dgrid->SetHttpGetVars($http_get_vars);

 
 

I have yet to learn JUMI (more learning curve), but can someone give more background as to how JUMI interacts with this code to make this possible. I have a comp sci degree, so you don't have to sugar coat it, just help me through some of the concepts.

Thanks in advance,

RUSHSociety.org