Page 1 of 2
gift with lastest update
Posted: Mon Dec 27, 2010 5:13 pm
by bigbro
Guys, thanks for this christmas gift.
With removed nonspawned sql tables, all custom npc from custom_spawnlist are spawned. Can you imagine 2000 custom mobs in giran? Lol.. that was really awesome!
Keep it up!
Happy holidays

Re: gift with lastest update
Posted: Mon Dec 27, 2010 5:33 pm
by JIV
you have mess in own custom spawntable...
Re: gift with lastest update
Posted: Mon Dec 27, 2010 5:34 pm
by jurchiks
Re: gift with lastest update
Posted: Mon Dec 27, 2010 5:49 pm
by bigbro
JIV wrote:you have mess in own custom spawntable...
why?
before admin spawn npc. well.. there is INSERT INTO custom_spawnlist table. After that admin deleted custom npc, there is still record into custom_spawnlist, but a recort into custom_nonspawned table.
Re: gift with lastest update
Posted: Mon Dec 27, 2010 5:59 pm
by JIV
and you use all 2000 spawns, yeah
Re: gift with lastest update
Posted: Mon Dec 27, 2010 6:07 pm
by bigbro
JIV wrote:and you use all 2000 spawns, yeah
oooooh no.. I have 6200 custom spawns in one of my servers

anyway at last this nonspawn table is gone and it works like it should.
Re: gift with lastest update
Posted: Mon Dec 27, 2010 7:00 pm
by bigbro
before... when admin delete regular mob, there was new record in nonspawn table. Now if admin delete mob, record will be deleted in original spawnlist table?
Re: gift with lastest update
Posted: Mon Dec 27, 2010 7:22 pm
by jurchiks
yep.
That's why I made that topic, but, as you can see, they don't give a fuck.
Re: gift with lastest update
Posted: Mon Dec 27, 2010 8:37 pm
by bigbro
jurchiks wrote:yep.
That's why I made that topic, but, as you can see, they don't give a fuck.
Not good. Now we need to use some software to see diffs in spawntable for updates.
life is not easy.
Re: gift with lastest update
Posted: Mon Dec 27, 2010 8:41 pm
by jurchiks
uhh... sync with repo? Eclipse?
Re: gift with lastest update
Posted: Mon Dec 27, 2010 10:13 pm
by bigbro
jurchiks wrote:uhh... sync with repo? Eclipse?
yes... Eclipse
Re: gift with lastest update
Posted: Mon Dec 27, 2010 11:00 pm
by jurchiks
yeah, that's how you see those differences. And since you already have Eclipse, that argument is invalid.
Re: gift with lastest update
Posted: Mon Dec 27, 2010 11:03 pm
by janiii
with eclipse you cannot compare changed database content with sql from svn. also the export of the data to sql is probably different structure as the sql in svn. that is probably what bigbro ment.
Re: gift with lastest update
Posted: Mon Dec 27, 2010 11:08 pm
by _DS_
If you throw junk under the bed - sometimes it will return back. Maybe just not create junk at all ? Or you (as my co-workers) store documents in recycle bin too ?
Re: gift with lastest update
Posted: Mon Dec 27, 2010 11:15 pm
by janiii
i dont think customizing the spawnlist is junk. it is a normal feature of a customizable l2j server. i dont agree with removing the not_spawned table too. you cannot directly change the sql files from svn when you change the spawns. that is why there was the table - to control the removed original spawns and be able to update the sql files and the database with those changes.