Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Mu Mobile [Release] Sv + client mu mobile 3.0 englist 95% by ackemina

Newbie Spellweaver
Joined
Mar 9, 2011
Messages
76
Reaction score
1
Hi Bro, Did you fixed your problem with regards to the diamond exchange in control panel? im having the same problem..

yes check user.dll using dnspy remove zoneid it causing the problem.
 
Newbie Spellweaver
Joined
Feb 3, 2018
Messages
44
Reaction score
2
yes check user.dll using dnspy remove zoneid it causing the problem.

You mean i need to remove the variable zoneid? it refers to server # right? can you please send to me your user.dll so that i compare to mine? thanks a lot..
 
Newbie Spellweaver
Joined
Mar 9, 2011
Messages
76
Reaction score
1
You mean i need to remove the variable zoneid? it refers to server # right? can you please send to me your user.dll so that i compare to mine? thanks a lot..

yes because when you check on your db there is no zoneid from that table you can remove it or add zoneid fields on your db.
 
Newbie Spellweaver
Joined
Mar 9, 2011
Messages
76
Reaction score
1
i check my t_inputlog and i have zoneid on the table bro

Here is where I remove the the zoneid originally there is zoneid on that string on t_tempmoney there is no zoneid


If you can't still find it just give me your user.dll i'll edit for you
 
Newbie Spellweaver
Joined
Feb 3, 2018
Messages
44
Reaction score
2
Here is where I remove the the zoneid originally there is zoneid on that string on t_tempmoney there is no zoneid


If you can't still find it just give me your user.dll i'll edit for you
I think we are using different user.dll. mine has this code

