Static topics (polecenie troche inne)

 

Strona 1 z 1 [ 3 posty(ów) ]

Widok do druku | « Poprzedni temat | Następny temat »

Temat

• Wysłany: 20 Cze 2006, 13:33

  Guzik17

  

  
  Rejestracja: 13 Cze 2006, 08:14
  Posty: 62
  Witam instaluje własnie moda Static topics mam takie polecenie
  
  jest to kawałek polecenia z viewforum.php
  
  

  Kod:

  #
  #-----[ FIND ]------------------------------------------
  #
  $sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
     FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
     WHERE t.forum_id = $forum_id
        AND t.topic_poster = u.user_id
        AND p.post_id = t.topic_first_post_id
        AND p2.post_id = t.topic_last_post_id
        AND u2.user_id = p2.poster_id
        AND t.topic_type <> " . POST_ANNOUNCE . "
        $limit_topics_time
     ORDER BY t.topic_type DESC, t.topic_last_post_id DESC
     LIMIT $start, ".$board_config['topics_per_page'];
  
  #
  #-----[ REPLACE WITH ]------------------------------------------
  #
  $sql = "SELECT st.*, t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
     FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2, " . TOPICS_STATIC_TABLE . " st
     WHERE t.forum_id = $forum_id
        AND t.topic_poster = u.user_id
        AND st.topic_id = t.topic_id
        AND p.post_id = t.topic_first_post_id
        AND p2.post_id = t.topic_last_post_id
        AND u2.user_id = p2.poster_id
        AND t.topic_type <> " . POST_ANNOUNCE . "
        $limit_topics_time
     ORDER BY t.topic_type DESC, st.static_id DESC
     LIMIT $start, ".$board_config['topics_per_page'];

  
  
  jednak moje znalezione wyglada tak trochę się różnią
  
  

  Kod:

  $sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time, u.user_rank, u2.user_posts as posts2, u2.user_rank as rank2, u.user_posts, u.user_rank, u2.user_posts as posts2, u2.user_rank as rank2
     FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
     WHERE t.forum_id = $forum_id
        AND t.topic_poster = u.user_id
        AND p.post_id = t.topic_first_post_id
        AND p2.post_id = t.topic_last_post_id
        AND u2.user_id = p2.poster_id
        AND t.topic_type <> " . POST_ANNOUNCE . "
        $limit_topics_time
     ORDER BY t.topic_type DESC, t.topic_last_post_id DESC
     LIMIT $start, ".$board_config['topics_per_page'];

  
  
  instalowałem wcześniej pare modów dlatego nie chciał bym nic namieszać proszę o prawidłowy kod na jaki mam wymienić.

  

Odpowiedzi

• Wysłany: 20 Cze 2006, 13:40

  roadway

  

  
  Rejestracja: 13 Maj 2005, 23:54
  Posty: 1184
  Pochwały: 153
  Kod:

  $sql = "SELECT st.*, t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time, u.user_rank, u2.user_posts as posts2, u2.user_rank as rank2, u.user_posts, u.user_rank, u2.user_posts as posts2, u2.user_rank as rank2
     FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2, " . TOPICS_STATIC_TABLE . " st
     WHERE t.forum_id = $forum_id
        AND t.topic_poster = u.user_id
        AND p.post_id = t.topic_first_post_id
        AND p2.post_id = t.topic_last_post_id
        AND u2.user_id = p2.poster_id
        AND t.topic_type <> " . POST_ANNOUNCE . "
        $limit_topics_time
     ORDER BY t.topic_type DESC, st.static_id DESC
     LIMIT $start, ".$board_config['topics_per_page'];

  

• Wysłany: 20 Cze 2006, 13:40

  alex1

  

  
  Rejestracja: 20 Cze 2006, 13:39
  Posty: 1
  dziex mi tez sie przyda własnie chciałem również instalować tego moda i sam mam zainstalowane CR

  

 

Strona 1 z 1 [ 3 posty(ów) ]