cpmain.asp

asp与MYSQL的源码

<table width="100%" cellpadding="5" cellspacing="0">
	<tr>
		<td bgcolor="#339999" height="10" align="center" width="550" class="celltitle">Management Tools</td>
	</tr>
	<tr>
		<td align="center">
			<table CELLPADDING="3" CELLSPACING="3" width="75%">
				<tr>
					<%
					set rsPriv = server.createobject("ADODB.Recordset")
					rsPriv.CursorLocation = 3
					rsPriv.Open "select * from mysql.user where user = '" & session("username") & "'", dsn, 2, 3
					if rsPriv("grant_priv") = "Y" then
					%>
					<td align="center">
						<a href="users.asp" class="mainmenu">
						<img SRC="images/users.jpg" border="0" WIDTH="57" HEIGHT="57"><br>
						User<br>
						Admin
					</td>
					<%
					end if
					%>
					<td align="center">
						<a href="dump.asp" class="mainmenu">
						<img SRC="images/dump.jpg" border="0" WIDTH="57" HEIGHT="57"><br>
						Data<br>
						Backup
					</td>
					<%
					if rsPriv("create_priv") = "Y" then
					%>
					<td align="center">
						<a href="createdb.asp" class="mainmenu">
						<img SRC="images/newdb.jpg" border="0" WIDTH="57" HEIGHT="57"><br>
						Create<br>
						Database
					</td>
					<%
					end if
					if rsPriv("drop_priv") = "Y" then
					%>
					<td align="center">
						<a href="dropdb.asp" class="mainmenu">
						<img SRC="images/dropdb.jpg" border="0" WIDTH="57" HEIGHT="57"><br>
						Drop<br>
						Database
					</td>
					<%
					end if
					%>
				</tr>
			</table>
		</td>
	</tr>
</table>
<%
set rsPriv = nothing
%>