[Requests] Troubleshooter

diablo2x

diablo2x

What is cheating?
Joined
Apr 28, 2020
Messages
2
petrock107 said:
I've figured out how to edit most things using too SQLite DB browser like exp,lvl, class lvl, items, money. But I cannot figure out how to edit masteries. I know they are located in the "companypropertymaster" section but I do not how to add masteries because there are many different types of entries and I think the in game mastery name is different from the save file mastery id. Does anyone have any tips?
I don't know how to add new mastery too,
but I know how to edit amounts of masteries.

In the "companyPropertyMaster",
the entry of mastery amount is "Mastery/mastery name/amount"
 
Y

yhawkz

Expert Cheater
Joined
Mar 3, 2017
Messages
57
acecel said:
About the game crashing when you load a save, i found a way to avoid it :
Load a save that your game accept (a copy of an old save),
Start the game, load the save
Then go back to title menu,
Then replace the save with the one you want to use,
Then load the save again in the game (without closing it), and voila it will always works :)

Edit : and delete the "cache client" file in Documents folder.
bro do you know why i can't delete the save at the main menu?
it suddenly give me error thing when i delete the save file, it says the file was used by the game. itnever happened before

thanks
 
X

XLordShadow45X

Noobzor
Joined
Apr 12, 2020
Messages
8
diablo2x said:
petrock107 said:
I've figured out how to edit most things using too SQLite DB browser like exp,lvl, class lvl, items, money. But I cannot figure out how to edit masteries. I know they are located in the "companypropertymaster" section but I do not how to add masteries because there are many different types of entries and I think the in game mastery name is different from the save file mastery id. Does anyone have any tips?
I don't know how to add new mastery too,
but I know how to edit amounts of masteries.

In the "companyPropertyMaster",
the entry of mastery amount is "Mastery/mastery name/amount"

Hi there,
I found the mastery entries. But I don't see any editable numbers. Only the text.
How do you change the value of the amount?
Do you add a number after 'amount'? Or do you replace the word 'amount' with the number you need?
It would be great if you could shed some light on this one.
Thanks!
 
V

variante

Expert Cheater
Joined
Mar 4, 2017
Messages
60
This SQL script modifies all mastery amounts to 9999, across all companies. Has been working so far.
Code:
<i>
</i>update companyProperty
set cpValue = 9999
where masterIndex in (select masterIndex from companyPropertyMaster where masterName like '%Amount')
 
X

XLordShadow45X

Noobzor
Joined
Apr 12, 2020
Messages
8
variante said:
This SQL script modifies all mastery amounts to 9999, across all companies. Has been working so far.
Code:
<i>
</i>update companyProperty
set cpValue = 9999
where masterIndex in (select masterIndex from companyPropertyMaster where masterName like '%Amount')
Ahh, now I understand.
I thought that the values could be modified without any scripts.
Well, I should have known better.
Thank you for the fast reply! :)
 
V

variante

Expert Cheater
Joined
Mar 4, 2017
Messages
60
XLordShadow45X said:
Ahh, now I understand.
I thought that the values could be modified without any scripts.
Well, I should have known better.
Thank you for the fast reply! :)
You can actually edit the data row directly without script. This script I only created to make the job easier.
 
M

MatthewD

Cheater
Joined
Dec 26, 2019
Messages
27
For someone whom has never done this before and has 0 idea about codes and scripting, it's hard to edit the data, especially if you have to find multiple values. Thank you for the script.
 
A

acecel

Expert Cheater
Joined
Apr 9, 2017
Messages
411
yhawkz said:
acecel said:
About the game crashing when you load a save, i found a way to avoid it :
Load a save that your game accept (a copy of an old save),
Start the game, load the save
Then go back to title menu,
Then replace the save with the one you want to use,
Then load the save again in the game (without closing it), and voila it will always works :)

Edit : and delete the "cache client" file in Documents folder.
bro do you know why i can't delete the save at the main menu?
it suddenly give me error thing when i delete the save file, it says the file was used by the game. itnever happened before

