phphelpdesk-help

[Phphelpdesk-help] format of text on after "Add Event" has occurred.

[Kevin M. S. <sh...@cg...>]

Ok. I have a problem/request. When I "Add Event" to a registered
ticket, I key in my text in the provided box and hit "Add Event".

My problem is, that I want the text in that window to remain as I 
keyed it in. Yet any formatting I do disappears and all text is
joined in sequence.

Is there something that I can do to avoid this?
perphaps you could direct me the piece of code (or file) that I 
may fix this?


Thanks for any assistance..

-k

Re: [Phphelpdesk-help] how to partecipate

[Andrew <ajw...@ro...>]

Hi Gigi;

Thanks for your email .. It's nice to hear that medium and
large companies are using PHP Helpdesk.  The best way
for PHP Helpdesk to grow and improve is if people that
use it are willing to help us make it better, and to avoid
having many incompatible versions.  Keeping one source
tree benefits everyone, since it will be easier for you
to include changes that other people will do in the future.

Would you mind sending me a copy of your version?  I
would like to look at it and see how difficult it would be
to add these improvements .. One important thing is 
making sure it is possible for existing users to migrate
to a new version after major changes (such as when
the database structure is changed).... I am very 
interested in looking at any kinds of improvements,
and the security privilege system is one area that 
could use improvement.

Also, it sounds like you have a team of programmers
working on your version .. If you are interested it may
be possible to add your people to the development
group so you can make changes to the main source
tree, provided that your version will be beneficial to
the existing users.

Thanks;
Andrew 



On Sunday 02 December 2001 08:14, you wrote:
> Dear phphelpdesk staff,
> let me introduce, my name is Gigi Delfino, i'm in Italy and i'm a service
> manager of a very big and important of a professional consultant society.
> We have about 80 employees and to centralize all help request from our
> customers we are deeping modifying, with our staff, phphelpdesk by adding
> new parametric fields, some new features to authorize tickets between
> levels of approver and levels of technician, and some thinghs about closing
> and forwarding ticket trought email.
> The reason that i'm writing, we would to (if is possible) partecipate into
> versioning of this software that we retain useful and very good.
> As well if you think there's a way to partecipate let us know.
>
> Best regards,
> Gigi Delfino
>
>
> _________________________________________________________________
> Scarica GRATUITAMENTE MSN Explorer all'indirizzo
> http://explorer.msn.it/intl.asp
>
>
> _______________________________________________
> Phphelpdesk-help mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

[Phphelpdesk-help] how to partecipate

[Piergiuseppe D. <pgd...@ho...>]

Dear phphelpdesk staff,
let me introduce, my name is Gigi Delfino, i'm in Italy and i'm a service 
manager of a very big and important of a professional consultant society.
We have about 80 employees and to centralize all help request from our 
customers we are deeping modifying, with our staff, phphelpdesk by adding 
new parametric fields, some new features to authorize tickets between levels 
of approver and levels of technician, and some thinghs about closing and 
forwarding ticket trought email.
The reason that i'm writing, we would to (if is possible) partecipate into 
versioning of this software that we retain useful and very good.
As well if you think there's a way to partecipate let us know.

Best regards,
Gigi Delfino


_________________________________________________________________
Scarica GRATUITAMENTE MSN Explorer all'indirizzo 
http://explorer.msn.it/intl.asp

[Phphelpdesk-help] Andrew Walker - New Project Manager

[Joe H. <jo...@jo...>]

Hi Everyone,

    As many of you know, lately I have not responded to most of you =
emails for support on this project.  I have been tremendously busy on =
other work related projects and thus have not had time to implement any =
changes to PHP Helpdesk.  This has been going on for about six months =
now.  I have been wanting to make the project much more robust with =
object oriented code, W3C standardization, better themes and graphics, =
more featuers, and bug fixes, along with continuing to promote the =
project.  However, everytime I say I'm going to sit down and work on it, =
I would get a phone call to go into the office because a server was down =
or something like that.
    Therefore, On December 1st I asked Andrew to become the Project =
Manager.  He has been very helpful, along with the rest of you, in =
making this project a team effort.  I think he will be a great project =
manager.  I enjoyed working on the project for the time that I did and =
would be glad to answer questions that you may have.  I still do have =
time constraints and may respond slowely to your emails, however.
    PHP Helpdesk is a great Help Desk tool.  The program work great for =
