/[drupal]/contributions/modules/biblio/biblio.install
ViewVC logotype

Diff of /contributions/modules/biblio/biblio.install

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.30.2.33, Mon Jun 16 02:09:04 2008 UTC revision 1.30.2.34, Tue Jun 17 03:04:35 2008 UTC
# Line 119  function biblio_enable() { Line 119  function biblio_enable() {
119        'relations' => 1,        'relations' => 1,
120        'tags' => 0,        'tags' => 0,
121        'multiple' => 1,        'multiple' => 1,
122        'required' => 1,        'required' => 0,
123        'weight' => 0,        'weight' => 0,
124        'module' => 'biblio',        'module' => 'biblio',
125      );      );
# Line 889  function biblio_reset_types(){ Line 889  function biblio_reset_types(){
889    
890  function _add_db_field_data(&$result)  function _add_db_field_data(&$result)
891  {  {
892    $fields_data[] = array(1,'biblio_contributors','contrib_widget',60,255,1,1);    $fields_data[] = array(1,'biblio_contributors','contrib_widget',60,255);
893    $fields_data[] = array(5,'biblio_secondary_title','textfield',60,255,0,0);    $fields_data[] = array(5,'biblio_secondary_title','textfield',60,255);
894    $fields_data[] = array(6,'biblio_tertiary_title','textfield',60,255,0,0);    $fields_data[] = array(6,'biblio_tertiary_title','textfield',60,255);
895    $fields_data[] = array(7,'biblio_accession_number','textfield',24,24,1,0);    $fields_data[] = array(7,'biblio_accession_number','textfield',24,24);
896    $fields_data[] = array(8,'biblio_isbn','textfield',24,24,1,0);    $fields_data[] = array(8,'biblio_isbn','textfield',24,24);
897    $fields_data[] = array(9,'biblio_call_number','textfield',24,24,1,0);    $fields_data[] = array(9,'biblio_call_number','textfield',24,24);
898    $fields_data[] = array(10,'biblio_other_number','textfield',10,24,1,0);    $fields_data[] = array(10,'biblio_other_number','textfield',10,24);
899    $fields_data[] = array(11,'biblio_other_author_affiliations','textfield',60,255,0,0);    $fields_data[] = array(11,'biblio_other_author_affiliations','textfield',60,255);
900    $fields_data[] = array(12,'biblio_publisher','textfield',60,255,0,0);    $fields_data[] = array(12,'biblio_publisher','textfield',60,255);
901    $fields_data[] = array(13,'biblio_place_published','textfield',60,255,0,0);    $fields_data[] = array(13,'biblio_place_published','textfield',60,255);
902    $fields_data[] = array(14,'biblio_year','textfield',4,4,1,1);    $fields_data[] = array(14,'biblio_year','textfield',4,4);
903    $fields_data[] = array(15,'biblio_edition','textfield',60,255,0,0);    $fields_data[] = array(15,'biblio_edition','textfield',60,255);
904    $fields_data[] = array(16,'biblio_volume','textfield',10,10,0,0);    $fields_data[] = array(16,'biblio_volume','textfield',10,10);
905    $fields_data[] = array(17,'biblio_number','textfield',10,10,0,0);    $fields_data[] = array(17,'biblio_number','textfield',10,10);
906    $fields_data[] = array(18,'biblio_pages','textfield',24,128,0,0);    $fields_data[] = array(18,'biblio_pages','textfield',24,128);
907    $fields_data[] = array(19,'biblio_date','textfield',16,16,0,0);    $fields_data[] = array(19,'biblio_date','textfield',16,16);
908    $fields_data[] = array(20,'biblio_lang','textfield',24,24,0,0);    $fields_data[] = array(20,'biblio_lang','textfield',24,24);
909    $fields_data[] = array(21,'biblio_abst_e','textarea',60,65535 ,0,0);    $fields_data[] = array(21,'biblio_abst_e','textarea',60,65535);
910    $fields_data[] = array(22,'biblio_abst_f','textarea',60,65535 ,0,0);    $fields_data[] = array(22,'biblio_abst_f','textarea',60,65535);
911    $fields_data[] = array(23,'biblio_keywords','textfield',60,255,0,0);    $fields_data[] = array(23,'biblio_keywords','textfield',60,255);
912    $fields_data[] = array(24,'biblio_type_of_work','textfield',60,255,0,0);    $fields_data[] = array(24,'biblio_type_of_work','textfield',60,255);
913    $fields_data[] = array(25,'biblio_url','textfield',60,255,0,0);    $fields_data[] = array(25,'biblio_url','textfield',60,255);
914    $fields_data[] = array(26,'biblio_notes','textarea',60,65535 ,0,0);    $fields_data[] = array(26,'biblio_notes','textarea',60,65535);
915    $fields_data[] = array(27,'biblio_issue','textfield',10,10,0,0);    $fields_data[] = array(27,'biblio_issue','textfield',10,10);
916    $fields_data[] = array(28,'biblio_research_notes','textarea',60,65535 ,0,0);    $fields_data[] = array(28,'biblio_research_notes','textarea',60,65535);
917    $fields_data[] = array(29,'biblio_custom1','textarea',60,65535,0,0);    $fields_data[] = array(29,'biblio_custom1','textarea',60,65535);
918    $fields_data[] = array(30,'biblio_custom2','textarea',60,65535,0,0);    $fields_data[] = array(30,'biblio_custom2','textarea',60,65535);
919    $fields_data[] = array(31,'biblio_custom3','textarea',60,65535,0,0);    $fields_data[] = array(31,'biblio_custom3','textarea',60,65535);
920    $fields_data[] = array(32,'biblio_custom4','textarea',60,65535,0,0);    $fields_data[] = array(32,'biblio_custom4','textarea',60,65535);
921    $fields_data[] = array(33,'biblio_custom5','textarea',60,65535,0,0);    $fields_data[] = array(33,'biblio_custom5','textarea',60,65535);
922    $fields_data[] = array(34,'biblio_custom6','textarea',60,65535,0,0);    $fields_data[] = array(34,'biblio_custom6','textarea',60,65535);
923    $fields_data[] = array(35,'biblio_custom7','textarea',60,65535,0,0);    $fields_data[] = array(35,'biblio_custom7','textarea',60,65535);
924    $fields_data[] = array(36,'biblio_number_of_volumes','textfield',10,10,0,0);    $fields_data[] = array(36,'biblio_number_of_volumes','textfield',10,10);
925    $fields_data[] = array(37,'biblio_short_title','textfield',60,255,0,0);    $fields_data[] = array(37,'biblio_short_title','textfield',60,255);
926    $fields_data[] = array(38,'biblio_alternate_title','textfield',60,255,0,0);    $fields_data[] = array(38,'biblio_alternate_title','textfield',60,255);
927    $fields_data[] = array(39,'biblio_translated_title','textfield',60,255,0,0);    $fields_data[] = array(39,'biblio_translated_title','textfield',60,255);
928    $fields_data[] = array(40,'biblio_original_publication','textfield',60,255,0,0);    $fields_data[] = array(40,'biblio_original_publication','textfield',60,255);
929    $fields_data[] = array(41,'biblio_reprint_edition','textfield',120,255,0,0);    $fields_data[] = array(41,'biblio_reprint_edition','textfield',120,255);
930    $fields_data[] = array(42,'biblio_section','textfield',10,10,0,0);    $fields_data[] = array(42,'biblio_section','textfield',10,10);
931    $fields_data[] = array(43,'biblio_citekey','textfield',16,16,0,0);    $fields_data[] = array(43,'biblio_citekey','textfield',16,16);
932    $fields_data[] = array(44,'biblio_coins','textarea',60,65535 ,0,0);    $fields_data[] = array(44,'biblio_coins','textarea',60,65535);
933    $fields_data[] = array(45,'biblio_issn','textfield',24,24,0,0);    $fields_data[] = array(45,'biblio_issn','textfield',24,24);
934    $fields_data[] = array(46,'biblio_doi','textfield',60,255,0,0);    $fields_data[] = array(46,'biblio_doi','textfield',60,255);
935    $fields_data[] = array(47,'biblio_auth_address','textarea',60,65535,0,0);    $fields_data[] = array(47,'biblio_auth_address','textarea',60,65535);
936    $fields_data[] = array(48,'biblio_remote_db_name','textfield',60,255,0,0);    $fields_data[] = array(48,'biblio_remote_db_name','textfield',60,255);
937    $fields_data[] = array(49,'biblio_remote_db_provider','textfield',60,255,0,0);    $fields_data[] = array(49,'biblio_remote_db_provider','textfield',60,255);
938    $fields_data[] = array(50,'biblio_label','textfield',60,255,0,0);    $fields_data[] = array(50,'biblio_label','textfield',60,255);
939    $fields_data[] = array(51,'biblio_access_date','textfield',60,255,0,0);    $fields_data[] = array(51,'biblio_access_date','textfield',60,255);
940    
941    $schema = biblio_schema();    $schema = biblio_schema();
942    $fieldnames = array_keys($schema['biblio_fields']['fields']);    $fieldnames = array_keys($schema['biblio_fields']['fields']);
# Line 1010  function _add_types(&$result){ Line 1010  function _add_types(&$result){
1010             'ftdid' => array('type' => 'int', 'not null' => 1, 'default' => 0, 'disp-width' => '11'),             'ftdid' => array('type' => 'int', 'not null' => 1, 'default' => 0, 'disp-width' => '11'),
1011             ),             ),
1012  */  */
1013      $fields_data[1]  = array(1,1,1,1,0);
1014      $fields_data[5]  = array(0,0,0,12,0);
1015      $fields_data[6]  = array(0,0,0,13,0);
1016      $fields_data[7]  = array(1,0,0,151,0);
1017      $fields_data[8]  = array(1,0,0,150,0);
1018      $fields_data[9]  = array(1,0,0,152,0);
1019      $fields_data[10] = array(1,0,0,153,0);
1020      $fields_data[11] = array(0,0,0,24,0);
1021      $fields_data[12] = array(0,0,0,19,0);
1022      $fields_data[13] = array(0,0,0,20,0);
1023      $fields_data[14] = array(1,1,1,-45,0);
1024      $fields_data[15] = array(0,0,0,15,0);
1025      $fields_data[16] = array(0,0,0,14,0);
1026      $fields_data[17] = array(0,0,0,16,0);
1027      $fields_data[18] = array(0,0,0,17,0);
1028      $fields_data[19] = array(0,0,0,18,0);
1029      $fields_data[20] = array(0,0,0,23,0);
1030      $fields_data[21] = array(0,0,0,155,0);
1031      $fields_data[22] = array(0,0,0,156,0);
1032      $fields_data[23] = array(0,0,0,154,0);
1033      $fields_data[24] = array(0,0,0,22,0);
1034      $fields_data[25] = array(0,0,0,158,0);
1035      $fields_data[26] = array(0,0,0,157,0);
1036      $fields_data[27] = array(0,0,0,15,0);
1037      $fields_data[28] = array(0,0,0,160,0);
1038      $fields_data[29] = array(0,0,0,161,0);
1039      $fields_data[30] = array(0,0,0,162,0);
1040      $fields_data[31] = array(0,0,0,163,0);
1041      $fields_data[32] = array(0,0,0,164,0);
1042      $fields_data[33] = array(0,0,0,165,0);
1043      $fields_data[34] = array(0,0,0,167,0);
1044      $fields_data[35] = array(0,0,0,168,0);
1045      $fields_data[36] = array(0,0,0,15,0);
1046      $fields_data[37] = array(0,0,0,169,0);
1047      $fields_data[38] = array(0,0,0,170,0);
1048      $fields_data[39] = array(0,0,0,170,0);
1049      $fields_data[40] = array(0,0,0,171,0);
1050      $fields_data[41] = array(0,0,0,172,0);
1051      $fields_data[42] = array(0,0,0,15,0);
1052      $fields_data[43] = array(0,0,0,175,0);
1053      $fields_data[44] = array(0,0,0,176,0);
1054      $fields_data[45] = array(0,0,0,150,0);
1055      $fields_data[46] = array(0,0,0,159,0);
1056      $fields_data[47] = array(0,0,0,178,0);
1057      $fields_data[48] = array(0,0,0,176,0);
1058      $fields_data[49] = array(0,0,0,177,0);
1059      $fields_data[50] = array(0,0,0,178,0);
1060      $fields_data[51] = array(0,0,0,179,0);
1061    
1062      $schema = biblio_schema();
1063      $fieldnames = array_keys($schema['biblio_field_type']['fields']);
1064    
1065    
1066    for ($f = 1; $f <=51; $f++ )    for ($f = 1; $f <=51; $f++ )
1067    {    {
1068         db_query("INSERT INTO {biblio_field_type} (tid, fid, ftdid, cust_tdid) VALUES ('0', '$f', $f, $f)");          if (isset($fields_data[$f])){
1069          $values = array(0, $f, $f, $f);
1070          $values = array_merge($values, $fields_data[$f]);
1071          db_query("INSERT INTO {biblio_field_type} (". implode(", ", $fieldnames) . ")
1072                    VALUES (%d, %d, %d, %d, %d, %d, %d, %d, %d)", $values);
1073            }
1074    }    }
1075    for ($f = 1; $f <=51; $f++ )    for ($f = 1; $f <=51; $f++ )
1076    {    {
1077      for ($t = 100; $t <= 130; $t++)      for ($t = 100; $t <= 130; $t++)
1078      {      {
1079         db_query("INSERT INTO {biblio_field_type} (tid, fid, ftdid, cust_tdid) VALUES ('$t', '$f', $f, $f)");            if (isset($fields_data[$f])){
1080                 $values = array($t, $f, $f, $f);
1081                 $values = array_merge($values, $fields_data[$f]);
1082             db_query("INSERT INTO {biblio_field_type} (". implode(", ", $fieldnames) . ")
1083                       VALUES (%d, %d, %d, %d, %d, %d, %d, %d, %d)", $values);
1084              }
1085      }      }
1086    }    }
1087    
1088    $fields_data[] = array(1,'Authors','',1,1,0);    unset($fields_data);
1089    $fields_data[] = array(5,'Secondary Title','',0,12,0);  
1090    $fields_data[] = array(6,'Tertiary Title','',0,13,0);    $fields_data[] = array(1,'Authors','');
1091    $fields_data[] = array(7,'Accession Number','',0,151,0);    $fields_data[] = array(5,'Secondary Title','');
1092    $fields_data[] = array(8,'ISBN Number','',0,150,0);    $fields_data[] = array(6,'Tertiary Title','');
1093    $fields_data[] = array(9,'Call Number','',0,152,0);    $fields_data[] = array(7,'Accession Number','');
1094    $fields_data[] = array(10,'Other Numbers','',0,153,0);    $fields_data[] = array(8,'ISBN Number','');
1095    $fields_data[] = array(11,'Other Author Affiliations','',0,24,0);    $fields_data[] = array(9,'Call Number','');
1096    $fields_data[] = array(12,'Publisher','',0,19,0);    $fields_data[] = array(10,'Other Numbers','');
1097    $fields_data[] = array(13,'Place Published','',0,20,0);    $fields_data[] = array(11,'Other Author Affiliations','');
1098    $fields_data[] = array(14,'Year of Publication','(yyyy)',1,-45,0);    $fields_data[] = array(12,'Publisher','');
1099    $fields_data[] = array(15,'Edition','',0,15,0);    $fields_data[] = array(13,'Place Published','');
1100    $fields_data[] = array(16,'Volume','',0,14,0);    $fields_data[] = array(14,'Year of Publication','(yyyy)');
1101    $fields_data[] = array(17,'Number','',0,16,0);    $fields_data[] = array(15,'Edition','');
1102    $fields_data[] = array(18,'Pagination','',0,17,0);    $fields_data[] = array(16,'Volume','');
1103    $fields_data[] = array(19,'Date Published','(mm/yyyy)',0,18,0);    $fields_data[] = array(17,'Number','');
1104    $fields_data[] = array(20,'Publication Language','',0,23,0);    $fields_data[] = array(18,'Pagination','');
1105    $fields_data[] = array(21,'Abstract','',0,155,0);    $fields_data[] = array(19,'Date Published','(mm/yyyy)');
1106    $fields_data[] = array(22,'French Abstract','',0,156,0);    $fields_data[] = array(20,'Publication Language','');
1107    $fields_data[] = array(23,'Key Words','',0,154,0);    $fields_data[] = array(21,'Abstract','');
1108    $fields_data[] = array(24,'Type of Work','Masters Thesis, PhD Thesis, etc.',0,22,0);    $fields_data[] = array(22,'French Abstract','');
1109    $fields_data[] = array(25,'URL','',0,158,0);    $fields_data[] = array(23,'Key Words','');
1110    $fields_data[] = array(26,'Notes','',0,157,0);    $fields_data[] = array(24,'Type of Work','Masters Thesis, PhD Thesis, etc.');
1111    $fields_data[] = array(27,'Issue','',0,15,0);    $fields_data[] = array(25,'URL','');
1112    $fields_data[] = array(28,'Reseach Notes','',0,160,0);    $fields_data[] = array(26,'Notes','');
1113    $fields_data[] = array(29,'Custom 1','',0,161,0);    $fields_data[] = array(27,'Issue','');
1114    $fields_data[] = array(30,'Custom 2','',0,162,0);    $fields_data[] = array(28,'Reseach Notes','');
1115    $fields_data[] = array(31,'Custom 3','',0,163,0);    $fields_data[] = array(29,'Custom 1','');
1116    $fields_data[] = array(32,'Custom 4','',0,164,0);    $fields_data[] = array(30,'Custom 2','');
1117    $fields_data[] = array(33,'Custom 5','',0,165,0);    $fields_data[] = array(31,'Custom 3','');
1118    $fields_data[] = array(34,'Custom 6','',0,167,0);    $fields_data[] = array(32,'Custom 4','');
1119    $fields_data[] = array(35,'Custom 7','',0,168,0);    $fields_data[] = array(33,'Custom 5','');
1120    $fields_data[] = array(36,'Number of Volumes','',0,15,0);    $fields_data[] = array(34,'Custom 6','');
1121    $fields_data[] = array(37,'Short Title','',0,169,0);    $fields_data[] = array(35,'Custom 7','');
1122    $fields_data[] = array(38,'Alternate Title','',0,170,0);    $fields_data[] = array(36,'Number of Volumes','');
1123    $fields_data[] = array(39,'Translated Title','',0,170,0);    $fields_data[] = array(37,'Short Title','');
1124    $fields_data[] = array(40,'Original Publication','',0,171,0);    $fields_data[] = array(38,'Alternate Title','');
1125    $fields_data[] = array(41,'Reprint Edition','',0,172,0);    $fields_data[] = array(39,'Translated Title','');
1126    $fields_data[] = array(42,'Section','',0,15,0);    $fields_data[] = array(40,'Original Publication','');
1127    $fields_data[] = array(43,'Citation Key','',0,175,0);    $fields_data[] = array(41,'Reprint Edition','');
1128    $fields_data[] = array(44,'COinS Data','This will be automatically generated, only edit if you know what you are doing.',0,176,0);    $fields_data[] = array(42,'Section','');
1129    $fields_data[] = array(45,'ISSN Number','',0,150,0);    $fields_data[] = array(43,'Citation Key','');
1130    $fields_data[] = array(46,'DOI','',0,159,0);    $fields_data[] = array(44,'COinS Data','This will be automatically generated, only edit if you know what you are doing.');
1131    $fields_data[] = array(47,'Author Address','',0,178,0);    $fields_data[] = array(45,'ISSN Number','');
1132    $fields_data[] = array(48,'Remote Database Name','',0,176,0);    $fields_data[] = array(46,'DOI','');
1133    $fields_data[] = array(49,'Remote Database Provider','',0,177,0);    $fields_data[] = array(47,'Author Address','');
1134    $fields_data[] = array(50,'Label','',0,178,0);    $fields_data[] = array(48,'Remote Database Name','');
1135    $fields_data[] = array(51,'Access Date','',0,179,0);    $fields_data[] = array(49,'Remote Database Provider','');
1136      $fields_data[] = array(50,'Label','');
1137      $fields_data[] = array(51,'Access Date','');
1138    
1139    $schema = biblio_schema();    $schema = biblio_schema();
1140    $fieldnames = array_keys($schema['biblio_field_type_data']['fields']);    $fieldnames = array_keys($schema['biblio_field_type_data']['fields']);
# Line 1086  function _add_types(&$result){ Line 1151  function _add_types(&$result){
1151  }  }
1152    
1153  function _add_custom_field_data() {  function _add_custom_field_data() {
1154      $query = "SELECT fid, name, required, weight,visible FROM {biblio_fields} b LEFT JOIN {biblio_field_type_data} bt on b.fid = bt.ftdid;";    $schema = biblio_schema();
1155      $res = db_query($query);    $fieldnames = array_keys($schema['biblio_field_type_data']['fields']);
1156    
1157      $query = "SELECT fid, name FROM {biblio_fields} ";
1158      $res = db_query($query);
1159    while ($row = db_fetch_object($res)){    while ($row = db_fetch_object($res)){
1160      $fieldmap[$row->name] = array(      $fieldmap[$row->name] =  $row->fid;
       'fid' => $row->fid,  
       'required' => $row->required,  
       'weight' => $row->weight,  
       'visible' => $row->visible  
     );  
1161    }    }
1162    
1163    $csv_file = drupal_get_path('module', 'biblio') .'/biblio.field.data.csv';    $csv_file = drupal_get_path('module', 'biblio') .'/biblio.field.data.csv';
# Line 1109  function _add_custom_field_data() { Line 1172  function _add_custom_field_data() {
1172            if ($row[$column] != "~" && !empty($row[1]) && isset($fieldmap[$field_name])) {            if ($row[$column] != "~" && !empty($row[1]) && isset($fieldmap[$field_name])) {
1173              $ftd[0] = variable_get('biblio_last_ftdid', 100); // ftdid              $ftd[0] = variable_get('biblio_last_ftdid', 100); // ftdid
1174              $ftd[1] = $row[$column];                          // title              $ftd[1] = $row[$column];                          // title
1175              $ftd[2] = '';                                     // hint              $ftd[2] = " ";                                     // hint
             $ftd[3] = $fieldmap[$field_name]['required'];     // required  
             $ftd[4] = $fieldmap[$field_name]['weight'];       // weight  
             $ftd[5] = 1;                                      // visibility  
1176              db_query("UPDATE {biblio_field_type}              db_query("UPDATE {biblio_field_type}
1177                        SET ftdid = %d, cust_tdid = %d                        SET ftdid = %d, cust_tdid = %d, visible = %d
1178                        WHERE tid = %d AND fid = %d ", $ftd[0], $ftd[0], $row[1], $fieldmap[$field_name]['fid'] );                        WHERE tid = %d AND fid = %d ", $ftd[0], $ftd[0], 1, $row[1], $fieldmap[$field_name] );
1179              db_query("INSERT INTO {biblio_field_type_data} ('ftdid', 'title', 'hint', 'required', 'weight', 'visible')              db_query("INSERT INTO {biblio_field_type_data} (" . implode(", ", $fieldnames) . ")
1180                        VALUES('" . implode("', '", $ftd) . "')");                        VALUES (%d, '%s', '%s')", $ftd);
1181              variable_set('biblio_last_ftdid', $ftd[0] +1); //increment the field type data id by one.              variable_set('biblio_last_ftdid', $ftd[0] +1); //increment the field type data id by one.
1182            }            }
1183          }          }
Legend:
Removed from v.1.30.2.33  
changed lines
  Added in v.1.30.2.34
  ViewVC Help
Powered by ViewVC 1.1.2