GodKnows Jhomz

September 27, 2018

4 hours ago, Psy Ops said:

Where specifically in the script sir? Sorry i am very new to scripting.

You just need to load the npc in your server :

Open npc/script_custom.conf
Add this line:
npc: npc/custom/luckyroulette_prize_changer.txt
Copy the downloaded npc file in your npc/custom folder.

Type @reloadscript or Restart your server then go to the npc in the middle of prontera to change the prize in your lucky roulette. After changing prize you need to restart the server.

September 26, 2018

2 hours ago, Wickedknight2 said:

Was gonna ask for the same thing
So if i have bat_a01.gnd already cached, and i want to duplicate it, all i have to do is edit the resnametable? Wish i knew it before doing all the duplicating i had to do with my maps xD

Here is the answer to your question :

September 26, 2018

On 9/25/2018 at 8:06 PM, Psy Ops said:

Hi, I've downloaded your script and i want to know how to add items for this roullette?

You can't add more rewards. It is fixed for 42 item rewards. You can just edit the roulette prizes in this script.

September 26, 2018

1 hour ago, Quesooo said:

Hi everyone anyone can help with this maps

arug_cas06
arug_cas07
arug_cas08
bat_a03
bat_a04
bat_a05
bat_b03
bat_b04
bat_b05
bat_c04
bat_c04
bat_c05
bat_c06
bat_c07
bat_c08
region_8
rush_cas01
rush_cas02
rush_cas03
rush_cas04
schg_cas06
schg_cas07
schg_cas08

thank you so much

Try to add this in your data/resnametable.txt :

bat_a03.gnd#bat_a01.gnd#
bat_a03.gat#bat_a01.gat#
bat_a03.rsw#bat_a01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_a03.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_a01.bmp#
bat_a04.gnd#bat_a01.gnd#
bat_a04.gat#bat_a01.gat#
bat_a04.rsw#bat_a01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_a04.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_a01.bmp#
bat_a05.gnd#bat_a01.gnd#
bat_a05.gat#bat_a01.gat#
bat_a05.rsw#bat_a01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_a05.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_a01.bmp#
bat_b03.gnd#bat_b01.gnd#
bat_b03.gat#bat_b01.gat#
bat_b03.rsw#bat_b01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_b03.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_b01.bmp#
bat_b04.gnd#bat_b01.gnd#
bat_b04.gat#bat_b01.gat#
bat_b04.rsw#bat_b01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_b04.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_b01.bmp#
bat_b05.gnd#bat_b01.gnd#
bat_b05.gat#bat_b01.gat#
bat_b05.rsw#bat_b01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_b05.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_b01.bmp#
bat_c04.gnd#bat_c01.gnd#
bat_c04.gat#bat_c01.gat#
bat_c04.rsw#bat_c01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_c04.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_c01.bmp#
bat_c05.gnd#bat_c01.gnd#
bat_c05.gat#bat_c01.gat#
bat_c05.rsw#bat_c01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_c05.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_c01.bmp#
bat_c06.gnd#bat_c01.gnd#
bat_c06.gat#bat_c01.gat#
bat_c06.rsw#bat_c01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_c06.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_c01.bmp#
bat_c07.gnd#bat_c01.gnd#
bat_c07.gat#bat_c01.gat#
bat_c07.rsw#bat_c01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_c07.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_c01.bmp#
bat_c08.gnd#bat_c01.gnd#
bat_c08.gat#bat_c01.gat#
bat_c08.rsw#bat_c01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_c08.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\bat_c01.bmp#
schg_cas06.gnd#schg_cas01.gnd#
schg_cas06.gat#schg_cas01.gat#
schg_cas06.rsw#schg_cas01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\schg_cas06.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\schg_cas01.bmp#
schg_cas07.gnd#schg_cas02.gnd#
schg_cas07.gat#schg_cas02.gat#
schg_cas07.rsw#schg_cas02.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\schg_cas07.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\schg_cas02.bmp#
schg_cas08.gnd#schg_cas03.gnd#
schg_cas08.gat#schg_cas03.gat#
schg_cas08.rsw#schg_cas03.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\schg_cas08.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\schg_cas03.bmp#
arug_cas06.gnd#arug_cas01.gnd#
arug_cas06.gat#arug_cas01.gat#
arug_cas06.rsw#arug_cas01.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\arug_cas06.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\arug_cas01.bmp#
arug_cas07.gnd#arug_cas02.gnd#
arug_cas07.gat#arug_cas02.gat#
arug_cas07.rsw#arug_cas02.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\arug_cas07.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\arug_cas02.bmp#
arug_cas08.gnd#arug_cas03.gnd#
arug_cas08.gat#arug_cas03.gat#
arug_cas08.rsw#arug_cas03.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\arug_cas08.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\arug_cas03.bmp#
rush_cas01.rsw#prtg_cas02.rsw#
rush_cas01.gat#prtg_cas02.gat#
rush_cas01.gnd#prtg_cas02.gnd#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\rush_cas01.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\prtg_cas02.bmp#
rush_cas02.rsw#payg_cas04.rsw#
rush_cas02.gat#payg_cas04.gat#
rush_cas02.gnd#payg_cas04.gnd#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\rush_cas02.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\payg_cas04.bmp#
rush_cas03.rsw#aldeg_cas05.rsw#
rush_cas03.gat#aldeg_cas05.gat#
rush_cas03.gnd#aldeg_cas05.gnd#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\rush_cas03.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\aldeg_cas05.bmp#
rush_cas04.rsw#gefg_cas03.rsw#
rush_cas04.gat#gefg_cas03.gat#
rush_cas04.gnd#gefg_cas03.gnd#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\rush_cas04.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\gefg_cas03.bmp#
region_8.gnd#guild_vs2.gnd#
region_8.gat#guild_vs2.gat#
region_8.rsw#guild_vs2.rsw#
À¯ÀúÀÎÅÍÆäÀÌ½º\map\region_8.bmp#À¯ÀúÀÎÅÍÆäÀÌ½º\map\guild_vs2.bmp#

