Advanced search  

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]

Pages: [1]   Go Down

Author Topic: Automatic changes in "Custom Field Descriptions"  (Read 3934 times)

0 Members and 1 Guest are viewing this topic.

AlexBarTender

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 43
Automatic changes in "Custom Field Descriptions"
« 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.
Logged

Nibbler

  • Guest
Re: Automatic changes in "Custom Field Descriptions"
« Reply #1 on: December 05, 2008, 01:39:01 am »

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

Code: [Select]
UPDATE cpg_pictures SET user1 = user1 * 1.3
Change cpg_ to the prefix you chose during installation and user1 to whatever corresponds to 'price'.
Logged

AlexBarTender

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 43
Re: Automatic changes in "Custom Field Descriptions"
« Reply #2 on: December 05, 2008, 02:00:10 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

You can update the fields using phpMyAdmin. Run a query like

Code: [Select]
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
Logged

AlexBarTender

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 43
Re: Automatic changes in "Custom Field Descriptions"
« Reply #3 on: December 05, 2008, 03:56:53 am »

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

Nibbler

  • Guest
Re: Automatic changes in "Custom Field Descriptions"
« Reply #4 on: December 05, 2008, 01:28:56 pm »

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

AlexBarTender

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 43
Re: Automatic changes in "Custom Field Descriptions"
« Reply #5 on: December 05, 2008, 03:26:52 pm »

Thanks :D I will try and I will tell you if works
Logged

AlexBarTender

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 43
Re: Automatic changes in "Custom Field Descriptions"
« Reply #6 on: December 06, 2008, 01:33:09 am »

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
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 19 queries.