Lines Matching +full:q +full:- +full:touch
5 * @license GPL 2 http://www.gnu.org/licenses/gpl-2.0.html
29 * @return int Sort order - Low numbers go before high numbers
42 …$this->Lexer->addSpecialPattern ( '\{\{simplemysqlclient\}\}', $mode, 'plugin_simplemysqlclient_si…
46 // $this->Lexer->addExitPattern('</FIXME>','plugin_simplemysqlclient_simplemysqlclient');
84 $renderer->info ['cache'] = false;
86 if (! $this->isAuthorized ()) {
87 echo '<div class="error">' . $this->getLang ( 'missingpermission' ) . '</div>';
91 $button = $this->getLang ( 'submit_button' );
94 if(isset($_GET ['q']))
95 $query = trim ( $_GET ['q'] );
101 $shortcuts = $this->getShortCuts ();
102 $templates = $this->getTemplates ();
104 $emptyresult = $this->getLang ( 'emptyresult' );
107 <script type="text/javascript"><!--
110 with ( document.simplemysqlclient.q )
118 //--></script>
130 <textarea name="q" rows="5" cols="100" style="width: 100%;">$queryEsc</textarea>
135 <script type="text/javascript"><!--
136 document.simplemysqlclient.q.focus();
137 document.simplemysqlclient.q.select();
138 //--></script>
143 <div style="padding-top: 1em; margin-top: 1em; border-top: 1px solid #888888;">
148 $db = $this->connectToDb ();
151 echo '<div class="error">' . $this->getLang ( 'errordbconnection' ) . '</div>';
154 if ($db->multi_query ( $query )) {
155 echo '<u>' . $this->getLang ( 'firstresult' ) . '</u><br>';
157 $result = $db->store_result ();
160 $rows = $this->fetch_all( $result);
162 echo $this->getLang ( 'emptyresult' );
166 echo $this->__renderTable ( $cols, $rows );
168 echo '<div class="error">' . $e->getMessage () . '</div>';
170 $result->free ();
174 …echo $this->getLang ( 'queryexecuted' ) . ($err != 0 ? $this->getLang ( 'no' ) : $this->getLang ( …
178 if ($db->more_results ()) {
179 echo '<br><u>' . $this->getLang ( 'nextresult' ) . '</u><br>';
181 } while ( $db->next_result () );
183 echo $this->getLang ( 'queriesnotexecuted' );
186 echo '<div class="error">' . $e->getMessage () . '</div>';
189 $db->close ();
211 * - collect header row according to listed rows
212 * - transform all listed rows to properly defined HTML table cells
231 $value = $this->valueFromDB ( $column, $value, $def );
233 $cell = $this->renderValue ( $column, $value, $def, false, false );
246 if ($nr == count ( $rows ) - 1)
274 // --> might be an alias definition
275 // --> extract originally selected column name from that
305 $width = intval ( $this->options ['width'] ) ? ' width="' . $this->options ['width'] . '"' : '';
307 $trClass = $this->options ['wikistyle'] ? '' : ' class="data-list"';
308 $tableClass = $this->options ['wikistyle'] ? ' class="inline"' : '';
311 <div style="overflow-x: scroll;">
342 // externally provided file --> don't touch
347 // externally provided file --> don't touch
352 'name' => substr ( $value, $a + 1, $b - $a - 1 ),
356 if (! preg_match ( '#^[a-z0-9-]+/[+a-z0-9-]+$#i', $temp ['mime'] ))
357 // externally provided file --> don't touch
361 // externally provided file --> don't touch
370 if ((trim ( $value ) === '') || ($value == '0000-00-00'))
383 …if ((trim ( $value ) === '') || ($value == '0000-00-00T00:00:00') || ($value == '0000-00-00 00:00:…
439 $remoteUser = $INPUT->server->str ( 'REMOTE_USER' );
447 $allowedUserGroups = $this->getConf ( 'allowedUserGroups' );
480 return '<span class="info">' . $this->getLang ( 'fileexternalfound' ) . '</span>';
482 return '<span class="info">' . $this->getLang ( 'fileexternalnotfound' ) . '</span>';
491 …return "<img src=\"$url\" alt=\"" . sprintf ( $this->getLang ( 'fileimagealt' ), $column, $value […
493 …return "<a href=\"$url\" title=\"" . $this->getLang ( 'filedlhint' ) . '">' . $this->getLang ( 'cm…
525 return strftime ( strtok ( trim ( $this->getConf ( 'dformat' ) ), ' ' ), $value );
531 return strftime ( $this->getConf ( 'dformat' ), $value );
534 if ($value && (substr ( $value, - 3 ) == ':00') && (strlen ( $value ) > 5))
535 $value = substr ( $value, 0, - 3 );
559 $ret = '<u><b>' . $this->getLang ( 'templatesLabel' ) . '</b></u><br>';
561 $text = $this->getLang ( 'template.1.text' );
567 $text = $this->getLang ( 'template.' . $i . '.text' );
572 $sql = $this->getLang ( 'template.' . $i . '.sql' );
579 $ret = '<u><b>' . $this->getLang ( 'shortcutslabel' ) . '</b></u><br>';
581 $text = $this->getLang ( 'shortcut.1.text' );
587 $text = $this->getLang ( 'shortcut.' . $i . '.text' );
592 $sql = $this->getLang ( 'shortcut.' . $i . '.sql' );
593 $sql = str_replace ( '#DATABASENAME#', $this->getConf ( 'dbName' ), $sql );
599 private function connectToDb() { // DB-Verbindung herstellen - eRent
600 $serverName = $this->getConf ( 'serverName' );
601 $userName = $this->getConf ( 'userName' );
602 $passWord = $this->getConf ( 'passWord' );
603 $dbName = $this->getConf ( 'dbName' );
608 mysqli_select_db ( $dbCon, $dbName ); // DB-Auswahl