phphelpdesk-help

[Phphelpdesk-help] re helpdesk and NIS

[mmoriarty <mm...@cs...>]

Many thanks for reponses. Plenty of food for thought
Martin

Re: [Phphelpdesk-help] compatibility with NIS/yp

[Tony G. <Get...@ka...>]

It would be cool to authenticate to LDAP. However, developing that piece =
is certainly beyond my programming abilities right now. But maybe not =
forever. :) I've used PHP to query LDAP, but not for authentication =
purposes such as this.


-----
Please "Reply All" if this is KPS Technology Services related email

Tony Gettig
Network Administrator
Kalamazoo Public Schools
616-337-0283
http://www.kalamazoopublicschools.com


>>> Roy Rapoport <rs...@ae...> 07/31/02 02:19PM >>>
There are two ways I can think of that would achieve this:
A) Modify PHPHD to actually be able to deal with external usernames and
   passwords
...

Re: [Phphelpdesk-help] compatibility with NIS/yp

[Roy R. <rs...@ae...>]

On Tue, 30 Jul 2002, mmoriarty wrote:
> Ive successfully deployed phphelpdesk on our unix server, and it is
> working really well. Looking ahead, I want our students to log calls
> directly on the system, as there is around 600 of them and they already
> have NIS accounts and encrypted passwords, I would rather that they
> could resuse these to log into helpdesk and use the system. Would anyone
> know of a way to achieve this? The other alternative is to let each year
> log in as a single user but then they would see each others logs rather
> than seeing a personalised view
> Any suggestions would be most welcom

There are two ways I can think of that would achieve this:
A) Modify PHPHD to actually be able to deal with external usernames and
   passwords
This would be non-trivially difficult.  It's not impossible (mostly because
querying user rights doesn't happen very often in the program), but would
be ... kinda messy.  The best approach, I suppose, would be to create some
sort of external user API that could be queried if you couldn't find a user
in the database.  Shamefully, I have to admit that the more I think of it,
the more I think it's actually doable, but I'm not sure I'd want to tackle
if if I didn't have a good week or so of free time to do it properly (of
course, this is impacted by whether or not you want to engineer things in a
way you can later contribute back to the source or merge with new versions
of PHPHD);

B) Data import/export
This is much more trivially easy -- just run some sort of program every
night that imports the NIS accounts into PHPHD and removes old accounts
that have been deleted from NIS.  You'd want to make some sort of maker for
these rows in the security table so you'd know they're associated with NIS
accounts, of course.

(A) is more elegant; (B) is simpler.  A competent PHP programmer probably
could do (B) in an hour or two.  The issue of dealing with the standard
UNIX-encrypted passwords is left up to the student as an exercise. :)

-roy

[Phphelpdesk-help] compatibility with NIS/yp

[mmoriarty <mm...@cs...>]

Hi threr
Ive successfully deployed phphelpdesk on our unix server, and it is 
working really well. Looking ahead, I want our students to log calls 
directly on the system, as there is around 600 of them and they already 
have NIS accounts and encrypted passwords, I would rather that they 
could resuse these to log into helpdesk and use the system. Would anyone 
know of a way to achieve this? The other alternative is to let each year 
log in as a single user but then they would see each others logs rather 
than seeing a personalised view
Any suggestions would be most welcom
Regards
Martin Moriarty
Systems administrator

[Phphelpdesk-help] Thanx !

[Marco A. M. M. <mar...@su...>]

Hello !

Yer software is great ! im using it since 6 months and is working excelent
for me & my co ... juas a big THANX !

-- 
Marco Antonio Muskus Muskus
Tecnico Administrativo
Oficina Asesora de Planeacion
Superintendencia de Puertos y Transporte
Carrera 7 # 73- 47 (Ed. Shell) - Tel 640 7930 - Bogota, D.C.

[Phphelpdesk-help] ADV - JustPlugins: Apps 4 Web Producers

[<jbo...@ju...>]

	JustPlugins.com provides web producers with 
a long list of useful "plugin" applications
and combines them with custom deployment to
seamlessly stitch them into your sites.

Plugins make it easy, and inexpensive to add sleak, 
databased functionality to your website projects.
These helper apps are customized tolook like they 
belong in your clients' web sites and are available 
via monthly subscription.

We'd be grateful if you got know us.

Stop by http://www.justplugins.com/demos

Plugin.... 

