Binary Tree kapot

Dmeijer13 · Bericht door **Dmeijer13** » 21 jun 2009, 14:24

Adres van je forum: http://forums.pokeplace.nl
Event. modificaties op je forum: categorize announcements stickies, ajax chat, upcoming birthday, html email, announcement centre, posting template, mcp info on index
Wanneer ontstond het probleem? Geen idee...
phpBB versie: 3.0.5

Heb je onlangs iets veranderd aan je forum?
Wat is het probleem?

In forums waar geen subforum in zit weergeeft het forum dat er wel subboards inzitten.
Toen ik net zo'n forum delete, veranderde er meer, ik ben nu namelijk een hele categorie kwijt + alles boards daarin en 2 ervan worden als subboard op de index als subboard weergegeven bij hulp % vragen terwijl als ik het open er niks staat.

Als ik een board aanmaak, dan zag ik hem net iig niet verschijnen terwijl d=hij wle permissies had...

Wat moet ik nu doen.. =(
..

Derky · Bericht door **Derky** » 21 jun 2009, 16:27

Kan je het probleem misschien wel duidelijker uitleggen, eventueel met screenshots?

Dmeijer13 · Bericht door **Dmeijer13** » 22 jun 2009, 19:57

'k Zal een duidelijkere uitleg proberen...

Ik probeerde daarstraks een board aan te maken gelukt, maar was niet te zien op de index. Permissies enzo stonden gewoon goed. Ik heb het board maar verwijderd... Maar door deze actie is een andere categorie + de boards die eribj hoorde ook verwijderd. Gek, want ik had die categorie niet verwijderd.

Doordat dit deleted was, kwam ik weer op de index, en toen zag ik dat pas dus, ook in ACP zie ik de categorie niet meer staan. Net zoals 2 andere boards die in die categorie behoorde zijn nu een subboard in een ander board, terwijl ikz e nóóit verplaatst heb.

Dit heb ik nu continu gek genoeg als ik een board aanmaak of wat dan ook... en ik ahd het eerder, dacht dat het opgelost was, maar mooi niet..

Als ik een board aanaak kan het ook zijnd at ie automatishc in een andere categorie terechtkomt, of ergens als een subboard.. Ik snap er niks van, en dit klopt ook totaal niet... Deze modificaties heb ik al langeretijd, en heb er nooit problemen mee gehad. Het probleem begon eerder dan 3.0.5 want ik heb vandaag de update gedaan.

Dmeijer13 · Bericht door **Dmeijer13** » 29 jun 2009, 21:13

Iemand? :S

Iemand die eventeel anders kijken wil...

www.forums.pokeplace.nl
useR: Testing Account
pass: testing

Dmeijer13 · Bericht door **Dmeijer13** » 02 jul 2009, 10:03

Nieuw voorbeeld van mijn probleem...

Ik heb de 2e categorie (algemeen) met boards en al opnieuw gemaakt. Daarna heb ik Hulp & Vragen verwijderd.

In hulp en vragen zaten 2 subboards zoals hij op de index aangaf, maar bij het deleten zag ik niks over subboards. En als ik het forum opende zag ik ook geen subboards.

Na het deleten eheft hij Poke-Populatie Toernooi en Team rating en building verplaatst naar Mededelingen. Als je mededelingen opent, zie je die subboards niet... Als je op de index op het forum klik (bij subforums) dna kom je er wel in...

Ik vind dit heel raar weet niet waar het aan ligt, enw eet alleen dat het ZSM opgelost moet worden...

Derky · Bericht door **Derky** » 02 jul 2009, 22:13

Het lijkt erop dat je Binary Tree dood is.

Wat dat is? Deze 'boom' houd bij in welke volgorde de forums staan en welke subforums van elkaar zijn.

Hoe lossen we dit op?
Maak eerst een back-up van je database.
Maak een bestand genaamd rebuild_tree.php aan en zet daarin het onderstaande. Voer daarna dit bestand uit en het moet weer werken. De forums zullen nu wel door de war staan maar dit was dus al zo, alleen zag je het niet.

Code: Selecteer alles

<?php

define('IN_PHPBB', true);
$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);


// Start session management
$user->session_begin();
$auth->acl($user->data);

/*
 Recalculate Binary Tree */

function recalc_btree($sql_id, $sql_table, $module_class = '')
{
    global $db;

    if (!$sql_id || !$sql_table)
    {
        return;
    }

    $sql_where = ($module_class) ? " WHERE module_class = '" . $db->sql_escape($module_class) . "'" : '';

    // Reset to minimum possible left and right id
    $sql = "SELECT MIN(left_id) as min_left_id, MIN(right_id) as min_right_id
        FROM $sql_table
        $sql_where";
    $result = $db->sql_query($sql);
    $row = $db->sql_fetchrow($result);
    $db->sql_freeresult($result);

    $substract = (int) (min($row['min_left_id'], $row['min_right_id']) - 1);

    if ($substract > 0)
    {
        $sql = "UPDATE $sql_table
            SET left_id = left_id - $substract, right_id = right_id - $substract
            $sql_where";
        $db->sql_query($sql);
    }

    $sql = "SELECT $sql_id, parent_id, left_id, right_id
        FROM $sql_table
        $sql_where
        ORDER BY left_id ASC, parent_id ASC, $sql_id ASC";
    $f_result = $db->sql_query($sql);

    while ($item_data = $db->sql_fetchrow($f_result))
    {
        if ($item_data['parent_id'])
        {
            $sql = "SELECT left_id, right_id
                FROM $sql_table
                $sql_where " . (($sql_where) ? 'AND' : 'WHERE') . "
                    $sql_id = {$item_data['parent_id']}";
            $result = $db->sql_query($sql);

            if (!$row = $db->sql_fetchrow($result))
            {
                $sql = "UPDATE $sql_table SET parent_id = 0 WHERE $sql_id = " . $item_data[$sql_id];
                $db->sql_query($sql);
            }
            $db->sql_freeresult($result);

            $sql = "UPDATE $sql_table
                SET left_id = left_id + 2, right_id = right_id + 2
                $sql_where " . (($sql_where) ? 'AND' : 'WHERE') . "
                    left_id > {$row['right_id']}";
            $db->sql_query($sql);

            $sql = "UPDATE $sql_table
                SET right_id = right_id + 2
                $sql_where " . (($sql_where) ? 'AND' : 'WHERE') . "
                    {$row['left_id']} BETWEEN left_id AND right_id";
            $db->sql_query($sql);

            $item_data['left_id'] = $row['right_id'];
            $item_data['right_id'] = $row['right_id'] + 1;
        }
        else
        {
            $sql = "SELECT MAX(right_id) AS right_id
                FROM $sql_table
                $sql_where";
            $result = $db->sql_query($sql);
            $row = $db->sql_fetchrow($result);
            $db->sql_freeresult($result);

            $item_data['left_id'] = $row['right_id'] + 1;
            $item_data['right_id'] = $row['right_id'] + 2;
        }
    
        $sql = "UPDATE $sql_table
            SET left_id = {$item_data['left_id']}, right_id = {$item_data['right_id']}
            WHERE $sql_id = " . $item_data[$sql_id];
        $db->sql_query($sql);
    }
    $db->sql_freeresult($f_result);
}

recalc_btree('forum_id', FORUMS_TABLE);

trigger_error("klaar!");

?>

Dmeijer13 · Bericht door **Dmeijer13** » 03 jul 2009, 09:53

