[DiscordArchive] Hi guys i wanted to ask you about some stuff what i´ve noticed. When the server is running days and
[DiscordArchive] Hi guys i wanted to ask you about some stuff what i´ve noticed. When the server is running days and
Original source
Hi guys i wanted to ask you about some stuff what i´ve noticed. When the server is running days and nights, and you try to update some item like for example from leather to cloth, then it can happen that the server doesn´t take the changes after a few restarts and 10000 times delete cache from the client. What could be the problem there ?
rektbyfaith
12-20-2024, 10:43 PM #1Archived author: cyberpro98 • Posted: 2024-12-20T22:43:31.136000+00:00
Original source
Hi guys i wanted to ask you about some stuff what i´ve noticed. When the server is running days and nights, and you try to update some item like for example from leather to cloth, then it can happen that the server doesn´t take the changes after a few restarts and 10000 times delete cache from the client. What could be the problem there ?
Original source
How long the server is up for is completely irrelevant
rektbyfaith
12-20-2024, 11:02 PM #2Archived author: Revision • Posted: 2024-12-20T23:02:19.345000+00:00
Original source
How long the server is up for is completely irrelevant
Original source
Certain columns for items are enforced unless you disable it in worldserver.conf so it'll just reset it to the dbc value on startup.
rektbyfaith
12-20-2024, 11:02 PM #3Archived author: Revision • Posted: 2024-12-20T23:02:55.415000+00:00
Original source
Certain columns for items are enforced unless you disable it in worldserver.conf so it'll just reset it to the dbc value on startup.
Original source
<https://github.com/azerothcore/azerothcore-wotlk/blob/08d5861a519a0dc85269f76458b55dbcb77bcda0/src/server/apps/worldserver/worldserver.conf.dist#L2657>
rektbyfaith
12-20-2024, 11:03 PM #4Archived author: Revision • Posted: 2024-12-20T23:03:55.694000+00:00
Original source
<https://github.com/azerothcore/azerothcore-wotlk/blob/08d5861a519a0dc85269f76458b55dbcb77bcda0/src/server/apps/worldserver/worldserver.conf.dist#L2657>
Original source
oh okay because in DB I have added :
```js
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `VerifiedBuild`) VALUES (600070, 4, 1, -1, 'Secular Plague Scientist\'s Boots', 269876, 5, 8, 0, 1, 403272, 80654, 8, 128, -1, 300, 80, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 5, 45, 175, 7, 128, 5, 128, 36, 112, 32, 92, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 2, 0, 2, 0, 0, 0, 429, 0, 375, 0, 0, 0, 0, '', 68, 0, 0, 0, 0, 11159);
```
rektbyfaith
12-20-2024, 11:25 PM #5Archived author: cyberpro98 • Posted: 2024-12-20T23:25:15.975000+00:00
Original source
oh okay because in DB I have added :
```js
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `duration`, `ItemLimitCategory`, `HolidayId`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`, `flagsCustom`, `VerifiedBuild`) VALUES (600070, 4, 1, -1, 'Secular Plague Scientist\'s Boots', 269876, 5, 8, 0, 1, 403272, 80654, 8, 128, -1, 300, 80, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 5, 45, 175, 7, 128, 5, 128, 36, 112, 32, 92, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, -1, 0, -1, 0, 1, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 1, '', 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 2, 0, 2, 0, 0, 0, 429, 0, 375, 0, 0, 0, 0, '', 68, 0, 0, 0, 0, 11159);
```
Original source
I understand what is the problem now, i modified many items in DB but i didn´t make a patch for them because they´re custom ....
rektbyfaith
12-20-2024, 11:27 PM #6Archived author: cyberpro98 • Posted: 2024-12-20T23:27:02.895000+00:00
Original source
I understand what is the problem now, i modified many items in DB but i didn´t make a patch for them because they´re custom ....
Original source
You never mentioned custom items, you just said modifying items (fair assumption would be *existing* items).
rektbyfaith
12-20-2024, 11:31 PM #7Archived author: Revision • Posted: 2024-12-20T23:31:18.749000+00:00
Original source
You never mentioned custom items, you just said modifying items (fair assumption would be *existing* items).
Original source
Well i do have even custom items but strangely in last time since the updates i did to the core from azerothcore github it started in this way
rektbyfaith
12-20-2024, 11:51 PM #8Archived author: cyberpro98 • Posted: 2024-12-20T23:51:54.953000+00:00
Original source
Well i do have even custom items but strangely in last time since the updates i did to the core from azerothcore github it started in this way
Original source
I managed to fix things, it was simply changing the password(s) in the existing database and (re)building the containers with the new password environment variable set
rektbyfaith
12-20-2024, 11:57 PM #9Archived author: Erwin • Posted: 2024-12-20T23:57:03.066000+00:00
Original source
I managed to fix things, it was simply changing the password(s) in the existing database and (re)building the containers with the new password environment variable set
1 Guest(s)
1 Guest(s)