Auctions  
Real Estate Listings
Dealership Inventory Management
Turnkey Online Catalogs (4 kinds!)
A Whole Suite of Lawfirm Website Functionality
Online Drawings/Contests
Online Menus Editing (for restaurants)
Online Calendars
Press Releases/News Articles
Discussion Forums
Coupon Publishing
Online Specials Publishing
Timed Automatic Emailing
Talent/VideoClip Resume Publishing
Online Quizzes and Testing
Interest Rate Publishing

Ask us about "The Q" - our proprietary, comprehensive website
design project intranet system.

43 apps in all, and the list is growing.

Realtime Publishing Tools for just pennies/day. - some as low as
$7.95/month

Empower your clients to manage their own content.


* Need an app we don't have? We may build it specially for you.
* Pricing Bundles available.
* Felixible Reseller Arrangements
* Would you like our pricing grid spreadsheet sent to you?

Thank you for very, very much your time.

Jeffrey Bonnell, President
http://www.JustPlugins.com
908-665-2500 x150

====================
Reply:  remove, or reply blank or with
the existing subject to be purged from our
database. 

Bill and I cleaned this database by 
hand and believe we've got it clearly targeted to
web designers who are most likely to find this
of interest. We don't want anybody to get this
who shouldn't or who doesn't want it.
	

Re: [Phphelpdesk-help] Opinion Solicitation: Deleting/Modifying Events

[Roy R. <rs...@ae...>]

On Mon, 15 Jul 2002, Tony Gettig wrote:
>From my perspective, I would think if a person has the ability to enter
>and update tickets, that should be security enough to be able to change
>the date. Which, if I understand your application of it, is how you are
>using it at your place. If integrity of the record is ever in question,
>could the dbadmin check the timestamp of the entry? Looking at the events
>table layout, might this require an extra field in the mysql db? For
>instance, a timestamp field (already there) and an e_workdate field for
>the date entered. Just thinking out loud now.

Right now, as you noticed, there's only one field -- e_timestamp.  Changing
the schema as you suggested would work, but I'm disinclined to do this
because database changes are kind of a big deal when it comes to people
already using the product and, frankly, I don't really think it's my place
to contribute code that requires DB changes.

> I've made very few changes to the program, but this is one that I've been
> seriously considering doing. If you have plans to put this ability in the
> release, I'll likely wait. I'm not much of a programmer, preferring to
> leave such things to people that are actually good at it. :)

Well, I have plans to put this ability in the repository.  I don't actually
make any decisions about when the next version of PHPHD is released and
what is included in it -- keep in mind I'm just a PHPHD user who hounded
the project manager until he gave me access to the repository.

As for leaving coding to people that are actually good at it ... why, yes,
I should probably do that also :)

-roy

Re: [Phphelpdesk-help] Opinion Solicitation: Deleting/Modifying Events

[Tony G. <Get...@ka...>]

Hi there,

I think the ability to set the date on an event is a great enhancement, =
and actually preferable.It can always default to the current date and =
time, but making it changeable is great. We use phphelpdesk for internal =
call tracking and have deployed it not just to our IT support staff, but =
to a group of teachers in the various schools doing front line support. =
They have to track their time carefully, as it is funded by grant. Many =
times, they log their time days (or weeks!) after the actual work is done. =
If they can't resolve the issue, they reassign it to Not Assigned and we =
take it from there. Likewise, we can delegate work to them in this manner.

From my perspective, I would think if a person has the ability to enter =
and update tickets, that should be security enough to be able to change =
the date. Which, if I understand your application of it, is how you are =
using it at your place. If integrity of the record is ever in question, =
could the dbadmin check the timestamp of the entry? Looking at the events =
table layout, might this require an extra field in the mysql db? For =
instance, a timestamp field (already there) and an e_workdate field for =
the date entered. Just thinking out loud now.=20

I've made very few changes to the program, but this is one that I've been =
seriously considering doing. If you have plans to put this ability in the =
release, I'll likely wait. I'm not much of a programmer, preferring to =
leave such things to people that are actually good at it. :)


-----
Please "Reply All" if this is KPS Technology Services related email

Tony Gettig
Network Administrator
Kalamazoo Public Schools
616-337-0283
http://www.kalamazoopublicschools.com


