private void DownloadYoutube(string value)
{
string youtubeUrl = YoutubeThumbnail.GetImageUrlFromUrl(value, (YoutubeThumbnail.YoutubeImageType)m_dropdown.value);
SetText(string.Format("[]({1}) \n{1}", m_altText.text, value, youtubeUrl));
StartCoroutine(StartDownloadPreview(youtubeUrl));
}
protected void Load_Images()
{
OleDbConnection con2 = new OleDbConnection();
con2.ConnectionString = @"Provider = Microsoft.ACE.OLEDB.12.0; Data Source = " + Request.PhysicalApplicationPath + "\\Yoav_DB.accdb";
con2.Open();
string sqlstring2 = @"SELECT Link, Link_order FROM links_tbl WHERE Username = @usr AND List_number = @num ORDER BY Link_order ASC";
OleDbCommand conSer2 = new OleDbCommand(sqlstring2, con2);
conSer2.Parameters.AddWithValue("@usr", Request.QueryString["Username"]);
conSer2.Parameters.AddWithValue("@num", Current.Text);
OleDbDataReader Drdr2 = conSer2.ExecuteReader();
DataTable dt = new DataTable("images");
DataColumn dc = new DataColumn("link");
dt.Columns.Add(dc);
dc = new DataColumn("count");
dt.Columns.Add(dc);
while (Drdr2.Read())
{
DataRow dr = dt.NewRow();
dr["link"] = "http://img.youtube.com/vi/" + Drdr2.GetString(0) + "/default.jpg";
dr["count"] = Drdr2.GetValue(1);
dt.Rows.Add(dr);
}
if (!dataSet.Tables.Contains("images"))
{
dataSet.Tables.Add(dt);
}
dataSet.Tables["images"].AcceptChanges();
YoutubeThumbnail.DataSource = dt;
YoutubeThumbnail.DataBind();
con2.Close();
}
IEnumerator C_SearchVideo(string p_SearchKeyWord, int p_MaxResultCount, Action p_OnSearchSuccessed)
{
// translate url
p_SearchKeyWord = p_SearchKeyWord.Replace(" ", "%20");
string l_EncodedURL = WWW.EscapeURL("https://www.googleapis.com/youtube/v3/search/?q=" + p_SearchKeyWord + "&type=video&maxResults=" + p_MaxResultCount + "&part=snippet,id&key=" + APIKey);
WWW l_waitForResponse = new WWW(WWW.UnEscapeURL(l_EncodedURL));
Debug.Log("Url : " + l_waitForResponse.url);
// try connect
yield return l_waitForResponse;
// parsing the json reserved
JSONNode l_jsonResult = JSON.Parse(l_waitForResponse.text);
SearchResultSet = new YoutubeSnippet[l_jsonResult["items"].Count];
ResultCount = SearchResultSet.Length;
Debug.Log("count : " + SearchResultSet.Length);
for (var i = 0; i < ResultCount; i++)
{
SearchResultSet[i].VideoID = l_jsonResult["items"][i]["id"]["videoId"];
SearchResultSet[i].Title = l_jsonResult["items"][i]["snippet"]["title"];
SearchResultSet[i].VideoDescription = l_jsonResult["items"][i]["snippet"]["description"];
var DefaultThumb = new YoutubeThumbnail
{
ThumbnailURL = l_jsonResult["items"][i]["snippet"]["thumbnails"]["default"]["url"],
Width = l_jsonResult["items"][i]["snippet"]["thumbnails"]["default"]["width"],
Height = l_jsonResult["items"][i]["snippet"]["thumbnails"]["default"]["height"]
};
var MidThumb = new YoutubeThumbnail
{
ThumbnailURL = l_jsonResult["items"][i]["snippet"]["thumbnails"]["medium"]["url"],
Width = l_jsonResult["items"][i]["snippet"]["thumbnails"]["medium"]["width"],
Height = l_jsonResult["items"][i]["snippet"]["thumbnails"]["medium"]["height"]
};
var StdThumb = new YoutubeThumbnail
{
ThumbnailURL = l_jsonResult["items"][i]["snippet"]["thumbnails"]["standard"]["url"],
Width = l_jsonResult["items"][i]["snippet"]["thumbnails"]["standard"]["width"],
Height = l_jsonResult["items"][i]["snippet"]["thumbnails"]["standard"]["height"]
};
var HQThumb = new YoutubeThumbnail
{
ThumbnailURL = l_jsonResult["items"][i]["snippet"]["thumbnails"]["high"]["url"],
Width = l_jsonResult["items"][i]["snippet"]["thumbnails"]["high"]["width"],
Height = l_jsonResult["items"][i]["snippet"]["thumbnails"]["high"]["height"]
};
var ThumbSet = new YoutubeThumbnailSet
{
DefaultThumbnail = DefaultThumb,
MidQualThumbnail = MidThumb,
StandardQualThumbnail = StdThumb,
HQualThumbnail = HQThumb
};
SearchResultSet[i].ThumbnailSet = ThumbSet;
}
p_OnSearchSuccessed.Invoke();
}
private string GetYoutubeImageUrl()
{
return(YoutubeThumbnail.GetImageUrlFromUrl(m_youtube.text, (YoutubeThumbnail.YoutubeImageType)m_dropdown.value));
}
public void ThumbnailReturnsDefaultWhenNotFinishedYetOnNOSDTest()
{
var n = new YoutubeThumbnail(nosd);
Assert.AreEqual("Resources/default.png", n.SafeThumbnail);
}
public void HighestThumbnailQualityFinderOnUPTOSDWithYoutubeContextTest()
{
var n = new YoutubeThumbnail(new YoutubeContext(uptosd));
Assert.AreEqual("https://i.ytimg.com/vi/t7Xv0P4LviE/sddefault.jpg", n.Thumbnail);
}
public void HighestThumbnailQualityFinderOnNOSDTest()
{
var n = new YoutubeThumbnail(nosd);
Assert.AreNotEqual("https://i.ytimg.com/vi/8SPtkjMUkGk/sddefault.jpg", n.Thumbnail);
Assert.AreEqual("https://i.ytimg.com/vi/8SPtkjMUkGk/hqdefault.jpg", n.Thumbnail);
}
