Automatic changes in "Custom Field Descriptions" Automatic changes in "Custom Field Descriptions"
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Automatic changes in "Custom Field Descriptions"

Started by AlexBarTender, December 05, 2008, 01:13:53 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

AlexBarTender

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.

Nibbler

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'.

AlexBarTender

Quote from: Nibbler on December 05, 2008, 01:39:01 AM
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

Quote from: Nibbler on December 05, 2008, 01:39:01 AMYou 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

AlexBarTender

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'".

Nibbler

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.

AlexBarTender


AlexBarTender

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