phpBB.de

phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/

[2.0.0] Categorie MOD

https://www.phpbb.de/community/viewtopic.php?t=8652

Seite 4 von 5

Verfasst: 22.03.2004 11:50
von Messiah of Death
dann kommt jetzt hier die große Umstellpost

ich weis zwar jetzt nicht mehr ganz genau was wo schon vorhanden war, aber hier folgt nun die Modifikation der Modifikation :D

Code: Alles auswählen

----------öffne modcp.php

-----------Suche
//
// Continue var definitions
//
-------------einfügen danach
$edit = ( isset($HTTP_POST_VARS['edit']) ) ? TRUE : FALSE;


-----------Suche (kommt gleich danach)
if ( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) )
{
	$mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
}
else
{
	if ( $delete )
	{
		$mode = 'delete';
	}
------------Füge danach ein
	//kategorien EDIT
	else if ( $edit )
	{
		$mode = 'edit';
	}
	//Kategorien EDIT
--------Suche
		message_die(GENERAL_MESSAGE, $lang['Topics_Unlocked'] . '<br /><br />' . $message);

		break;
----------Füge ein danach (MODIFIFZIERT !!!)
//kategorien
	case 'edit':
		if (!$is_auth['auth_cat'])
		{
			message_die(MESSAGE, sprintf($lang['Sorry_auth_cat'], $is_auth['auth_cat_type']));
		}
		
		$page_title = $lang['Mod_CP'];
		include($phpbb_root_path . 'includes/page_header.'.$phpEx);
		$kategorie = $_POST['kategorie']; $kat_old = $_POST['kat_old'];		
		$kat_del = $_POST['kat_del']; $add_cat = $_POST['add_cat'];
		$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 = "$PHP_SELF?f=$forum_id&sid=$sid";
			$message= $lang['akt_kat'];
			$message.="<br>";
			$message.="<a href=\"$redirect_page\">" . $lang['Previous']  . "</a>";
			message_die(GENERAL_MESSAGE, $message);
		
		
		
	break;	
	//kategorien	
		
-------------------Suche
			'L_SELECT' => $lang['Select'], 
------------Füge danach ein
			//kategorien
			'L_ADD_KAT' =>$lang['new_kat'],
			'L_KAT' => $lang['Category'],
			'L_KATE' =>$lang['kat'],
			'L_DEL_KATE' => $lang['Delete'],
			//kategorien
----------------suche
	   		message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql);
		}

		while ( $row = $db->sql_fetchrow($result) )
		{
-------------------Füge danach ein 
			//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
--------------------Suche
				'L_TOPIC_FOLDER_ALT' => $folder_alt)
			);			
		}

------------------Füge danach ein
			//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
---------------Öffne posting.php

----------Suche 
$params = array('submit' => 'post', 'confirm' => 'confirm', 'preview' => 'preview', 'delete' => 'delete', 'poll_delete' => 'poll_delete', 'poll_add' => 'add_poll_option', 'poll_edit' => 'edit_poll_option', 'mode' => 'mode');
------------Ersetze durch
$params = array('submit' => 'post', 'confirm' => 'confirm', 'preview' => 'preview', 'delete' => 'delete', 'poll_delete' => 'poll_delete', 'poll_add' => 'add_poll_option', 'poll_edit' => 'edit_poll_option', 'mode' => 'mode', 'k_id' => 'k_id');
-----------Suche 
	else
	{
		$$var = '';
	}
}
------------Füge ein danach
// Kategorie Mod 

if (!$k_id) 
 $k_id = 0;
