Beispiel #1
0
 function DTbarcode($text = "Testing", $filename = "")
 {
     global $barcode_type, $barcode_image_type, $barcodeDpi, $barcodeThick, $barcode_resolution, $barcode_font_size, $barcode_checksum, $barcode_rotation, $barCodeImagetypeToExt;
     $barcode_checksum = 0;
     $this->barcodeModel = DtrModel::getInstance('barcode', 'DtregisterModel');
     $barCodeImagetypeToExt = $this->barcodeModel->barCodeImagetypeToExt;
     $class_dir = JPATH_SITE . '/components/com_dtregister/lib/barcode/class';
     $filename = $filename != "" ? JPATH_SITE . '/images/dtregister/barcode/' . $filename . '.' . $barcode_image_type : '';
     require_once $class_dir . '/color.php';
     require_once $class_dir . '/barcode.php';
     require_once $class_dir . '/drawing.php';
     require_once $class_dir . '/font.php';
     require_once $class_dir . '/' . $barcode_type . '.php';
     $this->font = new BCGFont(JPATH_SITE . '/components/com_dtregister/monofont.ttf', intval($barcode_font_size));
     $this->color_black = new BCGColor(0, 0, 0);
     $this->color_white = new BCGColor(255, 255, 255);
     $codebar = 'BCG' . $barcode_type;
     $this->code_generated = new $codebar();
     if ($barcode_checksum && intval($barcode_checksum) === 1) {
         $this->code_generated->setChecksum(true);
     }
     $this->code_generated->setLabel($text);
     $this->code_generated->setThickness($barcodeThick);
     $this->code_generated->setScale($barcode_resolution);
     $this->code_generated->setBackgroundColor($this->color_white);
     $this->code_generated->setForegroundColor($this->color_black);
     $this->code_generated->setFont($this->font);
     $this->code_generated->parse($text);
     $this->drawing = new BCGDrawing($filename, $this->color_white);
     $this->drawing->setBarcode($this->code_generated);
     $this->drawing->setRotationAngle($barcode_rotation);
     $this->drawing->setDPI($barcodeDpi == 'null' || $barcodeDpi == "" ? null : (int) $barcodeDpi);
     $this->drawing->draw();
     $this->drawing->finish($barcode_image_type);
 }
Beispiel #2
0
 function __construct(&$db = null)
 {
     $db =& JFactory::getDBO();
     $this->db =& $db;
     parent::__construct('#__dtregister_permissions', 'id', $db);
     $this->ModelAco = DtrModel::getInstance('aco', 'DtregisterModel');
 }
Beispiel #3
0
 function __construct($config = array())
 {
     $this->options = array('at_door' => JText::_('DT_PAY_AT_DOOR'), 'mail' => JText::_('DT_MAILIN_PAYMENT'), 'phone' => JText::_('DT_CALLIN_PAYMENT'));
     $this->methods = array_keys($this->options);
     $this->table = new TablePaylater($this->getDBO());
     $this->options = $this->table->optionslist();
     parent::__construct($config);
 }
Beispiel #4
0
 function __construct($config = array())
 {
     $config['name'] = 'config';
     parent::__construct($config);
     $this->table = new DtrTable('#__dtregister_config', 'id', $this->getDBO());
     $this->TablePayoption =& DtrTable::getInstance('payoption', 'Table');
     $this->db = $this->getDBO();
 }
Beispiel #5
0
 function __construct($config = array())
 {
     parent::__construct($config);
     if ($this->jomsocialInstall()) {
         $this->table = new JomsocialFields($this->getDBO());
         $this->User = new JomUser($this->getDBO());
     }
 }
Beispiel #6
0
 function __construct($config = array())
 {
     parent::__construct($config);
     $this->notfields = array('forumorder', 'onlinestatus', 'lastvisitDate', 'registerDate', 'avatar', 'middlename', 'lastupdatedate', 'hits', 'password', 'params', 'connections', 'forumrank', 'forumkarma', 'forumsignature', 'forumview', 'forumorder', 'forumposts', 'username');
     if ($this->isInstall()) {
         $this->table = new DTCBFields($this->getDBO());
         $this->User = new DtCbUser($this->getDBO());
     }
 }
Beispiel #7
0
 function __construct($config = array())
 {
     parent::__construct($config);
     $this->barCodeTypes = array('code39' => JText::_('DT_CODE39'), 'code39extended' => JText::_('DT_CODE39_EXTENDED'), 'code93' => JText::_('DT_CODE93'), 'code128' => JText::_('DT_CODE128'));
     $this->barCodeImagetype = array('png' => JText::_('DT_BARCODE_PNG'), 'jpg' => JText::_('DT_BARCODE_JPEG'));
     $this->barCodeImagetypeToExt = array('png' => 'png', 'jpg' => 'jpeg');
     $this->barCodeResolutions = array('1' => 1, '2' => '2', '3' => '3');
     $this->barcodeRotation = array(0 => JText::_('DT_DEGREE_ZERO'), 90 => JText::_('DT_DEGREE_90'), 180 => JText::_('DT_DEGREE_180'), 270 => JText::_('DT_DEGREE_270'));
 }
Beispiel #8
0
 function __construct($config = array())
 {
     parent::__construct($config);
     $this->migrated = 0;
     $this->table = new TableDtregister($this->getDBO());
     $data = $this->table->find(' property = "migrate"');
     if ($data) {
         $data = $data[0];
         $this->migrated = $data->value;
     }
 }
Beispiel #9
0
 function __construct(&$db = null)
 {
     $db =& JFactory::getDBO();
     parent::__construct('#__dtregister_export_settings', 'id', $db);
     $this->UserModel =& DtrModel::getInstance('User', 'DtregisterModel');
     $this->pmethod =& DtrModel::getInstance('paymentmethod', 'DtregisterModel');
     $this->feeModel =& DtrModel::getInstance('fee', 'DtregisterModel');
     $this->Tablefield =& DtrTable::getInstance('Field', 'Table');
     $this->generalFields = array('event_date' => JText::_('DT_EVENT_DATE'), 'type' => JText::_('DT_USER_TYPE'), 'amount' => JText::_('DT_AMOUNT'), 'payment_type' => JText::_('DT_PAYMENT_TYPE'), 'paid' => JText::_('DT_PAYMENT_STATUS'), 'paid_amount' => JText::_('DT_AMOUNT_PAID'), 'memtot' => JText::_('DT_NUMBER_MEMBERS'), 'confirmNum' => JText::_('DT_CONFIRMATION_NUMBER'), 'code' => JText::_('DT_DISCOUNT_CODE'), 'category' => JText::_('DT_CATEGORY'), 'location' => JText::_('DT_LOCATION'), 'user_id' => JText::_('DT_JOOMLA_USERID'), 'attend' => JText::_('DT_ATTENDED'), 'status' => JText::_('DT_STATUS'), 'transaction_id' => JText::_('DT_TRANSACTION_ID'), 'userId' => JText::_('DT_USER_ID'));
     $fieldType = DtrModel::getInstance('Fieldtype', 'DtregisterModel');
     $this->fieldTypes = $fieldType->getTypes();
 }
Beispiel #10
0
 function __construct($config = array())
 {
     $this->defaultfields = array('firstname', 'lastname', 'zip', 'city', 'state', 'phone', 'email', 'address', 'address2', 'title', 'organization', 'country');
     parent::__construct($config);
     $this->TableEvent =& DtrTable::getInstance('Event', 'Table');
     $this->TableUser =& DtrTable::getInstance('Duser', 'Table');
     $this->TableUsergroupamount =& DtrTable::getInstance('Usergroupamount', 'Table');
     $this->TableUserfield =& DtrTable::getInstance('Userfield', 'Table');
     $this->TableMember =& DtrTable::getInstance('Member', 'Table');
     $this->fieldmapByName = array();
     $this->fieldmapById = array();
     $this->UserFldsTodefault = array('userFirstName' => 'firstname', 'userLastName' => 'lastname', 'userOrganization' => 'organization', 'userAddress' => 'address', 'userAddress2' => 'address2', 'userCity' => 'city', 'userState' => 'state', 'userCountry' => 'country', 'userZip' => 'zip', 'userPhone' => 'phone', 'userEmail' => 'email', 'userTitle' => 'title');
     $this->UserFldsTodefault = array_flip($this->UserFldsTodefault);
     $this->mapFields();
 }
Beispiel #11
0
 function __construct($event = null, $user = null)
 {
     $this->TableEvent = $event;
     $this->is_changed = false;
     $this->TableUser = $user;
     if ($user->userId) {
         $this->OldUser = new TableDuser();
         $this->OldUser->load($user->userId);
         ///$this->OldUser->compare($this->TableUser);
         $this->is_changed = !$this->OldUser->compare($this->TableUser);
     } else {
         $this->OldUser = false;
     }
     $fieldtype = DtrModel::getInstance('Fieldtype', 'DtregisterModel');
     $this->fieldtypes = $fieldtype->getTypes();
 }
 function getMergeList($all = false)
 {
     $paylater =& DtrModel::getInstance('paylater', 'dtregisterModel');
     $plm = $paylater->getOptions();
     if (isset($all) && $all) {
         $plm = $paylater->table->optionslist();
     } else {
         $plm = $paylater->getOptions();
     }
     $pm = $this->methods;
     if (isset($pm['pay_later'])) {
         unset($pm['pay_later']);
     }
     if (is_array($plm)) {
         foreach ($plm as $key => $method) {
             $pm[$key] = $method;
         }
     }
     return $pm;
 }
Beispiel #13
0
 function save()
 {
     global $mainframe;
     $row = $this->getModel('event')->table;
     $data = JRequest::getVar('data');
     $error = false;
     $error = false;
     if ($data['event']['slabId'] != "") {
         $row->load($data['event']['slabId']);
         if (!$row->validDateChange($data)) {
         }
         if (!$row->comparerepeat($data) && $row->repetition !== false) {
             $this->error = JText::_("DT_REPTITIONS_NOT_VALID");
             $error = true;
             //$error  = false ;
         }
     }
     if ($error) {
         DT_Session::set('event.data', $data);
         $files = JRequest::getVar('event_files', null, 'files', 'array');
         DT_Session::set('event.event_files', $files);
         $this->view->setLayout('warning');
         $this->view->assign('message', JText::_("DT_REPEAT_DELETE_WARNING"));
         $this->view->display();
     } else {
         if ($row->save($data) !== false) {
             global $eventListOrder;
             $conf = DtrModel::getInstance('config', 'DtregisterModel');
             $conf->updateEventorder($eventListOrder);
         } else {
             $mainframe->redirect("index.php?option=com_dtregister&controller=event&task=edit&cid[]=" . $row->slabId, $row->error);
         }
         $mainframe->redirect("index.php?option=com_dtregister&controller=event");
     }
 }
