Ejemplo n.º 1
0
        private void InitPollUI(DataRow currentRow)
        {
            RemovePoll.CommandArgument = currentRow["PollID"].ToString();

            if (currentRow["PollID"] != DBNull.Value)
            {
                DataTable choices = YAF.Classes.Data.DB.poll_stats(currentRow["PollID"]);

                Question.Text = choices.Rows[0]["Question"].ToString();
                if (choices.Rows[0]["Closes"] != DBNull.Value)
                {
                    TimeSpan closing = (DateTime)choices.Rows[0]["Closes"] - DateTime.Now;

                    PollExpire.Text = (SqlDataLayerConverter.VerifyInt32((closing.TotalDays + 1)).ToString());
                }
                else
                {
                    PollExpire.Text = null;
                }

                for (int i = 0; i < choices.Rows.Count; i++)
                {
                    HiddenField idField     = (HiddenField)this.FindControl(String.Format("PollChoice{0}ID", i + 1));
                    TextBox     choiceField = (TextBox)this.FindControl(String.Format("PollChoice{0}", i + 1));

                    idField.Value    = choices.Rows[i]["ChoiceID"].ToString();
                    choiceField.Text = choices.Rows[i]["Choice"].ToString();
                }

                ChangePollShowStatus(true);
            }
        }
Ejemplo n.º 2
0
        private bool CanEditPostCheck(DataRow message)
        {
            bool postLocked = false;

            if (!PageContext.IsAdmin && PageContext.BoardSettings.LockPosts > 0)
            {
                DateTime edited = (DateTime)message["Edited"];

                if (edited.AddDays(PageContext.BoardSettings.LockPosts) < DateTime.Now)
                {
                    postLocked = true;
                }
            }

            DataRow forumInfo, topicInfo;

            // get topic and forum information
            topicInfo = DB.topic_info(PageContext.PageTopicID);
            using (DataTable dt = DB.forum_list(PageContext.PageBoardID, PageContext.PageForumID))
                forumInfo = dt.Rows[0];

            // Ederon : 9/9/2007 - moderator can edit in locked topics
            return(((!postLocked &&
                     !General.BinaryAnd(forumInfo["Flags"], ForumFlags.Flags.IsLocked) &&
                     !General.BinaryAnd(topicInfo["Flags"], TopicFlags.Flags.IsLocked) &&
                     (SqlDataLayerConverter.VerifyInt32(message["UserID"]) == PageContext.PageUserID)) || PageContext.ForumModeratorAccess) &&
                   PageContext.ForumEditAccess);
        }
Ejemplo n.º 3
0
        /// <summary>
        /// The init reply to topic.
        /// </summary>
        private void InitReplyToTopic()
        {
            DataRow topic      = DB.topic_info(this.TopicID);
            var     topicFlags = new TopicFlags(SqlDataLayerConverter.VerifyInt32(topic["Flags"]));

            // Ederon : 9/9/2007 - moderators can reply in locked topics
            if (topicFlags.IsLocked && !this.PageContext.ForumModeratorAccess)
            {
                this.Response.Redirect(this.Request.UrlReferrer.ToString());
            }

            this.SubjectRow.Visible = false;
            this.Title.Text         = this.GetText("reply");

            // add topic link...
            this.PageLinks.AddLink(
                this.Server.HtmlDecode(topic["Topic"].ToString()), YafBuildLink.GetLink(ForumPages.posts, "t={0}", this.TopicID));

            // add "reply" text...
            this.PageLinks.AddLink(this.GetText("reply"));

            // show attach file option if its a reply...
            if (this.PageContext.ForumUploadAccess)
            {
                this.PostOptions1.Visible             = true;
                this.PostOptions1.AttachOptionVisible = true;
            }

            // show the last posts AJAX frame...
            this.LastPosts1.Visible = true;
            this.LastPosts1.TopicID = this.TopicID.Value;
        }
