gift with lastest update

If something doesn't fit in any other forum then post it here.
Forum rules
READ NOW: L2j Forums Rules of Conduct
bigbro
Posts: 215
Joined: Mon Apr 30, 2007 10:00 pm
Location: Bulgaria

gift with lastest update

Post 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 :)
User avatar
JIV
L2j Veteran
L2j Veteran
Posts: 1882
Joined: Sun Jan 06, 2008 8:17 pm
Location: Slovakia
Contact:

Re: gift with lastest update

Post by JIV »

you have mess in own custom spawntable...
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: gift with lastest update

Post by jurchiks »

If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
bigbro
Posts: 215
Joined: Mon Apr 30, 2007 10:00 pm
Location: Bulgaria

Re: gift with lastest update

Post 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.
User avatar
JIV
L2j Veteran
L2j Veteran
Posts: 1882
Joined: Sun Jan 06, 2008 8:17 pm
Location: Slovakia
Contact:

Re: gift with lastest update

Post by JIV »

and you use all 2000 spawns, yeah
bigbro
Posts: 215
Joined: Mon Apr 30, 2007 10:00 pm
Location: Bulgaria

Re: gift with lastest update

Post by bigbro »

JIV wrote:and you use all 2000 spawns, yeah
oooooh no.. I have 6200 custom spawns in one of my servers :D
anyway at last this nonspawn table is gone and it works like it should.
bigbro
Posts: 215
Joined: Mon Apr 30, 2007 10:00 pm
Location: Bulgaria

Re: gift with lastest update

Post 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?
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: gift with lastest update

Post by jurchiks »

yep.
That's why I made that topic, but, as you can see, they don't give a fuck.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
bigbro
Posts: 215
Joined: Mon Apr 30, 2007 10:00 pm
Location: Bulgaria

Re: gift with lastest update

Post 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.
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: gift with lastest update

Post by jurchiks »

uhh... sync with repo? Eclipse?
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
bigbro
Posts: 215
Joined: Mon Apr 30, 2007 10:00 pm
Location: Bulgaria

Re: gift with lastest update

Post by bigbro »

jurchiks wrote:uhh... sync with repo? Eclipse?
yes... Eclipse
User avatar
jurchiks
Posts: 6769
Joined: Sat Sep 19, 2009 4:16 pm
Location: Eastern Europe

Re: gift with lastest update

Post by jurchiks »

yeah, that's how you see those differences. And since you already have Eclipse, that argument is invalid.
If you have problems, FIRST TRY SOLVING THEM YOURSELF, and if you get errors, TRY TO ANALYZE THEM, and ONLY if you can't help it, THEN ask here.
Otherwise you will never learn anything if all you do is copy-paste!
Discussion breeds innovation.
User avatar
janiii
L2j Veteran
L2j Veteran
Posts: 4269
Joined: Wed May 28, 2008 3:15 pm
Location: Slovakia

Re: gift with lastest update

Post 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.
DO NOT EVEN TRY TO MESS WITH ME!
forum flOOder dancing dEVILoper
I don't give private support - PM will be ignored!
_DS_
L2j Veteran
L2j Veteran
Posts: 3437
Joined: Wed Apr 30, 2008 8:53 am
Location: Russia

Re: gift with lastest update

Post 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 ?
Commiter of the shit
public static final int PI = 3.1415926535897932384626433832795;
User avatar
janiii
L2j Veteran
L2j Veteran
Posts: 4269
Joined: Wed May 28, 2008 3:15 pm
Location: Slovakia

Re: gift with lastest update

Post 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.
DO NOT EVEN TRY TO MESS WITH ME!
forum flOOder dancing dEVILoper
I don't give private support - PM will be ignored!
Post Reply