Beispiel #14
0
    function getConditonField()
    {
        global $mainframe;
        $document =& JFactory::getDocument();
        if (isset($document->_script["text/javascript"])) {
            unset($document->_script["text/javascript"]);
        }
        $field = $this->getModel('field')->table;
        $field->load(JRequest::getVar('field_id', 0));
        $childs = $field->getchild($published = 1);
        $selectionindex = JRequest::getVar('selection', '');
        $not_remove = JRequest::getVar('not_remove', array());
        if (!is_array($not_remove)) {
            $not_remove = array($not_remove);
        }
        if ($field->type == 1) {
            $selectionindex--;
        }
        $elements = array();
        // $event = new Event(JRequest::getVar('eventId',0));
        $childjs = "";
        $user = unserialize(base64_decode(JRequest::getVar('obj', '')));
        $eventId = JRequest::getVar('eventId', '');
        $event = DtrTable::getInstance('event', 'Table');
        $event->load($eventId);
        ///$evt_fields = $event->getAllFields();
        $remove_elements = array();
        $ordering = array();
        require_once JPATH_COMPONENT . "/views/field/view.html.php";
        $fieldView = new DtregisterViewField(array());
        if (is_array($fieldView->_path['template'])) {
            foreach ($fieldView->_path['template'] as $path) {
                if (file_exists($path)) {
                    $basepath = $path;
                    break;
                }
            }
        }
        if (is_array($childs)) {
            foreach ($childs as $key => $child) {
                $selection = explode('|', $child->selection_values);
                $ordering[$child->id] = $child->ordering;
                $selectionindex;
                $fieldType = DtrModel::getInstance('Fieldtype', 'DtregisterModel');
                $fieldTypes = $fieldType->getTypes();
                if (in_array($selectionindex, $selection)) {
                    $class = "Field_" . $fieldTypes[$child->type];
                    $childObj = new $class();
                    $childObj->load($child->id);
                    //if(isset($evt_fields[$child->id])){
                    //$child->required = $evt_fields[$child->id]->required ;
                    //}
                    $file = $basepath . "field_" . $fieldTypes[$child->type] . ".php";
                    if (!file_exists($file)) {
                        $file = $basepath . "default.php";
                    }
                    $child->label = stripslashes($child->label) . ":";
                    if ($child->required) {
                        $child->label = $child->label . " <span class='dtrequired'>&nbsp;&nbsp;*&nbsp;&nbsp;</span> ";
                    }
                    $tpl = file_get_contents($file);
                    $constants = array('[label]', '[value]', '[description]');
                    $description = trim($child->description) != "" ? JHTML::tooltip($child->description, '', 'tooltip.png', '', '') : '';
                    $replace = array($child->label, $childObj->formhtml($user, $event, 'adminForm', true), $description);
                    $childjs .= $childObj->childJs;
                    $elements[$child->id] = str_replace($constants, $replace, $tpl);
                } else {
                    $remove = true;
                    if (is_array($selection)) {
                        foreach ($selection as $val) {
                            if (in_array($val, $not_remove)) {
                                $remove = false;
                                break;
                            }
                        }
                    }
                    if ($remove) {
                        $remove_elements[$child->id] = $child->id;
                    }
                }
            }
        }
        $temp = $remove_elements;
        foreach ($remove_elements as $remove_element) {
            $rChilds = array();
            $field->findtree($remove_element, $rChilds);
            foreach ($rChilds as $rchild) {
                if (!in_array($rchild->id, array_keys($elements))) {
                    $temp[$rchild->id] = $rchild->id;
                }
            }
        }
        $remove_elements = $temp;
        ob_start();
        ?>

	 var elements = <?php 
        echo json_encode($elements);
        ?>
;

	 var remove_elements = <?php 
        echo json_encode($remove_elements);
        ?>
;

     var ordering = <?php 
        echo json_encode($ordering);
        ?>
;

     <?php 
        echo $childjs;
        echo chr(13);
        if (isset($document->_script["text/javascript"])) {
            echo $document->_script['text/javascript'];
        }
        $data = ob_get_clean();
        echo str_replace("\n", ' ', $data) . "/*DTendScript*/";
        die;
    }
Beispiel #15
0
 function __construct($config = array())
 {
     parent::__construct($config);
     $this->location = new TableLocation($this->getDBO());
     $this->table = $this->location;
 }
Beispiel #16
0
 function __construct($config = array())
 {
     parent::__construct($config);
     $this->table = new TableEventGroup($this->getDBO());
     $this->tableJevt = new TableJevent($this->getDBO());
 }
Beispiel #17
0
 function save()
 {
     global $mainframe, $Itemid, $DT_mailfrom, $DT_fromname, $frontendEventNotification;
     $row = $this->getModel('event')->table;
     $data = JRequest::getVar('data');
     $error = false;
     if ($data['event']['slabId'] != "") {
         $row->load($data['event']['slabId']);
         if (!$row->validDateChange($data)) {
             $this->error = JText::_("DT_REPTITIONS_NOT_VALID");
             $error = true;
         }
     }
     if ($error) {
         DT_Session::set('event.data', $data);
         $files = JRequest::getVar('event_files', null, 'files', 'array');
         DT_Session::set('event.event_files', $files);
         $this->view->setLayout('warning');
         $this->view->assign('message', JText::_("DT_REPEAT_DELETE_WARNING"));
         $this->view->display();
     } else {
         if ($row->save($data) !== false) {
             global $eventListOrder;
             $conf = DtrModel::getInstance('config', 'DtregisterModel');
             $conf->updateEventorder($eventListOrder);
             $subject = JText::_('DT_EVENT_EDIT_SUBJECT');
             $message = JText::_('DT_EVENT_EDIT_MESSAGE');
             $user = $this->getModel('user')->table;
             $Tagparser = new Tagparser();
             if (isset($data['event']['slabId']) && $data['event']['slabId'] > 0) {
                 $token_subject = JText::_('DT_EVENT_EDIT_SUBJECT');
                 $token_msg = "";
                 $token_msg .= '<p>' . JText::_('DT_EVENT_EDIT_MESSAGE') . '</p><p>' . JText::_('DT_EVENT_NAME') . ': [EVENT_NAME]';
                 $token_msg .= '<br />' . JText::_('DT_EVENT_DATE') . ': [EVENT_DATE]';
                 $token_msg .= '<br />' . JText::_('DT_EVENT_TIME') . ': [EVENT_TIME]';
                 $token_msg .= '<br />' . JText::_('DT_LOCATION') . ': [LOCATION]</p>';
             } else {
                 $token_subject = JText::_('DT_EVENT_CREATE_SUBJECT');
                 $token_msg = "";
                 $token_msg .= '<p>' . JText::_('DT_EVENT_CREATE_MESSAGE') . '</p><p>' . JText::_('DT_EVENT_NAME') . ': [EVENT_NAME]';
                 $token_msg .= '<br />' . JText::_('DT_EVENT_DATE') . ': [EVENT_DATE]';
                 $token_msg .= '<br />' . JText::_('DT_EVENT_TIME') . ': [EVENT_TIME]';
                 $token_msg .= '<br />' . JText::_('DT_LOCATION') . ': [LOCATION]</p>';
             }
             $user->eventId = $row->slabId;
             $user->load(0);
             $message = $Tagparser->parsetags($token_msg, $user);
             $subject = $Tagparser->parsetags($token_subject, $user);
             $email = $frontendEventNotification;
             $emails = explode(";", $email);
             foreach ($emails as $email) {
                 JUTility::sendMail($DT_mailfrom, $DT_fromname, $email, $subject, $message, 1);
             }
         } else {
             $mainframe->redirect("index.php?option=com_dtregister&controller=eventmanage&Itemid={$Itemid}&task=edit&cid[]=" . $row->slabId, $row->error);
         }
         $mainframe->redirect("index.php?option=com_dtregister&controller=eventmanage&Itemid={$Itemid}");
     }
 }
Beispiel #18
0
    function formhtml($obj = null, $event = null, $form = '', $overlimitdisable = false, $type = 'I')
    {
        global $amp, $xhtml;
        parent::formhtml($obj, $event, $form, $overlimitdisable);
        $fieldType = DtrModel::getInstance('Fieldtype', 'DtregisterModel');
        $fieldTypes = $fieldType->getTypes();
        require_once JPATH_SITE . "/components/com_dtregister/views/field/view.html.php";
        $fieldView = new DtregisterViewField(array());
        if (count($fieldView->_path['template']) > 0) {
            foreach ($fieldView->_path['template'] as $path) {
                if (file_exists($path)) {
                    $basepath = $path;
                    break;
                }
            }
        }
        $file = $basepath . "default.php";
        $this->requiredHtml = "";
        if ($this->required) {
            $this->label = $this->label . " <span class='dtrequired'>&nbsp;&nbsp;*&nbsp;&nbsp;</span> ";
            $this->requiredHtml = "<span class='dtrequired'>&nbsp;&nbsp;*&nbsp;&nbsp;</span>";
            $this->required = true;
        }
        $requiredClass = $this->required ? 'required' : '';
        $tpl = file_get_contents($file);
        $constants = array('[label]', '[value]', '[description]');
        $description = trim($this->description) != "" ? JDTHTML::tooltip($this->description, '', 'tooltip.png', '', '') : '';
        $value = isset($obj['fields'][$this->id]) ? $obj['fields'][$this->id] : '';
        $maxlength = $this->maxlength != 0 && $this->maxlength != "" ? "maxlength='" . $this->maxlength . "'" : '';
        $requiredClass = $this->required ? 'required email' : 'email';
        $readonly = "";
        global $cbviewonly, $cb_integrated, $map_cb_fields;
        $my =& JFactory::getUser();
        if ($value != "" && $cb_integrated > 0 && $cbviewonly == 1 && $my->id && isset($map_cb_fields[$this->id])) {
            $readonly = "readonly='readonly'";
        }
        if (isset($obj['groupMemberId']) && $obj['groupMemberId'] > 0) {
            $readonly = "";
        }
        $fieldhtml = "<input type='text' id='Field" . $this->id . "' class='inputbox " . $requiredClass . "' " . $readonly . " size='{$this->field_size}' {$maxlength} name='Field[" . $this->id . "]' value='{$value}' />";
        $replace = array($this->label, $fieldhtml, $description);
        $html = "";
        $html .= str_replace($constants, $replace, $tpl);
        $replace = array(JText::_("DT_CONFIRM_EMAIL") . $this->requiredHtml, "<input type='text' id='ConfirmField" . $this->id . "' class='inputbox " . $requiredClass . "' size='{$this->field_size}' {$maxlength} name='ConfirmField[" . $this->id . "]' value='' />", '');
        global $mainframe;
        $this->emailConfirmation = false;
        if (!$mainframe->isAdmin() && $this->confirmation_field) {
            $html .= str_replace($constants, $replace, $tpl);
            $this->emailConfirmation = true;
        }
        // confirmemail
        $document =& JFactory::getDocument();
        ob_start();
        $dup_check = "";
        if (isset($this->duplicate_check) && !$this->duplicate_check) {
            $dup_check = "&dup_check=true";
        }
        $member_check = "";
        if ($type == 'M') {
            $member_check = "&member_check=true";
        }
        ?>

          DTjQuery(function(){

                DTjQuery(document.<?php 
        echo $form;
        ?>
).validate({

                        success: function(label) {

                            label.addClass("success");

                        }

                });
              
             DTjQuery('#Field<?php 
        echo $this->id;
        ?>
').rules('add',{remote: "<?php 
        echo JRoute::_('index.php?option=com_dtregister&controller=validate&task=email&no_html=1&eventId=' . $event->slabId . $dup_check . $member_check, $xhtml);
        ?>
" });
      <?php 
        if ($this->emailConfirmation && $form != 'adminForm') {
            ?>
              DTjQuery('#ConfirmField<?php 
            echo $this->id;
            ?>
').rules('add',{equalTo: "#Field<?php 
            echo $this->id;
            ?>
"
     
});

             <?php 
        }
        ?>
  

          })

            <?php 
        $js = ob_get_clean();
        $document->addScriptDeclaration($js);
        return $html;
    }
