DrupalBin
Submit Code
About
Recent Posts
Code
Fix for Fix for Code
Fix for Code
Code
Node type whitelist
an axe coach accessories
coach purses married
Fix for de las ghd alturas
de las ghd alturas
Code
more
User login
Log in using OpenID:
What is OpenID?
Username:
*
Password:
*
Log in using OpenID
Cancel OpenID login
Create new account
Request new password
Tags
CCK
drupal
fapi
jquery
menu
module
php
simpletest
taxonomy
test
theme
views
more tags
Home
›
KITTENS ZOMG
Fix for KITTENS ZOMG
View
Fix
Fixes are not saved to the database until you submit.
Summary:
Tags:
Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Show summary in full view
SELECT SUM(p.price) - COALESCE((SELECT sum(lid.discount) FROM {order_line_item_discounts} lid INNER JOIN {uc_orders} uopd ON uopd.order_id = lid.order_id AND uopd.order_status = "completed" WHERE p.nid = lid.nid ), 0) as total, (SUM(p.price) - COALESCE((SELECT sum(lid2.discount) FROM {order_line_item_discounts} lid2 INNER JOIN {uc_orders} uopd2 ON uopd2.order_id = lid2.order_id AND uopd2.order_status = "completed" WHERE p.nid = lid2.nid), 0)) / (SELECT count(1) FROM {uc_order_products} op2 INNER JOIN {uc_orders} uo2 WHERE op2.order_id = uo2.order_id AND uo2.order_status = 'completed' AND op2.nid = p.nid) as average, p.nid, p.title, p.price FROM {uc_order_products} p INNER JOIN {uc_orders} o ON o.order_id = p.order_id WHERE o.order_status = 'completed' GROUP BY p.nid ORDER BY p.title DESC LIMIT 1000
Syntax highlighting mode:
ActionScript
ColdFusion
Diff
Drupal 5
Drupal 6
HTML
INI
Javascript
MySQL
PHP
Python
robots.txt
SQL
Text
Select the syntax highlighting mode to use.
See Also:
Order
Title:
URL:
-1
0
1
Title:
URL:
-1
0
1
Any links you'd like to have associated with the post (Drupal.org issue, Wikipedia article, etc).
File attachments
Changes made to the attachments are not permanent until you save this post. The first "listed" file will be included in RSS feeds.
Attach new file:
The maximum upload size is
1 MB
. Only files with the following extensions may be uploaded:
jpg jpeg gif png txt doc xls pdf ppt pps odt ods odp phps
.
