phpBB.de

Code: Alles auswählen

ALTER TABLE phpbb_categories 
ADD parent_forum_id SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL, 
ADD cat_hier_level TINYINT UNSIGNED DEFAULT '0' NOT NULL;


ALTER TABLE phpbb_forums
ADD forum_hier_level TINYINT UNSIGNED DEFAULT '0' NOT NULL AFTER forum_last_post_id, 
ADD forum_issub TINYINT(1) DEFAULT '0' NOT NULL AFTER forum_hier_level; 


CREATE TABLE phpbb_cat_rel_cat_parents (
cat_id mediumint(8) unsigned NOT NULL default '0',
parent_cat_id mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY  (cat_id,parent_cat_id)
);

CREATE TABLE phpbb_cat_rel_forum_parents (
cat_id mediumint(8) unsigned NOT NULL default '0',
parent_forum_id smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY  (cat_id,parent_forum_id)
);

Code: Alles auswählen

<?php
/***************************************************************************
 *                              admin_query.php
 *                            -------------------
 *   begin                : Saturday, Febr 9, 2002
 *   copyright            : (C) 2002 XpertNetCoderZ
 *   email                : dwing@weingarten-net.de
 *
 *   $Id: admin_querye.php, v 1.00 2002/02/9 16:01:00 Dwing  $
 *
 *
 * uses phpBB technology (c) 2001 phpB<http://www.phpbb.com/>
 *
***************************************************************************/

/* **************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
***************************************************************************/

if( !empty($setmodules) )
{
   $filename = basename(__FILE__);
   $module['Users']['Disallow'] = append_sid($filename);
   $module['General']['Query Database'] = append_sid($filename."?mode=query");
}


//
// Load default header
//

define('IN_PHPBB', 1);
$phpbb_root_path = "./../";
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);

if(!$mode == "query")
{
	$query = $_POST["query"];
   if( mysql_query($query) )
   {
   echo "Mysql Query succesful";
   }
   else
   {
   echo "Error: Query "".$query."" could't be used succesfull";
   }
}
else
{
?>
<h1>Query Database</h1>
<p>&nbsp;</p>
<p>&nbsp;</p>

<table class="forumline" cellSpacing="1" cellPadding="4" align="center" border="0">
    <tbody>
      <tr>
        <th class="thHead" align="middle">Query Database</th>
      </tr>
      <tr>
        <td class="row1" align="middle"><p>
        <form method="post" action="admin_query.php">
        <textarea rows="7" name="query" cols="40">Query</textarea></p>
  &nbsp;<input class="mainoption" type="submit" value="Query" name="pruneset">&nbsp;
  		</form>
      </td>
      </tr>
    </tbody>
  </table>
<?
}

?>