try
{
addmoney /= 10;
this.conn.Open();
string text = "insert t_tempmoney (uid, addmoney) VALUES (@uid, @addmoney); Select LAST_INSERT_ID();";
MySqlCommand mySqlCommand = new MySqlCommand(text, this.conn);
mySqlCommand.Parameters.AddWithValue("@uid", uid);
mySqlCommand.Parameters.AddWithValue("@addmoney", addmoney);
int num = Convert.ToInt32(mySqlCommand.ExecuteScalar());
string text2 = num + this.UnixTimeStampUTC(DateTime.Now).ToString();
text = "INSERT INTO t_order (order_no) VALUES (@orderid)";
mySqlCommand = new MySqlCommand(text, this.conn);
mySqlCommand.Parameters.AddWithValue("@orderid", text2);
mySqlCommand.ExecuteNonQuery();
string text3 = text2 + this.UnixTimeStampUTC(DateTime.Now).ToString();
text = "INSERT INTO t_inputlog (order_no, zoneid, inputtime, result, sign, time, u, amount, cporder_no) VALUES (@order_no, Zoneid, @inputtime, result, Sign, time, @u, @amount, @cporder_no)";
mySqlCommand = new MySqlCommand(text, this.conn);
mySqlCommand.Parameters.AddWithValue("@order_no", text2);
mySqlCommand.Parameters.AddWithValue( Zoneid", serverid);
mySqlCommand.Parameters.AddWithValue("@inputtime", DateTime.Now);
mySqlCommand.Parameters.AddWithValue( result", "success");
mySqlCommand.Parameters.AddWithValue( Sign", "keySignMasTerToan");
mySqlCommand.Parameters.AddWithValue( time", this.UnixTimeStampUTC(DateTime.Now));
mySqlCommand.Parameters.AddWithValue("@u", uid);
mySqlCommand.Parameters.AddWithValue("@amount", addmoney);
mySqlCommand.Parameters.AddWithValue("@cporder_no", text3);
mySqlCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
LogManager.WriteLog(2, ex.ToString());
}
finally
{
this.conn.Close();
}
 
Newbie Spellweaver
Joined
Feb 3, 2018
Messages
44
Reaction score
2
Here is where I remove the the zoneid originally there is zoneid on that string on t_tempmoney there is no zoneid


If you can't still find it just give me your user.dll i'll edit for you

i think we are using different kinds of user.dll bro. mine has this..


here's my user.dll
 
Newbie Spellweaver
Joined
Mar 9, 2011
Messages
76
Reaction score
1
i think we are using different kinds of user.dll bro. mine has this..


here's my user.dll

I see which files you are using?
 
Newbie Spellweaver
Joined
Feb 3, 2018
Messages
44
Reaction score
2
which web you are using Im using those files also muwww?

yes bro the same. i believe the part of adding records in t_tempmoney is incomplete. can you please send me your user.dll or that part so that i can add it on my own? thanks a lot...
 
Newbie Spellweaver
Joined
Mar 9, 2011
Messages
76
Reaction score
1
is there anyone here know how to enable festive event? could you please help me which files is corresponding to this event

thank you



yes bro the same. i believe the part of adding records in t_tempmoney is incomplete. can you please send me your user.dll or that part so that i can add it on my own? thanks a lot...

check your logs on your api folder you can find out where the problem is

here is the sample
2018-04-25 01:47:03: MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'zoneid' in 'field list'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at Users.Controllers.GameControl.AddTempMoney(Int32 serverid, PlatChongZhiInfo data, Int32 itemid, Int32 addmoney)
 
Newbie Spellweaver
Joined
Feb 3, 2018
Messages
44
Reaction score
2
is there anyone here know how to enable festive event? could you please help me which files is corresponding to this event

thank you





check your logs on your api folder you can find out where the problem is

here is the sample
2018-04-25 01:47:03: MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'zoneid' in 'field list'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at Users.Controllers.GameControl.AddTempMoney(Int32 serverid, PlatChongZhiInfo data, Int32 itemid, Int32 addmoney)

It doesnt return any error. my insert record in t_tempmoney only saving 2 fields and i believe that the problem.
 
Newbie Spellweaver
Joined
Mar 9, 2011
Messages
76
Reaction score
1
It doesnt return any error. my insert record in t_tempmoney only saving 2 fields and i believe that the problem.

try this one just remove zoneid or add from t_tempmoney fields it's up to you which one you prefer

 
Newbie Spellweaver
Joined
Feb 3, 2018
Messages
44
Reaction score
2
try this one just remove zoneid or add from t_tempmoney fields it's up to you which one you prefer


Anyway, you can activate festival event by going to Gameres\config\JieRiGift\MUJieRiType.xml
 
Newbie Spellweaver
Joined
Jun 10, 2012
Messages
25
Reaction score
0
Heeeelpp me!!
63fQC0k - [Release] Sv + client mu mobile 3.0 englist 95% by ackemina - RaGEZONE Forums
SOLVED!!. I HAVE OTHER PROBLEM

075tOwQ - [Release] Sv + client mu mobile 3.0 englist 95% by ackemina - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Last edited:
Joined
Jun 3, 2009
Messages
975
Reaction score
282
Anyway, you can activate festival event by going to Gameres\config\JieRiGift\MUJieRiType.xml

FYI: to Activate Festive Event
1. Set the date in database t_config table columnname
paramname = jieristartday
paramvalue = 2018-05-03 <- date when the Festive Event will be active.

2. You must set all active Festive Event which is declared here
Gameres\Config\JieRiGift\MUJieRiType.xml inside of this .xml there's all the active list of events and you must open each one by one and changed the

FromDate="2018-05-03 00:00:00" ToDate="2018-05-09 23:59:59" AwardStartDate="2018-05-03 00:00:00" AwardEndDate="2018-05-03 23:59:59" />

Date of festive event start and end date.
 
Newbie Spellweaver
Joined
Feb 3, 2018
Messages
44
Reaction score
2
FYI: to Activate Festive Event
1. Set the date in database t_config table columnname
paramname = jieristartday
paramvalue = 2018-05-03 <- date when the Festive Event will be active.

2. You must set all active Festive Event which is declared here
Gameres\Config\JieRiGift\MUJieRiType.xml inside of this .xml there's all the active list of events and you must open each one by one and changed the

FromDate="2018-05-03 00:00:00" ToDate="2018-05-09 23:59:59" AwardStartDate="2018-05-03 00:00:00" AwardEndDate="2018-05-03 23:59:59" />

Date of festive event start and end date.
do we need to restart the game server bro to apply the changes?
 
Back
Top