function view_submissions() { $db = JFactory::getDBO(); $form_id = JRequest::getVar('form_id'); $after_save = JRequest::getVar('after_save', 0); $paypal = 0; $query = "SELECT DISTINCT `element_label` FROM #__formmaker_submits WHERE form_id='" . $db->escape((int) $form_id) . "'"; $db->setQuery($query); $labels = $db->loadColumn(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } $query = "SELECT id FROM #__formmaker_sessions where form_id=" . $db->escape((int) $form_id); $db->setQuery($query); $paypal_info = $db->loadObject(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } if ($paypal_info) { $paypal = 1; } $sorted_labels_id = array(); $label_titles = array(); $sorted_labels_type = array(); if ($labels) { $label_id = array(); $label_order = array(); $label_order_original = array(); $label_type = array(); $this_form = JTable::getInstance('formmaker', 'Table'); $this_form->load($form_id); if (strpos($this_form->label_order, 'type_paypal_')) { $this_form->label_order = $this_form->label_order . "item_total#**id**#Item Total#**label**#type_paypal_payment_total#****#total#**id**#Total#**label**#type_paypal_payment_total#****#0#**id**#Payment Status#**label**#type_paypal_payment_status#****#"; } $label_all = explode('#****#', $this_form->label_order); $label_all = array_slice($label_all, 0, count($label_all) - 1); foreach ($label_all as $key => $label_each) { $label_id_each = explode('#**id**#', $label_each); array_push($label_id, $label_id_each[0]); $label_order_each = explode('#**label**#', $label_id_each[1]); array_push($label_order_original, $label_order_each[0]); array_push($label_type, $label_order_each[1]); } foreach ($label_id as $key => $label) { if (in_array($label, $labels)) { array_push($sorted_labels_type, $label_type[$key]); array_push($sorted_labels_id, $label); array_push($label_titles, $label_order_original[$key]); } } } HTML_contact::view_submissions($label_titles, $form_id, $sorted_labels_id, $sorted_labels_type, $after_save, $paypal); }