tabela sqls

3 participantes

GabrielHB GabrielHB  • Seg 13 Abr 2015 - 12:36

tabela sqls Empty tabela sqls Seg 13 Abr 2015 - 12:36

O que deseja: Tabela Ranks

Nome do que deseja: tabela sqls

Print do que deseja (Se possível): .

Onde viu O que deseja: .

Deve ser compativel com: NewCrypto

Se escolheu outros, especifique:

Comentários adicionais: Pffv me ajudem me mandando essas sqls Ranks e Ranks Permissions

Saigon Saigon  • Seg 13 Abr 2015 - 13:35

tabela sqls Empty Re: tabela sqls Seg 13 Abr 2015 - 13:35

Aqui esta:
SQL:

iMuriloD iMuriloD  • Seg 13 Abr 2015 - 14:29

tabela sqls Empty Re: tabela sqls Seg 13 Abr 2015 - 14:29

Phoenix:

Permissions_Ranks:
  `rank` int(1) unsigned NOT NULL,
  `cmd_update_permissions` enum('1','0') NOT NULL,
  `cmd_update_settings` enum('1','0') NOT NULL,
  `cmd_update_bots` enum('1','0') NOT NULL,
  `cmd_update_catalogue` enum('1','0') NOT NULL,
  `cmd_update_navigator` enum('1','0') NOT NULL,
  `cmd_update_items` enum('1','0') NOT NULL,
  `cmd_award` enum('1','0') NOT NULL,
  `cmd_coords` enum('1','0') NOT NULL,
  `cmd_override` enum('1','0') NOT NULL,
  `cmd_coins` enum('1','0') NOT NULL,
  `cmd_pixels` enum('1','0') NOT NULL,
  `cmd_ha` enum('1','0') NOT NULL,
  `cmd_hal` enum('1','0') NOT NULL,
  `cmd_freeze` enum('1','0') NOT NULL,
  `cmd_enable` enum('1','0') NOT NULL,
  `cmd_roommute` enum('1','0') NOT NULL,
  `cmd_setspeed` enum('1','0') NOT NULL,
  `cmd_masscredits` enum('1','0') NOT NULL,
  `cmd_globalcredits` enum('1','0') NOT NULL,
  `cmd_roombadge` enum('1','0') NOT NULL,
  `cmd_massbadge` enum('1','0') NOT NULL,
  `cmd_userinfo` enum('1','0') NOT NULL,
  `cmd_shutdown` enum('1','0') NOT NULL,
  `cmd_givebadge` enum('1','0') NOT NULL,
  `cmd_invisible` enum('1','0') NOT NULL,
  `cmd_ban` enum('1','0') NOT NULL,
  `cmd_superban` enum('1','0') NOT NULL,
  `cmd_roomkick` enum('1','0') NOT NULL,
  `cmd_roomalert` enum('1','0') NOT NULL,
  `cmd_mute` enum('1','0') NOT NULL,
  `cmd_unmute` enum('1','0') NOT NULL,
  `cmd_alert` enum('1','0') NOT NULL,
  `cmd_motd` enum('1','0') NOT NULL,
  `cmd_kick` enum('1','0') NOT NULL,
  `cmd_update_filter` enum('1','0') NOT NULL,
  `acc_anyroomrights` enum('1','0') NOT NULL,
  `acc_anyroomowner` enum('1','0') NOT NULL,
  `acc_supporttool` enum('1','0') NOT NULL,
  `acc_chatlogs` enum('1','0') NOT NULL,
  `acc_enter_fullrooms` enum('1','0') NOT NULL,
  `acc_enter_anyroom` enum('1','0') NOT NULL,
  `acc_restrictedrooms` enum('1','0') NOT NULL,
  `acc_unkickable` enum('1','0') NOT NULL,
  `acc_unbannable` enum('1','0') NOT NULL,
  `cmd_removebadge` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_summon` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_update_bans` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_masspixels` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_globalpixels` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_sa` enum('1','0') NOT NULL DEFAULT '0',
  `receive_sa` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_ipban` enum('1','0') NOT NULL DEFAULT '0',
  `floodtime` int(3) NOT NULL DEFAULT '30',
  `cmd_spull` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_disconnect` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_update_achievements` enum('1','0') NOT NULL DEFAULT '0',
  `ignore_friendsettings` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_update_texts` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_points` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_teleport` enum('1','0') NOT NULL DEFAULT '1',
  `cmd_masspoints` enum('1','0') NOT NULL DEFAULT '0',
  `cmd_globalpoints` enum('1','0') NOT NULL DEFAULT '0',
  PRIMARY KEY (`rank`),
  UNIQUE KEY `rank` (`rank`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcar la base de datos para la tabla `permissions_ranks`
--

INSERT INTO `permissions_ranks` (`rank`, `cmd_update_permissions`, `cmd_update_settings`, `cmd_update_bots`, `cmd_update_catalogue`, `cmd_update_navigator`, `cmd_update_items`, `cmd_award`, `cmd_coords`, `cmd_override`, `cmd_coins`, `cmd_pixels`, `cmd_ha`, `cmd_hal`, `cmd_freeze`, `cmd_enable`, `cmd_roommute`, `cmd_setspeed`, `cmd_masscredits`, `cmd_globalcredits`, `cmd_roombadge`, `cmd_massbadge`, `cmd_userinfo`, `cmd_shutdown`, `cmd_givebadge`, `cmd_invisible`, `cmd_ban`, `cmd_superban`, `cmd_roomkick`, `cmd_roomalert`, `cmd_mute`, `cmd_unmute`, `cmd_alert`, `cmd_motd`, `cmd_kick`, `cmd_update_filter`, `acc_anyroomrights`, `acc_anyroomowner`, `acc_supporttool`, `acc_chatlogs`, `acc_enter_fullrooms`, `acc_enter_anyroom`, `acc_restrictedrooms`, `acc_unkickable`, `acc_unbannable`, `cmd_removebadge`, `cmd_summon`, `cmd_update_bans`, `cmd_masspixels`, `cmd_globalpixels`, `cmd_sa`, `receive_sa`, `cmd_ipban`, `floodtime`, `cmd_spull`, `cmd_disconnect`, `cmd_update_achievements`, `ignore_friendsettings`, `cmd_update_texts`, `cmd_points`, `cmd_teleport`, `cmd_masspoints`, `cmd_globalpoints`) VALUES
(1, '0', '0', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 20, '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(2, '0', '0', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 15, '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(3, '0', '0', '1', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', 10, '0', '0', '0', '0', '0', '0', '0', '0', '0'),
(4, '0', '0', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', 10, '0', '0', '0', '0', '0', '0', '1', '0', '0'),
(5, '0', '0', '1', '0', '0', '0', '0', '1', '0', '0', '0', '1', '0', '0', '1', '1', '1', '0', '0', '0', '0', '1', '0', '0', '0', '1', '0', '1', '1', '1', '1', '1', '0', '1', '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0', 5, '0', '0', '0', '0', '0', '0', '1', '0', '0'),
(6, '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '0', '1', '0', '0', '1', '1', '1', '0', '0', '1', '0', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '0', '0', '0', '1', '0', 5, '0', '0', '1', '0', '0', '0', '1', '0', '0'),
(7, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '1', '0', '1', '1', 5, '0', '0', '1', '0', '0', '0', '1', '0', '0'),
(8, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', 1, '1', '1', '1', '0', '0', '0', '1', '0', '0'),
(9, '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', 1, '1', '1', '1', '1', '1', '1', '1', '1', '1');

&

Ranks:
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `badgeid` varchar(5) DEFAULT NULL,
  `Descripcion` varchar(50) NOT NULL DEFAULT 'Comentario aqui',
  `color` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Volcar la base de datos para la tabla `ranks`
--

INSERT INTO `ranks` (`id`, `name`, `badgeid`, `Descripcion`, `color`) VALUES
(1, 'User', 'BE1', '', ''),
(2, 'VIP', 'VIP', '', ''),
(3, 'Guias', 'BOT', 'Guias', 'Morado'),
(4, 'Linces', 'LLL', 'Linces', 'Morado'),
(5, 'Moderadores', 'HS1', 'Staff''s', 'Morado'),
(6,'Promotores de Evento', 'MOD', 'Moderadores', 'Morado'),
(7, 'Administradores', 'AD2', 'Managers', 'Morado'),
(8, 'Gerentes', 'ADM', 'Gerentes', 'Morado'),
(9, 'Web Masters', 'ADM', 'Dueños y Fundadores', 'Morado');


NEW CRYPTO

Ranks:
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `badgeid` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Volcar la base de datos para la tabla `ranks`
--

INSERT INTO `ranks` (`id`, `name`, `badgeid`) VALUES
(9, 'Owner', 'ADM'),
(8, 'CEO', 'ADM'),
(1, 'User', ''),
(2, 'Guide', 'BOT'),
(3, 'VIP', 'VIP'),
(4, 'Trial Mod', 'ADM'),
(5, 'Moderator', 'ADM'),
(6, 'Super Moderator', 'ADM'),
(7, 'Administrator', 'ADM'),
(10, 'Overrated Owner', 'ADM'),
(11, 'God', 'ADM');

New Crypto só usa ranks,permissions_ranks = phoenix !

CLICA EM CIMA DOS "ABRA" PARA ABRIR O CÓDIGO INTEIRO !

GabrielHB GabrielHB  • Ter 14 Abr 2015 - 10:41

tabela sqls Empty Re: tabela sqls Ter 14 Abr 2015 - 10:41

Qual o maior cargo desses ai ? E p God?
Permissões neste sub-fórum
Não podes responder a tópicos

BH Servers

Recomendamos a BH Servers com proteção DDOS gratuita em Cloud Server de alta performance. Entrega imediata.