<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<title><![CDATA[刘新修]]></title> 
<link>http://pic1.liuxinxiu.com:80/index.php</link> 
<description><![CDATA[刘新修的个人博客 (Liuxinxiu'S Blog)]]></description> 
<language>zh-cn</language> 
<copyright><![CDATA[刘新修]]></copyright>
<item>
<link>http://pic1.liuxinxiu.com:80/update_category_items/</link>
<title><![CDATA[phpcms_v9推送到其他栏目后再在其他栏目删除导致数据库出错]]></title> 
<author>刘新修 &lt;admin@yourname.com&gt;</author>
<category><![CDATA[H5/JS/CSS]]></category>
<pubDate>Wed, 19 Mar 2014 10:07:58 +0000</pubDate> 
<guid>http://pic1.liuxinxiu.com:80/update_category_items/</guid> 
<description>
<![CDATA[ 
	<p>&nbsp; <span style="color: rgb(80, 80, 80); font-family: 宋体, 'Arial Narrow', arial, serif; line-height: 28px; ">修改phpcms/model/content_model.class.php大概454行的</span><span style="padding: 0px; margin: 0px; color: rgb(80, 80, 80); font-family: consolas, 'bitstream vera sans mono', 'courier new', courier, monospace; line-height: 17.600000381469727px; ">update_category_items()函数</span></p><div class="codeText"><div class="codeHead">PHP代码</div><ol start="1" class="dp-c"><li class="alt"><span><span class="keyword">private</span><span>&nbsp;</span><span class="keyword">function</span><span>&nbsp;update_category_items(</span><span class="vars">$catid</span><span>,</span><span class="vars">$action</span><span>&nbsp;=&nbsp;</span><span class="string">'add'</span><span>,</span><span class="vars">$cache</span><span>&nbsp;=&nbsp;0)&nbsp;&#123;&nbsp;&nbsp;</span></span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;<span class="vars">$this</span><span>-&gt;category_db&nbsp;=&nbsp;pc_base::load_model(</span><span class="string">'category_model'</span><span>);&nbsp;&nbsp;</span></span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;<span class="keyword">if</span><span>(</span><span class="vars">$action</span><span>==</span><span class="string">'add'</span><span>)&nbsp;&#123;&nbsp;&nbsp;</span></span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="vars">$this</span><span>-&gt;category_db-&gt;update(</span><span class="keyword">array</span><span>(</span><span class="string">'items'</span><span>=&gt;</span><span class="string">'+=1'</span><span>),</span><span class="keyword">array</span><span>(</span><span class="string">'catid'</span><span>=&gt;</span><span class="vars">$catid</span><span>));&nbsp;&nbsp;</span></span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&#125;&nbsp;&nbsp;<span class="keyword">else</span><span>&nbsp;&#123;&nbsp;&nbsp;</span></span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="vars">$this</span><span>-&gt;category_db-&gt;update(</span><span class="keyword">array</span><span>(</span><span class="string">'items'</span><span>=&gt;</span><span class="string">'-=1'</span><span>),</span><span class="keyword">array</span><span>(</span><span class="string">'catid'</span><span>=&gt;</span><span class="vars">$catid</span><span>));&nbsp;&nbsp;</span></span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&#125;&nbsp;&nbsp;</span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;<span class="keyword">if</span><span>(</span><span class="vars">$cache</span><span>)&nbsp;</span><span class="vars">$this</span><span>-&gt;cache_items();&nbsp;&nbsp;</span></span></li><li class="alt"><span>&#125;&nbsp;&nbsp;</span></li></ol></div><p><span style="color: rgb(80, 80, 80); font-family: 宋体, 'Arial Narrow', arial, serif; line-height: 28px; ">修改为：</span></p><div class="codeText"><div class="codeHead">PHP代码</div><ol start="1" class="dp-c"><li class="alt"><span><span class="keyword">private</span><span>&nbsp;</span><span class="keyword">function</span><span>&nbsp;update_category_items(</span><span class="vars">$catid</span><span>,</span><span class="vars">$action</span><span>&nbsp;=&nbsp;</span><span class="string">'add'</span><span>,</span><span class="vars">$cache</span><span>&nbsp;=&nbsp;0)&nbsp;&#123;&nbsp;&nbsp;</span></span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;<span class="vars">$this</span><span>-&gt;category_db&nbsp;=&nbsp;pc_base::load_model(</span><span class="string">'category_model'</span><span>);&nbsp;&nbsp;</span></span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;<span class="keyword">if</span><span>(</span><span class="vars">$action</span><span>==</span><span class="string">'add'</span><span>)&nbsp;&#123;&nbsp;&nbsp;</span></span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="vars">$this</span><span>-&gt;category_db-&gt;update(</span><span class="keyword">array</span><span>(</span><span class="string">'items'</span><span>=&gt;</span><span class="string">'+=1'</span><span>),</span><span class="keyword">array</span><span>(</span><span class="string">'catid'</span><span>=&gt;</span><span class="vars">$catid</span><span>));&nbsp;&nbsp;</span></span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&#125;&nbsp;&nbsp;<span class="keyword">else</span><span>&nbsp;&#123;&nbsp;&nbsp;</span></span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="vars">$r</span><span>&nbsp;=</span><span class="vars">$this</span><span>-&gt;category_db-&gt;get_one(</span><span class="keyword">array</span><span>(</span><span class="string">'catid'</span><span>=&gt;</span><span class="vars">$catid</span><span>));&nbsp;&nbsp;</span></span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="keyword">if</span><span>(</span><span class="vars">$r</span><span>[</span><span class="string">'items'</span><span>]&gt;0)&nbsp;&nbsp;</span></span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#123;&nbsp;&nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="vars">$this</span><span>-&gt;category_db-&gt;update(</span><span class="keyword">array</span><span>(</span><span class="string">'items'</span><span>=&gt;</span><span class="string">'-=1'</span><span>),</span><span class="keyword">array</span><span>(</span><span class="string">'catid'</span><span>=&gt;</span><span class="vars">$catid</span><span>));&nbsp;&nbsp;</span></span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#125;&nbsp;&nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="comment">//$this-&gt;category_db-&gt;update(array('items'=&gt;'-=1'),array('catid'=&gt;$catid));</span><span>&nbsp;&nbsp;</span></span></li><li><span>&nbsp;&nbsp;&nbsp;&nbsp;&#125;&nbsp;&nbsp;</span></li><li class="alt"><span>&nbsp;&nbsp;&nbsp;&nbsp;<span class="keyword">if</span><span>(</span><span class="vars">$cache</span><span>)&nbsp;</span><span class="vars">$this</span><span>-&gt;cache_items();&nbsp;&nbsp;</span></span></li><li><span>&#125;&nbsp;&nbsp;</span></li></ol></div><p>&nbsp;</p>
]]>
</description>
</item><item>
<link>http://pic1.liuxinxiu.com:80/update_category_items/#blogcomment</link>
<title><![CDATA[[评论] phpcms_v9推送到其他栏目后再在其他栏目删除导致数据库出错]]></title> 
<author> &lt;user@domain.com&gt;</author>
<category><![CDATA[评论]]></category>
<pubDate>Thu, 01 Jan 1970 00:00:00 +0000</pubDate> 
<guid>http://pic1.liuxinxiu.com:80/update_category_items/#blogcomment</guid> 
<description>
<![CDATA[ 
	
]]>
</description>
</item>
</channel>
</rss>