Icy Phoenix

Archived phpBB Topics (Styles, Mods, Support) - FAP CUSTOMIZATION - [BETA]FAP 1.4.1 - SQL Generator V0.2

Sorren [ Mon 25 Feb, 2008 19:15 ]
Post subject: FAP CUSTOMIZATION - [BETA]FAP 1.4.1 - SQL Generator V0.2

Hallo,
I've programmed a SQL generator for FAP 1.4.1 in Java. I hope you can understand it

Function:
First start the SQL-Gerator then go in options and modificate the fields for your album.
Then save and close the option Frame. After that you have to chose the path and then press create SQL.
In the dictory, where the pics are, is the generated SQL as an .txt file.

I hope you can understand my bad english

Bye Sorren

New version: v0.2

History:
01.03.08: Bug with " ' " in generated SQL fixed
27.02.08: SQL Preview added, Options in the main window, Bug .JPG solved, complete translation in english

Mighty Gorgon [ Tue 26 Feb, 2008 00:40 ]
Post subject: Re: [BETA]FAP 1.4.1 - SQL Generator V0.1

Wow, this could be very useful for users like me which usually upload pics manually.

I will have a try next time I need to upload pics in my album.

Thank you for sharing!

TheSteffen [ Tue 26 Feb, 2008 21:48 ]
Post subject: Re: [BETA]FAP 1.4.1 - SQL Generator V0.1

Thanks for sharing Sorren,

I will have a look at it.

Sorren [ Tue 26 Feb, 2008 21:55 ]
Post subject: Re: [BETA]FAP 1.4.1 - SQL Generator V0.1

That would be great

And if you find some bugs, please post it here

buldo [ Wed 27 Feb, 2008 15:31 ]
Post subject: Re: [BETA]FAP 1.4.1 - SQL Generator V0.1

Good work, it seems to work fine, but I, at the moment, prefer the "old" Excel sheet provided by MG.

Some tips/ideas:
- Why don't you include options fields directly in main winodow?
- I think that could be be useful if you may also provide an SQL preview.

Bugs:
- Files that have capital letters extension will not be included in SQL_generated.txt (eg. "image.PNG")

Minor thing:
- Some messages (when you restart the program) are in German.

Ciao,

Sorren [ Wed 27 Feb, 2008 16:50 ]
Post subject: Re: [BETA]FAP 1.4.1 - SQL Generator V0.1

OK thanks for your ideas

If corrected the Problem with the diffrent endings of the pics.
Now the program see .jpg, .JPG, .png, .PNG, .gif, .GIF .

Now in the DOS-Box are all comments on english

I think, i change the Option window in the main window. But not now

later.
And a preview? Do you mean a textfield and in it is the hole SQL Code?

Bye Sorren

buldo [ Wed 27 Feb, 2008 17:53 ]
Post subject: Re: [BETA]FAP 1.4.1 - SQL Generator V0.1

Sorren wrote: [View Post]
Now the program see .jpg, .JPG, .png, .PNG, .gif, .GIF .

Sorren wrote: [View Post]
Now in the DOS-Box are all comments on english

Sorren wrote: [View Post]
And a preview? Do you mean a textfield and in it is the hole SQL Code?

Yes, bur not hole SQL, just the first query.

Sorren [ Wed 27 Feb, 2008 18:36 ]
Post subject: Re: [BETA]FAP 1.4.1 - SQL Generator V0.1

OK, thats an intresting idea ... i see what i can do

Sorren [ Wed 27 Feb, 2008 19:51 ]
Post subject: Re: [BETA]FAP 1.4.1 - SQL Generator V0.1

ok i've solved your ideas

i hope you can give me more of them

TheSteffen [ Wed 27 Feb, 2008 21:51 ]
Post subject: Re: [BETA]FAP 1.4.1 - SQL Generator V0.2

Good work, but at the moment I prefer the "old" Excel sheet provided by MG because I want to insert more than one pic at once.

Anyway, thanks for sharing it.

Sorren [ Wed 27 Feb, 2008 22:55 ]
Post subject: Re: [BETA]FAP 1.4.1 - SQL Generator V0.2

^^ you haven't understand the program, the program can generate a sql syntax of a hole dictonary! ... Not only one picture, mark one picture in your dictonary klick on create SQL an then see into the marked dictonary. In it is the file SQL_generated.txt which contains for every picture a SQL statement.