September 24, 2018

View File

Lucky Roulette Prize Changer

I'm not that good at scripting but I want to help the community by making this Lucky Roulette Prize Changer so you won't need to go to your sql just to update the prize.
To display the guide, you need to upload the rouletteGuide.bmp in your GRF. ( The file is included in the download. )
Reminder : Lucky Roulette's Prizes will only refresh when the server restarts but the list is updated instantly.

Submitter

GodKnows Jhomz
Submitted

09/24/2018
Category

Utilities
Video
Content Author

GodKnows Jhomz

September 24, 2018

50 minutes ago, AinsLord said:

sir @Valor


[Error]:  Loading NPC file: npc/custom/ains/overstatban.txt
script error on npc/custom/ains/overstatban.txt line 20
    need '('
    15 : {
    16 :
    17 : OnPCLoginEvent:
    18 : set .@name$,strcharinfo(0);
    19 : set .@ipbannumber$,getcharip(strcharinfo(0));
*   20 : if ( getgmlevel() > 99 || getgroupid '>' 99 ) {        // GM level/group config
    21 :        //==== Authorized GM Checker =============================================
    22 :                if ( .@name$ == "GMawa" || .@name$ == "GMaa") end;
    23 :                announce "Shield: "+.@name$+" from "+.@ipbannumber$+" was banned for login unauthorized GM account.",bc_all;
    24 :                //atcommand "@block "+.@name$;
    25 :                debugmes .@name$+" was banned for login unauthorized GM account.";

i have this error on your code

Try this instead.

if ( getgmlevel() > 99 || getgroupid() > 99 ) {

September 24, 2018

43 minutes ago, iubantot said:

Hi so im having this error

and im thinking that i should somewhat increase the message id

if im not mistaken, how can i do that? increase the message id?

Open src/map/map.cpp
Find #define MAP_MAX_MSG 1550
Change the value to 1600 or higher.
Recompile.

June 16, 2018

35 minutes ago, noaim90 said:

Hello all together,

How can i change the Poring Coin Sprite? I want to replace by a different Image.

I am not able to find in /data/sprite...

Where can i find the poring Coin sprite?

Thanks a lot for help!

Rename you new Spr and Act file to this : Æ÷¸µÄÚÀÎ
Then add it to your grf.

May 30, 2018

prontera,155,175,5	script	Click Limit NPC 123,{
	if(ClickLimit == 3) end;
	mes "[ Limit Click ]";
	set ClickLimit,ClickLimit+1;
		mes "You have clicked me "+ClickLimit+"x.";
		close;
}

Try this.

April 13, 2018

You need to update your map_cache.dat in your db/(pre)re folder for the updated payon.gat so you can walk in the new open space in the removed houses.

March 3, 2018

3 hours ago, Subzero said:

hello i got this script from here

i just want ask its possible to make this npc player can play anytime?

which part should i change

Just remove this from the script so it won't hide the npc when the script loaded :

OnClock0400:
OnClock0800:
OnClock1200:
OnClock1600:
OnClock2000:
OnClock0000:
	announce "Slot Machine will begin in 1 minute.", bc_all;
	sleep 60000;
	announce "Come and Play slot machine at prontera", bc_all;
	hideoffnpc strnpcinfo(3);
	sleep 300000;
	announce "Slot Machine already finished", bc_all;
	hideonnpc strnpcinfo(3);
	end;

OnInit: <-- Don't remove this
hideonnpc strnpcinfo(3); <-- Just remove this line

Here is the file where I remove the hideonnpc part.

Slot Machine.txt

February 19, 2018

Copy the Summoner's Skills from db / re / skill_db.txt and paste it either into db / import / skill_db.txt or db / pre-re / skill_db.txt

Here it is: summonerskills.txt

February 17, 2018

Can anyone help me how to make an npc with temporary array.
The npc should be like this:

Talk to npc then selection of Add Item or Close.
After clicking Add Item, it will ask for Item ID then Item Amount.
Then it will show the item name and amount after clicking next.
( After next it will show the current item list and it will show the same menu (Add Item or Close) )
After clicking Add Item again, it will do the same then after adding item id and amount it will show the list again including the latest item added and the same menu.
When you click close, it will clear the array.

February 10, 2018

On 2/6/2018 at 4:15 PM, shanchien29 said:
20151104 and I disabled Packet Obfuscation in packets.h
	#ifndef PACKET_OBFUSCATION
		//#define PACKET_OBFUSCATION
The only thing that is not working for me is the cash shop 'buy'. I can open the cash shop and add. after clicking purchase there will be an unsupported packet in server.

Are you able to update your server that uses thor patcher using this AndRO without manually updating the folder in your device?

February 9, 2018

// https://www.eathena.ws/board/index.php?&act=attach&type=post&id=5866

//===== eAthena Script =======================================
//= Super Convex Mirror
//===== By: ==================================================
//= Brian
//===== Current Version: =====================================
//= 1.0
//===== Compatible With: =====================================
//= eAthena SVN
//===== Description: =========================================
//= Detects if every MVP is alive or dead.
//===== Additional Comments: =================================
//= http://www.eathena.ws/board/index.php?showtopic=242050
//============================================================

prontera,156,175,3	script	Super Convex Mirror::convex	46,{
	for( .@i = 0; .@i < getarraysize( .mvp_name$ ); .@i++ ) {
		switch (.@i) {
			case 9:
				@alive = mobcount( "lhz_dun03", "summon_boss_lt::OnMyMvPDead" );
			break;
			case 26:
				@alive = ( $ktullanux_summon < 4 || mobcount( "ice_dun03","ice_boss#on::OnMyMobDead" ) );
			break;
			case 28: 
				@alive = mobcount( "niflheim", "NifInvasion::OnLoDDead" );
			break;
			case 42:
				@alive = ( $@thana_summon < 6 || mobcount( "thana_boss", "#Death::OnThanaDead" ) );
			break;
			default:
				@alive = mobcount( .mvp_map$[.@i], "" );
			break;
		}
		
		if ( .display_type == 2 )
			.@menu$ = .@menu$ + ( ( @alive ) ? "^FF0000" : "^008000" ) + .mvp_name$[.@i] + "^000000 (" + .mvp_map$[.@i] + "):";
		else if ( .display_type == 1 )
			mes ( ( @alive ) ? "^FF0000" : "^008000" ) + .mvp_name$[.@i] + "^000000 (" + .mvp_map$[.@i] + ")";
	}
	
	if ( .display_type == 1 ) close;
	
	.@num = select( .@menu$ ) - 1;
	
	if (.warp_to_mvp == 1)
		warp .mvp_map$[.@num],0,0;
	else if(.warp_to_mvp == 2) {
		sleep2 1000;
		sc_start SC_BOSSMAPINFO,600000,0;
	}
	end;

	OnInit:
		 // 0 = disabled, 1 = enabled, 2 = enabled + SC_BOSSMAPINFO
		.warp_to_mvp = 0;
		
		setarray .mvp_map$, 
			"moc_pryd06","ra_fild02","ra_fild03","ra_fild04","ve_fild01",
			"ve_fild02","lou_dun03","prt_maze03","abbey03","lhz_dun03",
			"gl_chyard","abyss_03","gef_dun02","gef_dun01","treasure02",
			"pay_fild10","gon_dun03","abbey02","xmas_fild01","ra_san05",
			"prt_sewb4","mosk_dun03","man_fild03","thor_v03","ama_dun03",
			"kh_dun02","ice_dun03","ayo_dun02","niflheim","anthell02",
			"mjolnir_04","pay_dun04","gef_fild02","gef_fild14","gef_fild10",
			"moc_pryd04","in_sphinx5","moc_fild17","ein_dun02","xmas_dun02",
			"beach_dun","spl_fild03","thana_boss","tur_dun04","odin_tem03",
			"jupe_core","lhz_dun02";

		setarray .mvp_name$, 
			"AmonRa","Atroce","Atroce","Atroce","Atroce",
			"Atroce","Bacsojin","Baphomet","Beelzebub","Bio3",
			"DarkLord","Detale","Doppelganger","Dracula","Drake",
			"Eddga","EvilSnakeLord","FallenBishop","Garm","GloomUnderNight",
			"GoldenThiefBug","Gopinich","HardrockMammoth","Ifrit","IncantationSamurai",
			"KielD01","Ktullanux","LadyTanee","LordofDeath","Maya",
			"Mistress","MoonlightFlower","OrcHero","OrcHero","OrcLord",
			"Osiris","Pharaoh","Phreeoni","RSX0806","StormyKnight",
			"TaoGunka","TendrilLion","Thanatos","TurtleGeneral","ValkyrieRandgris",
			"Vesper","Ygnizem";
		
		.display_type = 1;
		
		if( .warp_to_mvp > 0 )
			.display_type = 2;
	end;
}

I also switched the color code.

February 8, 2018

1 hour ago, hendra814 said:

I'm using this script right now


// https://www.eathena.ws/board/index.php?&act=attach&type=post&id=5866

//===== eAthena Script =======================================
//= Super Convex Mirror
//===== By: ==================================================
//= Brian
//===== Current Version: =====================================
//= 1.0
//===== Compatible With: =====================================
//= eAthena SVN
//===== Description: =========================================
//= Detects if every MVP is alive or dead.
//===== Additional Comments: =================================
//= http://www.eathena.ws/board/index.php?showtopic=242050
//============================================================

invek,141,144,0	script	Super Convex Mirror::convex	46,{
	for( .@i = 0; .@i < getarraysize( .mvp_name$ ); .@i++ ) {
		switch (.@i) {
			case 9:
				.@alive = mobcount( "lhz_dun03", "summon_boss_lt::OnMyMvPDead" );
			break;
			case 26:
				.@alive = ( $ktullanux_summon < 4 || mobcount( "ice_dun03","ice_boss#on::OnMyMobDead" ) );
			break;
			case 28: 
				.@alive = mobcount( "niflheim", "NifInvasion::OnLoDDead" );
			break;
			case 42:
				.@alive = ( $@thana_summon < 6 || mobcount( "thana_boss", "#Death::OnThanaDead" ) );
			break;
			default:
				.@alive = mobcount( .mvp_map$[.@i], "" );
			break;
		}
		
		if ( .display_type == 2 )
			.@menu$ = .@menu$ + ( ( .@alive ) ? "^008000" : "^FF0000" ) + .mvp_name$[.@i] + "^000000 (" + .mvp_map$[.@i] + "):";
		else if ( .display_type == 1 )
			mes ( ( .@alive ) ? "^008000" : "^FF0000" ) + .mvp_name$[.@i] + "^000000 (" + .mvp_map$[.@i] + ")";
	}
	
	if ( .display_type == 1 ) close;
	
	.@num = select( .@menu$ ) - 1;
	
	if (.warp_to_mvp == 1)
		warp .mvp_map$[.@num],0,0;
	else if(.warp_to_mvp == 2) {
		sleep2 1000;
		sc_start SC_BOSSMAPINFO,600000,0;
	}
	end;

	OnInit:
		 // 0 = disabled, 1 = enabled, 2 = enabled + SC_BOSSMAPINFO
		.warp_to_mvp = 0;
		
		setarray .mvp_map$, 
			"moc_pryd06","ra_fild02","ra_fild03","ra_fild04","ve_fild01",
			"ve_fild02","lou_dun03","prt_maze03","abbey03","lhz_dun03",
			"gl_chyard","abyss_03","gef_dun02","gef_dun01","treasure02",
			"pay_fild10","gon_dun03","abbey02","xmas_fild01","ra_san05",
			"prt_sewb4","mosk_dun03","man_fild03","thor_v03","ama_dun03",
			"kh_dun02","ice_dun03","ayo_dun02","niflheim","anthell02",
			"mjolnir_04","pay_dun04","gef_fild02","gef_fild14","gef_fild10",
			"moc_pryd04","in_sphinx5","moc_fild17","ein_dun02","xmas_dun02",
			"beach_dun","spl_fild03","thana_boss","tur_dun04","odin_tem03",
			"jupe_core","lhz_dun02";

		setarray .mvp_name$, 
			"AmonRa","Atroce","Atroce","Atroce","Atroce",
			"Atroce","Bacsojin","Baphomet","Beelzebub","Bio3",
			"DarkLord","Detale","Doppelganger","Dracula","Drake",
			"Eddga","EvilSnakeLord","FallenBishop","Garm","GloomUnderNight",
			"GoldenThiefBug","Gopinich","HardrockMammoth","Ifrit","IncantationSamurai",
			"KielD01","Ktullanux","LadyTanee","LordofDeath","Maya",
			"Mistress","MoonlightFlower","OrcHero","OrcHero","OrcLord",
			"Osiris","Pharaoh","Phreeoni","RSX0806","StormyKnight",
			"TaoGunka","TendrilLion","Thanatos","TurtleGeneral","ValkyrieRandgris",
			"Vesper","Ygnizem";
		
		.display_type = 1;
		
		if( .warp_to_mvp > 0 )
			.display_type = 2;
	end;
}

already could show mvp are still alive (red) or killed (green).

The problem is when character already warp or change location, the npc will put back the killed MVP to alive again.

Try to change .@alive to @alive ( Remove . ) Just a guess.

February 2, 2018

1 hour ago, Pink Guy said:

Hello guys, I'm trying to make a new card but for some reason, I can't edit the num2cardillustnametable.txt file. Whenever I edit it via Notepad2, and save it, it says something about the file being in unicode and when I press ok, my client doesn't start and have an error. So I am forced to copy a different num2cardillustnametable.txt to revert the changes. I would really appreciate your help. I'll attach my current num2cardillustnametable.txt file so you guys can see what's wrong.

num2cardillustnametable.txt

Just edit it using notepad or wordpad then add your custom card and save. Don't edit it using Notepad++. That's the only way you can add new card cutin.
Or try my suggestion to edit your num2cardillustnametable.txt inside the GRF Editor add your custom card then save, then extract it if you need to make a patch.

January 31, 2018

26 minutes ago, fckng said:

good afternoon alright let's go using rAthena, when initiating the batteground, does not generate any error in ssh, however it has a game error, the clan emblem is appearing only in the name, it is missing in the head like the image below, What can it be?

Hide contents

https://i.ytimg.com/vi/iNce07OKvsg/hqdefault.jpg

Check your mapflag, maybe it is set as GVG instead of Battleground.

January 31, 2018

21 minutes ago, core said:

Hi guys any one can help me with my problem =(

// ------------------------- Custom Mid Headgears
29288,Alucard_Glasses,Alucard Glasses,5,0,,100,,,,1,0xFFFFFFFF,15,2,1024,,0,0,2172,{ bonus bAllStats,5; },{},{} << i can wear it
29289,Obito_Goggles,Obito Goggles,5,20,,100,,5,,1,0xFFFFFFFF,15,2,1024,,0,0,2173,{ bonus bAllStats,5; },{},{}
29290,Big_Back_Ribbon,Big Back Ribbon,5,20,,100,,5,,1,0xFFFFFFFF,15,2,1024,,0,0,2174,{ bonus bAllStats,5; },{},{}
29291,Chinese_Knot,Chinese Knot,5,20,,100,,5,,1,0xFFFFFFFF,15,2,1024,,0,0,2175,{ bonus bAllStats,5; },{},{}
29292,Robo_Headset,Robo Headset,5,20,,100,,5,,1,0xFFFFFFFF,15,2,1024,,0,0,2176,{ bonus bAllStats,5; },{},{}

but the rest i cant wear it it says >> cannot be worn during current status

i want to wear them to the Costume/Style

If you have the item in your inventory then change its location from normal headgear into costume headgear you need to type @refresh or drop the item or relog.

Then you can equip the costume item.

January 30, 2018

21 minutes ago, Tassadar said:
prontera,0,0	monster	Wild Rose	1261,1,7200000,3600000
how do I make a monster be invoked this way only once at midnight?

or

how do I do to in an invasion npc he summon the monster at midnight, only the big size monster?

Tks for help.

Try this one. It will summon 10 (Big) Wild Rose in Prontera on Midnight (12:00AM | 00:00 Server Time).
You will get Reward once you killed the Wild Rose.

-	script	Midnight Mob Invasion	-1,{
OnClock0000:
	announce "[Invasion]: 10 Giant Wild Rose has been summoned in Prontera!",0;
	// Summons 10 Wild Rose in prontera.
	monster "prontera",0,0,"[Event] Wild Rose",1261,10,strnpcinfo(3)+"::OnEventKill",2;
	end;

OnEventKill:
	message strcharinfo(0),"You have killed Wild Rose! You have been rewarded!";
	// Rewards when killed
	getitem 607,1;
	end;
}

January 28, 2018

6 hours ago, Nitrous said:

Hey guys, looks like I need some help.

I have 3 tables, mob_db_re, mob_drop_re, and item_db_re.
mob_drop_re is created with this ddl statement:


CREATE TABLE `mob_drop_re` (
    `mobid` mediumint(9) unsigned NOT NULL default '0',
    `dtype` smallint(5) unsigned NOT NULL default '0',
    `index` smallint(5) unsigned NOT NULL,
    `nameid` smallint(5) unsigned NOT NULL default '0',
    `rate` smallint(9) unsigned NOT NULL default '0',
    `stealProtected` bool default false,
    `randomOptionGroup` text,

    PRIMARY KEY (`mobId`, `dtype`, `index`)

) ENGINE=MyISAM;

I'm working on the card_seller in npc/custom/card_seller.txt, and I get an error at the first query_sql call. Here's the code:


OnInit:
    if (checkre(0)) {
        .@mob_db$  = "mob_db_re";
        .@mob_drop$ = "mob_drop_re";
        .@item_db$ = "item_db_re";
    } else {
        .@mob_db$  = "mob_db";
        .@mob_drop$ = "mob_drop";
        .@item_db$ = "item_db";
    }
    freeloop 1;
    .@total = query_sql("SELECT DISTINCT LEFT(`name_japanese`, 1) AS alphabets FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_drop$ +"` ON `"+ .@mob_drop$ +"`.`nameid` = `"+ .@item_db$ +"`.`id` RIGHT JOIN `"+.@mob_db$ +"` ON `"+ .@mob_db$ +"`.`ID` = `"+ .@mob_drop$ +"`.`mobid` WHERE `"+ .@item_db$ +"`.`type` = 6 AND `name_english` LIKE '%_Card' AND ~(`MODE`) & 0x4000000 ORDER BY alphabets;", .alphabet$);
    for ( .@i = 0; .@i < .@total; .@i++ ) {
        .alphabet_menu$ = .alphabet_menu$ + .alphabet$[.@i] +" Cards:";
        .@nb = query_sql("SELECT `"+.@item_db$ +"`.`id` FROM `"+ .@item_db$ +"` RIGHT JOIN `"+ .@mob_drop$ +"` ON `"+ .@mob_drop$ +"`.`nameid` = `"+ .@item_db$ +"`.`id` RIGHT JOIN `"+.@mob_db$ +"` ON `"+ .@mob_db$ +"`.`ID` = `"+ .@mob_drop$ +"`.`mobid` WHERE `"+ .@item_db$ +"`.`type` = 6 AND `name_english` LIKE '%_Card' AND ~(`MODE`) & 0x4000000 AND LEFT(`name_japanese`, 1) = '"+ .alphabet$[.@i]+"' GROUP BY `name_japanese` ORDER BY `name_japanese` LIMIT 128;", .@id);
        npcshopdelitem "card_mob#"+ .alphabet$[.@i], 501;
        for ( .@j = 0; .@j < .@nb; .@j++ )
            npcshopadditem "card_mob#"+ .alphabet$[.@i], .@id[.@j], 1000000;
    }
    freeloop 0;
    end;

The script creates a sql statement as so:


SELECT DISTINCT LEFT(`name_japanese`, 1) AS alphabets FROM `item_db_re` RIGHT JOIN `mob_drop_re` ON `mob_drop_re`.`nameid` = `item_db_re`.`id` RIGHT JOIN `mob_db_re` ON `mob_db_re`.`ID` = `mob_drop_re`.`mobid` WHERE `item_db_re`.`type` = 6 AND `name_english` LIKE '%_Card' AND ~(`MODE`) &0x4000000 ORDER BY alphabets;

It works fine on MySQL Workbench, but produces an error when using it in the script:


[SQL]: DB error - Unknown column 'mob_drop_re.nameid' in 'on clause'
[Debug]: at script.cpp:16666 - SELECT DISTINCT LEFT(`name_japanese`, 1) AS alpha
bets FROM `item_db_re` RIGHT JOIN `mob_drop_re` ON `mob_drop_re`.`nameid` = `ite
m_db_re`.`id` RIGHT JOIN `mob_db_re` ON `mob_db_re`.`ID` = `mob_drop_re`.`mobid`
 WHERE `item_db_re`.`type` = 6 AND `name_english` LIKE '%_Card' AND ~(`MODE`) &
0x4000000 ORDER BY alphabets;
[Debug]: Source (NPC): Card Seller at prontera (155,177)

Can anyone help?

What is the expected result in modifying this card seller?

January 24, 2018

52 minutes ago, BugSICK said:

im only using the @reloadscript sir. <- not the one?

As @hendra814 said, please use @reloadatcommand or restart your server to make it work. @reloadscript only reloads npc scripts, not commands (unless it is inside the script using bindatcmd).

January 24, 2018

4 hours ago, NightJar said:

Hi. it worked. I knew it was not working. But it works fine though. Hahaha. My mistake!

Thankyou again!

Haha No Problem

January 21, 2018

54 minutes ago, Shimmonta said:

hi i am planning to host a server in india... as per your guide lines its perfectly launching... But i would like to do some changes like drop rates, Exp and some more things...

it would be awesome if some help me the server and to join others in server...?? Awaiting for your reply!!!

Check exp.conf and drops.conf inside your trunk/conf/battle folder. You can change exp rates and drop rates there base on the file name.

January 21, 2018

42 minutes ago, danielps said:

I now undestand, ur talking about npc.h, i tried and it worked!!
Thans a lot man! There are not so much people that know this, cause i saw lot of people asking help and nobody got the correct answer!
Thanks and like !!!

Sorry bout the missing file to be edited. Already edited the post for the others to know. Glad that I helped you out.

Sign In

Profiles

Forums

Downloads

Jobs Available

Server Database

Third-Party Services

Top Guides

Store

Crowdfunding

Posts posted by GodKnows Jhomz

Lucky Roulette Prize Changer