Forums WoW Modding Support Archives WoWModding Support Archives [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

[DiscordArchive] Hey, I have not touched heidiSQL in ages, and wondering if anyone could save me from making a mistak

rektbyfaith
Administrator
0
12-20-2022, 06:31 PM
#1
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?
rektbyfaith
12-20-2022, 06:31 PM #1

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?

rektbyfaith
Administrator
0
12-20-2022, 06:31 PM
#2
Archived author: kapper3513 • Posted: 2022-12-20T18:31:24.196000+00:00
Original source


[Image: image.png?ex=690c40bc&is=690aef3c&hm=5a1...6d125d054&]
rektbyfaith
12-20-2022, 06:31 PM #2

Archived author: kapper3513 • Posted: 2022-12-20T18:31:24.196000+00:00
Original source


[Image: image.png?ex=690c40bc&is=690aef3c&hm=5a1...6d125d054&]

rektbyfaith
Administrator
0
12-20-2022, 06:42 PM
#3
Archived author: Vlathis • Posted: 2022-12-20T18:42:17.917000+00:00
Original source

You need a ; at the end.
rektbyfaith
12-20-2022, 06:42 PM #3

Archived author: Vlathis • Posted: 2022-12-20T18:42:17.917000+00:00
Original source

You need a ; at the end.

rektbyfaith
Administrator
0
12-20-2022, 06:42 PM
#4
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
rektbyfaith
12-20-2022, 06:42 PM #4

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

rektbyfaith
Administrator
0
12-20-2022, 06:43 PM
#5
Archived author: kapper3513 • Posted: 2022-12-20T18:43:30.553000+00:00
Original source

Awesome, thank you so much! Forgot all about the ;
rektbyfaith
12-20-2022, 06:43 PM #5

Archived author: kapper3513 • Posted: 2022-12-20T18:43:30.553000+00:00
Original source

Awesome, thank you so much! Forgot all about the ;

rektbyfaith
Administrator
0
12-20-2022, 06:43 PM
#6
Archived author: Vlathis • Posted: 2022-12-20T18:43:40.012000+00:00
Original source

No problem!
rektbyfaith
12-20-2022, 06:43 PM #6

Archived author: Vlathis • Posted: 2022-12-20T18:43:40.012000+00:00
Original source

No problem!

rektbyfaith
Administrator
0
12-20-2022, 06:45 PM
#7
Archived author: kapper3513 • Posted: 2022-12-20T18:45:47.457000+00:00
Original source


[Image: image.png?ex=690c441b&is=690af29b&hm=19d...7bcb6eecf&]
rektbyfaith
12-20-2022, 06:45 PM #7

Archived author: kapper3513 • Posted: 2022-12-20T18:45:47.457000+00:00
Original source


[Image: image.png?ex=690c441b&is=690af29b&hm=19d...7bcb6eecf&]

rektbyfaith
Administrator
0
12-20-2022, 06:46 PM
#8
Archived author: kapper3513 • Posted: 2022-12-20T18:46:05.517000+00:00
Original source

It says my syntax is wrong. Any clues to where?
rektbyfaith
12-20-2022, 06:46 PM #8

Archived author: kapper3513 • Posted: 2022-12-20T18:46:05.517000+00:00
Original source

It says my syntax is wrong. Any clues to where?

rektbyfaith
Administrator
0
12-20-2022, 06:58 PM
#9
Archived author: stoneharry • Posted: 2022-12-20T18:58:55.088000+00:00
Original source

Wrong MPQ, try opening them all in merged mode
rektbyfaith
12-20-2022, 06:58 PM #9

Archived author: stoneharry • Posted: 2022-12-20T18:58:55.088000+00:00
Original source

Wrong MPQ, try opening them all in merged mode

rektbyfaith
Administrator
0
12-20-2022, 07:11 PM
#10
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
rektbyfaith
12-20-2022, 07:11 PM #10

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

Recently Browsing
 
Recently Browsing