>>> Roy Rapoport <rs...@ae...> 07/13/02 06:50PM >>>
...
So the question to the list is:  Is this a useful capability? And if it =
is,
who should be allowed to modify/delete events?  Here, we've got everyone
who can update a ticket allowed to modify an event (on the basis that if
you're allowed to add an event, you should be allowed to delete/modify =
it),
but that may be overly unparanoid.

I'd like to put this capability into the repository, but I'd like to get
opinions as to how it should work.

[Phphelpdesk-help] Opinion Solicitation: Deleting/Modifying Events

[Roy R. <rs...@ae...>]

We're using events here to track time spent for clients; we then use these
events in reporting to actually generate invoices.  This means that in
general, we want events to be as reflective of reality as possible.

What we found was that it was reasonably difficult to actually have people
update a ticket as to what they did and when they did it on the same day
they did it.  The end result is that the way people usually preferred to
use the HD was to enter their activity in batches, every few days.  Because
we wanted to be able to accurately report the date of the activity, we
decided it would be beneficial to give them the ability to change/delete
the event.  At the same time, after a few too many "Oh, I entered 80 hours
into this event when I meant to enter 80 miles travelled," we also made it
possible to change the duration of the event.

Lastly, we typically see two sorts of client-oriented activity tickets:
A) ongoing work;
B) special projects.

So one of the things we wanted to be able to do was to move events from one
ticket to another ticket of the same client.  This is so we could
facilitate this sort of situation:

Person comes on-site and does work for client; they do tasks A, B, C, and D
for the client and enter helpdesk events for them under the "ongoing work"
ticket.  Then they find that (D) is actually the beginning of a special
project and open a new special project ticket (example:  The last thing the
person does is look at a server to do a health check.  Oh wait -- there's a
problem with the RAID and it needs to be rebuilt.  Open a special ticket
for this).  At that point, it'd be useful to shift the activity related to
this special project to the new 'special project' ticket and away from the
'ongoing work' ticket.

Apologies for being so long-winded.

So the question to the list is:  Is this a useful capability? And if it is,
who should be allowed to modify/delete events?  Here, we've got everyone
who can update a ticket allowed to modify an event (on the basis that if
you're allowed to add an event, you should be allowed to delete/modify it),
but that may be overly unparanoid.

I'd like to put this capability into the repository, but I'd like to get
opinions as to how it should work.

Thoughs?

-roy

RE: [Phphelpdesk-help] latest release?

[Roy R. <rs...@ae...>]

On Fri, 12 Jul 2002, Ray Miller wrote:
> Are you giving out copies of your coding additions?

Yup.  I'm probably more inclined to do this the orderly way -- by getting
the coding additions into the actual project -- but I'm not adverse to
mailing around diffs if I need to.

Since there seems to be some interest in the tweaks, let me ask this:
Of these changes:
> A) Be able to log events as people who are not the ticket owners without
> reassigning the ticket;
> B) Be able to modify or delete events;
> C) Some new reporting features;
> D) Greater compartmentalization between users (we wanted users who are
> only
> authorized for one company/department, for example, to not see the total
> number of tickets in the helpdesk).
> E) Invoicing out of the helpdesk (which is what I've done all last
> night.
> Sleep.  Good.)
> F) Automatically add existing manager-level people to new companies when
> they (the companies) are created.
G) Do not show ticket numbers in the initial login screen (before
authentication occurs)

Would people who are interested in any of these prioritize which they would
like to see put into the system first?

-roy

RE: [Phphelpdesk-help] latest release?

[Duke C. <dch...@my...>]

I would be interested in the new code also if possible.

Thank you.

Duke

-----Original Message-----
From: php...@li...
[mailto:php...@li...]On Behalf Of Ray
Miller
Sent: Friday, July 12, 2002 12:55 PM
To: Roy Rapoport; Russ Haskett
Cc: phphelpdesk-list
Subject: RE: [Phphelpdesk-help] latest release?


I would be definitely interested in your additions... I have added
several new tweaks to our site and could figure out how to integrate
your additions with our existing without a lot of work.  Are you giving
out copies of your coding additions?  I'm currently working on adding a
customer database for opening new tickets and updating one place for
contact info... I've got a ways to go though.

Thanx,
Ray


-----Original Message-----
From: Roy Rapoport [mailto:rs...@ae...] 
Sent: Friday, July 12, 2002 10:39 AM
To: Russ Haskett
Cc: phphelpdesk-list
Subject: Re: [Phphelpdesk-help] latest release?

