Listing 1529

Submitted by ami, 22 August 2008

<?
 
  include "config.php";
  
  if (empty($_SESSION['sid'])) {
      include "index.php";
      die();
  }
  
  security();
  
  //eventuelle Befehle ausführen (Truppen löschen/eintragen)
  if (isset($_GET['del'])) {
      include "delete.php";
  }
  if (isset($_POST['x1'])) {
      include "send.php";
  }
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
 
<html>
<head>
<title>Trooptool - <?=text('user_header')?></title>
<link rel="stylesheet" type="text/css" href="style.css">
<script type="text/javascript" src="overlib/overlib.js"><!-- overLIB (c) Erik Bosrup --></script>
<script type="text/javascript">
<!--
 
    function showforms(formname, formtext, refresh_site) {
        if (document.getElementById(formname).style.display == "none") {
            document.getElementById(formname).style.display = "block";
            document.getElementById(formtext).style.display = "none";
        }
        else {
            document.getElementById(formname).style.display = "none";
            document.getElementById(formtext).style.display = "block";
            if (refresh_site) {
                window.location="user.php";
            }
        }
    }
 
    function askdel(tid, site) {
        Check = confirm("<?=text('user_askdel')?>");
        if (Check == true) window.location.href = site + '?del=' + tid;
    }
 
//-->
</script>
 
 
 
</head>
<body>
<div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000; border:1px black solid;"></div>
<div class="oben"><? include "oben.php"; ?></div>
 
<div class="menu"><? include "menu.php"; ?></div>
 
<div class="mitte2" align="center">
 
<table class="itable2" cellpadding="2" cellspacing="1">
    <tr>
        <td class="header1" colspan="17"><?=text('user_header')?></td>
    </tr>
<?
  //--Tabellenheader
  //Zeilenanfang
  echo "<tr>";
  //Herkunft
  echo "<td class=\"header2\" width=\"85\" colspan=\"1\">".text('user_her')."</td>";
  //Standort
  echo "<td class=\"header2\" width=\"85\" colspan=\"1\">".text('user_sta')."</td>";
  //Volk (10 Truppenspalten)
  for ($i=1; $i<=10; $i++) {
      echo "<td class=\"header2\" width=\"20\"><img src=\"".img_pfad($volk, $i)."\" title=\"".text('t_'.$volk.$i)."\" alt=\"".text('t_'.$volk.$i)."\"></td>";
  }
  //zwei Leerspalten
  echo "<td class=\"header2\" colspan=\"3\"></td>";
  //Zeilenende
  echo "</tr>";
  
  //--Abfrage der Trupen aus der Datenbank
  $sql="SELECT
          tid,
          x1, y1,
          herkunft,
          x2, y2,
          standort,
          g1, g2, g3, g4, g5, g6, g7, g8, g9, g10, g11, g12, g13, g14, g15,
          gt1, gt2, gt3, gt4, gt5, gt6, gt7, gt8, gt9, gt10, gt11, gt12, gt13, gt14, gt15,
          t1, t2, t3, t4, t5, t6, t7, t8, t9, t10
        FROM
          ".PREFIX."truppen
        WHERE
          sid='".(int) $sid."'";
  $result = mysql_query($sql) OR die(mysql_error());
  
  //--Anzeige der Truppen
  while ($row = mysql_fetch_assoc($result)) {
      //Zeilenbeginn
      echo "<tr>";
        //Herkunft ami*
      // echo "<td title=\"".stripslashes($row['herkunft'])."\">".$row['herkunft']."</td>";
      //Herkunft
      echo "<td title=\"".stripslashes($row['herkunft'])."\">(".$row['x1']."|".$row['y1'].")</td>";
      //Standort ami*
      //  echo "<td title=\"".stripslashes($row['standort'])."\">".$row['standort']."</td>";      
      //Standort
      echo "<td title=\"".stripslashes($row['standort'])."\">(".$row['x2']."|".$row['y2'].")</td>";
      //Truppen
      for ($i=1; $i<=10; $i++) {
        echo "<td>".zero($row['t'.$i])."</td>";
    }
    
    //Grups ami*
    // echo "<td><img src=img/grup.gif >=0;</td>";
    
    
    //bearbeiten
    echo "<td><a href=\"?edit=".$row['tid']."\"><img src=\"img/edit.gif\" title=\"".text('edit')."\"></a></td>";
    //löschen
    echo "<td><a href=\"javascript: askdel(".$row['tid'].", 'user.php');\"><img src=\"img/del.gif\" title=\"".text('del')."\"></a></td>";
    //Zeilenende
    echo "</tr>";
  }
  
  //--Anzeige der Summe
  echo "<tr><td colspan=\"2\" class=\"header2\"><b>".text('admin_sum')."</b></td>";
  //Summenberechnung
  $sql="SELECT
          sum(t1), sum(t2), sum(t3), sum(t4), sum(t5), sum(t6), sum(t7), sum(t8), sum(t9), sum(t10)
        FROM
          ".PREFIX."truppen
        WHERE
          sid='".$sid."'";
  $result = mysql_query($sql) OR die(mysql_error());
  $row = mysql_fetch_assoc($result);
  for ($i=1; $i<=10; $i++) {
      echo "<td class=\"zeile2\">".zero($row['sum(t'.$i.')'])."</td>";
  }
  //leere Zellen am Ende der Zeile
  echo "<td colspan=\"3\" class=\"zeile2\"></td>";
  //Zeilenende
  echo "</tr>";
  //--Ende der Tabelle
  echo "</table>";
