B2-2b2install

接下来,我们来讲解如何安装B2的数据库。

这里涉及到两个文件:b2install.php和b2config.php。

以下是b2install的代码内容。这里主要涉及到数据库的建立。

<div style="width: 650px; height: 500px; overflow: auto;">

<link rel='stylesheet' type='text/css' href='http://tools.oschina.net/js/syntaxhighlighter_3.0.83/styles/shCoreEmacs.css' />

<div id="highlighter_322487" class="syntaxhighlighter  php">

<div class="toolbar"><span><a href="#" class="toolbar_item command_help help">?</a></span></div>

<table border="0" cellpadding="0" cellspacing="0">

<tbody>

<tr>

<td class="gutter">

<div class="line number1 index0 alt2">1</div>

<div class="line number2 index1 alt1">2</div>

<div class="line number3 index2 alt2">3</div>

<div class="line number4 index3 alt1">4</div>

<div class="line number5 index4 alt2">5</div>

<div class="line number6 index5 alt1">6</div>

<div class="line number7 index6 alt2">7</div>

<div class="line number8 index7 alt1">8</div>

<div class="line number9 index8 alt2">9</div>

<div class="line number10 index9 alt1">10</div>

<div class="line number11 index10 alt2">11</div>

<div class="line number12 index11 alt1">12</div>

<div class="line number13 index12 alt2">13</div>

<div class="line number14 index13 alt1">14</div>

<div class="line number15 index14 alt2">15</div>

<div class="line number16 index15 alt1">16</div>

<div class="line number17 index16 alt2">17</div>

<div class="line number18 index17 alt1">18</div>

<div class="line number19 index18 alt2">19</div>

<div class="line number20 index19 alt1">20</div>

<div class="line number21 index20 alt2">21</div>

<div class="line number22 index21 alt1">22</div>

<div class="line number23 index22 alt2">23</div>

<div class="line number24 index23 alt1">24</div>

<div class="line number25 index24 alt2">25</div>

<div class="line number26 index25 alt1">26</div>

<div class="line number27 index26 alt2">27</div>

<div class="line number28 index27 alt1">28</div>

<div class="line number29 index28 alt2">29</div>

<div class="line number30 index29 alt1">30</div>

<div class="line number31 index30 alt2">31</div>

<div class="line number32 index31 alt1">32</div>

<div class="line number33 index32 alt2">33</div>

<div class="line number34 index33 alt1">34</div>

<div class="line number35 index34 alt2">35</div>

<div class="line number36 index35 alt1">36</div>

<div class="line number37 index36 alt2">37</div>

<div class="line number38 index37 alt1">38</div>

<div class="line number39 index38 alt2">39</div>

<div class="line number40 index39 alt1">40</div>

<div class="line number41 index40 alt2">41</div>

<div class="line number42 index41 alt1">42</div>

<div class="line number43 index42 alt2">43</div>

<div class="line number44 index43 alt1">44</div>

<div class="line number45 index44 alt2">45</div>

<div class="line number46 index45 alt1">46</div>

<div class="line number47 index46 alt2">47</div>

<div class="line number48 index47 alt1">48</div>

<div class="line number49 index48 alt2">49</div>

<div class="line number50 index49 alt1">50</div>

<div class="line number51 index50 alt2">51</div>

<div class="line number52 index51 alt1">52</div>

<div class="line number53 index52 alt2">53</div>

<div class="line number54 index53 alt1">54</div>

<div class="line number55 index54 alt2">55</div>

<div class="line number56 index55 alt1">56</div>

<div class="line number57 index56 alt2">57</div>

<div class="line number58 index57 alt1">58</div>

<div class="line number59 index58 alt2">59</div>

<div class="line number60 index59 alt1">60</div>

<div class="line number61 index60 alt2">61</div>

<div class="line number62 index61 alt1">62</div>

<div class="line number63 index62 alt2">63</div>

<div class="line number64 index63 alt1">64</div>

<div class="line number65 index64 alt2">65</div>

<div class="line number66 index65 alt1">66</div>

<div class="line number67 index66 alt2">67</div>

<div class="line number68 index67 alt1">68</div>

<div class="line number69 index68 alt2">69</div>

<div class="line number70 index69 alt1">70</div>

<div class="line number71 index70 alt2">71</div>

<div class="line number72 index71 alt1">72</div>

<div class="line number73 index72 alt2">73</div>

<div class="line number74 index73 alt1">74</div>

<div class="line number75 index74 alt2">75</div>

<div class="line number76 index75 alt1">76</div>

<div class="line number77 index76 alt2">77</div>

<div class="line number78 index77 alt1">78</div>

<div class="line number79 index78 alt2">79</div>

<div class="line number80 index79 alt1">80</div>

<div class="line number81 index80 alt2">81</div>

<div class="line number82 index81 alt1">82</div>

<div class="line number83 index82 alt2">83</div>

<div class="line number84 index83 alt1">84</div>

<div class="line number85 index84 alt2">85</div>

<div class="line number86 index85 alt1">86</div>

<div class="line number87 index86 alt2">87</div>

<div class="line number88 index87 alt1">88</div>

<div class="line number89 index88 alt2">89</div>

<div class="line number90 index89 alt1">90</div>

<div class="line number91 index90 alt2">91</div>

<div class="line number92 index91 alt1">92</div>

<div class="line number93 index92 alt2">93</div>

<div class="line number94 index93 alt1">94</div>

<div class="line number95 index94 alt2">95</div>

<div class="line number96 index95 alt1">96</div>

<div class="line number97 index96 alt2">97</div>

<div class="line number98 index97 alt1">98</div>

<div class="line number99 index98 alt2">99</div>

<div class="line number100 index99 alt1">100</div>

<div class="line number101 index100 alt2">101</div>

<div class="line number102 index101 alt1">102</div>

</td>

<td class="code">

<div class="container">

<div class="line number1 index0 alt2"><code class="php plain">&lt;html&gt;</code></div>

<div class="line number2 index1 alt1"><code class="php plain">&lt;head&gt;</code></div>

<div class="line number3 index2 alt2"><code class="php plain">&lt;title&gt;b2&nbsp;&gt;&nbsp;Installation&lt;/title&gt;</code></div>

<div class="line number4 index3 alt1"><code class="php plain">&lt;/head&gt;</code></div>

<div class="line number5 index4 alt2"><code class="php plain">&lt;body&gt;</code></div>

<div class="line number6 index5 alt1">&nbsp;</div>

<div class="line number7 index6 alt2"><code class="php plain">&lt;?php</code></div>

