Exemplo n.º 1
0
		/// <summary>
		/// Create the XML for the subscribedUsers list
		/// </summary>
		/// <param name="userID">ID of user whose list we want</param>
		/// <param name="skip">skip to this index in the list</param>
		/// <param name="show">show this many items in the list</param>
		/// <returns></returns>
		public bool CreateSubscribingUsersList(int userID, int skip, int show)
		{
			// check object is not already initialised
			if (userID <= 0 || show <= 0)
			{
				return false;
			}

			int count = show;

			XmlElement SubscribingUsersList = AddElementTag(RootElement, "SUBSCRIBINGUSERS-LIST");
			AddAttribute(SubscribingUsersList, "SKIP", skip);
			AddAttribute(SubscribingUsersList, "SHOW", show);

			using (IDnaDataReader dataReader = GetSubscribingUsersList(userID, skip, show + 1))	// Get +1 so we know if there are more left
			{
				// Check to see if we found anything
				string userName = String.Empty;
				if (dataReader.HasRows && dataReader.Read())
				{
					User subscribedTo = new User(InputContext);
                    subscribedTo.AddPrefixedUserXMLBlock(dataReader, userID, "subscribedTo", SubscribingUsersList);

                    _userAcceptsSubscriptions = dataReader.GetBoolean("SubscribedToAcceptSubscriptions");
                    
                    //Get the list from the second recordset
                    dataReader.NextResult();
                    if (dataReader.HasRows && dataReader.Read())
                    {
                        XmlElement users = CreateElement("USERS");
                        do
                        {
                            User subscribingUser = new User(InputContext);
                            int subscribingUserID = dataReader.GetInt32NullAsZero("UserID");

                            subscribingUser.AddUserXMLBlock(dataReader, subscribingUserID, users);

                            count--;

                        } while (count > 0 && dataReader.Read());	// dataReader.Read won't get called if count == 0

                        SubscribingUsersList.AppendChild(users);

                        // See if there's an extra row waiting
                        if (count == 0 && dataReader.Read())
                        {
                            AddAttribute(SubscribingUsersList, "MORE", 1);
                        }
                    }
				}
			}
			//AddAttribute(UserSubscriptionsList, "COUNT", count);

			return true;
		}
