A Project for Chronicle 4 based on L2JServer.


    Question about spawnlist 'id' field

    Share

    roko91

    Posts : 238
    Join date : 2013-01-30
    Age : 26
    Location : Bulgaria

    Question about spawnlist 'id' field

    Post  roko91 on 22nd February 2013, 04:46

    hi,
    I am curious whats the reason of spawnlist 'id' field ?
    I asking because I want to fix large part of the spawnlist (to make it close to retail). But this field stops me of doing changes because I don't know what would be consequences of changing the records in this field.
    Sorry for my bad english.
    avatar
    xlinkinx

    Posts : 164
    Join date : 2012-12-11
    Age : 25

    Re: Question about spawnlist 'id' field

    Post  xlinkinx on 22nd February 2013, 05:38

    roko91 wrote:hi,
    I am curious whats the reason of spawnlist 'id' field ?
    I asking because I want to fix large part of the spawnlist (to make it close to retail). But this field stops me of doing changes because I don't know what would be consequences of changing the records in this field.
    Sorry for my bad english.
    If I understand what you are only interested in the field with ID have spawn so here it is itself only serves as a guide to fill in the database.

    roko91

    Posts : 238
    Join date : 2013-01-30
    Age : 26
    Location : Bulgaria

    Re: Question about spawnlist 'id' field

    Post  roko91 on 22nd February 2013, 05:46

    So it is only for primary key in order to database normalization ?
    avatar
    xlinkinx

    Posts : 164
    Join date : 2012-12-11
    Age : 25

    Re: Question about spawnlist 'id' field

    Post  xlinkinx on 22nd February 2013, 05:50

    roko91 wrote:So it is only for primary key in order to database normalization ?
    difficult for me to explain it is available not my native language, let's wait and see how the developer will comment on it.

    roko91

    Posts : 238
    Join date : 2013-01-30
    Age : 26
    Location : Bulgaria

    Re: Question about spawnlist 'id' field

    Post  roko91 on 22nd February 2013, 05:51

    I also noticed that every single record in fields 'randomx', 'randomy' and 'loc_id' have '0' as value, are they necessary ?
    Sorry for the bunch of stupid questions
    avatar
    xlinkinx

    Posts : 164
    Join date : 2012-12-11
    Age : 25

    Re: Question about spawnlist 'id' field

    Post  xlinkinx on 22nd February 2013, 05:59

    roko91 wrote:I also noticed that every single record in fields 'randomx', 'randomy' and 'loc_id' have '0' as value, are they necessary ?
    Sorry for the bunch of stupid questions
    field "randomx ',' randomy" serve to random occurrence of mobs and they are not necessarily the same as "loc_id" where the data is in the table locations.sql.

    roko91

    Posts : 238
    Join date : 2013-01-30
    Age : 26
    Location : Bulgaria

    Re: Question about spawnlist 'id' field

    Post  roko91 on 22nd February 2013, 06:07

    I asked because I saw that they are removed in aCis interlude project as well as 'id' field.
    Ty for the info
    avatar
    xlinkinx

    Posts : 164
    Join date : 2012-12-11
    Age : 25

    Re: Question about spawnlist 'id' field

    Post  xlinkinx on 22nd February 2013, 06:29

    roko91 wrote:I asked because I saw that they are removed in aCis interlude project as well as 'id' field.
    Ty for the info
    вообщем напишу на русском т.к гугл уже поднадоел порядком. У aCis спаун был исправлен в сторону ближе к птс и это хорошо, а радом указон из за гото, что бы мобы не появлялись постоянно в одной точке вообщем тоже как на птс и это хорошо, но для переделки спауна с aCis на лисвус будет проблематично, но думаю возможно хоть и займет большой промежуток времени из за смены идов нпц.

    roko91

    Posts : 238
    Join date : 2013-01-30
    Age : 26
    Location : Bulgaria

    Re: Question about spawnlist 'id' field

    Post  roko91 on 22nd February 2013, 06:32

    Sorry I don't speak russian
    avatar
    xlinkinx

    Posts : 164
    Join date : 2012-12-11
    Age : 25

    Re: Question about spawnlist 'id' field

    Post  xlinkinx on 22nd February 2013, 06:36

    roko91 wrote:Sorry I don't speak russian
    I will try to translate the brief. Spawn aCis should go well, but of course there will be much change id the mobs and have to remember to remove all of the new locations that appeared in interlude. Just filled in aCis additional fields that would not show up monsters each time in one and the same point.

    roko91

    Posts : 238
    Join date : 2013-01-30
    Age : 26
    Location : Bulgaria

    Re: Question about spawnlist 'id' field

    Post  roko91 on 22nd February 2013, 06:42

    Ty for the info I will do the best I can
    avatar
    xlinkinx

    Posts : 164
    Join date : 2012-12-11
    Age : 25

    Re: Question about spawnlist 'id' field

    Post  xlinkinx on 22nd February 2013, 06:45

    roko91 wrote:Ty for the info I will do the best I can
    we will wait for your work. I think many need a good spawn sheet.
    avatar
    DnR
    Admin
    Admin

    Posts : 1023
    Join date : 2012-12-03

    Re: Question about spawnlist 'id' field

    Post  DnR on 22nd February 2013, 12:07

    Just as xlinkinx said, id is used as a primary key.
    The order makes no difference.
    I can put spawns in order by recreating id record and set it to auto-increment, so you don' t need to worry. Wink

    roko91

    Posts : 238
    Join date : 2013-01-30
    Age : 26
    Location : Bulgaria

    Re: Question about spawnlist 'id' field

    Post  roko91 on 22nd February 2013, 13:50

    This night i managed to convert (from interlude project) npc id's from 3 to 1000 (they was only monster types).
    Now I test the new spawnlist and so far it seems promising Smile
    I will post it when I make sure there is no big issues.

    Sponsored content

    Re: Question about spawnlist 'id' field

    Post  Sponsored content


      Current date/time is 26th September 2017, 21:01