Changeset 504
- Timestamp:
- 10/24/2006 12:02:12 AM (19 years ago)
- Location:
- trunk
- Files:
-
- 3 edited
-
bb-admin/upgrade-schema.php (modified) (1 diff)
-
rss.php (modified) (2 diffs)
-
search.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/bb-admin/upgrade-schema.php
r385 r504 95 95 KEY topic_id_index (topic_id) 96 96 ); 97 CREATE TABLE {$bb_table_prefix}stats ( 98 topic_id bigint(20) unsigned NOT NULL default '0', 99 downloads bigint(20) unsigned NOT NULL default '0', 100 stamp date NOT NULL default '0000-00-00', 101 PRIMARY KEY (topic_id,stamp) 102 ); 103 CREATE TABLE {$bb_table_prefix}stats_users ( 104 topic_id bigint(20) unsigned NOT NULL default '0', 105 user_name varchar(60) NOT NULL default '0', 106 stamp date NOT NULL default '0000-00-00', 107 PRIMARY KEY (topic_id), 108 KEY user_name (user_name) 109 ); 110 CREATE TABLE {$bb_table_prefix}downloads ( 111 dl_id bigint(20) NOT NULL auto_increment, 112 topic_id bigint(20) unsigned NOT NULL default '0', 113 client_ip varchar(50) NOT NULL, 114 client_host varchar(250) NOT NULL, 115 user_id bigint(20) unsigned NOT NULL default '0', 116 user_name varchar(60) NOT NULL, 117 stamp datetime NOT NULL default '0000-00-00 00:00:00', 118 PRIMARY KEY (dl_id), 119 KEY client_ip (client_ip(20),stamp) 120 ); 97 121 "; 98 122 -
trunk/rss.php
r426 r504 1 1 <?php 2 2 require('./bb-load.php'); 3 require_once( BBPATH . BBINC . '/feed-functions.php'); 3 4 4 5 if ( isset($_GET['topic']) ) … … 57 58 do_action( 'bb_rss.php', '' ); 58 59 59 require_once( BBPATH . BBINC . '/feed-functions.php');60 61 60 bb_send_304( $posts[0]->post_time ); 62 61 -
trunk/search.php
r371 r504 6 6 7 7 if ( !empty( $q ) ) : 8 8 /* 9 9 if ( strlen( preg_replace('/[^a-z0-9]/i', '', $q) ) > 2 ) { 10 10 $users = $bbdb->get_results("SELECT * FROM $bbdb->users WHERE user_login LIKE ('%$likeit%')"); … … 12 12 bb_append_meta( $users, 'user' ); 13 13 } 14 14 */ 15 15 //Not appending topicmeta to titles at the moment! 16 16 $titles = $bbdb->get_results("SELECT * FROM $bbdb->topics WHERE LOWER(topic_title) LIKE ('%$likeit%') AND topic_status = 0 ORDER BY topic_time DESC LIMIT 5");
Note: See TracChangeset
for help on using the changeset viewer.