------------Suche
switch ( $mode )
{
	case 'newtopic':
		if ( empty($forum_id) )
		{
			message_die(GENERAL_MESSAGE, $lang['Forum_not_exist']);
		}

		$sql = "SELECT * 
			FROM " . FORUMS_TABLE . " 
			WHERE forum_id = $forum_id";
-------------------Füge ein danach
//kategorien
		$sql_kat="select * FROM " . TOPIC_KAT . " where forum_id=" .$forum_id. " ORDER BY kategorie" ;
        		if ( $result = $db->sql_query($sql_kat) ){
			$result2 = $db->sql_query($sql_kat);
			$kat33 = $db->sql_fetchrow($result2);
			$to_result=count($kat33);
			if($to_result >=2){
			$first= "<select size=\"1\" name=\"k_id\">";
			$first.="<option value=\"0\">$kat[kategorie]</option>";
			while($kat = $db->sql_fetchrow($result)){
			$first.="<option value=\"" . $kat[k_id] . "\">$kat[kategorie]</option>";
			}
			$first.="</select>";
			$kat=$first;
			}else{
			$kat="<input type=\"hidden\" name=\"k_id\" value=\"0\">";
			}
			$template->assign_vars(array(
			'TOPIC_CAT' => $kat,
			));
			
		}
		//kategorien	
--------------Suche
	else if ( $mode == 'quote' || $mode == 'editpost' )
	{
		$subject = ( $post_data['first_post'] ) ? $post_info['topic_title'] : $post_info['post_subject'];
		$message = $post_info['post_text'];

		if ( $mode == 'editpost' )
		{
-----------Füge ein danach
	//kategorien
		$sql_kat2="select * FROM " . TOPIC_KAT . " where forum_id=" .$forum_id. " ORDER BY kategorie" ;
        		
        		if ($result = $db->sql_query($sql_kat2)){
		$result2 = $db->sql_query($sql_kat2);
		$kat33 = $db->sql_fetchrow($result2);		
		$to_cat=count($kat33);
		if($to_cat >=1){
			$first= "<select size=\"1\" name=\"k_id\">";
			$first.="<option value=\"0\" $s>$kat[kategorie]</option>";
			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;
		}else{
		$kat="<input type=\"hidden\" name=\"k_id\" value=\"0\">";
		}			
			$template->assign_vars(array(
			'TOPIC_CAT' => $kat,
			));
			
		}
		//kategorien	
----------------öffne viewtopic.php

----------------suche
		$l_edited_by = '<br /><br />' . sprintf($l_edit_time_total, $poster, create_date($board_config['default_dateformat'], $postrow[$i]['post_edit_time'], $board_config['board_timezone']), $postrow[$i]['post_edit_count']);
	}
	else
	{
		$l_edited_by = '';
	}
------------Füge ein danach
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
--------------------öffne admin/admin_forum_auth.php

------------Suche
$forum_auth_fields = array('auth_view', 'auth_read', 'auth_post', 'auth_reply', 'auth_edit', 'auth_delete', 'auth_sticky', 'auth_announce', 'auth_vote', 'auth_pollcreate');
-----------Ersetze durch
$forum_auth_fields = array('auth_view', 'auth_read', 'auth_post', 'auth_reply', 'auth_edit', 'auth_delete', 'auth_sticky', 'auth_announce', 'auth_vote', 'auth_pollcreate', 'auth_cat');
----------Suche 
	'auth_vote' => $lang['Vote'], 
	'auth_pollcreate' => $lang['Pollcreate'],
------------Füge ein danach
	'auth_cat' => $lang['kat']);

-----------öffne includes/auth.php

--------Suche
function auth($type, $forum_id, $userdata, $f_access = '')
--------Suche darin
		case AUTH_ALL:
------------Ersetze danach
			$a_sql = 'a.auth_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete, a.auth_sticky, a.auth_announce, a.auth_vote, a.auth_pollcreate;
			$auth_fields = array('auth_view', 'auth_read', 'auth_post', 'auth_reply', 'auth_edit', 'auth_delete', 'auth_sticky', 'auth_announce', 'auth_vote', 'auth_pollcreate');
-------------durch
			$a_sql = 'a.auth_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete, a.auth_sticky, a.auth_announce, a.auth_vote, a.auth_pollcreate, a.auth_cat';
			$auth_fields = array('auth_view', 'auth_read', 'auth_post', 'auth_reply', 'auth_edit', 'auth_delete', 'auth_sticky', 'auth_announce', 'auth_vote', 'auth_pollcreate', 'auth_cat');
-----------Suche
		case AUTH_VOTE:
			$a_sql = 'a.auth_vote';
			$auth_fields = array('auth_vote');
			break;
----------Füge ein danach
		case AUTH_CAT:
			$a_sql = 'a.auth_cat';
			$auth_fields = array('auth_cat');
			break;
--------------öffne include/functions_post.php

------------Suche
function submit_post(
----------Suche darin
&$poll_length
-------------Füge danach ein
, &$k_id
-----------Suche in der Funktion
	if ($mode == 'newtopic' || ($mode == 'editpost' && $post_data['first_post']))
	{
		$topic_vote = (!empty($poll_title) && count($poll_options) >= 2) ? 1 : 0;
----------------füge danach ein (VERY WICHTIG !)
		// KATEGORIE !!!!!!
		$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 k_id = $k_id, topic_title = '$post_subject', topic_type = $topic_type " . (($post_data['edit_vote'] || !empty($poll_title)) ? ", topic_vote = " . $topic_vote : "") . " WHERE topic_id = $topic_id";

		// KATEGORIE !!!!!
----------------------öffne includes/constants.php

------------suche 
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');
----------füge ein danach
//kategorien
define('TOPIC_KAT', $table_prefix.'topic_cat');
//kategorien

-----------------öffne Template | modcp_body.tpl

------------ Suche
  <td class="row1" align="center" valign="middle"><span class="postdetails"><b>{L_DEL_KATE}</b></span> </td>	
  </tr>
   
-------------Füge danach ein
  <!-- BEGIN forum_katrow -->
  <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>
  <!-- END forum_katrow -->
----------------öffne  language/<sprache>_main.php
------------Suche 
$lang['Sorry_auth_vote'] = "In diesem Forum knen sich %s an Abstimmungen beteiligen.";
------------füge danach ein
$lang['Sorry_auth_cat'] = "Nur %s haben die Berechtigung die Kategorien bearbeiten.";

-------------Suche
// That's all Folks!
-------------Füge danach ein

$lang['akt_kat']="Kategorie(n) erfolgreich Aktualisiert.";
$lang['new_kat']="Neue Kategorie hinzuf・en:";
$lang['kat']="Kategorien Controlpanel";

--------------------öffne SQL Oberfläche
CREATE TABLE phpbb_categories (
  cat_id mediumint(8) unsigned NOT NULL auto_increment,
  cat_title varchar(100) default NULL,
  cat_order mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (cat_id),
  KEY cat_order (cat_order)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

ALTER TABLE `phpbb_auth_access` ADD `auth_cat` `auth_cat` TINYINT( 1 ) DEFAULT '0' NOT NULL;

ALTER TABLE `phpbb_forums` ADD `auth_cat` `auth_cat` TINYINT( 1 ) DEFAULT '0' NOT NULL;


Das war's eigentlich

gibt's ein Danke ?! :grin:

Re

Verfasst: 24.03.2004 00:59
von rcbcom
Mal sehen obs hilft!? ;)

ups

Verfasst: 01.04.2004 07:18
von Intelking
war falsch SORRY!!!

Verfasst: 04.04.2004 01:31
von siebenschlaefer
ich warte auch schon ewig auf ne umstellung für 2.06 bzw. mittlerweile halt 2.08 .............kann sich das nicht ma einer der obergurus hier vornehmen :P

Verfasst: 04.04.2004 01:34
von rcbcom
damit sollte es auch gehen mit 2.0.8

Code: Alles auswählen

----------öffne modcp.php 

-----------Suche 
// 
// Continue var definitions 
// 
-------------einfügen danach 
$edit = ( isset($HTTP_POST_VARS['edit']) ) ? TRUE : FALSE; 


-----------Suche (kommt gleich danach) 
if ( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) ) 
{ 
   $mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode']; 
} 
else 
{ 
   if ( $delete ) 
   { 
      $mode = 'delete'; 
   } 
------------Füge danach ein 
   //kategorien EDIT 
   else if ( $edit ) 
   { 
      $mode = 'edit'; 
   } 
   //Kategorien EDIT 
--------Suche 
      message_die(GENERAL_MESSAGE, $lang['Topics_Unlocked'] . '<br /><br />' . $message); 

      break; 
----------Füge ein danach (MODIFIFZIERT !!!) 
//kategorien 
   case 'edit': 
      if (!$is_auth['auth_cat']) 
      { 
         message_die(MESSAGE, sprintf($lang['Sorry_auth_cat'], $is_auth['auth_cat_type'])); 
      } 
       
      $page_title = $lang['Mod_CP']; 
      include($phpbb_root_path . 'includes/page_header.'.$phpEx); 
      $kategorie = $_POST['kategorie']; $kat_old = $_POST['kat_old'];       
      $kat_del = $_POST['kat_del']; $add_cat = $_POST['add_cat']; 
      $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 = "$PHP_SELF?f=$forum_id&sid=$sid"; 
         $message= $lang['akt_kat']; 
         $message.="<br>"; 
         $message.="<a href=\"$redirect_page\">" . $lang['Previous']  . "</a>"; 
         message_die(GENERAL_MESSAGE, $message); 
       
       
       
   break;    
   //kategorien    
       
-------------------Suche 
         'L_SELECT' => $lang['Select'], 
------------Füge danach ein 
         //kategorien 
         'L_ADD_KAT' =>$lang['new_kat'], 
         'L_KAT' => $lang['Category'], 
         'L_KATE' =>$lang['kat'], 
         'L_DEL_KATE' => $lang['Delete'], 
         //kategorien 
----------------suche 
            message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql); 
      } 

      while ( $row = $db->sql_fetchrow($result) ) 
      { 
-------------------Füge danach ein 
         //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 
--------------------Suche 
            'L_TOPIC_FOLDER_ALT' => $folder_alt) 
         );          
      } 

