[DiscordArchive] Hard coding?
[DiscordArchive] Hard coding?
Original source
This is the one: https://github.com/tkn963/mod-groupquest...mplate.sql
rektbyfaith
08-31-2022, 10:21 PM #11Archived author: Revision • Posted: 2022-08-31T22:21:40.504000+00:00
Original source
This is the one: https://github.com/tkn963/mod-groupquest...mplate.sql
Original source
You can also see the queries there that I used
rektbyfaith
08-31-2022, 10:21 PM #12Archived author: Revision • Posted: 2022-08-31T22:21:47.543000+00:00
Original source
You can also see the queries there that I used
Original source
shame theres no way to slow it some so it doesnt implode
rektbyfaith
08-31-2022, 10:24 PM #13Archived author: Ĝ̷̳r̸̹͊a̷̜̚k̴̞̔ • Posted: 2022-08-31T22:24:09.440000+00:00
Original source
shame theres no way to slow it some so it doesnt implode
Original source
If SQL used more than 1 thread per query, it would be ok.
rektbyfaith
08-31-2022, 10:24 PM #14Archived author: Revision • Posted: 2022-08-31T22:24:43.448000+00:00
Original source
If SQL used more than 1 thread per query, it would be ok.
Original source
Since it's always same value can't u just so it as 1 query ?
```
UPDATE `item_template` SET `Flags`=2048 WHERE `entry` IN (725, 726, ....);
```
rektbyfaith
08-31-2022, 10:24 PM #15Archived author: Rymercyble • Posted: 2022-08-31T22:24:55.425000+00:00
Original source
Since it's always same value can't u just so it as 1 query ?
```
UPDATE `item_template` SET `Flags`=2048 WHERE `entry` IN (725, 726, ....);
```
Original source
That was the old stuff
rektbyfaith
08-31-2022, 10:25 PM #16Archived author: Revision • Posted: 2022-08-31T22:25:02.580000+00:00
Original source
That was the old stuff
Original source
before I started doing Flags=Flags|2048
rektbyfaith
08-31-2022, 10:25 PM #17Archived author: Revision • Posted: 2022-08-31T22:25:08.892000+00:00
Original source
before I started doing Flags=Flags|2048
Original source
I was still fairly new to SQL at that point
rektbyfaith
08-31-2022, 10:25 PM #18Archived author: Revision • Posted: 2022-08-31T22:25:14.896000+00:00
Original source
I was still fairly new to SQL at that point
Original source
You could do it, yes, but I wanted to split it up like this since I'm adding stuff as I go and it makes it easier to read for me.
rektbyfaith
08-31-2022, 10:25 PM #19Archived author: Revision • Posted: 2022-08-31T22:25:44.963000+00:00
Original source
You could do it, yes, but I wanted to split it up like this since I'm adding stuff as I go and it makes it easier to read for me.
Original source
¯\_(ツ)_/¯
rektbyfaith
08-31-2022, 10:26 PM #20Archived author: Rymercyble • Posted: 2022-08-31T22:26:36.253000+00:00
Original source
¯\_(ツ)_/¯
1 Guest(s)
1 Guest(s)