-
Posts
272 -
Joined
-
Last visited
-
Days Won
3
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Crowdfunding
Everything posted by Scofield
-
Hello good evening, the skill Magnum Break, enchants the weapon with 20% effect fire, wanted to edit the src to that effect stay 100% ..
-
Hello, well I'm not very good at fotoshop, I'd love to adapt this skin Roloader for Neocube, if someone could help me understand would be very grateful. Theme: http://www.mediafire.com/?eh40rgbltzl8766
-
I configured my emulator with delay_rate: 0, yet the asura is slow, I wonder whether it is possible to change the src to get the backwardness of the asura wanted to leave the asura with speed like this http://www.youtube.com/watch?feature=player_embedded&v=GLMcWnvCAJM
-
wanted to leave the skill Sacrifice Ritual like a server that I played many years atraz, when using the skill you could select the opponent, you could use that crosshair A friend told me I would have to modify it in most skill_db not know where 368,0,6,4,0,0 x61, 0,5,1, yes, 0,0,0, weapon, 0, PA_SACRIFICE, Martyr's Reckoning
-
I am creating an old-time server, configured for 150 dex cast run out, plus the asura even I put 999 dex it still is a cast really fast, I would remove it.
-
I want to use this panel https://github.com/Mysteries/StarGamesControlPanel I want to use this panel he was set to "group_id" I wonder where I change to be able to pick up on "level"
-
Well I've seen some tutorials teaching ClientInfo edit the name, I wonder if I would edit the location of ClientInfo, I would put it out of date or in any other part of the patch. hexed version: 20100730
-
Hello I wanted to put this npc mvp to invoke the player choose in exchange for bloody twig with a chance of 50% chance to fail for non vip. 06guild_01,50,93,4 script MVP Summoner 404,{ mes "[MVP Summoner]"; mes "Hi, what can I do for you ?"; next; switch (select("Summon MVP","Summon Mini Boss","Heal","Leave this room")) { case 1: mes "[MVP Summoner]"; mes strcharinfo(0)+" It can only be summon 2 Monster in the Room."; next; switch (select( "Bacsojin","Baphomet","Dark Lord","Detale","Doppelgangger","Dracula","Drake","Eddga","Evil Snake Lord","Garm","Golden Thief Bug","Gopinich","Incantation Samurai","Knight of Windstorm","Maya","Mistress","Moonlight Flower","Orc Hero","Orc Lord","Osiris","Pharaoh","Phreeoni","RSX 0806","Tao Gunka","Turtle General")){ case 1 : if ( getmapmobs("this") > 2 ){ mes "[MVP Summoner]"; mes "I cannot summon another monster when there are monsters around."; close;} else if ( zeny < 10000 ) { mes "[MVP Summoner]"; mes "Sorry, you don't have enough money to summon"; close;} set Zeny, zeny -10000; monster "this", 49, 49, "--ja--",1630,1; announce "MVP Summoner: "+strcharinfo(0)+" have been summon Bacsojin, only him can kill it.",bc_map,0x70DBDB; close;
-
Thanks for answering Capuche, I put that way and gave the following error. Erro: #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 '"); CREATE TABLE `regras` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , ' at line 10 CREATE TABLE `fama` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `foto` VARCHAR( 100 ) NOT NULL , `nome` VARCHAR( 100 ) NOT NULL , `nick` VARCHAR( 100 ) NOT NULL , `classe` VARCHAR( 100 ) NOT NULL , `cla` VARCHAR( 100 ) NOT NULL , `idade` VARCHAR( 100 ) NOT NULL , `mora` VARCHAR( 100 ) NOT NULL ) ENGINE = MYISAM"); CREATE TABLE `regras` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `regra` TEXT NOT NULL ) ENGINE = MYISAM"); CREATE TABLE `download` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `versao_pat` VARCHAR( 50 ) NOT NULL , `tamanho_pat` VARCHAR( 50 ) NOT NULL , `link_pat` TEXT NOT NULL , `episodio_bro` VARCHAR( 50 ) NOT NULL , `tamanho_bro` VARCHAR( 50 ) NOT NULL , `link_bro` TEXT NOT NULL ) ENGINE = MYISAM"); CREATE TABLE `equipe` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `cargo` VARCHAR( 50 ) NOT NULL , `nome` VARCHAR( 50 ) NOT NULL , `especi` TEXT NOT NULL ) ENGINE = MYISAM"); CREATE TABLE `noticias` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `titulo` TEXT NOT NULL , `noticia` TEXT NOT NULL , `data` VARCHAR( 20 ) NOT NULL , `por` VARCHAR( 50 ) NOT NULL ) ENGINE = MYISAM"); CREATE TABLE `eventos` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `titulo` TEXT NOT NULL , `evento` TEXT NOT NULL , `data` VARCHAR( 20 ) NOT NULL ) ENGINE = MYISAM"); CREATE TABLE `admin` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `usuario` VARCHAR( 50 ) NOT NULL , `senha` VARCHAR( 50 ) NOT NULL , `privilegio` VARCHAR( 2 ) NOT NULL ) ENGINE = MYISAM");
-
Hello I have a website a bit old, you need a database but the db be giving error in the current managers, if someone podesse fix I would be very grateful Erro: #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 'mysql_query("CREATE DATABASE `site_alan`")' at line 1 mysql_query("CREATE DATABASE `site_alan`"); mysql_query("CREATE TABLE `site_alan`.`fama` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `foto` VARCHAR( 100 ) NOT NULL , `nome` VARCHAR( 100 ) NOT NULL , `nick` VARCHAR( 100 ) NOT NULL , `classe` VARCHAR( 100 ) NOT NULL , `cla` VARCHAR( 100 ) NOT NULL , `idade` VARCHAR( 100 ) NOT NULL , `mora` VARCHAR( 100 ) NOT NULL ) ENGINE = MYISAM"); mysql_query("CREATE TABLE `site_alan`.`regras` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `regra` TEXT NOT NULL ) ENGINE = MYISAM"); mysql_query("CREATE TABLE `site_alan`.`download` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `versao_pat` VARCHAR( 50 ) NOT NULL , `tamanho_pat` VARCHAR( 50 ) NOT NULL , `link_pat` TEXT NOT NULL , `episodio_bro` VARCHAR( 50 ) NOT NULL , `tamanho_bro` VARCHAR( 50 ) NOT NULL , `link_bro` TEXT NOT NULL ) ENGINE = MYISAM"); mysql_query("CREATE TABLE `site_alan`.`equipe` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `cargo` VARCHAR( 50 ) NOT NULL , `nome` VARCHAR( 50 ) NOT NULL , `especi` TEXT NOT NULL ) ENGINE = MYISAM"); mysql_query("CREATE TABLE `site_alan`.`noticias` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `titulo` TEXT NOT NULL , `noticia` TEXT NOT NULL , `data` VARCHAR( 20 ) NOT NULL , `por` VARCHAR( 50 ) NOT NULL ) ENGINE = MYISAM"); mysql_query("CREATE TABLE `site_alan`.`eventos` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `titulo` TEXT NOT NULL , `evento` TEXT NOT NULL , `data` VARCHAR( 20 ) NOT NULL ) ENGINE = MYISAM"); mysql_query("CREATE TABLE `site_alan`.`admin` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `usuario` VARCHAR( 50 ) NOT NULL , `senha` VARCHAR( 50 ) NOT NULL , `privilegio` VARCHAR( 2 ) NOT NULL ) ENGINE = MYISAM");
-
I try to apply this db but always give error, I believe it is because she is too old if someone can correct me thank ERRO: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 8 # # Database : `sgcp` # DROP TABLE IF EXISTS `mainnews`; CREATE TABLE `mainnews` ( `post_id` int(11) NOT NULL auto_increment, `title` varchar(60) NOT NULL, `message` text NOT NULL, `poster` text NOT NULL, `date` varchar(255) NOT NULL, PRIMARY KEY (`post_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `privilege`; CREATE TABLE `privilege` ( `account_id` int(11) NOT NULL default '0', `privilege` int(11) NOT NULL default '0', PRIMARY KEY (`account_id`) ) TYPE=MyISAM; INSERT INTO `privilege` VALUES (704554,5); DROP TABLE IF EXISTS `bugreport`; CREATE TABLE `bugreport` ( `post_id` int(11) NOT NULL auto_increment, `report` text NOT NULL, `poster` text NOT NULL, `sex` char(1) NOT NULL default 'M', `ip` varchar(255) NOT NULL, `date` varchar(255) NOT NULL, PRIMARY KEY (`post_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `forum`; CREATE TABLE `forum` ( `forum_id` int(11) NOT NULL auto_increment, `category_id` int(11) NOT NULL, `forum_title` varchar(255) default '', `forum_description` varchar(255) default '', `forum_perm` mediumtext NOT NULL, PRIMARY KEY (`forum_id`) ) TYPE=MyISAM; INSERT INTO `forum` (category_id,forum_title,forum_description,forum_perm) VALUES ('1','A Test Forum','A test forum that may be removed at any time','[g1]:show_perm::read_perm::reply_perm::start_perm:[/g1][g2]:show_perm::read_perm::reply_perm::start_perm:[/g2][g3][/g3][g4]:show_perm::read_perm::reply_perm::start_perm:[/g4][g5]:show_perm::read_perm::reply_perm::start_perm:[/g5]'); DROP TABLE IF EXISTS `board_reply`; CREATE TABLE `board_reply` ( `reply_id` int(11) NOT NULL auto_increment, `topic_id` int(11) NOT NULL, `forum_id` int(11) NOT NULL, `reply_user_id` varchar(255) default '', `reply_emo` int(11) NOT NULL, `reply_message` text, `reply_ip` varchar(255) NOT NULL default '0.0.0.0', `reply_date` varchar(255) default '', `reply_upload` varchar(255) default '', `reply_edit_name` varchar(255) default '', `reply_edit_date` varchar(255) default '', PRIMARY KEY (`reply_id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `board_topic`; CREATE TABLE `board_topic` ( `topic_id` int(11) NOT NULL auto_increment, `forum_id` int(11) NOT NULL, `pinned_mode` varchar(255) NOT NULL default '0', `closed_mode` varchar(255) NOT NULL default '0', `topic_name` varchar(255) default '', `topic_description` varchar(255) default '', `topic_starter` varchar(255) NOT NULL default '', `topic_reading` varchar(255) NOT NULL default '0', `topic_replying` varchar(255) NOT NULL default '0', `topic_lastreply_name` varchar(255) default '', `topic_start_date` varchar(255) default '', `topic_last_action_date` varchar(255) default '', PRIMARY KEY (`topic_id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `user_profile`; CREATE TABLE `user_profile` ( `user_number` int(11) unsigned NOT NULL auto_increment, `user_id` int(11) unsigned NOT NULL, `display_name` varchar(255) NOT NULL default '', `user_sls_pass` varchar(255) NOT NULL default '', `user_time_offset` varchar(255) default '', `user_ranking` varchar(255) NOT NULL default '0', `user_avatar` varchar(255) default '', `user_avatar_width` varchar(255) NOT NULL default '0', `user_avatar_height` varchar(255) NOT NULL default '0', `user_signature_message` text, `user_flood_protection` varchar(12) NOT NULL default '0', `user_joined` varchar(255) default '', `user_last_login` varchar(255) default '', `user_online` tinyint(1) default '0', PRIMARY KEY (`user_number`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `status`; CREATE TABLE `status` ( `last_checked` varchar(255) NOT NULL default '', `login` int(11) NOT NULL default '0', `char` int(11) NOT NULL default '0', `map` int(11) NOT NULL default '0', PRIMARY KEY (`last_checked`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `user_online`; CREATE TABLE `user_online` ( `session` char(100) NOT NULL, `time` int(11) DEFAULT '0' NOT NULL ) TYPE=MyISAM; DROP TABLE IF EXISTS `poll`; CREATE TABLE `poll` ( `poll_id` int(11) NOT NULL auto_increment, `topic_id` int(11) NOT NULL, `starter_id` varchar(255) default '', `last_vote_date` varchar(255) default '', `poll_question` varchar(255) default '', `choice1` text, `choice2` text, `choice3` text, `choice4` text, `choice5` text, `choice6` text, `choice7` text, `choice8` text, `choice9` text, `choice10` text, PRIMARY KEY (`poll_id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `poll_vote`; CREATE TABLE `poll_vote` ( `poll_id` int(11) NOT NULL auto_increment, `topic_id` int(11) NOT NULL, `vote1` int(11) default '0', `vote2` int(11) default '0', `vote3` int(11) default '0', `vote4` int(11) default '0', `vote5` int(11) default '0', `vote6` int(11) default '0', `vote7` int(11) default '0', `vote8` int(11) default '0', `vote9` int(11) default '0', `vote10` int(11) default '0', PRIMARY KEY (`poll_id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `voters`; CREATE TABLE `voters` ( `vid` int(11) NOT NULL auto_increment, `ip_address` varchar(255) default '', `vote_date` varchar(255) default '', `topic_id` varchar(255) default '', `member_id` varchar(255) default '', PRIMARY KEY (`vid`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `groups`; CREATE TABLE `groups` ( `g_id` int(11) NOT NULL auto_increment, `g_title` varchar(32) default '', `g_img` varchar(255) default '', `g_color` varchar(255) default '', `g_view_board` tinyint(1), `g_post_new_topics` tinyint(1), `g_post_polls` tinyint(1), `g_vote_polls` tinyint(1), `g_edit_topics` tinyint(1), `g_edit_posts` tinyint(1), `g_delete_topics` tinyint(1), `g_delete_posts` tinyint(1), `g_move_topics` tinyint(1), `g_file_upload` tinyint(1), `g_avatar_upload` tinyint(1), `g_pinned_topics` tinyint(1), `g_closed_topics` tinyint(1), `g_read_news` tinyint(1), `g_read_privilege` tinyint(1), `g_add_news` tinyint(1), `g_add_privilege` tinyint(1), `g_edit_news` tinyint(1), `g_edit_privilege` tinyint(1), `g_delete_news` tinyint(1), `g_delete_privilege` tinyint(1), `g_delete_id` tinyint(1), `g_view_lastestcp` tinyint(1), `g_view_adminmenu` tinyint(1), `g_view_topic_option` tinyint(1), `g_upload_nonlimit` int(11), `g_post_closed_topics` tinyint(1), `g_non_showip` tinyint(1), `g_no_delay_posts` tinyint(1), `g_view_userip` tinyint(1), `g_searching_id` tinyint(1), `g_edit_rank_title` tinyint(1), `g_edit_mes_control` tinyint(1), `g_forum_manage` tinyint(1), `g_account_manage` tinyint(1), PRIMARY KEY (`g_id`) ) TYPE=MyISAM; INSERT INTO `groups` VALUES (1,'Guest','guest.gif','',1,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); INSERT INTO `groups` VALUES (2,'Member','member.gif','',1,1,1,1,0,0,0,0,0,1,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); INSERT INTO `groups` VALUES (3,'Banned','banned.gif','gray',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); INSERT INTO `groups` VALUES (4,'Sub Admin','sub_admin.gif','green',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,0,1,0,0,0,1,1,1,1,1,1,1,1,0,0,0,0); INSERT INTO `groups` VALUES (5,'Administrator','admin.gif','red',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); DROP TABLE IF EXISTS `query_log`; CREATE TABLE `query_log` ( `action_id` int(11) NOT NULL auto_increment, `Date` datetime NOT NULL default '0000-00-00 00:00:00', `User` varchar(24) NOT NULL default '', `IP` varchar(20) NOT NULL default '', `page` varchar(24) NOT NULL default '', `query` text NOT NULL, PRIMARY KEY (`action_id`), KEY `action_id` (`action_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `ranking_ignore`; CREATE TABLE `ranking_ignore` ( `account_id` int(11) NOT NULL default '0', PRIMARY KEY (`account_id`) ) TYPE=MyISAM; DROP TABLE IF EXISTS `security_code`; CREATE TABLE `security_code` ( `sc_id` text NOT NULL, `sc_code` varchar(11) NOT NULL default '0', `sc_time` int(11) NOT NULL default '0' ) TYPE=MyISAM; DROP TABLE IF EXISTS `rank_title`; CREATE TABLE `rank_title` ( `title_id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '0', `min_post` int(11) NOT NULL default '0', PRIMARY KEY (`title_id`) ) TYPE=MyISAM AUTO_INCREMENT=1; INSERT INTO `rank_title` VALUES (1,'Baby',0); INSERT INTO `rank_title` VALUES (2,'Child',10); INSERT INTO `rank_title` VALUES (3,'Adult',30); INSERT INTO `rank_title` VALUES (4,'Major',50); INSERT INTO `rank_title` VALUES (5,'Colonel',100); INSERT INTO `rank_title` VALUES (6,'General',200); INSERT INTO `rank_title` VALUES (7,'Sir',350); INSERT INTO `rank_title` VALUES (8,'Baron',600); INSERT INTO `rank_title` VALUES (9,'Marquis',900); INSERT INTO `rank_title` VALUES (10,'King',1200); DROP TABLE IF EXISTS `register_log`; CREATE TABLE `register_log` ( `reg_id` int(11) NOT NULL auto_increment, `Date` datetime NOT NULL default '0000-00-00 00:00:00', `account_id` int(11) unsigned NOT NULL, `userid` varchar(23) NOT NULL default '', `level` tinyint(3) NOT NULL default '0', `ip` varchar(100) NOT NULL default '', PRIMARY KEY (`reg_id`), KEY (`account_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; DROP TABLE IF EXISTS `memory`; CREATE TABLE `memory` ( `memory_id` int(11) NOT NULL auto_increment, `memory_object` varchar(255) default '', `memory_value1` varchar(255) default '', `memory_value2` varchar(255) default '', `memory_value3` text, PRIMARY KEY (`memory_id`) ) TYPE=MyISAM; INSERT INTO `memory` (memory_object,memory_value1) VALUES ('sgcp_install','1'); INSERT INTO `memory` (memory_object,memory_value1) VALUES ('ro_message','Administrator'); INSERT INTO `memory` (memory_object,memory_value1,memory_value2,memory_value3) VALUES ('forum_category','1','1','A Test Category');
-
ok thank you, you're the best
-
Hello I have this npc exatama to see the amount of equipment on the server using their id, it would put a ption only for admin to delete items using only the id. In case if I put the id 680 all equipment with this id will disappear. prontera,168,179,5 script Registros 757,{ mes "Digite o ID do item o qual você quer saber a quantidade existente no servidor no momento."; mes "Exemplo: ^0b85f8Rondel [1] (id: 13017).^000000"; mes "^0b85f8Chifres Místicos de Bafomé (id: 5518).^000000"; input .@item_id; if( getitemname( .@item_id ) != "null" ){ if( .@item_id ){ for( set .@i,0; .@i < .sql_size; set .@i,.@i + 1 ){ query_sql( "SELECT SUM(`amount`) FROM `"+.sql_table$[.@i]+"` WHERE `nameid`='"+.@item_id+"'",.@amount ); query_sql( "SELECT COUNT(`card0`) FROM `"+.sql_table$[.@i]+"` WHERE `card0`='"+.@item_id+"'",.@card0 ); query_sql( "SELECT COUNT(`card1`) FROM `"+.sql_table$[.@i]+"` WHERE `card1`='"+.@item_id+"'",.@card1 ); query_sql( "SELECT COUNT(`card2`) FROM `"+.sql_table$[.@i]+"` WHERE `card2`='"+.@item_id+"'",.@card2 ); query_sql( "SELECT COUNT(`card3`) FROM `"+.sql_table$[.@i]+"` WHERE `card3`='"+.@item_id+"'",.@card3 ); set .@total,.@total + ( .@amount + .@card0 + .@card1 + .@card2 + .@card3 ); } mes "Encontrado "+.@total+" x "+getitemname( .@item_id ); } }else{ mes "ID Item inválido"; } close; OnInit: setarray .sql_table$[0],"inventory","cart_inventory","guild_storage","storage","mail"; set .sql_size,getarraysize( .sql_table$ ); end; }
-
I have this script that shows the top 100 ranking placed in PvP, like once a month he was alone and did reset the first place award. prontera,171,182,3 script Ranking MvP 857,{ if (getgmlevel() > 20) { if ( select( "Ranking", "Reset" ) -1 ) { query_sql "DELETE FROM `global_reg_value` WHERE `str` = 'MVPRank'"; dispbottom "Ranking MvP resetado."; close; } } query_sql "SELECT `global_reg_value`.`value`, `char`.`name` FROM `global_reg_value` left join `char` on `global_reg_value`.`char_id` = `char`.`char_id` "+ "WHERE `global_reg_value`.`str`= 'MVPRank' ORDER BY ABS(value) DESC LIMIT 100", .@pontos_mvp, .@char_name$; dispbottom "Posição. Jogador: MVPs Mortos: "; dispbottom " "; if( !getarraysize( .@char_name$ ) ) dispbottom "*Lista Vazia*"; else for( set .@i,0; .@i < getarraysize( .@char_name$ ) ; set .@i, .@i +1 ) dispbottom "["+ ( .@i +1 ) +"] Nome: ["+ .@char_name$[.@i] +"] [MVPs: "+ .@pontos_mvp[.@i]+"]"; close; OnInit: waitingroom "[ Ranking MVP ]",0; end; }
-
Por acaso foi você quem fez Cydonia??
-
Therefore, only those who have in his possession, account name
-
Hello, I have this script that shows the amount of item that exists in the project at the time just putting the id, it would only show to admin quantiade item beyond the login id or the people who own them. prontera,168,179,5 script Registros ImperialRO 757,{ mes "Digite o ID do item o qual você quer saber a quantidade existente no servidor no momento."; mes "Exemplo: ^0b85f8Rondel [1] (id: 13017).^000000"; mes "^0b85f8Chifres Místicos de Bafomé (id: 5518).^000000"; input .@item_id; if( getitemname( .@item_id ) != "null" ){ if( .@item_id ){ for( set .@i,0; .@i < .sql_size; set .@i,.@i + 1 ){ query_sql( "SELECT SUM(`amount`) FROM `"+.sql_table$[.@i]+"` WHERE `nameid`='"+.@item_id+"'",.@amount ); query_sql( "SELECT COUNT(`card0`) FROM `"+.sql_table$[.@i]+"` WHERE `card0`='"+.@item_id+"'",.@card0 ); query_sql( "SELECT COUNT(`card1`) FROM `"+.sql_table$[.@i]+"` WHERE `card1`='"+.@item_id+"'",.@card1 ); query_sql( "SELECT COUNT(`card2`) FROM `"+.sql_table$[.@i]+"` WHERE `card2`='"+.@item_id+"'",.@card2 ); query_sql( "SELECT COUNT(`card3`) FROM `"+.sql_table$[.@i]+"` WHERE `card3`='"+.@item_id+"'",.@card3 ); set .@total,.@total + ( .@amount + .@card0 + .@card1 + .@card2 + .@card3 ); } mes "Encontrado "+.@total+" x "+getitemname( .@item_id ); } }else{ mes "ID Item inválido"; } close; OnInit: setarray .sql_table$[0],"inventory","cart_inventory","guild_storage","storage","mail"; set .sql_size,getarraysize( .sql_table$ ); end; }
-
It did not work, I've added in the wrong way.