4images Forum & Community
Welcome, Guest. Please login or register.
Did you miss your activation email?
May 26, 2018, 08:02:42 AM

Login with username, password and session length
Search:     Advanced search
You're looking for some 4images templates and styles? Then visit this thread to show websites with 4images templates to download.
Togle to toolbar
Translate this page with =>
Translate this page >
* Home Help Search Login Register
 
+  4images Forum & Community
|-+  4images Issues / Ausgaben
| |-+  Discussion & Troubleshooting (Moderators: Acidgod, ivan, Rembrandt)
| | |-+  Suchergebnissausgabe
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] 2 3 4 » »» Print
Author Topic: Suchergebnissausgabe  (Read 35752 times)
kubiczek
Full Member
***
Offline Offline

Posts: 211

Thank You
-Given: 35
-Receive: 10


View Profile WWW
« on: January 24, 2011, 09:05:47 PM »

Hallo,

kann mann die Suchergebnissausgabe so erweitern........


Suchkeyword:  zb. 2010


5. Grab-Bild5   ges. 5 mai
4. Grab-Bild4   ges. 4 april
3. Grab-Bild3   ges. 3 märz
2. Grab-Bild2   ges. 2 febuar
1. Grab-Bild1   ges. 1 januar


Also:  untereinander  und ohne thumbnails


bis jetzt muss ich jedes bild manuel in eine liste eintragen ist haufgen arbeit.

http://www.grosspeterwitz.org/friedhof/4images/verstorben.php

auch nach intensiver suche habe ich nichts endeckt was ich mir anpassen könnte.


mfg kubiczek







Logged
Rembrandt
Moderator
4images Guru
*****
Offline Offline

Posts: 4187

Thank You
-Given: 116
-Receive: 896

Vienna


View Profile WWW
« Reply #1 on: January 25, 2011, 05:51:40 AM »

