bindatcmd @bst Help

[EL Dragon]

I need a sql log for @ bst this is the script

-	script	bst_atcommand	-1,{
OnInit:
	bindatcmd "bst",strnpcinfo(0)+"::OnCommand";
	end;
OnCommand:
	if ( !getstrlen(.@atcmd_parameters$) ) {
		message strcharinfo(0), "Please, enter a message (usage: @bst <message>).";
		end;
	}
	if ( @bst_delay + 1800 > gettimetick(2) ) {
		message strcharinfo(0), "There is a 30 min delay of using this command again";
		end;
	}
	@bst_delay = gettimetick(2);
	announce "[Market] "+ strcharinfo(0) +" : "+ implode( .@atcmd_parameters$," " ), bc_all, 0x9999FF;
	end;
}

want the,Player_name ,the announce test,and the datum in bst_Market_log is stored

 

hope someone can help me

[Skorm]

/*

CREATE TABLE `ragnarok_logs`.`bst_market_log` (

`id` BIGINT(20) NOT NULL AUTO_INCREMENT,

`name` VARCHAR(30) NOT NULL DEFAULT '',

`message` VARCHAR(150) NOT NULL DEFAULT '',

`time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',

PRIMARY KEY (`id`))

ENGINE = MyISAM

DEFAULT CHARACTER SET = utf8;

*/

- script bst_atcommand -1,{

OnInit:

bindatcmd "bst",strnpcinfo(0)+"::OnCommand";

end;

OnCommand:

if ( !getstrlen(.@atcmd_parameters$) ) {

message strcharinfo(0), "Please, enter a message (usage: @bst <message>).";

end;

}

if ( @bst_delay + 1800 > gettimetick(2) ) {

message strcharinfo(0), "There is a 30 min delay of using this command again";

end;

}

@bst_delay = gettimetick(2);

.@message$ = implode( .@atcmd_parameters$," " );

announce "[Market] "+ strcharinfo(0) +" : "+ .@message$, bc_all, 0x9999FF;

query_logsql( "INSERT INTO `bst_market_log` ( `name`, `message` ) VALUES ( '"+escape_sql(strcharinfo(0))+"', '"+escape_sql( getstrlen(.@message$)>150?substr(.@message$,0,149):.@message$ )+"' );" );

end;

}

[EL Dragon]

is on line 17 error 

Edited July 29, 2014 by EL Dragon

[Skorm]

Change strlen to getstrlen.

[Potato Chips]

Hello, How do I install this?
via NPC?
if this is to SQL  /  PHP ADMIN please enlighten me @Skorm Ty

[Emistry]

Hello, How do I install this?

via NPC?

if this is to SQL  /  PHP ADMIN please enlighten me @Skorm Ty

SQL table load in phpmyadmin

 

NPC save in NPC folder. 

Follow the NPC adding guide.

[Potato Chips]

So I can install it by using npc or SQL table?

[Vince Jimenez]

is this working on eAmod ? can someone help me to work on eAmod server  emulatr please ?P(

[Potato Chips]

 

Hello, How do I install this?

via NPC?

if this is to SQL  /  PHP ADMIN please enlighten me @Skorm Ty

SQL table load in phpmyadmin

 

NPC save in NPC folder. 

Follow the NPC adding guide.

 

do you have a script that goes the same but will use @shout instead of @bst?

@bst = Market

@shout = shoutout or paging or recruiting

 

I tried duplicating this script then changing the name still whenever I type @shout it will show as @bst.

[Skorm]

do you have a script that goes the same but will use @shout instead of @bst?

@bst = Market

@shout = shoutout or paging or recruiting

 

 

I tried duplicating this script then changing the name still whenever I type @shout it will show as @bst.

/*
CREATE TABLE `ragnarok_logs`.`sout_market_log` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(30) NOT NULL DEFAULT '',
  `message` VARCHAR(150) NOT NULL DEFAULT '',
  `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8;
*/

-	script	sout_atcommand	-1,{
OnInit:
	bindatcmd "shout",strnpcinfo(0)+"::OnCommand";
	end;
OnCommand:
	if ( !getstrlen(.@atcmd_parameters$) ) {
		message strcharinfo(0), "Please, enter a message (usage: @shout <message>).";
		end;
	}
	if ( @sout_delay + 1800 > gettimetick(2) ) {
		message strcharinfo(0), "There is a 30 min delay of using this command again";
		end;
	}
	@sout_delay = gettimetick(2);
	.@message$ = implode( .@atcmd_parameters$," " );
	announce "[Recruiting] "+ strcharinfo(0) +" : "+ .@message$, bc_area, 0x99FFFF;
	query_logsql( "INSERT INTO `sout_market_log` ( `name`, `message` ) VALUES ( '"+escape_sql(strcharinfo(0))+"', '"+escape_sql( getstrlen(.@message$)>150?substr(.@message$,0,149):.@message$ )+"' );" );
	end;
}

[Potato Chips]

 

do you have a script that goes the same but will use @shout instead of @bst?

@bst = Market

@shout = shoutout or paging or recruiting

 

 

I tried duplicating this script then changing the name still whenever I type @shout it will show as @bst.

/*
CREATE TABLE `ragnarok_logs`.`sout_market_log` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(30) NOT NULL DEFAULT '',
  `message` VARCHAR(150) NOT NULL DEFAULT '',
  `time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`))
ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8;
*/

-	script	sout_atcommand	-1,{
OnInit:
	bindatcmd "shout",strnpcinfo(0)+"::OnCommand";
	end;
OnCommand:
	if ( !getstrlen(.@atcmd_parameters$) ) {
		message strcharinfo(0), "Please, enter a message (usage: @shout <message>).";
		end;
	}
	if ( @sout_delay + 1800 > gettimetick(2) ) {
		message strcharinfo(0), "There is a 30 min delay of using this command again";
		end;
	}
	@sout_delay = gettimetick(2);
	.@message$ = implode( .@atcmd_parameters$," " );
	announce "[Recruiting] "+ strcharinfo(0) +" : "+ .@message$, bc_area, 0x99FFFF;
	query_logsql( "INSERT INTO `sout_market_log` ( `name`, `message` ) VALUES ( '"+escape_sql(strcharinfo(0))+"', '"+escape_sql( getstrlen(.@message$)>150?substr(.@message$,0,149):.@message$ )+"' );" );
	end;
}

Thank you so much skorm, this is very helpful. Commend. Thanks again.

Edited January 30, 2016 by Potato Chips