function edit_query() { $mainframe = JFactory::getApplication(); $user = JFactory::getUser(); $db = JFactory::getDBO(); $id = JRequest::getVar('id'); $query_id = JRequest::getVar('query_id'); $query = "SELECT `created_by` FROM #__formmaker where id=" . $db->escape((int) $id); $db->setQuery($query); $created_by = $db->loadResult(); $canEdit = $user->authorise('core.edit', 'com_formmaker'); $canEditOwn = $user->authorise('core.edit.own', 'com_formmaker'); if (!$canEdit) { if (!$canEditOwn || $created_by != $user->id) { $mainframe->redirect("index.php?option=com_formmaker", JText::_('JACTION_NOT_PERMITTED'), 'error'); } } $query = "SELECT label_order_current FROM #__formmaker where id=" . $db->escape((int) $id); $db->setQuery($query); $label = $db->loadResult(); $query = "SELECT * FROM #__formmaker_query where id=" . $db->escape((int) $query_id); $db->setQuery($query); $query_obj = $db->loadObject(); $temp = explode('***wdfcon_typewdf***', $query_obj->details); $con_type = $temp[0]; $temp = explode('***wdfcon_methodwdf***', $temp[1]); $con_method = $temp[0]; $temp = explode('***wdftablewdf***', $temp[1]); $table_cur = $temp[0]; $temp = explode('***wdfhostwdf***', $temp[1]); $host = $temp[0]; $temp = explode('***wdfportwdf***', $temp[1]); $port = $temp[0]; $temp = explode('***wdfusernamewdf***', $temp[1]); $username = $temp[0]; $temp = explode('***wdfpasswordwdf***', $temp[1]); $password = $temp[0]; $temp = explode('***wdfdatabasewdf***', $temp[1]); $database = $temp[0]; $db = JFactory::getDBO(); if ($con_type == 'local') { $query = "SHOW TABLES"; $db->setQuery($query); $tables = $db->loadColumn(); } if ($con_type == 'remote') { $remote = array(); //prevent problems $remote['driver'] = 'mysql'; $remote['host'] = $host; $remote['user'] = $username; $remote['password'] = $password; $remote['database'] = $database; $remote['prefix'] = ''; $db = JDatabase::getInstance($remote); if ($db->getErrorNum()) { echo '<div style="font-size: 22px; text-align: center; padding-top: 15px;">' . $db->stderr() . '</div>'; return false; } $query = "SHOW TABLES"; $db->setQuery($query); $tables = $db->loadColumn(); } $query = "SHOW COLUMNS FROM " . $table_cur; $db->setQuery($query); $table_struct = $db->loadObjectList(); HTML_contact::edit_query($id, $label, $query_obj, $tables, $table_struct, $con_type, $con_method, $table_cur, $temp[1], $host, $port, $username, $password, $database); }