Parašė KevinC· 2013 Lie. 6 22:07:39
#1
Sveiki, labai reikalinga jūsų pagalba su iškilusiu mysql erroru, tikiuosi padėsit, skolingas neliksiu. :)
ORDER BY date DESC LIMIT 0,20" );while ( $row = $db->get_row()){$row['date'] = strtotime( $row['date'] );$row['category'] = intval( $row['category'] );if( $config['allow_alt_url'] == "yes"){if( $row['flag'] and $config['seo_type']){if( $row['category'] and $config['seo_type'] == 2 ){$full_link = $config['http_home_url'] . get_url( $row['category'] ) . "/" . $row['id'] . "-" . $row['alt_name'] . ".html";}else{$full_link = $config['http_home_url'] . $row['id'] . "-" . $row['alt_name'] . ".html";}}else{$full_link = $config['http_home_url'] . date( 'Y/m/d/', $row['date'] ) . $row['alt_name'] . ".html";}}else{$full_link = $config['http_home_url'] . "index.php?newsid=" . $row['id'];}$title = substr( $row['title'], 0, 45 ) . "...";$short_story = substr( strip_tags($row['short_story']), 0, 0 )."...";$shortnews = $row['short_story'];preg_match_all( '#<img[^>]*\\ssrc=(\'|")(.*?)\\1.*?>#i',$shortnews,$total);foreach( $total[2] as $image )echo('
<?php $sql_result = $db->query( "SELECT id, title, date, alt_name, category, short_story, flag FROM " . PREFIX . "_post WHERE
category='1'
ORDER BY date DESC LIMIT 0,20" );while ( $row = $db->get_row()){$row['date'] = strtotime( $row['date'] );$row['category'] = intval( $row['category'] );if( $config['allow_alt_url'] == "yes"){if( $row['flag'] and $config['seo_type']){if( $row['category'] and $config['seo_type'] == 2 ){$full_link = $config['http_home_url'] . get_url( $row['category'] ) . "/" . $row['id'] . "-" . $row['alt_name'] . ".html";}else{$full_link = $config['http_home_url'] . $row['id'] . "-" . $row['alt_name'] . ".html";}}else{$full_link = $config['http_home_url'] . date( 'Y/m/d/', $row['date'] ) . $row['alt_name'] . ".html";}}else{$full_link = $config['http_home_url'] . "index.php?newsid=" . $row['id'];}$title = substr( $row['title'], 0, 45 ) . "...";$short_story = substr( strip_tags($row['short_story']), 0, 0 )."...";$shortnews = $row['short_story'];preg_match_all( '#<img[^>]*\\ssrc=(\'|")(.*?)\\1.*?>#i',$shortnews,$total);foreach( $total[2] as $image )echo('
<div class="panel">
<img src="'.$image.'" alt="" width="510" />
<div class="panel-overlay">
<div class="pan"><a href="'.$full_link.'">'.$title.'</a></div>
</div></div>
');}?>
Redagavo KevinC· 2013 Lie. 6 22:07:31