[DiscordArchive] Hey, I have not touched heidiSQL in ages, and wondering if anyone could save me from making a mistak
[DiscordArchive] Hey, I have not touched heidiSQL in ages, and wondering if anyone could save me from making a mistak
Archived author: kapper3513 • Posted: 2022-12-20T18:31:17.795000+00:00
Original source
Hey, I have not touched heidiSQL in ages, and wondering if anyone could save me from making a mistake with my database. Is this the correct way to increase every item_value1 in the database with a 10% increase, given that stat_value1 is 7 (stamina)? Or am I remembering it wrong?
![[Image: image.png?ex=690c40bc&is=690aef3c&hm=5a1...6d125d054&]](https://cdn.discordapp.com/attachments/415944535718494208/1054828382392684586/image.png?ex=690c40bc&is=690aef3c&hm=5a18704e82d21fafbd3df1f1e06c5a54e95f53717095774ea1e739a6d125d054&)
Archived author: kapper3513 • Posted: 2022-12-20T18:31:24.196000+00:00
Original source
![[Image: image.png?ex=690c40bc&is=690aef3c&hm=5a1...6d125d054&]](https://cdn.discordapp.com/attachments/415944535718494208/1054828382392684586/image.png?ex=690c40bc&is=690aef3c&hm=5a18704e82d21fafbd3df1f1e06c5a54e95f53717095774ea1e739a6d125d054&)
Archived author: Vlathis • Posted: 2022-12-20T18:42:17.917000+00:00
Original source
You need a ; at the end.
Archived author: Vlathis • Posted: 2022-12-20T18:42:47.850000+00:00
Original source
I've also never used the == in mine, it might work though, I haven't tried, but I've usually just done stat_type1 = 7
Archived author: kapper3513 • Posted: 2022-12-20T18:43:30.553000+00:00
Original source
Awesome, thank you so much! Forgot all about the ;
Archived author: Vlathis • Posted: 2022-12-20T18:43:40.012000+00:00
Original source
No problem!
![[Image: image.png?ex=690c441b&is=690af29b&hm=19d...7bcb6eecf&]](https://cdn.discordapp.com/attachments/415944535718494208/1054832003557638184/image.png?ex=690c441b&is=690af29b&hm=19dde28b24107176b925d55dd2317c13a5ac2549df670d769f3f3af7bcb6eecf&)
Archived author: kapper3513 • Posted: 2022-12-20T18:45:47.457000+00:00
Original source
![[Image: image.png?ex=690c441b&is=690af29b&hm=19d...7bcb6eecf&]](https://cdn.discordapp.com/attachments/415944535718494208/1054832003557638184/image.png?ex=690c441b&is=690af29b&hm=19dde28b24107176b925d55dd2317c13a5ac2549df670d769f3f3af7bcb6eecf&)
Archived author: kapper3513 • Posted: 2022-12-20T18:46:05.517000+00:00
Original source
It says my syntax is wrong. Any clues to where?
Archived author: stoneharry • Posted: 2022-12-20T18:58:55.088000+00:00
Original source
Wrong MPQ, try opening them all in merged mode
Archived author: Ed_Kay • Posted: 2022-12-20T19:11:07.780000+00:00
Original source
I had no idea you could do that, very new at this still. Thank you! I'll try fooling around with it and seeing what happens