Ik krijg hierbij de voglende SQL error:

Code: Selecteer alles

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 [1064]

SQL

UPDATE phpbb_forums SET left_id = left_id + 2, right_id = right_id + 2 WHERE left_id > 

BACKTRACE


FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: rebuild_tree.php
LINE: 72
CALL: dbal_mysql->sql_query()

FILE: rebuild_tree.php
LINE: 104
CALL: recalc_btree()

Doe ik zelf nu iets verkeerd?

Derky · Bericht door **Derky** » 03 jul 2009, 21:02

Geen idee waardoor dat komt..

In de support toolkit zit dezelfde functie, alleen mogen we deze nog niet aanbevelen in de support forums omdat dit een Release Candidate is. (Dus probeer het uit op eigen risico en maak db backup)

Erik Frèrejean · Bericht door **Erik Frèrejean** » 03 jul 2009, 21:42

Derky schreef:Geen idee waardoor dat komt.. In de support toolkit zit dezelfde functie, alleen mogen we deze nog niet aanbevelen in de support forums omdat dit een Release Candidate is. (Dus probeer het uit op eigen risico en maak db backup)

Doe dat dan ook niet

.

By the way het is geen Binary Tree

Dmeijer13 · Bericht door **Dmeijer13** » 04 jul 2009, 00:37

Nu klik ik opnieuw op forumindex en krijg je de voglende melding:

Code: Selecteer alles

[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 215: Undefined offset: 0
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 215: Undefined index: forum_topics
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 220: Undefined index: forum_posts
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 223: Undefined index: forum_last_post_time
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 281: Undefined index: parent_id
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 281: Undefined index: forum_type
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 285: Undefined index: forum_id
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 286: Undefined index: forum_name
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 287: Undefined index: forum_desc
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 287: Undefined index: forum_desc_uid
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 287: Undefined index: forum_desc_bitfield
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 287: Undefined index: forum_desc_options
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 290: Undefined index: forum_image
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 291: Undefined index: forum_image
[phpBB Debug] PHP Notice: in file /includes/functions_display.php on line 292: Undefined index: forum_id
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3838: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3840: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3841: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3842: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)

@Erik, Wat is het dan wel?

Erik Frèrejean · Bericht door **Erik Frèrejean** » 04 jul 2009, 04:07

Het is een nested set

.
http://code.phpbb.com/repositories/diff/phpbb?rev=9606

Stomme renaming

- Derky

Dmeijer13 · Bericht door **Dmeijer13** » 05 jul 2009, 15:12

Wat moet ik nu doen om het goed te krijgen dan?

Dmeijer13 · Bericht door **Dmeijer13** » 07 jul 2009, 12:04

Iemand 'n idee... ?

Erik Frèrejean · Bericht door **Erik Frèrejean** » 08 jul 2009, 10:38

Kan je een dump van je forums table posten?
Heb je een backup van voor dat het probleem begon?

Dmeijer13 · Bericht door **Dmeijer13** » 08 jul 2009, 18:31

Erik Frèrejean schreef:Kan je een dump van je forums table posten?
Heb je een backup van voor dat het probleem begon?

De dump kan ik best posten.
Backup ja volgens mij wel. Daar ook meteen een dump van?

Nouja nu:

Code: Selecteer alles

