24 replies to this topic

[Cris D.]

File Name: EtogalExtenderSuiteV1(beta)
File Submitter: Cris D.
File Submitted: 12 Jul 2007
File Updated: 19 Jul 2007
File Category: Images & Galleries

//Snippet EtogalExtender 1.3
//By Cris D. 12/7/07
//Use: When placed in the same page as etogal, it creates and shows additional fields displayed on the same page as an etogal //image.
//A new table can be added for each etogal gallery or use the default table name for all galleries.
//Table names and unlimited column names are added via the snippet call like this:
//[!EGextender?tableName=your_table_name&colnames=lable1,lable2,lable3,lable4,lable5,lable6!]
//If the default table is used, THE COLNAMES MUST BE IDENTICAL for each use of the snippet.
//Otherwise, a different table name and unique colnames can be set for every etogal gallery.
//Style used for the presentation of the additional info for the CSS: <table style="eg_addon">
//Future development: compare etogal and tableName to delete tableName rows that correspond to deleted etogal rows

##################### Snippet Configuration Here #######################

$etoPrefix="etomite_";//set this to the prefix of your etomite installation
$etogal=$etoPrefix."etogal";//set this to the name of your etogal installation
$defaultTableName="egExtender";//set the default table name here (optional)
$colan=" : ";//set this to the preferred divider between the field lable and the data,
//remove if just the etogal title and description are required.
//The rest happens from the snippet call: set the additional table names and colnames (as described above).

This snippet does the following:
For surfers, it just shows the additional data entered like EGPicInfo.

For Admin, once logged in, and zoomed to a single etogal picture, a new table and form is created that allows you to enter the data for surfers to see.

You can also use etogal in the normal way and edit the title and description and upload and delete pictures via the "Manage Pictures" button.

The snippet is well commented for customisation.

Instructions: 1) Install and populate Etogal. 2) Download this snippet and save it in your snippet library. 3) Call the snippet in the same page as etogal (include your tableName(optional) and colnames (required) parameters). That's it!

The snippet counts the number of colnames you put in the snippet call and automatically creates the table fields and form fields to enter and store the data.
CHANGELOG:
14/7/07 Changed the authentication method to make it more secure.
Updated file to fix a typo //(to comment out a comment regarding the changelog!).

Click here to download this file

[Cris D.]

Please note: If you download and install this snippet and get the error:

Parse error: syntax error, unexpected ':' in /home/www/your_site.com/index.php(506) : eval()'d code on line 11

I have re-uploaded the snippet twice but for some reason, the old snip is being returned with the typo. Just change the snippet line 11

CHANGELOG:14/7/07 Changed the authentication code to make it more secure.

to

//CHANGELOG:14/7/07 Changed the authentication code to make it more secure.

note the added "//".

Now I know this is simple, but could cause frustration for some if they new nothing

Note: It is relatively easy to change the table-based output to div-based output which means you can control the positioning of the add-on fields fairly easily.

Also, the default table column type is varchar 100, once the table has been created, you could change the column type with phpMyAdmin and keep the column name the same before you start entering data. This would be good to include things like timestamps, urls, binary etc. (some modifications may have to be made to the entry form and data handling section of the snippet).

For a live sample, fields beside the picture or fields above the picture. Be aware that you can not see the manager's form, just what the browsers see.

Edited by Cris D., 19 July 2007 - 09:34 AM.

[cathode]

Cris,
I finally tried this snippet- it works great and really opens up EtoGal to a wide variety of uses. Home listings, for instance would be simple now.

[darren]

Cris,
could this be used to add and manage columns on the etomite_etogal table or does it have to be a new table. I just need to save height and width for each image so it's available in a snippet... either by hand or maybe on the fly, i don't know yet.

thanks,

[mikef]

Darren, if you're going to do a lot of these you might want to look at using styles in the EtoGalThumbs snippet, as it picks up width and height from the image files, and allows some flexibility in selecting which images/galleries to use. Its not just for putting thumbnails onto pages (though thats how it started). There's an example of generating an RSS feed with it, and one for the thickbox slideshow (or one of the similar slideshows), either in the code or the etogal subforum.

Edited by mikef, 16 September 2008 - 12:02 AM.

[darren]

I like that snippet for some applications, even got a mootools scrolling thumbnail div integrated into it for a site. I'm just trying to get a batch of flash/etoGal integrations to have in my back pocket. This one in particular requires height and width to be set in the xml list so i'm just trying to see how that's going to work.

being able to present a flash photo gallery that a non-techical user can create and modify would, in my case, 'catch me up with the competition' so to speak. whether or not it is 'better' to use flash is another argument entirely

