Probleem

--------Add Table in you Mysql DB----------

CREATE TABLE `phpbb_topic_cat` (
`k_id` INT(11) AUTO_INCREMENT PRIMARY KEY,
`forum_id` INT(11),
`kategorie` TEXT
);

?? ik word daar niet echt wijs uit, kan iemand mij helpen ?
Met wat ik moet invullen op de mySQl tabel ...

vield : .... type: ..... waardes: .... attributten: .... null: .... standaardwaarde: ...... EXtra ...... en wat moet ik dan aanvinken ?

en invullen ?

Database ..... - Tabel phpbb_topic_cat wordt uitgevoerd op localhost

....

Hy,

for that you have to use phpmyAdmin.
Open your table and look for the biggest white input-box on this site. There you copy and paste this stuff in it and press OK...
If there are any questions left, post again, and I'll post a Screenshot..

MfG Tom

Code:

#################################################################
## Mod Title: Title Categorie
## Mod Version: 1.0.1
## Author: Ta Lun <ta_lun@hotmail.com> - http://www.love-creatues.de
## Description: Add Titel categories to you Forums. You can see it in the viewforums.php
## and viewtopic.php. You can edit it for each post.
##    For each forum you can select you own categories with a CP in the Mod CP
##
## Installation Level: Hard
## Installation Time: 20 Minutes
## Files To Edit: PHP = viewtopic,viewforum,modcp,posting,constans,lang_main,functions_post
## tpl = viewtopic,viewforum,modcp,posting_body
##
##
##
##
##
##
##
#################################################################
## Security Disclaimer: This MOD Cannot Be Posted To Or Added At Any Non-Official phpBB Sites
#################################################################
##
##
#################################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
#################################################################
##
## Revision History:
##
## v1.0.0
## - First Release and Final.
##
#################################################################

--------Add Table in you Mysql DB----------

CREATE TABLE `phpbb_topic_cat` (
`k_id` INT(11) AUTO_INCREMENT PRIMARY KEY,
`forum_id` INT(11),
`kategorie` TEXT
);

ALTER TABLE `topics` ADD `k_id` INT(10) DEFAULT '0';

(Change the name if you want. Then you must change the entrie in the constans.php)

---------------------------

open your Lang_main.php (Change it for every Language you have. German and Englisch included)

###----Find----

//
// That's all Folks!

##---Add before German----

//KATEGORIEN
$lang['akt_kat']="Kategorie(n) erfolgreich Aktualisiert.";
$lang['new_kat']="Neue Kategorie hinzufügen:";
$lang['kat']="Kategorien Controlpanel";

##---Add before Englisch----

//KATEGORIEN
$lang['akt_kat']="Categires Updated";
$lang['new_kat']="Add New Categorie:";
$lang['kat']="Categories Controlpanel";

##------------------------------------------

Save and Close Language_main.php

Open includes/constants.php

##----Find----
define('VOTE_DESC_TABLE', $table_prefix.'vote_desc');
define('VOTE_RESULTS_TABLE', $table_prefix.'vote_results');
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');
##-----After Add-----

//kategorien
define('TOPIC_KAT', $table_prefix.'topic_cat');
//kategorien

##---------------------------

Save and close the constans.php

open includes/function_post.php

##------Find----
function submit_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id, &$topic_type, &$bbcode_on, &$html_on, &$smilies_on, &$attach_sig, &$bbcode_uid, &$post_username, &$post_subject, &$post_message, &$poll_title, &$poll_options, &$poll_length)

##----Change the end of row-----
&$poll_options, &$poll_length, &$k_id)

##-----------------------------

##----FIND in function submit_post------
   $sql = ( $mode != "editpost" ) ? "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote) VALUES ('$post_subject', " . $userdata['user_id'] . ", $current_time, $forum_id, " . TOPIC_UNLOCKED . ", $topic_type, $topic_vote)" : "UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject', topic_type = $topic_type, topic_vote = $topic_vote WHERE topic_id = $topic_id";

##----Replace with----