suche in der search.php:
1
while ($image_row $site_db->fetch_array($result)) {
füge darüber ein:
1
$config['image_cells'] = 1;

suche:
1
2
3
4
    $thumbnails .= "<td width=\"".$imgtable_width."\" valign=\"top\">\n";
    
show_image($image_row"search");
    
$thumbnails .= $site_template->parse_template("thumbnail_bit");
    
$thumbnails .= "\n</td>\n";
ersetze es mit:
1
2
    $thumbnails .= "<td width=\"".$imgtable_width."\" valign=\"top\"><a href=\"./details.php?image_id=$image_row[image_id]\">".$image_row['image_name']."</a></td>\n";
    
$thumbnails .= "<td width=\"".$imgtable_width."\" valign=\"top\">".$image_row['image_gestorben']."</td>\n";

in der sql abfrage darüber, diese zeile:
1
ORDER BY ".$config['image_order']." ".$config['image_sort']."image_id ".$config['image_sort']."
kannst du zb. ändern in:
1
ORDER BY image_gestorben ASC 
oder statt "ASC" "DESC"


falls noch fragen sind bin am abend wieder online

mfg Andi
Logged

Meine 4Images Modifikationen  Now over 100 Modification Online!    Meine 4images Demo Seite


Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
kubiczek
Full Member
***
Offline Offline

Posts: 211

Thank You
-Given: 35
-Receive: 10


View Profile WWW
« Reply #2 on: January 25, 2011, 10:10:03 PM »

Hi

so weit so gut

habe mir das so eingebaut wie du mir es vorgeschlagen hast.  und auch schon um die spalte "image_geboren" erweitert.

dann als search1.php abgespeichert damit die normale suche weiterhin funktioniert.

nur die sortierung klappt nicht weder aufwärts noch abwärts (ASC DESC) ,  auch dann nicht wenn ich es in die orginall search.php einfüge.

http://www.grosspeterwitz.org/friedhof/4images/search1.php?search_keywords=2010

meine search1.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
<?php
/**************************************************************************
 *                                                                        *
 *    4images - A Web Based Image Gallery Management System               *
 *    ----------------------------------------------------------------    *
 *                                                                        *
 *             File: search.php                                           *
 *        Copyright: (C) 2002 Jan Sorgalla                                *
 *            Email: jan@4homepages.de                                    *
 *              Web: http://www.4homepages.de                             *
 *    Scriptversion: 1.7.6                                                *
 *                                                                        *
 *    Never released without support from: Nicky (http://www.nicky.net)   *
 *                                                                        *
 **************************************************************************
 *                                                                        *
 *    Dieses Script ist KEINE Freeware. Bitte lesen Sie die Lizenz-       *
 *    bedingungen (Lizenz.txt) für weitere Informationen.                 *
 *    ---------------------------------------------------------------     *
 *    This script is NOT freeware! Please read the Copyright Notice       *
 *    (Licence.txt) for further information.                              *
 *                                                                        *
 *************************************************************************/

$main_template 'search';

define('GET_CACHES'1);
define('ROOT_PATH''./');
include(
ROOT_PATH.'global.php');
require(
ROOT_PATH.'includes/sessions.php');
$user_access get_permission();
include(
ROOT_PATH.'includes/search_utils.php');
error_reporting(E_ALL);
$org_search_keywords $search_keywords;
$org_search_user $search_user;

if (isset(
$HTTP_GET_VARS['search_terms']) || isset($HTTP_POST_VARS['search_terms'])) {
  
$search_terms = isset($HTTP_POST_VARS['search_terms']) ? $HTTP_POST_VARS['search_terms'] : $HTTP_GET_VARS['search_terms'];
  
$search_terms $search_terms == "all" 0;
}
else {
  
$search_terms 0;
}

if (isset(
$HTTP_GET_VARS['search_fields']) || isset($HTTP_POST_VARS['search_fields'])) {
  
$search_fields = isset($HTTP_POST_VARS['search_fields']) ? trim($HTTP_POST_VARS['search_fields']) : trim($HTTP_GET_VARS['search_fields']);
}
else {
  
$search_fields "all";
}

$search_cat $cat_id;

$search_id = array();

if (
$search_user != "" && $show_result == 1) {
  
$search_user str_replace('*''%'trim($search_user));
  
$sql "SELECT ".get_user_table_field("""user_id")."
          FROM "
.USERS_TABLE."
          WHERE "
.get_user_table_field("""user_name")." LIKE '$search_user'";
  
$result $site_db->query($sql);
  
$light_activity "";
  
$search_id['user_ids'] = "";
  if (
$result) {
    while (
$row $site_db->fetch_array($result)) {
      
$search_id['user_ids'] .= (($search_id['user_ids'] != "") ? ", " "").$row[$user_table_fields['user_id']];
    }
    
$site_db->free_result($result);
  }
}

if (
$search_keywords != "" && $show_result == 1) {
  
$split_words prepare_searchwords($search_keywordstrue);

  
$match_field_sql = ($search_fields != "all" && isset($search_match_fields[$search_fields])) ? "AND m.".$search_match_fields[$search_fields]." = 1" "";
  
$search_word_cache = array();
  for (
$i 0$i sizeof($split_words); $i++) {
    if (
$split_words[$i] == "and" || $split_words[$i] == "und" || $split_words[$i] == "or" || $split_words[$i] == "oder" || $split_words[$i] == "not") {
      
$search_word_cache[$i] = ($search_terms) ? "and" $split_words[$i];
    }
    else {
      
$sql "SELECT m.image_id
              FROM ("
.WORDLIST_TABLE." w, ".WORDMATCH_TABLE." m)
              WHERE w.word_text LIKE '"
.addslashes(str_replace("*""%"$split_words[$i]))."'
              AND m.word_id = w.word_id
              
$match_field_sql";
      
$result $site_db->query($sql);
      
$search_word_cache[$i] = array();
      while (
$row $site_db->fetch_array($result)) {
        
$search_word_cache[$i][$row['image_id']] = 1;
      }
      
$site_db->free_result();
    }
  }

  
$is_first_word 1;
  
$operator "or";
  
$image_id_list = array();
  for (
$i 0$i sizeof($search_word_cache); $i++) {
    if (
$search_word_cache[$i] == "and" || $search_word_cache[$i] == "und" || $search_word_cache[$i] == "or" || $search_word_cache[$i] == "oder" || $search_word_cache[$i] == "not") {
      if (!
$is_first_word) {
        
$operator $search_word_cache[$i];
      }
    }
    elseif (
is_array($search_word_cache[$i])) {
      if (
$search_terms) {
        
$operator "and";
      }
      foreach (
$search_word_cache[$i] as $key => $val) {
        if (
$is_first_word || $operator == "or" || $operator == "oder") {
          
$image_id_list[$key] = 1;
        }
        elseif (
$operator == "not") {
          unset(
$image_id_list[$key]);
        }
      }
      if ((
$operator == "and" || $operator == "und") && !$is_first_word) {
        foreach (
$image_id_list as $key => $val) {
          if (!isset(
$search_word_cache[$i][$key])) {
            unset(
$image_id_list[$key]);
          }
        }
      }
    }
    
$is_first_word 0;
  }

  
$search_id['image_ids'] = "";
  foreach (
$image_id_list as $key => $val) {
    
$search_id['image_ids'] .= (($search_id['image_ids'] != "") ? ", " "").$key;
  }
  unset(
$image_id_list);
}

if (
$search_new_images && $show_result == 1) {
  
$search_id['search_new_images'] = 1;
}

if (
$search_cat && $show_result == 1) {
  
$search_id['search_cat'] = $search_cat;
}

if (!empty(
$search_id)) {
  
$site_sess->set_session_var("search_id"serialize($search_id));
}

include(
ROOT_PATH.'includes/page_header.php');

$num_rows_all 0;
if (
$show_result == 1) {
  if (empty(
$search_id)) {
    if (!empty(
$session_info['search_id'])) {
      
$search_id unserialize($session_info['search_id']);
    } else {
      
$search_id unserialize($site_sess->get_session_var("search_id"));
    }
  }

  
$sql_where_query "";

  if (!empty(
$search_id['image_ids'])) {
    
$sql_where_query .= "AND i.image_id IN (".$search_id['image_ids'].") ";
  }

  if (!empty(
$search_id['user_ids'])) {
    
$sql_where_query .= "AND i.user_id IN (".$search_id['user_ids'].") ";
  }

  if (!empty(
$search_id['search_new_images']) && $search_id['search_new_images'] == 1) {
    
$new_cutoff time() - 60 60 24 $config['new_cutoff'];
    
$sql_where_query .= "AND i.image_date >= $new_cutoff ";
  }

  if (!empty(
$search_id['search_cat']) && $search_id['search_cat'] != 0) {
    
$cat_id_sql 0;
    if (
check_permission("auth_viewcat"$search_id['search_cat'])) {
      
$sub_cat_ids get_subcat_ids($search_id['search_cat'], $search_id['search_cat'], $cat_parent_cache);
      
$cat_id_sql .= ", ".$search_id['search_cat'];
      if (!empty(
$sub_cat_ids[$search_id['search_cat']])) {
        foreach (
$sub_cat_ids[$search_id['search_cat']] as $val) {
          if (
check_permission("auth_viewcat"$val)) {
            
$cat_id_sql .= ", ".$val;
          }
        }
      }
    }
    
$cat_id_sql $cat_id_sql !== "AND i.cat_id IN ($cat_id_sql)" "";
  }
  else {
    
$cat_id_sql get_auth_cat_sql("auth_viewcat""NOTIN");
    
$cat_id_sql $cat_id_sql !== "AND i.cat_id NOT IN (".$cat_id_sql.")" "";
  }

  if (!empty(
$sql_where_query)) {
    
$sql "SELECT COUNT(*) AS num_rows_all
            FROM "
.IMAGES_TABLE." i
            WHERE i.image_active = 1 
$sql_where_query
            
$cat_id_sql";
    
$row $site_db->query_firstrow($sql);
    
$num_rows_all $row['num_rows_all'];
  }
}

if (!
$num_rows_all && $show_result == 1)  {
  
$msg preg_replace("/".$site_template->start."search_keywords".$site_template->end."/"$search_keywords$lang['search_no_results']);
}

//-----------------------------------------------------
//--- Show Search Results -----------------------------
//-----------------------------------------------------
if ($num_rows_all && $show_result == 1)  {
  
$link_arg $site_sess->url(ROOT_PATH."search1.php?show_result=1");

  include(
ROOT_PATH.'includes/paging.php');
  
$getpaging = new Paging($page$perpage$num_rows_all$link_arg);
  
$offset $getpaging->get_offset();
  
$site_template->register_vars(array(
    
"paging" => $getpaging->get_paging(),
    
"paging_stats" => $getpaging->get_paging_stats()
  ));

  
$imgtable_width ceil((intval($config['image_table_width'])) / $config['image_cells']);
  if ((
substr($config['image_table_width'], -1)) == "%") {
    
$imgtable_width .= "%";
  }

  
$additional_sql "";
  if (!empty(
$additional_image_fields)) {
    foreach (
$additional_image_fields as $key => $val) {
      
$additional_sql .= ", i.".$key;
    }
  }

  
$sql "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits".$additional_sql.", c.cat_name".get_user_table_field(", u.""user_name")."
          FROM ("
.IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
          LEFT JOIN "
.USERS_TABLE." u ON (".get_user_table_field("u.""user_id")." = i.user_id)
          WHERE i.image_active = 1
          
$sql_where_query
          AND c.cat_id = i.cat_id 
$cat_id_sql
          ORDER BY image_gestorbenGP ASC 
          LIMIT 
$offset$perpage";
  
$result $site_db->query($sql);

  
$thumbnails "<table width=\"".$config['image_table_width']."\" border=\"0\" cellpadding=\"".$config['image_table_cellpadding']."\" cellspacing=\"".$config['image_table_cellspacing']."\">\n";

  
$count 0;
  
$bgcounter 0;
  
$config['image_cells'] = 1;
  while (
$image_row $site_db->fetch_array($result)) {
    if (
$count == 0) {
      
$row_bg_number = ($bgcounter++ % == 0) ? 2;
      
$thumbnails .= "<tr class=\"imagerow".$row_bg_number."\">\n";
    }
$thumbnails .= "<td width=\"".$imgtable_width."\" valign=\"top\">".$image_row['image_gestorbenGP']."</td>\n";
	
$thumbnails .= "<td width=\"".$imgtable_width."\" valign=\"top\"><a href=\"./details.php?image_id=$image_row[image_id]\">".$image_row['image_name']."</a></td>\n";
	
$thumbnails .= "<td width=\"".$imgtable_width."\" valign=\"top\">".$image_row['image_geboren']."</td>\n";
    
$count++;
    if (
$count == $config['image_cells']) {
      
$thumbnails .= "</tr>\n";
      
$count 0;
    }
  } 
// end while
  
if ($count 0)  {
    
$leftover = ($config['image_cells'] - $count);
    if (
$leftover >= 1) {
      for (
$i 0$i $leftover$i++) {
        
$thumbnails .= "<td width=\"".$imgtable_width."\">\n&nbsp;\n</td>\n";
      }
      
$thumbnails .= "</tr>\n";
    }
  }
  
$thumbnails .= "</table>\n";
  
$content $thumbnails;
  unset(
$thumbnails);
// end if
else {
  
$site_template->register_vars(array(
    
"search_keywords" => format_text(stripslashes($org_search_keywords), 2),
    
"search_user" => format_text(stripslashes($org_search_user), 2),
    
"lang_search_by_keyword" => $lang['search_by_keyword'],
    
"lang_search_by_username" => $lang['search_by_username'],
    
"lang_new_images_only" => $lang['new_images_only'],
    
"lang_search_terms" => $lang['search_terms'],
    
"lang_or" => $lang['or'],
    
"lang_and" => $lang['and'],
    
"lang_category" => $lang['category'],
    
"lang_search_fields" => $lang['search_fields'],
    
"lang_all_fields" => $lang['all_fields'],
    
"lang_name_only" => $lang['name_only'],
    
"lang_description_only" => $lang['description_only'],
    
"lang_keywords_only" => $lang['keywords_only'],
    
"category_dropdown" => get_category_dropdown($cat_id)
  ));

  if (!empty(
$additional_image_fields)) {
    
$additional_field_array = array();
    foreach (
$additional_image_fields as $key => $val) {
      if (isset(
$lang[$key.'_only'])) {
        
$additional_field_array['lang_'.$key.'_only'] = $lang[$key.'_only'];
      }
    }
    if (!empty(
$additional_field_array)) {
      
$site_template->register_vars($additional_field_array);
    }
  }
  
$content $site_template->parse_template("search_form");
}



//-----------------------------------------------------
//--- Clickstream -------------------------------------
//-----------------------------------------------------
$clickstream "<span class=\"clickstream\"><a href=\"".$site_sess->url(ROOT_PATH."index.php")."\" class=\"clickstream\">".$lang['home']."</a>".$config['category_separator'].$lang['search']."</span>";

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(array(
  
"content" => $content,
  
"msg" => $msg,
  
  
"clickstream" => $clickstream,
  
"lang_search" => $lang['search']
));
$site_template->print_template($site_template->parse_template($main_template));
include(
ROOT_PATH.'includes/page_footer.php');
?>

Logged
Rembrandt
Moderator
4images Guru
*****
Offline Offline

Posts: 4187

Thank You
-Given: 116
-Receive: 896

Vienna


View Profile WWW
« Reply #3 on: January 26, 2011, 05:07:02 AM »

...habe mir das so eingebaut wie du mir es vorgeschlagen hast.  und auch schon um die spalte "image_geboren" erweitert.....
das war nur als beispl.  gedacht "image_geboren",  ich habe ja keine ahnung wo du das datum bisher eingetragen hast.  Very Happy
füge "i.image_gestorbenGP" mal in die "SELECT" hinzu.
Logged

Meine 4Images Modifikationen  Now over 100 Modification Online!    Meine 4images Demo Seite


Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
kubiczek
Full Member
***
Offline Offline

Posts: 211

Thank You
-Given: 35
-Receive: 10


View Profile WWW
« Reply #4 on: January 26, 2011, 05:44:31 AM »

hallo

das habe ich schon gemacht,

1
2
3
4
5
6
7
8
 $sql "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_media_file, i.image_thumb_file, i.image_download_url, i.image_allow_comments, i.image_comments, i.image_downloads, i.image_votes, i.image_rating, i.image_hits, i.image_gestorbenGP".$additional_sql.", c.cat_name".get_user_table_field(", u.""user_name")."
          FROM ("
.IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c)
          LEFT JOIN "
.USERS_TABLE." u ON (".get_user_table_field("u.""user_id")." = i.user_id)
          WHERE i.image_active = 1
          
$sql_where_query
          AND c.cat_id = i.cat_id 
$cat_id_sql
          ORDER BY image_gestorbenGP ASC 
          LIMIT 
$offset$perpage";

komischerweise funktioniert es mit image_date image_name usw.  einwandfrei.

kann es sein das image_geborenGP noch in einer anderen Datei defeniert werden muss?
Logged
Rembrandt
Moderator
4images Guru
*****
Offline Offline

Posts: 4187

Thank You
-Given: 116
-Receive: 896

Vienna


View Profile WWW
« Reply #5 on: January 26, 2011, 05:49:27 AM »

....
kann es sein das image_geborenGP noch in einer anderen Datei defeniert werden muss?
nein, dein problem wird sein das du es in der DB als textfeld deklariert hast das kannst du dann nicht sortieren.
Logged

Meine 4Images Modifikationen  Now over 100 Modification Online!    Meine 4images Demo Seite


Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
kubiczek
Full Member
***
Offline Offline

Posts: 211

Thank You
-Given: 35
-Receive: 10


View Profile WWW
« Reply #6 on: January 26, 2011, 06:48:36 AM »

Dann habe ich ein Problem.

denn das Datum ist als varchar(255) in sql eingetragen zb 20.01.2010

wenn ich es ändere verschwinden alle einträge es wird nur 0000:00:00 angezeigt
Logged
Rembrandt
Moderator
4images Guru
*****
Offline Offline

Posts: 4187

Thank You
-Given: 116
-Receive: 896

Vienna


View Profile WWW
« Reply #7 on: January 26, 2011, 07:51:50 AM »

du möchtest doch nach sterbedatum sortiere, wie wäre es wenn du das feld image_date dazu verwendest?
dann würde das alles funktionieren.
Logged

Meine 4Images Modifikationen  Now over 100 Modification Online!    Meine 4images Demo Seite


Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
kubiczek
Full Member
***
Offline Offline

Posts: 211

Thank You
-Given: 35
-Receive: 10


View Profile WWW
« Reply #8 on: January 26, 2011, 06:36:20 PM »

klingt logisch, 

aber wie kopiere ich das image_gestorbenGP  in das image_date feld

einfach exportieren in mysql geht nicht.


ich habe  schon an die 1500 bilder mit sterbedatum beschrifftet


du hast doch bestimmt eine kleine ZAUBERFORMEL Rolling Eyes  in der Hintertür?

Logged
Rembrandt
Moderator
4images Guru
*****
Offline Offline

Posts: 4187

Thank You
-Given: 116
-Receive: 896

Vienna


View Profile WWW
« Reply #9 on: January 26, 2011, 07:05:51 PM »

 
aber wie kopiere ich das image_gestorbenGP  in das image_date feld

...
du hast doch bestimmt eine kleine ZAUBERFORMEL Rolling Eyes  in der Hintertür?
*schluck* ich ahne schlimmes....   Laughing
in welchen format steht den das datum in der "image_gestorbenGP" kopier mal einen inhalt von einen feld hier rein.
Logged

Meine 4Images Modifikationen  Now over 100 Modification Online!    Meine 4images Demo Seite


Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
kubiczek
Full Member
***
Offline Offline

Posts: 211

Thank You
-Given: 35
-Receive: 10


View Profile WWW
« Reply #10 on: January 26, 2011, 09:11:34 PM »

so

hier ein auszug aus der _images

Quote  [Expand]
CREATE TABLE IF NOT EXISTS `friedhof_images` (
  `image_id` mediumint(Cool NOT NULL auto_increment,
  `image_gmap_longitude` varchar(20) NOT NULL,
  `cat_id` mediumint(Cool NOT NULL default '0',
  `user_id` mediumint(Cool NOT NULL default '0',
  `image_name` varchar(255) NOT NULL default '',
  `image_description` text NOT NULL,
  `image_keywords` text NOT NULL,
  `image_date` int(11) unsigned NOT NULL default '0',
  `image_active` tinyint(1) NOT NULL default '1',
  `image_media_file` varchar(255) NOT NULL default '',
  `image_thumb_file` varchar(255) NOT NULL default '',
  `image_download_url` varchar(255) NOT NULL default '',
  `image_allow_comments` tinyint(1) NOT NULL default '1',
  `image_comments` smallint(6) NOT NULL default '0',
  `image_downloads` smallint(6) NOT NULL default '0',
  `image_votes` smallint(6) NOT NULL default '0',
  `image_rating` decimal(4,2) NOT NULL default '0.00',
  `image_hits` mediumint(Cool NOT NULL default '0',
  `image_pin_allow` tinyint(1) default '0',
  `image_gmap_latitude` varchar(20) NOT NULL,
  `image_gmap_zoom` char(2) NOT NULL,
  `image_gmap_type` tinyint(1) NOT NULL,
  `image_gmap_show` tinyint(1) NOT NULL,
  `image_dienstgrad` varchar(255) NOT NULL,
  `image_gefallenam` varchar(255) NOT NULL,
  `image_gefallenin` varchar(255) NOT NULL,
  `image_begraben` varchar(255) NOT NULL,
  `image_geboren` varchar(255) NOT NULL,
  `image_geborenin` varchar(255) NOT NULL,
  `image_lage` varchar(255) NOT NULL,
  `image_truppenteil` varchar(255) NOT NULL,
  `image_strassen` varchar(255) NOT NULL,
  `image_gestorbenGP` varchar(255) NOT NULL,
  `image_group` int(10) NOT NULL default '0',
  `image_group_image` int(10) NOT NULL default '0',
  `image_photograph` varchar(255) NOT NULL,
  `image_Make` varchar(50) NOT NULL,
  `image_Model` varchar(50) NOT NULL,
  `image_DateTimeOriginal` varchar(50) NOT NULL,
  `image_ISOSpeedRatings` varchar(20) NOT NULL,
  `image_ExposureTime` varchar(20) NOT NULL,
  `image_FNumber` varchar(20) NOT NULL,
  `image_FocalLength` varchar(20) NOT NULL,
  `image_ExposureBiasValue` varchar(20) NOT NULL,
  `image_ApertureValue` varchar(20) NOT NULL,
  `image_MaxApertureValue` varchar(20) NOT NULL,
  `image_MeteringMode` varchar(50) NOT NULL,
  `image_Flash` varchar(100) NOT NULL,
  `image_ExposureProgram` varchar(50) NOT NULL,
  `image_ExposureMode` varchar(50) NOT NULL,
  `image_WhiteBalance` varchar(50) NOT NULL,
  `image_GPSLatitude` varchar(20) NOT NULL,
  `image_GPSLatitudeRef` varchar(20) NOT NULL,
  `image_GPSLongitude` varchar(20) NOT NULL,
  `image_GPSLongitudeRef` varchar(20) NOT NULL,
  `image_GPSAltitude` varchar(20) NOT NULL,
  `image_GPSTrack` varchar(20) NOT NULL,
  `image_gebaut` varchar(255) NOT NULL,
  PRIMARY KEY  (`image_id`),
  KEY `cat_id` (`cat_id`),
  KEY `user_id` (`user_id`),
  KEY `image_date` (`image_date`),
  KEY `image_active` (`image_active`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3065 ;

--
-- Daten für Tabelle `friedhof_images`
--

INSERT INTO `friedhof_images` (`image_id`, `image_gmap_longitude`, `cat_id`, `user_id`, `image_name`, `image_description`, `image_keywords`, `image_date`, `image_active`, `image_media_file`, `image_thumb_file`, `image_download_url`, `image_allow_comments`, `image_comments`, `image_downloads`, `image_votes`, `image_rating`, `image_hits`, `image_pin_allow`, `image_gmap_latitude`, `image_gmap_zoom`, `image_gmap_type`, `image_gmap_show`, `image_dienstgrad`, `image_gefallenam`, `image_gefallenin`, `image_begraben`, `image_geboren`, `image_geborenin`, `image_lage`, `image_truppenteil`, `image_strassen`, `image_gestorbenGP`, `image_group`, `image_group_image`, `image_photograph`, `image_Make`, `image_Model`, `image_DateTimeOriginal`, `image_ISOSpeedRatings`, `image_ExposureTime`, `image_FNumber`, `image_FocalLength`, `image_ExposureBiasValue`, `image_ApertureValue`, `image_MaxApertureValue`, `image_MeteringMode`, `image_Flash`, `image_ExposureProgram`, `image_ExposureMode`, `image_WhiteBalance`, `image_GPSLatitude`, `image_GPSLatitudeRef`, `image_GPSLongitude`, `image_GPSLongitudeRef`, `image_GPSAltitude`, `image_GPSTrack`, `image_gebaut`) VALUES
(1, '', 2, 129, 'Kubiczek Marta', '', '', 1077375757, 1, 'Kubiczek_Marta.JPG', 'Kubiczek_Marta.JPG', '', 1, 0, 0, 1, 1.00, 155, 1, '', '', 0, 0, '', '', '', '', '', '', '', '', '', '', 326, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(2, '', 2, 129, 'Kubiczek Marta', '', '', 1077375894, 1, 'Kubiczek_Marta1.JPG', 'Kubiczek_Marta1.JPG', '', 1, 0, 0, 5, 1.00, 195, 1, '', '', 0, 0, '', '', '', '', '05.03.1891', '', '', '', '', '03.01.1971', 326, 326, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(3, '', 3, 129, 'Kaul Alois', '', '', 1077375983, 1, 'Kaul_Alois__Sittek_Maria.JPG', 'Kaul_Alois__Sittek_Maria.JPG', '', 1, 0, 0, 7, 1.00, 171, 1, '', '', 0, 0, '', '', '', '', '', '', '', '', '', '', 317, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(4, '', 3, 129, 'Kaul Alois', '', '', 1077375983, 1, 'Kaul_Alois__Sittek_Maria1.JPG', 'Kaul_Alois__Sittek_Maria1.JPG', '', 1, 0, 0, 3, 1.00, 175, 1, '', '', 0, 0, '', '', '', '', '1902', '', '', '', '', '1976', 317, 317, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(5, '', 7, 129, 'Abrahamczyk Stefan', '', '', 1077387249, 1, 'Abrahamczyk_Stefan_Gertruda.JPG', 'Abrahamczyk_Stefan_Gertruda.JPG', '', 1, 0, 0, 0, 0.00, 161, 1, '', '', 0, 0, '', '', '', '', '26.12.1878', '', '', '', '', '09.06.1962', 59, 59, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(6, '', 7, 129, 'Abrahamczyk Gertruda', '', '', 1077387249, 1, 'Abrahamczyk_Stefan_Gertruda1.JPG', 'Abrahamczyk_Stefan_Gertruda1.JPG', '', 1, 0, 0, 0, 0.00, 144, 1, '', '', 0, 0, '', '', '', '', '29.01.1914', '', '', '', '', '27.07.1989', 59, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),

in das feld images_gestorbenGP  wird zb. "01.01.1954" eingetragen   und so gespeichert,   im images_data  wird ein zahlencode in der datenbank gespeichert

da blicke ich ehrlich gesagt garnet durch.

Logged
Rembrandt
Moderator
4images Guru
*****
Offline Offline

Posts: 4187

Thank You
-Given: 116
-Receive: 896

Vienna


View Profile WWW
« Reply #11 on: January 27, 2011, 07:53:23 AM »

ersetze in der SLQ abfrage oben, die zeile:
1
ORDER BY image_gestorbenGP ASC
mit dieser:
1
ORDER BY  STR_TO_DATE(image_gestorbenGP'%d.%m.%Y'DESC

mfg Andi
Logged

Meine 4Images Modifikationen  Now over 100 Modification Online!    Meine 4images Demo Seite


Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
kubiczek
Full Member
***
Offline Offline

Posts: 211

Thank You
-Given: 35
-Receive: 10


View Profile WWW
« Reply #12 on: January 27, 2011, 08:10:27 PM »

hallo,

das ist ja klasse,  funktioniert einwandfrei.

ich habe mich auch schon hiermit beschäftigt
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

der selbe gedanke
1
STR_TO_DATE(

einfach danke Wink  , hafen zeit hast Du mir erspart

gruß


Logged
Rembrandt
Moderator
4images Guru
*****
Offline Offline

Posts: 4187

Thank You
-Given: 116
-Receive: 896

Vienna


View Profile WWW
« Reply #13 on: January 27, 2011, 08:18:20 PM »

*puh* gott sei dank..  Very Happy
Logged

Meine 4Images Modifikationen  Now over 100 Modification Online!    Meine 4images Demo Seite


Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
kubiczek
Full Member
***
Offline Offline

Posts: 211

Thank You
-Given: 35
-Receive: 10


View Profile WWW
« Reply #14 on: January 27, 2011, 10:22:23 PM »

Ich hoffe ich verlange nicht zu viel

aber wenn es ohne grossen zeitlichen aufwand verbunden ist.......

habe schon vor 2-3 jahren damit angefangen alle gräber mit datum zu beschriften (wenn mir langweilig war, immer nur ein bissel ) in ca  6 Monaten werde ich fertig sein.

dann  will ich so eine art statistic ausgeben.   

 .....sehe selbst.
http://www.grosspeterwitz.org/friedhof/4images/geb.php

was mir fehlt ist Berechnung  zwischen image_geboren und image_gestorbenGP im bezug auf das heutige(aktuelle) datum

das folgende script habe ich mir zusammengeklaut und angepasst

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66



<table width="75%" border="1">
  <
tr>
    <
td><?php


	

mysql_connect("localhost","*********","*************") or die(mysql_error());
mysql_select_db("********") or die(mysql_error());
 


$datum=strftime("%m");
$datum3=strftime("%d%m");
$dat1=mysql_query("SELECT image_name, image_geboren , image_id FROM friedhof_images  ORDER BY image_geboren");

while(
$dat=mysql_fetch_array($dat1)) {
        
$datum1$dat[image_geboren];
        
$datum2explode("."$datum1);
        if(
$datum2[0].$datum2[1] == $datum3) {
//hier wird ein Geburtstag am aktuellen Tag angezeigt
                
echo "<b>Heute hat <a href=\"./details.php?image_id=$dat[image_id]\">".$dat[image_name]."</a> geb. ".$dat[image_geboren]." ?? Geburtstag</b>"."<br>";
        }
        if(
$datum2[1] == $datum and $datum2[0].$datum2[1] > $datum3 ) {






//hier werden alle Geburtstage im aktuellen Monat angezeigt
                
echo "Am ".$dat[image_geboren]." hat  <b><a href=\"./details.php?image_id=$dat[image_id]\">".$dat[image_name]."</a></b>  ?? Geburtstag"."<br>";
        }
}  
?></td>
  </tr>
  <tr>
    <td><?php
$datum
=strftime("%m");
$datum3=strftime("%d%m");
$dat1=mysql_query("SELECT image_name, image_gestorbenGP, image_id  FROM friedhof_images  ORDER BY image_gestorbenGP");

while(
$dat=mysql_fetch_array($dat1)) {
        
$datum1$dat[image_gestorbenGP];
        
$datum2explode("."$datum1);
        if(
$datum2[0].$datum2[1] == $datum3) {
//hier wird ein Sterbefall am aktuellen Tag angezeigt
                
echo "<b>Heute vor ?? Jahren ist <a href=\"./details.php?image_id=$dat[image_id]\">".$dat[image_name]."</a>  Gestorben</b>"."<br>";
        }
        if(
$datum2[1] == $datum and $datum2[0].$datum2[1] > $datum3 ) {




//hier werden alle Stärbefälle  im aktuellen Monat angezeigt
                
echo "Am ".$dat[image_gestorbenGP]." vor ?? Jahren ist  <b><a href=\"./details.php?image_id=$dat[image_id]\">".$dat[image_name]."</a></b>  Gestorben"."<br>";
        }
}  
?>
</td>
  </tr>
</table>



hast Du ein Ansatzt oder Beispielscript wie ich es realisieren könnte?

gruß
Logged
Pages: [1] 2 3 4 » »» Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.095 seconds with 20 queries.