You and Cris have done an awesome job developing and extending etoGal, it's opened another dimension to what we can do with etomite. Thanks!

[Cris D.]

This stores data in a separate table, but they are cross-refrenced so the info is pulled from table 1 (etogal) and also from the corresponding row in table 2 (etogal_extender). It has it's limitations- I have not written a delete coresponding row code when an etogal image is deleted... Having said that, I think php would be a much better option for pulling image dimensions out to use as there are built-in php functions for this. [edit] To use this, you will have to look at building arrays for use in the XML code and looping through the results. etogal_multigals creates a simple array which can be extended with php code to add image width and height fields as well as mike f's etogalThumbs, but you could easily write your own using getIntTableRows and adding it to your XML snippet. [/edit]

By the way... love your collection of integrations you are creating! Awsome job darren!

Edited by Cris D., 16 September 2008 - 07:55 AM.

[darren]

By the way... love your collection of integrations you are creating! Awsome job darren!

thank you
you are correct, it was easier to use getimagesize to obtain the w/h...

[cathode]

thank you
you are correct, it was easier to use getimagesize to obtain the w/h...

Looking great, fantastic work! Have you thought about converting some non-flash viewers, such as ibox?

[darren]

Looking great, fantastic work! Have you thought about converting some non-flash viewers, such as ibox?

I'm working on something similar to that next, (lightbox slideshow) however i do have to 'work' every once in a while.

[doolB]

Hi

I have installed the Extender but i recive at error.

CREATE TABLE`etomite_etogal_shop_01`(`ai` INT(100) NOT NULL AUTO_INCREMENT,`id` INT(100) NOT NULL,Colour VARCHAR (100),Price VARCHAR (100),lable3 VARCHAR (100),lable4 VARCHAR (100),lable5 VARCHAR (100),lable6 VARCHAR (100),PRIMARY KEY (`ai`),UNIQUE (`id`)) TYPE=myisam;

I don't know alot about SQL so I don't know where to start the debugging.

Can someone please help

Thanks
Thomas

[Cris D.]

It is a bit difficult to determine what is wrong with this with just the SQL error, the implementation is more important. Please answer:
1) Do you already have etogal installed and populated with images?
2) Are you placing this on the same page that has etogal added via a separate snippet?
3) Have you successfully added this to other pages yet?
4) Have you changed any of the table names for etogal or this snippet?
5) Please provide the snippet call you are using to attempt to add this to the page.

I do know that if you use a table name in the snippet call and attempt to re-use the same name with different columns it with new columns, you will get an error. It has been a long time since I have used this code and it amazes me when I look at it how amaturish the formatting and use of variables is... a bit of a walk down memory lane. But is should work.

The only other item that looks odd is the loss of back-ticks, you could also try changing line 70:

$sql.=$n." VARCHAR (100),";

with this:

$sql.="`".$n."` VARCHAR (100),";

[Ralph]

doolB, you posted the SQL statement but not the actual error message... What was the message itself...???

EDIT: After looking at the query it appears that some of the field/column names are not nested within backticks... While both with and without all of them having backticks works in my phpMyAdmin it may not work on all servers when sent via PHP/MySQL script...

[doolB]

It is a bit difficult to determine what is wrong with this with just the SQL error, the implementation is more important. Please answer:
1) Do you already have etogal installed and populated with images?
2) Are you placing this on the same page that has etogal added via a separate snippet?
3) Have you successfully added this to other pages yet?
4) Have you changed any of the table names for etogal or this snippet?
5) Please provide the snippet call you are using to attempt to add this to the page.

I do know that if you use a table name in the snippet call and attempt to re-use the same name with different columns it with new columns, you will get an error. It has been a long time since I have used this code and it amazes me when I look at it how amaturish the formatting and use of variables is... a bit of a walk down memory lane. But is should work.

The only other item that looks odd is the loss of back-ticks, you could also try changing line 70:

$sql.=$n." VARCHAR (100),";

with this:

$sql.="`".$n."` VARCHAR (100),";

Thanks for using your time to help me with this. This codes are almost 2 years old, I guess that it takes a bit of digging. hehe.

For your quistions....
1) Yes
2) Yes
3) No
4) No
5) [!EGextender?colnames=lable1,lable2,lable3,lable4,lable5,lable6!]