?>
<br>
 
<!-- -- --neue Truppen eintragen/alte bearbeiten-- -- -->
<div id="formtext"><a href="javascript:showforms('forms', 'formtext', 1)"><?=text('user_showforms')?></a></div><br><br>
<?
  if (isset($_GET['edit']) AND is_numeric($_GET['edit'])) {
      $display = "";
      $display2 = "";
      $sql="SELECT
              x1, y1,
              herkunft,
              x2, y2,
              standort,
            g1, g2, g3, g4, g5, g6, g7, g8, g9, g10, g11, g12, g13, g14, g15,
            gt1, gt2, gt3, gt4, gt5, gt6, gt7, gt8, gt9, gt10, gt11, gt12, gt13, gt14, gt15,              
            t1, t2, t3, t4, t5, t6, t7, t8, t9, t10,
            sid
          FROM
            ".PREFIX."truppen
          WHERE
            tid='".(int) $_GET['edit']."'";
    $result=mysql_query($sql) OR die(mysql_error());
      $row = mysql_fetch_assoc($result);
      if ($sid == $row['sid']) {
       for ($i=1; $i<=10; $i++) {
          $t[$i] = $row['t'.$i];
       }
          for ($i=1; $i<=15; $i++) {
          $g[$i] = $row['g'.$i];
       }
          for ($i=1; $i<=15; $i++) {
          $gt[$i] = $row['gt'.$i];
       }       
      
       $x1 = $row['x1'];
       $y1 = $row['y1'];
       $x2 = $row['x2'];
       $y2 = $row['y2'];
       $herkunft = $row['herkunft'];
       $standort = $row['standort'];
      } else {
       die("Sie haben keine Berechtigung diesen Wert zu &auml;ndern.<br><a href='user.php'>zur&uuml;ck</a>");
     }
  } else {
      $display = " style='display: none'";
      $display2 = "";
      $_GET['edit'] = 0;
      for ($i=1; $i<=10; $i++) {
       $t[$i] = 0;
     }
     for ($i=1; $i<=15; $i++) {
       $g[$i] = 0;
     }
        for ($i=1; $i<=15; $i++) {
       $gt[$i] = 0;
     } 
    
     $x1       = 0;        $x2       = 0;
     $y1       = 0;        $y2       = 0;
     $herkunft = "";        $standort = "";
 
  }
 
