andyed

var v1 = {
	"path" : Application.prefs.getValue("extensions.ubiquity.v1instance",""), 
	"debugMode" : true,
	"commandVersion": "0.3.3"
}

const V1MAXRESULTS = 20;
const V1NOPATH = 'Please run v1setinstance to set the path to your server.<br/><em>v1setinstance http://localhost/versionone/</em>';
const V1BRANDBAR = '<center><img src="http://udpates.versionone.com/ubiquity/images/versionone_logo_onblack_30.gif"/></center><br/>';
const V1BSDSTYLELICENSE = 'Copyright (c) 2008, VersionOne, Inc. All rights reserved.'+

andyed

/*

	@author: Andy Edmonds

	@url: http://www.twitter.com/andyed

	@email:andyed@gmail.com

	@title: Bing Site Searcher

andyed

/*
@author: Andy Edmonds
@url: http://www.uxagile.com
@update: http://uxagile.com/kiosk-tab-rotator-jetpack-for-firefox/
@title: Jetpack Kiosk Tab Rotator
@description: For you information radiator screens
@license: MPL
*/

// TODO

andyed

-- data from https://testpilot.mozillalabs.com/testcases/tab-switch-study

CREATE TABLE tabopenclose (rowid MEDIUMINT NOT NULL AUTO_INCREMENT,user int, event_code varchar(20), id int, position int, window int, tab_site_hash int, srp int, tabs int, timestamp bigint, os varchar(128), ffversion varchar(20), PRIMARY KEY (rowid))

LOAD DATA LOCAL INFILE '~/tab_2000_users.csv'
    INTO TABLE tabopenclose 
    FIELDS TERMINATED BY ',' 
    LINES TERMINATED BY '\n' 
    (user, event_code, id, position, window, tab_site_hash, srp, tabs, timestamp, os, ffversion)

andyed

CREATE TABLE vanilla30
(user int, event_code int, tab_position int, tab_window int, ui_method int, tab_site_hash int, num_tabs int, timestamp bigint)


LOAD DATA LOCAL INFILE '~/vanilla_firefox_users_30_percent.csv'
INTO TABLE vanilla30 
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n' 
(user, event_code, tab_position, tab_window, ui_method, tab_site_hash, num_tabs, timestamp);