Request: Monster Bestiary

[Nokia]

Hello, i saw it on some servers, its very simple:

every monster kill, will be saved and can be displayed into the homepage (php i guess) and npc.

Like:

Poring / Kills: 5

Drops / Kills: 0

maybe some reward can be given, like if you killed every mob or 100 porings etc.

i would do it by myself if i know how..

[Emistry]

O.O ? you wan to make count for all monster inside RO ?

then it would become an extremely huge table .....O.O ?

there is about...2000 ~ 3000 monster in RO...are you going to count for each of them ?

[Emistry]

i think you would required to create a new table of SQL to store these information because you wanna display this result through php ...

create a npc..

and check for the monster id upon killed a monster..

if the monster id is the targeted monster..

then increase the monster count by 1

and save the data / update it in your SQL table.

and for php...sorry dunno how to write php ...

[Nokia]

hm, if i got the script i would figure out how to display the information on php.. can you show me an example to check / save the monster kills?

[Emistry]

not really this will work...havent test ...just some scratch...

OnNPCKillEvent:
if( killedrid == 1002 ){
query_sql("UPDATE `Table_Name` WHERE `Count`=`Count`+1 AND `CharacterName`='"+escape_sql( strcharinfo(0) )+"'");
}
end;

[Nokia]

hum, so i have to add every existing mob id in the script? o.o

[Nokia]

thats what i planned o.o

should count, save and list every monster kill.. like an pokedex xd

[Arcenciel]

I'm not sure how viable this is.

Depending on how much players you have, the server that will host your SQL data will constantly be bombarded with queries.

Not sure how much resources will this consume, again with the number of processes that's going to be run in your server.

[Docubo]

Hmm, the picklog also logs every kill and drop, isnt it the same?

why just dont make a script for reading the picklog file, if sql logs are enabled its saved into sql also.

... oh well, the picklog only logs items with their id / map / amount.