Changeset 20301 for events

Timestamp:

09/30/08 20:14:23 (2 months ago)

Author:

kenji

Message:

Add link to @username

Location:

events/phpframework/codeigniter/trunk/system/application

Files:

• controllers/home.php (modified) (1 diff)
• models/status_model.php (modified) (2 diffs)
• views/home/main.php (modified) (1 diff)

events/phpframework/codeigniter/trunk/system/application/controllers/home.php

@@ -11 +11 @@
                         redirect('login');
                 }
-                //$this->output->enable_profiler(TRUE);
+                $this->output->enable_profiler(TRUE);
         }
 

events/phpframework/codeigniter/trunk/system/application/models/status_model.php

@@ -34 +34 @@
                 $this->db->where('username', $username);
                 $query = $this->db->get('users');
-                $row = $query->row();
-                return $row->id;
+
+                if ($query->num_rows() > 0)
+                {
+                        $row = $query->row();
+                        return $row->id;
+                }
+                else
+                {
+                        return FALSE;
+                }
         }
 
@@ -111 +119 @@
                 }
 
-                $this->db->select('SQL_CALC_FOUND_ROWS statuses.id, username, comment, UNIX_TIMESTAMP(statuses.created_at) AS created_at, image');
+                $this->db->select('SQL_CALC_FOUND_ROWS statuses.id, u1.username AS username, comment, u2.username AS reply_username, UNIX_TIMESTAMP(statuses.created_at) AS created_at, u1.image AS image');
                 $this->db->from('statuses');
-                $this->db->join('users', 'statuses.user_id = users.id', 'left');
+                $this->db->join('users AS u1', 'statuses.user_id = u1.id', 'left');
+                $this->db->join('users AS u2', 'statuses.reply_user_id = u2.id', 'left');
                 $this->db->where_in('statuses.user_id', $ids);
                 $this->db->order_by('created_at', 'DESC');

events/phpframework/codeigniter/trunk/system/application/views/home/main.php

@@ -34 +34 @@
                                 <p class="murmur">
                                 <?=anchor(site_url('user/index/' . $row->username), $row->username)?>
-                                <?=h($row->comment)?>
+                                <?php 
+                                        $row->comment = h($row->comment);
+                                        if ($row->reply_username) {
+                                                $row->comment = preg_replace('/^@(\w+)\s/', '@' . anchor(site_url('user/index/' . $row->reply_username), $row->reply_username) . ' ', $row->comment);
+                                        }
+                                ?>
+                                <?=$row->comment?>
                                 <?=anchor(site_url('user/statuses/' . $row->username . '/' . $row->id), posted_time($row->created_at))?>
                                 </p>