I have made the change to line 70 and now I get this.
CREATE TABLE`etomite_etogal_egExtender`(`ai` INT(100) NOT NULL AUTO_INCREMENT,`id` INT(100) NOT NULL,`lable1` VARCHAR (100),`lable2` VARCHAR (100),`lable3` VARCHAR (100),`lable4` VARCHAR (100),`lable5` VARCHAR (100),`lable6` VARCHAR (100),PRIMARY KEY (`ai`),UNIQUE (`id`)) TYPE=myisam;

Thomas

[Ralph]

doolB, are you actually getting a MySQL error or just the query string...??? Either Etomite, PHP, or MySQL is going to throw an error if one is encountered...

Also, are you on a hosted server or running in localhost mode on a WAMP server...???

[Cris D.]

The SQL error above does not even come close to matching the first one. If we are going to help de-bug, you will need to be very particular about what you change.

The first one is pointing to table etomite_etogal_shop_01 and the second is etomite_etogal_egExtender
The first's columns are: Color, Price, lable3, lable4, lable5, lable6 the second is lable1, lable2, lable3, lable4, lable5, lable6 So I'm guessing your snippet call has also changes from the first to the second.

It is too hard to diagnose when so many changes are being made at once, and if it then works, no-one knows what it was that fixed it. Errors like this can be caused by a single stray comma or missing space etc, so detail is important.

As Ralph asked earlier... Is this an etomite error message?

[doolB]

Ok sorry, I will try to be precise.

Since my first post I have changed the call back to using the default table (egExtender) and the default labels. In my first try i made some changes, but since that didn't work I changed every thing back to default. (as found in the example)
I have not made any changes to the script at all. In the call I have removed "tableName=your_table_name". I have looked in SQL database for the tabels but I found neighter etomite_etogal_shop_01 or etomite_etogal_egExtender
In the database I found a table named etomite_etogal, so I guess that the EtoGal is working fine. (I know it is)


My call

[!EGextender?colnames=lable1,lable2,lable3,lable4,lable5,lable6!]

This is the full error massage when I am Loged in.

« Error »
Etomite encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed »
SQL: CREATE TABLE`etomite_etogal_egExtender`(`ai` INT(100) NOT NULL AUTO_INCREMENT,`id` INT(100) NOT NULL,`lable1` VARCHAR (100),`lable2` VARCHAR (100),`lable3` VARCHAR (100),`lable4` VARCHAR (100),`lable5` VARCHAR (100),`lable6` VARCHAR (100),PRIMARY KEY (`ai`),UNIQUE (`id`)) TYPE=myisam;

And the error massage when I am not Loged in.

« Error »
Etomite encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed »
SQL: SELECT * FROM `web297763`.etomite_etogal_egExtender WHERE id=1 ;

[Cris D.]

OK, I just copied and pasted the SQL code above directly into phpMyAdmin into the SQL query section and it worked perfectly. I'm thinking that this is a database version issue.

1) Please provide your stats for:
php version,
SQL version,
PHPMyAdmin version,
Etomite version
Server type

2) Please attempt to create the table by copying and pasting the following code directly into your database:

CREATE TABLE`etomite_etogal_egExtender`(`ai` INT(100) NOT NULL AUTO_INCREMENT,`id` INT(100) NOT NULL,`lable1` VARCHAR (100),`lable2` VARCHAR (100),`lable3` VARCHAR (100),`lable4` VARCHAR (100),`lable5` VARCHAR (100),`lable6` VARCHAR (100),PRIMARY KEY (`ai`),UNIQUE (`id`)) TYPE=myisam;

and let me know if it was successfully created. If not, what was the error? This will determine whether it is a database issue or an etomite issue.

[Ralph]

doolB, you can get all of the information CrisD asked for, which is usually standard procedure earlier on than this, by going to Etomite Manager > System info > Server information > PHP info: View... Look in the appropriate sections for the information requested... Some software combinations just have a hard time running CREATE TABLE scripts from within Etomite and it could be for any of several reasons ranging from MySQL user rights to PHP version release quirks...

[doolB]

Hi,

I really appreciate your help, Thanks.

1)
php version, 5.2.6
SQL version, Client API version - 5.0.51a
PHPMyAdmin version, 2.11.7.1
Etomite version, 1.1 Prelude
Server type, Apache 2.0 Handler

2)
I managed to run the SQL code as you suggested. It was a success. ;-)
Now it looks like that the Extender is working to some extension. (the default labels are not very useful)

I have trouble with the “manage file” function in Etomite. (but that I will fix later, I hope)
I have just installed PoMMo in a sub dir on the same server and the table creation went well. But I was running php in safe mode and I had to manually create the dir for PoMMo installation.

I don’t know if there is any relation between this and the SQL error.

Thomas N