On 12 Jul 2002, Russ Haskett wrote:
> The last release was almost a year ago and I noticed that on one of
the
> projects web pages that it said the software was undergoing major
> revisions. Soooo my question is if I download the package now am I
gonna
> get hit with a major redo in a month or two?
> Should I just wait for the next version?

Judging by the traffic on the phphelpdesk-devel list (i.e. "almost
none"),
I'm guessing you don't want to wait.  I've not heard of any plans to do
a
new version in the very near future.

I've not heard of any updates to the software.  In fact, I'll go
further:
A) CHANGELOG has not been changed between 11/24/2001 and 7/9 (when I
contributed a security patch);
B) cvs log shows no changes between 11/24 and 7/9.

We (my company) have done a lot of work on phphelpdesk, including
functionality to
A) Be able to log events as people who are not the ticket owners without
reassigning the ticket;
B) Be able to modify or delete events;
C) Some new reporting features;
D) Greater compartmentalization between users (we wanted users who are
only
authorized for one company/department, for example, to not see the total
number of tickets in the helpdesk).
E) Invoicing out of the helpdesk (which is what I've done all last
night.
Sleep.  Good.)
F) Automatically add existing manager-level people to new companies when
they (the companies) are created.

At this point, if I'm not lame, I'll start contributing some of these
things to the CVS repository, but I'll need to come up with way to do
this
that don't affect people who like the current functionality.

-roy




-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Gadgets, caffeine, t-shirts, fun stuff.
http://thinkgeek.com/sf
_______________________________________________
Phphelpdesk-help mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Gadgets, caffeine, t-shirts, fun stuff.
http://thinkgeek.com/sf
_______________________________________________
Phphelpdesk-help mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

RE: [Phphelpdesk-help] latest release?

[Ray M. <ra...@st...>]

I would be definitely interested in your additions... I have added
several new tweaks to our site and could figure out how to integrate
your additions with our existing without a lot of work.  Are you giving
out copies of your coding additions?  I'm currently working on adding a
customer database for opening new tickets and updating one place for
contact info... I've got a ways to go though.

Thanx,
Ray


-----Original Message-----
From: Roy Rapoport [mailto:rs...@ae...]=20
Sent: Friday, July 12, 2002 10:39 AM
To: Russ Haskett
Cc: phphelpdesk-list
Subject: Re: [Phphelpdesk-help] latest release?

On 12 Jul 2002, Russ Haskett wrote:
> The last release was almost a year ago and I noticed that on one of
the
> projects web pages that it said the software was undergoing major
> revisions. Soooo my question is if I download the package now am I
gonna
> get hit with a major redo in a month or two?
> Should I just wait for the next version?

Judging by the traffic on the phphelpdesk-devel list (i.e. "almost
none"),
I'm guessing you don't want to wait.  I've not heard of any plans to do
a
new version in the very near future.

I've not heard of any updates to the software.  In fact, I'll go
further:
A) CHANGELOG has not been changed between 11/24/2001 and 7/9 (when I
contributed a security patch);
B) cvs log shows no changes between 11/24 and 7/9.

We (my company) have done a lot of work on phphelpdesk, including
functionality to
A) Be able to log events as people who are not the ticket owners without
reassigning the ticket;
B) Be able to modify or delete events;
C) Some new reporting features;
D) Greater compartmentalization between users (we wanted users who are
only
authorized for one company/department, for example, to not see the total
number of tickets in the helpdesk).
E) Invoicing out of the helpdesk (which is what I've done all last
night.
Sleep.  Good.)
F) Automatically add existing manager-level people to new companies when
they (the companies) are created.

At this point, if I'm not lame, I'll start contributing some of these
things to the CVS repository, but I'll need to come up with way to do
this
that don't affect people who like the current functionality.

-roy




-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Gadgets, caffeine, t-shirts, fun stuff.
http://thinkgeek.com/sf
_______________________________________________
Phphelpdesk-help mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

Re: [Phphelpdesk-help] latest release?

[Roy R. <rs...@ae...>]

On 12 Jul 2002, Russ Haskett wrote:
> The last release was almost a year ago and I noticed that on one of the
> projects web pages that it said the software was undergoing major
> revisions. Soooo my question is if I download the package now am I gonna
> get hit with a major redo in a month or two?
> Should I just wait for the next version?