organizing trouble tickets/jobs and have a queue.  It compares to other =
$5,000 - $10,000 programs and the best thing is that it is GPL and FREE =
to use!  In any case, take care.  I hope the project continues to =
develop into a wonderful alternative to the comercial products.

Thanks,=20

Joseph Hoot
Systems Architect
jo...@ne...

[Phphelpdesk-help] just set it up: cant see/modify/delete users?!

[David D. <da...@sh...>]

I just set up phphelpdesk 0.6.16, very nice, I added a user with full 
access and then went to delete the default 'admin' user, but its not on 
the list, nor is the user I added, can anyone help me
dave

[Phphelpdesk-help] just set it up: cant see/modify/delete users?!

[David D. <da...@sh...>]

I just set up phphelpdesk 0.6.16, very nice, I added a user with full 
access and then went to delete the default 'admin' user, but its not on 
the list, nor is the user I added, can anyone help me
dave

Re: [Phphelpdesk-help] PHPHelpDesk and Debian Testing

[Ed B. <eba...@ta...>]

Yes, I had installed the tarball from sourceforge and not the CVS version. =
 I'm going to have to see how I can hack the new stuff into my installation=
, because I've modified it a little.

Ed
>>> Andrew <ajw...@ro...> 11/28/01 08:15PM >>>
There is code in the functions script that prevents it from being included
more than once .. Maybe the current CVS version is not what you
have installed .. Check your includes/functions.inc.php file .. The first
few lines of my version look like this:...<snip>


--
F. Edward Barrett
Network Specialist, Traverse Area District Library
http://tadl.tcnet.org

Re: [Phphelpdesk-help] PHPHelpDesk and Debian Testing

[Andrew <ajw...@ro...>]

There is code in the functions script that prevents it from being included
more than once .. Maybe the current CVS version is not what you
have installed .. Check your includes/functions.inc.php file .. The first
few lines of my version look like this:

<?php   // Global Functions

if( isset( $FUNCTIONS ) ) {
    return;
}

$FUNCTIONS=1;


These lines prevent the rest of the file from being imported more than once.

I have a nagging suspicion that there are a lot of little bug fixes like this 
that are not in the most recent release .. I will talk to Joe, to project 
leader, and we will look into making a new release which includes these 
fixes.  Also, someone from the list says he will send me some patches, so I 
would like to include those also.

Hope this helps;
Andrew



On Wednesday 28 November 2001 15:21, you wrote:
> Hello.  I am running PHPHelpDesk 0.6.16, installed on Debian Woody with
> apache 1.3.19 and php4.0.5.  Everything was running smoothly until I
> (foolishly, it turns out) updated to the following relevant packages:
>
> apache-1.3.22-2
> apache-common-1.3.22-2
> apache-dev-1.3.22-2
> apache-perl-1.3.22-2
> libapache-dbi-perl-0.88-5
> libapache-request-perl-0.33-1
> libapache-session-perl-1.53-4
> libapache-mod-perl-1.26-1
> php4-4.0.100-1
> php4-cgi-4.0.100-1
> php4-mysql-4.0.100-1
> php4-pear-4.0.100-1
>
> After this, I started receiving "apache: PHP Fatal error:  Cannot redeclare
> showsummary() in /var/www/helpdesk/includes/functions.inc.php on line 61"
> in my syslog.  It looks like php is barfing on includes/functions.inc.php
> being included in most of the scripts in the system.  I seem to have fixed
> my problem when I commented out "include("includes/functions.inc.php");" at
> the top of each script that had it and added it to the top of index.php. 
> Now, I would believe this is a problem with the compile-time options used
> in the Debian packaging of PHP, but I'm wondering if there isn't a better
> way to fix the problem than what I did.  Any suggestions?
>
> Oh, and by the way, this is an excellent piece of software!  We're using
> this to replace the paper trouble ticket system that we've had in place
> since we've been running.
>
> Edward Barrett

[Phphelpdesk-help] PHPHelpDesk and Debian Testing

[Ed B. <eba...@ta...>]