$sql = ( $mode != "editpost" ) ? "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote, k_id) VALUES ('$post_subject', " . $userdata['user_id'] . ", $current_time, $forum_id, " . TOPIC_UNLOCKED . ", $topic_type, $topic_vote, $k_id)" : "UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject', topic_type = $topic_type, topic_vote = $topic_vote, k_id=$k_id WHERE topic_id = $topic_id";

##--------------------

Save an close the function_post.php

Open viewtopic.php

##----Find----
else
{
   $l_edited_by = '';
}

##---Add After----
//kategorien
if ( $postrow[$i]['k_id'] != 0 ) {
$sql="select kategorie FROM " . TOPIC_KAT . " where k_id=" .$postrow[$i]['k_id'];
if ( $result = $db->sql_query($sql) ){
$kat2 = $db->sql_fetchrow($result);
$topic_kat="[" .$kat2['kategorie'] . "]";

$template->assign_vars(array(
'TOPIC_CAT' => $topic_kat,
));
}
}
//kategorien

##-------------

##----FInd-----
//
// Go ahead and pull all data for this topic
//
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt
WHERE p.topic_id = $topic_id
   $limit_posts_time
   AND pt.post_id = p.post_id
   AND u.user_id = p.poster_id
ORDER BY p.post_time $post_time_order
LIMIT $start, ".$board_config['posts_per_page'];

##----Replace with---
//
// Go ahead and pull all data for this topic
//
$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile,u.user_active, u.user_allow_viewonline, u.user_session_time, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, t.k_id
FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt, " . TOPICS_TABLE. " t
WHERE p.topic_id = $topic_id
   $limit_posts_time
   AND pt.post_id = p.post_id
   AND u.user_id = p.poster_id
   AND t.topic_id = $topic_id
ORDER BY p.post_time $post_time_order
LIMIT $start, ".$board_config['posts_per_page'];

##-----------------

Save an Close viewtopic.php

Open viewforum.php

