[Dúvida] Comando de GM no WOW (COOLDOWN)

4 participantes

BGames :: Jogos :: World of Warcraft :: WoW | Dúvidas :: Dúvidas Arquivadas

[Dúvida] Comando de GM no WOW (COOLDOWN)Sáb 7 Fev 2015 - 2:06

Fala meus amigos, tudo bem?
Minha dúvida hoje é sobre como colocar aquele comando, que normalmente tem em server pirata, que fica com cooldown, castime e power infinitos, no meu wow! alguém sabe como posso fazer?

Os comandos que utilizo jogando em servidores piratas são:
.cheat cooldown on
.cheat casttime on
.cheat power on

Já vi na net e algumas pessoas mandam eu como ADM do server, colocar estes comandos acima, que o cooldown será infinito, porém nenhum dos comandos acima funciona no meu servidor. O comando que funciona é .cooldown+"nome da magia", mas ele não programa todas as magias de todos os personagens. Quero fazer para que todas as magias não tenham recarga, mesmo depois de usar as magias. Uso o core do trinity.

*Obs: nenhum comando com .CHEAT funciona no meu servidor!

Alguém sabe como adicionar cooldown, cast e "power" sem recarga no servidor?
Abraços

Re: [Dúvida] Comando de GM no WOW (COOLDOWN)Sáb 7 Fev 2015 - 11:33

Olá luannf
Esses comandos já vem por padrão, testei aqui e funcionou, qual a versão da sua TDB e a data do seu Core?

Re: [Dúvida] Comando de GM no WOW (COOLDOWN)Sáb 7 Fev 2015 - 12:18

Código:

[quote][size=12][ltr]-- Explicitly set the account-table to use INNODB-engine (to allow foreign keys and transactions)
ALTER TABLE account ENGINE=InnoDB;

-- Delete bad data from the DB before adding foreign keys
DELETE FROM `account_access` WHERE `id` NOT IN (SELECT `id` FROM `account`);

-- Need them first in case of re-execute due to foreign keys
DROP TABLE IF EXISTS `rbac_account_permissions`;
DROP TABLE IF EXISTS `rbac_account_roles`;
DROP TABLE IF EXISTS `rbac_account_groups`;
DROP TABLE IF EXISTS `rbac_role_permissions`;
DROP TABLE IF EXISTS `rbac_group_roles`;
DROP TABLE IF EXISTS `rbac_security_level_groups`;
DROP TABLE IF EXISTS `rbac_permissions`;
DROP TABLE IF EXISTS `rbac_roles`;
DROP TABLE IF EXISTS `rbac_groups`;

CREATE TABLE IF NOT EXISTS `rbac_groups` (
  `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Group id',
  `name` varchar(50) NOT NULL COMMENT 'Group name',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Group List';

CREATE TABLE IF NOT EXISTS `rbac_roles` (
  `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Role id',
  `name` varchar(50) NOT NULL COMMENT 'Role name',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Roles List';

CREATE TABLE IF NOT EXISTS `rbac_permissions` (
  `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Permission id',
  `name` varchar(100) NOT NULL COMMENT 'Permission name',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Permission List';

CREATE TABLE IF NOT EXISTS `rbac_group_roles` (
  `groupId` int(10) unsigned NOT NULL COMMENT 'group id',
  `roleId` int(10) unsigned NOT NULL COMMENT 'Role id',
  PRIMARY KEY (`groupId`, `roleId`),
  CONSTRAINT `fk__rbac_group_roles__rbac_roles`
    FOREIGN KEY (`roleId`) REFERENCES `rbac_roles`(`id`)
    ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `fk__rbac_group_roles__rbac_groups`
    FOREIGN KEY (`groupId`) REFERENCES `rbac_groups`(`id`)
    ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Group Role relation';

CREATE TABLE IF NOT EXISTS `rbac_role_permissions` (
  `roleId` int(10) unsigned NOT NULL COMMENT 'Role id',
  `permissionId` int(10) unsigned NOT NULL COMMENT 'Permission id',
  PRIMARY KEY (`roleId`, `permissionId`),
  CONSTRAINT `fk__role_permissions__rbac_roles`
    FOREIGN KEY (`roleId`) REFERENCES `rbac_roles`(`id`)
    ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `fk__role_permissions__rbac_permissions`
    FOREIGN KEY (`permissionId`) REFERENCES `rbac_permissions`(`id`)
    ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Role Permission relation';

CREATE TABLE IF NOT EXISTS `rbac_security_level_groups` (
  `secId` int(10) unsigned NOT NULL COMMENT 'Security Level id',
  `groupId` int(10) unsigned NOT NULL COMMENT 'group id',
  PRIMARY KEY (`secId`, `groupId`),
  CONSTRAINT `fk__rbac_security_level_groups__rbac_groups`
    FOREIGN KEY (`groupId`) REFERENCES `rbac_groups`(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Default groups to assign when an account is set gm level';

CREATE TABLE IF NOT EXISTS `rbac_account_groups` (
  `accountId` int(10) unsigned NOT NULL COMMENT 'Account id',
  `groupId` int(10) unsigned NOT NULL COMMENT 'Group id',
  `realmId` int(11) NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
  PRIMARY KEY (`accountId`, `groupId`, `realmId`),
  CONSTRAINT `fk__rbac_account_groups__account`
    FOREIGN KEY (`accountId`) REFERENCES `account`(`id`)
    ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `fk__rbac_account_groups__rbac_groups`
    FOREIGN KEY (`groupId`) REFERENCES `rbac_groups`(`id`)
    ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account-Group relation';

CREATE TABLE IF NOT EXISTS `rbac_account_roles` (
  `accountId` int(10) unsigned NOT NULL COMMENT 'Account id',
  `roleId` int(10) unsigned NOT NULL COMMENT 'Role id',
  `granted` tinyint(1) NOT NULL default 1 COMMENT 'Granted = 1, Denied = 0',
  `realmId` int(11) NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
  PRIMARY KEY (`accountId`, `roleId`, `realmId`),
  CONSTRAINT `fk__rbac_account_roles__account`
    FOREIGN KEY (`accountId`) REFERENCES `account`(`id`)
    ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `fk__rbac_account_roles__rbac_roles`
    FOREIGN KEY (`roleId`) REFERENCES `rbac_roles`(`id`)
    ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account-Role relation';

CREATE TABLE IF NOT EXISTS `rbac_account_permissions` (
  `accountId` int(10) unsigned NOT NULL COMMENT 'Account id',
  `permissionId` int(10) unsigned NOT NULL COMMENT 'Permission id',
  `granted` tinyint(1) NOT NULL default 1 COMMENT 'Granted = 1, Denied = 0',
  `realmId` int(11) NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
  PRIMARY KEY (`accountId`, `permissionId`, `realmId`),
  CONSTRAINT `fk__rbac_account_permissions__account`
    FOREIGN KEY (`accountId`) REFERENCES `account`(`id`)
    ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `fk__rbac_account_roles__rbac_permissions`
    FOREIGN KEY (`permissionId`) REFERENCES `rbac_permissions`(`id`)
    ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account-Permission relation';

DELETE FROM `rbac_permissions` WHERE `id` BETWEEN 1 AND 10;
INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
(1, 'Instant logout'),
(2, 'Skip Queue'),
(3, 'Join Normal Battleground'),
(4, 'Join Random Battleground'),
(5, 'Join Arenas'),
(6, 'Join Dungeon Finder'),
(7, 'Player Commands (Temporal till commands moved to rbac)'),
(8, 'Moderator Commands (Temporal till commands moved to rbac)'),
(9, 'GameMaster Commands (Temporal till commands moved to rbac)'),
(10, 'Administrator Commands (Temporal till commands moved to rbac)');

DELETE FROM `rbac_roles` WHERE `id` BETWEEN 1 AND 7;
INSERT INTO `rbac_roles` (`id`, `name`) VALUES
(1, 'Player Commands'),
(2, 'Moderator Commands'),
(3, 'GameMaster Commands'),
(4, 'Administrator Commands'),
(5, 'Quick Login/Logout'),
(6, 'Use Battleground/Arenas'),
(7, 'Use Dungeon Finder');

DELETE FROM `rbac_groups` WHERE `id` BETWEEN 1 AND 4;
INSERT INTO `rbac_groups` (`id`, `name`) VALUES
(1, 'Player'),
(2, 'Moderator'),
(3, 'GameMaster'),
(4, 'Administrator');

DELETE FROM `rbac_role_permissions` WHERE `roleId` BETWEEN 1 AND 7;
INSERT INTO `rbac_role_permissions` (`roleId`, `permissionId`) VALUES
(5, 1),
(5, 2),
(6, 3),
(6, 4),
(6, 5),
(7, 6),
(1, 7),
(2, 8),
(3, 9),
(4, 10);

DELETE FROM `rbac_group_roles` WHERE `groupId` BETWEEN 1 AND 4;
INSERT INTO `rbac_group_roles` (`groupId`, `roleId`) VALUES
(1, 1),
(1, 6),
(1, 7),
(2, 2),
(2, 5),
(3, 3),
(4, 4);

TRUNCATE `rbac_account_groups`;
INSERT INTO `rbac_account_groups` (`accountId`, `groupId`, `realmId`) SELECT `id`, 1, -1 FROM `account`; -- Add Player group to all accounts
INSERT INTO `rbac_account_groups` (`accountId`, `groupId`, `realmId`) SELECT `id`, 2, `RealmID` FROM `account_access` WHERE `gmlevel` > 0; -- Add Moderator group to all Moderator or higher GM level
INSERT INTO `rbac_account_groups` (`accountId`, `groupId`, `realmId`) SELECT `id`, 3, `RealmID` FROM `account_access` WHERE `gmlevel` > 1; -- Add GameMaster group to all GameMasters or higher GM level
INSERT INTO `rbac_account_groups` (`accountId`, `groupId`, `realmId`) SELECT `id`, 4, `RealmID` FROM `account_access` WHERE `gmlevel` > 2; -- Add Administrator group to all Administrators

TRUNCATE `rbac_security_level_groups`;
INSERT INTO `rbac_security_level_groups` (`secId`, `groupId`) VALUES
(0, 1),
(1, 1),
(1, 2),
(2, 1),
(2, 2),
(2, 3),
(3, 1),
(3, 2),
(3, 3),
(3, 4);[/ltr][/size][/quote]

Amigo Use Esse Script Para Regularizar Seu Rbac ,, Isso Funcionará Todos Command Foram Testado Na Core Destruction Reparck , Entre Outras ,, Use Na Detabase " Auth " Poderá Usa Navicat , SQLyog , etc...

Re: [Dúvida] Comando de GM no WOW (COOLDOWN)Sáb 7 Fev 2015 - 13:08

windownsserversbr,

Não sei o que sua resposta tem a ver com a dúvida do luannf.

Re: [Dúvida] Comando de GM no WOW (COOLDOWN)Sáb 7 Fev 2015 - 13:26

Obs: nenhum comando com .CHEAT funciona no meu servidor!

Alguém sabe como adicionar cooldown, cast e "power" sem recarga no servidor?
Abraços

Eu Apenas Disse Use Esse Script Eles Resetara Todos Command Para Todos Seus Levels De GameMaster >:D

Re: [Dúvida] Comando de GM no WOW (COOLDOWN)Seg 9 Fev 2015 - 14:00

Amigos eu uso o TrinityCore 9847, no local da DB "Auth" eu tenho o "Realmd".
Estou tentando colocar o comando, mais não consigo, dá um erro:

Código:

Error Code : 1064
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 '[quote][size=12][ltr]-- Explicitly set the account-table to use INNODB-engine (t' at line 1

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected, 1 warning(s))
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected)
Execution Time : 00:00:00:047
Transfer Time  : 00:00:00:016
Total Time     : 00:00:00:063

(0 row(s) affected)
Execution Time : 00:00:00:062
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:062

(0 row(s) affected)
Execution Time : 00:00:00:063
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:063

(0 row(s) affected)
Execution Time : 00:00:00:109
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:109

(0 row(s) affected)
Execution Time : 00:00:00:062
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:062

(0 row(s) affected)
Execution Time : 00:00:00:047
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:047

Error Code : 1005
Can't create table '.\realmd\rbac_account_groups.frm' (errno: 150)

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

Error Code : 1005
Can't create table '.\realmd\rbac_account_roles.frm' (errno: 150)

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

Error Code : 1005
Can't create table '.\realmd\rbac_account_permissions.frm' (errno: 150)

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(0 row(s) affected)
Execution Time : 00:00:00:031
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:031

(10 row(s) affected)
Execution Time : 00:00:00:016
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:016

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(7 row(s) affected)
Execution Time : 00:00:00:015
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:015

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:016
Total Time     : 00:00:00:016

(4 row(s) affected)
Execution Time : 00:00:00:016
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:016

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(10 row(s) affected)
Execution Time : 00:00:00:015
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:015

(0 row(s) affected)
Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(7 row(s) affected)
Execution Time : 00:00:00:016
Transfer Time  : 00:00:00:015
Total Time     : 00:00:00:031

Error Code : 1146
Table 'realmd.rbac_account_groups' doesn't exist

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

Error Code : 1146
Table 'realmd.rbac_account_groups' doesn't exist

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

Error Code : 1146
Table 'realmd.rbac_account_groups' doesn't exist

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

Error Code : 1146
Table 'realmd.rbac_account_groups' doesn't exist

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

Error Code : 1146
Table 'realmd.rbac_account_groups' doesn't exist

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

(1 row(s) affected)
Execution Time : 00:00:00:016
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:016

(10 row(s) affected)
Execution Time : 00:00:00:031
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:031

Error Code : 1064
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 '[/ltr][/size][/quote]' at line 1

Execution Time : 00:00:00:000
Transfer Time  : 00:00:00:000
Total Time     : 00:00:00:000

Bom acho que vou ter que atualizar meu repack mesmo, porque dessa forma está muito dificil! haha obrigado pela ajuda meus caros colegas!

Re: [Dúvida] Comando de GM no WOW (COOLDOWN)Seg 9 Fev 2015 - 18:11

Resolvido?

Re: [Dúvida] Comando de GM no WOW (COOLDOWN)Seg 9 Fev 2015 - 18:43

Sim! tenho outra dúvida mas vou criar outro tópico pra manter organizado. Obrigado pela atenção abraços!

Re: [Dúvida] Comando de GM no WOW (COOLDOWN)

Tópicos semelhantes

[Resolvido][Dúvida] icecrown cooldown
[Resolvido][Dúvida] Como tirar cooldown das raids
[Resolvido][Dúvida]Comando .st
[Resolvido][Dúvida]Comando de GM
[Resolvido][Dúvida] Comando .chat

Ir para:

Permissões neste sub-fórum

Não podes responder a tópicos

Fórum de Desenvolvimento de Jogos e Programação

[Dúvida] Comando de GM no WOW (COOLDOWN)

description [Dúvida] Comando de GM no WOW (COOLDOWN)Sáb 7 Fev 2015 - 2:06

descriptionRe: [Dúvida] Comando de GM no WOW (COOLDOWN)Sáb 7 Fev 2015 - 11:33

descriptionRe: [Dúvida] Comando de GM no WOW (COOLDOWN)Sáb 7 Fev 2015 - 12:18

descriptionRe: [Dúvida] Comando de GM no WOW (COOLDOWN)Sáb 7 Fev 2015 - 13:08

descriptionRe: [Dúvida] Comando de GM no WOW (COOLDOWN)Sáb 7 Fev 2015 - 13:26

descriptionRe: [Dúvida] Comando de GM no WOW (COOLDOWN)Seg 9 Fev 2015 - 14:00

descriptionRe: [Dúvida] Comando de GM no WOW (COOLDOWN)Seg 9 Fev 2015 - 18:11

descriptionRe: [Dúvida] Comando de GM no WOW (COOLDOWN)Seg 9 Fev 2015 - 18:43

descriptionRe: [Dúvida] Comando de GM no WOW (COOLDOWN)