Skip to content

Instantly share code, notes, and snippets.

View crosalot's full-sized avatar

Panudate Vasinwattana crosalot

View GitHub Profile
@crosalot
crosalot / openhelp.mysql.sql
Created November 6, 2011 09:44 — forked from nazt/openhelp.mysql.sql
openhelp.mysql.sql
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS `location` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`level0` varchar(255),
`level1` varchar(255),
`level2` varchar(255),
`level3` varchar(255),
SELECT node.nid AS nid, COUNT(node_node_data_field_tourist_attraction.nid) AS node_node_data_field_tourist_attraction_nid, node_node_data_field_tourist_attraction.type AS node_node_data_field_tourist_attraction_type FROM node node LEFT JOIN content_field_day_plan node_data_field_day_plan ON node.vid = node_data_field_day_plan.vid LEFT JOIN flexifield_items flexifield_items_node_data_field_day_plan ON node_data_field_day_plan.field_day_plan_item_id = flexifield_items_node_data_field_day_plan.item_id LEFT JOIN content_field_tourist_attraction flexifield_items_node_data_field_day_plan_node_data_field_tourist_attraction ON flexifield_items_node_data_field_day_plan.item_id = flexifield_items_node_data_field_day_plan_node_data_field_tourist_attraction.vid LEFT JOIN node node_node_data_field_tourist_attraction ON flexifield_items_node_data_field_day_plan_node_data_field_tourist_attraction.field_tourist_attraction_nid = node_node_data_field_tourist_attraction.nid WHERE node.type in ('travel_log') GROUP BY node_node_d
23
24 var upload = {
25 onloadstart: function (evt) {
26 bar.addClass('uploading');
27 },
28
29 onprogress: function (evt) {
30 var percent = evnt.loaded/evt.total*100;
31 progress.css('width', percent + '%')
32 },
We couldn’t find that file to show.