fullname . "\" AND contact.hidden != 1 ORDER BY fullname DESC LIMIT 1", $db_link) or die(reportSQLError()); $t_prev = mysql_fetch_array($r_prev); $prev = $t_prev['id']; if ($prev<1) $prev = $id; $r_next = mysql_query("SELECT id, CONCAT(lastname,', ',firstname) AS fullname FROM " . TABLE_CONTACT . " AS contact WHERE CONCAT(lastname, ', ', firstname) > \"" . $contact->fullname . "\" AND contact.hidden != 1 ORDER BY fullname ASC LIMIT 1", $db_link) or die(reportSQLError()); $t_next = mysql_fetch_array($r_next); $next = $t_next['id']; if ($next<1) $next=$id; // PICTURE STUFF. // do we have a picture? if ($contact->picture_url) { $tableColumnAmt = 3; $tableColumnWidth = (540 - $options->picWidth) / 2; } else { if ($options->picAlwaysDisplay == 1) { $tableColumnAmt = 3; $tableColumnWidth = (540 - $options->picWidth) / 2; } else { $tableColumnAmt = 2; $tableColumnWidth = (540 / 2); } } ?> <?php echo $lang[TAB].' - '.$lang[TITLE_ADDRESS]. ' '.$contact->fullname; ?>
notes) { echo(" \n"); echo(" \n"); echo(" \n"); } ?>
lastname"); if ($contact->firstname) { echo(", $contact->firstname"); } if ($contact->middlename) { echo(" $contact->middlename"); } if ($contact->nickname) { echo(" \"$contact->nickname\""); } ?> hidden == 1) { echo("[HIDDEN ENTRY] "); } // LIST GROUPS $tbl_groups = mysql_fetch_array($r_groups); $groupname = stripslashes( $tbl_groups['groupname'] ); $group_id = $tbl_groups['groupid']; // check if no groups if ( !$groupname ) { echo("\"\""); // leaves a spacer image if no groups is assigned to the person. } // format for group links $Groups = "" . $groupname . ""; while ( $tbl_groups = mysql_fetch_array($r_groups) ) { $groupname = stripslashes( $tbl_groups['groupname'] ); $group_id = $tbl_groups['groupid']; $Groups = $Groups . ", " . $groupname . ""; } echo($Groups); ?>
picWidth>\n"); echo(" picture_url) { echo(PATH_MUGSHOTS . $contact->picture_url); } else { echo("images/nopicture.gif"); } echo("\" WIDTH=$options->picWidth HEIGHT=$options->picHeight BORDER=1 ALT=\"\">\n"); echo(" \n"); } echo(" \n"); // ** OTHER PHONE NUMBERS ** $tbl_otherPhone = mysql_fetch_array($r_otherPhone); $otherphone_phone = stripslashes( $tbl_otherPhone['phone'] ); $otherphone_type = stripslashes( $tbl_otherPhone['type'] ); if ($otherphone_phone) { echo("

