Jump to content
Sign in to follow this  
XxAngelOFDethxX

[Partage] Commandes Icore via bdd

Recommended Posts

Bonjour 

 

J'ai vu que ya un manque de commandes Via la bdd 

 

j'ai régler le bug et aussi j'ai creer 33 new commandes a éxécuter dans la bdd

 

j'ai test sur mon serveur ca marche bien 

 

Merci de me contacter si vous trouver un bug/vous avez des problémes 

 

Voila le texte de commandes a éxécuter dans la console de votre bdd

 

SET FOREIGN_KEY_CHECKS=0;

 
-- ----------------------------
-- Table structure for `gmCommands` && Commands
-- ----------------------------
DROP TABLE IF EXISTS `gmcommands`;
CREATE TABLE `gmCommands` (
  `command` varchar(255) NOT NULL DEFAULT '',
  `gmlevel` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`command`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-- ----------------------------
-- Records of gmCommands
-- ----------------------------
INSERT INTO `gmCommands` VALUES ('ADDENDFIGHTACTION', '4');
INSERT INTO `gmCommands` VALUES ('ADDFIGHTPOS', '4');
INSERT INTO `gmCommands` VALUES ('ADDJOBXP', '2');
INSERT INTO `gmCommands` VALUES ('ADDMOUNTPARK', '4');
INSERT INTO `gmCommands` VALUES ('ADDNPC', '4');
INSERT INTO `gmCommands` VALUES ('ADDNPCITEM', '4');
INSERT INTO `gmCommands` VALUES ('ADDREPONSEACTION', '4');
INSERT INTO `gmCommands` VALUES ('ADDTRIGGER', '4');
INSERT INTO `gmCommands` VALUES ('ALLCADEAU', '4');
INSERT INTO `gmCommands` VALUES ('ANNOUNCE', '2');
INSERT INTO `gmCommands` VALUES ('ARENA', '4');
INSERT INTO `gmCommands` VALUES ('BAN', '2');
INSERT INTO `gmCommands` VALUES ('BANIP', '3');
INSERT INTO `gmCommands` VALUES ('BLOCK', '4');
INSERT INTO `gmCommands` VALUES ('CADEAU', '4');
INSERT INTO `gmCommands` VALUES ('CAPITAL', '3');
INSERT INTO `gmCommands` VALUES ('CREATEGUILD', '1');
INSERT INTO `gmCommands` VALUES ('DEBUG', '1');
INSERT INTO `gmCommands` VALUES ('DEBUGS', '4');
INSERT INTO `gmCommands` VALUES ('DELETETHREADS', '4');
INSERT INTO `gmCommands` VALUES ('DELFIGHTPOS', '4');
INSERT INTO `gmCommands` VALUES ('DELNPC', '4');
INSERT INTO `gmCommands` VALUES ('DELNPCITEM', '4');
INSERT INTO `gmCommands` VALUES ('DELTRIGGER', '4');
INSERT INTO `gmCommands` VALUES ('DEMORPH', '1');
INSERT INTO `gmCommands` VALUES ('DOACTION', '3');
INSERT INTO `gmCommands` VALUES ('EXIT', '3');
INSERT INTO `gmCommands` VALUES ('FULLHDV', '4');
INSERT INTO `gmCommands` VALUES ('GETCOORD', '4');
INSERT INTO `gmCommands` VALUES ('GOMAP', '1');
INSERT INTO `gmCommands` VALUES ('GONAME', '1');
INSERT INTO `gmCommands` VALUES ('HONOR', '3');
INSERT INTO `gmCommands` VALUES ('INFOS', '1');
INSERT INTO `gmCommands` VALUES ('ITEM', '3');
INSERT INTO `gmCommands` VALUES ('ITEMSET', '3');
INSERT INTO `gmCommands` VALUES ('KAMAS', '2');
INSERT INTO `gmCommands` VALUES ('KICK', '1');
INSERT INTO `gmCommands` VALUES ('LEARNJOB', '2');
INSERT INTO `gmCommands` VALUES ('LEARNSPELL', '3');
INSERT INTO `gmCommands` VALUES ('LEVEL', '3');
INSERT INTO `gmCommands` VALUES ('LISTTHREADS', '4');
INSERT INTO `gmCommands` VALUES ('LOCK', '4');
INSERT INTO `gmCommands` VALUES ('MAPANNOUNCE', '1');
INSERT INTO `gmCommands` VALUES ('MAPINFO', '1');
INSERT INTO `gmCommands` VALUES ('MORPH', '2');
INSERT INTO `gmCommands` VALUES ('MORPHITEM', '3');
INSERT INTO `gmCommands` VALUES ('MOVENPC', '4');
INSERT INTO `gmCommands` VALUES ('MUTE', '1');
INSERT INTO `gmCommands` VALUES ('MUTEMAP', '1');
INSERT INTO `gmCommands` VALUES ('NAMEANNOUNCE', '1');
INSERT INTO `gmCommands` VALUES ('NAMEGO', '1');
INSERT INTO `gmCommands` VALUES ('NEWITEM', '3');
INSERT INTO `gmCommands` VALUES ('PDVPER', '1');
INSERT INTO `gmCommands` VALUES ('PURGERAM', '4');
INSERT INTO `gmCommands` VALUES ('REFRESHMOBS', '2');
INSERT INTO `gmCommands` VALUES ('RELOADENCLOS', '3');
INSERT INTO `gmCommands` VALUES ('SAVE', '1');
INSERT INTO `gmCommands` VALUES ('SETADMIN', '4');
INSERT INTO `gmCommands` VALUES ('SETALIGN', '2');
INSERT INTO `gmCommands` VALUES ('SETINITQUESTION', '4')
INSERT INTO `gmCommands` VALUES ('SETMAXGROUP', '4');
INSERT INTO `gmCommands` VALUES ('SETREPONSES', '4');
INSERT INTO `gmCommands` VALUES ('SHOWFIGHTPOS', '4');
INSERT INTO `gmCommands` VALUES ('SHOWREPONSES', '4');
INSERT INTO `gmCommands` VALUES ('SHUTDOWN', '2');
INSERT INTO `gmCommands` VALUES ('SIZE', '2');
INSERT INTO `gmCommands` VALUES ('SPAWN', '2');
INSERT INTO `gmCommands` VALUES ('SPAWNSTARS', '2');
INSERT INTO `gmCommands` VALUES ('SPELLPOINT', '3');
INSERT INTO `gmCommands` VALUES ('SPWNFIX', '3');
INSERT INTO `gmCommands` VALUES ('TELEPORT', '1');
INSERT INTO `gmCommands` VALUES ('TITLE', '2');
INSERT INTO `gmCommands` VALUES ('TOOGLEAGGRO', '1');
INSERT INTO `gmCommands` VALUES ('UNBAN', '4');
INSERT INTO `gmCommands` VALUES ('UNBANIP', '4');
INSERT INTO `gmCommands` VALUES ('UNMUTE', '1');
INSERT INTO `gmCommands` VALUES ('UNMUTEMAP', '1');
INSERT INTO `gmCommands` VALUES ('VIEWSTUFF', '1');
INSERT INTO `gmCommands` VALUES ('WHO', '1');
INSERT INTO `gmCommands` VALUES ('RELOADCOMMANDS', '4');
UPDATE gmCommands SET command = "SPAWNFIX" WHERE command = "SPAWNFIX";
 
DROP TABLE IF EXISTS `commands`;
CREATE TABLE `Commands` (
  `id` int(11) NOT NULL DEFAULT '-1',
  `name` varchar(255) DEFAULT '',
  `functions` varchar(255) DEFAULT NULL,
  `conditions` varchar(255) DEFAULT NULL,
  `count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
-- ----------------------------
-- Records of Commands
-- ----------------------------
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('shop','38-27151,294','','0', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('mariage','38-2019,339','','1', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('start','38-27152,506','','2', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('pvm','38-10129,428','','3', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('pvm2','38-8482,428','','4', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('pvm3','38-4739,463','','5', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('pvp','38-952,312','','6', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('squatt','38-8721,240','','7', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('parcho','10','','8', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('setvip','15','PX>1','9', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('title','16-103','PZ=0','10', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('commandesvip','1','PZ=0','11', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('commandes','0','','12', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('infos','4','','13', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('staff','5','','14', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('save','6','','15', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('refresh','7','PZ=0','16', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('vie','8','','17', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('guilde','9','','18', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('kamas','13-100000000','','19', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('traque','18','','20', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('récompense','19','','21', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('normal','22','','22', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('commandeskoli','27','','23', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('TeamArena','29','','24', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('deTeamArena','30','','25', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('infoArena','31','','26', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('Arena','32','','27', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('stuffR','33','','28', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('points','34','','29', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('upmetier','35','PZ=0','30', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('fmcac','37-20000000','','31', '0');
INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('spellmax','39-6,0','','32', '0');

 
 
Merci De respecter mon petit travaille et je suis dispo pour vous aider :)
 
Edit : j'allait oublier 
 
Merci de faire un pti j'aime :P
  • Upvote 13

Share this post


Link to post
Share on other sites
Guest

Pour les GM commandes elles sont toutes dispo sur Icore 0.2.6 ;) et commande joueurs aussi mais merci quand même 

Share this post


Link to post
Share on other sites

INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('spellmax','39-6,0','','32', '0');

 

INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('spellmax','39-6,false','','32', '0');

Share this post


Link to post
Share on other sites

INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('spellmax','39-6,0','','32', '0');

 

INSERT INTO Commands(name, functions, conditions, id, count) VALUES ('spellmax','39-6,false','','32', '0');

je l'avait fait mais ca a utiliser tjr les point de sorts

 

donc j'ai mit 0 ^^

Share this post


Link to post
Share on other sites

Imposible, tu as mal fait (PS: c'est true), je demande si la commande est gratuite en point (True, oui, False non)

Share this post


Link to post
Share on other sites
Guest
  • les commande ne marche pas sur mon emu icore 0.2.6

Share this post


Link to post
Share on other sites

 

  • les commande ne marche pas sur mon emu icore 0.2.6

 

Commandes gm ou joueurs ?

Share this post


Link to post
Share on other sites
Guest

Développe un peu hein, les gens ne vont pas jouer aux devinettes avec ton problème

Share this post


Link to post
Share on other sites
Guest

tu parle avec moi salle ...;

Share this post


Link to post
Share on other sites

tu parle avec moi salle ...;

Un peu de respect s'il te plait et ne part pas en HS, developpe ton probleme ou creer une demande d'aide.

Share this post


Link to post
Share on other sites

Chez moi sa marche pas. j'utilise Icore 2.7 et sa me dit " commande non reconnue ou incomplète. " pour les commandes joueur.

 

Skype : willisixx

 

Merci d'avance :)

Share this post


Link to post
Share on other sites
Sign in to follow this  

×
×
  • Create New...