public static string SaveProfile(string myid, int memberid)
{
string myimg = "";
int isconfirm = 0;
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
string sql = String.Format("Update tblusers Set userprofileimage={0} Where userid={1} ", myid, memberid);
MySqlCommand cmd = new MySqlCommand(sql, conn);
conn.Open();
cmd.ExecuteNonQuery();
cmd.CommandText = String.Format("Select imagelink,isConfirm From userimages Where iduserimages={0}", myid);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
myimg = dr["imagelink"].ToString();
int.TryParse(dr["isConfirm"].ToString(), out isconfirm);
}
conn.Close();
}
spinmember mydata = methods.MemberList[memberid];
mydata.Image = myimg;
mydata.IsImgConfirm = isconfirm;
myimg = siteDefaults.SiteUrl + "/" + myimg.ToString().Replace("../", "").Replace("_size1", "_size0");
return(myimg);
}
protected void Page_Init(object sender, EventArgs e)
{
if (Session["memberid"] != null)
{
spinmember myspinmember = methods.GetMe();
myspinmember.GetAlertFrom = "";
// addmemberforDebug(16);
}
if (Request.QueryString["Lang"] != null && int.TryParse(Request.QueryString["Lang"], out lang))
{
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
string sql = "Select LandDir,LangCulture From languages where LangID=" + lang;
MySqlCommand cmd = new MySqlCommand(sql, conn);
conn.Open();
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
direction = dr["LandDir"].ToString();
culture = dr["LangCulture"].ToString();
}
}
}
else
{
direction = "ltr";
}
mystyle.Href = "Style/" + direction + ".css";
}
public static string DeleteImage(string myid)
{
spinmember myspin = methods.GetMe();
bool changeProfileImage = false;
if (methods.CheckSeesion())
{
string myfile = "";
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
string sql = String.Format("Select imagelink From userimages Where iduserimages={0} AND memberid={1} ", myid, myspin.MemberID);
MySqlCommand cmd = new MySqlCommand(sql, conn);
conn.Open();
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
myfile = HttpContext.Current.Server.MapPath(dr["imagelink"].ToString().Replace("../", ""));
if (myspin.Image2 == dr["imagelink"].ToString())
{
changeProfileImage = true;
}
}
dr.Close();
sql = String.Format("Delete From userimages Where iduserimages={0} AND memberid={1} ", myid, myspin.MemberID);
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
if (changeProfileImage)
{
cmd.CommandText = String.Format("Select iduserimages From userimages where memberid={0} limit 1", myspin.MemberID);
dr = cmd.ExecuteReader();
int iduserimages = 0;
if (dr.Read())
{
int.TryParse(dr["iduserimages"].ToString(), out iduserimages);
}
dr.Close();
if (iduserimages > 0)
{
SaveProfile(iduserimages.ToString(), myspin.MemberID);
}
}
conn.Close();
int size = 0;
while (File.Exists(myfile))
{
File.Delete(myfile);
size++;
myfile = myfile.Replace("_size" + (size - 1), "_size" + size);
}
}
return(myid);
}
else
{
return("1error1");
}
}
public static string SaveImage(string myimage, string count)
{
if (methods.CheckSeesion())
{
spinmember myspin = methods.GetMe();
string DirName = "memberimages";
int size = 0;
string myfile = HttpContext.Current.Server.MapPath(myimage.Replace("../", ""));
if (!File.Exists(myfile.Replace("tempFile", DirName)))
{
while (File.Exists(myfile))
{
string SaveTo = myfile.Replace("tempFile", DirName).Replace('\\', '/');
try
{
File.Copy(myfile, SaveTo);
}
catch (Exception ex)
{
string aaa = ex.Message;
}
if (size == 1)
{
MakeImageBusiness(SaveTo);
}
size++;
myfile = myfile.Replace("_size" + (size - 1), "_size" + size);
}
}
string imageid = "";
string myimg = "";
int isconfirm = 0;
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
string sql = String.Format("Insert Into userimages (imagelink,memberid) Values ('{0}',{1});SELECT last_insert_id(); ", myimage.Replace("tempFile", DirName), myspin.MemberID);
MySqlCommand cmd = new MySqlCommand(sql, conn);
conn.Open();
imageid = cmd.ExecuteScalar().ToString();
if (count == "0")
{
cmd.CommandText = String.Format("Update tblusers Set userprofileimage={0} WHERE userid={1}", imageid, HttpContext.Current.Session["memberid"]);
cmd.ExecuteNonQuery();
cmd.CommandText = String.Format("Select imagelink,isConfirm From userimages Where iduserimages={0}", imageid);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
myimg = dr["imagelink"].ToString();
int.TryParse(dr["isConfirm"].ToString(), out isconfirm);
}
myspin.Image = myimg;
myspin.IsImgConfirm = isconfirm;
myimg = siteDefaults.SiteUrl + "/" + myimg.ToString().Replace("../", "").Replace("_size1", "_size0");
}
conn.Close();
}
//cmd.ExecuteNonQuery();
return(imageid);// myimage.Replace("tempFile", DirName);
}
else
{
return("1error1");
}
}
protected void DoLoad()
{
string imagesql = "";
if (Request.QueryString["mymember"] != null && int.TryParse(Request.QueryString["mymember"], out mymember) && mymember.ToString() != Session["memberid"].ToString())
{
EditImage.Visible = false;
ProfileButtons.Visible = false;
deletebutton.Visible = false;
if (siteDefaults.SiteParam["hasConfirmPicture"].ToLower() == "true")
{
imagesql = " AND isConfirm=1";
}
}
else
{
EditImage.Visible = true;
mymember = int.Parse(Session["memberid"].ToString());
}
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
string sql = String.Format("select imagelink,iduserimages,userprofileimage,isConfirm,usergendor,memberid,xvalue,yvalue From tblusers left join userimages On userimages.memberid=tblusers.userid Where userid={0} {1}", mymember, imagesql);
MySqlDataAdapter ad = new MySqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
ad.Fill(ds, "images");
dv = ds.Tables["images"].DefaultView;
//dv.RowFilter = "userprofileimage=iduserimages";
if (dv.Count > 0)
{
for (int i = 0; i < dv.Count; i++)
{
int x = 0;
int y = 0;
int.TryParse(dv[i]["xvalue"].ToString(), out x);
int.TryParse(dv[i]["yvalue"].ToString(), out y);
int iduserimages;
int.TryParse(dv[i]["iduserimages"].ToString(), out iduserimages);
if (selectedImage == iduserimages)
{
imagenumber = i;
imageselected.Value = i.ToString();
string _sethedden = "sethiddenstart(" + x + "," + y + ");";
Page.ClientScript.RegisterStartupScript(GetType(), "setstart", _sethedden, true);
}
if (i == 0)
{
if (dv[i]["usergendor"].ToString().ToLower() == "false")
{
MyProfileImage.Src = siteDefaults.SiteUrl + "/images/SiteImages/proffilebig.png";
}
else
{
MyProfileImage.Src = siteDefaults.SiteUrl + "/images/SiteImages/proffilebig2.png";
}
if (dv.Count <= 1 && String.IsNullOrEmpty(dv[i]["imagelink"].ToString()))
{
GenderLiteral.Text = "<input id=\"mygenderimg\" type=\"hidden\" value=\"" + MyProfileImage.Src + "\" />";
deletebutton.Visible = false;
}
}
// MyProfileImage.Attributes["onload"] = "setimgpos(this);";
if (dv[i]["iduserimages"].ToString() == dv[i]["userprofileimage"].ToString())
{
imageprofile = i.ToString();
MyprofileImgHiddenField.Value = imageprofile;
if (File.Exists(MapPath(dv[i]["imagelink"].ToString().Replace("../", "").Replace("_size1", "_size0"))))
{
MyProfileImage.Src = siteDefaults.SiteUrl + "/" + dv[i]["imagelink"].ToString().Replace("../", "").Replace("_size1", "_size2");
MyProfileImage.Attributes["onload"] = "setimgposnew(this," + x + "," + y + ");";
//MyProfileImage.Style["width"] = "90%";
}
}
}
dv.RowFilter = "memberid=" + mymember;
imagesRepeater.DataSource = dv;
imagesRepeater.DataBind();
}
else
{
if (methods.MemberList.ContainsKey(mymember))
{
spinmember memspin = methods.MemberList[mymember];
if (memspin.Image == "")
{
string genimag = siteDefaults.SiteUrl + "/images/SiteImages/proffilebig.png";
if (memspin.Gender == 1)
{
genimag = siteDefaults.SiteUrl + "/images/SiteImages/proffilebig2.png";
}
GenderLiteral.Text = "<input id=\"mygenderimg\" type=\"hidden\" value=\"" + genimag + "\" />";
}
}
}
imagecount = dv.Count;
imgcount.Text = String.Format("({0} {1})", imagesRepeater.Items.Count, Languages.MyText("photos_images"));
allnum.InnerText = imagesRepeater.Items.Count.ToString();
}
}
protected void Page_Init(object sender, EventArgs e)
{
if (siteDefaults.SiteUrl == "")
{
// siteDefaults.SiteGeneralDefaults();
}
if (Session["memberid"] != null && int.TryParse(Session["memberid"].ToString(), out memberid) && methods.MemberList.ContainsKey(memberid))
{
}
else
{
if (Session["memberid"] != null && int.TryParse(Session["memberid"].ToString(), out memberid) && !methods.MemberList.ContainsKey(memberid))
{
methods.AddMember(memberid);
// methods.CreateRooms(memberid);
}
else
{
if (Request.Cookies["spindate"] != null)
{
bool HasCookie = false;
HttpCookie rememberCookie = Request.Cookies["spindate"];
string MyID = rememberCookie.Values["ID"];
string Email = rememberCookie.Values["user"];
if (!string.IsNullOrEmpty(MyID) && !string.IsNullOrEmpty(Email))
{
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
string sql = String.Format("Select count(*) From tblusers where userid={0} AND useremail='{1}'", MyID, Email);
MySqlCommand cmd = new MySqlCommand(sql, conn);
conn.Open();
if (cmd.ExecuteScalar() != null)
{
HasCookie = true;
}
conn.Close();
}
Session["memberid"] = rememberCookie.Values["ID"];
memberid = int.Parse(rememberCookie.Values["ID"]);
}
if (!methods.AddMember(memberid))
{
HttpContext.Current.Session.Abandon();
if (HttpContext.Current.Request.Cookies["spindate"] != null)
{
HttpCookie myCookie = new HttpCookie("spindate");
myCookie.Expires = DateTime.Now.AddDays(-1d);
HttpContext.Current.Response.Cookies.Add(myCookie);
}
Response.Redirect(siteDefaults.GetLink("./"));
}
}
}
}
Session["mylang"] = "1";
if (Request.QueryString["Lang"] != null && int.TryParse(Request.QueryString["Lang"], out lang))
{
Session["mylang"] = lang.ToString();
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
string sql = "Select LandDir,LangCulture From languages where LangID=" + lang;
MySqlCommand cmd = new MySqlCommand(sql, conn);
conn.Open();
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
direction = dr["LandDir"].ToString();
Session["dir"] = direction;
culture = dr["LangCulture"].ToString();
}
}
}
else
{
direction = "ltr";
Session["dir"] = direction;
}
mystyle.Href = "Style/" + direction + ".css";
LogoImage.Alt = Languages.MyText("Alt Logo_Master");
sitelogo.HRef = siteDefaults.GetLink("./");
sitelogo.Title = Languages.MyText("Spindate_Master");
if (memberid > 0 && methods.MemberList.ContainsKey(memberid))
{
myspin = methods.GetMe(memberid);
myspin.GetAlertFrom = "";
if (myspin.OnlineChat.Contains("menu"))
{
mychatonlineholderid.Style["overflow"] = "auto";
mychatonlineholderid.Style["top"] = "100%";
MyChatSearchBox.CssClass = "mychatsearchtextbox searchboxnone";
onlineoffline.Style["margin-top"] = "33px";
onlineoffline.Style["background"] = "url('Images/SiteImages/closechatbg.png') no-repeat left bottom";
}
soundstate.Text = string.Format("<input id=\"soundid\" type=\"hidden\" value=\"{0}\" />", myspin.Sound);
// addmemberforDebug(16);
}
homebutton.HRef = siteDefaults.GetLink("online.aspx");
homebutton.InnerText = Languages.MyText("Lobby_Master");
topmenuPanel.Attributes["title"] = Languages.MyText("Go To Lobby_Master");
profilebutton.HRef = siteDefaults.GetLink("profile.aspx");
profilebutton.InnerText = Languages.MyText("Profile_Master");
profilebutton.Attributes["title"] = Languages.MyText("Go To Profile_Master");
favoritebutton.HRef = siteDefaults.GetLink("Favourites.aspx");
favoritebutton.InnerText = Languages.MyText("Favourites_Master");
favoritebutton.Attributes["title"] = Languages.MyText("Go To Favourites_Master");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsSitePage)
{
if (!methods.CheckUserCradential())
{
Response.Redirect(siteDefaults.SiteUrl);
}
else
{
//int.TryParse(Session["memberid"].ToString(), out memberid);
if (!methods.MemberList.ContainsKey(memberid))
{
methods.AddMember(memberid);
}
if (!methods.MemberList[memberid].IsPassFirstStage)
{
if (IsLobby)
{
string _js = " openMyprofile('" + siteDefaults.GetLink("registermsg.aspx?status=2") + "', '480', '470');";
Page.ClientScript.RegisterStartupScript(GetType(), "WaitForConfirm", _js, true);
}
else
{
Response.Redirect(siteDefaults.GetLink("online.aspx"));
}
}
}
SystemBottomLiteral.Text = Languages.MyText("Bottom Code System_general");
HeadContentSite.Text = Languages.MyText("Header Code System_general");
}
else
{
SiteBottomLiteral.Text = Languages.MyText("Bottom Code Site_general");
HeadContentSite.Text = Languages.MyText("Header Code Site_general_3");
}
if (!IsPostBack)
{
mainIframHolder.Style["height"] = "0px";
}
else
{
mainIframHolder.Style["height"] = "0px";
}
if (memberid > 0)
{
if (methods.MemberList.ContainsKey(memberid))
{
myspin = methods.GetMe();
// yossi
//if (IsPostBack)
//{
// myspin.IsAvailable = true;
//}
Myprofimg.Src = methods.SetImage(myspin.Image2.Replace("_size0", "_size1").Replace("../", ""), (myspin.Gender.ToString()));
Myprofimg.Attributes["onload"] = "setimgposnew(this," + myspin.ImageX + "," + myspin.ImageY + ");";
Myprofimg.Alt = myspin.FirstName + "(" + myspin.Age + ")";
Myprofimg.Attributes["title"] = myspin.FirstName + "(" + myspin.Age + ")";
buble1Topdiv.Visible = false;
buble2Topdiv.Visible = false;
buble3Topdiv.Visible = false;
buble4Topdiv.Visible = false;
IsOnLine = myspin.IsOnline;
string a = myspin.OnlineChat;
if (!IsOnLine)
{
Page.ClientScript.RegisterStartupScript(GetType(), "setlogout", "window.onload= setchaton2($('.mychatoffbtn'));", true);
}
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
conn.Open();
string sql = "";
MySqlCommand cmd;
MySqlDataReader dr;
#region set account type
switch (myspin.AccountStatus)
{
case 3:
case 0:
// member in try time
if (siteDefaults.GetParam("hasDateFroDay").ToString().ToLower() == "true")
{
buble4Topdiv.Visible = true;
int date = 0;
DateTime datepablish = DateTime.Now;
bool setToDefault = false;
if (myspin.DateOnDayDate.ToString("ddMMyyyy") != DateTime.Now.ToString("ddMMyyyy"))
{
sql = String.Format("Select userdateonday,userdateondaydate From tblusers where userid={0}", memberid);
cmd = new MySqlCommand(sql, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
if (DateTime.TryParse(dr["userdateondaydate"].ToString(), out datepablish) && datepablish.ToString("ddMMyyyy") == DateTime.Now.ToString("ddMMyyyy"))
{
int.TryParse(dr["userdateonday"].ToString(), out date);
myspin.DateOnDay = date;
myspin.DateOnDayDate = DateTime.Now;
}
else
{
setToDefault = true;
}
}
dr.Close();
if (setToDefault)
{
cmd.CommandText = String.Format("Update tblusers Set userdateonday={0} ,userdateondaydate=now() where userid={1}", siteDefaults.SiteParam["DateaDay"], memberid);
cmd.ExecuteNonQuery();
int.TryParse(siteDefaults.SiteParam["DateaDay"], out date);
myspin.DateOnDay = date;
myspin.DateOnDayDate = DateTime.Now;
}
}
else
{
date = myspin.DateOnDay;
}
GuestSpinner2.InnerHtml = Languages.MyText("Guest spinner2_master_3").Replace("[[dates]]", date.ToString());
}
else
{
buble1Topdiv.Visible = true;
}
break;
case 1:
// member with coupon
if (myspin.SubscirbDate.Date > DateTime.Now.Date)
{
if (myspin.CouponType)
{
buble4Topdiv.Visible = true;
int date = 0;
DateTime datepablish = DateTime.Now;
bool setToDefault = false;
if (myspin.DateOnDayDate.ToString("ddMMyyyy") != DateTime.Now.ToString("ddMMyyyy"))
{
sql = String.Format("Select userdateonday,userdateondaydate,cuopondateaday From tblusers left join tblcuopons ON tblcuopons.couponcode=tblusers.usercoupon where userid={0}", memberid);
cmd = new MySqlCommand(sql, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
int.TryParse(dr["cuopondateaday"].ToString(), out date);
if (DateTime.TryParse(dr["userdateondaydate"].ToString(), out datepablish) && datepablish.ToString("ddMMyyyy") == DateTime.Now.ToString("ddMMyyyy"))
{
int.TryParse(dr["userdateonday"].ToString(), out date);
myspin.DateOnDay = date;
myspin.DateOnDayDate = DateTime.Now;
}
else
{
setToDefault = true;
}
}
dr.Close();
if (setToDefault)
{
cmd.CommandText = String.Format("Update tblusers Set userdateonday=(select cuopondateaday from tblcuopons where couponcode='{0}') ,userdateondaydate=now() where userid={1}", myspin.Coupon, memberid);
cmd.ExecuteNonQuery();
//int.TryParse(siteDefaults.SiteParam["DateaDay"], out date);
myspin.DateOnDay = date;
myspin.DateOnDayDate = DateTime.Now;
}
}
else
{
date = myspin.DateOnDay;
}
GuestSpinner2.InnerHtml = Languages.MyText("Guest spinner2_master_3").Replace("[[dates]]", date.ToString());
}
else
{
int mydays = (myspin.SubscirbDate - DateTime.Now).Days;
coupondaydiv.InnerHtml = Languages.MyText("Your invitation will expire in 7 days._master_3").Replace("[[days]]", mydays.ToString());;
buble3Topdiv.Visible = true;
}
}
else
{
sql = String.Format("Update tblusers Set userAccount=3 Where userid={0}", memberid);
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
Response.Redirect(siteDefaults.GetLink("./"));
}
break;
case 2:
// member subscribe
if (myspin.SubscirbDate.Date > DateTime.Now.Date)
{
int mydays = (myspin.SubscirbDate - DateTime.Now).Days;
buble2Topdiv.Visible = true;
freeacountdate.InnerHtml = Languages.MyText("premium user_master_3").Replace("[[days]]", mydays.ToString());
}
else
{
sql = String.Format("Update tblusers Set userAccount=3 Where userid={0}", memberid);
cmd = new MySqlCommand(sql, conn);
// conn.Open();
cmd.ExecuteNonQuery();
myspin.AccountStatus = 3;
Response.Redirect(siteDefaults.GetLink("./"));
}
break;
case 4:
// member frozen
// buble1Topdiv.Visible = true;
// freeacountdate.InnerHtml = Languages.MyText("premium user_master_3");
if (!IsSitePage)
{
LogOut(memberid, "frozen.aspx");
}
break;
case 5:
// member blocked
if (!IsSitePage)
{
LogOut(memberid, "./");
}
break;
}
#endregion
sql = String.Format("Select count(alertid) as alertcount From `" + siteDefaults.schemaalert + "`. `tblalert{0}` where memberid={0} and isread=false and alerttype<10 ", memberid);
cmd = new MySqlCommand(sql, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr["alertcount"].ToString() == "0")
{
AlertbLabel.Visible = false;
leftmenubellclassid.Attributes["class"] = "leftmenubellclass";
}
else
{
AlertbLabel.Text = dr["alertcount"].ToString();
AlertbLabel.CssClass = "alertbubleclass alerticonholder2";
leftmenubellclassid.Attributes["class"] = "leftmenubellclass leftmenubellclassSel";
}
}
dr.Close();
inboxbutton.HRef = siteDefaults.GetLink("inbox.aspx");
cmd.CommandText = String.Format("Select memberid as inboxcount From ( Select memberid From `" + siteDefaults.schemainbox + "`. `inboxmessages{0}` where memberid={0} and isRead=false and isDeleted=false Group by mymemberid ) as Myinbox ;", memberid);
dr = cmd.ExecuteReader();
int inboxcount = 0;
InboxSenderHiddenField.Value = "";
InboxbLabel.Style["display"] = "none";
while (dr.Read())
{
inboxcount++;
InboxSenderHiddenField.Value += "_" + dr["inboxcount"].ToString() + "_";
InboxbLabel.Text = inboxcount.ToString();
inboxbutton.Attributes["class"] = "leftmenuletterclass leftmenuletterclassred";
InboxbLabel.Style["display"] = "block";
}
dr.Close();
#region Top Line Content
string code = "";
string datacode = "";
sql = String.Format("Select topMessgaeSystem,msgkeysystem From toplinemsg where toplang={0} ", lang);
cmd = new MySqlCommand(sql, conn);
dr = cmd.ExecuteReader();
if (dr.Read())
{
datacode = dr["msgkeysystem"].ToString();
MyCodeLiteral.Text = string.Format("<input type=\"hidden\" id=\"topcodehidden\" value=\"{0}\" /> ", datacode);
TopeLineData.InnerHtml = dr["topMessgaeSystem"].ToString();
}
dr.Close();
if (Request.Cookies["spindatecode2"] != null)
{
HttpCookie rememberCookie = Request.Cookies["spindatecode2"];
code = rememberCookie.Values["code"];
}
if (code != "" && code == datacode)
{
MyToopLine.Visible = false;
}
#endregion
conn.Close();
}
}
memberImage = methods.SetImage(methods.MemberList[memberid].Image2.Replace("../", "").Replace("_size0", "_size1"), methods.MemberList[memberid].Gender.ToString());
imagex = methods.MemberList[memberid].ImageX.ToString();
imagey = methods.MemberList[memberid].ImageY.ToString();
#region set smilly icons
SmillyLiteral.Text = "";
for (int i = 1; i < MySmilly.Count; i++)
{
if (MySmilly.ContainsKey(i))
{
SmillyLiteral.Text += "<img onclick=\"insertsmile('" + Server.HtmlEncode(MySmilly[i].SmillyCode) + "','mynumber','" + Mychattextboxmynumber.ClientID + "');\" class=\"smillyclass\" alt\"\" src=\"" + MySmilly[i].SmillyPath + "\" />";
}
}
#endregion
OnlineChatPAnel.Visible = true;
ChatScriptPanel.Visible = true;
if (Session["dir"].ToString() == "rtl")
{
OnlineJSRTLPanel.Visible = true;
OnlineJSLTRPanel.Visible = false;
}
}
else
{
using (MySqlConnection conn = new MySqlConnection(siteDefaults.ConnStr))
{
conn.Open();
string code = "";
string datacode = "";
string sql = String.Format("Select topMessgaeSite,msgkeysite From toplinemsg where toplang={0} ", lang);
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
datacode = dr["msgkeysite"].ToString();
MyCodeLiteral.Text = string.Format("<input type=\"hidden\" id=\"topcodehidden\" value=\"{0}\" /> ", datacode);
TopeLineData.InnerHtml = dr["topMessgaeSite"].ToString();
}
dr.Close();
if (Request.Cookies["spindatecode"] != null)
{
HttpCookie rememberCookie = Request.Cookies["spindatecode"];
code = rememberCookie.Values["code"];
}
if (code != "" && code == datacode)
{
MyToopLine.Visible = false;
}
}
}
}
