Skip to content

Modifying BGEE.SQL with WeiDu

PaheejPaheej Member Posts: 126
in General Modding
Yo dudes,

How do I modify BGEE.SQL with WeiDu? I need a step by step example - I have noticed that my last version of the Super Ultimate Portrait Pack causes a significant amount of issues with updated versions of BGEE.SQL

I would prefer to be able to edit my downloads and fix this within the next 72 hours as I was recalled by the Army and have to go back to the middle east all of next year. The optimal way to do this is to edit BGEE.SQL with a WeiDu mod . . . issue is that I am not sure how to do this a cursory look at forums and WeiDu documentation doesn't really show me how to do this (I've made custom NPC's and other things before so I have a small amount of WeiDu knowledge and can write programs in Java and VBA)

My guess is that I need to use the "WRITE_ASCII" command on the BGEE.SQL file (I see that ADD_JOURNAL does edit BGEE.SQL to some degree) but all I have seen about BGEE.SQL documentation is from Cam in this thread at G3:
http://forums.gibberlings3.net/index.php?showtopic=25609

Essentially I just need to insert about 546 lines into the BGEE.SQL for both BGEE and BG2EE from one install file - then copy over the portraits in the override folder - pretty sure I can do that on my own though.

Thanks - mod that is being updated is here - your crashing culprit:
http://www.moddb.com/members/rodman49/addons/super-ultimate-portrait-pack

