Assembla home | Assembla project page
 

Changeset 46

Show
Ignore:
Timestamp:
06/07/07 16:46:38 (1 year ago)
Author:
digitalspaghetti
Message:

Updated video controller, some other minor changes.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • branch/controllers/playlists_controller.php

    r45 r46  
    139139                } 
    140140        } 
     141         
     142        function admin_orderlist($id = null) 
     143        { 
     144                $this->Session->setFlash('This method is currently disabled'); 
     145                $this->redirect(array('action'=>'index'), null, true); 
     146                /*if (!$id && empty($this->data)) 
     147                { 
     148                        $this->Session->setFlash('Invalid id for Playlist'); 
     149                        $this->redirect(array('action'=>'index'), null, true); 
     150                } 
     151                if (!empty($this->data)) 
     152                { 
     153                        pr($this->data); 
     154                        $this->Playlist->PlaylistsTrack->save($this->data); 
     155                        //$this->Session->setFlash('Order updated'); 
     156                        //$this->redirect(array('action'=>'index'), null, true); 
     157                } 
     158                $playlist = $this->Playlist->PlaylistsTrack->findAll(array('PlaylistsTrack.playlist_id' => $id)); 
     159                $this->set(compact('playlist'));*/ 
     160        } 
    141161 
    142162} 
  • branch/controllers/videos_controller.php

    r34 r46  
    1212                 
    1313                $youtube =& new phpYoutube($dev_id); 
    14                 $this->set('youtube', $youtube->videos_listbyuser($account, 1, 5)); 
     14                $this->set('youtube', $youtube->videos_listbyuser($account, 1, 50)); 
    1515        } 
    1616         
  • branch/models/playlist.php

    r45 r46  
    66        var $hasAndBelongsToMany = array( 
    77                        'Track' => array('className' => 'Track', 
     8                                                'joinTable' => 'playlists_tracks', 
     9                                                'foreignKey' => 'playlist_id', 
     10                                                'associationForeignKey' => 'track_id', 
    811                                                'with' => 'PlaylistsTrack', 
    9                                                 'associationForeignKey' => 'playlist_id', 
    1012                                                'order' => 'PlaylistsTrack.position ASC'), 
    1113        ); 
    12          
    13         /*function beforeSave() 
    14         { 
    15                 if ($this->data) 
    16                 { 
    17                         foreach ($this->data['Track']['Track'] as $key => $track)  
    18                         { 
    19                                 $this->data['PlaylistsTrack']['position'] = $key; 
    20                         } 
    21                 } 
    22         }*/ 
    23          
    24         /*function afterSave() 
    25         { 
    26                 $playlist = $this->getLastInsertID(); 
    27                  
    28                  
    29         }*/ 
    3014 
    3115} 
  • branch/models/playlists_track.php

    r44 r46  
    44{ 
    55        var $belongsTo = array('Playlist', 'Track'); 
     6         
     7        var $actsAs = array('SimpleResults' => array('simplifyIfJoins' => true)); 
     8 
     9        var $useSimpleResults = true; 
    610} 
    711 
  • branch/models/track.php

    r45 r46  
    2222        var $hasAndBelongsToMany = array( 
    2323                        'Playlist' => array('className' => 'Playlist', 
    24                                                 'with' => 'PlaylistsTrack', 
    25                                                 'associationForeignKey' => 'track_id',  
     24                                                'joinTable' => 'playlists_tracks', 
     25                                                'foreignKey' => 'track_id', 
     26                                                'associationForeignKey' => 'playlist_id', 
     27                                                'with' => 'PlaylistsTrack',                                               
    2628                                                'order' => 'PlaylistsTrack.position ASC'), 
    2729                        'Tag' => array('className' => 'Tag', 
  • branch/views/elements/topnav.ctp

    r24 r46  
    11<?php $menus = $this->requestAction('/menus/index/1');?> 
    22<div id="topnav" class="primarynav"> 
    3         <?php e($treeMenu->generate($menus));?> 
     3        <?php e($treeMenu->generate($menus, 'jd_menu', true));?> 
    44</div> 
  • branch/views/helpers/tree_menu.php

    r25 r46  
    55        var $helpers = array('Html','othAuth'); 
    66 
    7         function generate($data, $class='jd_menu',$include_login = 0
     7        function generate($data, $class='jd_menu', $include_login = false
    88        { 
    99                $output = '<ul class="' . $class .  '">'; 
     
    1818                                $output .= '</li>'; 
    1919                        } 
    20                 endforeach;              
     20                endforeach; 
     21                if ($include_login) { 
     22                        if ($this->othAuth->sessionValid()) 
     23                        { 
     24                        $output .= '<li><a href="/users/logout">Logout</a></li>'; 
     25                        } else { 
     26                        $output .= '<li><a href="/users/login">Login</a></li>'; 
     27                        } 
     28                } 
    2129                $output .= '</ul>'; 
    2230                return $output; 
  • branch/views/tracks/admin_add.ctp

    r43 r46  
    1313        <fieldset> 
    1414                <legend>Meta Information</legend> 
     15                <?php e($form->input('infourl'));?> 
    1516                <?php e($form->input('tags'));?> 
    1617                <?php e($form->input('image_id', array('options'=>$images)));?> 
  • branch/views/videos/youtube.ctp

    r34 r46  
    1 <?php print_r($youtube);?> 
    2  
     1<?php //pr($youtube);?> 
     2<ul class="gallery"> 
    33<?php foreach($youtube['video'] as $video) : ?> 
    4         <h2><?php e($video['title']);?></h2> 
    5  
    6         <object width="425" height="350"> 
    7                 <param name="movie" value="http://www.youtube.com/v/<?php e($video['id']);?>"></param> 
    8                 <param name="wmode" value="transparent"></param> 
    9                 <embed src="http://www.youtube.com/v/<?php e($video['id']);?>" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"></embed> 
    10         </object> 
     4        <li class="video-item-<?php e($video['id']);?>" style="display:none;" /> 
     5                <?php e($video['title']);?><br /> 
     6                <img src="<?php e($video['thumbnail_url']);?>" /> 
     7        </li> 
     8        <?php e($javascript->codeBlock('$("li.video-item-' . $video['id'] . '").fadeIn(1000);'));?> 
    119<?php endforeach;?> 
     10</ul> 
  • branch/webrocket.sql

    r42 r46  
    44--  
    55-- Host: localhost 
    6 -- Generation Time: Jun 04, 2007 at 11:22 PM 
     6-- Generation Time: Jun 07, 2007 at 05:43 PM 
    77-- Server version: 5.0.38 
    88-- PHP Version: 5.2.1 
     
    2929 
    3030INSERT INTO `cake_sessions` (`id`, `data`, `expires`) VALUES  
    31 ('fe8331bf8cc87191dd20a10e1b69cfce', 'Config|a:3:{s:9:"userAgent";s:32:"268042ced84746041c45b952d0ba6110";s:4:"time";i:1180995396;s:4:"rand";i:205194849;}othAuth|a:1:{s:41:"ADYhG93b0qyJfIxfs2guVoUubWwvniR2G0FgaC9mi";a:2:{s:4:"User";a:17:{s:2:"id";s:1:"1";s:8:"username";s:14:"WebrocketAdmin";s:6:"passwd";s:32:"fdfedc01c66e9ea2817508ca1097df2f";s:4:"name";s:15:"Webrocket Admin";s:5:"email";s:19:"admin@webrocket.com";s:10:"last_visit";s:19:"2007-06-04 16:00:00";s:8:"group_id";s:1:"1";s:10:"profile_id";s:1:"1";s:11:"posts_count";s:1:"4";s:11:"pages_count";s:1:"2";s:14:"comments_count";s:1:"2";s:12:"videos_count";s:1:"0";s:6:"active";s:1:"1";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";s:10:"login_hash";s:32:"9959667d54c2bb525ab6b832bdd90c14";s:7:"hashkey";s:41:"ADYhG93b0qyJfIxfs2guVoUubWwvniR2G0FgaC9mi";}s:5:"Group";a:8:{s:2:"id";s:1:"1";s:4:"name";s:11:"Site Admins";s:5:"level";s:3:"999";s:8:"redirect";s:0:"";s:9:"perm_type";s:5:"allow";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";s:10:"Permission";a:1:{i:0;a:4:{s:2:"id";s:1:"1";s:4:"name";s:1:"*";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";}}}}}Message|a:0:{}', 1180995396); 
     31('f3fa13175a022e6d7d1c445c9a39185b', 'Config|a:3:{s:9:"userAgent";s:32:"268042ced84746041c45b952d0ba6110";s:4:"time";i:1181230718;s:4:"rand";i:1380475676;}othAuth|a:1:{s:41:"ADYhG93b0qyJfIxfs2guVoUubWwvniR2G0FgaC9mi";a:2:{s:4:"User";a:18:{s:2:"id";s:1:"1";s:8:"username";s:14:"WebrocketAdmin";s:6:"passwd";s:32:"fdfedc01c66e9ea2817508ca1097df2f";s:4:"name";s:15:"Webrocket Admin";s:5:"email";s:19:"admin@webrocket.com";s:10:"last_visit";s:19:"2007-06-07 14:30:54";s:8:"group_id";s:1:"1";s:10:"profile_id";s:1:"1";s:11:"posts_count";s:1:"4";s:11:"pages_count";s:1:"2";s:14:"comments_count";s:1:"2";s:12:"videos_count";s:1:"0";s:4:"tags";s:0:"";s:6:"active";s:1:"1";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";s:10:"login_hash";s:32:"9959667d54c2bb525ab6b832bdd90c14";s:7:"hashkey";s:41:"ADYhG93b0qyJfIxfs2guVoUubWwvniR2G0FgaC9mi";}s:5:"Group";a:9:{s:2:"id";s:1:"1";s:4:"name";s:11:"Site Admins";s:5:"level";s:3:"999";s:8:"redirect";s:0:"";s:9:"perm_type";s:5:"allow";s:11:"users_count";s:1:"0";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";s:10:"Permission";a:1:{i:0;a:4:{s:2:"id";s:1:"1";s:4:"name";s:1:"*";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";}}}}}', 1181230718); 
    3232 
    3333-- -------------------------------------------------------- 
     
    556556  `redirect` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL, 
    557557  `perm_type` enum('allow','deny') NOT NULL default 'allow', 
     558  `users_count` int(8) unsigned NOT NULL, 
    558559  `created` datetime NOT NULL default '0000-00-00 00:00:00', 
    559560  `modified` datetime NOT NULL default '0000-00-00 00:00:00', 
     
    565566--  
    566567 
    567 INSERT INTO `groups` (`id`, `name`, `level`, `redirect`, `perm_type`, `created`, `modified`) VALUES  
    568 (1, 'Site Admins', 999, '', 'allow', '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
    569 (2, 'Site Editors', 900, '', 'allow', '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
    570 (3, 'Registered Members', 500, '', 'allow', '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
    571 (4, 'Anonymous Visitor', 0, '', 'allow', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); 
     568INSERT INTO `groups` (`id`, `name`, `level`, `redirect`, `perm_type`, `users_count`, `created`, `modified`) VALUES  
     569(1, 'Site Admins', 999, '', 'allow', 0, '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
     570(2, 'Site Editors', 900, '', 'allow', 0, '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
     571(3, 'Registered Members', 500, '', 'allow', 0, '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
     572(4, 'Anonymous Visitor', 0, '', 'allow', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); 
    572573 
    573574-- -------------------------------------------------------- 
     
    620621  `modified` datetime default NULL, 
    621622  PRIMARY KEY  (`id`) 
    622 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=44
     623) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=46
    623624 
    624625--  
     
    626627--  
    627628 
     629INSERT INTO `images` (`id`, `filename`, `dir`, `thumb`, `mimetype`, `alt`, `subject_id`, `copyright_owner`, `copyright_id`, `image_location`, `image_date`, `image_notes`, `filesize`, `tags`, `user_id`, `created`, `modified`) VALUES  
     630(45, 'TheHedrons_Group1.jpg', 'files/Image', 'thumb.TheHedrons_Group1.jpg', 'image/jpeg', 'The Hedrons Group', 1, 'The Hedrons', 1, 'None', '2007-06-05', 'The Hedrons', 146539, 'The Hedrons', 1, '2007-06-05 15:47:17', '2007-06-05 15:47:17'); 
    628631 
    629632-- -------------------------------------------------------- 
     
    647650(37, 30), 
    648651(38, 29), 
    649 (38, 30); 
     652(38, 30), 
     653(45, 4); 
    650654 
    651655-- -------------------------------------------------------- 
     
    820824  `id` int(8) unsigned NOT NULL auto_increment, 
    821825  `title` varchar(255) collate utf8_unicode_ci NOT NULL, 
    822   PRIMARY KEY  (`id`) 
    823 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; 
     826  `comments` varchar(255) collate utf8_unicode_ci NOT NULL, 
     827  PRIMARY KEY  (`id`) 
     828) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ; 
    824829 
    825830--  
     
    827832--  
    828833 
    829 INSERT INTO `playlists` (`id`, `title`) VALUES  
    830 (1, 'One More Won''t Kill Us'); 
     834INSERT INTO `playlists` (`id`, `title`, `comments`) VALUES  
     835(13, 'New Test Playlist', ''), 
     836(14, 'New Test Playlist', ''); 
    831837 
    832838-- -------------------------------------------------------- 
     
    838844CREATE TABLE `playlists_tracks` ( 
    839845  `playlist_id` int(8) unsigned NOT NULL, 
    840   `track_id` int(8) unsigned NOT NULL 
     846  `track_id` int(8) unsigned NOT NULL, 
     847  `position` int(8) unsigned NOT NULL 
    841848) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
    842849 
     
    845852--  
    846853 
    847 INSERT INTO `playlists_tracks` (`playlist_id`, `track_id`) VALUES  
    848 (1, 1), 
    849 (1, 2); 
     854INSERT INTO `playlists_tracks` (`playlist_id`, `track_id`, `position`) VALUES  
     855(14, 3, 0), 
     856(14, 4, 0), 
     857(14, 6, 0), 
     858(14, 5, 0), 
     859(13, 3, 0), 
     860(13, 5, 0), 
     861(13, 6, 0), 
     862(13, 4, 0); 
    850863 
    851864-- -------------------------------------------------------- 
     
    10721085 
    10731086INSERT INTO `subjects` (`id`, `title`, `posts_count`, `pages_count`, `events_count`, `feeds_count`, `images_count`, `galleries_count`, `videos_count`, `created`, `modified`) VALUES  
    1074 (1, 'Webrocket', 4, 0, 2, 0, 0, 0, 0, '2007-05-01 17:05:55', '2007-05-01 17:05:55'); 
     1087(1, 'Webrocket', 4, 0, 2, 0, 1, 0, 0, '2007-05-01 17:05:55', '2007-05-01 17:05:55'); 
    10751088 
    10761089-- -------------------------------------------------------- 
     
    11411154 
    11421155INSERT INTO `tags_tracks` (`tag_id`, `track_id`) VALUES  
    1143 (4, 1), 
    1144 (4, 2); 
     1156(4, 4), 
     1157(4, 3), 
     1158(4, 5), 
     1159(4, 6); 
     1160 
     1161-- -------------------------------------------------------- 
     1162 
     1163--  
     1164-- Table structure for table `tags_users` 
     1165--  
     1166 
     1167CREATE TABLE `tags_users` ( 
     1168  `tag_id` int(8) unsigned NOT NULL, 
     1169  `user_id` int(8) unsigned NOT NULL 
     1170) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
     1171 
     1172--  
     1173-- Dumping data for table `tags_users` 
     1174--  
     1175 
    11451176 
    11461177-- -------------------------------------------------------- 
     
    11861217  `dir` varchar(255) collate utf8_unicode_ci NOT NULL, 
    11871218  `mimetype` varchar(255) collate utf8_unicode_ci NOT NULL, 
     1219  `filesize` int(8) unsigned NOT NULL, 
     1220  `trackname` varchar(255) collate utf8_unicode_ci NOT NULL, 
    11881221  `artist` varchar(255) collate utf8_unicode_ci NOT NULL, 
     1222  `infourl` varchar(255) collate utf8_unicode_ci NOT NULL, 
    11891223  `tags` varchar(255) collate utf8_unicode_ci NOT NULL, 
    11901224  `image_id` int(8) unsigned NOT NULL, 
     
    11921226  `modified` datetime default NULL, 
    11931227  PRIMARY KEY  (`id`) 
    1194 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3
     1228) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7
    11951229 
    11961230--  
     
    11981232--  
    11991233 
    1200 INSERT INTO `tracks` (`id`, `filename`, `dir`, `mimetype`, `artist`, `tags`, `image_id`, `created`, `modified`) VALUES  
    1201 (1, '01__Heatseeker.mp3', 'files/Media', 'audio/mpeg', 'The Hedrons', 'The Hedrons', 42, '2007-06-04 16:08:34', '2007-06-04 16:08:34'), 
    1202 (2, '02__Couldnt_Leave_Her_Alone.mp3', 'files/Media', 'audio/mpeg', 'The Hedrons', 'The Hedrons', 42, '2007-06-04 16:42:21', '2007-06-04 16:42:21'); 
     1234INSERT INTO `tracks` (`id`, `filename`, `dir`, `mimetype`, `filesize`, `trackname`, `artist`, `infourl`, `tags`, `image_id`, `created`, `modified`) VALUES  
     1235(3, '01__Heatseeker.mp3', 'files/Media', 'audio/mpeg', 1399270, 'Heatseeker', 'The Hedrons', 'http://www.7digital.com/stores/productDetail.aspx?shop=34&amp;product=55080&amp;sid=639775', 'The Hedrons', 45, '2007-06-05 15:49:11', '2007-06-05 15:49:11'), 
     1236(4, '02__Couldnt_Leave_Her_Alone.mp3', 'files/Media', 'audio/mpeg', 1078158, 'Couldn''t Leave Her Alone', 'The Hedrons', 'http://www.7digital.com/stores/productDetail.aspx?shop=34&amp;product=55080&amp;sid=639775', 'The Hedrons', 45, '2007-06-05 15:51:51', '2007-06-05 15:51:51'), 
     1237(5, '03__I_Need_You.mp3', 'files/Media', 'audio/mpeg', 1185184, 'I Need You', 'The Hedrons', 'http://www.7digital.com/stores/productDetail.aspx?shop=34&amp;product=55080&amp;sid=639775', 'The Hedrons', 45, '2007-06-05 15:53:54', '2007-06-05 15:53:54'), 
     1238(6, '04__Be_My_Friend.mp3', 'files/Media', 'audio/mpeg', 1054441, 'Be My Friend', 'The Hedrons', 'http://www.7digital.com/stores/productDetail.aspx?shop=34&amp;product=55080&amp;sid=639775', 'The Hedrons', 45, '2007-06-05 15:59:45', '2007-06-05 15:59:45'); 
    12031239 
    12041240-- -------------------------------------------------------- 
     
    12411277  `comments_count` int(4) NOT NULL, 
    12421278  `videos_count` int(4) NOT NULL, 
     1279  `tags` varchar(255) NOT NULL, 
    12431280  `active` tinyint(1) unsigned NOT NULL default '0', 
    12441281  `created` datetime NOT NULL default '0000-00-00 00:00:00', 
     
    12541291--  
    12551292 
    1256 INSERT INTO `users` (`id`, `username`, `passwd`, `name`, `email`, `last_visit`, `group_id`, `profile_id`, `posts_count`, `pages_count`, `comments_count`, `videos_count`, `active`, `created`, `modified`) VALUES  
    1257 (1, 'WebrocketAdmin', 'fdfedc01c66e9ea2817508ca1097df2f', 'Webrocket Admin', 'admin@webrocket.com', '2007-06-04 22:52:42', 1, 1, 4, 2, 2, 0, 1, '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
    1258 (2, 'Editor', '5aee9dbd2a188839105073571bee1b1f', 'Site', 'Editor', '2007-04-27 10:02:45', 2, 0, 0, 0, 0, 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
    1259 (3, 'Member', 'aa08769cdcb26674c6706093503ff0a3', 'Member', 'member@member.com', '2007-04-26 13:43:34', 3, 0, 0, 0, 0, 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
    1260 (4, '', '', '', '', '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 3, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); 
     1293INSERT INTO `users` (`id`, `username`, `passwd`, `name`, `email`, `last_visit`, `group_id`, `profile_id`, `posts_count`, `pages_count`, `comments_count`, `videos_count`, `tags`, `active`, `created`, `modified`) VALUES  
     1294(1, 'WebrocketAdmin', 'fdfedc01c66e9ea2817508ca1097df2f', 'Webrocket Admin', 'admin@webrocket.com', '2007-06-07 16:11:33', 1, 1, 4, 2, 2, 0, '', 1, '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
     1295(2, 'Editor', '5aee9dbd2a188839105073571bee1b1f', 'Site', 'Editor', '2007-04-27 10:02:45', 2, 0, 0, 0, 0, 0, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
     1296(3, 'Member', 'aa08769cdcb26674c6706093503ff0a3', 'Member', 'member@member.com', '2007-04-26 13:43:34', 3, 0, 0, 0, 0, 0, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
     1297(4, '', '', '', '', '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 3, '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); 
    12611298 
    12621299-- -------------------------------------------------------- 
     
    12901327INSERT INTO `videos` (`id`, `title`, `url`, `video_location`, `video_date`, `body`, `copyright_owner`, `copyright_id`, `published`, `user_id`, `subject_id`, `tags`, `created`, `modified`) VALUES  
    12911328(20, 'The Hedrons EPK', 'http://www.youtube.com/v/28u-swVWo9Q', 'N/A', '2007-05-17', 'The Hedrons EPK', 'The Hedrons', 1, 0, 0, 1, 'The Hedrons, Video, Epk, Biography, Be My Friend, I Need You, Couldnt Leave Her Alone, Heatseeker', '2007-05-17 16:18:11', '2007-05-17 16:24:36'); 
    1292