Forums WoW Modding Support Archives WoWModding Support Archives [DiscordArchive] We have any mysql experts in here? I'm trying to create a select statement that returns every `entry

[DiscordArchive] We have any mysql experts in here? I'm trying to create a select statement that returns every `entry

[DiscordArchive] We have any mysql experts in here? I'm trying to create a select statement that returns every `entry

rektbyfaith
Administrator
0
09-18-2021, 12:36 PM
#1
Archived author: ReynoldsCahoon • Posted: 2021-09-18T12:36:21.410000+00:00
Original source

We have any mysql experts in here? I'm trying to create a select statement that returns every `entry` in the `item_template` table, with each `spellid_1, spellid_2, spellid_3, spellid_4, spellid_5` separated into it's own row under a unified `spellid` column. Anyone have any idea how I'd accomplish that?
rektbyfaith
09-18-2021, 12:36 PM #1

Archived author: ReynoldsCahoon • Posted: 2021-09-18T12:36:21.410000+00:00
Original source

We have any mysql experts in here? I'm trying to create a select statement that returns every `entry` in the `item_template` table, with each `spellid_1, spellid_2, spellid_3, spellid_4, spellid_5` separated into it's own row under a unified `spellid` column. Anyone have any idea how I'd accomplish that?

rektbyfaith
Administrator
0
09-18-2021, 12:36 PM
#2
Archived author: -Jan- • Posted: 2021-09-18T12:36:35.751000+00:00
Original source

I dont really i returned to Moding after few years... there is alot of gaps ill try to find it and tell you
rektbyfaith
09-18-2021, 12:36 PM #2

Archived author: -Jan- • Posted: 2021-09-18T12:36:35.751000+00:00
Original source

I dont really i returned to Moding after few years... there is alot of gaps ill try to find it and tell you

rektbyfaith
Administrator
0
09-18-2021, 12:38 PM
#3
Archived author: -Jan- • Posted: 2021-09-18T12:38:52.173000+00:00
Original source

Right so... you have to create waypoints int the waypoints table and its related tables ofc and than add the ID of that waypoint to the creature in creature table
rektbyfaith
09-18-2021, 12:38 PM #3

Archived author: -Jan- • Posted: 2021-09-18T12:38:52.173000+00:00
Original source

Right so... you have to create waypoints int the waypoints table and its related tables ofc and than add the ID of that waypoint to the creature in creature table

rektbyfaith
Administrator
0
09-18-2021, 12:56 PM
#4
Archived author: ayahne • Posted: 2021-09-18T12:56:28.493000+00:00
Original source

Looking for help someone know the steps i need to take before slash m2 into converter? the problem is something overwrite actual globalsequences and im not sure how i can menage to fix that (if needed i can pay for help)
https://gyazo.com/b9b60523a03fd0bb95c6537883f7e615
[Embed: Gyazo]
https://gyazo.com/b9b60523a03fd0bb95c6537883f7e615
rektbyfaith
09-18-2021, 12:56 PM #4

Archived author: ayahne • Posted: 2021-09-18T12:56:28.493000+00:00
Original source

Looking for help someone know the steps i need to take before slash m2 into converter? the problem is something overwrite actual globalsequences and im not sure how i can menage to fix that (if needed i can pay for help)
https://gyazo.com/b9b60523a03fd0bb95c6537883f7e615
[Embed: Gyazo]
https://gyazo.com/b9b60523a03fd0bb95c6537883f7e615

Recently Browsing
 1 Guest(s)
Recently Browsing
 1 Guest(s)