public static void savejianghu(client.gamestate client)
public static void savejianghu(client.gamestate client) { try { memorystream stream = new memorystream(); binarywriter writer = new binarywriter(stream); client.entity.myjiang.serialize(writer); /////////// string sql = "update `jiang` set powers=@powers,ownname=@ownname,customizedname=@customizedname where uid = " + client.entity.uid + " ;"; byte[] rawdata = stream.toarray(); using (var conn = dataholder.mysqlconnection) { conn.open(); using (var cmd = new mysql.data.mysqlclient.mysqlcommand()) { cmd.connection = conn; cmd.commandtext = sql; cmd.parameters.addwithvalue("@powers", rawdata); cmd.parameters.addwithvalue("@ownname", client.entity.myjiang.ownname); cmd.parameters.addwithvalue("@customizedname", client.entity.myjiang.customizedname); cmd.executenonquery(); } } } catch (exception e) { console.writeline(e); } }