Judging by the traffic on the phphelpdesk-devel list (i.e. "almost none"),
I'm guessing you don't want to wait.  I've not heard of any plans to do a
new version in the very near future.

I've not heard of any updates to the software.  In fact, I'll go further:
A) CHANGELOG has not been changed between 11/24/2001 and 7/9 (when I
contributed a security patch);
B) cvs log shows no changes between 11/24 and 7/9.

We (my company) have done a lot of work on phphelpdesk, including
functionality to
A) Be able to log events as people who are not the ticket owners without
reassigning the ticket;
B) Be able to modify or delete events;
C) Some new reporting features;
D) Greater compartmentalization between users (we wanted users who are only
authorized for one company/department, for example, to not see the total
number of tickets in the helpdesk).
E) Invoicing out of the helpdesk (which is what I've done all last night.
Sleep.  Good.)
F) Automatically add existing manager-level people to new companies when
they (the companies) are created.

At this point, if I'm not lame, I'll start contributing some of these
things to the CVS repository, but I'll need to come up with way to do this
that don't affect people who like the current functionality.

-roy

[Phphelpdesk-help] latest release?

[Russ H. <web...@ps...>]

I have been meaning to install PhpHelpdesk for some time now but have
been putting it off. I am now ready to install and I have a few
questions:

The last release was almost a year ago and I noticed that on one of the
projects web pages that it said the software was undergoing major
revisions. Soooo my question is if I download the package now am I gonna
get hit with a major redo in a month or two?
Should I just wait for the next version?

Thanks,

[Phphelpdesk-help] Users entering a ticket

[Paul L. W. <pa...@fe...>]

I noticed that when users enter their information on the add job page that
if they do not fill out the short summary category and they click on add
job - it just clears the add job page and DOES not send the ticket.  Has
anybody out there added any error checking for this page or encountered this
issue?  I'm running on Red Hat Linux 7.2, MySQL 3.23, php 4.1.2, phphelpdesk
0.6.16.  Thanks in advance

Paul "Skip" Weintraub
IT Specialist
FEA, Inc.
(510)549-8702 ext. 105
sk...@fe...

[Phphelpdesk-help] Login Problem

[Jeff <te...@gl...>]

New Install=20
Running PHP 4.2.1=20
Apache 1.3.**=20
Any rate i see first page of index.php=20
when i click login i get the url of=20
websiteurl/helpdesk/index.php?login=3Dgoto=20
but the login screen does not appear in the index.php=20
page like it does on the demo version???=20
In other words its refreshing the page back to the same=20
one but not gining me the part to put in username and=20
password.=20

Any Ideas?

[Phphelpdesk-help] RE: Could not add host definition

[Martin M. (THALES) <mm...@fi...>]

Oops!!!

sorry for this cross-posting! I just pasted the wrong email address!!

It won't happen again.
 

[Phphelpdesk-help] Could not add host definition

[Martin M. (THALES) <mm...@fi...>]

Dear all,

I'm struggling to use nmap2netsaint.pl to populate my hosts.cfg file faster
than typing all the hostnames (352) and services one by one.
Unfortunatelly I get the following error message when starting NetSaint:

   'Error in configuration file '/usr/local/netsaint/etc/hosts.cfg'  - Line
31 (Could not add host definition)"

I double-checked the file and everything seems to be OK... although I could
be overseeing something obvious...

Could you please bring up some light before I bang my head against the
wall?? ;-))

Thanks,

Martin

Re: [Phphelpdesk-help] phphelpdesk - HELP!

[Stefan S. <Ste...@st...>]

Check that you have configured php with "register_globals: On" inside
php.ini. Thats most likely your problem...

Regards,
Stefan Skotte



|---------+-------------------------------------------->
|         |           Mik...@va...          |
|         |           Sent by:                         |
|         |           php...@li...ur|
|         |           ceforge.net                      |
|         |                                            |
|         |                                            |
|         |           04-07-2002 17:11                 |
|         |                                            |
|---------+-------------------------------------------->
  >----------------------------------------------------------------------------------------------|
  |                                                                                              |
  |       To:       php...@li...                                       |
  |       cc:                                                                                    |
  |       Subject:  [Phphelpdesk-help] phphelpdesk - HELP!                                       |
  >----------------------------------------------------------------------------------------------|




Hello there and thanks for the great system!

But there is still some b-i-g problems.

