r********y
发帖数: 2540 | 1 想哭大妈觉得自动下载个头像就了不得了
威胁网友“非常危险”
被打脸肿得不敢聊黑客了
想哭大妈来看看这段SQL
你能复制一模一样跟贴贴上来算你赢
你不是懂1=1吗，这难不倒你吧
SELECT DATEADD(day,-1,pxd_upd_date),
pbd_prod_code,
psd_stk_qty+psd_booked_qty,
IFNULL(CONCAT(CONCAT(TRIM(TRAILING ' ' FROM P.pbd_prod_name),
CASE LENGTH(CONVERT(VARCHAR(6), P.pbd_prod_ptr))
WHEN '5' THEN
CASE
WHEN CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6),P.pbd_prod_ptr),3)) <=
700
THEN
(SELECT TRIM(TRAILING ' ' FROM A.aca_cu_name)
FROM admin.sffaca_details A
WHERE A.aca_cu_no=CONCAT('PTX0', SUBSTRING(CONVERT(VARCHAR(6), P.pbd_prod_
ptr),1,2))
AND A.aca_addr_no=CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6), P.pbd_
prod_ptr),3)))
ELSE
(SELECT TRIM(TRAILING ' ' FROM aca_txt_l1)
FROM admin.sffaca_other C
WHERE C.aca_cu_no=CONCAT('PTX0', SUBSTRING(CONVERT(VARCHAR(6), P.pbd_prod_
ptr),1,2))
AND C.aca_addr_no=CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6), P.pbd_
prod_ptr),3)))
END
WHEN '6' THEN
CASE
WHEN CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6),P.pbd_prod_ptr),4)) <=
700
THEN
(SELECT TRIM(TRAILING ' ' FROM A.aca_cu_name)
FROM admin.sffaca_details A
WHERE A.aca_cu_no=CONCAT('PTX', SUBSTRING(CONVERT(VARCHAR(6), P.pbd_prod_ptr
),1,3))
AND A.aca_addr_no=CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6), P.pbd_
prod_ptr),4)))
ELSE
(SELECT TRIM(TRAILING ' ' FROM aca_txt_l1)
FROM admin.sffaca_other C
WHERE C.aca_cu_no=CONCAT('PTX', SUBSTRING(CONVERT(VARCHAR(6), P.pbd_prod_ptr
),1,3))
AND C.aca_addr_no=CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6), P.pbd_
prod_ptr),4)))
END
END),
CONCAT(' ', CASE P.pbd_prod_unit WHEN 'Single' THEN '' ELSE P.pbd_prod_unit
END)),
CONCAT(TRIM(TRAILING ' ' FROM P.pbd_prod_name),
CONCAT(' ', CASE P.pbd_prod_unit WHEN 'Single' THEN '' ELSE P.pbd_prod_unit
END))) AS Description,
(SELECT TOP 1 DATEADD(day,-1, A.bsj_putaway_date)
FROM admin.sffbsj A
WHERE A.bsj_prod_ptr=P.pbd_prod_ptr
AND A.bsj_type=1
ORDER BY A.bsj_move_date DESC, A.bsj_move_time DESC),
pbd_prod_pack,
pbd_vat_code,
pbd_split_price,
pbd_trade_price,
pbd_retail_price,
pbd_layer_qty,
pbd_pallet_size,
pxd_ean_code,
pbd_maj_grp,
pbd_min_grp,
pxd_flags_1,
pxd_flags_2,
pbd_prod_ptr,
CASE pbd_prod_unit WHEN 'Single' THEN '' ELSE pbd_prod_unit END,
psd_po_qty from admin.sffpbd P
LEFT JOIN admin.sffpsd S
ON P.pbd_prod_ptr=S.psd_prod_ptr
LEFT JOIN admin.sffpxd_details D
ON P.pbd_prod_ptr=D.pxd_prod_ptr
WHERE psd_stk_qty+psd_booked_qty+psd_po_qty>0
ORDER BY pbd_maj_grp ASC,
pbd_min_grp ASC,
pbd_prod_name ASC | r********y
发帖数: 2540 | 2 SELECT DATEADD(day,-1,pxd_upd_date),
pbd_prod_code,
psd_stk_qty+psd_booked_qty,
IFNULL(CONCAT(CONCAT(TRIM(TRAILING ' ' FROM P.pbd_prod_name),
CASE LENGTH(CONVERT(VARCHAR(6), P.pbd_prod_ptr))
WHEN '5' THEN
CASE
WHEN CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6),P.pbd_prod_ptr),3)) <=
700
THEN
(SELECT TRIM(TRAILING ' ' FROM A.aca_cu_name)
FROM admin.sffaca_details A
WHERE A.aca_cu_no=CONCAT('PTX0', SUBSTRING(CONVERT(VARCHAR(6), P.pbd_prod_
ptr),1,2))
AND A.aca_addr_no=CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6), P.pbd_
prod_ptr),3)))
ELSE
(SELECT TRIM(TRAILING ' ' FROM aca_txt_l1)
FROM admin.sffaca_other C
WHERE C.aca_cu_no=CONCAT('PTX0', SUBSTRING(CONVERT(VARCHAR(6), P.pbd_prod_
ptr),1,2))
AND C.aca_addr_no=CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6), P.pbd_
prod_ptr),3)))
END
WHEN '6' THEN
CASE
WHEN CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6),P.pbd_prod_ptr),4)) <=
700
THEN
(SELECT TRIM(TRAILING ' ' FROM A.aca_cu_name)
FROM admin.sffaca_details A
WHERE A.aca_cu_no=CONCAT('PTX', SUBSTRING(CONVERT(VARCHAR(6), P.pbd_prod_ptr
),1,3))
AND A.aca_addr_no=CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6), P.pbd_
prod_ptr),4)))
ELSE
(SELECT TRIM(TRAILING ' ' FROM aca_txt_l1)
FROM admin.sffaca_other C
WHERE C.aca_cu_no=CONCAT('PTX', SUBSTRING(CONVERT(VARCHAR(6), P.pbd_prod_ptr
),1,3))
AND C.aca_addr_no=CONVERT(SQL_INTEGER,SUBSTRING(CONVERT(VARCHAR(6), P.pbd_
prod_ptr),4)))
END
END),
CONCAT(' ', CASE P.pbd_prod_unit WHEN 'Single' THEN '' ELSE P.pbd_prod_unit
END)),
CONCAT(TRIM(TRAILING ' ' FROM P.pbd_prod_name),
CONCAT(' ', CASE P.pbd_prod_unit WHEN 'Single' THEN '' ELSE P.pbd_prod_unit
END))) AS Description,
(SELECT TOP 1 DATEADD(day,-1, A.bsj_putaway_date)
FROM admin.sffbsj A
WHERE A.bsj_prod_ptr=P.pbd_prod_ptr
AND A.bsj_type=1
ORDER BY A.bsj_move_date DESC, A.bsj_move_time DESC),
pbd_prod_pack,
pbd_vat_code,
pbd_split_price,
pbd_trade_price,
pbd_retail_price,
pbd_layer_qty,
pbd_pallet_size,
pxd_ean_code,
pbd_maj_grp,
pbd_min_grp,
pxd_flags_1,
pxd_flags_2,
pbd_prod_ptr,
CASE pbd_prod_unit WHEN 'Single' THEN '' ELSE pbd_prod_unit END,
psd_po_qty from admin.sffpbd P
LEFT JOIN admin.sffpsd S
ON P.pbd_prod_ptr=S.psd_prod_ptr
LEFT JOIN admin.sffpxd_details D
ON P.pbd_prod_ptr=D.pxd_prod_ptr
WHERE psd_stk_qty+psd_booked_qty+psd_po_qty>0
ORDER BY pbd_maj_grp ASC,
pbd_min_grp ASC,
pbd_prod_name ASC | r********y
发帖数: 2540 | | f********h
发帖数: 1 | | r********y
发帖数: 2540 | | R**********6
发帖数: 4 | 6 Which SQL dialect is this? It seems neither Microsoft, nor Oracle. | r********y
发帖数: 2540 | 7 try copy and paste
it doesn't matter what dialect it is.
【在 R**********6 的大作中提到】
: Which SQL dialect is this? It seems neither Microsoft, nor Oracle.
| R**********6
发帖数: 4 | 8 without knowing which dialect, without the underlying tables, functions, it'
s just text.
【在 r********y 的大作中提到】
: try copy and paste
: it doesn't matter what dialect it is.
| F**0
发帖数: 5004 | 9 Sorry, you have been blocked
You are unable to access mitbbs.com
厉害啊 | r********y
发帖数: 2540 | 10 why dont you just try copy and past, it is just text
it'
【在 R**********6 的大作中提到】
: without knowing which dialect, without the underlying tables, functions, it'
: s just text.
| R**********6
发帖数: 4 | 11 I copied to notepad, no problem. Without knowing what it does nor how it
does, it's just text.
【在 r********y 的大作中提到】
: why dont you just try copy and past, it is just text
:
: it'
| r********y
发帖数: 2540 | 12 copy and paste to this thread
as a reply post
you dont understand zhinese or what?
【在 R**********6 的大作中提到】
: I copied to notepad, no problem. Without knowing what it does nor how it
: does, it's just text.
| R**********6
发帖数: 4 | 13 我不会把网上下载的 SCRIPT 随意 PASTE. MITBBS 如果运行你的 SCRIPT，那将是一
个安全漏洞， 需要修补。
【在 r********y 的大作中提到】
: copy and paste to this thread
: as a reply post
: you dont understand zhinese or what?
| r********y
发帖数: 2540 | 14 dont overthink
just paste to this thread and see what happen
and tell us what do you think about what happen
if you get blocked by the system, tell us why
【在 R**********6 的大作中提到】
: 我不会把网上下载的 SCRIPT 随意 PASTE. MITBBS 如果运行你的 SCRIPT，那将是一
: 个安全漏洞， 需要修补。
| W********y
发帖数: 1 | 15 水逼连下载头像，突然就不由你控制了，就好比你点了不该点的邮件附件一样一样的效果
这点简单的基础只是都听不懂
这你麻痹的又从网上抄一段过来秀逗啊
看，还说得像真的一样哦，煞有介事的样子：
“我不会把网上下载的 SCRIPT 随意 PASTE. MITBBS 如果运行你的 SCRIPT，那将是一
个安全漏洞， 需要修补。” | r********y
发帖数: 2540 | 16 快来围观想哭大妈的智商
想哭大妈连复制文本都不会，笑死人了
效果
是一
【在 W********y 的大作中提到】
: 水逼连下载头像，突然就不由你控制了，就好比你点了不该点的邮件附件一样一样的效果
: 这点简单的基础只是都听不懂
: 这你麻痹的又从网上抄一段过来秀逗啊
: 看，还说得像真的一样哦，煞有介事的样子：
: “我不会把网上下载的 SCRIPT 随意 PASTE. MITBBS 如果运行你的 SCRIPT，那将是一
: 个安全漏洞， 需要修补。”
| W********y
发帖数: 1 | 17 水逼啊，你今天咬不动，明天咬不动，这辈子都无望
不关你网上早什么脚本，用什么工具，你这辈子+下辈子都无法咬动买提数据库
我就这么量死你，莫在老子面前装神弄鬼的 | R**********6
发帖数: 4 | 18 不知道， 我读 SQL SCRIPT， 最不喜欢的就是用A， B， C aliasing tables， 尤其
是在一段SCIRPT 中， 一个 A 可能是 两个甚至更多的 TABLES, 或者， 一个TABLE有
两个甚至更多的 ALIASes。 读着头大
【在 r********y 的大作中提到】
: dont overthink
: just paste to this thread and see what happen
: and tell us what do you think about what happen
: if you get blocked by the system, tell us why
| t*******e
发帖数: 723 | | t*******e
发帖数: 723 | 20 LOL
Mr. Xing is going to die |
|
