X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)
-   -   Free Full CustomerCare Software Addon for X-cart (https://forum.x-cart.com/showthread.php?t=7682)

deniz 05-20-2004 08:00 AM

Free Full CustomerCare Software Addon for X-cart
 
Dear Friends,

I have just finished a CustomerCare Addon software for x-cart.

And I will be happy to gice anyone who one wants to use it.

To configure it you only have to change the /connection/connection.php

as you database values.

Thats all.

After that , as you can see , you will never miss any request of your customers.
And your customers can investigate their all action in your store.
And also they will have history for all of each order they have.

And there is a question wizard addin.

And there is Ticket system addin.

No fee requested. Realy I will be glad to use anyone.

:idea: http://www.bookglobal.net/customercare.rar

shan 05-20-2004 08:25 AM

very generous of you.

maybe you should post a demo too

adpboss 05-20-2004 07:42 PM

This is incredible.

I just bought a FAQ system two weeks ago. I will investigate using this system however. THANK YOU!

John7 05-20-2004 10:18 PM

Hmmm intersting.
 
Hmmm intersting...

I think I'll try this out now.

Does this really integrate?

I didn't see any smarty in the folders.

John7 05-20-2004 10:48 PM

It has failed.
 
It has failed.

customercaremodule_news' doesn't exist


No documentation.

The SQL file seems to be missing.

John7 05-20-2004 10:58 PM

No go. :-(
 
No go. :-(


Sigh... I can't get to work for anything.

I even found a demo here:
http://www.bookglobal.net/customercare/


I also got many errors in the demo...

Any one else have any luck?

deniz 05-20-2004 11:00 PM

sorry I forget SQL :)

Code:

CREATE TABLE `customercaremodule_messages` (
  `id` tinyint(3) NOT NULL auto_increment,
  `orderid` varchar(255) default NULL,
  `sender` varchar(255) default NULL,
  `message` text,
  `senddate` varchar(255) default NULL,
  `reply` varchar(255) default NULL,
  `idle` varchar(255) default 'closed',
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

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

#
# Tablo yapısı : `customercaremodule_news`
#

CREATE TABLE `customercaremodule_news` (
  `id` tinyint(3) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `news` text,
  `adddate` varchar(255) default NULL,
  `link_if_it_is` varchar(255) default NULL,
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

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

#
# Tablo yapısı : `customercaremodule_questions`
#

CREATE TABLE `customercaremodule_questions` (
  `id` tinyint(3) NOT NULL auto_increment,
  `value` varchar(255) default NULL,
  `idle` tinyint(5) unsigned default NULL,
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

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

#
# Tablo yapısı : `customercaremodule_reviews`
#

CREATE TABLE `customercaremodule_reviews` (
  `id` tinyint(3) NOT NULL auto_increment,
  `subject` varchar(255) default NULL,
  `reviews` text,
  `first_lastname` varchar(255) default NULL,
  `country` varchar(50) default NULL,
  `email` varchar(255) default NULL,
  `status` varchar(255) default 'pasif',
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;


deniz 05-20-2004 11:03 PM

Kindly send me the bugs you found , I can fix them.

Regards

deniz 05-20-2004 11:11 PM

Also anyone can find live demo at:

http://www.bookglobal.net/customercare/

for test use account is:

username : deniztest
email : admin@satissitesi.com

John7 05-20-2004 11:23 PM

Thanks for the rapid response.
 
Thanks for the rapid response.

I'll go test it now.

Will let you know in a few mins how it turned out.

John7 05-20-2004 11:30 PM

Errors so far...
 
Quote:

Ask an specicif question?

Should be, "ASk a specific question."

Quote:

Forget your info? Click here
Click for information

Doesn't link to the right place.


Quote:

NEW MEMBER
ReGISTER HERE!!!

Doesn't work either.


Nor does

Code:

Read all news...


Most of the links I've tried so far do not work...

Any ideas???

deniz 05-20-2004 11:35 PM

I guess , the integrate functions works but some of notneeded links doesnot works.

Kindly any one can do it byself.

An important thing is , the order message screen , takes question history and answers autoresponse messages.

Regards.

John7 05-20-2004 11:37 PM

Another question.
 
Another question...

Is there an admin to go into to change the FAQ and such?

Thanks

John7 05-20-2004 11:45 PM

The answer is...
 
The answer is...

No.

All the info is hard coded. Intersting...

Hmmm...

This mod is cool but it'll take a lost of customization to get it look right.

I thank you for your efforts and rapid responses.

Your contribution is greatly appreciated.

groovico 05-22-2004 09:30 AM

Nice mod, and nice site which you've obviously spent alot of time on...but...

http://www.bookglobal.net/xcart/customer/product.php?productid=631&cat=36&page=1

Versus

http://www.amazon.com/exec/obidos/tg/detail/-/0345442725/ref=pd_bxgy_img_2/103-7610229-5332658?v=glance&s=books

.... from a legal point of view that's like putting you're head in the lions mouth and waiting for it to snap.

deniz 05-22-2004 10:13 AM

The buttons are not the same , all have been done again.

May be it looks like 99% but not the same one.

;)

john80y 05-22-2004 10:58 AM

I just realised that Amazon and Newegg look exactly the same !

deniz 05-22-2004 03:33 PM

Lets talk abour module not the web site.
I any question you have about module , I can reply you Regards

junaid 05-27-2004 03:34 PM

Quote:

Originally Posted by deniz
Kindly send me the bugs you found , I can fix them.

Regards

hello i installed it and when tried to login following error came
Table 'shop.customercaremodule_stats' doesn't exist

also want to know is it possible for customer to use same as xcart username and email or they had to regiter here again.

shan 05-27-2004 04:03 PM

Quote:

Originally Posted by deniz
May be it looks like 99% but not the same one.
;)


if the 1% that is different is just the domain name then it still counts as copying :lol:

deniz 05-28-2004 03:47 AM

Is it problem for you?
Why you are so interested with this?

junaid 05-28-2004 04:11 AM

Quote:

Originally Posted by deniz
Is it problem for you?
Why you are so interested with this?


i would be really helpful if you could give a bit attention to my post also
Quote:

hello i installed it and when tried to login following error came
Table 'shop.customercaremodule_stats' doesn't exist

also want to know is it possible for customer to use same as xcart username and email or they had to regiter here again.
kindly let me know whats causing this Table 'shop.customercaremodule_stats' doesn't exist
Problem.
regards

shan 05-28-2004 04:15 AM

Quote:

i would be really helpful if you could give a bit attention to my post also

you must not have added the sql file to the datababase. Its looking for sql tables that are not there

deniz 05-28-2004 04:24 AM

I have changed the SQL arrays from config.php , the reason for.

normaly it must be xcart_custom...

but I ave changed this to shop_custom..

I guess it will help you.

You have to change the SQL dump file names... in.

junaid 05-28-2004 11:35 AM

Quote:

Originally Posted by shan
Quote:

i would be really helpful if you could give a bit attention to my post also

you must not have added the sql file to the datababase. Its looking for sql tables that are not there

i have added the sql file to the database and it is asking for the table which isnt in the sql file..
here is the sql file:
Quote:

CREATE TABLE `customercaremodule_messages` (
`id` tinyint(3) NOT NULL auto_increment,
`orderid` varchar(255) default NULL,
`sender` varchar(255) default NULL,
`message` text,
`senddate` varchar(255) default NULL,
`reply` varchar(255) default NULL,
`idle` varchar(255) default 'closed',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

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

#
# Tablo yapısı : `customercaremodule_news`
#

CREATE TABLE `customercaremodule_news` (
`id` tinyint(3) NOT NULL auto_increment,
`title` varchar(255) default NULL,
`news` text,
`adddate` varchar(255) default NULL,
`link_if_it_is` varchar(255) default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

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

#
# Tablo yapısı : `customercaremodule_questions`
#

CREATE TABLE `customercaremodule_questions` (
`id` tinyint(3) NOT NULL auto_increment,
`value` varchar(255) default NULL,
`idle` tinyint(5) unsigned default NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

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

#
# Tablo yapısı : `customercaremodule_reviews`
#

CREATE TABLE `customercaremodule_reviews` (
`id` tinyint(3) NOT NULL auto_increment,
`subject` varchar(255) default NULL,
`reviews` text,
`first_lastname` varchar(255) default NULL,
`country` varchar(50) default NULL,
`email` varchar(255) default NULL,
`status` varchar(255) default 'pasif',
regards

junaid 05-28-2004 11:43 AM

Quote:

Originally Posted by deniz
I have changed the SQL arrays from config.php , the reason for.

normaly it must be xcart_custom...

but I ave changed this to shop_custom..

I guess it will help you.

You have to change the SQL dump file names... in.

Can you please elaborate on this.
i guess ther eis a table missing in the sql file you have posted.
would appreciate the help.

deniz 05-28-2004 12:19 PM

Find the following line;

shop.xcart

junaid 05-28-2004 12:31 PM

Quote:

Originally Posted by deniz
Find the following line;

shop.xcart

thanks but which file, furthermore can you let me know where is this table " customercare statistics in your sql file.

regards

junaid 06-03-2004 11:09 AM

i guess deniz hasnt been geneorus enough, sorry if i m wrong.
there is clearly a table missing here is a query that i found in my a file.
Quote:

"SELECT * FROM customercaremodule_stats WHERE subject = 'shipping'";
$shipping = mysql_query($query_shipping, $customer_care) or die(mysql_error());
$row_shipping = mysql_fetch_assoc($shipping);
$totalRows_shipping = mysql_num_rows($shipping);
//kucuk istatistiklerin aritmetik ortalamasini buraya aliyorum...DenizNisan2004
$result = mysql_query("select avg(vote) from customercaremodule_stats WHERE subject = 'bookglobal'");
$sonuc = mysql_fetch_row($result);

and that is the fifth table which is clearly missing.
kindly do let me know if i m wrong.

deniz 06-05-2004 02:08 AM

Code:

CREATE TABLE `customercaremodule_messages` (
  `id` tinyint(3) NOT NULL auto_increment,
  `orderid` varchar(255) default NULL,
  `sender` varchar(255) default NULL,
  `message` text,
  `senddate` varchar(255) default NULL,
  `reply` varchar(255) default NULL,
  `idle` varchar(255) default 'closed',
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

#
# Tablo dц╤kц╪m verisi `customercaremodule_messages`
#

INSERT INTO `customercaremodule_messages` VALUES (1, '1', 'zorounzet', 'Please let me now why my order was decline?', '2004 Apr 11', NULL, 'closed');
INSERT INTO `customercaremodule_messages` VALUES (2, '3', 'zorounzet', 'ok', '2004 Apr 11', NULL, 'closed');
INSERT INTO `customercaremodule_messages` VALUES (3, '3', 'zorounzet', NULL, '2004 Apr 11', NULL, 'closed');
INSERT INTO `customercaremodule_messages` VALUES (4, '3', 'zorounzet', 'nerde kardeşim', '2004 Apr 12', NULL, 'closed');
INSERT INTO `customercaremodule_messages` VALUES (5, '4', 'ersin', 'daha gelmedi...', '2004 Apr 12', NULL, 'closed');
INSERT INTO `customercaremodule_messages` VALUES (6, '3', 'zorounzet', 'siparişim nyşlfdşlfşlfd', '2004 Apr 12', 'gonderik niye almadın....', 'closed');
INSERT INTO `customercaremodule_messages` VALUES (7, '3', 'zorounzet', 'ujyujuyuj', '2004 Apr 12', NULL, 'closed');
INSERT INTO `customercaremodule_messages` VALUES (8, '3', 'zorounzet', NULL, '2004 Apr 12', NULL, 'closed');
INSERT INTO `customercaremodule_messages` VALUES (9, '1', 'zorounzet', 'umut dereli', '2004 Apr 12', NULL, 'closed');
INSERT INTO `customercaremodule_messages` VALUES (10, '3', 'zorounzet', 'umut', '2004 Apr 12', NULL, 'closed');
INSERT INTO `customercaremodule_messages` VALUES (11, '1', 'zorounzet', 'niye kardeşim cevap vvermiyorsun?', '2004 Apr 15', 'yooo verdik ya...', 'open');

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

#
# Tablo yapısı : `customercaremodule_news`
#

CREATE TABLE `customercaremodule_news` (
  `id` tinyint(3) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `news` text,
  `adddate` varchar(255) default NULL,
  `link_if_it_is` varchar(255) default NULL,
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

#
# Tablo dц╤kц╪m verisi `customercaremodule_news`
#

INSERT INTO `customercaremodule_news` VALUES (1, 'New Campaign!!', NULL, '12 April 2004', 'http://www.bookglobal.net');
INSERT INTO `customercaremodule_news` VALUES (2, 'Kid DVDs released', NULL, '11 April 2004', '');
INSERT INTO `customercaremodule_news` VALUES (3, NULL, NULL, NULL, NULL);
INSERT INTO `customercaremodule_news` VALUES (4, NULL, NULL, NULL, NULL);
INSERT INTO `customercaremodule_news` VALUES (5, NULL, NULL, NULL, NULL);
INSERT INTO `customercaremodule_news` VALUES (6, NULL, NULL, NULL, NULL);

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

#
# Tablo yapısı : `customercaremodule_questions`
#

CREATE TABLE `customercaremodule_questions` (
  `id` tinyint(3) NOT NULL auto_increment,
  `value` varchar(255) default NULL,
  `idle` tinyint(5) unsigned default NULL,
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

#
# Tablo dц╤kц╪m verisi `customercaremodule_questions`
#

INSERT INTO `customercaremodule_questions` VALUES (1, 'Orders', 1);
INSERT INTO `customercaremodule_questions` VALUES (2, 'Affiliate', 2);
INSERT INTO `customercaremodule_questions` VALUES (3, 'User Information', 3);
INSERT INTO `customercaremodule_questions` VALUES (4, 'Return Policys', 4);
INSERT INTO `customercaremodule_questions` VALUES (5, 'Using Bookglobal.net', 5);
INSERT INTO `customercaremodule_questions` VALUES (6, 'Wholesalers', 6);
INSERT INTO `customercaremodule_questions` VALUES (7, 'Special Offers', 7);
INSERT INTO `customercaremodule_questions` VALUES (8, 'Security Information', 8);
INSERT INTO `customercaremodule_questions` VALUES (9, 'Discounts', 9);
INSERT INTO `customercaremodule_questions` VALUES (10, 'About Harun Yahya', 10);

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

#
# Tablo yapısı : `customercaremodule_reviews`
#

CREATE TABLE `customercaremodule_reviews` (
  `id` tinyint(3) NOT NULL auto_increment,
  `subject` varchar(255) default NULL,
  `reviews` text,
  `first_lastname` varchar(255) default NULL,
  `country` varchar(50) default NULL,
  `email` varchar(255) default NULL,
  `status` varchar(255) default 'pasif',
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

#
# Tablo dц╤kц╪m verisi `customercaremodule_reviews`
#

INSERT INTO `customercaremodule_reviews` VALUES (1, 'customercare', 'perfect work, great job, glad you..\r\ninsaAllah.', 'Umut Dereli', 'US', 'admin@bookglobal.net', 'aktif');
INSERT INTO `customercaremodule_reviews` VALUES (2, 'customercare', 'ffgfgfgfdgfdgfgfdg', 'Erdem Dereli', 'US', 'zorounzet@yahoo.com', 'aktif');
INSERT INTO `customercaremodule_reviews` VALUES (3, 'customercare', 'umut', NULL, 'US', NULL, 'pasif');
INSERT INTO `customercaremodule_reviews` VALUES (4, 'customercare', 'ftrgtrgtrgtrg', NULL, 'US', NULL, 'pasif');
INSERT INTO `customercaremodule_reviews` VALUES (5, 'shipping', 'cdfdsfds', NULL, 'CN', NULL, 'aktif');

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

#
# Tablo yapısı : `customercaremodule_stats`
#

CREATE TABLE `customercaremodule_stats` (
  `id` tinyint(3) NOT NULL auto_increment,
  `vote` tinyint(50) NOT NULL default '0',
  `ip` varchar(255) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=127 ;

#
# Tablo dц╤kц╪m verisi `customercaremodule_stats`
#

INSERT INTO `customercaremodule_stats` VALUES (1, 67, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (4, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (5, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (6, 50, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (7, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (8, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (9, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (10, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (11, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (12, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (13, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (14, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (15, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (16, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (17, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (18, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (19, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (20, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (21, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (22, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (23, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (24, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (25, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (26, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (27, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (28, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (29, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (30, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (31, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (32, 30, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (33, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (34, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (35, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (36, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (37, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (38, 40, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (39, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (40, 40, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (41, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (42, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (43, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (44, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (45, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (46, 50, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (47, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (48, 60, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (49, 50, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (50, 70, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (51, 50, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (52, 50, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (53, 30, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (54, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (55, 40, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (56, 50, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (57, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (58, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (59, 50, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (60, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (61, 50, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (62, 60, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (63, 40, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (64, 40, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (65, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (66, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (67, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (68, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (69, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (70, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (71, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (72, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (73, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (74, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (75, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (76, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (77, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (78, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (79, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (80, 100, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (81, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (82, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (83, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (84, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (85, 30, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (86, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (87, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (88, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (89, 50, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (90, 70, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (91, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (92, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (93, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (94, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (95, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (96, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (97, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (98, 50, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (99, 90, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (100, 100, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (101, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (102, 20, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (103, 60, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (104, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (105, 90, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (106, 90, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (107, 90, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (108, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (109, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (110, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (111, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (112, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (113, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (114, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (115, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (116, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (117, 50, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (118, 20, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (119, 90, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (120, 100, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (121, 100, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (122, 100, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (123, 100, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (124, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (125, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (126, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 20, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 30, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 20, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 40, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 40, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 40, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 40, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 30, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 20, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 40, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 30, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 30, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 30, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 40, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 40, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 10, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 30, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 40, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 90, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 60, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 50, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 70, '127.0.0.1', 'ccp');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'shipping');
INSERT INTO `customercaremodule_stats` VALUES (127, 100, '127.0.0.1', 'bookglobal');
INSERT INTO `customercaremodule_stats` VALUES (127, 80, '127.0.0.1', 'bookglobal');

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

#
# Tablo yapısı : `customermodule_customer_questions`
#

CREATE TABLE `customermodule_customer_questions` (
  `id` tinyint(3) NOT NULL auto_increment,
  `login` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `subject` varchar(255) default NULL,
  `subsubject` varchar(255) default NULL,
  `questions` text,
  `status` varchar(255) default 'closed',
  `date` varchar(255) default NULL,
  `reply` varchar(255) default NULL,
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;

#
# Tablo dц╤kц╪m verisi `customermodule_customer_questions`
#

INSERT INTO `customermodule_customer_questions` VALUES (1, 'zorounzet', 'admin@bookglobal.net', 'Affiliate', 'Become Affiliate', 'ok', 'closed', '2004 Apr 11', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (2, 'zorounzet', NULL, NULL, NULL, NULL, 'closed', '2004 Apr 11', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (3, NULL, NULL, 'Affiliate', 'Become Affiliate', NULL, 'closed', '2004 Apr 11', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (4, 'zorounzet', NULL, 'Orders', 'About your orders', 'benim iptal oldu', 'closed', '2004 Apr 12', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (5, 'zorounzet', NULL, 'Return Policys', 'Missing products', 'ufytfyf', 'open', '2004 Apr 12', 'yoo tam gonderdik');
INSERT INTO `customermodule_customer_questions` VALUES (6, NULL, NULL, 'Affiliate', 'Become Affiliate', 'dfsdfdsfdsfsdf', 'closed', '2004 Apr 12', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (7, NULL, NULL, 'Special Offers', 'FreeShipping Offers', 'umut test.....', 'closed', '2004 Apr 12', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (8, NULL, NULL, 'Return Policys', 'Missing products', 'hjmjmjmjhm', 'closed', '2004 Apr 12', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (9, NULL, NULL, 'User Information', 'General Questions', 'umut dereli\r\numut dereli\r\numut dereli\r\n', 'closed', '2004 Apr 12', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (10, NULL, NULL, NULL, NULL, 'regetget', 'closed', '2004 Apr 15', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (11, 'zorounzet', 'admin@bookglobal.net', 'Return Policys', 'Missing products', 'DVDşler yokkine\r\n', 'open', '2004 Apr 15', 'tamam gonderiyoruzkine');
INSERT INTO `customermodule_customer_questions` VALUES (12, 'zorounzet', 'admin@bookglobal.net', 'User Information', 'Customer Details', 'test', 'closed', '2004 May 02', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (13, 'zorounzet', 'admin@bookglobal.net', 'User Information', 'Customer Details', 'dsfsdfsdf', 'closed', '2004 May 02', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (14, 'zorounzet', 'admin@bookglobal.net', 'User Information', 'Customer Details', 'test', '0', NULL, NULL);
INSERT INTO `customermodule_customer_questions` VALUES (15, 'zorounzet', 'admin@bookglobal.net', 'Orders', 'Billing & Shipping', 'I want to change my billing information.\r\nthanks.', '0', NULL, NULL);
INSERT INTO `customermodule_customer_questions` VALUES (16, 'zorounzet', 'admin@bookglobal.net', 'Affiliate', 'Payment', 'test', 'closed', '2004 May 02', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (17, 'zorounzet', 'admin@bookglobal.net', 'Affiliate', 'Payment', 'test', 'closed', '2004 May 02', NULL);
INSERT INTO `customermodule_customer_questions` VALUES (18, 'zorounzet', 'admin@bookglobal.net', 'Orders', 'Products', 'mumumyumymy', 'closed', '2004 May 07', NULL);


junaid 06-05-2004 05:14 AM

thanks deniz would try it tonight.
sorry for trouble.

xcell67 06-23-2004 10:51 PM

Hi,

I love this mod but I have one concern. To log in the user has to enter their username and email. This may be a security issue because other users can easily log in as the other person.

How can it be set up so that it asks for the username and password or email and password instead?

Or can it be set up in a way that if the customer logs into the main shop, they are automatically logged into customercare?

Thanks!

deniz 06-24-2004 01:50 AM

In register.php find the lined below then change them.

Code:

$dologin

Code:

$Session

&

Code:

zipcode


Regards

xcell67 06-24-2004 05:11 PM

hmmm, change them to what?

thanks

fhiremark 05-03-2006 05:46 AM

Hello,
Tried to download it from http://www.bookglobal.net/customercare.rar but I couldn't, the page shows alot of weird symbols. Did you take this mod down? Also, is this compatible with v4.0.18? I would really like to try this, can you please fix the download link.

Thank You.

intel352 05-03-2006 06:02 AM

i would not try this mod if i were you, apparently it's poorly coded, is hardcoded in alot of areas, and is really not a good mod. i believe it wasn't even properly working on his own website.

nothing against the author, just don't want you to screw up your own website

fhiremark 05-03-2006 06:27 AM

Hey Intel,

Thanks for the heads up =)
Can your recommend any free support mods out there that integrate well with X-Cart?

cotc2001 05-03-2006 08:25 AM

Not free but talk to gary at www.x-cart-plus.com im pretty sure he's developed a help system not sure if it's for resale though

EDIT: it is for sale link here
http://www.x-cart-plus.com/Ticket-Support-System-for-X-CART-p-41.html

fhiremark 05-03-2006 06:59 PM

Thanks for the lead cotc2001, I'll probably hold off for now.

intel352 05-04-2006 05:27 AM

with some work, i'm sure this Helpdesk package could be integrated.

the point is, this is a free Helpdesk, so if you could find someone willing to work on integration, it might work well for you.

http://osticketcommunity.ath.cx/ (This is the Community version of OSTicket)

http://www.osticket.com << The Community version exists because OSTicket v1.3 has been removed from the author's website, in anticipation of v2.0 (which has been anticipated for about a year or so now?...)

good software, community version is worth a look, is addressing bugs that existed in the software


All times are GMT -8. The time now is 03:35 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.