Beispiel #19
0
 function __construct($config = array())
 {
     parent::__construct($config);
     $this->discountcode = new TableDiscountcode($this->getDBO());
     $this->table = $this->discountcode;
 }
Beispiel #20
0
 function __construct($config = array())
 {
     $this->types = array("Visa" => JText::_('DT_VISA'), "MasterCard" => JText::_('DT_MASTERCARD'), "Discover" => JText::_('DT_DISCOVER'), "AmericanExpress" => JText::_('DT_AMERICANEXPRESS'));
     parent::__construct($config);
 }
Beispiel #21
0
 function viewFields($type = 'I', $obj, $showHidden = false, $form = 'frmcart', $overlimitdisable = false)
 {
     $fieldTable = DtrTable::getInstance('field', 'Table');
     $fieldType = DtrModel::getInstance('Fieldtype', 'DtregisterModel');
     $fieldTypes = $fieldType->getTypes();
     $fieldTable->getAllFields($this, $type, $showHidden, 0, $fields);
     require_once JPATH_SITE . "/components/com_dtregister/views/field/view.html.php";
     $fieldView = new DtregisterViewField(array());
     foreach ($fieldView->_path['template'] as $path) {
         if (file_exists($path)) {
             $basepath = $path;
             break;
         }
     }
     $html = "";
     if (is_array($fields)) {
         foreach ($fields as $field) {
             $class = "Field_" . $fieldTypes[$field->type];
             $fieldTable = new $class();
             $fieldTable->load($field->id);
             if ($fieldTable->type == 6 && $fieldTable->textualdisplay == 1) {
                 $show_field = false;
                 if (isset($obj['fields'][$fieldTable->parent_id])) {
                     if (is_array($fieldTable->selection_values)) {
                         if (!is_array($obj['fields'][$fieldTable->parent_id]) && in_array($obj['fields'][$fieldTable->parent_id], $fieldTable->selection_values)) {
                             $show_field = true;
                         } elseif (is_array($obj['fields'][$fieldTable->parent_id])) {
                             foreach ($obj['fields'][$fieldTable->parent_id] as $parent_value) {
                                 if (in_array($parent_value, $fieldTable->selection_values)) {
                                     $show_field = true;
                                     break;
                                 }
                             }
                         }
                     } else {
                         if ($obj['fields'][$fieldTable->parent_id] == $fieldTable->selection_values) {
                             $show_field = true;
                         }
                     }
                 }
                 if (!$show_field) {
                     continue;
                 }
             } elseif ($fieldTable->type == 6 && $fieldTable->textualdisplay == 0) {
                 continue;
             }
             if ($showHidden) {
                 continue;
             }
             $file = $basepath . "field_" . $fieldTypes[$field->type] . ".php";
             if (!file_exists($file)) {
                 $file = $basepath . "default.php";
             }
             $field->label = stripslashes($fieldTable->label) . ":";
             $tpl = file_get_contents($file);
             $constants = array('[label]', '[value]', '[description]');
             $value = $fieldTable->viewHtml($obj, $this, $form, $overlimitdisable);
             if ($value) {
                 $replace = array($field->label, $value, '');
                 $html .= str_replace($constants, $replace, $tpl);
             }
         }
     }
     return $html;
 }
Beispiel #22
0
 function __construct($config = array())
 {
     $this->colors = array("green" => JText::_('DT_GREEN'), "black" => JText::_('DT_BLACK'), "blue" => JText::_('DT_BLUE'), "brown" => JText::_('DT_BROWN'), "orange" => JText::_('DT_ORANGE'), "purple" => JText::_('DT_PURPLE'), "red" => JText::_('DT_RED'), "yellow" => JText::_('DT_YELLOW'));
     parent::__construct($config);
 }
Beispiel #23
0
 function generateconfirmNum()
 {
     global $confirm_number_type, $confirm_number_prefix, $confirm_number_start;
     $x_invoice_num1 = "";
     if ($confirm_number_type == 'random') {
         $chars = "0123456789";
         srand((double) microtime() * 1000000);
         for ($i = 0; $i < 7; $i++) {
             $x_invoice_num1 .= $chars[rand() % strlen($chars)];
         }
     } else {
         $x_invoice_num1 = $confirm_number_start + 1;
         $config =& DtrModel::getInstance('config', 'dtregisterModel');
         $config->setConfig('confirm_number_start', $x_invoice_num1);
     }
     return $confirm_number_prefix . $x_invoice_num1;
 }
Beispiel #24
0
 function __construct($config = array())
 {
     parent::__construct($config);
     $this->AcoGroup = array('DT_EDIT_OWN_EVENT' => array(array('controller' => 'event', 'task' => 'edit', 'type' => 'sessionUser'), array('controller' => 'event', 'task' => 'publish', 'type' => 'sessionUser'), array('controller' => 'event', 'task' => 'unpublish', 'type' => 'sessionUser')), 'DT_EVENT_CREATE' => array(array('controller' => 'event', 'task' => 'add', 'type' => 'action')), 'DT_PUBLISH_EVENT' => array(array('controller' => 'event', 'task' => 'publish', 'type' => 'action'), array('controller' => 'event', 'task' => 'unpublish', 'type' => 'action')), 'DT_DELETE_EVENT' => array(array('controller' => 'event', 'task' => 'delete', 'type' => 'action')), 'DT_CREATE_CATEGORY' => array(array('controller' => 'category', 'task' => 'add', 'type' => 'action')), 'DT_EDIT_DELETE_CATEGORY' => array(array('controller' => 'category', 'task' => 'edit', 'type' => 'action'), array('controller' => 'category', 'task' => 'delete', 'type' => 'action')), 'DT_CREATE_FIELD' => array(array('controller' => 'field', 'task' => 'add', 'type' => 'action')), 'DT_EDIT_DELETE_FIELD' => array(array('controller' => 'field', 'task' => 'edit', 'type' => 'action'), array('controller' => 'field', 'task' => 'delete', 'type' => 'action')), 'DT_CREATE_DISCOUNTCODE' => array(array('controller' => 'discountcode', 'task' => 'add', 'type' => 'action')), 'DT_EDIT_DELETE_DISCOUNTCODE' => array(array('controller' => 'discountcode', 'task' => 'edit', 'type' => 'action'), array('controller' => 'discountcode', 'task' => 'delete', 'type' => 'action')), 'DT_CREATE_LOCATION' => array(array('controller' => 'location', 'task' => 'add', 'type' => 'action')), 'DT_EDIT_DELETE_LOCATION' => array(array('controller' => 'location', 'task' => 'edit', 'type' => 'action'), array('controller' => 'location', 'task' => 'delete', 'type' => 'action')), 'DT_CONFIG' => array(array('controller' => 'config', 'task' => 'index', 'type' => 'action')), 'DT_EMAIL_REGISTRANT' => array(array('controller' => 'registrantemail', 'task' => 'index', 'type' => 'action')), 'DT_CREATE_PAYOPTION' => array(array('controller' => 'payoption', 'task' => 'add', 'type' => 'action')), 'DT_EDIT_DELETE_PAYOPTION' => array(array('controller' => 'payoption', 'task' => 'edit', 'type' => 'action'), array('controller' => 'payoption', 'task' => 'delete', 'type' => 'action')), 'DT_CSV_EXPORT' => array(array('controller' => 'export', 'task' => 'eventlist', 'type' => 'action'), array('controller' => 'export', 'task' => 'fieldlist', 'type' => 'action')));
     $this->table = new TableAco($this->getDBO());
 }
Beispiel #25
0
 function userdata($userId)
 {
     $user =& DtrModel::getInstance('DtregisterModelUser');
     $user = $user->table;
     $user->load($userId);
     $type = $user->type == 'I' ? 'I' : 'B';
     $fieldshtml = "";
     if ($user->user_id > 0) {
         $fieldshtml .= '<tr><td>' . JText::_('DT_USERNAME') . ':</td><td>' . $user->TableJUser->username . '</td></tr>';
     }
     $fieldshtml .= $user->TableEvent->viewFields($type, (array) $user->getObjData(), false);
     if ($user->type == 'G') {
         $i = 1;
         foreach ($user->members as $key => $member) {
             $fieldshtml .= "<tr><td colspan='2'>&nbsp;</td></tr><tr><td colspan='3'><u>" . JText::_('DT_MEMBER') . $i . " </u></td></tr>";
             $fieldshtml .= $user->TableEvent->viewFields('M', (array) $member, false, 'frmcart', false);
             $i++;
         }
     }
     return $fieldshtml;
 }
    function billingform()
    {
        ob_start();
        $paymentMethod = DT_Session::get('register.payment.method');
        ?>

		        <tr><td colspan="2" ><strong><?php 
        echo JText::_('DT_PAYMENT_INFORMATION');
        ?>
</strong></td></tr>

                <tr><td colspan="2" >&nbsp;
                	<input type="hidden" name="paymentmethod" value="<?php 
        echo $paymentMethod;
        ?>
" />
                </td></tr>

			<?php 
        if (count(DT_Session::get('register.User')) == 1) {
            ?>
             <tr>
                	<td><?php 
            echo JText::_('DT_SAME_BILLING_INFO');
            ?>
</td>
                	<td><input type="checkbox" class="inputbox" name="same" id="same" value="1" /></td>
             </tr>
            <?php 
        }
        ?>

		        <tr>

                	<td width="31%"><?php 
        echo JText::_('DT_CARD_HOLDER_FIRSTNAME');
        ?>
:<span class="dtrequired">  *  </span></td>

                    <td width="69%" align="left" > <input id="billingFirstname"  class="inputbox required" type="text" name="billing[firstname]" value="<?php 
        echo isset($this->firstname) ? $this->firstname : '';
        ?>
" /> </td>

                 </tr>

                   <tr>

                	<td width="31%"  ><?php 
        echo JText::_('DT_CARD_HOLDER_LASTNAME');
        ?>
:<span class="dtrequired">  *  </span></td>

                    <td width="69%" align="left" > <input id="billingLastname" class="inputbox required" type="text" name="billing[lastname]" value="<?php 
        echo isset($this->lastname) ? $this->lastname : '';
        ?>
" /> </td>

                 </tr>

                   <tr>

                	<td width="31%"  ><?php 
        echo JText::_('DT_BILLING_ADDRESS');
        ?>
:<span class="dtrequired">  *  </span></td>

                    <td width="69%" align="left" > <input id="billingAddress" class="inputbox required" type="text" name="billing[address]" value="<?php 
        echo isset($this->address) ? $this->address : '';
        ?>
" /> </td>

                 </tr>

                   <tr>

                	<td width="31%"  ><?php 
        echo JText::_('DT_CITY');
        ?>
:<span class="dtrequired">  *  </span></td>

                    <td width="69%" align="left" ><input id="billingCity" class="inputbox required" type="text" name="billing[city]" value="<?php 
        echo isset($this->city) ? $this->city : '';
        ?>
" />  </td>

                 </tr>

                   <tr>

                	<td width="31%"  ><?php 
        echo JText::_('DT_STATE');
        ?>
:<span class="dtrequired">  *  </span></td>

                    <td width="69%" align="left" > <input  id="billingState" class="inputbox required" type="text" name="billing[state]" value="<?php 
        echo isset($this->state) ? $this->state : '';
        ?>
" /> </td>

                 </tr>
<?php 
        $countylist = new TableField();
        $field = $countylist->fingbyName('country');
        // pr($field->id);
        $paymentmethod = DtrModel::getInstance('paymentmethod', 'DtregisterModel');
        global $paypal_pro_country;
        if (get_class($this) == 'paypal_pro') {
            $value = isset($this->country) ? $this->country : $paypal_pro_country;
            $dropDownDatas = $paymentmethod->paypal_country_codes();
            $countrydropdown = JHTML::_('select.genericlist', DtHtml::options($dropDownDatas, JText::_("DT_SELECT_COUNTRY")), 'billing[country]', $value, 'value', 'text', array($value));
            // pr($value); pr($countrydropdown); exit;
        } else {
            if ($field) {
                $dropDownDatas = explode("|", $field->values);
                $value = isset($this->country) ? $this->country : $field->selected;
                $countrydropdown = JHTML::_('select.genericlist', DtHtml::options($dropDownDatas, JText::_("DT_SELECT_COUNTRY")), 'billing[country]', ' ', 'value', 'text', $value);
            }
        }
        ?>
        <tr>
			   <td>
				 <?php 
        echo JText::_('DT_COUNTRY');
        ?>
			   </td>
			   <td>
				 <?php 
        echo $countrydropdown;
        ?>
			   </td>
		</tr>
       
                 <tr>
                	<td width="31%"><?php 
        echo JText::_('DT_ZIPCODE');
        ?>
:<span class="dtrequired">  *  </span></td>
                    <td width="69%" align="left"> <input id="billingZipcode" class="inputbox required" type="text" name="billing[zipcode]" value="<?php 
        echo isset($this->zipcode) ? $this->zipcode : '';
        ?>
" /> </td>
                 </tr>
  
                 <tr>
                	<td width="31%"><?php 
        echo JText::_('DT_PHONE');
        ?>
:<span class="dtrequired">  *  </span></td>
                    <td width="69%" align="left"> <input id="billingPhone" class="inputbox required" type="text" name="billing[phone]" value="<?php 
        echo isset($this->phone) ? $this->phone : '';
        ?>
" /> </td>
                 </tr>
  <?php 
        if (get_class($this) != 'offline_payment') {
            ?>
                 <tr>
                	<td width="31%"><?php 
            echo JText::_('DT_EMAIL');
            ?>
:<span class="dtrequired">  *  </span></td>
                    <td width="69%" align="left"> <input id="billingEmail" class="inputbox required" type="text" name="billing[email]" value="<?php 
            echo isset($this->email) ? $this->email : '';
            ?>
" /> </td>
                 </tr>
   <?php 
        }
        ?>
                 <?php 
        foreach (DT_Session::get('register.User') as $key => $user) {
            if (!intval($key)) {
                continue;
            }
            break;
        }
        ?>

				<script language="javascript" type="text/javascript">

                    //<![CDATA[
							<?php 
        $field = $countylist->fingbyName('firstname');
        ?>
							var billing_firstname = "<?php 
        echo $field ? $user['fields'][$field->id] : '';
        ?>
";
							<?php 
        $field = $countylist->fingbyName('lastname');
        ?>
							var billing_lastname = "<?php 
        echo $field ? $user['fields'][$field->id] : '';
        ?>
";
							<?php 
        $field = $countylist->fingbyName('address');
        ?>
							var billing_address = "<?php 
        echo $field ? $user['fields'][$field->id] : '';
        ?>
";
							<?php 
        $field = $countylist->fingbyName('city');
        ?>
							var billing_city = "<?php 
        echo $field ? $user['fields'][$field->id] : '';
        ?>
";
							<?php 
        $field = $countylist->fingbyName('state');
        ?>
							var billing_state = "<?php 
        echo isset($this->state) ? $this->state : '';
        ?>
";
							<?php 
        $field = $countylist->fingbyName('zip');
        ?>
							var billing_zipcode = "<?php 
        echo $field && isset($user['fields'][$field->id]) ? $user['fields'][$field->id] : '';
        ?>
";
							<?php 
        $field = $countylist->fingbyName('email');
        ?>
							var billing_email = "<?php 
        echo $field ? $user['fields'][$field->id] : '';
        ?>
";
							<?php 
        $field = $countylist->fingbyName('country');
        ?>
							var billing_country = "<?php 
        echo $field ? $user['fields'][$field->id] : '';
        ?>
";
		
							DTjQuery(function(){
								DTjQuery("#same").click(function(){
									
									if(this.checked) {
										DTjQuery("#billingFirstname").val(billing_firstname);
										DTjQuery("#billingLastname").val(billing_lastname);
										DTjQuery("#billingAddress").val(billing_address);
										DTjQuery("#billingCity").val(billing_city);
										DTjQuery("#billingState").val(billing_state);
										DTjQuery("#billingZipcode").val(billing_zipcode);
										DTjQuery("#billingEmail").val(billing_email);
										DTjQuery("#billingcountry").val(billing_country);
									} else {
										DTjQuery("#billingFirstname").val('');
										DTjQuery("#billingLastname").val('');
										DTjQuery("#billingAddress").val('');
										DTjQuery("#billingCity").val('');
										DTjQuery("#billingState").val('');
										DTjQuery("#billingZipcode").val('');
										DTjQuery("#billingEmail").val('');
										DTjQuery("#billingcountry").val('');
									}
		
								});
							});
                    
							//]]>

                   </script>

                <?php 
        $data = ob_get_clean();
        return $data;
    }
Beispiel #27
0
 function __construct($config = array())
 {
     parent::__construct($config);
     $this->table = new TableSection($this->getDBO());
 }