Exemplo n.º 2
0
        /*		    <FORUMSOURCE>
                        <JOURNAL>
                            <USER>
                                <USERID>6</USERID>
                                <USERNAME>Jim Lynn</USERNAME>
                            </USER>
                        </JOURNAL>
                    </FORUMSOURCE>
    				
                    or

                    <FORUMSOURCE>
                        <ARTICLE>
                            <H2G2ID>12345</H2G2ID>
                            <SUBJECT>Hello there</SUBJECT>
                        </ARTICLE>
                    </FORUMSOURCE>

                    or

                    <FORUMSOURCE>
                        <USERPAGE>
                            <USER>
                                <USERID>6</USERID>
                                <USERNAME>Jim Lynn</USERNAME>
                            </USER>
                        </USERPAGE>
                    </FORUMSOURCE>

                    or 

                    <FORUMSOURCE>
                        <CLUB ID= '1'>
                            <NAME>Dharmesh Club</NAME>
                        </CLUB>
                    </FORUMSOURCE> 
         */
        /// <summary>
        /// Builds an XML representation of the forum source, vis:
        /// </summary>
        /// <param name="forumID">ID of forum</param>
        /// <param name="threadID">ID of forum thread</param>
        /// <param name="includeArticle">flag to include article data</param>
        /// <param name="type">Type of forum</param>
        /// <param name="ID">ID either H2G2ID or club ID</param>
        /// <param name="title">Title</param>
        /// <param name="siteID">Site ID</param>
        /// <param name="url">URL involved</param>
        public void GetTitle(int forumID, int threadID, bool includeArticle, ref int type, ref int ID, ref string title, ref int siteID, ref string url)
        {
            string subject = "";	// Subject based on type found
            int userID = 0;
            int reviewForumID = 0;
            int alertInstantly = 0;
            int hiddenStatus = 0;
            int articleStatus = 0;
            int realForumID = 0;

            using (IDnaDataReader dataReader = InputContext.CreateDnaDataReader("getforumsource"))
            {
                dataReader.AddParameter("ForumID", forumID);
                dataReader.AddParameter("ThreadID", threadID);
                dataReader.AddParameter("CurrentSiteID", InputContext.CurrentSite.SiteID);
                dataReader.Execute();

                if (dataReader.HasRows && dataReader.Read())
                {
                    // Fill in return values
                    ID = dataReader.GetInt32NullAsZero("h2g2ID");
                    type = dataReader.GetInt32NullAsZero("Type");
                    hiddenStatus = dataReader.GetInt32NullAsZero("HiddenStatus");
                    articleStatus = dataReader.GetInt32NullAsZero("ArticleStatus");
                    alertInstantly = dataReader.GetInt32NullAsZero("AlertInstantly");
                    siteID = dataReader.GetInt32NullAsZero("SiteID");
                    realForumID = dataReader.GetInt32NullAsZero("ForumID");

                    reviewForumID = 0;
                    userID = 0;

                    if (dataReader.GetInt32NullAsZero("JournalOwner") > 0)
                    {
                        title = dataReader.GetStringNullAsEmpty("JournalUserName");
                        userID = dataReader.GetInt32NullAsZero("JournalOwner");
                    }
                    else if (dataReader.GetInt32NullAsZero("UserID") > 0)
                    {
                        title = dataReader.GetStringNullAsEmpty("UserName");
                        userID = dataReader.GetInt32NullAsZero("UserID");
                    }
                    else if (!dataReader.IsDBNull("ReviewForumID"))
                    {
                        title = dataReader.GetStringNullAsEmpty("ReviewForumName");
                        reviewForumID = dataReader.GetInt32NullAsZero("ReviewForumID");
                    }
                    else if (!dataReader.IsDBNull("URL"))
                    {
                        url = dataReader.GetStringNullAsEmpty("URL");
                    }
                    else
                    {
                        title = dataReader.GetStringNullAsEmpty("Subject");
                    }

                    XmlElement forumSource = AddElementTag(RootElement, "FORUMSOURCE");

                    if (type == 0)
                    {
                        AddAttribute(forumSource, "TYPE", "journal");

                        User journalOwner = new User(InputContext);
                        journalOwner.AddPrefixedUserXMLBlock(dataReader, userID, "Journal", forumSource);
                    }
                    else if (type == 3)
                    {
                        // It's a review forum
                        AddAttribute(forumSource, "TYPE", "reviewforum");

                        XmlElement reviewForum = AddElementTag(forumSource, "REVIEWFORUM");
                        AddAttribute(reviewForum, "ID", reviewForumID);
                        AddTextTag(reviewForum, "REVIEWFORUMNAME", subject);
                        AddTextTag(reviewForum, "URLFRIENDLYNAME", "RF" + reviewForumID.ToString());
                    }
                    else if (type == 1)
                    {
                        AddAttribute(forumSource, "TYPE", "article");
                    }
                    /*else if (type == 5)
                    {
                        AddAttribute(forumSource, "TYPE", "club");

                        XmlElement club = AddElementTag(forumSource, "CLUB");
                        AddAttribute(club, "ID", clubID);
                        AddTextTag(club, "NAME", subject);
                    }
                    else if (type == 6)
                    {
                        AddAttribute(forumSource, "TYPE", "clubforum");

                        XmlElement club = AddElementTag(forumSource, "CLUB");
                        AddAttribute(club, "ID", clubID);
                        AddTextTag(club, "NAME", subject);
                    }
                    else if (type == 7)
                    {
                        AddAttribute(forumSource, "TYPE", "clubjournal");

                        XmlElement club = AddElementTag(forumSource, "CLUB");
                        AddAttribute(club, "ID", clubID);
                        AddTextTag(club, "NAME", subject);
                    }*/
                    else if (type == 4)
                    {
                        AddAttribute(forumSource, "TYPE", "privateuser");
                        XmlElement userPage = AddElementTag(forumSource, "USERPAGE");
                        User user = new User(InputContext);
                        user.AddUserXMLBlock(dataReader, userID, userPage);
                    }
                    else if (type == 8)
                    {
                        AddAttribute(forumSource, "TYPE", "noticeboard");
                    }
                    else
                    {
                        AddAttribute(forumSource, "TYPE", "userpage");
                        XmlElement userPage = AddElementTag(forumSource, "USERPAGE");
                        User user = new User(InputContext);
                        user.AddUserXMLBlock(dataReader, userID, userPage);
                    }

                    if (ID > 0)
                    {
                        if (includeArticle)
                        {
                            GuideEntrySetup guideEntrySetup = new GuideEntrySetup(ID);
                            guideEntrySetup.ShowEntryData = true;
                            guideEntrySetup.ShowPageAuthors = true;
                            guideEntrySetup.ShowReferences = true;
                            guideEntrySetup.SafeToCache = true;

                            GuideEntry guideEntry = new GuideEntry(InputContext, guideEntrySetup);
                            if (!guideEntry.Initialise())
                            {
                                throw new DnaException("The article doesn't exist. " + ID.ToString());
                            }

                            if (!guideEntry.IsDeleted)
                            {
                                AddInside(guideEntry, "FORUMSOURCE");
                                XmlElement article = (XmlElement)forumSource.SelectSingleNode("ARTICLE");
                                AddIntElement(article, "H2G2ID", ID);
                            }
                            else
                            {
                                XmlElement deletedArticle = AddElementTag(forumSource, "ARTICLE");
                                AddIntElement(deletedArticle, "H2G2ID", ID);
                                AddTextTag(deletedArticle, "SUBJECT", "Deleted");
                                AddIntElement(deletedArticle, "HIDDEN", hiddenStatus);
                                XmlNode statusNode = AddTextTag(deletedArticle, "STATUS", GuideEntry.GetDescriptionForStatusValue(articleStatus));
                                AddAttribute(statusNode, "TYPE", articleStatus);
                            }
                        }
                        else
                        {
                            XmlElement defaultArticle = AddElementTag(forumSource, "ARTICLE");
                            AddIntElement(defaultArticle, "H2G2ID", ID);
                            AddTextTag(defaultArticle, "SUBJECT", subject);
                            AddIntElement(defaultArticle, "HIDDEN", hiddenStatus);
                            XmlNode statusNode = AddTextTag(defaultArticle, "STATUS", GuideEntry.GetDescriptionForStatusValue(articleStatus));
                            AddAttribute(statusNode, "TYPE", articleStatus);
                        }

                        AddIntElement(forumSource, "ALERTINSTANTLY", alertInstantly);
                    }
                }
            }
        }