Ejemplo n.º 4
0
        private void BindData()
        {
            ActiveList.DataSource = YAF.Classes.Data.DB.active_list(PageContext.PageBoardID, true);
            UserList.DataSource   = YAF.Classes.Data.DB.user_list(PageContext.PageBoardID, null, false);
            DataBind();

            // get stats for current board, selected board or all boards (see function)
            DataRow row = YAF.Classes.Data.DB.board_stats(GetSelectedBoardID());

            NumPosts.Text  = String.Format("{0:N0}", row ["NumPosts"]);
            NumTopics.Text = String.Format("{0:N0}", row ["NumTopics"]);
            NumUsers.Text  = String.Format("{0:N0}", row ["NumUsers"]);

            TimeSpan span = DateTime.Now - ( DateTime )row ["BoardStart"];
            double   days = span.Days;

            BoardStart.Text = String.Format("{0:d} ({1:N0} days ago)", row ["BoardStart"], days);

            if (days < 1)
            {
                days = 1;
            }
            DayPosts.Text  = String.Format("{0:N2}", SqlDataLayerConverter.VerifyInt32(row["NumPosts"]) / days);
            DayTopics.Text = String.Format("{0:N2}", SqlDataLayerConverter.VerifyInt32(row["NumTopics"]) / days);
            DayUsers.Text  = String.Format("{0:N2}", SqlDataLayerConverter.VerifyInt32(row["NumUsers"]) / days);

            DBSize.Text = String.Format("{0} MB", DB.DBSize);
        }
Ejemplo n.º 5
0
        /// <summary>
        /// The user list_ item command.
        /// </summary>
        /// <param name="source">
        /// The source.
        /// </param>
        /// <param name="e">
        /// The e.
        /// </param>
        public void UserList_ItemCommand([NotNull] object source, [NotNull] RepeaterCommandEventArgs e)
        {
            switch (e.CommandName)
            {
            case "edit":

                // we are going to edit user - redirect to edit page
                YafBuildLink.Redirect(ForumPages.admin_edituser, "u={0}", e.CommandArgument);
                break;

            case "delete":

                // we are deleting user
                if (this.PageContext.PageUserID == int.Parse(e.CommandArgument.ToString()))
                {
                    // deleting yourself isn't an option
                    this.PageContext.AddLoadMessage("You can't delete yourself.");
                    return;
                }

                // get user(s) we are about to delete
                using (DataTable dt = DB.user_list(this.PageContext.PageBoardID, e.CommandArgument, DBNull.Value))
                {
                    // examine each if he's possible to delete
                    foreach (DataRow row in dt.Rows)
                    {
                        if (SqlDataLayerConverter.VerifyInt32(row["IsGuest"]) > 0)
                        {
                            // we cannot detele guest
                            this.PageContext.AddLoadMessage("You can't delete the Guest.");
                            return;
                        }

                        if ((row["IsAdmin"] != DBNull.Value && SqlDataLayerConverter.VerifyInt32(row["IsAdmin"]) > 0) ||
                            (row["IsHostAdmin"] != DBNull.Value && Convert.ToInt32(row["IsHostAdmin"]) > 0))
                        {
                            // admin are not deletable either
                            this.PageContext.AddLoadMessage("You can't delete the Admin.");
                            return;
                        }
                    }
                }

                // all is good, user can be deleted
                UserMembershipHelper.DeleteUser(Convert.ToInt32(e.CommandArgument));

                // rebind data
                this.BindData();

                // quit case
                break;
            }
        }
Ejemplo n.º 6
0
        protected string GetViewing(object o)
        {
            DataRow row      = ( DataRow )o;
            int     nViewing = SqlDataLayerConverter.VerifyInt32(row["Viewing"]);

            if (nViewing > 0)
            {
                return("&nbsp;" + String.Format(PageContext.Localization.GetText("VIEWING"), nViewing));
            }
            else
            {
                return("");
            }
        }
Ejemplo n.º 7
0
        /// <summary>
        /// The get viewing.
        /// </summary>
        /// <param name="o">
        /// The o.
        /// </param>
        /// <returns>
        /// The get viewing.
        /// </returns>
        protected string GetViewing([NotNull] object o)
        {
            var row      = (DataRow)o;
            int nViewing = SqlDataLayerConverter.VerifyInt32(row["Viewing"]);

            if (nViewing > 0)
            {
                return("&nbsp;" + this.PageContext.Localization.GetTextFormatted("VIEWING", nViewing));
            }
            else
            {
                return(string.Empty);
            }
        }
