<?php
/*
Copyright (C)
This program is free software; you can redistribute it and/or modify it
under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option)
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
$connection = @mssql_connect($_SESSION['datasource_name'], $_SESSION['datasource_username'], $_SESSION['datasource_password']) or die(throwSQLError('general connection failure to the database'));
if (!empty($_GET['dbname'])) {
$db = urldecode($_GET['dbname']);
mssql_select_db($db);
$_SESSION['database'] = $db;
}
<td align="center" style="background: #D0DCE0">
<input type="submit" value="Run Query">
</td>
</tr>
</table>
</form>
<script language="javascript">
document.form1.query.focus();
</script>
<?php
if ($_POST['query'] == '') {
include 'inc/footer.php';
}
mssql_select_db($_SESSION['database']);
$data_query = @mssql_query($_POST['query']) or die(throwSQLError('unable to complete query'));
echo '<table width="' . $_SETTINGS['mobilescreenwidth'] . '" cellpadding="2" cellspacing="0" style="border: 1px solid">';
$toggle = true;
$colors = array('#DDDDDD', '#CCCCCC');
$isempty = true;
$fields = array();
if (mssql_num_rows($data_query) > 0) {
while ($row = mssql_fetch_array($data_query)) {
if ($isempty) {
$isempty = false;
}
if ($toggle) {
$bg = $colors[0];
} else {
$bg = $colors[1];
}
under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option)
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
mssql_select_db($_SESSION['database']);
$data_query = @mssql_query('sp_helptext \'' . urldecode($_GET['procedure']) . '\'') or die(throwSQLError('unable to retrieve procedure'));
if (!@mssql_num_rows($data_query)) {
$schema_query = @mssql_query('SELECT SPECIFIC_SCHEMA FROM INFORMATION_SCHEMA.ROUTINES WHERE SPECIFIC_NAME = \'' . urldecode($_GET['procedure']) . '\';');
if ($schema_query) {
$schema_array = mssql_fetch_array($schema_query);
if ($schema_array['SPECIFIC_SCHEMA'] != 'dbo') {
$_GET['procedure'] = $schema_array['SPECIFIC_SCHEMA'] . '.' . urldecode($_GET['procedure']);
}
}
}
@mssql_query('DROP PROCEDURE ' . urldecode($_GET['procedure']) . ';') or die(throwSQLError('unable to delete procedure'));
if (empty($_GET['returnto'])) {
$_GET['returnto'] = 'database_properties.php';
}
echo '<meta http-equiv="refresh" content="0;url=' . $_GET['returnto'] . '">';
include 'inc/footer.php';
This program is free software; you can redistribute it and/or modify it
under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option)
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
$db_info_query = @mssql_query('sp_helpdb') or die(throwSQLError('unable to retrieve databases'));
$dbinfo = array();
while ($row = mssql_fetch_array($db_info_query)) {
if (!in_array($row['name'], $_SETTINGS['dbexclude'])) {
$dbinfo[] = $row['name'] . ':' . number_format($row['db_size'], 2);
}
}
?>
<table width="90%">
<tr>
<td align="left" valign="top" width="45%">
<form name="form1" method="post" action="database_create.php?step=1">
<table cellpadding="5" cellspacing="0" width="100%" style="border: 1px solid; border-color: black">
<tr>
<td align="center" colspan="2" style="background: #D0DCE0; border-bottom: 1px solid">
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
mssql_select_db($_SESSION['database']);
if (!empty($_POST['query'])) {
if (!@mssql_query($_POST['query'])) {
throwSQLError('unable to create trigger');
} else {
echo '<meta http-equiv="refresh" content="0;url=database_properties.php">';
include 'inc/footer.php';
}
} else {
$_POST['query'] = 'CREATE TRIGGER NewTrig;';
}
?>
<form name="form1" method="post" action="trigger_create.php">
<table cellpadding="3" cellspacing="3" style="border: 1px solid">
<tr>
<td align="center" style="background: #D0DCE0">
<b>Create Trigger</b>
</td>
</tr>
<b>Triggers</b>
</td>
</tr>
<tr>
<td style="background: #D0DCE0"> </td>
<td align="center" style="background: #D0DCE0">
<b>Name</b>
</td>
<td align="center" colspan="2" style="background: #D0DCE0">
<b>Action</b>
</td>
</tr>
<?php
$toggle = true;
$colors = array('#DDDDDD', '#CCCCCC');
$trig_query = @mssql_query('sp_helptrigger \'' . urldecode($_GET['table']) . '\'') or die(throwSQLError('unable to retrieve list of stored procedures'));
while ($row = mssql_fetch_assoc($trig_query)) {
if ($row['trigger_schema'] != '') {
$fullname = $row['trigger_schema'] . '.' . $row['trigger_name'];
} else {
$fullname = $row['trigger_name'];
}
if ($toggle) {
$bg = $colors[0];
} else {
$bg = $colors[1];
}
$toggle = !$toggle;
echo '<tr>';
echo '<td align="center" style="background: ' . $bg . '" nowrap><input type="checkbox" name="triggers[]" value="' . $fullname . '"></td>';
echo '<td style="background: ' . $bg . '" nowrap>' . $row['trigger_name'] . '</td>';
@mssql_query($query) or die(throwSQLError('unable to lock database', $query));
$query = 'ALTER DATABASE ' . urldecode($_GET[dbname]) . ' SET READ_ONLY';
@mssql_query($query) or die(throwSQLError('unable to make database READ-ONLY', $query));
$query = 'ALTER DATABASE ' . urldecode($_GET[dbname]) . ' SET MULTI_USER';
@mssql_query($query) or die(throwSQLError('unable to re-enable mutli-user mode on database', $query));
echo '<meta http-equiv="refresh" content="0;url=home.php">';
} else {
if ($confirm == 'readwrite') {
$_SESSION['database'] = 'master';
mssql_select_db('master');
$query = 'ALTER DATABASE ' . urldecode($_GET[dbname]) . ' SET SINGLE_USER';
@mssql_query($query) or die(throwSQLError('unable to lock database', $query));
$query = 'ALTER DATABASE ' . urldecode($_GET[dbname]) . ' SET READ_WRITE';
@mssql_query($query) or die(throwSQLError('unable to make database READ-WRITE', $query));
$query = 'ALTER DATABASE ' . urldecode($_GET[dbname]) . ' SET MULTI_USER';
@mssql_query($query) or die(throwSQLError('unable to re-enable mutli-user mode on database', $query));
echo '<meta http-equiv="refresh" content="0;url=home.php">';
} else {
$status_query = @mssql_query('sp_helpdb') or die(throwError('unable to retrive database information'));
while ($row = mssql_fetch_array($status_query)) {
if ($row['name'] == $_GET['dbname']) {
$status = explode(', ', $row['status']);
foreach ($status as $value) {
$split = explode('=', $value);
if ($split[0] == 'Updateability') {
if ($split[1] == 'READ_WRITE') {
$newmode = 'READ_ONLY';
} else {
$newmode = 'READ_WRITE';
}
}
/*
Copyright (C)
This program is free software; you can redistribute it and/or modify it
under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option)
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
@mssql_select_db($_SESSION['database']) or die(throwSQLError('unable to select database'));
if ($_POST['tables'][0] == '') {
@mssql_query('DROP TABLE ' . urldecode($_GET['table']) . ';') or die(throwSQLError('unable to complete drop'));
} else {
for ($counter = 0; $counter < count($_POST['tables']); $counter++) {
@mssql_query('DROP TABLE ' . urldecode($_POST['tables'][$counter]) . ';') or die(throwSQLError('unable to complete drop'));
}
}
if ($_SESSION['expanded'] != '') {
echo '<script language="javascript">parent.left.location.reload();</script>';
}
echo '<meta http-equiv="refresh" content="0;url=database_properties.php?dbname=' . urlencode($_SESSION['database']) . '">';
include 'inc/footer.php';
$colquery = 'sp_columns @table_name = N\'' . $tablesep[0] . '\'';
}
$column_query = @mssql_query($colquery) or throwSQLError('unable to retrieve column data');
while ($row = mssql_fetch_array($column_query)) {
if (substr_count($row['TYPE_NAME'], 'identity') > 0) {
$idcol = $row['COLUMN_NAME'];
}
}
// END IDENTITY ISOLATION CODE
if (substr($query, -6) == ' WHERE') {
$query = substr($query, 0, -6);
}
if (!empty($_POST['orderbyfield'])) {
$query .= ' ORDER BY ' . $_POST['orderbyfield'] . ' ' . $_POST['orderbyorder'];
}
$data_query = @mssql_query($query) or throwSQLError('unable to complete query', $query);
if ($data_query) {
echo '<table width="300" cellpadding="3" cellspacing="3" style="border: 1px solid">';
$toggle = true;
$colors = array('#DDDDDD', '#CCCCCC');
$isempty = true;
$fields = array();
while ($row = mssql_fetch_array($data_query)) {
if ($isempty) {
$isempty = false;
}
if ($toggle) {
$bg = $colors[0];
} else {
$bg = $colors[1];
}
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
if (!empty($_POST['confirm'])) {
$confirm = $_POST['confirm'];
} else {
$confirm = '';
}
if ($confirm == 'detach') {
$_SESSION['database'] = 'master';
mssql_select_db('master');
$result = @mssql_query('sp_detach_db \'' . urldecode($_POST[dbname]) . '\',\'false\'') or die(throwSQLError('unable to detach database'));
if ($result) {
echo '<script language="javascript">parent.left.location.reload();</script>';
echo '<meta http-equiv="refresh" content="0;url=home.php">';
}
} else {
?>
<form name="form1" method="post" action="database_detach.php?dbname=<?php
echo $_GET['dbname'];
?>
">
<input type="hidden" name="dbname" value="<?php
echo $_GET['dbname'];
?>
">
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
@mssql_select_db($_SESSION['database']) or die(throwSQLError('unable to select database'));
if ($_GET['showall'] != 'yes') {
if (substr_count(urldecode($_GET['table']), '.') > 0) {
$data_query = @mssql_query('SELECT TOP 100 * FROM ' . urldecode($_GET['table'])) or die(throwSQLError('unable to complete query'));
} else {
$data_query = @mssql_query('SELECT TOP 100 * FROM [' . urldecode($_GET['table']) . ']') or die(throwSQLError('unable to complete query'));
}
} else {
if (substr_count(urldecode($_GET['table']), '.') > 0) {
$data_query = @mssql_query('SELECT * FROM ' . urldecode($_GET['table'])) or die(throwSQLError('unable to complete query'));
} else {
$data_query = @mssql_query('SELECT * FROM [' . urldecode($_GET['table']) . ']') or die(throwSQLError('unable to complete query'));
}
}
echo '<table width="' . $_SETTINGS['mobilescreenwidth'] . '" cellpadding="2" cellspacing="0" style="border: 1px solid">';
$toggle = true;
$colors = array('#DDDDDD', '#CCCCCC');
$isempty = true;
$fields = array();
while ($row = mssql_fetch_array($data_query)) {
if ($isempty) {
$isempty = false;
}
if ($toggle) {
$bg = $colors[0];
} else {
$bg = $colors[1];
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
mssql_select_db($_SESSION['database']);
if (!empty($_POST['query'])) {
if (!@mssql_query($_POST['query'])) {
throwSQLError('unable to create procedure');
} else {
echo '<meta http-equiv="refresh" content="0;url=database_properties.php">';
}
} else {
$_POST['query'] = 'CREATE PROCEDURE NewProc;';
}
?>
<form name="form1" method="post" action="procedure_create.php">
<table cellpadding="3" cellspacing="3" style="border: 1px solid">
<tr>
<td align="center" style="background: #D0DCE0">
<b>Create Stored Procedure</b>
</td>
</tr>
<tr>
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
?>
<?php
include 'inc/header.php';
if (empty($_POST['mdf'])) {
$result = @mssql_query('CREATE DATABASE ' . $_POST['dbname']) or die(throwSQLError('unable to create database'));
} else {
if (substr_count($_POST['mdf'], '\\') == 0 || substr_count($_POST['ldf'], '\\') == 0 && $_POST['ldf'] != '') {
mssql_select_db('master');
$path_query = @mssql_query('sp_helpfile') or die(throwSQLError('unable to retrieve file path'));
$path_array = mssql_fetch_array($path_query);
if (substr_count($_POST['mdf'], '\\') == 0) {
$_POST['mdf'] = substr($path_array['filename'], 0, strrpos($path_array['filename'], '\\')) . $_POST['mdf'];
}
if (substr_count($_POST['ldf'], '\\') == 0) {
$_POST['ldf'] = substr($path_array['filename'], 0, strrpos($path_array['filename'], '\\')) . $_POST['ldf'];
}
}
if ($_POST['ldf'] == '') {
$result = @mssql_query('sp_attach_single_file_db \'' . $_POST['dbname'] . '\',\'' . $_POST['mdf'] . '\'') or die(throwSQLError('unable to attach database'));
} else {
$result = @mssql_query('sp_attach_db \'' . $_POST['dbname'] . '\',\'' . $_POST['mdf'] . '\',\'' . $_POST['ldf'] . '\'') or die(throwSQLError('unable to attach database'));
}
}
if ($result) {
echo '<script language="javascript">parent.left.location.reload();</script>';
echo '<meta http-equiv="refresh" content="0;url=database_properties.php?dbname=' . $_POST['dbname'] . '">';
}
include 'inc/footer.php';
$data_query = @mssql_query($_POST['query']) or die(throwSQLError('unable to save view'));
if ($data_query) {
throwSuccess('view saved');
}
} else {
mssql_select_db($_SESSION['database']);
$lines = array();
$doit = false;
$data_query = @mssql_query('sp_helptext \'' . urldecode($_GET['view']) . '\'') or die(throwSQLError('unable to retrieve procedure'));
if (!@mssql_num_rows($data_query)) {
$schema_query = @mssql_query('SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = \'' . urldecode($_GET['view']) . '\';');
if ($schema_query) {
$schema_array = mssql_fetch_array($schema_query);
$_GET['view'] = $schema_array['TABLE_SCHEMA'] . '.' . urldecode($_GET['view']);
unset($data_query);
$data_query = @mssql_query('sp_helptext \'' . $_GET['view'] . '\'') or die(throwSQLError('unable to retrieve view'));
if (@mssql_num_rows($data_query)) {
$doit = true;
}
}
} else {
$doit = true;
}
if ($doit) {
while ($row = mssql_fetch_array($data_query)) {
$lines[] = $row['Text'];
}
} else {
$lines[] = 'I am unable to read this view.';
}
}
/*
Copyright (C)
This program is free software; you can redistribute it and/or modify it
under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option)
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
@mssql_select_db($_SESSION['database']) or die(throwSQLError('unable to select database'));
if (empty($_POST['tablecount'])) {
@mssql_query('DELETE FROM ' . urldecode($_GET['table']) . ';') or die(throwSQLError('unable to complete empty'));
} else {
for ($counter = 0; $counter < $_POST['tablecount']; $counter++) {
if ($_POST['tables'][$counter] == 'yes') {
@mssql_query('DELETE FROM ' . urldecode($_POST['tables'][$counter]) . ';') or die(throwSQLError('unable to complete empty'));
}
}
}
echo '<meta http-equiv="refresh" content="0;url=database_properties.php?dbname=' . urlencode($_SESSION['database']) . '">';
include 'inc/footer.php';
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
if (!empty($_POST['newname'])) {
mssql_select_db($_SESSION['database']);
$query = 'sp_rename \'' . $_POST['oldname'] . '\', \'' . $_POST['newname'] . '\'';
$result = @mssql_query($query) or throwSQLError('unable to renable table', $query);
if ($result) {
echo '<script language="javascript">parent.left.location.reload();</script>';
echo '<meta http-equiv="refresh" content="0;url=database_properties.php">';
exit;
}
} else {
?>
<form name="form1" method="post" action="table_rename.php">
<input type="hidden" name="oldname" value="<?php
echo urldecode($_GET['table']);
?>
">
<table cellpadding="3" cellspacing="3" width="300" style="border: 1px solid">
<tr>
$_SESSION['expanded'] = 'yes';
} else {
$expand = '';
$_SESSION['expanded'] = 'no';
}
$db_query = @mssql_query('sp_databases') or die(throwSQLError('unable to retrieve a list of databases'));
while ($row = mssql_fetch_array($db_query)) {
if (!in_array($row['DATABASE_NAME'], $_SETTINGS['dbexclude'])) {
$encoded = urlencode($row['DATABASE_NAME']);
if ($expand != $encoded) {
echo '<a href="menu.php?expand=' . $encoded . '">+</a> <a href="database_properties.php?dbname=' . $encoded . '" oncontextmenu="javascript:genDBLink(\'' . $encoded . '\');return(false);" target="right">' . $row['DATABASE_NAME'] . '</a><br>';
} else {
echo '<a href="menu.php">+</a> <a href="database_properties.php?dbname=' . $encoded . '" oncontextmenu="javascript:genDBLink(\'' . $encoded . '\');return(false);" target="right">' . $row['DATABASE_NAME'] . '</a><br>';
$_SESSION['database'] = $row['DATABASE_NAME'];
@mssql_select_db($row['DATABASE_NAME']) or die(throwSQLError('unable to select database'));
$table_query = @mssql_query('sp_tables') or die(throwSQLError('unable to retrieve a list of tables'));
while ($row2 = mssql_fetch_array($table_query)) {
if ($row2['TABLE_TYPE'] == 'TABLE' && $row2['TABLE_NAME'] != 'dtproperties' || $_SETTINGS['showsysdata']) {
if ($row2['TABLE_OWNER'] != 'dbo') {
$row2['TABLE_NAME'] = $row2['TABLE_OWNER'] . '.' . $row2['TABLE_NAME'];
}
echo ' - <font size="-1"><a href="table_properties.php?table=' . urlencode($row2['TABLE_NAME']) . '&dbname=' . $_GET['expand'] . '" oncontextmenu="javascript:genTableLink(\'' . urlencode($row2['TABLE_NAME']) . '\',\'' . $_GET['expand'] . '\');return(false);" target="right">' . $row2['TABLE_NAME'] . '</a></font><br>';
}
}
}
}
}
?>
</body>
</html>
Software Foundation; either version 2 of the License, or (at your option)
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
mssql_select_db($_SESSION['database']);
$doit = false;
$data_query = @mssql_query('sp_helptext \'' . urldecode($_GET['view']) . '\'') or die(throwSQLError('unable to retrieve procedure'));
if (!@mssql_num_rows($data_query)) {
$schema_query = @mssql_query('SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = \'' . urldecode($_GET['view']) . '\';');
if ($schema_query) {
$schema_array = mssql_fetch_array($schema_query);
if ($schema_array['TABLE_SCHEMA'] != 'dbo') {
$_GET['view'] = $schema_array['TABLE_SCHEMA'] . '.' . urldecode($_GET['view']);
}
}
}
@mssql_query('DROP VIEW ' . urldecode($_GET['view']) . ';') or die(throwSQLError('unable to delete procedure'));
if ($_GET['returnto'] == '') {
$_GET['returnto'] = 'database_properties.php';
}
echo '<meta http-equiv="refresh" content="0;url=' . $_GET['returnto'] . '">';
include 'inc/footer.php';
if ($data_query) {
throwSuccess('procedure saved');
}
$lines = explode("\n", $_POST['query']);
} else {
mssql_select_db($_SESSION['database']);
$lines = array();
$doit = false;
$data_query = @mssql_query('sp_helptext \'' . urldecode($_GET['procedure']) . '\'') or die(throwSQLError('unable to retrieve procedure'));
if (!@mssql_num_rows($data_query)) {
$schema_query = @mssql_query('SELECT SPECIFIC_SCHEMA FROM INFORMATION_SCHEMA.ROUTINES WHERE SPECIFIC_NAME = \'' . urldecode($_GET['procedure']) . '\';');
if ($schema_query) {
$schema_array = mssql_fetch_array($schema_query);
$_GET['procedure'] = $schema_array['SPECIFIC_SCHEMA'] . '.' . urldecode($_GET['procedure']);
unset($data_query);
$data_query = @mssql_query('sp_helptext \'' . $_GET['procedure'] . '\'') or die(throwSQLError('unable to retrieve procedure'));
if (@mssql_num_rows($data_query)) {
$doit = true;
}
}
} else {
$doit = true;
}
if ($doit) {
while ($row = mssql_fetch_array($data_query)) {
$lines[] = str_replace('CREATE', 'ALTER', $row['Text']);
}
} else {
$lines[] = 'I am unable to read this stored procedure.';
}
}
document.form1.delimiter.focus();
</script>
<?php
} else {
@mssql_select_db($_SESSION['database']) or die(throwSQLError('unable to select database'));
if ($_POST['fieldquote'] == 'single') {
$quote = '\'';
} else {
$quote = '"';
}
echo '<form name="form1" method="post" action="table_export_download.php">';
echo '<textarea name="data" rows="30" cols="75">';
$tablecount = count($_POST['tables']);
for ($counter = 0; $counter < $tablecount; $counter++) {
$table_query = @mssql_query('SELECT * FROM ' . $_POST['tables'][$counter] . ';') or die(throwSQLError('unable to retrieve table data'));
while ($row = mssql_fetch_array($table_query)) {
if (!isset($schema)) {
$schema = array();
foreach ($row as $key => $value) {
if (!is_int($key)) {
$schema[] = $key;
}
}
}
$values = array();
foreach ($schema as $col) {
if ($quote == '\'') {
$values[] = '\'' . str_replace('\'', '\'\'', $row[$col]) . '\'';
} else {
$values[] = '"' . $row[$col] . '"';
<html>
<head>
<title>phpMSAdmin</title>
</head>
<body bgcolor="#D0DCE0" style="font-family: <?php
echo $_SETTINGS['fontfamily'];
?>
">
<center>
<font style="font-size: 24pt; font-weight: bold"><font style="color: #2A00A6">php</font><font style="color: #B90000">MS</font><font style="color: #006300">Admin</font></font>
<br><br>
<?php
include 'inc/funclib.php';
if (!empty($_POST['username'])) {
$c = @mssql_connect($_POST['datasource'], $_POST['username'], $_POST['password']) or die(throwSQLError('unable to establish a connection'));
mssql_close($c);
session_start();
$_SESSION['updatetime'] = date('U');
$_SESSION['datasource_name'] = $_POST['datasource'];
$_SESSION['datasource_username'] = $_POST['username'];
$_SESSION['datasource_password'] = $_POST['password'];
$_SESSION['REMOTE_ADDR'] = $_SERVER['REMOTE_ADDR'];
$_SESSION['HTTP_USER_AGENT'] = $_SERVER['HTTP_USER_AGENT'];
echo '<meta http-equiv="refresh" content="0;url=frameset.php">';
exit;
}
$sources = array();
if (!$_SETTINGS['detectionoff']) {
if (!isset($_SERVER['WINDIR']) && file_exists($_SETTINGS['freetdspath'])) {
$sourcefile = array();
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
mssql_select_db($_SESSION['database']);
if (!empty($_POST['query'])) {
if (!@mssql_query($_POST['query'])) {
throwSQLError('unable to create view');
} else {
echo '<meta http-equiv="refresh" content="0;url=database_properties.php">';
include 'inc/footer';
}
} else {
$_POST['query'] = 'CREATE VIEW NewView AS ();';
}
?>
<form name="form1" method="post" action="view_create.php">
<table cellpadding="3" cellspacing="3" style="border: 1px solid">
<tr>
<td align="center" style="background: #D0DCE0">
<b>Create View</b>
</td>
</tr>
<td align="center" style="background: #D0DCE0" nowrap>
<b>Username</b>
</td>
<td align="center" style="background: #D0DCE0" nowrap>
<b>Default DB</b>
</td>
<td align="center" colspan="2" style="background: #D0DCE0" nowrap>
<b>Actions</b>
</td>
</tr>
<?php
$toggle = true;
$colors = array('#DDDDDD', '#CCCCCC');
$skiplist = array('##MS_AgentSigningCertificate##', 'NT AUTHORITY\\NETWORK SERVICE', 'NT AUTHORITY\\SYSTEM', 'sa');
$login_query = @mssql_query('sp_helplogins;') or die(throwSQLError('unable to retrieve user list'));
while ($row = mssql_fetch_array($login_query)) {
if ($row['AUser'] == 'yes' && substr_count($row['LoginName'], '$') == 0 && !in_array($row['LoginName'], $skiplist)) {
if ($toggle) {
$bg = $colors[0];
} else {
$bg = $colors[1];
}
$toggle = !$toggle;
echo '<tr>';
echo '<td style="background: ' . $bg . '" nowrap> ' . $row['LoginName'] . ' </td>';
echo '<td style="background: ' . $bg . '" nowrap> ' . $row['DefDBName'] . ' </td>';
echo '<td style="background: ' . $bg . '" nowrap> <a href="users_modify.php?user='******'LoginName']) . '">Modify</a> </td>';
echo '<td style="background: ' . $bg . '" nowrap> <a href="users_drop.php?user='******'LoginName']) . '">Drop</a> </td>';
echo '</tr>';
}
<b>Views</b>
</td>
</tr>
<tr>
<td style="background: #D0DCE0"> </td>
<td align="center" style="background: #D0DCE0">
<b>Name</b>
</td>
<td align="center" colspan="3" style="background: #D0DCE0">
<b>Action</b>
</td>
</tr>
<?php
$toggle = true;
$colors = array('#DDDDDD', '#CCCCCC');
$view_query = @mssql_query('sp_help') or die(throwSQLError('unable to retrieve list of stored procedures'));
while ($row = mssql_fetch_assoc($view_query)) {
if ($row['Object_type'] == 'view' && ($row['Owner'] == 'dbo' || $_SETTINGS['showsysdata'])) {
if ($toggle) {
$bg = $colors[0];
} else {
$bg = $colors[1];
}
$toggle = !$toggle;
echo '<tr>';
echo '<td align="center" style="background: ' . $bg . '"><input type="checkbox" name="views[]" value="' . $row['Name'] . '"></td>';
echo '<td style="background: ' . $bg . '" nowrap>' . $row['Name'] . '</td>';
echo '<td align="center" style="background: ' . $bg . '"><a href="table_select.php?view=' . urlencode($row['Name']) . '">Select</a></td>';
echo '<td align="center" style="background: ' . $bg . '"><a href="view_modify.php?view=' . urlencode($row['Name']) . '">Modify</a></td>';
echo '<td align="center" style="background: ' . $bg . '"><a href="view_drop.php?view=' . urlencode($row['Name']) . '&returnto=view_list.php">Drop</a></td>';
echo '</tr>';
<td colspan="2" style="background: #D0DCE0">
<input type="radio" name="primarykey" value="" <?php
if ($primary_array['index_keys'] != urldecode($_GET['column'])) {
echo 'checked';
}
?>
> No Primary Key
</td>
</tr>
</table>
</form>
<script language="javascript">
document.form1.elements["name"].focus();
</script>
<?php
}
} else {
if ($_GET['mode'] == 'drop') {
@mssql_select_db($_SESSION['database']) or die(throwSQLError('unable to select database'));
$query = 'ALTER TABLE ' . urldecode($_GET['table']) . ' DROP COLUMN ' . urldecode($_GET['column']) . ';';
@mssql_query($query) or die(throwSQLError('unable to drop column', $query));
echo '<meta http-equiv="refresh" content="0;url=table_properties.php?table=' . $_GET['table'] . '">';
}
}
}
?>
<?php
include 'inc/footer.php';
<?php
/*
Copyright (C)
This program is free software; you can redistribute it and/or modify it
under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option)
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
mssql_select_db($_SESSION['database']);
@mssql_query('DROP TRIGGER ' . urldecode($_GET['trigger'])) or die(throwSQLError('unable to delete trigger'));
if (empty($_GET['returnto'])) {
$_GET['returnto'] = 'database_properties.php';
}
echo '<meta http-equiv="refresh" content="0;url=' . $_GET['returnto'] . '">';
include 'inc/footer.php';
<b>Value</b>
</td>
</tr>
<?php
mssql_select_db($_SESSION['database']);
$_GET['table'] = urldecode($_GET['table']);
$existing_query = @mssql_query('SELECT * FROM ' . $_GET['table'] . ' WHERE ' . $_GET['col'] . '=\'' . $_GET['id'] . '\'') or throwSQLError('unable to retrieve existing row');
$existing_array = mssql_fetch_assoc($existing_query);
if (substr_count($_GET['table'], '.') > 0) {
$tablesep = explode('.', $_GET['table']);
$query = 'sp_columns @table_name = N\'' . $tablesep[1] . '\'';
$query .= ', @table_owner = N\'' . $tablesep[0] . '\'';
} else {
$query = 'sp_columns @table_name = N\'' . $_GET['table'] . '\'';
}
$column_query = @mssql_query($query) or die(throwSQLError('unable to retrieve column data'));
$counter = 0;
$toggle = true;
$colors = array('#CCCCCC', '#DDDDDD');
while ($row = mssql_fetch_array($column_query)) {
if ($toggle) {
$bg = $colors[0];
} else {
$bg = $colors[1];
}
$toggle = !$toggle;
if (substr_count($row['TYPE_NAME'], 'identity') > 0) {
$status = 'disabled readonly';
} else {
$status = '';
}
<?php
/*
Copyright (C)
This program is free software; you can redistribute it and/or modify it
under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option)
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
mssql_select_db($_SESSION['database']);
@mssql_query('DROP FUNCTION ' . urldecode($_GET['function']) . ';') or die(throwSQLError('unable to delete function'));
if (empty($_GET['returnto'])) {
$_GET['returnto'] = 'database_properties.php';
}
echo '<meta http-equiv="refresh" content="0;url=' . $_GET['returnto'] . '">';
include 'inc/footer.php';
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
if ($_POST['query'] != '') {
$data_query = @mssql_query($_POST['query']) or die(throwSQLError('unable to save procedure'));
if ($data_query) {
throwSuccess('procedure saved');
}
} else {
mssql_select_db($_SESSION['database']);
$lines = array();
$doit = false;
$data_query = @mssql_query('sp_helptext \'' . urldecode($_GET['trigger']) . '\'') or die(throwSQLError('unable to retrieve trigger'));
if ($data_query) {
while ($row = mssql_fetch_array($data_query)) {
$lines[] = $row['Text'];
}
$lines[1] = str_replace('CREATE', 'ALTER', $lines[1]);
} else {
$lines[] = 'I am unable to read this trigger.';
}
}
?>
<form name="form1" method="post" action="trigger_modify.php?trigger=<?php
echo $_GET['trigger'];
?>
">
<table width="<?php
<?php
/*
Copyright (C)
This program is free software; you can redistribute it and/or modify it
under the terms of the GNU General Public License as published by the Free
Software Foundation; either version 2 of the License, or (at your option)
any later version.
This program is distributed in the hope that it will be useful, but WITHOUT
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
include 'inc/header.php';
@mssql_query('sp_dropuser ' . urldecode($_GET['user']) . ';') or die(throwSQLError('unable to drop user'));
echo '<meta http-equiv="refresh" content="0;url=users_list.php">';
include 'inc/footer.php';
