Scofield

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.

Resolved.!!!

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;

Tranks.

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");

tranks

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; }

Thank you.

It did not work, I've added in the wrong way.

where in my script I add it? could you give me an example?

how to get it implemented in my script? the idea was to just people in the staff could access the function to reset the npc

I have this script that shows the ranking MvP my server, I wish it had a function to reset the ranking by the time I wanted prontera,171,182,3 script Ranking MvP 857,{ query_sql "SELECT `char_id`,`value` FROM `global_reg_value` WHERE `str`='MVPRank' ORDER BY ABS(value)DESC LIMIT 10",@char_id,@pontos_mvp; dispbottom "Position. Player: MVPs Dead: "; dispbottom " "; for(set @i,0;@i<=9;set @i,@i+1) { query_sql "SELECT `name` FROM `char` WHERE `char_id`='"+@char_id[@i]+"'",@nome$; dispbottom "["+(@i+1)+"] Nome: ["+@nome$+"] [MVPs: "+@pontos_mvp[@i]+"]"; } close; OnInit: waitingroom "[ Ranking MVP ]",0; end; }

It worked thank you.

There are some minor errors, the script will be adding 146 items in each account instead of just one, and just who gets to be online, people who are off when logs get nothing.

The NPC appears to click on it nothing happens.

per account. in that case would be the same storage.