Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * * 1 votes

Custom Computer Creator v9 Support


538 replies to this topic

#81 carloshax

  • Community Member
  • 69 posts
  • Real Name:carl
  • Location:kent, UK

Posted 01 January 2004, 16:36

Right i have installed this contrib now and have the following problem:

When i enter admin and hover over "custom computer" button i see http://www.themodhouse.co.uk/test/admin/FI...d_box=ccc&cID=1, and obviously link does not work. I take it you have to alter settings in admin to be able to see anything different on the site. So any ideas whats wrong with this so i can test the store side of it please.

You can see what i mean by looking at my admin as its only my test store but please do not alter anything.

www.themodhouse.co.uk/test/admin

Thx
Carl

#82 Unified

  • Community Member
  • 97 posts
  • Real Name:Jiten
  • Location:London

Posted 02 January 2004, 00:17

hello guys

Sorry i have been away a few days.

I have a complete working version and will upload it today.

Stephen has got a new version where images can be shown. Unfortunately I have not got it to work yet.

Stephen is great for trouble shooting and with his help I will hopefully get it to work soon!

Regards Jiten

#83 blueinfinity

  • Community Member
  • 20 posts
  • Real Name:Shawn

Posted 02 January 2004, 17:45

um im having trouble with my mysql table do i have to make a new table or edit an older one?

and btw crlos

in admin/includes/filenames.php

add this in there

Quote

// CCC
define('FILENAME_CCC', 'ccc.php');

shoulkd work

can anyoen help me out on the databse? how do i create a new one?

please :)

#84 Unified

  • Community Member
  • 97 posts
  • Real Name:Jiten
  • Location:London

Posted 02 January 2004, 18:53

Hi blueinfinity

Johnson is helping me to put the complete contrib with fixes (thanx to stephen) together.

In the meantime here is the complete SQL you need to add: Using phpmy admin or whatever you may use apply the following SQL:

CREATE TABLE `ccc` (
  `ccc_id` int(11) NOT NULL default '0',
  `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',
  `fsb_100` char(1) NOT NULL default 'n',
  `fsb_133` char(1) NOT NULL default 'n',
  `fsb_266` char(1) NOT NULL default 'n',
  `fsb_333` char(1) NOT NULL default 'n',
  `fsb_400` char(1) NOT NULL default 'n',
  `fsb_533` char(1) NOT NULL default 'n',
  `fsb_800` char(1) NOT NULL default 'n',
  `fsb_111` char(2) NOT NULL default 'n',
  `fsb_222` char(2) NOT NULL default 'n',
  KEY `ccc_id` (`ccc_id`)
) TYPE=MyISAM;

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

CREATE TABLE `ccc_prebuilt` (
  `description` longtext NOT NULL,
  `product_id` int(10) NOT NULL auto_increment,
  `sys` varchar(10) NOT NULL default '',
  `price` decimal(5,2) NOT NULL default '0.00',
  PRIMARY KEY  (`product_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE `ccc_prebuilt_templates` (
  `sys` varchar(10) NOT NULL default '',
  `template` varchar(5) NOT NULL default '',
  `product1` varchar(30) NOT NULL default '',
  `product2` varchar(30) NOT NULL default '',
  `product3` varchar(30) NOT NULL default '',
  `product4` varchar(30) NOT NULL default '',
  `product5` varchar(30) NOT NULL default '',
  `product6` varchar(30) NOT NULL default '',
  `product_price1` decimal(4,2) NOT NULL default '0.00',
  `product_price2` decimal(4,2) NOT NULL default '0.00',
  `product_price3` decimal(4,2) NOT NULL default '0.00',
  `product_price4` decimal(4,2) NOT NULL default '0.00',
  `product_price5` decimal(4,2) NOT NULL default '0.00',
  `product_price6` decimal(4,2) NOT NULL default '0.00',
  `product_pic1` varchar(30) NOT NULL default '',
  `product_pic2` varchar(30) NOT NULL default '',
  `product_pic3` varchar(30) NOT NULL default '',
  `product_pic4` varchar(30) NOT NULL default '',
  `product_pic5` varchar(30) NOT NULL default '',
  `product_pic6` varchar(30) NOT NULL default '',
  `product_desc1` text NOT NULL,
  `product_desc2` text NOT NULL,
  `product_desc3` text NOT NULL,
  `product_desc4` text NOT NULL,
  `product_desc5` text NOT NULL,
  `product_desc6` text NOT NULL,
  `bigpic` varchar(50) NOT NULL default '',
  `product_count` varchar(5) NOT NULL default '',
  `product_name1` varchar(30) NOT NULL default '',
  `product_name2` varchar(30) NOT NULL default '',
  `product_name3` varchar(30) NOT NULL default '',
  `product_name4` varchar(30) NOT NULL default '',
  `product_name5` varchar(30) NOT NULL default '',
  `product_name6` varchar(30) NOT NULL default ''
) TYPE=MyISAM;

INSERT INTO `ccc_prebuilt_templates` VALUES ('amd', '2', 'motherboard', 'processor', 'memory', 'harddrive', 'cd-rom', 'dvd-rw', '50.00', '99.00', '45.00', '83.00', '99.00', '190.00', '', '', '', '', '', '', 'testing description number one', 'testing description number two', 'bobby', 'testing description number four', 'testing description number five', 'testing description number six', '', '6', 'Motherboard', 'Processor', 'Memory', 'Hard Drive', 'Cd-Rom', 'Dvd-Rw');
INSERT INTO `ccc_prebuilt_templates` VALUES ('intel', '1', 'motherboard', 'processor', 'memory', 'harddrive', 'cd-rom', 'dvd-rw', '50.00', '99.00', '45.00', '83.00', '99.00', '190.00', '', '', '', '', '', '', 'testing description number one', 'testing description number two', 'testing description number three', 'testing description number four', 'testing description number five', 'testing description number six', '', '6', 'Motherboard', 'Processor', 'Memory', 'Hard Drive', 'Cd-Rom', 'Dvd-Rw');

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_model` varchar(255) NOT NULL default '',
  `products_price` decimal(15,2) NOT NULL default '0.00',
  `fsb_100` char(1) NOT NULL default 'n',
  `fsb_133` char(1) NOT NULL default 'n',
  `fsb_266` char(1) NOT NULL default 'n',
  `fsb_333` char(1) NOT NULL default 'n',
  `fsb_400` char(1) NOT NULL default 'n',
  `fsb_533` char(1) NOT NULL default 'n',
  `fsb_800` char(1) NOT NULL default 'n',
  `intel` char(1) NOT NULL default 'n',
  `amd` char(1) NOT NULL default 'n',
  `cat_id` varchar(5) NOT NULL default '',
  `fsb_111` char(2) NOT NULL default 'n',
  `fsb_222` char(2) NOT NULL default 'n',
  PRIMARY KEY  (`products_id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE `ccc_temp_products` (
  `products_id` varchar(5) NOT NULL default ''
) TYPE=MyISAM;

ALSO Carl make sure you also add to admin/includes/filenames.php:

define('FILENAME_CCC', 'ccc.php');
define('FILENAME_ADD_MORE', 'add_more.php');

Regards

Jiten

Edited by Unified, 02 January 2004, 18:56.


#85 blueinfinity

  • Community Member
  • 20 posts
  • Real Name:Shawn

Posted 02 January 2004, 19:03

thanks

i have been playing and now i have a problem!!

when i do a test order and i get t the end page order confirm
it gives a total and proper shipping but in the products part

all it has is a single X then ont he other side it has 0.00

but int he next box it is totaled

any idea?

test it at
www.fortunemods.com

#86 blueinfinity

  • Community Member
  • 20 posts
  • Real Name:Shawn

Posted 02 January 2004, 19:05

also there is no script for doing the sql data make faster? as i blow with sql :(

#87 Unified

  • Community Member
  • 97 posts
  • Real Name:Jiten
  • Location:London

Posted 02 January 2004, 19:21

Sorry bluinfinity I dont understand?

You can copy the sql that I posted above and paste it into phpmyadmin.

If you goto phpmyadmin -> select your database -> click on the SQL Tab at the top THEN paste the SQL I posted into the SQL box and click on RUN!

Should work -> I do not know about any other SQL programmes sorry!

Regards,

Jiten

#88 carloshax

  • Community Member
  • 69 posts
  • Real Name:carl
  • Location:kent, UK

Posted 02 January 2004, 19:58

I dont know if i have a problem or if im setting it up wrong. I can see nothing to do with custom computer creator on my test site, how is the quickest way to set it up so i can see something/anything.

I also have template pictures missing in admin, and when i go to add new products as i work through the folder to the products i can sellect them by turning the box green but cannot remove them but the main thing is i only get a back button nothing else. Help me please

Carl

#89 blueinfinity

  • Community Member
  • 20 posts
  • Real Name:Shawn

Posted 02 January 2004, 20:45

ok i got it working.havnt tested it yet

sorry upt ill now i had no idea what phpmyadmin was :|

sorry

but i still dotn get whats up with my orders

http://fortunemods.com/shop/checkout_confirmation.php

when you make an order and get to THAT page its empty. theres no product lsited..

any idea why? i probably remvoed the wrong item from that page i will have to look.

#90 blueinfinity

  • Community Member
  • 20 posts
  • Real Name:Shawn

Posted 02 January 2004, 20:54

here is a pic of what i mean

http://www.fortunemods.com/images/error.JPG

any idea why? i probably have a missing strign or symbol in that php file but i am not sure where.

here is a txt file of my php file :)
http://www.fortunemods.com/images/checkout_confirmation.txt

any ideas?

i need to launch the site soon. so im hoping to get it working asap

and tis kinda kills chances of test orders. heh

#91 carloshax

  • Community Member
  • 69 posts
  • Real Name:carl
  • Location:kent, UK

Posted 02 January 2004, 21:04

Right this is what i have in my admin, could someone tells me if this is how it should be:

Options

[img]http://www.themodhouse.co.uk/carls/options.gif[/img]

Noted no images

Add more options

This seems to be ok

Pending builds

nothing in there

Add products

[img]http://www.themodhouse.co.uk/carls/products.gif[/img]

I have noted only a back button, you can turn all the green lights on but not remove them. I can see how you actually select them without having to press the back button.

Prebuilt systems

No images

edit products and delete products

Both these pages show "There Are Currently No Products In Custom Computer Creator's Database" if you click to add products you get the same as the image above.

Queued products

nothing in there

What do i have to do to show custom computer creator to show on my site, is everything listed how other people have it?.

you can see my test store admin here:

www.themodhouse.co.uk/test/admin

Thanks
Carl

#92 blueinfinity

  • Community Member
  • 20 posts
  • Real Name:Shawn

Posted 03 January 2004, 08:35

anyone?

#93 airsoftmart

  • Community Member
  • 56 posts
  • Real Name:mark
  • Location:uk

Posted 03 January 2004, 17:39

I though someone was going to upload a fully working :ph34r:
ver of this cool addon

Including pics, sql and all the code updates

Please Please do it soon we are all waiting :unsure:

#94 airsoftmart

  • Community Member
  • 56 posts
  • Real Name:mark
  • Location:uk

Posted 05 January 2004, 09:44

has any seen this error

Warning: Wrong parameter count for explode() in /home/sites/site1/web/catalog/build.php on line 5

Warning: Wrong parameter count for explode() in /home/sites/site1/web/catalog/build.php on line 6

it comes up when i click build a pc then select a computer type i.e

100mhz fsb

ppl are telling me thats its a prob with my php

ver of the server is :- Server OS: Linux 2.2.16C32_III

ver of the php is :- PHP Version: 4.0.0 (Zend: 1.00)

anybody know anthing

#95 darkangel

  • Community Member
  • 112 posts
  • Real Name:David

Posted 05 January 2004, 18:52

snjcomputers,

I would like to point out that the demo is not working correctly on my computer. I have a Macintosh and I am not able to either see the images, nor see click any of the links made there. This is the problem I get see if anyone can have a crack at it:

Microsoft Java Error

Error: Object Expected

#96 Norton

  • Community Member
  • 19 posts
  • Real Name:Magnus Lindén
  • Location:Sweden

Posted 10 January 2004, 11:30

Maybe i'm dumb, but there seams to be a little confusion in the readme...
First the checkout_confirmation.php line 175-184?? there aren't so many lines..
and i,m rather confused about wether or not to replace some lines.

help plz on the correct lines.. "using dreamweaver MX"

and i aint no PHP wizard either :)
Together for a better tomorrow.

#97 cheta

  • Community Member
  • 29 posts
  • Real Name:Bruno
  • Location:Portugal

Posted 15 January 2004, 10:49

hi all.

I haven't installed ccc yet, because i have some doughts: do the products listed in the ccc are products from the categories? i mean: the products used in ccc are the products we upload in the categories page, or they are new products that have to be uploaded again?

And another thing: i noticed that in the demo at snjcomputers when we choose an AMD board, the Intel processors remain there. Is there any way to: if we choose AMD boards, automaticly reload the processors so that we have only AMD boards compatible?


Thanks all.

#98 John Doswell

  • Team Member
  • 456 posts
  • Real Name:John Doswell
  • Gender:Male

Posted 15 January 2004, 12:26

cheta, on Jan 15 2004, 06:49 AM, said:

hi all.

I haven't installed ccc yet, because i have some doughts: do the products listed in the ccc are products from the categories? i mean: the products used in ccc are the products we upload in the categories page, or they are new products that have to be uploaded again?

And another thing: i noticed that in the demo at snjcomputers when we choose an AMD board, the Intel processors remain there. Is there any way to: if we choose AMD boards, automaticly reload the processors so that we have only AMD boards compatible?


Thanks all.
1. yes they are the same as used in the catalog
2. you can make the settings (hidden/required) in admin

regads John

#99 Pnop

  • Community Member
  • 38 posts
  • Real Name:Logged In Sometimes
  • Location:UK and Spain

Posted 17 January 2004, 14:50

Hi.

Don't know if this has been answered, done the searches etc nothing came back.

How do you change the $ currency for the £ currency?

#100 John Doswell

  • Team Member
  • 456 posts
  • Real Name:John Doswell
  • Gender:Male

Posted 17 January 2004, 17:19

Pnop, on Jan 17 2004, 10:50 AM, said:

Hi.

Don't know if this has been answered, done the searches etc nothing came back.

How do you change the $ currency for the £ currency?
update to newer vers. and find it in admin!!!

John