Custom Computer Creator

[rdcoy]

:unsure: I'm not sure if this is off topic for this post, but here it goes.

 

I am trying to install the Custom Computer Creator contribution and I have hit a snag. I had no problems at all replacing the script in the correct places, but I have no idea what to do with this:

 

DROP TABLE IF EXISTS `ccc`;
CREATE TABLE `ccc` (
 `ccc_id` int(11) NOT NULL auto_increment,
 `ccc_category` varchar(45) NOT NULL default '',
 `ccc_cname` varchar(45) NOT NULL default '',
 `ccc_amd_hidden` char(1) NOT NULL default 'n',
 `ccc_amd_req` char(1) NOT NULL default 'n',
 `ccc_intel_req` char(1) NOT NULL default 'n',
 `ccc_intel_hidden` char(1) NOT NULL default 'n',
 KEY `ccc_id` (`ccc_id`)
) TYPE=MyISAM;

#
# Dumping data for table `ccc`
#

INSERT INTO `ccc` VALUES (1, '1', 'Intel MotherBoards', 'y', 'n', 'y', 'n');
INSERT INTO `ccc` VALUES (2, '2', 'Intel Processors', 'y', 'n', 'y', 'n');
INSERT INTO `ccc` VALUES (3, '3', 'AMD MotherBoard', 'n', 'y', 'n', 'y');
INSERT INTO `ccc` VALUES (4, '4', 'AMD Processors', 'n', 'y', 'n', 'y');
INSERT INTO `ccc` VALUES (5, '5', 'DDR Memory', 'n', 'n', 'n', 'n');
INSERT INTO `ccc` VALUES (6, '6', 'Hard Drives', 'n', 'n', 'n', 'n');
INSERT INTO `ccc` VALUES (7, '7', 'Video Cards', 'y', 'n', 'y', 'n');
INSERT INTO `ccc` VALUES (8, '8', 'Computer Cases', 'n', 'n', 'n', 'n');
INSERT INTO `ccc` VALUES (9, '9', 'Operating Systems', 'n', 'n', 'n', 'n');
INSERT INTO `ccc` VALUES (10, '10', 'Sound Cards', 'n', 'n', 'n', 'n');
INSERT INTO `ccc` VALUES (11, '11', 'Modems', 'n', 'n', 'n', 'n');
INSERT INTO `ccc` VALUES (12, '12', 'Network Cards', 'n', 'n', 'n', 'n');
INSERT INTO `ccc` VALUES (13, '13', 'CD-ReWriters', 'n', 'n', 'n', 'n');
INSERT INTO `ccc` VALUES (14, '14', 'DVD Roms', 'n', 'n', 'n', 'n');
INSERT INTO `ccc` VALUES (15, '15', 'tester', 'n', 'n', 'n', 'n');

# --------------------------------------------------------

#
# Table structure for table `ccc_products`
#
# Creation: Sep 28, 2003 at 01:17 AM
# Last update: Sep 28, 2003 at 04:44 AM
#

DROP TABLE IF EXISTS `ccc_products`;
CREATE TABLE `ccc_products` (
 `products_id` int(5) NOT NULL auto_increment,
 `products_image` varchar(255) NOT NULL default '',
 `products_description` varchar(255) NOT NULL default '',
 `products_language` char(3) NOT NULL default '',
 `products_name` varchar(255) NOT NULL default '',
 `products_catid` varchar(5) NOT NULL default '',
 `products_model` varchar(255) NOT NULL default '',
 `products_price` decimal(15,2) NOT NULL default '0.00',
 `products_sys` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`products_id`)
) TYPE=MyISAM;

 

If anyone could give me a clue as to what this is written in and where to implement the changes to the product database, that would be :P great!

 

I'm pretty good with the MySQL command line interface but this looking nothing like an SQL script.

 

Thanks again,

Rob

 

A wise man once said: "Never take a sleeping pill and laxative at the same time."

[Guest]

I'm pretty good with the MySQL command line interface but this looking nothing like an SQL script.

What do you expect a MySQL script to look like? That's all that is, just a bunch of MySQL commands. If you save that text as a file named ccc.sql, you could load it into a database with mysql commands like

 

use database_name;

source ccc.sql;

 

You could also type the lines in manually if you prefer.

 

In general, posts about contributions belong in the Contributions General Support forum.

 

Hth,

Matt

[Guest]

In general, posts about contributions belong in the Contributions General Support forum.

 

Well the last time I checked this was the Installation and Configuration board. And he was having an Instillation issue, so I guess this would be the place to ask it. But thats just my thought on this post "In General".

 

It never stops to amaze me, a simple question from someone who needs a little help and he gets a a cocky answer and criticized.

 

 

The answer to you question is they represent tables in your database that need to be created.

[Guest]

He said that he wasn't sure if this was the right place. I not only answered his main question (how to process that info, which you didn't), but also his side question (where should I have posted this).

 

It's amazing to me that some people would rather criticize others than make a serious effort to help. The post included 3 questions:

 

1. Where should this kind of post be put? This forum is for posts about installing and configuring the core code of osCommerce. This may seem trivial to you, but one of the difficulties of searching the forums is the large number of irrelevant posts through which one must wade to find useful answers. It would be helpful to keep this to a minimum. As the poster raised the issue, I pointed out that the Contributions area exists to allow people to ask questions about Contributions. Asking the question there makes it easier to find answers in the future; looking for answers there makes it easier to find answers now. He asked, I provided an answer. Despite your criticism, I still maintain that my answer was correct. This kind of post is best suited for the Contributions General Support forum, which is where one discusses installing contributions.

 

2. In what is that code written? The answer is that it is in MySQL.

 

3. Where to implement the changes? I would normally answer phpMyAdmin, but he mentioned the command line interface. Therefore, I gave instructions for that.

 

You sort of answered a fourth question, which he didn't ask: what does the code do. Your answer to this unasked question was somewhat correct if unhelpful (how does he create those tables?).

 

Cocky? Perhaps. I was faced with a simple problem. He asked what it was and then said that he didn't think that it was what it was (a SQL script).

 

Criticised? I didn't criticise him, other than by pointing out that he was incorrect about it not being SQL commands and telling him where this kind of post belongs. All I was trying to do was answer his questions. My answers were only critical in the sense that they disagreed with what he had already done. When someone is doing something incorrectly (and asks if they are), should I just ignore them because correcting them would be critical?

 

Cheers,

Matt

[Guest]

I will agree that the search feature is a bit difficault do to all the repeated posts. The only point I was trying to make was that the way you worded the post seemed to be a bit cocky, in the sense of not all know as much as us or many others who come here to get and give help. To some one that has no clue and is asking for some help that probably seemed a bit harsh for an answer.