Ejemplo n.º 8
0
        /// <summary>
        /// The setup user statistics.
        /// </summary>
        /// <param name="userData">
        /// The user data.
        /// </param>
        private void SetupUserStatistics([NotNull] CombinedUserDataHelper userData)
        {
            double allPosts = 0.0;

            if (SqlDataLayerConverter.VerifyInt32(userData.DBRow["NumPostsForum"]) > 0)
            {
                allPosts = 100.0 * SqlDataLayerConverter.VerifyInt32(userData.DBRow["NumPosts"]) /
                           SqlDataLayerConverter.VerifyInt32(userData.DBRow["NumPostsForum"]);
            }

            this.Stats.InnerHtml = "{0:N0}<br />[{1} / {2}]".FormatWith(
                userData.DBRow["NumPosts"],
                this.GetTextFormatted("NUMALL", allPosts),
                this.GetTextFormatted(
                    "NUMDAY",
                    (double)SqlDataLayerConverter.VerifyInt32(userData.DBRow["NumPosts"]) /
                    SqlDataLayerConverter.VerifyInt32(userData.DBRow["NumDays"])));
        }
Ejemplo n.º 9
0
        private void InitReplyToTopic()
        {
            DataRow    topic      = DB.topic_info(TopicID);
            TopicFlags topicFlags = new TopicFlags(SqlDataLayerConverter.VerifyInt32(topic["Flags"]));

            // Ederon : 9/9/2007 - moderators can reply in locked topics
            if (topicFlags.IsLocked && !PageContext.ForumModeratorAccess)
            {
                Response.Redirect(Request.UrlReferrer.ToString());
            }
            SubjectRow.Visible = false;
            Title.Text         = GetText("reply");

            // add topic link...
            PageLinks.AddLink(Server.HtmlDecode(topic ["Topic"].ToString()), YAF.Classes.Utils.YafBuildLink.GetLink(YAF.Classes.Utils.ForumPages.posts, "t={0}", TopicID));
            // add "reply" text...
            PageLinks.AddLink(GetText("reply"));

            // show attach file option if its a reply...
            if (PageContext.ForumUploadAccess)
            {
                NewTopicOptionsRow.Visible = true;
                TopicAttach.Visible        = true;
                TopicAttachLabel.Visible   = true;
                TopicWatch.Visible         = false;
                TopicWatchLabel.Visible    = false;
                TopicAttachBr.Visible      = false;
            }

            if (YAF.Classes.Config.IsDotNetNuke || YAF.Classes.Config.IsRainbow || YAF.Classes.Config.IsPortal)
            {
                // can't use the last post iframe
                LastPosts.Visible    = true;
                LastPosts.DataSource = DB.post_list_reverse10(TopicID);
                LastPosts.DataBind();
            }
            else
            {
                LastPostsIFrame.Visible = true;
                LastPostsIFrame.Attributes.Add("src", string.Format("{0}framehelper.aspx?g=lastposts&t={1}", YafForumInfo.ForumRoot, TopicID));
            }
        }
Ejemplo n.º 10
0
        /// <summary>
        /// Handles click event of Update button.
        /// </summary>
        protected void Update_Click(object sender, System.EventArgs e)
        {
            // no user was specified
            if (UserName.Text.Length <= 0)
            {
                PageContext.AddLoadMessage(GetText("NO_SUCH_USER"));
                return;
            }

            // if we choose user from drop down, set selected value to text box
            if (ToList.Visible)
            {
                UserName.Text = ToList.SelectedItem.Text;
            }

            // we need to verify user exists
            using (DataTable dt = YAF.Classes.Data.DB.user_find(PageContext.PageBoardID, false, UserName.Text, null))
            {
                // there is no such user or reference is ambiugous
                if (dt.Rows.Count != 1)
                {
                    PageContext.AddLoadMessage(GetText("NO_SUCH_USER"));
                    return;
                }
                // we cannot use guest user here
                else if (SqlDataLayerConverter.VerifyInt32(dt.Rows[0]["IsGuest"]) > 0)
                {
                    PageContext.AddLoadMessage(GetText("NOT_GUEST"));
                    return;
                }

                // save permission
                YAF.Classes.Data.DB.userforum_save(dt.Rows[0]["UserID"], PageContext.PageForumID, AccessMaskID.SelectedValue);
                // redirect to forum moderation page
                YAF.Classes.Utils.YafBuildLink.Redirect(YAF.Classes.Utils.ForumPages.moderate, "f={0}", PageContext.PageForumID);

                // clear moderatorss cache
                YafCache.Current.Remove(YafCache.GetBoardCacheKey(Constants.Cache.ForumModerators));
            }
        }
