Hallo erstmal, bin mir jetzt nicht sicher ob ich hier richtig bin oder nicht 
ich denke aber mal eher hier als bei mysql
Zu meinem Problem:
Ich habe ein PHP script was ich einigermaßen anpassen musste,
Dabei geht es um ein User control panel für ein Spiel...
Darin sind verschiedene Fraktion aufgeführt wo es möglich ist sich bei genannten zu bewerben...wenn ich jetzt auf den Punkt bewerben gehe und die erforderlichen Daten eingebe und diese Bewerbung Absende kommt nichts in der Datenbank an...
Den genauen Fehler weiß ich jedoch nicht
Ich vermute dass im script der Bereich mit dem "insert into" nicht genügend gefüllt ist
Oder aber auch das mir spalten in der Datenbank fehlen ich habe dort momentan 6 spalten...ich bin mir nur nicht ganz sicher ob es alle nötigen sind
Hier mal der Code:
<?php
if ($_GET['do'] == 'settings')
{
if(isset($_SESSION['user']))
{
$fraktion = @mysql_result(@mysql_query("SELECT Leader FROM accounts where name='".$_SESSION['user']."'"), 0 );
if($fraktion != 0)
{
$fraktion_leader = @mysql_result(@mysql_query("SELECT name FROM accounts where Leader='".$fraktion."'"), 0 );
$fraktion_member_count = @mysql_num_rows(@mysql_query("SELECT * FROM accounts where member = '".$fraktion."'"));
$fraktion_desc = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='".$fraktion."'"), 0 );
$min_level = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='".$fraktion."'"), 0 );
$application_stop = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='".$fraktion."'"), 0 );
if(isset($_POST['submit']))
{
$set_desc = clean_it(nl2br($_POST['desc']));
$set_min_level = clean_it($_POST['min_level']);
$set_application_stop = clean_it($_POST['application_stop']);
mysql_query("UPDATE `fraktion` SET description='$set_desc', min_level='$set_min_level', application_stop='$set_application_stop' WHERE id='$fraktion'");
echo 'Erfolgreich gespeichert!';
}
echo '<fieldset><legend>'. fraktion($fraktion) .'</legend>
<table class="fraktion">
<form method="post">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'. $fraktion_leader .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $fraktion_member_count .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td><select name="min_level"><option value="'. $min_level .'">'. $min_level .'</option><option value=""></option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option></select></td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">Bewerbungsstop:</td><td><select name="application_stop"><option value="1">Ja</option><option value="2">Nein</option></select></td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td><textarea name="desc">'. $fraktion_desc .'</textarea></td></tr>
<tr><td class="key" width="120px"></td><td><input type="submit" name="submit" value="Save"></td></tr>
</table>
</form>
</fieldset>';
///// Bewerbungen /////
$application = mysql_query("SELECT * FROM application where fraktion=". $fraktion ." AND done=1");
while($application_table = @mysql_fetch_array($application)){
echo '
<style type="text/css">
table#app td{border:1px solid #221d2c;}
</style>
<table id="app" width="50%">
<tr><td class="key">Name</td><td class="key">Level</td><td class="key">Grund</td><td>Status</td></tr>
<tr><td>'. $application_table['name'] .'</td><td>'. $application_table['level'] .'</td><td>'. $application_table['reason'] .'</td><td><a href="ajax.php?a=frakdone&frakid='. $application_table['id'] .'">Done</a></td></tr>
</table>
';
}
}
}
else
{
echo '<div class="fail">Du must eingelogt sein!</div>';
}
}
else if($_GET['do'] == 'apply')
{
if(isset($_SESSION['user']))
{
$ausgabe = '';
if(($_POST['send_application']))
{
$application_fraktion = clean_it($_POST['app_id']);
$application_reason = clean_it($_POST['reason']);
$application_name = clean_it($_SESSION['user']);
$application_level = mysql_result(mysql_query("SELECT level FROM accounts where name='". $_SESSION['user'] ."'"), 0);
$is_in_fraktion = mysql_result(mysql_query("SELECT member FROM accounts where name='". $_SESSION['user'] ."'"),0);
$is_in_leader = mysql_result(mysql_query("SELECT Leader FROM accounts where name='". $_SESSION['user'] ."'"),0);
$min_level_app = mysql_result(mysql_query("SELECT min_level FROM fraktion where id='". $fraktion ."'"),0);
if(empty($application_fraktion) or empty($application_reason) or empty($application_name) or empty($application_level))
{$ausgabe = '<div class="fail">Bitte fülle alle Felder aus.</div>';}
elseif ($is_in_fraktion != 0)
{$ausgabe = '<div class="fail">Du bist bereits in einer Fraktion.</div>';}
elseif ($is_in_leader != 0)
{$ausgabe = '<div class="fail">Du bist bereits in einer Fraktion.</div>';}
/*elseif ($min_level_app < $application_level)
{$ausgabe = '<div class="fail">Dein Level ist zu niedrig!</div>';}*/
else
{
mysql_query("INSERT INTO application VALUES('', '$application_name', '$application_fraktion', '$application_level', '$application_reason', 1)");
}
}
$app_id = @mysql_query("SELECT id FROM fraktion where application_stop = 2");
echo $ausgabe;
echo '<form method="post">
<table>
<tr><td class="key">Fraktion:</td><td><select name="app_id">';
while($application_select = @mysql_fetch_array($app_id))
{
echo '<option value="'. $application_select['id'].'">'. fraktion($application_select['id']) .'</option>';
}
echo '</select></td></tr>
<tr><td class="key">Grund:</td><td><textarea name="reason"></textarea></td></tr>
<tr><td></td><td><input type="submit" name="send_application" value="Bewerbung abschicken"></td></tr></table>
</form>';
}
else
{
echo '<div class="fail">Du must eingelogt sein!</div>';
}
}
else
{
if(isset($_SESSION['user']))
{
$fraktion_leader = @mysql_result(@mysql_query("SELECT Leader FROM accounts where name='".$_SESSION['user']."'"), 0 );
if($fraktion_leader != 0)
{
echo '<a href="index.php?site=fraktion&do=settings" style="color:hsl(0,100%,50%)">Fraktionseinstellungen</a><br>';
}
$user_level = @mysql_result(@mysql_query("SELECT level FROM accounts where id='".$_SESSION['user']."'"), 0 );
$leader_sapd = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "1"'), 0 );
$member_count_sapd = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "1"'));
$desc_sapd = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='1'"), 0 );
$min_level_sapd = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='1'"), 0 );
$application_stop_sapd = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='1'"), 0 );
$leader_fbi = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "2"'), 0 );
$member_count_fbi = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "2"'));
$desc_fbi = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='2'"), 0 );
$min_level_fbi = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='2'"), 0 );
$application_stop_fbi = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='2'"), 0 );
$leader_sani = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "4"'), 0 );
$member_count_sani = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "4"'));
$desc_sani = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='4'"), 0 );
$min_level_sani = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='4'"), 0 );
$application_stop_sani = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='4'"), 0 );
$leader_lcm = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "5"'), 0 );
$member_count_lcm = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "5"'));
$desc_lcm = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='5'"), 0 );
$min_level_lcm = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='5'"), 0 );
$application_stop_lcm = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='5'"), 0 );
$leader_yakuza = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "6"'), 0 );
$member_count_yakuza = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "6"'));
$desc_yakuza = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='6'"), 0 );
$min_level_sapd = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='1'"), 0 );
$application_stop_sapd = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='1'"), 0 );
$leader_hitman = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "8"'), 0 );
$member_count_hitman = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "8"'));
$desc_hitman = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='8'"), 0 );
$min_level_hitman = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='8'"), 0 );
$application_stop_hitman = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='8'"), 0 );
$leader_news_reporter = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "9"'), 0 );
$member_count_news_reporter = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "9"'));
$desc_news_reporter = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='9'"), 0 );
$min_level_news_reporter = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='9'"), 0 );
$application_stop_news_reporter = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='9'"), 0 );
$leader_grove = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "12"'), 0 );
$member_count_grove = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "12"'));
$desc_grove = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='12'"), 0 );
$min_level_grove = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='12'"), 0 );
$application_stop_grove = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='12'"), 0 );
$leader_ballas = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "13"'), 0 );
$member_count_ballas = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "13"'));
$desc_ballas = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='13'"), 0 );
$min_level_ballas = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='13'"), 0 );
$application_stop_ballas = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='13'"), 0 );
$leader_sfrive = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "22"'), 0 );
$member_count_sfrive = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "18"'));
$desc_sfrive = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='18'"), 0 );
$min_level_sfrive = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='18'"), 0 );
$application_stop_sfrive = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='18'"), 0 );
$leader_rmafia = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "23"'), 0 );
$member_count_rmafia = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "23"'));
$desc_rmafia = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='23'"), 0 );
$min_level_rmafia = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='23'"), 0 );
$application_stop_rmafia = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='23'"), 0 );
$leader_ordnungsamt = @mysql_result(@mysql_query('SELECT name FROM accounts where Leader = "18"'), 0 );
$member_count_ordnungsamt = @mysql_num_rows(@mysql_query('SELECT * FROM accounts where member = "18"'));
$desc_ordnungsamt = @mysql_result(@mysql_query("SELECT description FROM fraktion where id='18'"), 0 );
$min_level_ordnungsamt = @mysql_result(@mysql_query("SELECT min_level FROM fraktion where id='18'"), 0 );
$application_stop_ordnungsamt = @mysql_result(@mysql_query("SELECT application_stop FROM fraktion where id='18'"), 0 );
echo '
<fieldset><legend>San Andreas Police Department</legend>
<img src="images/misc/sapd.png" alt="SAPD" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_sapd)){echo $leader_sapd; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_sapd .'</td></tr>
<tr><td class="key" width="120px" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_sapd > $user_level){echo $min_level_sapd;}else{echo'<span class="stop">'. $min_level_sapd .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_sapd .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_sapd == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
<fieldset><legend>Federal Bureau of Investigation</legend>
<img src="images/misc/fbi.png" alt="SAPD" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_fbi)){echo $leader_fbi; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_fbi .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_fbi > $user_level){echo $min_level_fbi;}else{echo'<span class="stop">'. $min_level_fbi .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_fbi .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_fbi == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
<fieldset><legend>Sanitäter</legend>
<img src="images/misc/sanitäter.png" alt="Sanitäter" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_sani)){echo $leader_sani; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_sani .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_sani > $user_level){echo $min_level_sani;}else{echo'<span class="stop">'. $min_level_sani .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_sani .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_sani == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
<fieldset><legend>La Cosa Nostra</legend>
<img src="images/misc/lcn.png" alt="LCN" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_lcm)){echo $leader_lcm; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_lcm .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_lcm > $user_level){echo $min_level_lcm;}else{echo'<span class="stop">'. $min_level_lcm .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_lcm .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_lcm == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
<fieldset><legend>Yakuza</legend>
<img src="images/misc/yakuzza.png" alt="Yakuzza" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_yakuza)){echo $leader_yakuza; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_yakuza .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_yakuza > $user_level){echo $min_level_yakuza;}else{echo'<span class="stop">'. $min_level_yakuza .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_yakuza .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_yakuza == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
<fieldset><legend>Hitman</legend>
<img src="images/misc/hitman.png" alt="Hitman" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_hitman)){echo $leader_hitman; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_hitman .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_hitman > $user_level){echo $min_level_hitman;}else{echo'<span class="stop">'. $min_level_hitman .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_hitman .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_hitman == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
<fieldset><legend>News Reporter</legend>
<img src="images/misc/reporter.png" alt="Reporter" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_news_reporter)){echo $leader_news_reporter; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_news_reporter .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_news_reporter > $user_level){echo $min_level_news_reporter;}else{echo'<span class="stop">'. $min_level_news_reporter .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_news_reporter .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_news_reporter == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
<fieldset><legend>Grove Street</legend>
<img src="images/misc/grove.png" alt="Grove Street" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_grove)){echo $leader_grove; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_grove .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_grove > $user_level){echo $min_level_grove;}else{echo'<span class="stop">'. $min_level_grove .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_grove .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_grove == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
<fieldset><legend>Ballas</legend>
<img src="images/misc/ballas.png" alt="SAPD" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_ballas)){echo $leader_ballas; }else{echo '<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_ballas .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_ballas > $user_level){echo $min_level_ballas;}else{echo'<span class="stop">'. $min_level_ballas .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_ballas .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_ballas == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
<fieldset><legend>S.F. Rifa</legend>
<img src="images/misc/sfrifa.png" alt="SAPD" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_sfrive)){echo $leader_sfrive; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_sfrive .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_sfrive > $user_level){echo $min_level_sfrive;}else{echo'<span class="stop">'. $min_level_sfrive .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_sfrive .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_sfrive == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
<fieldset><legend>Russen Mafia</legend>
<img src="images/misc/russenmafia.png" alt="SAPD" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_rmafia)){echo $leader_rmafia; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_rmafia .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_rmafia > $user_level){echo $min_level_rmafia;}else{echo'<span class="stop">'. $min_level_rmafia .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_rmafia .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_rmafia == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
<fieldset><legend>Ordnungsamt</legend>
<img src="images/misc/ordnungsamt.png" alt="SAPD" align="left" style="margin-right:5px;">
<table class="fraktion">
<tr><td class="key" width="120px"><img src="images/misc/frak_leader.gif" alt="Leader">Leader:</td><td>'; if(!empty($leader_ordnungsamt)){echo $leader_ordnungsamt; }else{echo'<span class="none">Kein Leader</span>';} echo '</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_member.gif" alt="Member">Member:</td><td>'. $member_count_ordnungsamt .'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_anforderung.gif" alt="Mindest Level">Mindestlevel:</td><td>'; if($min_level_ordnungsamt < $user_level){echo $min_level_ordnungsamt;}else{echo'<span class="stop">'. $min_level_sapd .'</span>';} echo'</td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_info.gif" alt="Beschreibung">Beschreibung:</td><td>'. $desc_ordnungsamt .'</td></tr>
<tr><td> </td><td> </td></tr>
<tr><td class="key" width="120px"><img src="images/misc/frak_nobw.gif" alt="">'; if($application_stop_ordnungsamt == 1){echo'<span class="stop">Bewerbungsstop</span>';}else{echo'<a href="index.php?site=fraktion&do=apply" class="transition">Bewerben</a>';} echo'</td></tr>
</table>
</fieldset>
';
}
else
{
include('includes/login.php');
}
}
?>
Alles anzeigen
Ich hoffe ihr könnt mit verraten welche spalten ich in der Tabelle "application" brauche und warum keine Bewerbung versendet wird ;/
Mfg Chris