Hello.  I am running PHPHelpDesk 0.6.16, installed on Debian Woody with =
apache 1.3.19 and php4.0.5.  Everything was running smoothly until I =
(foolishly, it turns out) updated to the following relevant packages:

apache-1.3.22-2
apache-common-1.3.22-2
apache-dev-1.3.22-2
apache-perl-1.3.22-2
libapache-dbi-perl-0.88-5
libapache-request-perl-0.33-1
libapache-session-perl-1.53-4
libapache-mod-perl-1.26-1
php4-4.0.100-1
php4-cgi-4.0.100-1
php4-mysql-4.0.100-1
php4-pear-4.0.100-1

After this, I started receiving "apache: PHP Fatal error:  Cannot =
redeclare showsummary() in /var/www/helpdesk/includes/functions.inc.php on =
line 61" in my syslog.  It looks like php is barfing on includes/functions.=
inc.php being included in most of the scripts in the system.  I seem to =
have fixed my problem when I commented out "include("includes/functions.inc=
.php");" at the top of each script that had it and added it to the top of =
index.php.  Now, I would believe this is a problem with the compile-time =
options used in the Debian packaging of PHP, but I'm wondering if there =
isn't a better way to fix the problem than what I did.  Any suggestions?

Oh, and by the way, this is an excellent piece of software!  We're using =
this to replace the paper trouble ticket system that we've had in place =
since we've been running.

Edward Barrett

--
F. Edward Barrett
Network Specialist, Traverse Area District Library
http://tadl.tcnet.org

Re: [Phphelpdesk-help] A hole about helpdesk..

[Andrew <ajw...@ro...>]

Pim;

Yes, you can delete from the security table, it won't cause
problems (just be carefuly when doing any update or 
delete sql) ... You can also use sql to change passwords if
needed (they are stored as plain text)

The current version of the helpdesk does have a delete user
option .. I don't remember which version this feature was added
to, but it's been there quite a while.

Andrew



On Tuesday 20 November 2001 09:36, Pim van Stam wrote:
> > -----Oorspronkelijk bericht-----
> > Van: php...@li...
> > [mailto:php...@li...]Namens Kevin M.
> > Shortt
> > Verzonden: dinsdag 20 november 2001 15:08
> > Aan: Pim van Stam
> > CC: php...@li...
> > Onderwerp: RE: [Phphelpdesk-help] A hole about helpdesk..
> >
> > On Tue, 20 Nov 2001, Pim van Stam wrote:
> > > I rather like to know what the leak exactly is and how to solve it.
> > > Is it possible for anyone to tell?
> >
> > I posted last week about one issue I discovered.
> > If the issue is known about, and all default usernames/passwords
> > are cleaned up properly, then I really isn't any way a user
> > could get the access.
> >
> > The issue I discovered can be read in detail at:
> > http://sourceforge.net/tracker/index.php?func=detail&aid=48167
> > 8&group_id=5706&atid=205706
> >
> > The issue of the demo site password being changed, was that the
> > default usernames with default privileges were installed and
> > unchanged.
> > so anyone familiar with phphelpdesk would be able to guess it, and
> > comprise the phphelpdesk demo. That's the extent of it really.
> >
> > All and all the software is sound.
> >
> > To follow the information posted on the url above, click on
> > the "Browse"
> > link near the top of the page, that will bring you to the index of
> > posts for phphelpdesk.
> >
> > I hope this helps.
> >
> >
> > -k
>
> Is there a solution, apart from deleting from the database directly by
> 'mysql'?
> And if not, if I delete from the table security, with the following, is
> there anything else left behind?
>
> mysql> delete from security where s_user='testuser';
>
>
> Regards, Pim
>
>
>
>
> _______________________________________________
> Phphelpdesk-help mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

Re: [Phphelpdesk-help] Anyone alive ?

[Andrew <ajw...@ro...>]

Hi Vladimir;

I've taken a bit of a break from the project, and I havn't heard much
from Joe lately either.  Anyway, please send me your patches, I will
gladly add them.  I also just added a file upload/attachment feature, so 
I'll ask Joe to create a new release soon.

Thanks;
Andrew