Exemplo n.º 3
0
        /// <summary>
        /// Gets the journal forum
        /// </summary>
        /// <param name="journalID">The ID of the journal you want to get the list for</param>
        /// <param name="show">The number of threads you want to pull out</param>
        /// <param name="skip">The number of threads you want to skip</param>
        /// <param name="showUserHidden">Whether to show user hidden</param>
        public void GetJournal(int journalID, int show, int skip, bool showUserHidden)
        {
            if (journalID == 0)
            {
                // Now create the xml tree
                XmlElement journalPosts = AddElementTag(RootElement, "JOURNALPOSTS");

                // Add all the attributes for the JournalPosts node
                AddAttribute(journalPosts, "FORUMID", journalID);
                AddAttribute(journalPosts, "SKIPTO", skip);
                AddAttribute(journalPosts, "COUNT", show);

                AddAttribute(journalPosts, "TOTALTHREADS", 0);
                AddAttribute(journalPosts, "CANREAD", 1);
                AddAttribute(journalPosts, "CANWRITE", 0);

                return;
            }
            // Check to make sure we've been given acceptable values
            if (show > 200)
            {
                show = 200;
            }

            // Get the site that the forum belongs to
            int siteID = GetSiteIDForForum(journalID);

            // Get the most recent thread date
            DateTime expiryDate = GetMostRecentThreadDate(journalID);

            // Check to see if the journal is cached
            _cachedFileName = "J" + journalID.ToString() + "-" + skip.ToString() + "-" + Convert.ToString(skip + show - 1) + "-" + showUserHidden.ToString() + ".txt";
            string cachedJournal = "";
            if (InputContext.FileCacheGetItem("journal", _cachedFileName, ref expiryDate, ref cachedJournal) && cachedJournal.Length > 0)
            {
                // Create the journal from the cache
                CreateAndInsertCachedXML(cachedJournal, "JOURNALPOSTS", true);

                // Set the siteid from the tree
                if (RootElement.SelectSingleNode("//SITEID") != null)
                {
                    _siteID = Convert.ToInt32(RootElement.SelectSingleNode("//SITEID").Value);
                }

                // Set the forum field
                _forumID = journalID;

                // Update the users permissions
                FilterOnJournalPostPermissions(ForumID);

                // Finally update the relative dates and return
                UpdateRelativeDates();
                return;
            }

            // Not cached. Get the journal from the database and cache it if it's valid
            bool cacheResult = true;
            using (IDnaDataReader dataReader = InputContext.CreateDnaDataReader("forumlistjournalthreadswithreplies"))
            {
                dataReader.AddParameter("ForumID", journalID);
                dataReader.Execute();
                cacheResult = dataReader.HasRows;

                bool moreData = false;
                bool defaultCanRead = true;
                bool defaultCanWrite = true;
                int moderationStatus = 0;
                int totalThreads = 0;

                if (dataReader.Read())
                {
                    moreData = true;
                    defaultCanRead = dataReader.GetBoolean("CanRead");
                    defaultCanWrite = dataReader.GetBoolean("CanWrite");
                    moderationStatus = dataReader.GetInt32NullAsZero("ModerationStatus");
                    totalThreads = dataReader.GetInt32("ThreadCount");
                }

                // Now create the xml tree
                XmlElement journalPosts = AddElementTag(RootElement, "JOURNALPOSTS");

                // Add all the attributes for the JournalPosts node
                AddAttribute(journalPosts, "FORUMID", journalID);
                AddAttribute(journalPosts, "SKIPTO", skip);
                AddAttribute(journalPosts, "COUNT", show);

                AddAttribute(journalPosts, "TOTALTHREADS", totalThreads);
                AddAttribute(journalPosts, "CANREAD", Convert.ToInt32(defaultCanRead));
                AddAttribute(journalPosts, "CANWRITE", Convert.ToInt32(defaultCanWrite));

                if (skip > 0)
                {
                    //Read/skip over the skip number of rows so that the row that the first row that in the do below is 
                    //the one required
                    for (int i = 0; i < skip; i++)
                    {
                        moreData = dataReader.Read();
                    }
                }

                // Now add all the other info
                //XmlNode moderationNode = AddIntElement(forumThreadsNode, "MODERATIONSTATUS", moderationStatus);
                //AddAttribute(moderationNode, "ID", forumID);

                int numberOfPosts = show;
                while (moreData && numberOfPosts > 0 && totalThreads > 0)
                {
                    int threadID = dataReader.GetInt32NullAsZero("ThreadID");
                    int postID = dataReader.GetInt32NullAsZero("EntryID");
                    int userID = dataReader.GetInt32NullAsZero("UserID");
                    int count = dataReader.GetInt32NullAsZero("Cnt");
                    int hidden = dataReader.GetInt32NullAsZero("Hidden");

                    string subject = "";
                    string text = "";

                    //Allow author to view their own user-hidden items.
                    bool showHidden = (hidden == 7 && showUserHidden && InputContext.ViewingUser.UserID == userID);
                    if (hidden > 0 && !showHidden)
                    {
                        subject = "Hidden";
                        text = "This post has been hidden";
                    }
                    else
                    {
                        subject = dataReader.GetStringNullAsEmpty("Subject");
                        text = dataReader.GetStringNullAsEmpty("text");
                    }

                    // Add the text, checking to see what style it is
                    int postStyle = 0;
                    if (!dataReader.IsDBNull("PostStyle"))
                    {
                        postStyle = dataReader.GetTinyIntAsInt("PostStyle");
                    }
                    if (postStyle != 1)
                    {
                        text = ThreadPost.FormatPost(text, (CommentStatus.Hidden)hidden, true, false);

                        //text = StringUtils.ConvertPlainText(text);
                    }
                    else
                    {
                        //TODO Do we need Rich Post stuff for the post style??
                        string temp = "<RICHPOST>" + HtmlUtils.ReplaceCRsWithBRs(text) + "</RICHPOST>";
                        //Regex regex = new Regex(@"(<[^<>]+)<BR \/>");
                        //while (regex.Match(temp).Success)
                        //{
                        //    temp = regex.Replace(temp, @"$1 ");
                        //}
                        //text = temp;
                        text = HtmlUtils.TryParseToValidHtml(temp);
                    }

                    XmlElement post = AddElementTag(journalPosts, "POST");
                    AddAttribute(post, "POSTID", postID);
                    AddAttribute(post, "THREADID", threadID);
                    AddAttribute(post, "HIDDEN", hidden);
                    AddTextTag(post, "SUBJECT", subject);

                    AddDateXml(dataReader, post, "DATEPOSTED", "DatePosted");

                    if (count > 0)
                    {
                        AddDateXml(dataReader, post, "LASTREPLY", "LastReply");
                        XmlElement lastReplyTag = (XmlElement)post.SelectSingleNode("LASTREPLY");
                        AddAttribute(lastReplyTag, "COUNT", count);
                    }

                    User tempUser = new User(InputContext);
                    tempUser.AddUserXMLBlock(dataReader, userID, post);

                    AddXmlTextTag(post, "TEXT", text);

                    // Now check to see if we've got more posts
                    moreData = dataReader.Read();
                    numberOfPosts--;
                }
                if ((totalThreads > (skip + show)) && moreData)
                {
                    AddAttribute(journalPosts, "MORE", 1);
                }

                // Check to see if we're needed to cache the journal
                if (cacheResult)
                {
                    InputContext.FileCachePutItem("journal", _cachedFileName, journalPosts.OuterXml);
                }

                FilterOnJournalPostPermissions(journalID);

                UpdateRelativeDates();
            }
        }
