Project

General

Profile

« Previous | Next » 

Revision 66

Added by stefan about 20 years ago

Changed column names in mod_news_posts from short,long to content_short, content_long.

View differences:

install.php
1 1 
<?php
2 2 

  		




  3
  
  
    
// $Id: install.php,v 1.6 2005/04/02 08:21:46 rdjurovich Exp $


  		




  
  3
  
    
// $Id$


  		




  4
  4
  
    

  		




  5
  5
  
    
/*


  		




  6
  6
  
    

  		




  ......




  35
  35
  
    
					 . '`position` INT NOT NULL,'


  		




  36
  36
  
    
					 . '`title` VARCHAR(255) NOT NULL,'


  		




  37
  37
  
    
					 . '`link` TEXT NOT NULL,'


  		




  38
  
  
    
					 . '`short` TEXT NOT NULL,'


  		




  39
  
  
    
					 . '`long` TEXT NOT NULL,'


  		




  
  38
  
    
					 . '`content_short` TEXT NOT NULL,'


  		




  
  39
  
    
					 . '`content_long` TEXT NOT NULL,'


  		




  40
  40
  
    
					 . '`commenting` VARCHAR(7) NOT NULL,'


  		




  41
  41
  
    
		   	    . '`posted_when` INT NOT NULL ,'


  		




  42
  42
  
    
					 . '`posted_by` INT NOT NULL ,'


  		




  ......




  107
  107
  
    
	// Query body


  		




  108
  108
  
    
	$query_body_code = "


  		




  109
  109
  
    
	[TP]pages.page_id = [TP]mod_news_posts.page_id AND [TP]mod_news_posts.title LIKE \'%[STRING]%\'


  		




  110
  
  
    
	OR [TP]pages.page_id = [TP]mod_news_posts.page_id AND [TP]mod_news_posts.short LIKE \'%[STRING]%\'


  		




  111
  
  
    
	OR [TP]pages.page_id = [TP]mod_news_posts.page_id AND [TP]mod_news_posts.long LIKE \'%[STRING]%\'


  		




  
  110
  
    
	OR [TP]pages.page_id = [TP]mod_news_posts.page_id AND [TP]mod_news_posts.content_short LIKE \'%[STRING]%\'


  		




  
  111
  
    
	OR [TP]pages.page_id = [TP]mod_news_posts.page_id AND [TP]mod_news_posts.content_long LIKE \'%[STRING]%\'


  		




  112
  112
  
    
	OR [TP]pages.page_id = [TP]mod_news_comments.page_id AND [TP]mod_news_comments.title LIKE \'%[STRING]%\'


  		




  113
  113
  
    
	OR [TP]pages.page_id = [TP]mod_news_comments.page_id AND [TP]mod_news_comments.comment LIKE \'%[STRING]%\'


  		




  114
  114
  
    
	OR [TP]pages.page_id = [TP]mod_news_settings.page_id AND [TP]mod_news_settings.header LIKE \'%[STRING]%\'


  		












Also available in:  Unified diff