\n$lang[LBL_OTHERPHONE]\n"); echo("
$otherphone_type: $otherphone_phone\n"); while ($tbl_otherPhone = mysql_fetch_array($r_otherPhone)) { $otherphone_phone = stripslashes( $tbl_otherPhone['phone'] ); $otherphone_type = stripslashes( $tbl_otherPhone['type'] ); echo("
$otherphone_type: $otherphone_phone\n"); } } // ** MESSAGING ** // A primitive version that does not output in desired format yet. // Would like it to be: //
AIM: name1, name2 //
ICQ: something $tbl_messaging = mysql_fetch_array($r_messaging); $messaging_handle = stripslashes( $tbl_messaging['handle'] ); $messaging_type = stripslashes( $tbl_messaging['type'] ); if ($messaging_handle) { echo("

\n$lang[LBL_MESSAGING]\n"); echo("
$messaging_type: $messaging_handle\n"); while ($tbl_messaging = mysql_fetch_array($r_messaging)) { $messaging_handle = stripslashes( $tbl_messaging['handle'] ); $messaging_type = stripslashes( $tbl_messaging['type'] ); echo("
$messaging_type: $messaging_handle\n"); } } ?>  

\n"); ?>
\n"); // ** ADDRESSES ** while ($tbl_address = mysql_fetch_array($r_address)) { $address_refid = $tbl_address['refid']; $address_type = stripslashes( $tbl_address['type'] ); $address_line1 = stripslashes( $tbl_address['line1'] ); $address_line2 = stripslashes( $tbl_address['line2'] ); $address_city = stripslashes( $tbl_address['city'] ); $address_state = stripslashes( $tbl_address['state'] ); $address_zip = stripslashes( $tbl_address['zip'] ); $address_phone1 = stripslashes( $tbl_address['phone1'] ); $address_phone2 = stripslashes( $tbl_address['phone2'] ); $address_country = $tbl_address['country']; echo "

\n" . (($contact->primary_address == $address_refid) ? $lang[LBL_PRIMARY_ADDRESS] : $lang[LBL_ADDRESS]); if ($address_type) { echo " ($address_type)"; } echo "\n"; if ($address_line1) { echo "\n
$address_line1"; } if ($address_line2) { echo "\n
$address_line2"; } if ($address_city OR $address_state OR $address_zip) { echo "\n
"; } if ($address_city) { echo "$address_city"; } if ($address_city AND $address_state) { echo ", "; } if ($address_state) { echo "$address_state"; } if ($address_zip) { echo " $address_zip"; } if ($address_phone1) { echo "\n
$address_phone1"; } if ($address_phone2) { echo "\n
$address_phone2"; } // Country if ($address_country) { echo "\n
$country[$address_country]"; } } // ** E-MAIL ** // First check to see that the result set is filled. If so, create E-mail section header. // Then start pulling data out of the result set and displaying them. $tbl_email = mysql_fetch_array($r_email); $email_address = stripslashes( $tbl_email['email'] ); $email_type = stripslashes( $tbl_email['type'] ); if ($email_address) { echo("

\n$lang[LBL_EMAIL]\n"); if ($options->useMailScript == 1) { echo("
$email_address"); } else { echo("
$email_address"); } if ($email_type) { echo(" ($email_type)"); } echo("\n"); while ($tbl_email = mysql_fetch_array($r_email)) { $email_address = stripslashes( $tbl_email['email'] ); $email_type = stripslashes( $tbl_email['type'] ); if ($options->useMailScript == 1) { echo("
$email_address"); } else { echo("
$email_address"); } if ($email_type) { echo(" ($email_type)"); } echo("\n"); } } ?>  

birthday) { echo(" \n"); echo(" "); echo(" \n"); echo(" \n"); } // ** ADDITIONAL DATA ** while ( $tbl_additionalData = mysql_fetch_array($r_additionalData) ) { $adddataType = stripslashes( $tbl_additionalData['type'] ); $adddataValue = stripslashes( $tbl_additionalData['value'] ); echo(" \n"); echo(" \n"); echo(" \n"); echo(" \n"); } // ** WEBSITES ** $tbl_websites = mysql_fetch_array($r_websites); $websiteURL = stripslashes( $tbl_websites['webpageURL'] ); $websiteName = stripslashes( $tbl_websites['webpageName'] ); if ($websiteURL) { echo(" \n"); echo(" \n"); echo(" \n"); echo(" \n"); } ?>
$lang[LBL_BIRTHDATE] $contact->birthday
$adddataType$adddataValue
$lang[LBL_WEBSITES]\n"); echo(" "); // Displays URL if no name is given if ($websiteName) { echo($websiteName); } else { echo($websiteURL); } echo("\n"); while ($tbl_websites = mysql_fetch_array($r_websites)) { $websiteURL = stripslashes( $tbl_websites['webpageURL'] ); $websiteName = stripslashes( $tbl_websites['webpageName'] ); echo("
"); if ($websiteName) { echo($websiteName); } else { echo($websiteURL); } echo("\n"); } echo("
\n"); echo(" $lang[LBL_NOTES]\n"); echo("
\n"); echo(" $contact->notes\n"); echo("

last_update).'.'; ?>