Problème pour" monter/descendre" des forums (Galerie aussi)

ElenWii Membre non connecté

Le 29/05/2014 à 23h45

Il y a un blem dans la numérotation, (modelimse/annonce/mécanique)
J'ai refait les numéros d'ordre pour test et plus de bug :

Code SQL :

-- phpMyAdmin SQL Dump
-- version 4.1.12
-- http://www.phpmyadmin.net
--
-- Client :  sql8:3306
-- Généré le :  Jeu 29 Mai 2014 à 16:13
-- Version du serveur :  5.5.33a-MariaDB-1~squeeze
-- Version de PHP :  5.4.4-14+deb7u5
 
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
 
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
 
--
-- Base de données :  `passiontruck`
--
 
-- --------------------------------------------------------
 
--
-- Structure de la table `phpboost_forum_cats`
--
 
CREATE TABLE IF NOT EXISTS `phpboost_forum_cats` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `id_left` INT(11) NOT NULL DEFAULT '0',
  `id_right` INT(11) NOT NULL DEFAULT '0',
  `level` INT(11) NOT NULL DEFAULT '0',
  `name` VARCHAR(100) NOT NULL DEFAULT '',
  `subname` VARCHAR(150) NOT NULL DEFAULT '',
  `nbr_topic` mediumint(9) NOT NULL DEFAULT '0',
  `nbr_msg` mediumint(9) NOT NULL DEFAULT '0',
  `last_topic_id` INT(11) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `aprob` tinyint(1) NOT NULL DEFAULT '0',
  `auth` text,
  `url` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `last_topic_id` (`last_topic_id`),
  KEY `id_left` (`id_left`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=60 ;
 
--
-- Contenu de la table `phpboost_forum_cats`
--
 
INSERT INTO `phpboost_forum_cats` (`id`, `id_left`, `id_right`, `level`, `name`, `subname`, `nbr_topic`, `nbr_msg`, `last_topic_id`, `status`, `aprob`, `auth`, `url`) VALUES
(33, 1, 8, 0, 'Informations - Débats', '', 72, 772, 0, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(16, 2, 3, 1, 'Débâts sur les actualités', '', 71, 569, 694, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(22, 4, 5, 1, 'Informations diverses du site', '', 37, 447, 673, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(34, 6, 7, 1, 'Fiches des métiers', '', 4, 55, 289, 1, 1, 'a:2:{s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(1, 9, 26, 0, 'Domaine du camion', '', 248, 4356, 723, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:1;s:2:"r1";i:1;}', ''),
(8, 10, 11, 1, 'Autour du camion', '', 81, 1274, 494, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(15, 12, 13, 1, 'Permis - formations', '', 38, 863, 554, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(42, 14, 17, 1, 'Equipements', '', 19, 356, 680, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(43, 15, 16, 2, 'Annonces', '', 1, 1, 680, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(30, 18, 19, 1, 'Transporteurs - Emplois', '', 32, 415, 697, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(12, 20, 21, 1, 'Mécanique', '', 17, 205, 588, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(9, 22, 25, 1, 'Modélisme &amp; modélisme RC', '', 24, 439, 683, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(47, 23, 24, 2, 'Annonces', '', 1, 1, 683, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(3, 27, 40, 0, 'Discussions générales', 'Divers dicussions', 230, 5572, 680, 1, 1, 'a:4:{s:3:"r-1";i:1;s:2:"r0";i:1;s:2:"r1";i:1;i:1;i:1;}', ''),
(2, 28, 29, 1, 'Présentation des membres', '', 125, 1454, 700, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(59, 30, 31, 1, 'Localisation des membres', '', 0, 0, 0, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', 'http://planet-truck.fr/site/member/member.php'),
(38, 32, 33, 1, 'Carrière des membres', '', 22, 869, 367, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(6, 34, 35, 1, 'Bar du forum', '', 80, 1729, 699, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(7, 36, 37, 1, 'Jeux - Divertissements', '', 31, 2472, 475, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(17, 38, 39, 1, 'Partenariat', '', 1, 21, 507, 1, 1, 'a:4:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;i:1;i:3;}', ''),
(39, 41, 44, 0, 'Forum des formateurs', '', 0, 0, 592, 1, 1, 'a:2:{s:2:"r1";i:1;i:15;i:1;}', ''),
(40, 42, 43, 1, 'Informations - Débâts', '', 0, 0, 592, 1, 1, 'a:2:{s:2:"r1";i:7;i:15;i:3;}', ''),
(5, 45, 50, 0, 'Forum V.I.P.', 'Forum V.I.P. de notre site', 6, 86, 36, 1, 1, 'a:3:{s:2:"r0";i:2;s:2:"r1";i:7;i:1;i:1;}', ''),
(13, 46, 47, 1, 'Bar des V.I.P.', '', 5, 85, 36, 1, 1, 'a:1:{s:2:"r1";i:7;}', ''),
(14, 48, 49, 1, 'Vos dons', '', 1, 1, 152, 1, 1, 'a:1:{s:2:"r1";i:7;}', ''),
(4, 51, 56, 0, 'Support - Aide', 'Support et aide du site ou autres', 18, 262, 99, 1, 1, 'a:4:{s:3:"r-1";i:1;s:2:"r0";i:1;s:2:"r1";i:1;i:1;i:1;}', ''),
(10, 52, 53, 1, 'Support du site - Forum', '', 17, 236, 99, 1, 1, 'a:4:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;i:1;i:3;}', ''),
(21, 54, 55, 1, 'Impressions - Remarques (Membres)', '', 3, 31, 184, 1, 1, 'a:4:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;i:1;i:3;}', ''),
(41, 57, 60, 0, 'Corbeille', '', 0, -70, 183, 1, 1, 'a:3:{s:3:"r-1";i:1;s:2:"r0";i:3;s:2:"r1";i:7;}', ''),
(24, 58, 59, 1, 'Sujets fermés', '', 24, 304, 183, 1, 1, 'a:10:{s:3:"r-1";i:1;s:2:"r0";i:1;s:2:"r1";i:1;i:2;i:7;i:4;i:7;i:7;i:1;i:9;i:1;i:10;i:7;i:15;i:1;i:16;i:1;}', ''),
(23, 61, 68, 0, 'Webmasteurs -  Staff', '', 65, 749, 681, 1, 1, 'a:4:{i:4;i:1;i:9;i:1;i:10;i:1;i:12;i:1;}', ''),
(26, 62, 63, 1, 'Débats Staff  (Améliorations, sanctions..)', '', 38, 454, 681, 1, 1, 'a:6:{s:2:"r1";i:7;i:2;i:7;i:4;i:7;i:9;i:7;i:10;i:7;i:12;i:7;}', ''),
(35, 64, 65, 1, '[Régulateurs] - Formations écrites - Contact', '', 2, 10, 387, 1, 1, 'a:3:{i:4;i:7;i:10;i:7;i:14;i:3;}', ''),
(36, 66, 67, 1, '[Rédacteurs] - Formations écrites - Contact', '', 5, 20, 503, 1, 1, 'a:3:{i:9;i:3;i:10;i:7;i:13;i:3;}', '');
 
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;