Exemplo n.º 4
0
        /// <summary>
        /// Produce XML for users posts tagged to the specified node.
        /// </summary>
        /// <param name="nodeID">The node ID in question</param>
        /// <returns>An XML Element contain the list of users for a node</returns>
        public XmlElement GetUsersForNodeID(int nodeID)
        {
            // Check the NodeID!
            if (nodeID == 0)
            {
                throw new DnaException("Category - NoNodeIDGiven - Illegal NodeID (0)");
            }

            XmlElement userMemberList = CreateElement("USERMEMBERLIST");
            // Now get the list for the given list id
            using (IDnaDataReader reader = InputContext.CreateDnaDataReader("getusersfornode"))
            {
                reader.AddParameter("nodeID", nodeID);
                reader.AddParameter("siteID", InputContext.CurrentSite.SiteID);
                reader.Execute();

                if (reader.HasRows)
                {
                    int userMemberCount = 0;
                    while (reader.Read())
                    {                      
                        User user = new User(InputContext);
                        int userID = reader.GetInt32NullAsZero("UserID");
                        user.AddUserXMLBlock(reader, userID, userMemberList);

                        userMemberCount++;
                    }
                    AddIntElement(userMemberList, "USERMEMBERCOUNT", userMemberCount);
                }
            }
            return userMemberList;
        }