This is where i am now:
System: Win98, PHP4, Apache 1.3 and MySQL (stable release)

I have made the default DB with those datas from 'phphelpdesk.mysql'. And I
HAVENT done ANY chances, everything is just like I should be. Everything
seems to be ok, but...

This is where I am now:

The index.php is rocking, but:
"Notice: Undefined variable: partfound in c:\program
files\apache\apache\htdocs\languages\english.lang.php on line 256

Notice: Undefined variable: p_id in c:\program
files\apache\apache\htdocs\languages\english.lang.php on line 258

Notice: Undefined variable: whattodo in c:\program
files\apache\apache\htdocs\config\header.conf.php on line 8"

And probably because these undefined variables, the 'Login', 'Information
Technology', 'Human Resources' & 'Sales' -links doesnt do anything, just
flip back to index.php with no chances.

Ones I test to modify the loginform.conf.php -file,
I deleted these lines (and the }  few lines below)
     <?
     if (isset($login)) {
     ?>
Then I got the login-boxes, but every attemp to log in, flip it back to
index.php with loginboxes.

So, the (isset($login))is false, rite? But why?!




PLEASE help me, tell me what I am doing wrong?

Thanks for the help,

/Mikko Hannula, from Finland



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Caffeinated soap. No kidding.
http://thinkgeek.com/sf
_______________________________________________
Phphelpdesk-help mailing list
Php...@li...
https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

[Phphelpdesk-help] phphelpdesk - HELP!

[<Mik...@va...>]

Hello there and thanks for the great system!

But there is still some b-i-g problems.

This is where i am now:
System: Win98, PHP4, Apache 1.3 and MySQL (stable release)

I have made the default DB with those datas from 'phphelpdesk.mysql'. And I
HAVENT done ANY chances, everything is just like I should be. Everything
seems to be ok, but...

This is where I am now:

The index.php is rocking, but:
"Notice: Undefined variable: partfound in c:\program
files\apache\apache\htdocs\languages\english.lang.php on line 256

Notice: Undefined variable: p_id in c:\program
files\apache\apache\htdocs\languages\english.lang.php on line 258

Notice: Undefined variable: whattodo in c:\program
files\apache\apache\htdocs\config\header.conf.php on line 8"

And probably because these undefined variables, the 'Login', 'Information
Technology', 'Human Resources' & 'Sales' -links doesnt do anything, just
flip back to index.php with no chances.

Ones I test to modify the loginform.conf.php -file,
I deleted these lines (and the }  few lines below)
     <?
     if (isset($login)) {
     ?>
Then I got the login-boxes, but every attemp to log in, flip it back to
index.php with loginboxes.

So, the (isset($login))is false, rite? But why?!




PLEASE help me, tell me what I am doing wrong?

Thanks for the help,

/Mikko Hannula, from Finland

[Phphelpdesk-help] help needed

[<Mik...@va...>]

hello

I should use your forum as a customer req system.

But I can't get it rocking. Its on Win98, Apache 1.3 and php4. And ofcourse
Mysql 1.4.

Is there any help file or similar, I can't understand all this..

or if you can help, let me know, ill write you more then.

Thanks!

/Mikko Hannula

[Phphelpdesk-help] SQL ERROR

[Martin M. (THALES) <mm...@fi...>]

Dear all,

when assigning a user (say "phphelpdeskuser") to a group, I get the
following error message:

	SQL ERROR: You have an error in your SQL syntax near '='phphelpdeskuser''
at line 1

This line appears as many times as groups the user is assigned to.

Any clue?


Thanks,

Martin

Re: [Phphelpdesk-help] Automatic email send with ticket creation

[Mike M. <mm...@ad...>]

Yes Paul there is. This is a simple edit, but it works.
Edit addjob.scp.php.
Find $mailto = "$txtUserEmail";
Change it to $mailto = "$txtUserEmail, pau...@ua...";
You can add as many recipients as you like separated by commas.

I have even modified my scripts so an email is sent to the user when ever an
event is added, that way they are notified whenever I update their ticket.
If you want that ability add the following to vj_addevent.scp.php after the
last occurrence of $mysqlresult = query($query); (It's near the bottom).
Watch for wrapped text below. Each line begins with $mailbody except for the
last two lines. They begin with "mail" and "print". To be safe, make backup
copies of these files before you modify them.

$mailto = "$t_useremail";
$mailsubject = "$g_title - Ticket #$t_id has been updated!";
$mailbody = "$t_userfirstname,\n\n";
$mailbody .= "Your Help Desk request has been updated. Below is a copy of
the updated information.\n\n";
$mailbody .= "Thanks,\n\n";
$mailbody .= "Mike\n";
$mailbody .= "x2323\n\n";
$mailbody .= "ORIGINAL
REQUEST\n-------------------------------------------------------------------
-----\n";
$mailbody .= "Division: $lstDepartment\n";
$mailbody .= "Category: $lstCategory\n";
$mailbody .= "Summary: $txtSummary\n";
$mailbody .= "Detail: $txtDetail\n";
$mailbody .= "Location: $txtLocation\n";
$mailbody .= "\n";
$mailbody .= "UPDATE\n";
$mailbody .=
"------------------------------------------------------------------------\n"
;
$mailbody .= "$txtDescription\n\n Time: $txtDuration hour(s)\n";
$mailbody .=
"------------------------------------------------------------------------\n"
;
$mailheader = "From: mik...@np...";
$mailbody = stripslashes($mailbody);
mail($mailto, $mailsubject, $mailbody, $mailheader);
print "<center>A receipt was sent to $t_userfirstname
$t_userlastname<BR></center>\n";

I've only been using phpHelpDesk for a few weeks and have found it to be an
excellent program. Thank you Joseph Hoot and the other developers for a
great work!

Mike

----- Original Message -----
From: "Paul Greidanus" <pau...@ua...>
To: <php...@so...>
Sent: Friday, June 28, 2002 9:32 AM
Subject: [Phphelpdesk-help] Automatic email send with ticket creation


> Is there a way to have phphelpdesk send emails when a ticket is created?
>
> I don't want to have to be checking the queue all the time to find out
> if there are any new tickets, when email would be much more effective..
>
> Thanks
>
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Caffeinated soap. No kidding.
> http://thinkgeek.com/sf
> _______________________________________________
> Phphelpdesk-help mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phphelpdesk-help

[Phphelpdesk-help] Automatic email send with ticket creation

[Paul G. <pau...@ua...>]

Is there a way to have phphelpdesk send emails when a ticket is created?

I don't want to have to be checking the queue all the time to find out 
if there are any new tickets, when email would be much more effective..

Thanks

[Phphelpdesk-help] ** Outdoor Wireless Router **

[Wireless T. <mai...@wi...>]

<html>
<head>
<meta name="generator" content="HTML Tidy, see www.w3.org">
<title>Wireless Team: Outdoor Wireless Equipment</title>
<meta name="description" content=
"Wireless Team is specialized in producing wireless network equipment.
Find out more information about our award winning products at
www.wirelessteam.net">
<meta name="keywords" content=
"wireless, outdoor, router, equipment, power injector, technical, support,
ethernet, fast, network, hubs, switches, adapters, NIC, servers">
<meta http-equiv="Content-Type" content=
"text/html; charset=iso-8859-1">
<link href="http://www.wirelessteam.net/stylesheet.css" rel=
"stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0"
marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="1" cellpadding="0"
bgcolor="#FFFFFF" align="center">
<tr>
<td colspan="2">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td background="http://www.wirelessteam.net/images/bkgrnd.gif"><img
src="http://www.wirelessteam.net/images/shim.gif" width="100"
height="20"> </td>
<td align="right" width="300"><img src=
"http://www.wirelessteam.net/images/logo.gif" width="300" height=
"43" border="0"></td>
</tr>
</table>
</td>
</tr>

<tr>
<td colspan="2">
<table border="0" cellpadding="1" cellspacing="0" width="100%"
background="http://www.wirelessteam.net/images/bkgrnd_nav.gif"
height="30">
<tr>
<td align="right" valign="middle">
<table border="0" cellspacing="0" cellpadding="0">
<tr valign="bottom">
<td><a href="http://www.wirelessteam.net/index.html"><img src=
"http://www.wirelessteam.net/images/home.gif" width="90" height=
"14" border="0"></a></td>
<td><a href="http://www.wirelessteam.net/aboutus.html"><img src=
"http://www.wirelessteam.net/images/aboutus.gif" width="100"
height="14" border="0"></a></td>
<td><a href="http://www.wirelessteam.net/contactus.html"><img src=
"http://www.wirelessteam.net/images/contactus.gif" width="110"
height="14" border="0"></a></td>
<td><a href="http://www.wirelessteam.net/faq.html"><img src=
"http://www.wirelessteam.net/images/faq.gif" width="100" height=
"14" border="0"></a></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>

<tr>
<td colspan="2">
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2"></td>
</tr>

<tr>
<td bgcolor="#F5F5F5" valign="top">&nbsp;</td>
<td align="center">
<table width="100%" border="0">
<tr>
<td>
<ul>
<li><font color="#990000"><b>Low Cost One Stop
Solution</b></font></li>

<li><font color="#990000"><b>True Easy To Use
Device.</b></font></li>

<li><font color="#990000"><b>Superior Range And
Throughput</b></font></li>

<li><font color="#990000"><b>Built-In Antenna</b></font></li>

<li><font color="#990000"><b>No Additional Equipment
Needed</b></font></li>

<li><font color="#990000"><b>Multiple Configuration
Tools</b></font></li>

<li><font color="#990000"><b>Based On Linux
Firmware</b></font></li>

<li><font color="#990000"><b>Full Network Address Translation
(NAT).</b></font></li>

<li><font color="#990000"><b>Bandwidth Shaping Support
Included.</b></font></li>

<li><font color="#990000"><b>Linux Shell For Custom
Configurations</b></font></li>
</ul>
</td>
<td colspan="2"><img src=
"http://www.wirelessteam.net/images/img-new.jpg" width="500"
height="300"></td>
</tr>

<tr>
<td>&nbsp;</td>
<td><img src="http://www.wirelessteam.net/images/price.gif" width=
"150" height="23"></td>
<td><a href="http://www.wirelessteam.net/orders.html">
<img src="http://www.wirelessteam.net/images/ordernow.gif"
width="150" height="23"></a></td>
</tr>
</table>
</td>
</tr>

<tr>
<td bgcolor="#f5f5f5">&nbsp;</td>
<td align="left" valign="top">
<table width="99%" border="0" cellspacing="5" cellpadding="5"
align="right">
<tr>
<td colspan="2">
<p><b>The Outdoor Wireless Router</b> is a flexible network
solution designed to provide a new high-speed alternative for
delivering broadband connections. The Wireless Router helps to
bypass telecommunications charges for expensive local loops and
costly equipment usually needed to establish a T1 (1.5 Mbps) or
faster connections. The Wireless Router helps you take advantage of
the rapidly changing Internet, and to enhance your company's
productivity at a very reasonable price.</p>

<p><b>The Outdoor Wireless Router</b> is totally adapted for
outdoor mounting and the base system includes integrated antenna.
It is equipped with power injector as well. Thus prevents you from
having problems with power supplies at open areas and gives you the
possibility to have the device at a distance of 100-140 m from your
switch or hub.</p>

<p><b>With a full 100mW of transmit power</b> and the best receive
sensitivity in the industry it has the longest range and best
reliability available for wireless clients. Advanced signal
processing helps manage the multi-path propagation often found in
office environments. Intelligent filtering addresses ambient noise
and interference that can decrease network performance. Building
upon Cisco leadership in wireless LAN (WLAN) performance, it
provides the greatest throughput available so users can enjoy
virtually the same connectivity they gain from wired connections.
Based on direct sequence spread spectrum (DSSS) technology and
operating in the 2.4-GHz band, the device complies with the IEEE
802.11b standard-ensuring interoperability with all other compliant
WLAN products.</p>

<p><br>
</p>
</td>
</tr>

<tr>
<td colspan="2">&nbsp;</td>
</tr>
</table>
</td>
</tr>

<tr>
<td bgcolor="#f5f5f5" rowspan="3">&nbsp;</td>
<td align="left" valign="top">&nbsp;</td>
</tr>

<tr>
<td align="left" valign="top">
<table width="100%" border="0">
<tr>
<td align="left" valign="top">
<table width="99%" border="0" cellspacing="5" cellpadding="5"
align="right">
<tr>
<td bordercolor="#CCCC99" valign="top"><font class=
"bottomtxt">This mailing is done only to people who have requested
info from one of our sites, or downloaded our Software. If you have
recieved this email in error and you wish to be removed from future
mailings, please reply with the subject "<b>Remove</b>" and our
software will automatically block you from their future
mailings.<br>
<br>
</font> </td>
</tr>
</table>
</td>
</tr>

<tr>
<td>&nbsp;</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>