[DiscordArchive] A MySQL trigger?
[DiscordArchive] A MySQL trigger?
Original source
A MySQL trigger?
rektbyfaith
05-05-2025, 10:21 PM #1Archived author: metallinos • Posted: 2025-05-05T22:21:29.419000+00:00
Original source
A MySQL trigger?
Original source
What exactly is it you want to do with AIO? Display your fusioncms store in something like https://github.com/Foereaper/Eluna-AIO-StoreSystem ?
rektbyfaith
05-05-2025, 10:22 PM #2Archived author: metallinos • Posted: 2025-05-05T22:22:51.161000+00:00
Original source
What exactly is it you want to do with AIO? Display your fusioncms store in something like https://github.com/Foereaper/Eluna-AIO-StoreSystem ?
Original source
exactly but I don't know where to start
rektbyfaith
05-05-2025, 10:26 PM #3Archived author: MTSURUGY⚡DEV • Posted: 2025-05-05T22:26:37.215000+00:00
Original source
exactly but I don't know where to start
Original source
Is the idea to sell the same items in-game as on the website? What's the point of having two stores with the same items?
rektbyfaith
05-05-2025, 10:27 PM #4Archived author: metallinos • Posted: 2025-05-05T22:27:59.123000+00:00
Original source
Is the idea to sell the same items in-game as on the website? What's the point of having two stores with the same items?
Original source
I just want the points acquired on the website to appear in the game store just like gold does.
rektbyfaith
05-05-2025, 10:29 PM #5Archived author: MTSURUGY⚡DEV • Posted: 2025-05-05T22:29:12.772000+00:00
Original source
I just want the points acquired on the website to appear in the game store just like gold does.
Original source
Make a MySQL trigger that updates from one db (fusioncms) to the char db or account db under a new table of you preference (e.g., "account_currencies") then run an authdbquery or chardbquery, depending on your db of choice, on login to cache the value to the player's guid/account's guid on login, store it with a chardbexecute or authdbexecute on logout, and cache it in between
rektbyfaith
05-05-2025, 10:30 PM #6Archived author: metallinos • Posted: 2025-05-05T22:30:56.248000+00:00
Original source
Make a MySQL trigger that updates from one db (fusioncms) to the char db or account db under a new table of you preference (e.g., "account_currencies") then run an authdbquery or chardbquery, depending on your db of choice, on login to cache the value to the player's guid/account's guid on login, store it with a chardbexecute or authdbexecute on logout, and cache it in between
Original source
Or better yet, change your fusioncms code to just store the account currencies balance directly in the char or auth db so you won't have to rely on triggers updating the databases back and forth
rektbyfaith
05-05-2025, 10:32 PM #7Archived author: metallinos • Posted: 2025-05-05T22:32:08.853000+00:00
Original source
Or better yet, change your fusioncms code to just store the account currencies balance directly in the char or auth db so you won't have to rely on triggers updating the databases back and forth
Original source
theory of connecting an ab store sql tablet to the website's db accounts tablet but I have no idea how to do this
rektbyfaith
05-05-2025, 10:32 PM #8Archived author: MTSURUGY⚡DEV • Posted: 2025-05-05T22:32:49.185000+00:00
Original source
theory of connecting an ab store sql tablet to the website's db accounts tablet but I have no idea how to do this
Original source
The simplest way is a MySQL trigger
rektbyfaith
05-05-2025, 10:33 PM #9Archived author: metallinos • Posted: 2025-05-05T22:33:20.888000+00:00
Original source
The simplest way is a MySQL trigger
Original source
yes but I'm completely noob in sql
rektbyfaith
05-05-2025, 10:33 PM #10Archived author: MTSURUGY⚡DEV • Posted: 2025-05-05T22:33:52.447000+00:00
Original source
yes but I'm completely noob in sql
1 Guest(s)
1 Guest(s)