Exemplo n.º 5
0
        /// <summary>
        /// Method to generate POST XML and add to a parent node 
        /// </summary>
        /// <param name="reader">DataReader result of stored procedure returning forum post data.</param>
        /// <param name="component">DnaComponent to add posts to.</param>
        /// <param name="parentNode">Parent Node to xml the generated xml to.</param>
        /// <param name="context">The Input Context</param>
        public static void AddPostXml(IDnaDataReader reader, DnaComponent component, XmlNode parentNode, IInputContext context)
        {
            int hidden = 0;
            int inReplyTo = 0;
            int prevSibling = 0;
            int nextSibling = 0;
            int firstChild = 0;
            int userID = 0;
            int entryId = 0;
            int threadId = 0;
            int postIndex = 0;

            string subject = String.Empty;
            string datePosted = String.Empty;
            string bodyText = String.Empty;
            string hostPageUrl = String.Empty;
            string commentForumTitle = String.Empty;

            //get from db
            if (reader.DoesFieldExist("parent"))
            {
                inReplyTo = reader.GetInt32NullAsZero("parent");
            }
            if (reader.DoesFieldExist("prevSibling"))
            {
                prevSibling = reader.GetInt32NullAsZero("prevSibling");
            }
            if (reader.DoesFieldExist("nextSibling"))
            {
                nextSibling = reader.GetInt32NullAsZero("nextSibling");
            }
            if (reader.DoesFieldExist("firstChild"))
            {
                firstChild = reader.GetInt32NullAsZero("firstChild");
            }
            if (reader.DoesFieldExist("userID"))
            {
                userID = reader.GetInt32NullAsZero("userID");
            }
            if (reader.DoesFieldExist("hidden"))
            {
                hidden = reader.GetInt32NullAsZero("hidden");
            }

            subject = String.Empty;
            if (hidden == 3) // 3 means premoderated! - hidden!
            {
                subject = "Hidden";
            }
            else if (hidden > 0)
            {
                subject = "Removed";
            }
            else
            {
                subject = reader["subject"] as string;
                subject = StringUtils.EscapeAllXml(subject);
            }

            datePosted = String.Empty;
            if (reader["datePosted"] != DBNull.Value)
            {
                datePosted = reader["datePosted"].ToString();
            }

            bodyText = String.Empty;
            if (hidden == 3) // 3 means premoderated! - hidden!
            {
                bodyText = "This post has been hidden";
            }
            else if (hidden > 0)
            {
                bodyText = "This post has been Removed";
            }
            else
            {
                bodyText = reader.GetStringNullAsEmpty("text");
            }

            byte postStyle = reader.GetByteNullAsZero("postStyle");

            if (postStyle != 1)
            {
                bodyText = StringUtils.ConvertPlainText(bodyText);
            }
            else
            {
                //TODO Do we need Rich Post stuff for the post style??
                string temp = "<RICHPOST>" + bodyText.Replace("\r\n", "<BR />").Replace("\n", "<BR />") + "</RICHPOST>";
                //Regex regex = new Regex(@"(<[^<>]+)<BR \/>");
                //while (regex.Match(temp).Success)
                //{
                //    temp = regex.Replace(temp,@"$1 ");
                //}
                //bodyText = temp;
                bodyText = HtmlUtils.TryParseToValidHtml(temp);
            }

            if (reader.DoesFieldExist("hostpageurl"))
            {
                hostPageUrl = reader.GetStringNullAsEmpty("hostpageurl");
            }
            if (reader.DoesFieldExist("commentforumtitle"))
            {
                commentForumTitle = reader.GetStringNullAsEmpty("commentforumtitle");
            }

            if (reader.DoesFieldExist("entryID"))
            {
                entryId = reader.GetInt32NullAsZero("entryID");
            }

            if (reader.DoesFieldExist("threadID"))
            {
                threadId = reader.GetInt32NullAsZero("threadID");
            }

            if (reader.DoesFieldExist("postindex"))
            {
                postIndex = reader.GetInt32NullAsZero("postindex");
            }

            string canRead = String.Empty;
            if (reader.DoesFieldExist("canRead"))
            {
                canRead = reader.GetByteNullAsZero("canRead").ToString();
            }
            string canWrite = String.Empty;
            if (reader.DoesFieldExist("canWrite"))
            {
                canWrite = reader.GetByteNullAsZero("canWrite").ToString();
            }


            XmlNode post = component.CreateElementNode("POST");
            User user = new User(context);
            user.AddUserXMLBlock(reader, userID, post);

            AddPostXmlInternal(component, parentNode, context, hidden, inReplyTo, prevSibling, nextSibling, 
                firstChild, userID, subject, datePosted, bodyText, hostPageUrl, commentForumTitle, entryId, threadId,
                postIndex, canRead, canWrite, post.ChildNodes[0]);
        }
