[ "._ADDRESS_BOOK." ] | [ "._A_BADVANCEDSEARCH." ] | [ "._A_BADMIN." ] | "._GOBACK.""; } /*********************************************************/ /* Sections Manager Functions */ /*********************************************************/ function alpha($eid) { global $module_name, $prefix, $dbi; $alphabet = array ("A","B","C","D","E","F","G","H","I","J","K","L","M", "N","O","P","Q","R","S","T","U","V","W","X","Y","Z"); $num = count($alphabet) - 1; echo "[ "; $counter = 0; while (list(, $ltr) = each($alphabet)) { $result = sql_query("select * from ".$prefix."_address_book_text where eid='$eid' AND UPPER(title) LIKE '$ltr%'", $dbi); if (sql_num_rows($result) > 0) { echo "$ltr"; } else { echo "$ltr"; } if ( $counter == round($num/2) ) { echo " ]\n
\n[ "; } elseif ( $counter != $num ) { echo " | \n"; } $counter++; } echo " ]

\n\n\n"; } function address_book() { global $pNum, $base, $user, $module_name, $prefix, $dbi, $language, $multilingual, $bgcolor2; ## if(!is_user($user)){ include("header.php"); OpenTable(); echo _NIX; CloseTable(); include("footer.php"); ## } else { include("header.php"); title(""._ADDRESS_BOOKMANAGER.""); OpenTable(); echo "" .""; $userinfo = cookiedecode($user); if(!$base) $base=0; $i = $base + 1; $result = sql_query("select image,title,tid,email,celltel,country from ".$prefix."_address_book_text where author='$userinfo[0]' order by title LIMIT $base,$pNum", $dbi); while($a_b = sql_fetch_array($result, $dbi)) { echo ""; } echo ""; $resC = sql_query("select count(tid) from ".$prefix."_address_book_text where author='$userinfo[0]'", $dbi); list($num) = sql_fetch_array($resC, $dbi); if($num > ($base+$pNum)) $next_lnk = ""._NEXT." "; if($base) $prev_lnk = ""._PREVIOUS." "; echo ""; echo "

	"._TITLE."	"._A_BEMAIL."	"._A_BCELL ."	"._FUNCTIONS."
".$i++."	$a_b[title]	$a_b[email]	$a_b[celltel]	[ "._EDIT." | "._DELETE." ]
			"._A_B_TOTALS.": ".$num."	".$prev_lnk."	".$next_lnk."

"; CloseTable(); echo "
"; OpenTable(); ShowMenu(); echo "
"._ADDNEWA_BTERM."

" ."

"; echo formLayout(); echo "" ."" ."

"; ShowMenu(); CloseTable(); include("footer.php"); ## } ## } function address_book_terms($eid, $ltr) { global $module_name, $prefix, $dbi; include("header.php"); title(""._ADDRESS_BOOKMANAGER.""); $result = sql_query("select title from ".$prefix."_address_book where eid='$eid' AND UPPER(title) LIKE '%$ltr%'", $dbi); list($title) = sql_fetch_row($result, $dbi); title("$title"); OpenTable(); echo ""._SELECTONETERM."

" .""; $result = sql_query("select tid, title from ".$prefix."_address_book_text WHERE UPPER(title) LIKE '$ltr%' AND eid='$eid'", $dbi); if (sql_num_rows($result, $dbi) == 0) { echo ""._NOCONTENTFORLETTER." $ltr."; } while(list($tid, $title) = sql_fetch_row($result, $dbi)) { echo ""; } echo "

$title

"; alpha($eid); ShowMenu(); echo ""._GOBACK.""; CloseTable(); include("footer.php"); } function address_book_text_edit($tid) { global $module_name, $user, $prefix, $dbi, $language, $multilingual, $bgcolor2; include("header.php"); $userinfo = cookiedecode($user); $result = sql_query("select * from ".$prefix."_address_book_text WHERE tid='$tid' AND author='$userinfo[0]'", $dbi); title(""._ADDRESS_BOOKMANAGER.""); $a_b = sql_fetch_array($result, $dbi); OpenTable(); ShowMenu(); echo "
"._A_BTERMSEDIT."

" ."

"; echo formLayout($a_b); echo "" ."" ."    [ "._DELETE." ]" ."

"; ShowMenu(); CloseTable(); include("footer.php"); } function CreateSelect($arr){ // RB if(!is_array($arr)) return; $arr = array_unique($arr); asort($arr); $string = "\n"; foreach($arr as $item){ if(!empty($item)) $string .= "".$item."\n"; } return($string); } function CreateJsArr($arr, $field){ // RB if(!is_array($arr)) return; $arr = array_unique($arr); asort($arr); $string = "\n\n"; return($string); } function formLayout($a_b=0){ // RB global $user, $prefix, $dbi; $userinfo = cookiedecode($user); $result = sql_query("select image, company, role, fax, country, email, wab, wub, area, city, state from ".$prefix."_address_book_text where author='$userinfo[0]' OR access='public'", $dbi); while(list($image,$company,$role,$fax,$country,$email,$wab,$wub,$area,$city,$state) = sql_fetch_array($result, $dbi)){ $image_arr[] = $image; $company_arr[] = $company; $role_arr[] = $role; $fax_arr[] = $fax; $country_arr[] = $country; $email_arr[] = $email; $area_arr[] = $area; $wab_arr[] = $wab; $wub_arr[] = $wub; $city_arr[] = $city; $state_arr[] = $state; } $image_sel = CreateJsArr($image_arr, 'image_arr')."\n".CreateSelect($image_arr)."\n"; $company_sel = CreateJsArr($company_arr, 'company_arr')."\n".CreateSelect($company_arr)."\n"; $country_sel = CreateJsArr($country_arr, 'country_arr')."\n".CreateSelect($country_arr)."\n"; $fax_sel = CreateJsArr($fax_arr, 'fax_arr')."\n".CreateSelect($fax_arr)."\n"; $email_sel = CreateJsArr($email_arr, 'email_arr')."\n".CreateSelect($email_arr)."\n"; $role_sel = CreateJsArr($role_arr, 'role_arr')."\n".CreateSelect($role_arr)."\n"; $wab_sel = CreateJsArr($wab_arr, 'wab_arr')."\n".CreateSelect($wab_arr)."\n"; $wub_sel = CreateJsArr($wub_arr, 'wub_arr')."\n".CreateSelect($wub_arr)."\n"; if($a_b[access]=="public"){ $PubCheck = " CHECKED"; } else { $PrivCheck = " CHECKED"; } $string = "\n\n"; $string .= "\n" .""._A_BIMAGE.":
" ."

