[DiscordArchive] and because its bitmask it would be the interger total of all flags I want kept?
[DiscordArchive] and because its bitmask it would be the interger total of all flags I want kept?
Original source
that sounded bad
rektbyfaith
02-27-2023, 07:26 PM #71Archived author: Jp • Posted: 2023-02-27T19:26:11.149000+00:00
Original source
that sounded bad
Original source
```SELECT `Flags`=`Flags`&~524288 FROM `item_template` WHERE `entry`=<insert-entry-here>;```
Just as I finish the query since I don't know it by heart silly Roboto beats me to it.
rektbyfaith
02-27-2023, 07:26 PM #72Archived author: Revision • Posted: 2023-02-27T19:26:15.254000+00:00
Original source
```SELECT `Flags`=`Flags`&~524288 FROM `item_template` WHERE `entry`=<insert-entry-here>;```
Just as I finish the query since I don't know it by heart silly Roboto beats me to it.
Original source
xxx tells me its an unknown clause? maybe that does'nt work for all items?
rektbyfaith
02-27-2023, 07:27 PM #73Archived author: Jp • Posted: 2023-02-27T19:27:03.490000+00:00
Original source
xxx tells me its an unknown clause? maybe that does'nt work for all items?
Original source
i literally ctrl c and v your line from roboto
rektbyfaith
02-27-2023, 07:27 PM #74Archived author: Jp • Posted: 2023-02-27T19:27:20.818000+00:00
Original source
i literally ctrl c and v your line from roboto
Original source
You replace xxx with the item entry
rektbyfaith
02-27-2023, 07:27 PM #75Archived author: Revision • Posted: 2023-02-27T19:27:25.666000+00:00
Original source
You replace xxx with the item entry
Original source
you need to either replace the `xxx` with your item id or run without the whole `WHERE ...` part to do it for every item like Rymercyble said
rektbyfaith
02-27-2023, 07:27 PM #76Archived author: Roboto • Posted: 2023-02-27T19:27:27.395000+00:00
Original source
you need to either replace the `xxx` with your item id or run without the whole `WHERE ...` part to do it for every item like Rymercyble said
Original source
![[Image: 2x.png?ex=690c4ddf&is=690afc5f&hm=81569a...22e533bed&]](https://cdn.discordapp.com/attachments/284406375495368704/1079847253965025310/2x.png?ex=690c4ddf&is=690afc5f&hm=81569a2bcd9fdfae006a98847b4b9d8a5a5496456e0b7042a620f8922e533bed&)
rektbyfaith
02-27-2023, 07:27 PM #77Archived author: Rymercyble • Posted: 2023-02-27T19:27:28.025000+00:00
Original source
Original source
oh I misunderstand
rektbyfaith
02-27-2023, 07:27 PM #78Archived author: Jp • Posted: 2023-02-27T19:27:31.700000+00:00
Original source
oh I misunderstand
Original source
i thought you said I could update all at once by leaving it as xx
rektbyfaith
02-27-2023, 07:27 PM #79Archived author: Jp • Posted: 2023-02-27T19:27:38.767000+00:00
Original source
i thought you said I could update all at once by leaving it as xx
Original source
xxx
rektbyfaith
02-27-2023, 07:27 PM #80Archived author: Jp • Posted: 2023-02-27T19:27:39.742000+00:00
Original source
xxx
1 Guest(s)
1 Guest(s)