[备份] 网站常用超文本及 MySQL 语句

<div align="right" style="margin:4px 3px 0px 0px"><script type="text/JavaScript">

• 横向滚动公示
  
  

  <table class="borderwrap" width="100%">
  
  <tr>
  
  <td >
  
  <marquee behavior="scroll" loop="-1" direction="left" scrollamount="3" hspace="0" vspace="0" scrolldelay="30" onmouseover='this.stop()' onmouseout='this.start()'>
  
  <font color="darkred"><b>内容</b></font>
  
  </marquee>
  
  </td>
  
  </tr>
  
  </table>[/code]
  
  
  
  
  

• [b]纵向滚动公示[/b]
  [code]<marquee behavior="scroll" loop="-1" height="300" direction="up" scrollamount="2" hspace="0" vspace="0" scrolldelay="30" onmouseover='this.stop()' onmouseout='this.start()'>
  内容
  </marquee>
• 导航栏公告 A

  <div class="ruleswrap" align="center">
  
  <b><font color="darkred">内容</font></b>
  
  </div>[/code]
  
  
  
  
  

• [b]导航栏公告 B[/b]
  [code]<div class="ruleswrap">
  <img src='http://www.fpschina.com/style_images/fpschina/forum_rules.gif' border='0'> <b><font color="darkred">内容</font></b>
  </div>
• 页眉公告

  <div style='background: #DDD;text-align:left;height:20px;color:#FFF' align='left'>
  
  <div style='float:right;padding-top:2px;padding-right:6px;'>
  
  <b><font color="darkred">内容</font></b>
  
  </div>
  
  </div>[/code]
  
  
  
  
  

• [b]信息栏框架[/b]
  [code]<div class="borderwrap">
  <div class="maintitle">
  <{CAT_IMG}>标题
  </div>
  <div class="tablepad">
  内容
  </div>
  </div>
• 页面打开后的渐显效果

  <meta http-equiv="Page-Enter" content="blendTrans(Duration=0.3)" />

• 将帖子少于 10 的用户从组 A 移动到组 B

  update ibf_members set mgroup = B where mgroup = A AND posts < 10

• 移除导航栏 Powered by Invision Power Board 字样 /sources/action_public/boards.php
• 数据库 UTF-8 输出 /ips_kernel/class_db_mysql_client.php

  		if ( ! mysql_select_db($this->obj['sql_database'], $this->connection_id) )
  
  		{
  
  			$this->fatal_error();
  
  			return FALSE;
  
  		}
  
  		mysql_query( 'set names utf8' ); <-- Add this line
  
  		unset( $this->obj['sql_host'] );
  
  		unset( $this->obj['sql_user'] );
  
  		unset( $this->obj['sql_pass'] );[/code]
  
  
  [color=#0000FF]/ips_kernel/class_db_mysql.php[/color]
  
  
  
  [code]		define( 'FORCE_MYSQL_ONLY', 1 ); <-- Remove the // at the front

• 更改主题显示字符数量 /sources/classes/class_forums.php

  $forum_data['last_title'] = $this->ipsclass->txt_truncate($forum_data['last_title'], 18);

• 下载中心皮肤修改 skin_downloads → categories <div class=forumdesc">{$data['cdesc]}{$data['show_subforums']}{$data['subcategories']}</div>

  <th colspan="2" width="38%">
  
  <th style='text-align:center;' width="8%">
  
  <th style='text-align:center;' width="8%">
  
  <th style='text-align:center;' width="8%">
  
  <th width="38%">
  
  
  <td align="center" class="row2" width="2%">
  
  <td class="row2" width='36%'>
  
  <td align="center" class="row1" width='8%'>
  
  <td align="center" class="row2" width='8%'>
  
  <td align="center" class="row1" width='8%'>
  
  <td class="row2" width='38%'>[/code]
  
  
  [color=#0000FF]skin_downloads → latest_file_info[/color]
  
  
  
  [code]{$file_info['file']}
  
  {$file_info['datelang']}: {$file_info['fdate']}<br />
  
  {$this->ipsclass->lang['catfile_author']}: {$file_info['author']}

  替换为

  {$file_info['file']} by {$file_info['author']} @ {$file_info['fdate']}