<% Option Explicit %>

<%

response.expires = 0

response.buffer = true

%>

<%

if session("login") <> "true" then

	response.redirect "login2.asp"

End If

%>

<%

response.expires = 0

response.buffer = true

dim db, strConnection
Set db = Server.CreateObject("ADODB.Connection") 
strConnection = "driver={MySQL 3.22.32};server=localhost;uid=root;pwd=cobalt-mysql;database=css"
db.open strConnection
%>

<%

DIm strRedirect

Dim strMessage



Strredirect = Request.QueryString("id")



If strRedirect = "1" then

StrMessage = "<font size=""3"" color=""#990237"" face=""Arial""><b>Content has been posted to the site.</b></font>"

Elseif strRedirect = "2" then

StrMessage = "<font size=""3"" color=""#990237"" face=""Arial""><b>Content has been deleted.</b></font>"

Elseif strRedirect = "3" then

StrMessage = "<font size=""3"" color=""#990237"" face=""Arial""><b>Content has been edited.</b></font>"

Else

StrMessage = ""

End if

%>

<HTML>



<HEAD>

<TITLE</TITLE>

</HEAD>



<BODY BGCOLOR=#FFFFFF marginwidth="0" marginheight="0" topmargin="0" leftmargin="0" link="#000000" vlink="#000000" alink="#000000">

            <center>

              <%=strMessage%> 

              <table width="600" border=0 cellpadding=2 cellspacing=0>

                <tr> 

                  <td align="LEFT"> <font color="#990237" face="ARIAL" size="3">Menu</font> 

                    <hr>

                  </td>

                </tr>

                <tr> 

                  <td align="LEFT"> <font color="#000000" face="ARIAL" size="2">1. <a href="#addcontent">Add News</a></font> </td>

                </tr>

                <tr> 

                  <td align="LEFT"> <font color="#000000" face="ARIAL" size="2">2. <a href="#editcontent">Edit/Delete News</a></font></td>

                </tr>

                <tr> 

                  <td align="LEFT"> <font color="#000000" face="ARIAL" size="2">3. <a href="logout.asp">LOGOUT</a></font>

				</td>

                </tr>

              </table>

              <br>

            </center>

            <a name="addjob"></a>

            <center>

<script language="JavaScript">

<!--

function validate(myform) {

	var msg = "";



	if(!myform.title.value.match(/\D+/)){

		msg += " *Title\n";

	}

	if(!myform.content.value.match(/\D+/)){

		msg += " *Content\n";

	}

    if (msg == "") {

    	return true;

    }

	else {

    	alert("The following fields must contain information:\n\n" + msg);

    	return false;

    }

}

//-->

</script>

<form name="myform" action="addcontent.asp" method="post" onSubmit="return validate(this)">

              <table width="600" border=0 align="center" cellpadding=2 cellspacing=0 bgcolor="#FFFF00">
                <tr> 

<th align="LEFT"><font color="#000000" face="ARIAL" size="-1">Enter News</font></th>

</tr>

<tr> 

<td bgcolor="#FFFF00"> 

<table bgcolor="#FFFFFF" border=0 width=100% cellspacing=0 cellpadding=1>

<tr> 

<td colspan="2">

<font size="1" face="arial" color="#FF0000"><i><b>Required Information = *</b></i></font> </td>

</tr>

<tr> 

<td align=RIGHT width="25%">

<font face="ARIAL" size="-1">Content Area <font size="1" face="arial" color="#FFFF00">*</font> :</font> </td>

<td width="75%"> 

<select name="content_area" onchange='process()'>

<option value="1">news</option>

</select>

</td>

</tr>

<tr> 

<td align=RIGHT width="25%">

<font face="ARIAL" size="-1">Title<font size="1" face="arial" color="#FFFF00">*</font> : </font></td>

<td width="75%"> 

<input type="text" name="title" size="25">

</td>

</tr>

<tr> 

<td align=RIGHT valign="TOP" width="25%"> <font face="ARIAL" size="-1">Content<font size="1" face="arial" color="#FFFF00">*</font> :</font> </td>

<td width="75%"> 

<textarea name="content" rows=15 cols=50></textarea>

</td>

</tr>

<tr> 

<td colspan=2 align=CENTER> 

<p> 

<input type="submit" name="Submit" value="Add Content">

</td>

</tr>

</table>

</table>

</form>

</TD>
</TR>
</TABLE>

<FORM METHOD="POST" ACTION=""  NAME="form">

<a name="editcontent">

<TABLE BGCOLOR="" WIDTH="600" BORDER=0 CELLPADDING=2 CELLSPACING=0 align="center">

<TR>

<TD colpan="4">

<font face="arial" size="3"><b>Current News On Site :</b></font>

<br><br>

</td>

</tr>

<tr>

<td>

<font face="arial" size="2"><u>Title</u></font>

</td>

<td>

<font face="arial" size="2"><u>Content</u></font>

</td>

<td>

<font face="arial" size="2"><u>Content Type</u></font>

</td>

</tr>

<%

Dim objRS3,SQL2



SQL2 = "SELECT * FROM content ORDER BY title;"

set objRS3 = DB.Execute(SQL2)



if objRS3.EOF then 'state there are no event to show

%>

<tr>

<td colspan="4">

<center>

<font face="arial" size="2" color="red"><b>There is currently no news on the site</b></font>

</center>

</td>

</tr>

<%

else

End if



Do While not objRS3.EOF

dim bgcol

dim fontcol

if bgcol = "#FFFF00" then

	bgcol = "#C0C0C0"

Else bgcol = "#FFFF00"

End IF



If fontcol = "#000000" then

	fontcol = "#000000"

Else fontcol = "#000000"

End if

%>

<tr>

<td bgcolor="<%=bgcol%>">

<font face="arial" size="2" color="<%=fontcol%>"><%= objRS3.fields("title")%></font>

</td>

<td bgcolor="<%=bgcol%>">

<font face="arial" size="2" color="<%=fontcol%>"><%= objRS3.fields("content")%></font>

</td>

<td bgcolor="<%=bgcol%>">

<% 

if objRS3.fields("content_type") = 1 then

%>

<font face="arial" size="2" color="<%=fontcol%>">News</font>

<%

Else

%>

<font face="arial" size="2" color="<%=fontcol%>">FAQ</font>

<%

End if

%>

</td>

<td bgcolor="<%=bgcol%>">

<a href="contentdelete.asp?id=<%= objRS3.fields("content_id")%>"><font face="arial" size="2" color="<%=fontcol%>">Delete</font></a>

</td>

<td bgcolor="<%=bgcol%>">

<a href="contentedit.asp?id=<%= objRS3.fields("content_id")%>"><font face="arial" size="2" color="<%=fontcol%>">Edit</font></a>

</td>

</tr>

<%

objRS3.MoveNext

loop

%>

</table>

</form>

<%

db.close

set objRS3 = nothing

set db = nothing

%>

    </TD>



  </TR>



</TABLE>
</TD>
</TR>
</TABLE>



<!-- End ImageReady Slices --> 





</BODY>



</HTML>