@@ -91,168 +91,168 @@ discard block |
||
| 91 | 91 | $ext_item_value = $ext_item_arr[1]; |
| 92 | 92 | |
| 93 | 93 | switch ($ext_item_name) { |
| 94 | - case "cols": |
|
| 95 | - $cols = $ext_item_value; |
|
| 96 | - break; |
|
| 97 | - case "rows": |
|
| 98 | - $rows = $ext_item_value; |
|
| 99 | - break; |
|
| 100 | - case "size": |
|
| 101 | - $size = $ext_item_value; |
|
| 102 | - break; |
|
| 103 | - case "maxsize": |
|
| 104 | - $maxsize = $ext_item_value; |
|
| 105 | - break; |
|
| 106 | - case "multiple": |
|
| 107 | - $multiple = true; |
|
| 108 | - $size = 5; |
|
| 109 | - case "value": |
|
| 110 | - if ($ext_item_value != '' and $value == '' ) { |
|
| 111 | - $value = $ext_item_value; |
|
| 112 | - } |
|
| 113 | - break; |
|
| 94 | + case "cols": |
|
| 95 | + $cols = $ext_item_value; |
|
| 96 | + break; |
|
| 97 | + case "rows": |
|
| 98 | + $rows = $ext_item_value; |
|
| 99 | + break; |
|
| 100 | + case "size": |
|
| 101 | + $size = $ext_item_value; |
|
| 102 | + break; |
|
| 103 | + case "maxsize": |
|
| 104 | + $maxsize = $ext_item_value; |
|
| 105 | + break; |
|
| 106 | + case "multiple": |
|
| 107 | + $multiple = true; |
|
| 108 | + $size = 5; |
|
| 109 | + case "value": |
|
| 110 | + if ($ext_item_value != '' and $value == '' ) { |
|
| 111 | + $value = $ext_item_value; |
|
| 112 | + } |
|
| 113 | + break; |
|
| 114 | 114 | } |
| 115 | 115 | } |
| 116 | 116 | } |
| 117 | 117 | |
| 118 | 118 | switch ($fieldtype) { |
| 119 | - case "address": |
|
| 120 | - //Query all address fields associated with the address type that belongs to the locid. |
|
| 121 | - $addressfields = getAddressFields('0'); |
|
| 122 | - $addressvalues = getAddressValues($value); |
|
| 123 | - $form->addElement(new XoopsFormLabel("", "<strong>".$title."</strong>")); |
|
| 124 | - $fieldtitles = array('address' => _MD_DF_ADDRESS, 'address2' => _MD_DF_ADDRESS2, 'zip' => _MD_DF_ZIP, 'postcode' => _MD_DF_POSTCODE, 'lat' => _MD_DF_LAT, 'lon' => _MD_DF_LON, 'phone' => _MD_DF_PHONE, 'fax' => _MD_DF_FAX, 'mobile' => _MD_DF_MOBILE, 'city' => _MD_DF_CITY, 'country' => _MD_DF_COUNTRY, 'typename' => _MD_DF_TYPENAME, 'uselocyn' => _MD_DF_USELOCYN); |
|
| 125 | - foreach ($addressfields['addressfields'] as $field => $fieldvalue) { |
|
| 126 | - $storedvalue = $addressvalues["$field"]; |
|
| 127 | - if ($fieldvalue == 1) { |
|
| 128 | - $title = $fieldtitles["$field"]; |
|
| 129 | - $form->addElement(new XoopsFormText($title, $name.$field, 50, 250, $myts->makeTboxData4Show($storedvalue))); |
|
| 119 | + case "address": |
|
| 120 | + //Query all address fields associated with the address type that belongs to the locid. |
|
| 121 | + $addressfields = getAddressFields('0'); |
|
| 122 | + $addressvalues = getAddressValues($value); |
|
| 123 | + $form->addElement(new XoopsFormLabel("", "<strong>".$title."</strong>")); |
|
| 124 | + $fieldtitles = array('address' => _MD_DF_ADDRESS, 'address2' => _MD_DF_ADDRESS2, 'zip' => _MD_DF_ZIP, 'postcode' => _MD_DF_POSTCODE, 'lat' => _MD_DF_LAT, 'lon' => _MD_DF_LON, 'phone' => _MD_DF_PHONE, 'fax' => _MD_DF_FAX, 'mobile' => _MD_DF_MOBILE, 'city' => _MD_DF_CITY, 'country' => _MD_DF_COUNTRY, 'typename' => _MD_DF_TYPENAME, 'uselocyn' => _MD_DF_USELOCYN); |
|
| 125 | + foreach ($addressfields['addressfields'] as $field => $fieldvalue) { |
|
| 126 | + $storedvalue = $addressvalues["$field"]; |
|
| 127 | + if ($fieldvalue == 1) { |
|
| 128 | + $title = $fieldtitles["$field"]; |
|
| 129 | + $form->addElement(new XoopsFormText($title, $name.$field, 50, 250, $myts->makeTboxData4Show($storedvalue))); |
|
| 130 | + } |
|
| 131 | + } |
|
| 132 | + $form->addElement(new XoopsFormHidden("submitaddress","1")); |
|
| 133 | + $form->addElement(new XoopsFormHidden($name, $value)); |
|
| 134 | + $form->addElement(new XoopsFormHidden("addrid", $value)); |
|
| 135 | + break; |
|
| 136 | + case "checkbox": |
|
| 137 | + $options_arr = split("[|]",$options); |
|
| 138 | + $form_checkbox = new XoopsFormCheckbox($title, $name, $value, 1); |
|
| 139 | + foreach($options_arr as $option) { |
|
| 140 | + $form_checkbox->addOption($option, $option); |
|
| 141 | + } |
|
| 142 | + $form->addElement($form_checkbox); |
|
| 143 | + break; |
|
| 144 | + case "date": |
|
| 145 | + $form->addElement(new XoopsFormText($title, $name, 10, 10, $value)); |
|
| 146 | + break; |
|
| 147 | + case "datetime": |
|
| 148 | + $form->addElement(new XoopsFormDateTime($title, $name, 10, $value)); |
|
| 149 | + break; |
|
| 150 | + case "dhtml": |
|
| 151 | + if ($custom == '1') { |
|
| 152 | + $form_dhtmlarea_tray = new XoopsFormElementTray($title, "", $name); |
|
| 153 | + $form_dhtmlarea_tray->addElement(new XoopsFormLabel("", "<table><tr><td>")); |
|
| 154 | + $form_dhtmlarea_tray->addElement(new XoopsFormText("<b>"._MD_CUSTOM_TITLE."</b></td><td>", "custom".$name, 50, 250, $customtitle)); |
|
| 155 | + $form_dhtmlarea_tray->addElement(new XoopsFormLabel("", "</td></tr><tr><td>")); |
|
| 156 | + $form_dhtmlarea_tray->addElement(new XoopsFormDhtmlTextArea("<b>"._MD_CUSTOM_VALUE."</b></td><td>", $name, $value, $rows, $cols)); |
|
| 157 | + $form_dhtmlarea_tray->addElement(new XoopsFormLabel("", "</td></tr></table>")); |
|
| 158 | + $form->addElement($form_dhtmlarea_tray); |
|
| 159 | + } else { |
|
| 160 | + $form->addElement(new XoopsFormDhtmlTextArea($title, $name, $value, $rows, $cols)); |
|
| 161 | + } |
|
| 162 | + break; |
|
| 163 | + //case "gmap": |
|
| 164 | + //$gmap = new efqGmap(); |
|
| 165 | + // $gmapHandler = new efqGmapHandler(); |
|
| 166 | + // $gmap_lon = ''; |
|
| 167 | + // $gmap_lat = ''; |
|
| 168 | + // $gmap_descr = ''; |
|
| 169 | + // if (intval($value) > 0) { |
|
| 170 | + // $gmap->setData($gmapHandler->getGmapById($value)); |
|
| 171 | + // $gmap_lon = $gmap->getVar('lon'); |
|
| 172 | + // $gmap_lat = $gmap->getVar('lat'); |
|
| 173 | + // $gmap_descr = $gmap->getVar('descr'); |
|
| 174 | + // } |
|
| 175 | + // $form->addElement(new XoopsFormHidden($name.'_dataid', $name)); |
|
| 176 | + // $form->addElement(new XoopsFormText(_MD_GMAP_LON, $name.'_lon', 10, 30, $gmap_lon)); |
|
| 177 | + // $form->addElement(new XoopsFormText(_MD_GMAP_LAT, $name.'_lat', 10, 30, $gmap_lat)); |
|
| 178 | + // $form->addElement(new XoopsFormTextArea(_MD_GMAP_DESCR, $name.'_descr', $gmap_descr, 5, 50)); |
|
| 179 | + // break; |
|
| 180 | + case "radio": |
|
| 181 | + $options_arr = split("[|]",$options); |
|
| 182 | + $form_radio = new XoopsFormRadio($title, $name, $value, 1); |
|
| 183 | + foreach($options_arr as $option) { |
|
| 184 | + $form_radio->addOption($option, $option); |
|
| 185 | + } |
|
| 186 | + $form->addElement($form_radio); |
|
| 187 | + break; |
|
| 188 | + case "rating": |
|
| 189 | + $rating_options = array(1,2,3,4,5,6,7,8,9,10); |
|
| 190 | + $form_rating = new XoopsFormSelect($title, $name, $value, 1); |
|
| 191 | + $form_rating->addOption('0', '----'); |
|
| 192 | + foreach($rating_options as $option) { |
|
| 193 | + $form_rating->addOption($option, $option); |
|
| 194 | + } |
|
| 195 | + $form->addElement($form_rating); |
|
| 196 | + break; |
|
| 197 | + case "select": |
|
| 198 | + $options_arr = split("[|]",$options); |
|
| 199 | + $value_arr = split("[|]",$value); |
|
| 200 | + $form_select = new XoopsFormSelect($title, $name, $value, $size, $multiple); |
|
| 201 | + $form_select->addOption('-', '----'); |
|
| 202 | + $form_select->setValue($value_arr); |
|
| 203 | + foreach($options_arr as $key => $option) { |
|
| 204 | + $form_select->addOption($option, $option); |
|
| 205 | + } |
|
| 206 | + $form->addElement($form_select); |
|
| 207 | + break; |
|
| 208 | + case "textarea": |
|
| 209 | + if ($custom == '1') { |
|
| 210 | + $form_textarea_tray = new XoopsFormElementTray($title, "", $name); |
|
| 211 | + $form_textarea_tray->addElement(new XoopsFormLabel("", "<table><tr><td>")); |
|
| 212 | + $form_textarea_tray->addElement(new XoopsFormText("<b>"._MD_CUSTOM_TITLE."</b></td><td>", "custom".$name, 50, 250, $customtitle)); |
|
| 213 | + $form_textarea_tray->addElement(new XoopsFormLabel("", "</td></tr><tr><td>")); |
|
| 214 | + $form_textarea_tray->addElement(new XoopsFormTextArea("<b>"._MD_CUSTOM_VALUE."</b></td><td>", $name, $value, $rows, $cols)); |
|
| 215 | + $form_textarea_tray->addElement(new XoopsFormLabel("", "</td></tr></table>")); |
|
| 216 | + $form->addElement($form_textarea_tray); |
|
| 217 | + } else { |
|
| 218 | + $form->addElement(new XoopsFormTextArea($title, $name, $value, $rows, $cols)); |
|
| 219 | + } |
|
| 220 | + break; |
|
| 221 | + case "textbox": |
|
| 222 | + if ($custom == '1') { |
|
| 223 | + $form_text_tray = new XoopsFormElementTray($title, "", $name); |
|
| 224 | + $form_text_tray->addElement(new XoopsFormLabel("", "<table><tr><td>")); |
|
| 225 | + $form_text_tray->addElement(new XoopsFormText("<b>"._MD_CUSTOM_TITLE."</b></td><td>", "custom".$name, 50, 250, $customtitle)); |
|
| 226 | + $form_text_tray->addElement(new XoopsFormLabel("", "</td></tr><tr><td>")); |
|
| 227 | + $form_text_tray->addElement(new XoopsFormText("<b>"._MD_CUSTOM_VALUE."</b></td><td>", $name, $size, $maxsize, $value)); |
|
| 228 | + $form_text_tray->addElement(new XoopsFormLabel("", "</td></tr></table>")); |
|
| 229 | + $form->addElement($form_text_tray); |
|
| 230 | + } else { |
|
| 231 | + $form->addElement(new XoopsFormText($title, $name, 50, 250, $myts->makeTboxData4Show($value))); |
|
| 232 | + } |
|
| 233 | + break; |
|
| 234 | + case "url": |
|
| 235 | + if ($value != '') { |
|
| 236 | + $link = explode('|',$value); |
|
| 237 | + } else { |
|
| 238 | + $link = array(); |
|
| 239 | + $link[0] = ''; |
|
| 240 | + $link[1] = ''; |
|
| 130 | 241 | } |
| 131 | - } |
|
| 132 | - $form->addElement(new XoopsFormHidden("submitaddress","1")); |
|
| 133 | - $form->addElement(new XoopsFormHidden($name, $value)); |
|
| 134 | - $form->addElement(new XoopsFormHidden("addrid", $value)); |
|
| 135 | - break; |
|
| 136 | - case "checkbox": |
|
| 137 | - $options_arr = split("[|]",$options); |
|
| 138 | - $form_checkbox = new XoopsFormCheckbox($title, $name, $value, 1); |
|
| 139 | - foreach($options_arr as $option) { |
|
| 140 | - $form_checkbox->addOption($option, $option); |
|
| 141 | - } |
|
| 142 | - $form->addElement($form_checkbox); |
|
| 143 | - break; |
|
| 144 | - case "date": |
|
| 145 | - $form->addElement(new XoopsFormText($title, $name, 10, 10, $value)); |
|
| 146 | - break; |
|
| 147 | - case "datetime": |
|
| 148 | - $form->addElement(new XoopsFormDateTime($title, $name, 10, $value)); |
|
| 149 | - break; |
|
| 150 | - case "dhtml": |
|
| 151 | - if ($custom == '1') { |
|
| 152 | - $form_dhtmlarea_tray = new XoopsFormElementTray($title, "", $name); |
|
| 153 | - $form_dhtmlarea_tray->addElement(new XoopsFormLabel("", "<table><tr><td>")); |
|
| 154 | - $form_dhtmlarea_tray->addElement(new XoopsFormText("<b>"._MD_CUSTOM_TITLE."</b></td><td>", "custom".$name, 50, 250, $customtitle)); |
|
| 155 | - $form_dhtmlarea_tray->addElement(new XoopsFormLabel("", "</td></tr><tr><td>")); |
|
| 156 | - $form_dhtmlarea_tray->addElement(new XoopsFormDhtmlTextArea("<b>"._MD_CUSTOM_VALUE."</b></td><td>", $name, $value, $rows, $cols)); |
|
| 157 | - $form_dhtmlarea_tray->addElement(new XoopsFormLabel("", "</td></tr></table>")); |
|
| 158 | - $form->addElement($form_dhtmlarea_tray); |
|
| 159 | - } else { |
|
| 160 | - $form->addElement(new XoopsFormDhtmlTextArea($title, $name, $value, $rows, $cols)); |
|
| 161 | - } |
|
| 162 | - break; |
|
| 163 | - //case "gmap": |
|
| 164 | - //$gmap = new efqGmap(); |
|
| 165 | -// $gmapHandler = new efqGmapHandler(); |
|
| 166 | -// $gmap_lon = ''; |
|
| 167 | -// $gmap_lat = ''; |
|
| 168 | -// $gmap_descr = ''; |
|
| 169 | -// if (intval($value) > 0) { |
|
| 170 | -// $gmap->setData($gmapHandler->getGmapById($value)); |
|
| 171 | -// $gmap_lon = $gmap->getVar('lon'); |
|
| 172 | -// $gmap_lat = $gmap->getVar('lat'); |
|
| 173 | -// $gmap_descr = $gmap->getVar('descr'); |
|
| 174 | -// } |
|
| 175 | -// $form->addElement(new XoopsFormHidden($name.'_dataid', $name)); |
|
| 176 | -// $form->addElement(new XoopsFormText(_MD_GMAP_LON, $name.'_lon', 10, 30, $gmap_lon)); |
|
| 177 | -// $form->addElement(new XoopsFormText(_MD_GMAP_LAT, $name.'_lat', 10, 30, $gmap_lat)); |
|
| 178 | -// $form->addElement(new XoopsFormTextArea(_MD_GMAP_DESCR, $name.'_descr', $gmap_descr, 5, 50)); |
|
| 179 | -// break; |
|
| 180 | - case "radio": |
|
| 181 | - $options_arr = split("[|]",$options); |
|
| 182 | - $form_radio = new XoopsFormRadio($title, $name, $value, 1); |
|
| 183 | - foreach($options_arr as $option) { |
|
| 184 | - $form_radio->addOption($option, $option); |
|
| 185 | - } |
|
| 186 | - $form->addElement($form_radio); |
|
| 187 | - break; |
|
| 188 | - case "rating": |
|
| 189 | - $rating_options = array(1,2,3,4,5,6,7,8,9,10); |
|
| 190 | - $form_rating = new XoopsFormSelect($title, $name, $value, 1); |
|
| 191 | - $form_rating->addOption('0', '----'); |
|
| 192 | - foreach($rating_options as $option) { |
|
| 193 | - $form_rating->addOption($option, $option); |
|
| 194 | - } |
|
| 195 | - $form->addElement($form_rating); |
|
| 196 | - break; |
|
| 197 | - case "select": |
|
| 198 | - $options_arr = split("[|]",$options); |
|
| 199 | - $value_arr = split("[|]",$value); |
|
| 200 | - $form_select = new XoopsFormSelect($title, $name, $value, $size, $multiple); |
|
| 201 | - $form_select->addOption('-', '----'); |
|
| 202 | - $form_select->setValue($value_arr); |
|
| 203 | - foreach($options_arr as $key => $option) { |
|
| 204 | - $form_select->addOption($option, $option); |
|
| 205 | - } |
|
| 206 | - $form->addElement($form_select); |
|
| 207 | - break; |
|
| 208 | - case "textarea": |
|
| 209 | - if ($custom == '1') { |
|
| 210 | 242 | $form_textarea_tray = new XoopsFormElementTray($title, "", $name); |
| 211 | 243 | $form_textarea_tray->addElement(new XoopsFormLabel("", "<table><tr><td>")); |
| 212 | - $form_textarea_tray->addElement(new XoopsFormText("<b>"._MD_CUSTOM_TITLE."</b></td><td>", "custom".$name, 50, 250, $customtitle)); |
|
| 244 | + $form_textarea_tray->addElement(new XoopsFormText("<b>"._MD_FIELDNAMES_URL_TITLE."</b></td><td>", "url_title".$name, 50, 250, $link[1])); |
|
| 213 | 245 | $form_textarea_tray->addElement(new XoopsFormLabel("", "</td></tr><tr><td>")); |
| 214 | - $form_textarea_tray->addElement(new XoopsFormTextArea("<b>"._MD_CUSTOM_VALUE."</b></td><td>", $name, $value, $rows, $cols)); |
|
| 246 | + $form_textarea_tray->addElement(new XoopsFormText("<b>"._MD_FIELDNAMES_URL_LINK."</b></td><td>", "url_link".$name, 50, 250, $link[0])); |
|
| 215 | 247 | $form_textarea_tray->addElement(new XoopsFormLabel("", "</td></tr></table>")); |
| 216 | 248 | $form->addElement($form_textarea_tray); |
| 217 | - } else { |
|
| 218 | - $form->addElement(new XoopsFormTextArea($title, $name, $value, $rows, $cols)); |
|
| 219 | - } |
|
| 220 | - break; |
|
| 221 | - case "textbox": |
|
| 222 | - if ($custom == '1') { |
|
| 223 | - $form_text_tray = new XoopsFormElementTray($title, "", $name); |
|
| 224 | - $form_text_tray->addElement(new XoopsFormLabel("", "<table><tr><td>")); |
|
| 225 | - $form_text_tray->addElement(new XoopsFormText("<b>"._MD_CUSTOM_TITLE."</b></td><td>", "custom".$name, 50, 250, $customtitle)); |
|
| 226 | - $form_text_tray->addElement(new XoopsFormLabel("", "</td></tr><tr><td>")); |
|
| 227 | - $form_text_tray->addElement(new XoopsFormText("<b>"._MD_CUSTOM_VALUE."</b></td><td>", $name, $size, $maxsize, $value)); |
|
| 228 | - $form_text_tray->addElement(new XoopsFormLabel("", "</td></tr></table>")); |
|
| 229 | - $form->addElement($form_text_tray); |
|
| 230 | - } else { |
|
| 231 | - $form->addElement(new XoopsFormText($title, $name, 50, 250, $myts->makeTboxData4Show($value))); |
|
| 232 | - } |
|
| 233 | - break; |
|
| 234 | - case "url": |
|
| 235 | - if ($value != '') { |
|
| 236 | - $link = explode('|',$value); |
|
| 237 | - } else { |
|
| 238 | - $link = array(); |
|
| 239 | - $link[0] = ''; |
|
| 240 | - $link[1] = ''; |
|
| 241 | - } |
|
| 242 | - $form_textarea_tray = new XoopsFormElementTray($title, "", $name); |
|
| 243 | - $form_textarea_tray->addElement(new XoopsFormLabel("", "<table><tr><td>")); |
|
| 244 | - $form_textarea_tray->addElement(new XoopsFormText("<b>"._MD_FIELDNAMES_URL_TITLE."</b></td><td>", "url_title".$name, 50, 250, $link[1])); |
|
| 245 | - $form_textarea_tray->addElement(new XoopsFormLabel("", "</td></tr><tr><td>")); |
|
| 246 | - $form_textarea_tray->addElement(new XoopsFormText("<b>"._MD_FIELDNAMES_URL_LINK."</b></td><td>", "url_link".$name, 50, 250, $link[0])); |
|
| 247 | - $form_textarea_tray->addElement(new XoopsFormLabel("", "</td></tr></table>")); |
|
| 248 | - $form->addElement($form_textarea_tray); |
|
| 249 | - break; |
|
| 250 | - case "yesno": |
|
| 251 | - $form->addElement(new XoopsFormRadioyn($title, $name, $value, _YES, _NO)); |
|
| 252 | - break; |
|
| 253 | - default: |
|
| 254 | - echo $fieldtype." is an unknown field type."; |
|
| 255 | - break; |
|
| 249 | + break; |
|
| 250 | + case "yesno": |
|
| 251 | + $form->addElement(new XoopsFormRadioyn($title, $name, $value, _YES, _NO)); |
|
| 252 | + break; |
|
| 253 | + default: |
|
| 254 | + echo $fieldtype." is an unknown field type."; |
|
| 255 | + break; |
|
| 256 | 256 | } |
| 257 | 257 | } |
| 258 | 258 | |
@@ -391,30 +391,30 @@ discard block |
||
| 391 | 391 | global $form, $myts; |
| 392 | 392 | |
| 393 | 393 | switch ($fieldtype) { |
| 394 | - case "textbox": |
|
| 395 | - $this->createSearchField_text($title, $name, $value, $options); |
|
| 396 | - break; |
|
| 397 | - case "textarea": |
|
| 398 | - $this->createSearchField_text($title, $value, $options); |
|
| 399 | - break; |
|
| 400 | - case "yesno": |
|
| 401 | - $form->addElement(new XoopsFormRadioyn($title, $name, "", _YES, _NO)); |
|
| 402 | - break; |
|
| 403 | - case "radio": |
|
| 404 | - $this->createSearchField_select($title, $name, $value, $options); |
|
| 405 | - break; |
|
| 406 | - case "checkbox": |
|
| 407 | - $this->createSearchField_checkbox($title, $name, $value, $options); |
|
| 408 | - break; |
|
| 409 | - case "select": |
|
| 410 | - $this->createSearchField_checkbox($title, $name, $value, $options); |
|
| 411 | - break; |
|
| 412 | - case "dhtml": |
|
| 413 | - $this->createSearchField_text($title, $name, $value, $options); |
|
| 414 | - break; |
|
| 415 | - case "address": |
|
| 416 | - //Query all address fields associated with the address type that belongs to the locid. |
|
| 417 | - /* $addressfields = getAddressFields('0'); |
|
| 394 | + case "textbox": |
|
| 395 | + $this->createSearchField_text($title, $name, $value, $options); |
|
| 396 | + break; |
|
| 397 | + case "textarea": |
|
| 398 | + $this->createSearchField_text($title, $value, $options); |
|
| 399 | + break; |
|
| 400 | + case "yesno": |
|
| 401 | + $form->addElement(new XoopsFormRadioyn($title, $name, "", _YES, _NO)); |
|
| 402 | + break; |
|
| 403 | + case "radio": |
|
| 404 | + $this->createSearchField_select($title, $name, $value, $options); |
|
| 405 | + break; |
|
| 406 | + case "checkbox": |
|
| 407 | + $this->createSearchField_checkbox($title, $name, $value, $options); |
|
| 408 | + break; |
|
| 409 | + case "select": |
|
| 410 | + $this->createSearchField_checkbox($title, $name, $value, $options); |
|
| 411 | + break; |
|
| 412 | + case "dhtml": |
|
| 413 | + $this->createSearchField_text($title, $name, $value, $options); |
|
| 414 | + break; |
|
| 415 | + case "address": |
|
| 416 | + //Query all address fields associated with the address type that belongs to the locid. |
|
| 417 | + /* $addressfields = getAddressFields('0'); |
|
| 418 | 418 | $fieldtitles = array('address' => _MD_DF_ADDRESS, 'address2' => _MD_DF_ADDRESS2, 'zip' => _MD_DF_ZIP, 'postcode' => _MD_DF_POSTCODE, 'lat' => _MD_DF_LAT, 'lon' => _MD_DF_LON, 'phone' => _MD_DF_PHONE, 'fax' => _MD_DF_FAX, 'mobile' => _MD_DF_MOBILE, 'city' => _MD_DF_CITY, 'country' => _MD_DF_COUNTRY, 'typename' => _MD_DF_TYPENAME); |
| 419 | 419 | $form->addElement(new XoopsFormLabel("", "<strong>".$title."</strong>")); |
| 420 | 420 | foreach ($addressfields['addressfields'] as $field => $fieldvalue) { |
@@ -426,18 +426,18 @@ discard block |
||
| 426 | 426 | $form->addElement(new XoopsFormHidden("submitaddress","1")); |
| 427 | 427 | $form->addElement(new XoopsFormHidden($name, $value)); |
| 428 | 428 | $form->addElement(new XoopsFormHidden("addrid", $value)); */ |
| 429 | - break; |
|
| 430 | - case "rating": |
|
| 431 | - $this->createSearchField_rating($title, $name, $value, $options); |
|
| 432 | - break; |
|
| 433 | - case "date": |
|
| 434 | - $this->createSearchField_text($title, $name, $value, $options); |
|
| 435 | - break; |
|
| 436 | - case "url": |
|
| 437 | - $this->createSearchField_text($title, $name, $value, $options); |
|
| 438 | - default: |
|
| 439 | - echo $fieldtype." geen bekend veldtype "; |
|
| 440 | - break; |
|
| 429 | + break; |
|
| 430 | + case "rating": |
|
| 431 | + $this->createSearchField_rating($title, $name, $value, $options); |
|
| 432 | + break; |
|
| 433 | + case "date": |
|
| 434 | + $this->createSearchField_text($title, $name, $value, $options); |
|
| 435 | + break; |
|
| 436 | + case "url": |
|
| 437 | + $this->createSearchField_text($title, $name, $value, $options); |
|
| 438 | + default: |
|
| 439 | + echo $fieldtype." geen bekend veldtype "; |
|
| 440 | + break; |
|
| 441 | 441 | } |
| 442 | 442 | } |
| 443 | 443 | |
@@ -318,25 +318,25 @@ discard block |
||
| 318 | 318 | function getFieldValue($fieldtype="", $options="", $value=0) { |
| 319 | 319 | global $myts, $moddir; |
| 320 | 320 | switch ($fieldtype) { |
| 321 | - case "dhtml": |
|
| 322 | - return $myts->makeTareaData4Show($value); |
|
| 323 | - break; |
|
| 324 | - case "gmap": |
|
| 325 | - $gmapHandler = new efqGmapHandler(); |
|
| 326 | - $gmap = new efqGmap(); |
|
| 327 | - $gmap->setPointsJS($gmapHandler->getPointsJS($gmap)); |
|
| 328 | - $gmap->generateMap(); |
|
| 329 | - $ret = $gmap->showMap(); |
|
| 330 | - unset($gmap); |
|
| 331 | - unset($gmapHandler); |
|
| 332 | - return $ret; |
|
| 333 | - break; |
|
| 334 | - case "radio": |
|
| 335 | - return $myts->makeTboxData4Show($value); |
|
| 336 | - break; |
|
| 337 | - case "rating": |
|
| 338 | - $xoops_url = XOOPS_URL; |
|
| 339 | - switch ($value) { |
|
| 321 | + case "dhtml": |
|
| 322 | + return $myts->makeTareaData4Show($value); |
|
| 323 | + break; |
|
| 324 | + case "gmap": |
|
| 325 | + $gmapHandler = new efqGmapHandler(); |
|
| 326 | + $gmap = new efqGmap(); |
|
| 327 | + $gmap->setPointsJS($gmapHandler->getPointsJS($gmap)); |
|
| 328 | + $gmap->generateMap(); |
|
| 329 | + $ret = $gmap->showMap(); |
|
| 330 | + unset($gmap); |
|
| 331 | + unset($gmapHandler); |
|
| 332 | + return $ret; |
|
| 333 | + break; |
|
| 334 | + case "radio": |
|
| 335 | + return $myts->makeTboxData4Show($value); |
|
| 336 | + break; |
|
| 337 | + case "rating": |
|
| 338 | + $xoops_url = XOOPS_URL; |
|
| 339 | + switch ($value) { |
|
| 340 | 340 | case 1: |
| 341 | 341 | $src = "$xoops_url/modules/$moddir/images/rating_1.gif"; |
| 342 | 342 | break; |
@@ -369,30 +369,30 @@ discard block |
||
| 369 | 369 | break; |
| 370 | 370 | default: |
| 371 | 371 | $src = ""; |
| 372 | - } |
|
| 372 | + } |
|
| 373 | 373 | $rating = "<img src=\"$src\" />"; |
| 374 | 374 | return $rating; |
| 375 | 375 | break; |
| 376 | - case "select": |
|
| 377 | - return $myts->makeTboxData4Show($value); |
|
| 378 | - break; |
|
| 379 | - case "textbox": |
|
| 380 | - return $myts->makeTboxData4Show($value); |
|
| 381 | - break; |
|
| 382 | - case "url": |
|
| 383 | - $link = explode('|',$value); |
|
| 384 | - return '<a href="'.$myts->makeTboxData4Show($link[0]).'" title="'.$myts->makeTboxData4Show($link[1]).'">'.$myts->makeTboxData4Show($link[0]).'</a>'; |
|
| 385 | - break; |
|
| 386 | - case "yesno": |
|
| 387 | - if ($value == '1') { |
|
| 388 | - return _YES; |
|
| 389 | - } else { |
|
| 390 | - return _NO; |
|
| 391 | - } |
|
| 392 | - break; |
|
| 393 | - default: |
|
| 394 | - return $myts->makeTboxData4Show($value); |
|
| 395 | - break; |
|
| 376 | + case "select": |
|
| 377 | + return $myts->makeTboxData4Show($value); |
|
| 378 | + break; |
|
| 379 | + case "textbox": |
|
| 380 | + return $myts->makeTboxData4Show($value); |
|
| 381 | + break; |
|
| 382 | + case "url": |
|
| 383 | + $link = explode('|',$value); |
|
| 384 | + return '<a href="'.$myts->makeTboxData4Show($link[0]).'" title="'.$myts->makeTboxData4Show($link[1]).'">'.$myts->makeTboxData4Show($link[0]).'</a>'; |
|
| 385 | + break; |
|
| 386 | + case "yesno": |
|
| 387 | + if ($value == '1') { |
|
| 388 | + return _YES; |
|
| 389 | + } else { |
|
| 390 | + return _NO; |
|
| 391 | + } |
|
| 392 | + break; |
|
| 393 | + default: |
|
| 394 | + return $myts->makeTboxData4Show($value); |
|
| 395 | + break; |
|
| 396 | 396 | } |
| 397 | 397 | } |
| 398 | 398 | |
@@ -110,25 +110,25 @@ discard block |
||
| 110 | 110 | function getFieldValue($fieldtype="", $options="", $value=0) { |
| 111 | 111 | global $myts, $moddir; |
| 112 | 112 | switch ($fieldtype) { |
| 113 | - case "dhtml": |
|
| 114 | - return $myts->makeTareaData4Show($value); |
|
| 115 | - break; |
|
| 116 | - //case "gmap": |
|
| 117 | -// $gmapHandler = new efqGmapHandler(); |
|
| 118 | -// $gmap = new efqGmap(); |
|
| 119 | -// $gmap->setPointsJS($gmapHandler->getPointsJS($gmap)); |
|
| 120 | -// $gmap->generateMap(); |
|
| 121 | -// $ret = $gmap->showMap(); |
|
| 122 | -// unset($gmap); |
|
| 123 | -// unset($gmapHandler); |
|
| 124 | - //return $myts->makeTboxData4Show($value); |
|
| 125 | - //break; |
|
| 126 | - case "radio": |
|
| 127 | - return $myts->makeTboxData4Show($value); |
|
| 128 | - break; |
|
| 129 | - case "rating": |
|
| 130 | - $xoops_url = XOOPS_URL; |
|
| 131 | - switch ($value) { |
|
| 113 | + case "dhtml": |
|
| 114 | + return $myts->makeTareaData4Show($value); |
|
| 115 | + break; |
|
| 116 | + //case "gmap": |
|
| 117 | + // $gmapHandler = new efqGmapHandler(); |
|
| 118 | + // $gmap = new efqGmap(); |
|
| 119 | + // $gmap->setPointsJS($gmapHandler->getPointsJS($gmap)); |
|
| 120 | + // $gmap->generateMap(); |
|
| 121 | + // $ret = $gmap->showMap(); |
|
| 122 | + // unset($gmap); |
|
| 123 | + // unset($gmapHandler); |
|
| 124 | + //return $myts->makeTboxData4Show($value); |
|
| 125 | + //break; |
|
| 126 | + case "radio": |
|
| 127 | + return $myts->makeTboxData4Show($value); |
|
| 128 | + break; |
|
| 129 | + case "rating": |
|
| 130 | + $xoops_url = XOOPS_URL; |
|
| 131 | + switch ($value) { |
|
| 132 | 132 | case 1: |
| 133 | 133 | $src = "$xoops_url/modules/$moddir/images/rating_1.gif"; |
| 134 | 134 | break; |
@@ -161,30 +161,30 @@ discard block |
||
| 161 | 161 | break; |
| 162 | 162 | default: |
| 163 | 163 | $src = ""; |
| 164 | - } |
|
| 164 | + } |
|
| 165 | 165 | $rating = "<img src=\"$src\" />"; |
| 166 | 166 | return $rating; |
| 167 | 167 | break; |
| 168 | - case "select": |
|
| 169 | - return $myts->makeTboxData4Show($value); |
|
| 170 | - break; |
|
| 171 | - case "textbox": |
|
| 172 | - return $myts->makeTboxData4Show($value); |
|
| 173 | - break; |
|
| 174 | - case "url": |
|
| 175 | - $link = explode('|',$value); |
|
| 176 | - return '<a href="'.$myts->makeTboxData4Show($link[0]).'" title="'.$myts->makeTboxData4Show($link[1]).'">'.$myts->makeTboxData4Show($link[0]).'</a>'; |
|
| 177 | - break; |
|
| 178 | - case "yesno": |
|
| 179 | - if ($value == '1') { |
|
| 180 | - return _YES; |
|
| 181 | - } else { |
|
| 182 | - return _NO; |
|
| 183 | - } |
|
| 184 | - break; |
|
| 185 | - default: |
|
| 186 | - return $myts->makeTboxData4Show($value); |
|
| 187 | - break; |
|
| 168 | + case "select": |
|
| 169 | + return $myts->makeTboxData4Show($value); |
|
| 170 | + break; |
|
| 171 | + case "textbox": |
|
| 172 | + return $myts->makeTboxData4Show($value); |
|
| 173 | + break; |
|
| 174 | + case "url": |
|
| 175 | + $link = explode('|',$value); |
|
| 176 | + return '<a href="'.$myts->makeTboxData4Show($link[0]).'" title="'.$myts->makeTboxData4Show($link[1]).'">'.$myts->makeTboxData4Show($link[0]).'</a>'; |
|
| 177 | + break; |
|
| 178 | + case "yesno": |
|
| 179 | + if ($value == '1') { |
|
| 180 | + return _YES; |
|
| 181 | + } else { |
|
| 182 | + return _NO; |
|
| 183 | + } |
|
| 184 | + break; |
|
| 185 | + default: |
|
| 186 | + return $myts->makeTboxData4Show($value); |
|
| 187 | + break; |
|
| 188 | 188 | } |
| 189 | 189 | } |
| 190 | 190 | |
@@ -31,31 +31,31 @@ |
||
| 31 | 31 | // ------------------------------------------------------------------------- // |
| 32 | 32 | function convertorderbyin($orderby) { |
| 33 | 33 | switch (trim($orderby)) { |
| 34 | - case "titleA": |
|
| 35 | - $orderby = "title ASC"; |
|
| 36 | - break; |
|
| 37 | - case "dateA": |
|
| 38 | - $orderby = "created ASC"; |
|
| 39 | - break; |
|
| 40 | - case "hitsA": |
|
| 41 | - $orderby = "hits ASC"; |
|
| 42 | - break; |
|
| 43 | - case "ratingA": |
|
| 44 | - $orderby = "rating ASC"; |
|
| 45 | - break; |
|
| 46 | - case "titleD": |
|
| 47 | - $orderby = "title DESC"; |
|
| 48 | - break; |
|
| 49 | - case "hitsD": |
|
| 50 | - $orderby = "hits DESC"; |
|
| 51 | - break; |
|
| 52 | - case "ratingD": |
|
| 53 | - $orderby = "rating DESC"; |
|
| 54 | - break; |
|
| 55 | - case"dateD": |
|
| 56 | - default: |
|
| 57 | - $orderby = "created DESC"; |
|
| 58 | - break; |
|
| 34 | + case "titleA": |
|
| 35 | + $orderby = "title ASC"; |
|
| 36 | + break; |
|
| 37 | + case "dateA": |
|
| 38 | + $orderby = "created ASC"; |
|
| 39 | + break; |
|
| 40 | + case "hitsA": |
|
| 41 | + $orderby = "hits ASC"; |
|
| 42 | + break; |
|
| 43 | + case "ratingA": |
|
| 44 | + $orderby = "rating ASC"; |
|
| 45 | + break; |
|
| 46 | + case "titleD": |
|
| 47 | + $orderby = "title DESC"; |
|
| 48 | + break; |
|
| 49 | + case "hitsD": |
|
| 50 | + $orderby = "hits DESC"; |
|
| 51 | + break; |
|
| 52 | + case "ratingD": |
|
| 53 | + $orderby = "rating DESC"; |
|
| 54 | + break; |
|
| 55 | + case"dateD": |
|
| 56 | + default: |
|
| 57 | + $orderby = "created DESC"; |
|
| 58 | + break; |
|
| 59 | 59 | } |
| 60 | 60 | return $orderby; |
| 61 | 61 | } |
@@ -317,9 +317,9 @@ |
||
| 317 | 317 | $op = $_POST['op']; |
| 318 | 318 | } |
| 319 | 319 | switch ($op) { |
| 320 | - case "approve": |
|
| 321 | - approve(); |
|
| 322 | - break; |
|
| 320 | + case "approve": |
|
| 321 | + approve(); |
|
| 322 | + break; |
|
| 323 | 323 | case "deleteListingConfirm": |
| 324 | 324 | delListingConfirm(); |
| 325 | 325 | break; |
@@ -28,33 +28,33 @@ |
||
| 28 | 28 | //decide which post method to use |
| 29 | 29 | switch($paypal['post_method']) { |
| 30 | 30 | |
| 31 | -case "libCurl": //php compiled with libCurl support |
|
| 31 | + case "libCurl": //php compiled with libCurl support |
|
| 32 | 32 | |
| 33 | -$result=libCurlPost($paypal['url'],$_POST); |
|
| 33 | + $result=libCurlPost($paypal['url'],$_POST); |
|
| 34 | 34 | |
| 35 | 35 | |
| 36 | -break; |
|
| 36 | + break; |
|
| 37 | 37 | |
| 38 | 38 | |
| 39 | -case "curl": //cURL via command line |
|
| 39 | + case "curl": //cURL via command line |
|
| 40 | 40 | |
| 41 | -$result=curlPost($paypal['url'],$_POST); |
|
| 42 | -//print_r($result); |
|
| 43 | -break; |
|
| 41 | + $result=curlPost($paypal['url'],$_POST); |
|
| 42 | + //print_r($result); |
|
| 43 | + break; |
|
| 44 | 44 | |
| 45 | 45 | |
| 46 | -case "fso": //php fsockopen(); |
|
| 46 | + case "fso": //php fsockopen(); |
|
| 47 | 47 | |
| 48 | -$result=fsockPost($paypal['url'],$_POST); |
|
| 49 | -//print_r($result); |
|
| 50 | -break; |
|
| 48 | + $result=fsockPost($paypal['url'],$_POST); |
|
| 49 | + //print_r($result); |
|
| 50 | + break; |
|
| 51 | 51 | |
| 52 | 52 | |
| 53 | -default: //use the fsockopen method as default post method |
|
| 53 | + default: //use the fsockopen method as default post method |
|
| 54 | 54 | |
| 55 | -$result=fsockPost($paypal['url'],$_POST); |
|
| 56 | -//print_r($result); |
|
| 57 | -break; |
|
| 55 | + $result=fsockPost($paypal['url'],$_POST); |
|
| 56 | + //print_r($result); |
|
| 57 | + break; |
|
| 58 | 58 | |
| 59 | 59 | } |
| 60 | 60 | |
@@ -25,33 +25,33 @@ |
||
| 25 | 25 | //decide which post method to use |
| 26 | 26 | switch($paypal[post_method]) { |
| 27 | 27 | |
| 28 | -case "libCurl": //php compiled with libCurl support |
|
| 28 | + case "libCurl": //php compiled with libCurl support |
|
| 29 | 29 | |
| 30 | -$result=libCurlPost($paypal[url],$_POST); |
|
| 30 | + $result=libCurlPost($paypal[url],$_POST); |
|
| 31 | 31 | |
| 32 | 32 | |
| 33 | -break; |
|
| 33 | + break; |
|
| 34 | 34 | |
| 35 | 35 | |
| 36 | -case "curl": //cURL via command line |
|
| 36 | + case "curl": //cURL via command line |
|
| 37 | 37 | |
| 38 | -$result=curlPost($paypal[url],$_POST); |
|
| 39 | -//print_r($result); |
|
| 40 | -break; |
|
| 38 | + $result=curlPost($paypal[url],$_POST); |
|
| 39 | + //print_r($result); |
|
| 40 | + break; |
|
| 41 | 41 | |
| 42 | 42 | |
| 43 | -case "fso": //php fsockopen(); |
|
| 43 | + case "fso": //php fsockopen(); |
|
| 44 | 44 | |
| 45 | -$result=fsockPost($paypal[url],$_POST); |
|
| 46 | -//print_r($result); |
|
| 47 | -break; |
|
| 45 | + $result=fsockPost($paypal[url],$_POST); |
|
| 46 | + //print_r($result); |
|
| 47 | + break; |
|
| 48 | 48 | |
| 49 | 49 | |
| 50 | -default: //use the fsockopen method as default post method |
|
| 50 | + default: //use the fsockopen method as default post method |
|
| 51 | 51 | |
| 52 | -$result=fsockPost($paypal[url],$_POST); |
|
| 53 | -//print_r($result); |
|
| 54 | -break; |
|
| 52 | + $result=fsockPost($paypal[url],$_POST); |
|
| 53 | + //print_r($result); |
|
| 54 | + break; |
|
| 55 | 55 | |
| 56 | 56 | } |
| 57 | 57 | |
@@ -44,23 +44,23 @@ |
||
| 44 | 44 | $date = getdate($current_billto); |
| 45 | 45 | |
| 46 | 46 | switch($duration) { |
| 47 | - case '1': |
|
| 48 | - $billto = mktime( $date['hours'], $date['minutes'], $date['seconds'], $date['mon'], $date['mday']+ (1 * $count), $date['year'] ); |
|
| 49 | - break; |
|
| 50 | - case '2': |
|
| 51 | - $billto = mktime( $date['hours'], $date['minutes'], $date['seconds'], $date['mon'], $date['mday']+ (7 * $count), $date['year'] ); |
|
| 52 | - break; |
|
| 53 | - case '3': |
|
| 54 | - $billto = mktime( $date['hours'], $date['minutes'], $date['seconds'], $date['mon'] + (1 * $count), $date['mday'], $date['year'] ); |
|
| 55 | - break; |
|
| 56 | - case '4': |
|
| 57 | - $billto = mktime( $date['hours'], $date['minutes'], $date['seconds'], $date['mon'] + (3 * $count), $date['mday'], $date['year'] ); |
|
| 58 | - break; |
|
| 59 | - case '5': |
|
| 60 | - $billto = mktime( $date['hours'], $date['minutes'], $date['seconds'], $date['mon'], $date['mday'], $date['year'] + (1 * $count) ); |
|
| 61 | - break; |
|
| 62 | - default: |
|
| 63 | - $billto = ''; |
|
| 47 | + case '1': |
|
| 48 | + $billto = mktime( $date['hours'], $date['minutes'], $date['seconds'], $date['mon'], $date['mday']+ (1 * $count), $date['year'] ); |
|
| 49 | + break; |
|
| 50 | + case '2': |
|
| 51 | + $billto = mktime( $date['hours'], $date['minutes'], $date['seconds'], $date['mon'], $date['mday']+ (7 * $count), $date['year'] ); |
|
| 52 | + break; |
|
| 53 | + case '3': |
|
| 54 | + $billto = mktime( $date['hours'], $date['minutes'], $date['seconds'], $date['mon'] + (1 * $count), $date['mday'], $date['year'] ); |
|
| 55 | + break; |
|
| 56 | + case '4': |
|
| 57 | + $billto = mktime( $date['hours'], $date['minutes'], $date['seconds'], $date['mon'] + (3 * $count), $date['mday'], $date['year'] ); |
|
| 58 | + break; |
|
| 59 | + case '5': |
|
| 60 | + $billto = mktime( $date['hours'], $date['minutes'], $date['seconds'], $date['mon'], $date['mday'], $date['year'] + (1 * $count) ); |
|
| 61 | + break; |
|
| 62 | + default: |
|
| 63 | + $billto = ''; |
|
| 64 | 64 | } |
| 65 | 65 | |
| 66 | 66 | if ( $ordervalues['startdate'] < time() && $ordervalues[billto] == '' ) { |
@@ -81,61 +81,61 @@ discard block |
||
| 81 | 81 | $filter_arr = array(); |
| 82 | 82 | while(list($dtypeid, $dtypetitle, $dtypeoptions, $fieldtype) = $xoopsDB->fetchRow($result)) { |
| 83 | 83 | switch ($fieldtype) { |
| 84 | - case "textbox": |
|
| 85 | - $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 86 | - break; |
|
| 87 | - case "textarea": |
|
| 88 | - $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 89 | - break; |
|
| 90 | - case "yesno": |
|
| 91 | - $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 92 | - break; |
|
| 93 | - case "radio": |
|
| 94 | - $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 95 | - break; |
|
| 96 | - case "select": |
|
| 97 | - $selectarr = getPostedValue_array($dtypeid); |
|
| 98 | - $count_arr = count($selectarr); |
|
| 84 | + case "textbox": |
|
| 85 | + $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 86 | + break; |
|
| 87 | + case "textarea": |
|
| 88 | + $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 89 | + break; |
|
| 90 | + case "yesno": |
|
| 91 | + $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 92 | + break; |
|
| 93 | + case "radio": |
|
| 94 | + $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 95 | + break; |
|
| 96 | + case "select": |
|
| 97 | + $selectarr = getPostedValue_array($dtypeid); |
|
| 98 | + $count_arr = count($selectarr); |
|
| 99 | 99 | |
| 100 | - if ($count_arr >= 1) { |
|
| 101 | - foreach ($selectarr as $arr) { |
|
| 102 | - $selectarray[] = $arr['postvalue']; |
|
| 100 | + if ($count_arr >= 1) { |
|
| 101 | + foreach ($selectarr as $arr) { |
|
| 102 | + $selectarray[] = $arr['postvalue']; |
|
| 103 | + } |
|
| 104 | + $filter_arr[] = array('dtypeid' => $dtypeid, 'constr' => "equal", 'postvalue' => $selectarr['postvalue'], 'selectfields' => $selectarray, 'addressfields' => 0); |
|
| 103 | 105 | } |
| 104 | - $filter_arr[] = array('dtypeid' => $dtypeid, 'constr' => "equal", 'postvalue' => $selectarr['postvalue'], 'selectfields' => $selectarray, 'addressfields' => 0); |
|
| 105 | - } |
|
| 106 | - break; |
|
| 107 | - case "dhtml": |
|
| 108 | - $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 109 | - break; |
|
| 110 | - case "address": |
|
| 111 | - $addressarr = getPostedValue_address($dtypeid); |
|
| 112 | - $addressarray = array(); |
|
| 113 | - //$countarr = count($address |
|
| 114 | - if (is_array($addressarray) && count($addressarray) >= 1) { |
|
| 115 | - foreach ($addressarr as $arr) { |
|
| 116 | - $addressarray[] = array($arr['field'] => $arr['postvalue']); |
|
| 106 | + break; |
|
| 107 | + case "dhtml": |
|
| 108 | + $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 109 | + break; |
|
| 110 | + case "address": |
|
| 111 | + $addressarr = getPostedValue_address($dtypeid); |
|
| 112 | + $addressarray = array(); |
|
| 113 | + //$countarr = count($address |
|
| 114 | + if (is_array($addressarray) && count($addressarray) >= 1) { |
|
| 115 | + foreach ($addressarr as $arr) { |
|
| 116 | + $addressarray[] = array($arr['field'] => $arr['postvalue']); |
|
| 117 | + } |
|
| 118 | + $filter_arr[] = array('dtypeid' => $dtypeid, 'constr' => "equal", 'postvalue' => $arr['postvalue'], 'selectfields' => 0, 'addressfields' => $addressarray); |
|
| 117 | 119 | } |
| 118 | - $filter_arr[] = array('dtypeid' => $dtypeid, 'constr' => "equal", 'postvalue' => $arr['postvalue'], 'selectfields' => 0, 'addressfields' => $addressarray); |
|
| 119 | - } |
|
| 120 | - break; |
|
| 121 | - case "rating": |
|
| 122 | - $selectarr = getPostedValue_array($dtypeid); |
|
| 123 | - //$selectarr = getPostedValue_text($dtypeid); |
|
| 124 | - $count_arr = count($selectarr); |
|
| 120 | + break; |
|
| 121 | + case "rating": |
|
| 122 | + $selectarr = getPostedValue_array($dtypeid); |
|
| 123 | + //$selectarr = getPostedValue_text($dtypeid); |
|
| 124 | + $count_arr = count($selectarr); |
|
| 125 | 125 | |
| 126 | - if ($count_arr >= 1) { |
|
| 127 | - foreach ($selectarr as $arr) { |
|
| 128 | - $selectarray[] = $arr; |
|
| 126 | + if ($count_arr >= 1) { |
|
| 127 | + foreach ($selectarr as $arr) { |
|
| 128 | + $selectarray[] = $arr; |
|
| 129 | + } |
|
| 130 | + //echo $selectarr['postvalue']; |
|
| 131 | + $filter_arr[] = array('dtypeid' => $dtypeid, 'constr' => $selectarr['constr'], 'postvalue' => $selectarr['postvalue'], 'selectfields' => '', 'addressfields' => 0); |
|
| 129 | 132 | } |
| 130 | - //echo $selectarr['postvalue']; |
|
| 131 | - $filter_arr[] = array('dtypeid' => $dtypeid, 'constr' => $selectarr['constr'], 'postvalue' => $selectarr['postvalue'], 'selectfields' => '', 'addressfields' => 0); |
|
| 132 | - } |
|
| 133 | - break; |
|
| 134 | - case "date": |
|
| 135 | - $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 136 | - break; |
|
| 137 | - default: |
|
| 138 | - break; |
|
| 133 | + break; |
|
| 134 | + case "date": |
|
| 135 | + $filter_arr[] = getPostedValue_text($dtypeid); |
|
| 136 | + break; |
|
| 137 | + default: |
|
| 138 | + break; |
|
| 139 | 139 | } |
| 140 | 140 | } |
| 141 | 141 | if(isset($_POST['q'])) { |
@@ -390,40 +390,40 @@ discard block |
||
| 390 | 390 | ${"sql".$n} = ""; |
| 391 | 391 | //$zero_allowed = '1'; |
| 392 | 392 | switch ($constr) { |
| 393 | - case "equal": |
|
| 394 | - ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 395 | - $constraint = " = '".$postvalue."'"; |
|
| 396 | - break; |
|
| 397 | - case "notequal": |
|
| 398 | - ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 399 | - $constraint = " <> '".$postvalue."'"; |
|
| 400 | - break; |
|
| 401 | - case "contains": |
|
| 402 | - ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 403 | - $constraint = " LIKE '%".$postvalue."%'"; |
|
| 404 | - break; |
|
| 405 | - case "notcontain": |
|
| 406 | - ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 407 | - $constraint = " NOT LIKE '%".$postvalue."%'"; |
|
| 408 | - break; |
|
| 409 | - case "begins": |
|
| 410 | - ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 411 | - $constraint = " LIKE '".$postvalue."%'"; |
|
| 412 | - break; |
|
| 413 | - case "ends": |
|
| 414 | - ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 415 | - $constraint = " LIKE '%".$postvalue."'"; |
|
| 416 | - break; |
|
| 417 | - case "bigger": |
|
| 418 | - ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 419 | - $constraint = " > ".intval($postvalue).""; |
|
| 420 | - break; |
|
| 421 | - case "smaller": |
|
| 422 | - ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 423 | - $constraint = " < ".intval($postvalue).""; |
|
| 424 | - break; |
|
| 425 | - default: |
|
| 426 | - break; |
|
| 393 | + case "equal": |
|
| 394 | + ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 395 | + $constraint = " = '".$postvalue."'"; |
|
| 396 | + break; |
|
| 397 | + case "notequal": |
|
| 398 | + ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 399 | + $constraint = " <> '".$postvalue."'"; |
|
| 400 | + break; |
|
| 401 | + case "contains": |
|
| 402 | + ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 403 | + $constraint = " LIKE '%".$postvalue."%'"; |
|
| 404 | + break; |
|
| 405 | + case "notcontain": |
|
| 406 | + ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 407 | + $constraint = " NOT LIKE '%".$postvalue."%'"; |
|
| 408 | + break; |
|
| 409 | + case "begins": |
|
| 410 | + ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 411 | + $constraint = " LIKE '".$postvalue."%'"; |
|
| 412 | + break; |
|
| 413 | + case "ends": |
|
| 414 | + ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 415 | + $constraint = " LIKE '%".$postvalue."'"; |
|
| 416 | + break; |
|
| 417 | + case "bigger": |
|
| 418 | + ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 419 | + $constraint = " > ".intval($postvalue).""; |
|
| 420 | + break; |
|
| 421 | + case "smaller": |
|
| 422 | + ${"sql".$n} .= "SELECT DISTINCT i.itemid, i.title, i.uid, i.created, t.description FROM ".$xoopsDB->prefix("efqdiralpha1_data")." d, ".$xoopsDB->prefix("efqdiralpha1_items")." i LEFT JOIN ".$xoopsDB->prefix("efqdiralpha1_item_text")." t ON (t.itemid=i.itemid) WHERE d.itemid=i.itemid AND i.status='2'"; |
|
| 423 | + $constraint = " < ".intval($postvalue).""; |
|
| 424 | + break; |
|
| 425 | + default: |
|
| 426 | + break; |
|
| 427 | 427 | } |
| 428 | 428 | if ($postvalue != '0' ) { |
| 429 | 429 | ${"sql".$n} .= $andor." (d.dtypeid = ".$dtypeid." AND d.value ".$constraint.")"; |