Ejemplo n.º 11
0
        public void UserList_ItemCommand(object source, System.Web.UI.WebControls.RepeaterCommandEventArgs e)
        {
            switch (e.CommandName)
            {
            case "edit":
                YAF.Classes.Utils.YafBuildLink.Redirect(YAF.Classes.Utils.ForumPages.admin_edituser, "u={0}", e.CommandArgument);
                break;

            case "delete":
                if (PageContext.PageUserID == int.Parse(e.CommandArgument.ToString()))
                {
                    PageContext.AddLoadMessage("You can't delete yourself.");
                    return;
                }
                string userName = string.Empty;
                using (DataTable dt = YAF.Classes.Data.DB.user_list(PageContext.PageBoardID, e.CommandArgument, DBNull.Value))
                {
                    foreach (DataRow row in dt.Rows)
                    {
                        userName = ( string )row ["Name"];
                        if (SqlDataLayerConverter.VerifyInt32(row ["IsGuest"]) > 0)
                        {
                            PageContext.AddLoadMessage("You can't delete the Guest.");
                            return;
                        }
                        if ((row["IsAdmin"] != DBNull.Value && SqlDataLayerConverter.VerifyInt32(row["IsAdmin"]) > 0) || (row["IsHostAdmin"] != DBNull.Value && Convert.ToInt32(row["IsHostAdmin"]) > 0))
                        {
                            PageContext.AddLoadMessage("You can't delete the Admin.");
                            return;
                        }
                    }
                }
                UserMembershipHelper.DeleteUser(Convert.ToInt32(e.CommandArgument));
                BindData();
                break;
            }
        }
Ejemplo n.º 12
0
        /// <summary>
        /// The bind data.
        /// </summary>
        private void BindData()
        {
            DataTable activeList = DB.active_list(
                PageContext.PageBoardID, true, true, PageContext.BoardSettings.ActiveListTime, PageContext.BoardSettings.UseStyledNicks);

            // Set colorOnly parameter to false, as we get active users style from database
            if (PageContext.BoardSettings.UseStyledNicks)
            {
                new StyleTransform(PageContext.Theme).DecodeStyleByTable(ref activeList, false);
            }
            this.ActiveList.DataSource = activeList;
            this.UserList.DataSource   = DB.user_list(PageContext.PageBoardID, null, false);
            DataBind();

            // get stats for current board, selected board or all boards (see function)
            DataRow row = DB.board_stats(GetSelectedBoardID());

            this.NumPosts.Text  = "{0:N0}".FormatWith(row["NumPosts"]);
            this.NumTopics.Text = "{0:N0}".FormatWith(row["NumTopics"]);
            this.NumUsers.Text  = "{0:N0}".FormatWith(row["NumUsers"]);

            TimeSpan span = DateTime.UtcNow - (DateTime)row["BoardStart"];
            double   days = span.Days;

            this.BoardStart.Text = "{0:d} ({1:N0} days ago)".FormatWith(row["BoardStart"], days);

            if (days < 1)
            {
                days = 1;
            }

            this.DayPosts.Text  = "{0:N2}".FormatWith(SqlDataLayerConverter.VerifyInt32(row["NumPosts"]) / days);
            this.DayTopics.Text = "{0:N2}".FormatWith(SqlDataLayerConverter.VerifyInt32(row["NumTopics"]) / days);
            this.DayUsers.Text  = "{0:N2}".FormatWith(SqlDataLayerConverter.VerifyInt32(row["NumUsers"]) / days);

            this.DBSize.Text = "{0} MB".FormatWith(DB.DBSize);
        }
Ejemplo n.º 13
0
 private bool CanHavePoll(DataRow message)
 {
     return((TopicID == null && QuotedTopicID == null && EditTopicID == null) ||
            (message != null && (SqlDataLayerConverter.VerifyInt32(message["Position"])) == 0));
 }
Ejemplo n.º 14
0
 /// <summary>
 /// The can have poll.
 /// </summary>
 /// <param name="message">
 /// The message.
 /// </param>
 /// <returns>
 /// The can have poll.
 /// </returns>
 private bool CanHavePoll(DataRow message)
 {
     return((this.TopicID == null && this.QuotedMessageID == null && this.EditMessageID == null) ||
            (message != null && SqlDataLayerConverter.VerifyInt32(message["Position"]) == 0));
 }
