aide Problème CMS

[Dimitriiii 2]

Bonjour, j'ai un problème, je m'explique, quand je crée un joueur, l'id se met automatiquement à 0, comment faire pour que les ID se suivent ? Merci à ceux qui m'aideront!  

[Monde 69]

Il faut mettre L'AUTO INCREMENT

[Dimitriiii 2]

Hmm, avec ce code ça marche pas  

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(125) CHARACTER SET latin1 NOT NULL,
  `password` varchar(255) CHARACTER SET latin1 NOT NULL,
  `auth_ticket` varchar(60) CHARACTER SET latin1 NOT NULL,
  `rank` int(11) UNSIGNED NOT NULL DEFAULT '1',
  `vip_points` int(11) NOT NULL DEFAULT '30',
  `credits` int(11) NOT NULL DEFAULT '0',
  `activity_points` int(11) NOT NULL DEFAULT '0',
  `look` varchar(160) CHARACTER SET latin1 NOT NULL DEFAULT 'sh-290-1222.hr-100-1045.hd-180-1.ch-210-1201.lg-275-97',
  `gender` enum('M','F') CHARACTER SET latin1 NOT NULL DEFAULT 'M',
  `motto` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `mail` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT 'undefined',
  `account_created` double(50,0) NOT NULL DEFAULT '0',
  `last_online` int(11) NOT NULL DEFAULT '0',
  `online` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `ip_last` varchar(120) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `ip_reg` varchar(120) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `home_room` int(10) UNSIGNED DEFAULT '674',
  `newbie_status` int(11) NOT NULL DEFAULT '1',
  `is_muted` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `mutant_penalty` enum('0','1','2') CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
  `trade_lock` enum('0','1') NOT NULL DEFAULT '0',
  `trade_lock_expire` int(11) NOT NULL DEFAULT '0',
  `block_newfriends` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `hide_online` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `hide_inroom` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `vip` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `vip_expire` timestamp NOT NULL DEFAULT '2014-05-13 12:29:36',
  `birth` varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT '',
  `last_name_change` int(11) NOT NULL DEFAULT '0',
  `client_volume` varchar(255) NOT NULL DEFAULT '100,100,100',
  `nux_passed` enum('0','1') NOT NULL DEFAULT '0',
  `fundom` varchar(255) NOT NULL DEFAULT '#43AC6A',
  `facebook_id` varchar(50) DEFAULT NULL,
  `facebook_mail` varchar(255) DEFAULT NULL,
  `facebook_name` varchar(255) DEFAULT NULL,
  `pin` varchar(50) DEFAULT '0000',
  `client_pin` varchar(255) NOT NULL DEFAULT '1212',
  `facebook_change` varchar(50) DEFAULT '0',
  `facebook` enum('0','1') DEFAULT '0',
  `country_cf` varchar(50) DEFAULT 'US',
  `refer_count` varchar(50) DEFAULT '0',
  `radio` varchar(255) NOT NULL DEFAULT 'autoplay',
  `change_name` int(1) NOT NULL DEFAULT '0',
  `home_active` enum('0','1','2') NOT NULL DEFAULT '1',
  `home_active_security` enum('0','1','2') NOT NULL DEFAULT '1',
  `home_active_badges` enum('0','1') NOT NULL DEFAULT '1',
  `home_active_rooms` enum('0','1') NOT NULL DEFAULT '1',
  `home_active_friends` enum('0','1') NOT NULL DEFAULT '1',
  `home_active_fb` varchar(500) NOT NULL,
  `home_active_twitter` varchar(500) NOT NULL,
  `home_active_instagram` varchar(500) NOT NULL,
  `home_active_redes` enum('0','1','2') NOT NULL DEFAULT '1',
  `home_active_diamonds` enum('0','1','2') NOT NULL DEFAULT '1',
  `home_active_duckets` enum('0','1','2') NOT NULL DEFAULT '1',
  `home_active_gotw` enum('0','1','2') NOT NULL DEFAULT '1',
  `home_active_color` varchar(500) NOT NULL DEFAULT '#e6c873',
  `home_active_colorc` varchar(500) NOT NULL DEFAULT '#806f40',
  `allow_pull` enum('0','1') NOT NULL DEFAULT '0',
  `country` varchar(255) NOT NULL DEFAULT 'Unknown',
  `rank_vip` int(1) DEFAULT '3',
  `volume` varchar(15) NOT NULL DEFAULT '100,100,100',
  `last_change` int(20) NOT NULL DEFAULT '0',
  `machine_id` varchar(125) CHARACTER SET latin1 DEFAULT NULL,
  `focus_preference` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
  `chat_preference` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
  `pets_muted` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
  `bots_muted` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
  `advertising_report_blocked` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
  `gotw_points` int(11) DEFAULT '0',
  `ignore_invites` enum('0','1') CHARACTER SET latin1 DEFAULT '0',
  `time_muted` double DEFAULT '0',
  `allow_gifts` enum('0','1') CHARACTER SET latin1 DEFAULT '1',
  `trading_locked` double DEFAULT '0',
  `friend_bar_state` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '1',
  `disable_forced_effects` enum('0','1') CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `allow_mimic` enum('1','0') CHARACTER SET latin1 NOT NULL DEFAULT '1',
  `cms_signature` text,
  `forum_color` varchar(6) NOT NULL DEFAULT '666666',
  `cms_currency` int(99) NOT NULL,
  `bot_frank` varchar(500) NOT NULL DEFAULT '0',
  `nux_user` enum('true','false') NOT NULL DEFAULT 'true',
  `is_nuevo` enum('0','1') NOT NULL DEFAULT '0',
  `name_color` varchar(666) NOT NULL,
  `prefix_name` varchar(666) NOT NULL,
  `prefix_name_color` varchar(699) NOT NULL,
  `bubble_color` varchar(666) NOT NULL,
  `bubble_id` int(11) NOT NULL DEFAULT '0',
  `publi` enum('0','1','2','3') NOT NULL DEFAULT '0',
  `guia` enum('0','1','2','3','4') NOT NULL DEFAULT '0',
  `builder` enum('0','1') NOT NULL,
  `croupier` enum('1','0') NOT NULL DEFAULT '0',
  `user_points` int(99) NOT NULL DEFAULT '0',
  `pumpkins` int(11) NOT NULL DEFAULT '0',
  `talent_status` enum('citizenship','helper') NOT NULL DEFAULT 'citizenship',
  `staff_ocult` enum('0','1') NOT NULL DEFAULT '0',
  `work` text NOT NULL,
  `targeted_buy` int(11) NOT NULL DEFAULT '0',
  `frank_gift_count` int(11) NOT NULL DEFAULT '0',
  `bonus_points` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=119 ;

 

[Dimitriiii 2]

Problème résolu, il suffisait de mettre en première key et de le mettre en auto incrément (sur Navicat)

[Nagasaki 117]

Salut,

 

Ton sujet qui se trouvait dans Divers Habbo > Aides et support, a été déplacé dans Aides et support > Divers Habbo > Résolu.

 

Ceci est un message automatique.