- 1
- 2
- 3
- 4
$sql = "SELECT (max(nid) + 1) FROM cms_news";
$MySQL_baza->ExecQuery($sql);
$myrow=$MySQL_baza->FetchArray();
$max=$myrow[0];
Нашли или выдавили из себя код, который нельзя назвать нормальным, на который без улыбки не взглянешь? Не торопитесь его удалять или рефакторить, — запостите его на говнокод.ру, посмеёмся вместе!
+164
$sql = "SELECT (max(nid) + 1) FROM cms_news";
$MySQL_baza->ExecQuery($sql);
$myrow=$MySQL_baza->FetchArray();
$max=$myrow[0];
Копался в одном старом проекте, не сразу понял зачем нужен следующий код.
Автоинкримент %)
+161
function GetBasketUserID($bSkipFUserInit = False)
{
$bSkipFUserInit = ($bSkipFUserInit ? True : False); // <----это зачем вообще надо
if (!array_key_exists("SALE_USER_ID", $_SESSION))
$_SESSION["SALE_USER_ID"] = 0;
CSaleBasket::Init(false, $bSkipFUserInit);
return $_SESSION["SALE_USER_ID"];
}
Стандартная функция модуля интернет-магазина в битригзе. Наткнулся во время поиска неуловимого бага, из-за которого пришлось лезть в кишки CMS
+145
<?php
$tmp = mcc_get_contacts();
if (!empty($tmp)) {
$i = 0;
foreach ($tmp as $k => $v) {
if (empty($v['coords'])) {
echo '<div class="s_adr" style="width: 275px;">' . "\r\n";
echo 'г. <span>' . $v['city'] . '</span><br /><br />' . "\r\n";
if (!empty($v['telfax'])) foreach ($v['telfax'] as $v_t) {
echo 'Тел/факс: <span>' . $v_t . '</span><br />' . "\r\n";
}
if (!empty($v['tel'])) foreach ($v['tel'] as $v_t) {
echo 'Телефон: <span>' . $v_t . '</span><br />' . "\r\n";
}
echo 'e-mail: <a href="mailto:' . $v['email'] . '">' . $v['email'] . '</a><br />' . "\r\n";
echo '</div>' . "\r\n";
} else {
echo '<div class="s_cont">' . "\r\n";
if ($i === 0) {
echo '<div class="print-icon"><a href="#print" onclick="window.print(); return false;">Печать</a></div>' . "\r\n";
}
echo '<div class="map" id="map' . $k . '">' . $v['coords'] . '</div>' . "\r\n";
echo '<div class="s_adr" >' . "\r\n";
echo 'г. <span>' . $v['city'] . '</span><br /><br />' . "\r\n";
echo '<p>';
if (!empty($v['telfax'])) foreach ($v['telfax'] as $v_t) {
echo 'Тел/факс: <span>' . $v_t . '</span><br />' . "\r\n";
}
if (!empty($v['tel'])) foreach ($v['tel'] as $v_t) {
echo 'Телефон: <span>' . $v_t . '</span><br />' . "\r\n";
}
echo 'e-mail: <a href="mailto:' . $v['email'] . '">' . $v['email'] . '</a></p>' . "\r\n";
echo '<p>';
if (!empty($v['metro'])) {
echo 'м. "' . implode('" / "', $v['metro']) . '",<br />' . "\r\n";
}
echo $v['address'] . '</p>' . "\r\n";
echo '</div>' . "\r\n";
echo '</div>' . "\r\n";
echo '<div class="hr"></div>' . "\r\n";
}
$i++;
}
}
?>
<div class="hr"></div>
<script src="<?php bloginfo('stylesheet_directory'); ?>/jquery-1.4.2.min.js" type="text/javascript"></script>
<script src="http://maps.google.com/maps?file=api&v=2&key=ABQIAAAAY78XWK5-Zy3qhkiV3w_m0hTPoZqTU4uhKIMSNHImBFQOd4WjahSr_Q8JwRSdhkeCWJkgoFFnVWj2Aw" type="text/javascript"></script>
<script type="text/javascript"><!--
$(document).ready(function(){
var show_map = function(o, p3, p2, p1, p0, p4) {
if (o.length) {
o.empty().show();
var s = $('<img class="print" />').attr('alt', '');
s.attr('src', 'http://maps.google.com/staticmap?center=' + p0 + ',' + p1 + '&zoom=' + p4 + '&size=580x312&maptype=roadmap&markers=' + p2 + ',' + p3 + '&hl=ru&key=ABQIAAAAY78XWK5-Zy3qhkiV3w_m0hTPoZqTU4uhKIMSNHImBFQOd4WjahSr_Q8JwRSdhkeCWJkgoFFnVWj2Aw');
o.next().after(s);
var map = new GMap2(o.get(0));
map.addControl(new GSmallMapControl());
map.setCenter(new GLatLng(p0, p1), p4);
var marker = new GMarker(new GLatLng(p2, p3));
map.addOverlay(marker);
}
};
if (GBrowserIsCompatible()) {
$('div.map').each(function () {
var p = $(this).text().split(',');
show_map($(this), parseFloat(p[1]), parseFloat(p[0]), parseFloat(p[3]), parseFloat(p[2]), parseInt(p[4]));
});
}
});
//--></script>
+164
if (!isset ($_POST['filter']['state'])) $_POST['filter']['state'] = 0;
.....
$state = @$_POST['filter']['state'] ? $_POST['filter']['state'] : 0;
не, ну а вдруг потеряется
+161
public function selectItems( $id, $withStrictment = 'no' /* $withStrictment = no, retail, discount */ ) {
if( $withStrictment == 'discount' ) $onlyWithRetailPriceSql = " and items.articul in ( select articul from items_discount ) ";
if( $withStrictment == 'retail' ) $onlyWithRetailPriceSql = " and items.articul in ( select articul from retailPrice ) ";
$a = database::select(" SELECT items.* FROM items WHERE items.id = '$id' and items.deleted = 'no' ");
$a = $a[0];
$this->data = database::select("SELECT items.*,
IF(DATEDIFF(now(),created) <= 30, 'Новинка! ', '') as fresh,
( items.quantity - coalesce(view_pendeditemsquantity.sum,0) ) as quantity,
items_comments.comment as dopDescr, items_comments.comment as comment, items_discount.priceAsUSD as discountPrice,
items_packing.packing,
concat(items.name, ' - ', items.quantity) as name
FROM items
LEFT JOIN view_pendeditemsquantity ON items.articul = view_pendeditemsquantity.articul
LEFT JOIN items_comments ON items.articul = items_comments.articul
left join items_discount on items.articul = items_discount.articul
left join items_packing on items.articul = items_packing.articul
WHERE items.group_id in ( select articul from items where is_group = '1' and name = '{$a['name']}' and group_id = '' )
and items.deleted = 'no'
$onlyWithRetailPriceSql
order by items.quantity desc, items.name asc
");
}
+186
$__language = ($__language == 'en')?'ru':'lv';
мозговынос
+177
if (preg_replace("/[\D]+/" , '', $word)) {
$word = str_replace('.','',$word);
$word = str_replace(',','',$word);
$word = str_replace(' ','',$word);
$word = str_replace('$','',$word);
$word = str_replace('*','',$word);
}
Увидев первую строчку я уж обрадовался, оказалось рано.
+165
try {
$newUserId = $users->insert($data);
} catch (Exception $e) {
if ($e->getCode() == '23000') {
$this->customRedirect(
array(
'notice',
'User already exists',
)
);
return;
} else {
throw new Exception(null, null, $e);
}
}
Быстрая проверка на уникальность.
+167
if (is_file($GLOBALS['fldr']."modules/sell/images/items/small_".str_replace("<img src=http://www.site.ru/modules/sell/images/items/small_", "", str_replace(" border=0>","",$M['icon'])))) {
echo "<a href='".$GLOBALS['fldr']."marki/models/object/current/index.php?id=".$M['id']."'>".replace_icon($M['icon'])."</a>";
}
function replace_icon($var) {
return str_replace("<img src=http://www.site.ru/modules/sell/images/items/", "<img src=".$GLOBALS['fldr']."modules/sell/images/items/?img_name=", $var);
}
Мы легких путей не ищем...
+146
if ($url=='/news/index.html')
{
$data = $this->dbf->execute('select * from news where status=1 order by date_add desc,id desc limit 10');
$object->smarty->assign('news_body',$data);
$object->smarty->assign('title','Новости');
} elseif(preg_match('@/news/([0-9]+?)/@i',$url,$out)){
$data = $this->dbf->execute('select * from news where status=1 and id='.intval($out[1]).' order by date_add desc limit 1');
$object->smarty->assign('news_body',$data);
$object->smarty->assign('title','Новости');
} elseif($url=='/search/') {
$data = array();
if ($_POST['search']!='' && strlen($_POST['search'])>6)
{
$data = $this->dbf->execute('select * from pages where content like "%'.mysql_real_escape_string($_POST['search'],$this->dbh->conn).'%" limit 10');
}
$object->smarty->assign('search',$data);
$object->smarty->assign('title','Поиск');
$object->smarty->assign('news',$this->dbh->execute('select * from news where status=1 order by date_add desc limit 3'));
} else {
$data = $this->dbf->execute('select * from pages where link="'.mysql_real_escape_string($url,$this->dbh->conn).'"');
$this->data = $data[0];
$object->smarty->assign('title',$this->data['title']);
$object->smarty->assign('news',$this->dbh->execute('select * from news where status=1 order by date_add desc limit 3'));
}