CREATE TABLE IF NOT EXISTS `phpbb_forums` (
  `forum_id` mediumint(8) unsigned NOT NULL auto_increment,
  `parent_id` mediumint(8) unsigned NOT NULL default '0',
  `left_id` mediumint(8) unsigned NOT NULL default '0',
  `right_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_parents` mediumtext collate utf8_bin NOT NULL,
  `forum_name` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_desc` text collate utf8_bin NOT NULL,
  `forum_desc_bitfield` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_desc_options` int(11) unsigned NOT NULL default '7',
  `forum_desc_uid` varchar(8) collate utf8_bin NOT NULL default '',
  `forum_link` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_password` varchar(40) collate utf8_bin NOT NULL default '',
  `forum_style` mediumint(8) unsigned NOT NULL default '0',
  `forum_image` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_rules` text collate utf8_bin NOT NULL,
  `forum_rules_link` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_rules_bitfield` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_rules_options` int(11) unsigned NOT NULL default '7',
  `forum_rules_uid` varchar(8) collate utf8_bin NOT NULL default '',
  `forum_topics_per_page` tinyint(4) NOT NULL default '0',
  `forum_type` tinyint(4) NOT NULL default '0',
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics_real` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_poster_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_subject` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_last_post_time` int(11) unsigned NOT NULL default '0',
  `forum_last_poster_name` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_last_poster_colour` varchar(6) collate utf8_bin NOT NULL default '',
  `forum_flags` tinyint(4) NOT NULL default '32',
  `display_on_index` tinyint(1) unsigned NOT NULL default '1',
  `enable_indexing` tinyint(1) unsigned NOT NULL default '1',
  `enable_icons` tinyint(1) unsigned NOT NULL default '1',
  `enable_prune` tinyint(1) unsigned NOT NULL default '0',
  `prune_next` int(11) unsigned NOT NULL default '0',
  `prune_days` mediumint(8) unsigned NOT NULL default '0',
  `prune_viewed` mediumint(8) unsigned NOT NULL default '0',
  `prune_freq` mediumint(8) unsigned NOT NULL default '0',
  `forum_post_tpl` text collate utf8_bin,
  `display_subforum_list` tinyint(1) unsigned NOT NULL default '1',
  `forum_topic_tags` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`forum_id`),
  KEY `left_right_id` (`left_id`,`right_id`),
  KEY `forum_lastpost_id` (`forum_last_post_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=193 ;

--
-- Gegevens worden uitgevoerd voor tabel `phpbb_forums`
--

INSERT INTO `phpbb_forums` (`forum_id`, `parent_id`, `left_id`, `right_id`, `forum_parents`, `forum_name`, `forum_desc`, `forum_desc_bitfield`, `forum_desc_options`, `forum_desc_uid`, `forum_link`, `forum_password`, `forum_style`, `forum_image`, `forum_rules`, `forum_rules_link`, `forum_rules_bitfield`, `forum_rules_options`, `forum_rules_uid`, `forum_topics_per_page`, `forum_type`, `forum_status`, `forum_posts`, `forum_topics`, `forum_topics_real`, `forum_last_post_id`, `forum_last_poster_id`, `forum_last_post_subject`, `forum_last_post_time`, `forum_last_poster_name`, `forum_last_poster_colour`, `forum_flags`, `display_on_index`, `enable_indexing`, `enable_icons`, `enable_prune`, `prune_next`, `prune_days`, `prune_viewed`, `prune_freq`, `forum_post_tpl`, `display_subforum_list`, `forum_topic_tags`) VALUES
(65, 0, 106, 113, '', 'PokePlace.nl', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 6, 1, 1, 7926, 6, 'Re: karel art', 1208033810, 'Mismagius', '6699CC', 32, 1, 1, 1, 0, 0, 0, 0, 0, '', 1, 0),
(67, 0, 14, 23, '', 'The Games', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 1, 1, 0, 0, 0, 0, 0, '', 1, 0),
(70, 0, 48, 83, '', 'Off-Topic', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 1, 1, 0, 0, 0, 0, 0, '', 1, 0),
(71, 33, 52, 53, 0x613a323a7b693a37303b613a323a7b693a303b733a393a224f66662d546f706963223b693a313b693a303b7d693a33333b613a323a7b693a303b733a32333a224f6666746f7069632026616d703b205370616d6d696e67223b693a313b693a313b7d7d, 'Media', 0x50726161742068696572206f76657220616c6c65732076616e206465206d656469612c2062756974656e20706f6b656d6f6e206f6d21, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 221, 20, 20, 14745, 2, 'Re: Welke nummer bespeel je nu?', 1244126405, 'Splashing Mudkip', '0000CC', 32, 1, 1, 1, 0, 0, 0, 0, 0, '', 1, 0),
(179, 178, 94, 95, '', 'Basis', 0x4c656572206869657220616c6c652062617369732064696e67656e21, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(1, 65, 107, 112, 0x613a313a7b693a36353b613a323a7b693a303b733a31323a22506f6b65506c6163652e6e6c223b693a313b693a303b7d7d, 'Mededelingen', 0x48696572206b6f6d656e20616c206f6e7a652062656c616e6772696a6b65206d656c64696e67656e206f76657220506f6b65506c6163652e6e6c, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 44, 5, 5, 14569, 2, 'Re: Website Team', 1242572685, 'Splashing Mudkip', '0000CC', 34, 1, 1, 1, 0, 0, 0, 0, 0, '', 1, 1),
(161, 159, 43, 44, '', 'WiFi - Andere Games', 0x5769466920696e2067616d65732062756974656e20706f6b656d6f6e3f20426573707265656b20686574206869657221, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(162, 159, 45, 46, '', 'WiFi Hulp', 0x56726167656e206f662048756c70206f76657220576946693f205a6574206865742068696572206e65657221, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(4, 51, 30, 31, 0x613a323a7b693a3135383b613a323a7b693a303b733a393a225370696e2d6f666673223b693a313b693a303b7d693a35313b613a323a7b693a303b733a31333a224f7665726967652047616d6573223b693a313b693a313b7d7d, 'Pokemon Red, Blue & Yellow', 0x56696e64742026616d703b207672616167206869657220616c6c6573206f76657220506f6b656d6f6e205265642c20426c75652026616d703b2059656c6c6f77, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 27, 4, 4, 12412, 183, 'Re: challange', 1223828351, 'Rotom', '6699CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),
(5, 51, 32, 33, 0x613a323a7b693a3135383b613a323a7b693a303b733a393a225370696e2d6f666673223b693a313b693a303b7d693a35313b613a323a7b693a303b733a31333a224f7665726967652047616d6573223b693a313b693a313b7d7d, 'Pokemon Gold, Silver & Crystal', 0x56696e64742026616d703b207672616167206869657220616c6c6573206f76657220506f6b656d6f6e20476f6c642c2073696c7665722026616d703b204372797374616c2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 24, 4, 4, 8373, 51, 'Re: Mening', 1208788976, 'Jarno', '6699CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),
(6, 67, 17, 18, 0x613a313a7b693a36373b613a323a7b693a303b733a393a225468652047616d6573223b693a313b693a303b7d7d, 'Pokemon Ruby, Sapphire & Emerald', 0x50726161742068696572206f76657220646520486f656e6e20726567696f2c2033652067656e657261746965, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 91, 11, 11, 14742, 2, 'Re: was emerald nauw zo veel beter dan ruby/saphire?', 1244110510, 'Splashing Mudkip', '0000CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),
(11, 41, 15, 16, '', 'Pokemon of the Week', 0x456c6b65207765656b2065656e206e696575776520506f6b656d6f6e206f6620746865205765656b2c2077696520697320646974206b6565722064652062657374653f, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 7, 1, 1, 14568, 179, 'Re: Pokemon of the Week #1', 1242570292, 'Tim', '6699CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),
(51, 158, 29, 38, 0x613a313a7b693a3135383b613a323a7b693a303b733a393a225370696e2d6f666673223b693a313b693a303b7d7d, 'Overige Games', 0x56696e64742026616d703b2076726161672068696572206f76657220616c6c6520616e64657265206265737461616e646520706f6b656d6f6e2067616d65732e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 20, 3, 3, 14489, 179, 'Re: GOLD & SILVER REMAKES!', 1242309680, 'Tim', '6699CC', 34, 0, 1, 0, 0, 0, 0, 0, 0, '', 0, 0),
(33, 70, 51, 60, 0x613a313a7b693a37303b613a323a7b693a303b733a393a224f66662d546f706963223b693a313b693a303b7d7d, 'Offtopic & Spamming', 0x416c6c657320776174206e657267656e7320616e64657273206b616e2c206b616e20686965722c206f6f6b20616c73206a65206666206c656b6b6572207370616d6d656e2077696c74210a5b623a313969687a3935625d576f7264206e696574206d6565676574656c6420766f6f72206a6520706f7374636f756e742e5b2f623a313969687a3935625d, 'QA==', 7, '19ihz95b', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 396, 12, 12, 14766, 26, 'Vakantie.', 1246348954, 'Shadow Celebi', '339900', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),
(182, 178, 100, 101, '', 'Geschiedenis', 0x4c656572206869657220616c6c6573206f766572206465204765736368696564656e69732076616e20506f6b656d6f6e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(180, 178, 96, 97, '', 'In depth Pokemon', 0x4c656572206869657220616c6c6573206f76657220496e20646570746820506f6b656d6f6e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(181, 178, 98, 99, '', 'Competitief', 0x4c656572206869657220616c6c6573206f76657220636f6d7065746974696566207370656c656e2076616e20506f6bc3a96d6f6e207370656c6c656e2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(178, 173, 93, 102, '', 'RPG Lessen', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(156, 67, 19, 20, 0x613a313a7b693a36373b613a323a7b693a303b733a393a225468652047616d6573223b693a313b693a303b7d7d, 'Pokemon Soul Silver & Heart Gold', 0x44652072656d616b65732076616e20506f6b656d6f6e2053696c76657220656e20476f6c642c206f6f6b2064657a6520322067616d6573206b6f6d656e2065722064616e2065696e64656c696a6b2061616e2c206b6f6d206869657220616c6c657320616c732065657273746520746520776574656e21, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 29, 4, 4, 14668, 183, 'Re: Team Rocket!', 1243062897, 'Rotom', '6699CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(8, 67, 21, 22, 0x613a313a7b693a36373b613a323a7b693a303b733a393a225468652047616d6573223b693a313b693a303b7d7d, 'Pokemon Leaf Green & Fire Red', 0x56696e64742026616d703b207672616167206869657220616c6c6573206f76657220506f6b656d6f6e204c65616620477265656e2026616d703b2046697265205265642e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 18, 2, 2, 14201, 7, 'Re: echt zoveel beter of gewoon de wil naar meer geld?', 1233762154, 'ShadowLoom', '0000CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),
(9, 51, 36, 37, 0x613a323a7b693a3135383b613a323a7b693a303b733a393a225370696e2d6f666673223b693a313b693a303b7d693a35313b613a323a7b693a303b733a31333a224f7665726967652047616d6573223b693a313b693a313b7d7d, 'Pokemon Mystery Dungeon Red & Blue', 0x56696e64742026616d703b205672616167206869657220616c6c6573206f76657220506f6b656d6f6e204d7973746572792044756e67656f6e2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 164, 13, 13, 14677, 7, 'Het algemen rescue topic', 1243101239, 'ShadowLoom', '0000CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),
(10, 51, 34, 35, 0x613a323a7b693a3135383b613a323a7b693a303b733a393a225370696e2d6f666673223b693a313b693a303b7d693a35313b613a323a7b693a303b733a31333a224f7665726967652047616d6573223b693a313b693a313b7d7d, 'Pokemon Ranger', 0x50726161742068696572206f76657220646520506f6b656d6f6e2052616e6765722061766f6e747572656e20696e20646520726567696f2046696f72652e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 10, 2, 2, 12413, 183, 'Re: Het moeilijkste', 1223828410, 'Rotom', '6699CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),
(23, 70, 49, 50, 0x613a313a7b693a37303b613a323a7b693a303b733a393a224f66662d546f706963223b693a313b693a303b7d7d, 'Stel je voor!', 0x42656e206a65206e696575773f204c6161742064616e20776574656e20776965206a652062656e7421, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 553, 63, 63, 14363, 26, 'Re: Justin hoi', 1237102570, 'Shadow Celebi', '339900', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),
(158, 0, 24, 39, '', 'Spin-offs', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(159, 0, 40, 47, '', 'Wi-Fi', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(160, 159, 41, 42, '', 'WiFi gevechten & ruilen', 0x47657665636874656e206f66207275696c656e20696e20646520706f6b656d6f6e2067616d65733f2048696572206b616e2068657421, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 56, 6, 6, 14618, 7, 'Re: Random Toernooi', 1242743102, 'ShadowLoom', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(107, 0, 114, 115, 0x613a313a7b693a34313b613a323a7b693a303b733a373a22506f6b656d6f6e223b693a313b693a303b7d7d, 'Poke-populatie toernooi', 0x5374656d2068696572206f70206a6f75206661766f7269657420656e206c616174206a65206661766f726965746520706f6b656d6f6e20686965722077696e6e656e21, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 455, 69, 69, 14473, 183, 'Re: Umbreon VS Glaceon', 1242231897, 'Rotom', '6699CC', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(105, 1, 108, 109, 0x613a323a7b693a36353b613a323a7b693a303b733a31323a22506f6b65506c6163652e6e6c223b693a313b693a303b7d693a313b613a323a7b693a303b733a31323a224d65646564656c696e67656e223b693a313b693a313b7d7d, 'Crewroom', 0x4869657220776f726420616c6c65732062657370726f6b656e2062696e6e656e20616c6c652063726577206c6564656e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 35, 6, 6, 14760, 2, 'Re: Mod-Voorwaarden/regels', 1244754746, 'Splashing Mudkip', '0000CC', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(184, 70, 69, 70, 0x613a313a7b693a37303b613a323a7b693a303b733a393a224f66662d546f706963223b693a313b693a303b7d7d, 'Forumspellen', 0x537065656c206869657220616c6c65207370656c6c65746a657320646965206a65207669612068657420666f72756d207370656c656e206b616e21, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 2840, 22, 22, 14749, 19, 'Re: The Never Ending Question', 1244202792, 'TiliX', '339900', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(185, 173, 103, 104, '', 'RPG Overleg', 0x48696572206b756e6e656e20616c6c65656e2064652061646d696e6973747261746f72656e2026616d703b20646520727067206c6564656e2062696a2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 2, 1, 1, 14764, 2, 'Re: Voorbeeld lessentopic', 1245588119, 'Splashing Mudkip', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(139, 158, 25, 26, 0x613a313a7b693a3135383b613a323a7b693a303b733a393a225370696e2d6f666673223b693a313b693a303b7d7d, 'Mystery Dungeon Time & Darkness', 0x56696e647420656e207672616167206869657220616c6c6573206f7665722064652032652067656e6572617469652076616e204d7973746572792044756e67656f6e2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 25, 7, 7, 14676, 7, 'Het algemeen rescue topic', 1243101183, 'ShadowLoom', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(140, 158, 27, 28, 0x613a313a7b693a3135383b613a323a7b693a303b733a393a225370696e2d6f666673223b693a313b693a303b7d7d, 'Pokemon Ranger 2: Shadows of Almia', 0x56696e647420656e207672616167206869657220616c6c6573206f76657220506f6b656d6f6e2052616e6765723b20536861646f7773206f6620416c6d6961, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 20, 5, 5, 14765, 183, 'Re: Leuke regio?', 1246085998, 'Rotom', '6699CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(172, 169, 80, 81, 0x613a323a7b693a37303b613a323a7b693a303b733a393a224f66662d546f706963223b693a313b693a303b7d693a3136393b613a323a7b693a303b733a373a2246616e576f726b223b693a313b693a313b7d7d, 'Hulp & Tutorials', 0x567261616720686965722068756c702c206f6620706c616174732068696572207475746f7269616c7321, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(138, 67, 15, 16, 0x613a313a7b693a36373b613a323a7b693a303b733a393a225468652047616d6573223b693a313b693a303b7d7d, 'Pokemon Pearl, Diamond & Platinum', 0x50726161742068696572206f76657220646520506f6b656d6f6e2047616d65732076616e2064652053696e6e6f6820526567696f21200a5b623a3166366e6a6376365d506c6174696e756d2072656c656173653a203232204d656920323030395b2f623a3166366e6a6376365d, 'QA==', 7, '1f6njcv6', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 142, 23, 23, 14747, 2, 'Re: Platinum team', 1244150930, 'Splashing Mudkip', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(157, 41, 1, 2, 0x613a313a7b693a34313b613a323a7b693a303b733a373a22506f6b656d6f6e223b693a313b693a303b7d7d, 'Films, Anime & Muziek', 0x56696e6474206869657220616c6c6573206f76657220646520506f6b656d6f6e2046696c6d732c20416e696d652026616d703b204d757a69656b2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 252, 19, 19, 14449, 183, 'Re: Wedstrijden - Coordinators.', 1242151333, 'Rotom', '6699CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(153, 1, 110, 111, 0x613a323a7b693a36353b613a323a7b693a303b733a31323a22506f6b65506c6163652e6e6c223b693a313b693a303b7d693a313b613a323a7b693a303b733a31323a224d65646564656c696e67656e223b693a313b693a313b7d7d, 'Styling Team overleg + Artikelen', 0x48696572206b616e20686574205374796c696e67205465616d206f7665726c656767656e2c206f6f6b20776f7264656e206869657220646520617274696b656c656e206765706c61617473207a6f646174207a65206e6167656b656b656e206b756e6e656e20776f7264656e20656e206765706c6161747374206b756e6e656e20776f7264656e2e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 45, 11, 11, 14662, 177, 'Re: Menu Suggesties', 1242986530, 'Niels', 'FF9900', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(134, 0, 1, 12, 0x613a313a7b693a34313b613a323a7b693a303b733a373a22506f6b656d6f6e223b693a313b693a303b7d7d, 'Team Rating & Building', 0x566f6f7220616c206a652074697073206f766520726a65207465616d2c206f6620686574206c6174656e20726174656e2076616e206a65207465616d2c2068696572206b616e2068657421, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 23, 5, 5, 14443, 10, 'Mijn platinum team (word updated)', 1242143240, 'mew vanger', '993399', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(137, 33, 54, 55, 0x613a323a7b693a37303b613a323a7b693a303b733a393a224f66662d546f706963223b693a313b693a303b7d693a33333b613a323a7b693a303b733a32333a224f6666746f7069632026616d703b205370616d6d696e67223b693a313b693a313b7d7d, 'Discussies', 0x5a6574206869657220616c6c6520676f6564652064697363757373696573206e65657221, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 148, 13, 13, 14743, 2, 'Re: Rare nieuwsberichten.', 1244110716, 'Splashing Mudkip', '0000CC', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 0, 0),
(167, 70, 71, 72, 0x613a313a7b693a37303b613a323a7b693a303b733a393a224f66662d546f706963223b693a313b693a303b7d7d, 'Anime', 0x56696e6474206869657220616c6c657320646174206d6574206e6f6e2e706f6b656d6f6e20616e696d65207465206d616b656e20686565667421, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 38, 4, 4, 14181, 2, 'Re: YU-GI-OH', 1233740970, 'Splashing Mudkip', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(168, 70, 73, 74, 0x613a313a7b693a37303b613a323a7b693a303b733a393a224f66662d546f706963223b693a313b693a303b7d7d, 'Games', 0x56696e6474206869657220616c6c657320646174206d6574206e6f6e2d706f6b656d6f6e2067616d6573207465206d616b656e20686565667421, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 1, 1, 1, 14767, 190, 'Call of duty 4', 1246600047, 'Jensiewrt12', '6699CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(169, 70, 75, 82, 0x613a313a7b693a37303b613a323a7b693a303b733a393a224f66662d546f706963223b693a313b693a303b7d7d, 'FanWork', 0x56696e6474206869657220616c6c657320646174207465206d616b656e206865656674206d65742044657369676e2026616d703b2046616e6669632e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(170, 169, 76, 77, 0x613a323a7b693a37303b613a323a7b693a303b733a393a224f66662d546f706963223b693a313b693a303b7d693a3136393b613a323a7b693a303b733a373a2246616e576f726b223b693a313b693a313b7d7d, 'FanFics', 0x506c61617473206869657220616c206a652046616e4669637321, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(171, 169, 78, 79, 0x613a323a7b693a37303b613a323a7b693a303b733a393a224f66662d546f706963223b693a313b693a303b7d693a3136393b613a323a7b693a303b733a373a2246616e576f726b223b693a313b693a313b7d7d, 'Designing', 0x506c61617473206869657220616c6c6573206f766572207a656c6667656d61616b74652044657369676e7321, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(173, 0, 84, 105, '', 'PokéPlace RPG', 0x5a6f647261206a652068696572206b6c696b74206b6f6d206a65206f7020646520506f6b65506c616365205250472e2048696572206b756e206a6520647573206f6f6b206f6e7a6520525047207370656c656e2c20656e206a652076726167656e2065726f766572207374656c6c656e21, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(174, 173, 85, 92, '', 'RPG Index', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(175, 174, 86, 87, '', 'RPG Mededelingen', 0x56696e6474206869657220616c6c65206d6565646564656c696e67656e20646965206761616e206f766572206465205250472e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(176, 174, 88, 89, '', 'RPG Vragen & Ideeën', 0x506c61617473206869657220616c206a652076726167656e20656e2069646565c3ab6e206f766572206465205250472e, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(177, 174, 90, 91, '', 'Profielen', 0x4869657220616c6c652070726f6669656c656e2076616e20616c6c65207370656c65727321, '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(188, 187, 3, 4, 0x613a323a7b693a3133343b613a323a7b693a303b733a32363a225465616d20526174696e672026616d703b204275696c64696e67223b693a313b693a313b7d693a3138373b613a323a7b693a303b733a383a22416c67656d65656e223b693a313b693a303b7d7d, 'Pokemon Algemeen', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(189, 187, 7, 8, 0x613a323a7b693a3133343b613a323a7b693a303b733a32363a225465616d20526174696e672026616d703b204275696c64696e67223b693a313b693a313b7d693a3138373b613a323a7b693a303b733a383a22416c67656d65656e223b693a313b693a303b7d7d, 'Team Rating & Building', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(190, 187, 9, 10, 0x613a323a7b693a3133343b613a323a7b693a303b733a32363a225465616d20526174696e672026616d703b204275696c64696e67223b693a313b693a313b7d693a3138373b613a323a7b693a303b733a383a22416c67656d65656e223b693a313b693a303b7d7d, 'Poke Populatie Toernooi', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 50, 3, 3, 14756, 26, 'Re: De Website', 1244274730, 'Shadow Celebi', '339900', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(191, 187, 5, 6, 0x613a323a7b693a3133343b613a323a7b693a303b733a32363a225465616d20526174696e672026616d703b204275696c64696e67223b693a313b693a313b7d693a3138373b613a323a7b693a303b733a383a22416c67656d65656e223b693a313b693a303b7d7d, 'Films, Anime & Muziek', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(192, 187, 11, 12, 0x613a323a7b693a3133343b613a323a7b693a303b733a32363a225465616d20526174696e672026616d703b204275696c64696e67223b693a313b693a313b7d693a3138373b613a323a7b693a303b733a383a22416c67656d65656e223b693a313b693a303b7d7d, 'POTW', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),
(187, 0, 2, 13, '', 'Algemeen', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0);

Voor:

Code: Selecteer alles

 Table: phpbb_forums
DROP TABLE IF EXISTS phpbb_forums;
CREATE TABLE `phpbb_forums` (
  `forum_id` mediumint(8) unsigned NOT NULL auto_increment,
  `parent_id` mediumint(8) unsigned NOT NULL default '0',
  `left_id` mediumint(8) unsigned NOT NULL default '0',
  `right_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_parents` mediumtext collate utf8_bin NOT NULL,
  `forum_name` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_desc` text collate utf8_bin NOT NULL,
  `forum_desc_bitfield` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_desc_options` int(11) unsigned NOT NULL default '7',
  `forum_desc_uid` varchar(8) collate utf8_bin NOT NULL default '',
  `forum_link` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_password` varchar(40) collate utf8_bin NOT NULL default '',
  `forum_style` smallint(4) unsigned NOT NULL default '0',
  `forum_image` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_rules` text collate utf8_bin NOT NULL,
  `forum_rules_link` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_rules_bitfield` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_rules_options` int(11) unsigned NOT NULL default '7',
  `forum_rules_uid` varchar(8) collate utf8_bin NOT NULL default '',
  `forum_topics_per_page` tinyint(4) NOT NULL default '0',
  `forum_type` tinyint(4) NOT NULL default '0',
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics_real` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_poster_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_subject` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_last_post_time` int(11) unsigned NOT NULL default '0',
  `forum_last_poster_name` varchar(255) collate utf8_bin NOT NULL default '',
  `forum_last_poster_colour` varchar(6) collate utf8_bin NOT NULL default '',
  `forum_flags` tinyint(4) NOT NULL default '32',
  `display_on_index` tinyint(1) unsigned NOT NULL default '1',
  `enable_indexing` tinyint(1) unsigned NOT NULL default '1',
  `enable_icons` tinyint(1) unsigned NOT NULL default '1',
  `enable_prune` tinyint(1) unsigned NOT NULL default '0',
  `prune_next` int(11) unsigned NOT NULL default '0',
  `prune_days` mediumint(8) unsigned NOT NULL default '0',
  `prune_viewed` mediumint(8) unsigned NOT NULL default '0',
  `prune_freq` mediumint(8) unsigned NOT NULL default '0',
  `forum_post_tpl` text collate utf8_bin,
  `display_subforum_list` tinyint(1) unsigned NOT NULL default '1',
  `forum_topic_tags` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`forum_id`),
  KEY `left_right_id` (`left_id`,`right_id`),
  KEY `forum_lastpost_id` (`forum_last_post_id`)
) ENGINE=MyISAM AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO phpbb_forums (forum_id, parent_id, left_id, right_id, forum_parents, forum_name, forum_desc, forum_desc_bitfield, forum_desc_options, forum_desc_uid, forum_link, forum_password, forum_style, forum_image, forum_rules, forum_rules_link, forum_rules_bitfield, forum_rules_options, forum_rules_uid, forum_topics_per_page, forum_type, forum_status, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_last_poster_colour, forum_flags, display_on_index, enable_indexing, enable_icons, enable_prune, prune_next, prune_days, prune_viewed, prune_freq, forum_post_tpl, display_subforum_list, forum_topic_tags) VALUES (65, 0, 1, 10, '', 'PokéPlace Index', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 6, 1, 1, 7926, 6, 'Re: karel art', 1208033810, 'Mismagius', '6699CC', 32, 1, 1, 1, 0, 0, 0, 0, 0, NULL, 1, 0),(67, 0, 23, 48, '', 'Pokemon Games', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 1, 1, 0, 0, 0, 0, 0, '', 1, 0),(70, 0, 65, 78, '', 'Overig', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 1, 1, 1, 0, 0, 0, 0, 0, '', 1, 0),(71, 33, 71, 72, 'a:2:{i:70;a:2:{i:0;s:6:\"Overig\";i:1;i:0;}i:33;a:2:{i:0;s:23:\"Offtopic & Spamming\";i:1;i:1;}}', 'Media', 'Praat hier over alles dat met de media te maken heeft.\n(Televisie, Radio etc.)\n[b:149fjtdm]Word niet meegeteld voor je postcount.[/b:149fjtdm]', 'QA==', 7, '149fjtdm', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 255, 24, 24, 14203, 2, 'Re: Leukste progamma.', 1233762612, 'Splashing Mudkip', '0000CC', 32, 1, 1, 1, 0, 0, 0, 0, 0, '', 1, 0),(72, 0, 79, 88, '', 'Design', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, 'Re: karel art', 0, '', '', 32, 1, 1, 1, 0, 0, 0, 0, 0, '', 1, 0),(1, 65, 2, 5, 'a:1:{i:65;a:2:{i:0;s:16:\"PokéPlace Index\";i:1;i:0;}}', 'Mededelingen', 'Hier staan belangrijke meldingen m.b.t. de PokéPlace forums', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 44, 5, 5, 14569, 2, 'Re: Website Team', 1242572685, 'Splashing Mudkip', '0000CC', 34, 1, 1, 1, 0, 0, 0, 0, 0, '', 1, 1),(44, 65, 6, 7, 'a:1:{i:65;a:2:{i:0;s:16:\"PokéPlace Index\";i:1;i:0;}}', 'Feedback', 'Heb je een tip, suggestie klacht of wat dan ook, hier mag je het neerzetten!', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 49, 3, 3, 14453, 2, 'Re: De Website', 1242158731, 'Splashing Mudkip', '0000CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(41, 0, 9, 22, '', 'Pokemon Algemeen', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, 'Re: ken jij de 1e 151?', 0, '', '', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(141, 154, 11, 12, 'a:2:{i:41;a:2:{i:0;s:16:\"Pokemon Algemeen\";i:1;i:0;}i:154;a:2:{i:0;s:16:\"Pokemon algemeen\";i:1;i:1;}}', 'Pokemon Media', 'Praat hier over Pokemon Afleveringen, Films, de Personages, de Muziek en ga zo maar door!', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 252, 19, 19, 14449, 183, 'Re: Wedstrijden - Coordinators.', 1242151333, 'Rotom', '6699CC', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(4, 51, 39, 40, '', 'Pokemon Red/Blue/Yellow', 'Praat hier over de Kanto regio, 1e generatie', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 27, 4, 4, 12412, 183, 'Re: challange', 1223828351, 'Rotom', '6699CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(5, 51, 41, 42, '', 'Pokemon Gold/Silver/Crystal', 'Praat hier over de Johto regio, 2e generatie', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 24, 4, 4, 8373, 51, 'Re: Mening', 1208788976, 'Jarno', '6699CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(6, 67, 34, 35, 'a:1:{i:67;a:2:{i:0;s:13:\"Pokemon Games\";i:1;i:0;}}', 'Pokemon Ruby/Sapphire/Emerald', 'Praat hier over de Hoenn regio, 3e generatie', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 89, 11, 11, 14457, 7, 'Vragen topic', 1242209964, 'ShadowLoom', '0000CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(11, 41, 16, 17, 'a:1:{i:41;a:2:{i:0;s:16:\"Pokemon Algemeen\";i:1;i:0;}}', 'Pokemon of the Week', 'Elke week een neiuwe Poll, om jouw favo poke te bepalen!', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 7, 1, 1, 14568, 179, 'Re: Pokemon of the Week #1', 1242570292, 'Tim', '339900', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(51, 67, 38, 47, 'a:1:{i:67;a:2:{i:0;s:13:\"Pokemon Games\";i:1;i:0;}}', 'Andere Pokemon Games', 'Praat hier over alle oudere pokemon games, of de de games waar geen board voor is.', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 20, 3, 3, 14489, 179, 'Re: GOLD & SILVER REMAKES!', 1242309680, 'Tim', '339900', 34, 0, 1, 0, 0, 0, 0, 0, 0, '', 0, 0),(33, 70, 70, 73, 'a:1:{i:70;a:2:{i:0;s:6:\"Overig\";i:1;i:0;}}', 'Offtopic & Spamming', 'Alles wat nergens anders kan, kan hier, ook als je ff lekker spammen wilt!\n[b:19ihz95b]Word niet meegeteld voor je postcount.[/b:19ihz95b]', 'QA==', 7, '19ihz95b', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 320, 10, 10, 14636, 2, 'Re: Spamtopic!', 1242758143, 'Splashing Mudkip', '0000CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(13, 70, 74, 75, 'a:1:{i:70;a:2:{i:0;s:6:\"Overig\";i:1;i:0;}}', 'Forum Games', 'Ken jij een spel dat je spelen kan via het forum? Zet hem dan hier!\n[b:65aogg02]Word niet meegeteld voor je postcount.[/b:65aogg02]', 'QA==', 7, '65aogg02', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 2825, 22, 22, 14633, 7, 'Re: Raad de persoon onder jou', 1242755130, 'ShadowLoom', '0000CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(15, 70, 74, 77, 'a:1:{i:70;a:2:{i:0;s:6:\"Overig\";i:1;i:0;}}', 'Reclame', 'Als je aan onze reclame regels voldoet, mag je hier voor je eigen site/forum reclame maken.', '', 7, '', '', '', 0, '', 'Lees voor je reclame maken gaat, even het PokéPlace Regelement. Deze vind je in Mededelingen.', '', '', 7, '', 0, 1, 0, 3, 2, 2, 14402, 2, 'Re: Linkpartners', 1241793097, 'Splashing Mudkip', '0000CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(154, 41, 10, 15, 'a:1:{i:41;a:2:{i:0;s:16:\"Pokemon Algemeen\";i:1;i:0;}}', 'Pokemon algemeen', 'Allles over pokemon wat niet in een van de andere boards past kan hier!', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 20, 7, 7, 14552, 7, 'Re: Pkmn die een aanval had moeten leren?', 1242555006, 'ShadowLoom', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(29, 72, 80, 81, 'a:1:{i:72;a:2:{i:0;s:6:\"Design\";i:1;i:0;}}', 'Fan Fic', 'Post hier je zelfgemaakte verhalen etc.', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 296, 29, 29, 14623, 10, 'Re: 3 woorden verhaal', 1242746665, 'mew vanger', '6699CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(30, 72, 82, 83, 'a:1:{i:72;a:2:{i:0;s:6:\"Design\";i:1;i:0;}}', 'Design aanvraag', 'Wil je een avatar en signature? Laat het hier maken', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 125, 18, 18, 14211, 26, 'Nog een anvraagje!', 1234029074, 'Shadow Celebi', '339900', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(40, 72, 86, 87, 'a:1:{i:72;a:2:{i:0;s:6:\"Design\";i:1;i:0;}}', 'Design vragen en tutorials', 'Hier mag je je vragen stellen over design, en ook je tutorials neerzetten.', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 128, 19, 19, 14158, 14, 'Re: Simpele Signature Tut voor beginners', 1233426592, 'Flydoom', '0000CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(46, 72, 84, 85, 'a:1:{i:72;a:2:{i:0;s:6:\"Design\";i:1;i:0;}}', 'Design Show-off', 'Laat hier je werk zien, (wat niet op aanvraag is)', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 380, 38, 38, 14040, 26, 'Re: Mijn Recolor/Fakemon zooi', 1230026404, 'Shadow Celebi', '339900', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(156, 67, 24, 25, 'a:1:{i:67;a:2:{i:0;s:13:\"Pokemon Games\";i:1;i:0;}}', 'Pokemon Soul Silver & Heart Gold', 'De remakes van Pokemon Silver en Gold, ook deze 2 games komen er dan eindelijk aan, kom hier alles als eerste te weten!', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 28, 4, 4, 14608, 2, 'Re: Dream Team', 1242709746, 'Splashing Mudkip', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(8, 51, 43, 44, '', 'Pokemon Leaf Green/Fire Red', 'Praat hier over de remakes van Pokemon Red en Blue', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 18, 2, 2, 14201, 7, 'Re: echt zoveel beter of gewoon de wil naar meer geld?', 1233762154, 'ShadowLoom', '0000CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(9, 67, 36, 37, 'a:1:{i:67;a:2:{i:0;s:13:\"Pokemon Games\";i:1;i:0;}}', 'Pokemon Mystery Dungeon Red & Blue', 'Praat hier over Mystery Dungeon Red en Blue', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 163, 12, 12, 14458, 7, 'Vragen topic', 1242209985, 'ShadowLoom', '0000CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(10, 51, 45, 46, '', 'Pokemon Ranger', 'Praat hier over de Pokemon Ranger avonturen in de regio Fiore.', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 10, 2, 2, 12413, 183, 'Re: Het moeilijkste', 1223828410, 'Rotom', '6699CC', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(143, 15, 75, 76, '', 'GameBeach', 'Een goed, beginnende site met  forum met alles over Games, een bezoekje waard dus!', '', 7, '', 'http://gamebeach.nl/', '', 0, '', '', '', '', 7, '', 0, 2, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(23, 70, 66, 67, 'a:1:{i:70;a:2:{i:0;s:6:\"Overig\";i:1;i:0;}}', 'Newbie Lounge', 'Als je net nieuw bent hier, zou het leuk zijn als je jezelf hier voorsteld.', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 553, 63, 63, 14363, 26, 'Re: Justin hoi', 1237102570, 'Shadow Celebi', '339900', 34, 1, 1, 0, 0, 0, 0, 0, 0, '', 1, 0),(142, 154, 13, 14, 'a:2:{i:41;a:2:{i:0;s:16:\"Pokemon Algemeen\";i:1;i:0;}i:154;a:2:{i:0;s:16:\"Pokemon algemeen\";i:1;i:1;}}', 'Pokemon Sparen', 'Plaats hier alles dat met sparen te maken heeft, bijvoorbeeld over de kaarten of flippo\'s, heb jij ze enog?', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 12, 2, 2, 14235, 183, 'Re: Flippo\'s', 1234116767, 'Rotom', '6699CC', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(107, 41, 18, 19, 'a:1:{i:41;a:2:{i:0;s:16:\"Pokemon Algemeen\";i:1;i:0;}}', 'Poke-populatie toernooi', 'Stem hier op jou favoriet en laat je favoriete pokemon hier winnen!', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 455, 69, 69, 14473, 183, 'Re: Umbreon VS Glaceon', 1242231897, 'Rotom', '6699CC', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(104, 0, 89, 92, '', 'Admins en Moderators', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, NULL, 1, 0),(105, 104, 90, 91, 'a:1:{i:104;a:2:{i:0;s:20:\"Admins en Moderators\";i:1;i:0;}}', 'Crew Room', 'Hier word alles besproken binnen alle crew leden', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 34, 6, 6, 14408, 7, 'Re: We zijn erweer', 1241967729, 'ShadowLoom', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(155, 0, 93, 94, '', 'website', 'Mathew Edison - Splashing Mudkip - ShadowLugia', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 2, 1, 1, 14419, 7, 'Re: Website hoe verder', 1241971254, 'ShadowLoom', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(117, 147, 54, 63, 'a:1:{i:147;a:2:{i:0;s:10:\"Game Stuff\";i:1;i:0;}}', 'Rom Editing', 'Bespreek hier alles over Rom Editing', '', 7, '', '', '', 0, '', 'Alleen in Rom Hacking mag er over Roms gepraat worden, nergens anders!', '', '', 7, '', 0, 1, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(118, 117, 55, 56, 'a:2:{i:147;a:2:{i:0;s:10:\"Game Stuff\";i:1;i:0;}i:117;a:2:{i:0;s:11:\"Rom Editing\";i:1;i:1;}}', 'Roms & Tools', 'Hier kan je roms en andere rom downloads vinden.', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 25, 2, 2, 13980, 6, 'Re: Myuu Officiele Toolbox.', 1229257885, 'Mismagius', '6699CC', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(139, 67, 26, 27, 'a:1:{i:67;a:2:{i:0;s:13:\"Pokemon Games\";i:1;i:0;}}', 'Mystery Dungeon Time & Darkness', 'Praat hier over de 2e Pokemon Mystery Dungeon', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 24, 6, 6, 14456, 7, 'Vragen topic', 1242209940, 'ShadowLoom', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(140, 67, 28, 29, 'a:1:{i:67;a:2:{i:0;s:13:\"Pokemon Games\";i:1;i:0;}}', 'Pokemon Ranger 2: Shadows of Almia', 'Bespreek hier alles over Pokemon Ranger 2; shadows of Almia\n[b:2l3oa62g]21-11-08 Uitgekomen (officieel)[/b:2l3oa62g]', 'QA==', 7, '2l3oa62g', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 19, 5, 5, 14225, 26, 'Re: Maatje =D', 1234084818, 'Shadow Celebi', '339900', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(119, 117, 57, 60, 'a:2:{i:147;a:2:{i:0;s:10:\"Game Stuff\";i:1;i:0;}i:117;a:2:{i:0;s:11:\"Rom Editing\";i:1;i:1;}}', 'Hulp', 'Hier kan je hulp vragen mbt Rom Hacking.', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 6, 2, 2, 13859, 6, 'Re: #hack hulpzone topic #1', 1228332958, 'Mismagius', '6699CC', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(120, 117, 61, 62, 'a:2:{i:147;a:2:{i:0;s:10:\"Game Stuff\";i:1;i:0;}i:117;a:2:{i:0;s:11:\"Rom Editing\";i:1;i:1;}}', 'Show', 'show hier je eigen roms.', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 39, 5, 5, 13149, 7, 'Re: [Hack] Bad Distiny', 1226145533, 'ShadowLoom', '0000CC', 32, 1, 1, 0, 0, 1208780452, 7, 7, 1, '[b]Titel:[/b]\n[b]Gehackt van:[/b]\n[b]Verhaal:[/b]\n[b]Starters:[/b]\n[b]Media:[/b]\n[b]Nieuwtjes:[/b]\n[b]Credits:[/b]\n[b]Beta\'s:[/b]\n[b]Download Link[/b]', 1, 0),(121, 119, 58, 59, '', 'Tutorials', 'Hier kan je tutorials vinden, je mag natuurlijk ook tuts plaatsen.', '', 5, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 11, 3, 3, 13917, 6, 'Re: Unlz gba nummers voor Emerald. part 1', 1228828924, 'Mismagius', '6699CC', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(145, 138, 31, 32, 'a:2:{i:67;a:2:{i:0;s:13:\"Pokemon Games\";i:1;i:0;}i:138;a:2:{i:0;s:37:\"Pokemon Pearl, Diamond & Platinum\";i:1;i:1;}}', 'Wi-Fi', 'Zet hier alles neer wat Wi-FI betreft, ruilen, vechten en nog veel meer!', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 56, 6, 6, 14618, 7, 'Re: Random Toernooi', 1242743102, 'ShadowLoom', '0000CC', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(138, 67, 30, 33, 'a:1:{i:67;a:2:{i:0;s:13:\"Pokemon Games\";i:1;i:0;}}', 'Pokemon Pearl, Diamond & Platinum', 'Praat hier over de Pokemon Games van de Sinnoh Regio! \n[b:1f6njcv6]Platinum release: 22 Mei 2009[/b:1f6njcv6]', 'QA==', 7, '1f6njcv6', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 136, 22, 22, 14610, 2, 'Platinum Trailer', 1242711335, 'Splashing Mudkip', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(152, 65, 8, 9, 'a:1:{i:65;a:2:{i:0;s:16:\"PokéPlace Index\";i:1;i:0;}}', 'Het Magazine', 'Elke maand is hier ene nieuw magazine te vinden! snel kijken dus. <!-- s;) --><img src=\"{SMILIES_PATH}/icon_49 (68).gif\" alt=\";)\" title=\"Wink\" /><!-- s;) -->', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 38, 6, 6, 14136, 2, 'Re: Magazine 240109', 1233001036, 'Splashing Mudkip', '0000CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(153, 1, 3, 4, 'a:2:{i:65;a:2:{i:0;s:16:\"PokéPlace Index\";i:1;i:0;}i:1;a:2:{i:0;s:12:\"Mededelingen\";i:1;i:1;}}', 'Styling Team overleg + Artikelen', 'Hier kan het Styling Team overleggen, ook worden hier de artikelen geplaats zodat ze nagekeken kunnen worden en geplaatst kunnen worden.', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 43, 11, 11, 14625, 177, 'Re: Artikel af?', 1242752449, 'Niels', 'FF9900', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(134, 41, 20, 21, 'a:1:{i:41;a:2:{i:0;s:16:\"Pokemon Algemeen\";i:1;i:0;}}', 'Team Rating & Building', 'Voor al je tips ove rje team, of het laten raten van je team, hier kan het!', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 23, 5, 5, 14443, 10, 'Mijn platinum team (word updated)', 1242143240, 'mew vanger', '6699CC', 32, 1, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(137, 70, 68, 69, 'a:1:{i:70;a:2:{i:0;s:6:\"Overig\";i:1;i:0;}}', 'Discussie Center', 'Heb je een goede discussie? Plaats hem dna hier en dan kunnen we lekker discusieren!', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 146, 12, 12, 14590, 201, 'Re: Mensen zonder geld...', 1242629641, 'Folkert', '6699CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(147, 0, 49, 64, '', 'Game Stuff', '', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', '', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(148, 147, 50, 51, 'a:1:{i:147;a:2:{i:0;s:10:\"Game Stuff\";i:1;i:0;}}', 'Game Discussie', 'Hier kun je discussieren over alle games buiten pokemon om. Ook kun je praten over de benodigdheden zoals de accesoires en consoles.', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 106, 14, 14, 14452, 19, 'Re: MapleStory', 1242156886, 'TiliX', '6699CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0),(149, 147, 52, 53, 'a:1:{i:147;a:2:{i:0;s:10:\"Game Stuff\";i:1;i:0;}}', 'Game Informatie', 'Plaats hier alle game info zoals Reviews, Previews, Walktroughs en Tips en Tricks.', '', 7, '', '', '', 0, '', '', '', '', 7, '', 0, 1, 0, 64, 10, 10, 14592, 201, '[PC] World of Goo review', 1242631163, 'Folkert', '6699CC', 32, 0, 1, 0, 0, 0, 7, 7, 1, '', 1, 0);

Hoop dat dit is wta jje bedoeld.

Bevo · Bericht door **Bevo** » 08 jul 2009, 18:53

Dat is niet echt wat hij bedoelde. Je moet je code-dumb hier plaatsen:
http://www.phpbb.nl/hulpmiddelen/code_dump

Erik Frèrejean · Bericht door **Erik Frèrejean** » 08 jul 2009, 19:04

@Splashing Mudkip
Zie eens wat er gebeurt als je het volgende script, opslaat als fix.php, upload naar de root van je phpbb installatie en hem dan aanroept via je browser (niet vergeten te verwijderen achteraf!)
http://www.paulscripts.nl/fix.phps

Bevo schreef:Dat is niet echt wat hij bedoelde. Je moet je code-dumb hier plaatsen:
http://www.phpbb.nl/hulpmiddelen/code_dump

Nee hoor *moet* niet. Binnen code tags in het forum is ook goed

.

Bevo · Bericht door **Bevo** » 08 jul 2009, 19:12

Bevo schreef:Dat is niet echt wat hij bedoelde. Je moet je code-dumb hier plaatsen:
http://www.phpbb.nl/hulpmiddelen/code_dump
Nee hoor *moet* niet. Binnen code tags in het forum is ook goed .

Ah, ok. Zal ik onthouden als ik ooit ook eens een code dumb moet plaatsen.

Erik Frèrejean · Bericht door **Erik Frèrejean** » 08 jul 2009, 19:15

Voor het dumpen van grote stukken code is de code dump mogelijk een betere plaats, maar dat is aan je eigen interpertatie

.

Dmeijer13 · Bericht door **Dmeijer13** » 08 jul 2009, 19:32

Erik Frèrejean schreef:@Splashing Mudkip
Zie eens wat er gebeurt als je het volgende script, opslaat als fix.php, upload naar de root van je phpbb installatie en hem dan aanroept via je browser (niet vergeten te verwijderen achteraf!)
http://www.paulscripts.nl/fix.phps

Hatstikke bedankt, mijn problemen zijn opgelost zo te zien, en het werkt zo te zien nogmaals bedankt! =)

Binary Tree kapot

Binary Tree kapot

Re: forums...

Re: forums...

Re: forums...

Re: forums...

Re: Binary tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot

Re: Binary Tree kapot