Avatar

Geänderte Einträge (German / Deutsch)

by RaHa @, Wednesday, December 21, 2016, 09:02 (1032 days ago) @ Auge
edited by RaHa, Wednesday, December 21, 2016, 09:13

oder sollen sich die zuletzt geänderten Einträge in die Liste der neuesten Einträge einreihen? Ich persönlich halte eine Einreihung in die vorhandene Listung mit einer Markierung "neu/bearbeitet" für sinnvoll.

genau so!

Meine Nutzer sagten, dass abhängig von der Kategorieauswahl nicht alle neusten Einträge (aus allen Kategorien) angezeigt werden. Hat man z.B. die Katagorie "meine Auswahl" bekommt man garnicht mit, dass es in einer anderen Kategorie einen neuen Eintrag gibt.

Inzwischen habe ich die Stelle und das Script gefunden, komme aber immo mit der Syntax der Abfrage nicht zurecht.
Habe es aber schon mal so eingerichtet, dass unbahängig von der Kategorieauswahl immer alle neusten Einträge angezeigt werden, man kann zwar auch die Auswahl "Alle Kategorien" wählen, um zum Ergebnis zu kommen aber so sieht man es sofort.

// latest postings:
if($settings['latest_postings']>0)
 {
 
//print_r($category_ids_query);
//exit;
 
      $latest_postings_result = @mysqli_query($connid, "SELECT id, pid, tid, name, user_name, ".$db_settings['forum_table'].".user_id, UNIX_TIMESTAMP(time) AS time, UNIX_TIMESTAMP(time + INTERVAL ".intval($time_difference)." MINUTE) AS timestamp, UNIX_TIMESTAMP(last_reply) AS last_reply, subject, category
                                              FROM ".$db_settings['forum_table']."
                                              LEFT JOIN ".$db_settings['userdata_table']." ON ".$db_settings['userdata_table'].".user_id=".$db_settings['forum_table'].".user_id
                                              WHERE spam=0
                                              ORDER BY time DESC LIMIT ".$settings['latest_postings']) or raise_error('database_error',mysqli_error($connid));
 
/* rahadeactive
  if($categories == false)
   {
    $latest_postings_result = @mysqli_query($connid, "SELECT id, pid, tid, name, user_name, ".$db_settings['forum_table'].".user_id, UNIX_TIMESTAMP(time) AS time, UNIX_TIMESTAMP(time + INTERVAL ".intval($time_difference)." MINUTE) AS timestamp, UNIX_TIMESTAMP(last_reply) AS last_reply, subject, category
                                            FROM ".$db_settings['forum_table']."
                                            LEFT JOIN ".$db_settings['userdata_table']." ON ".$db_settings['userdata_table'].".user_id=".$db_settings['forum_table'].".user_id
                                            WHERE spam=0
                                            ORDER BY time DESC LIMIT ".$settings['latest_postings']) or raise_error('database_error',mysqli_error($connid));
   }
  else
   {
    if($category>0)
     {
      $latest_postings_result = @mysqli_query($connid, "SELECT id, pid, tid, name, user_name, ".$db_settings['forum_table'].".user_id, UNIX_TIMESTAMP(time) AS time, UNIX_TIMESTAMP(time + INTERVAL ".intval($time_difference)." MINUTE) AS timestamp, UNIX_TIMESTAMP(last_reply) AS last_reply, subject, category
                                              FROM ".$db_settings['forum_table']."
                                              LEFT JOIN ".$db_settings['userdata_table']." ON ".$db_settings['userdata_table'].".user_id=".$db_settings['forum_table'].".user_id
                                              WHERE spam=0 AND category IN (".$category_ids_query.")
                                              ORDER BY time DESC LIMIT ".$settings['latest_postings']) or raise_error('database_error',mysqli_error($connid));
     }
    else
     {
      $latest_postings_result = @mysqli_query($connid, "SELECT id, pid, tid, name, user_name, ".$db_settings['forum_table'].".user_id, UNIX_TIMESTAMP(time) AS time, UNIX_TIMESTAMP(time + INTERVAL ".intval($time_difference)." MINUTE) AS timestamp, UNIX_TIMESTAMP(last_reply) AS last_reply, subject, category
                                              FROM ".$db_settings['forum_table']."
                                              LEFT JOIN ".$db_settings['userdata_table']." ON ".$db_settings['userdata_table'].".user_id=".$db_settings['forum_table'].".user_id
                                              WHERE spam=0 AND category IN (".$category_ids_query.")
                                              ORDER BY time DESC LIMIT ".$settings['latest_postings']) or raise_error('database_error',mysqli_error($connid));
     }
   }
*/
 


Danke!!


Complete thread:

 RSS Feed of thread

powered by my little forum