[virtualcommons-svn] SF.net SVN: virtualcommons:[26] vcweb/trunk/virtualcommons/experiment
Status: Beta
Brought to you by:
alllee
Menu
▾
▴
[virtualcommons-svn] SF.net SVN: virtualcommons:[26] vcweb/trunk/virtualcommons/experiment
|
From: <see...@us...> - 2008-08-06 05:22:17
|
Revision: 26
http://virtualcommons.svn.sourceforge.net/virtualcommons/?rev=26&view=rev
Author: seematalele
Date: 2008-08-06 05:22:25 +0000 (Wed, 06 Aug 2008)
Log Message:
-----------
Added Paths:
-----------
vcweb/trunk/virtualcommons/experiment/survey/
vcweb/trunk/virtualcommons/experiment/survey/survey.info
vcweb/trunk/virtualcommons/experiment/survey/survey.install
vcweb/trunk/virtualcommons/experiment/survey/survey.module
vcweb/trunk/virtualcommons/experiment/survey/survey_questions.sql
Added: vcweb/trunk/virtualcommons/experiment/survey/survey.info
===================================================================
--- vcweb/trunk/virtualcommons/experiment/survey/survey.info (rev 0)
+++ vcweb/trunk/virtualcommons/experiment/survey/survey.info 2008-08-06 05:22:25 UTC (rev 26)
@@ -0,0 +1,5 @@
+; $Id: rules.info 17 2008-07-30 22:56:29Z alllee $
+name = Survey For The Games
+description = Allows student to fill the survey after voting for the rules.
+package=Virtual Commons
+version = "$Rev$"
Added: vcweb/trunk/virtualcommons/experiment/survey/survey.install
===================================================================
--- vcweb/trunk/virtualcommons/experiment/survey/survey.install (rev 0)
+++ vcweb/trunk/virtualcommons/experiment/survey/survey.install 2008-08-06 05:22:25 UTC (rev 26)
@@ -0,0 +1,279 @@
+<?php
+// vim:sts=2:sw=2:filetype=php
+// $Id$
+/**
+ * Implementation of hook_install().
+ */
+function survey_install() {
+ switch ($GLOBALS['db_type']) {
+ case 'mysql':
+ case 'mysqli':
+
+db_query("CREATE TABLE {vc_survey}
+(
+ id int AUTO_INCREMENT,
+ vc_experiment_id int NOT NULL,
+ date_of_creation TIMESTAMP,
+
+ PRIMARY KEY(id),
+
+ FOREIGN KEY(vc_experiment_id) REFERENCES vc_experiment(id)
+ ON DELETE CASCADE
+
+)ENGINE=InnoDB /*!40100 DEFAULT CHARACTER SET UTF8 */");
+
+db_query("CREATE TABLE {vc_survey_questions}
+(
+ id int AUTO_INCREMENT,
+ vc_survey_id int NOT NULL,
+ vc_rules_id int NOT NULL,
+ questions varchar(500) default ' ',
+
+
+ PRIMARY KEY(id),
+
+ FOREIGN KEY(vc_survey_id) REFERENCES vc_survey(id)
+ ON DELETE CASCADE,
+
+ FOREIGN KEY(vc_rules_id) REFERENCES vc_rules(id)
+ ON DELETE CASCADE
+
+)ENGINE=InnoDB /*!40100 DEFAULT CHARACTER SET UTF8 */");
+
+
+db_query("CREATE TABLE {vc_survey_questions_options}
+(
+ id int AUTO_INCREMENT,
+ vc_survey_questions_id int NOT NULL,
+ min_value varchar(100) NOT NULL,
+ max_value varchar(100) NOT NULL,
+
+ PRIMARY KEY(id),
+
+ FOREIGN KEY(vc_survey_questions_id) REFERENCES vc_survey_questions(id)
+ ON DELETE CASCADE
+
+)ENGINE=InnoDB /*!40100 DEFAULT CHARACTER SET UTF8 */");
+
+db_query("CREATE TABLE {vc_survey_response}
+(
+ id int AUTO_INCREMENT,
+ vc_student_id varchar(14) NOT NULL,
+ vc_survey_questions_id int NOT NULL,
+ response varchar(100) NOT NULL,
+
+
+ PRIMARY KEY(id),
+
+ FOREIGN KEY(vc_student_id) REFERENCES vc_student(id)
+ ON DELETE CASCADE,
+
+
+ FOREIGN KEY(vc_survey_questions_id) REFERENCES vc_survey_questions(id)
+ ON DELETE CASCADE
+
+)ENGINE=InnoDB /*!40100 DEFAULT CHARACTER SET UTF8 */");
+
+
+db_query("insert into { vc_survey} (vc_experiment_id) values('1')");
+db_query("insert into { vc_survey} (vc_experiment_id) values('2')");
+db_query("insert into { vc_survey} (vc_experiment_id) values('3')");
+
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,1,'How efficient do you think this rule is for managing the fishing grounds?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,1,'How fair do you think this rule is for managing the fishing grounds? ')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,1,'How much personal freedom do you think this rule allows you in managing the fishing grounds?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,1,'How much do you think this rule would advance your own self-interest as measured by your total earning?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,1,'All things considered how attractive do you find this rule?')");
+
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,2,'How efficient do you think this rule is for managing the fishing grounds?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,2,'How fair do you think this rule is for managing the fishing grounds? ')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,2,'How much personal freedom do you think this rule allows you in managing the fishing grounds?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,2,'How much do you think this rule would advance your own self-interest as measured by your total earning?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,2,'All things considered how attractive do you find this rule?')");
+
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,3,'How efficient do you think this rule is for managing the fishing grounds?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,3,'How fair do you think this rule is for managing the fishing grounds? ')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,3,'How much personal freedom do you think this rule allows you in managing the fishing grounds?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,3,'How much do you think this rule would advance your own self-interest as measured by your total earning?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(1,3,'All things considered how attractive do you find this rule?')");
+
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,4,'How efficient do you think this rule is for managing the forest?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,4,'How fair do you think this rule is for managing the forest? ')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,4,'How much personal freedom do you think this rule allows you in managing the forest?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,4,'How much do you think this rule would advance your own self-interest as measured by your total earning?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,4,'All things considered how attractive do you find this rule?')");
+
+
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,5,'How efficient do you think this rule is for managing the forest?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,5,'How fair do you think this rule is for managing the forest? ')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,5,'How much personal freedom do you think this rule allows you in managing the forest?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,5,'How much do you think this rule would advance your own self-interest as measured by your total earning?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,5,'All things considered how attractive do you find this rule?')");
+
+
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,6,'How efficient do you think this rule is for managing the forest?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,6,'How fair do you think this rule is for managing the forest? ')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,6,'How much personal freedom do you think this rule allows you in managing the forest?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,6,'How much do you think this rule would advance your own self-interest as measured by your total earning?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(2,6,'All things considered how attractive do you find this rule?')");
+
+
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,7,'How efficient do you think this rule is for managing the irrigation system?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,7,'How fair do you think this rule is for managing the irrigation system? ')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,7,'How much personal freedom do you think this rule allows you in managing the irrigation system?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,7,'How much do you think this rule would advance your own self-interest as measured by your total earning?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,7,'All things considered how attractive do you find this rule?')");
+
+
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,8,'How efficient do you think this rule is for managing the irrigation system?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,8,'How fair do you think this rule is for managing the irrigation system? ')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,8,'How much personal freedom do you think this rule allows you in managing the irrigation system?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,8,'How much do you think this rule would advance your own self-interest as measured by your total earning?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,8,'All things considered how attractive do you find this rule?')");
+
+
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,9,'How efficient do you think this rule is for managing the irrigation system?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,9,'How fair do you think this rule is for managing the irrigation system? ')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,9,'How much personal freedom do you think this rule allows you in managing the irrigation system?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,9,'How much do you think this rule would advance your own self-interest as measured by your total earning?')");
+db_query("insert into { vc_survey_questions} (vc_survey_id,vc_rules_id,questions) values(3,9,'All things considered how attractive do you find this rule?')");
+
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(1,'not at all efficient','very efficient')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(2,'not at all fair','very fair')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(3,'no freedom at all','complete freedom')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(4,'not at all','very much')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(5,'not attractive at all','Very attractive')");
+
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(6,'not at all efficient','very efficient')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(7,'not at all fair','very fair')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(8,'no freedom at all','complete freedom')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(9,'not at all','very much')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(10,'not attractive at all','Very attractive')");
+
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(11,'not at all efficient','very efficient')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(12,'not at all fair','very fair')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(13,'no freedom at all','complete freedom')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(14,'not at all','very much')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(15,'not attractive at all','Very attractive')");
+
+
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(16,'not at all efficient','very efficient')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(17,'not at all fair','very fair')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(18,'no freedom at all','complete freedom')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(19,'not at all','very much')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(20,'not attractive at all','Very attractive')");
+
+
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(21,'not at all efficient','very efficient')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values} (22,'not at all fair','very fair')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(23,'no freedom at all','complete freedom')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(24,'not at all','very much')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(25,'not attractive at all','Very attractive')");
+
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(26,'not at all efficient','very efficient')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(27,'not at all fair','very fair')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(28,'no freedom at all','complete freedom')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(29,'not at all','very much')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(30,'not attractive at all','Very attractive')");
+
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(31,'not at all efficient','very efficient')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(32,'not at all fair','very fair')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(33,'no freedom at all','complete freedom')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(34,'not at all','very much')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(35,'not attractive at all','Very attractive')");
+
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(36,'not at all efficient','very efficient')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(37,'not at all fair','very fair')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(38,'no freedom at all','complete freedom')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(39,'not at all','very much')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(40,'not attractive at all','Very attractive')");
+
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(41,'not at all efficient','very efficient')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(42,'not at all fair','very fair')");
+db_query("insert into { vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(43,'no freedom at all','complete freedom')");
+db_query("insert into {vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(44,'not at all','very much')");
+db_query("insert into {vc_survey_questions_options} (vc_survey_questions_id,min_value,max_value) values(45,'not attractive at all','Very attractive')");
+
+
+ $flag=TRUE;
+ break;
+ case 'pgsql':
+
+
+db_query("CREATE TABLE {vc_survey}
+(
+ id int AUTO_INCREMENT,
+ vc_experiments_id int NOT NULL,
+ date_of_creation DATE,
+
+ PRIMARY KEY(id),
+
+ FOREIGN KEY(vc_experiments_id) REFERENCES vc_experiments(id)
+ ON DELETE CASCADE
+
+)ENGINE=InnoDB /*!40100 DEFAULT CHARACTER SET UTF8 */");
+
+db_query("CREATE TABLE {vc_survey_questions}
+(
+ id int NOT NULL AUTO_INCREMENT,
+ vc_survey_id int NOT NULL,
+ vc_rules_id int NOT NULL,
+ questions varchar(500) default ' ',
+
+
+ PRIMARY KEY(id),
+
+ FOREIGN KEY(vc_survey_id) REFERENCES vc_survey(id)
+ ON DELETE CASCADE,
+
+ FOREIGN KEY(vc_rules_id) REFERENCES vc_rules(id)
+ ON DELETE CASCADE
+
+)ENGINE=InnoDB /*!40100 DEFAULT CHARACTER SET UTF8 */");
+
+
+db_query("CREATE TABLE {vc_survey_questions_options}
+(
+ id int NOT NULL AUTO_INCREMENT,
+ vc_survey_questions_id int NOT NULL,
+ min_value varchar(100) NOT NULL,
+ max_value varchar(100) NOT NULL,
+
+
+ PRIMARY KEY(id),
+
+ FOREIGN KEY(vc_survey_questions_id) REFERENCES vc_survey_questions(id)
+ ON DELETE CASCADE
+
+)ENGINE=InnoDB /*!40100 DEFAULT CHARACTER SET UTF8 */");
+
+
+ $flag=TRUE;
+ break;
+ default:
+ drupal_set_message(t('Unsupported Database'));
+ }
+ if($flag)
+ {
+ drupal_set_message(t('Survey table is successfully created.'));
+ }
+ else
+ {
+ drupal_set_message(t('Survey table is NOT successfully created.'),'error');
+ }
+}
+
+/**
+ * Implementation of hook_uninstall().
+ */
+function survey_uninstall()
+{
+ db_query("DROP TABLE {vc_survey_response}");
+ db_query("DROP TABLE {vc_survey_questions_options}");
+ db_query("DROP TABLE {vc_survey_questions}");
+ db_query("DROP TABLE {vc_survey}");
+
+
+ drupal_set_message(t('Survey table is successfully deleted from the database.'));
+}
+
Added: vcweb/trunk/virtualcommons/experiment/survey/survey.module
===================================================================
--- vcweb/trunk/virtualcommons/experiment/survey/survey.module (rev 0)
+++ vcweb/trunk/virtualcommons/experiment/survey/survey.module 2008-08-06 05:22:25 UTC (rev 26)
@@ -0,0 +1,129 @@
+<?php
+
+
+/*function rules_load() {
+ static $loaded = FALSE;
+
+ if (!$loaded) {
+ $path = drupal_get_path('module', 'forestry_stage1');
+ drupal_add_css($path .'/form.css');
+ $loaded = TRUE;
+ }
+}*/
+
+function survey_menu($may_cache) {
+ $items = array();
+ if ($may_cache) {
+
+$items[]=array( 'path' => 'survey',
+ 'title' => t('Survey'),
+ 'callback' => 'survey',
+ 'type'=>MENU_CALLBACK,
+ 'access' => TRUE//user_access('Only Teachers')
+ );
+
+ }
+/*else
+{
+rules_load();
+}*/
+
+ return $items;
+}
+
+function survey() {
+
+
+ // Return the HTML generated from the $form data structure.
+$output='Till we determine the results of the voting, please fill out a following survey';
+ $output .= drupal_get_form('survey_form');
+ return $output;
+}
+
+
+function survey_form()
+{
+$form['#id']='survey_form';
+$form['#tree'] = TRUE;
+$stud_id=$_SESSION['student_id'];
+
+//$group=Session::get('group');
+
+
+//$exp_id=$group->getExperimentId();
+$survey=new Survey();
+$exp_id=2;
+$survey_data=$survey->getSurveyQuestions($exp_id);
+$_SESSION['survey_data']=$survey_data;
+$header[]='Survey Questions';
+foreach($survey_data as $rule=>$Q_array)
+{
+ $form['resource'][$rule]=array(
+ '#type'=>'fieldset',
+ '#title'=>t('<b>Rule '. $rule. '</b>'),
+ );
+
+ foreach($Q_array as $Q=>$ans)
+ {
+
+ $form['resource'][$rule][$Q]['option']=array(
+ '#type'=>'radios',
+ '#title'=>t('<b>Q'. ++$Q_cnt . '. '. $Q.'</b>'),
+ '#options'=>$ans,
+ '#required'=>TRUE
+
+ );
+ }
+}
+
+$form['submit'] = array(
+ '#type' => 'submit',
+ '#value' => t('Submit!!!'),
+
+ );
+
+return $form;
+}
+
+
+function survey_form_submit($form,$form_values)
+{
+ $stud_id=$_SESSION['student_id'];
+ $group=Session::get('group');
+
+ $survey=new Survey();
+// $rules->saveStudentSurvey($stud_id,$ans);
+ $survey_data=$_SESSION['survey_data'];
+ $stage_id=$group->getCurrentStageId();
+ $i=0;
+ foreach($survey_data as $rule=>$Q_array)
+ {
+ foreach($Q_array as $Q=>$ans)
+ {
+ // drupal_set_message(t('Question is: '. $Q . 'answers are:'. $ans[$form_values['resource'][$rule][$Q]['option']]));
+ $survey->saveSurveyResponse($stage_id,$stud_id,$rule,$Q,$ans[$form_values['resource'][$rule][$Q]['option']]);
+ $i++;
+
+ }
+ }
+
+
+ /*if($exp_name=='Forestry Game')
+ {
+ return 'forestry';
+ }
+
+ else if($exp_name=='Fishery Game')
+ {
+ return 'fishery';
+ }
+
+ else if($exp_name=='Water Irrigation Game')
+ {
+ return 'water';
+
+ }*/
+return 'survey';
+
+}
+
Added: vcweb/trunk/virtualcommons/experiment/survey/survey_questions.sql
===================================================================
--- vcweb/trunk/virtualcommons/experiment/survey/survey_questions.sql (rev 0)
+++ vcweb/trunk/virtualcommons/experiment/survey/survey_questions.sql 2008-08-06 05:22:25 UTC (rev 26)
@@ -0,0 +1,119 @@
+insert into vc_survey(vc_experiment_id) values('1');
+insert into vc_survey(vc_experiment_id) values('2');
+insert into vc_survey(vc_experiment_id) values('3');
+
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,1,'How efficient do you think this rule is for managing the fishing grounds?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,1,'How fair do you think this rule is for managing the fishing grounds? ');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,1,'How much personal freedom do you think this rule allows you in managing the fishing grounds?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,1,'How much do you think this rule would advance your own self-interest as measured by your total earning?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,1,'All things considered how attractive do you find this rule?');
+
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,2,'How efficient do you think this rule is for managing the fishing grounds?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,2,'How fair do you think this rule is for managing the fishing grounds? ');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,2,'How much personal freedom do you think this rule allows you in managing the fishing grounds?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,2,'How much do you think this rule would advance your own self-interest as measured by your total earning?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,2,'All things considered how attractive do you find this rule?');
+
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,3,'How efficient do you think this rule is for managing the fishing grounds?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,3,'How fair do you think this rule is for managing the fishing grounds? ');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,3,'How much personal freedom do you think this rule allows you in managing the fishing grounds?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,3,'How much do you think this rule would advance your own self-interest as measured by your total earning?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(1,3,'All things considered how attractive do you find this rule?');
+
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,4,'How efficient do you think this rule is for managing the forest?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,4,'How fair do you think this rule is for managing the forest? ');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,4,'How much personal freedom do you think this rule allows you in managing the forest?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,4,'How much do you think this rule would advance your own self-interest as measured by your total earning?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,4,'All things considered how attractive do you find this rule?');
+
+
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,5,'How efficient do you think this rule is for managing the forest?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,5,'How fair do you think this rule is for managing the forest? ');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,5,'How much personal freedom do you think this rule allows you in managing the forest?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,5,'How much do you think this rule would advance your own self-interest as measured by your total earning?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,5,'All things considered how attractive do you find this rule?');
+
+
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,6,'How efficient do you think this rule is for managing the fishing grounds?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,6,'How fair do you think this rule is for managing the fishing grounds? ');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,6,'How much personal freedom do you think this rule allows you in managing the fishing grounds?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,6,'How much do you think this rule would advance your own self-interest as measured by your total earning?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(2,6,'All things considered how attractive do you find this rule?');
+
+
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,7,'How efficient do you think this rule is for managing the irrigation system?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,7,'How fair do you think this rule is for managing the irrigation system? ');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,7,'How much personal freedom do you think this rule allows you in managing the irrigation system?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,7,'How much do you think this rule would advance your own self-interest as measured by your total earning?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,7,'All things considered how attractive do you find this rule?');
+
+
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,8,'How efficient do you think this rule is for managing the irrigation system?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,8,'How fair do you think this rule is for managing the irrigation system? ');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,8,'How much personal freedom do you think this rule allows you in managing the irrigation system?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,8,'How much do you think this rule would advance your own self-interest as measured by your total earning?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,8,'All things considered how attractive do you find this rule?');
+
+
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,9,'How efficient do you think this rule is for managing the irrigation system?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,9,'How fair do you think this rule is for managing the irrigation system? ');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,9,'How much personal freedom do you think this rule allows you in managing the irrigation system?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,9,'How much do you think this rule would advance your own self-interest as measured by your total earning?');
+insert into vc_survey_questions(vc_survey_id,vc_rules_id,questions) values(3,9,'All things considered how attractive do you find this rule?');
+
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(1,'not at all efficient','very efficient');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(2,'not at all fair','very fair');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(3,'no freedom at all','complete freedom');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(4,'not at all','very much');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(5,'not attractive at all','Very attractive');
+
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(6,'not at all efficient','very efficient');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(7,'not at all fair','very fair');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(8,'no freedom at all','complete freedom');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(9,'not at all','very much');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(10,'not attractive at all','Very attractive');
+
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(11,'not at all efficient','very efficient');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(12,'not at all fair','very fair');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(13,'no freedom at all','complete freedom');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(14,'not at all','very much');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(15,'not attractive at all','Very attractive');
+
+
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(16,'not at all efficient','very efficient');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(17,'not at all fair','very fair');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(18,'no freedom at all','complete freedom');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(19,'not at all','very much');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(20,'not attractive at all','Very attractive');
+
+
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(21,'not at all efficient','very efficient');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(22,'not at all fair','very fair');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(23,'no freedom at all','complete freedom');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(24,'not at all','very much');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(25,'not attractive at all','Very attractive');
+
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(26,'not at all efficient','very efficient');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(27,'not at all fair','very fair');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(28,'no freedom at all','complete freedom');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(29,'not at all','very much');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(30,'not attractive at all','Very attractive');
+
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(31,'not at all efficient','very efficient');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(32,'not at all fair','very fair');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(33,'no freedom at all','complete freedom');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(34,'not at all','very much');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(35,'not attractive at all','Very attractive');
+
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(36,'not at all efficient','very efficient');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(37,'not at all fair','very fair');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(38,'no freedom at all','complete freedom');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(39,'not at all','very much');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(40,'not attractive at all','Very attractive');
+
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(41,'not at all efficient','very efficient');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(42,'not at all fair','very fair');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(43,'no freedom at all','complete freedom');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(44,'not at all','very much');
+insert into vc_survey_questions_options(vc_survey_questions_id,min_value,max_value) values(45,'not attractive at all','Very attractive');
+
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
