04.05.2006, 18:37
Reicht es nicht den Link in der Beschreibung des Downloads mit anzugeben? Das was du vorhast ist nicht so leicht, die neuen Daten müssen ja schließlich auch in der Datenbank gespeichert werden.
ALTER TABLE `mybb_forumdownloads` ADD `customlink` VARCHAR( 200 ) NOT NULL , ADD `customurl` VARCHAR( 200 ) NOT NULL ;
if($mybb->input['type'] == 'download')
{
$new_entry['cid'] = intval($mybb->input['cid']);
$new_entry['uid'] = intval($mybb->input['uid']);
$new_entry['cid'] = addslashes($mybb->input['cid']);
$new_entry['url'] = addslashes($mybb->input['url']);
$new_entry['visible'] = addslashes($mybb->input['visible']);
$new_entry['sticky'] = addslashes($mybb->input['sticky']);
$new_entry['validated'] = 'yes';
$db->insert_query(TABLE_PREFIX."forumdownloads", $new_entry);
$message = 'Download hinzugefügt';
}
if($mybb->input['type'] == 'download')
{
$new_entry['cid'] = intval($mybb->input['cid']);
$new_entry['uid'] = intval($mybb->input['uid']);
$new_entry['cid'] = addslashes($mybb->input['cid']);
$new_entry['url'] = addslashes($mybb->input['url']);
$new_entry['visible'] = addslashes($mybb->input['visible']);
$new_entry['sticky'] = addslashes($mybb->input['sticky']);
$new_entry['validated'] = 'yes';
$new_entry['customlink'] = addslashes($mybb->input['customlink']);
$new_entry['customurl'] = addslashes($mybb->input['customurl']);
$db->insert_query(TABLE_PREFIX."forumdownloads", $new_entry);
$message = 'Download hinzugefügt';
}
if(intval($mybb->input['did']))
{
$update_download = array(
'did' => intval($mybb->input['did']),
'cid' => intval($mybb->input['cid']),
'uid' => intval($mybb->input['uid']),
'name' => addslashes($mybb->input['name']),
'description' => addslashes($mybb->input['description']),
'url' => addslashes($mybb->input['url']),
'sticky' => addslashes($mybb->input['sticky']),
'visible' => addslashes($mybb->input['visible']),
);
$db->update_query(TABLE_PREFIX."forumdownloads", $update_download, "did='".intval($mybb->input['did'])."'");
$message = 'Download geändert';
}
if(intval($mybb->input['did']))
{
$update_download = array(
'did' => intval($mybb->input['did']),
'cid' => intval($mybb->input['cid']),
'uid' => intval($mybb->input['uid']),
'name' => addslashes($mybb->input['name']),
'description' => addslashes($mybb->input['description']),
'url' => addslashes($mybb->input['url']),
'sticky' => addslashes($mybb->input['sticky']),
'visible' => addslashes($mybb->input['visible']),
'customlink' => addslashes($mybb->input['customlink']),
'customurl' => addslashes($mybb->input['customurl']),
);
$db->update_query(TABLE_PREFIX."forumdownloads", $update_download, "did='".intval($mybb->input['did'])."'");
$message = 'Download geändert';
}
$update_download = array(
'cid' => intval($mybb->input['cid'][$did]),
'name' => addslashes($mybb->input['name'][$did]),
'description' => addslashes($mybb->input['description'][$did]),
'url' => addslashes($mybb->input['url'][$did]),
'sticky' => addslashes($mybb->input['sticky'][$did]),
'visible' => addslashes($mybb->input['visible'][$did]),
'validated' => 'yes',
);
$update_download = array(
'cid' => intval($mybb->input['cid'][$did]),
'name' => addslashes($mybb->input['name'][$did]),
'description' => addslashes($mybb->input['description'][$did]),
'url' => addslashes($mybb->input['url'][$did]),
'sticky' => addslashes($mybb->input['sticky'][$did]),
'visible' => addslashes($mybb->input['visible'][$did]),
'validated' => 'yes',
'customlink' => addslashes($mybb->input['customlink'][$did]),
'customurl' => addslashes($mybb->input['customurl'][$did]),
);
if($count['numcats'] > 0)
{
echo "<br />\n";
startform('downloads.php', '', 'do_add');
makehiddencode('type', 'download');
starttable();
tableheader('Download hinzufügen');
makeinputcode('Download Name', 'name');
maketextareacode('Download Beschreibung', 'description');
makeinputcode('Download URL', 'url');
makeselectcode('Kategorie', 'cid', 'downloadcategories', 'cid', 'name');
makeyesnocode('Ist der Download sichtbar?', 'visible');
makeyesnocode('Ist der Download wichtig?', 'sticky', 'no');
endtable();
endform('Download hinzufügen', 'Zurücksetzen');
}
if($count['numcats'] > 0)
{
echo "<br />\n";
startform('downloads.php', '', 'do_add');
makehiddencode('type', 'download');
starttable();
tableheader('Download hinzufügen');
makeinputcode('Download Name', 'name');
maketextareacode('Download Beschreibung', 'description');
makeinputcode('Download URL', 'url');
makeselectcode('Kategorie', 'cid', 'downloadcategories', 'cid', 'name');
makeyesnocode('Ist der Download sichtbar?', 'visible');
makeyesnocode('Ist der Download wichtig?', 'sticky', 'no');
makeinputcode('Eigener Link (Name)', 'customlink');
makeinputcode('Eigener Link (URL)', 'customurl');
endtable();
endform('Download hinzufügen', 'Zurücksetzen');
}
if(intval($mybb->input['did']))
{
$did = intval($mybb->input['did']);
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."forumdownloads WHERE did='$did'");
$download = $db->fetch_array($query);
$download['description'] = stripslashes($download['description']);
startform('downloads.php', '', 'do_edit');
starttable();
tableheader('Download bearbeiten');
makeinputcode('Download Name', 'name', $download['name']);
maketextareacode('Download Beschreibung', 'description', $download['description']);
makeselectcode('Kategorie', 'cid', 'downloadcategories', 'cid', 'name', $download['cid']);
makeinputcode('Datei URL', 'url', $download['url']);
makeyesnocode('Ist der Download sichtbar?', 'visible', $download['visible']);
makeyesnocode('Ist der Download wichtig?', 'sticky', $download['sticky']);
endtable();
makehiddencode('did', $did);
endform('Download ändern', 'Zurücksetzen');
}
if(intval($mybb->input['did']))
{
$did = intval($mybb->input['did']);
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."forumdownloads WHERE did='$did'");
$download = $db->fetch_array($query);
$download['description'] = stripslashes($download['description']);
startform('downloads.php', '', 'do_edit');
starttable();
tableheader('Download bearbeiten');
makeinputcode('Download Name', 'name', $download['name']);
maketextareacode('Download Beschreibung', 'description', $download['description']);
makeselectcode('Kategorie', 'cid', 'downloadcategories', 'cid', 'name', $download['cid']);
makeinputcode('Datei URL', 'url', $download['url']);
makeyesnocode('Ist der Download sichtbar?', 'visible', $download['visible']);
makeyesnocode('Ist der Download wichtig?', 'sticky', $download['sticky']);
makeinputcode('Eigener Link (Name)', 'customlink', $download['customlink']);
makeinputcode('Eigener Link (URL)', 'customurl', $download['customurl']);
endtable();
makehiddencode('did', $did);
endform('Download ändern', 'Zurücksetzen');
}
while($download = $db->fetch_array($query))
{
makeinputcode('Download Name', "name[$download[did]]", $download['name']);
makelabelcode('Eingereicht von', "<a href=\"users.php?action=edit&uid=$download[uid]\">$download[username]</a>");
maketextareacode('Beschreibung', "description[$download[did]]", $download['description']);
makeselectcode('Kategorie', "cid[$download[did]]", "downloadcategories", "cid", "name", $download['cid']);
makeinputcode('Datei URL', "url[$download[did]]", $download['url']);
makeyesnocode('Ist der Download sichtbar?', "visible[$download[did]]", 'yes');
makeyesnocode('Ist der Download wichtig?', "sticky[$download[did]]", 'no');
makeyesnocode('Einreichung annehmen?', "validated[$download[did]]", 'yes');
makeyesnocode('Einreichung ablehnen?', "delete[$download[did]]", 'no');
echo "<tr>\n<td class=\"subheader\" align=\"center\" colspan=\"2\" height=\"2\"><img src=\"pixel.gif\" width=\"1\" height=\"1\"></td>\n</tr>\n";
}
while($download = $db->fetch_array($query))
{
makeinputcode('Download Name', "name[$download[did]]", $download['name']);
makelabelcode('Eingereicht von', "<a href=\"users.php?action=edit&uid=$download[uid]\">$download[username]</a>");
maketextareacode('Beschreibung', "description[$download[did]]", $download['description']);
makeselectcode('Kategorie', "cid[$download[did]]", "downloadcategories", "cid", "name", $download['cid']);
makeinputcode('Datei URL', "url[$download[did]]", $download['url']);
makeyesnocode('Ist der Download sichtbar?', "visible[$download[did]]", 'yes');
makeyesnocode('Ist der Download wichtig?', "sticky[$download[did]]", 'no');
makeinputcode('Eigener Link (Name)', "customlink[$download[did]]", $download['customlink']);
makeinputcode('Eigener Link (URL)', "customurl[$download[did]]", $download['customurl']);
makeyesnocode('Einreichung annehmen?', "validated[$download[did]]", 'yes');
makeyesnocode('Einreichung ablehnen?', "delete[$download[did]]", 'no');
echo "<tr>\n<td class=\"subheader\" align=\"center\" colspan=\"2\" height=\"2\"><img src=\"pixel.gif\" width=\"1\" height=\"1\"></td>\n</tr>\n";
}
<a href="$download[customurl]">$download[customlink]</a>
ALTER TABLE `mybb_forumdownloads` ADD `downloadlinkname` VARCHAR( 200 ) NOT NULL ;
if($mybb->input['type'] == 'download')
{
$new_entry['cid'] = intval($mybb->input['cid']);
$new_entry['uid'] = intval($mybb->input['uid']);
$new_entry['cid'] = addslashes($mybb->input['cid']);
$new_entry['url'] = addslashes($mybb->input['url']);
$new_entry['visible'] = addslashes($mybb->input['visible']);
$new_entry['sticky'] = addslashes($mybb->input['sticky']);
$new_entry['validated'] = 'yes';
$new_entry['customlink'] = addslashes($mybb->input['customlink']);
$new_entry['customurl'] = addslashes($mybb->input['customurl']);
$new_entry['downloadlinkname'] = addslashes($mybb->input['downloadlinkname']);
$db->insert_query(TABLE_PREFIX."forumdownloads", $new_entry);
$message = 'Download hinzugefügt';
}
ALTER TABLE `mybb_forumdownloads` ADD `downloadlinkname` VARCHAR( 200 ) NOT NULL ;
if($mybb->input['type'] == 'download')
{
$new_entry['cid'] = intval($mybb->input['cid']);
$new_entry['uid'] = intval($mybb->input['uid']);
$new_entry['cid'] = addslashes($mybb->input['cid']);
$new_entry['url'] = addslashes($mybb->input['url']);
$new_entry['visible'] = addslashes($mybb->input['visible']);
$new_entry['sticky'] = addslashes($mybb->input['sticky']);
$new_entry['validated'] = 'yes';
$new_entry['customlink'] = addslashes($mybb->input['customlink']);
$new_entry['customurl'] = addslashes($mybb->input['customurl']);
$db->insert_query(TABLE_PREFIX."forumdownloads", $new_entry);
$message = 'Download hinzugefügt';
}
if($mybb->input['type'] == 'download')
{
$new_entry['cid'] = intval($mybb->input['cid']);
$new_entry['uid'] = intval($mybb->input['uid']);
$new_entry['cid'] = addslashes($mybb->input['cid']);
$new_entry['url'] = addslashes($mybb->input['url']);
$new_entry['visible'] = addslashes($mybb->input['visible']);
$new_entry['sticky'] = addslashes($mybb->input['sticky']);
$new_entry['validated'] = 'yes';
$new_entry['customlink'] = addslashes($mybb->input['customlink']);
$new_entry['customurl'] = addslashes($mybb->input['customurl']);
$new_entry['downloadlinkname'] = addslashes($mybb->input['downloadlinkname']);
$db->insert_query(TABLE_PREFIX."forumdownloads", $new_entry);
$message = 'Download hinzugefügt';
}
if(intval($mybb->input['did']))
{
$update_download = array(
'did' => intval($mybb->input['did']),
'cid' => intval($mybb->input['cid']),
'uid' => intval($mybb->input['uid']),
'name' => addslashes($mybb->input['name']),
'description' => addslashes($mybb->input['description']),
'url' => addslashes($mybb->input['url']),
'sticky' => addslashes($mybb->input['sticky']),
'visible' => addslashes($mybb->input['visible']),
'customlink' => addslashes($mybb->input['customlink']),
'customurl' => addslashes($mybb->input['customurl']),
);
$db->update_query(TABLE_PREFIX."forumdownloads", $update_download, "did='".intval($mybb->input['did'])."'");
$message = 'Download geändert';
}
if(intval($mybb->input['did']))
{
$update_download = array(
'did' => intval($mybb->input['did']),
'cid' => intval($mybb->input['cid']),
'uid' => intval($mybb->input['uid']),
'name' => addslashes($mybb->input['name']),
'description' => addslashes($mybb->input['description']),
'url' => addslashes($mybb->input['url']),
'sticky' => addslashes($mybb->input['sticky']),
'visible' => addslashes($mybb->input['visible']),
'customlink' => addslashes($mybb->input['customlink']),
'customurl' => addslashes($mybb->input['customurl']),
'downloadlinkname' => addslashes($mybb->input['downloadlinkname']),
);
$db->update_query(TABLE_PREFIX."forumdownloads", $update_download, "did='".intval($mybb->input['did'])."'");
$message = 'Download geändert';
}
$update_download = array(
'cid' => intval($mybb->input['cid'][$did]),
'name' => addslashes($mybb->input['name'][$did]),
'description' => addslashes($mybb->input['description'][$did]),
'url' => addslashes($mybb->input['url'][$did]),
'sticky' => addslashes($mybb->input['sticky'][$did]),
'visible' => addslashes($mybb->input['visible'][$did]),
'validated' => 'yes',
'customlink' => addslashes($mybb->input['customlink'][$did]),
'customurl' => addslashes($mybb->input['customurl'][$did]),
);
$update_download = array(
'cid' => intval($mybb->input['cid'][$did]),
'name' => addslashes($mybb->input['name'][$did]),
'description' => addslashes($mybb->input['description'][$did]),
'url' => addslashes($mybb->input['url'][$did]),
'sticky' => addslashes($mybb->input['sticky'][$did]),
'visible' => addslashes($mybb->input['visible'][$did]),
'validated' => 'yes',
'customlink' => addslashes($mybb->input['customlink'][$did]),
'customurl' => addslashes($mybb->input['customurl'][$did]),
'downloadlinkname' => addslashes($mybb->input['downloadlinkname'][$did]),
);
if($count['numcats'] > 0)
{
echo "<br />\n";
startform('downloads.php', '', 'do_add');
makehiddencode('type', 'download');
starttable();
tableheader('Download hinzufügen');
makeinputcode('Download Name', 'name');
maketextareacode('Download Beschreibung', 'description');
makeinputcode('Download URL', 'url');
makeselectcode('Kategorie', 'cid', 'downloadcategories', 'cid', 'name');
makeyesnocode('Ist der Download sichtbar?', 'visible');
makeyesnocode('Ist der Download wichtig?', 'sticky', 'no');
makeinputcode('Eigener Link (Name)', 'customlink');
makeinputcode('Eigener Link (URL)', 'customurl');
endtable();
endform('Download hinzufügen', 'Zurücksetzen');
}
if($count['numcats'] > 0)
{
echo "<br />\n";
startform('downloads.php', '', 'do_add');
makehiddencode('type', 'download');
starttable();
tableheader('Download hinzufügen');
makeinputcode('Download Name', 'name');
maketextareacode('Download Beschreibung', 'description');
makeinputcode('Download URL', 'url');
makeselectcode('Kategorie', 'cid', 'downloadcategories', 'cid', 'name');
makeyesnocode('Ist der Download sichtbar?', 'visible');
makeyesnocode('Ist der Download wichtig?', 'sticky', 'no');
makeinputcode('Eigener Link (Name)', 'customlink');
makeinputcode('Eigener Link (URL)', 'customurl');
makeinputcode('Eigener Name', 'downloadlinkname');
endtable();
endform('Download hinzufügen', 'Zurücksetzen');
}
if(intval($mybb->input['did']))
{
$did = intval($mybb->input['did']);
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."forumdownloads WHERE did='$did'");
$download = $db->fetch_array($query);
$download['description'] = stripslashes($download['description']);
startform('downloads.php', '', 'do_edit');
starttable();
tableheader('Download bearbeiten');
makeinputcode('Download Name', 'name', $download['name']);
maketextareacode('Download Beschreibung', 'description', $download['description']);
makeselectcode('Kategorie', 'cid', 'downloadcategories', 'cid', 'name', $download['cid']);
makeinputcode('Datei URL', 'url', $download['url']);
makeyesnocode('Ist der Download sichtbar?', 'visible', $download['visible']);
makeyesnocode('Ist der Download wichtig?', 'sticky', $download['sticky']);
makeinputcode('Eigener Link (Name)', 'customlink', $download['customlink']);
makeinputcode('Eigener Link (URL)', 'customurl', $download['customurl']);
endtable();
makehiddencode('did', $did);
endform('Download ändern', 'Zurücksetzen');
}
if(intval($mybb->input['did']))
{
$did = intval($mybb->input['did']);
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."forumdownloads WHERE did='$did'");
$download = $db->fetch_array($query);
$download['description'] = stripslashes($download['description']);
startform('downloads.php', '', 'do_edit');
starttable();
tableheader('Download bearbeiten');
makeinputcode('Download Name', 'name', $download['name']);
maketextareacode('Download Beschreibung', 'description', $download['description']);
makeselectcode('Kategorie', 'cid', 'downloadcategories', 'cid', 'name', $download['cid']);
makeinputcode('Datei URL', 'url', $download['url']);
makeyesnocode('Ist der Download sichtbar?', 'visible', $download['visible']);
makeyesnocode('Ist der Download wichtig?', 'sticky', $download['sticky']);
makeinputcode('Eigener Link (Name)', 'customlink', $download['customlink']);
makeinputcode('Eigener Link (URL)', 'customurl', $download['customurl']);
makeinputcode('Eigener Name', 'downloadlinkname', $download['downloadlinkname']);
endtable();
makehiddencode('did', $did);
endform('Download ändern', 'Zurücksetzen');
}
while($download = $db->fetch_array($query))
{
makeinputcode('Download Name', "name[$download[did]]", $download['name']);
makelabelcode('Eingereicht von', "<a href=\"users.php?action=edit&uid=$download[uid]\">$download[username]</a>");
maketextareacode('Beschreibung', "description[$download[did]]", $download['description']);
makeselectcode('Kategorie', "cid[$download[did]]", "downloadcategories", "cid", "name", $download['cid']);
makeinputcode('Datei URL', "url[$download[did]]", $download['url']);
makeyesnocode('Ist der Download sichtbar?', "visible[$download[did]]", 'yes');
makeyesnocode('Ist der Download wichtig?', "sticky[$download[did]]", 'no');
makeinputcode('Eigener Link (Name)', "customlink[$download[did]]", $download['customlink']);
makeinputcode('Eigener Link (URL)', "customurl[$download[did]]", $download['customurl']);
makeyesnocode('Einreichung annehmen?', "validated[$download[did]]", 'yes');
makeyesnocode('Einreichung ablehnen?', "delete[$download[did]]", 'no');
echo "<tr>\n<td class=\"subheader\" align=\"center\" colspan=\"2\" height=\"2\"><img src=\"pixel.gif\" width=\"1\" height=\"1\"></td>\n</tr>\n";
}
while($download = $db->fetch_array($query))
{
makeinputcode('Download Name', "name[$download[did]]", $download['name']);
makelabelcode('Eingereicht von', "<a href=\"users.php?action=edit&uid=$download[uid]\">$download[username]</a>");
maketextareacode('Beschreibung', "description[$download[did]]", $download['description']);
makeselectcode('Kategorie', "cid[$download[did]]", "downloadcategories", "cid", "name", $download['cid']);
makeinputcode('Datei URL', "url[$download[did]]", $download['url']);
makeyesnocode('Ist der Download sichtbar?', "visible[$download[did]]", 'yes');
makeyesnocode('Ist der Download wichtig?', "sticky[$download[did]]", 'no');
makeinputcode('Eigener Link (Name)', "customlink[$download[did]]", $download['customlink']);
makeinputcode('Eigener Link (URL)', "customurl[$download[did]]", $download['customurl']);
makeinputcode('Eigener Name', "downloadlinkname[$download[did]]", $download['downloadlinkname']);
makeyesnocode('Einreichung annehmen?', "validated[$download[did]]", 'yes');
makeyesnocode('Einreichung ablehnen?', "delete[$download[did]]", 'no');
echo "<tr>\n<td class=\"subheader\" align=\"center\" colspan=\"2\" height=\"2\"><img src=\"pixel.gif\" width=\"1\" height=\"1\"></td>\n</tr>\n";
}