The Arcive of vBulletin Modifications Site.

ragtek · #1 06-05-2006, 06:10 PM

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,&sect;,...
</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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04561 seconds Memory Usage 4,664KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_code (1)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages: