Here is the full code of inbox with married code include, if u can find anything wrong with SQL-query.
Text in swedish.
<?php
session_start();
include_once "databas.php";
include_once "funktioner.php";
include"figurer.php";
logincheck();
echo "<link href=includes/in.css rel=stylesheet type=text/css> ";
$username = $_SESSION['username'];
$mysql=mysql_query("SELECT * FROM users WHERE username='$username'");
$fetch=mysql_fetch_object($mysql);
if ($_POST['Accept_get_away']){
$sjakie = mysql_query("SELECT * from get_away where invite_get='$username'");
$sjakie2 = mysql_fetch_assoc($sjakie);
$oc_id = $sjakie2['id'];
$abc = mysql_num_rows(mysql_query("SELECT * FROM get_away WHERE id='$oc_id' AND invite_get='$username'"));
if ($abc != "0"){
if ($fetch->get_away == "1"){ echo "DU är på flykt!"; }elseif ($fetch->get_away == "0"){
if ($fetch->get_away_time > time()){ echo "Du måste vänta ett tag."; }elseif ($fetch->get_away_time < time()){
mysql_query("UPDATE get_away SET person='$username' WHERE id='$oc_id'");
mysql_query("UPDATE users SET get_away='1' WHERE username='$username'");
echo "Du är nu i ett race.";
}
}}
}
if (strip_tags($POST['Accept_marriage'] && $GET['accept'] == "marry")){
$marriewhom = strip_tags($_GET['marrie_who']);
$lyegdfgdfgdf = mysql_num_rows(mysql_query("SELECT *
FROM married
WHERE starter = '$username'
OR other = '$username' AND done = '1'"));
if ($lyegdfgdfgdf != "0"){
echo "Du är redan gift.";
}elseif ($lyegdfgdfgdf == "0"){
mysql_query("UPDATE married SET done='1' WHERE starter='$marriewhom' AND other='$username'");
echo "Gratulerar, du har gift dig med $marriewhom!";
//}else{
//echo "Av någon underlig anledning har du inte blivit tillfrågade att gifta dig med $marriewhom";
//}
}}
if (strip_tags($POST['join_crew']) && strip_tags($POST['invite_crew'])){
$invite_crew = strip_tags($_POST['invite_crew']);
if ($invite_crew == "1"){
$***=mysql_fetch_object(mysql_query("SELECT FROM users WHERE username='$username'"));
$true=mysql_fetch_object(mysql_query("SELECT FROM crews WHERE id='$**->crew_invite'"));
$numba = mysql_num_rows(mysql_query("SELECT FROM users WHERE crew='$true->crew'"));
if ($numba >= $true->size){
echo "Det är fullt i gänget, du får leta vidare!";
}else{
mysql_query("DELETE FROM inbox WHERE event_id='$****->crew_invite'");
mysql_query("UPDATE users SET crew='$true->name', crew_invite='0' WHERE username='$username'");
echo "Du är en i gänget!";
}}
}
if (strip_tags($POST['Accept_OC'])){
$oc_id=strip_tags($POST['oc_id']);
if (strip_tags($POST['place']) == "we"){
$use="we_inv";
$a="we";
$query= "SELECT FROM oc WHERE we_inv='$username' AND id='$oc_id'";
}elseif (strip_tags($POST['place']) == "ee"){
$use="ee_inv";
$a="ee";
$query= "SELECT FROM oc WHERE ee_inv='$username' AND id='$oc_id'";
}elseif (strip_tags($_POST['place']) == "driver"){
$use="driver_inv";
$a="driver";
$query= "SELECT * FROM oc WHERE driver_inv='$username' AND id='$oc_id'";
}
$round=mysql_query($query);
$check=mysql_num_rows($round);
if ($check != "0"){
echo "Du är nu i OC.";
mysql_query("UPDATE oc SET $a='$username' WHERE id='$oc_id'");
mysql_query("UPDATE users SET oc='1' WHERE username='$username'");
}
}
if (strip_tags($POST['Yes_street'])){
$race_id=strip_tags($POST['race_id']);
if ($fetch->street != "0"){ echo "Du är i ett race."; }elseif ($fetch->street == "0"){
if ($fetch->last_race >= time()){ echo "Du kan inte köra annat race ännu."; }elseif ($fetch->last_race < time()){
$aa=mysql_query("SELECT FROM street WHERE id='$race_id' AND op_invite='$username'");
$check=mysql_num_rows($aa);
$=mysql_fetch_object($aa);
if ($check == "0"){
echo "Det har blivit ett fel. Meddela ledaren för en ny inbjudan.";
}elseif ($check != "0"){
if ($->prize == "Money"){
$new_money=$fetch->money - $->prize_win;
if ($fetch->money < $->prize_win){
echo "Du har inte råd!";
}elseif ($fetch->money >= $***->prize_win){
mysql_query("UPDATE users SET street='1', money='$new_money' WHERE username='$username'");
mysql_query("UPDATE street SET op_username='$username' WHERE id='$****->id'");
echo "Du är nu i racet.";
}
}else{
mysql_query("UPDATE street SET op_username='$username' WHERE id='$****->id'");
mysql_query("UPDATE users SET street='1' WHERE username='$username'");
echo "Du är nu i racet.";
}}}
}}
echo "<form action='' method=POST name=f><table width='68%' border='1' align='center' cellpadding='0' cellspacing='0' class=thinline rules=none>
<tr>
<td><table width='100%' border='0' cellspacing='3' cellpadding='0'>
<tr>
<td width='48%'> <div align='right'>
<input name='Dall' type='submit' id='Dall' value='Delete All'>
</div></td>
<td width='26%'> <div align='left'>
<input name='D_s' type='submit' id='Delete_s' value='Delete Selected'>
</div></td>
<td width='26%'> <div align='left'> </div></td>
</tr>
</table></td>
</tr>
</table><br>";
if ($POST['Delete']){
$del=$POST['Delete'];
$checker = mysql_query("SELECT * FROM inbox WHERE to ='$username' AND id ='$del' ");
$rows=mysql_num_rows($checker);
if ($rows > "0"){
echo "Meddelande borttaget!";
mysql_query("DELETE FROM inbox WHERE id='$del'");
}}////END DELETE THERE MSG
if (strip_tags($POST['Dall'])){
mysql_query("DELETE FROM inbox WHERE saved='0' AND to='$username'");
echo "<center><b>Alla meddelanden borttagna.</b></center><br>";
}
if (strip_tags($POST['D_s'])){
foreach($_POST['radio'] as $value) {
$count++;
mysql_query("DELETE FROM inbox WHERE id='$value'");
}
echo "$count brev borttagna<br>";
}
echo "<center>";
$mysql1 = mysql_query("SELECT * FROM inbox WHERE to='$username' AND saved ='0' ORDER by date DESC");
$num_rows =mysql_num_rows($mysql1);
if ($num_rows == "0"){
echo "Du har inga brev i inkorgen.";
}else{
while($get = mysql_fetch_object($mysql1)){
$t++;
$n++;
echo "
<table width='68%' border='1' align='center' cellpadding='0' cellspacing='0' class=thinline rules=none>
<tr>
<td background=includes/grad.jpg><center>
From:<a href='profile.php?viewuser=$get->from'>$get->from</a> On:$get->date</center></td>
</tr>
<tr bgcolor=black><td height=1></td></tr>
<tr>
<td><table width='100%' border='0' cellspacing='3' cellpadding='0'>
<tr>
<td colspan='3'>".replace($get->message)."</td>
</tr>";
if ($get->witness == "1"){ echo "<tr><td>Vittne - ID: $get->id</td></tr>"; }
echo "<tr>
<td width='6%' height='23'><input type=\"checkbox\" name=\"radio[]\" value=\"$get->id\"></td>
</tr>
</table></td>
</tr>
</table><br>
";
}}
echo "</form>";
mysql_query("UPDATE inbox SET read='1' WHERE to='$username'");
echo "</center>";
require_once"nere.php";
?>