Help needed for dropcalc testing.
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
- MELERIX
- L2j Veteran
- Posts: 6667
- Joined: Sat Sep 23, 2006 11:31 pm
- Location: Chile
- Contact:
-
- Advanced User
- Posts: 308
- Joined: Wed May 10, 2006 11:40 am
- Location: U.K.
O.K. - I'm making a few adjustments ... but before I solve this problem (I know what has gone on) I need some advice.
I assume that Raid Bosses are spawned by the "raidboss_spawnlist" table. At the moment, some Raid Bosses are being spawned by the spawnlist table. Dre Vanul, for example, is also listed in there as an "L2Monster" instead of an "L2RaidBoss".
If you look at Greyclaw Kutus, for example, id 10001, and Guard of Klutus, 10002, then Guard of klutus drops wooden arrow - item id 17. If you look on the drop calc for item 17, then you will correctly see that Guard of Klutus, is correctly shown in the droplist.
When I programmed the drop calc, I assumed that all Raid Bosses were spawned using the raidboss_spawnlist table.
Can someone straighten me out on this please?
I assume that Raid Bosses are spawned by the "raidboss_spawnlist" table. At the moment, some Raid Bosses are being spawned by the spawnlist table. Dre Vanul, for example, is also listed in there as an "L2Monster" instead of an "L2RaidBoss".
If you look at Greyclaw Kutus, for example, id 10001, and Guard of Klutus, 10002, then Guard of klutus drops wooden arrow - item id 17. If you look on the drop calc for item 17, then you will correctly see that Guard of Klutus, is correctly shown in the droplist.
When I programmed the drop calc, I assumed that all Raid Bosses were spawned using the raidboss_spawnlist table.
Can someone straighten me out on this please?
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
-
- Advanced User
- Posts: 308
- Joined: Wed May 10, 2006 11:40 am
- Location: U.K.
Thanks for the positive comments - much appreciated.
New version uploaded - code and graphics.
Config.php has sections for ...
... because some people have reported that the new server is only working with account names of a maximum of ten characters.
New version also puts a small graphic (for GM's) "IP" at the top left of every who's online entry, so that a GM can view all accounts registered to the IP that the running account is linked to.
New version uploaded - code and graphics.
Config.php has sections for ...
Code: Select all
// specifies maximum length for account names.
$max_acc_length = 20;
New version also puts a small graphic (for GM's) "IP" at the top left of every who's online entry, so that a GM can view all accounts registered to the IP that the running account is linked to.
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
-
- Advanced User
- Posts: 308
- Joined: Wed May 10, 2006 11:40 am
- Location: U.K.
I've just added yet another section to the code, and the config ...
When set to 1, anyone in the database with maxhp or maxmp over 60000 will get kicked and their character deleted.
The routine is run whenever a GM is watching the server console, or whenever anyone is watching the whos online... so whenever a GM or admin is watching the server by one of those two methods, the routine runs on every refresh.
------
This was done in response to people who are apparently using scripts to boost their characters on an L2J server, to absurdely high levels.
If you want to change the actual level at which the drop calc kicks and deletes the character (or just kicks, or just deletes, or whatever) then the code is near the bottom of the common.php file.
Code: Select all
// Bot Banning - whenever the server console or "Who's Online" is run, any character with max hp or max mp over 60,000 is kicked and deleted.
$bot_scan_ban = 1;
The routine is run whenever a GM is watching the server console, or whenever anyone is watching the whos online... so whenever a GM or admin is watching the server by one of those two methods, the routine runs on every refresh.
------
This was done in response to people who are apparently using scripts to boost their characters on an L2J server, to absurdely high levels.
If you want to change the actual level at which the drop calc kicks and deletes the character (or just kicks, or just deletes, or whatever) then the code is near the bottom of the common.php file.
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
-
- L2j Veteran
- Posts: 152
- Joined: Sun Apr 10, 2005 1:34 am
As I said on the L2J forum.
You may be on to something with this. A new GM/Admin tool.
If we come up with a list of things that do get abused, such as the levels you have mentioned, more configurations could be used to stop the abuses that go un noticed.
I would really like to see L2J incorporate some of these, but maybe a tool might be a better option, atleast for now.
You may be on to something with this. A new GM/Admin tool.
If we come up with a list of things that do get abused, such as the levels you have mentioned, more configurations could be used to stop the abuses that go un noticed.
I would really like to see L2J incorporate some of these, but maybe a tool might be a better option, atleast for now.
- MELERIX
- L2j Veteran
- Posts: 6667
- Joined: Sat Sep 23, 2006 11:31 pm
- Location: Chile
- Contact:
-
- Advanced User
- Posts: 308
- Joined: Wed May 10, 2006 11:40 am
- Location: U.K.
... It is all at the same location. At the moment, the version numbers are the same as I haven't got the time to go through all the code to change the versions, but it is all up to date.The drop calc itself is free to all, and there is a copy hooked up to a standard datapack at http://195.7.255.202 with documentation at http://195.7.255.202/documentation/index.htm and the php and SQL can be downloaded from http://www.msknight.com/comps/lineage2/ ... opcalc.htm
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
-
- Advanced User
- Posts: 308
- Joined: Wed May 10, 2006 11:40 am
- Location: U.K.
O.K. - new code uplaoded. This should be fixed. disKret kindly confirmed that minions are attached to mobs that aren't raidbosses, so I've adjusted the code to match.nbd wrote:another thing i noticed is that drops by minions arent listed.. only with "admin show non-spawned" .. some spellbooks are dropped by minions.. so players allways ask why the books dont drop
Let me know if it works right for you please.
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
- MELERIX
- L2j Veteran
- Posts: 6667
- Joined: Sat Sep 23, 2006 11:31 pm
- Location: Chile
- Contact:
Here is a fix for you map.jpg pic: http://img153.imageshack.us/img153/8809/mapgx4.jpg
i get some errors when use function "Who's On Line"
i get some errors when use function "Who's On Line"
Code: Select all
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 16 in W:\www\drops\w-online.php on line 133
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 16 in W:\www\drops\w-online.php on line 134
InCuBiTo
1 - Human (1)
incubito
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 20 in W:\www\drops\w-online.php on line 133
Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 20 in W:\www\drops\w-online.php on line 134
-
- Advanced User
- Posts: 308
- Joined: Wed May 10, 2006 11:40 am
- Location: U.K.
Hi Melerix,
That error is looking for the players account in the knightdrop table. It then pulls out the columns called "boxingok" and "warnlevel". They are both decimal 1 with default 0.
If those columns are there and populated, then check to see if the users account is in that table.
Let me know what happens please.
Thanks for the map fix, but I'm not clear what was broken. Can you let me know please? Many thanks.
Michelle.
That error is looking for the players account in the knightdrop table. It then pulls out the columns called "boxingok" and "warnlevel". They are both decimal 1 with default 0.
If those columns are there and populated, then check to see if the users account is in that table.
Let me know what happens please.
Thanks for the map fix, but I'm not clear what was broken. Can you let me know please? Many thanks.
Michelle.
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
- MELERIX
- L2j Veteran
- Posts: 6667
- Joined: Sat Sep 23, 2006 11:31 pm
- Location: Chile
- Contact:
the map fix, is original C5 map downloaded from www.lineage2.com, and ajusted to your maplist (Xpixels x Xpixels).
The map fix inlcuide real colors and zone names
The map fix inlcuide real colors and zone names
-
- Advanced User
- Posts: 308
- Joined: Wed May 10, 2006 11:40 am
- Location: U.K.
Hi Melerix,
Many thanks for that, but the map in the dropcalc is deliberately toned down. I found that with the full colour version, the crosses for the mobs, weren't easy to see. I actually spent a day dodging the names off the map!
So ... on one side people say it's too bright, and others say its too dark I can't win!
Is the map too dark for you? Can you see the location crosses O.K. against the full colour map? I'd appreciate your input.
... and what happened with the error?
Michelle.
Many thanks for that, but the map in the dropcalc is deliberately toned down. I found that with the full colour version, the crosses for the mobs, weren't easy to see. I actually spent a day dodging the names off the map!
So ... on one side people say it's too bright, and others say its too dark I can't win!
Is the map too dark for you? Can you see the location crosses O.K. against the full colour map? I'd appreciate your input.
... and what happened with the error?
Michelle.
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.
- MELERIX
- L2j Veteran
- Posts: 6667
- Joined: Sat Sep 23, 2006 11:31 pm
- Location: Chile
- Contact:
-
- Advanced User
- Posts: 308
- Joined: Wed May 10, 2006 11:40 am
- Location: U.K.
... and you've got the two columns "boxingok" and "warnlevel" in the knightdrop table in the logon database?
The knightdrop table should contain an entry for every entry in your accounts table. Does it? If it doesn't, there is a button in the "Server Tools" marked "import accounts" - try that.
The knightdrop table should contain an entry for every entry in your accounts table. Does it? If it doesn't, there is a button in the "Server Tools" marked "import accounts" - try that.
My friend is a paranoid schizophrenic ... she'll take over the world, as long as nobody minds.