" .""._A_B_TITLE.":
" ."

" .""._A_BCITY.":
" ." ".$city_sel."

" // RB ==> Add here (and in the db) as many fields as you need <== .""._A_BCELLTEL.":
" ."

" .""._A_BCOUNTRY.":
" ." ".$country_sel."

" .""._A_BSTATE.":
" ." ".$state_sel."

" .""._A_BTEL.":
" ."

" .""._A_BFAX.":
" ." ".$fax_sel."

" .""._A_BEMAIL.":
" ." ".$email_sel."

" .""._A_BWEB.":
" ."

" .""._A_BWAB.":
" ." ".$wab_sel."

" .""._A_BWUB.":
" ." ".$wub_sel."

" .""._A_BWOB.":
" .""._WOBNO." \n" .""._WOBYES." \n" .""._WOBSOMETIMES."

" .""._A_BCOMPANY.":
" ."

" .""._A_BROLE.":
" ." ".$role_sel."

" .""._A_BADDRESS.":
" ."

" .""._A_BZIP.":
" ."

" .""._A_BAREA.":
" ." ".$area_sel."

" .""._A_BACCESS.":
" .""._A_BPRIVATE."
" .""._A_BPUBLIC."

"; return($string); } function address_book_text_save($eid,$image,$title,$text,$celltel,$country,$tel,$fax,$email,$web,$wab,$wub,$wob,$company,$role,$address,$zip,$area,$city,$state,$access) { global $user, $module_name, $prefix, $dbi; $userinfo = cookiedecode($user); sql_query("insert into ".$prefix."_address_book_text values (NULL, '$eid','$image','$title','$celltel','$country','$tel','$fax','$email','$web','$wab','$wub','$wob','$company','$role','$address','$zip','$area','$city','$state', '$text', '0','$userinfo[0]','$access')", $dbi); Header("Location: modules.php?name=".$module_name."&file=admin&op=address_book"); } function address_book_text_save_edit($tid, $eid, $image, $title, $text, $celltel, $country, $tel,$fax,$email,$web,$wab,$wub,$company,$role,$address,$zip,$area,$city,$state,$access) { global $user, $module_name, $prefix, $dbi; $userinfo = cookiedecode($user); sql_query("update ".$prefix."_address_book_text set eid='$eid', image='$image', title='$title', text='$text', celltel='$celltel', country='$country', tel='$tel',fax='$fax',email='$email',web='$web',wab='$wab',wub='$wub',wob='$wob',company='$company',role='$role',address='$address',zip='$zip',area='$area',city='$city',state='$state',author='$userinfo[0]',access='$access' WHERE tid='$tid' AND author='$userinfo[0]'", $dbi); Header("Location: modules.php?name=".$module_name.""); } function address_book_text_delete($tid, $ok=0) { global $user, $module_name, $prefix, $dbi; $userinfo = cookiedecode($user); if ($ok==1) { sql_query("delete from ".$prefix."_address_book_text where tid='$tid' AND author='$userinfo[0]'", $dbi); Header("Location: modules.php?name=".$module_name."&file=admin&op=address_book"); } else { include("header.php"); // RB GraphicAdmin(); title(""._ADDRESS_BOOKMANAGER.""); $result = sql_query("select title from ".$prefix."_address_book_text where tid='$tid'", $dbi); list($title) = sql_fetch_row($result, $dbi); OpenTable(); echo ""._DEL_ADDRESS_BOOKTEXT.": $title

" .""._DELA_BTEXTWARNING."

" ."[ "._NO." | "._YES." ]"; CloseTable(); include("footer.php"); } } switch ($op) { case "address_book": address_book(); break; case "address_book_terms": address_book_terms($eid, $ltr); break; case "address_book_text_edit": address_book_text_edit($tid); break; case "address_book_text_delete": address_book_text_delete($tid, $ok); break; case "address_book_text_save": address_book_text_save($eid,$image,$title,$text,$celltel,$country,$tel,$fax,$email,$web,$wab,$wub,$wob,$company,$role,$address,$zip,$area,$city,$state,$access); break; case "address_book_text_save_edit": address_book_text_save_edit($tid, $eid, $image, $title, $text, $celltel, $country, $tel,$fax,$email,$web,$wab,$wub,$wob,$company,$role,$address,$zip,$area,$city,$state,$access); break; } ?>