Update Script

[Furyan]

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 :(

[skolroots]

da uma olhada nos campos que são do tipo integer....

aí não vai ''(aspas simples)

tipo...

WHERE id='" . $_POST['ud_id'] . "'";

se esse campo é inteiro...deixa ele assim:

WHERE id= . $_POST['ud_id] . ";";

vlw

[Guest Visitante]

obrigado cara... eu já havia resolvido! :)

mas é bom pra ficar pra galera que procurar a mesma duvida ficar sabendo! ^^