/**
* @version 2.7.7
* @package Joomla 1.5
* @subpackage DT Register
* @copyright Copyright (C) 2006 DTH Development
* @copyright contact dthdev@dthdevelopment.com
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
*/
function com_install()
{
    $database =& JFactory::getDBO();
    JFolder::create('../images/dtregister/');
    JFolder::create('../images/dtregister/barcode/');
    JFolder::create('../images/dtregister/eventpics/');
    JFolder::create('../images/dtregister/locations/');
    JFolder::create('../images/dtregister/uploads/');
    /******* Database changes from 2.6.9 to 2.7.x *******/
    // Start changes for #__dtregister_categories
    $sql = "Show columns from #__dtregister_categories";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('color', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_categories` ADD `color` varchar(20) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('published', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_categories` ADD `published` int(1) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('access', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_categories` ADD `access` int(2) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    $sql = "ALTER TABLE `#__dtregister_categories` CHANGE `ordering` `ordering` INT(7) UNSIGNED NULL DEFAULT '1'";
    $database->setQuery($sql);
    $database->query();
    // End of changes to #__dtregister_categories
    // Start of changes to #__dtregister_codes
    $sql = "Show columns from #__dtregister_codes";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('amount', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_codes` CHANGE `amount` `amount` decimal(8,2) default '0.00'";
        $database->setQuery($sql);
        $database->query();
    }
    // End of changes to #__dtregister_codes
    // Drop unneeded tables
    $sql = "Show columns from #__dtregister_export_fields";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('group_export_fields', $arrFields)) {
        $sql = "DROP TABLE `#__dtregister_export_fields`";
        $database->setQuery($sql);
        $database->query();
    }
    $sql = "Show columns from #__dtregister_sync";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('old_event_id', $arrFields)) {
        $sql = "DROP TABLE `#__dtregister_sync`";
        $database->setQuery($sql);
        $database->query();
    }
    $sql = "Show columns from #__dtregister_waiting";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('number_registrants', $arrFields)) {
        $sql = "DROP TABLE `#__dtregister_waiting`";
        $database->setQuery($sql);
        $database->query();
    }
    // End of DROP tables
    // Start of changes to #__dtregister_fields table
    $sql = "Show columns from #__dtregister_fields";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('showed', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_fields` CHANGE `showed` `showed` tinyint(2) NOT NULL default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('textareafee', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_fields` ADD `textareafee` text default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('showcharcnt', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_fields` ADD `showcharcnt` int(2) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('default', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_fields` ADD `default` int(2) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('confirmation_field', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_fields` ADD `confirmation_field` int(2) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('listing', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_fields` ADD `listing` text default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('textualdisplay', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_fields` ADD `textualdisplay` int(1) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('applychangefee', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_fields` ADD `applychangefee` int(2) default '1'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('tag', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_fields` ADD `tag` varchar(255) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('all_tag_enable', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_fields` ADD `all_tag_enable` int(2) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    // End of changes to #__dtregister_fields table
    // Start of changes to #__dtregister_group_event
    $sql = "Show columns from #__dtregister_group_event";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('title', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `title` varchar(255) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('dtstart', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `dtstart` date default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('dtend', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `dtend` date default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('dtstarttime', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `dtstarttime` TIME default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('dtendtime', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `dtendtime` TIME default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('tax_amount', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` CHANGE `tax_amount` `tax_amount` decimal(8,2) default '0.00'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('payment_id', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `payment_id` int(4) NULL default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('repetition_id', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `repetition_id` int(7) NULL default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('parent_id', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `parent_id` int(7) NULL default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('usercreation', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `usercreation` int(2) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('imagepath', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `imagepath` varchar(255) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('timeformat', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `timeformat` int(2) NULL default '2'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('latefeetime', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `latefeetime` time default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('bird_discount_time', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `bird_discount_time` time default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('starttime', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `starttime` time default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('cut_off_time', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `cut_off_time` time default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('change_time', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `change_time` time default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('cancel_time', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `cancel_time` time default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('user_id', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `user_id` int(7) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('changefee_enable', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `changefee_enable` int(2) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('changefee_type', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `changefee_type` int(2) default '1'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('changefee', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `changefee` decimal(8,2) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('cancelfee_type', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `cancelfee_type` int(2) default '1'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('cancelfee', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `cancelfee` decimal(8,2) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('usetimecheck', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `usetimecheck` int(1) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('group_registration_type', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `group_registration_type` varchar(20) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('cancel_enable', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `cancel_enable` tinyint(1) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('min_group_size', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `min_group_size` int(4) default '2'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('admin_notification_set', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `admin_notification_set` tinyint(2) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('admin_notification', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `admin_notification` text default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('partial_payment_enable', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `partial_payment_enable` int(1) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('prevent_duplication', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `prevent_duplication` tinyint(1) NULL default '1'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('event_admin_email_set', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `event_admin_email_set` tinyint(4) NOT NULL default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('event_admin_email_from_name', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `event_admin_email_from_name` varchar(100) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('event_admin_email_from_email', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `event_admin_email_from_email` varchar(100) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('thanks_redirection', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `thanks_redirection` int(2) NULL default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('thanks_redirect_url', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `thanks_redirect_url` varchar(255) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('pay_later_redirection', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `pay_later_redirection` int(2) NULL default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('pay_later_redirect_url', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_event` ADD `pay_later_redirect_url` varchar(255) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    $sql = "ALTER TABLE `#__dtregister_group_event` CHANGE `ordering` `ordering` INT(7) UNSIGNED NULL DEFAULT '1'";
    $database->setQuery($sql);
    $database->query();
    // End of changes to #__dtregister_group_event
    // Start of changes to #__dtregister_group_member
    $sql = "Show columns from #__dtregister_group_member";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('created', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_group_member` ADD `created` DATETIME DEFAULT NULL";
        $database->setQuery($sql);
        $database->query();
    }
    // End of changes to #__dtregister_group_member
    // Start of changes to #__dtregister_history
    $sql = "Show columns from #__dtregister_history";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('transaction_id', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_history` CHANGE `amount` `amount` decimal(10,2) default '0.00'";
        $database->setQuery($sql);
        $database->query();
    }
    // End of changes to #__dtregister_history
    // Start of changes to #__dtregister_session
    $sql = "Show columns from #__dtregister_session";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('processed', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_session` ADD `processed` tinyint(1) NULL default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    // End of changes to #__dtregister_session
    // Start of changes to #__dtregister_user
    $sql = "Show columns from #__dtregister_user";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('userType', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_user` CHANGE `userType` `type` enum('I','G') default 'I'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('status', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_user` ADD `status` int(11) default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    if (!in_array('memtot', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_user` ADD `memtot` int(4) NULL default '0'";
        $database->setQuery($sql);
        $database->query();
    }
    // End of changes to #__dtregister_user
    // Add title field to config table
    $sql = "Show columns from #__dtregister_config";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (!in_array('title', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_config` ADD `title` varchar(50) default NULL";
        $database->setQuery($sql);
        $database->query();
    }
    //Check and insert default data for configuration
    $sql = "Select count(*) From #__dtregister_config";
    $database->setQuery($sql);
    $total = $database->loadResult();
    if (!$total) {
        //Insert default data here
        $sql = "INSERT INTO `#__dtregister_config` VALUES(1, 'capacity_column', '1', 'capacity_column');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(2, 'registered_column', '1', 'registered_column');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(3, 'cb_integrated', '1', 'cb_integrated');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(4, 'cbviewonly', '0', 'cbviewonly');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(5, 'thanksemail', '<p>[TITLE] [FIRSTNAME] [LASTNAME],</p>\n\t\t<p>You have registered for [EVENT_NAME] on [EVENT_DATE] which i held at [LOCATION]. Location details are:</p>\n\t\t<p>[LOCATION_DETAILS]</p>\n\t\t<p>Your info is:</p>\n\t\t<p>[ADDRESS]<br />[ADDRESS2]<br />[CITY], [STATE] [ZIP]<br />[COUNTRY]<br />[ORGANIZATION]<br />Phone: [PHONE]<br /> Email: [EMAIL]<br /></p>\n\t\t<p>There are [GROUP_NUMBER] people in your group:</p>\n\t\t<p>{GROUP_MEMBER}<br /> [TITLE] [FIRSTNAME] [LASTNAME]<br /> [ADDRESS]<br /> [ADDRESS2]<br /> [CITY], [STATE] [ZIP]<br /> [COUNTRY]<br /> Phone: [PHONE]<br /> Email: [EMAIL]<br /> {/GROUP_MEMBER}</p>\n\t\t<p>Your registration price total is [AMOUNT]. You have paid [AMOUNT_PAID], which leaves an amount due of [AMOUNT_DUE]. You paid via [PAYMENT_TYPE].</p>\n\t\t<br />\n\t\t<p>Your selected login info is:</p>\n\t\t<p>Username: [USERNAME]<br />Password: [PASSWORD]</p>\n\t\t<p>You registered on [DATE_REGISTERED] and your status is [STATUS] with a payment status of [PAID_STATUS].<br />Confirmation #: [CONFIRM_NUM]</p>\n\t\t<p>Thanks again for registering!</p>\n\t\t<p>Sincerely,</p>\n\t\t<p>Registration Team</p>', 'thanksemail');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(6, 'thanksmsg', 'Thank you for registering for [EVENT_NAME] on [EVENT_DATE]! Your registration is being processed and you will be sent any information that you need for the event. You will also be receiving an email receipt of your registration.', 'thanksmsg');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(7, 'subthanksemail', 'You have registered for [EVENT_NAME]!', 'subthanksemail');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(8, 'terms_conditions_msg', 'Place your terms and conditions message here.', 'terms_conditions_msg');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(9, 'terms_conditions', '1', 'terms_conditions');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(10, 'security_image_check', '1', 'security_image_check');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(11, 'full_message', 'This event is currently full and we are not allowing for any more registrations at this time.  We do apologize for this, but would like to offer you to be added to our Waiting List.  Fill out the following form, then if someone cancels their registration, you will be notified and given the opportunity to become an official registrant.', 'full_message');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(12, 'cut_off_date_message', 'We are no longer accepting registrations for this event. Thank you.', 'cut_off_date_message');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(13, 'waiting_msg', 'You have been added to the Waiting List for this event.  You will be notified if space becomes available. Thank you.', 'waiting_msg');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(14, 'paid_default_status', '0', 'paid_default_status');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(15, 'partial_default_status', '2', 'partial_default_status');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(16, 'paylater_default_status', '2', 'paylater_default_status');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(17, 'prerequisite_event_msg', '<p>Before you can register for this event, you must have already registered for the following event(s): <br />[PREREQ_EVENTS]</p>', 'prerequisite_event_msg');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(18, 'overlap_event_msg', '<p>You can not register for this event because you are already registered for another event at this same time.</p>', 'overlap_event_msg');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(19, 'confirm_number_start', '', 'confirm_number_start');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(20, 'confirm_number_prefix', 'DT-', 'confirm_number_prefix');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(21, 'confirm_number_type', 'random', 'confirm_number_type');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(22, 'prevent_duplication', '0', 'prevent_duplication');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(23, 'godaddy_hosting', '0', 'godaddy_hosting');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(24, 'save_payment_info', '1', 'save_payment_info');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(25, 'event_field_width', '200', 'event_field_width');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(26, 'event_filter_show', '1', 'event_filter_show');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(27, 'event_search_show', '1', 'event_search_show');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(28, 'eventListOrder', '1', 'eventListOrder');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(29, 'event_title_link', 'dtregister', 'event_title_link');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(30, 'sendEmailToGroup', '1', 'sendEmailToGroup');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(31, 'price_column', '1', 'price_column');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(32, 'private_event_msg', 'This event requires that you be a logged in member of this website. Please register a user account to gain access to our private events.', 'private_event_msg');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(33, 'private_event_notification', 'onscreen', 'private_event_notification');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(34, 'private_event_redirect', '', 'private_event_redirect');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(35, 'date_format', '%m-%d-%Y', 'date_format');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(36, 'event_show_date', '1', 'event_show_date');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(37, 'show_past_event', '0', 'show_past_event');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(38, 'show_group_members', '0', 'show_group_members');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(39, 'registrant_message', '<p>Below are the users that have already registered for this event.</p>', 'registrant_message');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(40, 'button_color', 'green', 'button_color');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(41, 'registrant_list', '1', 'registrant_list');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(42, 'registrant_avatar_height', '86', 'registrant_avatar_height');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(43, 'registrant_avatar_width', '60', 'registrant_avatar_width');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(44, 'registrant_cb_linked', '0', 'registrant_cb_linked');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(45, 'registrant_username', '0', 'registrant_username');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(46, 'registrant_registered_date', '1', 'registrant_registered_date');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(47, 'registrant_show_avatar', '0', 'registrant_show_avatar');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(48, 'show_registration_button', '1', 'show_registration_button');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(49, 'linktogoogle', '1', 'linktogoogle');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(50, 'showlocation', '1', 'showlocation');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(51, 'displaytime', '2', 'displaytime');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(52, 'location_img_w', '150', 'location_img_w');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(53, 'location_img_h', '150', 'location_img_h');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(54, 'googlekey', '', 'googlekey');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(55, 'userpanelmessage', 'This is a message at the top of the user's control panel.', 'userpanelmessage');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(56, 'prerequisite_paid', '0', 'prerequisite_paid');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(57, 'prerequisite_attend', '0', 'prerequisite_attend');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(58, 'timecheck', '0', 'timecheck');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(59, 'paid_status_change_msg', 'The payment status of your registration of [EVENT_NAME] has been updated to [PAID_STATUS].', 'paid_status_change_msg');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(60, 'status_change_msg', 'The status of your registration of [EVENT_NAME] has been updated to [STATUS].', 'status_change_msg');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(61, 'paid_status_change_msg_send', '0', 'paid_status_change_msg_send');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(62, 'status_change_msg_send', '0', 'status_change_msg_send');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(63, 'map_cb_fields', '', 'map_cb_fields');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(64, 'map_jomsocial_fields', '', 'map_jomsocial_fields');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(65, 'DT_fromname', '', 'DT_fromname');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(66, 'DT_mailfrom', '', 'DT_mailfrom');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(67, 'month_filter_show', '1', 'month_filter_show');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(68, 'event_date_show', '1', 'event_date_show');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(69, 'barcode_enable', '0', 'barcode_enable');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(70, 'barcode_font_size', '12', 'barcode_font_size');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(71, 'barcode_resolution', '1', 'barcode_resolution');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(72, 'barcodeThick', '30', 'barcodeThick');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(73, 'barcodeDpi', '72', 'barcodeDpi');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(74, 'barcode_image_type', 'png', 'barcode_image_type');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(75, 'barcode_type', 'code39', 'barcode_type');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(76, 'barcode_rotation', '0', 'barcode_rotation');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(77, 'show_price_tax', '0', 'show_price_tax');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(78, 'admin_registrationemail', '<p>A new registration has come in for [EVENT_NAME] on [EVENT_DATE] at [EVENT_TIME]. The registrant is:</p>\n\t\t<p>Name: [FIRSTNAME] [LASTNAME]<br />Address: [ADDRESS]<br />Address2: [ADDRESS2]<br />City: [CITY]<br />State: [STATE] <br />Zip: [ZIP]<br />Country: [COUNTRY]<br />Organization: [ORGANIZATION]<br />Phone: [PHONE]<br /> Email: [EMAIL]</p>\n\t\t<p>[ALL_FIELDS]</p>\n\t\t<p>Number of Members: [GROUP_NUMBER]</p>\n\t\t<p>{GROUP_MEMBER}<br /> [TITLE] [FIRSTNAME] [LASTNAME]<br /> [ADDRESS]<br /> [ADDRESS2]<br /> [CITY], [STATE] [ZIP]<br /> [COUNTRY]<br /> Phone: [PHONE]<br /> Email: [EMAIL]<br />[ALL_FIELDS]<br />{/GROUP_MEMBER}</p>\n\t\t<p>Registration Amount: [AMOUNT]<br />Amount Paid: [AMOUNT_PAID]<br />Payment Method: [PAYMENT_TYPE]</p>\n\t\t<p>Status: [STATUS]<br />Username created: [USERNAME]</p>\n\t\t<p>Confirmation Number: [CONFIRM_NUM]<br />Transaction ID: [TRANS_ID]</p>\n\t\t<p>[BARCODE]</p>', 'admin_registrationemail');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(79, 'calendar_eventTitle_wrap', '1', 'calendar_eventTitle_wrap');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(80, 'calendar_link', '1', 'calendar_link');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(81, 'calendar_showCat', '1', 'calendar_showCat');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(82, 'calendar_showTime', '1', 'calendar_showTime');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(83, 'calendar_startDay', '1', 'calendar_startDay');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(84, 'csv_separator', ',', 'csv_separator');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(85, 'email_cancel_confirm', '', 'email_cancel_confirm');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(86, 'email_change_confirm', '', 'email_change_confirm');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(87, 'event_date_width', '', 'event_date_width');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(88, 'event_list_number', '20', 'event_list_number');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(89, 'event_thumb_height', '150', 'event_thumb_height');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(90, 'event_thumb_width', '150', 'event_thumb_width');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(91, 'eventModifyNotification', '', 'eventModifyNotification');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(92, 'front_link_type', '1', 'front_link_type');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(93, 'frontendEventNotification', '', 'frontendEventNotification');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(94, 'link_moderator_profile', '1', 'link_moderator_profile');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(95, 'pay_later_thk_msg', 'Thank you for registering for [EVENT_NAME] on [EVENT_DATE]! Your registration is being processed and you will be sent any information that you need for the event. You will also be receiving an email receipt of your registration.', 'pay_later_thk_msg');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(96, 'payment_confirm', '', 'payment_confirm');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(97, 'show_fee_breakdown', '1', 'show_fee_breakdown');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(98, 'show_moderator', '1', 'show_moderator');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(99, 'subchangestatusemail', 'Status changed for [EVENT_NAME]', 'subchangestatusemail');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(100, 'subject_admin_registrationemail', 'New [EVENT_NAME] Registration', 'subject_admin_registrationemail');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(101, 'subpaidstatusemail', 'Payment Status changed for [EVENT_NAME]', 'subpaidstatusemail');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(102, 'upanel_amount_show', '1', 'upanel_amount_show');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(103, 'upanel_cancel_show', '1', 'upanel_cancel_show');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(104, 'upanel_due_show', '1', 'upanel_due_show');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(105, 'upanel_edit_show', '1', 'upanel_edit_show');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(106, 'upanel_pay_show', '1', 'upanel_pay_show');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(107, 'upanel_status_show', '1', 'upanel_status_show');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(108, 'upsubcancelemail', 'Cancelled Registration for [EVENT_NAME]', 'upsubcancelemail');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(109, 'upsubchangeemail', 'Changed Registration for [EVENT_NAME]', 'upsubchangeemail');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(110, 'upsubpaymentemail', 'Payment Made for [EVENT_NAME]', 'upsubpaymentemail');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(111, 'show_event_image', '1', 'show_event_image');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(112, 'calendar_show_image_gridview', '0', 'calendar_show_image_gridview');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(113, 'event_image_gridview_width', '60', 'event_image_gridview_width');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(114, 'event_image_gridview_height', '60', 'event_image_gridview_height');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(115, 'calendar_show_popup', '1', 'calendar_show_popup');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(116, 'calendar_show_image', '1', 'calendar_show_image');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(117, 'calendar_show_date', '1', 'calendar_show_date');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(118, 'calendar_show_time', '1', 'calendar_show_time');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(119, 'calendar_show_price', '1', 'calendar_show_price');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(120, 'calendar_show_capacity', '1', 'calendar_show_capacity');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(121, 'calendar_show_registered', '1', 'calendar_show_registered');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(122, 'calendar_show_available_spots', '1', 'calendar_show_available_spots');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(123, 'calendar_show_location', '1', 'calendar_show_location');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(124, 'calendar_show_moderator', '1', 'calendar_show_moderator');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(125, 'waitingemail', '<p>[TITLE] [FIRSTNAME] [LASTNAME],</p>\n\t\t<p>You have joined the Waiting List for [EVENT_NAME] on [EVENT_DATE] which is held at [LOCATION]. Location details are:</p>\n\t\t<p>[LOCATION_DETAILS]</p>\n\t\t<p>Your info is:</p>\n\t\t<p>[ADDRESS]<br />[ADDRESS2]<br />[CITY], [STATE] [ZIP]<br />[COUNTRY]<br />[ORGANIZATION]<br />Phone: [PHONE]<br /> Email: [EMAIL]</p>\n\t\t<p>[ALL_FIELDS]</p>\n\t\t<p>There are [GROUP_NUMBER] people in your group:</p>\n\t\t<p>{GROUP_MEMBER}<br /> [TITLE] [FIRSTNAME] [LASTNAME]<br /> [ADDRESS]<br /> [ADDRESS2]<br /> [CITY], [STATE] [ZIP]<br /> [COUNTRY]<br /> Phone: [PHONE]<br /> Email: [EMAIL]<br />[ALL_FIELDS]<br /> {/GROUP_MEMBER}</p>\n\t\t<p>Your registration price total is  [AMOUNT] and will be required if space becomes available for you.</p>\n\t\t<p>You signed up on the waiting list on [DATE_REGISTERED] and your status is [STATUS].<br />Confirmation #: [CONFIRM_NUM]</p>\n\t\t<p>Thanks again for registering!</p>\n\t\t<p>Sincerely,</p>\n\t\t<p>Registration Team</p>', 'waitingemail');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(126, 'subwaitingemail', 'You are on the Waiting List for [EVENT_NAME]', 'subwaitingemail');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(127, 'event_location_show', '0', 'event_location_show');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(128, 'thanks_redirection', '1', 'thanks_redirection');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(129, 'pay_later_redirection', '1', 'pay_later_redirection');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_config` VALUES(130, 'admin_email_from_user', '0', 'admin_email_from_user');";
        $database->setQuery($sql);
        $database->query();
    }
    // Load default properties into database
    $sql = "Select count(*) From #__dtregister";
    $database->setQuery($sql);
    $total = $database->loadResult();
    if (!$total) {
        $sql = "INSERT INTO `#__dtregister` VALUES(1,'migrate','0');";
        $database->setQuery($sql);
        $database->query();
    }
    // Load default Fields into database
    $sql = "Select count(*) From #__dtregister_fields where `name`\n\t  in('firstname','title','lastname','address','address2','city','state','zip','country','phone','email','organization')";
    $database->setQuery($sql);
    $total = $database->loadResult();
    if ($total < 1) {
        $sql = "delete t1, t2 From #__dtregister_fields t1 left join #__dtregister_field_event t2 on t1.id = t2.field_id where `name`  \n\t   in('firstname','title','lastname','address','address2','city','state','zip','country','phone','email','organization')";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'title','Title','100','','1','1','0','\tMr|Mrs|Ms|Miss|Dr|Rev','1','','0','0','0','','0','','1','1','1','0|0|0|0|0|0','1','','0','0','0','2','0','3','0','','0','','','0','0','0','','0','1','TITLE','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'firstname','First Name','30','','2','1','1','','0','','0','0','0','','0','','1','1','1','','1','','0','0','0','3','1','3','60','','0','','','0','1','0','memberlist|attendeelist|recordlist','0','1','FIRSTNAME','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'lastname','Last Name','30','','3','1','1','','0','','0','0','0','','0','','1','1','1','','1','','0','0','0','3','1','3','100','','0','','','0','1','0','memberlist|attendeelist|recordlist','0','1','LASTNAME','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'address','Address','30','','5','1','0','','0','','0','0','0','','0','','1','1','1','','1','','0','0','0','1','0','0','200','','0','','','0','0','0','memberlist','0','0','ADDRESS','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'address2','Address 2','30','','6','1','0','','0','','0','0','0','','0','','1','1','1','','1','','0','0','0','1','0','0','200','','0','','','0','0','0','memberlist','0','0','ADDRESS2','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'city','City','30','','7','1','1','','0','','0','0','0','','0','','1','1','1','','1','','0','0','0','3','1','3','100','','0','','','0','0','0','memberlist','0','0','CITY','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'state','State','150','','8','1','0','Alabama|Alaska|Arizona|Arkansas|California|Colorado|Connecticut|Delaware|District of Columbia|Florida|Georgia|Hawaii|Idaho|Illinois|Indiana|Iowa|Kansas|Kentucky|Louisiana|Maine|Maryland|Massachusetts|Michigan|Minnesota|Mississippi|Missouri|Montana|Nebraska|Nevada|New Hampshire|New Jersey|New Mexico|New York|North Carolina|North Dakota|Ohio|Oklahoma|Oregon|Pennsylvania|Rhode Island|South Carolina|South Dakota|Tennessee|Texas|Utah|Vermont|Virginia|Washington|West Virginia|Wisconsin|Wyoming','1','','0','0','0','','0','','1','1','1','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','1','','0','0','0','3','1','3','0','','0','','','0','0','0','','0','0','STATE','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'zip','Zip','10','','9','1','0','','0','','0','0','0','','0','','1','1','1','','1','','0','0','0','1','1','3','10','','0','','','0','0','0','','0','0','ZIP','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $text = "Afghanistan|Albania|Algeria|Andorra|Angola|Antigua & Barbuda|Argentina|Armenia|Australia|Austria|Azerbaijan|Bahamas|Bahrain|Bangladesh|Barbados|Belarus|Belgium|Belize|Benin|Bhutan|Bolivia|Bosnia & Herzegovina|Botswana|Brazil|Brunei Darussalam|Bulgaria|Burkina Faso|Burma (Myanmar)|Burundi|Cambodia|Cameroon|Canada|Cape Verde|Cayman Islands|Central African|Chad|Chile|China|Colombia|Comoros|Congo|Congo, Democratic Republic of the|Costa Rica|Côte d'Ivoire|Croatia|Cuba|Cyprus|Czech Republic|Denmark|Djibouti|Dominica|Dominican Republic|Ecuador|East Timor|Egypt|El Salvador|England|Equatorial Guinea|Eritrea|Estonia|Ethiopia|Fiji|Finland|France|Gabon|Gambia, The|Georgia|Germany|Ghana|Great Britain|Greece|Grenada|Guatemala|Guinea|Guinea-Bissau|Guyana|Haiti|Honduras|Hong Kong|Hungary|Iceland|India|Indonesia|Iran|Iraq|Ireland|Israel|Italy|Jamaica|Japan|Jordan|Kazakhstan|Kenya|Kiribati|Kuwait|Kyrgyzstan|Laos|Latvia|Lebanon|Lesotho|Liberia|Libya|Liechtenstein|Lithuania|Luxembourg|Macedonia|Madagascar|Malawi|Malaysia|Maldives|Mali|Malta|Marshall Islands|Mauritania|Mauritius|Mexico|Micronesia|Moldova|Monaco|Mongolia|Montenegro|Morocco|Mozambique|Myanmar|Namibia|Nauru|Nepal|The Netherlands|New Zealand|Nicaragua|Niger|Nigeria|North Korea|Norway|Oman|Pakistan|Palau|Palestinian State|Panama|Papua New Guinea|Paraguay|Peru|Philippines|Poland|Portugal|Qatar|Romania|Russia|Rwanda|St. Kitts & Nevis|St. Lucia|St. Vincent & The Grenadines|Samoa|San Marino|São Tomé & Príncipe|Saudi Arabia|Senegal|Serbia|Seychelles|Sierra Leone|Singapore|Slovakia|Slovenia|Solomon Islands|Somalia|South Africa|South Korea|Spain|Sri Lanka|Sudan|Suriname|Swaziland|Sweden|Switzerland|Syria|Taiwan|Tajikistan|Tanzania|Thailand|Togo|Tonga|Trinidad & Tobago|Tunisia|Turkey|Turkmenistan|Tuvalu|Uganda|Ukraine|United Arab Emirates|United Kingdom|United States|Uruguay|Uzbekistan|Vanuatu|Vatican City|Venezuela|Vietnam|Western Sahara|Yemen|Yugoslavia|Zaire|Zambia|Zimbabwe";
        $text = $database->Quote($text);
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'country','Country','150','','10','1','0'," . $text . ",'1','United States','0','0','0','','0','','1','1','1','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','1','','0','0','0','2','0','3','0','','0','','','0','0','0','','0','0','COUNTRY','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'email','Email','30','','11','1','1','','8','','0','0','0','','0','','1','1','1','','1','','0','0','0','3','1','3','100','','0','','','0','0','1','memberlist|recordlist','0','0','EMAIL','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'phone','Phone','10','','12','1','0','','0','','0','0','0','','0','','1','1','1','','1','','0','0','0','3','1','1','10','','0','','','0','0','0','','0','0','PHONE','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
        $sql = "INSERT INTO `#__dtregister_fields` VALUES(null, 'organization','Organization','30','','4','1','0','','0','','0','0','0','','0','','1','1','1','','1','','0','0','0','1','0','0','200','','0','','','0','0','0','attendeelist','0','0','ORGANIZATION','0');";
        $database->setQuery($sql);
        $database->query();
        echo $database->getErrorMsg();
    }
    // Changes to #__dtregister_field_event
    $sql = "Show columns from #__dtregister_field_event";
    $database->setQuery($sql);
    $rows = $database->loadObjectList();
    $arrFields = array();
    for ($i = 0, $n = count($rows); $i < $n; $i++) {
        $row = $rows[$i];
        $arrFields[] = $row->Field;
    }
    if (in_array('showed', $arrFields)) {
        $sql = "ALTER TABLE `#__dtregister_field_event` CHANGE `showed` `showed` TINYINT(3) DEFAULT NULL";
        $database->setQuery($sql);
        $database->query();
    }
    $query = "insert into #__dtregister_field_event(field_id,event_id,showed) select t3.* , -1 from (SELECT *\nFROM (\n\nSELECT id\nFROM #__dtregister_fields\nWHERE `name`\nIN (\n'firstname', 'title', 'lastname', 'address', 'address2', 'city', 'state', 'zip', 'country', 'phone', 'email', 'organization'\n)\n)t\nJOIN (\n\nSELECT DISTINCT slabId\nFROM `#__dtregister_group_event`\n)t2 ) t3 left join #__dtregister_field_event t4 on t4.field_id = t3.id and t4.event_id = t3.slabId  where t4.event_id is null";
    $database->setQuery($sql);
    $database->query();
    echo $database->getErrorMsg();
    // End of changes to #__dtregister_field_event
    // Load default Permissions options into database
    $sql = "Select count(*) From #__dtregister_acos";
    $database->setQuery($sql);
    $total = $database->loadResult();
    if (!$total) {
        //Insert default data here
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(1,'event','add','DT_EVENT_CREATE','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(2,'event','edit','DT_EDIT_OWN_EVENT','sessionUser');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(3,'event','publish','DT_PUBLISH_EVENT','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(4,'event','delete','DT_DELETE_EVENT','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(5,'event','unpublish','DT_EDIT_OWN_EVENT','sessionUser');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(6,'event','publish','DT_EDIT_OWN_EVENT','sessionUser');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(7,'event','unpublish','DT_PUBLISH_EVENT','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(8,'payoption','delete','DT_EDIT_DELETE_PAYOPTION','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(9,'payoption','edit','DT_EDIT_DELETE_PAYOPTION','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(10,'category','add','DT_CREATE_CATEGORY','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(11,'field','delete','DT_EDIT_DELETE_FIELD','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(12,'field','edit','DT_EDIT_DELETE_FIELD','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(13,'discountcode','add','DT_CREATE_DISCOUNTCODE','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(14,'location','add','DT_CREATE_LOCATION','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(15,'config','index','DT_CONFIG','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(16,'payoption','add','DT_CREATE_PAYOPTION','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(17,'registrantemail','index','DT_EMAIL_REGISTRANT','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(18,'discountcode','delete','DT_EDIT_DELETE_DISCOUNTCODE','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(19,'discountcode','edit','DT_EDIT_DELETE_DISCOUNTCODE','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(20,'field','add','DT_CREATE_FIELD','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(21,'category','delete','DT_EDIT_DELETE_CATEGORY','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(22,'category','edit','DT_EDIT_DELETE_CATEGORY','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(23,'location','delete','DT_EDIT_DELETE_LOCATION','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(24,'location','edit','DT_EDIT_DELETE_LOCATION','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(25,'export','fieldlist','DT_CSV_EXPORT','action');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_acos` VALUES(26,'export','eventlist','DT_CSV_EXPORT','action');";
        $database->setQuery($sql);
        $database->query();
    }
    $sql = "UPDATE `#__dtregister_acos` SET `controller` = 'payoption' WHERE `controller` = 'payment'";
    $database->setQuery($sql);
    $database->query();
    // echo "<br />".$database->getErrorMsg();
    // Load default Joomla User groups into database for Permissions use
    $sql = "Select count(*) From #__dtregister_aros";
    $database->setQuery($sql);
    $total = $database->loadResult();
    if (!$total) {
        $sql = "INSERT INTO `#__dtregister_aros` VALUES(1,'29','joomlaAro','Public Frontend');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_aros` VALUES(2,'18','joomlaAro','Registered');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_aros` VALUES(3,'19','joomlaAro','Author');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_aros` VALUES(4,'20','joomlaAro','Editor');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_aros` VALUES(5,'21','joomlaAro','Publisher');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_aros` VALUES(6,'30','joomlaAro','Public Backend');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_aros` VALUES(7,'23','joomlaAro','Manager');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_aros` VALUES(8,'24','joomlaAro','Administrator');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_aros` VALUES(9,'25','joomlaAro','Super Administrator');";
        $database->setQuery($sql);
        $database->query();
    }
    // Load default Admin Permissions into database
    $sql = "Select count(*) From #__dtregister_permissions";
    $database->setQuery($sql);
    $total = $database->loadResult();
    if (!$total) {
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(1,'9','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(2,'9','3');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(3,'9','7');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(4,'9','4');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(5,'9','10');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(6,'9','22');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(7,'9','21');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(8,'9','20');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(9,'9','12');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(10,'9','11');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(11,'9','13');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(12,'9','19');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(13,'9','18');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(14,'9','14');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(15,'9','24');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(16,'9','23');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(17,'9','15');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(18,'9','17');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(19,'9','16');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(20,'9','9');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(21,'9','8');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(22,'1','2');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(23,'1','5');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(24,'1','6');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(25,'2','2');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(26,'2','5');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(27,'2','6');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(28,'3','2');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(29,'3','5');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(30,'3','6');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(31,'4','2');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(32,'4','5');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(33,'4','6');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(34,'5','2');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(35,'5','5');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(36,'5','6');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(37,'6','2');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(38,'6','5');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(39,'6','6');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(40,'7','2');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(41,'7','5');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(42,'7','6');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(43,'8','2');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(44,'8','5');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(45,'8','6');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(46,'9','25');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_permissions` VALUES(47,'9','26');";
        $database->setQuery($sql);
        $database->query();
    }
    // Load default Pay Later options into database
    $sql = "Select count(*) From #__dtregister_paylater";
    $database->setQuery($sql);
    $total = $database->loadResult();
    if (!$total) {
        $sql = "INSERT INTO `#__dtregister_paylater` VALUES(1,'Pay at the Door');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_paylater` VALUES(2,'Mail in Payment');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_paylater` VALUES(3,'Call in Payment');";
        $database->setQuery($sql);
        $database->query();
    }
    // Load default Pay Option into database
    $sql = "Select count(*) From #__dtregister_payment";
    $database->setQuery($sql);
    $total = $database->loadResult();
    if (!$total) {
        $sql = "INSERT INTO `#__dtregister_payment` VALUES(1,'Default Payment Options','1');";
        $database->setQuery($sql);
        $database->query();
    }
    // Load default Pay Option Config into database
    $sql = "Select count(*) From #__dtregister_payment_config";
    $database->setQuery($sql);
    $total = $database->loadResult();
    if (!$total) {
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(1,'pay_later_options','1,2,3','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(2,'sage_M_id','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(3,'sage_M_key','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(4,'idealLiteHashKey','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(5,'idealLiteMerchantId','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(6,'partner_id','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(7,'eway_customerid','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(8,'ewaytype','hosted','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(9,'paypalid','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(10,'netdeposit_clientcode','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(11,'netdeposit_clientid','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(12,'googleapikey','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(13,'googlemerchid','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(14,'merchid','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(15,'transkey','','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(16,'cardtype','Visa,MasterCard','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(17,'paymentmethod','authorizenet,paypal,pay_later','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(18,'paymentmode','live','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(19,'currency_separator','2','1');";
        $database->setQuery($sql);
        $database->query();
        $sql = "INSERT INTO `#__dtregister_payment_config` VALUES(20,'currency_code','USD','1');";
        $database->setQuery($sql);
        $database->query();
    }
    //Check if the fields exist or not for CB Payment Info Records
    $fieldName = "cb_creditcardnumber";
    //$sql="Select count(*) From #__comprofiler_fields where name='$fieldName'";
    $sql = "SHOW TABLES LIKE '%_comprofiler%'";
    $database->setQuery($sql);
    $database->getQuery();
    $total = $database->loadResult();
    if ($total) {
        //Create CB tabs and CB fields for storing payment data
        $sql = "Select tabid From #__comprofiler_tabs where title='Payment Information'";
        $database->setQuery($sql);
        $tabId = $database->loadResult();
        if (!$tabId) {
            $sql = "INSERT INTO `#__comprofiler_tabs` VALUES ('', 'Payment Information', 'This information is used for online payments on this website.', 107, 10, '.5', 1, NULL, NULL, 1, '', 0, 'tab', 'cb_tabmain', -2);";
            $database->setQuery($sql);
            $database->query();
            $tabId = $database->insertid();
        }
        //Here we will add the additional fields for storing payment information
        $fieldName = "cb_creditcardnumber";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Credit Card Number', 'Enter your card number without any dashes or spaces like aaaabbbbccccdddd', 'text', 16, 16, 0, {$tabId}, 5, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_expdate";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Expiration Date', 'Enter your credit card expiration date as mm/yy', 'text', 5, 5, 0, {$tabId}, 6, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_routingnumber";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'ABA Routing Number', 'Enter your 9-digit routing number for your checking account. Do not use any space or other characters.', 'text', 9, 10, 0, {$tabId}, 3, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_acctnumber";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Bank Account Number', 'Enter your bank account number with no spaces or other characters.', 'text', 0, 0, 0, {$tabId}, 1, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, 0, NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_bankname";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Bank Name', 'Enter the name of your Bank.', 'text', 60, 20, 0, {$tabId}, 2, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_cardtype";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Card Type', 'Please select the type of card you are using.', 'select', 0, 20, 0, {$tabId}, 7, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
            //add values to these type of fields
            $sql = "INSERT INTO `#__comprofiler_field_values` VALUES ('', {$fieldId}, 'Visa', 1, 0);";
            $database->setQuery($sql);
            $database->query();
            $sql = "INSERT INTO `#__comprofiler_field_values` VALUES ('', {$fieldId}, 'MasterCard', 2, 0);";
            $database->setQuery($sql);
            $database->query();
            $sql = "INSERT INTO `#__comprofiler_field_values` VALUES ('', {$fieldId}, 'Discover', 3, 0);";
            $database->setQuery($sql);
            $database->query();
            $sql = "INSERT INTO `#__comprofiler_field_values` VALUES ('', {$fieldId}, 'American Express', 4, 0);";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_accountholder";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Account Holder', 'Enter the name on the bank account.', 'text', 50, 20, 0, {$tabId}, 8, 0, 0, NULL, NULL, 1, 0, 0, 0, 0, 0, NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        ///////////////////////////////////////////////////////////
        //Check if the fields exist or not for Additional User Info
        ///////////////////////////////////////////////////////////
        //Create CB tabs and CB fields for storing user information
        $sql = "Select tabid From #__comprofiler_tabs where title='Additional Info'";
        $database->setQuery($sql);
        $tabId = $database->loadResult();
        if (!$tabId) {
            $sql = "INSERT INTO `#__comprofiler_tabs` VALUES ('', 'Additional Info', 'Additional User contact information', 1, 10, '.5', 1, NULL, NULL, 1, NULL, 0, 'tab', 'cb_tabmain', -2);";
            $database->setQuery($sql);
            $database->query();
            $tabId = $database->insertid();
        }
        $fieldName = "cb_title";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Title', '', 'text', 0, 0, 0, '{$tabId}', 7, 0, 0, NULL, NULL, 1, 1, 1, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_address";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Address', '', 'text', 0, 0, 0, '{$tabId}', 7, 0, 0, NULL, NULL, 1, 1, 1, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_address2";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Address 2', '', 'text', 0, 0, 0, '{$tabId}', 7, 0, 0, NULL, NULL, 1, 1, 1, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        //Here we will begin adding fields for additional user info
        $fieldName = "cb_website";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Website', '', 'webaddress', 0, 0, 0, '{$tabId}', 1, 0, 0, NULL, NULL, 1, 0, 1, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_company";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Company', '', 'text', 0, 0, 0, '{$tabId}', 2, 0, 0, NULL, NULL, 1, 1, 1, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_phone";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Phone', '', 'text', 0, 0, 0, '{$tabId}', 8, 0, 0, NULL, NULL, 1, 1, 1, 0, 0, 0, NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_city";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'City', '.', 'text', 0, 0, 0, '{$tabId}', 3, 0, 0, NULL, NULL, 1, 1, 1, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_state";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'State', '', 'text', 10, 4, 0, '{$tabId}', 4, 0, 0, NULL, NULL, 1, 1, 1, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_zipcode";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Zip Code', '', 'text', 0, 0, 0, '{$tabId}', 5, 0, 0, NULL, NULL, 1, 1, 1, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
        $fieldName = "cb_country";
        $sql = "Select count(*) From #__comprofiler_fields where name='{$fieldName}'";
        $database->setQuery($sql);
        $total = $database->loadResult();
        if (!$total) {
            //Add the fields to this table
            $sql = "INSERT INTO #__comprofiler_fields(`fieldid`,`name`,`table`,`title`,`description`,`type`,`maxlength`,`size`,`required`,`tabid`,`ordering`,`cols`,`rows`,`value`,`default`,`published`,`registration`,`profile`,`readonly`,`calculated`,`sys`,`params`) VALUES ('', '{$fieldName}', '#__comprofiler', 'Country', '', 'text', 0, 0, 0, '{$tabId}', 6, 0, 0, NULL, NULL, 1, 1, 1, 0, 0, 0,  NULL);";
            $database->setQuery($sql);
            $database->query();
            $fieldId = $database->insertid();
            //Add this field to #___comprofiler table
            $sql = "Alter table #__comprofiler add `{$fieldName}` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL";
            $database->setQuery($sql);
            $database->query();
        }
    }
    include_once JPATH_SITE . DS . 'administrator' . DS . 'components' . DS . 'com_dtregister' . DS . 'lib' . DS . 'defines.php';
    include_once JPATH_SITE . DS . 'administrator' . DS . 'components' . DS . 'com_dtregister' . DS . 'lib' . DS . 'dtmodel.php';
    include_once JPATH_SITE . DS . 'administrator' . DS . 'components' . DS . 'com_dtregister' . DS . 'lib' . DS . 'dttable.php';
    include_once JPATH_SITE . DS . 'administrator' . DS . 'components' . DS . 'com_dtregister' . DS . 'models' . DS . 'migration.php';
    include_once JPATH_SITE . DS . 'administrator' . DS . 'components' . DS . 'com_dtregister' . DS . 'models' . DS . 'event.php';
    include_once JPATH_SITE . DS . 'administrator' . DS . 'components' . DS . 'com_dtregister' . DS . 'models' . DS . 'user.php';
    include_once JPATH_SITE . DS . 'administrator' . DS . 'components' . DS . 'com_dtregister' . DS . 'models' . DS . 'member.php';
    include_once JPATH_SITE . DS . 'administrator' . DS . 'components' . DS . 'com_dtregister' . DS . 'models' . DS . 'dtregister.php';
    $migrate = DtrModel::getInstance('migration', 'DtregisterModel');
    $tables = $database->getTableList();
    $table_name = $database->getPrefix() . "dtregister_rollback_group_event";
    $rollbackthere = !in_array($table_name, $tables);
    $newTable = $database->getPrefix() . "dtregister_group_event";
    $freshinstall = !in_array($newTable, $tables);
    $dtreg = DtrModel::getInstance('dtregister', 'DtregisterModel');
    if ($rollbackthere && !$dtreg->migrated && !$freshinstall) {
        $migrate->backupForRollback();
        //$migrate->event();
        //$migrate->usertable();
    } elseif (!$dtreg->migrated && !$freshinstall) {
        //$migrate->fix_migration();
    }
    $migrate->TableUser->renamefield('userType', 'type');
    $offset = $migrate->get_jevent_offset();
    if ($offset === 0) {
        $offset = " + 0 ";
    } elseif ($offset < 0) {
        $offset = " - " . abs($offset);
    } elseif ($offset > 0) {
        $offset = " + " . abs($offset);
    }
    $query = "update #__dtregister_group_event e inner join  #__dtregister_rollback_group_event re on \n\nre.slabId = e.slabId inner join #__jevents_vevdetail j on re.eventId=j.evdet_id set \n\ne.title = \n\t\t\tj.summary ,  e.dtstart = FROM_UNIXTIME(j.dtstart " . $offset . " ,'%Y-%m-%d') , \n\ne.dtstarttime = FROM_UNIXTIME(j.dtstart " . $offset . " ,'%H:%i:%s') , \n\t\t\te.dtend =  FROM_UNIXTIME(j.dtend " . $offset . " ,'%Y-%m-%d') , e.dtendtime = \n\nFROM_UNIXTIME(j.dtend " . $offset . " ,'%H:%i:%s') where e.title is null or e.title = ''";
    $database->setQuery($query);
    $database->query();
    // echo $database->getErrorMsg();
    // Onscreen text after successful installation
    if (!is_dir('../images/dtregister/locations/')) {
        print "<font color=red>Failed to create folder /images/dtregister/locations/  <br />Please create this directory manually and make sure it is writable.</font><br />";
    }
    echo "<p><b>DT Register component Installed Successfully!</b></p>";
    echo "<p>To create your landing page for registration and list your events, simply create a Component menu item for DT Register.\n\n<br /><br /></p>";
    echo "<p>\n\n<br /></p>";
    echo "<p>Be sure to check our website at <a href=\"http://www.dthdevelopment.com\" target=\"_blank\">www.DTHDevelopment.com</a> for video tutorials and other support.\n\n<br /><br /></p>";
}