Comments by Akshay malvankar (Top 83 by date)

$(document).ready(function () {
var original_open = window.open;

if (!this.isApp) {
window.open = original_open;
}
debugger;
try {
var strFaceBookKey = "<%=strFaceBookKey%>";
var redirecturl = window.location.href;
console.log("redirect " + redirecturl);



function statusChangeCallback(response) { // Called with the results from FB.getLoginStatus().
console.log('statusChangeCallback');
console.log(response); // The current login status of the person.
if (response.status === 'connected') { // Logged into your webpage and Facebook response.authResponse.accessToken.
console.log("connected to fb");
DirectLogin(response.authResponse.accessToken);
} else if (response.status === 'not_authorized') {
AskPermissionForLogin();
}

else { // Not logged into your webpage or we are unable to tell.
console.log("not connected to fb");
}
}


if (userid == 0) {
window.fbAsyncInit = function () {
FB.init({ appId: strFaceBookKey, status: true, cookie: true, xfbml: true, version: 'v2.9'});
FB.getLoginStatus(function (response) { // Called after the JS SDK has been initialized.
console.log("Inside FB login status");
statusChangeCallback(response); // Returns the login status.
});
};
}


// to Load Javascript sdk e.g facebook permission popup
(function (d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) { return; }
js = d.createElement(s); js.id = id;
js.src = "https://connect.facebook.net/en_US/sdk.js#version=v2.8&appId=" + strFaceBookKey + "&status=true&cookie=true&xfbml=true";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));


function DirectLogin(token) { // Testing Graph API after login. See statusChangeCallback() for when this call is made.
FB.api("https://graph.facebook.com/me?&fields=id,name,email,first_name,last_name,birthday,picture,hometown,gender,website", function (response) {
console.log("DirectLogin " + JSON.stringify(response));
window.document.forms[0].hdnId.value = response.id;
window.document.forms[0].hdnEmail.value = response.email;
window.document.forms[0].hdnName.value = response.name;
window.document.forms[0].hdnfname.value = response.first_name;
window.document.forms[0].hdnlname.value = response.last_name;
if (response.gender)
{ window.document.forms[0].hdngen.value = response.gender; }
if (response.birthday)
{ window.document.forms[0].hdndob.value = response.birthday; }
window.document.forms[0].hdnimgsrc.value = response.picture.data;
if (response.hometown)
{ window.document.forms[0].hdnHmeCty.value = response.hometown.name; }
if (response.location)
{ window.document.forms[0].hdnLoc.value = response.loc

Dim logo As LinkedResource = Nothing
Dim Path As String = Server.MapPath("../Images/mob1.jpg")
logo = New LinkedResource(Path, MediaTypeNames.Image.Jpeg)
logo.ContentId = "Logo_Ms"

Dim imageContent1 As String =

Dim str_mail As String = "" + imageContent1 + ""

Dim logo As LinkedResource = Nothing
Dim Path As String = Server.MapPath("../Images/mob1.jpg")
logo = New LinkedResource(Path, MediaTypeNames.Image.Jpeg)
logo.ContentId = "Logo_Ms"

Dim imageContent1 As String = ""

Dim str_mail As String = "" + imageContent1 + ""

Dim logo As LinkedResource = Nothing
Dim Path As String = Server.MapPath("../Images/mob1.jpg")
logo = New LinkedResource(Path, MediaTypeNames.Image.Jpeg)
logo.ContentId = "Logo_Ms"

Dim imageContent1 As String = ""

Dim str_mail As String = "" + imageContent1 + ""

i try this also but didnt get successed

Following query produce this in SQL

SELECT avg(DATEDIFF(second,tur.start,tur.[end])) as t FROM tblUserTracking tur where tur.start
between '2000-01-01'
and '2019-01-01'

Output : 41519653

In Mysql

SELECT avg(CEILING(TIMESTAMPDIFF(second,tur.start,tur.end))) as t FROM tblUserTracking tur where tur.start
between '2000-01-01'
and '2019-01-01'

Output
41519652.9524

So how to round up point value in Mysql