<commit_before><commit_msg>Set Vimeo to publish. Admin interface to do this is temporarily not available.<commit_after><?php
//use to set values in the database

include_once(dirname(__FILE__) . "/../../config/environment.php");
$mysqli =& $GLOBALS['mysqli_connection'];

$wrap = "\n\n";

/*
$id     = 26; //for WORMS
$fld    = "accesspoint_url";
$value  = "";

$id     = 79;  //public health image library
$fld    = "service_type_id";
$value  = 2;

$id     = 90;  //for Conservation Biology of FW turtles and tortoises
$fld    = "service_type_id";
$value  = 2;

$id     = 89; //for DiArk
$fld    = "accesspoint_url";
$value  = "http://www.goenmr.de/~bham/diark2009_12_15_2nd.xml";
$value  = "http://www.goenmr.de/~bham/diark2009_12_18.xml";

$id     = 68;  //for Dutch Species Catalogue
$fld    = "service_type_id";
$value  = 2;

$id     = 83;  //for MorphBank
$fld    = "service_type_id";
$value  = 2;

$id     = 11;  //for Biolib.cz
$fld    = "service_type_id";
$value  = 2;

$id     = 81;  //for BOLDS
$fld    = "service_type_id";
$value  = 2;

$id     = 63;  //for INOTAXA
$fld    = "service_type_id";
$value  = 2;

$id     = 107;  //for Encyclopedia of Marine Life - Britain and Ireland
$fld    = "service_type_id";
$value  = 2;

$id     = 98;  //Hexacorallians
$fld    = "service_type_id";
$value  = 2;

$id     = 100;  //Conabio
$fld    = "service_type_id";
$value  = 2;

$id     = 108;  //USDA Plants text descriptions
$fld    = "service_type_id";
$value  = 2;

$id     = 93;  //Antarctic Invertebrates
$fld    = "service_type_id";
$value  = 2;

$id     = 111;  //Field Museum Lichen Resource
$fld    = "service_type_id";
$value  = 2;

$id     = 116;  //The Dutch Ascidians Homepage 
$fld    = "service_type_id";
$value  = 2;

$id     = 119;  //Photosynth
$fld    = "service_type_id";
$value  = 2;

$id     = 121;  //Photographic Identification Guide to Larvae at Hydrothermal Vents E.Pacific Resource
$fld    = "service_type_id";
$value  = 2;

$id     = 123;  //AquaMaps
$fld    = "service_type_id";
$value  = 2;

$id     = 106; //for Biodiversity of Tamborine Mountain 
$fld    = "accesspoint_url";
$value  = "http://pandanus.eol.org/public/EOL_resource/kuttner_corrected.xml";

$id     = 123;  //AquaMaps
$fld    = "auto_publish";
$value  = 1;

$id     = 138;  //Afrotropical
$fld    = "service_type_id";
$value  = 2;

$id     = 143;  //Insect Visitors of Illinois Wildflowers 
$fld    = "service_type_id";
$value  = 2;

$id     = 145;  //Natural History Services
$fld    = "service_type_id";
$value  = 2;

$id     = 119;  //Photosynth
$fld    = "auto_publish";
$value  = 1;

$id     = 145;  //Natural History Services
$fld    = "auto_publish";
$value  = 1;

$id     = 168;  //BioImages
$fld    = "service_type_id";
$value  = 2;

$id     = 170;  //SERPENT Media Project
$fld    = "service_type_id";
$value  = 2;

$id     = 171;  //OBIS depth range
$fld    = "service_type_id";
$value  = 2;

$id     = 173;  //CMARZ
$fld    = "service_type_id";
$value  = 2;

$id     = 185;  //Turbellarian database
$fld    = "service_type_id";
$value  = 2;

$id     = 190;  //FishWise Pro
$fld    = "service_type_id";
$value  = 2;

$id     = 201;  //MCZ Harvard
$fld    = "service_type_id";
$value  = 2;

$id     = 33;  //AskNature
$fld    = "service_type_id";
$value  = 2;

$id     = 207; //Sloan-CoML NameLink Project 
$fld    = "resource_status_id";
$value  = 11; //Publish Pending

$id     = 207; //Sloan-CoML NameLink Project 
$fld    = "auto_publish";
$value  = 1; //Publish Pending

$id     = 201; //MCZ
$fld    = "auto_publish";
$value  = 1; 

$id     = 201; //MCZ
$fld    = "resource_status_id";
$value  = 11; //Publish Pending

$id     = 214;  //Vimeo
$fld    = "service_type_id";
$value  = 2;

*/

$id     = 214; //Vimeo
$fld    = "auto_publish";
$value  = 1;

$query="Select resources.$fld, resources.title, resources.id From resources Where resources.id = $id";
$result = $mysqli->query($query);    
while($row=$result->fetch_assoc()){print "$row[$fld] -- $row[title] -- $wrap";}

$query="update resources set $fld = '$value' Where id = $id";
$update = $mysqli->query($query);    

$query="Select resources.$fld, resources.title, resources.id From resources Where resources.id = $id";
$result = $mysqli->query($query);    
while($row=$result->fetch_assoc()){print "$row[$fld] -- $row[title] -- $wrap";}

print "\n\n --end-- \n\n";

?>
{'fraction_non_alphanumeric': 0.17273146015660987, 'fraction_numerical': 0.037770612620912025, 'mean_word_length': 2.7963286713286712, 'pattern_counts': {'":': 0, '<': 4, '<?xml version=': 0, '>': 9, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, 'xml': 3}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '747321', 'n_tokens_mistral': 1960, 'n_tokens_neox': 1762, 'n_words': 425}