<div class="line number8 index7 alt1"><code class="php keyword">include</code>&nbsp;<code class="php plain">(</code><code class="php string">"b2config.php"</code><code class="php plain">);</code></div>

<div class="line number9 index8 alt2">&nbsp;</div>

<div class="line number10 index9 alt1"><code class="php keyword">function</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php variable">$msg</code><code class="php plain">,</code><code class="php variable">$sql</code><code class="php plain">,</code><code class="php variable">$error</code><code class="php plain">)&nbsp;{</code></div>

<div class="line number11 index10 alt2"><code class="php spaces">&nbsp;&nbsp;&nbsp;&nbsp;</code><code class="php functions">echo</code>&nbsp;<code class="php string">"&lt;p&gt;$msg&lt;/p&gt;"</code><code class="php plain">;</code></div>

<div class="line number12 index11 alt1"><code class="php spaces">&nbsp;&nbsp;&nbsp;&nbsp;</code><code class="php functions">echo</code>&nbsp;<code class="php string">"&lt;p&gt;query:&lt;br&nbsp;/&gt;$sql&lt;/p&gt;"</code><code class="php plain">;</code></div>

<div class="line number13 index12 alt2"><code class="php spaces">&nbsp;&nbsp;&nbsp;&nbsp;</code><code class="php functions">echo</code>&nbsp;<code class="php string">"&lt;p&gt;error:&lt;br&nbsp;/&gt;$error&lt;/p&gt;"</code><code class="php plain">;</code></div>

<div class="line number14 index13 alt1"><code class="php spaces">&nbsp;&nbsp;&nbsp;&nbsp;</code><code class="php keyword">die</code><code class="php plain">();</code></div>

<div class="line number15 index14 alt2"><code class="php plain">}</code></div>

<div class="line number16 index15 alt1">&nbsp;</div>

<div class="line number17 index16 alt2"><code class="php variable">$connexion</code>&nbsp;<code class="php plain">=&nbsp;mysql_connect(</code><code class="php variable">$server</code><code class="php plain">,</code><code class="php variable">$loginsql</code><code class="php plain">,</code><code class="php variable">$passsql</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php keyword">die</code><code class="php plain">(</code><code class="php string">"Can't&nbsp;connect&nbsp;to&nbsp;the&nbsp;database&lt;br&gt;"</code><code class="php plain">.mysql_error());</code></div>

<div class="line number18 index17 alt1"><code class="php variable">$dbconnexion</code>&nbsp;<code class="php plain">=&nbsp;mysql_select_db(</code><code class="php variable">$base</code><code class="php plain">,&nbsp;</code><code class="php variable">$connexion</code><code class="php plain">);</code></div>

<div class="line number19 index18 alt2">&nbsp;</div>

<div class="line number20 index19 alt1"><code class="php keyword">if</code>&nbsp;<code class="php plain">(!</code><code class="php variable">$dbconnexion</code><code class="php plain">)&nbsp;{</code></div>

<div class="line number21 index20 alt2"><code class="php spaces">&nbsp;&nbsp;&nbsp;&nbsp;</code><code class="php functions">echo</code>&nbsp;<code class="php plain">mysql_error();</code></div>

<div class="line number22 index21 alt1"><code class="php spaces">&nbsp;&nbsp;&nbsp;&nbsp;</code><code class="php keyword">die</code><code class="php plain">();</code></div>

<div class="line number23 index22 alt2"><code class="php plain">}</code></div>

<div class="line number24 index23 alt1">&nbsp;</div>

<div class="line number25 index24 alt2"><code class="php functions">echo</code>&nbsp;<code class="php string">"Now&nbsp;creating&nbsp;the&nbsp;necessary&nbsp;tables&nbsp;in&nbsp;the&nbsp;database...&lt;br&nbsp;/&gt;&lt;br&nbsp;/&gt;"</code><code class="php plain">;</code></div>

<div class="line number26 index25 alt1">&nbsp;</div>

<div class="line number27 index26 alt2">&nbsp;</div>

<div class="line number28 index27 alt1"><code class="php plain">#&nbsp;Note:&nbsp;</code><code class="php keyword">if</code>&nbsp;<code class="php plain">you&nbsp;want&nbsp;to&nbsp;start&nbsp;again&nbsp;with&nbsp;a&nbsp;clean&nbsp;b2&nbsp;database,</code></div>

<div class="line number29 index28 alt2"><code class="php plain">#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;just&nbsp;remove&nbsp;the&nbsp;</code><code class="php comments">//&nbsp;in&nbsp;this&nbsp;file</code></div>

<div class="line number30 index29 alt1">&nbsp;</div>

<div class="line number31 index30 alt2"><code class="php comments">//&nbsp;$query&nbsp;=&nbsp;"DROP&nbsp;TABLE&nbsp;IF&nbsp;EXISTS&nbsp;$tableposts";</code></div>

<div class="line number32 index31 alt1"><code class="php comments">//&nbsp;$q&nbsp;=&nbsp;mysql_query($query)&nbsp;or&nbsp;die&nbsp;("doh,&nbsp;can't&nbsp;drop&nbsp;the&nbsp;table&nbsp;\"$tableposts\"&nbsp;in&nbsp;the&nbsp;database.");</code></div>

<div class="line number33 index32 alt2">&nbsp;</div>

<div class="line number34 index33 alt1"><code class="php variable">$query</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php string">"CREATE&nbsp;TABLE&nbsp;$tableposts&nbsp;(&nbsp;ID&nbsp;int(10)&nbsp;unsigned&nbsp;NOT&nbsp;NULL&nbsp;auto_increment,&nbsp;post_author&nbsp;int(4)&nbsp;DEFAULT&nbsp;'0'&nbsp;NOT&nbsp;NULL,&nbsp;post_date&nbsp;datetime&nbsp;DEFAULT&nbsp;'0000-00-00&nbsp;00:00:00'&nbsp;NOT&nbsp;NULL,&nbsp;post_content&nbsp;text&nbsp;NOT&nbsp;NULL,&nbsp;post_title&nbsp;text&nbsp;NOT&nbsp;NULL,&nbsp;post_category&nbsp;int(4)&nbsp;DEFAULT&nbsp;'0'&nbsp;NOT&nbsp;NULL,&nbsp;post_karma&nbsp;int(11)&nbsp;DEFAULT&nbsp;'0'&nbsp;NOT&nbsp;NULL,&nbsp;PRIMARY&nbsp;KEY&nbsp;(ID),&nbsp;UNIQUE&nbsp;ID&nbsp;(ID)&nbsp;)"</code><code class="php plain">;</code></div>

<div class="line number35 index34 alt2"><code class="php variable">$q</code>&nbsp;<code class="php plain">=&nbsp;mysql_query(</code><code class="php variable">$query</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php string">"doh,&nbsp;can't&nbsp;create&nbsp;the&nbsp;table&nbsp;\"$tableposts\"&nbsp;in&nbsp;the&nbsp;database."</code><code class="php plain">,&nbsp;</code><code class="php variable">$query</code><code class="php plain">,&nbsp;mysql_error());</code></div>

<div class="line number36 index35 alt1">&nbsp;</div>

<div class="line number37 index36 alt2"><code class="php variable">$now</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php functions">date</code><code class="php plain">(</code><code class="php string">'Y-m-d&nbsp;H:i:s'</code><code class="php plain">);</code></div>

<div class="line number38 index37 alt1"><code class="php variable">$query</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php string">"INSERT&nbsp;INTO&nbsp;$tableposts&nbsp;(post_author,&nbsp;post_date,&nbsp;post_content,&nbsp;post_title,&nbsp;post_category)&nbsp;VALUES&nbsp;('1',&nbsp;'$now',&nbsp;'This&nbsp;is&nbsp;the&nbsp;first&nbsp;post.&nbsp;Edit&nbsp;or&nbsp;delete&nbsp;it,&nbsp;then&nbsp;start&nbsp;blogging&nbsp;!',&nbsp;'Hello&nbsp;world&nbsp;!',&nbsp;'1')"</code><code class="php plain">;</code></div>

<div class="line number39 index38 alt2"><code class="php variable">$q</code>&nbsp;<code class="php plain">=&nbsp;mysql_query(</code><code class="php variable">$query</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php string">"doh,&nbsp;can't&nbsp;insert&nbsp;a&nbsp;first&nbsp;post&nbsp;in&nbsp;the&nbsp;table&nbsp;\"$tableposts\"&nbsp;in&nbsp;the&nbsp;database."</code><code class="php plain">,&nbsp;</code><code class="php variable">$query</code><code class="php plain">,&nbsp;mysql_error());</code></div>

<div class="line number40 index39 alt1">&nbsp;</div>

<div class="line number41 index40 alt2"><code class="php functions">echo</code>&nbsp;<code class="php string">"posts:&nbsp;OK&lt;br&nbsp;/&gt;"</code><code class="php plain">;</code></div>

<div class="line number42 index41 alt1">&nbsp;</div>

<div class="line number43 index42 alt2"><code class="php comments">//&nbsp;$query&nbsp;=&nbsp;"DROP&nbsp;TABLE&nbsp;IF&nbsp;EXISTS&nbsp;$tablecategories";</code></div>

<div class="line number44 index43 alt1"><code class="php comments">//&nbsp;$q&nbsp;=&nbsp;mysql_query($query)&nbsp;or&nbsp;mysql_doh("doh,&nbsp;can't&nbsp;drop&nbsp;the&nbsp;table&nbsp;\"$tablecategories\"&nbsp;in&nbsp;the&nbsp;database.");</code></div>

<div class="line number45 index44 alt2">&nbsp;</div>

<div class="line number46 index45 alt1"><code class="php variable">$query</code><code class="php plain">=</code><code class="php string">"CREATE&nbsp;TABLE&nbsp;$tablecategories&nbsp;(cat_ID&nbsp;int(4)&nbsp;NOT&nbsp;NULL&nbsp;auto_increment,&nbsp;cat_name&nbsp;TINYTEXT&nbsp;not&nbsp;null&nbsp;,&nbsp;KEY&nbsp;(cat_ID))"</code><code class="php plain">;</code></div>

<div class="line number47 index46 alt2"><code class="php variable">$q</code>&nbsp;<code class="php plain">=&nbsp;mysql_query(</code><code class="php variable">$query</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php string">"doh,&nbsp;can't&nbsp;create&nbsp;the&nbsp;table&nbsp;\"$tablecategories\"&nbsp;in&nbsp;the&nbsp;database."</code><code class="php plain">,&nbsp;</code><code class="php variable">$query</code><code class="php plain">,&nbsp;mysql_error());</code></div>

<div class="line number48 index47 alt1">&nbsp;</div>

<div class="line number49 index48 alt2"><code class="php variable">$query</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php string">"INSERT&nbsp;INTO&nbsp;$tablecategories&nbsp;(cat_ID,&nbsp;cat_name)&nbsp;VALUES&nbsp;('0',&nbsp;'General')"</code><code class="php plain">;</code></div>

<div class="line number50 index49 alt1"><code class="php variable">$q</code>&nbsp;<code class="php plain">=&nbsp;mysql_query(</code><code class="php variable">$query</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php string">"doh,&nbsp;can't&nbsp;set&nbsp;the&nbsp;default&nbsp;category&nbsp;in&nbsp;the&nbsp;table&nbsp;\"$tablecategories\"&nbsp;in&nbsp;the&nbsp;database."</code><code class="php plain">,&nbsp;</code><code class="php variable">$query</code><code class="php plain">,&nbsp;mysql_error());</code></div>

<div class="line number51 index50 alt2">&nbsp;</div>

<div class="line number52 index51 alt1"><code class="php variable">$query</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php string">"UPDATE&nbsp;$tableposts&nbsp;SET&nbsp;post_category=\"1\""</code><code class="php plain">;</code></div>

<div class="line number53 index52 alt2"><code class="php variable">$result</code>&nbsp;<code class="php plain">=&nbsp;mysql_query(</code><code class="php variable">$query</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php string">"Oops,&nbsp;can't&nbsp;set&nbsp;the&nbsp;default&nbsp;category&nbsp;on&nbsp;$tableposts."</code><code class="php plain">,&nbsp;</code><code class="php variable">$query</code><code class="php plain">,&nbsp;mysql_error());</code></div>

<div class="line number54 index53 alt1">&nbsp;</div>

<div class="line number55 index54 alt2"><code class="php functions">echo</code>&nbsp;<code class="php string">"b2categories:&nbsp;OK&lt;br&nbsp;/&gt;"</code><code class="php plain">;</code></div>

<div class="line number56 index55 alt1">&nbsp;</div>

<div class="line number57 index56 alt2"><code class="php comments">//&nbsp;$query&nbsp;=&nbsp;"DROP&nbsp;TABLE&nbsp;IF&nbsp;EXISTS&nbsp;$tablecomments";</code></div>

<div class="line number58 index57 alt1"><code class="php comments">//&nbsp;$q&nbsp;=&nbsp;mysql_query($query)&nbsp;or&nbsp;mysql_doh("doh,&nbsp;can't&nbsp;drop&nbsp;the&nbsp;table&nbsp;\"$tablecomments\"&nbsp;in&nbsp;the&nbsp;database.");</code></div>

<div class="line number59 index58 alt2">&nbsp;</div>

<div class="line number60 index59 alt1"><code class="php variable">$query</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php string">"CREATE&nbsp;TABLE&nbsp;$tablecomments&nbsp;(&nbsp;comment_ID&nbsp;int(11)&nbsp;unsigned&nbsp;NOT&nbsp;NULL&nbsp;auto_increment,&nbsp;comment_post_ID&nbsp;int(11)&nbsp;DEFAULT&nbsp;'0'&nbsp;NOT&nbsp;NULL,&nbsp;comment_author&nbsp;tinytext&nbsp;NOT&nbsp;NULL,&nbsp;comment_author_email&nbsp;varchar(100)&nbsp;NOT&nbsp;NULL,&nbsp;comment_author_url&nbsp;varchar(100)&nbsp;NOT&nbsp;NULL,&nbsp;comment_author_IP&nbsp;varchar(100)&nbsp;NOT&nbsp;NULL,&nbsp;comment_date&nbsp;datetime&nbsp;DEFAULT&nbsp;'0000-00-00&nbsp;00:00:00'&nbsp;NOT&nbsp;NULL,&nbsp;comment_content&nbsp;text&nbsp;NOT&nbsp;NULL,&nbsp;comment_karma&nbsp;int(11)&nbsp;DEFAULT&nbsp;'0'&nbsp;NOT&nbsp;NULL,&nbsp;PRIMARY&nbsp;KEY&nbsp;(comment_ID)&nbsp;)"</code><code class="php plain">;</code></div>

<div class="line number61 index60 alt2"><code class="php variable">$q</code>&nbsp;<code class="php plain">=&nbsp;mysql_query(</code><code class="php variable">$query</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php string">"doh,&nbsp;can't&nbsp;create&nbsp;the&nbsp;table&nbsp;\"$tablecomments\"&nbsp;in&nbsp;the&nbsp;database."</code><code class="php plain">,&nbsp;</code><code class="php variable">$query</code><code class="php plain">,&nbsp;mysql_error());</code></div>

<div class="line number62 index61 alt1">&nbsp;</div>

<div class="line number63 index62 alt2"><code class="php variable">$now</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php functions">date</code><code class="php plain">(</code><code class="php string">'Y-m-d&nbsp;H:i:s'</code><code class="php plain">);</code></div>

<div class="line number64 index63 alt1"><code class="php variable">$query</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php string">"INSERT&nbsp;INTO&nbsp;$tablecomments&nbsp;(comment_post_ID,&nbsp;comment_author,&nbsp;comment_author_email,&nbsp;comment_author_url,&nbsp;comment_author_IP,&nbsp;comment_date,&nbsp;comment_content)&nbsp;VALUES&nbsp;('1',&nbsp;'miss&nbsp;b2',&nbsp;'[email protected]',&nbsp;'<a href="http://example.com">http://example.com</a>',&nbsp;'127.0.0.1',&nbsp;'$now',&nbsp;'Hi,&nbsp;this&nbsp;is&nbsp;a&nbsp;comment.&lt;br&nbsp;/&gt;To&nbsp;delete&nbsp;a&nbsp;comment,&nbsp;just&nbsp;log&nbsp;in,&nbsp;and&nbsp;view&nbsp;the&nbsp;posts\'&nbsp;comments,&nbsp;there&nbsp;you&nbsp;will&nbsp;have&nbsp;the&nbsp;option&nbsp;to&nbsp;edit&nbsp;or&nbsp;delete&nbsp;them.')"</code><code class="php plain">;</code></div>

<div class="line number65 index64 alt2"><code class="php variable">$q</code>&nbsp;<code class="php plain">=&nbsp;mysql_query(</code><code class="php variable">$query</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php string">"doh,&nbsp;can't&nbsp;insert&nbsp;a&nbsp;first&nbsp;comment&nbsp;in&nbsp;the&nbsp;table&nbsp;\"$tablecomments\"&nbsp;in&nbsp;the&nbsp;database."</code><code class="php plain">,&nbsp;</code><code class="php variable">$query</code><code class="php plain">,&nbsp;mysql_error());</code></div>

<div class="line number66 index65 alt1">&nbsp;</div>

<div class="line number67 index66 alt2"><code class="php functions">echo</code>&nbsp;<code class="php string">"comments:&nbsp;OK&lt;br&nbsp;/&gt;"</code><code class="php plain">;</code></div>

<div class="line number68 index67 alt1">&nbsp;</div>

<div class="line number69 index68 alt2"><code class="php comments">//&nbsp;$query&nbsp;=&nbsp;"DROP&nbsp;TABLE&nbsp;IF&nbsp;EXISTS&nbsp;$tablesettings";</code></div>

<div class="line number70 index69 alt1"><code class="php comments">//&nbsp;$q&nbsp;=&nbsp;mysql_query($query)&nbsp;or&nbsp;mysql_doh("doh,&nbsp;can't&nbsp;drop&nbsp;the&nbsp;table&nbsp;\"$tablesettings\"&nbsp;in&nbsp;the&nbsp;database.");</code></div>

<div class="line number71 index70 alt2">&nbsp;</div>

<div class="line number72 index71 alt1"><code class="php variable">$query</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php string">"CREATE&nbsp;TABLE&nbsp;$tablesettings&nbsp;(&nbsp;ID&nbsp;tinyint(3)&nbsp;DEFAULT&nbsp;'1'&nbsp;NOT&nbsp;NULL,&nbsp;posts_per_page&nbsp;int(4)&nbsp;unsigned&nbsp;DEFAULT&nbsp;'7'&nbsp;NOT&nbsp;NULL,&nbsp;what_to_show&nbsp;varchar(5)&nbsp;DEFAULT&nbsp;'days'&nbsp;NOT&nbsp;NULL,&nbsp;archive_mode&nbsp;varchar(10)&nbsp;DEFAULT&nbsp;'weekly'&nbsp;NOT&nbsp;NULL,&nbsp;time_difference&nbsp;tinyint(4)&nbsp;DEFAULT&nbsp;'0'&nbsp;NOT&nbsp;NULL,&nbsp;AutoBR&nbsp;tinyint(1)&nbsp;DEFAULT&nbsp;'1'&nbsp;NOT&nbsp;NULL,&nbsp;time_format&nbsp;varchar(20)&nbsp;DEFAULT&nbsp;'H:i:s'&nbsp;NOT&nbsp;NULL,&nbsp;date_format&nbsp;varchar(20)&nbsp;DEFAULT&nbsp;'Y/m/d'&nbsp;NOT&nbsp;NULL,&nbsp;PRIMARY&nbsp;KEY&nbsp;(ID),&nbsp;KEY&nbsp;ID&nbsp;(ID)&nbsp;)"</code><code class="php plain">;</code></div>

<div class="line number73 index72 alt2"><code class="php variable">$q</code>&nbsp;<code class="php plain">=&nbsp;mysql_query(</code><code class="php variable">$query</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php string">"doh,&nbsp;can't&nbsp;create&nbsp;the&nbsp;table&nbsp;\"$tablesettings\"&nbsp;in&nbsp;the&nbsp;database."</code><code class="php plain">,&nbsp;</code><code class="php variable">$query</code><code class="php plain">,&nbsp;mysql_error());</code></div>

<div class="line number74 index73 alt1">&nbsp;</div>

<div class="line number75 index74 alt2"><code class="php variable">$query</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php string">"INSERT&nbsp;INTO&nbsp;$tablesettings&nbsp;(&nbsp;ID,&nbsp;posts_per_page,&nbsp;what_to_show,&nbsp;archive_mode,&nbsp;time_difference,&nbsp;AutoBR,&nbsp;time_format,&nbsp;date_format)&nbsp;VALUES&nbsp;(&nbsp;'1',&nbsp;'20',&nbsp;'posts',&nbsp;'monthly',&nbsp;'0',&nbsp;'1',&nbsp;'H:i:s',&nbsp;'d.m.y')"</code><code class="php plain">;</code></div>

<div class="line number76 index75 alt1"><code class="php variable">$q</code>&nbsp;<code class="php plain">=&nbsp;mysql_query(</code><code class="php variable">$query</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php string">"doh,&nbsp;can't&nbsp;set&nbsp;the&nbsp;default&nbsp;settings&nbsp;in&nbsp;the&nbsp;table&nbsp;\"$tablesettings\"&nbsp;in&nbsp;the&nbsp;database."</code><code class="php plain">,&nbsp;</code><code class="php variable">$query</code><code class="php plain">,&nbsp;mysql_error());</code></div>

<div class="line number77 index76 alt2">&nbsp;</div>

<div class="line number78 index77 alt1"><code class="php functions">echo</code>&nbsp;<code class="php string">"settings:&nbsp;OK&lt;br&nbsp;/&gt;"</code><code class="php plain">;</code></div>

<div class="line number79 index78 alt2">&nbsp;</div>

<div class="line number80 index79 alt1"><code class="php comments">//&nbsp;$query&nbsp;=&nbsp;"DROP&nbsp;TABLE&nbsp;IF&nbsp;EXISTS&nbsp;$tableusers";</code></div>

<div class="line number81 index80 alt2"><code class="php comments">//&nbsp;$q&nbsp;=&nbsp;mysql_query($query)&nbsp;or&nbsp;mysql_doh("doh,&nbsp;can't&nbsp;drop&nbsp;the&nbsp;table&nbsp;\"$tableusers\"&nbsp;in&nbsp;the&nbsp;database.");</code></div>

<div class="line number82 index81 alt1">&nbsp;</div>

<div class="line number83 index82 alt2"><code class="php variable">$query</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php string">"CREATE&nbsp;TABLE&nbsp;$tableusers&nbsp;(&nbsp;ID&nbsp;int(10)&nbsp;unsigned&nbsp;NOT&nbsp;NULL&nbsp;auto_increment,&nbsp;user_login&nbsp;varchar(20)&nbsp;NOT&nbsp;NULL,&nbsp;user_pass&nbsp;varchar(20)&nbsp;NOT&nbsp;NULL,&nbsp;user_firstname&nbsp;varchar(50)&nbsp;NOT&nbsp;NULL,&nbsp;user_lastname&nbsp;varchar(50)&nbsp;NOT&nbsp;NULL,&nbsp;user_nickname&nbsp;varchar(50)&nbsp;NOT&nbsp;NULL,&nbsp;user_icq&nbsp;int(10)&nbsp;unsigned&nbsp;DEFAULT&nbsp;'0'&nbsp;NOT&nbsp;NULL,&nbsp;user_email&nbsp;varchar(100)&nbsp;NOT&nbsp;NULL,&nbsp;user_url&nbsp;varchar(100)&nbsp;NOT&nbsp;NULL,&nbsp;user_ip&nbsp;varchar(15)&nbsp;NOT&nbsp;NULL,&nbsp;user_domain&nbsp;varchar(200)&nbsp;NOT&nbsp;NULL,&nbsp;user_browser&nbsp;varchar(200)&nbsp;NOT&nbsp;NULL,&nbsp;dateYMDhour&nbsp;datetime&nbsp;DEFAULT&nbsp;'0000-00-00&nbsp;00:00:00'&nbsp;NOT&nbsp;NULL,&nbsp;user_level&nbsp;int(2)&nbsp;unsigned&nbsp;DEFAULT&nbsp;'0'&nbsp;NOT&nbsp;NULL,&nbsp;user_aim&nbsp;varchar(50)&nbsp;NOT&nbsp;NULL,&nbsp;user_msn&nbsp;varchar(100)&nbsp;NOT&nbsp;NULL,&nbsp;user_yim&nbsp;varchar(50)&nbsp;NOT&nbsp;NULL,&nbsp;user_idmode&nbsp;varchar(20)&nbsp;NOT&nbsp;NULL,&nbsp;PRIMARY&nbsp;KEY&nbsp;(ID),&nbsp;UNIQUE&nbsp;ID&nbsp;(ID),&nbsp;UNIQUE&nbsp;(user_login)&nbsp;)"</code><code class="php plain">;</code></div>

<div class="line number84 index83 alt1"><code class="php variable">$q</code>&nbsp;<code class="php plain">=&nbsp;mysql_query(</code><code class="php variable">$query</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php string">"doh,&nbsp;can't&nbsp;create&nbsp;the&nbsp;table&nbsp;\"$tableusers\"&nbsp;in&nbsp;the&nbsp;database."</code><code class="php plain">,&nbsp;</code><code class="php variable">$query</code><code class="php plain">,&nbsp;mysql_error());</code></div>

<div class="line number85 index84 alt2">&nbsp;</div>

<div class="line number86 index85 alt1"><code class="php variable">$random_password</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php functions">substr</code><code class="php plain">(md5(uniqid(microtime())),0,6);</code></div>

<div class="line number87 index86 alt2">&nbsp;</div>

<div class="line number88 index87 alt1"><code class="php variable">$query</code>&nbsp;<code class="php plain">=&nbsp;</code><code class="php string">"INSERT&nbsp;INTO&nbsp;$tableusers&nbsp;(ID,&nbsp;user_login,&nbsp;user_pass,&nbsp;user_firstname,&nbsp;user_lastname,&nbsp;user_nickname,&nbsp;user_icq,&nbsp;user_email,&nbsp;user_url,&nbsp;user_ip,&nbsp;user_domain,&nbsp;user_browser,&nbsp;dateYMDhour,&nbsp;user_level,&nbsp;user_aim,&nbsp;user_msn,&nbsp;user_yim,&nbsp;user_idmode)&nbsp;VALUES&nbsp;(&nbsp;'1',&nbsp;'admin',&nbsp;'$random_password',&nbsp;'',&nbsp;'',&nbsp;'admin',&nbsp;'0',&nbsp;'$admin_email',&nbsp;'',&nbsp;'127.0.0.1',&nbsp;'127.0.0.1',&nbsp;'',&nbsp;'00-00-0000&nbsp;00:00:01',&nbsp;'10',&nbsp;'',&nbsp;'',&nbsp;'',&nbsp;'nickname')"</code><code class="php plain">;</code></div>

<div class="line number89 index88 alt2"><code class="php variable">$q</code>&nbsp;<code class="php plain">=&nbsp;mysql_query(</code><code class="php variable">$query</code><code class="php plain">)&nbsp;</code><code class="php keyword">or</code>&nbsp;<code class="php plain">mysql_doh(</code><code class="php string">"doh,&nbsp;can't&nbsp;set&nbsp;the&nbsp;default&nbsp;user&nbsp;in&nbsp;the&nbsp;table&nbsp;\"$tableusers\"&nbsp;in&nbsp;the&nbsp;database."</code><code class="php plain">,&nbsp;</code><code class="php variable">$query</code><code class="php plain">,&nbsp;mysql_error());</code></div>

<div class="line number90 index89 alt1">&nbsp;</div>

<div class="line number91 index90 alt2"><code class="php functions">echo</code>&nbsp;<code class="php string">"users:&nbsp;OK&lt;br&nbsp;/&gt;"</code><code class="php plain">;</code></div>

<div class="line number92 index91 alt1"><code class="php plain">?&gt;</code></div>

<div class="line number93 index92 alt2">&nbsp;</div>

<div class="line number94 index93 alt1"><code class="php plain">&lt;br&nbsp;/&gt;</code></div>

<div class="line number95 index94 alt2"><code class="php plain">Installation&nbsp;successful&nbsp;!&lt;br&nbsp;/&gt;</code></div>

<div class="line number96 index95 alt1"><code class="php plain">&lt;br/&nbsp;&gt;</code></div>

<div class="line number97 index96 alt2"><code class="php plain">Now&nbsp;you&nbsp;can&nbsp;&lt;a&nbsp;href=</code><code class="php string">"b2login.php"</code><code class="php plain">&gt;log&nbsp;in&lt;/a&gt;&nbsp;with&nbsp;the&nbsp;login&nbsp;</code><code class="php string">"admin"</code>&nbsp;<code class="php keyword">and</code>&nbsp;<code class="php plain">password&nbsp;</code><code class="php string">"&lt;?php&nbsp;echo&nbsp;$random_password;&nbsp;?&gt;"</code><code class="php plain">.&lt;br&nbsp;/&gt;&lt;br&nbsp;/&gt;</code></div>

<div class="line number98 index97 alt1"><code class="php plain">&lt;br&nbsp;/&gt;</code></div>

<div class="line number99 index98 alt2"><code class="php plain">Note&nbsp;that&nbsp;password&nbsp;carefully&nbsp;!&nbsp;It&nbsp;is&nbsp;a&nbsp;&lt;em&gt;random&lt;/em&gt;&nbsp;password&nbsp;that&nbsp;is&nbsp;given&nbsp;to&nbsp;you&nbsp;when&nbsp;you&nbsp;install&nbsp;b2.&nbsp;If&nbsp;you&nbsp;lose&nbsp;it,&nbsp;you&nbsp;will&nbsp;have&nbsp;to&nbsp;</code><code class="php functions">delete</code>&nbsp;<code class="php plain">the&nbsp;tables&nbsp;from&nbsp;the&nbsp;database&nbsp;yourself,&nbsp;</code><code class="php keyword">and</code>&nbsp;<code class="php plain">re-install&nbsp;b2.</code></div>

<div class="line number100 index99 alt1">&nbsp;</div>

<div class="line number101 index100 alt2"><code class="php plain">&lt;/body&gt;</code></div>

<div class="line number102 index101 alt1"><code class="php plain">&lt;/html&gt;</code></div>

</div>

</td>

</tr>

</tbody>

</table>

</div>

</div>

具体的安装的步骤是:首先,创建用来装B2数据的数据库。

创建数据库的方法是

windows(linux和苹果的用户类似)下:ctl+r呼出命令行cmd。

然后连接mysql,在命令行中输入

mysql -uroot -p

如果有密码,接下来输入密码。如果没有密码,直接按回车。

然后

show databases;

create database b2install charset utf8;

这样我们就建立了一个名为b2install的数据库。

当然名字可以自己取。

然后我们打开b2config.php。

<div style="width: 650px; height: 500px; overflow: auto;">

<div id="highlighter_707140" class="syntaxhighlighter php">

<div class="toolbar"><a class="toolbar_item command_help help" href="#">?</a></div>

<table border="0" cellspacing="0" cellpadding="0">

<tbody>

<tr>

<td class="gutter">

<div class="line number1 index0 alt2">1</div>

<div class="line number2 index1 alt1">2</div>

<div class="line number3 index2 alt2">3</div>

<div class="line number4 index3 alt1">4</div>

<div class="line number5 index4 alt2">5</div>

<div class="line number6 index5 alt1">6</div>

<div class="line number7 index6 alt2">7</div>

<div class="line number8 index7 alt1">8</div>

<div class="line number9 index8 alt2">9</div>

<div class="line number10 index9 alt1">10</div>

<div class="line number11 index10 alt2">11</div>

<div class="line number12 index11 alt1">12</div>

<div class="line number13 index12 alt2">13</div>

<div class="line number14 index13 alt1">14</div>

<div class="line number15 index14 alt2">15</div>

<div class="line number16 index15 alt1">16</div>

<div class="line number17 index16 alt2">17</div>

<div class="line number18 index17 alt1">18</div>

<div class="line number19 index18 alt2">19</div>

<div class="line number20 index19 alt1">20</div>

<div class="line number21 index20 alt2">21</div>

<div class="line number22 index21 alt1">22</div>

<div class="line number23 index22 alt2">23</div>

<div class="line number24 index23 alt1">24</div>

<div class="line number25 index24 alt2">25</div>

<div class="line number26 index25 alt1">26</div>

<div class="line number27 index26 alt2">27</div>

<div class="line number28 index27 alt1">28</div>

<div class="line number29 index28 alt2">29</div>

<div class="line number30 index29 alt1">30</div>

<div class="line number31 index30 alt2">31</div>

<div class="line number32 index31 alt1">32</div>

<div class="line number33 index32 alt2">33</div>

<div class="line number34 index33 alt1">34</div>

<div class="line number35 index34 alt2">35</div>

<div class="line number36 index35 alt1">36</div>

<div class="line number37 index36 alt2">37</div>

<div class="line number38 index37 alt1">38</div>

<div class="line number39 index38 alt2">39</div>

<div class="line number40 index39 alt1">40</div>

<div class="line number41 index40 alt2">41</div>

<div class="line number42 index41 alt1">42</div>

<div class="line number43 index42 alt2">43</div>

<div class="line number44 index43 alt1">44</div>

<div class="line number45 index44 alt2">45</div>

<div class="line number46 index45 alt1">46</div>

<div class="line number47 index46 alt2">47</div>

<div class="line number48 index47 alt1">48</div>

<div class="line number49 index48 alt2">49</div>

<div class="line number50 index49 alt1">50</div>

<div class="line number51 index50 alt2">51</div>

<div class="line number52 index51 alt1">52</div>

<div class="line number53 index52 alt2">53</div>

<div class="line number54 index53 alt1">54</div>

<div class="line number55 index54 alt2">55</div>

<div class="line number56 index55 alt1">56</div>

<div class="line number57 index56 alt2">57</div>

<div class="line number58 index57 alt1">58</div>

<div class="line number59 index58 alt2">59</div>

<div class="line number60 index59 alt1">60</div>

<div class="line number61 index60 alt2">61</div>

<div class="line number62 index61 alt1">62</div>

<div class="line number63 index62 alt2">63</div>

<div class="line number64 index63 alt1">64</div>

<div class="line number65 index64 alt2">65</div>

<div class="line number66 index65 alt1">66</div>

<div class="line number67 index66 alt2">67</div>

<div class="line number68 index67 alt1">68</div>

<div class="line number69 index68 alt2">69</div>

<div class="line number70 index69 alt1">70</div>

<div class="line number71 index70 alt2">71</div>

<div class="line number72 index71 alt1">72</div>

<div class="line number73 index72 alt2">73</div>

<div class="line number74 index73 alt1">74</div>

<div class="line number75 index74 alt2">75</div>

<div class="line number76 index75 alt1">76</div>

<div class="line number77 index76 alt2">77</div>

<div class="line number78 index77 alt1">78</div>

<div class="line number79 index78 alt2">79</div>

<div class="line number80 index79 alt1">80</div>

<div class="line number81 index80 alt2">81</div>

<div class="line number82 index81 alt1">82</div>

<div class="line number83 index82 alt2">83</div>

<div class="line number84 index83 alt1">84</div>

<div class="line number85 index84 alt2">85</div>

<div class="line number86 index85 alt1">86</div>

<div class="line number87 index86 alt2">87</div>

<div class="line number88 index87 alt1">88</div>

<div class="line number89 index88 alt2">89</div>

<div class="line number90 index89 alt1">90</div>

<div class="line number91 index90 alt2">91</div>

<div class="line number92 index91 alt1">92</div>

<div class="line number93 index92 alt2">93</div>

<div class="line number94 index93 alt1">94</div>

<div class="line number95 index94 alt2">95</div>

<div class="line number96 index95 alt1">96</div>

<div class="line number97 index96 alt2">97</div>

<div class="line number98 index97 alt1">98</div>

<div class="line number99 index98 alt2">99</div>

<div class="line number100 index99 alt1">100</div>

<div class="line number101 index100 alt2">101</div>

<div class="line number102 index101 alt1">102</div>

<div class="line number103 index102 alt2">103</div>

<div class="line number104 index103 alt1">104</div>

<div class="line number105 index104 alt2">105</div>

<div class="line number106 index105 alt1">106</div>

<div class="line number107 index106 alt2">107</div>

<div class="line number108 index107 alt1">108</div>

<div class="line number109 index108 alt2">109</div>

<div class="line number110 index109 alt1">110</div>

<div class="line number111 index110 alt2">111</div>

<div class="line number112 index111 alt1">112</div>

<div class="line number113 index112 alt2">113</div>

<div class="line number114 index113 alt1">114</div>

<div class="line number115 index114 alt2">115</div>

<div class="line number116 index115 alt1">116</div>

<div class="line number117 index116 alt2">117</div>

<div class="line number118 index117 alt1">118</div>

<div class="line number119 index118 alt2">119</div>

<div class="line number120 index119 alt1">120</div>

<div class="line number121 index120 alt2">121</div>

<div class="line number122 index121 alt1">122</div>

<div class="line number123 index122 alt2">123</div>

<div class="line number124 index123 alt1">124</div>

<div class="line number125 index124 alt2">125</div>

<div class="line number126 index125 alt1">126</div>

<div class="line number127 index126 alt2">127</div>

<div class="line number128 index127 alt1">128</div>

<div class="line number129 index128 alt2">129</div>

<div class="line number130 index129 alt1">130</div>

<div class="line number131 index130 alt2">131</div>

<div class="line number132 index131 alt1">132</div>

<div class="line number133 index132 alt2">133</div>

<div class="line number134 index133 alt1">134</div>

<div class="line number135 index134 alt2">135</div>

<div class="line number136 index135 alt1">136</div>

<div class="line number137 index136 alt2">137</div>

<div class="line number138 index137 alt1">138</div>

<div class="line number139 index138 alt2">139</div>

<div class="line number140 index139 alt1">140</div>

<div class="line number141 index140 alt2">141</div>

<div class="line number142 index141 alt1">142</div>

<div class="line number143 index142 alt2">143</div>

<div class="line number144 index143 alt1">144</div>

<div class="line number145 index144 alt2">145</div>

<div class="line number146 index145 alt1">146</div>

<div class="line number147 index146 alt2">147</div>

<div class="line number148 index147 alt1">148</div>

<div class="line number149 index148 alt2">149</div>

<div class="line number150 index149 alt1">150</div>

<div class="line number151 index150 alt2">151</div>

<div class="line number152 index151 alt1">152</div>

<div class="line number153 index152 alt2">153</div>

<div class="line number154 index153 alt1">154</div>

<div class="line number155 index154 alt2">155</div>

<div class="line number156 index155 alt1">156</div>

<div class="line number157 index156 alt2">157</div>

<div class="line number158 index157 alt1">158</div>

<div class="line number159 index158 alt2">159</div>

<div class="line number160 index159 alt1">160</div>

<div class="line number161 index160 alt2">161</div>

<div class="line number162 index161 alt1">162</div>

<div class="line number163 index162 alt2">163</div>

<div class="line number164 index163 alt1">164</div>

<div class="line number165 index164 alt2">165</div>

<div class="line number166 index165 alt1">166</div>

<div class="line number167 index166 alt2">167</div>

<div class="line number168 index167 alt1">168</div>

<div class="line number169 index168 alt2">169</div>

<div class="line number170 index169 alt1">170</div>

<div class="line number171 index170 alt2">171</div>

<div class="line number172 index171 alt1">172</div>

<div class="line number173 index172 alt2">173</div>

<div class="line number174 index173 alt1">174</div>

<div class="line number175 index174 alt2">175</div>

<div class="line number176 index175 alt1">176</div>

<div class="line number177 index176 alt2">177</div>

<div class="line number178 index177 alt1">178</div>

<div class="line number179 index178 alt2">179</div>

<div class="line number180 index179 alt1">180</div>

<div class="line number181 index180 alt2">181</div>

<div class="line number182 index181 alt1">182</div>

<div class="line number183 index182 alt2">183</div>

<div class="line number184 index183 alt1">184</div>

<div class="line number185 index184 alt2">185</div>

<div class="line number186 index185 alt1">186</div>

<div class="line number187 index186 alt2">187</div>

<div class="line number188 index187 alt1">188</div>

<div class="line number189 index188 alt2">189</div>

<div class="line number190 index189 alt1">190</div>

<div class="line number191 index190 alt2">191</div>

<div class="line number192 index191 alt1">192</div>

<div class="line number193 index192 alt2">193</div>

<div class="line number194 index193 alt1">194</div>

<div class="line number195 index194 alt2">195</div>

<div class="line number196 index195 alt1">196</div>

<div class="line number197 index196 alt2">197</div>

<div class="line number198 index197 alt1">198</div>

<div class="line number199 index198 alt2">199</div>

<div class="line number200 index199 alt1">200</div>

<div class="line number201 index200 alt2">201</div>

<div class="line number202 index201 alt1">202</div>

<div class="line number203 index202 alt2">203</div>

<div class="line number204 index203 alt1">204</div>

<div class="line number205 index204 alt2">205</div>

<div class="line number206 index205 alt1">206</div>

<div class="line number207 index206 alt2">207</div>

<div class="line number208 index207 alt1">208</div>

<div class="line number209 index208 alt2">209</div>

<div class="line number210 index209 alt1">210</div>

<div class="line number211 index210 alt2">211</div>

<div class="line number212 index211 alt1">212</div>

<div class="line number213 index212 alt2">213</div>

<div class="line number214 index213 alt1">214</div>

<div class="line number215 index214 alt2">215</div>

<div class="line number216 index215 alt1">216</div>

<div class="line number217 index216 alt2">217</div>

<div class="line number218 index217 alt1">218</div>

<div class="line number219 index218 alt2">219</div>

<div class="line number220 index219 alt1">220</div>

<div class="line number221 index220 alt2">221</div>

<div class="line number222 index221 alt1">222</div>

<div class="line number223 index222 alt2">223</div>

<div class="line number224 index223 alt1">224</div>

<div class="line number225 index224 alt2">225</div>

<div class="line number226 index225 alt1">226</div>

<div class="line number227 index226 alt2">227</div>

<div class="line number228 index227 alt1">228</div>

<div class="line number229 index228 alt2">229</div>

<div class="line number230 index229 alt1">230</div>

<div class="line number231 index230 alt2">231</div>

<div class="line number232 index231 alt1">232</div>

<div class="line number233 index232 alt2">233</div>

<div class="line number234 index233 alt1">234</div>

<div class="line number235 index234 alt2">235</div>

<div class="line number236 index235 alt1">236</div>

<div class="line number237 index236 alt2">237</div>

<div class="line number238 index237 alt1">238</div>

<div class="line number239 index238 alt2">239</div>

<div class="line number240 index239 alt1">240</div>

<div class="line number241 index240 alt2">241</div>

<div class="line number242 index241 alt1">242</div>

<div class="line number243 index242 alt2">243</div>

<div class="line number244 index243 alt1">244</div>

<div class="line number245 index244 alt2">245</div>

<div class="line number246 index245 alt1">246</div>

<div class="line number247 index246 alt2">247</div>

<div class="line number248 index247 alt1">248</div>

<div class="line number249 index248 alt2">249</div>

<div class="line number250 index249 alt1">250</div>

<div class="line number251 index250 alt2">251</div>

<div class="line number252 index251 alt1">252</div>

<div class="line number253 index252 alt2">253</div>

<div class="line number254 index253 alt1">254</div>

<div class="line number255 index254 alt2">255</div>

<div class="line number256 index255 alt1">256</div>

<div class="line number257 index256 alt2">257</div>

<div class="line number258 index257 alt1">258</div>

<div class="line number259 index258 alt2">259</div>

<div class="line number260 index259 alt1">260</div>

<div class="line number261 index260 alt2">261</div>

<div class="line number262 index261 alt1">262</div>

<div class="line number263 index262 alt2">263</div>

<div class="line number264 index263 alt1">264</div>

<div class="line number265 index264 alt2">265</div>

<div class="line number266 index265 alt1">266</div>

<div class="line number267 index266 alt2">267</div>

<div class="line number268 index267 alt1">268</div>

<div class="line number269 index268 alt2">269</div>

<div class="line number270 index269 alt1">270</div>

<div class="line number271 index270 alt2">271</div>

<div class="line number272 i