Discussion: Editing BGEE.SQL with WeiDu

[Rodman49]

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

[Wisp]

I don't have time for step-by-step instructions, but you want REPLACE_EVALUATE or REPLACE_TEXTUALLY for this.

 

I suppose I should write some sort of function for appending to these sql tables.

[pro5]

Simple APPEND should work. You can have multiple "INSERT INTO portraits" in the SQL file, they all seem to processed in the end and can live happily together.