[DiscordArchive] Are you planning to trigger it yourself for each character?
[DiscordArchive] Are you planning to trigger it yourself for each character?
Original source
Or item_instance table rather
rektbyfaith
01-24-2022, 06:50 PM #21Archived author: Bench • Posted: 2022-01-24T18:50:52.175000+00:00
Original source
Or item_instance table rather
Original source
That should like a huge pain to manually copy :p
rektbyfaith
01-24-2022, 06:52 PM #22Archived author: Revision • Posted: 2022-01-24T18:52:05.769000+00:00
Original source
That should like a huge pain to manually copy :p
Original source
You are very correct
rektbyfaith
01-24-2022, 06:52 PM #23Archived author: Bench • Posted: 2022-01-24T18:52:48.627000+00:00
Original source
You are very correct
Original source
That's why I'm asking here after having done one lol
rektbyfaith
01-24-2022, 06:53 PM #24Archived author: Bench • Posted: 2022-01-24T18:53:00.561000+00:00
Original source
That's why I'm asking here after having done one lol
Original source
Well as long as your + isn't equal to a value that's already existing, it's fine.
rektbyfaith
01-24-2022, 06:54 PM #25Archived author: Revision • Posted: 2022-01-24T18:54:02.954000+00:00
Original source
Well as long as your + isn't equal to a value that's already existing, it's fine.
Original source
So what would the query look like? Because I think what I've got
```INSERT INTO ac_characters.characters SELECT guid+120 FROM tc_characters.characters;```
is wrong
rektbyfaith
01-24-2022, 07:02 PM #26Archived author: Bench • Posted: 2022-01-24T19:02:47.318000+00:00
Original source
So what would the query look like? Because I think what I've got
```INSERT INTO ac_characters.characters SELECT guid+120 FROM tc_characters.characters;```
is wrong
Original source
i made a lua script to sort guid's for items ages ago. maybe you can use this as a template.
<https://github.com/55Honey/Acore_Sortmachine>
rektbyfaith
01-24-2022, 07:05 PM #27Archived author: Honey • Posted: 2022-01-24T19:05:30.041000+00:00
Original source
i made a lua script to sort guid's for items ages ago. maybe you can use this as a template.
<https://github.com/55Honey/Acore_Sortmachine>
Original source
you have to include column names both for the insert and the select, and the select should be within ()
rektbyfaith
01-24-2022, 07:51 PM #28Archived author: Revision • Posted: 2022-01-24T19:51:54.749000+00:00
Original source
you have to include column names both for the insert and the select, and the select should be within ()
Original source
like INSERT INTO database.table (column1, column2, column3) VALUES (SELECT guid+120, column2, column3 from database.table)
rektbyfaith
01-24-2022, 07:52 PM #29Archived author: Revision • Posted: 2022-01-24T19:52:35.422000+00:00
Original source
like INSERT INTO database.table (column1, column2, column3) VALUES (SELECT guid+120, column2, column3 from database.table)
Original source
Hmm, tells me I should check my syntax
rektbyfaith
01-24-2022, 08:09 PM #30Archived author: Bench • Posted: 2022-01-24T20:09:58.799000+00:00
Original source
Hmm, tells me I should check my syntax
1 Guest(s)
1 Guest(s)