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 [ view in CVS ]
Date | Directory [filter] | File(s) [view] | Author [filter] |
06 Aug 2002 20:18:29 | postnuke_modules/PostContact | index.php,1.2,1.3 pninit.php,1.2,1.3 pntables.php,1.2,1.3 | Richard Cave |
ADODB conversion. |
Update of /home/cvsroot/postnuke_modules/PostContact In directory ns7.hostnuke.net:/tmp/cvs-serv18000/PostContact Modified Files: index.php pninit.php pntables.php Log Message: ADODB conversion. Index: index.php =================================================================== RCS file: /home/cvsroot/postnuke_modules/PostContact/index.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** index.php 23 Jul 2002 11:51:04 -0000 1.2 --- index.php 6 Aug 2002 20:18:27 -0000 1.3 *************** *** 1,4 **** --- 1,28 ---- <? // $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 information + // ---------------------------------------------------------------------- + if (!defined("LOADED_AS_MODULE")) { *************** *** 16,318 **** function theindex($mode=''){ ! global $ModName,$sitename; ! list($dbconn) = pnDBGetConn(); ! $pntable = PostContact_pntables(); ! $prefix = pnConfigGetVar('prefix'); ! $sitename = pnConfigGetVar('sitename'); ! $table = $pntable['persons_table']; ! $column = &$pntable['person']; ! $query = "SELECT * FROM ".$table." WHERE (".$column['hide']."='1') and (".$column['lang']."='$currentlang' or ".$column['lang']."='all') ORDER BY ".$column['firstname'].""; ! $membersInDepartment = @mysql_query($query); ! if(mysql_error()){ ! $error_report .= "<br><li>".mysql_error()."</li>"; ! }else{ ! $persons_exists = mysql_numrows($membersInDepartment); ! } ! $table = $pntable['company_table']; ! $column = &$pntable['company']; ! $currentlang = pnUserGetLang(); ! $result = @mysql_query("SELECT * FROM ".$table." WHERE ".$column['hide']."='0' order by ".$column['name'].""); ! if(mysql_error()){ ! $error_report .= "<br><li>".mysql_error()."</li>"; ! }else{ ! $company_exists = mysql_numrows($result); ! for ($i = 0 ;$i < $company_exists; $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']); ! $companyLogo = mysql_result($result, $i, $column['logo']); ! $companyState = mysql_result($result, $i, $column['state']); ! $companyDefaultCountry = mysql_result($result, $i, $column['defaultcountry']); ! } ! } ! ! if($currentlang == ""){ ! $currentlang = $companyDefaultCountry; ! } ! if(is_file($companyLogo)){ ! $companyLogo = "<p><img src=\"".$companyLogo."\"></p>"; ! }else{ ! $companyLogo = ""; ! } ! $city = getCity($prefix,$companyCity); ! $lang = "_COUNTRY_".strtoupper($companyCountry); ! $all = get_defined_constants(); ! $companyCountry = $all[$lang]; ! if($mode == ""){ ! $table = $pntable['departments_table']; ! $column = &$pntable['departments']; ! $result = mysql_query("SELECT * FROM ".$table." WHERE (".$column['hide']."='0') and (".$column['cid']."='$currentlang' or ".$column['cid']."='all') order by ".$column['name'].""); ! if(mysql_error()){ ! $error_report .= "<br><li>".mysql_error()."</li>"; ! }else{ ! $departments_exists = mysql_numrows($result); ! if(!$departments_exists){ ! $mode = 1; ! $NoInfoExtraText = "<p><font class=\"pn-normal\">"._CIYOUAREALWAYSWELCOME."</font></p>"; ! } ! } ! } ! if($mode == ""){ ! // PAGE ONE FOR COMPANY CONTACT INFORMATION ! if($departments_exists){ ! echo mysql_error(); ! if($departments_exists > 0){ ! echo "<link rel=\"StyleSheet\" href=\"modules/$ModName/css/style.css\" type=\"text/css\"><p><b><font class=\"pn-title\">"._CICONTACT." ".$companyName."</font></b></p>".$companyLogo; ! echo "<p><font class=\"pn-normal\">"._CIYOUAREALWAYSWELCOME."</font></p>"; ! echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">"; ! for ($i = 0 ;$i < $departments_exists; $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']); ! if(!$departmentFax){ ! $departmentFax = $companyFax; ! } ! if(!$departmentPhone){ ! $departmentPhone = $companyPhone; ! } ! if(!$departmentEmail){ ! $departmentEmail = $companyMail; ! } ! $lang = "_COUNTRY_".strtoupper($departmentCountry); ! $all = get_defined_constants(); ! $departmentCountry = $all[$lang]; ! echo " ! <tr> ! <td width=\"10\" align=\"center\" class=\"ContactInfoHeader\"><font class=\"ContactInfoHeader\">"._CIBULLET."</font></td> ! <td nowrap=\"nowrap\" class=\"ContactInfoHeader\"><font class=\"ContactInfoHeader\"><b>".$departmentName."</b></font></td> ! <td width=\"15\"><a href=\"javascript:ShowForm('','$departmentID','');\"><img src=\"modules/$ModName/images/friend.gif\" width=\"15\" height=\"11\" border=\"0\" /></a></td> ! </tr><tr> ! <td width=\"10\" align=\"center\"> </td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\"><b>"._CIMAIL.":</b> ".$departmentEmail."</font></td> ! <td width=\"15\"> </td> ! </tr><tr> ! <td width=\"10\" align=\"center\"> </td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\"><b>"._CIPHONE.":</b> ".$departmentPhone."<br /> </font></td> ! <td width=\"15\"> </td> ! </tr> ! "; ! } ! echo "</table>"; ! } ! if(($company_exists) or ($persons_exists)){ ! echo "<p><font class=\"pn-normal\">"._CIDOYOUNEEDFURTHERINFO1." ".$companyName.", "._CIDOYOUNEEDFURTHERINFO2." <a href=\"".$PHP_SELF."?op=modload&name=".$ModName."&file=".$GLOBALS['file']."&mode=2\">"._CIDOYOUNEEDFURTHERINFO3."</a>.</font></p>"; ! } ! }else{ ! if($company_exists){ ! echo "<p><font class=\"pn-normal\">"._CIDOYOUNEEDFURTHERINFO1." ".$companyName.", "._CIDOYOUNEEDFURTHERINFO2." <a href=\"".$PHP_SELF."?op=modload&name=".$ModName."&file=".$GLOBALS['file']."&mode=2\">"._CIDOYOUNEEDFURTHERINFO3."</a>.</font></p>"; ! }else{ ! echo "<p><font class=\"pn-normal\">"._CINOCOMPANY_EXISTS_."</font></p>"; ! } ! } ! }else{ ! ! // PAGE TWO FOR COMPANY CONTACT INFORMATION IF THE COMPANY POST IS ACTIVE THEN DISPLAY THE INFORMATION ! if($company_exists){ ! echo "<link rel=\"StyleSheet\" href=\"modules/$ModName/css/style.css\" type=\"text/css\">"; ! ! echo "<p><b><font class=\"pn-title\">"._CICONTACTINFOFOR." ".$sitename."</font></b></p>"; ! // if($companyName){ ! // echo "<p><b><font class=\"pn-title\">"._CICONTACTINFOFOR." ".$companyName."</font></b></p>"; ! // } ! echo "<table><tr><td>$companyLogo</td><td> </td><td><table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">"; ! if($companyName){ ! echo "<tr><td colspan=\"4\" nowrap=\"nowrap\" class=\"ContactInfoHeader\"><font class=\"ContactInfoHeader\"><b>".$companyName."</b></font></td></tr>"; ! } ! if($companyAddress or $companyZip or $city['name'] or $companyState){ ! echo "<tr><td colspan=\"4\" nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">".$companyAddress; ! if($companyAddress && $companyZip){ ! echo ", "; ! } ! echo $companyZip; ! if(($companyZip && $city['name']) or ($companyAddress && $city['name'])){ ! echo " "; ! } ! echo $city['name']; ! ! if($companyAddress or $companyZip or $city['name']){ ! echo ", "; ! } ! echo $companyState; ! echo "</font></td></tr>"; ! } ! if($companyCountry){ ! echo "<tr><td colspan=\"4\" nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">".$companyCountry."</font></td></tr>"; ! } ! if($companyPhone || $companyFax || $companyMail){ ! echo "<tr><td colspan=\"4\" nowrap=\"nowrap\"><img src=\"modules/$ModName/images/dots.gif\" width=\"207\" height=\"1\" border=\"0\" /></td></tr>"; ! if($companyPhone){ ! echo " ! <tr> ! <td width=\"30\" nowrap=\"nowrap\"> </td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><b><font class=\"ContactInfoText\">"._CIPHONE.": </b></font></td> ! <td colspan=\"2\" nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">".$companyPhone."</font></td> ! </tr> ! "; ! } ! if($companyFax){ ! echo " ! <tr> ! <td width=\"30\" nowrap=\"nowrap\"> </td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\"><b>"._CIFAX.": </b></font></td> ! <td colspan=\"2\" nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">".$companyFax."</font></td> ! </tr> ! "; ! } ! if($companyMail){ ! echo " ! <tr> ! <td width=\"30\" nowrap=\"nowrap\"> </td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><b><font class=\"ContactInfoText\">"._CIEMAIL.": </b></font></td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">".$companyMail."</font></td> ! <td nowrap=\"nowrap\"><a href=\"javascript:ShowForm('','','');\"><img src=\"modules/$ModName/images/friend.gif\" width=\"15\" height=\"11\" align=\"absmiddle\" border=\"0\" /></a></td> ! </tr> ! "; ! } ! } ! echo "</table></td></tr></table>"; ! if($companyPhone || $companyFax || $companyMail || $companyAddress || $companyZip || $companyCountry || $city['name'] || $companyName){ ! echo "<hr />"; ! } ! } ! ! echo $NoInfoExtraText; ! ! // query from both persons and attributes tables ! $table = $pntable['persons_table']; ! $column = &$pntable['person']; ! $table2 = $pntable['attributes_table']; ! $column2 = &$pntable['attribute']; ! $contactType = "P"; ! $query = "SELECT * FROM ".$table.", ".$table2. ! " WHERE (".$column['hide']."='1')" . ! " AND (".$column['lang']."='".$currentlang."' or ".$column['lang']."='all')" . ! " AND ".$column['id']."=".$column2['id']. ! " AND ".$column2['contacttype']."='".$contactType."'" . ! " ORDER BY ".$column['firstname'].""; ! $membersInDepartment = @mysql_query($query); ! if(mysql_error()){ ! $error_report .= "<br><li>".mysql_error()."</li>"; ! echo "<p>".$query."</p>"; ! }else{ ! $members = mysql_numrows($membersInDepartment); ! } ! if($members > 0){ ! echo "<p><font class=\"pn-normal\">"._CIIFYOUKNOWWHOTOCONTACT."</font></p><table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">"; ! for ($x = 0 ;$x < $members; $x++){ ! $personID = mysql_result($membersInDepartment, $x, $column['id']); ! $personFirstName = mysql_result($membersInDepartment, $x, $column['firstname']); ! $personLastName = mysql_result($membersInDepartment, $x, $column['lastname']); ! $personMail = mysql_result($membersInDepartment, $x, $column['mail']); ! $personMobile = mysql_result($membersInDepartment, $x, $column['mobile']); ! $personPhone = mysql_result($membersInDepartment, $x, $column['phone']); ! $personAddress = mysql_result($membersInDepartment, $x, $column['address']); ! $personCountry = mysql_result($membersInDepartment, $x, $column['country']); ! $personCounpersonFaxtry = mysql_result($membersInDepartment, $x, $column['fax']); ! $personTitleID = mysql_result($membersInDepartment, $x, $column['titleID']); ! $attributeShowName = mysql_result($membersInDepartment, $x, $column2['showname']); ! $attributeShowAddress = mysql_result($membersInDepartment, $x, $column2['showaddress']); ! $attributeShowAddress2 = mysql_result($membersInDepartment, $x, $column2['showaddress2']); ! $attributeShowZip = mysql_result($membersInDepartment, $x, $column2['showzip']); ! $attributeShowCity = mysql_result($membersInDepartment, $x, $column2['showcity']); ! $attributeShowCountry = mysql_result($membersInDepartment, $x, $column2['showcountry']); ! $attributeShowPhone = mysql_result($membersInDepartment, $x, $column2['showphone']); ! $attributeShowFax = mysql_result($membersInDepartment, $x, $column2['showfax']); ! $attributeShowMobile = mysql_result($membersInDepartment, $x, $column2['showmobile']); ! $attributeShowPager = mysql_result($membersInDepartment, $x, $column2['showpager']); ! $attributeShowEmail = mysql_result($membersInDepartment, $x, $column2['showemail']); ! $attributeShowICQ = mysql_result($membersInDepartment, $x, $column2['showICQ']); ! $attributeShowAIM = mysql_result($membersInDepartment, $x, $column2['showAIM']); ! $attributeShowYIM = mysql_result($membersInDepartment, $x, $column2['showYIM']); ! $attributeShowMSNM = mysql_result($membersInDepartment, $x, $column2['showMSNM']); ! $attributeShowTitle = mysql_result($membersInDepartment, $x, $column2['showtitle']); ! $attributeShowState = mysql_result($membersInDepartment, $x, $column2['showState']); ! $attributeShowDepartment = mysql_result($membersInDepartment, $x, $column2['showdepartment']); ! if(($attributeShowEmail == "0") or (strlen($personMail) < 3)){ ! $personMail = $companyMail; ! } ! ! $personTitle = getTitle($prefix,$personTitleID); ! ! if(!$attributeShowTitle){ ! $personTitle = ""; ! } ! ! echo " ! <tr> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">".$personFirstName." ".$personLastName."</font></td> ! <td class=\"ContactInfoText\"><b><font class=\"ContactInfoText\">".$personTitle['name']."</b></font></td> ! <td align=\"center\" valign=\"middle\"><a href=\"javascript:ShowUser('".$personID."','','');\"><img src=\"modules/$ModName/images/questionmark.gif\" width=\"14\" height=\"14\" align=\"absmiddle\" border=\"0\" /></a></td> ! <td align=\"center\" valign=\"middle\">"; ! if(checkMailInfo($personID) == TRUE){ ! echo "<a href=\"javascript:ShowForm('".$personID."','','');\"><img src=\"modules/$ModName/images/friend.gif\" width=\"15\" height=\"11\" border=\"0\" /></a>"; ! } ! echo "</td></tr>"; ! ! if($personMail){ ! echo "<tr> ! <td colspan=\"4\" nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\"><b>"._CIEMAIL.": </b>".$personMail."</font></td> ! </tr>"; ! } ! echo " ! <tr> ! <td colspan=\"4\"><hr /></td> ! </tr>"; ! } ! echo "</table>"; ! } ! } ! if($error_report){ ! openTable(); ! echo $error_report; ! closeTable(); ! } } theindex($GLOBALS['mode']); --- 40,396 ---- function theindex($mode=''){ ! global $ModName,$sitename; ! list($dbconn) = pnDBGetConn(); ! $pntable = PostContact_pntables(); ! $prefix = pnConfigGetVar('prefix'); ! $sitename = pnConfigGetVar('sitename'); ! $table = $pntable['persons_table']; ! $column = &$pntable['person']; ! $query = "SELECT ".$column['id']. ! " FROM ".$table." WHERE (".$column['hide']."='1') and (".$column['lang']."='$currentlang' or ".$column['lang']."='all') ORDER BY ".$column['firstname'].""; ! $result = $dbconn->Execute( $query ); ! if ( $result == false ) { ! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" ); ! } ! if( $result->EOF ) { ! $persons_exists = false; ! } else { ! $persons_exists = true; ! } ! ! $table = $pntable['company_table']; ! $column = &$pntable['company']; ! $currentlang = pnUserGetLang(); ! $query = "SELECT ".$column['name']. ! ", ".$column['address'].", ".$column['address2']. ! ", ".$column['city'].", ".$column['state']. ! ", ".$column['zip'].", ".$column['country']. ! ", ".$column['phone']. ! ", ".$column['fax'].", ".$column['mail']. ! ", ".$column['logo'].", ".$column['defaultcountry']. ! " 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" ); ! } ! if( $result->EOF ) { ! $company_exists = false; ! } else { ! $company_exists = true; ! 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]; ! $companyDefaultCountry = $result->fields[11]; ! } ! } ! ! if($currentlang == ""){ ! $currentlang = $companyDefaultCountry; ! } ! if(is_file($companyLogo)){ ! $companyLogo = "<p><img src=\"".$companyLogo."\"></p>"; ! }else{ ! $companyLogo = ""; ! } ! $city = getCity($prefix,$companyCity); ! $lang = "_COUNTRY_".strtoupper($companyCountry); ! $all = get_defined_constants(); ! $companyCountry = $all[$lang]; ! if($mode == ""){ ! $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['hide']."='0') and (".$column['cid']."='$currentlang' or ".$column['cid']."='all')". ! " order by ".$column['name'].""; ! $result = $dbconn->Execute( $query ); ! if ( $result == false ) { ! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" ); ! } ! if( !$result->EOF ) { ! $departments_exists = true; ! } else { ! $departments_exists = false; ! $mode = 1; ! $NoInfoExtraText = "<p><font class=\"pn-normal\">"._CIYOUAREALWAYSWELCOME."</font></p>"; ! } ! } // if($mode == "") + if($mode == ""){ + // PAGE ONE FOR COMPANY CONTACT INFORMATION + if($departments_exists){ + echo "<link rel=\"StyleSheet\" href=\"modules/$ModName/css/style.css\" type=\"text/css\"><p><b><font class=\"pn-title\">"._CICONTACT." ".$companyName."</font></b></p>".$companyLogo; + echo "<p><font class=\"pn-normal\">"._CIYOUAREALWAYSWELCOME."</font></p>"; + echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">"; + 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]; + if(!$departmentFax){ + $departmentFax = $companyFax; + } + if(!$departmentPhone){ + $departmentPhone = $companyPhone; + } + if(!$departmentEmail){ + $departmentEmail = $companyMail; + } + $lang = "_COUNTRY_".strtoupper($departmentCountry); + $all = get_defined_constants(); + $departmentCountry = $all[$lang]; ! echo " ! <tr> ! <td width=\"10\" align=\"center\" class=\"ContactInfoHeader\"><font class=\"ContactInfoHeader\">"._CIBULLET."</font></td> ! <td nowrap=\"nowrap\" class=\"ContactInfoHeader\"><font class=\"ContactInfoHeader\"><b>".$departmentName."</b></font></td> ! <td width=\"15\"><a href=\"javascript:ShowForm('','$departmentID','');\"><img src=\"modules/$ModName/images/friend.gif\" width=\"15\" height=\"11\" border=\"0\" /></a></td> ! </tr><tr> ! <td width=\"10\" align=\"center\"> </td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\"><b>"._CIMAIL.":</b> ".$departmentEmail."</font></td> ! <td width=\"15\"> </td> ! </tr><tr> ! <td width=\"10\" align=\"center\"> </td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\"><b>"._CIPHONE.":</b> ".$departmentPhone."<br /> </font></td> ! <td width=\"15\"> </td> ! </tr> ! "; ! } ! echo "</table>"; ! } ! if(($company_exists) or ($persons_exists)){ ! echo "<p><font class=\"pn-normal\">"._CIDOYOUNEEDFURTHERINFO1." ".$companyName.", "._CIDOYOUNEEDFURTHERINFO2." <a href=\"".$PHP_SELF."?op=modload&name=".$ModName."&file=".$GLOBALS['file']."&mode=2\">"._CIDOYOUNEEDFURTHERINFO3."</a>.</font></p>"; ! }else if($company_exists){ ! echo "<p><font class=\"pn-normal\">"._CIDOYOUNEEDFURTHERINFO1." ".$companyName.", "._CIDOYOUNEEDFURTHERINFO2." <a href=\"".$PHP_SELF."?op=modload&name=".$ModName."&file=".$GLOBALS['file']."&mode=2\">"._CIDOYOUNEEDFURTHERINFO3."</a>.</font></p>"; ! }else{ ! echo "<p><font class=\"pn-normal\">"._CINOCOMPANY_EXISTS_."</font></p>"; ! } ! }else{ ! // PAGE TWO FOR COMPANY CONTACT INFORMATION IF THE COMPANY POST IS ACTIVE THEN DISPLAY THE INFORMATION ! if($company_exists){ ! echo "<link rel=\"StyleSheet\" href=\"modules/$ModName/css/style.css\" type=\"text/css\">"; ! ! echo "<p><b><font class=\"pn-title\">"._CICONTACTINFOFOR." ".$sitename."</font></b></p>"; ! // if($companyName){ ! // echo "<p><b><font class=\"pn-title\">"._CICONTACTINFOFOR." ".$companyName."</font></b></p>"; ! // } ! echo "<table><tr><td>$companyLogo</td><td> </td><td><table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">"; ! if($companyName){ ! echo "<tr><td colspan=\"4\" nowrap=\"nowrap\" class=\"ContactInfoHeader\"><font class=\"ContactInfoHeader\"><b>".$companyName."</b></font></td></tr>"; ! } ! if($companyAddress or $companyState or $companyZip or $city['name']){ ! echo "<tr><td colspan=\"4\" nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">".$companyAddress; ! if($companyAddress && $city['name']){ ! echo ", "; ! } ! echo $city['name']; ! if($city['name'] && $companyState){ ! echo ", "; ! } ! echo $companyState; ! //if(($companyState && $companyZip) or ($companyAddress && $companyZip)){ ! echo " "; ! //} ! echo $companyZip."</font></td></tr>"; ! } ! if($companyCountry){ ! echo "<tr><td colspan=\"4\" nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">".$companyCountry."</font></td></tr>"; ! } ! if($companyPhone || $companyFax || $companyMail){ ! echo "<tr><td colspan=\"4\" nowrap=\"nowrap\"><img src=\"modules/$ModName/images/dots.gif\" width=\"207\" height=\"1\" border=\"0\" /></td></tr>"; ! if($companyPhone){ ! echo " ! <tr> ! <td width=\"30\" nowrap=\"nowrap\"> </td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><b><font class=\"ContactInfoText\">"._CIPHONE.": </b></font></td> ! <td colspan=\"2\" nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">".$companyPhone."</font></td> ! </tr> ! "; ! } ! if($companyFax){ ! echo " ! <tr> ! <td width=\"30\" nowrap=\"nowrap\"> </td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\"><b>"._CIFAX.": </b></font></td> ! <td colspan=\"2\" nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">".$companyFax."</font></td> ! </tr> ! "; ! } ! if($companyMail){ ! echo " ! <tr> ! <td width=\"30\" nowrap=\"nowrap\"> </td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><b><font class=\"ContactInfoText\">"._CIEMAIL.": </b></font></td> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\">".$companyMail."</font></td> ! <td nowrap=\"nowrap\"><a href=\"javascript:ShowForm('','','');\"><img src=\"modules/$ModName/images/friend.gif\" width=\"15\" height=\"11\" align=\"absmiddle\" border=\"0\" /></a></td> ! </tr> ! "; ! } ! } ! echo "</table></td></tr></table>"; ! if($companyPhone || $companyFax || $companyMail || $companyAddress || $companyZip || $companyCountry || $city['name'] || $companyName){ ! echo "<hr />"; ! } ! } ! ! echo $NoInfoExtraText; ! ! // query from both persons and attributes tables ! $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['typepager']. ", ".$column['typemobile']. ! ", ".$column['titleID']. ! ", ".$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['hide']."='1')" . ! " AND (".$column['lang']."='".$currentlang."' or ".$column['lang']."='all')" . ! " AND ".$column['id']."=".$column2['id']. ! " AND ".$column2['contacttype']."='".$contactType."'" . ! " ORDER BY ".$column['firstname']; ! $result = $dbconn->Execute( $query ); ! if ( $result == false ) { ! PN_DBMsgError( $dbconn, __FILE__, __LINE__, "Error accessing the database" ); ! } ! if( !$result->EOF ) { ! echo "<p><font class=\"pn-normal\">"._CIIFYOUKNOWWHOTOCONTACT."</font></p><table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">"; ! 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]; ! $personTypePager = $result->fields[23]; ! $personTypeMobile = $result->fields[24]; ! $personTitleID = $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]; ! if(($attributeShowEmail == "0") or (strlen($personMail) < 3)){ ! $personMail = $companyMail; ! } ! ! $personTitle = getTitle($prefix,$personTitleID); ! ! if(!$attributeShowTitle){ ! $personTitle = ""; ! } ! ! echo " ! <tr> ! <td nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\"><a href=\"javascript:ShowUser('".$personID."','','');\">".$personFirstName." ".$personLastName."</a></font></td> ! <td class=\"ContactInfoText\"><b><font class=\"ContactInfoText\">".$personTitle['name']."</b></font></td> ! <td align=\"center\" valign=\"middle\"><a href=\"javascript:ShowUser('".$personID."','','');\"><img src=\"modules/$ModName/images/questionmark.gif\" width=\"14\" height=\"14\" align=\"absmiddle\" border=\"0\" /></a></td> ! <td align=\"center\" valign=\"middle\">"; ! if(checkMailInfo($personID) == TRUE){ ! echo "<a href=\"javascript:ShowForm('".$personID."','','');\"><img src=\"modules/$ModName/images/friend.gif\" width=\"15\" height=\"11\" border=\"0\" /></a>"; ! } // for (; !$result->EOF; $result->MoveNext() ) ! echo "</td></tr>"; ! ! if($personMail){ ! echo "<tr> ! <td colspan=\"4\" nowrap=\"nowrap\" class=\"ContactInfoText\"><font class=\"ContactInfoText\"><b>"._CIEMAIL.": </b>".$personMail."</font></td> ! </tr>"; ! } ! ! echo " ! <tr> ! <td colspan=\"4\"><hr /></td> ! </tr>"; ! } ! echo "</table>"; ! } ! } ! if($error_report){ ! openTable(); ! echo $error_report; ! closeTable(); ! } } theindex($GLOBALS['mode']); Index: pninit.php =================================================================== RCS file: /home/cvsroot/postnuke_modules/PostContact/pninit.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** pninit.php 23 Jul 2002 11:49:56 -0000 1.2 --- pninit.php 6 Aug 2002 20:18:27 -0000 1.3 *************** *** 1,326 **** <? // $Id$ $Name$ if(basename($PHP_SELF) == basename(__FILE__)){ ! echo "You have no access to this file!!!"; ! exit; } function PostContact_init(){ ! list($dbconn) = pnDBGetConn(); ! $pntable = pnDBGetTables(); [...1255 lines suppressed...] ! pnSessionSetVar('errormsg', _DROPTABLEFAILED); ! return false; ! } $sql = "DROP TABLE IF EXISTS ".$pntable['countrymembers_table']; ! $result = $dbconn->Execute( $sql ); ! if ($result == false) { ! pnSessionSetVar('errormsg', _DROPTABLEFAILED); ! return false; ! } $sql = "DROP TABLE IF EXISTS ".$pntable['company_table']; ! $result = $dbconn->Execute( $sql ); ! if ($result == false) { ! pnSessionSetVar('errormsg', _DROPTABLEFAILED); ! return false; ! } ! ! return true; } ! ?> Index: pntables.php =================================================================== RCS file: /home/cvsroot/postnuke_modules/PostContact/pntables.php,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** pntables.php 23 Jul 2002 11:51:09 -0000 1.2 --- pntables.php 6 Aug 2002 20:18:27 -0000 1.3 *************** *** 1,4 **** --- 1,28 ---- <? // $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: Table information for template module + // ---------------------------------------------------------------------- + if(basename($PHP_SELF) == basename(__FILE__)){ echo "You have no access to this file!!!"; *************** *** 7,227 **** function PostContact_pntables(){ ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: $pntable = array(); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_departments ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $departments = pnConfigGetVar('prefix') . '_postcontact_departments'; ! $pntable['departments_table'] = $departments; ! $pntable['departments'] = array( ! 'id' => $departments . '.departmentID', ! 'email' => $departments . '.departmentEmail', ! 'name' => $departments . '.departmentName', ! 'phone' => $departments . '.departmentPhone', ! 'fax' => $departments . '.departmentFax', ! 'state' => $departments . '.departmentState', ! 'country' => $departments . '.departmentCountry', ! 'cid' => $departments . '.countryID', ! 'hide' => $departments . '.departmentHide' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_departments_members ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $departments_members = pnConfigGetVar('prefix') . '_postcontact_departments_members'; ! $pntable['department_members_table'] = $departments_members; ! $pntable['department_members'] = array( ! 'id' => $departments_members . '.personID', ! 'depid' => $departments_members . '.departmentID' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_titles ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $titles = pnConfigGetVar('prefix') . '_postcontact_titles'; ! $pntable['titles_table'] = $titles; ! $pntable['titles'] = array( ! 'id' => $titles . '.titleID', ! 'name' => $titles . '.titleName', ! 'cid' => $titles . '.countryID' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_city ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $city = pnConfigGetVar('prefix') . '_postcontact_city'; ! $pntable['city_table'] = $city; ! $pntable['city'] = array( ! 'id' => $city . '.cityID', ! 'name' => $city . '.cityName', ! 'cid' => $city . '.countryID' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_country ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $city = pnConfigGetVar('prefix') . '_postcontact_country'; ! $pntable['country_table'] = $city; ! $pntable['country'] = array( ! 'id' => $city . '.countryID', ! 'name' => $city . '.countryName', ! 'lang' => $city . '.countryLang' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_infoType ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $infoType = pnConfigGetVar('prefix') . '_postcontact_infoType'; ! $pntable['infotype_table'] = $infoType; ! $pntable['infotype'] = array( ! 'id' => $infoType . '.typeID', ! 'name' => $infoType . '.typeName', ! 'cid' => $infoType . '.countryID' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_persons ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $person = pnConfigGetVar('prefix') . '_postcontact_persons'; ! $pntable['persons_table'] = $person; ! $pntable['person'] = array( ! 'id' => $person . '.personID', ! 'mail' => $person . '.personMail', ! 'firstname' => $person . '.personFirstName', ! 'lastname' => $person . '.personLastName', ! 'mobile' => $person . '.personMobile', ! 'phone' => $person . '.personPhone', ! 'address' => $person . '.personAddress', ! 'country' => $person . '.personCountry', ! 'lang' => $person . '.personLang', ! 'fax' => $person . '.personFax', ! 'hide' => $person . '.personHide', ! 'city' => $person . '.personCity', ! 'image' => $person . '.personImage', ! 'pager' => $person . '.personPager', ! 'ICQ' => $person . '.personICQ', ! 'AIM' => $person . '.personAIM', ! 'YIM' => $person . '.personYIM', ! 'state' => $person . '.personState', ! 'MSNM' => $person . '.personMSNM', ! 'address2' => $person . '.personAddress2', ! 'typephone' => $person . '.personTypePhone', ! 'typefax' => $person . '.personTypeFax', ! 'titleID' => $person . '.personTitleID', ! 'typepager' => $person . '.personTypePager', 'typemobile' => $person . '.personTypeMobile', ! 'zip' => $person . '.personZip' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // attributes ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $attribute = pnConfigGetVar('prefix') . '_postcontact_attributes'; // Set the table name ! $pntable['attributes_table'] = $attribute; // Set the column names ! $pntable['attribute'] = array( ! 'id' => $attribute . '.attributeID', ! 'contacttype' => $attribute . '.attributeContactType', ! 'showname' => $attribute . '.attributeShowName', ! 'showaddress' => $attribute . '.attributeShowAddress', ! 'showaddress2' => $attribute . '.attributeShowAddress2', ! 'showzip' => $attribute . '.attributeShowZip', ! 'showcountry' => $attribute . '.attributeShowCountry', ! 'showphone' => $attribute . '.attributeShowPhone', ! 'showfax' => $attribute . '.attributeShowFax', ! 'showmobile' => $attribute . '.attributeShowMobile', ! 'showpager' => $attribute . '.attributeShowPager', ! 'showemail' => $attribute . '.attributeShowEmail', ! 'showtitle' => $attribute . '.attributeShowTitle', ! 'showICQ' => $attribute . '.attributeShowICQ', ! 'showAIM' => $attribute . '.attributeShowAIM', ! 'showYIM' => $attribute . '.attributeShowYIM', ! 'showState' => $attribute . '.attributeShowState', ! 'showMSNM' => $attribute . '.attributeShowMSNM', ! 'showcity' => $attribute . '.attributeShowCity', ! 'showdepartment' => $attribute . '.attributeShowDepartment', ! 'showimage' => $attribute . '.attributeShowImage' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_company_prefs ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $company = pnConfigGetVar('prefix') . '_postcontact_company_prefs'; ! $pntable['company_table'] = $company; ! $pntable['company'] = array( ! 'id' => $company . '.companyID', ! 'name' => $company . '.companyName', ! 'phone' => $company . '.companyPhone', ! 'fax' => $company . '.companyFax', ! 'mail' => $company . '.companyMail', ! 'address' => $company . '.companyAddress', ! 'address2' => $company . '.companyAddress2', ! 'zip' => $company . '.companyZip', ! 'logo' => $company . '.companyLogo', ! 'country' => $company . '.companyCountry', ! 'state' => $company . '.companyState', ! 'hide' => $company . '.companyHide', ! 'defaultcountry' => $company . '.companyDefaultCountry', ! 'city' => $company . '.companyCity' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_lang_members ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $langmembers = pnConfigGetVar('prefix') . '_postcontact_lang_members'; ! $pntable['langmembers_table'] = $langmembers; ! $pntable['langmembers'] = array( ! 'id' => $langmembers . '.personID', ! 'cid' => $langmembers . '.countryID' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_country_members ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $countrymembers = pnConfigGetVar('prefix') . '_postcontact_country_members'; ! $pntable['countrymembers_table'] = $countrymembers; ! $pntable['countrymembers'] = array( ! 'id' => $countrymembers . '.personID', ! 'cid' => $countrymembers . '.countryID' ! ); ! return $pntable; } ?> --- 31,252 ---- function PostContact_pntables(){ ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: $pntable = array(); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_departments ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $departments = pnConfigGetVar('prefix') . '_postcontact_departments'; ! $pntable['departments_table'] = $departments; ! $pntable['departments'] = array( ! 'id' => $departments . '.departmentID', ! 'email' => $departments . '.departmentEmail', ! 'name' => $departments . '.departmentName', ! 'phone' => $departments . '.departmentPhone', ! 'fax' => $departments . '.departmentFax', ! 'state' => $departments . '.departmentState', ! 'country' => $departments . '.departmentCountry', ! 'cid' => $departments . '.countryID', ! 'hide' => $departments . '.departmentHide' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_departments_members ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $departments_members = pnConfigGetVar('prefix') . '_postcontact_departments_members'; ! $pntable['department_members_table'] = $departments_members; ! $pntable['department_members'] = array( ! 'id' => $departments_members . '.personID', ! 'depid' => $departments_members . '.departmentID' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_titles ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $titles = pnConfigGetVar('prefix') . '_postcontact_titles'; ! $pntable['titles_table'] = $titles; ! $pntable['titles'] = array( ! 'id' => $titles . '.titleID', ! 'name' => $titles . '.titleName', ! 'cid' => $titles . '.countryID' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_city ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $city = pnConfigGetVar('prefix') . '_postcontact_city'; ! $pntable['city_table'] = $city; ! $pntable['city'] = array( ! 'id' => $city . '.cityID', ! 'name' => $city . '.cityName', ! 'cid' => $city . '.countryID' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_country ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $city = pnConfigGetVar('prefix') . '_postcontact_country'; ! $pntable['country_table'] = $city; ! $pntable['country'] = array( ! 'id' => $city . '.countryID', ! 'name' => $city . '.countryName', ! 'lang' => $city . '.countryLang' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_infoType ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $infoType = pnConfigGetVar('prefix') . '_postcontact_infoType'; ! $pntable['infotype_table'] = $infoType; ! $pntable['infotype'] = array( ! 'id' => $infoType . '.typeID', ! 'name' => $infoType . '.typeName', ! 'cid' => $infoType . '.countryID' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_persons ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $person = pnConfigGetVar('prefix') . '_postcontact_persons'; ! $pntable['persons_table'] = $person; ! $pntable['person'] = array( ! 'id' => $person . '.personID', ! 'firstname' => $person . '.personFirstName', ! 'lastname' => $person . '.personLastName', ! 'address' => $person . '.personAddress', ! 'address2' => $person . '.personAddress2', ! 'city' => $person . '.personCity', ! 'state' => $person . '.personState', ! 'zip' => $person . '.personZip', ! 'country' => $person . '.personCountry', ! 'mail' => $person . '.personMail', ! 'phone' => $person . '.personPhone', ! 'fax' => $person . '.personFax', ! 'mobile' => $person . '.personMobile', ! 'pager' => $person . '.personPager', ! 'typephone' => $person . '.personTypePhone', ! 'typefax' => $person . '.personTypeFax', 'typemobile' => $person . '.personTypeMobile', ! 'typepager' => $person . '.personTypePager', ! 'lang' => $person . '.personLang', ! 'ICQ' => $person . '.personICQ', ! 'AIM' => $person . '.personAIM', ! 'YIM' => $person . '.personYIM', ! 'MSNM' => $person . '.personMSNM', ! 'titleID' => $person . '.personTitleID', ! 'image' => $person . '.personImage', ! 'hide' => $person . '.personHide' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // attributes ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $attribute = pnConfigGetVar('prefix') . '_postcontact_attributes'; // Set the table name ! $pntable['attributes_table'] = $attribute; // Set the column names ! $pntable['attribute'] = array( ! 'id' => $attribute . '.attributeID', ! 'contacttype' => $attribute . '.attributeContactType', ! 'showname' => $attribute . '.attributeShowName', ! 'showaddress' => $attribute . '.attributeShowAddress', ! 'showaddress2' => $attribute . '.attributeShowAddress2', ! 'showcity' => $attribute . '.attributeShowCity', ! 'showstate' => $attribute . '.attributeShowState', ! 'showzip' => $attribute . '.attributeShowZip', ! 'showcountry' => $attribute . '.attributeShowCountry', ! 'showemail' => $attribute . '.attributeShowEmail', ! 'showphone' => $attribute . '.attributeShowPhone', ! 'showfax' => $attribute . '.attributeShowFax', ! 'showmobile' => $attribute . '.attributeShowMobile', ! 'showpager' => $attribute . '.attributeShowPager', ! 'showICQ' => $attribute . '.attributeShowICQ', ! 'showAIM' => $attribute . '.attributeShowAIM', ! 'showYIM' => $attribute . '.attributeShowYIM', ! 'showMSNM' => $attribute . '.attributeShowMSNM', ! 'showtitle' => $attribute . '.attributeShowTitle', ! 'showdepartment' => $attribute . '.attributeShowDepartment', ! 'showimage' => $attribute . '.attributeShowImage' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_company_prefs ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $company = pnConfigGetVar('prefix') . '_postcontact_company_prefs'; ! $pntable['company_table'] = $company; ! $pntable['company'] = array( ! 'id' => $company . '.companyID', ! 'name' => $company . '.companyName', ! 'address' => $company . '.companyAddress', ! 'address2' => $company . '.companyAddress2', ! 'city' => $company . '.companyCity', ! 'state' => $company . '.companyState', ! 'zip' => $company . '.companyZip', ! 'country' => $company . '.companyCountry', ! 'phone' => $company . '.companyPhone', ! 'fax' => $company . '.companyFax', ! 'mail' => $company . '.companyMail', ! 'logo' => $company . '.companyLogo', ! 'hide' => $company . '.companyHide', ! 'defaultcountry' => $company . '.companyDefaultCountry' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_lang_members ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $langmembers = pnConfigGetVar('prefix') . '_postcontact_lang_members'; ! $pntable['langmembers_table'] = $langmembers; ! $pntable['langmembers'] = array( ! 'id' => $langmembers . '.personID', ! 'cid' => $langmembers . '.countryID' ! ); ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ! // ============================== NEXT TABLE =============================== ! // contact_country_members ! // ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: // Get the name for the template item table. This is not necessary // but helps in the following statements and keeps them readable ! $countrymembers = pnConfigGetVar('prefix') . '_postcontact_country_members'; ! $pntable['countrymembers_table'] = $countrymembers; ! $pntable['countrymembers'] = array( ! 'id' => $countrymembers . '.personID', ! 'cid' => $countrymembers . '.countryID' ! ); ! ! return $pntable; } ?>
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 |