forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: AlexBarTender on December 05, 2008, 01:13:53 am
-
Good evening, my best regards for the community.
My question is as follows: I need do automatically changes in "Custom Field Descriptions"
I will explain better, I created one, call "Price", and I have a lot of images. So, change 1 for 1 is very upset.
Is possible do some variable do for this automatically changes? I mean, that all images are changed, in this field, increase in 30% for example. Or maybe, write this data in "excel" or "access" and import to Data Base in this field.
Very thank you for your answers.
-
Please don't ask the same question in multiple languages, it just wastes peoples' time.
You can update the fields using phpMyAdmin. Run a query like
UPDATE cpg_pictures SET user1 = user1 * 1.3
Change cpg_ to the prefix you chose during installation and user1 to whatever corresponds to 'price'.
-
Please don't ask the same question in multiple languages, it just wastes peoples' time.
Please, I'm very sorry for that. I just thought that maybe if in Spanish nobody know how to do this in other maybe yes. But is true when you tell me that "I wastes peoples' time". I don't thought this when I did
You can update the fields using phpMyAdmin. Run a query like
UPDATE cpg_pictures SET user1 = user1 * 1.3
Change cpg_ to the prefix you chose during installation and user1 to whatever corresponds to 'price'.
I will try to do this, but can you explain me more? Please.
I don't know almost none about "phpmyadmin", I know how create my data base and look some tables for small changes, but I never did something like that
-
My friend. I saw where is the things that you said to me.
I attachment a file with a pic
You can see in the image that cpg_ is same and user1 is right there but I don't know what you mean with "user1 to whatever corresponds to 'price'".
-
Click on 'browse' and see which of the 'user' columns contains the price information and use that column name instead of user1. To run the query click the 'SQL' tab and enter the query there and press 'Go'. Make a backup of the pictures table first if you are not comfortable making the changes.
-
Thanks :D I will try and I will tell you if works
-
My friend. Wonderful
Works better that perfect.
I don't know how to thank you.
solved
If you could rate you for your reply and cordiality. Perfect score