public string GetUpdatedUsers()
{
GetUpdatedUsers actionParams = JavaScriptConvert.DeserializeObject <GetUpdatedUsers>(JsonParams);
List <UserLogInfo> userLogList = ManyouApplications.GetUserLog(actionParams.Count);
List <UserInfoWithAction> userInfoWithActionList = new List <UserInfoWithAction>();
foreach (UserLogInfo userLogInfo in userLogList)
{
UserInfoWithAction userInfoWithAction = new UserInfoWithAction();
userInfoWithAction.Action = userLogInfo.Action.ToString();
if (userLogInfo.Action != UserLogActionEnum.Delete)
{
Discuz.Entity.UserInfo userInfo = Forum.Users.GetUserInfo(userLogInfo.UId);
userInfoWithAction.UserName = userInfo.Username;
}
userInfoWithAction.Action = userLogInfo.Action.ToString().ToLower();
userInfoWithAction.Uid = userLogInfo.UId;
userInfoWithActionList.Add(userInfoWithAction);
}
GetUpdateUsersResponse guuResponse = new GetUpdateUsersResponse();
guuResponse.TotalNum = userInfoWithActionList.Count >= actionParams.Count ? actionParams.Count * 2 : userInfoWithActionList.Count;
guuResponse.UserInfoWithActionList = userInfoWithActionList;
return(GetResult(guuResponse));
}
protected override void ShowPage()
{
pagetitle = "用户控制面板";
if (userid == -1)
{
AddErrLine("你尚未登录");
return;
}
user = Discuz.Forum.Users.GetUserInfo(userid);
if (!IsErr())
{
score = Scoresets.GetValidScoreName();
avatar = user.Avatar;
avatarurl = "";
avatartype = 1;
avatarwidth = 0;
avatarheight = 0;
if (Utils.CutString(avatar, 0, 15).ToLower().Equals(@"avatars\common\"))
{
avatartype = 0;
}
else if (Utils.CutString(avatar, 0, 7).ToLower().Equals("http://"))
{
avatarurl = avatar;
avatartype = 2;
avatarwidth = user.Avatarwidth;
avatarheight = user.Avatarheight;
}
}
}
protected override void ShowPage()
{
pagetitle = "用户控制面板";
if (userid == -1)
{
AddErrLine("你尚未登录");
return;
}
user = Users.GetUserInfo(userid);
//得到当前用户请求的页数
//获取主题总数
topiccount = Topics.GetMyUnauditTopicCount(user.Uid, -2);
//获取总页数
pagecount = topiccount % 16 == 0 ? topiccount / 16 : topiccount / 16 + 1;
pagecount = pagecount == 0 ? 1 : pagecount;
//修正请求页数中可能的错误
pageid = pageid < 1 ? 1 : pageid;
pageid = pageid > pagecount ? pagecount : pageid;
//查找需要审核的主题
topics = Topics.GetMyUnauditTopic(user.Uid, 16, pageid, -2);
pagenumbers = Utils.GetPageNumbers(pageid, pagecount, "myaudittopics.aspx", 8);
}
public string GetFriendInfo()
{
GetFriendInfoParams actionParams = JavaScriptConvert.DeserializeObject<GetFriendInfoParams>(JsonParams);
ShortUserInfo shortInfo = Forum.Users.GetShortUserInfo(actionParams.Uid);
UserInfo user = new UserInfo();
user.Uid = shortInfo.Uid;
user.UserName = shortInfo.Username;
GetFriendInfoResponse gfiResponse = new GetFriendInfoResponse();
gfiResponse.TotalNum = Forum.Friendship.GetUserFriendsCount(user.Uid);
gfiResponse.Me = user;
List<FriendshipInfo> friendshipList = Friendship.GetUserFriendsList(user.Uid, 1, actionParams.ShowFriendsNum);
List<Friend> friendList = new List<Friend>();
foreach (FriendshipInfo info in friendshipList)
{
friendList.Add(new Friend(info.FriendUid, info.FriendUserName.Trim()));
}
gfiResponse.Friends = friendList;
return GetResult(gfiResponse);
}
/// <summary>
/// 更新用户名
/// </summary>
/// <param name="userInfo">当前用户信息</param>
/// <param name="oldusername">以前用户的名称</param>
/// <returns></returns>
public static bool UserNameChange(UserInfo userInfo, string oldusername)
{
//将新主题表
Data.Topics.UpdateTopicLastPoster(userInfo.Uid, userInfo.Username);
Data.Topics.UpdateTopicPoster(userInfo.Uid, userInfo.Username);
//更新帖子表
//foreach (DataRow dr in Data.PostTables.GetAllPostTableName().Rows)
//{
Data.Posts.UpdatePostPoster(userInfo.Uid, userInfo.Username);
//}
//更新短消息
Data.PrivateMessages.UpdatePMSenderAndReceiver(userInfo.Uid, userInfo.Username);
//更新公告
Data.Announcements.UpdateAnnouncementPoster(userInfo.Uid, userInfo.Username);
//更新统计表中的信息
if (Data.Statistics.UpdateStatisticsLastUserName(userInfo.Uid, userInfo.Username) != 0)
{
Discuz.Cache.DNTCache.GetCacheService().RemoveObject("/Forum/Statistics");
}
//更新论坛版主相关信息
//foreach (DataRow dr in Data.Forums.GetModerators(oldusername).Rows)
//{
// string moderators = "," + dr["moderators"].ToString().Trim() + ",";
// if (moderators.IndexOf("," + oldusername + ",") >= 0)
// Forums.UpdateForumField(Utils.StrToInt(dr["fid"], 0),"moderators",dr["moderators"].ToString().Trim().Replace(oldusername, userInfo.Username));
//}
//更新版块版主的名字
Forums.UpdateModeratorName(oldusername, userInfo.Username);
return true;
}
protected override void ShowPage()
{
pagetitle = "用户控制面板";
if (userid == -1)
{
AddErrLine("你尚未登录");
return;
}
user = Users.GetUserInfo(userid);
//得到当前用户请求的页数
//获取主题总数
topiccount = Topics.GetTopicsCountbyUserId(userid, false);
//获取总页数
pagecount = topiccount % 16 == 0 ? topiccount / 16 : topiccount / 16 + 1;
pagecount = pagecount == 0 ? 1 : pagecount;
//修正请求页数中可能的错误
pageid = pageid < 1 ? 1 : pageid;
pageid = pageid > pagecount ? pagecount : pageid;
topics = Topics.GetTopicsByUserId(userid, pageid, 16, 600, config.Hottopic);
pagenumbers = Utils.GetPageNumbers(pageid, pagecount, "mytopics.aspx", 8);
}
protected override void ShowPage()
{
pagetitle = "用户控制面板";
if (userid == -1)
{
AddErrLine("你尚未登录");
return;
}
user = Discuz.Forum.Users.GetUserInfo(userid);
if (DNTRequest.IsPost())
{
string oldpassword = DNTRequest.GetString("oldpassword");
string newpassword = DNTRequest.GetString("newpassword");
string newpassword2 = DNTRequest.GetString("newpassword2");
if (Discuz.Forum.Users.CheckPassword(userid, oldpassword, true) == -1)
{
AddErrLine("你的原密码错误");
}
if (newpassword != newpassword2)
{
AddErrLine("新密码两次输入不一致");
}
if (newpassword.Equals(""))
{
newpassword = oldpassword;
}
if (newpassword.Length < 6)
{
AddErrLine("密码不得少于6个字符");
}
if (IsErr())
{
return;
}
else
{
//判断是否需要修改安全提问
Discuz.Forum.Users.UpdateUserPassword(userid, newpassword);
if (DNTRequest.GetString("changesecques") != "")
{
Discuz.Forum.Users.UpdateUserSecques(userid, DNTRequest.GetInt("question", 0), DNTRequest.GetString("answer"));
}
ForumUtils.WriteCookie("password",
ForumUtils.SetCookiePassword(Utils.MD5(newpassword), config.Passwordkey));
OnlineUsers.UpdatePassword(olid, Utils.MD5(newpassword));
SetUrl("usercpnewpassword.aspx");
SetMetaRefresh();
SetShowBackLink(true);
AddMsgLine("修改密码完毕, 同时已经更新了您的登录信息");
}
}
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="userInfo">要保存的用户信息(密码为明文)</param>
/// <returns>返回经过处理之后的实际用户信息</returns>
public UserInfo SaveUserInfo(UserInfo userInfo)
{
if (Utils.StrIsNullOrEmpty(userInfo.Salt))
userInfo.Salt = ForumUtils.CreateAuthStr(6, false);
userInfo.Password = GetEncryptedPassword(userInfo, userInfo.Password);
return Users.UpdateUser(userInfo) ? userInfo : null;
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="userInfo">要保存的用户信息(密码为明文)</param>
/// <returns>返回经过处理之后的实际用户信息</returns>
public UserInfo SaveUserInfo(UserInfo userInfo)
{
if(Utils.StrIsNullOrEmpty(userInfo.Salt))
userInfo.Salt = Forum.ForumUtils.CreateAuthStr(6,false);
userInfo.Password = Utils.MD5(Utils.MD5(userInfo.Password) + userInfo.Salt); //两遍MD5
return Discuz.Data.Users.UpdateUser(userInfo) ? userInfo : null;
}
/// <summary>
/// 检查密码
/// </summary>
/// <param name="userInfo">通过username获取的用户信息，用于进行密码验证</param>
/// <param name="postpassword">用户提交的密码</param>
/// <returns>返回当前用户信息与提交密码的验证结果</returns>
public bool CheckPassword(UserInfo userInfo, string postpassword)
{
if (userInfo == null)
{
return false;
}
var doubleMd5 = GetEncryptedPassword(userInfo, postpassword);
return doubleMd5 == userInfo.Password; //比较
}
protected override void ShowPage()
{
pagetitle = "查看用户信息";
if (usergroupinfo.Allowviewpro != 1)
{
AddErrLine(string.Format("您当前的身份 \"{0}\" 没有查看用户资料的权限", usergroupinfo.Grouptitle));
if (userid < 1)
needlogin = true;
return;
}
if (DNTRequest.GetString("username").Trim() == "" && DNTRequest.GetString("userid").Trim() == "")
{
AddErrLine("错误的URL链接");
return;
}
int id = DNTRequest.GetInt("userid", -1);
if (id == -1)
id = Users.GetUserId(Utils.UrlDecode(DNTRequest.GetString("username")));
if (id == -1)
{
AddErrLine("该用户不存在");
return;
}
user = Users.GetUserInfo(id);
if (user == null)
{
AddErrLine("该用户不存在");
return;
}
//用户设定Email保密时，清空用户的Email属性以避免被显示
if (user.Showemail != 1 && id != userid)
user.Email = "";
//获取积分机制和用户组信息，底层有缓存
score = Scoresets.GetValidScoreName();
group = UserGroups.GetUserGroupInfo(user.Groupid);
admininfo = AdminUserGroups.AdminGetAdminGroupInfo(usergroupid);
score1 = ((decimal)user.Extcredits1).ToString();
score2 = ((decimal)user.Extcredits2).ToString();
score3 = ((decimal)user.Extcredits3).ToString();
score4 = ((decimal)user.Extcredits4).ToString();
score5 = ((decimal)user.Extcredits5).ToString();
score6 = ((decimal)user.Extcredits6).ToString();
score7 = ((decimal)user.Extcredits7).ToString();
score8 = ((decimal)user.Extcredits8).ToString();
}
protected override void ShowPage()
{
pagetitle = "查看用户信息";
if (usergroupinfo.Allowviewpro != 1)
{
AddErrLine(string.Format("您当前的身份 \"{0}\" 没有查看用户资料的权限", usergroupinfo.Grouptitle));
if (userid < 1)
needlogin = true;
return;
}
if (DNTRequest.GetString("username").Trim() == "" && DNTRequest.GetString("userid").Trim() == "")
{
AddErrLine("错误的URL链接");
return;
}
int id = DNTRequest.GetInt("userid", -1);
if (id == -1)
{
id = Discuz.Forum.Users.GetUserID(Utils.UrlDecode(DNTRequest.GetString("username")));
}
if (id == -1)
{
AddErrLine("该用户不存在");
return;
}
user = Discuz.Forum.Users.GetUserInfo(id);
if (user == null)
{
AddErrLine("该用户不存在");
return;
}
//用户设定Email保密时，清空用户的Email属性以避免被显示
if (user.Showemail != 1)
{
user.Email = "";
}
//获取金币机制和用户组信息，底层有缓存
score = Scoresets.GetValidScoreName();
group = UserGroups.GetUserGroupInfo(user.Groupid);
admininfo = AdminUserGroups.AdminGetAdminGroupInfo(usergroupid);
}
/// <summary>
/// 返回相应用户扩展积分字段信息
/// </summary>
/// <param name="userInfo"></param>
/// <param name="extId"></param>
/// <returns></returns>
public static float GetUserExtCredit(UserInfo userInfo, int extId)
{
switch (extId)
{
case 1: return userInfo.Extcredits1;
case 2: return userInfo.Extcredits2;
case 3: return userInfo.Extcredits3;
case 4: return userInfo.Extcredits4;
case 5: return userInfo.Extcredits5;
case 6: return userInfo.Extcredits6;
case 7: return userInfo.Extcredits7;
case 8: return userInfo.Extcredits8;
default: return 0;
}
}
/// <summary>
/// 更新用户全部信息
/// </summary>
/// <param name="__userinfo"></param>
/// <returns></returns>
public static bool UpdateUserAllInfo(UserInfo userInfo)
{
Users.UpdateUser(userInfo);
//当用户不是版主(超级版主)或管理员
if ((userInfo.Adminid == 0) || (userInfo.Adminid > 3))
{
//删除用户在版主列表中相关数据
Data.Moderators.DeleteModerator(userInfo.Uid);
//同时更新版块相关的版主信息
UpdateForumsFieldModerators(userInfo.Username);
}
#region 以下为更新该用户的扩展信息
string signature = Utils.HtmlEncode(ForumUtils.BanWordFilter(userInfo.Signature));
UserGroupInfo usergroupinfo = AdminUserGroups.AdminGetUserGroupInfo(userInfo.Groupid);
GeneralConfigInfo config = GeneralConfigs.GetConfig();
PostpramsInfo postPramsInfo = new PostpramsInfo();
postPramsInfo.Usergroupid = usergroupinfo.Groupid;
postPramsInfo.Attachimgpost = config.Attachimgpost;
postPramsInfo.Showattachmentpath = config.Showattachmentpath;
postPramsInfo.Hide = 0;
postPramsInfo.Price = 0;
postPramsInfo.Sdetail = userInfo.Signature;
postPramsInfo.Smileyoff = 1;
postPramsInfo.Bbcodeoff = 1 - usergroupinfo.Allowsigbbcode;
postPramsInfo.Parseurloff = 1;
postPramsInfo.Showimages = usergroupinfo.Allowsigimgcode;
postPramsInfo.Allowhtml = 0;
postPramsInfo.Smiliesinfo = Smilies.GetSmiliesListWithInfo();
postPramsInfo.Customeditorbuttoninfo = Editors.GetCustomEditButtonListWithInfo();
postPramsInfo.Smiliesmax = config.Smiliesmax;
postPramsInfo.Signature = 1;
postPramsInfo.Onlinetimeout = config.Onlinetimeout;
userInfo.Signature = signature;
userInfo.Authstr = ForumUtils.CreateAuthStr(20);
userInfo.Sightml = UBB.UBBToHTML(postPramsInfo);
Users.UpdateUser(userInfo);
#endregion
Users.UpdateUserForumSetting(userInfo);
return true;
}
protected bool IsLogin()
{
if (userid == -1)
{
AddErrLine("你尚未登录");
return false;
}
user = Users.GetUserInfo(userid);
if (user == null)
{
AddErrLine("用户不存在");
return false;
}
return true;
}
/// <summary>
/// 绑定feed模板中的变量值
/// </summary>
/// <param name="template"></param>
/// <param name="dataJson"></param>
/// <param name="userInfo"></param>
/// <returns></returns>
public static string MergeFeedTemplateData(string template, string dataJson, UserInfo userInfo)
{
Dictionary<string, string> dataList = new Dictionary<string, string>();
if (!string.IsNullOrEmpty(dataJson))
dataList = JavaScriptConvert.DeserializeObject<Dictionary<string, string>>(dataJson);
string actorData = string.Format("<a href=\"{0}\">{1}</a>", Urls.UserInfoAspxRewrite(userInfo.Uid), userInfo.Username);
dataList.Add("actor", actorData);
foreach (string key in dataList.Keys)
{
template = template.Replace("{" + key + "}", dataList[key]);
}
return template;
}
public DiscuzSpaceUCBase()
{
OnlineUserInfo oluserinfo = OnlineUsers.UpdateInfo(config.Passwordkey, config.Onlinetimeout);
olid = oluserinfo.Olid;
userid = oluserinfo.Userid;
username = oluserinfo.Username;
_userinfo = Users.GetUserInfo(userid);
if(DNTRequest.GetInt("postid",0) > 0)
{
SpacePostInfo __spacepostinfo = BlogProvider.GetSpacepostsInfo(Space.Data.DbProvider.GetInstance().GetSpacePost(DNTRequest.GetInt("postid",0)));
spaceuid = __spacepostinfo != null? __spacepostinfo.Uid:0;
}
if(spaceuid > 0)
{
spaceconfiginfo = BlogProvider.GetSpaceConfigInfo(spaceuid);
spaceid = spaceconfiginfo.SpaceID;
}
else
{
if(spaceid > 0)
{
spaceuid=BlogProvider.GetUidBySpaceid(spaceid.ToString());
spaceconfiginfo = BlogProvider.GetSpaceConfigInfo(spaceuid);
}
}
if(spaceconfiginfo == null)
spaceconfiginfo = new SpaceConfigInfo();
pagesize = spaceconfiginfo.Bpp;
//去掉http地址中的文件名称
if (forumurl.ToLower().IndexOf("http://") == 0)
forumurlnopage = forumurl.Substring(0, forumurl.LastIndexOf('/')) + "/";
else
forumurl = "../" + forumurl;
if (configspaceurlnopage.ToLower().IndexOf("http://") < 0)
configspaceurlnopage = forumurlnopage;
else
configspaceurlnopage = configspaceurlnopage.ToLower().Substring(0, configspaceurlnopage.LastIndexOf('/')) + "/" ;
}
public string GetInfo()
{
GetUsersInfoParams actionParams = JavaScriptConvert.DeserializeObject<GetUsersInfoParams>(JsonParams);
if (!Utils.IsNumericList(actionParams.Uids))
throw new Exception("Params Exception!");
DataTable dt = Forum.Users.GetUserList(actionParams.UidArray.Length, 1, string.Format("[{0}users].[uid] IN({1})", BaseConfigs.GetTablePrefix, actionParams.Uids));
List<UserInfo> userList = new List<UserInfo>();
foreach (DataRow dr in dt.Rows)
{
UserInfo userInfo = new UserInfo();
userInfo.Uid = TypeConverter.ObjectToInt(dr["uid"]);
userInfo.UserName = dr["username"].ToString().Trim();
userList.Add(userInfo);
}
return GetResult(userList);
}
/// <summary>
/// 更新用户名
/// </summary>
/// <param name="__userinfo">当前用户信息</param>
/// <param name="oldusername">以前用户的名称</param>
/// <returns></returns>
public static bool UserNameChange(UserInfo __userinfo, string oldusername)
{
//将新主题表
DatabaseProvider.GetInstance().UpdateTopicLastPoster(__userinfo.Uid, __userinfo.Username);
DatabaseProvider.GetInstance().UpdateTopicPoster(__userinfo.Uid, __userinfo.Username);
//更新帖子表
foreach (DataRow dr in DatabaseProvider.GetInstance().GetTableListIds())
{
DatabaseProvider.GetInstance().UpdatePostPoster(__userinfo.Uid, __userinfo.Username, dr["id"].ToString());
}
//更新短消息
DatabaseProvider.GetInstance().UpdatePMSender(__userinfo.Uid, __userinfo.Username);
DatabaseProvider.GetInstance().UpdatePMReceiver(__userinfo.Uid, __userinfo.Username);
//更新公告
DatabaseProvider.GetInstance().UpdateAnnouncementPoster(__userinfo.Uid, __userinfo.Username);
//更新统计表中的信息
if (DatabaseProvider.GetInstance().HasStatisticsByLastUserId(__userinfo.Uid))
{
DatabaseProvider.GetInstance().UpdateStatisticsLastUserName(__userinfo.Uid, __userinfo.Username);
//更新缓存
Discuz.Cache.DNTCache.GetCacheService().RemoveObject("/Statistics");
}
//更新论坛版主相关信息
foreach (DataRow dr in DatabaseProvider.GetInstance().GetModerators(oldusername))
{
string moderators = "," + dr["moderators"].ToString().Trim() + ",";
if (moderators.IndexOf("," + oldusername + ",") >= 0)
{
DatabaseProvider.GetInstance().UpdateModerators(Utils.StrToInt(dr["fid"], 0), dr["moderators"].ToString().Trim().Replace(oldusername, __userinfo.Username));
}
}
return true;
}
protected override void ShowPage()
{
pagetitle = "用户控制面板";
if (userid == -1)
{
AddErrLine("你尚未登录");
return;
}
user = Discuz.Forum.Users.GetUserInfo(userid);
//得到当前用户请求的页数
pageid = DNTRequest.GetInt("page", 1);
//获取主题总数
payoutlogcount = PaymentLogs.GetPaymentLogOutRecordCount(userid);
//获取总页数
pagecount = payoutlogcount%pagesize==0 ? payoutlogcount/pagesize : payoutlogcount/pagesize + 1;
if (pagecount == 0)
{
pagecount = 1;
}
//修正请求页数中可能的错误
if (pageid < 1)
{
pageid = 1;
}
if (pageid > pagecount)
{
pageid = pagecount;
}
//获取收入记录并分页显示
payloglist = PaymentLogs.GetPayLogOutList(pagesize,pageid,userid);
pagenumbers = Utils.GetPageNumbers(pageid, pagecount, "usercpcreditspayoutlog.aspx", 8);
}
protected override void ShowPage()
{
if (config.Enablemall == 0) //未启用交易服务
{
AddErrLine("系统未开启交易服务, 当前页面暂时无法访问!");
return;
}
int uid = DNTRequest.GetInt("uid", 0);
if (uid <= 0)
{
AddErrLine("无效的用户id.");
return;
}
userinfo = Users.GetUserInfo(uid);
if (userinfo != null)
joindate = Convert.ToDateTime(userinfo.Joindate).ToString("yyyy-MM-dd");
sb_usercredit = GoodsUserCredits.GetUserCreditJsonData(uid);
creditrulesjsondata = GoodsUserCredits.GetCreditRulesJsonData().ToString();
}
protected override void ShowPage()
{
pagetitle = "用户控制面板";
if (userid == -1)
{
AddErrLine("你尚未登录");
return;
}
user = Discuz.Forum.Users.GetUserInfo(userid);
receivepmsetting = (int) user.Newsletter;
if (DNTRequest.IsPost())
{
user.Pmsound = DNTRequest.GetInt("pmsound", 0);
receivepmsetting = 1;
foreach (string rpms in DNTRequest.GetString("receivesetting").Split(','))
{
if (rpms != string.Empty)
{
int tmp = int.Parse(rpms);
receivepmsetting = receivepmsetting | tmp;
}
}
user.Newsletter = (ReceivePMSettingType) receivepmsetting;
Discuz.Forum.Users.UpdateUserPMSetting(user);
ForumUtils.WriteCookie("pmsound", user.Pmsound.ToString());
SetUrl("usercppmset.aspx");
SetMetaRefresh();
SetShowBackLink(true);
AddMsgLine("短消息设置已成功更新");
}
}
protected override void ShowPage()
{
pagetitle = "用户控制面板";
if (userid == -1)
{
AddErrLine("你尚未登录");
return;
}
user = Users.GetUserInfo(userid);
attachmentcount = typeid > 0 ? Attachments.GetUserAttachmentCount(userid,typeid) : Attachments.GetUserAttachmentCount(userid);
pagecount = attachmentcount % 16 == 0 ? attachmentcount / 16 : attachmentcount / 16 + 1;
pagecount = pagecount == 0 ? 1 : pagecount;
//修正请求页数中可能的错误
pageid = pageid < 1 ? 1 : pageid;
pageid = pageid > pagecount ? pagecount :pageid;
myattachmentlist = Attachments.GetAttachmentByUid(userid, typeid, pageid, 16);
pagenumbers = Utils.GetPageNumbers(pageid, pagecount,typeid > 0 ? "myattachment.aspx?typeid=" + typeid : "myattachment.aspx", 10);
}
public void AddDebateDigg(int tid, int pid, int field, string ip, UserInfo userInfo)
{
DbParameter[] parms = {
DbHelper.MakeInParam("@tid", (DbType)SqlDbType.Int, 4, tid),
DbHelper.MakeInParam("@pid", (DbType)SqlDbType.Int, 4, pid),
DbHelper.MakeInParam("@debates", (DbType)SqlDbType.Int,4, field),
DbHelper.MakeInParam("@diggerip",(DbType)SqlDbType.VarChar,15,ip),
DbHelper.MakeInParam("@diggdatetime", (DbType)SqlDbType.DateTime, 8, DateTime.Now),
DbHelper.MakeInParam("@diggerid", (DbType)SqlDbType.Int, 4,userInfo.Uid),
DbHelper.MakeInParam("@digger", (DbType)SqlDbType.NChar, 20,userInfo.Username)
};
string commandText = string.Format("INSERT INTO [{0}debatediggs]([tid],[pid],[digger],[diggerid],[diggerip],[diggdatetime]) VALUES(@tid,@pid,@digger,@diggerid,@diggerip,@diggdatetime)",
BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
commandText = string.Format("UPDATE [{0}postdebatefields] SET [opinion]=@debates,[diggs]=[diggs]+1 WHERE [tid]=@tid AND [pid]=@pid",
BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
commandText = string.Format("UPDATE [{0}debates] SET {1}={1}+1 WHERE [tid]=@tid",
BaseConfigs.GetTablePrefix,
Enum.GetName(typeof(DebateType), field));
DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
}
public void UpdateUserPMSetting(UserInfo user)
{
IDataParameter[] parms = {
DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4, user.Uid),
DbHelper.MakeInParam("@pmsound", (DbType)SqlDbType.Int, 4, user.Pmsound),
DbHelper.MakeInParam("@newsletter", (DbType)SqlDbType.Int, 4, (int)user.Newsletter)
};
string sql = string.Format(@"UPDATE [{0}users] SET [pmsound]=@pmsound, [newsletter]=@newsletter WHERE [uid]=@uid", BaseConfigs.GetTablePrefix);
DbHelper.ExecuteNonQuery(CommandType.Text, sql, parms);
}
/// <summary>
/// 更新用户论坛设置
/// </summary>
/// <param name="__userinfo">用户信息</param>
/// <returns>如果用户不存在则返回false, 否则返回true</returns>
public void UpdateUserForumSetting(UserInfo __userinfo)
{
IDataParameter[] prams = {
DbHelper.MakeInParam("@uid",(DbType)SqlDbType.Int,4,__userinfo.Uid),
DbHelper.MakeInParam("@tpp",(DbType)SqlDbType.Int,4,__userinfo.Tpp),
DbHelper.MakeInParam("@ppp",(DbType)SqlDbType.Int,4,__userinfo.Ppp),
DbHelper.MakeInParam("@invisible",(DbType)SqlDbType.Int,4,__userinfo.Invisible),
DbHelper.MakeInParam("@customstatus",(DbType)SqlDbType.VarChar,30,__userinfo.Customstatus),
DbHelper.MakeInParam("@sigstatus", (DbType)SqlDbType.Int, 4, __userinfo.Sigstatus),
DbHelper.MakeInParam("@signature", (DbType)SqlDbType.NVarChar, 500, __userinfo.Signature),
DbHelper.MakeInParam("@sightml", (DbType)SqlDbType.NVarChar, 1000, __userinfo.Sightml)
};
DbHelper.ExecuteNonQuery(CommandType.StoredProcedure, BaseConfigs.GetTablePrefix + "updateuserforumsetting", prams);
}
/// <summary>
/// 更新指定用户的个人资料
/// </summary>
/// <param name="__userinfo">用户信息</param>
/// <returns>如果用户不存在则为false, 否则为true</returns>
public void UpdateUserProfile(UserInfo __userinfo)
{
IDataParameter[] prams = {
DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4, __userinfo.Uid),
DbHelper.MakeInParam("@nickname",(DbType)SqlDbType.Char,20,__userinfo.Nickname),
DbHelper.MakeInParam("@gender", (DbType)SqlDbType.Int, 4, __userinfo.Gender),
DbHelper.MakeInParam("@email", (DbType)SqlDbType.Char, 50, __userinfo.Email),
DbHelper.MakeInParam("@bday", (DbType)SqlDbType.Char, 10, __userinfo.Bday),
DbHelper.MakeInParam("@showemail", (DbType)SqlDbType.Int, 4, __userinfo.Showemail),
DbHelper.MakeInParam("@website", (DbType)SqlDbType.VarChar, 80, __userinfo.Website),
DbHelper.MakeInParam("@icq", (DbType)SqlDbType.VarChar, 12, __userinfo.Icq),
DbHelper.MakeInParam("@qq", (DbType)SqlDbType.VarChar, 12, __userinfo.Qq),
DbHelper.MakeInParam("@yahoo", (DbType)SqlDbType.VarChar, 40, __userinfo.Yahoo),
DbHelper.MakeInParam("@msn", (DbType)SqlDbType.VarChar, 40, __userinfo.Msn),
DbHelper.MakeInParam("@skype", (DbType)SqlDbType.VarChar, 40, __userinfo.Skype),
DbHelper.MakeInParam("@location", (DbType)SqlDbType.NVarChar, 30, __userinfo.Location),
DbHelper.MakeInParam("@bio", (DbType)SqlDbType.NVarChar, 500, __userinfo.Bio),
DbHelper.MakeInParam("@realname",(DbType)SqlDbType.NVarChar,10,__userinfo.Realname),
DbHelper.MakeInParam("@idcard",(DbType)SqlDbType.VarChar,20,__userinfo.Idcard),
DbHelper.MakeInParam("@mobile",(DbType)SqlDbType.VarChar,20,__userinfo.Mobile),
DbHelper.MakeInParam("@phone",(DbType)SqlDbType.VarChar,20,__userinfo.Phone)
};
DbHelper.ExecuteNonQuery(CommandType.StoredProcedure, BaseConfigs.GetTablePrefix + "updateuserprofile", prams);
}
/// <summary>
/// 创建新用户.
/// </summary>
/// <param name="__userinfo">用户信息</param>
/// <returns>返回用户ID, 如果已存在该用户名则返回-1</returns>
public int CreateUser(UserInfo __userinfo)
{
IDataParameter[] prams = {
DbHelper.MakeInParam("@username",(DbType)SqlDbType.Char,20,__userinfo.Username),
DbHelper.MakeInParam("@nickname",(DbType)SqlDbType.Char,20,__userinfo.Nickname),
DbHelper.MakeInParam("@password",(DbType)SqlDbType.Char,32,__userinfo.Password),
DbHelper.MakeInParam("@secques",(DbType)SqlDbType.Char,8,__userinfo.Secques),
DbHelper.MakeInParam("@gender",(DbType)SqlDbType.Int,4,__userinfo.Gender),
DbHelper.MakeInParam("@adminid",(DbType)SqlDbType.Int,4,__userinfo.Adminid),
DbHelper.MakeInParam("@groupid",(DbType)SqlDbType.SmallInt,2,__userinfo.Groupid),
DbHelper.MakeInParam("@groupexpiry",(DbType)SqlDbType.Int,4,__userinfo.Groupexpiry),
DbHelper.MakeInParam("@extgroupids",(DbType)SqlDbType.Char,60,__userinfo.Extgroupids),
DbHelper.MakeInParam("@regip",(DbType)SqlDbType.VarChar,0,__userinfo.Regip),
DbHelper.MakeInParam("@joindate",(DbType)SqlDbType.VarChar,0,__userinfo.Joindate),
DbHelper.MakeInParam("@lastip",(DbType)SqlDbType.Char,15,__userinfo.Lastip),
DbHelper.MakeInParam("@lastvisit",(DbType)SqlDbType.VarChar,0,__userinfo.Lastvisit),
DbHelper.MakeInParam("@lastactivity",(DbType)SqlDbType.VarChar,0,__userinfo.Lastactivity),
DbHelper.MakeInParam("@lastpost",(DbType)SqlDbType.VarChar,0,__userinfo.Lastpost),
DbHelper.MakeInParam("@lastpostid",(DbType)SqlDbType.Int,4,__userinfo.Lastpostid),
DbHelper.MakeInParam("@lastposttitle",(DbType)SqlDbType.VarChar,0,__userinfo.Lastposttitle),
DbHelper.MakeInParam("@posts",(DbType)SqlDbType.Int,4,__userinfo.Posts),
DbHelper.MakeInParam("@digestposts",(DbType)SqlDbType.SmallInt,2,__userinfo.Digestposts),
DbHelper.MakeInParam("@oltime",(DbType)SqlDbType.Int,2,__userinfo.Oltime),
DbHelper.MakeInParam("@pageviews",(DbType)SqlDbType.Int,4,__userinfo.Pageviews),
DbHelper.MakeInParam("@credits",(DbType)SqlDbType.Int,4,__userinfo.Credits),
DbHelper.MakeInParam("@extcredits1",(DbType)SqlDbType.Float,8,__userinfo.Extcredits1),
DbHelper.MakeInParam("@extcredits2",(DbType)SqlDbType.Float,8,__userinfo.Extcredits2),
DbHelper.MakeInParam("@extcredits3",(DbType)SqlDbType.Float,8,__userinfo.Extcredits3),
DbHelper.MakeInParam("@extcredits4",(DbType)SqlDbType.Float,8,__userinfo.Extcredits4),
DbHelper.MakeInParam("@extcredits5",(DbType)SqlDbType.Float,8,__userinfo.Extcredits5),
DbHelper.MakeInParam("@extcredits6",(DbType)SqlDbType.Float,8,__userinfo.Extcredits6),
DbHelper.MakeInParam("@extcredits7",(DbType)SqlDbType.Float,8,__userinfo.Extcredits7),
DbHelper.MakeInParam("@extcredits8",(DbType)SqlDbType.Float,8,__userinfo.Extcredits8),
DbHelper.MakeInParam("@avatarshowid",(DbType)SqlDbType.Int,4,__userinfo.Avatarshowid),
DbHelper.MakeInParam("@email",(DbType)SqlDbType.Char,50,__userinfo.Email),
DbHelper.MakeInParam("@bday",(DbType)SqlDbType.VarChar,0,__userinfo.Bday),
DbHelper.MakeInParam("@sigstatus",(DbType)SqlDbType.Int,4,__userinfo.Sigstatus),
DbHelper.MakeInParam("@tpp",(DbType)SqlDbType.Int,4,__userinfo.Tpp),
DbHelper.MakeInParam("@ppp",(DbType)SqlDbType.Int,4,__userinfo.Ppp),
DbHelper.MakeInParam("@templateid",(DbType)SqlDbType.SmallInt,2,__userinfo.Templateid),
DbHelper.MakeInParam("@pmsound",(DbType)SqlDbType.Int,4,__userinfo.Pmsound),
DbHelper.MakeInParam("@showemail",(DbType)SqlDbType.Int,4,__userinfo.Showemail),
DbHelper.MakeInParam("@newsletter",(DbType)SqlDbType.Int,4,__userinfo.Newsletter),
DbHelper.MakeInParam("@invisible",(DbType)SqlDbType.Int,4,__userinfo.Invisible),
//DbHelper.MakeInParam("@timeoffset",(DbType)SqlDbType.Char,4,__userinfo.Timeoffset),
DbHelper.MakeInParam("@newpm",(DbType)SqlDbType.Int,4,__userinfo.Newpm),
DbHelper.MakeInParam("@accessmasks",(DbType)SqlDbType.Int,4,__userinfo.Accessmasks),
//
DbHelper.MakeInParam("@website",(DbType)SqlDbType.VarChar,80,__userinfo.Website),
DbHelper.MakeInParam("@icq",(DbType)SqlDbType.VarChar,12,__userinfo.Icq),
DbHelper.MakeInParam("@qq",(DbType)SqlDbType.VarChar,12,__userinfo.Qq),
DbHelper.MakeInParam("@yahoo",(DbType)SqlDbType.VarChar,40,__userinfo.Yahoo),
DbHelper.MakeInParam("@msn",(DbType)SqlDbType.VarChar,40,__userinfo.Msn),
DbHelper.MakeInParam("@skype",(DbType)SqlDbType.VarChar,40,__userinfo.Skype),
DbHelper.MakeInParam("@location",(DbType)SqlDbType.VarChar,30,__userinfo.Location),
DbHelper.MakeInParam("@customstatus",(DbType)SqlDbType.VarChar,30,__userinfo.Customstatus),
DbHelper.MakeInParam("@avatar",(DbType)SqlDbType.VarChar,255,__userinfo.Avatar),
DbHelper.MakeInParam("@avatarwidth",(DbType)SqlDbType.Int,4,__userinfo.Avatarwidth),
DbHelper.MakeInParam("@avatarheight",(DbType)SqlDbType.Int,4,__userinfo.Avatarheight),
DbHelper.MakeInParam("@medals",(DbType)SqlDbType.VarChar,40, __userinfo.Medals),
DbHelper.MakeInParam("@bio",(DbType)SqlDbType.NVarChar,500,__userinfo.Bio),
DbHelper.MakeInParam("@signature",(DbType)SqlDbType.NVarChar,500,__userinfo.Signature),
DbHelper.MakeInParam("@sightml",(DbType)SqlDbType.NVarChar,1000,__userinfo.Sightml),
DbHelper.MakeInParam("@authstr",(DbType)SqlDbType.VarChar,20,__userinfo.Authstr),
DbHelper.MakeInParam("@realname",(DbType)SqlDbType.NVarChar,10,__userinfo.Realname),
DbHelper.MakeInParam("@idcard",(DbType)SqlDbType.VarChar,20,__userinfo.Idcard),
DbHelper.MakeInParam("@mobile",(DbType)SqlDbType.VarChar,20,__userinfo.Mobile),
DbHelper.MakeInParam("@phone",(DbType)SqlDbType.VarChar,20,__userinfo.Phone)
};
return Utils.StrToInt(DbHelper.ExecuteScalar(CommandType.StoredProcedure, BaseConfigs.GetTablePrefix + "createuser", prams), -1);
}
public void CombinationUser(string posttablename, UserInfo __targetuserinfo, UserInfo __srcuserinfo)
{
IDataParameter[] prams = {
DbHelper.MakeInParam("@target_uid", (DbType)SqlDbType.Int, 4, __targetuserinfo.Uid),
DbHelper.MakeInParam("@target_username", (DbType)SqlDbType.NChar, 20, __targetuserinfo.Username.Trim()),
DbHelper.MakeInParam("@src_uid", (DbType)SqlDbType.Int, 4, __srcuserinfo.Uid)
};
DbHelper.ExecuteNonQuery(CommandType.Text, "UPDATE [" + BaseConfigs.GetTablePrefix + "topics] SET [posterid]=@target_uid,[poster]=@target_username WHERE [posterid]=@src_uid", prams);
DbHelper.ExecuteNonQuery(CommandType.Text, "UPDATE [" + posttablename + "] SET [posterid]=@target_uid,[poster]=@target_username WHERE [posterid]=@src_uid", prams);
DbHelper.ExecuteNonQuery(CommandType.Text, "UPDATE [" + BaseConfigs.GetTablePrefix + "pms] SET [msgtoid]=@target_uid,[msgto]=@target_username WHERE [msgtoid]=@src_uid", prams);
}
public void UpdateUserField(UserInfo __userinfo, string signature, string authstr, string sightml)
{
string sqlstring = "Update [" + BaseConfigs.GetTablePrefix + "userfields] Set website=@website,icq=@icq,qq=@qq,yahoo=@yahoo,msn=@msn,skype=@skype,location=@location,customstatus=@customstatus, avatar=@avatar," +
"avatarwidth=@avatarwidth , avatarheight=@avatarheight, medals=@medals, authstr=@authstr, authtime=@authtime, authflag=@authflag,bio=@bio, signature=@signature,sightml=@sightml,realname=@Realname,idcard=@Idcard,mobile=@Mobile,phone=@Phone Where uid=@uid";
IDataParameter[] prams1 = {
DbHelper.MakeInParam("@website", (DbType)SqlDbType.NVarChar, 80, __userinfo.Website),
DbHelper.MakeInParam("@icq", (DbType)SqlDbType.VarChar, 12, __userinfo.Icq),
DbHelper.MakeInParam("@qq", (DbType)SqlDbType.VarChar, 12, __userinfo.Qq),
DbHelper.MakeInParam("@yahoo", (DbType)SqlDbType.VarChar, 40, __userinfo.Yahoo),
DbHelper.MakeInParam("@msn", (DbType)SqlDbType.VarChar, 40, __userinfo.Msn),
DbHelper.MakeInParam("@skype", (DbType)SqlDbType.VarChar, 40, __userinfo.Skype),
DbHelper.MakeInParam("@location", (DbType)SqlDbType.NVarChar, 50, __userinfo.Location),
DbHelper.MakeInParam("@customstatus", (DbType)SqlDbType.NVarChar, 50, __userinfo.Customstatus),
DbHelper.MakeInParam("@avatar", (DbType)SqlDbType.NVarChar, 255, __userinfo.Avatar),
DbHelper.MakeInParam("@avatarwidth", (DbType)SqlDbType.Int, 4, __userinfo.Avatarwidth),
DbHelper.MakeInParam("@avatarheight", (DbType)SqlDbType.Int, 4, __userinfo.Avatarheight),
DbHelper.MakeInParam("@medals", (DbType)SqlDbType.VarChar, 300, __userinfo.Medals),
DbHelper.MakeInParam("@authstr", (DbType)SqlDbType.VarChar, 20, authstr),
DbHelper.MakeInParam("@authtime", (DbType)SqlDbType.SmallDateTime, 4, __userinfo.Authtime),
DbHelper.MakeInParam("@authflag", (DbType)SqlDbType.TinyInt, 1, 1),
DbHelper.MakeInParam("@bio", (DbType)SqlDbType.NVarChar, 500, __userinfo.Bio.ToString()),
DbHelper.MakeInParam("@signature", (DbType)SqlDbType.NVarChar, 500, signature),
DbHelper.MakeInParam("@sightml", (DbType)SqlDbType.NVarChar, 1000, sightml),
DbHelper.MakeInParam("@Realname", (DbType)SqlDbType.NVarChar, 1000, __userinfo.Realname),
DbHelper.MakeInParam("@Idcard", (DbType)SqlDbType.NVarChar, 1000, __userinfo.Idcard),
DbHelper.MakeInParam("@Mobile", (DbType)SqlDbType.NVarChar, 1000, __userinfo.Mobile),
DbHelper.MakeInParam("@Phone", (DbType)SqlDbType.NVarChar, 1000, __userinfo.Phone),
DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4, __userinfo.Uid)
};
DbHelper.ExecuteNonQuery(CommandType.Text, sqlstring, prams1);
}
public void UpdateUserAllInfo(UserInfo userinfo)
{
string sqlstring = "Update [" + BaseConfigs.GetTablePrefix + "users] Set username=@username ,nickname=@nickname,secques=@secques,gender=@gender,adminid=@adminid,groupid=@groupid,groupexpiry=@groupexpiry,extgroupids=@extgroupids, regip=@regip," +
"joindate=@joindate , lastip=@lastip, lastvisit=@lastvisit, lastactivity=@lastactivity, lastpost=@lastpost, lastposttitle=@lastposttitle,posts=@posts, digestposts=@digestposts,oltime=@oltime,pageviews=@pageviews,credits=@credits," +
"avatarshowid=@avatarshowid, email=@email,bday=@bday,sigstatus=@sigstatus,tpp=@tpp,ppp=@ppp,templateid=@templateid,pmsound=@pmsound," +
"showemail=@showemail,newsletter=@newsletter,invisible=@invisible,newpm=@newpm,accessmasks=@accessmasks,extcredits1=@extcredits1,extcredits2=@extcredits2,extcredits3=@extcredits3,extcredits4=@extcredits4,extcredits5=@extcredits5,extcredits6=@extcredits6,extcredits7=@extcredits7,extcredits8=@extcredits8 Where uid=@uid";
IDataParameter[] prams = {
DbHelper.MakeInParam("@username", (DbType)SqlDbType.VarChar, 20, userinfo.Username),
DbHelper.MakeInParam("@nickname", (DbType)SqlDbType.VarChar, 10, userinfo.Nickname),
DbHelper.MakeInParam("@secques", (DbType)SqlDbType.VarChar, 8, userinfo.Secques),
DbHelper.MakeInParam("@gender", (DbType)SqlDbType.Int, 4, userinfo.Gender),
DbHelper.MakeInParam("@adminid", (DbType)SqlDbType.Int, 4, userinfo.Uid == 1 ? 1 : userinfo.Adminid),
DbHelper.MakeInParam("@groupid", (DbType)SqlDbType.SmallInt, 2, userinfo.Groupid),
DbHelper.MakeInParam("@groupexpiry", (DbType)SqlDbType.Int, 4, userinfo.Groupexpiry),
DbHelper.MakeInParam("@extgroupids", (DbType)SqlDbType.VarChar, 60, userinfo.Extgroupids),
DbHelper.MakeInParam("@regip", (DbType)SqlDbType.NChar, 15, userinfo.Regip),
DbHelper.MakeInParam("@joindate", (DbType)SqlDbType.SmallDateTime, 4, userinfo.Joindate),
DbHelper.MakeInParam("@lastip", (DbType)SqlDbType.NChar, 15, userinfo.Lastip),
DbHelper.MakeInParam("@lastvisit", (DbType)SqlDbType.DateTime, 8, userinfo.Lastvisit),
DbHelper.MakeInParam("@lastactivity", (DbType)SqlDbType.DateTime, 8, userinfo.Lastactivity),
DbHelper.MakeInParam("@lastpost", (DbType)SqlDbType.DateTime, 8, userinfo.Lastpost),
DbHelper.MakeInParam("@lastposttitle", (DbType)SqlDbType.NChar, 80, userinfo.Lastposttitle),
DbHelper.MakeInParam("@posts", (DbType)SqlDbType.Int, 4, userinfo.Posts),
DbHelper.MakeInParam("@digestposts", (DbType)SqlDbType.SmallInt, 2, userinfo.Digestposts),
DbHelper.MakeInParam("@oltime", (DbType)SqlDbType.Int, 4, userinfo.Oltime),
DbHelper.MakeInParam("@pageviews", (DbType)SqlDbType.Int, 4, userinfo.Pageviews),
DbHelper.MakeInParam("@credits", (DbType)SqlDbType.Decimal, 10, userinfo.Credits),
DbHelper.MakeInParam("@avatarshowid", (DbType)SqlDbType.Int, 4, userinfo.Avatarshowid),
DbHelper.MakeInParam("@email", (DbType)SqlDbType.NChar, 50, userinfo.Email.ToString()),
DbHelper.MakeInParam("@bday", (DbType)SqlDbType.NChar, 10, userinfo.Bday.ToString()),
DbHelper.MakeInParam("@sigstatus", (DbType)SqlDbType.Int, 4, userinfo.Sigstatus.ToString()),
DbHelper.MakeInParam("@tpp", (DbType)SqlDbType.Int, 4, userinfo.Tpp),
DbHelper.MakeInParam("@ppp", (DbType)SqlDbType.Int, 4, userinfo.Ppp),
DbHelper.MakeInParam("@templateid", (DbType)SqlDbType.Int, 4, userinfo.Templateid),
DbHelper.MakeInParam("@pmsound", (DbType)SqlDbType.Int, 4, userinfo.Pmsound),
DbHelper.MakeInParam("@showemail", (DbType)SqlDbType.Int, 4, userinfo.Showemail),
DbHelper.MakeInParam("@newsletter", (DbType)SqlDbType.Int, 4, userinfo.Newsletter),
DbHelper.MakeInParam("@invisible", (DbType)SqlDbType.Int, 4, userinfo.Invisible),
DbHelper.MakeInParam("@newpm", (DbType)SqlDbType.Int, 4, userinfo.Newpm),
DbHelper.MakeInParam("@accessmasks", (DbType)SqlDbType.Int, 4, userinfo.Accessmasks),
DbHelper.MakeInParam("@extcredits1", (DbType)SqlDbType.Decimal, 10, userinfo.Extcredits1),
DbHelper.MakeInParam("@extcredits2", (DbType)SqlDbType.Decimal, 10, userinfo.Extcredits2),
DbHelper.MakeInParam("@extcredits3", (DbType)SqlDbType.Decimal, 10, userinfo.Extcredits3),
DbHelper.MakeInParam("@extcredits4", (DbType)SqlDbType.Decimal, 10, userinfo.Extcredits4),
DbHelper.MakeInParam("@extcredits5", (DbType)SqlDbType.Decimal, 10, userinfo.Extcredits5),
DbHelper.MakeInParam("@extcredits6", (DbType)SqlDbType.Decimal, 10, userinfo.Extcredits6),
DbHelper.MakeInParam("@extcredits7", (DbType)SqlDbType.Decimal, 10, userinfo.Extcredits7),
DbHelper.MakeInParam("@extcredits8", (DbType)SqlDbType.Decimal, 10, userinfo.Extcredits8),
DbHelper.MakeInParam("@uid", (DbType)SqlDbType.Int, 4, userinfo.Uid)
};
DbHelper.ExecuteNonQuery(CommandType.Text, sqlstring, prams);
}
