Need mySQL Help

[cpv1st]

as i am not an mysql pro i need a little help installing CVV 1.23 there are 4 steps the second one i am having trouble with

 

INSERT INTO configuration VALUES( 136, 'CVV2 Number', 'CVVNUMBER_MIN_LENGTH', 3, 'Minimum Length of CVV2 Number', 2, 17, '2003-02-20 10:30:00', '2003-02-20 10:30:00', NULL , NULL );

 

i am not sure where to put what in the correct line provided for the configuration table....here are my choice to input into the above...

 

function null Value

configuration_id ________ ___ ________

configuration_title ________ ___ ________

configuration_key ________ ___ ________

configuration_value ________ ___ ________

configuration_description ________ ___ ________

configuration_group_id ________ ___ ________

sort_order ________ ___ ________

last_modified ________ ___ ________

date_added ________ ___ ________

use_function ________ ___ ________

set_function ________ ___ ________

[mugitty]

Assuming that your table (configuration) has already been created, you should be able to just run the INSERT as an SQL command via phpMyAdmin or similar interface

[cpv1st]

command start at values or is the whole string this

 

 

INSERT INTO configuration VALUES ( 136, 'CVV2 Number', 'CVVNUMBER_MIN_LENGTH', 3, 'Minimum Length of CVV2 Number', 2, 17, '2003-02-20 10:30:00', '2003-02-20 10:30:00', NULL , NULL );

 

thanks again for your help mugitty.....

[mugitty]

Use the whole string

 

INSERT tells the program to insert the record that follows

INTO tells it which table

VALUES tells it the specific values, in order, with which to fill the record

[cpv1st]

thanks again for your help...i just ran the string..thanks...i like the chocolate lab by the way....i have a yellow one she is 5 years old...thank you again...by the way do you know how to alter the text and or the links inside the email that is sent to the customer after you update the order status (pending, processing, shipping) in the admin , then you can hit send and the customer recieves an email of the current status of thier order.....if you can help great...if not ..great too..you have been plenty help already.... :D

[mugitty]

Take a look at this thread (and there are probably others)

The files that you may need to touch to change the link and the text are most likely going to be:

 

admin/includes/languages/english/orders.php

admin/orders.php

 

I must admit that I haven't played with changing those items, but those should be the files involved.

 

(Actually, I believe that he's mostly Vizsla - but he's a foundling, so I can't be sure. What I do know for sure is that I've never seen another puppy with more energy than what he displays constantly :!:

[toolcrazy]

(Actually, I believe that he's mostly Vizsla - but he's a foundling, so I can't be sure. What I do know for sure is that I've never seen another puppy with more energy than what he displays constantly

 

I don't know about that. I've got a Lab/shepard mix puppy(Cody) that is 10 months old. I don't know if he ever runs out of energy.