Storytracer "some technical info"
Posted 12-07-2007 at 09:19 AM by The_Caveman
Well I had two days of from work so had the chance to do some nice progress on Storytracer.
Now things are getting close to a release so I thought I'd post some more technical information for those interested ^^.
Before I talked of using a remote database but it seems like a lot of hosts dont allow remote connections so I had to come up with something different.
Another problem was that some projects who might be interested have their forums, websites etc and I can't ask them to adapt to Storytracer but it should work the other way around.
So I came up with the idea of using "php" files.
Very simple ones. Just with some SQL code that is easy to change. I'll call them php templates from now ^^.
So how do I plan on making this work.
For each type of info from a movie (scene, character, age, props etc) I create a basic php file that will stock some information into the db. so when the "upload" function is called to put a file online, the php template will be loaded into storytracer the template vilues like name, id etc will be replaced with the actual information from the local database. A new php file will be written according to the template. The file will be uploaded and because storytracer has its own webbrowser I can silently (or visible, a choice I'll need to make) navigate to this file and execute it and this way update the database.
This would mean that next to my sql command you could adapt it to your own tables and even insert the same information into another table and this way integrate it with your own website and execute other functions. This will give an almost total freedom of how the information will be handled.
Well I better get started on those functions ^^
Hope they'll be usefull
Cheers
Jozef
Now things are getting close to a release so I thought I'd post some more technical information for those interested ^^.
Before I talked of using a remote database but it seems like a lot of hosts dont allow remote connections so I had to come up with something different.
Another problem was that some projects who might be interested have their forums, websites etc and I can't ask them to adapt to Storytracer but it should work the other way around.
So I came up with the idea of using "php" files.
Very simple ones. Just with some SQL code that is easy to change. I'll call them php templates from now ^^.
So how do I plan on making this work.
For each type of info from a movie (scene, character, age, props etc) I create a basic php file that will stock some information into the db. so when the "upload" function is called to put a file online, the php template will be loaded into storytracer the template vilues like name, id etc will be replaced with the actual information from the local database. A new php file will be written according to the template. The file will be uploaded and because storytracer has its own webbrowser I can silently (or visible, a choice I'll need to make) navigate to this file and execute it and this way update the database.
This would mean that next to my sql command you could adapt it to your own tables and even insert the same information into another table and this way integrate it with your own website and execute other functions. This will give an almost total freedom of how the information will be handled.
Well I better get started on those functions ^^
Hope they'll be usefull
Cheers
Jozef
Total Comments 2
Comments
 |  That sounds like a cool idea... What you could do I suppose is when installing, or asking for database information, is to ask the user what their tables are called and then substitute the default values for those entered, and that way minimise the amount of sql statements that need to be edited as sql can be a little confusing for those who have notused it before. Just an idea that I thought of  Also, in regards to the 'script' section.....how does ST pull this in? does it parse a DOC file? or something else? Just trying to figure it out in my head. TheMightySpud |
Posted 12-07-2007 at 03:34 PM by TheMightySpud  |
| |  Thanks Paul, (sorry, hehe didnt reply to your pm yet only just saw it.... I don't get a notification when they arrive :s) Yups that sounds like a good idea to me as well. But I'm a bit afraid it should already go in the more advanced options. A "normal" user should be able to start the program, give his/her website and get going lol ^^ (this won't be working I'm afraid but well) The script it is actually a simple text editor with one extra function that will allow file versioning and uploading of the versions. So you can load .txt, .rtf probably .doc as well (I hope ) but It doesn't do much after that. The true "core" for which you could use the script is the storyline where you'll have a visual overview over the complete script and be able to move things around .Maybe in a next version I might take the script editor a little further though but I'd better get the first one ready hehe. I'm off to reading the info on ur website. thanks for the comment cheers Jozef |
| Posted 12-07-2007 at 06:29 PM by The_Caveman |
Recent Blog Entries by The_Caveman
- Storytracer "some updates" (01-18-2008)
- Storytracer "the return" (01-06-2008)
- Storytracer "Moving" (12-25-2007)
- Storytracer "The next step" (12-17-2007)
- Storytracer "some technical info" (12-07-2007)
