[DiscordArchive] do i need to change something in DB when i want to disable pvp in all areas except cities ?
[DiscordArchive] do i need to change something in DB when i want to disable pvp in all areas except cities ?
Original source
Probably for the case of PvP realms
rektbyfaith
11-08-2022, 10:44 PM #11Archived author: Bench • Posted: 2022-11-08T22:44:14.714000+00:00
Original source
Probably for the case of PvP realms
Original source
yes
rektbyfaith
11-08-2022, 10:44 PM #12Archived author: Rymercyble • Posted: 2022-11-08T22:44:37.774000+00:00
Original source
yes
Original source
if I'm not mistaken, there is an SQL that selects certain data in the Acore_world Table
I need to select all Level 284 Items from the Item_template Table
Can someone help me
rektbyfaith
11-08-2022, 10:49 PM #13Archived author: Marcelo • Posted: 2022-11-08T22:49:28.880000+00:00
Original source
if I'm not mistaken, there is an SQL that selects certain data in the Acore_world Table
I need to select all Level 284 Items from the Item_template Table
Can someone help me
Original source
more or less that
SELECT from item_template SET ItemLevel = WHERE "284%";
rektbyfaith
11-08-2022, 10:49 PM #14Archived author: Marcelo • Posted: 2022-11-08T22:49:50.605000+00:00
Original source
more or less that
SELECT from item_template SET ItemLevel = WHERE "284%";
Original source
```sql
SELECT * FROM `item_template` WHERE `ItemLevel` = 284;
```
rektbyfaith
11-08-2022, 10:51 PM #15Archived author: Kitzunu • Posted: 2022-11-08T22:51:17.447000+00:00
Original source
```sql
SELECT * FROM `item_template` WHERE `ItemLevel` = 284;
```
Original source
thanks
rektbyfaith
11-08-2022, 10:51 PM #16Archived author: Marcelo • Posted: 2022-11-08T22:51:28.977000+00:00
Original source
thanks
Original source
That worked perfectly ty very much. I want to go through and edit the groups of enemies in the starter areas to match the hostility that was present in Vanilla -TBC.
rektbyfaith
11-08-2022, 11:01 PM #17Archived author: RIVEIR • Posted: 2022-11-08T23:01:24.914000+00:00
Original source
That worked perfectly ty very much. I want to go through and edit the groups of enemies in the starter areas to match the hostility that was present in Vanilla -TBC.
Original source
I'd recommend going through a vanilla emulator like vmangos and grab their faction values, since those are sniffed from vanilla/classic
rektbyfaith
11-08-2022, 11:01 PM #18Archived author: Bench • Posted: 2022-11-08T23:01:54.363000+00:00
Original source
I'd recommend going through a vanilla emulator like vmangos and grab their faction values, since those are sniffed from vanilla/classic
Original source
<@391764207034695691> make them all hostile and level 60 elites, and turn on Ironman Mode.
rektbyfaith
11-08-2022, 11:01 PM #19Archived author: Michael Crilly • Posted: 2022-11-08T23:01:57.880000+00:00
Original source
<@391764207034695691> make them all hostile and level 60 elites, and turn on Ironman Mode.
Original source
Haha a little follow up to our conversation yesterday I see. Well played indeed.
rektbyfaith
11-08-2022, 11:02 PM #20Archived author: RIVEIR • Posted: 2022-11-08T23:02:49.283000+00:00
Original source
Haha a little follow up to our conversation yesterday I see. Well played indeed.