##---Find----
if( ( $replies + 1 ) > $board_config['posts_per_page'] )
   {

##----Add Before-----
//kategorien
   if($topic_rowset[$i]['k_id'] !=0)
   {
      $sql="select kategorie FROM " . TOPIC_KAT ." where k_id=" . $topic_rowset[$i]['k_id'];

      if ( $result = $db->sql_query($sql) )
      {
      $kat = $db->sql_fetchrow($result);
      $topic_kat="[" .$kat['kategorie'] . "]";
      }
   }else{
      $topic_kat="";
   }
   //kategorien

##------------

##----Find----
$template->assign_block_vars('topicrow', array(
'ROW_COLOR' => $row_color,

##---REplace with-----
$template->assign_block_vars('topicrow', array(
      'TOPIC_KAT' => $topic_kat,
      'ROW_COLOR' => $row_color,
##--------------------

Save and Close viewforum.php

Open modcp.php

##----Find----
else if ( $unlock )
{
   $mode = 'unlock';
}
##---Add after---

//kategorien EDIT
else if ( $edit )
{
   $mode = 'edit';
}
//Kategorien EDIT

##---------

##----Find---

$template->assign_vars(array(
      'META' => '<meta http-equiv="refresh" content="3;url=' . $redirect_page . '">')
   );

   message_die(GENERAL_MESSAGE, $lang['Topics_Locked'] . '<br /><br />' . $message);

   break;
##---Add After------

//kategorien
case 'edit':
   $page_title = $lang['Mod_CP'];
   include($phpbb_root_path . 'includes/page_header.'.$phpEx);
   $total_kat= count($kategorie);
   $j=0;
   $i=0;
   while($j < $total_kat){
   $kategorie[$i]=addslashes($kategorie[$i]);
   $sql="Update " . TOPIC_KAT ." set kategorie='$kategorie[$i]' WHERE k_id=" .$kat_old[$i];
   $j++;
   $i++;
   if ( !($result = $db->sql_query($sql)) )
   {


      message_die(GENERAL_ERROR, 'Could not update Category table', '', __LINE__, __FILE__, $sql);
   }

   }
   if(!empty($add_cat)) {
   $add_cat= addslashes($add_cat);
   $sql_k_u="INSERT INTO " . TOPIC_KAT ." (k_id, forum_id, kategorie) VALUES ('', $forum_id, '$add_cat')";
   if ( !($result = $db->sql_query($sql_k_u)) )
   {
   echo $add_cat;
   echo $sql_k_u;
   message_die(GENERAL_ERROR, 'Could not Insert Category table', '', __LINE__, __FILE__, $sql);
   }
   }

   $c_del_k= count($kat_del);
   if($c_del_k){

   $j=0;
   $i=0;
   while($j < $c_del_k){

      $sql_del="Delete From " . TOPIC_KAT ." where k_id=" .$kat_del[$i];
   $j++;
   $i++;
   if ( !($result = $db->sql_query($sql_del)) )
   {

      message_die(GENERAL_ERROR, 'Could not Del Category ', '', __LINE__, __FILE__, $sql);
   }
   }
   }


      $redirect_page = "modcp.$phpEx?f=$forum_id";
      $message= $lang['akt_kat'];
      $message.="<br>";
      $message.="<a href=\"$redirect_page\">" . $lang['Previous'] . "</a>";
      message_die(GENERAL_MESSAGE, $message);



break;
//kategorien

##--------------

##---Find-----

'L_REPLIES' => $lang['Replies'],
      'L_LASTPOST' => $lang['Last_Post'],
      'L_SELECT' => $lang['Select'],
##----Add after-----
//kategorien
      'L_ADD_KAT' =>$lang['new_kat'],
      'L_KAT' => $lang['Category'],
      'L_KATE' =>$lang['kat'],
      'L_DEL_KATE' => $lang['Delete'],
      //kategorien

##--------

##----Find----
$topic_title = '';

      if ( $row['topic_status'] == TOPIC_LOCKED )
      {
##---Add before----

//kategorien
      if($row['k_id'] !=0){
      $sql2="select kategorie FROM " . TOPIC_KAT ." where k_id=".$row['k_id'];
      if ( $result2 = $db->sql_query($sql2) )
         {
            $kat = $db->sql_fetchrow($result2);
            $topic_kat="[" .$kat['kategorie'] . "]";
         }
      }else{
      $topic_kat="";
      }
      //kategorien

##--------------

##----Find-----
'TOPIC_ID' => $topic_id,

         'L_TOPIC_FOLDER_ALT' => $folder_alt)
      );

   }
##----Add After----

//kategorien
   $sql_forum_k="select kategorie,k_id FROM " . TOPIC_KAT ." where forum_id=".$forum_id;
      if ( $result_f = $db->sql_query($sql_forum_k) )
      {
      while($kat2 = $db->sql_fetchrow($result_f))
      {

      $template->assign_block_vars('forum_katrow', array(
         'FORUM_KAT' => $kat2['kategorie'],
         'K_ID' => $kat2['k_id'])
      );
      }
}

//kategorien

##---------------

Save and close modcp.php

open posting.php

##-----Find----
case 'newtopic':
   if ( empty($forum_id) )
   {
      message_die(GENERAL_MESSAGE, $lang['Forum_not_exist']);
   }

   $sql = "SELECT *
      FROM " . FORUMS_TABLE . "
      WHERE forum_id = $forum_id";

##----Add after----

//kategorien
   $sql_kat="select * FROM " . TOPIC_KAT . " where forum_id=" .$forum_id. " ORDER BY kategorie" ;
   if ( $result = $db->sql_query($sql_kat) ){
      $first= "<select size=\"1\" name=\"k_id\">";
      while($kat = $db->sql_fetchrow($result)){
      $first.="<option value=\"" . $kat[k_id] . "\">$kat[kategorie]</option>";
      }
      $first.="</select>";
      $kat=$first;

      $template->assign_vars(array(
      'TOPIC_CAT' => $kat,
      ));

   }
   //kategorien
##---------

##----find----
$message = $post_info['post_text'];

if ( $mode == 'editpost' )
   {

##----Add After----
//kategorien
   $sql_kat="select * FROM " . TOPIC_KAT . " where forum_id=" .$forum_id. " ORDER BY kategorie" ;
   if ( $result = $db->sql_query($sql_kat) ){
      $first= "<select size=\"1\" name=\"k_id\">";
      while($kat = $db->sql_fetchrow($result)){
      if(($post_info['k_id'])==$kat['k_id'])
      {
      $s="selected";
      }else
      {
      $s="";
      }
      $first.="<option value=\"" . $kat[k_id] . "\" $s>$kat[kategorie]</option>";
      }
      $first.="</select>";
      $kat=$first;

      $template->assign_vars(array(
      'TOPIC_CAT' => $kat,
      ));

   }
   //kategorien

##--------

##------Find----
submit_post($mode, $post_data, $return_message, $return_meta, $forum_id, $topic_id, $post_id, $poll_id, $topic_type, $bbcode_on, $html_on, $smilies_on, $attach_sig, $bbcode_uid, str_replace("\'", "''", $username), str_replace("\'", "''", $subject), str_replace("\'", "''", $message), str_replace("\'", "''", $poll_title), $poll_options, $poll_length);

##---Replace with----
submit_post($mode, $post_data, $return_message, $return_meta, $forum_id, $topic_id, $post_id, $poll_id, $topic_type, $bbcode_on, $html_on, $smilies_on, $attach_sig, $bbcode_uid, str_replace("\'", "''", $username),
str_replace("\'", "''", $subject), str_replace("\'", "''", $message), str_replace("\'", "''", $poll_title),
$poll_options, $poll_length, $k_id);

##----

##----Find---
$select_sql = ( !$submit ) ? ", t.topic_title, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, p.post_username, pt.post_subject, pt.post_text, pt.bbcode_uid, u.username, u.user_id, u.user_sig" : '';

##---Replace with----
$select_sql = ( !$submit ) ? ", t.topic_title,t.k_id, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, p.post_username, pt.post_subject, pt.post_text, pt.bbcode_uid, u.username, u.user_id, u.user_sig"
: '';

##--------

Save and Close Posting.php

open posting_body.tpl

##----find---
<input type="text" name="subject" size="45" maxlength="60" style="width:450px" tabindex="2" class="post" value="{SUBJECT}" />

##----Add Before----
{TOPIC_CAT}  

##-------

Save and Close posting_body.tpl

Open modcp_body.tpl

##----Find----
<input type="submit" name="lock" class="liteoption" value="{L_LOCK}" />
    
   <input type="submit" name="unlock" class="liteoption" value="{L_UNLOCK}" />
   </td>
</tr>
</table>
##----Add After----

<table width="100%" cellpadding="4" cellspacing="1" border="0" class="forumline">
<tr>
<td colspan="2" class="row1" align="center" valign="middle"><span class="postdetails"><b>{L_KATE}</b></span> </td>
<td class="row1" align="center" valign="middle"><span class="postdetails"><b>{L_DEL_KATE}</b></span> </td>
</tr>


<tr>
<td class="row1" align="center" valign="middle"><span class="postdetails">{L_KAT}:</span> </td>
   <td class="row1" align="center" valign="middle"><span class="postdetails"><input type="text" name="kategorie[]" class="post" size="20" value="{forum_katrow.FORUM_KAT}"></span>
   <td class="row1" align="center" valign="middle"><span class="postdetails"><input type="checkbox" name="kat_del[]" value="{forum_katrow.K_ID}"></span> </td>
   <input type="hidden" name="kat_old[]" value="{forum_katrow.K_ID}">
   </td>
   </tr>

<tr>
   <td class="row1" align="center" valign="middle"><span class="postdetails">{L_ADD_KAT}</span> </td>
   <td class="row1" align="center" valign="middle"><span class="postdetails"><input type="text" name="add_cat" class="post" size="20" value=""></span>
   </td>
   <td class="row1" align="center" valign="middle"><span class="postdetails"></span> </td>
   </tr>
<tr align="right">
   <td class="catBottom" colspan="5" height="29"> {S_HIDDEN_FIELDS}
   <input type="submit" name="edit" class="liteoption" value="Edit" />


   </td>
</tr>
</table>

##-----------------------------------

Save and Close modcp_body.tpl

open viewtopic_body.tpl

##---Find---
<td align="left" valign="bottom" colspan="2"><a class="maintitle" href="{U_VIEW_TOPIC}">{TOPIC_TITLE}</a><br />

##----Replace with-----
<td align="left" valign="bottom" colspan="2"><a class="maintitle" href="{U_VIEW_TOPIC}">{TOPIC_CAT} {TOPIC_TITLE}</a><br />
##------------

Save and close viewtopic_body.tpl

Open viewforum_body.tpl

##----Find in the topicrow----

<td class="row1" width="100%"><span class="topictitle">{topicrow.NEWEST_POST_IMG}{topicrow.TOPIC_TYPE}<a href="{topicrow.U_VIEW_TOPIC}" class="topictitle">{topicrow.TOPIC_TITLE}</a></span><span class="gensmall"><br />
##---Replace with----
<td class="row1" width="100%"><span class="topictitle">{topicrow.NEWEST_POST_IMG}{topicrow.TOPIC_TYPE} {topicrow.TOPIC_KAT} <a href="{topicrow.U_VIEW_TOPIC}" class="topictitle">{topicrow.TOPIC_TITLE}</a></span><span class="gensmall"><br />

##------------
Save and close viewforum_body.tpl

Done have Fun

Database acidpadd wordt uitgevoerd op localhost
Fout

SQL-query :

CREATE TABLE `phpbb_topic_cat` (
`k_id` INT(11) AUTO_INCREMENT PRIMARY KEY,
`forum_id` INT(11),
`kategorie` TEXT
)

MySQL retourneerde:

Table 'phpbb_topic_cat' already exists

ABBER da ist niks sind nur 28 tables ..

phpbb_auth_access Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 29 MyISAM 3,5 KB
phpbb_banlist Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 0 MyISAM 1,0 KB
phpbb_categories Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 3 MyISAM 3,3 KB
phpbb_config Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 59 MyISAM 4,6 KB
phpbb_disallow Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 0 MyISAM 1,0 KB
phpbb_forum_prune Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 0 MyISAM 1,0 KB
phpbb_forums Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 8 MyISAM 5,9 KB
phpbb_groups Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 7 MyISAM 3,2 KB
phpbb_posts Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 29 MyISAM 6,9 KB
phpbb_posts_text Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 29 MyISAM 7,8 KB
phpbb_privmsgs Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 18 MyISAM 4,9 KB
phpbb_privmsgs_text Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 18 MyISAM 4,0 KB
phpbb_ranks Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 3 MyISAM 2,1 KB
phpbb_search_results Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 2 MyISAM 3,5 KB
phpbb_search_wordlist Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 281 MyISAM 15,6 KB
phpbb_search_wordmatch Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 504 MyISAM 10,9 KB
phpbb_sessions Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 7 HEAP 4,1 KB
phpbb_smilies Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 71 MyISAM 4,5 KB
phpbb_themes Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 1 MyISAM 2,9 KB
phpbb_themes_name Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 1 MyISAM 4,9 KB
phpbb_topics Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 6 MyISAM 6,5 KB
phpbb_topics_watch Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 0 MyISAM 1,0 KB
phpbb_user_group Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 7 MyISAM 3,1 KB
phpbb_users Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 7 MyISAM 4,7 KB
phpbb_vote_desc Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 0 MyISAM 1,0 KB
phpbb_vote_results Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 0 MyISAM 1,0 KB
phpbb_vote_voters Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 0 MyISAM 1,0 KB
phpbb_words Verkennen Selecteren Invoegen Eigenschappen Verwijderen Legen 0 MyISAM 1,0 KB
28 tabel(len) Som 1.090 -- 115,1 KB
Selecteer alles / Deselecteer alles Met geselecteerd: Verwijderen Legen Printopmaak Optimaliseer tabel

danke es had geklapt....
Shocked

phpBB2.de User Joined: 28 Nov 2002 Posts: 12

could someone plese tell me im english what he just said after 'phpbb_auth_access'

Thanks!