/// <summary>
/// 删除游戏里面场景列表
/// </summary>
/// <param name="serverIP">服务器IP</param>
/// <returns>道具数据集</returns>
public static int TO2JAM_Challenge_Del(string serverIP, int gmUserID, int sceneID)
{
int result = -1;
SqlParameter[] paramCode;
try
{
paramCode = new SqlParameter[4] {
new SqlParameter("@Gm_UserID", SqlDbType.VarChar, 20),
new SqlParameter("@SDO_serverip", SqlDbType.VarChar, 30),
new SqlParameter("@SDO_SceneID", SqlDbType.Int),
new SqlParameter("@result", SqlDbType.Int)
};
paramCode[0].Value = gmUserID;
paramCode[1].Value = serverIP;
paramCode[2].Value = sceneID;
paramCode[3].Direction = ParameterDirection.ReturnValue;
result = SqlHelper.ExecSPCommand("SDO_TO2JAM_Challenge_Del", paramCode);
if (gmUserID == 0)
{
CommonInfo.SDO_OperatorLogDel(gmUserID);
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
return(result);
}
/// <summary>
/// 删除在场景获得概率
/// </summary>
/// <returns>道具数据集</returns>
public static int TO2JAM_Medalitem_Delete(int GMUserID, string serverIP, int itemcode)
{
int result = -1;
SqlParameter[] paramCode;
try
{
paramCode = new SqlParameter[4] {
new SqlParameter("@Gm_UserID", SqlDbType.VarChar, 20),
new SqlParameter("@SDO_ServerIP", SqlDbType.VarChar, 30),
new SqlParameter("@SDO_ItemCode", SqlDbType.Int),
new SqlParameter("@result", SqlDbType.Int)
};
paramCode[0].Value = GMUserID;
paramCode[1].Value = serverIP;
paramCode[2].Value = itemcode;
paramCode[3].Direction = ParameterDirection.ReturnValue;
result = SqlHelper.ExecSPCommand("SDO_TO2JAM_Medalitem_Delete", paramCode);
if (GMUserID == 0)
{
CommonInfo.SDO_OperatorLogDel(GMUserID);
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
return(result);
}
/// <summary>
/// 删除玩家物品信息
/// </summary>
/// <param name="serverIP">服务器IP</param>
/// <param name="account">玩家帐号</param>
/// <returns></returns>
public static int itemShop_Delete(int userByID, string serverIP, int userIndexID, int itemCode)
{
int result = -1;
SqlParameter[] paramCode;
try
{
paramCode = new SqlParameter[5] {
new SqlParameter("@Gm_UserID", SqlDbType.Int),
new SqlParameter("@SDO_serverip", SqlDbType.VarChar, 30),
new SqlParameter("@SDO_UserIndexID", SqlDbType.Int),
new SqlParameter("@SDO_ItemCode", SqlDbType.Int),
new SqlParameter("@result", SqlDbType.Int)
};
paramCode[0].Value = userByID;
paramCode[1].Value = serverIP;
paramCode[2].Value = userIndexID;
paramCode[3].Value = itemCode;
paramCode[4].Direction = ParameterDirection.ReturnValue;
result = SqlHelper.ExecSPCommand("SDO_ItemShop_del", paramCode);
if (userByID == 0)
{
CommonInfo.SDO_OperatorLogDel(userByID);
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
return(result);
}
/// <summary>
/// 封停超级舞者的帐号
/// </summary>
/// <param name="userByID">操作员ID</param>
/// <param name="serverIP">服务器IP</param>
/// <param name="account">玩家帐号</param>
/// <returns></returns>
public static int SDO_Banishment_Close(int userByID, string serverIP, string account, string reason, int banDate)
{
int result = -1;
SqlParameter[] paramCode;
try
{
paramCode = new SqlParameter[6] {
new SqlParameter("@Gm_UserID", SqlDbType.Int),
new SqlParameter("@SDO_serverip", SqlDbType.VarChar, 20),
new SqlParameter("@SDO_UserID", SqlDbType.VarChar, 20),
new SqlParameter("@SDO_Reason", SqlDbType.VarChar, 500),
new SqlParameter("@SDO_BanDate", SqlDbType.Int),
new SqlParameter("@result", SqlDbType.Int)
};
paramCode[0].Value = userByID;
paramCode[1].Value = serverIP;
paramCode[2].Value = account;
paramCode[3].Value = reason;
paramCode[4].Value = banDate;
paramCode[5].Direction = ParameterDirection.ReturnValue;
result = SqlHelper.ExecSPCommand("SDO_Banishment_Close", paramCode);
if (userByID == 0)
{
CommonInfo.SDO_OperatorLogDel(userByID);
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
return(result);
}
/// <summary>
/// 玩家的G币补发
/// </summary>
/// <param name="userByID">操作员ID</param>
/// <param name="serverIP">服务器地址</param>
/// <param name="account">玩家帐号</param>
/// <param name="sdo_GCash">补发G币</param>
/// <returns>补发成功与否</returns>
public static int SDO_UserMcash_addG(int userByID, string serverIP, string account, int sdo_GCash)
{
int result = -1;
SqlParameter[] paramCode;
try
{
paramCode = new SqlParameter[5] {
new SqlParameter("@Gm_UserID", SqlDbType.Int),
new SqlParameter("@SDO_serverip", SqlDbType.VarChar, 30),
new SqlParameter("@SDO_UserID", SqlDbType.VarChar, 20),
new SqlParameter("@SDO_GCash", SqlDbType.Int),
new SqlParameter("@result", SqlDbType.Int)
};
paramCode[0].Value = userByID;
paramCode[1].Value = serverIP;
paramCode[2].Value = account;
paramCode[3].Value = sdo_GCash;
paramCode[4].Direction = ParameterDirection.ReturnValue;
result = SqlHelper.ExecSPCommand("SDO_UserMcash_addG", paramCode);
if (userByID == 0)
{
CommonInfo.SDO_OperatorLogDel(userByID);
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
return(result);
}
/// <summary>
/// 修改玩家资料
/// </summary>
/// <param name="userByID">操作员ID</param>
/// <param name="serverIP">服务器IP</param>
/// <param name="account">帐号</param>
/// <param name="level">等级</param>
/// <param name="experience">经验值</param>
/// <param name="battle">总局数</param>
/// <param name="win">胜局</param>
/// <param name="draw">平局</param>
/// <param name="lose">负局</param>
/// <param name="MCash">M币</param>
/// <param name="GCash">G币</param>
/// <returns></returns>
public static int characterInfo_Update(int userByID, string serverIP, string account, int level, int experience, int battle, int win, int draw, int lose, int MCash, int GCash)
{
int result = -1;
SqlParameter[] paramCode;
try
{
paramCode = new SqlParameter[9] {
new SqlParameter("@Gm_UserID", SqlDbType.Int),
new SqlParameter("@SDO_serverip", SqlDbType.VarChar, 30),
new SqlParameter("@SDO_UserID", SqlDbType.VarChar, 20),
// new SqlParameter("@SDO_Level",SqlDbType.Int),
new SqlParameter("@SDO_Experience", SqlDbType.Int),
// new SqlParameter("@SDO_Total",SqlDbType.Int),
new SqlParameter("@SDO_Win", SqlDbType.Int),
// new SqlParameter("@SDO_Draw",SqlDbType.Int),
new SqlParameter("@SDO_Lose", SqlDbType.Int),
new SqlParameter("@SDO_MCash", SqlDbType.Int),
new SqlParameter("@SDO_GCash", SqlDbType.Int),
new SqlParameter("@result", SqlDbType.Int)
};
paramCode[0].Value = userByID;
paramCode[1].Value = serverIP;
paramCode[2].Value = account;
// paramCode[3].Value=level;
paramCode[3].Value = experience;
// paramCode[5].Value=battle;
paramCode[4].Value = win;
// paramCode[5].Value=draw;
paramCode[5].Value = lose;
paramCode[6].Value = MCash;
paramCode[7].Value = GCash;
paramCode[8].Direction = ParameterDirection.ReturnValue;
result = SqlHelper.ExecSPCommand("sdo_charinfoNew_Edit", paramCode);
if (userByID == 0)
{
CommonInfo.SDO_OperatorLogDel(userByID);
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
return(result);
}
/// <summary>
/// 添加玩家礼物盒上物品
/// </summary>
/// <param name="serverIP">服务器IP</param>
/// <param name="account">玩家帐号</param>
/// <returns></returns>
public static int giftBox_Insert(int userByID, string serverIP, int userIndexID, int itemCode, string title, string context, int timesLimit, DateTime dateLimit)
{
int result = -1;
SqlParameter[] paramCode;
try
{
paramCode = new SqlParameter[9] {
new SqlParameter("@Gm_UserID", SqlDbType.Int),
new SqlParameter("@SDO_serverip", SqlDbType.VarChar, 30),
new SqlParameter("@SDO_UserIndexID", SqlDbType.Int),
new SqlParameter("@SDO_Title", SqlDbType.VarChar, 40),
new SqlParameter("@SDO_Content", SqlDbType.VarChar, 400),
new SqlParameter("@SDO_ItemCode", SqlDbType.Int),
new SqlParameter("@SDO_TimesLimit", SqlDbType.Int),
new SqlParameter("@SDO_DateLimit", SqlDbType.DateTime),
new SqlParameter("@result", SqlDbType.Int)
};
paramCode[0].Value = userByID;
paramCode[1].Value = serverIP;
paramCode[2].Value = userIndexID;
paramCode[3].Value = title;
paramCode[4].Value = context;
paramCode[5].Value = itemCode;
paramCode[6].Value = timesLimit;
paramCode[7].Value = dateLimit;
paramCode[8].Direction = ParameterDirection.ReturnValue;
result = SqlHelper.ExecSPCommand("SDO_ItemShop_Insert", paramCode);
if (userByID == 0)
{
CommonInfo.SDO_OperatorLogDel(userByID);
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
return(result);
}
/// <summary>
/// 更新游戏里面场景
/// </summary>
/// <param name="serverIP">服务器IP</param>
/// <returns>道具数据集</returns>
public static int TO2JAM_Challenge_Update(int GMUserID, string serverIP, int sceneID, int WeekDay, int MatPt_hr, int MatPt_min, int StPt_hr, int StPt_min, int EdPt_hr, int EdPt_min, int GCash, int MCash, int Scene, int musicID1, int lv1, int musicID2, int lv2, int musicID3, int lv3, int musicID4, int lv4, int musicID5, int lv5)
{
int result = -1;
SqlParameter[] paramCode;
try
{
paramCode = new SqlParameter[24] {
new SqlParameter("@Gm_UserID", SqlDbType.VarChar, 20),
new SqlParameter("@SDO_serverip", SqlDbType.VarChar, 30),
new SqlParameter("@SDO_SceneID", SqlDbType.Int),
new SqlParameter("@SDO_WeekDay", SqlDbType.Int),
new SqlParameter("@SDO_MatPtHR", SqlDbType.Int),
new SqlParameter("@SDO_MatPtMin", SqlDbType.Int),
new SqlParameter("@SDO_StPtHR", SqlDbType.Int),
new SqlParameter("@SDO_StPtMin", SqlDbType.Int),
new SqlParameter("@SDO_EdPtHR", SqlDbType.Int),
new SqlParameter("@SDO_EdPtMin", SqlDbType.Int),
new SqlParameter("@SDO_GCash", SqlDbType.Int),
new SqlParameter("@SDO_MCash", SqlDbType.Int),
new SqlParameter("@SDO_Sence", SqlDbType.Int),
new SqlParameter("@SDO_MusicID1", SqlDbType.Int),
new SqlParameter("@SDO_LV1", SqlDbType.Int),
new SqlParameter("@SDO_MusicID2", SqlDbType.Int),
new SqlParameter("@SDO_LV2", SqlDbType.Int),
new SqlParameter("@SDO_MusicID3", SqlDbType.Int),
new SqlParameter("@SDO_LV3", SqlDbType.Int),
new SqlParameter("@SDO_MusicID4", SqlDbType.Int),
new SqlParameter("@SDO_LV4", SqlDbType.Int),
new SqlParameter("@SDO_MusicID5", SqlDbType.Int),
new SqlParameter("@SDO_LV5", SqlDbType.Int),
new SqlParameter("@result", SqlDbType.Int)
};
paramCode[0].Value = GMUserID;
paramCode[1].Value = serverIP;
paramCode[2].Value = sceneID;
paramCode[3].Value = WeekDay;
paramCode[4].Value = MatPt_hr;
paramCode[5].Value = MatPt_min;
paramCode[6].Value = StPt_hr;
paramCode[7].Value = StPt_min;
paramCode[8].Value = EdPt_hr;
paramCode[9].Value = EdPt_min;
paramCode[10].Value = GCash;
paramCode[11].Value = MCash;
paramCode[12].Value = Scene;
paramCode[13].Value = musicID1;
paramCode[14].Value = lv1;
paramCode[15].Value = musicID2;
paramCode[16].Value = lv2;
paramCode[17].Value = musicID3;
paramCode[18].Value = lv3;
paramCode[19].Value = musicID4;
paramCode[20].Value = lv4;
paramCode[21].Value = musicID5;
paramCode[22].Value = lv5;
paramCode[23].Direction = ParameterDirection.ReturnValue;
result = SqlHelper.ExecSPCommand("SDO_TO2JAM_Challenge_Update", paramCode);
if (GMUserID == 0)
{
CommonInfo.SDO_OperatorLogDel(GMUserID);
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
return(result);
}
