Quote:
Hallo,
so sollte es eigentlich gehen:
PHP Code:<meta charset="utf-8" />
<?php
$step = $_GET["step"];
$MYSQL_PLAYER_DATABASE = "nbnnbnbv";
$MYSQL_HOST = "nh";
$MYSQL_USERNAME = "n";
$MYSQL_PASSWORD = "nh";
if ($step == 2 ){
$player_name = $_POST["playerName"];
$player_Id = 0;
$connection = mysql_connect($MYSQL_HOST,$MYSQL_USERNAME,$MYSQL_PASSWORD) or die ("Could not connect to Database.");
mysql_select_db($MYSQL_PLAYER_DATABASE)or die ("The Database does not Exist -,-");
//$requestId = "SELECT * FROM `player` WHERE `name` = '".$player_name LIMIT 0, 100";
$requestId = "SELECT * FROM player WHERE name = '".$player_name."'";
$resultId = mysql_query($requestId)or die(mysql_error());
$resultreq = mysql_fetch_object($resultId);
$player_Id = $resultreq->id;
if ($resultreq->name == $player_name){
$requestItems = "SELECT * FROM item WHERE owner_id = $player_Id ";
$resultItemQuery = mysql_query($requestItems)or die(mysql_error());
$i = 0;
$ItemArray = array();
while ( $row = mysql_fetch_assoc($resultItemQuery) )
{
$ItemArray[$i] = $row;
$i++;
}
//echo "Count: ".$i."";?> <br> <?php
/*echo "<pre>";
print_r($ItemArray);
echo "</pre>";*/?>
<?php
$read = 0;
echo "Name" ?> - <?php echo "Boni's Ändern"; ?> <br><br><?php
while($i != $read){
$vnum = $ItemArray[$read]['vnum'];
$Item_protoQuery = "SELECT locale_name, type, wearflag FROM item_proto WHERE vnum = $vnum";
$resultItem_proto = mysql_query($Item_protoQuery)or die(mysql_error());
$data = array();
while ($row = mysql_fetch_assoc($resultItem_proto)) {
$data[] = $row;
}
if (($data[0]['type'] == 1) || ($data[0]['type'] == 2)){
if ($data[0]['wearflag'] != 128 || 256 || 512){
$was = array("ä", "ö", "ü", "Ä", "Ö", "Ü", "ß");
$wie = array("ae", "oe", "ue", "Ae", "Oe", "Ue", "ss");
$in = $data[0]['locale_name'];
$out = str_replace($was, $wie, $in);
echo "".$out."";
?>
<form action="item_attr.php?step=3" method="post">
<input type="hidden" value="<?php echo $vnum; ?>" size="24" maxlength="50"name="item_vnum">
<input type="hidden" value="<?php echo $player_Id; ?>" size="24" maxlength="50"name="owner_vnum">
<input type="submit" value="Ändern">
</form> <br><br>
<?php
}
}
$read++;
}
?>
<?php
}
}else if ( $step == 3 ){
$connection = mysql_connect($MYSQL_HOST,$MYSQL_USERNAME,$MYSQL_PASSWORD) or die ("Could not connect to Database.");
mysql_select_db($MYSQL_PLAYER_DATABASE)or die ("The Database does not Exist -,-");
$owner_id = $_POST['owner_vnum'];
$gegenstand = $_POST['item_vnum'];
echo 'Werte_ID: '.$gegenstand.' WERTE_OWNER'.$owner_id.' und???';
/*$boniQuery = "SELECT * FROM item WHERE vnum = $gegenstand";
$resultBonusList = mysql_query($boniQuery)or die(mysql_error());
$boni_list = array();
while ($row = mysql_fetch_assoc($resultBonusList)) {
$boni_list[] = $row;
}
print_r($boni_list);*/
}else{
?>
<form action="item_attr.php?step=2" method="post">
Spielername:<br>
<input type="text" value="Test" size="24" maxlength="20" name="playerName"><br><br>
<input type="submit" value="Abschicken">
</form>
<?php
}
?>
mit echo gings auchnicht, habe es nochgestern über >GET gelöst, es werdne ja keine geheimen daten die übergeben werden.