Ejemplo n.º 15
0
        /// <summary>
        /// Handles save button click event.
        /// </summary>
        protected void Save_Click(object sender, EventArgs e)
        {
            // recipient was set in dropdown
            if (ToList.Visible)
            {
                To.Text = ToList.SelectedItem.Text;
            }
            if (To.Text.Length <= 0)
            {
                // recipient is required field
                PageContext.AddLoadMessage(GetText("need_to"));
                return;
            }

            // subject is required
            if (Subject.Text.Trim().Length <= 0)
            {
                PageContext.AddLoadMessage(GetText("need_subject"));
                return;
            }
            // message is required
            if (_editor.Text.Trim().Length <= 0)
            {
                PageContext.AddLoadMessage(GetText("need_message"));
                return;
            }

            if (ToList.SelectedItem != null && ToList.SelectedItem.Value == "0")
            {
                // administrator is sending PMs tp all users

                string       body         = _editor.Text;
                MessageFlags messageFlags = new MessageFlags();

                messageFlags.IsHtml   = _editor.UsesHTML;
                messageFlags.IsBBCode = _editor.UsesBBCode;

                DB.pmessage_save(PageContext.PageUserID, 0, Subject.Text, body, messageFlags.BitValue);

                // redirect to outbox (sent items), not control panel
                YafBuildLink.Redirect(ForumPages.cp_pm, "v={0}", "out");
            }
            else
            {
                // remove all abundant whitespaces and separators
                To.Text.Trim();
                Regex rx = new Regex(@";(\s|;)*;");
                To.Text = rx.Replace(To.Text, ";");
                if (To.Text.StartsWith(";"))
                {
                    To.Text = To.Text.Substring(1);
                }
                if (To.Text.EndsWith(";"))
                {
                    To.Text = To.Text.Substring(0, To.Text.Length - 1);
                }
                rx      = new Regex(@"\s*;\s*");
                To.Text = rx.Replace(To.Text, ";");

                // list of recipients
                List <string> recipients = new List <string>(To.Text.Split(';'));
                // list of recipient's ids
                int [] recipientID = new int [recipients.Count];

                if (recipients.Count > PageContext.BoardSettings.PrivateMessageMaxRecipients && !PageContext.IsAdmin)
                {
                    // to many recipients
                    PageContext.AddLoadMessage(String.Format(GetText("TOO_MANY_RECIPIENTS"), PageContext.BoardSettings.PrivateMessageMaxRecipients));
                    return;
                }

                // test sending user's PM count
                if (PageContext.BoardSettings.MaxPrivateMessagesPerUser != 0 &&
                    (DB.user_pmcount(PageContext.PageUserID) + recipients.Count) > PageContext.BoardSettings.MaxPrivateMessagesPerUser &&
                    !PageContext.IsAdmin)
                {
                    // user has full PM box
                    PageContext.AddLoadMessage(String.Format(GetText("OWN_PMBOX_FULL"), PageContext.BoardSettings.MaxPrivateMessagesPerUser));
                    return;
                }

                // get recipients' IDs
                for (int i = 0; i < recipients.Count; i++)
                {
                    using (DataTable dt = DB.user_find(PageContext.PageBoardID, false, recipients [i], null))
                    {
                        if (dt.Rows.Count != 1)
                        {
                            PageContext.AddLoadMessage(String.Format(GetText("NO_SUCH_USER"), recipients [i]));
                            return;
                        }
                        else if (SqlDataLayerConverter.VerifyInt32(dt.Rows [0] ["IsGuest"]) > 0)
                        {
                            PageContext.AddLoadMessage(GetText("NOT_GUEST"));
                            return;
                        }

                        // get recipient's ID from the database
                        recipientID [i] = Convert.ToInt32(dt.Rows [0] ["UserID"]);

                        // test receiving user's PM count
                        if (PageContext.BoardSettings.MaxPrivateMessagesPerUser != 0 &&
                            DB.user_pmcount(recipientID [i]) >= PageContext.BoardSettings.MaxPrivateMessagesPerUser &&
                            !PageContext.IsAdmin)
                        {
                            // recipient has full PM box
                            PageContext.AddLoadMessage(String.Format(GetText("RECIPIENTS_PMBOX_FULL"), recipients [i]));
                            return;
                        }
                    }
                }

                // send PM to all recipients
                for (int i = 0; i < recipients.Count; i++)
                {
                    string body = _editor.Text;

                    MessageFlags messageFlags = new MessageFlags();

                    messageFlags.IsHtml   = _editor.UsesHTML;
                    messageFlags.IsBBCode = _editor.UsesBBCode;

                    DB.pmessage_save(PageContext.PageUserID, recipientID [i], Subject.Text, body, messageFlags.BitValue);

                    if (PageContext.BoardSettings.AllowPMEmailNotification)
                    {
                        SendPMNotification(recipientID [i], Subject.Text);
                    }
                }

                // redirect to outbox (sent items), not control panel
                YafBuildLink.Redirect(ForumPages.cp_pm, "v={0}", "out");
            }
        }
