Please Help (Linda Download Controller)

[happyyo]

Hi guyss :)

 

I have checked about this question but I couldnt find it...... I have set up the Lindas download controller; I have no idea what to do with the downloads_controller.sql file.

 

What do i do with that file?? upload it somewhere?? add its content to some other sql file??

 

Thanks a lot in advanceeeeeeeee :) :) :)

[1quicksi]

When a contribution has a .sql file generaly it contains commands to make changes/alter your database. First off BACK YOUR DATABASE UP, second see first step ;) Next you will need to open the file and cut and paste the text within phpMyAdmin and comit the changes.

 

Hope that helped...

[happyyo]

:) Thanksss a lot for your help :) ..... but I am very new in database so I would need a little more of help :)

 

The downloads_controller.sql is this:

 

 

#NEW FIELDS FOR DOWNLOADS CONTROLLER

 

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Downloads Controller Update Status Value', 'DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE', '4', 'What orders_status resets the Download days and Max Downloads - Default is 4', '13', '90', '2003-02-18 13:22:32', '', NULL , NULL);

 

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Downloads Controller Download on hold message', 'DOWNLOADS_CONTROLLER_ON_HOLD_MSG', '<BR><font color="FF0000">NOTE: Downloads are not available until payment has been confirmed</font>', 'Downloads Controller Download on hold message', '13', '91', '2003-02-18 13:22:32', '', NULL , NULL);

 

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Downloads Controller Order Status Value', 'DOWNLOADS_CONTROLLER_ORDERS_STATUS', '2', 'Downloads Controller Order Status Value - Default=2', '13', '92', '2003-02-18 13:22:32', '', NULL , NULL);

 

Hmmmmmm any ideas please??????

 

Thanks a lot in advance :) :)

[1quicksi]

No problem at all I can walk you through this step by step a it is very easy :)

 

Before we do anything lets get some basic information of your system.

 

First off how did you create your OSC database? Do you have phpMyAdmin installed? Which version are you running?

[happyyo]

hello again :)

 

Thanksssssss a lot for your help 1quicksi :rolleyes: :rolleyes:

 

I installed oscommerce with just a "mouse click" through the C-panel (Fantastico) in my hosting account. Automatically it created the data base. And yess, i have phpMyAdmin installed.

 

If u need more information, just let me know.

 

Thankssssssssss again for your help :rolleyes: :rolleyes:

 

It is great to find people like u around here :)

 

Regardsssssss

Laura

[1quicksi]

1. Backup your database.

2. Backup your database.

3. Did I mention to back up your database? Laff...

 

Ok in phpMyAdmin you first need to select the database from the drop down box on the left. Now at the top of the screen you should have a bunch of tabs. Click on the one that says SQL. This will bring up a new screen and you should have a rectangular dialog box that is titled "Run SQL query/queries on database xxx" or something very simular depending on what version you are running. Next you need to take the text from that .sql file and cut and past it into the dialog box EXACTLY. Now double check to make sure the text is EXACTLY the same (ie periods, brackets, semi-colons, etc) Then click on "Go" You should next get a message that the command was properly executed.

 

That is all there is to it :D

 

The other option is to use the browse option and le tthe system upload but I have seen instances of larger files fail to properly execute this way.

 

Hopefully your control panel lets you administer the database at this level. If not you wil need to have your provider give you the proper privlidges.

 

If this is confusing or are unsure PM me and we can walk thorugh this in e-mail.

 

Good luck :)