Note: this list is kept only as a demonstration for CVSNotice. For the latest CVS notices, see the Xaraya and Postnuke sites
View Statistics - Next Notice - Previous NoticeDirectory filter : [ all ] / postnuke_modules / PostContact / user_functions [ view in CVS ]
| Date | Directory [filter] | File(s) [view] | Author [filter] |
| 06 Aug 2002 20:17:00 | postnuke_modules/PostContact/user_functions | sendmail.php,1.2,1.3 vicitcard.php,1.2,1.3 | Richard Cave |
| ADODB conversion. | |||
Update of /home/cvsroot/postnuke_modules/PostContact/user_functions
In directory ns7.hostnuke.net:/tmp/cvs-serv17969/PostContact/user_functions
Modified Files:
sendmail.php vicitcard.php
Log Message:
ADODB conversion.
Index: sendmail.php
===================================================================
RCS file: /home/cvsroot/postnuke_modules/PostContact/user_functions/sendmail.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** sendmail.php 23 Jul 2002 12:07:04 -0000 1.2
--- sendmail.php 6 Aug 2002 20:16:57 -0000 1.3
***************
*** 1,21 ****
<?
// $Id$ $Name$
if(basename($PHP_SELF) == basename(__FILE__)){
! echo "You have no access to this file!!!";
! exit;
}
function writeToErrorLogg($message){
! $export_folder = "./errors";
! if(file_exists($export_folder)){
! if(is_writable($export_folder)){
! $dagens_datum = date("Y-m-d");
! $filnamn = "ErrorLog_".$dagens_datum;
! $filnamn = $export_folder."/".$filnamn.".tab";
! $filen = fopen($filnamn, "a+");
! $filskriv = fwrite($filen, $export);
! $filstangd = fclose($filen);
! }
! }
}
--- 1,45 ----
<?
// $Id$ $Name$
+ // ----------------------------------------------------------------------
+ // POST-NUKE Content Management System
+ // Copyright (C) 2002 by the PostNuke Development Team.
+ // http://www.postnuke.com/
+ // ----------------------------------------------------------------------
+ // LICENSE
+ //
+ // This program is free software; you can redistribute it and/or
+ // modify it under the terms of the GNU General Public License (GPL)
+ // as published by the Free Software Foundation; either version 2
+ // of the License, or (at your option) any later version.
+ //
+ // This program is distributed in the hope that it will be useful,
+ // but WIthOUT ANY WARRANTY; without even the implied warranty of
+ // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ // GNU General Public License for more details.
+ //
+ // To read the license please visit http://www.gnu.org/copyleft/gpl.html
+ // ----------------------------------------------------------------------
+ // Original Author of file: Bjarne Var�ystrand and Bjarne Var�ystrand
+ // Modifications by: Richard Cave
+ // Purpose of file: Send mail to company or contact person
+ // ----------------------------------------------------------------------
+
if(basename($PHP_SELF) == basename(__FILE__)){
! echo "You have no access to this file!!!";
! exit;
}
function writeToErrorLogg($message){
! $export_folder = "./errors";
! if(file_exists($export_folder)){
! if(is_writable($export_folder)){
! $dagens_datum = date("Y-m-d");
! $filnamn = "ErrorLog_".$dagens_datum;
! $filnamn = $export_folder."/".$filnamn.".tab";
! $filen = fopen($filnamn, "a+");
! $filskriv = fwrite($filen, $export);
! $filstangd = fclose($filen);
! }
! }
}
***************
*** 23,41 ****
$department = $GLOBALS['departmentID'];
! $name = $GLOBALS['sender_name'];
! $phone = $GLOBALS['sender_phone'];
! $email = $GLOBALS['sender_email'];
! $copy = $GLOBALS['sender_wantcopy'];
! $message = htmlspecialchars($GLOBALS['sender_message']);
! $contact = $GLOBALS['sender_wants_contact'];
! $to = $department['email'];
! $department = $department['name'];
if($contact == 1){
! $contact = ""._CIIWANTYOUTOCONTACTME."";
}
echo " <br /><table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td><p class=\"ContactInfoHeader\">"._CITHANKYOUFORYOURMAIL." ".$name."!<br>";
echo ""._CIWEWILLREPLYSOON."<br>";
if($copy){
! echo "("._CACOPYHASBEENSENTTOYOURMAIL_.")<br><br>";
}
echo _CIENJOYTHERESTOFTHESITE."</p>";
--- 47,65 ----
$department = $GLOBALS['departmentID'];
! $name = $GLOBALS['sender_name'];
! $phone = $GLOBALS['sender_phone'];
! $email = $GLOBALS['sender_email'];
! $copy = $GLOBALS['sender_wantcopy'];
! $message = htmlspecialchars($GLOBALS['sender_message']);
! $contact = $GLOBALS['sender_wants_contact'];
! $to = $department['email'];
! $department = $department['name'];
if($contact == 1){
! $contact = ""._CIIWANTYOUTOCONTACTME."";
}
echo " <br /><table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td><p class=\"ContactInfoHeader\">"._CITHANKYOUFORYOURMAIL." ".$name."!<br>";
echo ""._CIWEWILLREPLYSOON."<br>";
if($copy){
! echo "("._CACOPYHASBEENSENTTOYOURMAIL_.")<br><br>";
}
echo _CIENJOYTHERESTOFTHESITE."</p>";
***************
*** 48,106 ****
function print_FormParts($preview_data){
echo $preview_data." <br /><table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIYOUR." "._CINAME.": </font></td>
! <td><input name=\"sender_name\" value=\"".$GLOBALS['sender_name']."\" type=\"text\" class=\"ContactInfoText\" /></td>
! </tr>
!
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIYOUR." "._CIPHONE.": </font></td>
! <td><input name=\"sender_phone\" value=\"".$GLOBALS['sender_phone']."\" type=\"text\" class=\"ContactInfoText\" /></td>
! </tr>
!
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIYOUR." "._CIEMAIL.": </font></td>
! <td><input name=\"sender_email\" value=\"".$GLOBALS['sender_email']."\" type=\"text\" class=\"ContactInfoText\" /></td>
! </tr>
!
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIYOUR." "._CIMESSAGE.": </font></td>
! <td><textarea name=\"sender_message\" wrap=\"virtual\" rows=\"8\" class=\"ContactInfoText\">".$GLOBALS['sender_message']."</textarea></td>
! </tr>
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CISENDMEACOPY.": </font></td>
! <td><input type=\"checkbox\" name=\"sender_wantcopy\"";
! if($GLOBALS['sender_wantcopy'] == 1){
! echo " checked=\"checked\"";
! }
! echo "\" value=\"1\" /></td>
! </tr>
!
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIPLEASECONTACTME.": </font></td>
! <td><input type=\"checkbox\" name=\"sender_wants_contact\"";
! if($GLOBALS['sender_wants_contact'] == 1){
! echo " checked=\"checked\"";
! }
! echo "\" value=\"1\" /></td>
! </tr>
!
! <tr>
! <td> </td>
! <td>
! <table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">
! <tr>
! <td align=\"right\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIPREVIEW." </font></td>
! <td><input type=\"radio\" name=\"preview\" value=\"1\" checked=\"checked\" /></td>
! </tr><tr>
! <td align=\"right\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CISEND." </font></td>
! <td><input type=\"radio\" name=\"preview\" value=\"2\" /></td>
! </tr>
! </table>
! </td>
! </tr><tr>
! <td> </td>
! <td><input name=\"Reset\" type=\"reset\" class=\"ContactInfoText\" value=\""._CIRESET."\" /><input name=\"Submit\" type=\"submit\" class=\"ContactInfoText\" value=\""._CISUBMIT."\" /></td>
! </tr>
! </table>";
}
--- 72,130 ----
function print_FormParts($preview_data){
echo $preview_data." <br /><table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIYOUR." "._CINAME.": </font></td>
! <td><input name=\"sender_name\" value=\"".$GLOBALS['sender_name']."\" type=\"text\" class=\"ContactInfoText\" /></td>
! </tr>
!
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIYOUR." "._CIPHONE.": </font></td>
! <td><input name=\"sender_phone\" value=\"".$GLOBALS['sender_phone']."\" type=\"text\" class=\"ContactInfoText\" /></td>
! </tr>
!
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIYOUR." "._CIEMAIL.": </font></td>
! <td><input name=\"sender_email\" value=\"".$GLOBALS['sender_email']."\" type=\"text\" class=\"ContactInfoText\" /></td>
! </tr>
!
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIYOUR." "._CIMESSAGE.": </font></td>
! <td><textarea name=\"sender_message\" wrap=\"virtual\" rows=\"8\" class=\"ContactInfoText\">".$GLOBALS['sender_message']."</textarea></td>
! </tr>
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CISENDMEACOPY.": </font></td>
! <td><input type=\"checkbox\" name=\"sender_wantcopy\"";
! if($GLOBALS['sender_wantcopy'] == 1){
! echo " checked=\"checked\"";
! }
! echo "\" value=\"1\" /></td>
! </tr>
!
! <tr>
! <td align=\"right\" valign=\"top\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIPLEASECONTACTME.": </font></td>
! <td><input type=\"checkbox\" name=\"sender_wants_contact\"";
! if($GLOBALS['sender_wants_contact'] == 1){
! echo " checked=\"checked\"";
! }
! echo "\" value=\"1\" /></td>
! </tr>
!
! <tr>
! <td> </td>
! <td>
! <table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">
! <tr>
! <td align=\"right\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CIPREVIEW." </font></td>
! <td><input type=\"radio\" name=\"preview\" value=\"1\" checked=\"checked\" /></td>
! </tr><tr>
! <td align=\"right\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">"._CISEND." </font></td>
! <td><input type=\"radio\" name=\"preview\" value=\"2\" /></td>
! </tr>
! </table>
! </td>
! </tr><tr>
! <td> </td>
! <td><input name=\"Reset\" type=\"reset\" class=\"ContactInfoText\" value=\""._CIRESET."\" /><input name=\"Submit\" type=\"submit\" class=\"ContactInfoText\" value=\""._CISUBMIT."\" /></td>
! </tr>
! </table>";
}
***************
*** 110,307 ****
function theindex($personID,$department,$company) {
! global $ModName,$prefix,$sitename,$SERVER_NAME;
! list($dbconn) = pnDBGetConn();
! $pntable = PostContact_pntables();
! if($personID > 0){
! $table = $pntable['persons_table'];
! $column = &$pntable['person'];
! $result = mysql_query("SELECT * FROM ".$table." WHERE (".$column['id']."='$personID' and ".$column['hide']."='1')");
! $num = mysql_numrows($result);
! for ($i = 0 ;$i < $num; $i++) {
! $personID = mysql_result($result, $i, $column['id']);
! $to = mysql_result($result, $i, $column['mail']);
! $personFirstName = mysql_result($result, $i, $column['firstname']);
! $personLastName = mysql_result($result, $i, $column['lastname']);
! }
! $recepient = $personFirstName." ".$personLastName;
! if(strlen($to) < 4){
! $table = $pntable['company_table'];
! $column = &$pntable['company'];
! $result = mysql_query("SELECT * FROM ".$table." WHERE ".$column['hide']."='0' order by ".$column['name']."");
! $num = mysql_numrows($result);
! for ($i = 0 ;$i < $num; $i++){
! $companyName = mysql_result($result, $i, $column['name']);
! $companyAddress = mysql_result($result, $i, $column['address']);
! $companyCity = mysql_result($result, $i, $column['city']);
! $companyZip = mysql_result($result, $i, $column['zip']);
! $companyCountry = mysql_result($result, $i, $column['country']);
! $companyPhone = mysql_result($result, $i, $column['phone']);
! $companyFax = mysql_result($result, $i, $column['fax']);
! $to = mysql_result($result, $i, $column['mail']);
! }
! if(strlen($recepient) < 4){
! $recepient = $companyName;
! }
! }
! }elseif($department > 0){
! $table = $pntable['departments_table'];
! $column = &$pntable['departments'];
! $result = mysql_query("SELECT * FROM ".$table." WHERE ".$column['id']."='$department'");
! $num = mysql_numrows($result);
! echo mysql_error();
! for ($i = 0 ;$i < $num; $i++) {
! $departmentID = mysql_result($result, $i, $column['id']);
! $to = mysql_result($result, $i, $column['email']);
! $departmentName = mysql_result($result, $i, $column['name']);
! $departmentPhone = mysql_result($result, $i, $column['phone']);
! $departmentCountry = mysql_result($result, $i, $column['country']);
! $departmentFax = mysql_result($result, $i, $column['fax']);
! }
! $recepient = $departmentName;
! if(strlen($to) < 4){
! $table = $pntable['company_table'];
! $column = &$pntable['company'];
! $result = mysql_query("SELECT * FROM ".$table." WHERE ".$column['hide']."='0' order by ".$column['name']."");
! $num = mysql_numrows($result);
! for ($i = 0 ;$i < $num; $i++){
! $companyName = mysql_result($result, $i, $column['name']);
! $companyAddress = mysql_result($result, $i, $column['address']);
! $companyCity = mysql_result($result, $i, $column['city']);
! $companyZip = mysql_result($result, $i, $column['zip']);
! $companyCountry = mysql_result($result, $i, $column['country']);
! $companyPhone = mysql_result($result, $i, $column['phone']);
! $companyFax = mysql_result($result, $i, $column['fax']);
! $to = mysql_result($result, $i, $column['mail']);
! }
! if(strlen($recepient) < 4){
! $recepient = $companyName;
! }
! }
! }else{
! $table = $pntable['company_table'];
! $column = &$pntable['company'];
! $result = mysql_query("SELECT * FROM ".$table." WHERE ".$column['hide']."='0' order by ".$column['name']."");
! $num = mysql_numrows($result);
! for ($i = 0 ;$i < $num; $i++){
! $companyName = mysql_result($result, $i, $column['name']);
! $companyAddress = mysql_result($result, $i, $column['address']);
! $companyCity = mysql_result($result, $i, $column['city']);
! $companyZip = mysql_result($result, $i, $column['zip']);
! $companyCountry = mysql_result($result, $i, $column['country']);
! $companyPhone = mysql_result($result, $i, $column['phone']);
! $companyFax = mysql_result($result, $i, $column['fax']);
! $to = mysql_result($result, $i, $column['mail']);
! }
! $country = getCountry($prefix,$companyCountry);
! $city = getCity($prefix,$companyCity);
! $recepient = $companyName;
! }
echo "
! <html xmlns=\"http://www.w3.org/1999/xhtml\">
! <head>
! <title>"._CICONTACT." $recepient</title>
! <meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" />
! <link href=\"modules/".$ModName."/css/style.css\" rel=\"stylesheet\" type=\"text/css\" />
! </head>
! <body bgcolor=\"#FFFFFF\" text=\"#000000\" leftmargin=\"0\" topmargin=\"0\" marginwidth=\"0\" marginheight=\"0\">
";
include("modules/$ModName/global_functions/javascripts.php");
echo "<form action=\"modules.php?op=modload&file=show_user_functions&pid=sendmail&name=".$ModName."&personID=".$personID."&department=".$department."&company=".$company."\" method=\"post\">";
! if($GLOBALS['sendMailToCompany'] == 1) {
! $name = $GLOBALS['sender_name'];
! $phone = $GLOBALS['sender_phone'];
! $email = $GLOBALS['sender_email'];
! $copy = $GLOBALS['sender_wantcopy'];
! $message = htmlspecialchars($GLOBALS['sender_message']);
!
! if(strlen($email) > 0){
! if(!preg_match("'^[a-z0-9_.=-]+@(?:[a-z0-9-]+\.)+([a-z]{2,3})\$'i", $email)){
! $error_message .= _EMAIL_ERROR_."<br>";
! }
! }
! if(strlen($message) < 3){
! $error_message .= _MESSAGE_ERROR_."<br>";
! }
! if(strlen($name) < 3){
! $error_message .= _NAME_ERROR_."<br>";
! }
! $contact = $GLOBALS['sender_wants_contact'];
! $department = $recepient;
! if($contact == 1) {
! $contact = "-----------------------------------------------------------------------------\nPlease Contact me!\n";
! $contactHTML = "Please Contact me!\n";
! }
! $sendMessage = "Contact: $department\n";
! $sendMessage .= "-----------------------------------------------------------------------------\n";
! $sendMessage .= "Name $name\n";
! $sendMessage .= "Phone $phone\n";
! $sendMessage .= "Email $email\n";
! $sendMessage .= "-----------------------------------------------------------------------------\n";
! $sendMessage .= "$message\n";
! $sendMessage .= "\n";
! $sendMessage .= "".$contact."-----------------------------------------------------------------------------\n";
! $sendMessage .= "Date and time: ".date("Y-m-d")." ".date("H:i")."\n";
! $sendMessage .= "\n";
! $sendHTMLMessage = "Department: $department\n";
! $sendHTMLMessage .= "\n";
! $sendHTMLMessage .= "Name $name\n";
! $sendHTMLMessage .= "Phone $phone\n";
! $sendHTMLMessage .= "Email $email\n";
! $sendHTMLMessage .= "\n";
! $sendHTMLMessage .= "$message\n";
! $sendHTMLMessage .= "\n";
! $sendHTMLMessage .= $contactHTML;
! $sendHTMLMessage .= "Date and time: ".date("Y-m-d")." ".date("H:i")."\n";
! if($GLOBALS['preview'] == 1) {
! $preview_data .= " <br /><table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td><p class=\"ContactInfoHeader\"><b>"._CIPREVIEW."</b></p><font class=\"ContactInfoText\">".nl2br(htmlspecialchars($sendHTMLMessage))."<hr noshade size=\"1\"></font></td></tr></table>";
! }else{
! if(!$error_message){
! $header = "From: ".$email."\r\nReply-To: ".$email."\r\nX-Mailer: Script from server ".$SERVER_NAME;
! $mail_success = @mail($to,"ContactMail",$sendMessage,$header);
! if($copy && $email){
! $c_mail_success = @mail($email,"Copy of ContactMail",$sendMessage,$header);
! }
! if(!$mail_success){
! writeToErrorLogg($sendMessage);
! }
! $mail_sent = 1;
! }
! }
! }
! if($error_message){
! $preview_data = " <br /><table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td><p class=\"ContactInfoHeader\"><font class=\"ContactInfoHeader\"><b>"._ERROR_INTRODUCTION_."</b></font><p class=\"ContactInfoText\">".$error_message."</p></td></tr></table>".$preview_data;
! }
! echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
! <tr><input type=\"hidden\" name=\"sendMailToCompany\" value=\"1\">
! <td width=\"20\"><img src=\"modules/$ModName/images/contactform/head_left.gif\" width=\"20\" height=\"28\" /></td>
! <td align=\"center\" valign=\"middle\" background=\"modules/$ModName/images/contactform/head_middle.gif\" class=\"ContactInfoHeader\"><font class=\"ContactInfoHeader\"><b>"._CICONTACT." $recepient</font><img src=\"modules/$ModName/images/contactform/exclam.gif\" width=\"11\" height=\"22\" align=\"absmiddle\" /></b></td>
! <td width=\"27\"><img src=\"modules/$ModName/images/contactform/head_right.gif\" width=\"27\" height=\"28\" /></td>
! </tr>
! </table><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
! <tr>
! <td width=\"20\" background=\"modules/$ModName/images/contactform/boxleft.gif\"><img src=\"modules/$ModName/images/contactform/boxleft.gif\" width=\"20\" height=\"25\" /></td>
! <td align=\"center\">";
! if(!$mail_sent) {
! print_FormParts($preview_data);
! }else{
! sendThankYou();
! }
! echo "</td>
! <td width=\"27\" background=\"modules/$ModName/images/contactform/boxright.gif\"><img src=\"modules/$ModName/images/contactform/boxright.gif\" width=\"27\" height=\"25\" /></td>
! </tr>
! </table><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
! <tr>
! <td width=\"20\"><img src=\"modules/$ModName/images/contactform/boxbott_left.gif\" width=\"20\" height=\"22\" /></td>
! <td background=\"modules/$ModName/images/contactform/boxbott_middle.gif\"><img src=\"modules/$ModName/images/contactform/boxbott_middle.gif\" width=\"9\" height=\"22\" /></td>
! <td width=\"27\"><img src=\"modules/$ModName/images/contactform/boxbott_right.gif\" width=\"27\" height=\"22\" /></td>
! </tr>
! </table></form>
! </body>
! </html>";
}
theindex($personID,$department,$company);
--- 134,385 ----
function theindex($personID,$department,$company) {
! global $ModName,$prefix,$sitename,$SERVER_NAME;
! list($dbconn) = pnDBGetConn();
! $pntable = PostContact_pntables();
! if($personID > 0){
! $table = $pntable['persons_table'];
! $column = &$pntable['person'];
!
! $query = "SELECT ".$column['id'].", ".$column['mail'].
! ", ".$column['firstname'].", ".$column['lastname'].
! " FROM ".$table." WHERE (".$column['id']."='$personID' and ".$column['hide']."='1')";
! $result = $dbconn->Execute( $query );
! if ( $result == false ) {
! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" );
! }
!
! for (; !$result->EOF; $result->MoveNext() ) {
! $personID = $result->fields[0];
! $to = $result->fields[1];
! $personFirstName = $result->fields[2];
! $personLastName = $result->fields[3];
! }
!
! $recepient = $personFirstName." ".$personLastName;
! if(strlen($to) < 4){
! $table = $pntable['company_table'];
! $column = &$pntable['company'];
!
! $query = "SELECT ".$column['name'].", ".$column['address'].
! ", ".$column['address2'].", ".$column['city'].
! ", ".$column['state'].", ".$column['zip'].
! ", ".$column['country'].", ".$column['phone'].
! ", ".$column['fax'].", ".$column['mail'].
! " FROM ".$table." WHERE ".$column['hide']."='0' order by ".$column['name']."";
!
! $result = $dbconn->Execute( $query );
! if ( $result == false ) {
! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" );
! }
!
! for (; !$result->EOF; $result->MoveNext() ) {
! $companyName = $result->fields[0];
! $companyAddress = $result->fields[1];
! $companyAddress2 = $result->fields[2];
! $companyCity = $result->fields[3];
! $companyState = $result->fields[4];
! $companyZip = $result->fields[5];
! $companyCountry = $result->fields[6];
! $companyPhone = $result->fields[7];
! $companyFax = $result->fields[8];
! $to = $result->fields[9];
! }
! if(strlen($recepient) < 4){
! $recepient = $companyName;
! }
! }
! }elseif($department > 0){
! $table = $pntable['departments_table'];
! $column = &$pntable['departments'];
! $query = "SELECT ".$column['id'].", ".$column['name'].
! ", ".$column['phone'].", ".$column['country'].
! ", ".$column['fax'].", ".$column['email'].
! " FROM ".$table." WHERE ".$column['id']."='$department'";
!
! $result = $dbconn->Execute( $query );
! if ( $result == false ) {
! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" );
! }
!
! for (; !$result->EOF; $result->MoveNext() ) {
! $departmentID = $result->fields[0];
! $departmentName = $result->fields[1];
! $departmentPhone = $result->fields[2];
! $departmentCountry = $result->fields[3];
! $departmentFax = $result->fields[4];
! $to = $result->fields[5];
! }
! $recepient = $departmentName;
! if(strlen($to) < 4){
! $table = $pntable['company_table'];
! $column = &$pntable['company'];
!
! $query = "SELECT ".$column['name'].", ".$column['address'].
! ", ".$column['address2'].", ".$column['city'].
! ", ".$column['state'].", ".$column['zip'].
! ", ".$column['country'].", ".$column['phone'].
! ", ".$column['fax'].", ".$column['mail'].
! " FROM ".$table." WHERE ".$column['hide']."='0' order by ".$column['name']."";
!
! $result = $dbconn->Execute( $query );
! if ( $result == false ) {
! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" );
! }
!
! for (; !$result->EOF; $result->MoveNext() ) {
! $companyName = $result->fields[0];
! $companyAddress = $result->fields[1];
! $companyAddress2 = $result->fields[2];
! $companyCity = $result->fields[3];
! $companyState = $result->fields[4];
! $companyZip = $result->fields[5];
! $companyCountry = $result->fields[6];
! $companyPhone = $result->fields[7];
! $companyFax = $result->fields[8];
! $to = $result->fields[9];
! }
! if(strlen($recepient) < 4){
! $recepient = $companyName;
! }
! }
! }else{
! $table = $pntable['company_table'];
! $column = &$pntable['company'];
!
! $query = "SELECT ".$column['name'].", ".$column['address'].
! ", ".$column['address2'].", ".$column['city'].
! ", ".$column['state'].", ".$column['zip'].
! ", ".$column['country'].", ".$column['phone'].
! ", ".$column['fax'].", ".$column['mail'].
! " FROM ".$table." WHERE ".$column['hide']."='0' order by ".$column['name']."";
!
! $result = $dbconn->Execute( $query );
! if ( $result == false ) {
! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" );
! }
!
! for (; !$result->EOF; $result->MoveNext() ) {
! $companyName = $result->fields[0];
! $companyAddress = $result->fields[1];
! $companyAddress2 = $result->fields[2];
! $companyCity = $result->fields[3];
! $companyState = $result->fields[4];
! $companyZip = $result->fields[5];
! $companyCountry = $result->fields[6];
! $companyPhone = $result->fields[7];
! $companyFax = $result->fields[8];
! $to = $result->fields[9];
! }
! $country = getCountry($prefix,$companyCountry);
! $city = getCity($prefix,$companyCity);
! $recepient = $companyName;
! }
echo "
! <html xmlns=\"http://www.w3.org/1999/xhtml\">
! <head>
! <title>"._CICONTACT." $recepient</title>
! <meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\" />
! <link href=\"modules/".$ModName."/css/style.css\" rel=\"stylesheet\" type=\"text/css\" />
! </head>
! <body bgcolor=\"#FFFFFF\" text=\"#000000\" leftmargin=\"0\" topmargin=\"0\" marginwidth=\"0\" marginheight=\"0\">
";
include("modules/$ModName/global_functions/javascripts.php");
echo "<form action=\"modules.php?op=modload&file=show_user_functions&pid=sendmail&name=".$ModName."&personID=".$personID."&department=".$department."&company=".$company."\" method=\"post\">";
! if($GLOBALS['sendMailToCompany'] == 1) {
! $name = $GLOBALS['sender_name'];
! $phone = $GLOBALS['sender_phone'];
! $email = $GLOBALS['sender_email'];
! $copy = $GLOBALS['sender_wantcopy'];
! $message = htmlspecialchars($GLOBALS['sender_message']);
!
! if(strlen($email) > 0){
! if(!preg_match("'^[a-z0-9_.=-]+@(?:[a-z0-9-]+\.)+([a-z]{2,3})\$'i", $email)){
! $error_message .= _EMAIL_ERROR_."<br>";
! }
! }
! if(strlen($message) < 3){
! $error_message .= _MESSAGE_ERROR_."<br>";
! }
! if(strlen($name) < 3){
! $error_message .= _NAME_ERROR_."<br>";
! }
! $contact = $GLOBALS['sender_wants_contact'];
! $department = $recepient;
! if($contact == 1) {
! $contact = "-----------------------------------------------------------------------------\nPlease Contact me!\n";
! $contactHTML = "Please Contact me!\n";
! }
! $sendMessage = "Contact: $department\n";
! $sendMessage .= "-----------------------------------------------------------------------------\n";
! $sendMessage .= "Name $name\n";
! $sendMessage .= "Phone $phone\n";
! $sendMessage .= "Email $email\n";
! $sendMessage .= "-----------------------------------------------------------------------------\n";
! $sendMessage .= "$message\n";
! $sendMessage .= "\n";
! $sendMessage .= "".$contact."-----------------------------------------------------------------------------\n";
! $sendMessage .= "Date and time: ".date("Y-m-d")." ".date("H:i")."\n";
! $sendMessage .= "\n";
! $sendHTMLMessage = "Department: $department\n";
! $sendHTMLMessage .= "\n";
! $sendHTMLMessage .= "Name $name\n";
! $sendHTMLMessage .= "Phone $phone\n";
! $sendHTMLMessage .= "Email $email\n";
! $sendHTMLMessage .= "\n";
! $sendHTMLMessage .= "$message\n";
! $sendHTMLMessage .= "\n";
! $sendHTMLMessage .= $contactHTML;
! $sendHTMLMessage .= "Date and time: ".date("Y-m-d")." ".date("H:i")."\n";
! if($GLOBALS['preview'] == 1) {
! $preview_data .= " <br /><table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td><p class=\"ContactInfoHeader\"><b>"._CIPREVIEW."</b></p><font class=\"ContactInfoText\">".nl2br(htmlspecialchars($sendHTMLMessage))."<hr noshade size=\"1\"></font></td></tr></table>";
! }else{
! if(!$error_message){
! $header = "From: ".$email."\r\nReply-To: ".$email."\r\nX-Mailer: Script from server ".$SERVER_NAME;
! $mail_success = @mail($to,"ContactMail",$sendMessage,$header);
! if($copy && $email){
! $c_mail_success = @mail($email,"Copy of ContactMail",$sendMessage,$header);
! }
! if(!$mail_success){
! writeToErrorLogg($sendMessage);
! }
! $mail_sent = 1;
! }
! }
! }
! if($error_message){
! $preview_data = " <br /><table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td><p class=\"ContactInfoHeader\"><font class=\"ContactInfoHeader\"><b>"._ERROR_INTRODUCTION_."</b></font><p class=\"ContactInfoText\">".$error_message."</p></td></tr></table>".$preview_data;
! }
! echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
! <tr><input type=\"hidden\" name=\"sendMailToCompany\" value=\"1\">
! <td width=\"20\"><img src=\"modules/$ModName/images/contactform/head_left.gif\" width=\"20\" height=\"28\" /></td>
! <td align=\"center\" valign=\"middle\" background=\"modules/$ModName/images/contactform/head_middle.gif\" class=\"ContactInfoHeader\"><font class=\"ContactInfoHeader\"><b>"._CICONTACT." $recepient</font><img src=\"modules/$ModName/images/contactform/exclam.gif\" width=\"11\" height=\"22\" align=\"absmiddle\" /></b></td>
! <td width=\"27\"><img src=\"modules/$ModName/images/contactform/head_right.gif\" width=\"27\" height=\"28\" /></td>
! </tr>
! </table><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
! <tr>
! <td width=\"20\" background=\"modules/$ModName/images/contactform/boxleft.gif\"><img src=\"modules/$ModName/images/contactform/boxleft.gif\" width=\"20\" height=\"25\" /></td>
! <td align=\"center\">";
! if(!$mail_sent) {
! print_FormParts($preview_data);
! }else{
! sendThankYou();
! }
! echo "</td>
! <td width=\"27\" background=\"modules/$ModName/images/contactform/boxright.gif\"><img src=\"modules/$ModName/images/contactform/boxright.gif\" width=\"27\" height=\"25\" /></td>
! </tr>
! </table><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
! <tr>
! <td width=\"20\"><img src=\"modules/$ModName/images/contactform/boxbott_left.gif\" width=\"20\" height=\"22\" /></td>
! <td background=\"modules/$ModName/images/contactform/boxbott_middle.gif\"><img src=\"modules/$ModName/images/contactform/boxbott_middle.gif\" width=\"9\" height=\"22\" /></td>
! <td width=\"27\"><img src=\"modules/$ModName/images/contactform/boxbott_right.gif\" width=\"27\" height=\"22\" /></td>
! </tr>
! </table></form>
! </body>
! </html>";
}
theindex($personID,$department,$company);
Index: vicitcard.php
===================================================================
RCS file: /home/cvsroot/postnuke_modules/PostContact/user_functions/vicitcard.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** vicitcard.php 23 Jul 2002 12:07:08 -0000 1.2
--- vicitcard.php 6 Aug 2002 20:16:57 -0000 1.3
***************
*** 1,197 ****
<?
// $Id$ $Name$
if(basename($PHP_SELF) == basename(__FILE__)){
! echo "You have no access to this file!!!";
! exit;
}
function theindex($personID){
! global $ModName,$prefix,$sitename;
! list($dbconn) = pnDBGetConn();
! $pntable = PostContact_pntables();
!
! $table = $pntable['company_table'];
! $column = &$pntable['company'];
! $result = mysql_query("SELECT * FROM ".$table." WHERE ".$column['hide']."='0' order by ".$column['name']);
! $num = mysql_numrows($result);
! for ($i = 0 ;$i < $num; $i++){
! $companyName = mysql_result($result, $i, $column['name']);
! $companyAddress = mysql_result($result, $i, $column['address']);
! $companyCity = mysql_result($result, $i, $column['city']);
! $companyZip = mysql_result($result, $i, $column['zip']);
! $companyCountry = mysql_result($result, $i, $column['country']);
! $companyPhone = mysql_result($result, $i, $column['phone']);
! $companyFax = mysql_result($result, $i, $column['fax']);
! $companyMail = mysql_result($result, $i, $column['mail']);
! $companyState = mysql_result($result, $i, $column['state']);
! $companyLogo = mysql_result($result, $i, $column['logo']);
! }
! $companyCity = getCity($prefix,$companyCity);
! $companyCity = $companyCity['name'];
! $table = $pntable['persons_table'];
! $column = &$pntable['person'];
! $table2 = $pntable['attributes_table'];
! $column2 = &$pntable['attribute'];
$contactType = "P";
! $query = "SELECT * FROM ".$table.", ".$table2 .
! " WHERE (".$column['id']."='$personID' and ".$column['hide']."='1')" .
! " AND ".$column['id']."=".$column2['id'] .
! " AND ".$column2['contacttype']."='".$contactType."'";
! $result = mysql_query($query);
! if(mysql_error()){
! echo "<p>MySQL-fel: ".mysql_error()."</p>";
! echo "<p>".$query."</p>";
}
! $num = mysql_numrows($result);
! for ($i = 0 ;$i < $num; $i++){
! $personID = mysql_result($result, $i, $column['id']);
! $attributeShowImage = mysql_result($result, $i, $column['showimage']);
! $personMail = mysql_result($result, $i, $column['mail']);
! $personFirstName = mysql_result($result, $i, $column['firstname']);
! $personLastName = mysql_result($result, $i, $column['lastname']);
! $personAddress = mysql_result($result, $i, $column['address']);
! $personAddress2 = mysql_result($result, $i, $column['address2']);
! $personZip = mysql_result($result, $i, $column['zip']);
! $personCity = mysql_result($result, $i, $column['city']);
! $personCountry = mysql_result($result, $i, $column['country']);
! $personLang = mysql_result($result, $i, $column['lang']);
! $personFax = mysql_result($result, $i, $column['fax']);
! $personState = mysql_result($result, $i, $column['state']);
! $personMobile = mysql_result($result, $i, $column['mobile']);
! $personPhone = mysql_result($result, $i, $column['phone']);
! $personPager = mysql_result($result, $i, $column['pager']);
! $personICQ = mysql_result($result, $i, $column['ICQ']);
! $personAIM = mysql_result($result, $i, $column['AIM']);
! $personYIM = mysql_result($result, $i, $column['YIM']);
! $personMSNM = mysql_result($result, $i, $column['MSNM']);
! $personImage = mysql_result($result, $i, $column['image']);
! $personTypePhone = mysql_result($result, $i, $column['typephone']);
! $personTypeFax = mysql_result($result, $i, $column['typefax']);
! $personTypePager = mysql_result($result, $i, $column['typepager']);
! $personTypeMobile = mysql_result($result, $i, $column['typemobile']);
! $personHide = mysql_result($result, $i, $column['hide']);
! $attributeShowName = mysql_result($result, $i, $column2['showname']);
! $attributeShowAddress = mysql_result($result, $i, $column2['showaddress']);
! $attributeShowAddress2 = mysql_result($result, $i, $column2['showaddress2']);
! $attributeShowZip = mysql_result($result, $i, $column2['showzip']);
! $attributeShowCity = mysql_result($result, $i, $column2['showcity']);
! $attributeShowCountry = mysql_result($result, $i, $column2['showcountry']);
! $attributeShowPhone = mysql_result($result, $i, $column2['showphone']);
! $attributeShowFax = mysql_result($result, $i, $column2['showfax']);
! $attributeShowMobile = mysql_result($result, $i, $column2['showmobile']);
! $attributeShowPager = mysql_result($result, $i, $column2['showpager']);
! $attributeShowEmail = mysql_result($result, $i, $column2['showemail']);
! $attributeShowICQ = mysql_result($result, $i, $column2['showICQ']);
! $attributeShowAIM = mysql_result($result, $i, $column2['showAIM']);
! $attributeShowYIM = mysql_result($result, $i, $column2['showYIM']);
! $attributeShowMSNM = mysql_result($result, $i, $column2['showMSNM']);
! $attributeShowTitle = mysql_result($result, $i, $column2['showtitle']);
! $attributeShowState = mysql_result($result, $i, $column2['showState']);
! $attributeShowDepartment = mysql_result($result, $i, $column2['showdepartment']);
! $personTitleID = mysql_result($result, $i, $column['titleID']);
!
!
! }
! $personTitle = getTitle($prefix,$personTitleID);
! $personCity = getCity($prefix,$personCity);
!
! $personTitleName = $personTitle['name'];
! $personCityName = $personCity['name'];
!
! $personTypePhone = getContactType($prefix,$personTypePhone);
! $personTypeFax = getContactType($prefix,$personTypeFax);
! $personTypePager = getContactType($prefix,$personTypePager);
! $personTypeMobile = getContactType($prefix,$personTypeMobile);
!
! $personTypePhone = $personTypePhone['name'];
! $personTypeFax = $personTypeFax['name'];
! $personTypePager = $personTypePager['name'];
! $personTypeMobile = $personTypeMobile['name'];
! if((!is_file($personImage)) OR (!$attributeShowImage)){
! $personImage = "modules/$ModName/images/transparent.gif";
! $PersonImageProp = " border=\"0\" cellpadding=\"0\" cellspacing=\"0\"";
! }else{
! $PersonImageProp = " border=\"1\" cellpadding=\"0\" cellspacing=\"0\" class=\"BusinessCardFotoBackground\"";
! }
! if(!is_file($companyLogo)){
! $companyLogo = "modules/$ModName/images/transparent.gif";
! $logoProp = " border=\"0\" cellpadding=\"0\" cellspacing=\"0\"";
! }else{
! $logoProp = " border=\"1\" cellpadding=\"0\" cellspacing=\"0\" class=\"BusinessCardFotoBackground\"";
! }
! $table = $pntable['department_members_table'];
! $column = &$pntable['department_members'];
! $result = mysql_query("SELECT * FROM ".$table." WHERE ".$column['id']."='$personID'");
! $num = mysql_numrows($result);
! echo mysql_error();
! for ($i = 0 ;$i < $num; $i++){
! $departmentID = mysql_result($result, $i, $column['depid']);
! }
! $table = $pntable['departments_table'];
! $column = &$pntable['departments'];
! $result = mysql_query("SELECT * FROM ".$table." WHERE ".$column['id']."='$departmentID'");
! $num = mysql_numrows($result);
! if(!$num){
! $departmentName = "";
! }else{
! echo mysql_error();
! for ($i = 0 ;$i < $num; $i++){
! $departmentID = mysql_result($result, $i, $column['id']);
! $departmentEmail = mysql_result($result, $i, $column['email']);
! $departmentName = mysql_result($result, $i, $column['name']);
! $departmentPhone = mysql_result($result, $i, $column['phone']);
! $departmentCountry = mysql_result($result, $i, $column['country']);
! $departmentFax = mysql_result($result, $i, $column['fax']);
! }
! }
! // Check what to show, else use companyinfo
! if(!$attributeShowState){
! $personState = $companyState;
! }elseif(!$personState){ // If no state is used for user, then use company state
! $personState = $companyState;
! }
if((!$attributeShowAddress) or ($personAddress == "")){
! $personAddress = $companyAddress;
}
if((!$attributeShowZip) or ($personZip == "")){
! $personZip = $companyZip;
}
if((!$attributeShowCity) or ($personCity == "")){
! $personCity = $companyCity;
}
if((!$attributeShowCountry) or ($personCountry == "")){
! $personCountry = $companyCountry;
}
if((!$attributeShowPhone) or ($personPhone == "")){
! $personPhone = $companyPhone;
}
if((!$attributeShowFax) or ($personFax == "")){
! $personFax = $companyFax;
}
if(!$attributeShowMobile){
! $personMobile = "";
}
if(!$attributeShowPager){
--- 1,252 ----
<?
// $Id$ $Name$
+ // ----------------------------------------------------------------------
+ // POST-NUKE Content Management System
+ // Copyright (C) 2002 by the PostNuke Development Team.
+ // http://www.postnuke.com/
+ // ----------------------------------------------------------------------
+ // LICENSE
+ //
+ // This program is free software; you can redistribute it and/or
+ // modify it under the terms of the GNU General Public License (GPL)
+ // as published by the Free Software Foundation; either version 2
+ // of the License, or (at your option) any later version.
+ //
+ // This program is distributed in the hope that it will be useful,
+ // but WIthOUT ANY WARRANTY; without even the implied warranty of
+ // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ // GNU General Public License for more details.
+ //
+ // To read the license please visit http://www.gnu.org/copyleft/gpl.html
+ // ----------------------------------------------------------------------
+ // Original Author of file: Bjarne Var�ystrand and Bjarne Var�ystrand
+ // Modifications by: Richard Cave
+ // Purpose of file: Display contact person information
+ // ----------------------------------------------------------------------
+
if(basename($PHP_SELF) == basename(__FILE__)){
! echo "You have no access to this file!!!";
! exit;
}
function theindex($personID){
! global $ModName,$prefix,$sitename;
! list($dbconn) = pnDBGetConn();
! $pntable = PostContact_pntables();
! $table = $pntable['company_table'];
! $column = &$pntable['company'];
! $query = "SELECT ".$column['name'].", ".$column['address'].
! ", ".$column['address2'].", ".$column['city'].
! ", ".$column['state'].", ".$column['zip'].
! ", ".$column['country'].", ".$column['phone'].
! ", ".$column['fax'].", ".$column['mail'].", ".$column['logo'].
! " FROM ".$table." WHERE ".$column['hide']."='0' order by ".$column['name'];
! $result = $dbconn->Execute( $query );
! if ( $result == false ) {
! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" );
! }
+ for (; !$result->EOF; $result->MoveNext() ) {
+ $companyName = $result->fields[0];
+ $companyAddress = $result->fields[1];
+ $companyAddress2 = $result->fields[2];
+ $companyCity = $result->fields[3];
+ $companyState = $result->fields[4];
+ $companyZip = $result->fields[5];
+ $companyCountry = $result->fields[6];
+ $companyPhone = $result->fields[7];
+ $companyFax = $result->fields[8];
+ $companyMail = $result->fields[9];
+ $companyLogo = $result->fields[10];
+ }
+ $companyCity = getCity($prefix,$companyCity);
+ $companyCity = $companyCity['name'];
! $table = $pntable['persons_table'];
! $column = &$pntable['person'];
! $table2 = $pntable['attributes_table'];
! $column2 = &$pntable['attribute'];
$contactType = "P";
! $query = "SELECT ".$column['id'].", ".$column['mail'].
! ", ".$column['firstname'].", ".$column['lastname'].
! ", ".$column['mobile'].", ".$column['phone'].
! ", ".$column['address'].", ".$column['address2'].
! ", ".$column['city'].", ".$column['state'].
! ", ".$column['zip'].", ".$column['country'].
! ", ".$column['lang'].
! ", ".$column['fax'].", ".$column['hide'].
! ", ".$column['image'].", ".$column['pager'].
! ", ".$column['ICQ'].", ".$column['AIM'].
! ", ".$column['YIM'].", ".$column['MSNM'].
! ", ".$column['typephone'].", ".$column['typefax'].
! ", ".$column['titleID'].", ".$column['typepager'].
! ", ".$column['typemobile'].
! ", ".$column2['showname'].
! ", ".$column2['showaddress'].", ".$column2['showaddress2'].
! ", ".$column2['showcity'].", ".$column2['showstate'].
! ", ".$column2['showzip'].", ".$column2['showcountry'].
! ", ".$column2['showphone'].", ".$column2['showfax'].
! ", ".$column2['showmobile'].", ".$column2['showpager'].
! ", ".$column2['showemail'].", ".$column2['showICQ'].
! ", ".$column2['showAIM'].", ".$column2['showYIM'].
! ", ".$column2['showMSNM'].", ".$column2['showtitle'].
! ", ".$column2['showdepartment'].", ".$column2['showimage'].
! " FROM ".$table.", ".$table2.
! " WHERE (".$column['id']."='$personID' and ".$column['hide']."='1')" .
! " AND ".$column['id']."=".$column2['id'] .
! " AND ".$column2['contacttype']."='".$contactType."'";
! $result = $dbconn->Execute( $query );
! if ( $result == false ) {
! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" );
! }
! for (; !$result->EOF; $result->MoveNext() ) {
! $personID = $result->fields[0];
! $personMail = $result->fields[1];
! $personFirstName = $result->fields[2];
! $personLastName = $result->fields[3];
! $personMobile = $result->fields[4];
! $personPhone = $result->fields[5];
! $personAddress = $result->fields[6];
! $personAddress2 = $result->fields[7];
! $personCity = $result->fields[8];
! $personState = $result->fields[9];
! $personZip = $result->fields[10];
! $personCountry = $result->fields[11];
! $personLang = $result->fields[12];
! $personFax = $result->fields[13];
! $personHide = $result->fields[14];
! $personImage = $result->fields[15];
! $personPager = $result->fields[16];
! $personICQ = $result->fields[17];
! $personAIM = $result->fields[18];
! $personYIM = $result->fields[19];
! $personMSNM = $result->fields[20];
! $personTypePhone = $result->fields[21];
! $personTypeFax = $result->fields[22];
! $personTitleID = $result->fields[23];
! $personTypePager = $result->fields[24];
! $personTypeMobile = $result->fields[25];
! $attributeShowName = $result->fields[26];
! $attributeShowAddress = $result->fields[27];
! $attributeShowAddress2 = $result->fields[28];
! $attributeShowCity = $result->fields[29];
! $attributeShowState = $result->fields[30];
! $attributeShowZip = $result->fields[31];
! $attributeShowCountry = $result->fields[32];
! $attributeShowPhone = $result->fields[33];
! $attributeShowFax = $result->fields[34];
! $attributeShowMobile = $result->fields[35];
! $attributeShowPager = $result->fields[36];
! $attributeShowEmail = $result->fields[37];
! $attributeShowICQ = $result->fields[38];
! $attributeShowAIM = $result->fields[39];
! $attributeShowYIM = $result->fields[40];
! $attributeShowMSNM = $result->fields[41];
! $attributeShowTitle = $result->fields[42];
! $attributeShowDepartment = $result->fields[43];
! $attributeShowImage = $result->fields[44];
}
! $personTitle = getTitle($prefix,$personTitleID);
! $personCity = getCity($prefix,$personCity);
!
! $personTitleName = $personTitle['name'];
! $personCityName = $personCity['name'];
!
! $personTypePhone = getContactType($prefix,$personTypePhone);
! $personTypeFax = getContactType($prefix,$personTypeFax);
! $personTypePager = getContactType($prefix,$personTypePager);
! $personTypeMobile = getContactType($prefix,$personTypeMobile);
!
! $personTypePhone = $personTypePhone['name'];
! $personTypeFax = $personTypeFax['name'];
! $personTypePager = $personTypePager['name'];
! $personTypeMobile = $personTypeMobile['name'];
! if((!is_file($personImage)) OR (!$attributeShowImage)){
! $personImage = "modules/$ModName/images/transparent.gif";
! $PersonImageProp = " border=\"0\" cellpadding=\"0\" cellspacing=\"0\"";
! }else{
! $PersonImageProp = " border=\"1\" cellpadding=\"0\" cellspacing=\"0\" class=\"BusinessCardFotoBackground\"";
! }
! if(!is_file($companyLogo)){
! $companyLogo = "modules/$ModName/images/transparent.gif";
! $logoProp = " border=\"0\" cellpadding=\"0\" cellspacing=\"0\"";
! }else{
! $logoProp = " border=\"1\" cellpadding=\"0\" cellspacing=\"0\" class=\"BusinessCardFotoBackground\"";
! }
+ $table = $pntable['department_members_table'];
+ $column = &$pntable['department_members'];
! $query = "SELECT ".$column['depid']." FROM ".$table." WHERE ".$column['id']."='$personID'";
! $result = $dbconn->Execute( $query );
! if ( $result == false ) {
! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" );
! }
! for (; !$result->EOF; $result->MoveNext() ) {
! $departmentID = $result->fields[0];
! }
+ $table = $pntable['departments_table'];
+ $column = &$pntable['departments'];
! $query = "SELECT ".$column['id'].", ".$column['email'].", ".$column['name'].
! ", ".$column['phone'].", ".$column['country'].", ".$column['fax'].
! " FROM ".$table." WHERE ".$column['id']."='$departmentID'";
! $result = $dbconn->Execute( $query );
! if ( $result == false ) {
! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" );
! }
+ // R.Cave - initialize $departmentName incase no rows are returned
+ $departmentName = "";
! for (; !$result->EOF; $result->MoveNext() ) {
! $departmentID = $result->fields[0];
! $departmentEmail = $result->fields[1];
! $departmentName = $result->fields[2];
! $departmentPhone = $result->fields[3];
! $departmentCountry = $result->fields[4];
! $departmentFax = $result->fields[5];
! }
! // Kontrollera vad som ska visas, anv�nd annars company-prefs
!
if((!$attributeShowAddress) or ($personAddress == "")){
! $personAddress = $companyAddress;
! }
! if((!$attributeShowState) or ($personState == "")){
! $personState = $companyState;
}
if((!$attributeShowZip) or ($personZip == "")){
! $personZip = $companyZip;
}
if((!$attributeShowCity) or ($personCity == "")){
! $personCity = $companyCity;
}
if((!$attributeShowCountry) or ($personCountry == "")){
! $personCountry = $companyCountry;
}
if((!$attributeShowPhone) or ($personPhone == "")){
! $personPhone = $companyPhone;
}
if((!$attributeShowFax) or ($personFax == "")){
! $personFax = $companyFax;
}
if(!$attributeShowMobile){
! $personMobile = "";
}
if(!$attributeShowPager){
***************
*** 199,203 ****
}
if((!$attributeShowEmail) or ($personMail == "")){
! $personMail = $companyMail;
}
if(!$attributeShowICQ){
--- 254,258 ----
}
if((!$attributeShowEmail) or ($personMail == "")){
! $personMail = $companyMail;
}
if(!$attributeShowICQ){
***************
*** 221,317 ****
echo "<html>
! <head>
! <title>".$personFirstName." ".$personLastName."</title>
! </head>
! <link rel=\"StyleSheet\" href=\"modules/$ModName/css/style.css\" type=\"text/css\">
! <body bgcolor=\"#ffffff\" leftmargin=\"0\" marginwidth=\"0\" topmargin=\"0\" marginheight=\"0\">
! <table width=\"100%\" height=\"100%\">
! <tr>
! <td align=\"center\" valign=\"middle\">
! <table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" class=\"BusinessCardBackground\">
! <tr>
! <td><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\">
! <tr>
! <td width=\"70\"> </td>
! <th class=\"BusinessCardHeader\"><font class=\"BusinessCardHeader\">".$companyName;
! if($departmentName && $companyName){
! echo " - ";
! }
! echo $departmentName."</font></th>
! <td width=\"70\"> </td>
! </tr><tr>
! <td width=\"70\" align=\"center\" valign=\"top\"><table width=\"100%\"".$PersonImageProp.">
! <tr>
! <td align=\"center\"><img src=\"".$personImage."\" width=\"60\" height=\"80\" vspace=\"3\" /></td>
! </tr>
! </table></td>
! <td align=\"left\" valign=\"middle\"><table width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"0\">
! <tr>
! <td align=\"center\" class=\"BusinessCardText\"><font class=\"BusinessCardText\">".$personFirstName." ".$personLastName."</font></td>
! </tr>";
! if($attributeShowTitle){
! if($personTitleName){
! echo "<tr>
! <td align=\"center\" class=\"BusinessCardText\"><font class=\"BusinessCardText\"><i>".$personTitleName."</i></font></td>
! </tr>
! ";
! }
! }
! echo "<tr>
! <td align=\"center\" class=\"BusinessCardText\"><font class=\"BusinessCardText\">".$personAddress;
! if($personZip && $personAddress){
! echo ", ";
! }
! echo $personZip." ".$personCityName."</font></td>
! </tr><tr>
! <td align=\"center\" class=\"BusinessCardText\"><font class=\"BusinessCardText\">".$personCountry."</font></td>
! </tr><tr>
! <td align=\"center\"><img src=\"dots.gif\" width=\"207\" height=\"1\" vspace=\"1\" /></td>
! </tr>
! </table></td>
! <td width=\"70\" align=\"center\" valign=\"top\"><table width=\"100%\"".$logoProp.">
! <tr>
! <td align=\"center\" height=\"80\" valign=\"middle\"><img src=\"".$companyLogo."\" width=\"60\" vspace=\"3\" /></td>
! </tr>
! </table></td>
! </tr><tr>
! <td align=\"center\" valign=\"top\"> </td>
! <td align=\"center\" valign=\"middle\" nowrap=\"nowrap\" class=\"BusinessCardContactWays\">";
! if($personPhone){
! echo "<font class=\"BusinessCardContactWays\"><b>"._CIPHONE.":</b> ".$personPhone;
! }
! if($personFax && $personPhone){
! echo ",";
! }
! if($personFax){
! echo " <b>"._CIFAX.":</b> ".$personFax."</font>";
! }
! echo "<br />";
! if($attributeShowMobile){
! if($personMobile){
! echo "<font class=\"BusinessCardContactWays\"><b>"._CIMOBILE.":</b> ".$personMobile."";
! }
! }
! if($attributeShowICQ){
! if($attributeShowMobile && $personMobile){
! echo ", ";
! }
! if($personICQ){
! echo "<b>"._CIICQ.":</b> ".$personICQ."</font>";
! }
! echo "<br />";
! }elseif($attributeShowMobile){
! echo "<br />";
! }
! if($personMail){
! echo "<font class=\"BusinessCardContactWays\"><b>"._CIEMAIL.":</b> ".$personMail."</font>";
! }
! echo "</td>
! <td align=\"center\" valign=\"top\"> </td>
! </tr>
! </table></td>
! </tr>
! </table>";
}
--- 276,372 ----
echo "<html>
! <head>
! <title>".$personFirstName." ".$personLastName."</title>
! </head>
! <link rel=\"StyleSheet\" href=\"modules/$ModName/css/style.css\" type=\"text/css\">
! <body bgcolor=\"#ffffff\" leftmargin=\"0\" marginwidth=\"0\" topmargin=\"0\" marginheight=\"0\">
! <table width=\"100%\" height=\"90%\">
! <tr>
! <td align=\"center\" valign=\"middle\">
! <table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" class=\"BusinessCardBackground\">
! <tr>
! <td><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\">
! <tr>
! <td width=\"70\"> </td>
! <th class=\"BusinessCardHeader\"><font class=\"BusinessCardHeader\">".$companyName;
! if($departmentName && $companyName){
! echo " - ";
! }
! echo $departmentName."</font></th>
! <td width=\"70\"> </td>
! </tr><tr>
! <td width=\"70\" align=\"center\" valign=\"top\"><table width=\"100%\"".$PersonImageProp.">
! <tr>
! <td align=\"center\"><img src=\"".$personImage."\" width=\"60\" height=\"80\" vspace=\"3\" /></td>
! </tr>
! </table></td>
! <td align=\"left\" valign=\"middle\"><table width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"0\">
! <tr>
! <td align=\"center\" class=\"BusinessCardText\"><font class=\"BusinessCardText\">".$personFirstName." ".$personLastName."</font></td>
! </tr>";
! if($attributeShowTitle){
! if($personTitleName){
! echo "<tr>
! <td align=\"center\" class=\"BusinessCardText\"><font class=\"BusinessCardText\"><i>".$personTitleName."</i></font></td>
! </tr>
! ";
! }
! }
! echo "<tr>
! <td align=\"center\" class=\"BusinessCardText\"><font class=\"BusinessCardText\">".$personAddress;
! if($personZip && $personAddress){
! echo ", ";
! }
! echo $personCityName." ".$personState." ".$personZip."</font></td>
! </tr><tr>
! <td align=\"center\" class=\"BusinessCardText\"><font class=\"BusinessCardText\">".$personCountry."</font></td>
! </tr><tr>
! <td align=\"center\"><img src=\"dots.gif\" width=\"207\" height=\"1\" vspace=\"1\" /></td>
! </tr>
! </table></td>
! <td width=\"70\" align=\"center\" valign=\"top\"><table width=\"100%\"".$logoProp.">
! <tr>
! <td align=\"center\" height=\"80\" valign=\"middle\"><img src=\"".$companyLogo."\" width=\"60\" vspace=\"3\" /></td>
! </tr>
! </table></td>
! </tr><tr>
! <td align=\"center\" valign=\"top\"> </td>
! <td align=\"center\" valign=\"middle\" nowrap=\"nowrap\" class=\"BusinessCardContactWays\">";
! if($personPhone){
! echo "<font class=\"BusinessCardContactWays\"><b>"._CIPHONE.":</b> ".$personPhone;
! }
! if($personFax && $personPhone){
! echo ",";
! }
! if($personFax){
! echo " <b>"._CIFAX.":</b> ".$personFax."</font>";
! }
! echo "<br />";
! if($attributeShowMobile){
! if($personMobile){
! echo "<font class=\"BusinessCardContactWays\"><b>"._CIMOBILE.":</b> ".$personMobile."";
! }
! }
! if($attributeShowICQ){
! if($attributeShowMobile && $personMobile){
! echo ", ";
! }
! if($personICQ){
! echo "<b>"._CIICQ.":</b> ".$personICQ."</font>";
! }
! echo "<br />";
! }elseif($attributeShowMobile){
! echo "<br />";
! }
! if($personMail){
! echo "<font class=\"BusinessCardContactWays\"><b>"._CIEMAIL.":</b> ".$personMail."</font>";
! }
! echo "</td>
! <td align=\"center\" valign=\"top\"> </td>
! </tr>
! </table></td>
! </tr>
! </table>";
}
***************
*** 321,324 ****
</tr>
</table>
</body>
! </html>
--- 376,384 ----
</tr>
</table>
+ <div align="center">
+ <font class="BusinessCardText">
+ <a href="javascript:window.close();">Close Window</a>
+ </font>
+ </div>
</body>
! </html>
\ No newline at end of file
View Statistics - Next Notice - Previous Notice
| Visit Developer Site - Browse CVS Repository |
Syndicate via backend.rss (max. once per hour please) | Powered by CVSNotice 0.1.3 |