galera, seguinte, criei um simples script para mostrar a list de quests de um jogo! porem eu queria fazer um script para atualizar as quests, dados que ficam faltando e tal... isso é o que tenho até agora: atualizar.php <?php
include "include/config.php";
include "include/language.php";
$id = $_GET['id'];
$query = "SELECT * FROM hero_quests WHERE id='$id'";
$result = mysql_query("SELECT * FROM hero_quests");
$num = mysql_num_rows($result);
mysql_close();
$i = 0;
while ($i < $num) {
$tipo = mysql_result($result, $i, "tipo");
$_GET['id'] = mysql_result($result, $i, "id");
$level = mysql_result($result, $i, "level");
$localizacao = mysql_result($result, $i, "localizacao");
$quest = mysql_result($result, $i, "quest");
$recompensa = mysql_result($result, $i, "recompensa");
$descricao = mysql_result($result, $i, "descricao");
$item = mysql_result($result, $i, "item");
$conversa = mysql_result($result, $i, "conversa");
$dicas = mysql_result($result, $i, "dicas");
?>
<form action="atualizado.php" method="POST" >
<table width="778">
<tr>
<td width="90">
<?php echo "$lang_type";
?>: </td>
<td width="678"> <select size="1" name='ud_tipo'>
<option selected><?php echo "$tipo";
?></option>
<option>Quest</option>
<option>Justice</option>
<option>Story</option>
</select></td>
</tr>
<tr>
<td width="90">
<tr>
<td width="90">
<?php echo "$lang_level";
?>: </td>
<td width="678"> <input type="text" value='<?php echo "$level";
?>' name='ud_level' maxlength='3' size="1"/></td>
</tr>
<tr>
<td width="90">
<?php echo "$lang_location";
?>: </td>
<td width="678"> <select size="1" name='ud_localizacao'>
<option selected><?php echo "$localizacao";
?></option>
<option>Ho-Nam - Dragon Castle</option>
<option>Ho-Nam - Highlands</option>
<option>Ho-Nam - Venom Swamp</option>
<option>Ho-Nam - Spirit Spire</option>
<option>Sa-Chum - Southern Plain</option>
<option>Sa-Chum - Central Isle</option>
<option>Sa-Chum - Mudo Island</option>
</select></td>
</tr>
<tr>
<td width="90">
<?php echo "$lang_quest";
?>: </td>
<td width="678"> <input type='text' value='<?php echo "$quest";
?>' name='ud_quest' maxlength='200' size="58"/></td>
</tr>
<tr>
<td width="90">
<?php echo "$lang_reward";
?>: </td>
<td width="678"> <input type='text' value='<?php echo "$recompensa";
?>' name='ud_recompensa' maxlength='200' size="58"/></td>
</tr>
<tr>
<td valign="top" width="90">
<?php echo "$lang_description";
?>: </td>
<td width="678"> <textarea rows="3" value='<?php echo "$descricao";
?>' name='ud_descricao' cols="44"></textarea></td>
</tr>
<tr>
<td width="90">
<?php echo "$lang_request";
?>: </td>
<td width="678"> <input type='text' value='<?php echo "$item";
?>' name='ud_item' maxlength='200' size="58"/></td>
</tr>
<tr>
<td valign="top" width="90">
<?php echo "$lang_conversation";
?>: </td>
<td width="678"> <textarea rows="9" value='<?php echo "$conversa";
?>' name='ud_conversa' cols="44"></textarea></td>
</tr>
<tr>
<td valign="top" width="90">
<?php echo "$lang_tips";
?>: </td>
<td width="678"> <textarea rows="6" value='<?php echo "$dicas";
?>' name='ud_dicas' cols="44"></textarea></td>
</tr>
<tr>
<td colspan="2">
<table id="table1" width="471">
<tr>
<td>
<input name="ud_id" type='hidden' value='<?php echo $_GET['id'];
?>'>
<p align="center"><input type='submit' value='<?php echo "$lang_sendbutton";
?>'>
<input type='reset' value='<?php echo "$lang_resetbutton";
?>'></td>
</tr>
</table> </td>
</tr>
</table>
<?php
++$i;
}
?>
atualizador.php
<?php
include "include/config.php";
$query = "UPDATE hero_quest SET level='" . $_POST['ud_level'] . "', localizacao='" . $_POST['ud_localizacao'] . "', quest='" . $_POST['ud_quest'] . "', recompensa='" . $_POST['ud_recompensa'] . "', descricao='" . $_POST['ud_descricao'] . "', item='" . $_POST['ud_item'] . "', conversa='" . $_POST['ud_conversa'] . "', dicas='" . $_POST['ud_dicas'] . "', tipo='" . $_POST['ud_tipo'] . "', WHERE id='" . $_POST['ud_id'] . "'";
echo $query;
$checkresult = mysql_query($query);
if ($checkresult) echo '<p>Quest atualizada com sucesso!';
else echo '<p>Falha na atualização!';
mysql_close();
?>
como forma de procurar por erros eu coloquei: echo $query; e if ($checkresult) echo '<p>Quest atualizada com sucesso!'; else echo '<p>Falha na atualização!'; para verificar, e ele mostra falha na atualização.. queria saber o que posso fazer :(