Exemplo n.º 6
0
        /// <summary>
        /// Helper method to create the list after a specific stored procedure
        ///		has been called to return an appropriate results set.
        /// </summary>
        /// <param name="dataReader">The data reader containing results</param>
        /// <param name="userlistXML">returned XmlElement</param>
        /// <param name="maxNumber">max number of rows to add</param>
        /// <param name="skip">number of rows to skip</param>
        /// <returns>true if successful, false if not.</returns>
        private bool CreateList(IDnaDataReader dataReader, ref XmlElement userlistXML, int maxNumber, int skip)
        {
            if (!dataReader.HasRows)
            {
                return false;
            }

            int numberShown = 0;

            if (skip > 0)
            {
                //Read/skip over the skip number of rows
                for (int i = 0; i < skip; i++)
                {
                    dataReader.Read();
                }
            }

            //add rows, assume that sp has limited the amount returned
            while (maxNumber > numberShown && dataReader.Read())           
            {
                User user = new User(InputContext);
                user.AddUserXMLBlock(dataReader, dataReader.GetInt32NullAsZero("USERID"), userlistXML);

                numberShown++;
            } 

            if (dataReader.Read())
            {
                AddAttribute(userlistXML, "MORE", 1);
            }

            AddAttribute(userlistXML, "COUNT", numberShown);

            return true;
        }