Stats resetting?

[Jay53928]

Once again, everytime I log on, my stats reset. It appears that I am the only one whose stats reset. Is there anyway I can prevent this from happening?

[Ultima]

Are you using mysql (did you fill in the database data?) of the default database?

[Jay53928]

No I did not. I don't even know how to do that alone.

[Ultima]

Try this:

- Turn off server
- Rename the database.db in the Database map.
- Start server
- Try if it still happens.
- Report back to us.

All users will lose there stats if you rename it, it acts like a backup for if this doesn't work.

[ismellike]

This happened to me, I think it was because my stats were too big in size like 1000000000

You can also try this:

[Download]<-sql

/sql DELETE FROM Players WHERE Name='Jay53928'

Source Code, by Dzienny

Code: Select all

//
// Coded by dzienny - 2013
//

using System;
using System.Data;
using System.Linq;

namespace MCDzienny
{
    public class CmdSql : Command
    {
        public override string name { get { return "sql"; } }
        public override string shortcut { get { return ""; } }
        public override string type { get { return "other"; } }
        public override bool museumUsable { get { return true; } }
        public override LevelPermission defaultRank { get { return LevelPermission.Nobody; } }

        public override void Use(Player p, string message)
        {
            DataTable queryResults = DBInterface.fillData(message, false);
            if (queryResults.Columns.Count == 0)
            {
                Player.SendMessage(p, "Query executed.");
                return;
            }
            if (queryResults.Rows.Count == 0)
            {
                Player.SendMessage(p, "No results found.");
                return;
            }

            // Display column names.
            string columnNames = String.Join(" | ", queryResults.Columns.Cast<DataColumn>().Select(c => c.ToString()).ToArray());
            Player.SendMessage(p, columnNames);

            // Display rows data.
            foreach (DataRow row in queryResults.Rows)
            {
                string rowItems = String.Join(" | ", row.ItemArray.Select(i => i.ToString()).ToArray());
                Player.SendMessage(p, rowItems);
            }

            queryResults.Dispose();
        }

        public override void Help(Player p)
        {
            Player.SendMessage(p, "/sql [query] - executes [query] on the server database.");
        }
    }
}