Comments

  • prophet1prophet1 Member Posts: 172
    edited December 2013
    This should do what you need. A heads-up - while checking, I noticed that one of the male portraits showed up empty (as a question mark), this means it's either missing, or its filename is misspelled in the .sql file, or it's in incorrect format (must be 24 bit).

    APPEND ~bgee.sql~ ~ INSERT INTO portraits ROWS ( 'FDWBA00', 2, 'FDWBA01', 2, 'FDWBA02', 2, 'FDWCL00', 2, 'FDWCL01', 2, 'FDWCL02', 2, 'FDWFI00', 2, 'FDWFI01', 2, 'FDWFI02', 2, 'FDWFI03', 2, 'FDWTH00', 2, 'FDWTH01', 2, 'FDWTH02', 2, 'FELBA00', 2, 'FELBA01', 2, 'FELBA02', 2, 'FELBA03', 2, 'FELCL00', 2, 'FELCL01', 2, 'FELCL02', 2, 'FELCL03', 2, 'FELCL04', 2, 'FELCL05', 2, 'FELCL06', 2, 'FELCL07', 2, 'FELCL08', 2, 'FELDR00', 2, 'FELDR01', 2, 'FELDR02', 2, 'FELDR03', 2, 'FELDR04', 2, 'FELDR05', 2, 'FELDR06', 2, 'FELFI00', 2, 'FELFI01', 2, 'FELFI02', 2, 'FELFI04', 2, 'FELFI05', 2, 'FELFI06', 2, 'FELFI07', 2, 'FELFI08', 2, 'FELFI09', 2, 'FELMA00', 2, 'FELMA01', 2, 'FELMA02', 2, 'FELMA03', 2, 'FELMA04', 2, 'FELMA05', 2, 'FELMA06', 2, 'FELMA07', 2, 'FELMA08', 2, 'FELMA09', 2, 'FELMA10', 2, 'FELMA11', 2, 'FELMA12', 2, 'FELMA13', 2, 'FELMA14', 2, 'FELMA15', 2, 'FELMA16', 2, 'FELRA00', 2, 'FELRA01', 2, 'FELRA02', 2, 'FELRA03', 2, 'FELRA04', 2, 'FELRA05', 2, 'FELRA06', 2, 'FELSO00', 2, 'FELSO01', 2, 'FELSO02', 2, 'FELSO03', 2, 'FELSO04', 2, 'FELSO05', 2, 'FELSO06', 2, 'FELSO07', 2, 'FELTH00', 2, 'FELTH01', 2, 'FELTH02', 2, 'FELTH03', 2, 'FELTH04', 2, 'FELTH05', 2, 'FGNCL00', 2, 'FGNCL01', 2, 'FGNCL02', 2, 'FGNFI00', 2, 'FGNFI01', 2, 'FGNFI02', 2, 'FGNMA00', 2, 'FGNMA01', 2, 'FGNMA02', 2, 'FGNTH00', 2, 'FGNTH01', 2, 'FGNTH02', 2, 'FHACL00', 2, 'FHACL01', 2, 'FHACL02', 2, 'FHAFI00', 2, 'FHAFI01', 2, 'FHAFI02', 2, 'FHATH00', 2, 'FHATH01', 2, 'FHATH02', 2, 'FHATH03', 2, 'FHATH04', 2, 'FHUBA00', 2, 'FHUBA01', 2, 'FHUBA02', 2, 'FHUBA03', 2, 'FHUBD00', 2, 'FHUBD01', 2, 'FHUBD02', 2, 'FHUBD03', 2, 'FHUBD04', 2, 'FHUBD05', 2, 'FHUBD06', 2, 'FHUCL00', 2, 'FHUCL01', 2, 'FHUCL02', 2, 'FHUCL03', 2, 'FHUCL04', 2, 'FHUCL05', 2, 'FHUCL06', 2, 'FHUCL07', 2, 'FHUCL08', 2, 'FHUCL09', 2, 'FHUCL10', 2, 'FHUCL11', 2, 'FHUCL12', 2, 'FHUCL13', 2, 'FHUDR00', 2, 'FHUDR01', 2, 'FHUDR02', 2, 'FHUDR03', 2, 'FHUDR04', 2, 'FHUDR05', 2, 'FHUDR06', 2, 'FHUDR07', 2, 'FHUDR08', 2, 'FHUDR09', 2, 'FHUFI00', 2, 'FHUFI01', 2, 'FHUFI02', 2, 'FHUFI03', 2, 'FHUFI04', 2, 'FHUFI05', 2, 'FHUFI06', 2, 'FHUFI07', 2, 'FHUFI08', 2, 'FHUFI09', 2, 'FHUFI10', 2, 'FHUFI11', 2, 'FHUFI12', 2, 'FHUFI13', 2, 'FHUFI14', 2, 'FHUFI15', 2, 'FHUFI16', 2, 'FHUFI17', 2, 'FHUFI18', 2, 'FHUFI19', 2, 'FHUFI20', 2, 'FHUFI21', 2, 'FHUFI22', 2, 'FHUMA00', 2, 'FHUMA01', 2, 'FHUMA02', 2, 'FHUMA03', 2, 'FHUMA04', 2, 'FHUMA05', 2, 'FHUMA06', 2, 'FHUMA07', 2, 'FHUMA08', 2, 'FHUMA09', 2, 'FHUMA10', 2, 'FHUMA11', 2, 'FHUMA12', 2, 'FHUMA13', 2, 'FHUMA14', 2, 'FHUMA15', 2, 'FHUMA16', 2, 'FHUMA17', 2, 'FHUMA18', 2, 'FHUMA19', 2, 'FHUMO00', 2, 'FHUMO01', 2, 'FHUMO02', 2, 'FHUPA00', 2, 'FHUPA01', 2, 'FHUPA02', 2, 'FHUPA03', 2, 'FHUPA04', 2, 'FHUPA05', 2, 'FHUPA06', 2, 'FHUPA07', 2, 'FHUPA08', 2, 'FHUPA09', 2, 'FHUPA10', 2, 'FHUPA11', 2, 'FHUPA12', 2, 'FHURA00', 2, 'FHURA01', 2, 'FHURA02', 2, 'FHURA03', 2, 'FHURA04', 2, 'FHURA05', 2, 'FHUSO00', 2, 'FHUSO01', 2, 'FHUSO02', 2, 'FHUSO03', 2, 'FHUSO04', 2, 'FHUSO05', 2, 'FHUSO06', 2, 'FHUSO07', 2, 'FHUSO08', 2, 'FHUSO09', 2, 'FHUSO10', 2, 'FHUTH00', 2, 'FHUTH01', 2, 'FHUTH02', 2, 'FHUTH03', 2, 'FHUTH04', 2, 'FHUTH05', 2, 'FHUTH06', 2, 'FHUTH07', 2, 'FHUTH08', 2, 'FHUTH09', 2, 'FHUTH10', 2, 'FHUTH11', 2, 'FHUTH13', 2, 'FHUTH14', 2, 'FHUTH15', 2, 'FHUTH16', 2, 'FHUTH17', 2, 'FHUTH18', 2, 'FORBA00', 2, 'FORBA01', 2, 'FORBA02', 2, 'FORBA03', 2, 'FORCL00', 2, 'FORCL01', 2, 'FORCL02', 2, 'FORCL03', 2, 'FORFI00', 2, 'FORFI01', 2, 'FORFI02', 2, 'FORFI03', 2, 'FORTH00', 2, 'FORTH01', 2, 'FORTH02', 2, 'MDWBA00', 1, 'MDWBA01', 1, 'MDWBA02', 1, 'MDWBA03', 1, 'MDWCL00', 1, 'MDWCL01', 1, 'MDWCL02', 1, 'MDWCL03', 1, 'MDWCL04', 1, 'MDWCL05', 1, 'MDWCL06', 1, 'MDWCL07', 1, 'MDWFI00', 1, 'MDWFI01', 1, 'MDWFI02', 1, 'MDWFI03', 1, 'MDWFI04', 1, 'MDWFI05', 1, 'MDWFI06', 1, 'MDWFI07', 1, 'MDWFI08', 1, 'MDWFI09', 1, 'MDWFI10', 1, 'MDWFI11', 1, 'MDWFI12', 1, 'MDWFI13', 1, 'MDWFI14', 1, 'MDWFI15', 1, 'MDWFI16', 1, 'MDWFI17', 1, 'MDWFI18', 1, 'MDWFI19', 1, 'MDWFI20', 1, 'MDWFI21', 1, 'MDWTH00', 1, 'MDWTH01', 1, 'MDWTH02', 1, 'MDWTH03', 1, 'MDWTH04', 1, 'MELBA00', 1, 'MELBA01', 1, 'MELBA02', 1, 'MELBA03', 1, 'MELBA04', 1, 'MELCL00', 1, 'MELCL01', 1, 'MELCL02', 1, 'MELCL03', 1, 'MELCL04', 1, 'MELCL05', 1, 'MELCL06', 1, 'MELDR00', 1, 'MELFI00', 1, 'MELFI03', 1, 'MELFI04', 1, 'MELFI05', 1, 'MELFI06', 1, 'MELFI07', 1, 'MELFI08', 1, 'MELFI09', 1, 'MELFI10', 1, 'MELMA00', 1, 'MELMA01', 1, 'MELMA02', 1, 'MELMA03', 1, 'MELMA05', 1, 'MELMA06', 1, 'MELMA07', 1, 'MELRA00', 1, 'MELRA01', 1, 'MELRA02', 1, 'MELRA03', 1, 'MELSO00', 1, 'MELSO01', 1, 'MELSO02', 1, 'MELSO03', 1, 'MELSO04', 1, 'MELSO05', 1, 'MELTH00', 1, 'MELTH01', 1, 'MELTH02', 1, 'MELTH03', 1, 'MELTH04', 1, 'MELTH05', 1, 'MELTH06', 1, 'MELTH07', 1, 'MELTH08', 1, 'MELTH09', 1, 'MGNCL00', 1, 'MGNCL01', 1, 'MGNCL02', 1, 'MGNCL03', 1, 'MGNFI00', 1, 'MGNFI01', 1, 'MGNFI02', 1, 'MGNFI03', 1, 'MGNFI04', 1, 'MGNMA00', 1, 'MGNMA01', 1, 'MGNMA02', 1, 'MGNMA03', 1, 'MGNMA04', 1, 'MGNMA05', 1, 'MGNTH00', 1, 'MGNTH01', 1, 'MGNTH02', 1, 'MHACL00', 1, 'MHACL01', 1, 'MHACL02', 1, 'MHAFI00', 1, 'MHAFI01', 1, 'MHAFI02', 1, 'MHAFI03', 1, 'MHAFI04', 1, 'MHAFI05', 1, 'MHAFI06', 1, 'MHATH00', 1, 'MHATH01', 1, 'MHATH02', 1, 'MHATH03', 1, 'MHATH04', 1, 'MHATH05', 1, 'MHUBA00', 1, 'MHUBA01', 1, 'MHUBA02', 1, 'MHUBA03', 1, 'MHUBA04', 1, 'MHUBA05', 1, 'MHUBA06', 1, 'MHUBD00', 1, 'MHUBD01', 1, 'MHUBD02', 1, 'MHUBD03', 1, 'MHUBD04', 1, 'MHUBD05', 1, 'MHUCL00', 1, 'MHUCL01', 1, 'MHUCL02', 1, 'MHUCL03', 1, 'MHUCL04', 1, 'MHUCL05', 1, 'MHUCL06', 1, 'MHUCL07', 1, 'MHUDR00', 1, 'MHUDR01', 1, 'MHUDR02', 1, 'MHUDR03', 1, 'MHUDR04', 1, 'MHUDR05', 1, 'MHUDR06', 1, 'MHUDR07', 1, 'MHUFI00', 1, 'MHUFI01', 1, 'MHUFI02', 1, 'MHUFI03', 1, 'MHUFI04', 1, 'MHUFI05', 1, 'MHUFI06', 1, 'MHUFI07', 1, 'MHUFI08', 1, 'MHUFI09', 1, 'MHUFI10', 1, 'MHUFI11', 1, 'MHUFI12', 1, 'MHUFI13', 1, 'MHUFI14', 1, 'MHUFI15', 1, 'MHUFI16', 1, 'MHUFI17', 1, 'MHUFI18', 1, 'MHUFI19', 1, 'MHUFI20', 1, 'MHUFI21', 1, 'MHUFI22', 1, 'MHUFI23', 1, 'MHUFI24', 1, 'MHUFI25', 1, 'MHUFI26', 1, 'MHUFI27', 1, 'MHUFI28', 1, 'MHUFI29', 1, 'MHUFI30', 1, 'MHUFI31', 1, 'MHUFI32', 1, 'MHUFI33', 1, 'MHUFI34', 1, 'MHUFI35', 1, 'MHUFI36', 1, 'MHUFI37', 1, 'MHUFI38', 1, 'MHUFI39', 1, 'MHUFI40', 1, 'MHUFI41', 1, 'MHUFI42', 1, 'MHUFI43', 1, 'MHUFI44', 1, 'MHUFI45', 1, 'MHUFI46', 1, 'MHUFI47', 1, 'MHUFI48', 1, 'MHUFI49', 1, 'MHUFI50', 1, 'MHUFI51', 1, 'MHUFI52', 1, 'MHUFI53', 1, 'MHUFI54', 1, 'MHUMA00', 1, 'MHUMA01', 1, 'MHUMA02', 1, 'MHUMA03', 1, 'MHUMA04', 1, 'MHUMA05', 1, 'MHUMA06', 1, 'MHUMA07', 1, 'MHUMA08', 1, 'MHUMA09', 1, 'MHUMA10', 1, 'MHUMA11', 1, 'MHUMA12', 1, 'MHUMA13', 1, 'MHUMA14', 1, 'MHUMA15', 1, 'MHUMA16', 1, 'MHUMA17', 1, 'MHUMA18', 1, 'MHUMA19', 1, 'MHUMA20', 1, 'MHUMO00', 1, 'MHUMO01', 1, 'MHUMO02', 1, 'MHUMO03', 1, 'MHUMO04', 1, 'MHUMO05', 1, 'MHUMO06', 1, 'MHUPA00', 1, 'MHUPA01', 1, 'MHUPA02', 1, 'MHUPA03', 1, 'MHUPA04', 1, 'MHUPA05', 1, 'MHUPA06', 1, 'MHUPA07', 1, 'MHUPA08', 1, 'MHUPA09', 1, 'MHUPA10', 1, 'MHURA00', 1, 'MHURA01', 1, 'MHURA02', 1, 'MHURA03', 1, 'MHURA04', 1, 'MHURA05', 1, 'MHUSO00', 1, 'MHUSO01', 1, 'MHUSO02', 1, 'MHUSO03', 1, 'MHUSO04', 1, 'MHUSO05', 1, 'MHUTH00', 1, 'MHUTH01', 1, 'MHUTH02', 1, 'MHUTH03', 1, 'MHUTH04', 1, 'MHUTH05', 1, 'MHUTH06', 1, 'MHUTH07', 1, 'MHUTH08', 1, 'MHUTH09', 1, 'MHUTH10', 1, 'MHUTH11', 1, 'MHUTH12', 1, 'MHUTH13', 1, 'MHUTH14', 1, 'MHUTH15', 1, 'MORBA00', 1, 'MORBA01', 1, 'MORBA02', 1, 'MORBA03', 1, 'MORBA04', 1, 'MORBA05', 1, 'MORBA06', 1, 'MORCL00', 1, 'MORCL01', 1, 'MORCL02', 1, 'MORCL03', 1, 'MORFI00', 1, 'MORFI01', 1, 'MORFI02', 1, 'MORFI03', 1, 'MORFI04', 1, 'MORFI05', 1, 'MORFI06', 1, 'MORFI07', 1, 'MORFI08', 1, 'MORFI09', 1, 'MORFI10', 1, 'MORFI11', 1, 'MORTH00', 1, 'MORTH01', 1, 'MORTH02', 1, 'XCOOKE1', 1 ); ~
    Post edited by prophet1 on
  • prophet1prophet1 Member Posts: 172
    Edited the post above to replace the original suggestion with REPLACE_TEXTUALLY with a simple APPEND - looks like there is no limit on how many times the same INSERT can used in the sql file, which makes things much easier and more reliable.
  • PaheejPaheej Member Posts: 126
    Great, thanks @prophet1

    I'll get around to this as time permits over the next few weeks. I actually have some VBA code that will create the necessary rows for insertion. I think I will make it so you can install components of the mod (just human portraits, just gnome portraits, all the portraits, etc).
Sign In or Register to comment.

2024 Overhaul Games, a division of Beamdog. © 2024 Hasbro, Inc. All Rights Reserved. Baldur's Gate, Dungeons & Dragons, D&D, Forgotten Realms, Baldur's Gate, Wizards of the Coast and their logos are trademarks of Wizards of the Coast LLC in the U.S.A. and other countries, and are used with permission. Hasbro and its logo are trademarks of Hasbro, Inc. and are used with permission. © 1998 BioWare Corp. All Rights Reserved. BioWare, the BioWare Infinity Engine and the BioWare logo are trademarks of Bioware Corp. Black Isle Studios and the Black Isle Studios logo are trademarks of Interplay Entertainment Corp. Atari and the Atari logo are trademarks owned by Atari Interactive, Inc. All other trademarks are the property of their respective owners.