------------------Füge danach ein 
         //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 
---------------Öffne posting.php 

----------Suche 
$params = array('submit' => 'post', 'confirm' => 'confirm', 'preview' => 'preview', 'delete' => 'delete', 'poll_delete' => 'poll_delete', 'poll_add' => 'add_poll_option', 'poll_edit' => 'edit_poll_option', 'mode' => 'mode'); 
------------Ersetze durch 
$params = array('submit' => 'post', 'confirm' => 'confirm', 'preview' => 'preview', 'delete' => 'delete', 'poll_delete' => 'poll_delete', 'poll_add' => 'add_poll_option', 'poll_edit' => 'edit_poll_option', 'mode' => 'mode', 'k_id' => 'k_id'); 
-----------Suche 
   else 
   { 
      $$var = ''; 
   } 
} 
------------Füge ein danach 
// Kategorie Mod 

if (!$k_id) 
 $k_id = 0; 
------------Suche 
switch ( $mode ) 
{ 
   case 'newtopic': 
      if ( empty($forum_id) ) 
      { 
         message_die(GENERAL_MESSAGE, $lang['Forum_not_exist']); 
      } 

      $sql = "SELECT * 
         FROM " . FORUMS_TABLE . " 
         WHERE forum_id = $forum_id"; 
-------------------Füge ein danach 
//kategorien 
      $sql_kat="select * FROM " . TOPIC_KAT . " where forum_id=" .$forum_id. " ORDER BY kategorie" ; 
              if ( $result = $db->sql_query($sql_kat) ){ 
         $result2 = $db->sql_query($sql_kat); 
         $kat33 = $db->sql_fetchrow($result2); 
         $to_result=count($kat33); 
         if($to_result >=2){ 
         $first= "<select size=\"1\" name=\"k_id\">"; 
         $first.="<option value=\"0\">$kat[kategorie]</option>"; 
         while($kat = $db->sql_fetchrow($result)){ 
         $first.="<option value=\"" . $kat[k_id] . "\">$kat[kategorie]</option>"; 
         } 
         $first.="</select>"; 
         $kat=$first; 
         }else{ 
         $kat="<input type=\"hidden\" name=\"k_id\" value=\"0\">"; 
         } 
         $template->assign_vars(array( 
         'TOPIC_CAT' => $kat, 
         )); 
          
      } 
      //kategorien    
--------------Suche 
   else if ( $mode == 'quote' || $mode == 'editpost' ) 
   { 
      $subject = ( $post_data['first_post'] ) ? $post_info['topic_title'] : $post_info['post_subject']; 
      $message = $post_info['post_text']; 

      if ( $mode == 'editpost' ) 
      { 
-----------Füge ein danach 
   //kategorien 
      $sql_kat2="select * FROM " . TOPIC_KAT . " where forum_id=" .$forum_id. " ORDER BY kategorie" ; 
               
              if ($result = $db->sql_query($sql_kat2)){ 
      $result2 = $db->sql_query($sql_kat2); 
      $kat33 = $db->sql_fetchrow($result2);       
      $to_cat=count($kat33); 
      if($to_cat >=1){ 
         $first= "<select size=\"1\" name=\"k_id\">"; 
         $first.="<option value=\"0\" $s>$kat[kategorie]</option>"; 
         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; 
      }else{ 
      $kat="<input type=\"hidden\" name=\"k_id\" value=\"0\">"; 
      }          
         $template->assign_vars(array( 
         'TOPIC_CAT' => $kat, 
         )); 
          
      } 
      //kategorien    
----------------öffne viewtopic.php 

----------------suche 
      $l_edited_by = '<br /><br />' . sprintf($l_edit_time_total, $poster, create_date($board_config['default_dateformat'], $postrow[$i]['post_edit_time'], $board_config['board_timezone']), $postrow[$i]['post_edit_count']); 
   } 
   else 
   { 
      $l_edited_by = ''; 
   } 
------------Füge ein danach 
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 
--------------------öffne admin/admin_forum_auth.php 

------------Suche 
$forum_auth_fields = array('auth_view', 'auth_read', 'auth_post', 'auth_reply', 'auth_edit', 'auth_delete', 'auth_sticky', 'auth_announce', 'auth_vote', 'auth_pollcreate'); 
-----------Ersetze durch 
$forum_auth_fields = array('auth_view', 'auth_read', 'auth_post', 'auth_reply', 'auth_edit', 'auth_delete', 'auth_sticky', 'auth_announce', 'auth_vote', 'auth_pollcreate', 'auth_cat'); 
----------Suche 
   'auth_vote' => $lang['Vote'], 
   'auth_pollcreate' => $lang['Pollcreate'], 
------------Füge ein danach 
   'auth_cat' => $lang['kat']); 

-----------öffne includes/auth.php 

--------Suche 
function auth($type, $forum_id, $userdata, $f_access = '') 
--------Suche darin 
      case AUTH_ALL: 
------------Ersetze danach 
         $a_sql = 'a.auth_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete, a.auth_sticky, a.auth_announce, a.auth_vote, a.auth_pollcreate; 
         $auth_fields = array('auth_view', 'auth_read', 'auth_post', 'auth_reply', 'auth_edit', 'auth_delete', 'auth_sticky', 'auth_announce', 'auth_vote', 'auth_pollcreate'); 
-------------durch 
         $a_sql = 'a.auth_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete, a.auth_sticky, a.auth_announce, a.auth_vote, a.auth_pollcreate, a.auth_cat'; 
         $auth_fields = array('auth_view', 'auth_read', 'auth_post', 'auth_reply', 'auth_edit', 'auth_delete', 'auth_sticky', 'auth_announce', 'auth_vote', 'auth_pollcreate', 'auth_cat'); 
-----------Suche 
      case AUTH_VOTE: 
         $a_sql = 'a.auth_vote'; 
         $auth_fields = array('auth_vote'); 
         break; 
----------Füge ein danach 
      case AUTH_CAT: 
         $a_sql = 'a.auth_cat'; 
         $auth_fields = array('auth_cat'); 
         break; 
--------------öffne include/functions_post.php 

------------Suche 
function submit_post( 
----------Suche darin 
&$poll_length 
-------------Füge danach ein 
, &$k_id 
-----------Suche in der Funktion 
   if ($mode == 'newtopic' || ($mode == 'editpost' && $post_data['first_post'])) 
   { 
      $topic_vote = (!empty($poll_title) && count($poll_options) >= 2) ? 1 : 0; 
----------------füge danach ein (VERY WICHTIG !) 
      // KATEGORIE !!!!!! 
      $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 k_id = $k_id, topic_title = '$post_subject', topic_type = $topic_type " . (($post_data['edit_vote'] || !empty($poll_title)) ? ", topic_vote = " . $topic_vote : "") . " WHERE topic_id = $topic_id"; 

      // KATEGORIE !!!!! 
----------------------öffne includes/constants.php 

------------suche 
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters'); 
----------füge ein danach 
//kategorien 
define('TOPIC_KAT', $table_prefix.'topic_cat'); 
//kategorien 

-----------------öffne Template | modcp_body.tpl 

------------ Suche 
  <td class="row1" align="center" valign="middle"><span class="postdetails"><b>{L_DEL_KATE}</b></span> </td>    
  </tr> 
    
-------------Füge danach ein 
  <!-- BEGIN forum_katrow --> 
  <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> 
  <!-- END forum_katrow --> 
----------------öffne  language/<sprache>_main.php 
------------Suche 
$lang['Sorry_auth_vote'] = "In diesem Forum knen sich %s an Abstimmungen beteiligen."; 
------------füge danach ein 
$lang['Sorry_auth_cat'] = "Nur %s haben die Berechtigung die Kategorien bearbeiten."; 

-------------Suche 
// That's all Folks! 
-------------Füge danach ein 

$lang['akt_kat']="Kategorie(n) erfolgreich Aktualisiert."; 
$lang['new_kat']="Neue Kategorie hinzuf・en:"; 
$lang['kat']="Kategorien Controlpanel"; 

--------------------öffne SQL Oberfläche 
CREATE TABLE phpbb_categories ( 
  cat_id mediumint(8) unsigned NOT NULL auto_increment, 
  cat_title varchar(100) default NULL, 
  cat_order mediumint(8) unsigned NOT NULL default '0', 
  PRIMARY KEY  (cat_id), 
  KEY cat_order (cat_order) 
) TYPE=MyISAM AUTO_INCREMENT=2 ; 

ALTER TABLE `phpbb_auth_access` ADD `auth_cat` `auth_cat` TINYINT( 1 ) DEFAULT '0' NOT NULL; 

ALTER TABLE `phpbb_forums` ADD `auth_cat` `auth_cat` TINYINT( 1 ) DEFAULT '0' NOT NULL;
Code von Messiah of Death

also bei mir läuft es soweit.

Verfasst: 04.04.2004 01:35
von rcbcom
Edit

Verfasst: 04.04.2004 18:00
von adidas
naja perfekt ist es nicht aber schlecht ist das auch nicht

ich finde es ist ok, habe für gut gevotet

Verfasst: 19.07.2004 17:23
von Holger
Gibt es ein Update für 2.0.10?

Kriege nämlich die Fehlermeldung:
Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'WHERE topic_id = 14' at line 1

UPDATE phpbb_topics SET topic_title = 'Namn- och adresslista', topic_type = 0 , k_id= WHERE topic_id = 14

Line : 266
File : /customers/gremminger.se/gremminger.se/httpd.www/service/forum/includes/functions_post.php
wenn ich versuche ein Topic zu ändern und wieder abzuspeichern. Hat bis heute wunderbar funktioniert, nach dem Update auf 2.0.9 oder 2.0.10 leider nicht mehr.

Gruss
Holger

Verfasst: 26.07.2004 12:39
von abcdefg123
also ich ahb die version 2.0.10 und template SmartDark! Im ModCP ist da rein gar nix -.-

Verfasst: 27.07.2004 20:57
von poisi
gibts da für die 2.0.10 version schon eine möglichkeit?
Alle Zeiten sind UTC+02:00
Seite 4 von 5

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de