[Party Exp Share]

Ah you mean all receive 1100?

If you have 10 players killing a monster giving 1000 exp, basicaly it'll give 100 exp to everybody (1000/10). You want that the monster gives the monsters exp to everyone?

1000 to everyone instead of 100 to everyone?

(Then there's the 1% bonus but that's something different)

With your edit everyone will get 110 exp instead of 109 if i'm not wrong

[QuestBoard NPC - Save Progress Database]

That's the point of the sql save, it is saved permantaly in the sql database.

[Party Exp Share]

Hello,

Let's say 10 player, one monster giving 1000, everybody's gonna get 101 exp (+1%), that's what you want? So a monster at 1000 giving actually 1010?
If I'm not wrong, actually the monster at 1000 exp with a bonus of 1% with 10 players will counte as 1090 exp and your edit will make it 1010.

[[08/06/20] Kreustoo's Collection]

Thanks gidzdlcrz

Added 2 new scripts :
-One paid full event (with map + sprites)

-A news npc

 

[Utility: News NPC]

@daLWeeeeelll, maybe it's not obvious but when you're a gm, talk to it again without updating it. I think that's just that?
I'll make a patch making that after updating it go to the news part even for gm directly.

EDIT: Patch uploaded, 1.2.0 it is

[Utility: News NPC]

View File

News NPC

---

Description
A News npc that will let the players read news from the server stocked in sql. It can print colors and show an animated showevent to attract players if there's a new news.
Each news is separated in 2, the resume and more. Make a short version of your news and then explain it more. That way you have more chance to spread at least the important part of it to the players.

Installation
-Run this sql command

CREATE TABLE IF NOT EXISTS `z_custom_news` (`id` int(11) NOT NULL AUTO_INCREMENT,`News` text NOT NULL,`Resume` text NOT NULL,`More` text NOT NULL,PRIMARY KEY (`id`))

-Add news

-Edit the !!Modify  Lines

-Check if you want to edit anything in the OnInit.

-Load the npc (news.txt) and voila!

-The news are sql and to update in game, just make a gm talk to it, no need to reload it each time. Not making it checking each time someone talk to it (or each hour ect) make the npc less ressource consuming, but you can edit it and make the request everytime.

Information
-It does not make a lot of sql request, it only update when a gm talk to it and chose to update.

-It saves the highest news seen and print an event to attract the attention of the player, commenting all the !!Saving Mecanism!! lines removes it. It does not save which one you saw.

-You can add color using ^RRGGBB and adding new lines using # (editable)
 

---

• Submitter
  Kreustoo
• Submitted
  05/15/2020
• Category
  Utilities
• Video
   
• Content Author
  Kreustoo

 

[Request Auto Reward Zeny For Base Level]

Hello,

-	script	LabelEvent	-1,{
	
	OnPCBaseLvUpEvent:
		while(BaseLevel - lastRewarded >= 10){ //lastRewarded to not miss multiple leveling
			lastRewarded = lastRewarded + 10;
			Zeny = Zeny + 1000;
			dispbottom "Congratulation you have reach milestone base level "+(lastRewarded)+", you gained 1000z"+(lastRewarded<90?(", next mile stone is base leve "+(lastRewarded+10)+"."):".");
		}
}

Killed one remover:

Not heavily tested

[if mvp is dead = pvp off]

Put your announce just after the first label OnOffPVP:

[Block-Exp Item]

use the mapflag on the maps of your instance

[Warp to GM Area]

From the documentation:

*warp "<map name>",<x>,<y>{,<char id>};

This command will take the invoking character or <char id>, if specified, to the specified map, and if
wanted, specified coordinates too, but these can be random.

	warp "place",50,55;

This would take them to X 50 Y 55 on the map called "place". If your X and Y
coordinates land on an unwalkable map square, it will send the warped character
to a random place. Same will happen if they are both zero:

	warp "place",0,0;

Notice that while warping people to coordinates 0,0 will normally get them into
a random place, it's not certain to always be so. Darned if I know where this is
actually coded, it might be that this happens because square 0,0 is unwalkable
on all official maps. If you're using custom maps, beware.

There are also three special 'map names' you can use.

"Random" will warp the player randomly on the current map.
"Save" and "SavePoint" will warp the player back to their save point.

so just :

warp "1@bamq",x,y;
close;

Is that what you were searching for?

[QuestBoard NPC - Save Progress Database]

Just a small tip, be carefull with the request you're doing, like doing a lot of select each time you talk to a npc ect.
At first it doesn't matter but after some times, if you use it a lot of times, it'll cost. Do as less request as possible (temporary storing table in npc/player var ect).

[HP Bars showing as GM]

Hello,

conf/groups.conf

Inside permissions:

view_hpmeter: false

 

For example:

{
	id: 10
	name: "Law Enforcement"
	inherit: ( "Mentor" )
	level: 2
	commands: {
		follow: true
		kick: true
		jail: true
		jailfor: true
		mute: true
		hide: true
		warp: true
	}
	log_commands: true
	permissions: {
		join_chat: true
		kick_chat: true
		hide_session: true
		who_display_aid: false
		hack_info: true
		any_warp: true
		view_hpmeter: false
		view_equipment: false
	}
},

 

[[08/06/20] Kreustoo's Collection]

Kreustoo's Collection

I worked on a lot of project and decided to make a proper topic with all my release. You can contact me on discord Kreustoo#4473 even if I'm actually part working with a server but I'm mostly free. I'm going to update this topic with some new content for the following weeks.

Free

Scripts

Spoiler

Poring Search

News NPC

 

Stat NPC

 

 

 

Sources Modifications

Spoiler

(QOL) Taekwon Mission printing

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[Mapflag/QOL] NoDeath_Count

 

 

 

Sprites

Spoiler

Angry Spore

 

Aqua Ten Gallon Hat 8 Recolors

 

 

Paid

Scripts

Spoiler

Bomb Poring

 

 

 

 

I'd like to thank rathena for all the work they've done and still doing. A lot of child dream came true thanks to you.

 

[Below lvl 99 Reward. Npc.]

Do they reborn using the official way or custom one?
You can remove the job you don't want to have it like Job_Hunter ect.

And 98 trans or 99? What about ninja ect?

[how to update database without closing server]

cash_db, you can just reloaditemdb (and if you use the button on the client, disconnect/reconnect)

[how to update database without closing server]

Just for information, I don't have a list (and maybe it changed and i'm wrong?) but some info can't be edited whithout restarting like guild name, and editing inventory ect live can make some weird behaviour too.

[OnPCDieEvent do not work]

Hello,

Do you have any error trigerring?
Try this even if I don't think it'll help?

getmapxy(.@map$,.@x,.@y,BL_PC);

Does your announce print anything uncommented?

[All pvp area's can't use ygg berry]

EDIT (Read too fast your post, missed your point)

Did you check with notepad++ 607 in db? Maybe it's somewhere and you didn't see it?
Sometimes the dumb solutions are the good ones

[Below lvl 99 Reward. Npc.]

Yeah, even level 1 can get the reward. Anyone below 99 can talk to the npc, anyway:

This

 if ( BaseLevel > .max_base_level || JobLevel > .max_job_level ) {
        mes "[ ^00FF00Race Up to Max^000000 ]";
        mes "We're sorry you are not qualified anymore for this event. Come back being less than "+(.max_base_level+1)+" base level and "+(.max_job_level+1)+" job level.";
        close;
    }

to this

 if ( BaseLevel != 98 ) {
        mes "[ ^00FF00Race Up to Max^000000 ]";
        mes "Only level 98 players can get the reward.";
        close;
    }

[Below lvl 99 Reward. Npc.]

I don't understand what you want:

Quote

So you want anybody below 99 being able to talk to the npc BUT not anyone at 99?

You want anybody at 98 having the reward?

[How can I disable Token of Siegfried in Event Maps]

Just for information, they don't have acess to @storage or kafra card? They can stock it in poring qpet too, or in cart.

[Token of Siegfried Delay]

Hello,

Did you try to change db\pre-re\item_delay.txt or db\re\item_delay.txt?
Anyway I wonder if a disconnect/reconnect would not reset the delay?

[[@where]: modify the command so that it does not display the location of VIP]

Hello,

I did that and it seems to work (but not heavily tested) - doesn't show vip players when using @where on them

vip_no_where.diff

[SQL Table Error - DB error - Duplicate entry]

Happened one time or happens regulary? In what situation?

[R> NPC that can give Item but you must be online 15days]

Hello,

Work on account and only on reconnection :

-	script	RewardForCo	-1,{

	OnPCLogoutEvent:
		if(@timingConnected > 0){
			@timeConnected = gettimetick(2)-@timingConnected;
			#sumConnected = #sumConnected + @timeConnected; // in seconds
		}
	end;
	
	OnPcLoginEvent:
		if(!#rewardConnection){
			if(#sumConnected >= 1296000) //15 days in seconds
			//if(#sumConnected >= 60) //1 minute, if you want to test
			{
				getinventorylist;
				if(checkweight(500,1) && @inventorylist_count <= (100-1)){
					#rewardConnection = 1;
					getitem 501,1; //REWARD -- edit the test if you add multiple items
					dispbottom "Great !";
				}else {
					dispbottom "Too heavy to get the reward !";
				}
			}else {
				@timingConnected = gettimetick(2);
			}
		}
	end;
}

Not heavily tested