Ejemplo n.º 16
0
        /// <summary>
        /// The init poll ui.
        /// </summary>
        /// <param name="pollID">
        /// The poll ID.
        /// </param>
        private void InitPollUI(int?pollID)
        {
            // we should get the schema anyway
            this._choices = DB.poll_stats(pollID);
            this._choices.Columns.Add("ChoiceOrderID", typeof(int));

            // First existing values alway 1!
            int existingRowsCount    = 1;
            int allExistingRowsCount = this._choices.Rows.Count;

            // we edit existing poll
            if (this._choices.Rows.Count > 0)
            {
                if ((Convert.ToInt32(this._choices.Rows[0]["UserID"]) != this.PageContext.PageUserID) &&
                    (!this.PageContext.IsAdmin) && (!this.PageContext.IsForumModerator))
                {
                    YafBuildLink.RedirectInfoPage(InfoMessage.Invalid);
                }


                this.IsBoundCheckBox.Checked              = this._choices.Rows[0]["IsBound"].ToType <bool>();
                this.IsClosedBoundCheckBox.Checked        = this._choices.Rows[0]["IsClosedBound"].ToType <bool>();
                this.AllowMultipleChoicesCheckBox.Checked = this._choices.Rows[0]["AllowMultipleChoices"].ToType <bool>();

                this.Question.Text           = this._choices.Rows[0]["Question"].ToString();
                this.QuestionObjectPath.Text = this._choices.Rows[0]["QuestionObjectPath"].ToString();

                if (this._choices.Rows[0]["Closes"] != DBNull.Value)
                {
                    TimeSpan closing = (DateTime)this._choices.Rows[0]["Closes"] - DateTime.UtcNow;

                    this.PollExpire.Text = SqlDataLayerConverter.VerifyInt32(closing.TotalDays + 1).ToString();
                }
                else
                {
                    this.PollExpire.Text = null;
                }

                foreach (DataRow choiceRow in this._choices.Rows)
                {
                    choiceRow["ChoiceOrderID"] = existingRowsCount;

                    existingRowsCount++;
                }
            }
            else
            {
                // A new topic is created
                // below check currently if works for topics only, but will do as some things are not enabled
                if (!CanCreatePoll())
                {
                    YafBuildLink.RedirectInfoPage(InfoMessage.AccessDenied);
                }
                // Get isBound value using page variables. They are initialized here.
                int pgidt = 0;

                // If a topic poll is edited or new topic created
                if (this._topicId > 0 && this._topicInfo != null)
                {
                    // topicid should not be null here
                    if (!this._topicInfo["PollID"].IsNullOrEmptyDBField())
                    {
                        pgidt = (int)this._topicInfo["PollID"];

                        DataTable pollGroupData = DB.pollgroup_stats(pgidt);

                        this.IsBoundCheckBox.Checked = Convert.ToBoolean(pollGroupData.Rows[0]["IsBound"]);
                        // this.IsClosedBoundCheckBox.Checked = Convert.ToBoolean(DB.pollgroup_stats(pgidt).Rows[0]["IsClosedBound"]);
                    }
                }
                else if (this._forumId > 0 && (!(this._topicId > 0) || (!(this._editTopicId > 0))))
                {
                    // forumid should not be null here
                    pgidt = (int)DB.forum_list(this.PageContext.PageBoardID, this._forumId).Rows[0]["PollGroupID"];
                }
                else if (this._categoryId > 0)
                {
                    // categoryid should not be null here
                    pgidt =
                        (int)
                        DB.category_listread(this.PageContext.PageBoardID, this.PageContext.PageUserID, this._categoryId).Rows[0][
                            "PollGroupID"];
                }

                if (pgidt > 0)
                {
                    if (Convert.ToInt32(DB.pollgroup_stats(pgidt).Rows[0]["IsBound"]) == 2)
                    {
                        this.IsBoundCheckBox.Checked = true;
                    }

                    if (Convert.ToInt32(DB.pollgroup_stats(pgidt).Rows[0]["IsClosedBound"]) == 4)
                    {
                        this.IsClosedBoundCheckBox.Checked = true;
                    }
                }

                // clear the fields...
                this.PollExpire.Text = string.Empty;
                this.Question.Text   = string.Empty;
            }

            // we add dummy rows to data table to fill in repeater empty fields
            int dummyRowsCount = this.PageContext.BoardSettings.AllowedPollChoiceNumber - allExistingRowsCount - 1;

            for (int i = 0; i <= dummyRowsCount; i++)
            {
                DataRow drow = this._choices.NewRow();
                drow["ChoiceOrderID"] = existingRowsCount + i;
                this._choices.Rows.Add(drow);
            }

            // Bind choices repeater
            this.ChoiceRepeater.DataSource = this._choices;
            this.ChoiceRepeater.DataBind();
            this.ChoiceRepeater.Visible = true;

            // Show controls
            this.SavePoll.Visible                = true;
            this.Cancel.Visible                  = true;
            this.PollRow1.Visible                = true;
            this.PollRowExpire.Visible           = true;
            this.IsClosedBound.Visible           = this.IsBound.Visible = PageContext.BoardSettings.AllowUsersHidePollResults || PageContext.IsAdmin || PageContext.IsForumModerator;
            this.tr_AllowMultipleChoices.Visible = PageContext.BoardSettings.AllowMultipleChoices || PageContext.IsAdmin || PageContext.IsForumModerator;
        }
