Edit pr?b

[Chris2k]

hey guys,

here is my mod: http://pastebin.com/sixSKzxx

The problem is when i click $_post['esub']

it shud bring that record ($site) for ediitting, however its bringing the last record up to edit...

Any1 can help? spent the laast 8hrs trya figure.....

Chris2k Reviewed by Chris2k on 3rd Feb 2012. Edit pr?b hey guys, here is my mod: http://pastebin.com/sixSKzxx The problem is when i click $_post it shud bring that record ($site) for ediitting, however its bringing the last record up to edit... Any1 can help? spent the laast 8hrs trya figure..... Rating: 5

[jokerhacker]

try to dump $site

var_dump($site); 

add it under

 if (isset($_POST['esub'])) {
           $site = $_POST['site']; 

[Chris2k]

wot u mean?

replace $site...........;?

Srry i iz a noob.

[l0calh0st]

This is what jokerhacker suggested:

        $bwurl = $_POST['bwurl'];
        $bwmail = $_POST['bwemail'];
        $bwdate = $_POST['bwdate'];
        $reason = $_POST['bwreason'];
        $bwsub = $_POST['bwsubmit'];
        $edit = $_POST['esub'];
        $modifysub = $_POST['save'];

        $html .= '<form method="post"><table width="100%">
        <tr>
        <td>Site URL</td><td>Date</td><td>Reason</td><td>Email</td><td>Remove/Edit</td></tr>
        <h1>Latest 125 Blacklisted Sites</h1>';
        $acpquery = mysql_query("SELECT * FROM wcddl_blacklist ORDER BY dat DESC LIMIT 125");
        while ($row = mysql_fetch_assoc($acpquery)) {
            $html .= '<tr>
            <td>'.$row['url'].'</td>
            <td>'.$row['dat'].'</td>
            <td>'.$row['reason'].'</td>
            <td>'.$row['email'].'</td>
            <td><input type="checkbox" name="remove[]" value="'.$row['url'].'"><input type="hidden" name="site" value="'.$row['url'].'">
            <button type="submit" name="esub"><img src="/modules/wcp/images/edit-icon.png" title="Edit Item" /></button>
            </td></tr>';
        }
        $html .= '<tr><td colspan="5" align="center"><input type="submit" value="Remove Selected URLs" name="bwsubmit"></td></tr></table>';
        
        $html .= '<table width="100%">
        <tr align="center">
            <td>Site URL - (Hostname Only)<br />
            <input type="text" name="bwurl" /></td>
            <td>Date - (Dont worry its Auto-added)<br /><strong>'. $bwdate .'</strong>
            <input type="hidden" name="bwdate" value="'.date("Y-m-d").'" /></td>
            <td>Reason - (355 Chars Max)<br />
            <input type="text" name="bwreason" /></td>
        </tr>
        <tr align="center">
            <td colspan="2">Email<br />
            <input type="text" name="bwemail" /> <input name="del-ddls" type="checkbox" value="" /> Delete Downloads...?</td>
            <td><input type="submit" value="Blacklist This Site...." name="bwsubmit"></td>
        </tr>
        </table></form><p />';

        if (isset($_POST['esub'])) { 
            $site = $_POST['site'];
            var_dump($site);

            $html .= '<form method="post">
            <table width="98%">
            <h1 align="center">Modify...</h1>';
            $list = mysql_query("SELECT url,dat,reason,email FROM wcddl_blacklist WHERE url like '".mysql_real_escape_string($site)."'");
            while($mod = mysql_fetch_assoc($list)) {
                $html .= '
                <tr><td><input name="murl" type="text" value="'.$mod['url'].'" /></td>
                <input name="mdate" type="hidden" value="'.$mod['dat'].'" />
                <td><input name="mbody" type="text" value="'.$mod['reason'].'" /></td></tr>
                <tr align="center"><td colspan="2"><input name="memail" type="text" value="'.$mod['email'].'" /></td>
                </tr>';
            }
            $html .= '<tr><td colspan="3"><input type="submit" value="Save" name="save"></td></tr>
            </table></form><p />';
        } 

That should work.

[Lock Down]

try changing this code:

like '".mysql_real_escape_string($site)."'"

to this code:

like '%".mysql_real_escape_string($site)."%'"