public function display($tpl = null) { $document = JFactory::getDocument(); $document->addStyleSheet('components/com_mijosql/assets/css/mijosql.css'); // Toolbar JToolBarHelper::title(JText::_('MijoSQL') . ' - ' . JText::_('COM_MIJOSQL_RUN_QUERY'), 'mijosql'); if (MijosqlHelper::is30()) { JToolBarHelper::custom('run', 'play.png', 'play.png', JText::_('COM_MIJOSQL_RUN_QUERY'), false); JToolBarHelper::divider(); JToolBarHelper::custom('savequery', 'folder-close.png', 'folder-close.png', JText::_('COM_MIJOSQL_SAVE_QUERY'), false); JToolBarHelper::divider(); JToolBarHelper::custom('csv', 'upload.png', 'upload.png', JText::_('COM_MIJOSQL_EXPORT_CSV'), false); } else { JToolBarHelper::custom('run', 'run.png', 'run.png', JText::_('COM_MIJOSQL_RUN_QUERY'), false); JToolBarHelper::divider(); JToolBarHelper::custom('savequery', 'savequery.png', 'savequery.png', JText::_('COM_MIJOSQL_SAVE_QUERY'), false); JToolBarHelper::divider(); JToolBarHelper::custom('csv', 'csv.png', 'csv.png', JText::_('COM_MIJOSQL_EXPORT_CSV'), false); } // ACL if (version_compare(JVERSION, '1.6.0', 'ge') && JFactory::getUser()->authorise('core.admin', 'com_mijosql')) { JToolBarHelper::divider(); JToolBarHelper::preferences('com_mijosql', '550'); } $this->data = $this->get('Data'); $this->tables = $this->get('Tables'); $this->prefix = $this->get('Prefix'); parent::display($tpl); }
public function getFields() { $table = MijosqlHelper::getVar('tbl'); if (MijosqlHelper::is30()) { $fields = $this->_db->getTableColumns($table); } else { $fields = $this->_db->getTableFields(array($table)); } return $fields; }
public function delete($table) { $sql = MijosqlHelper::getVar('qry'); $key = JRequest::getString('key', null, 'get'); if (!is_null($sql) && !is_null($key)) { $id = JRequest::getCmd('id', null, 'get'); $this->_db->setQuery("DELETE FROM {$table} WHERE {$key} = '{$id}'"); $this->_db->query(); if (!empty($this->_db->_errorMsg)) { echo '<small style="color:red;">' . $this->_db->_errorMsg . '</small><br/>'; return false; } else { return true; } } }
public function display($tpl = null) { $db = JFactory::getDbo(); $task = JRequest::getCmd('task'); $table = MijosqlHelper::getVar('tbl'); $query = MijosqlHelper::getVar('qry'); $id = JRequest::getInt('id', JRequest::getInt('id', null, 'post'), 'get'); $key = JRequest::getCmd('key', JRequest::getCmd('key', null, 'post'), 'get'); $document =& JFactory::getDocument(); $document->addStyleSheet('components/com_mijosql/assets/css/mijosql.css'); // Toolbar JToolBarHelper::title(JText::_('MijoSQL') . ': <small><small> ' . $table . ' [ ' . $key . ' = ' . $id . ' ]' . ' </small></small>', 'mijosql'); JToolBarHelper::apply(); JToolBarHelper::save(); JToolBarHelper::divider(); JToolBarHelper::cancel(); if ($task == 'edit') { $fld_value = '$value = $this->rows[$this->id][$field];'; } else { $fld_value = '$value = "";'; } list($rows, $last_key_vol) = $this->get('Data'); $this->task = $task; $this->id = $id; $this->key = $key; $this->table = $table; $this->query = $query; $this->fld_value = $fld_value; $this->last_key_vol = $last_key_vol; $this->rows = $rows; $fields = $this->get('Fields'); if (!MijosqlHelper::is30()) { $fields = $fields[$this->table]; } $this->fields = $fields; parent::display($tpl); }
?> </select> <?php echo JText::_('COM_MIJOSQL_RECORDS') . ': '; ?> <input class="text_area" type="text" size="3" id="ja_lim_p" name="ja_lim_p" value="<?php echo JRequest::getInt('ja_lim_p', 10, 'post'); ?> " style="width:30px;" onchange="changeQuery(this);"> </td> </tr> <tr> <td> <textarea class="text_area" id="ja_qry_p" name="ja_qry_p" style="width:100%;height:70px;"><?php echo MijosqlHelper::getVar('qry'); ?> </textarea> </td> </tr> </table> <?php echo $this->data; ?> <input type="hidden" name="option" value="com_mijosql" /> <input type="hidden" name="controller" value="mijosql" /> <input type="hidden" name="task" value=""> <?php echo JHTML::_('form.token');
<?php /** * @package MijoSQL * @copyright 2009-2012 Mijosoft LLC, www.mijosoft.com * @license GNU/GPL http://www.gnu.org/copyleft/gpl.html */ // No Permission defined('_JEXEC') or die('Restricted access'); require_once JPATH_COMPONENT . '/helpers/helper.php'; JHTML::_('behavior.switcher'); if (JRequest::getInt('hidemainmenu') != 1) { JSubMenuHelper::addEntry(JText::_('COM_MIJOSQL_RUN_QUERY'), 'index.php?option=com_mijosql', MijosqlHelper::isActiveSubMenu('query')); JSubMenuHelper::addEntry(JText::_('COM_MIJOSQL_SAVED_QUERIES'), 'index.php?option=com_mijosql&controller=queries', MijosqlHelper::isActiveSubMenu('queries')); }
</td> <td width="80%"> <?php if ($this->key == $field && $this->task == 'edit') { echo $this->id . MijosqlHelper::renderHtml($field, 'hidden', $this->id) . ' [ ' . $type . ' ]'; } else { if ($this->key == $field && $this->task == 'new') { if (is_numeric($this->last_key_vol)) { $value = $this->last_key_vol + 1; } else { $value = $this->last_key_vol . '_1'; } } else { eval($this->fld_value); } echo MijosqlHelper::renderHtml($field, $type, $value) . ' [ ' . $type . ' ]'; } ?> </td> </tr> <?php $k = 1 - $k; } ?> </table> <input type="hidden" name="option" value="com_mijosql" /> <input type="hidden" name="controller" value="edit" /> <input type="hidden" name="task" value=""> <input type="hidden" name="id" value="<?php echo $this->id;