WooYun.org

if ( empty( $step ) || $step == "articleList" )
{
				$mytypeId_cond = "";
				if ( !empty( $mytypeId ) )
				{
								$mytypeId_cond = " and mytypeId=".$mytypeId." ";
				}
				$sql_query = "SELECT `id`\r\n\t\t\t, `name`\r\n\t\t\t, `systypeId`\r\n\t\t\t, `mytypeId`\r\n\t\t\t, `status`\r\n\t\t\t, `sys_status`\r\n\t\t\t, `sort`\r\n\t\t\t, `uid`\r\n\t\t\t, `count`\r\n\t\t\t, `type`\r\n\t\t\t, `content`\r\n\t\t\t, `createtime` \r\n\t\t\t,(SELECT `name` FROM `".$tablepre."logtype` WHERE `type`=0 and id=a.mytypeId)  as typename\r\n\tFROM `{$tablepre}article` a\r\n\tWHERE `uid`='{$id}' \r\n\t\t   and `type`='0' and `status`=1 {$mytypeId_cond} ORDER BY `id` DESC\r\n\t";
				$sql_count = "SELECT count(*)\r\n\t\t  FROM `".$tablepre."article`  \r\n\t\t  WHERE `uid`='{$id}' and `type`='0' {$mytypeId_cond}\r\n\t\t   \r\n\t\t  ";
				( );
				$page = new pdo_page( );
				$page_size = 20;
				$link_num = 6;
				$pagestr = "?action=article&step=articleList&id=".$id."&";
				$page->set( $db, $sql_query, $sql_count, $page_size, $link_num, $pagestr );
				$page->create_page( );
				$page_data = $page->get( 0 );
				$page_show = $page->get( 1 );
				$tpl->assign( "page_show", $page_show );
				$page_data = htmlsc( $page_data );
				$tpl->assign( "articles", $page_data );
				$tpl->display( "user/default/articleList.html" );
}