[DiscordArchive] A MySQL trigger?
[DiscordArchive] A MySQL trigger?
Original source
I know I can edit something but I don't really understand what
rektbyfaith
05-05-2025, 10:50 PM #31Archived author: MTSURUGY⚡DEV • Posted: 2025-05-05T22:50:52.901000+00:00
Original source
I know I can edit something but I don't really understand what
Original source
None of these Lua files will help you connect the information you need, what you need is a MySQL trigger, not a Lua script
rektbyfaith
05-05-2025, 10:51 PM #32Archived author: metallinos • Posted: 2025-05-05T22:51:21.347000+00:00
Original source
None of these Lua files will help you connect the information you need, what you need is a MySQL trigger, not a Lua script
Original source
Well, I'll have to stuff it but I don't know how to do that.
rektbyfaith
05-05-2025, 10:52 PM #33Archived author: MTSURUGY⚡DEV • Posted: 2025-05-05T22:52:40.926000+00:00
Original source
Well, I'll have to stuff it but I don't know how to do that.
Original source
https://chat.mistral.ai/chat?q=make%20me...0fusioncms
rektbyfaith
05-05-2025, 10:53 PM #34Archived author: metallinos • Posted: 2025-05-05T22:53:30.274000+00:00
Original source
https://chat.mistral.ai/chat?q=make%20me...0fusioncms
Original source
Hopefully Mistral can help you out, there's a few approaches that all lead to the same end result so it's up to you to find which way you want to link the information, and once you have it in a database that Eluna can interact with, we can look into adjusting the scripts to get the info readily available in-game
rektbyfaith
05-05-2025, 10:54 PM #35Archived author: metallinos • Posted: 2025-05-05T22:54:53.647000+00:00
Original source
Hopefully Mistral can help you out, there's a few approaches that all lead to the same end result so it's up to you to find which way you want to link the information, and once you have it in a database that Eluna can interact with, we can look into adjusting the scripts to get the info readily available in-game
Original source
I was looking and I really appreciate the help, in my head it doesn't make sense.
The information that the online store takes is from the character DB because it is the gold. What I want is that in the same way that it goes to the character DB, I want it to also go to the account_data of fusioncms to get the values of the points.
rektbyfaith
05-05-2025, 11:04 PM #36Archived author: MTSURUGY⚡DEV • Posted: 2025-05-05T23:04:01.156000+00:00
Original source
I was looking and I really appreciate the help, in my head it doesn't make sense.
The information that the online store takes is from the character DB because it is the gold. What I want is that in the same way that it goes to the character DB, I want it to also go to the account_data of fusioncms to get the values of the points.
Original source
When you say online store, do you mean eluna store or fusioncms store?
rektbyfaith
05-05-2025, 11:09 PM #37Archived author: metallinos • Posted: 2025-05-05T23:09:27.281000+00:00
Original source
When you say online store, do you mean eluna store or fusioncms store?
Original source
eluna store
rektbyfaith
05-05-2025, 11:16 PM #38Archived author: MTSURUGY⚡DEV • Posted: 2025-05-05T23:16:00.688000+00:00
Original source
eluna store
Original source
Here's a quick mock-up of how my suggested approach will work:
1. Your MySQL server consists of these 4 primary databases (fusioncms, auth, char, world)
2. AzerothCore, and by extension Eluna, can only communicate to its native three databases (auth, char, world)
3. FusionCMS stores account currency (VP, DP) data in its own database
4. You can set up a trigger to *synchronize* a table with this information between database fusioncms and any other database of your choice. It doesn't matter which. It can be either of the other three databases, as Eluna can access it. But seeing as it's stored per account in fusioncms, acore_auth makes most sense to use.
5. Then, in your Lua scripts, you query the newly created account_data table in whichever database you chose to retrieve updated information, synced with the website
![[Image: image.png?ex=690bdab3&is=690a8933&hm=e21...859b41727&]](https://cdn.discordapp.com/attachments/448835144564867094/1369090297996509305/image.png?ex=690bdab3&is=690a8933&hm=e2163f6beb2a9870666d5bd18aac68efdffd735b4315b70d47137a8859b41727&)
rektbyfaith
05-05-2025, 11:16 PM #39Archived author: metallinos • Posted: 2025-05-05T23:16:03.607000+00:00
Original source
Here's a quick mock-up of how my suggested approach will work:
1. Your MySQL server consists of these 4 primary databases (fusioncms, auth, char, world)
2. AzerothCore, and by extension Eluna, can only communicate to its native three databases (auth, char, world)
3. FusionCMS stores account currency (VP, DP) data in its own database
4. You can set up a trigger to *synchronize* a table with this information between database fusioncms and any other database of your choice. It doesn't matter which. It can be either of the other three databases, as Eluna can access it. But seeing as it's stored per account in fusioncms, acore_auth makes most sense to use.
5. Then, in your Lua scripts, you query the newly created account_data table in whichever database you chose to retrieve updated information, synced with the website
Original source
A MySQL trigger is a script that runs in your MySQL server, hence why it's in the mysql server box
rektbyfaith
05-05-2025, 11:17 PM #40Archived author: metallinos • Posted: 2025-05-05T23:17:21.447000+00:00
Original source
A MySQL trigger is a script that runs in your MySQL server, hence why it's in the mysql server box
1 Guest(s)
1 Guest(s)