[Archive] [Tool] SQL Insert Into to Update Convertor
[Archive] [Tool] SQL Insert Into to Update Convertor
11-04-2025, 12:45 PM
Original source
Quote: I made this for 2d, but I'll post it for you all. This little utility takes a .txt file with INSERT INTO commands and converts them all to UPDATE commands. Example:
Code:
INSERT INTO creature_names VALUES (1337,4,4,-1)
becomes
Code:
UPDATE creature_names SET entry = 1338 WHERE entry = 1337
The entry number (in that example, 133is set by the user for each entry, so if you're doing a big list you'll be typing in a LOT of numbers.
Things to note:
-The thing breaks if a line doesn't follow the syntax in the first code box. Comments are a no-no.
-You need to press Load before Convert.
-You need the full path of each file, drive and all. If the output file exists....I don't know what will happen XD
Changelog:
v1.0 - Initial release
Virus Scan:
http://www.virustotal.com/analisis/0...d352ab52167e4c
Download:
Filebeam - Free Fast File Hosting
rektbyfaith
11-04-2025, 12:45 PM #1Archived author: ReidE96 • Posted: 2025-11-04T13:45:59.292172
Original source
Quote: I made this for 2d, but I'll post it for you all. This little utility takes a .txt file with INSERT INTO commands and converts them all to UPDATE commands. Example:
Code:
INSERT INTO creature_names VALUES (1337,4,4,-1)
becomes
Code:
UPDATE creature_names SET entry = 1338 WHERE entry = 1337
The entry number (in that example, 133
Things to note:
-The thing breaks if a line doesn't follow the syntax in the first code box. Comments are a no-no.
-You need to press Load before Convert.
-You need the full path of each file, drive and all. If the output file exists....I don't know what will happen XD
Changelog:
v1.0 - Initial release
Virus Scan:
http://www.virustotal.com/analisis/0...d352ab52167e4c
Download:
Filebeam - Free Fast File Hosting
11-04-2025, 12:45 PM
Original source
Quote: Sweet!
Thanks dude.
rektbyfaith
11-04-2025, 12:45 PM #2Archived author: abct4 • Posted: 2025-11-04T13:45:59.292172
Original source
Quote: Sweet!
Thanks dude.
11-04-2025, 12:45 PM
Original source
Quote: thx nice tool
rektbyfaith
11-04-2025, 12:45 PM #3Archived author: whitevamp • Posted: 2025-11-04T13:45:59.292172
Original source
Quote: thx nice tool
11-04-2025, 12:45 PM
Original source
Quote:Can I have source code? I assume its in like VB.NET
I want to add more functions
rektbyfaith
11-04-2025, 12:45 PM #4Archived author: SectorSeven • Posted: 2025-11-04T13:45:59.292172
Original source
Quote:Can I have source code? I assume its in like VB.NET
I want to add more functions
11-04-2025, 12:45 PM
Original source
Quote: s7, yes it's vb.net and I can probably code the stuff myself, just say whatcha wantThough I can give you the source if you want.
rektbyfaith
11-04-2025, 12:45 PM #5Archived author: ReidE96 • Posted: 2025-11-04T13:45:59.292172
Original source
Quote: s7, yes it's vb.net and I can probably code the stuff myself, just say whatcha want
11-04-2025, 12:45 PM
Original source
Quote:I'd like to view the source code if thats ok (PM me) for educational purposes, as I'm still learning vb.net.
But I was just gonna add some pimp stuff.
rektbyfaith
11-04-2025, 12:45 PM #6Archived author: SectorSeven • Posted: 2025-11-04T13:45:59.292172
Original source
Quote:I'd like to view the source code if thats ok (PM me) for educational purposes, as I'm still learning vb.net.
But I was just gonna add some pimp stuff.
11-04-2025, 12:45 PM
Original source
Quote: Check your PMs, I sent you the zipped project folder.
rektbyfaith
11-04-2025, 12:45 PM #7Archived author: ReidE96 • Posted: 2025-11-04T13:45:59.292172
Original source
Quote: Check your PMs, I sent you the zipped project folder.
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)