Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Addnews.php
- [code]
- // startar sessionen
- session_start();
- // om ingen session finns med rätt användarnamn och lösenord visas inloggningssidan igen
- if (!isset($_SESSION["inloggning"]) || $_SESSION["inloggning"] !== true) {
- header("Location: login.php");
- exit;
- }
- // om sessionen finns är inloggningen korrekt och då visas sidinnehållet nedan:
- ?>
- <?php
- $header = "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
- <html xmlns=\"http://www.w3.org/1999/xhtml\">
- <head>
- <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />
- <title>Proffser tipsar</title>
- <style type=\"text/css\">
- a{
- text-decoration: none;
- }
- a.header:link {color: #222222}
- a.header:visited {color: #222222}
- a.header:hover {color: #663300}
- a.header:active {color: #663300}
- a.regular:link {color: #003366}
- a.regular:visited {color: #003366}
- a.regular:hover {color: #663300}
- a.regular:active {color: #663300}
- a.h5{
- font-family:Verdana, Arial, Helvetica, sans-serif;
- font-size: 8px;
- text-align:center;
- color: #666666;
- text-decoration: none;
- }
- table{
- background: #DDDDDD;
- }
- table.border{
- border: #666666 solid 1px;
- }
- td.title{
- background:#003366;
- text-align:center;
- font-family:Verdana, Arial, Helvetica, sans-serif;
- font-size: 16px;
- border: #666666 double 2px;
- padding-top:5px;
- padding-bottom:5px;
- color: #DDDDDD;
- }
- </style>
- </head>
- <body bgcolor=\"#CCCCCC\">
- <center>
- <br><br>";
- //Bakgrundsfarg meny
- $header2="<table width=\"700\" class=\"border\" style=\"background: #CCCCCC\">
- <tr>
- <td width=\"700\" td colspan=\"6\" class=\"title\"><a href=\"addnewsv.php\" style=\"color: #DDDDDD; text-decoration: none\">Proffser tipsar</a></td>
- <tr>
- <tr>
- <td width=\"120\" td align=\"center\"><a class=\"header\" href=\"addnewsv.php?nav=addnews\">Lägga till nyhet</a></td>
- <td width=\"120\" td align=\"center\"><a class=\"header\" href=\"addnewsv.php?nav=ed\">Ändra nyhet</a></td>
- <td width=\"120\" td align=\"center\"><a class=\"header\" href=\"viewnews0.php\" target=\"_blank\">Förhandstitt</a></td>
- <td width=\"120\" td align=\"center\"><a class=\"header\" href=\"skyddad.php\">Admin</a></td></tr></table><br>";
- $return="<form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">
- <input type=\"hidden\" name=\"opt\" value=\"mn\">
- <input type=\"submit\" name=\"submit\" value=\"Main Menu\"></form>";
- $addnews="<script language=\"javascript\" type=\"text/javascript\" src=\"tiny_mce/tiny_mce.js\"></script>
- <script language=\"javascript\" type=\"text/javascript\">
- tinyMCE.init({
- mode : \"textareas\",
- theme : \"advanced\",
- plugins : \"table\",
- theme_advanced_buttons3_add : \"separator,forecolor,backcolor,fontselect,fontsizeselect,tablecontrols,\",
- theme_advanced_toolbar_align : \"center\",
- extended_valid_elements : \"a[name|href|target|title|onclick],img[class|src|border=0|alt|title|hspace|vspace|width|height|align|onmouseover|onmouseout|name],hr[class|width|size|noshade],font[face|size|color|style],span[class|align|style]\"
- });
- </script>
- <form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">
- <table align=\"center\" style=\"border:#666666 solid 1px; margin-bottom: 10px;\">
- <tr>
- <td class=\"title\">Lägga till nyhet:</td>
- </tr>
- <td style=\"padding: 0px\"><textarea name=\"news\" rows=\"10\" cols=\"33\" class=\"wysiwyg\"></textarea></td>
- </tr>
- <input type=\"hidden\" name=\"opt\" value=\"news\" />
- <tr>
- <td align=\"right\" style=\"padding-right: 4px; padding-bottom: 4px;\"><input type=\"submit\" name=\"submit\" value=\"OK\" /></td>
- </tr>
- </table>
- </form>";
- echo $header;
- include("connection.php");
- $result = mysql_query("SELECT * FROM vars0");
- while($row = mysql_fetch_array($result))
- mysql_close($con);
- echo $header2;
- if(!empty($_GET['d'])) //DELTES SELECTED POST
- {
- $d=$_GET['d'];
- include("connection.php");
- $result = mysql_query("SELECT * FROM news0 ORDER BY Number");
- $count=0;$b=0;
- while($row = mysql_fetch_array($result))
- {
- $count++;
- if($count==$d)
- { mysql_query("DELETE FROM news0 WHERE Number = '$d'");}
- if($count>$d)
- {
- $b=$count-1;
- mysql_query("UPDATE news0 SET Number = '$b' WHERE Number = '$count'");
- }
- }
- mysql_close($con);
- echo "<table align=\"center\" style=\"border:#666666 solid 1px\">
- <tr><td>Nyheten raderad!</td></tr></table>";
- }else if(!empty($_GET['e'])){//PULLS UP SELECTED POST
- $e=$_GET['e'];
- include("connection.php");
- $result = mysql_query("SELECT * FROM news0 ORDER BY Number");
- $count=0;
- while($row = mysql_fetch_array($result))
- {
- $count++;
- if($e==$count)
- {
- $date=$row['Date'];
- $news=$row['News'];
- }
- }
- mysql_close($con);
- echo "<script language=\"javascript\" type=\"text/javascript\" src=\"tiny_mce/tiny_mce.js\"></script>
- <script language=\"javascript\" type=\"text/javascript\">
- tinyMCE.init({
- mode : \"textareas\",
- theme : \"advanced\",
- plugins : \"table\",
- theme_advanced_buttons3_add : \"separator,forecolor,backcolor,fontselect,fontsizeselect,tablecontrols\",
- theme_advanced_toolbar_align : \"center\",
- extended_valid_elements : \"a[name|href|target|title|onclick],img[class|src|border=0|alt|title|hspace|vspace|width|height|align|onmouseover|onmouseout|name],hr[class|width|size|noshade],font[face|size|color|style],span[class|align|style]\"
- });
- </script>
- <form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">
- <table align=\"center\" style=\"border:#666666 solid 1px; margin-bottom: 10px; \">
- <tr>
- <td class=\"title\">Redigera nyheter:</td>
- </tr>
- <tr>
- <td style=\"padding: 0px\"><textarea name=\"news\" rows=\"10\" cols=\"33\">".$news."</textarea></td>
- </tr>
- <input type=\"hidden\" name=\"opt\" value=\"edit\">
- <input type=\"hidden\" name=\"ed\" value=\"".$e."\">
- <tr>
- <td align=\"right\" style=\"padding-right: 4px; padding-bottom: 4px;\"><input type=\"submit\" name=\"submit\" value=\"Redigera\" /></td>
- </tr>
- </table>
- </form>";
- }
- switch($_GET['nav'])
- {
- case "addnews":
- echo $addnews;
- break;
- case "customize":
- include("connection.php");
- $result = mysql_query("SELECT * FROM vars0");
- while($row = mysql_fetch_array($result))
- {
- $twidth=$row['TWidth'];
- $tbg=$row['TBg'];
- $bgi=$row['BGI'];
- $tbord=$row['TBord'];
- $tbw=$row['TBW'];
- $nbord=$row['NBord'];
- $spacing=$row['Spacing'];
- $maxp=$row['MaxP'];
- $date=$row['Date'];
- $dfont=$row['DFont'];
- $dfsize=$row['DFSize'];
- $dfc=$row['DFC'];
- $dalign=$row['DAlign'];
- $nalign=$row['NAlign'];
- $pbc=$row['PBC'];
- $tbc=$row['TBC'];
- }
- mysql_close($con);
- echo "<form action=\"".$_SERVER['PHP_SELF']."\" method=\"post\">
- <table class=\"border\">
- <tr>
- <td colspan=\"2\" align=\"center\" class=\"title\">Ändra tabelllayout</td>
- </tr>
- <tr>
- <td>Table width(pixels or percent):</td><td align=\"right\"><input type=\"text\" name=\"twidth\" value=\"".$twidth."\" size=\"30\"></td>
- </tr>
- <tr>
- <td>Table color(name or hex value):</td><td align=\"right\"><input type=\"text\" name=\"tbg\" value=\"".$tbg."\" size=\"30\"></td>
- </tr>
- <tr>
- <td>Table image(if none: 'NULL'):</td><td align=\"right\"><input type=\"text\" name=\"bgi\" value=\"".$bgi."\" size=\"30\"></td>
- </tr>
- <tr>
- <td>Table border style:</td><td align=\"right\"><select name=\"tbord\">";
- if($tbord=="medium"){
- echo "<option value=\"medium\" selected=\"selected\">Medium</option>";}else{
- echo "<option value=\"medium\">Medium</option>";}
- if($tbord=="thin"){
- echo "<option value=\"thin\" selected=\"selected\">Thin</option>";}else{
- echo "<option value=\"thin\">Thin</option>";}
- if($tbord=="thick"){
- echo "<option value=\"thick\" selected=\"selected\">Thick</option>";}else{
- echo "<option value=\"thick\">Thick</option>";}
- if($tbord=="dashed"){
- echo "<option value=\"dashed\" selected=\"selected\">Dashed</option>";}else{
- echo "<option value=\"dashed\">Dashed</option>";}
- if($tbord=="dotted"){
- echo "<option value=\"dotted\" selected=\"selected\">Dotted</option>";}else{
- echo "<option value=\"dotted\">Dotted</option>";}
- if($tbord=="double"){
- echo "<option value=\"double\" selected=\"selected\">Double</option>";}else{
- echo "<option value=\"double\">Double</option>";}
- if($tbord=="groove"){
- echo "<option value=\"groove\" selected=\"selected\">Groove</option>";}else{
- echo "<option value=\"groove\">Groove</option>";}
- if($tbord=="hidden"){
- echo "<option value=\"hidden\" selected=\"selected\">Hidden</option>";}else{
- echo "<option value=\"hidden\">Hidden</option>";}
- if($tbord=="inset"){
- echo "<option value=\"inset\" selected=\"selected\">Inset</option>";}else{
- echo "<option value=\"inset\">Inset</option>";}
- if($tbord=="none"){
- echo "<option value=\"none\" selected=\"selected\">None</option>";}else{
- echo "<option value=\"none\">None</option>";}
- if($tbord=="outset"){
- echo "<option value=\"outset\" selected=\"selected\">Outset</option>";}else{
- echo "<option value=\"outset\">Outset</option>";}
- if($tbord=="ridge"){
- echo "<option value=\"ridge\" selected=\"selected\">Ridge</option>";}else{
- echo "<option value=\"ridge\">Ridge</option>";}
- if($tbord=="solid"){
- echo "<option value=\"solid\" selected=\"selected\">Solid</option>";}else{
- echo "<option value=\"solid\">Solid</option>";}
- echo "</select></td>
- </tr>
- <tr>
- <td>Table Border Width:</td><td align=\"right\"><select name=\"tbw\">";
- if($tbw=="0px"){
- echo "<option value=\"0px\" selected=\"selected\">0px</option>";}else{
- echo "<option value=\"0px\">0px</option>";}
- if($tbw=="1px"){
- echo "<option value=\"1px\" selected=\"selected\">1px</option>";}else{
- echo "<option value=\"1px\">1px</option>";}
- if($tbw=="2px"){
- echo "<option value=\"2px\" selected=\"selected\">2px</option>";}else{
- echo "<option value=\"2px\">2px</option>";}
- if($tbw=="3px"){
- echo "<option value=\"3px\" selected=\"selected\">3px</option>";}else{
- echo "<option value=\"3px\">3px</option>";}
- if($tbw=="4px"){
- echo "<option value=\"4px\" selected=\"selected\">4px</option>";}else{
- echo "<option value=\"4px\">4px</option>";}
- if($tbw=="5px"){
- echo "<option value=\"5px\" selected=\"selected\">5px</option>";}else{
- echo "<option value=\"5px\">5px</option>";}
- echo "</select></td>
- </tr>
- <tr>
- <td>Table Border Color (if no border, type NULL):</td><td align=\"right\"><input type=\"text\" name=\"tbc\" value=\"".$tbc."\" size=\"30\"></td>
- </tr>
- <tr>
- <td>Post border:</td><td align=\"right\"><select name=\"nbord\">";
- //if($nbord=="medium"){
- //echo "<option value=\"medium\" selected=\"selected\">Medium</option>";}else{
- //echo "<option value=\"medium\">Medium</option>";}
- //if($nbord=="thin"){
- //echo "<option value=\"thin\" selected=\"selected\">Thin</option>";}else{
- //echo "<option value=\"thin\">Thin</option>";}
- //if($nbord=="thick"){
- //echo "<option value=\"thick\" selected=\"selected\">Thick</option>";}else{
- //echo "<option value=\"thick\">Thick</option>";}
- //if($nbord=="dashed"){
- //echo "<option value=\"dashed\" selected=\"selected\">Dashed</option>";}else{
- //echo "<option value=\"dashed\">Dashed</option>";}
- //if($nbord=="dotted"){
- //echo "<option value=\"dotted\" selected=\"selected\">Dotted</option>";}else{
- //echo "<option value=\"dotted\">Dotted</option>";}
- //if($nbord=="double"){
- //echo "<option value=\"double\" selected=\"selected\">Double</option>";}else{
- //echo "<option value=\"double\">Double</option>";}
- //if($nbord=="groove"){
- //echo "<option value=\"groove\" selected=\"selected\">Groove</option>";}else{
- //echo "<option value=\"groove\">Groove</option>";}
- //if($nbord=="hidden"){
- //echo "<option value=\"hidden\" selected=\"selected\">Hidden</option>";}else{
- //echo "<option value=\"hidden\">Hidden</option>";}
- //if($nbord=="inset"){
- //echo "<option value=\"inset\" selected=\"selected\">Inset</option>";}else{
- //echo "<option value=\"inset\">Inset</option>";}
- if($nbord=="none"){
- echo "<option value=\"none\" selected=\"selected\">None</option>";}else{
- echo "<option value=\"none\">None</option>";}
- //if($nbord=="outset"){
- //echo "<option value=\"outset\" selected=\"selected\">Outset</option>";}else{
- //echo "<option value=\"outset\">Outset</option>";}
- //if($nbord=="ridge"){
- //echo "<option value=\"ridge\" selected=\"selected\">Ridge</option>";}else{
- //echo "<option value=\"ridge\">Ridge</option>";}
- //if($nbord=="solid"){
- //echo "<option value=\"solid\" selected=\"selected\">Solid</option>";}else{
- //echo "<option value=\"solid\">Solid</option>";}
- echo " </select></td>
- </tr>
- <tr>
- <td>Post Border Color (if no border, type NULL):</td><td align=\"right\"><input type=\"text\" name=\"pbc\" value=\"".$pbc."\" size=\"30\"></td>
- </tr>
- <tr>
- <td>Spacing between posts:</td><td align=\"right\"><select name=\"spacing\">";
- if($spacing=="0px"){
- echo "<option value=\"0px\" selected=\"selected\">0px</option>";}else{
- echo "<option value=\"0px\">0px</option>";}
- if($spacing=="2px"){
- echo "<option value=\"2px\" selected=\"selected\">2px</option>";}else{
- echo "<option value=\"2px\">2px</option>";}
- if($spacing=="4px"){
- echo "<option value=\"4px\" selected=\"selected\">4px</option>";}else{
- echo "<option value=\"4px\">4px</option>";}
- if($spacing=="6px"){
- echo "<option value=\"6px\" selected=\"selected\">6px</option>";}else{
- echo "<option value=\"6px\">6px</option>";}
- if($spacing=="8px"){
- echo "<option value=\"8px\" selected=\"selected\">8px</option>";}else{
- echo "<option value=\"8px\">8px</option>";}
- if($spacing=="10px"){
- echo "<option value=\"10px\" selected=\"selected\">10px</option>";}else{
- echo "<option value=\"10px\">10px</option>";}
- echo " </select></td>
- </tr>
- <tr>
- <td>Maximum amount of posts:</td><td align=\"right\"><input type=\"text\" name=\"maxp\" value=\"".$maxp."\" size=\"30\"></td>
- </tr>
- <tr>
- <td>Date format:</td><td align=\"right\"><select name=\"date\">";
- //if($date=="m.d.Y"){
- //echo "<option value=\"m.d.Y\" selected=\"selected\">".date("m.d.Y")."</option>";}else{
- //echo "<option value=\"m.d.Y\">".date("m.d.Y")."</option>";}
- //if($date=="m/d/Y"){
- //echo "<option value=\"m/d/Y\" selected=\"selected\">".date("m/d/Y")."</option>";}else{
- //echo "<option value=\"m/d/Y\">".date("m/d/Y")."</option>";}
- //if($date=="m-d-Y"){
- //echo "<option value=\"m.d.Y\" selected=\"selected\">".date("m-d-Y")."</option>";}else{
- //echo "<option value=\"m-d-Y\">".date("m-d-Y")."</option>";}
- //if($date=="m-d,Y"){
- //echo "<option value=\"m-d,Y\" selected=\"selected\">".date("m-d,Y")."</option>";}else{
- //echo "<option value=\"m-d,Y\">".date("m-d,Y")."</option>";}
- if($date=="Y,m-d"){
- echo "<option value=\"Y,m-d\" selected=\"selected\">".date("Y-m-d")."</option>";}else{
- echo "<option value=\"Y-m-d\">".date("Y-m-d")."</option>";}
- //if($date=="m/d"){
- //echo "<option value=\"m/d\" selected=\"selected\">".date("m/d")."</option>";}else{
- //echo "<option value=\"m/d\">".date("m/d")."</option>";}
- echo " </select></td>
- </tr>
- <tr>
- <td>Date font:</td><td align=\"right\"><select name=\"dfont\">";
- //if($dfont=="1"){
- //echo "<option value=\"1\" selected=\"selected\">Arial, Helvetica, sans-serif</option>";}else{
- //echo "<option value=\"1\">Arial, Helvetica, sans-serif</option>";}
- //if($dfont=="2"){
- //echo "<option value=\"2\" selected=\"selected\">Georgia, \"Times New Roman\", Times, serif</option>";}else{
- //echo "<option value=\"2\">Georgia, \"Times New Roman\", Times, serif</option>";}
- //if($dfont=="3"){
- //echo "<option value=\"3\" selected=\"selected\">Geneva, Arial, Helvetica, sans-serif</option>";}else{
- //echo "<option value=\"3\">Geneva, Arial, Helvetica, sans-serif</option>";}
- //if($dfont=="4"){
- //echo "<option value=\"4\" selected=\"selected\">\"Courier New\", Courier, monospace</option>";}else{
- //echo "<option value=\"4\">\"Courier New\", Courier, monospace</option>";}
- //if($dfont=="5"){
- //echo "<option value=\"5\" selected=\"selected\">\"Times New Roman\", Times, serif</option>";}else{
- //echo "<option value=\"5\">\"Times New Roman\", Times, serif</option>";}
- if($dfont=="6"){
- echo "<option value=\"6\" selected=\"selected\">Verdana, Arial, Helvetica, sans-serif</option>";}else{
- echo "<option value=\"6\">Verdana, Arial, Helvetica, sans-serif</option>";}
- echo " </select></td>
- </tr>
- <tr>
- <td>Date font size:</td><td align=\"right\"><select name=\"dfsize\">";
- if($dfsize=="8px"){
- echo "<option value=\"8px\" selected=\"selected\">8px</option>";}else{
- echo "<option value=\"8px\">8px</option>";}
- if($dfsize=="10px"){
- echo "<option value=\"10px\" selected=\"selected\">10px</option>";}else{
- echo "<option value=\"10px\">10px</option>";}
- if($dfsize=="12px"){
- echo "<option value=\"12px\" selected=\"selected\">12px</option>";}else{
- echo "<option value=\"12px\">12px</option>";}
- if($dfsize=="14px"){
- echo "<option value=\"14px\" selected=\"selected\">14px</option>";}else{
- echo "<option value=\"14px\">14px</option>";}
- if($dfsize=="16px"){
- echo "<option value=\"16px\" selected=\"selected\">16px</option>";}else{
- echo "<option value=\"16px\">16px</option>";}
- if($dfsize=="18px"){
- echo "<option value=\"18px\" selected=\"selected\">18px</option>";}else{
- echo "<option value=\"18px\">18px</option>";}
- if($dfsize=="20px"){
- echo "<option value=\"20px\" selected=\"selected\">20px</option>";}else{
- echo "<option value=\"20px\">20px</option>";}
- if($dfsize=="24px"){
- echo "<option value=\"24px\" selected=\"selected\">24px</option>";}else{
- echo "<option value=\"24px\">24px</option>";}
- echo" </select></td>
- </tr>
- <tr>
- <td>Date font color:</td><td align=\"right\"><input type=\"text\" name=\"dfc\" value=\"".$dfc."\" size=\"30\"></td>
- </tr>
- <tr>
- <td>Date align:</td><td align=\"right\"><select name=\"dalign\">";
- if($dalign=="left"){
- echo "<option value=\"left\" selected=\"selected\">Left</option>";}else{
- echo "<option value=\"left\">Left</option>";}
- if($dalign=="center"){
- echo "<option value=\"center\" selected=\"selected\">Center</option>";}else{
- echo "<option value=\"center\">Center</option>";}
- if($dalign=="right"){
- echo "<option value=\"right\" selected=\"selected\">Right</option>";}else{
- echo "<option value=\"right\">Right</option>";}
- echo " </select></td>
- </tr>
- <tr>
- <td>News align:</td><td align=\"right\"><select name=\"nalign\">";
- if($nalign=="left"){
- echo "<option value=\"left\" selected=\"selected\">Left</option>";}else{
- echo "<option value=\"left\">Left</option>";}
- if($nalign=="center"){
- echo "<option value=\"center\" selected=\"selected\">Center</option>";}else{
- echo "<option value=\"center\">Center</option>";}
- if($nalign=="right"){
- echo "<option value=\"right\" selected=\"selected\">Right</option>";}else{
- echo "<option value=\"right\">Right</option>";}
- echo " </select></td>
- </tr>
- <input type=\"hidden\" name=\"opt\" value=\"cust\">
- <tr>
- <td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"submit\" value=\"Update!\"></td>
- </tr>
- </table>
- </form>";
- break;
- case "ed":
- echo "<table width=\"75%\" align=\"center\" style=\"border: #666666 solid 1px\"><tr><td>";
- include("connection.php");
- $result = mysql_query("SELECT * FROM news0 ORDER BY Number");
- $count=0;$tbc=1;
- while($row = mysql_fetch_array($result))
- {
- $tb="#CCCCCC";
- $tbc++;
- if($tbc==3)
- {
- $tbc=1;
- $tb="#DDDDDD";
- }
- $date=$row['Date'];
- $news=$row['News'];
- $count++;
- echo "<table class=\"border\" width=\"800px\" style=\"margin: 1px; background: ".$tb."\"><tr valign=\"top\"><td width=\"100px\">".$date."</td><td width=\"350px\" align=\"left\">".$news."</td><td width=\"10%\" valign=\"middle\"><a class=\"regular\" href=\"addnewsv.php?nav=edit&e=".$count."\">Ändra</a></td><td width=\"10%\" valign=\"middle\"><a class=\"regular\" href=\"addnewsv.php?nav=delete&d=".$count."\">Ta bort</a></td></tr></table>";
- }
- mysql_close($con);
- echo "</tr></td></table>";
- break;
- }
- {
- switch($_POST['opt'])
- {
- case "log": //UPDATES LOGIN INFORMATION
- $user=$_POST['name'];
- $pass=$_POST['npass'];
- if(empty($_POST['name']) && empty($_POST['npass']) && empty($_POST['pass2']))
- {
- echo "<table align=\"center\" style=\"border:#666666 solid 1px\">
- <tr><td>Ingen ändring gjord</td></tr></table>";
- }else if(empty($user) || empty($pass) || empty($_POST['pass2']))
- {
- echo $ulogin;
- echo "<br><table align=\"center\" style=\"border:#666666 solid 1px\">
- <tr><td><font color=\"red\">Please make sure you fill out the entire form</font></td></tr></table>";
- }
- if($pass==$_POST['pass2'] && !empty($_POST['name']) && !empty($_POST['npass']))
- {
- include("connection.php");
- mysql_query("UPDATE vars0 SET User = '$user' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET Pass = '$pass' WHERE Loc = '1'");
- mysql_close($con);
- echo "<table align=\"center\" style=\"border:#666666 solid 1px\">
- <tr><td>Uppdaterat! Glöm ej att notera lösenordet:</td><tr></table><br>
- <table align=\"center\" style=\"border: #666666 1px solid\">
- <tr>
- <td align = \"left\" style=\"border-bottom: #666666 1px solid; padding-bottom: 3px\">Användarnamn:</td><td style=\"border-bottom: #666666 1px solid; padding-bottom: 3px\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" pointsize=\"12px\">
- ".$user."</font></td>
- </tr>
- <tr>
- <td align = \"left\">Lösenord: </td><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" pointsize=\"12px\">".$pass."</font></td>
- </tr>
- </table>";
- }else if($pass!=$_POST['pass2']){
- echo $ulogin."<br><table align=\"center\" style=\"border:#666666 solid 1px\">
- <tr><td><font color=\"red\">Please ensure the passwords match!</font></td></tr></table>";
- }
- break;
- case "news": //ADD NEWS
- include("connection.php");
- $result = mysql_query("SELECT * FROM vars0");
- while($row = mysql_fetch_array($result))
- {
- $maxcount=$row['MaxP'];
- //$df=$row['Date'];Ger posterna datum
- }
- $result = mysql_query("SELECT * FROM news0");
- $count=0;
- while($row = mysql_fetch_array($result))
- {
- $count++;
- }
- if($count==$maxcount)
- {
- mysql_query("DELETE FROM news0 WHERE Number = '$count'");
- for($a=($maxcount-1); $a>=1; $a--)
- {
- $b=$a+1;
- mysql_query("UPDATE news0 SET Number = '$b' WHERE Number = '$a'");
- }
- }else{
- for($a=($count); $a>=1; $a--)
- {
- $b=$a+1;
- mysql_query("UPDATE news0 SET Number = '$b' WHERE Number = '$a'");
- }
- }
- $date=date($df);
- $pnews=$_POST['news'];
- mysql_query("INSERT INTO news0 (Date, News, Number) VALUES ('$date', '$pnews', '1')");
- mysql_close($con);
- echo "<table align=\"center\" style=\"border:#666666 solid 1px\">
- <tr><td>Nyhet inlagd!</td></tr></table>";
- break;
- case "cust": //UPDATES viewnews0.PHP CUSTOMIZATION
- $twidth=$_POST['twidth'];
- $tbg=$_POST['tbg'];
- $bgi=$_POST['bgi'];
- $tbord=$_POST['tbord'];
- $tbw=$_POST['tbw'];
- $nbord=$_POST['nbord'];
- $spacing=$_POST['spacing'];
- $maxp=$_POST['maxp'];
- $date=$_POST['date'];
- $dfont=$_POST['dfont'];
- $dfsize=$_POST['dfsize'];
- $dfc=$_POST['dfc'];
- $dalign=$_POST['dalign'];
- $nalign=$_POST['nalign'];
- $pbc=$_POST['pbc'];
- $tbc=$_POST['tbc'];
- include("connection.php");
- $result = mysql_query("SELECT * FROM news0");
- $count=0;
- while($row = mysql_fetch_array($result))
- {
- $count++;
- }
- if($count>$maxp)
- {
- for($a=$count; $a>$maxp; $a--)
- {
- mysql_query("DELETE FROM news0 WHERE Number = '$a'");
- }
- }
- $b=$maxp;
- mysql_query("UPDATE vars0 SET MaxP = '$maxp' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET TWidth = '$twidth' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET TBg = '$tbg' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET BGI = '$bgi' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET TBord = '$tbord' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET TBW = '$tbw' WHERE Loc = '1'");
- mysql_query("UPDATE vars0SET NBord = '$nbord' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET Spacing = '$spacing' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET Date = '$date' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET DFont = '$dfont' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET DFSize = '$dfsize' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET DFC = '$dfc' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET DAlign = '$dalign' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET NAlign = '$nalign' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET TBC = '$tbc' WHERE Loc = '1'");
- mysql_query("UPDATE vars0 SET PBC = '$pbc' WHERE Loc = '1'");
- mysql_close($con);
- echo "<table align=\"center\" style=\"border:#666666 solid 1px\">
- <tr><td>Tabellen ändrad!</td></tr></table>";
- break;
- case "edit": //UPDATES EDITED NEWS
- $e=$_POST['ed'];
- $news=$_POST['news'];
- $date=$_POST['date'];
- include("connection.php");
- mysql_query("UPDATE news0 SET News = '$news' WHERE Number = '$e'");
- mysql_query("UPDATE news0 SET Date = '$date' WHERE Number = '$e'");
- mysql_close($con);
- echo "<table align=\"center\" style=\"border:#666666 solid 1px\">
- <tr><td>Nyhetsposten uppdaterad!.</td></tr></table>";
- break;
- }
- }
- [/php]
- viewnews.php
- [php]
- include("connection.php");
- $result = mysql_query("SELECT * FROM vars1");
- while($row = mysql_fetch_array($result))
- {
- $twidth=$row['TWidth'];
- $tbg=$row['TBg'];
- $bgi=$row['BGI'];
- $tbord=$row['TBord'];
- $tbw=$row['TBW'];
- $nbord=$row['NBord'];
- $spacing=$row['Spacing'];
- $dfont=$row['DFont'];
- $dfsize=$row['DFSize'];
- $dfc=$row['DFC'];
- $dalign=$row['DAlign'];
- $nalign=$row['NAlign'];
- $tbc=$row['TBC'];
- $pbc=$row['PBC'];
- }
- switch($dfont)
- {
- case "1":
- $font="font: Arial, Helvetica, sans-serif;";
- break;
- case "2":
- $font="font: Georgia, \"Times New Roman\", Times, serif;";
- break;
- case "3":
- $font="font: Geneva, Arial, Helvetica, sans-serif;";
- break;
- case "4":
- $font="font: \"Courier New\", Courier, monospace;";
- break;
- case "5":
- $font="font: \"Times New Roman\", Times, serif;";
- break;
- case "6":
- $font="font: Verdana, Arial, Helvetica, sans-serif;";
- break;
- }
- echo "<table width=\"".$twidth."\" style=\"background: ".$tbg;
- if($bgi!="NULL")
- {echo " url('".$bgi."')";}
- echo " repeat scroll; border: ".$tbc." ".$tbord." ".$tbw.";\">";
- $result = mysql_query("SELECT * FROM news1 ORDER BY Number");
- while($row = mysql_fetch_array($result))
- {
- echo "<tr><td>";
- echo "<table width=\"100%\" style=\"margin-bottom: ".$spacing.";\">";
- echo "<tr >
- <td align=\"".$nalign."\" style=\"border-bottom: ".$pbc." ".$nbord." 1px;\">".$row['News']."</td>
- </tr>";
- echo "</table>
- </td></tr>";
- }
- echo "</table>";
- mysql_close($con);
- [/code]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement