Install phpmydesk – Supportdesk ( for customer support application) in localhost


1. install xampp terlebih dulu
2. taruh directory phpmydesk di c:xampp/htdocs/”nama_dir
3. buat database di phpmyadmin dgn nama “pmd”
4. edit file “pmd config”
############ DATABASE CONFIGURATION ############
$host = “localhost”;
$user = “terserah anda”;
$pass = “terserah anda”;
$db = “pmd”;
############ DATABASE CONFIGURATION ############

5. buat database di phpmyadmin di dalam database “pmd”
6. buat sesuai dengan urutan di pmd.sql, seperti ini :

able structure for table `responses`

CREATE TABLE responses (
id int(11) NOT NULL auto_increment,
ticketid int(11) NOT NULL default ‘0’,
response text NOT NULL,
rtime datetime NOT NULL default ‘0000-00-00 00:00:00’,
responseby varchar(46) NOT NULL default ”,
PRIMARY KEY (id)
) TYPE=MyISAM;
# ——————————————————–

#
# Table structure for table `tickets`
#

CREATE TABLE tickets (
id int(11) NOT NULL auto_increment,
usr_id int(11) NOT NULL default ‘0’,
sub varchar(140) NOT NULL default ”,
details text NOT NULL,
pri smallint(6) NOT NULL default ‘0’,
status smallint(6) NOT NULL default ‘0’,
logg datetime NOT NULL default ‘0000-00-00 00:00:00’,
PRIMARY KEY (id)
) TYPE=MyISAM;
# ——————————————————–

#
# Table structure for table `users`
#

CREATE TABLE users (
id int(11) NOT NULL auto_increment,
usr varchar(16) NOT NULL default ”,
pwd varchar(16) NOT NULL default ”,
fn varchar(40) NOT NULL default ”,
ln varchar(40) NOT NULL default ”,
em varchar(250) NOT NULL default ”,
PRIMARY KEY (id)
) TYPE=MyISAM;

Silahkan download aplikasi supportdesk/phpmydesk disini

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

%d blogger menyukai ini: