[Tool] SQL Insert Into to Update Convertor menu

Shout-Out

User Tag List

Results 1 to 7 of 7
  1. #1
    ReidE96's Avatar Archer Authenticator enabled
    Reputation
    470
    Join Date
    Dec 2006
    Posts
    1,625
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Tool] SQL Insert Into to Update Convertor

    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 is 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
    Last edited by ReidE96; 06-04-2008 at 03:26 PM. Reason: Forgot a virus scan. My bad.

    [Tool] SQL Insert Into to Update Convertor
  2. #2
    abct4's Avatar Member
    Reputation
    1
    Join Date
    May 2008
    Posts
    6
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sweet!
    Thanks dude.

  3. #3
    whitevamp's Avatar Member
    Reputation
    1
    Join Date
    Apr 2008
    Posts
    2
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thx nice tool

  4. #4
    SectorSeven's Avatar Banned
    Reputation
    444
    Join Date
    Oct 2007
    Posts
    1,948
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can I have source code? I assume its in like VB.NET

    I want to add more functions

  5. #5
    ReidE96's Avatar Archer Authenticator enabled
    Reputation
    470
    Join Date
    Dec 2006
    Posts
    1,625
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    s7, yes it's vb.net and I can probably code the stuff myself, just say whatcha want Though I can give you the source if you want.

  6. #6
    SectorSeven's Avatar Banned
    Reputation
    444
    Join Date
    Oct 2007
    Posts
    1,948
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.

  7. #7
    ReidE96's Avatar Archer Authenticator enabled
    Reputation
    470
    Join Date
    Dec 2006
    Posts
    1,625
    Thanks G/R
    1/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Check your PMs, I sent you the zipped project folder.

Similar Threads

  1. SQL Insert Help
    By Hadesminion13 in forum WoW EMU Questions & Requests
    Replies: 2
    Last Post: 07-06-2009, 09:50 PM
  2. Stepping Into C++ [Updated]
    By mager1794 in forum WoW EMU Guides & Tutorials
    Replies: 16
    Last Post: 05-08-2009, 03:09 PM
  3. Inserting toons to updated core repack
    By yellowd in forum WoW EMU Questions & Requests
    Replies: 8
    Last Post: 01-10-2009, 08:58 PM
  4. [GUIDE][Pictures]Combining a bunch of SQL files into one
    By Kiyoshi in forum WoW EMU Guides & Tutorials
    Replies: 1
    Last Post: 07-02-2008, 12:55 PM
  5. [Guide]Putting a lot of SQL files into 1 big SQL file FAST !
    By latruwski in forum WoW EMU Guides & Tutorials
    Replies: 15
    Last Post: 03-25-2008, 07:00 AM
All times are GMT -5. The time now is 03:03 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search