McGuffinpunk Chapter Editor

[cafeenman]

This is the evolved version of my Tree Editor I posted a year or so ago.

I've gotten rid of the all the random tree creation stuff. I thought that would be cool but it constrained me to writing that perfectly filled what I was given. Turned out to be a really bad idea.

The one thing I really want to be able to do with this that I haven't done is drag and drop or even just up/down arrows to move things around.

For example, when I want a choice that's currently after another choice to go before it instead. Right now there's no way to do that except to write queries directly in the db to do the swapping (or do it manually).

Other than that, this does everything I need it to do. I may church it up a bit over time but for now it's done.

I'd love some feedback on it.

By the way, this is the content editor for the game I'm working on.

McGuffinpunk Chapter Editor.zip

[cafeenman]

OK, just found a bug. In the bDB module, do this:

Public Function CreateTableCopy(ByRef SourceTable As String, ByRef NewTable As String) As Long
Dim SQL As String

' Returns Error Code.

On Error GoTo errHandler

SQL = "SELECT * INTO " & NewTable & " FROM " & SourceTable ' Remove the WHERE 0=1 part that's here or it will not copy the contents of the template.

DB.Execute SQL, dbFailOnError

DB.TableDefs.Refresh

Exit Function

errHandler:

CreateTableCopy = Err

MsgBox Error & " (" & Err & ")."

End Function