thanks
I never had this issue and i don't understand why it happen, so i don't know, sorry :-(
 
P

petrock107

Noobzor
Joined
Mar 20, 2020
Messages
8
yhawkz said:
acecel said:
About the game crashing when you load a save, i found a way to avoid it :
Load a save that your game accept (a copy of an old save),
Start the game, load the save
Then go back to title menu,
Then replace the save with the one you want to use,
Then load the save again in the game (without closing it), and voila it will always works :)

Edit : and delete the "cache client" file in Documents folder.
bro do you know why i can't delete the save at the main menu?
it suddenly give me error thing when i delete the save file, it says the file was used by the game. itnever happened before

thanks

You don't delete the save, you copy and paste your "broken" save over the working one. At least that's how it works for me.
 
P

petrock107

Noobzor
Joined
Mar 20, 2020
Messages
8
variante said:
This SQL script modifies all mastery amounts to 9999, across all companies. Has been working so far.
Code:
<i>
</i>update companyProperty
set cpValue = 9999
where masterIndex in (select masterIndex from companyPropertyMaster where masterName like '%Amount')
Thanks for the script. Do you know of any way to add mastery that you haven't unlocked/found yet? It seems this script will only modify amounts of mastery you already have. I tried adding new entries to the db such as mastery/"mastery name"/amount but noticed the mastery names are not always the same in the db as they are in game. For example, counterattack mastery is called BladeParry in the db. Is there anyway to find a list of mastery IDs for the db?
 
A

archiloque

What is cheating?
Joined
Mar 28, 2020
Messages
4
yhawkz said:
acecel said:
About the game crashing when you load a save, i found a way to avoid it :
Load a save that your game accept (a copy of an old save),
Start the game, load the save
Then go back to title menu,
Then replace the save with the one you want to use,
Then load the save again in the game (without closing it), and voila it will always works :)

Edit : and delete the "cache client" file in Documents folder.
bro do you know why i can't delete the save at the main menu?
it suddenly give me error thing when i delete the save file, it says the file was used by the game. itnever happened before

thanks
Happened to me once, what I did was disconnect my internet, somehow the game process was using the save while internet was connected. Disconnect and you can replace your save no problem, then reconnect whenever you want.
 
M

Maalik

Noobzor
Joined
Mar 6, 2017
Messages
10
I'll add here the mastery names and masterindex that I have unlocked so far. If you guys have any that's not included, please share ^^

1 Base_Title
2 Text
3 BodyTraining
6 FairWind
7 Swordmaster
8 Deftness
12 ElectricShock
13 Magician
14 TacticalSense
16 Aggression
21 CounterAttack
22 Alacrity
24 Forestallment
28 PositiveMind
30 TacticalEnvelopment
34 Yearning
36 Sunglasses
38 Learning
40 PangOfConscience
42 Supporter
46 Understanding
50 BladeParry
58 SpellStrike
59 MagicTheory
60 Insight
65 SharpBlade
72 Bloodlet
73 BoundingStride
75 MagicAcceleration
76 SoCloseYetFar
78 Bladestorm
80 HighSpeed
81 Challenger
84 InnerFlame
85 LightningReflexes
86 OneByOne
87 RagingFlame
88 ConversionOfEnergy
89 RoaringBlaze
90 OpportunityStrikes
97 WeaponBlocking
98 Bruise
99 CleanHit
101 Lightningmage
104 SlashInjury
105 MagicResonance
106 BloodScent
108 Archmage
112 CloseCombatant
113 ElectricPulse
115 Parry
119 BladeEvasion
120 MuscleTraining
122 RedThornSword
124 Willpower
125 BurnSoul
127 DrainSoul
133 MyDreamIsHero
134 Fellowship
135 Shaman
137 Abundance
142 HealingWave
144 SoulHealer
145 WindRush
148 MagicReactor
153 SpellAbsorbing
158 HuntingDog
159 Hemorrhage
160 CursedSword
163 WoundInfection
176 FinalBlow
178 HeavyStrike
181 WillToSurvive
182 SpellPowerOfCrack
185 VindictiveSpirit
189 AcutePain
190 ShadowZone
223 Bloodthirst
228 Windmage
 
