Re: [PHP] Help Desk software
Daniel Lahey said the following on 12/20/2005 10:28 PM: Can anyone recommend some good Open-Source Help Desk software for PHP? (I know this is a little off-topic, but I'm having a hard time finding decent Open Source software.) IMHO the best is RT, which is Perl and Mason. (http://www.bestpractical.com/rt) There are some nice PHP ones out there, but I don't have any experience with them: ruQueue: http://freshmeat.net/projects/ruqueue/ Hesk: http://www.phpjunkyard.com/free-helpdesk-software.php Help Desk Software: http://www.helpdeskreloaded.com/ I'm sure there are more.. Best, --Glenn -- AIM: RainbearNJ YahooIM: rainbear_nj They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. ~Benjamin Franklin, Historical Review of Pennsylvania, 1759 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Using localhost is taking me to localhost.com!!! why?
Hey Wm, Nothing prevents you from running a webserver on your local host (unless of course you're on a corporate network where it's generally pooh-poohed by the AoH (Admins on High). Lots of developers run local webservers to check their work. And, since localhost refers to 127.0.0.1 or the local loopback address, http://localhost is a perfectly valid URL if one is running a webserver and trying to connect to that webserver from the same machine it's running on. :) Glenn On 10:52 AM 8/28/2002 -0700, Wm wrote: shouldn't that just be /localhost/ rather than http://? Seems like the http://; part would be telling it to look for an actual website, which would default to a .com address... --- Glenn E. Sieb System Administrator Lumeta Corporation +1 732 357-3514 (V) +1 732 564-0731 (Fax) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP and Windows Active Directory...
I know that *ahem* theoretically Active Directory uses LDAP... has anyone had any luck getting PHP to talk to Active Directory? Basically I'd like to fool around with a webpage for a corporate directory based on AD entries... if anyone has had any luck with this, I'd appreciate it :))) As always, Thanks! Glenn --- Glenn E. Sieb System Administrator Lumeta Corporation +1 732 357-3514 (V) +1 732 564-0731 (Fax) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Win PHP Editor...
My favorite win-editor is UltraEdit (http://www.idmcomp.com) Also does nice color-tagging, and is very user-customizable that way! Glenn At 03:02 PM 8/10/2002 -0400, Randy Johnson posted the following... I noticed they have not come out with a new version in quite a long time and do not answer their emails? anybody else heard about any future releases of editplus? --- The original portions of this message are the copyright of the author (c)1998-2002 Glenn E. Sieb.ICQ UIN: 300395IRC Nick: Rainbear All acts of Love and Pleasure are Her rituals-Charge of the Goddess -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] decrypting values in MYSQL
At 09:44 AM 8/2/2002 +0800, Michael P. Carel posted the following... so you mean there's no way to decrypt that. I wan't to create a Password Reminder to my script, that would email them their password if ever they forgot it. Is there any suggestion/comments? You can, instead, have it email to the address-of-record a new password, generated randomly. Check out http://www.dacode.org -- it's how it handles forgotten passwords. :) Glenn --- The original portions of this message are the copyright of the author (c)1998-2002 Glenn E. Sieb.ICQ UIN: 300395IRC Nick: Rainbear All acts of Love and Pleasure are Her rituals-Charge of the Goddess -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] CMS systems using PHP and PostgreSQL?
Does anyone know of a good CMS using both PHP and PostgreSQL? I see a lot of CMS' out there like pHpSlash, but I'd like to find one that works with PostgreSQL if possible.. :) (I use PostgreSQL for a few other things, and would much rather not have to load MySQL on the server as well) Thanks in advance, as always! Glenn --- The original portions of this message are the copyright of the author (c)1998-2002 Glenn E. Sieb.ICQ UIN: 300395IRC Nick: Rainbear All acts of Love and Pleasure are Her rituals-Charge of the Goddess -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] (OT) No Punishment for Erik Hegreberg, Yet...
Personally I think they're copping out. How many of us forwarded EVERY piece of his crap to them? There's an old (ok not so old) saying: Eat rice. A couple billion Chinese people can't be wrong. Why these admins can't catch a clue and, by the sheer volume of the emails, do something about this ass, boggles my mind. Glenn (who got a similar reply from the idiots) On 08:17 AM 7/11/2002 -0800, Jason Soza wrote: In any case, here's the response from [EMAIL PROTECTED] (apparently the same as [EMAIL PROTECTED]): --- Glenn E. Sieb System Administrator Lumeta Corporation +1 732 357-3514 (V) +1 732 564-0731 (Fax) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Survey: MySQL vs PostgreSQL for PHP
Has anyone read: PHP and PostgreSQL Advanced Web Programming by Ewald Geschwinde and Hans-Juergen Schoenig yet? I'd been waiting for this book to come out... but would like to know if it's actually worth the $ first. Back to the question at hand... Personally I like PostgreSQL for a few reasons: Scalability Ease of use SECURITY (yeah--well what can I say.. I work for a security company LOL--but seriously, Postgres has more security that MySQL does... and more flexible...) Variety of data types (for instance a CIDR block and IP data type...) Stored procedures Cleanup built in (vacuum) Unions Full Joins Constraints But that's just me. :) Glenn --- Glenn E. Sieb System Administrator Lumeta Corporation +1 732 357-3514 (V) +1 732 564-0731 (Fax) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] majordomo in php?
That's what majordomo and the others do. People send messages to [EMAIL PROTECTED] that have commands like subscribe, unsubscribe, digest, etc. Glenn On 10:39 AM 6/7/2002 -0500, The Gabster wrote: thanks Dave, that makes sense... i was just thinking of a mailing list totally controled through email... Like people if they want to subscribe, they send an email with subscribe in the subject, etc... gabi. --- Glenn E. Sieb See us at NetSec! June 18-19 System AdministratorHyatt Embarcadero, San Francisco Lumeta Corporation http://www.lumeta.com/Events/events.html +1 732 357-3514 (V) +1 732 564-0731 (Fax) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] disabled cookies and sessions
On 06:33 PM 6/7/2002 +0200, Nick Wilson wrote: I have compiled php with --enable-trans-sid but when I diable cookies on my brower (Mozilla 1) the obeject I'm trying to pass (eg: its properties) are not bein passed. I've used sessions a lot so I'm sure it's not my php at fault but something is eluding me? Any help much appreciated. Sessions are cookies. Glenn --- Glenn E. Sieb See us at NetSec! June 18-19 System AdministratorHyatt Embarcadero, San Francisco Lumeta Corporation http://www.lumeta.com/Events/events.html +1 732 357-3514 (V) +1 732 564-0731 (Fax) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Sessions
At 08:32 AM 6/3/2002 +1000, Justin French posted the following... sitepoint.com has a nice one on restricting pages with login/sessions, etc by Kevin Yank. http://www.WebmasterBase.com/article/319 Is that the one you're referring to, Justin? It seems pretty good.. :) Glenn --- The original portions of this message are the copyright of the author (c)1998-2002 Glenn E. Sieb.ICQ UIN: 300395IRC Nick: Rainbear All acts of Love and Pleasure are Her rituals-Charge of the Goddess -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: PHP+MySQL - Excel ?
At 02:13 PM 5/17/2002 -0300, Manuel Lemos posted the following... Hello, On 05/17/2002 01:18 PM, Evan wrote: Is it possible to create an excel file with some data from mySQL, using PHP ? Sure, you can use this class to generate Excel files on fly on even in non-Windows platforms. Heck, outputting a tab-delimited file with a mime type of application/msexcel works too.. :) Glenn --- The original portions of this message are the copyright of the author (c)1998-2002 Glenn E. Sieb.ICQ UIN: 300395IRC Nick: Rainbear All acts of Love and Pleasure are Her rituals-Charge of the Goddess -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] I just wanted to thank everyone.. :) (Kinda long...)
Hey everyone! After some futzing about, and using techniques you guys all helped out with, I now have a nice, portable, fully-commented-for-future-maintenance script for doing *all* of my SQL queries to our MSSQL server, and outputting a nice, easy-to-read table. I only have to change one comment at the beginning, then the variables at the top of the script. Quite a bit easier to maintain that my old script (which most of you saw some of the other day). The script has been Sanitized, Homogenized, as well as Pasteurized and Anonymized For Your Protection (feel free to break the paper seal...) as well as mine. :))) Now my next trick is to have the same query output to a downloaded-to-the-client-PC CSV file, but I just need to read more on that.. I have the CSV output, just have to tuck it into a plain/text CSV stream.. it will be fun to figure out!!! : As I said to one of my coworkers last night when I got this done, There is now much joy in Lumetaville... :) hehe In gratitude to the community who helped me build it, here's my script, which was originally snagged from a php-coding website that I visited somewhere in my travels, and unfortunately forgot which one. The script kept the SelectQuery function name and parameters from the original script. Since then, it has been mangled and coded and recoded and such by myself, with the help of the people here and at my office. The script now: 1) Automagically figures out how many fields are in the query, 2) Feeds the header information from those fields into the table, 3) Checks to see if any data cells are blank, and if so, throws in a nbsp;, 4) Alternates the colors by company name. 5) Produces pretty HTML source. The whole thing is orders of magnitude more efficient than the original script was, and orders of magnitude easier for me to use to create new pages with! In addition, if you have certain variables set, it will: 1) Only print each company name once, 2) Format any Price fields as being in dollars as well as right-aligned, 3) Gives you a link to a similarly-named page that will have a CSV-formatted file (this is coming soon.. not done yet! hehe) downloaded to your PC with the data from the table. I hope people find this useful. It's a good way of being able to query a DB and just dump the data into a table. I've learned a lot in this exercise, not the least of which was the fact that associative arrays are handled differently than regular arrays (and here I thought the mssql_fetch_assoc just didn't work LOL...), as well as when it's more right to use if clauses instead of ternary operators, for the sake of ease of reading. Feel free to use, abuse, gut, trash it, whatever you'd like :) Again, thanks, everyone :) Sincerely, Glenn (note... breaking the php tag so it'll show... instead of executing (I hope)) ? php /* * This script performs a query on the MS SQL Server, against a database. * * This will show us put what this script is showing us here! * * Version 1.12 5/11/02 * ges with the help of ryan/hburch/bunches of people on php-general! * * Here we set up variables that change for the page * * Query Parms: * $fields - comma separated list of field names or *. * $tables - comma separated list of table names. * $where - SQL Where clause (e.g. id=2). * $groupBy - SQL Group clause (e.g. name). * $orderBy - SQL Order clause (e.g. name). * $show_debug - If true then print SQL query. * $filter_company - If true, then only shows the first instance of a company's name * $filter_dollars - If true, then formats any price colums to be $'s and such. * * Page Parms: * $title - What the name of this page is. Echoed in title and h3 below. * $subtitle - Further information regarding the page. Echoed in h3 below. * $csv_page - If true, prints the line that offers the user a CSV version of the page. * $page_name - Set to the filename of this page, minus the .php * Returns: * 2d array of rows and columns on success. * Error String on failure. */ $fields = Enter the fields to query ; $tables = From which tables ; $where = conditions on match ; $groupBy = grouping by ; $orderBy = sorting by ; $show_debug = False; # True or False $filter_company = False; # True or False $filter_dollars = False; # True or False /* * Page Parms */ $title = Title of page here; $subtitle =Subtitle of page here; $csv_page = True; # True or False $page_name = pre-extension portion of the name of the php file here; # example Testing instead of Testing.php /* * Here we set up the page... */ print HTML\n\n. HEAD\n\n. TITLE$title/TITLE\n\n. /HEAD\n\n.
[PHP] Serialize/URLencode query...
I'd like to pass a bunch of variables to another PHP page for processing there... I think serialize() and urlencode() will do what I'm looking for.. can I pass multiple strings through this? I'm also not clear on how I can decode the separate strings out... Can someone point me in the right direction? Thanks, everyone! Glenn --- The original portions of this message are the copyright of the author (c)1998-2002 Glenn E. Sieb.ICQ UIN: 300395IRC Nick: Rainbear All acts of Love and Pleasure are Her rituals-Charge of the Goddess -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Serialize/URLencode query...
At 12:11 AM 5/12/2002 -0700, John Holmes posted the following... You should use sessions. All you have to do is call session_start() at the beginning of your code. Then, any variable you want to save to the session, you simply use: That did the trick! Thanks for the explanation, John! Now I have a nifty script that reads the variables from my MSSQL query script, and creates a MS Excel file using the data without having to have a separate Excel-creating script for every page... :) This rocks! Thanks again, John! Glenn (I could post the code from that script, as well, if people would like to see it..?) --- The original portions of this message are the copyright of the author (c)1998-2002 Glenn E. Sieb.ICQ UIN: 300395IRC Nick: Rainbear All acts of Love and Pleasure are Her rituals-Charge of the Goddess -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Alternating table rows...
Hi everyone,
I have a PHP script that reads data from an MS SQL server and outputs the
data into a table. I've been asked if I can alternate the colors of the
rows to make the report more legible. The relevant piece of code looks like:
for ($i = 0; $i mssql_num_rows( $stmt ); ++$i)
{
$line = mssql_fetch_row($stmt);
print (TRFONT
COLOR=#$colorTD$line[2]/TDTD$line[0]/TDTD$line[3]/TD/TR);
}
Is there a way for me to do one of the following:
1) Test to see if $i is an even or odd number?
2) Grab more than one line from the database at a time, and just put in two
table rows at once?
Thanks for your help in advance!
Glenn
---
Glenn E. Sieb, System Administrator
Lumeta Corp. mailto:[EMAIL PROTECTED]
+1 732 357-3514 (V)
+1 732 564-0731 (Fax)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Alternating table rows...
Austin, you rock :) I've only just started with PHP recently, and was introduced to the ternary operators by reading Rasmus' book (great job, Rasmus!!!), so I'm learning as I go here :) Thanks buddy! Glenn On 01:50 PM 5/10/2002 -0500, Austin Marshall wrote: $color=($i%2) ? grey : white; will let you change the background color depending on whether or not $i is even or odd. --- Glenn E. Sieb, System Administrator Lumeta Corp. mailto:[EMAIL PROTECTED] +1 732 357-3514 (V) +1 732 564-0731 (Fax) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Alternating table rows...
On 02:47 AM 5/11/2002 +0800, Jason Wong wrote:
if ($i % 2) { odd; } else { even; }
Great! Thanks, Jason :)))
One thing I love about this list... you guys are more than helpful! :)
Glenn
---
Glenn E. Sieb, System Administrator
Lumeta Corp. mailto:[EMAIL PROTECTED]
+1 732 357-3514 (V)
+1 732 564-0731 (Fax)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Alternating Table Rows, Part Deux..
Hey everyone!
Thanks for all the hints--here's what my boss and I eventually came out with:
/* ##
## And for every row of data we pull, we create a table row...
## */
$company = 0;
$previous = ;
for ($i = 0; $i mssql_num_rows( $stmt ); ++$i)
{
$line = mssql_fetch_row($stmt);
$company +=
(strcmp($previous,$line[0]) ? 1 : 0);
$color = (($company%2) ? FF :
00);
$cname = (strcmp($previous,$line[0])
? $line[0] : nbsp;);
print (TR
BGCOLOR=#$color\n\tTD$line[2]/TD\n\tTD$cname/TD\n\tTD$line[3]/TD\n/TR\n);
$previous = $line[0];
}
print (/TABLE);
This not only takes care of the table row colors, but also removes
duplicate company names so it looks MUCH neater this way :
Thanks again!
Glenn
(who's still trying to get it all down lol.. between trying to learn SQL,
MySQL,PHP, PostgreSQL, and VBScript lately, I'm surprised I haven't had my
head explode yet!)
---
Glenn E. Sieb, System Administrator
Lumeta Corp. mailto:[EMAIL PROTECTED]
+1 732 357-3514 (V)
+1 732 564-0731 (Fax)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Getting PHP on FreeBSD to talk to MSSQL Server 7...
Hi.. it's me again :) We have a few different servers here, most of which are FreeBSD, including our internal web server (Apache 1.3.24). We have PHP 4.2.0 installed as well. Currently I'm running my MSSQL query scripts on a Win2k webserver, as I can't seem to get PHP to talk to MSSQL on the FreeBSD side. I'd really prefer to have my PHP scripts all running on the FreeBSD side, rather than on Win2k. We do have Perl able to talk to the MSSQL server using FreeTDS and the DBI::Sybase package on the same FreeBSD machine. My ./configure: ./configure --prefix=/usr/local --with-apache=/home/src/Apache/Apachetoolbox -1.5.56/apache_1.3.24 --enable-exif --enable-track-vars --with-calendar=shared - -enable-safe-mode --enable-magic-quotes --enable-trans-sid --enable-wddx --enabl e-ftp --with-gd=/usr/local --with-zlib --enable-gd-native-tt --with-t1lib=/usr/l ocal --with-jpeg-dir=/usr/local --with-png-dir=/usr/local --with-zlib-dir=/usr - -with-ttf --with-freetype-dir=/usr/local --with-unixodbc=/usr/local/unixODBC --w ith-openssl=/usr/local --with-curl=/usr/local --enable-apc --with-mysql=/sw/mysq l --with-mssql=/usr/local/etc/freetds --with-sybase=/usr/local/etc/freetds (built using ApacheToolbox, 1.5.56) FreeTDS' interfaces file is located in /usr/local/etc/freetds, which it is/was my understanding that this is what's supposed to be there. Yet not only does PHP give me: Fatal error: Call to undefined function: mssql_connect() in /usr/home/inweb/inside.lumeta.com/htdocs/TaskInfoCompletedProj1.php on line 82 (and yes, if I put the sybase_connect() in I get the same error only it says sybase*) What am I missing here? Is there another package I need that I neglected to install? Am I just not configured properly? *sigh* Debugging this stuff is always fun :) Thanks in advance.. hope I'm not bein a PITA :) Glenn --- Glenn E. Sieb, System Administrator Lumeta Corp. mailto:[EMAIL PROTECTED] +1 732 357-3514 (V) +1 732 564-0731 (Fax) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Alternating Table Rows, Part Deux..
On 04:58 PM 5/10/2002 -0500, Miguel Cruz wrote: But he's dealing with cases where the company name remains the same but other data in the row changes (for instance, a company with multiple offices, where you wanted to list the phone number and address for each). GROUP BY would discard that other data. *nod* We're just doing this for ease-of-reading. Right now it'd look something along these lines: Marvin BlahBlah, Inc. 5/10/02 Notes on meeting Davis 5/10/02 More Notes on meeting etc. Glenn --- Glenn E. Sieb, System Administrator Lumeta Corp. mailto:[EMAIL PROTECTED] +1 732 357-3514 (V) +1 732 564-0731 (Fax) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Alternating Table Rows, Part Deux..
Thanks! I'll play with this!!! :) Glenn On 05:11 PM 5/10/2002 -0500, Shaun Thomas wrote: This could use a few tweaks. First off, putting mysql_num_rows in the actual for loop executes it every iteration. Bad. Second, consider giving your code some readability by returning an associative array. You also duplicate your if statements for company name. You can also rotate your column in the same IF statement to rotate the color. Try this (I'll assume column names...): --- Glenn E. Sieb, System Administrator Lumeta Corp. mailto:[EMAIL PROTECTED] +1 732 357-3514 (V) +1 732 564-0731 (Fax) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Alternating Table Rows, Part Deux..
On 05:11 PM 5/10/2002 -0500, Shaun Thomas wrote:
This could use a few tweaks.
Ok I got it now... This exhibits the behaviour I was looking for, and,
thanks to you, is much easier to read and maintain! :)))
Thanks, Shaun!
Glenn
$sPrevCompany = $sColor = '';
while ($aRow = mssql_fetch_row($stmt))
{
$sCompanyName = $aRow[$companyname];
/* If our previous company name is the same as this one, don't print
the company name, but print the data. */
if ($sPrevCompany !== $sCompanyName)
{
$sColor = ($sColor == 'FF') ? '00' : 'FF';
$sPrevCompany = $sCompanyName;
} else {
$sCompanyName = 'nbsp;';
}
/* We're past our if statement, so save the previous company for
next time. */
print (
TR BGCOLOR=#$sColor\n.
\tTD$aRow[0]/TD\n.
\tTD$aRow[1]/TD\n.
\tTD$sCompanyName/TD\n.
\tTD$aRow[2]/TD\n.
\tTD$aRow[4]/TD\n.
\tTD$aRow[5]/TD\n.
\tTD$aRow[6]/TD\n.
\tTD$aRow[7]/TD\n.
/TR\n);
}
print (/TABLE);
---
Glenn E. Sieb, System Administrator
Lumeta Corp. mailto:[EMAIL PROTECTED]
+1 732 357-3514 (V)
+1 732 564-0731 (Fax)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
