Menu
▾
▴
phphelpdesk-help
You can subscribe to this list here.
| 2000 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(4) |
Feb
(8) |
Mar
(29) |
Apr
(21) |
May
(26) |
Jun
(15) |
Jul
(18) |
Aug
(26) |
Sep
(27) |
Oct
(17) |
Nov
(35) |
Dec
(22) |
| 2002 |
Jan
(8) |
Feb
(26) |
Mar
(17) |
Apr
(5) |
May
(16) |
Jun
(16) |
Jul
(21) |
Aug
(11) |
Sep
(9) |
Oct
(15) |
Nov
(5) |
Dec
(15) |
| 2003 |
Jan
(20) |
Feb
(14) |
Mar
(15) |
Apr
(44) |
May
(15) |
Jun
(9) |
Jul
(7) |
Aug
(21) |
Sep
(2) |
Oct
(7) |
Nov
(15) |
Dec
(8) |
| 2004 |
Jan
(33) |
Feb
(13) |
Mar
(8) |
Apr
(20) |
May
(16) |
Jun
(30) |
Jul
(14) |
Aug
(16) |
Sep
(10) |
Oct
(8) |
Nov
(23) |
Dec
(15) |
| 2005 |
Jan
(8) |
Feb
(7) |
Mar
(19) |
Apr
(11) |
May
(13) |
Jun
(11) |
Jul
(12) |
Aug
(52) |
Sep
(14) |
Oct
(56) |
Nov
(9) |
Dec
(6) |
| 2006 |
Jan
|
Feb
(7) |
Mar
(5) |
Apr
|
May
(9) |
Jun
|
Jul
|
Aug
(5) |
Sep
(4) |
Oct
(1) |
Nov
(3) |
Dec
(13) |
| 2007 |
Jan
(6) |
Feb
(8) |
Mar
(12) |
Apr
(3) |
May
(3) |
Jun
(15) |
Jul
(11) |
Aug
(32) |
Sep
(35) |
Oct
(12) |
Nov
(13) |
Dec
(11) |
| 2008 |
Jan
(7) |
Feb
(10) |
Mar
(34) |
Apr
(34) |
May
(20) |
Jun
(6) |
Jul
(19) |
Aug
(21) |
Sep
(8) |
Oct
(11) |
Nov
(36) |
Dec
(39) |
| 2009 |
Jan
(34) |
Feb
(15) |
Mar
(14) |
Apr
(21) |
May
(50) |
Jun
(17) |
Jul
(37) |
Aug
(3) |
Sep
(5) |
Oct
(1) |
Nov
(1) |
Dec
(12) |
| 2010 |
Jan
(10) |
Feb
(5) |
Mar
(5) |
Apr
|
May
(12) |
Jun
(7) |
Jul
(4) |
Aug
(4) |
Sep
(8) |
Oct
(4) |
Nov
(6) |
Dec
(4) |
| 2011 |
Jan
(4) |
Feb
(2) |
Mar
|
Apr
(4) |
May
|
Jun
(4) |
Jul
(2) |
Aug
(6) |
Sep
(7) |
Oct
(15) |
Nov
(4) |
Dec
(2) |
| 2012 |
Jan
(3) |
Feb
(3) |
Mar
(2) |
Apr
(1) |
May
(2) |
Jun
(9) |
Jul
(10) |
Aug
(10) |
Sep
(10) |
Oct
(7) |
Nov
(1) |
Dec
|
| 2013 |
Jan
(4) |
Feb
|
Mar
(1) |
Apr
(11) |
May
(4) |
Jun
(4) |
Jul
(1) |
Aug
(28) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
(1) |
Feb
|
Mar
(3) |
Apr
(4) |
May
|
Jun
(9) |
Jul
|
Aug
|
Sep
|
Oct
(1) |
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2016 |
Jan
|
Feb
(1) |
Mar
(6) |
Apr
(6) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: scott b. <sc...@hi...> - 2001-10-10 05:29:53
|
ok I installed the php helpdesk and got errors installed to http://www.hijinksdesign.com/support/ Fatal error: Call to undefined function: mysql_connect() in /home/DESIGN-WEB/www/support/includes/connect.inc.php on line 10 any help is appreciated I used the red hat rpm to install php-4.0.4pl1 |
|
From: alister a. <ali...@ut...> - 2001-10-09 00:00:18
|
At 08:26 AM 9/10/2001, Brendon Anderson wrote: >Is there some module between php and mysql or something? Well, yes. What OS are you using? For me, it was as simple as typing apt-get install php-mysql and then restarting the running applications. Otherwise, you'd have to ensure you compiled php with mysql support - a --with-mysql would be needed. Alister -- Alister Air Ph 9514 1277 IT Manager Fx 9514 1656 Faculty of Science, University of Technology Sydney "The time of your life is the one commodity that you can sell but never buy back." -- Bob Black |
|
From: Brendon A. <BAn...@hs...> - 2001-10-08 22:26:40
|
I've seen other posts here on this subject, but no real answers to the = problem. When I go to the helpdesk page on my website, I get the following error: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/h= elpdesk/includes/connect.inc.php on line 10 =20 and the page "header" right underneath it (with the desk and the title and = version stuff). It's been driving me crazy trying to get this thing to work...I've been = through all the config files and everything seems to be configured = correctly, I can manually log into the database... Is there some module between php and mysql or something? Thanks Brendon |
|
From: Vincent H. <vin...@mu...> - 2001-10-04 15:15:56
|
I have see that the search fonction don't search in the events of a
ticket? can i add this request in the wish list of this fabulous
software? :))
if you have a information mailing list of this product, you can add my
address ib this list. i wait for a update ao this soft, good job!
------------------------
Vincent Hauler
t=E9l : 03.89.31.29.92
email: vin...@mu...
___ BP 1125
/ | _ ____ _______ 68052 MULHOUSE Cedex
/ /| | | |/_/ / / / ___/=20
/ ___ |_> </ /_/ (__ ) standard: 03.89.31.29.50
/_/ |_/_/|_|\__, /____/ fax : 03.89.31.29.99
/____/ web : www.axys-sa.fr
|
|
From: Scott S. <Sco...@De...> - 2001-09-28 17:17:28
|
I just just installed the latest version (0.6.16), and everything is up and running, however when I select the login option, it goes into an endless download loop. I was using IE5 (ick!!), and could not tell it was doing this, but when I switched over to Netscape, I was able to determine that it was downloading something, but did not know what, I let it run about 2 minutes, and it went up to like 6 megs. Any ideas? Scott |
|
From: Kevin M. S. <sh...@cg...> - 2001-09-27 00:39:28
|
Hey Joe and Gang, I am finally getting around to putting this thing together. The demo looks awesome. I have a question... The INSTALL file states: <snip> PHP 4.0 or greater with MySQL support enabled <snip> How can I verify MySQL support is enabled before moving forward with an initial install? -k |
|
From: Andrew <ajw...@ho...> - 2001-09-26 21:45:16
|
Definately a PHP problem, sounds like the MySQL database component of PHP is not there, which is strange. If the problem was a connection problem, it would have given a different error message. I'm using Red Hat 7.0 and everything was included. Did you use the rpm from the Red Hat 7.1 cd to install PHP? Andrew "Missana, Tony" wrote: > I received the following fatal error after installing and configuring > phphelpdesk. I can connect manually to the phphelpdesk database. Apache is > working for other programs. > Fatal error: Call to undefined function: mysql_connect() in > /var/www/html/helpdesk/includes/connect.inc.php on line 10 > > I have the following configuration: > RH 7.1 > PHP 4.0.4pl1-9 > Apache 1.3.19-5 > Mysql 3.23.36-1 > > Please can someone help. Thanks. > Tony > > _______________________________________________ > Phphelpdesk-help mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help |
|
From: Matt G. <ma...@ma...> - 2001-09-26 19:41:00
|
connect.inc.php is a php script interpreted by Apache. As far as what the problem is, I don't know. Where it lies- not in phphelpdesk is my guess. I would say maybe Apache can't execute PHP commands? Anybody else out there know how to debug why Apache or PHP can't execute a PHP function. Maybe an include in PHP is wrong? I'm no expert. Matt At 03:27 PM 9/26/2001 -0400, Missana, Tony wrote: >I am using 0.6.16 and the database name is phpheldesk (default). >The db.conf.php is as follows > <<...OLE_Obj...>> > >Thanks, >Tony >--------------------------------------- >What version of PHPHelpdesk are you using? >It sounds like the problem is with PHP. The mysql_connect() function is a >PHP function. >However, it could be your config file has the wrong hostname and database >name. >(The mysql_connect() function uses these parameters to execute). >Matt >At 12:32 PM 9/26/2001 -0400, Missana, Tony wrote: > >I received the following fatal error after installing and configuring > >phphelpdesk. I can connect manually to the phphelpdesk database. Apache >is > >working for other programs. > >Fatal error: Call to undefined function: mysql_connect() in > >/var/www/html/helpdesk/includes/connect.inc.php on line 10 > > > >I have the following configuration: > >RH 7.1 > >PHP 4.0.4pl1-9 > >Apache 1.3.19-5 > >Mysql 3.23.36-1 > > > >Please can someone help. Thanks. > >Tony > > > > > >_______________________________________________ > >Phphelpdesk-help mailing list > >Php...@li... > >https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help > > >_______________________________________________ >Phphelpdesk-help mailing list >Php...@li... >https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help > > >_______________________________________________ >Phphelpdesk-help mailing list >Php...@li... >https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help |
|
From: Missana, T. <ton...@ed...> - 2001-09-26 19:27:18
|
I am using 0.6.16 and the database name is phpheldesk (default). The db.conf.php is as follows <<...OLE_Obj...>> Thanks, Tony --------------------------------------- What version of PHPHelpdesk are you using? It sounds like the problem is with PHP. The mysql_connect() function is a PHP function. However, it could be your config file has the wrong hostname and database name. (The mysql_connect() function uses these parameters to execute). Matt At 12:32 PM 9/26/2001 -0400, Missana, Tony wrote: >I received the following fatal error after installing and configuring >phphelpdesk. I can connect manually to the phphelpdesk database. Apache is >working for other programs. >Fatal error: Call to undefined function: mysql_connect() in >/var/www/html/helpdesk/includes/connect.inc.php on line 10 > >I have the following configuration: >RH 7.1 >PHP 4.0.4pl1-9 >Apache 1.3.19-5 >Mysql 3.23.36-1 > >Please can someone help. Thanks. >Tony > > >_______________________________________________ >Phphelpdesk-help mailing list >Php...@li... >https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help _______________________________________________ Phphelpdesk-help mailing list Php...@li... https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help |
|
From: Matt G. <ma...@ma...> - 2001-09-26 17:03:42
|
What version of PHPHelpdesk are you using? It sounds like the problem is with PHP. The mysql_connect() function is a PHP function. However, it could be your config file has the wrong hostname and database name. (The mysql_connect() function uses these parameters to execute). Matt At 12:32 PM 9/26/2001 -0400, Missana, Tony wrote: >I received the following fatal error after installing and configuring >phphelpdesk. I can connect manually to the phphelpdesk database. Apache is >working for other programs. >Fatal error: Call to undefined function: mysql_connect() in >/var/www/html/helpdesk/includes/connect.inc.php on line 10 > >I have the following configuration: >RH 7.1 >PHP 4.0.4pl1-9 >Apache 1.3.19-5 >Mysql 3.23.36-1 > >Please can someone help. Thanks. >Tony > > >_______________________________________________ >Phphelpdesk-help mailing list >Php...@li... >https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help |
|
From: Missana, T. <ton...@ed...> - 2001-09-26 16:37:51
|
I received the following fatal error after installing and configuring phphelpdesk. I can connect manually to the phphelpdesk database. Apache is working for other programs. Fatal error: Call to undefined function: mysql_connect() in /var/www/html/helpdesk/includes/connect.inc.php on line 10 I have the following configuration: RH 7.1 PHP 4.0.4pl1-9 Apache 1.3.19-5 Mysql 3.23.36-1 Please can someone help. Thanks. Tony |
|
From: Matt G. <ma...@ma...> - 2001-09-26 13:59:31
|
Basically this is a script written in PHP. There are 2 variables, what
email program are you running, and what scripting language are you
using. This is the PHP answer to the equation. Mysql actually comes with
a PERL script for adding email to a database, but it is coded with the
email program part of the equation as sendmail, not qmail. That script is
called mail_to_db.pl. My script could be adapted to that script, so
basically 80% of the work is done - if you want sendmail, PERL, mysql, PHP,
and phphelpdesk.
At 06:51 AM 9/26/2001 -0700, you wrote:
>You should just be able to put "|/home/helpdesk/mail_to_db.php", without
>the quotes, into /home/username/.forward. Now Sendmail has be be able
>to run that command. And sometimes you need to put that command
>"mail_to_db.php" into /etc/smrsh so that sendmail knows that it is a
>secure command that it should be able to run. PHP has to be compiled
>with command line arguments. I don't know the flag for this. But it
>doesn't have to even be a PHP script. You could do PERL, python, or
>many other scripting languages.
>
>-----Original Message-----
>From: Matt Grab [mailto:ma...@ma...]
>Sent: Wednesday, September 26, 2001 6:48 AM
>To: Joe Hoot
>Subject: RE: [Phphelpdesk-help] Enter Tickets via Email
>
>As far as I can tell, the only differences are these:
>1 - how do you forward an email to a script in sendmail
>2 - how does sendmail make the email available to the script process -
>ie.
>is it on stdin, or is it an environment variable, or is it a command
>line
>argument
>
>At 06:32 AM 9/26/2001 -0700, you wrote:
> >You should be able to just put this in the .forward file of the same
> >users' directory. Sometimes in sendmail it is better to put it in
> >/etc/smrsh, or at least put a symbolic link in there for this program.
> >This way, sendmail can run it as a secure shell. If I get time, I'll
> >try this at work today.
> >
> >-----Original Message-----
> >From: Web-Hoster Support Team [mailto:su...@we...]
> >Sent: Wednesday, September 26, 2001 1:49 AM
> >To: Matthew C. Grab; php...@li...
> >Subject: RE: [Phphelpdesk-help] Enter Tickets via Email
> >
> >Great news this has been talked about for a while - any chance of doing
> >a
> >sendmail version? or do we need to look at procmail?
> >
> >Regards
> >
> >Gavin
> >
> > > -----Original Message-----
> > > From: own...@ww...
> > > [mailto:own...@ww...]On Behalf Of Matthew C.
> >Grab
> > > Sent: 26 September 2001 02:30
> > > To: php...@li...
> > > Cc: php...@li...
> > > Subject: [Phphelpdesk-help] Enter Tickets via Email
> > >
> > >
> > >
> > > Here is a script that allows you to enter tickets to phphelpdesk
> > > via an email.
> > > Assumed is that you have phphelpdesk up and running, and that you
> > > have php
> > > compiled for command line scripts. Also, you need to have qmail
> >running,
> > > and have an email account that can run this forward script.
> > > For example, I have an email account called helpdesk. I have a
> > > .qmail file
> > > which contains the command
> > >
> > > |/home/helpdesk/mail_to_db.php
> > >
> > > Copy this script in, edit the user and the category, put the
> > > .qmail file in
> > > /home/helpdesk, and whenever this user receives email, it will show
>up
> > > instantly in the support database.
> > >
> > > This will run the command that is needed.
> > > Note that this does not add the email as the user. All email
>tickets
> >are
> > > added under one account. It would be simple enough to parse out
> > > the user's
> > > email address, and submit it that way, but this is definitely
> > > simpler. It
> > > might be an idea to create multiple category email addresses, and
>have
> > > emails categorized that way.
> > > Follows is the mail_to_db.php script.
> > > You will need to edit the variables for such things as what user do
> >you
> > > want the email to be added to, what department, company, category,
> >etc..
> > >
> > > ------------------------------------------
> > > #!/usr/bin/php -q
> > > <?php
> > > #This connects to your database - put your mysql server, user, &
>pass
> >here
> > > $link = mysql_connect("localhost", "root", "")
> > > or die ("could not connect\n");
> > > mysql_select_db ("phphelpdesk")
> > > or die ("could not select database\n");
> > > $fp = fopen("./helplog", "a");
> > >
> > > #This makes it so that all emails sent to this email address show up
> >under
> > > #the same user in PHPHelpdesk
> > > $ctgry = "Other";
> > > $tbl = "ticket";
> > > $usr = "admin";
> > > $dpt = "crag";
> > > $loc = "idunno";
> > > $nowtime = date('Y-m-d H:i:s');
> > > $priority = "1";
> > > $e_stat = "REGISTERED";
> > > $e_des = "Ticket Assigned";
> > > #Read the entire email, including headers. It is being passed to
> >stdin.
> > > #The last 2 lines carve out only the message body, and trim leading
> >and
> > > #trailing whitespaces.
> > > $fd = fopen("php://stdin","r");
> > > while (!feof($fd)) {
> > > $data = fgets($fd, 4096);
> > > $testdata = "$testdata$data";
> > > }
> > > $body = strstr($testdata, "\n\n");
> > > $body = trim ($body);
> > > #This builds the query that adds the ticket to the ticket table.
> > > $qry = "INSERT INTO $tbl SET t_category='$ctgry', t_detail='$body',
> > > t_user='$usr', t_priority='$priority',
>t_timestamp_opened='$nowtime',
> > > t_department='$dpt', t_location='$loc', t_summary='$UFLINE'";
> > > $testresult = fwrite ($fp, $qry);
> > > $testresult = fwrite ($fp, "\n");
> > > #This executes the query that adds the ticket to the ticket table.
> > > $result = mysql_query ($qry)
> > > or die ("Query Failed\n");
> > > #This saves the Ticket ID created. It is needed to create an
> > > Authorize Event.
> > > $t_id = mysql_insert_id ($link);
> > > # or die ("Query Tid Failed\n");
> > > $testresult = fwrite ($fp, $t_id);
> > > $testresult = fwrite ($fp, "\n");
> > > $tbl = "events";
> > > #This builds the query that adds a new Authorize Event to the Event
> >table.
> > > #An Authorize Event in the event table is needed for the ticket
> > > to show up.
> > > $qry2 = "INSERT INTO $tbl SET t_id='$t_id', s_user='$usr',
> > > e_assignedto='$usr', e_status='$e_stat', e_description='$e_des'";
> > > $testresult = fwrite($fp, $qry2);
> > > $testresult = fwrite($fp, "\n");
> > > #This executes the query that adds a new Authorize Event to the
> > > Event table.
> > > $result = mysql_query ($qry2)
> > > or die ("Query2 Failed\n");
> > > #This closes the link to the database.
> > > mysql_close ($link);
> > > ?>
> > >
> > >
> > > _______________________________________________
> > > Phphelpdesk-help mailing list
> > > Php...@li...
> > > https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help
> > >
> >
> >
> >_______________________________________________
> >Phphelpdesk-help mailing list
> >Php...@li...
> >https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help
> >
> >_______________________________________________
> >Phphelpdesk-help mailing list
> >Php...@li...
> >https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help
|
|
From: Joe H. <jo...@ne...> - 2001-09-26 13:32:52
|
You should be able to just put this in the .forward file of the same
users' directory. Sometimes in sendmail it is better to put it in
/etc/smrsh, or at least put a symbolic link in there for this program.
This way, sendmail can run it as a secure shell. If I get time, I'll
try this at work today.
-----Original Message-----
From: Web-Hoster Support Team [mailto:su...@we...]=20
Sent: Wednesday, September 26, 2001 1:49 AM
To: Matthew C. Grab; php...@li...
Subject: RE: [Phphelpdesk-help] Enter Tickets via Email
Great news this has been talked about for a while - any chance of doing
a
sendmail version? or do we need to look at procmail?
Regards
Gavin
> -----Original Message-----
> From: own...@ww...
> [mailto:own...@ww...]On Behalf Of Matthew C.
Grab
> Sent: 26 September 2001 02:30
> To: php...@li...
> Cc: php...@li...
> Subject: [Phphelpdesk-help] Enter Tickets via Email
>
>
>
> Here is a script that allows you to enter tickets to phphelpdesk
> via an email.
> Assumed is that you have phphelpdesk up and running, and that you
> have php
> compiled for command line scripts. Also, you need to have qmail
running,
> and have an email account that can run this forward script.
> For example, I have an email account called helpdesk. I have a
> .qmail file
> which contains the command
>
> |/home/helpdesk/mail_to_db.php
>
> Copy this script in, edit the user and the category, put the
> .qmail file in
> /home/helpdesk, and whenever this user receives email, it will show up
> instantly in the support database.
>
> This will run the command that is needed.
> Note that this does not add the email as the user. All email tickets
are
> added under one account. It would be simple enough to parse out
> the user's
> email address, and submit it that way, but this is definitely
> simpler. It
> might be an idea to create multiple category email addresses, and have
> emails categorized that way.
> Follows is the mail_to_db.php script.
> You will need to edit the variables for such things as what user do
you
> want the email to be added to, what department, company, category,
etc..
>
> ------------------------------------------
> #!/usr/bin/php -q
> <?php
> #This connects to your database - put your mysql server, user, & pass
here
> $link =3D mysql_connect("localhost", "root", "")
> or die ("could not connect\n");
> mysql_select_db ("phphelpdesk")
> or die ("could not select database\n");
> $fp =3D fopen("./helplog", "a");
>
> #This makes it so that all emails sent to this email address show up
under
> #the same user in PHPHelpdesk
> $ctgry =3D "Other";
> $tbl =3D "ticket";
> $usr =3D "admin";
> $dpt =3D "crag";
> $loc =3D "idunno";
> $nowtime =3D date('Y-m-d H:i:s');
> $priority =3D "1";
> $e_stat =3D "REGISTERED";
> $e_des =3D "Ticket Assigned";
> #Read the entire email, including headers. It is being passed to
stdin.
> #The last 2 lines carve out only the message body, and trim leading
and
> #trailing whitespaces.
> $fd =3D fopen("php://stdin","r");
> while (!feof($fd)) {
> $data =3D fgets($fd, 4096);
> $testdata =3D "$testdata$data";
> }
> $body =3D strstr($testdata, "\n\n");
> $body =3D trim ($body);
> #This builds the query that adds the ticket to the ticket table.
> $qry =3D "INSERT INTO $tbl SET t_category=3D'$ctgry', =
t_detail=3D'$body',
> t_user=3D'$usr', t_priority=3D'$priority', =
t_timestamp_opened=3D'$nowtime',
> t_department=3D'$dpt', t_location=3D'$loc', t_summary=3D'$UFLINE'";
> $testresult =3D fwrite ($fp, $qry);
> $testresult =3D fwrite ($fp, "\n");
> #This executes the query that adds the ticket to the ticket table.
> $result =3D mysql_query ($qry)
> or die ("Query Failed\n");
> #This saves the Ticket ID created. It is needed to create an
> Authorize Event.
> $t_id =3D mysql_insert_id ($link);
> # or die ("Query Tid Failed\n");
> $testresult =3D fwrite ($fp, $t_id);
> $testresult =3D fwrite ($fp, "\n");
> $tbl =3D "events";
> #This builds the query that adds a new Authorize Event to the Event
table.
> #An Authorize Event in the event table is needed for the ticket
> to show up.
> $qry2 =3D "INSERT INTO $tbl SET t_id=3D'$t_id', s_user=3D'$usr',
> e_assignedto=3D'$usr', e_status=3D'$e_stat', =
e_description=3D'$e_des'";
> $testresult =3D fwrite($fp, $qry2);
> $testresult =3D fwrite($fp, "\n");
> #This executes the query that adds a new Authorize Event to the
> Event table.
> $result =3D mysql_query ($qry2)
> or die ("Query2 Failed\n");
> #This closes the link to the database.
> mysql_close ($link);
> ?>
>
>
> _______________________________________________
> Phphelpdesk-help mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help
>
_______________________________________________
Phphelpdesk-help mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help
|
|
From: Web-Hoster S. T. <su...@we...> - 2001-09-26 08:48:34
|
Great news this has been talked about for a while - any chance of doing a
sendmail version? or do we need to look at procmail?
Regards
Gavin
> -----Original Message-----
> From: own...@ww...
> [mailto:own...@ww...]On Behalf Of Matthew C. Grab
> Sent: 26 September 2001 02:30
> To: php...@li...
> Cc: php...@li...
> Subject: [Phphelpdesk-help] Enter Tickets via Email
>
>
>
> Here is a script that allows you to enter tickets to phphelpdesk
> via an email.
> Assumed is that you have phphelpdesk up and running, and that you
> have php
> compiled for command line scripts. Also, you need to have qmail running,
> and have an email account that can run this forward script.
> For example, I have an email account called helpdesk. I have a
> .qmail file
> which contains the command
>
> |/home/helpdesk/mail_to_db.php
>
> Copy this script in, edit the user and the category, put the
> .qmail file in
> /home/helpdesk, and whenever this user receives email, it will show up
> instantly in the support database.
>
> This will run the command that is needed.
> Note that this does not add the email as the user. All email tickets are
> added under one account. It would be simple enough to parse out
> the user's
> email address, and submit it that way, but this is definitely
> simpler. It
> might be an idea to create multiple category email addresses, and have
> emails categorized that way.
> Follows is the mail_to_db.php script.
> You will need to edit the variables for such things as what user do you
> want the email to be added to, what department, company, category, etc..
>
> ------------------------------------------
> #!/usr/bin/php -q
> <?php
> #This connects to your database - put your mysql server, user, & pass here
> $link = mysql_connect("localhost", "root", "")
> or die ("could not connect\n");
> mysql_select_db ("phphelpdesk")
> or die ("could not select database\n");
> $fp = fopen("./helplog", "a");
>
> #This makes it so that all emails sent to this email address show up under
> #the same user in PHPHelpdesk
> $ctgry = "Other";
> $tbl = "ticket";
> $usr = "admin";
> $dpt = "crag";
> $loc = "idunno";
> $nowtime = date('Y-m-d H:i:s');
> $priority = "1";
> $e_stat = "REGISTERED";
> $e_des = "Ticket Assigned";
> #Read the entire email, including headers. It is being passed to stdin.
> #The last 2 lines carve out only the message body, and trim leading and
> #trailing whitespaces.
> $fd = fopen("php://stdin","r");
> while (!feof($fd)) {
> $data = fgets($fd, 4096);
> $testdata = "$testdata$data";
> }
> $body = strstr($testdata, "\n\n");
> $body = trim ($body);
> #This builds the query that adds the ticket to the ticket table.
> $qry = "INSERT INTO $tbl SET t_category='$ctgry', t_detail='$body',
> t_user='$usr', t_priority='$priority', t_timestamp_opened='$nowtime',
> t_department='$dpt', t_location='$loc', t_summary='$UFLINE'";
> $testresult = fwrite ($fp, $qry);
> $testresult = fwrite ($fp, "\n");
> #This executes the query that adds the ticket to the ticket table.
> $result = mysql_query ($qry)
> or die ("Query Failed\n");
> #This saves the Ticket ID created. It is needed to create an
> Authorize Event.
> $t_id = mysql_insert_id ($link);
> # or die ("Query Tid Failed\n");
> $testresult = fwrite ($fp, $t_id);
> $testresult = fwrite ($fp, "\n");
> $tbl = "events";
> #This builds the query that adds a new Authorize Event to the Event table.
> #An Authorize Event in the event table is needed for the ticket
> to show up.
> $qry2 = "INSERT INTO $tbl SET t_id='$t_id', s_user='$usr',
> e_assignedto='$usr', e_status='$e_stat', e_description='$e_des'";
> $testresult = fwrite($fp, $qry2);
> $testresult = fwrite($fp, "\n");
> #This executes the query that adds a new Authorize Event to the
> Event table.
> $result = mysql_query ($qry2)
> or die ("Query2 Failed\n");
> #This closes the link to the database.
> mysql_close ($link);
> ?>
>
>
> _______________________________________________
> Phphelpdesk-help mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help
>
|
|
From: Matthew C. G. <mi...@ci...> - 2001-09-26 01:30:03
|
Here is a script that allows you to enter tickets to phphelpdesk via an email.
Assumed is that you have phphelpdesk up and running, and that you have php
compiled for command line scripts. Also, you need to have qmail running,
and have an email account that can run this forward script.
For example, I have an email account called helpdesk. I have a .qmail file
which contains the command
|/home/helpdesk/mail_to_db.php
Copy this script in, edit the user and the category, put the .qmail file in
/home/helpdesk, and whenever this user receives email, it will show up
instantly in the support database.
This will run the command that is needed.
Note that this does not add the email as the user. All email tickets are
added under one account. It would be simple enough to parse out the user's
email address, and submit it that way, but this is definitely simpler. It
might be an idea to create multiple category email addresses, and have
emails categorized that way.
Follows is the mail_to_db.php script.
You will need to edit the variables for such things as what user do you
want the email to be added to, what department, company, category, etc..
------------------------------------------
#!/usr/bin/php -q
<?php
#This connects to your database - put your mysql server, user, & pass here
$link = mysql_connect("localhost", "root", "")
or die ("could not connect\n");
mysql_select_db ("phphelpdesk")
or die ("could not select database\n");
$fp = fopen("./helplog", "a");
#This makes it so that all emails sent to this email address show up under
#the same user in PHPHelpdesk
$ctgry = "Other";
$tbl = "ticket";
$usr = "admin";
$dpt = "crag";
$loc = "idunno";
$nowtime = date('Y-m-d H:i:s');
$priority = "1";
$e_stat = "REGISTERED";
$e_des = "Ticket Assigned";
#Read the entire email, including headers. It is being passed to stdin.
#The last 2 lines carve out only the message body, and trim leading and
#trailing whitespaces.
$fd = fopen("php://stdin","r");
while (!feof($fd)) {
$data = fgets($fd, 4096);
$testdata = "$testdata$data";
}
$body = strstr($testdata, "\n\n");
$body = trim ($body);
#This builds the query that adds the ticket to the ticket table.
$qry = "INSERT INTO $tbl SET t_category='$ctgry', t_detail='$body',
t_user='$usr', t_priority='$priority', t_timestamp_opened='$nowtime',
t_department='$dpt', t_location='$loc', t_summary='$UFLINE'";
$testresult = fwrite ($fp, $qry);
$testresult = fwrite ($fp, "\n");
#This executes the query that adds the ticket to the ticket table.
$result = mysql_query ($qry)
or die ("Query Failed\n");
#This saves the Ticket ID created. It is needed to create an Authorize Event.
$t_id = mysql_insert_id ($link);
# or die ("Query Tid Failed\n");
$testresult = fwrite ($fp, $t_id);
$testresult = fwrite ($fp, "\n");
$tbl = "events";
#This builds the query that adds a new Authorize Event to the Event table.
#An Authorize Event in the event table is needed for the ticket to show up.
$qry2 = "INSERT INTO $tbl SET t_id='$t_id', s_user='$usr',
e_assignedto='$usr', e_status='$e_stat', e_description='$e_des'";
$testresult = fwrite($fp, $qry2);
$testresult = fwrite($fp, "\n");
#This executes the query that adds a new Authorize Event to the Event table.
$result = mysql_query ($qry2)
or die ("Query2 Failed\n");
#This closes the link to the database.
mysql_close ($link);
?>
|
|
From: Andrew W. <AJW...@ho...> - 2001-09-25 22:19:15
|
Hi Oliver; I actually added this feature to the customized version I run at work, I will integrate this and other upgrades in the near future.. Andrew Oliver Schoenknecht wrote: > Hello everyone, > > just wanting to know if there is any chance to make phpHelpDesk > 0.6.16 to send the internal ticket number assigned with each E-mail to > the customer ? > > I mean when opening and closing a ticket the customer shall always see > which ticket number this E-Mail refers to... > > Any idea on this one ? Would be really great as the program itself > just kicks ass ... :-) ! > > Keep it up ! > > -- > Mit freundlichem Gruss OSc...@ka... > Oliver Schoenknecht Join us at http://www.kapa.de > > ********************************************************************************* > * Telefonie der Zukunft: > * Voice Over IP, Telefonie über Netzwerktechnik! Ab sofort bei KAPA verfügbar! > * Sparen Sie Geld mit innovativer Technik durch Nutzung vorhandener Ressourcen! > ********************************************************************************* > > Als Recklinghausens Internet-Provider und Kommunikationsspezialist > bringen wir Sie sicher und angemessen in das Internet und sichern Ihre Kontakte!! > > _______________________________________________ > Phphelpdesk-help mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help |
|
From: Oliver S. <osc...@ka...> - 2001-09-25 10:44:15
|
Hello everyone, just wanting to know if there is any chance to make phpHelpDesk 0.6.16 to send the internal ticket number assigned with each E-mail to the customer ? I mean when opening and closing a ticket the customer shall always see which ticket number this E-Mail refers to... Any idea on this one ? Would be really great as the program itself just kicks ass ... :-) ! Keep it up ! -- Mit freundlichem Gruss OSc...@ka... Oliver Schoenknecht Join us at http://www.kapa.de *************************************************************************= ******** * Telefonie der Zukunft: * Voice Over IP, Telefonie =FCber Netzwerktechnik! Ab sofort bei KAPA ver= f=FCgbar!=20 * Sparen Sie Geld mit innovativer Technik durch Nutzung vorhandener Resso= urcen! *************************************************************************= ******** Als Recklinghausens Internet-Provider und Kommunikationsspezialist=20 bringen wir Sie sicher und angemessen in das Internet und sichern Ihre Ko= ntakte!! |
|
From:
<le...@co...> - 2001-09-20 13:16:19
|
Dear I have version 0.6.16 Phphelpdesk. My problem are in Netscape 4.51 (portuguese)when for view new jobs.In other versions of Netscape i have problem too. Thanks, |
|
From: Eric R. <eri...@mr...> - 2001-09-19 04:06:50
|
Okay, this is a never-mind. I don't know what was wrong, but I reinstalled and reconfigured and it seems to work. I'm guessing I deleted a critical character somewhere. Thanks for your help! > Sounds like a config file problem .. Can you post your > conf/general.conf.php file? > > Thanks; > Andrew > > > > Eric Reed wrote: > > > Hello, > > > > I'm trying to install version 0.6.16. Everything seems good, but I > > have all the symptoms of the cookie problem described in other > > postings. People seem to allude to a fix, but I can't find it. I have > > been able to use OTHER people's phphelpdesk installations via my > > browser, so there must be some tweak that will fix my installation. > > > > Advise is appreciated, > > > > Eric. > > > > _______________________________________________ > > Phphelpdesk-help mailing list > > Php...@li... > > https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help > > > _______________________________________________ > Phphelpdesk-help mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help > > |
|
From: Eric R. <eri...@mr...> - 2001-09-19 04:06:32
|
Okay, this is a never-mind. I don't know what was wrong, but I reinstalled and reconfigured and it seems to work. I'm guessing I deleted a critical character somewhere. Thanks for your help! > Sounds like a config file problem .. Can you post your > conf/general.conf.php file? > > Thanks; > Andrew > > > > Eric Reed wrote: > > > Hello, > > > > I'm trying to install version 0.6.16. Everything seems good, but I > > have all the symptoms of the cookie problem described in other > > postings. People seem to allude to a fix, but I can't find it. I have > > been able to use OTHER people's phphelpdesk installations via my > > browser, so there must be some tweak that will fix my installation. > > > > Advise is appreciated, > > > > Eric. > > > > _______________________________________________ > > Phphelpdesk-help mailing list > > Php...@li... > > https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help > > > _______________________________________________ > Phphelpdesk-help mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help > > |
|
From: Andrew <ajw...@ho...> - 2001-09-18 00:37:58
|
Sounds like a config file problem .. Can you post your conf/general.conf.php file? Thanks; Andrew Eric Reed wrote: > Hello, > > I'm trying to install version 0.6.16. Everything seems good, but I > have all the symptoms of the cookie problem described in other > postings. People seem to allude to a fix, but I can't find it. I have > been able to use OTHER people's phphelpdesk installations via my > browser, so there must be some tweak that will fix my installation. > > Advise is appreciated, > > Eric. > > _______________________________________________ > Phphelpdesk-help mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help |
|
From: Eric R. <eri...@mr...> - 2001-09-17 02:37:03
|
Hello, I'm trying to install version 0.6.16. Everything seems good, but I have all the symptoms of the cookie problem described in other postings. People seem to allude to a fix, but I can't find it. I have been able to use OTHER people's phphelpdesk installations via my browser, so there must be some tweak that will fix my installation. Advise is appreciated, Eric. |
|
From: Andre C. <ca...@op...> - 2001-09-16 07:07:00
|
Hello, I setup phphelpdesk and logged in as admin admin and I can not add users, categorys or anything else I keep getting "You do not have admin privlages" So I added a user into the db manually and I used the DB admin info and STILL I can't do anything PLUS all admins username looks like this when I log in: MTpBTklDOjM0ZTgzNWQxZDA0ZWQxZGYzODM3YjU0ZGMxY2Y4ZDU5OjEwOjowOjA6MDowOmFuaWM6NDA5Ng== Does any one have ANY idea whats wrong and how to fix it?!?!?! Andre |
|
From: <rb...@vo...> - 2001-09-14 19:03:47
|
Yes, just change your permissions for the users. Grant Privileges to them to "Register New Tickets" and change everything else to Don't Grant. -----Original Message----- From: Robert Wallace [mailto:to...@ip...] Sent: Friday, September 14, 2001 2:56 PM To: 'php...@li...' Subject: [Phphelpdesk-help] Help with PHPHelpDesk Is there a way to set the system to allow people to submit only and not view tickets. What I would really like is to have the ability to allow end users to submit tickets into the help desk and not see the tickets the engineer's submit. I would hate for a customer to see some of the comments the engineers put it about a situation. The engineers need to be able to see all tickets. We support multiple companies with PHP helpdesk. Todd Wallace |
|
From: Robert W. <to...@ip...> - 2001-09-14 18:57:23
|
Is there a way to set the system to allow people to submit only and not view tickets. What I would really like is to have the ability to allow end users to submit tickets into the help desk and not see the tickets the engineer's submit. I would hate for a customer to see some of the comments the engineers put it about a situation. The engineers need to be able to see all tickets. We support multiple companies with PHP helpdesk. Todd Wallace |
837 messages has been excluded from this view by a project administrator.
