ups kr-data. Så ikke lige din post ovenover.
Her kommer alle filerne. Håber i/du kan holde styr på det :)
main.php(uden min db_connect):
<?
function db_query ($sql, $link)
{
if (!($result = mysql_query($sql, $link)))
{
echo("(1)mysql error: " . mysql_errno() . " " . mysql_error());
return 0 ;
}
return $result;
};
$ip = $_SERVER['REMOTE_ADDR'];
switch ($_GET['mode']) {
case 'allnews':
Include('inc/main/news/allnews.php');
$link = db_connect();
$location = $_SERVER['QUERY_STRING'];
$sql = "UPDATE online_users SET location = '/index.php?$location' WHERE ip ='$ip'";
db_query($sql,$link);
break;
case 'news':
switch ($_GET['kat']) {
case 'it':
include('inc/main/news/it/it.php');
$link = db_connect();
$sql = "UPDATE online_users SET location = '/index.php?mode=news&kat=it' WHERE ip ='$ip'";
db_query($sql,$link);
break;
case 'film':
include('inc/main/news/film/film.php');
$link = db_connect();
$sql = "UPDATE online_users SET location = '/index.php?mode=news&kat=film' WHERE ip ='$ip'";
db_query($sql,$link);
break;
case 'generelt':
include('inc/main/news/generelt/generelt.php');
$link = db_connect();
$sql = "UPDATE online_users SET location = '/index.php?mode=news&kat=generelt' WHERE ip ='$ip'";
db_query($sql,$link);
break;
case 'ligegyldig':
include('inc/main/news/ligegyldig/ligegyldig.php');
$link = db_connect();
$sql = "UPDATE online_users SET location = '/index.php?mode=news&kat=ligegyldig' WHERE ip ='$ip'";
db_query($sql,$link);
break;
};
break;
case 'laesnews':
$IDnews = $_GET['ID'];
$kategori = $_GET['kat'];
$link = db_connect();
$sql = "UPDATE online_users SET location = '/index.php?mode=laesnews&kat=$kategori&ID=$IDnews' WHERE ip ='$ip'";
db_query($sql,$link);
$link = db_connect();
$sql = "SELECT * FROM news WHERE kategori = '$kategori' AND ID = '$IDnews'";
$res = db_query($sql, $link);
while($tab=mysql_fetch_array($res)) {
$id=$tab["ID"];
$overskrift=$tab["headline"];
$teaser=$tab["teaser"];
$nyhed= nl2br($tab["bodytext"]);
$navn=$tab["skribent"];
$kilde=$tab["kilde"];
$dato=$tab["dato"];
echo "
<br>
<center>
<table align=\"center\" cellpadding=\"0\" cellspacing=\"0\">
<tr>
<td width=\"597\"><img src=\"img/boxcorner_top.gif\"></td>
</tr>
</table>
<table cellpadding=\"0\" cellspacing=\"0\" align=\"center\">
<tr>
<td class=\"boxtop2\" width=\"67\" height=\"19\"><img src=\"img/boxcorner_bottom.gif\"></td>
<td class=\"boxtop1\" background=\"img/boxtopbg.gif\" width=\"528\" height=\"19\"><div class=\"text\">$overskrift</div></td>
</tr>
</table>
<table class=\"boxmidt\" cellpadding=\"0\" cellspacing=\"0\" align=\"center\">
<tr>
<td valign=\"top\" width=\"595\" height=\"*\">
<table bgcolor=\"#FAFAFA\">
<tr>
<td style=\"padding: 5px;\" class=\"text\"><b>$teaser</b> <br><br><br><br> $nyhed</td></tr>
</table>
</td>
</tr>
<tr>
<td class=\"forfatter\" height=\"19\" width=\"595\" background=\"img/boxbottombg.gif\"><div class=\"text\" style=\"padding-left: 5px;\">Skrevet d. $dato af $navn</div></td>
</tr>
</table>
</center>
";
};
echo "<br><br><br><br><br>";
$sql = "SELECT * FROM comments WHERE NewsID = $id ORDER BY id";
$res = db_query($sql, $link);
$cmtnr = 1;
while($tab=mysql_fetch_array($res)) {
$comment=$tab["CommentBody"];
$bruger=$tab["user"];
$dato=$tab["dato"];
echo "
<center>
<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"500\">
<tr>
<td align=\"left\" class=\"text\" background=\"img/commentbg.gif\" style=\"border-top: 1px solid #84A8BE; border-left: 1px solid #84A8BE; padding-left: 5px;\">Kommentar #$cmtnr:</td>
<td align=\"right\" class=\"text\" background=\"img/commentbg.gif\" style=\"border-right: 1px solid #84A8BE; border-top: 1px solid #84A8BE;\">$dato</td>
</tr>
<tr>
<td colspan=\"2\" class=\"text\" style=\" border-right: 1px solid #84A8BE; border-left: 1px solid #84A8BE; padding: 5px;\">$comment</td>
</tr>
<tr>
<td align=\"left\"colspan=\"2\" class=\"text\" style=\" border-right: 1px solid #84A8BE; border-bottom: 1px solid #84A8BE; border-left: 1px solid #84A8BE; padding: 5px;\">Bruger: $bruger</td>
</tr>
</table>
</center>
<br>
";
$cmtnr = $cmtnr + 1;
};
break;
case 'online':
switch ($_GET['profile']) {
case 'guest':
$link = db_connect();
$sql = "UPDATE online_users SET location = '/index.php?mode=online&profile=guest' WHERE ip ='$ip'";
db_query($sql,$link);
include('inc/main/uo/uo.php');
break;
};
break;
case 'login':
db_connect();
if(!isset($_POST['Submit'])) { //Tester om brugeren kom fra login.html
echo "Du har ikke brugt login formen.";
}else{
$postbruger = $_POST['brugernavn'];
$postpass = $_POST['adgangskode']; //For læservenligheden overføres post variablerne til normale variabler
$resultat = mysql_query("SELECT Id FROM `brugere` WHERE brugernavn = '$postbruger' AND adgangskode = '$postpass'");//Spørger efter ID
$number = mysql_num_rows($resultat);//Tæller antaller af resultater
if($number == 1) { //Hvis der kun er et resultat, bliver brugeren logget in
$_SESSION['logget_ind'] = 1;
$_SESSION['brugernavn'] = $postbruger;
$_SESSION['adgangskode'] = $postpass; //Sætter session variablerne
include('inc/main/loginsys/loggedin.php');
}else echo"De indtastede oplysninger er ikke korrekte";
};
break;
};
?>
rightmenu.php:
<?
$ip = $_SERVER['REMOTE_ADDR'];
$name = gethostbyaddr($_SERVER['REMOTE_ADDR']);
mysql_connect($mysql_host,$mysql_user,$mysql_password);
mysql_select_db("fjappedk");
$time = explode(" ",microtime());
$array1 = $time[0];
$array2 = $time[1];
$location = $_GET['QUERY_STRING'];
if ($location == null) {
$location = "/index.php";
};
$r = mysql_fetch_row( mysql_query("SELECT * FROM online_users WHERE ip like '$ip'"));
if ($r == (false)) {
mysql_query("INSERT INTO online_users (id,ip,name,location,date) values ('','$ip','$name','$location','$array2')");
}
mysql_query("DELETE FROM online_users where date < $array2 - 400");
$res = mysql_query("SELECT * FROM online_users");
$tal = mysql_num_rows($res);
$dDagNumMaaned = date('j'); // Dagens nummer i indeværende måned
// (et tal mellem 1-31, begge iregnet)
$dMaanedNumAar = date('n'); // Måneds nummer i året
//(et tal mellem 1-12, begge iregnet)
$dAarNu = date('Y'); // Indeværende år (4 cifre)
$dDagNumUge = date('w'); // Dagens nummer i indeværende uge
// (et tal mellem 0-6, begge iregnet)
$dagNavn[] = "Søndag";
$dagNavn[] = "Mandag";
$dagNavn[] = "Tirsdag";
$dagNavn[] = "Onsdag";
$dagNavn[] = "Torsdag";
$dagNavn[] = "Fredag";
$dagNavn[] = "Lørdag";
$maanedNavn[] = "Januar";
$maanedNavn[] = "Februar";
$maanedNavn[] = "Marts";
$maanedNavn[] = "April";
$maanedNavn[] = "Maj";
$maanedNavn[] = "Juni";
$maanedNavn[] = "Juli";
$maanedNavn[] = "August";
$maanedNavn[] = "September";
$maanedNavn[] = "Oktober";
$maanedNavn[] = "November";
$maanedNavn[] = "December";
$dagNavn = htmlentities($dagNavn[$dDagNumUge]);
$maanedNavn = htmlentities($maanedNavn[$dMaanedNumAar-1]);
?>
<?php
$aarnr = date(Y);
$maanednr = date(m);
$dagnr = date(d);
function ugenummer ($y, $m, $d) {
$dato = "$y-$m-$d"; // ÅÅÅÅ-MM-DD
$ugenummer = date("W",strtotime($dato));
return ($ugenummer);
}
?>
<br>
<img src="img/skillelinie2.gif" width="163" height="1" alt="" border="0"><br>
<table border="0" width="163" bgcolor="#D1DBE3" bordercolor="#D1DBE3">
<tr>
<td class="text" width="100%">
<strong> Community</strong>
</td>
</tr>
</table>
<img src="img/skillelinie2.gif" width="163" height="1" alt="" border="0"><br>
<?
if(!$_SESSION['logget_ind'] == 1) {//Hvis brugeren ikke er logget in
include('inc/main/loginsys/login.php');
}else{
include('inc/main/loginsys/community.php');
};
?>
<img src="img/skillelinie2.gif" width="163" height="1" alt="" border="0"><br>
<table border="0" width="163" bgcolor="#D1DBE3" bordercolor="#D1DBE3">
<tr>
<td class="text" width="100%">
<strong> Statistik</strong>
</td>
</tr>
</table>
<img src="img/skillelinie2.gif" width="163" height="1" alt="" border="0"><br>
<div onmouseover="style.backgroundColor='#D1DBE3'; style.bordercolor='#D1DBE3'; style.cursor='hand';" onmouseout="style.backgroundColor='transparent';" onclick="location.href='?mode=online&profile=guest'">
<table border="0" width="163">
<tr>
<td class="text" width="100%">
Gæster online:
<?
if ($tal <= "1") {
print "1";
}
else {
print $tal;
};
?>
</td>
</tr>
</table>
</div>
<div onmouseover="style.backgroundColor='#D1DBE3'; style.bordercolor='#D1DBE3'; style.cursor='hand';" onmouseout="style.backgroundColor='transparent';">
<table border="0" width="163">
<tr>
<td class="text" width="100%">
Profiler online: 70<br>
</td>
</tr>
</table>
</div>
<div onmouseover="style.backgroundColor='#D1DBE3'; style.bordercolor='#D1DBE3'; style.cursor='hand';" onmouseout="style.backgroundColor='transparent';">
<table border="0" width="163">
<tr>
<td class="text" width="100%">
Profiler ialt: 70<br>
</td>
</tr>
</table>
</div>
<img src="img/skillelinie2.gif" width="163" height="1" alt="" border="0"><br>
<table border="0" width="163">
<tr>
<td class="text" width="100%">
<?php echo "$dagNavn d. $dDagNumMaaned. $maanedNavn"; ?><br>
<?php echo "$dAarNu";?><br>
Uge: <?php echo ugenummer(£aarnr, £maanednr, $dagnr); ?>
</td>
</tr>
</table>
<img src="img/skillelinie2.gif" width="163" height="1" alt="" border="0"><br>
<table border="0" width="163">
<tr>
<td class="text" width="100%">
Genereringstid: <strong><? printf("%.4f", $CPUtime); ?>s.</strong><br>
</td>
</tr>
</table>
<img src="img/skillelinie2.gif" width="163" height="1" alt="" border="0"><br>
</tr>
</table>
</td>
</tr>
</table>
login.php:
<table border="0" width="163" cellspacing="0" cellpadding="0">
<tr>
<td class="text" width="100%">
<form action="?mode=login" method="post" name="login" width="163">
<font class="text"> Brugernavn</font>
<input type="text" width="150" class="inputbox" MAXLENGTH="30" name="brugernavn">
<font class="text"> Adgangskode</font>
<input type="password" width="150" class="inputbox" MAXLENGTH="40" name="adgangskode">
<br>
<input type="submit" name="Submit" value="login" class="loginknap">
<tr>
<td class="text" width="100%">
Gem Login: <input type="radio">
</td>
</tr>
</form>
</td>
</table>
<img src="img/skillelinie2.gif" width="163" height="1" alt="" border="0"><br>
<div onmouseover="style.backgroundColor='#D1DBE3'; style.bordercolor='#D1DBE3'; style.cursor='hand';" onmouseout="style.backgroundColor='transparent';">
<table border="0" width="163">
<tr>
<td class="text" width="100%">
Opret bruger<br>
</td>
</tr>
</table>
</div>
<div onmouseover="style.backgroundColor='#D1DBE3'; style.bordercolor='#D1DBE3'; style.cursor='hand';" onmouseout="style.backgroundColor='transparent';">
<table border="0" width="163">
<tr>
<td class="text" width="100%">
Glemt adgangskode?<br>
</td>
</tr>
</table>
</div>
<img src="img/skillelinie2.gif" width="163" height="1" alt="" border="0"><br><br>
loggedin.php:
<?php
if(!$_SESSION['logget_ind'] == 1) {//Hvis brugeren ikke er logget in
echo"Hvis du ikke er oprettet som bruger. Så opret dig :)";//Sender brugeren videre
exit;//Sørger for at resten af koden, ikke bliver udført
}
$loggedin = $_SESSION['logget_ind'];
$brugernavn = $_SESSION['brugernavn'];
$adgangskode = $_SESSION['adgangskode'];
$link = db_connect();
$sql = "SELECT * FROM brugere WHERE brugernavn = '$brugernavn' AND adgangskode = '$adgangskode'";
$res = db_query($sql, $link);
while($tab=mysql_fetch_array($res)) {
$status=$tab["status"];
};
if($status = 1) {
$status = "Administrator";
}elseif($status = 2) {
$status = "Skribent";
}else{
$status = "Normal Bruger";
};
echo "
<center>
<table border=\"0\" width=\"600\">
<tr>
<td bgcolor=\"#D1DBE3\" style=\"border-left: 1px solid #84A8BE; border-right: 1px solid #84A8BE; border-top: 1px solid #84A8BE; border-bottom: 1px solid #84A8BE;\"><center><Font class=\"text\"><b>Community</b></FONT></center></td>
</tr>
</table>
</center>
<br><br>
<center>
<table border=\"0\" width=\"600\">
<tr>
<td class=\"text\">Er du logget ind: $loggedin hej $brugernavn Du har fået tildelt følgende rettigheder på dette site: $status</td>
</tr>
</table>
</center>";
?>
Og sidst Community.php
<?if(!$_SESSION['logget_ind'] == 1) {//Hvis brugeren ikke er logget in
echo"Hvis du ikke er oprettet som bruger. Så opret dig :)";//Sender brugeren videre
exit;//Sørger for at resten af koden, ikke bliver udført
}
?>
<table border="0" width="163" cellspacing="0" cellpadding="0">
<tr>
<td class="text" width="100%">
<form action="?mode=login" method="post" name="login" width="163">
<font class="text"> Brugernavn</font>
<input type="text" width="150" class="inputbox" MAXLENGTH="30" name="brugernavn">
<font class="text"> Adgangskode</font>
<input type="password" width="150" class="inputbox" MAXLENGTH="40" name="adgangskode">
<br>
<input type="submit" name="Submit" value="login" class="loginknap">
<tr>
<td class="text" width="100%">
Gem Login: <input type="radio">
</td>
</tr>
</form>
</td>
</table>
<img src="img/skillelinie2.gif" width="163" height="1" alt="" border="0"><br>
<div onmouseover="style.backgroundColor='#D1DBE3'; style.bordercolor='#D1DBE3'; style.cursor='hand';" onmouseout="style.backgroundColor='transparent';">
<table border="0" width="163">
<tr>
<td class="text" width="100%">
Opret KURT<br>
</td>
</tr>
</table>
</div>
<div onmouseover="style.backgroundColor='#D1DBE3'; style.bordercolor='#D1DBE3'; style.cursor='hand';" onmouseout="style.backgroundColor='transparent';">
<table border="0" width="163">
<tr>
<td class="text" width="100%">
Glemt ÅGESVEN?<br>
</td>
</tr>
</table>
</div>
<img src="img/skillelinie2.gif" width="163" height="1" alt="" border="0"><br><br>