?>
<div id="forms" class="formular"<?=$display?>>
 
<form action="user.php" method="POST">
  <input type="hidden" name="edit" value="<?=(int) $_GET['edit']?>">
    <table class="itable" cellpadding="2" cellspacing="1" width="350">
        <tr class="header1">
            <td colspan="3" class="header1"><?=text('user_form_header')?><a href="javascript:showforms('forms', 'formtext', 1)"><img src="img/close.png" style="position:absolute; right:2px; top:2px;" height="18" width="18"></a></td>
        </tr>
        <tr>
            <td colspan="2" class="header2"><?=text('user_her')?>:</td>
            <td><input class="ibox f80" type="text" name="her" value="<?=$herkunft?>" maxlength="20"> ( <input class="ibox f30" type="text" name="x1" value="<?=$x1?>" maxlength="4"> | <input class="ibox f30" type="text" name="y1" value="<?=$y1?>" maxlength="4"> ) </td>
        </tr>
        <tr>
            <td colspan="2" class="header2"><?=text('user_sta')?>:</td>
            <td><input class="ibox f80" type="text" name="sta" value="<?=$standort?>" maxlength="20"> ( <input class="ibox f30" type="text" name="x2" value="<?=$x2?>" maxlength="4"> | <input class="ibox f30" type="text" name="y2" value="<?=$y2?>" maxlength="4"> ) </td>
        </tr>
                        <tr>
            <td colspan="3">
              <table id="regex"<?=$display2?>>
                <tr>
                      <td><br /></td>            
                </tr>
              </table>
            </td>
        </tr>
        <tr>
          <td colspan="3">
          <table class="itable" cellpadding="2" cellspacing="0" width="300"<?=$display2?> id="manuell">
<?
  for($i=1; $i<=10; $i++) {
      echo "<tr>";
    echo "<td width=\"20\"><img src=\"".img_pfad($volk, $i)."\">";
    echo "<td width=\"170\" class=\"header2\">".text('t_'.$volk.$i)."</td>";
    echo "<td width=\"110\" align=\"center\"><input class=\"ibox f30\" type=\"text\" maxlength=\"4\" name=\"t".$i."\" value=\"".$t[$i]."\"></td>";
    echo "</tr>";
  }
?>
 
 
              
            </table>  
          </td>
        </tr>
        
        <tr>
                <td colspan="3" height="0"><br /><p>Kolejna heroiczna próba, nie zwracajcie na to uwagi, i tym bardziej tego nie tykajcie.</p></td>
              </tr>
        
 
         <tr>
          <td colspan="3">
          <table class="itable" cellpadding="2" cellspacing="0" width="300"<?=$display2?> id="manuell">
 
 
    
          
<?
  for($i=1; $i<=15; $i++) {
      echo "<tr>";
      echo "<td width=\"190\" class=\"header2\" colspan=\"2\" ><select style=\"width: 150px;\" name=\"gt".$i."\">";
      echo "<option value=\"0\"> --- </option>" ;
      echo "<option value=\"1\"> ".text('t_'.$volk.'1')." </option> <option value=\"2\"> ".text('t_'.$volk.'2')." </option> <option value=\"3\"> ".text('t_'.$volk.'3')." </option> " ;
      echo "<option value=\"4\"> ".text('t_'.$volk.'4')." </option> <option value=\"5\"> ".text('t_'.$volk.'5')." </option> <option value=\"6\"> ".text('t_'.$volk.'6')." </option> <option value=\"7\"> ".text('t_'.$volk.'7')." </option> <option value=\"8\"> ".text('t_'.$volk.'8')." </option>" ;
      echo "</select></td>" ;      
    echo "<td width=\"110\" align=\"center\"><input class=\"ibox f30\" type=\"text\" maxlength=\"2\" name=\"g".$i."\" value=\"".$g[$i]."\"></td>";
    echo "</tr>";
  }
?>
                   
              
            </table>  
          </td>
        </tr>
 
 
 
        
        <tr>
            <td colspan="3"><input class="submit" type="submit" value="<?=text('save')?>"></td>
        </tr>
    </table>
  </form>
</div>
</div>
</body>
</html>

Submit a Follow Up

Your Name:

Your Email:

Language:

Your Code*:

<?
 
  include "config.php";
  
  if (empty($_SESSION['sid'])) {
  	include "index.php";
  	die();
  }
  
  security();
  
  //eventuelle Befehle ausführen (Truppen löschen/eintragen)
  if (isset($_GET['del'])) {
  	include "delete.php";
  }
  if (isset($_POST['x1'])) {
  	include "send.php";
  }
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
<title>Trooptool - <?=text('user_header')?></title>
<link rel="stylesheet" type="text/css" href="style.css">
<script type="text/javascript" src="overlib/overlib.js"></script>
<script type="text/javascript">
<!--

function askdel(tid, site) {
        Check = confirm("<?=text('user_askdel')?>");
        if (Check == true) window.location.href = site + '?del=' + tid;
    }

//-->
</script>

</head>
<body>
<div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000; border:1px black solid;"></div>
<div class="oben"><? include "oben.php"; ?></div>

<table class="itable2" cellpadding="2" cellspacing="1">
	<tr>
		<td class="header1" colspan="17"><?=text('user_header')?></td>
	</tr>
<?
  //--Tabellenheader
  //Zeilenanfang
  echo "<tr>";
  //Herkunft
  echo "<td class=\"header2\" width=\"85\" colspan=\"1\">".text('user_her')."</td>";
  //Standort
  echo "<td class=\"header2\" width=\"85\" colspan=\"1\">".text('user_sta')."</td>";
  //Volk (10 Truppenspalten)
  for ($i=1; $i<=10; $i++) {
  	echo "<td class=\"header2\" width=\"20\"><img src=\"".img_pfad($volk, $i)."\" title=\"".text('t_'.$volk.$i)."\" alt=\"".text('t_'.$volk.$i)."\"></td>";
  }
  //zwei Leerspalten
  echo "<td class=\"header2\" colspan=\"3\"></td>";
  //Zeilenende
  echo "</tr>";
  
  //--Abfrage der Trupen aus der Datenbank
  $sql="SELECT
          tid,
          x1, y1,
          herkunft,
          x2, y2,
          standort,
          g1, g2, g3, g4, g5, g6, g7, g8, g9, g10, g11, g12, g13, g14, g15,
          gt1, gt2, gt3, gt4, gt5, gt6, gt7, gt8, gt9, gt10, gt11, gt12, gt13, gt14, gt15,
          t1, t2, t3, t4, t5, t6, t7, t8, t9, t10
        FROM
          ".PREFIX."truppen
		WHERE
		  sid='".(int) $sid."'";
  $result = mysql_query($sql) OR die(mysql_error());
  
  //--Anzeige der Truppen
  while ($row = mysql_fetch_assoc($result)) {
  	//Zeilenbeginn
  	echo "<tr>";
        //Herkunft ami*
  	// echo "<td title=\"".stripslashes($row['herkunft'])."\">".$row['herkunft']."</td>";
  	//Herkunft
  	echo "<td title=\"".stripslashes($row['herkunft'])."\">(".$row['x1']."|".$row['y1'].")</td>";
  	//Standort ami*
  	//  echo "<td title=\"".stripslashes($row['standort'])."\">".$row['standort']."</td>";  	
  	//Standort
  	echo "<td title=\"".stripslashes($row['standort'])."\">(".$row['x2']."|".$row['y2'].")</td>";
  	//Truppen
  	for ($i=1; $i<=10; $i++) {
	    echo "<td>".zero($row['t'.$i])."</td>";
    }
    
    //Grups ami*
    // echo "<td><img src=img/grup.gif >=0;</td>";
    
    
    //bearbeiten
    echo "<td><a href=\"?edit=".$row['tid']."\"><img src=\"img/edit.gif\" title=\"".text('edit')."\"></a></td>";
    //löschen
    echo "<td><a href=\"javascript: askdel(".$row['tid'].", 'user.php');\"><img src=\"img/del.gif\" title=\"".text('del')."\"></a></td>";
    //Zeilenende
    echo "</tr>";
  }
  
  //--Anzeige der Summe
  echo "<tr><td colspan=\"2\" class=\"header2\"><b>".text('admin_sum')."</b></td>";
  //Summenberechnung
  $sql="SELECT
          sum(t1), sum(t2), sum(t3), sum(t4), sum(t5), sum(t6), sum(t7), sum(t8), sum(t9), sum(t10)
        FROM
          ".PREFIX."truppen
		WHERE
		  sid='".$sid."'";
  $result = mysql_query($sql) OR die(mysql_error());
  $row = mysql_fetch_assoc($result);
  for ($i=1; $i<=10; $i++) {
  	echo "<td class=\"zeile2\">".zero($row['sum(t'.$i.')'])."</td>";
  }
  //leere Zellen am Ende der Zeile
  echo "<td colspan=\"3\" class=\"zeile2\"></td>";
  //Zeilenende
  echo "</tr>";
  //--Ende der Tabelle
  echo "</table>";
?>
<br>

<div id="formtext"><a href="javascript:showforms('forms', 'formtext', 1)"><?=text('user_showforms')?></a></div><br><br>
<?
  if (isset($_GET['edit']) AND is_numeric($_GET['edit'])) {
  	$display = "";
  	$display2 = "";
  	$sql="SELECT
  	        x1, y1,
  	        herkunft,
  	        x2, y2,
  	        standort,
            g1, g2, g3, g4, g5, g6, g7, g8, g9, g10, g11, g12, g13, g14, g15,
            gt1, gt2, gt3, gt4, gt5, gt6, gt7, gt8, gt9, gt10, gt11, gt12, gt13, gt14, gt15,  	        
            t1, t2, t3, t4, t5, t6, t7, t8, t9, t10,
            sid
          FROM
            ".PREFIX."truppen
          WHERE
            tid='".(int) $_GET['edit']."'";
    $result=mysql_query($sql) OR die(mysql_error());
  	$row = mysql_fetch_assoc($result);
  	if ($sid == $row['sid']) {
 	  for ($i=1; $i<=10; $i++) {
 	 	$t[$i] = $row['t'.$i];
 	  }
          for ($i=1; $i<=15; $i++) {
 	 	$g[$i] = $row['g'.$i];
 	  }
          for ($i=1; $i<=15; $i++) {
 	 	$gt[$i] = $row['gt'.$i];
 	  } 	  
	  
 	  $x1 = $row['x1'];
 	  $y1 = $row['y1'];
 	  $x2 = $row['x2'];
 	  $y2 = $row['y2'];
 	  $herkunft = $row['herkunft'];
 	  $standort = $row['standort'];
  	} else {
 	  die("Sie haben keine Berechtigung diesen Wert zu &auml;ndern.<br><a href='user.php'>zur&uuml;ck</a>");
 	}
  } else {
  	$display = " style='display: none'";
  	$display2 = "";
  	$_GET['edit'] = 0;
  	for ($i=1; $i<=10; $i++) {
 	  $t[$i] = 0;
 	}
 	for ($i=1; $i<=15; $i++) {
 	  $g[$i] = 0;
 	}
        for ($i=1; $i<=15; $i++) {
 	  $gt[$i] = 0;
 	} 
	
 	$x1       = 0;		$x2       = 0;
 	$y1       = 0;		$y2       = 0;
 	$herkunft = "";		$standort = "";

}

?>
<div id="forms" class="formular"<?=$display?>>

<form action="user.php" method="POST">
  <input type="hidden" name="edit" value="<?=(int) $_GET['edit']?>">
    <table class="itable" cellpadding="2" cellspacing="1" width="350">
        <tr class="header1">
            <td colspan="3" class="header1"><?=text('user_form_header')?><a href="javascript:showforms('forms', 'formtext', 1)"><img src="img/close.png" style="position:absolute; right:2px; top:2px;" height="18" width="18"></a></td>
        </tr>
        <tr>
            <td colspan="2" class="header2"><?=text('user_her')?>:</td>
            <td><input class="ibox f80" type="text" name="her" value="<?=$herkunft?>" maxlength="20"> ( <input class="ibox f30" type="text" name="x1" value="<?=$x1?>" maxlength="4"> | <input class="ibox f30" type="text" name="y1" value="<?=$y1?>" maxlength="4"> ) </td>
        </tr>
        <tr>
            <td colspan="2" class="header2"><?=text('user_sta')?>:</td>
            <td><input class="ibox f80" type="text" name="sta" value="<?=$standort?>" maxlength="20"> ( <input class="ibox f30" type="text" name="x2" value="<?=$x2?>" maxlength="4"> | <input class="ibox f30" type="text" name="y2" value="<?=$y2?>" maxlength="4"> ) </td>
        </tr>
                        <tr>
		    <td colspan="3">
		      <table id="regex"<?=$display2?>>
			    <tr>
		              <td><br /></td>			
			    </tr>
			  </table>
			</td>
		</tr>
		<tr>
		  <td colspan="3">
		  <table class="itable" cellpadding="2" cellspacing="0" width="300"<?=$display2?> id="manuell">
<?
  for($i=1; $i<=10; $i++) {
  	echo "<tr>";
	echo "<td width=\"20\"><img src=\"".img_pfad($volk, $i)."\">";
	echo "<td width=\"170\" class=\"header2\">".text('t_'.$volk.$i)."</td>";
	echo "<td width=\"110\" align=\"center\"><input class=\"ibox f30\" type=\"text\" maxlength=\"4\" name=\"t".$i."\" value=\"".$t[$i]."\"></td>";
	echo "</tr>";
  }
?>

</table>  
		  </td>
		</tr>
		
		<tr>
			    <td colspan="3" height="0"><br /><p>Kolejna heroiczna próba, nie zwracajcie na to uwagi, i tym bardziej tego nie tykajcie.</p></td>
			  </tr>

<tr>
		  <td colspan="3">
		  <table class="itable" cellpadding="2" cellspacing="0" width="300"<?=$display2?> id="manuell">

<?
  for($i=1; $i<=15; $i++) {
  	echo "<tr>";
  	echo "<td width=\"190\" class=\"header2\" colspan=\"2\" ><select style=\"width: 150px;\" name=\"gt".$i."\">";
  	echo "<option value=\"0\"> --- </option>" ;
  	echo "<option value=\"1\"> ".text('t_'.$volk.'1')." </option> <option value=\"2\"> ".text('t_'.$volk.'2')." </option> <option value=\"3\"> ".text('t_'.$volk.'3')." </option> " ;
  	echo "<option value=\"4\"> ".text('t_'.$volk.'4')." </option> <option value=\"5\"> ".text('t_'.$volk.'5')." </option> <option value=\"6\"> ".text('t_'.$volk.'6')." </option> <option value=\"7\"> ".text('t_'.$volk.'7')." </option> <option value=\"8\"> ".text('t_'.$volk.'8')." </option>" ;
  	echo "</select></td>" ;  	
	echo "<td width=\"110\" align=\"center\"><input class=\"ibox f30\" type=\"text\" maxlength=\"2\" name=\"g".$i."\" value=\"".$g[$i]."\"></td>";
	echo "</tr>";
  }
?>
             	  
			  
            </table>  
		  </td>
		</tr>

Enter Security Code*: