Add IF NOT EXISTS to CREATE DATABASE query (RFE #1608372), reload navigation after...
[phpmyadmin/crack.git] / server_processlist.php
blobf2305f52006bef888756d711934a05366162eae7
1 <?php
2 /* $Id$ */
3 // vim: expandtab sw=4 ts=4 sts=4:
5 require_once('./libraries/common.lib.php');
7 /**
8 * Does the common work
9 */
10 require_once('./libraries/server_common.inc.php');
13 /**
14 * Kills a selected process
16 if (!empty($kill)) {
17 if (PMA_DBI_try_query('KILL ' . $kill . ';')) {
18 $message = sprintf($strThreadSuccessfullyKilled, $kill);
19 } else {
20 $message = sprintf($strCouldNotKill, $kill);
25 /**
26 * Displays the links
28 require('./libraries/server_links.inc.php');
31 /**
32 * Displays the sub-page heading
34 echo '<h2>' . "\n"
35 . ($cfg['MainPageIconic'] ? '<img class="icon" src="' . $pmaThemeImage . 's_process.png" width="16" height="16" alt="" />' : '' )
36 . $strProcesslist . "\n"
37 . '</h2>' . "\n";
40 /**
41 * Sends the query
43 $sql_query = 'SHOW' . ( empty( $full ) ? '' : ' FULL' ) . ' PROCESSLIST';
44 $result = PMA_DBI_query($sql_query);
46 PMA_showMessage( $GLOBALS['strSuccess'] );
49 /**
50 * Displays the page
53 <table id="tableprocesslist" class="data">
54 <thead>
55 <tr><td><a href="./server_processlist.php?<?php echo $url_query . (empty($full) ? '&amp;full=1' : ''); ?>"
56 title="<?php echo empty($full) ? $strShowFullQueries : $strTruncateQueries; ?>">
57 <img src="<?php echo $pmaThemeImage . 's_' . (empty($full) ? 'full' : 'partial'); ?>text.png"
58 width="50" height="20" alt="<?php echo empty($full) ? $strShowFullQueries : $strTruncateQueries; ?>" />
59 </a></td>
60 <th><?php echo $strId; ?></th>
61 <th><?php echo $strUser; ?></th>
62 <th><?php echo $strHost; ?></th>
63 <th><?php echo $strDatabase; ?></th>
64 <th><?php echo $strCommand; ?></th>
65 <th><?php echo $strTime; ?></th>
66 <th><?php echo $strStatus; ?></th>
67 <th><?php echo $strSQLQuery; ?></th>
68 </tr>
69 </thead>
70 <tbody>
71 <?php
72 $odd_row = true;
73 while($process = PMA_DBI_fetch_assoc($result)) {
75 <tr class="<?php echo $odd_row ? 'odd' : 'even'; ?>">
76 <td><a href="./server_processlist.php?<?php echo $url_query . '&amp;kill=' . $process['Id']; ?>"><?php echo $strKill; ?></a></td>
77 <td class="value"><?php echo $process['Id']; ?></td>
78 <td><?php echo $process['User']; ?></td>
79 <td><?php echo $process['Host']; ?></td>
80 <td><?php echo (( ! isset( $process['db'] ) || ! strlen($process['db']) ) ? '<i>' . $strNone . '</i>' : $process['db']); ?></td>
81 <td><?php echo $process['Command']; ?></td>
82 <td class="value"><?php echo $process['Time']; ?></td>
83 <td><?php echo (empty($process['State']) ? '---' : $process['State']); ?></td>
84 <td><?php echo (empty($process['Info']) ? '---' : PMA_SQP_formatHtml(PMA_SQP_parse($process['Info']))); ?></td>
85 </tr>
86 <?php
87 $odd_row = ! $odd_row;
90 </tbody>
91 </table>
92 <?php
94 /**
95 * Sends the footer
97 require_once('./libraries/footer.inc.php');