Ejemplo n.º 17
0
        private void BindData()
        {
            int userID = ( int )Security.StringToLongOrRedirect(Request.QueryString ["u"]);

            MembershipUser user = UserMembershipHelper.GetMembershipUser(userID);

            if (user == null)
            {
                YafBuildLink.AccessDenied(/*No such user exists*/);
            }

            YafCombinedUserData userData = new YafCombinedUserData(user, userID);

            // populate user information controls...
            UserName.Text        = HtmlEncode(userData.Membership.UserName);
            Name.Text            = HtmlEncode(userData.Membership.UserName);
            Joined.Text          = String.Format("{0}", YafDateTime.FormatDateLong(Convert.ToDateTime(userData.Joined)));
            LastVisit.Text       = YafDateTime.FormatDateTime(userData.LastVisit);
            Rank.Text            = userData.RankName;
            Location.Text        = HtmlEncode(General.BadWordReplace(userData.Profile.Location));
            RealName.InnerHtml   = HtmlEncode(General.BadWordReplace(userData.Profile.RealName));
            Interests.InnerHtml  = HtmlEncode(General.BadWordReplace(userData.Profile.Interests));
            Occupation.InnerHtml = HtmlEncode(General.BadWordReplace(userData.Profile.Occupation));
            Gender.InnerText     = GetText("GENDER" + userData.Profile.Gender);

            PageLinks.Clear();
            PageLinks.AddLink(PageContext.BoardSettings.Name, YAF.Classes.Utils.YafBuildLink.GetLink(YAF.Classes.Utils.ForumPages.forum));
            PageLinks.AddLink(GetText("MEMBERS"), YAF.Classes.Utils.YafBuildLink.GetLink(YAF.Classes.Utils.ForumPages.members));
            PageLinks.AddLink(userData.Membership.UserName, "");

            double dAllPosts = 0.0;

            if (SqlDataLayerConverter.VerifyInt32(userData.DBRow["NumPostsForum"]) > 0)
            {
                dAllPosts = 100.0 * SqlDataLayerConverter.VerifyInt32(userData.DBRow["NumPosts"]) / SqlDataLayerConverter.VerifyInt32(userData.DBRow["NumPostsForum"]);
            }

            Stats.InnerHtml = String.Format("{0:N0}<br/>[{1} / {2}]",
                                            userData.DBRow ["NumPosts"],
                                            String.Format(GetText("NUMALL"), dAllPosts),
                                            String.Format(GetText("NUMDAY"), (double)SqlDataLayerConverter.VerifyInt32(userData.DBRow["NumPosts"]) / SqlDataLayerConverter.VerifyInt32(userData.DBRow["NumDays"]))
                                            );

            // private messages
            ///CHANGED THIS ON 12/1/2010
            //PM.Visible = !userData.IsGuest && User != null && PageContext.BoardSettings.AllowPrivateMessages;
            PM.Visible = false;

            PM.NavigateUrl = YafBuildLink.GetLinkNotEscaped(YAF.Classes.Utils.ForumPages.pmessage, "u={0}", userData.UserID);

            // email link
            Email.Visible     = !userData.IsGuest && User != null && PageContext.BoardSettings.AllowEmailSending;
            Email.NavigateUrl = YafBuildLink.GetLinkNotEscaped(YAF.Classes.Utils.ForumPages.im_email, "u={0}", userData.UserID);
            if (PageContext.IsAdmin)
            {
                Email.TitleNonLocalized = userData.Membership.Email;
            }

            // homepage link
            Home.Visible = !String.IsNullOrEmpty(userData.Profile.Homepage);
            SetupThemeButtonWithLink(Home, userData.Profile.Homepage);

            // blog link
            Blog.Visible = !String.IsNullOrEmpty(userData.Profile.Blog);
            SetupThemeButtonWithLink(Blog, userData.Profile.Blog);

            MSN.Visible     = (User != null && !String.IsNullOrEmpty(userData.Profile.MSN));
            MSN.NavigateUrl = YAF.Classes.Utils.YafBuildLink.GetLink(YAF.Classes.Utils.ForumPages.im_email, "u={0}", userData.UserID);

            YIM.Visible     = (User != null && !String.IsNullOrEmpty(userData.Profile.YIM));
            YIM.NavigateUrl = YAF.Classes.Utils.YafBuildLink.GetLink(YAF.Classes.Utils.ForumPages.im_yim, "u={0}", userData.UserID);

            AIM.Visible     = (User != null && !String.IsNullOrEmpty(userData.Profile.AIM));
            AIM.NavigateUrl = YAF.Classes.Utils.YafBuildLink.GetLink(YAF.Classes.Utils.ForumPages.im_aim, "u={0}", userData.UserID);

            ICQ.Visible     = (User != null && !String.IsNullOrEmpty(userData.Profile.ICQ));
            ICQ.NavigateUrl = YAF.Classes.Utils.YafBuildLink.GetLink(YAF.Classes.Utils.ForumPages.im_icq, "u={0}", userData.UserID);

            Skype.Visible     = (User != null && !String.IsNullOrEmpty(userData.Profile.Skype));
            Skype.NavigateUrl = YAF.Classes.Utils.YafBuildLink.GetLink(YAF.Classes.Utils.ForumPages.im_skype, "u={0}", userData.UserID);

            // localize tab titles...
            AboutTab.HeaderText       = GetText("ABOUT");
            StatisticsTab.HeaderText  = GetText("STATISTICS");
            AvatarTab.HeaderText      = GetText("AVATAR");
            Last10PostsTab.HeaderText = GetText("LAST10");

            if (PageContext.BoardSettings.AvatarUpload && userData.HasAvatarImage)
            {
                Avatar.ImageUrl = YafForumInfo.ForumRoot + "resource.ashx?u=" + (userID);
            }
            else if (!String.IsNullOrEmpty(userData.Avatar))                 // Took out PageContext.BoardSettings.AvatarRemote
            {
                Avatar.ImageUrl = String.Format("{3}resource.ashx?url={0}&width={1}&height={2}",
                                                Server.UrlEncode(userData.Avatar),
                                                PageContext.BoardSettings.AvatarWidth,
                                                PageContext.BoardSettings.AvatarHeight,
                                                YafForumInfo.ForumRoot);
            }
            else
            {
                Avatar.Visible    = false;
                AvatarTab.Visible = false;
            }

            Groups.DataSource = Roles.GetRolesForUser(UserMembershipHelper.GetUserNameFromID(userID));

            //EmailRow.Visible = PageContext.IsAdmin;
            ModerateTab.Visible     = PageContext.IsAdmin || PageContext.IsForumModerator;
            AdminUserButton.Visible = PageContext.IsAdmin;

            if (LastPosts.Visible)
            {
                LastPosts.DataSource   = YAF.Classes.Data.DB.post_last10user(PageContext.PageBoardID, Request.QueryString ["u"], PageContext.PageUserID);
                SearchUser.NavigateUrl = YAF.Classes.Utils.YafBuildLink.GetLinkNotEscaped(YAF.Classes.Utils.ForumPages.search,
                                                                                          "postedby={0}",
                                                                                          userData.Membership.UserName);
            }

            DataBind();
        }