Elysium Core 1.12 Repack - Including MMaps and Optional Vendors

[koyle112]

Well how? With what?

[koyle112]

Just add a new entry in the `item_template` table.

Well how? With what?

[brotalnia]

With HeidiSQL for example. Make sure MySQL is running first. Then use these settings to connect:

Hostname: 127.0.0.1
User: root
Password: root
Port: 3306

You will find the `item_template` table inside the `mangos` database. Find an existing item that is similar to the one you want to create and use it as a template. Find it by ID, click on it and choose "Duplicate row". Give it a new ID and change whatever stats you want. You can see the meaning of the different columns here -> “item_template” table — mangos-zero 0.2.0 documentation

[koyle112]

With HeidiSQL for example. Make sure MySQL is running first. Then use these settings to connect:

Hostname: 127.0.0.1
User: root
Password: root
Port: 3306

You will find the `item_template` table inside the `mangos` database. Find an existing item that is similar to the one you want to create and use it as a template. Find it by ID, click on it and choose "Duplicate row". Give it a new ID and change whatever stats you want. You can see the meaning of the different columns here -> “item_template” table — mangos-zero 0.2.0 documentation

How would I find an item that is worn by NPCs? And i'm sorry but I have no experience with this what so ever, so if you could please go into a little more detail.

[brotalnia]

Now that is more complex. Mobs don't wear actual items that you can add to yourself, but you can find the display ids that they have for the different slots and create items with it. First find the displayid of the creature whose items you want. Then open CreatureDisplayInfo.dbc with MyDbcEditor, and find the display id there. The fourth column is the skin + equipment id. Copy this, then open CreatureDisplayInfoExtra.dbc and find it there. Here is the format of this dbc file DB/CreatureDisplayInfoExtra - wowdev but this is for 3.3.5. You will have to figure out if the column numbers are correct for 1.12 too. Then you can just use the ids from there for your custom items.

[vu159]

So, now I checked some commands. As you said, I had to start event "155 - Argent dawn @ 1.11". Now I can see quest givers in the chapel of light. I even can complete the T-3 quests. For that thank you but I started every event to see "Anachronos". Hey normalie stays infront The caverns of Time in Tanaris but not in this repack. As I said I started every event on your ID - List but he is not spawning. Damn, what can I do? Yes you said complete the quest with the .quest command but how do I find quest ID's? I mean there are 10000000 quests in the game???? hehe
I saw the command npc add......maybe this could be a solution? but where to find the npc ids? hell yeah!^^

[brotalnia]

So, now I checked some commands. As you said, I had to start event "155 - Argent dawn @ 1.11". Now I can see quest givers in the chapel of light. I even can complete the T-3 quests. For that thank you but I started every event to see "Anachronos". Hey normalie stays infront The caverns of Time in Tanaris but not in this repack. As I said I started every event on your ID - List but he is not spawning. Damn, what can I do? Yes you said complete the quest with the .quest command but how do I find quest ID's? I mean there are 10000000 quests in the game???? hehe
I saw the command npc add......maybe this could be a solution? but where to find the npc ids? hell yeah!^^

You can find IDs on this site: Anachronos - NPC - AoWoW - World of Warcraft Database

The number at the end of the link after the "=" is the id. As you can see Anachronos' id is 15192. Just search for any creature, quest or item on the website and copy the id from the end of the link.

[copiatodo]

Hello brotalnia

When I try ejecut itemization 1.05 "pve_items" Nor does sqlyog / navicat terminate the function.

Navicat " 1200 process from 1282 Queries" and sqlyog 1272 querys execute.

any ideas?

[brotalnia]

Hello brotalnia

When I try ejecut itemization 1.05 "pve_items" Nor does sqlyog / navicat terminate the function.

Navicat " 1200 process from 1282 Queries" and sqlyog 1272 querys execute.

any ideas?

That's weird. Have you tried with HeidiSQL?

[copiatodo]

That's weird. Have you tried with HeidiSQL?

I did, after 2-3 hours process finish.

But Brotalnia, the itemization 1.5 It's not the same as elysium, I've tried extracting the tier2 from sql and patching it alone, I have been able to do it but the objects lose their class and can not be equipped.

Gyazo - 93f017b9bd9558c5e43b9f4c2270252e.png