V

variante

Expert Cheater
Joined
Mar 4, 2017
Messages
60
Maalik said:
I'll add here the mastery names and masterindex that I have unlocked so far. If you guys have any that's not included, please share ^^

1 Base_Title
2 Text
3 BodyTraining
6 FairWind
7 Swordmaster
8 Deftness
12 ElectricShock
13 Magician
14 TacticalSense
16 Aggression
21 CounterAttack
22 Alacrity
24 Forestallment
28 PositiveMind
30 TacticalEnvelopment
34 Yearning
36 Sunglasses
38 Learning
40 PangOfConscience
42 Supporter
46 Understanding
50 BladeParry
58 SpellStrike
59 MagicTheory
60 Insight
65 SharpBlade
72 Bloodlet
73 BoundingStride
75 MagicAcceleration
76 SoCloseYetFar
78 Bladestorm
80 HighSpeed
81 Challenger
84 InnerFlame
85 LightningReflexes
86 OneByOne
87 RagingFlame
88 ConversionOfEnergy
89 RoaringBlaze
90 OpportunityStrikes
97 WeaponBlocking
98 Bruise
99 CleanHit
101 Lightningmage
104 SlashInjury
105 MagicResonance
106 BloodScent
108 Archmage
112 CloseCombatant
113 ElectricPulse
115 Parry
119 BladeEvasion
120 MuscleTraining
122 RedThornSword
124 Willpower
125 BurnSoul
127 DrainSoul
133 MyDreamIsHero
134 Fellowship
135 Shaman
137 Abundance
142 HealingWave
144 SoulHealer
145 WindRush
148 MagicReactor
153 SpellAbsorbing
158 HuntingDog
159 Hemorrhage
160 CursedSword
163 WoundInfection
176 FinalBlow
178 HeavyStrike
181 WillToSurvive
182 SpellPowerOfCrack
185 VindictiveSpirit
189 AcutePain
190 ShadowZone
223 Bloodthirst
228 Windmage
The masterIndex is not the same as mastery ID, it is just there for data governance in relational database. It doesn't really mean anything outside of the database itself. For example, here's mine, I've manually added many entries by just incrementing masterIndex off the latest one. Btw, the "masteryMaster" table is for equipped masteries. To change the equip status (on/off + which mastery board), do it in "mastery" table.
Code:
<i>
</i>1	Base_Title
2	Text
3	BodyTraining
5	CounterAttack
6	Swordmaster
7	Yearning
8	PositiveMind
9	Forestallment
11	FairWind
13	ElectricShock
14	Magician
15	TacticalSense
17	PangOfConscience
18	BoundingStride
19	Lightningmage
21	DrainSoul
23	Bladestorm
24	MuscleTraining
26	Learning
27	Alacrity
29	InnerFlame
30	LightningReflexes
31	OneByOne
32	RagingFlame
36	FireBolt
38	Berserker
39	CloseCombatant
40	Bruise
42	Understanding
43	ImpulseFields
44	Consideration
45	WindRush
48	IndomitableWill
49	Insight
50	Deftness
51	OpportunityStrikes
55	Fellowship
56	Shaman
59	HighSpeed
62	HeavyStrike
64	FinalBlow
66	HealingWave
67	SoulHealer
74	RedThornSword
75	Bloodlet
80	Retribution
81	ToughSpirit
82	SlashInjury
88	VictoryShout
91	MyDreamIsHero
92	BlessOfRegeneration
94	OriginOfLife
95	OneShotOneKill
99	Aggression
101	ConcentratedFire
103	LonelyWolf
106	ShadowZone
107	SoCloseYetFar
108	SurvivalTraining
110	WillToSurvive
111	Zeroing
112	BloodSword
113	CursedSword
114	BloodSucker
115	RapidReaction
116	MagicReactor
117	Predator
118	IronHeart
119	BloodScent
120	Bloodthirst
121	Hemorrhage
122	PracticedHand
123	LargeTopPocket
124	LargeBottomPocket
125	DeepseaEscape
126	Ambush
127	Veteran
128	SecondHeart
129	Luck
130	Rearrange
131	Overcharge
132	BreakCastleGate
133	BreakArmor
134	Waiting
135	SwordsmanshipBook
136	SharpBlade
137	Sharpening
138	ContainingAttack
139	Feint
140	Envenoming
141	Comradeship
142	IceBolt
143	LightningBolt
144	MagicErosion
145	WoundInfection
150	PositionOfAdvantage
151	PriorPlanning
153	Stretching
154	TeamPlayer
155	Outthrow
156	Overwatch
157	Reload
158	PiercingShot
159	Sharpshooter
162	HeroDontGiveUp
163	Training100
164	HeroResponsibility
165	RoaringBlaze
166	Grappling
167	Breakthrough
168	CleanHit
169	Parry
173	Challenger
174	Windway
175	MaterialCollector
176	TraceOn
177	Charging
178	LimitBreak
180	HolyShield
187	FirstAid
188	MentalStability
190	Willpower
191	ScreamyBlaze
192	ThunderBolt
194	SpellPowerOfCrack
195	MagicField
196	MagicAcceleration
197	MagicTheory
199	WhiteHeat
202	Concentration
204	FixedFire
205	HeadShot
206	HoldPosition
211	SerialShot
214	Sniper
217	GunbarrelEnhancement
218	LuckyNumberSeven
219	LuckyNumberEight
220	LuckyNumberNine
221	FigterBook
222	Prosperity
223	Damp
224	WitchJealousy
225	BindingPower
226	AcuteSense
227	OpportunityCreation
228	HitAndRun
229	NimbleFinger
230	Informant
231	Supporter
232	Superiority
233	Charisma
234	GunRemodeling
235	SilencingShot
236	RushHeadlong
237	GrenadeBag
238	EnhancedPotion
239	ControlReactor
240	HeavyPressure
241	Jealousy
242	PoisonBullet
243	AlchemyBag
244	Windmage
245	WindHammer
246	WindBlade
247	GustWind
248	WindWall
249	HeadWind
250	Haze
251	RagingWind
252	Catharsis
256	ChainTactics
259	EnergySuit
260	EnhancedSuit
261	ApplicationKnowledge
262	ArchScholar
263	Educationalbooks
264	MajorTextbooks
265	PriorInformation
266	Curse
267	Sentinel
268	Solo
269	Mutation
270	IronWall
271	Solidification
272	HolySword
273	InvisibleSword
274	Avalon
275	Sage
276	Recluse
285	Robust
289	Excitement
290	Wanderer
291	DirectShot
292	SameTarget
293	Quickthrow
294	ThrowHigh
295	Shockwave
300	ParabolicOrbit
301	HeartOfHunter
302	CounterShoot
304	HawkEye
305	RiflingEnhancement
306	DetailedSnipe
309	Camouflage
313	GraciousRefusal
314	InnerPeace
315	RapidPreparation
316	AntiESPBullet
317	MagicResonance
318	Archmage
319	ReleaseEnergy
323	MagicOuterArmor
328	Principlism
329	DelayedThrow
331	DivideAndConquerAlgorithm
332	DoubleGear
334	LightningRod
336	SpellPowerCopy
338	BorrowingEnergy
343	Module_Durability
344	Miracle
346	ForthrightStatement
347	SupportHeal
350	TacticalRetreat
351	ResistWill
356	LightOfSalvation
357	Grouping
358	MassExtract
 
