numbering?

[wize_one]

trying to work with mw_052_053_alpha2.sql database wanting to renumber things like items, faction_list(that one jumps from 1 to 101)would like to renumber so it goes from 1 up.


INSERT INTO faction_list VALUES("1", "Beta Neutral", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0");
INSERT INTO faction_list VALUES("101", "Qeynos Citizens", "0", "0", "0", "100", "25", "-50", "25", "0", "25", "-20", "0", "-100", "0", "0", "0", "0", "1500", "250", "250", "250", "200", "-100", "1000", "100", "-200", "-100", "300", "100", "-1000", "-1000", "-500", "-500", "-250", "-200", "50", "-1000", "0", "-750", "0", "-1000", "100", "0", "50", "-1000", "100", "0", "0", "0", "100", "0", "0", "0", "0");





INSERT INTO items VALUES("68190", "0", "Gem of Burning Rage", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "", "32767", "0", "0", "0", "0", "0", "0", "0", "0", "2", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "", "3507", "0", "0", "0", "1429", "0", "0", "54", "0", "0", "Gem of Burning Rage", "1", "0", "0", "-1", "0", "0", "255", "0", "32767", "0", "0", "0", "63", "1", "0", "0", "0", "0", "2072574", "-1", "0", "0", "0", "0", "0", "0", "0", "-1", "-1", "0", "0", "0", "0", "0", "0", "0", "0", "0", "3", "0", "0", "0", "0", "0", "0", "0", "", "1", "0", "0", "0", "0");
INSERT INTO items VALUES("68195", "0", "Circlet of Flowing Time", "25", "23", "0", "8", "0", "25", "13", "13", "8", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "", "15360", "0", "0", "0", "15", "0", "0", "0", "15", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "", "3524", "0", "0", "165", "1124", "0", "0", "10", "0", "0", "Circlet of Flowing Time", "1", "180", "0", "0", "15", "0", "255", "15", "32767", "0", "0", "0", "65", "1", "0", "2", "0", "0", "4", "-1", "0", "0", "0", "0", "0", "0", "0", "-1", "-1", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "0", "7", "", "1", "0", "0", "0", "0");


do they have to be items 68190 and 68195 or could they be 1 and 2(for example)

would make life a little easier knowing what the next avil # is instead of spending 25 mins searching for a avil #.

[sanock42]

The numbers for items start at 1001, so if you want, you can renumber them all to whatever you wish. As long as everyone you have refers to those, it shouldn't make a difference. However, spells point to certain numbers for reagents, like bone chips and malachite, so if you do that, you'll have to either leave those reagents, keep the numbers the same, or change your spells_us.txt file (probably not something you want to do unless you want to distribute it for your server, like Winter's Roar does)

While I don't know exactly about the faction list, I wouldn't think it would be different. Just have to edit all your NPCs as well, for the right factions.

[mattmeck]

trying to work with mw_052_053_alpha2.sql database wanting to renumber things like items, faction_list(that one jumps from 1 to 101)would like to renumber so it goes from 1 up.

Your server you can change what you want HOWEVER if you change stuff around in the DB when they put an update out you will NOT be able to use it.


do they have to be items 68190 and 68195 or could they be 1 and 2(for example)

People are packet collecting from live so missing item #'s signify an item that hasnt been collected, once again you can change as you want but this will mean you wont be able to add new items easily when there added.