Klistre to LETTE koder sammen
Hejsa alle små Eksperter derude :)!God jul og godt nytår.. Nu til det dramatiske ;)
Jeg er "RIMELIG" ny i php.. og jeg skal klistre disse to koder sammen fordi jeg har lavet et design til info side og det skal jeg så klistre sammen med den gamle kode sådan at det virker.. Jeg giver 200 points til den der vil klare det for mig.. Også vil jeg kigge koden igennem for også selv at lære lidt :)
HER ER MIN SIDE MED DESIGNET:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>NetCity</title>
<style type="text/css">
body { margin: 0px }
</style>
</head>
<body topmargin="0" leftmargin="0">
<table border="0" width="139" cellspacing="0" cellpadding="0">
<tr>
<td width="221" height="23">
<img border="0" src="menu_bar.bmp" width="219" height="23">
</td>
<td width="59" height="23">
<a href="java script:history.go(-1)">
<img border="0" src="back.bmp" width="60" height="23">
</a>
</td>
</tr>
<tr>
<td width="279" height="12" colspan="2"><img border="0" src="info.bmp"></td>
</tr>
<tr>
<td width="279" colspan="2">
<table border="0" width="100%">
<tr>
<td width="85%"><img border="0" src="gfx/brugernavn.bmp" width="72" height="5"></td>
<td width="15%"> </td>
</tr>
<tr>
<td width="85%"><font size="1" face="Verdana" color="#808080">HER SKAL
DEN PÅGÆLDENDE BRUGERS NAVN MAN HAR HENTET VISES</font></td>
<td width="15%"> </td>
</tr>
<tr>
<td width="85%"><font color="#808080"><img border="0" src="gfx/onlinetime.bmp" width="66" height="5"></font></td>
<td width="15%"> </td>
</tr>
<tr>
<td width="85%"><font size="1" face="Verdana" color="#808080">HER SKAL
DEN BRUGERS ONLINE TID HENTES</font></td>
<td width="15%"> </td>
<tr>
<td width="85%"><font color="#808080"><img border="0" src="gfx/credits.bmp" width="49" height="5"></font></td>
<td width="15%"> </td>
</tr>
<td width="85%"><font size="1" face="Verdana" color="#808080">HER SKAL
HANS CREDITS HENTES</font></td>
<td width="15%"> </td>
<tr>
<td width="85%"><font color="#808080"><img border="0" src="gfx/lejlighed.bmp" width="63" height="5"></font></td>
<td width="15%"> </td>
</tr>
<tr>
<td width="85%"><font size="1" face="Verdana" color="#808080">HER SKAL
HANS LEJLIGHEDS NUMMER HENTES FX. 100 (Gå til)</font></td>
<td width="15%"> </td>
</tr>
<td width="85%"><font color="#808080"><img border="0" src="gfx/fritekst.bmp" width="56" height="5"></font></td>
<td width="15%"> </td>
<tr>
<td width="85%"><font size="1" face="Verdana" color="#808080">HER SKAL
DER IKKE LAVES NOGET!!! DETTE FELT SKAM VÆRE TOMT OG DER SKAL IKKE
LAVES NOGET VED DET</font></td>
<td width="15%"> </td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
OG HER ER DEN INFO SIDE JEG HAR NU!!!
DET SKAL LIGE SIGES AT DENNE KODE INDEHOLDER OGSÅ EN MASSE ANDRE TING.. MEN DET ER IKKE MIG DER HAR LAVET DENNE KODE, DERFOR KENDER JEG DEN IKKE OG JEG ER JO HELLER IKEK GOD TIL PHP :)!
DE LINJER HVOR DER STÅR HVORDAN MAN HENTER DET ER VEL CA. LINJE 300
<?
include("../inc/password.php");
include("inc/header.php");
$select_info = mysql_query("SELECT username,room,rum,status,roomname,roommax,roombgpic FROM users WHERE(id='$id')");
$row_info = mysql_fetch_array($select_info);
if ($action=="ringerpaa") {
$room=addslashes($room);
$select_info2 = mysql_query("SELECT username FROM users WHERE(room='$room')");
$row_info2 =mysql_fetch_array($select_info2);
print "Du ringer nu på hos $row_info2[username].";
}
if ($action=="smidud") {
$uid = addslashes($uid);
$select_info2 = mysql_query("SELECT rum,status,username FROM users WHERE(id='$uid')");
$row_info2 = mysql_fetch_array($select_info2);
if ($row_info[room] != $row_info2[rum] && $row_info[status]=="0") {
print "Du kan kun smide folk ud der er i din egen lejlighed.";
}
elseif ($row_info2[status] > 0) {
print "Du kan ikke smide admins ud.";
} else {
print "$row_info2[username] blev smidt ud af rummet.";
$select_chatten = mysql_query("SELECT id FROM users WHERE(username='Chatten')");
$row_chatten = mysql_fetch_array($select_chatten);
$time = time();
mysql_query("INSERT INTO chat (rum,text,time,f,t) VALUES('$row_info[rum]','$row_info[username] smed $row_info2[username] ud af rummet $row_info[rum].','$time','$row_chatten[id]','0')");
mysql_query("UPDATE users SET botmes='$row_info[username] smed dig ud af rummet $row_info[rum].<Script>\n parent.bot.location=\"bot.php?action=changeroom&rum=1&smidud=true\";\n </Script>' WHERE (id='$uid')");
}
}
if($action=="indret") {
if ($row_info[rum] != $row_info[room]) {
print "Du skal være i din lejlighed for at indrette den!.";
exit;
}
$x=addslashes($x);
$y=addslashes($y);
$status=addslashes($status);
$roomname=addslashes($roomname);
$roommax=addslashes($roommax);
$roombg=addslashes($roombg);
$roomname = htmlspecialchars($roomname);
$roomname = str_replace("\\\'","'",$roomname);
print "<center><font size=\"4\">Indret Suite</font><br>";
print "<table cellspacing=\"0\" cellpadding=\"0\"><div style=\"position:absolute;z-index:-1\"><img src=\"../gfx/rum/$row_info[roombgpic]\" width=\"214\" height=\"180\"></div><tr>";
$i=0;
$y2=-70;
$x2=0;
while ($i < 35) {
if ($i%7==0) {
$y2=$y2+70;
$x2=0;
print "</tr><tr>";
}
$i++;
print "<td><a href=\"info.php?action=indret&x=$x2&y=$y2&felt=$i\"><img src=\"../gfx/spacer.gif\" width=\"30\" height=\"35\""; if ($felt!=$i) { print " border=\"0\""; } print "></a></td>";
$x2+=60;
}
print "</tr></table>";
if($x!="" && $y!="") {
if ($save=="true") {
if ($status=="url") {
if ($row_info[status]==0 && $row_info[room]>99) {
print "Kun admin kan lave URL.";
exit;
}
}
if ($status=="normal") {
mysql_query("DELETE FROM felter WHERE(rum='$row_info[room]' && x='$x' && y='$y')");
} else {
if (mysql_num_rows(mysql_query("SELECT x FROM felter WHERE(rum='$row_info[room]' && x='$x' && y='$y')"))=="0") {
mysql_query("INSERT INTO felter (rum,x,y,status,value) VALUES('$row_info[room]','$x','$y','$status','$value')");
} else {
mysql_query("UPDATE felter SET status='$status',value='$value' WHERE(rum='$row_info[room]' && x='$x' && y='$y')");
}
}
print "<font size=\"1\">Gemt.</font>";
}
$select_felt = mysql_query("SELECT status,value FROM felter WHERE(rum='$row_info[room]' && x='$x' && y='$y')");
$row_felt = mysql_fetch_array($select_felt);
print "<form>Felt $felt<br>
<select name=\"nyk\" onchange=\"changefelt(this.form.elements[0])\">
<option value=\"info.php?felt=$felt&action=indret&status=locked&save=true&x=$x&y=$y\""; if ($row_felt[status]=="locked") { print " selected"; } print ">Låst</option>
<option value=\"info.php?felt=$felt&action=indret&status=normal&save=true&x=$x&y=$y\""; if (mysql_num_rows($select_felt)==0) { print " selected"; } print ">Normal</option>
";
if ($row_info[status]>0 || $row_info[room]<101) {
print "
<option value=\"info.php?felt=$felt&action=indret&status=url&save=true&x=$x&y=$y\"";
if ($row_felt[status]=="url") { print " selected"; } print ">URL</option>
";
}
print "
</select>";
if ($row_felt[status]=="url") {
print "</form>
<form action=\"info.php?action=indret&x=$x&y=$y&status=url&save=true&felt=$felt\">
<input type=\"hidden\" name=\"action\" value=\"indret\">
<input type=\"hidden\" name=\"x\" value=\"$x\">
<input type=\"hidden\" name=\"y\" value=\"$y\">
<input type=\"hidden\" name=\"status\" value=\"url\">
<input type=\"hidden\" name=\"save\" value=\"true\">
<input type=\"hidden\" name=\"felt\" value=\"$felt\">
URL: <input type=\"text\" name=\"value\" value=\"$row_felt[value]\"><br>
<input type=\"submit\" value=\"Gem\" class=\"submit\">";
}
print "</form>";
}
if ($roomname && $roommax && $roombg) {
mysql_query("UPDATE users SET roomname='$roomname',roommax='$roommax',roombg='$roombg' WHERE(id='$id')");
print "
<Script>
parent.chat.location='chat.php?framecheck=true';
parent.besked.location='besked.php';
parent.beskeder.document.bgColor='#A0BEBF'
</Script>
";
}
$select_roominfo = mysql_query("SELECT roomname,roommax,roombg FROM users WHERE(id='$id')");
$row_roominfo = mysql_fetch_array($select_roominfo);
print "
<font size=\"1\">
<form action=\"info.php\">
<input type=\"hidden\" name=\"action\" value=\"indret\">
<input type=\"hidden\" name=\"roombg\" value=\"000000\">
Suite Navn : <input type=\"text\" name=\"roomname\" maxlength=\"15\" value=\"$row_roominfo[roomname]\" class=\"text\"><br>
Max antal i din lejlighed : <input type=\"text\" name=\"roommax\" maxlength=\"2\" value=\"$row_roominfo[roommax]\" class=\"text\"><br>
<input type=\"submit\" value=\"Gem\" class=\"submit\">
</form>
";
}
if($action=="options") {
print "
<center>
<font size=\"4\">Instillingerr</font>
<form name=\"options\" action=\"java script:showinfo(1)\">
<input type=\"submit\" name=\"showinfo\" class=\"submit\">
</form>
<input type=\"button\" onclick=\"parent.beskeder.document.body.innerHTML = '<font color=#000000 face=verdana size=1>Chatvinduet er tømt.<br>'\" class=\"submit\" value=\"Tøm Textbox\">";
if ($row_info[room]!=0) {
print "
<form action=\"info.php\">
<input type=\"hidden\" name=\"action\" value=\"indret\">
<input type=\"submit\" class=\"submit\" value=\"Indret Lejlighed\">
</form>
";
}
print "
<Script>
showinfo(0)
</Script>
";
}
if ($action=="changeroom") {
$select_rooms = mysql_query("SELECT room,roomname,roommax FROM users WHERE(room !=0 && onlinechat!=0) ORDER BY room");
print mysql_error();
while($row_rooms = mysql_fetch_array($select_rooms)) {
$select_visitors = mysql_query("SELECT id FROM users WHERE(rum='$row_rooms[room]')");
$you="";
if ($row_rooms[room] == $row_info[rum]) {
$you = "<font size=\"1\"><b></b></font>";
}
if ($row_rooms[room] < 100) {
$normalrooms .= "
<tr>
<td>[<b>$row_rooms[room]</b>]</td>
<td>
<font size=\"1\"><a href=\"java script:changeroom($row_rooms[room])\">$row_rooms[roomname]</a>
</td>
<td> <font size=\"1\">(".mysql_num_rows($select_visitors)."/$row_rooms[roommax])
</td>
<td>
</td><td> $you
</td>
</tr>";
} else {
$privaterooms .= "
<tr>
<td><font size=\"1\">[<b>$row_rooms[room]</b>]</td>
<td><font size=\"1\">
<a target=\"bot\""; if ($row_rooms[room]!=$row_info[room]) { $privaterooms .= " onclick=\"document.location='info.php?action=ringerpaa&room=$row_rooms[room]'\""; } $privaterooms .= " href=\"bot.php?action=changeroom&rum=$row_rooms[room]\">$row_rooms[roomname]</a>
</td>
<td> <font size=\"1\">(".mysql_num_rows($select_visitors)."/$row_rooms[roommax])
</td>
<td>
</td><td> $you
</td>
</tr>";
}
}
print "<table height=\"18\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">$normalrooms</table><br><br><table height=\"18\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">$privaterooms</table>";
}
if ($action=="showuser") {
$uid = addslashes($uid);
$select_info = mysql_query("SELECT username,room,alder,onlinetid,spir,sex,rum,onlinechat FROM users WHERE(id='$uid')");
$row_info = mysql_fetch_array($select_info);
$result_info2 = mysql_query("SELECT rum,room,status FROM users WHERE(id='$id')");
$row_info2 = mysql_fetch_array($result_info2);
$sex = ucwords($row_info[sex]);
$online = "<br><br>$sex er ikke længere online på chatten.";
if ($row_info[onlinechat] != "0")
{
$temphour = $row_info[onlinetid]/60/60;
$hour = floor($temphour);
$tempmin = $row_info[onlinetid]/60;
$min = $tempmin-$hour*60;
$min = floor($min);
$now = time();
$min2 = $now-$row_info[onlinechat];
$min2 = $min2/60;
$min2 = floor($min2);
function level($onlinechat) {
if ($onlinechat < 1) {$level = 1; }
elseif ($onlinechat < 4) { $level = 2; }
elseif ($onlinechat < 5) { $level = 3; }
elseif ($onlinechat < 10) { $level = 4; }
elseif ($onlinechat < 12) { $level = 5; }
elseif ($onlinechat < 15) { $level = 6; }
elseif ($onlinechat < 20) { $level = 7; }
elseif ($onlinechat < 35) { $level = 8; }
elseif ($onlinechat < 50) { $level = 9; }
elseif ($onlinechat < 75) { $level = 10; }
elseif ($onlinechat < 100) { $level = 11; }
elseif ($onlinechat < 125) { $level = 12; }
elseif ($onlinechat < 150) { $level = 13; }
elseif ($onlinechat < 200) { $level = 14; }
elseif ($onlinechat < 250) { $level = 15; }
elseif ($onlinechat < 350) { $level = 16; }
elseif ($onlinechat < 500) { $level = 17; }
elseif ($onlinechat < 700) { $level = 18; }
elseif ($onlinechat < 1000) { $level = 19; }
elseif ($onlinechat < 1500) { $level = 20; }
return $level;
}
$online = "";
}
echo "<BR>";
echo "<BR>";
print "<font size=\"1\"><br><b>Bruger: </b>$row_info[username] </u></b>
<br><b>Credits: </b>".floor($row_info[spir])."<br><b>Online tid:</b> $hour</b> timer og $min min.<br><b>Loggede på chatten:</b> $min2 min. siden<br><b>Level: </b> ".level($hour)."";
if ($row_info[room] != "0") {
print "<font size=\"1\"><br><b>Lejlighed: </b>$row_info[room] <a href=\"bot.php?action=changeroom&rum=$row_info[room]\" target=\"bot\"> (Gå dertil)";
}
if ($row_info2[room2] != $row_info[room] && $row_info[room] != 0) {
print "<font size=\"1\"><br><br><a href=\"bot.php?action=changeroom&rum=$row_info[room]\" target=\"bot\"><b>$room_info[room]</b></a><BR>";
}
if ($row_info[rum] == $row_info2[room] || $row_info2[status] > 0) {
if ($uid != $id) {
print "<br><font size=\"1\"><a href=\"info.php?action=smidud&uid=$uid\">Kick</a>";
}
}
print "$online<br><br><left>";
$result_ting = mysql_query("SELECT id,tingname,figur FROM ting WHERE(owner='$uid')");
if (mysql_num_rows($result_ting) != 0)
{
while($row_ting = mysql_fetch_array($result_ting)) {
print "<font size=\"1\"><b><h4><u>$row_ting[tingname]</u></h4></b><font size=\"1\"><a href=\"info.php?action=showthing&tid=$row_ting[id]\"><img src=\"../gfx/ting/$row_ting[figur]\" border=\"0\"><br><img src=\"../gfx/spacer.gif\" border=\"0\"></a><br><font size=\"1\"><b></b><font size=\"1\"><br>";
$i++;
}
print "";
}
if($i==0)
{
print "<font size=\"1\">Denne bruger ejer ingen ting!";
}
}
if ($action=="pickupthing") {
$tid = addslashes($tid);
$pickupting = addslashes($pickupthing);
$select_ting_info = mysql_query("SELECT tingname,value,rum,owner,x,y FROM ting WHERE(id='$tid')");
$row_ting_info = mysql_fetch_array($select_ting_info);
$select_user_info = mysql_query("SELECT rum,x,y,status,room,spir FROM users WHERE(id='$id')");
$row_user_info = mysql_fetch_array($select_user_info);
$select_room_info = mysql_query("SELECT roomstatus FROM users WHERE(room='$row_ting_info[rum]')");
$row_room_info = mysql_fetch_array($select_room_info);
if ($row_user_info[rum] != $row_ting_info[rum] || $row_user_info[y] != $row_ting_info[y] || $row_user_info[x] != $row_ting_info[x]) {
print "<font size=\"1\">Du står ikke på tingen!";
}
elseif ($row_user_info[room] != $row_user_info[rum] && $row_user_info[rum] > 99) {
print "<font size=\"1\">Du kan ikke samle op i en andens lejlighed!";
}
elseif ($row_room_info[roomstatus]=="1" && $row_ting_info[value] > $row_user_info[spir]) {
print "<font size=\"1\">Du har ikke Credits nok.";
}
else {
if ($row_room_info[roomstatus]=="1") {
mysql_query("UPDATE users SET spir=spir-$row_ting_info[value] WHERE(id='$id')");
$ext = " <font size=\"1\">Du har nu <b>".floor($row_user_info[spir]-$row_ting_info[value])."</b> credits.";
}
if(ereg("And",$row_ting_info[tingname])) {
mysql_query("UPDATE users SET fisk=fisk+1 WHERE(id='$id')");
$select_info2 = mysql_query("SELECT fisk FROM users WHERE(id='$id')") or die("FEJL");
$row_info2 = mysql_fetch_array($select_info2);
mysql_query("UPDATE ting SET rum='0',owner='-1',x='',y='',tingname='Chilliplante',value='2',figur='chilliplante.gif' WHERE(id='$tid')");
print "<font size=\"1\">Du har nu <b>$row_info2[fisk]</b> ænder.";
} else {
mysql_query("UPDATE ting SET rum='0',owner='$id',x='',y='' WHERE(id='$tid')");
print "<font size=\"1\">Du fik $row_ting_info[tingname].$ext
<Script>
parent.bot.location='bot.php';
</Script>
";
}
}
}
if ($action=="dropthing") {
$tid = addslashes($tid);
$pickupting = addslashes($dropthing);
$select_ting_info = mysql_query("SELECT tingname,owner,value FROM ting WHERE(id='$tid')");
$row_ting_info = mysql_fetch_array($select_ting_info);
$select_user_info = mysql_query("SELECT rum,x,y,id,spir FROM users WHERE(id='$id')");
$row_user_info = mysql_fetch_array($select_user_info);
$select_room_info = mysql_query("SELECT roomstatus FROM users WHERE(room='$row_user_info[rum]')");
$row_room_info = mysql_fetch_array($select_room_info);
if ($row_ting_info[owner] != "$id") {
print "<font size=\"1\">Du ejer ikke denne ting, og kan derfor ikke smide den.";
} else {
if ($row_room_info[roomstatus] == "1") {
$ext = " <font size=\"1\">Du har nu <b>".floor($row_user_info[spir]+$row_ting_info[value])."</b> Credits.";
mysql_query("UPDATE users SET spir=spir+$row_ting_info[value] WHERE(id='$id')");
}
mysql_query("UPDATE ting SET owner='0',rum='$row_user_info[rum]',x='$row_user_info[x]',y='$row_user_info[y]' WHERE(id='$tid')");
print "<font size=\"1\">$row_ting_info[tingname] blev smidt.$ext<br>
<Script>
parent.bot.location='bot.php';
</Script>
";
}
}
if ($action=="showthing") {
$tid = addslashes($tid);
$visting = addslashes($visting);
$select_ting_info = mysql_query("SELECT tingname,value,rum,owner FROM ting WHERE(id='$tid')");
$row_ting_info = mysql_fetch_array($select_ting_info);
if ($row_ting_info[owner] != "0") {
$owner = $row_ting_info[owner];
} else {
if ($row_ting_info[rum] < 100) {
$owner = "Ingen";
} else {
$select_owner_info = mysql_query("SELECT id FROM users WHERE(room='$row_ting_info[rum]')");
$row_owner_info = mysql_fetch_array($select_owner_info);
$owner = $row_owner_info[id];
}
}
if ($owner == "$id" && $row_ting_info[rum] == "0") {
$youraction = "<a href=\"info.php?action=dropthing&tid=$tid\">Smid $row_ting_info[tingname]</a>";
} else {
if ($row_ting_info[rum] < 100 || $row_info[room] == $row_ting_info[rum]) {
$youraction = "<a href=\"info.php?action=pickupthing&tid=$tid\">Samle Op</a>";
}
}
if ($owner != "Ingen") {
$select_owner_info = mysql_query("SELECT username FROM users WHERE(id='$owner')");
$row_owner_info = mysql_fetch_array($select_owner_info);
$owner = $row_owner_info[username];
}
print "<br>
<b>Ting:</b> $row_ting_info[tingname]<br>
<b>Værdi:</b> $row_ting_info[value]<br>
<b>ID:</b> $tid<br>
<br>
$youraction";
}
?>
<meta name="generator" content="Namo WebEditor v5.0(Trial)">
<p> </p>