M

Maalik

Noobzor
Joined
Mar 6, 2017
Messages
10
variante said:
Maalik said:
I'll add here the mastery names and masterindex that I have unlocked so far. If you guys have any that's not included, please share ^^

1 Base_Title
2 Text
3 BodyTraining
6 FairWind
7 Swordmaster
8 Deftness
12 ElectricShock
13 Magician
14 TacticalSense
16 Aggression
21 CounterAttack
22 Alacrity
24 Forestallment
28 PositiveMind
30 TacticalEnvelopment
34 Yearning
36 Sunglasses
38 Learning
40 PangOfConscience
42 Supporter
46 Understanding
50 BladeParry
58 SpellStrike
59 MagicTheory
60 Insight
65 SharpBlade
72 Bloodlet
73 BoundingStride
75 MagicAcceleration
76 SoCloseYetFar
78 Bladestorm
80 HighSpeed
81 Challenger
84 InnerFlame
85 LightningReflexes
86 OneByOne
87 RagingFlame
88 ConversionOfEnergy
89 RoaringBlaze
90 OpportunityStrikes
97 WeaponBlocking
98 Bruise
99 CleanHit
101 Lightningmage
104 SlashInjury
105 MagicResonance
106 BloodScent
108 Archmage
112 CloseCombatant
113 ElectricPulse
115 Parry
119 BladeEvasion
120 MuscleTraining
122 RedThornSword
124 Willpower
125 BurnSoul
127 DrainSoul
133 MyDreamIsHero
134 Fellowship
135 Shaman
137 Abundance
142 HealingWave
144 SoulHealer
145 WindRush
148 MagicReactor
153 SpellAbsorbing
158 HuntingDog
159 Hemorrhage
160 CursedSword
163 WoundInfection
176 FinalBlow
178 HeavyStrike
181 WillToSurvive
182 SpellPowerOfCrack
185 VindictiveSpirit
189 AcutePain
190 ShadowZone
223 Bloodthirst
228 Windmage
The masterIndex is not the same as mastery ID, it is just there for data governance in relational database. It doesn't really mean anything outside of the database itself. For example, here's mine, I've manually added many entries by just incrementing masterIndex off the latest one. Btw, the "masteryMaster" table is for equipped masteries. To change the equip status (on/off + which mastery board), do it in "mastery" table.
Code:
<i>
</i>1	Base_Title
2	Text
3	BodyTraining
5	CounterAttack
6	Swordmaster
7	Yearning
8	PositiveMind
9	Forestallment
11	FairWind
13	ElectricShock
14	Magician
15	TacticalSense
17	PangOfConscience
18	BoundingStride
19	Lightningmage
21	DrainSoul
23	Bladestorm
24	MuscleTraining
26	Learning
27	Alacrity
29	InnerFlame
30	LightningReflexes
31	OneByOne
32	RagingFlame
36	FireBolt
38	Berserker
39	CloseCombatant
40	Bruise
42	Understanding
43	ImpulseFields
44	Consideration
45	WindRush
48	IndomitableWill
49	Insight
50	Deftness
51	OpportunityStrikes
55	Fellowship
56	Shaman
59	HighSpeed
62	HeavyStrike
64	FinalBlow
66	HealingWave
67	SoulHealer
74	RedThornSword
75	Bloodlet
80	Retribution
81	ToughSpirit
82	SlashInjury
88	VictoryShout
91	MyDreamIsHero
92	BlessOfRegeneration
94	OriginOfLife
95	OneShotOneKill
99	Aggression
101	ConcentratedFire
103	LonelyWolf
106	ShadowZone
107	SoCloseYetFar
108	SurvivalTraining
110	WillToSurvive
111	Zeroing
112	BloodSword
113	CursedSword
114	BloodSucker
115	RapidReaction
116	MagicReactor
117	Predator
118	IronHeart
119	BloodScent
120	Bloodthirst
121	Hemorrhage
122	PracticedHand
123	LargeTopPocket
124	LargeBottomPocket
125	DeepseaEscape
126	Ambush
127	Veteran
128	SecondHeart
129	Luck
130	Rearrange
131	Overcharge
132	BreakCastleGate
133	BreakArmor
134	Waiting
135	SwordsmanshipBook
136	SharpBlade
137	Sharpening
138	ContainingAttack
139	Feint
140	Envenoming
141	Comradeship
142	IceBolt
143	LightningBolt
144	MagicErosion
145	WoundInfection
150	PositionOfAdvantage
151	PriorPlanning
153	Stretching
154	TeamPlayer
155	Outthrow
156	Overwatch
157	Reload
158	PiercingShot
159	Sharpshooter
162	HeroDontGiveUp
163	Training100
164	HeroResponsibility
165	RoaringBlaze
166	Grappling
167	Breakthrough
168	CleanHit
169	Parry
173	Challenger
174	Windway
175	MaterialCollector
176	TraceOn
177	Charging
178	LimitBreak
180	HolyShield
187	FirstAid
188	MentalStability
190	Willpower
191	ScreamyBlaze
192	ThunderBolt
194	SpellPowerOfCrack
195	MagicField
196	MagicAcceleration
197	MagicTheory
199	WhiteHeat
202	Concentration
204	FixedFire
205	HeadShot
206	HoldPosition
211	SerialShot
214	Sniper
217	GunbarrelEnhancement
218	LuckyNumberSeven
219	LuckyNumberEight
220	LuckyNumberNine
221	FigterBook
222	Prosperity
223	Damp
224	WitchJealousy
225	BindingPower
226	AcuteSense
227	OpportunityCreation
228	HitAndRun
229	NimbleFinger
230	Informant
231	Supporter
232	Superiority
233	Charisma
234	GunRemodeling
235	SilencingShot
236	RushHeadlong
237	GrenadeBag
238	EnhancedPotion
239	ControlReactor
240	HeavyPressure
241	Jealousy
242	PoisonBullet
243	AlchemyBag
244	Windmage
245	WindHammer
246	WindBlade
247	GustWind
248	WindWall
249	HeadWind
250	Haze
251	RagingWind
252	Catharsis
256	ChainTactics
259	EnergySuit
260	EnhancedSuit
261	ApplicationKnowledge
262	ArchScholar
263	Educationalbooks
264	MajorTextbooks
265	PriorInformation
266	Curse
267	Sentinel
268	Solo
269	Mutation
270	IronWall
271	Solidification
272	HolySword
273	InvisibleSword
274	Avalon
275	Sage
276	Recluse
285	Robust
289	Excitement
290	Wanderer
291	DirectShot
292	SameTarget
293	Quickthrow
294	ThrowHigh
295	Shockwave
300	ParabolicOrbit
301	HeartOfHunter
302	CounterShoot
304	HawkEye
305	RiflingEnhancement
306	DetailedSnipe
309	Camouflage
313	GraciousRefusal
314	InnerPeace
315	RapidPreparation
316	AntiESPBullet
317	MagicResonance
318	Archmage
319	ReleaseEnergy
323	MagicOuterArmor
328	Principlism
329	DelayedThrow
331	DivideAndConquerAlgorithm
332	DoubleGear
334	LightningRod
336	SpellPowerCopy
338	BorrowingEnergy
343	Module_Durability
344	Miracle
346	ForthrightStatement
347	SupportHeal
350	TacticalRetreat
351	ResistWill
356	LightOfSalvation
357	Grouping
358	MassExtract
Thanks for the reply m8. I got the hang of the masteries with your help.

Could you give me a light on altering stats aswell? I've been changing the values on "stats/etc" from the rosterpropertymastery but the values ingame doesn't seem to change.
 
CYBER_PUNK

CYBER_PUNK

What is cheating?
Joined
Sep 17, 2019
Messages
2
I delete the cache in documents, but it keeps crashing, even upon making a new company, if the old .sav file is in there, it crashes when clicking new game, and creating a new save which will work for a while or sometimes just until you exit and re launch the game, importing old .sav doesn't work, it crashes anyway, cache file deleted as well.

Can't get it to work, keeps crashing when i try load my save, it works for a while but eventually stops and have to start from scratch. It seems to be something within the .sav file, a flag there or something.

I also wonder if it's possible to add Carter's abilities/masteries to the company.
 
Top