Elysium Core 1.12 Repack - Including MMaps and Optional Vendors

[katavskiy]

The best server. The scripts work great. but there are problems. In Naxxramas one can not revive Tadius. After the murder of his servants. Lightning beats a character, and Tadius just stands. Maybe need 40 players and kill it honestly, but I do not know.

[katavskiy]

Hello. Event of 23 - AQ War Effort (Collector Quests) not work. Event 23 it Darkmoon Faire Building (Elwynn) (TODO). But event id - 100 not work. I enter "lookup event" https://pp.userapi.com/c824500/v8245...yYwNq1YxuU.jpg and AQ War Effort (Collector Quests) does not exist.
.

[fathertorque]

i was wondering about this item Shard of the Defiler - Item - World of Warcraft
people claim that it exists in vanilla. but i cant find any trace for it, i dunno if its a server thing or it just exists in datamining
i remember seeing it in some private server, not sure though if it was original or custom. but i remember using it and it had a chance to transform you into a dreadlord

[katavskiy]

fathertorque look in classicdb. it`s item did not exist in Classic. Maybe it was added to the beta test of the BC

[Scathy]

Can someone help me with a SQL query to restore the GM island vendors from a backup? The vendors as part of the repack have a bunch of stuff, but I ended up adding multiple weapons and gear choices that I would prefer to not add all over again after migrating to the latest repack.

[locario]

Have you got a SQL backup before updating the repack?

[Scathy]

I do. I'm not particularly good at SQL, so I would just want to export the GM island NPCs, then insert them into my latest repack deployment.

[locario]

I'm not expert but i can try

[Scathy]

I'm sure this is a ghetto way of doing this, but if it helps anyone - here's how I restored the GM island vendors from repack v7 to v8 after I added ~100 items to various vendors using .npc add <item no>. I used HeidiSQL for all of this.

-Take a backup of your current working configuration. You can export all of the databases, but I found it easier to just shut down MySQL, then make a copy the entire Mangos directory.
-Load up the original DB that has the custom entries
-The custom vendors are entry ID 90000 - 900025. Select the mangos database, then run query 'select * from npc_vendor where entry>89999' : this will dump only the custom entries that the batch file defines and adds into the database when you kick off the batch file. In the query results pane, select all> right click > Export grid rows > Encoding utf-8/ output format SQL replace/row selection - selection. Give the file a name with a .sql extension.
-Shut down the old database, then load up the new one.
-run the batch file to spawn GM island NPCs if they are not already spawned
-Open HeidiSQL again, then select the mangos database.
-File > Load SQL file > select your exported .sql file from earlier. It should load into the query window.
-Click the play button or press F9 to execute the query.

-Scathy

[fathertorque]

fathertorque look in classicdb. it`s item did not exist in Classic. Maybe it was added to the beta test of the BC

look at this image. the left one is supposed to be the item in vanilla (as they claim). and the one on the right represents the item in WOTLK 3.3.5a as seen in the repack i am using.
but the thing is that it clearly states: transform into echo of archimonde. and this spell in vanilla 1.12 (light hope's repack) if you add it manually, it transforms you into a pig not a dreadlord...

shard of defiler.jpg

[locario]

I'm sure this is a ghetto way of doing this, but if it helps anyone - here's how I restored the GM island vendors from repack v7 to v8 after I added ~100 items to various vendors using .npc add <item no>. I used HeidiSQL for all of this.

-Take a backup of your current working configuration. You can export all of the databases, but I found it easier to just shut down MySQL, then make a copy the entire Mangos directory.
-Load up the original DB that has the custom entries
-The custom vendors are entry ID 90000 - 900025. Select the mangos database, then run query 'select * from npc_vendor where entry>89999' : this will dump only the custom entries that the batch file defines and adds into the database when you kick off the batch file. In the query results pane, select all> right click > Export grid rows > Encoding utf-8/ output format SQL replace/row selection - selection. Give the file a name with a .sql extension.
-Shut down the old database, then load up the new one.
-run the batch file to spawn GM island NPCs if they are not already spawned
-Open HeidiSQL again, then select the mangos database.
-File > Load SQL file > select your exported .sql file from earlier. It should load into the query window.
-Click the play button or press F9 to execute the query.

-Scathy

Is there a chance you share with us the SQL file with vendors items?

Thanks

[Nairanco]

Is there a chance you share with us the SQL file with vendors items?

Thanks

+1

I'm also curious if you have done any vendors for professions/skill leveling and enchants like the Lightbringer PTR had

[locario]

+1

I'm also curious if you have done any vendors for professions/skill leveling and enchants like the Lightbringer PTR had

Brotalnia did it.

Enchants_Professions_Transporter

NPC Id:

20008 - transporter
90029 - professions
90028 - enchants 2
90027 - enchants 1
99900 - transporter to gm island

Cheers

[fathertorque]

i was trying to create custom items via trinity item creator but it doesnt work properly without inserting the database's name, so whats the database's name?
and i wonder if there is another proper way to create custom items for this repack

[xyz1346]

Thank you very much for this, everything works great!