[DiscordArchive] `player_classlevelstats` its new?
[DiscordArchive] `player_classlevelstats` its new?
Original source
`player_classlevelstats` its new?
rektbyfaith
02-04-2025, 09:51 PM #1Archived author: OUTRAKE • Posted: 2025-02-04T21:51:26.715000+00:00
Original source
`player_classlevelstats` its new?
Original source
On this `e58c9cba422d 2024-09-23 10:31:03 +0000 (master branch) (Win64, RelWithDebInfo, Static)` (old as fuck i know) uses `player_classlevelstats`
rektbyfaith
02-04-2025, 09:54 PM #2Archived author: Ryan Turner • Posted: 2025-02-04T21:54:14.388000+00:00
Original source
On this `e58c9cba422d 2024-09-23 10:31:03 +0000 (master branch) (Win64, RelWithDebInfo, Static)` (old as fuck i know) uses `player_classlevelstats`
Original source
Changed was made here https://github.com/azerothcore/azerothco...7188/files end of 2023
rektbyfaith
02-04-2025, 09:55 PM #3Archived author: Ryan Turner • Posted: 2025-02-04T21:55:04.250000+00:00
Original source
Changed was made here https://github.com/azerothcore/azerothco...7188/files end of 2023
Original source
so the new one is player_class_stats
rektbyfaith
02-04-2025, 09:55 PM #4Archived author: OUTRAKE • Posted: 2025-02-04T21:55:35.009000+00:00
Original source
so the new one is player_class_stats
Original source
why do i have both on a fresh db remains a mistery
rektbyfaith
02-04-2025, 09:56 PM #5Archived author: OUTRAKE • Posted: 2025-02-04T21:56:29.789000+00:00
Original source
why do i have both on a fresh db remains a mistery
Original source
`player_class_stats` is the new one
rektbyfaith
02-04-2025, 09:57 PM #6Archived author: Ryan Turner • Posted: 2025-02-04T21:57:06.888000+00:00
Original source
`player_class_stats` is the new one
Original source
```sql
@@ -0,0 +1,9 @@
ALTER TABLE `player_class_stats`
ADD COLUMN `BaseHP` int unsigned NOT NULL DEFAULT '1' AFTER `Level`,
ADD COLUMN `BaseMana` int unsigned NOT NULL DEFAULT '1' AFTER `BaseHP`;
UPDATE player_class_stats AS noo
JOIN player_classlevelstats AS ole ON noo.Class = ole.class AND noo.Level = ole.level
SET noo.BaseHP = ole.basehp, noo.BaseMana = ole.basemana;
DROP TABLE IF EXISTS `player_classlevelstats`;
```
rektbyfaith
02-04-2025, 09:57 PM #7Archived author: Ryan Turner • Posted: 2025-02-04T21:57:15.643000+00:00
Original source
```sql
@@ -0,0 +1,9 @@
ALTER TABLE `player_class_stats`
ADD COLUMN `BaseHP` int unsigned NOT NULL DEFAULT '1' AFTER `Level`,
ADD COLUMN `BaseMana` int unsigned NOT NULL DEFAULT '1' AFTER `BaseHP`;
UPDATE player_class_stats AS noo
JOIN player_classlevelstats AS ole ON noo.Class = ole.class AND noo.Level = ole.level
SET noo.BaseHP = ole.basehp, noo.BaseMana = ole.basemana;
DROP TABLE IF EXISTS `player_classlevelstats`;
```
Original source
ok, why i get that error on a maxlevel 49 and dk at 55
rektbyfaith
02-04-2025, 09:57 PM #8Archived author: OUTRAKE • Posted: 2025-02-04T21:57:16.801000+00:00
Original source
ok, why i get that error on a maxlevel 49 and dk at 55
Original source
using bench sql
rektbyfaith
02-04-2025, 09:57 PM #9Archived author: OUTRAKE • Posted: 2025-02-04T21:57:29.858000+00:00
Original source
using bench sql
Original source
It should've dropped that old table
rektbyfaith
02-04-2025, 09:57 PM #10Archived author: Ryan Turner • Posted: 2025-02-04T21:57:31.576000+00:00
Original source
It should've dropped that old table