[verplaatst] Probleem met fotogallerij mod
Geplaatst: 20 dec 2004, 23:20
Het is dus een extra pagina op het forum waar leden hun plaatjes kunnen uploaden en dus ook verwijderen, ik ben alleen blijven hangen op het verwijderen.
Alles blijkt te werken, hij verwijderd de GOEDE bestandsverwijzing uit het tabel, maar hij laat de andere zien (getest met twee plaatjes in tabel) :$. Heeft iemand een idee wat het zou kunnen zijn? de code van de php en tpl file staan hieronder.
img_upload.php:
img_upload.tpl:
Verplaatst door mosymuis
Alles blijkt te werken, hij verwijderd de GOEDE bestandsverwijzing uit het tabel, maar hij laat de andere zien (getest met twee plaatjes in tabel) :$. Heeft iemand een idee wat het zou kunnen zijn? de code van de php en tpl file staan hieronder.
img_upload.php:
Code: Selecteer alles
<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_PROFILE);
init_userprefs($userdata);
//
// End session management
//
// session id check
if (!empty($HTTP_POST_VARS['sid']) || !empty($HTTP_GET_VARS['sid']))
{
$sid = (!empty($HTTP_POST_VARS['sid'])) ? $HTTP_POST_VARS['sid'] : $HTTP_GET_VARS['sid'];
}
else
{
$sid = '';
}
$sql = "SELECT * FROM forum_addon_images WHERE username = '". $userdata['username'] . "'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain image information', '', __LINE__, __FILE__, $sql);
}
$total_images = 0;
while( $row = $db->sql_fetchrow($result) )
{
$img_rowset[] = $row;
$total_images++;
}
//
// Did the user submit? In this case build a query to update the users profile in the DB
//
if ( isset($HTTP_POST_VARS['submit']) )
{
//
// Kijken of er wat verwijderd moet worden
//
for($i = 0; $i < $total_images; $i++)
{
if ( isset($HTTP_POST_VARS["delete"]) )
{
$sql = "DELETE FROM forum_addon_images WHERE filename = '" . $delete . "'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not delete image information', '', __LINE__, __FILE__, $sql);
} else {
// DELETE FILE OF SERVER MOET NOG NEERZETTEN
}
}
}
}
//
// Retreive User Images, and send them to the template.
//
include($phpbb_root_path . 'includes/page_header.'.$phpEx);
$sql = "SELECT * FROM forum_addon_images WHERE username = '". $userdata['username'] . "'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain image information', '', __LINE__, __FILE__, $sql);
}
$total_images = 0;
while( $row = $db->sql_fetchrow($result) )
{
$img_rowset[] = $row;
$total_images++;
}
$template->set_filenames(array(
'body' => 'img_upload.tpl')
);
if( $total_images > 0)
{
for($i = 0; $i < $total_images; $i++)
{
$link = $img_rowset[$i]['roothttp'] . $userdata['username'] . "/" . $img_rowset[$i]['filename'];
$check_name = $img_rowset[$i]['filename'];
$template->assign_block_vars('img_block', array(
'DELETE' => $check_name,
'LINK' => $link)
);
}
} else {
$template->assign_block_vars('switch_no_images', array() );
}
$template->assign_vars(array(
'S_IMG' => append_sid("img_upload.$phpEx"))
);
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
?>Code: Selecteer alles
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td><img name="tlc" src="templates/BBLite/images/tlc.gif" WIDTH=15 HEIGHT=30 border="0" alt=""></td>
<td width="100%" background="templates/BBLite/images/tm.gif"><img name="tm" src="templates/BBLite/images/spacer.gif" width="1" height="1" border="0" alt=""></td>
<td><img name="trc" src="templates/BBLite/images/trc.gif" WIDTH=15 HEIGHT=30 border="0" alt=""></td>
</tr>
<tr>
<td height="372" background="templates/BBLite/images/left.gif"><img name="left" src="templates/BBLite/images/spacer.gif" width="1" height="1" border="0" alt=""></td>
<td valign="top" bgcolor="#D8D8D8">
<form action="{S_IMG}" method="post">
<table width="100%" cellspacing="2" cellpadding="2" border="0" align="center">
<tr>
<td align="left"><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a></span></td>
</tr>
</table>
<table border="0" cellpadding="3" cellspacing="1" width="100%" class="forumline">
<tr>
<th class="thHead" colspan="3" height="25" valign="middle">Mijn Afbeeldingen</th>
</tr>
<!-- BEGIN img_block -->
<tr>
<td width="378" height="128" class="row1"><img src="{img_block.LINK}" width="128" height="128"></td>
<td width="557" class="row2"><span class="nav"><a href="{img_block.LINK}" target="_blank">{img_block.LINK}</a></span></td>
<td width="55" align="center" valign="middle" class="row2"><input type="checkbox" name="delete" value="{img_block.DELETE}"/></td>
</tr>
<!-- END img_block -->
<!-- BEGIN switch_no_images -->
<tr>
<td width="378"><div align="center"><span class="gen">Er zijn momenteel geen plaatjes upgeload!</span></div></td>
</tr>
<!-- END switch_no_images -->
<tr>
<td class="row1"><span class="gen">Met geselecteerd:</span></td>
<td class="row2" colspan="2">
<select name="img" onChange="MM_jumpMenu('parent',this,0)">
<option selected>Verwijderen
<option>Naam Wijzigen
</select></td>
</tr>
<tr>
<td width="38%" class="row1"><span class="gen">Upload een Afbeelding:</span></td>
<td class="row2" colspan="2"><input type="file" name="avatar" class="post" style="width:200px" /></td>
</tr>
<tr>
<td class="catBottom" colspan="3" align="center" height="28"><input type="submit" name="submit" value="Verzenden" class="mainoption" /> <input type="reset" value="Leegmaken" name="reset" class="liteoption" /></td>
</tr>
</table>
</form>
</td>
<td background="templates/BBLite/images/right.gif"><img name="right" src="templates/BBLite/images/spacer.gif" width="1" height="1" border="0" alt=""></td>
</tr>
<tr>
<td><img name="blc" src="templates/BBLite/images/blc.gif" WIDTH=15 HEIGHT=20 border="0" alt=""></td>
<td background="templates/BBLite/images/btm.gif"><img name="btm" src="templates/BBLite/images/spacer.gif" width="1" height="1" border="0" alt=""></td>
<td><img name="brc" src="templates/BBLite/images/brc.gif" WIDTH=15 HEIGHT=20 border="0" alt=""></td>
</tr></table>