On Tuesday 20 November 2001 19:38, Vladimir Vuksan wrote:
> I have contacted couple of the PHP Helpdesk developers about submitting
> patches but have received no answer. Last release was more than 3 months
> ago so I was just wondering what are the developers up to. Are other
> developers simply too busy ?
>
> Thanks,
>
> Vladimir
>
>
>
>
> _______________________________________________
> Phphelpdesk-help mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

[Phphelpdesk-help] Individual User Activity Report

[<mi...@dt...>]

Hi All

Has any one on the list created an adjusted/new report which would display for 
printing a users ticket activity for a time period ?

Some things like

Headers - Name, and total hours, ETC.

BODY
Tickets ID, Ticket Short Summary, Total Hours, Total Parts Cost
              Tickets Full Description
     Tickets Parts and Cost.

Repeat for all jobs in the period, includeing open and closed jobs.

If not, does any one have a report I could adjust to do this ?

Thanks
	Mike O'Connor

[Phphelpdesk-help] Anyone alive ?

[Vladimir V. <vu...@sa...>]

I have contacted couple of the PHP Helpdesk developers about submitting
patches but have received no answer. Last release was more than 3 months
ago so I was just wondering what are the developers up to. Are other
developers simply too busy ?

Thanks,

Vladimir

RE: [Phphelpdesk-help] A hole about helpdesk..

[Pim v. S. <pim...@nl...>]

> -----Oorspronkelijk bericht-----
> Van: php...@li...
> [mailto:php...@li...]Namens Kevin M.
> Shortt
> Verzonden: dinsdag 20 november 2001 15:08
> Aan: Pim van Stam
> CC: php...@li...
> Onderwerp: RE: [Phphelpdesk-help] A hole about helpdesk..
>
>
>
>
> On Tue, 20 Nov 2001, Pim van Stam wrote:
>
> > I rather like to know what the leak exactly is and how to solve it.
> > Is it possible for anyone to tell?
> >
>
> I posted last week about one issue I discovered.
> If the issue is known about, and all default usernames/passwords
> are cleaned up properly, then I really isn't any way a user
> could get the access.
>
> The issue I discovered can be read in detail at:
> http://sourceforge.net/tracker/index.php?func=detail&aid=48167
> 8&group_id=5706&atid=205706
>
> The issue of the demo site password being changed, was that the
> default usernames with default privileges were installed and
> unchanged.
> so anyone familiar with phphelpdesk would be able to guess it, and
> comprise the phphelpdesk demo. That's the extent of it really.
>
> All and all the software is sound.
>
> To follow the information posted on the url above, click on
> the "Browse"
> link near the top of the page, that will bring you to the index of
> posts for phphelpdesk.
>
> I hope this helps.
>
>
> -k
>

Is there a solution, apart from deleting from the database directly by
'mysql'?
And if not, if I delete from the table security, with the following, is
there anything else left behind?

mysql> delete from security where s_user='testuser';


Regards, Pim

RE: [Phphelpdesk-help] A hole about helpdesk..

[Kevin M. S. <sh...@cg...>]

On Tue, 20 Nov 2001, Pim van Stam wrote:

> I rather like to know what the leak exactly is and how to solve it.
> Is it possible for anyone to tell?
> 

I posted last week about one issue I discovered. 
If the issue is known about, and all default usernames/passwords
are cleaned up properly, then I really isn't any way a user
could get the access. 

The issue I discovered can be read in detail at:
http://sourceforge.net/tracker/index.php?func=detail&aid=481678&group_id=5706&atid=205706

The issue of the demo site password being changed, was that the 
default usernames with default privileges were installed and unchanged.
so anyone familiar with phphelpdesk would be able to guess it, and
comprise the phphelpdesk demo. That's the extent of it really.

All and all the software is sound. 

To follow the information posted on the url above, click on the "Browse"
link near the top of the page, that will bring you to the index of 
posts for phphelpdesk.

I hope this helps.


-k

RE: [Phphelpdesk-help] A hole about helpdesk..

[Pim v. S. <pim...@nl...>]

 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I rather like to know what the leak exactly is and how to solve it.
Is it possible for anyone to tell?

Regards, Pim

