Поиск говнокода

Этот поиск практически ничего не может найти! Но вы всё-таки попытайтесь, вдруг повезет.

Найдено: 384

PHP / Говнокод #6468

+162

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

$_i=1;
  $_stb = mysql_query("SELECT * FROM ".$admin_prefix."_catalog_title WHERE pub=1 ORDER BY sort, BINARY name");
  while($_rtb=mysql_fetch_assoc($_stb)){
    echo print_r($_rtb,2);
    $sql="SELECT * FROM ".$admin_prefix."_catalog_regions WHERE pub=1 AND region_id=0 AND (id IN (".implode(",",$_SESSION['terms']['toureastgroup_catalog_regions'])."))";
    $_s_reg=mysql_query($sql);
    while($_r_reg=mysql_fetch_assoc($_s_reg)){
        // определяем подрегионы региона
        $result_array=array();$all_current_regions_array=array();$all_current_regions_array_where=array();
        GetChildElements("region_id",$_r_reg['id'],$admin_prefix."_catalog_regions",$_SESSION['terms']['toureastgroup_catalog_regions']);
        $all_current_regions_array=$result_array;
        // добавляем сам регион
        
        $all_current_regions_array[]=$_r_reg['id'];
        // составляем условие региона
        foreach($all_current_regions_array as $v){									
          $all_current_regions_array_where[]="(region_id LIKE '%##".$v."##%')";									
        }
        $sql="SELECT * FROM ".$admin_prefix."_catalog_programms WHERE pub=1 AND title_id=$_rtb[id] AND (id IN (".$_SESSION['string_where_programms'].")) AND (".implode(" OR ",$all_current_regions_array_where).")";
        $_s_pr=mysql_query($sql);
        $_title_progs_id=array();
        while($_r_pr=mysql_fetch_assoc($_s_pr)){
          $_title_progs_id[]=$_r_pr['id'];
        }
        $_title_progs_where="(".implode(",",$_title_progs_id).")";
        
        $sql="SELECT * FROM ".$admin_prefix."_catalog_programs_tours WHERE price>0 AND start>=".(time()-36000)." AND pub=1 AND (programm_id IN ".$_title_progs_where.") ORDER BY start LIMIT 5";
        $_stours=mysql_query($sql);
        if(mysql_num_rows($_stours)>0){
            while($_rtours=mysql_fetch_assoc($_stours)){
              echo '<pre>'.print_r($_rtours,2).'</pre>';
              $_array_r=array();
            }
        }
   }
   $_i++;

Простите не удержался, больше не могу раскапывать это...
сайт ввв.toureastgroup.ру автор откликнись - плюну в лицо

Sum, 25 Апреля 2011

Комментарии (4)

PHP / Говнокод #6344

+179

1
2
3

// Count rows in news table
$rows = $db -> query('SELECT * FROM news');
$count = count($rows)

Увидел в одном самопальном движке.

Shitafaka, 14 Апреля 2011

Комментарии (16)

SQL / Говнокод #6218

−858

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20

create or replace function t8() returns integer as $$
declare
    rec record;
begin
    for rec in select * from purchase loop
      update purchase set amount=(
              select book.cost*purchase.quantity*(1-customer.discount/100.0)
              from purchase, book, customer
              where purchase.id=rec.id and
                  book.id=purchase.book and
                  customer.id=purchase.customer
      )
      where purchase.id=rec.id;
    end loop;

    return 1;
end;
$$ language plpgsql;

select t8();

прочно засевшие в голове алгоритмические языки

ilardm, 04 Апреля 2011

Комментарии (2)

PHP / Говнокод #6184

+160

01
02
03
04
05
06
07
08
09
10

<?php
$vlid = mysql_fetch_array( mysql_query("select * from vt_par where pid = $nov[id] && prmid = 17") ); $param17 = $vlid[val_int]; $param17print = number_format($param17,0,","," "); // Стоимость [17]
$vlid = mysql_fetch_array( mysql_query("select * from vt_par where pid = $nov[id] && prmid = 131") ); $param131 = $vlid[val_char]; // Артикул [131]
$vlid = mysql_fetch_array( mysql_query("select * from vt_par where pid = $nov[id] && prmid = 28") ); $param28 = $vlid[val_int]; // Код [28]
$vlid = mysql_fetch_array( mysql_query("select * from vt_par where pid = $nov[id] && prmid = 29") ); $param29 = $vlid[val_int]; // Новинка [29]
$vlid = mysql_fetch_array( mysql_query("select * from vt_par where pid = $nov[id] && prmid = 130") ); $param130 = $vlid[val_int]; // Акция или распродажа [130]
$vlid = mysql_fetch_array( mysql_query("select * from vt_par where pid = $nov[id] && prmid = 76") ); $param76 = $vlid[val_int]; // Бесплатная доставка [76]
$vlid = mysql_fetch_array( mysql_query("select * from vt_par where pid = $nov[id] && prmid = 232") ); $param232 = $vlid[val_int]; // Топ продаж [232]
$vlid = mysql_fetch_array( mysql_query("select * from vt_par where pid = $nov[id] && prmid = 44") ); $param44 = $vlid[val_char]; // Тип товара для Яндекс.Маркета [44]
?>

Именно так нужно именовать переменные. Видимо, чтоб враги не догадались. Я уж не говорю про ужас работы с БД. Всё это безобразие выполняется на одну страницу раз по 50-70.

TiGR, 01 Апреля 2011

Комментарии (7)

Python / Говнокод #6116

−83

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

for row in rows:
    service = row[0].split('_')
    if row[0].find('lk_s_du') > -1:
        loki_cursor.execute("""select tariff_id from inet_inetsessionlog where id = %s;""", (service[-1],))
        tariff_id = str(loki_cursor.fetchall()[0][0])
    else:
        if row[1] == 'inet_dynamic_ip':
            cursor.execute('select tariff_plan from inet_dynamic_ip_services where id = %s', (service[-1],))
            tariff = str(cursor.fetchall()[0][0])
        elif row[1] == 'inet_fixed_ip':
            if row[0].split('_')[-1].find('.') == -1:
                cursor.execute('select tariff_plan from inet_fixed_ip_services where id = %s', (service[-1],))
            else:
                cursor.execute('select tariff_plan from inet_fixed_ip_services where id = %s', (service[-2],))
            tariff = str(cursor.fetchall()[0][0])
        loki_cursor.execute("select tariff_ptr_id from inet_inettariff where cherry_id = %s", (tariff,))
        tariff_id = str(loki_cursor.fetchall()[0][0])
    loki_cursor.execute("select * from inet_inettariff where tariff_ptr_id = %s", (tariff_id,))
    tariff = loki_cursor.fetchall()[0]
tariff = dict(zip(('tariff_ptr_id', 'price_per_unit', 'is_dynamic', 'cherry_id', 'ie_price_first', 'ie_price_second', 'ie_price_switch', 'oe_price_first', 'oe_price_second', 'oe_price_switch', 'il_price_first', 'il_price_second', 'il_price_switch', 'ol_price_first', 'ol_price_second', 'ol_price_switch'), tariff))
    if login in row[0]:
        print>>o, (str(row[2]) + ';' + row[4] + ';' + str(row[5]).replace('.000000', '').replace('.', ',') + ';' + row[6] + ';' + str(price)).decode('utf-8').replace(u'incoming_external', u'Входящий внешний').replace(u'internal', u'Внутренний').replace(u'outgoing_any',u'Исходящий внешний').encode('utf-8')
    else:
        print>>o, (str(row[2]) + ';' + row[4] + ';' + str(row[5]).replace('.000000', '').replace('.', ',') + ';' + row[6] + ';' + str(price)).decode('utf-8').replace(u'incoming_external', u'Входящий внешний').replace(u'internal', u'Внутренний').replace(u'outgoing_any',u'Исходящий внешний').replace(date_start,u'Суммарно').encode('utf-8')
else:
    price = str(row[7]).replace('.',',')
    if login in row[0]:
        print>>o, (str(row[2]) + ';' + row[4] + ';' + str(row[5]).replace('.000000', '').replace('.', ',') + ';' + row[6] + ';' + str(price)).decode('utf-8').replace(u'incoming_external', u'Входящий внешний').replace(u'internal', u'Внутренний').replace(u'outgoing_any',u'Исходящий внешний').encode('utf-8')
    else:
        print>>o, (str(row[2]) + ';' + row[4] + ';' + str(row[5]).replace('.000000', '').replace('.', ',') + ';' + row[6] + ';' + str(price)).decode('utf-8').replace(u'incoming_external', u'Входящий внешний').replace(u'internal', u'Внутренний').replace(u'outgoing_any',u'Исходящий внешний').replace(date_start,u'Суммарно').encode('utf-8')

Кусочек интернет-тарификатора.

spaceoflabview, 29 Марта 2011

Комментарии (5)

SQL / Говнокод #6074

−860

1
2
3
4

update dv_main set dv_main.tp_id = 2 where dv_main.uid in
(SELECT dv.uid FROM (select * from dv_main) as dv
LEFT JOIN users u ON (u.uid = dv.uid)
WHERE dv.tp_id = 1);

Вот так вот саппорт одного биллинга посоветовал массово сменить тарифный план пользователям...

NiTr0man, 23 Марта 2011

Комментарии (3)

PHP / Говнокод #6016

+161

01
02
03
04
05
06
07
08
09
10
11

<?
function save($author,$title,$pubyear,$price) {
        $sql = "INSERT INTO catalog(author,title,pubyear,price) 
                        VALUES('$author','$title',$pubyear,$price)";
        mysql_query($sql) or die (mysql_error());
}
 function selectAll() {
                $sql = "SELECT * FROM catalog";
                $result = mysql_query($sql) or die(mysql_error());
                return $result;
}

qbasic, 17 Марта 2011

Комментарии (10)

SQL / Говнокод #5979

−851

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

select distinct bk.ID, bk.URL, bk.Date, bk.Name, bk.Description, bk.UserCreatorID from bookmarking_bookmark as bk 
where bk.Tenant=@Tenant and bk.ID in 
(select *  from (select b.ID  from bookmarking_bookmark as b  left join  bookmarking_bookmarktag as bt on b.ID=bt.BookmarkID left join bookmarking_tag as t  on bt.TagID=t.TagID 
left join (select ub.BookmarkID as BookmarkID, ub.Name as UserBookmarkName,ub.Description as UserBookmarkDescription, t.Name as TagName  
from (select * from bookmarking_userbookmark as ub where ub.UserID=@userID) as ub 
left join bookmarking_userbookmarktag as ubt  on ub.UserBookmarkID=ubt.UserBookmarkID  
left join bookmarking_tag as t  on ubt.TagID=t.TagID) as ub on b.ID=ub.BookmarkID 
where  ( ( lower(b.URL) like lower(@tagNameForUrlWithoutLastSlash0) )  
or (lower(b.Name) like lower(@tagName0) or lower(b.Name) like lower(@tagNameWithSpace0)) 
or (lower(b.Description) like lower(@tagName0) or lower(b.Description) like lower(@tagNameWithSpace0))    
or (lower(t.Name) like lower(@tagName0)) or (lower(t.Name)  like lower(@tagNameWithSpace0)) 
or (lower(TagName) like lower(@tagName0)) or (lower(TagName) like lower(@tagNameWithSpace0))    
or (lower(UserBookmarkName) like lower(@tagName0) or lower(UserBookmarkName) like lower(@tagNameWithSpace0))    
or (lower(UserBookmarkDescription) like lower(@tagName0) or lower(UserBookmarkDescription) like lower(@tagNameWithSpace0)))  
and b.ID in (
select b.ID   from bookmarking_bookmark as b  left join  bookmarking_bookmarktag as bt  on b.ID=bt.BookmarkID
left join bookmarking_tag as t    on bt.TagID=t.TagID 
left join  (
select ub.BookmarkID as BookmarkID, ub.Name as UserBookmarkName, ub.Description as UserBookmarkDescription, t.Name as TagName from 
(select * from bookmarking_userbookmark as ub where ub.UserID=@userID) as ub  
left join bookmarking_userbookmarktag as ubt on ub.UserBookmarkID=ubt.UserBookmarkID
left join bookmarking_tag as t on ubt.TagID=t.TagID) as ub on b.ID=ub.BookmarkID
where  (( lower(b.URL) like lower(@tagNameForUrlWithoutLastSlash1) ) or (lower(b.Name) like lower(@tagName1) or lower(b.Name) like lower(@tagNameWithSpace1)) 
or (lower(b.Description) like lower(@tagName1) or lower(b.Description) like lower(@tagNameWithSpace1)) or (lower(t.Name) like lower(@tagName1)) 
or (lower(t.Name)  like lower(@tagNameWithSpace1)) or (lower(TagName) like lower(@tagName1)) or (lower(TagName) like lower(@tagNameWithSpace1))  
or (lower(UserBookmarkName) like lower(@tagName1) or lower(UserBookmarkName) like lower(@tagNameWithSpace1)) or (lower(UserBookmarkDescription)
like lower(@tagName1) or lower(UserBookmarkDescription) like lower(@tagNameWithSpace1))) and b.ID in (
select b.ID from bookmarking_bookmark as b left join bookmarking_bookmarktag as bt on b.ID=bt.BookmarkID left join bookmarking_tag as t on bt.TagID=t.TagID left join
(select ub.BookmarkID as BookmarkID, ub.Name as UserBookmarkName,  ub.Description as UserBookmarkDescription, t.Name as TagName 
from (select * from bookmarking_userbookmark as ub where ub.UserID=@userID) as ub 
left join bookmarking_userbookmarktag as ubt on ub.UserBookmarkID=ubt.UserBookmarkID  left join bookmarking_tag as t on ubt.TagID=t.TagID) as ub on b.ID=ub.BookmarkID
where (( lower(b.URL) like lower(@tagNameForUrlWithoutLastSlash2) ) or (lower(b.Name) like lower(@tagName2) or lower(b.Name) like lower(@tagNameWithSpace2))
or (lower(b.Description) like lower(@tagName2) or lower(b.Description) like lower(@tagNameWithSpace2)) or (lower(t.Name) like lower(@tagName2)) or (lower(t.Name)
like lower(@tagNameWithSpace2)) or....

среднее время выполнения 30 секунд

arusanov, 14 Марта 2011

Комментарии (115)

PHP / Говнокод #5972

+165

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16

if (isset($_GET['frends'])) {
  $query = "SELECT `imail` FROM `frends` WHERE imail ='" .$_SESSION['user'] . "' AND status = '1'";
  $res = mysql_query($query) or die(mysql_error());
  
  while ($row = mysql_fetch_array($res)) {
       $imail = $row['imail_frend'];
 
 
       $query2 = "SELECT * FROM `users` WHERE imail ='$imail'";
       $res2 = mysql_query($query2) or die(mysql_error());
   
      $row2 = mysql_fetch_array($res2);
       echo $row2['surname'];
 
   }
}

qbasic, 13 Марта 2011

Комментарии (7)

PHP / Говнокод #5962

+159

01
02
03
04
05
06
07
08
09
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

<?php
session_start();
DEFINE('trusteko', true);
@$l=$_GET['l'];
//echo md5('12345');
include_once "../admin/meta.php";
include_once ("../inc/setup.php");
include_once ("../inc/config.php");
$dbc=db_connect();
if(isset($_POST['reg']))
{
$query="SELECT * FROM `access` WHERE login='".$_POST['login']."' LIMIT 1";
$result = mysql_query($query,$dbc);
$row=mysql_fetch_array($result);
    if (md5($_POST['passwd'])==$row['parol'] and $_POST['login']==$row['login'])
    {
    $_SESSION['passwd']=$_POST['passwd'];
    $_SESSION['login']=$_POST['login'];
    //////////////////
include "menu_text.php";
	//////////////////
	}
        else
        {
        echo "<center><form action=\"\" method=\"post\" name=\"reg\">
<table style=\"width:400px; height:50px;border:1px;\" align=\"center\">
<tr><td colspan=\"2\" style=\"text-align:center\">Авторизация</td></tr>
<tr><td>Login:</td><td><input type=\"text\" name=\"login\"></td></tr>
<tr><td>Password:</td><td><input type=\"password\" name=\"passwd\"></td></tr>
<tr><Td colspan=\"2\"><input type=\"submit\" name=\"reg\" value=\"Вход\"></td></tr>
</table>
</form></center>";
        }
}
if (isset($_SESSION['login']) and !isset($_POST['reg']))
{
    $query="SELECT * FROM `access` WHERE login='".$_SESSION['login']."' LIMIT 1";
    $result = mysql_query($query,$dbc);
    $row=mysql_fetch_array($result);
    if (md5($_SESSION['passwd'])==$row['parol'] and $_SESSION['login']==$row['login'])
    {
		
    //////////////////
include "menu_text.php";
	//////////////////
	}
}

if (!isset($_SESSION['login']) and !isset($_POST['reg']))
{
echo "<center><form action=\"\" method=\"post\" name=\"reg\">
<table style=\"width:400px; height:50px;border:1px;\" align=\"center\">
<tr><td colspan=\"2\" style=\"text-align:center\">Авторизация</td></tr>
<tr><td>Login:</td><td><input type=\"text\" name=\"login\"></td></tr>
<tr><td>Password:</td><td><input type=\"password\" name=\"passwd\"></td></tr>
<tr><Td colspan=\"2\"><input type=\"submit\" name=\"reg\" value=\"Вход\"></td></tr>
</table>
</form></center>";
}
?>

Мое, этому коду 2 года )
Веселая система авторизации.
Разумеется я так уже не пишу ;)

topilnik, 12 Марта 2011

Комментарии (6)

Говнокод: по колено в коде.