| 1 | <?php |
|---|
| 2 | |
|---|
| 3 | |
|---|
| 4 | |
|---|
| 5 | |
|---|
| 6 | |
|---|
| 7 | |
|---|
| 8 | |
|---|
| 9 | |
|---|
| 10 | |
|---|
| 11 | |
|---|
| 12 | |
|---|
| 13 | |
|---|
| 14 | |
|---|
| 15 | |
|---|
| 16 | |
|---|
| 17 | |
|---|
| 18 | |
|---|
| 19 | |
|---|
| 20 | |
|---|
| 21 | |
|---|
| 22 | |
|---|
| 23 | |
|---|
| 24 | |
|---|
| 25 | $_SMARTY['Title'] = 'Friend finder'; |
|---|
| 26 | |
|---|
| 27 | $user['info'] = get_cache_user_info($url_id); |
|---|
| 28 | $user['photo'] = build_image_url($url_id); |
|---|
| 29 | |
|---|
| 30 | if($_POST['fname'] || $_POST['lname'] || $_POST['nick'] ) |
|---|
| 31 | { |
|---|
| 32 | $t_fields = 'id, fname, lname, here_for, gender, country, relationship_status'; |
|---|
| 33 | |
|---|
| 34 | if($_POST['fname']!='' && $_POST['lname']!='') |
|---|
| 35 | { |
|---|
| 36 | $r0 = $db->query('SELECT ! FROM cache_user WHERE fname=? AND lname=? LIMIT 20', array($t_fields, $_POST['fname'], $_POST['lname'])); |
|---|
| 37 | while($item = $r0->fetchRow()) |
|---|
| 38 | { |
|---|
| 39 | $item_id = $item['id']; |
|---|
| 40 | unset($item['id']); |
|---|
| 41 | |
|---|
| 42 | $result[$item_id] = $item; |
|---|
| 43 | $result[$item_id]['gender_t'] = translate_list($item['gender'], $labels['profile']['gender']); |
|---|
| 44 | $result[$item_id]['here_for_t'] = translate_list($item['here_for'], $labels['profile']['here_for']); |
|---|
| 45 | $result[$item_id]['relationship_status_t'] = translate_list($item['relationship_status'], $labels['profile']['relationship_status']); |
|---|
| 46 | |
|---|
| 47 | $result[$item_id]['photo'] = build_thumb_url($item_id); |
|---|
| 48 | $result[$item_id]['pertinence'] = 4; |
|---|
| 49 | } |
|---|
| 50 | $r0_nb = $r0->numRows(); |
|---|
| 51 | } |
|---|
| 52 | |
|---|
| 53 | if($_POST['fname']!='' && $_POST['lname']!='' && $r0_nb <20) |
|---|
| 54 | { |
|---|
| 55 | $r1 = $db->query('SELECT ! FROM cache_user WHERE fname_sndex=SOUNDEX(?) AND lname_sndex=SOUNDEX(?) LIMIT !', array($t_fields, $_POST['fname'], $_POST['lname'], 20-$r0_nb)); |
|---|
| 56 | while($item = $r1->fetchRow()) |
|---|
| 57 | { |
|---|
| 58 | if(!isset($result[$item['id']])) |
|---|
| 59 | { |
|---|
| 60 | $item_id = $item['id']; |
|---|
| 61 | unset($item['id']); |
|---|
| 62 | |
|---|
| 63 | $result[$item_id] = $item; |
|---|
| 64 | $result[$item_id]['gender_t'] = translate_list($item['gender'], $labels['profile']['gender']); |
|---|
| 65 | $result[$item_id]['here_for_t'] = translate_list($item['here_for'], $labels['profile']['here_for']); |
|---|
| 66 | $result[$item_id]['relationship_status_t'] = translate_list($item['relationship_status'], $labels['profile']['relationship_status']); |
|---|
| 67 | |
|---|
| 68 | $result[$item_id]['photo'] = build_thumb_url($item_id); |
|---|
| 69 | $result[$item_id]['pertinence'] = 3; |
|---|
| 70 | } |
|---|
| 71 | } |
|---|
| 72 | $r1_nb = $r1->numRows(); |
|---|
| 73 | } |
|---|
| 74 | |
|---|
| 75 | if($_POST['lname']!='' && ($r0_nb+$r1_nb) <20) |
|---|
| 76 | { |
|---|
| 77 | $r2 = $db->query('SELECT ! FROM cache_user WHERE lname_sndex=SOUNDEX(?) LIMIT !', array($t_fields, $_POST['lname'], 20-$r0_nb-$r1_nb)); |
|---|
| 78 | while($item = $r2->fetchRow()) |
|---|
| 79 | { |
|---|
| 80 | if(!isset($result[$item['id']])) |
|---|
| 81 | { |
|---|
| 82 | $item_id = $item['id']; |
|---|
| 83 | unset($item['id']); |
|---|
| 84 | |
|---|
| 85 | $result[$item_id] = $item; |
|---|
| 86 | $result[$item_id]['gender_t'] = translate_list($item['gender'], $labels['profile']['gender']); |
|---|
| 87 | $result[$item_id]['here_for_t'] = translate_list($item['here_for'], $labels['profile']['here_for']); |
|---|
| 88 | $result[$item_id]['relationship_status_t'] = translate_list($item['relationship_status'], $labels['profile']['relationship_status']); |
|---|
| 89 | |
|---|
| 90 | $result[$item_id]['photo'] = build_thumb_url($item_id); |
|---|
| 91 | $result[$item_id]['pertinence'] = 2; |
|---|
| 92 | } |
|---|
| 93 | } |
|---|
| 94 | $r2_nb = $r2->numRows(); |
|---|
| 95 | } |
|---|
| 96 | |
|---|
| 97 | if($_POST['fname']!='' && ($r0_nb+$r1_nb+$r2_nb )<20 ) |
|---|
| 98 | { |
|---|
| 99 | $r3 = $db->query('SELECT ! FROM cache_user WHERE fname_sndex=SOUNDEX(?) LIMIT !', array($t_fields, $_POST['fname'], 20-$r0_nb-$r1_nb-$r2_nb)); |
|---|
| 100 | while($item = $r3->fetchRow()) |
|---|
| 101 | { |
|---|
| 102 | if(!isset($result[$item['id']])) |
|---|
| 103 | { |
|---|
| 104 | $item_id = $item['id']; |
|---|
| 105 | unset($item['id']); |
|---|
| 106 | |
|---|
| 107 | $result[$item_id] = $item; |
|---|
| 108 | $result[$item_id]['gender_t'] = translate_list($item['gender'], $labels['profile']['gender']); |
|---|
| 109 | $result[$item_id]['here_for_t'] = translate_list($item['here_for'], $labels['profile']['here_for']); |
|---|
| 110 | $result[$item_id]['relationship_status_t'] = translate_list($item['relationship_status'], $labels['profile']['relationship_status']); |
|---|
| 111 | |
|---|
| 112 | $result[$item_id]['photo'] = build_thumb_url($item_id); |
|---|
| 113 | $result[$item_id]['pertinence'] = 1; |
|---|
| 114 | } |
|---|
| 115 | } |
|---|
| 116 | $r3_nb = $r3->numRows(); |
|---|
| 117 | } |
|---|
| 118 | |
|---|
| 119 | if($_POST['nick']!='' && ($r0_nb+$r1_nb+$r2_nb+$r3_nb )<20 ) |
|---|
| 120 | { |
|---|
| 121 | $r4 = $db->query('SELECT ! FROM cache_user WHERE nick_sndex=SOUNDEX(?) LIMIT !', array($t_fields, $_POST['nick'], 20-$r0_nb-$r1_nb-$r2_nb+$r3_nb)); |
|---|
| 122 | while($item = $r4->fetchRow()) |
|---|
| 123 | { |
|---|
| 124 | if(!isset($result[$item['id']])) |
|---|
| 125 | { |
|---|
| 126 | $item_id = $item['id']; |
|---|
| 127 | unset($item['id']); |
|---|
| 128 | |
|---|
| 129 | $result[$item_id] = $item; |
|---|
| 130 | $result[$item_id]['gender_t'] = translate_list($item['gender'], $labels['profile']['gender']); |
|---|
| 131 | $result[$item_id]['here_for_t'] = translate_list($item['here_for'], $labels['profile']['here_for']); |
|---|
| 132 | $result[$item_id]['relationship_status_t'] = translate_list($item['relationship_status'], $labels['profile']['relationship_status']); |
|---|
| 133 | |
|---|
| 134 | $result[$item_id]['photo'] = build_thumb_url($item_id); |
|---|
| 135 | $result[$item_id]['pertinence'] = 1; |
|---|
| 136 | } |
|---|
| 137 | } |
|---|
| 138 | } |
|---|
| 139 | |
|---|
| 140 | } |
|---|
| 141 | |
|---|
| 142 | |
|---|
| 143 | |
|---|
| 144 | $leftmenu["/profile/$url_id"] = 'Profile'; |
|---|
| 145 | |
|---|
| 146 | if($user['info']['nb_photos'] > 0) |
|---|
| 147 | $leftmenu["/album/$url_id"] = 'Album'; |
|---|
| 148 | |
|---|
| 149 | if($user['info']['nb_blogs'] > 0) |
|---|
| 150 | $leftmenu["/blog/$url_id"] = 'Blog'; |
|---|
| 151 | |
|---|
| 152 | if($user['info']['nb_bookmarks'] > 0) |
|---|
| 153 | $leftmenu["/bookmarks/$url_id"] = 'Bookmarks'; |
|---|
| 154 | |
|---|
| 155 | $_SMARTY['leftmenu'] = $leftmenu; |
|---|
| 156 | |
|---|
| 157 | |
|---|
| 158 | $_SMARTY['user'] = $user; |
|---|
| 159 | if($result) $_SMARTY['result'] = $result; |
|---|
| 160 | ?> |
|---|