Several Questions

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
Borst
Posts: 5
Joined: Wed Jul 27, 2011 2:41 am

Several Questions

Post by Borst »

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

Ok here i go,

First thing is, where again can i check my revision number? I set the server quite some month ago, didnt used it in a while and forgot what revision it is again.

Second is, how do i change skills? Editing the xml doesnt work, also in the dp i cant seem to find the skills. e.g the summon reuse delay is too high.

Third, how can i set the overall respawn, if possible? The respawn for the mobs seem too fast, its not retail like, that is kinda annoying .

Fourth thing, is there a way to increase augmenting stones drop rate seperate from the ,,normal" drop rates?

Next thing is, is there a way to change the leveling exp needed and is it legit to do so? If not nvm, but i want the lower levels to take a certain time, not too fast. But the higher levels around 50+ and so on shouldnt take too long also. Managing this with just setting the rates doesnt seem likely.

I guess thats it for now.
User avatar
nonom
L2j Veteran
L2j Veteran
Posts: 649
Joined: Wed Mar 11, 2009 10:34 pm
Location: Magmeld

Re: Several Questions

Post by nonom »

Please use the search the next time, these questions are answered in our forums :P
Borst wrote:First thing is, where again can i check my revision number? I set the server quite some month ago, didnt used it in a while and forgot what revision it is again.
Open your build and check that:

l2j-version.properties
l2jdp- version.properties
Borst wrote:Second is, how do i change skills? Editing the xml doesnt work, also in the dp i cant seem to find the skills. e.g the summon reuse delay is too high.
Yes It works ;), you can improve the reuse delay, etc into the XML definitions. In-game use Alt+G and "Skill Search" to know what ID or take a look into the data/stats/skills/ xml files for any Skill Name/Id.
Borst wrote:Third, how can i set the overall respawn, if possible? The respawn for the mobs seem too fast, its not retail like, that is kinda annoying.
Check the spawnlist.sql file where you can modify the `respawn_delay` column for any npc id.
Borst wrote:Fourth thing, is there a way to increase augmenting stones drop rate seperate from the ,,normal" drop rates?
Into the rates.properties file you have something like "RateDropItemsById" and It says:

# List of items affected by custom drop rate by id, used now for Adena rate too.
# Usage: itemId1,dropChance1;itemId2,dropChance2;...
# Note: Make sure the lists do NOT CONTAIN trailing spaces or spaces between the numbers!
# Example for Raid boss 1x jewelry: 6656,1;6657,1;6658,1;6659,1;6660,1;6661,1;6662,1;8191,1;10170,1;10314,1;
# Default: 57,1
Borst wrote:Next thing is, is there a way to change the leveling exp needed and is it legit to do so? If not nvm, but i want the lower levels to take a certain time, not too fast. But the higher levels around 50+ and so on shouldnt take too long also. Managing this with just setting the rates doesnt seem likely.
Check that
data/stats/experience.xml
com.l2jserver.gameserver.datatables.ExperienceTable;
Image
"There are three kinds of people in this world, those who can count and those who can't"
Borst
Posts: 5
Joined: Wed Jul 27, 2011 2:41 am

Re: Several Questions

Post by Borst »

Ok really thanks for your help.
About the spawnlist.sql, is there a way to set the respawn delay at one time? Changing the respawn delay one per one would take several days i guess..
User avatar
volix
Posts: 106
Joined: Tue May 17, 2011 5:20 pm

Re: Several Questions

Post by volix »

Code: Select all

UPDATE spawnlist SET respawn_delay=123 WHERE npc_templateid BETWEEN 456 AND 789;
Borst
Posts: 5
Joined: Wed Jul 27, 2011 2:41 am

Re: Several Questions

Post by Borst »

Okay now again, what to do with these? If i open the spawnlist it says
spawnlist does not have a primary key
updates to this table will be done using the following pseudo statement:
Update spawnlist SET ModifiedFieldsAndValues Where AllFieldsAndOldValues LIMIT 1

i guess here should be the values you just posted, but i dont know how to change that and google doesnt helps me either again.

edit: After an hour of search it seems i have to use the ,,Query" option for that. But if i copy and past your values it doesnt work, dont know if im doing the right thing. Error under ,,explain is":
[Err] 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 'UPDATE spawnlist SET respawn_delay=123 WHERE npc_templateid BETWEEN 456 AND 789' at line 1
edit2:Didnt worked for me i had to change the SET, now
UPDATE spawnlist SET respawn_delay = 600 WHERE respawn_delay BETWEEN 1 AND 1200
worked for me.
Post Reply