I have tried with "UPDATE INTO" -- "INSERT INTO" but i not know, I do not know how to update stats only without touching the object.

¿could you help me? I've looked a thousand times at sql 1.5 but I do not understand its working.

REPLACE INTO `item_template`

(entry,stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6,
armor, fire_res, nature_res, frost_res, shadow_res, arcane_res,
spellid_1, spelltrigger_1, spellid_2, spelltrigger_2, spellid_3, spelltrigger_3)
VALUES
('16811','5','18','6','15','7','17','0','0','0','0','0','0','70','0','0','0','7' ,'0','9406','1','0','0','0','0'),
('16812','5','15','6','15','7','10','0','0','0','0','0','0','63','7','0','0','0' ,'0','21626','1','9406','1','0','0'),
('16813','5','27','6','20','7','17','0','0','0','0','0','0','83','10','0','0','0 ','0','9417','1','9408','1','0','0'),
('16814','5','24','6','20','7','18','0','0','0','0','0','0','89','0','0','0','10 ','0','21626','1','9408','1','0','0'),
('16815','5','27','6','17','7','20','0','0','0','0','0','0','102','10','0','0',' 0','0','9408','1','0','0','0','0'),
('16816','5','23','6','10','7','13','0','0','0','0','0','0','76','0','0','0','7' ,'0','9415','1','0','0','0','0'),
('16817','5','22','6','10','7','10','0','0','0','0','0','0','57','7','0','0','0' ,'0','21618','1','9415','1','0','0'),
('16819','7','8','5','12','6','7','0','0','0','0','0','0','44','0','0','0','0',' 0','21624','1','9407','1','0','0'),
('16820','3','29','7','20','4','10','0','0','0','0','0','0','200','10','0','0',' 0','0','7597','1','0','0','0','0'),
('16821','3','20','7','19','4','6','0','0','0','0','0','0','163','10','0','0','0 ','0','7598','1','0','0','0','0'),
('16822','3','33','7','15','4','10','0','0','0','0','0','0','175','0','0','0','1 0','0','7597','1','0','0','0','0'),
('16823','3','26','7','12','4','3','0','0','0','0','0','0','150','0','0','0','7' ,'0','15464','1','0','0','0','0'),
('16824','3','26','7','18','0','0','0','0','0','0','0','0','138','0','0','0','7' ,'0','0','0','0','0','0','0'),
('16825','3','20','7','15','0','0','0','0','0','0','0','0','88','0','0','0','0', '0','0','0','0','0','0','0'),
('16826','3','18','7','17','4','12','0','0','0','0','0','0','125','7','0','0','0 ','0','15464','1','0','0','0','0'),
('16827','3','17','7','18','4','9','0','0','0','0','0','0','113','7','0','0','0' ,'0','7597','1','0','0','0','0'),
('16828','5','22','6','10','7','10','0','0','0','0','0','0','113','7','0','0','0 ','0','21618','1','9415','1','0','0'),
('16829','5','13','6','15','7','16','0','0','0','0','0','0','138','0','0','0','7 ','0','21625','1','9406','1','0','0'),
('16830','5','14','6','13','7','13','0','0','0','0','0','0','88','0','0','0','0' ,'0','9396','1','0','0','0','0'),
('16831','5','18','6','15','7','17','0','0','0','0','0','0','125','7','0','0','0 ','0','9406','1','0','0','0','0'),
('16832','3','25','7','17','4','6','0','0','0','0','0','0','169','10','0','0','0 ','0','13669','1','0','0','0','0'),
('16833','5','24','6','16','7','23','0','0','0','0','0','0','200','10','0','0',' 0','0','21625','1','9408','1','0','0'),
('16834','5','28','6','13','7','26','0','0','0','0','0','0','163','10','0','0',' 0','0','9417','1','0','0','0','0'),
('16835','5','19','6','20','7','18','0','0','0','0','0','0','175','0','0','0','1 0','0','18384','1','21362','1','9408','1'),
('16836','5','20','6','10','7','13','0','0','0','0','0','0','150','0','0','0','7 ','0','21618','1','9406','1','0','0'),
('16837','5','10','6','22','7','15','0','0','0','0','0','0','290','0','0','0','7 ','0','9406','1','0','0','0','0'),
('16838','5','21','6','7','7','12','0','0','0','0','0','0','237','7','0','0','0' ,'0','21618','1','9406','1','0','0'),
('16839','5','13','6','15','7','14','0','0','0','0','0','0','264','7','0','0','0 ','0','18384','1','9415','1','0','0'),
('16840','5','17','6','11','7','10','0','0','0','0','0','0','185','0','0','0','0 ','0','9396','1','0','0','0','0'),
('16841','5','27','6','13','7','17','0','0','0','0','0','0','422','10','0','0',' 0','0','18384','1','9408','1','0','0'),
('16842','5','23','6','13','7','24','0','0','0','0','0','0','343','10','0','0',' 0','0','21626','1','9408','1','0','0'),
('16843','5','19','6','21','7','18','0','0','0','0','0','0','369','0','0','0','1 0','0','21627','1','9417','1','0','0'),
('16844','5','18','6','10','7','17','0','0','0','0','0','0','317','0','0','0','7 ','0','21618','1','9406','1','0','0'),
('16845','3','26','5','11','7','23','0','0','0','0','0','0','422','10','0','0',' 0','0','7597','1','0','0','0','0'),
('16846','3','23','5','15','6','8','7','23','0','0','0','0','343','10','0','0',' 0','0','7597','1','0','0','0','0'),
('16847','3','32','5','6','6','8','7','15','0','0','0','0','369','0','0','0','10 ','0','7597','1','0','0','0','0'),
('16848','3','24','5','5','6','9','7','14','0','0','0','0','317','0','0','0','7' ,'0','15464','1','0','0','0','0'),
('16849','3','28','6','6','7','14','0','0','0','0','0','0','290','0','0','0','7' ,'0','0','0','0','0','0','0'),
('16850','3','20','5','6','6','5','7','11','0','0','0','0','185','0','0','0','0' ,'0','0','0','0','0','0','0'),
('16851','3','18','5','9','6','4','7','16','0','0','0','0','237','7','0','0','0' ,'0','7597','1','0','0','0','0'),
('16852','3','18','7','12','0','0','0','0','0','0','0','0','264','7','0','0','0' ,'0','15465','1','0','0','0','0'),
('16853','5','21','6','13','7','26','4','8','0','0','0','0','749','10','0','0',' 0','0','9408','1','0','0','0','0'),
('16854','5','24','6','10','7','20','4','9','0','0','0','0','608','10','0','0',' 0','0','21619','1','9408','1','0','0'),
('16855','5','18','6','18','7','24','4','7','0','0','0','0','655','0','0','0','1 0','0','21625','1','9408','1','0','0'),
('16856','5','15','6','8','7','22','4','10','0','0','0','0','562','0','0','0','7 ','0','9406','1','0','0','0','0'),
('16857','5','8','6','11','7','11','4','10','0','0','0','0','328','0','0','0','0 ','0','21618','1','0','0','0','0'),
('16858','5','20','6','8','7','15','4','13','0','0','0','0','421','7','0','0','0 ','0','9406','1','0','0','0','0'),
('16859','5','13','6','10','7','20','4','7','0','0','0','0','515','0','0','0','7 ','0','21624','1','9406','1','0','0'),
('16860','5','15','6','14','7','15','4','10','0','0','0','0','468','7','0','0',' 0','0','9406','1','0','0','0','0'),
('16861','7','23','4','11','0','0','0','0','0','0','0','0','328','0','0','0','0' ,'0','0','0','0','0','0','0'),
('16862','7','26','4','15','0','0','0','0','0','0','0','0','515','0','0','0','7' ,'0','13383','1','0','0','0','0'),
('16863','7','17','4','22','0','0','0','0','0','0','0','0','468','7','0','0','0' ,'0','15464','1','13383','1','0','0'),
('16864','7','15','4','21','0','0','0','0','0','0','0','0','421','7','0','0','0' ,'0','13669','1','13383','1','0','0'),
('16865','7','28','4','20','0','0','0','0','0','0','0','0','749','10','0','0','0 ','0','13676','1','13386','1','0','0'),
('16866','7','35','4','15','0','0','0','0','0','0','0','0','608','10','0','0','0 ','0','13669','1','13386','1','0','0'),
('16867','7','23','4','24','0','0','0','0','0','0','0','0','655','0','0','0','10 ','0','13665','1','13386','1','0','0'),
('16868','7','22','4','15','0','0','0','0','0','0','0','0','562','0','0','0','7' ,'0','13675','1','13383','1','0','0'),
('16897','5','25','6','17','7','20','0','0','0','0','0','0','225','10','10','0', '0','0','18384','1','18032','1','0','0'),
('16898','5','17','6','11','7','15','0','0','0','0','0','0','154','10','0','0',' 0','0','18384','1','9315','1','0','0'),
('16899','5','19','6','15','7','13','0','0','0','0','0','0','140','0','0','0','1 0','0','18032','1','0','0','0','0'),
('16900','5','31','6','12','7','20','0','0','0','0','0','0','183','0','0','10',' 10','0','21626','1','9316','1','0','0'),
('16901','5','26','6','23','7','17','0','0','0','0','0','0','197','10','0','0',' 0','10','18034','1','0','1','0','0'),
('16902','5','23','6','12','7','15','0','0','0','0','0','0','169','10','0','0',' 0','0','9316','1','0','1','0','0'),
('16903','5','25','6','12','7','13','0','0','0','0','0','0','126','0','0','0','1 0','0','9315','1','0','1','0','0'),
('16904','5','15','6','12','7','11','0','0','0','0','0','0','98','0','0','0','0' ,'0','9318','1','0','0','0','0'),
('16905','3','26','7','17','4','12','0','0','0','0','0','0','225','10','10','0', '0','0','7597','1','15465','1','0','0'),
('16906','3','25','7','17','4','6','0','0','0','0','0','0','154','10','0','0','0 ','0','13669','1','0','0','0','0'),
('16907','3','20','7','20','4','19','0','0','0','0','0','0','140','0','0','0','1 0','0','7219','1','0','0','0','0'),
('16908','3','27','7','25','4','19','0','0','0','0','0','0','183','0','0','10',' 10','0','7597','1','0','0','0','0'),
('16909','3','37','7','17','4','11','0','0','0','0','0','0','197','10','0','0',' 0','10','7597','1','0','0','0','0'),
('16910','3','20','7','15','4','13','0','0','0','0','0','0','126','0','0','0','1 0','0','7597','1','0','0','0','0'),
('16911','3','23','7','13','0','0','0','0','0','0','0','0','98','0','0','0','0', '0','15464','1','0','0','0','0'),
('16919','5','17','6','17','7','17','0','0','0','0','0','0','80','10','0','0','0 ','0','18029','1','0','0','0','0'),
('16920','5','20','6','13','7','12','0','0','0','0','0','0','72','0','0','0','10 ','0','18384','1','9316','1','0','0'),
('16921','5','27','6','22','7','17','0','0','0','0','0','0','94','10','0','10',' 0','0','18034','1','0','0','0','0'),
('16922','5','21','6','21','7','16','0','0','0','0','0','0','101','0','0','0','1 0','10','18033','1','0','0','0','0'),
('16923','5','27','6','16','7','17','0','0','0','0','0','0','116','10','10','0', '0','0','18037','1','0','0','0','0'),
('16924','5','25','6','13','7','12','0','0','0','0','0','0','87','5','3','0','0' ,'0','9315','1','0','0','0','0'),
('16925','5','26','6','9','7','14','0','0','0','0','0','0','65','0','0','0','10' ,'0','9315','1','0','0','0','0'),
('16926','5','13','6','16','7','9','0','0','0','0','0','0','51','0','0','0','0', '0','9318','1','0','0','0','0'),
('16935','3','23','5','6','6','6','7','13','0','0','0','0','211','0','0','0','0' ,'0','0','0','0','0','0','0'),
('16936','3','20','5','13','6','11','7','15','0','0','0','0','271','0','0','0',' 10','0','7597','1','0','0','0','0'),
('16937','3','23','5','13','6','6','7','15','0','0','0','0','362','10','0','0',' 0','0','15464','1','0','0','0','0'),
('16938','3','31','5','15','6','8','7','16','0','0','0','0','422','10','0','0',' 0','10','15464','1','7597','1','0','0'),
('16939','3','27','5','16','6','8','7','26','0','0','0','0','392','0','0','10',' 10','0','7597','1','0','0','0','0'),
('16940','3','20','5','13','6','6','7','17','0','0','0','0','301','0','0','0','1 0','0','7597','1','0','0','0','0'),
('16941','3','30','5','6','6','6','7','15','0','0','0','0','332','10','0','0','0 ','0','0','0','0','0','0','0'),
('16942','3','34','5','14','6','6','7','17','0','0','0','0','482','10','10','0', '0','0','7597','1','0','0','0','0'),
('16943','5','16','6','9','7','13','0','0','0','0','0','0','211','0','0','0','0' ,'0','18379','1','0','0','0','0'),
('16944','5','18','6','11','7','13','0','0','0','0','0','0','271','0','0','0','1 0','0','18384','1','9315','1','0','0'),
('16945','5','17','6','8','7','23','0','0','0','0','0','0','362','10','0','0','0 ','0','9317','1','0','0','0','0'),
('16946','5','18','6','20','7','16','0','0','0','0','0','0','422','10','0','0',' 0','10','18384','1','13881','1','0','0'),
('16947','5','24','6','12','7','20','0','0','0','0','0','0','392','0','0','10',' 10','0','18384','1','18029','1','0','0'),
('16948','5','17','6','13','7','15','0','0','0','0','0','0','301','0','0','0','1 0','0','21626','1','9317','1','0','0'),
('16949','5','16','6','16','7','17','0','0','0','0','0','0','332','10','0','0',' 0','0','14799','1','0','0','0','0'),
('16950','5','31','6','16','7','17','0','0','0','0','0','0','482','10','10','0', '0','0','17371','1','0','0','0','0'),
('16951','5','13','6','9','7','23','4','0','0','0','0','0','375','0','0','0','0' ,'0','0','0','0','0','0','0'),
('16952','5','23','6','8','7','15','4','0','0','0','0','0','482','0','0','0','10 ','0','18029','1','0','0','0','0'),
('16953','5','17','6','8','7','20','4','0','0','0','0','0','642','10','0','0','0 ','0','21363','1','9408','1','0','0'),
('16954','5','27','6','17','7','26','4','0','0','0','0','0','749','0','0','0','0 ','0','18029','1','0','0','0','0'),
('16955','5','29','6','17','7','21','4','0','0','0','0','0','696','0','0','10',' 10','0','18033','1','0','0','0','0'),
('16956','5','20','6','10','7','17','4','0','0','0','0','0','535','0','0','0','1 0','0','21626','1','23796','1','0','0'),
('16957','5','15','6','12','7','23','4','0','0','0','0','0','589','10','0','0',' 0','0','9316','1','0','0','0','0'),
('16958','5','21','6','12','7','23','4','0','0','0','0','0','857','10','10','0', '0','10','18379','1','18030','1','0','0'),
('16959','7','27','4','13','0','0','0','0','0','0','0','0','375','0','0','0','0' ,'0','0','0','0','0','0','0'),
('16960','7','20','4','20','0','0','0','0','0','0','0','0','482','0','0','0','10 ','0','13676','1','13386','1','0','0'),
('16961','7','27','4','13','0','0','0','0','0','0','0','0','642','10','0','0','0 ','0','23516','1','13386','1','0','0'),
('16962','7','27','4','19','0','0','0','0','0','0','0','0','749','10','0','0','0 ','10','13670','1','21407','1','0','0'),
('16963','7','40','4','17','0','0','0','0','0','0','0','0','696','0','0','10','1 0','0','21407','1','0','0','0','0'),
('16964','7','20','4','15','0','0','0','0','0','0','0','0','535','0','0','0','10 ','0','13665','1','13386','1','0','0'),
('16965','7','30','4','13','0','0','0','0','0','0','0','0','589','10','0','0','0 ','0','23515','1','13386','1','0','0'),
('16966','7','40','4','17','0','0','0','0','0','0','0','0','857','10','10','0',' 0','0','21407','1','0','0','0','0'),
-- arcanist (1.5)
('16795','7','14','5','35','6','8','0','0','0','0','0','0','83','10','0','0','0' ,'0','9344','1','0','0','0','0'),
('16796','5','24','6','13','7','23','0','0','0','0','0','0','89','0','0','0','10 ','10','18384','1','9404','1','0','0'),
('16797','5','24','6','9','7','10','0','0','0','0','0','0','76','5','0','0','0', '0','13605','1','0','0','0','0'),
('16798','5','33','6','16','7','7','3','7','0','0','0','0','102','0','0','0','0' ,'0','13599','1','9401','0','9404','0'),
('16799','5','20','7','6','6','8','0','0','0','0','0','0','44','7','0','4','0',' 0','9396','1','21624','1','0','0'),
('16800','7','13','5','15','6','14','0','0','0','0','0','0','70','0','0','0','10 ','10','18384','1','9402','1','0','0'),
('16801','5','18','6','10','7','17','0','0','0','0','0','0','63','7','0','0','0' ,'0','21618','1','0','0','0','0'),
('16802','5','26','6','10','7','10','0','0','0','0','0','0','57','7','0','0','0' ,'0','9415','1','0','0','0','0'),
-- felheart (1.5)
('16803','5','10','6','8','7','27','0','0','0','0','0','0','70','0','0','0','7', '7','9412','1','0','0','0','0'),
('16804','5','11','6','8','7','18','0','0','0','0','0','0','44','0','0','0','0', '0','21346','1','7708','1','0','0'),
('16805','5','15','6','8','7','18','0','0','0','0','0','0','63','7','0','0','0', '0','18384','1','9415','1','0','0'),
('16806','5','14','6','13','7','14','0','0','0','0','0','0','57','7','0','0','0' ,'0','21348','1','9412','0','0','0'),
('16807','5','17','6','7','7','25','0','0','0','0','0','0','76','0','0','0','7', '7','9415','1','0','0','0','0'),
('16808','5','20','6','12','7','27','0','0','0','0','0','0','83','10','0','0','0 ','0','21595','1','9414','1','0','0'),
('16809','5','20','7','31','0','0','0','0','0','0','0','0','102','10','0','0','0 ','0','9342','1','23727','1','0','0'),
('16810','5','19','6','10','7','20','0','0','0','0','0','0','89','0','0','0','10 ','10','14798','1','0','0','0','0'),
-- netherwind (1.5)
('16818', '5', '25', '6', '13', '7', '12', '0', '0', '0', '0', '0', '0', '65', '0', '0', '0', '10', '0', '9343', '1', '0', '0', '0', '0'),
('16912', '5', '17', '6', '20', '7', '13', '0', '0', '0', '0', '0', '0', '80', '0', '10', '0', '0', '0', '13605', '1', '0', '0', '0', '0'),
('16913', '5', '17', '6', '14', '7', '15', '0', '0', '0', '0', '0', '0', '72', '0', '0', '0', '10', '0', '18384', '1', '9344', '1', '0', '0'),
('16914', '5', '32', '6', '12', '7', '14', '0', '0', '0', '0', '0', '0', '94', '0', '0', '10', '10', '0', '18049', '1', '0', '0', '0', '0'),
('16915', '5', '27', '6', '17', '7', '16', '0', '0', '0', '0', '0', '0', '101', '10', '0', '0', '0', '10', '14798', '1', '0', '0', '0', '0'),
('16916', '5', '36', '6', '17', '7', '8', '0', '0', '0', '0', '0', '0', '116', '9', '3', '0', '0', '0', '17868', '1', '0', '0', '0', '0'),
('16917', '5', '18', '6', '13', '7', '16', '0', '0', '0', '0', '0', '0', '87', '10', '0', '0', '0', '0', '21619', '1', '9343', '1', '0', '0'),
('16918', '5', '23', '6', '13', '7', '9', '0', '0', '0', '0', '0', '0', '51', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
-- nemesis (1.5)
('16927', '5', '13', '6', '17', '7', '20', '0', '0', '0', '0', '0', '0', '80', '0', '3', '0', '0', '0', '18009', '1', '0', '0', '0', '0'),
('16928', '5', '16', '6', '7', '7', '17', '0', '0', '0', '0', '0', '0', '72', '0', '0', '0', '10', '0', '20885', '1', '9343', '1', '0', '0'),
('16929', '5', '18', '6', '13', '7', '27', '0', '0', '0', '0', '0', '0', '94', '0', '0', '10', '10', '0', '21599', '1', '14799', '1', '0', '0'),
('16930', '5', '17', '6', '16', '7', '27', '0', '0', '0', '0', '0', '0', '101', '10', '0', '0', '0', '10', '14798', '1', '0', '0', '0', '0'),
('16931', '3', '5', '5', '23', '6', '17', '7', '27', '0', '0', '0', '0', '116', '3', '0', '0', '9', '0', '18009', '1', '0', '0', '0', '0'),
('16932', '5', '13', '6', '10', '7', '20', '0', '0', '0', '0', '0', '0', '87', '10', '0', '0', '0', '0', '21598', '1', '9346', '1', '0', '0'),
('16933', '5', '20', '6', '11', '7', '14', '0', '0', '0', '0', '0', '0', '65', '13', '0', '12', '13', '0', '0', '0', '0', '0', '0', '0'),
('16934', '5', '13', '6', '9', '7', '21', '0', '0', '0', '0', '0', '0', '51', '0', '0', '0', '0', '0', '9397', '1', '0', '0', '0', '0');

[koyle112]

So, now I checked some commands. As you said, I had to start event "155 - Argent dawn @ 1.11". Now I can see quest givers in the chapel of light. I even can complete the T-3 quests. For that thank you but I started every event to see "Anachronos". Hey normalie stays infront The caverns of Time in Tanaris but not in this repack. As I said I started every event on your ID - List but he is not spawning. Damn, what can I do? Yes you said complete the quest with the .quest command but how do I find quest ID's? I mean there are 10000000 quests in the game???? hehe
I saw the command npc add......maybe this could be a solution? but where to find the npc ids? hell yeah!^^

Do .look crea *npc name here*

[brotalnia]

@copiatodo Well those are the old itemization patches, new ones are not really finished yet. I have not looked into itemization patches that much so i can't give you any more advice about it

You can find the latest itemization patches here:
database/progression at master * elysium-project/database * GitHub.

[eisik]

Thank you for this amazing repack.

I've been wanting to create a custom private server for a couple of friends, since like 2014, and with this repack, everything went great. I've been working on my server for around 4 weeks now, with fully custom questlines, npcs, weapons, and gear. I've learned a shit ton of database editing due to errors and problems, but now, I'm stuck and need a helping hand.

I need Eluna or some kind of a lua engine for my server so I can get into scripting custom dungeon and raid bosses. Without this, I won't be able to complete what I got into, and I've tried literally everything. I have no idea why but I cannot get to compile my own core due to some cancer maps/vmaps problems. Is there anything I can do to get lua scripts working on this repack? I'd be so happy if there is anything because I've been searching literally the whole web..

Thanks in advance.

[brotalnia]

Unfortunately the Elysium core does not support lua scripts. You should use the database scripting tables instead. You can script creature behavior in `creature_ai_scripts`. There are also `quest_start_scripts` and `quest_end_scripts` for scripts that run when starting or turning in a quest, `creature_movement_scripts` when a creature reaches a certain waypoint, `spell_scripts` when a certain spell is used, `gossip_scripts` for scripting gossip options, and `event_scripts` for event scripts obviously. You can accomplish quite a bit if you get familiar with the database scripting.

Here is more information about database scripts:
Creature_ai_scripts * cmangos/issues Wiki * GitHub
DBScripts * cmangos/issues Wiki * GitHub
“dbscripts_on_quest_start” table — mangos-zero 0.2.0 documentation

All the scripting tables except `creature_ai_scripts` work the same way and have the same commands.
You can see the exact commands and parameters here:
server/ScriptMgr.h at development * elysium-project/server * GitHub

If you want to script a custom creature using the `creature_ai_scripts` table, don't forget to set column `AIName` to 'EventAI'.

[86kirua]

Thx for ur repack brotalnia

I open my server to play with my friend but after that i wasnt able connect anymore locally to my server (they call that "realmloops").
I fixed it by adding a 2nd line in realmlist with name:Elysium2 address:127.0.0.1 localaddress:127.0.0.1 . ( thx to this post ([MaNGOS] Can't connect to world server via LAN) )
Also now put "set realmlist 127.0.0.1" to your realmlist.wtf to play locally.

Table : realmlist