> -----Oorspronkelijk bericht-----
> Van: php...@li...
> [mailto:php...@li...]Namens Kevin
> M. Shortt
> Verzonden: dinsdag 20 november 2001 12:10
> Aan: alister air
> CC: tu...@tu...; php...@li...
> Onderwerp: Re: [Phphelpdesk-help] A hole about helpdesk..
> 
> 
> 
> 
> On Tue, 20 Nov 2001, alister air wrote:
> 
> > such way.  Changing the password and attempting to hold the 
> demo site to 
> > ransom is *not* one such way.  It would be polite now to change
> > the  passwords back to their originals.
> 
> I agree with Alister. If anyone needs assistance recovering from
> such an act, then email me directly. I can help them change the
> password back without the help of the person that changed it.
> 
> 
> -k
> 
> 
> 
> 
> _______________________________________________
> Phphelpdesk-help mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

-----BEGIN PGP SIGNATURE-----
Version: PGP 7.0.4

iQA/AwUBO/pZdY5pIpBZNFf7EQIIyQCfVCxOhhh0SLLuukcmieTv+Bzje/IAnRDo
rcLeZnBdGYLxLS5HHELrgG5K
=XfY3
-----END PGP SIGNATURE-----

Re: [Phphelpdesk-help] A hole about helpdesk..

[Kevin M. S. <sh...@cg...>]

On Tue, 20 Nov 2001, alister air wrote:

> such way.  Changing the password and attempting to hold the demo site to 
> ransom is *not* one such way.  It would be polite now to change the 
> passwords back to their originals.

I agree with Alister. If anyone needs assistance recovering from such
an act, then email me directly. I can help them change the password
back without the help of the person that changed it.


-k

Re: [Phphelpdesk-help] A hole about helpdesk..

[alister a. <ali...@ut...>]

Yes.

And that's helpful.  Unless you're a script kiddie wannabe, you would not 
do this.  Do you not realise that it's self-evident that a program like 
this isn't immensely secure?  Demo sites *aren't supposed* to have top 
security on them in any case, as otherwise the demo is somewhat 
limited.  Further, it's polite to point out the security hole in a 
non-malicious way - emailing the sourceforge project leader would be one 
such way.  Changing the password and attempting to hold the demo site to 
ransom is *not* one such way.  It would be polite now to change the 
passwords back to their originals.

If you want to secure your helpdesk system, you might want to restrict the 
IP addresses that can access it, and ensure a valid reverse lookup is 
performed.

Regards,

Alister

At 02:58 AM 11/20/2001, tu...@tu... wrote:
>I find a hole on your demo site..And I change all password to enter the 
>helpdesk..Please make warning to helpdesk users..If you need the password 
>I can send you..See you later..
>--
>_____________________________________________
>Merhaba bedava mail ve üyelik http://turks.i-p.com
>BÝZE KATIL.
>
>Powered by Instant Portal
>
>_______________________________________________
>Phphelpdesk-help mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help


--

Alister Air          Ph 9514 1277
IT Manager           Fx 9514 1656
Faculty of Science, University of Technology Sydney

"I will never apologize for the United States of America.
I don't care what the facts are." George H Bush, 1988,
after the U.S. warship Vincennes shot down an Iranian
airliner in a commercial corridor, killing 290 civilians.

[Phphelpdesk-help] A hole about helpdesk..

[<tu...@tu...>]

I find a hole on your demo site..And I change all password to enter the helpdesk..Please make warning to helpdesk users..If you need the password I can send you..See you later..
-- 
_____________________________________________
Merhaba bedava mail ve üyelik http://turks.i-p.com
BÝZE KATIL.

Powered by Instant Portal

[Phphelpdesk-help] Security Bug - add/delete user problem

[Kevin M. S. <sh...@cg...>]

I am cross-posting this here as well as the support request board.
I am sorry if you are seeing this multiple times.

-k

-------

If a privileged account deletes a Department before deleting the users 
assigned to that department, then the user is unable to be deleted or 
modified, but still has the ability to login. 

I discovered this during the implementation. I used the phphelpdesk.mysql 
to create my datatbase. I wanted to test behavior with the sample data 
first. When I was done cleaning out the phoney data with the web interface, 
I went back and tried to login in with "it"/"it". I was surprised to see that I 
got in. 


I have a detailed explanation below. 

