Scofield

October 13, 2013

Resolved.!!!

October 12, 2013

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"

September 10, 2013

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

September 8, 2013

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;

August 29, 2013

Tranks.

August 29, 2013

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

August 29, 2013

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

August 26, 2013

tranks

August 26, 2013

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

June 29, 2013

ok thank you, you're the best

June 27, 2013

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

June 21, 2013

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

June 20, 2013

Por acaso foi você quem fez Cydonia??

June 13, 2013

Therefore, only those who have in his possession, account name

June 11, 2013

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;

}

April 19, 2013

Thank you.

April 19, 2013

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

April 19, 2013

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

April 19, 2013

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

April 18, 2013

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

April 13, 2013

It worked thank you.

April 13, 2013

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.

April 12, 2013

The NPC appears to click on it nothing happens.

April 11, 2013

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

April 11, 2013

That, plus not just on the players online but to all registered accounts in inventory if possible

Sign In

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by Scofield