i'm working on a linklist 4 me
PHP Code:
<?php
error_reporting(E_ALL & ~E_NOTICE);
define('NO_REGISTER_GLOBALS', 1);
define('THIS_SCRIPT', 'linkliste');
$phrasegroups = array();
$specialtemplates = array();
$globaltemplates = array(
'linkliste'
);
$actiontemplates = array();
require_once('./global.php');
// draw nav bar
$navbits = array();
$parentlist = array_reverse(explode(',', $foruminfo['parentlist']));
foreach ($parentlist AS $forumID)
{
$forumTitle = $forumcache["$forumID"]['title'];
$navbits["forumdisplay.php?$session[sessionurl]f=$forumID"] = $forumTitle;
}
$navbits["linkliste.php"] = "Linkliste";
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
// ######################## Benutzercode #################
global $vbulletin;
if($_POST['neulink'] == 1)
{
$vbulletin->input->clean_array_gpc('p', array(
'link' => TYPE_NOTRIM,
'name' => TYPE_NOTRIM,
'kategorie' => TYPE_NOTRIM
));
$url = htmlspecialchars_uni($vbulletin->GPC['link']);
$beschreibung = htmlspecialchars_uni($vbulletin->GPC['name']);
$kategorie = htmlspecialchars_uni($vbulletin->GPC['kategorie']);
$db->query_write("
INSERT INTO vb_linklist
(name,link,kategorie)
VALUES ('" . $db->escape_string($name) ."','" . $db->escape_string($url) ."','" . $db->escape_string($kategorie) ."');");
}
$sys='';
$son='';
$items = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "linklist where kategorie = 'sys'");
while ($item = $vbulletin->db->fetch_array($items))
{
$sys.='<tr class="alt1"><td>'. $item['name'] .'</td><td><a target="_blank" href="'.$item['link'].'">'.$item['link'].'</a></td><td width="24px"><img src="images/bgold/buttons/report.gif" alt="melden" title="melden"></td></tr>';
}
$vbulletin->db->free_result($items);
$items = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "linklist where kategorie = 'son'");
while ($item = $vbulletin->db->fetch_array($items))
{
$son.='<tr class="alt1"><td>'. $item['name'] .'</td><td><a target="_blank" href="'.$item['link'].'">'.$item['link'].'</a></td><td width="24px"><img src="images/bgold/buttons/report.gif" alt="melden" title="melden"></td>';
}
$vbulletin->db->free_result($items);
eval('print_output("' . fetch_template('linkliste') . '");');
?>
thats the linklist.php
and the template is:
Code:
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
$headinclude
<title>$vboptions[bbtitle]</title>
</head>
<body>
$header
$navbar
<table class="tborder"><tr><td class="alt1">
Hier gibts demn?chst wieder eine Linkliste
</td></tr></table>
<br />
<table class="tborder" width="100%"><tr><td class="alt2" colspan="3" align="center"><b>Soundsysteme</b></td></tr>
<tr class="thead" align="center"><td align="left">Name</td><td width="650px">Link</td><td width="24px">Melden</td></tr>
$sys
</table>
<br />
<table class="tborder" width="100%"><tr><td class="alt2" colspan="3" align="center"><b>Sonstiges</b></td></tr>
<tr class="thead" align="center"><td align="left">Name</td><td width="650px">Link</td><td width="24px">Melden</td>
$son
</table>
<br />
<br />
<form action="linkliste.php" method="post">
<table class="tborder" width="100%">
<tr class="alt2">
<td colspan="6" align="center">Link hinzuf?gen:</td></tr>
<tr>
<td class="alt1" width="25px">URL:</td>
<td width="30px"><input type=text size=30 name=link></td>
<td class="alt1" width="25px">Name:</td>
<td width="50px"><input type=text size=50 name=name></td>
<td class="alt1">Kategorie:</td>
<td><select name="kategorie">
<option value="sys"> Soundsysteme,..
<option value="rec"> Recordstores,..
<option value="son"> Allgemeiner Link
<option value="ges"> Gesetze,§,...
</select></td>
</tr>
<tr><td colspan="6" align="center"><input type=submit border=0 value="senden"></td></table></form>
$footer
</body>
</html>
the select from the db works! but if i want to write a new link to the db theres nothing happing!
can pls someone help
More Information