Any questions feel free to email me. 
---- 
load page: http://phphelpdesk.yourdomain.com/index.php 

1. Login. 

2. Click on "Add Department", Follow proper steps to add the department. 
   To test, do not be bothered aligning permissions, any will do. 
   I added (testdepartment). 

3. When main page returns, click on "Add User", Follow proper steps, 
   be sure that you adding your user to the "testdepartment" ONLY. 
   If two departments are assigned to one user, and one department 
   get's deleted, then some useless data is left behind in some tables, 
   but no security hole should exist. 
   I added (testuser2). 

4. Now verify from the mysql prompt that both department and user 
   exist as expected. My table output is here: 

	mysql> select * from department; 
	+----------------+ 
	| d_name | 
	+----------------+ 
	| Client | 
	| Internal | 
	| testdepartment | 
	+----------------+ 
	3 rows in set (0.00 sec) 

	mysql> select * from userdepartments ;
	+-------+-----------+----------------+ 
	| ud_id | s_user | d_name | 
	+-------+-----------+----------------+ 
	| 2 | admin | Client | 
	| 6 | testuser2 | testdepartment | 
	| 5 | admin | testdepartment | 
	| 3 | shortt | Client | 
	| 1 | admin | Internal | 
	| 4 | shortt | Internal | 
	+-------+-----------+----------------+ 
	6 rows in set (0.00 sec) 

	mysql> select s_user from security; 
	+-----------+ 
	| s_user | 
	+-----------+ 
	| admin | 
	| shortt | 
	| testuser2 | 
	+-----------+ 
	3 rows in set (0.00 sec) 

	mysql> 

5. Click on "Delete Department". Follow the proper steps to delete a department. 
   I deleted (testdepartment). 
6. Now verify from the mysql prompt that department was deleted as expected. 
   Notice that testuser2 still exists in the security table.My table output is here: 

	mysql> select * from department; 
	+----------+ 
	| d_name | 
	+----------+ 
	| Client | 
	| Internal | 
	+----------+ 
	2 rows in set (0.00 sec) 

	mysql> select * from userdepartments; 
	+-------+--------+----------+ 
	| ud_id | s_user | d_name | 
	+-------+--------+----------+ 
	| 2 | admin | Client | 
	| 3 | shortt | Client | 
	| 1 | admin | Internal | 
	| 4 | shortt | Internal | 
	+-------+--------+----------+ 
	4 rows in set (0.00 sec) 

	mysql> select s_user from security; 
	+-----------+ 
	| s_user | 
	+-----------+ 
	| admin | 
	| shortt | 
	| testuser2 | 
	+-----------+ 
	3 rows in set (0.00 sec) 

	mysql> 

7. Click on "Delete User". The only users (in my case) to choose are "shortt"and "admin". 
8. Log out. 
9. Log back in using testuser2. 
   Bingo!!! you're back in. 

[Phphelpdesk-help] typo/bug

[Kevin M. S. <sh...@cg...>]

I found a bug/typo. 
I have installed version 0.6.16.
The SQL SELECT statement bombed when attempting to add departments
during the Add User process. The initial query declaration was missing
a space at the end, thus bleeding it into the "WHERE.." portion of the
query.

Any questions, shoot me an email.

-k


I tracked it down and found it here:

line #: 	66
file: 		scripts/adduser.scp.php

The line was:
        $query = "SELECT d_name FROM userdepartments";
I should be:
        $query = "SELECT d_name FROM userdepartments ";

Re: [Phphelpdesk-help] Ticket # in receipts

[Matt G. <ma...@ma...>]

I looked at the code in addjob.scp.php.  Here is what I noted.  First, the 
ticket is created, and inserted into the ticket table.  The ticket ID is 
not known by the code at this time.  However, I assume that the ticket ID 
must be known by the time the code inserts the event into the event 
table.  The reason is this: mysql will add a new ticket, and automatically 
increment the ticket ID.  When adding the event, mysql does not know which 
ticketID you are referring to.  So the code must determine the ticket ID, 
and assign it to the event when it inserts it into mysql.  That is the part 
that needs figured out.

Matt

At 09:25 AM 11/8/2001 -0500, you wrote:
>Has anyone been able to get the Ticket# to come through in the email
>receipts to the client?
>I have tried adding the $t_id variable in several places to no avail.
>
>
>
>Mitchell K. Smith
>Service and Information Systems Manager
>ePlus Technology of PA
>130 Futura Drive
>Pottstown, PA  19464
>610-495-7800 ext. 264
>mk...@pa...
>
>
>
>_______________________________________________
>Phphelpdesk-help mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

Re: [Phphelpdesk-help] Ticket # in receipts

[Matt G. <ma...@ma...>]

I think I found out how it works here.  The mysql command includes 
LAST_INSERT_ID() as what is to be placed into the t_id field of the 
event.  This is interpreted by mysql as a command to just replace 
LAST_INSERT_ID() with whatever was the last id of the last record added.  I 
don't believe this is a good idea, but I could be wrong.  Under heavy 
volume, two tickets could be entered near-simultaneously.  Unless the 
LAST_INSERT_ID() function is only for the user that is logged into mysql at 
that time for that session only.  So the code never knows what the ticket 
id is.  It just tells mysql to look up the last ticket id that mysql just 
created, and use that.  However I believe there is a way to find it.

Matt

At 09:25 AM 11/8/2001 -0500, you wrote:
>Has anyone been able to get the Ticket# to come through in the email
>receipts to the client?
>I have tried adding the $t_id variable in several places to no avail.
>
>
>
>Mitchell K. Smith
>Service and Information Systems Manager
>ePlus Technology of PA
>130 Futura Drive
>Pottstown, PA  19464
>610-495-7800 ext. 264
>mk...@pa...
>
>
>
>_______________________________________________
>Phphelpdesk-help mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

[Phphelpdesk-help] Re: Ticket # in receipts - theoretically solved

[Matt G. <ma...@ma...>]

In my code to add a ticket, I faced this problem also.  Here's what I did.
I used the command $t_id = mysql_insert_id ($link);
I believe it needs to be run after the $mysql_result = query($query); command.


#Somebody who knows more about php might know this.  But right now, the 
next line after #mysql_result=query(query) is
i#f ($mysql_result) {
#
#2 questions.  If I put the command $t_id = mysql_insert_id ($link); after 
the $mysql_result = #query($query); command, will the if($mysql_result) { 
command still work.  I imagine that if($mysql_result { #only works if 
something is in mysql_result


yes, I am sure that is what needs done.
$mysql_result = query($query);
$t_id = mysql_insert_id ($mysql_link);

at this point, you now have $t_id filled in.
then, add your $t_id into the email that is sent out.  The only question is 
this.  What is the name of

Matt


At 09:25 AM 11/8/2001 -0500, you wrote:
>Has anyone been able to get the Ticket# to come through in the email
>receipts to the client?
>I have tried adding the $t_id variable in several places to no avail.
>
>
>
>Mitchell K. Smith
>Service and Information Systems Manager
>ePlus Technology of PA
>130 Futura Drive
>Pottstown, PA  19464
>610-495-7800 ext. 264
>mk...@pa...
>
>
>
>_______________________________________________
>Phphelpdesk-help mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

RE: [Phphelpdesk-help] Ticket # in receipts

[Tijl D. <tdu...@co...>]

 Hi, 

I did add the ticket ID , ... into the E-mail to the client but this a
little bit in a frantic way :) 

Because I did not seem to succeed in just putting the $t_id I made a new SQL
query which 
did a select on ticket id where timestamp, problem description , department
etc etc are the same 
as the respective values or the variables in the PHP code.

This is maybe not the most clean way to do it but when you want to make it
work quickly it is a good solution , 
We are using the system now already for one month in prodction and it always
gave correct results. 

Regards, 

Tijl




-----Original Message-----
From: Mitchell K. Smith
To: 'php...@li...'
Sent: 8-11-01 15:25
Subject: [Phphelpdesk-help] Ticket # in receipts

Has anyone been able to get the Ticket# to come through in the email
receipts to the client?
I have tried adding the $t_id variable in several places to no avail.



Mitchell K. Smith
Service and Information Systems Manager
ePlus Technology of PA
130 Futura Drive
Pottstown, PA  19464
610-495-7800 ext. 264
mk...@pa...



_______________________________________________
Phphelpdesk-help mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help