MuADMINS
Soluciones
Arreglos breves para problemas comunes de servidores, clientes y sitios web de MU Online, cada uno con su fuente y su fecha. “Confirmado” significa que la persona que preguntó dijo que el arreglo funcionó.
16 soluciones para “resets column” · Limpiar
MuMaker: how to fill the first configuration window (SQL user, local or remote, MD5, database names, reset column)
1. Extract MuMaker and start MuMaker.exe. 2. Type any name (server name or yours), the SQL user (sa by default) and its password. 3. Connection type: choose local when MuMaker runs on the...
/reset works in game but the website still shows 0 resets (newest DarksTeam files)
The server writes resets to the column Resets, while the website reads another column (Reset). 1. Open the website config (usually config.php) and find $res_column_name. 2. Set it to $res...
✓ Confirmado por el autor del temaDarksTeam · 2017-06-13DMN CMS with MuEmu S6E3 files: reset and grand reset modules do not work.
1. Open the Character table in SQL and read the exact column names. 2. In the DMN config type them exactly, with the same upper and lower case (for example ResetCount, not reset or resetc...
✓ Confirmado por el autor del temaTuServerMU · 2018-11-22Which website CMS expects which MU database columns (WebEngine table maps, DmN)
WebEngine 1.2.7 picks a table map by server files (includes/config): - igcn.tables.php / custom.tables.php: resets = Character.RESETS, grand resets = Character.GrandResets, VIP = T_VIPLis...
Not verifiedEscrito por MuADMINSMuOnlineWebs with Louis S6 files: /reset works in game but the website does not count the resets
1. Louis files store resets in the column ResetCount, while MuOnlineWebs reads Resets by default. 2. In the MuOnlineWebs admin panel open the Table Settings. 3. Change the reset column fr...
✓ Confirmado por el autor del temaRaGEZONE · 2020-12-15Louis S6 Ep3: after /reset the character gets a huge or negative Zen amount (shows -7000 in the database).
1. The Zen cost was set in two places that conflicted for /reset. 2. Set the MoneyReq columns of the reset command line in Command.txt to 0. 3. Keep the reset Zen cost only in GameServerI...
✓ Confirmado por el autor del temaTuServerMU · 2024-08-24What is in the X-Team MuOnline database (password column, VIP, coins, resets, gens, master level)?
X-Team uses one database, MuOnline, with the MuEmu procedure set. - Accounts: MEMB_INFO.memb__pwd varchar(10) (plain; no MD5 function in the scripts), sno__numb char(18), AccountLevel / A...
Not verifiedEscrito por MuADMINSHow do I reset a character with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (ResetCount) with the server closed?
Columns: Character.ResetCount and MasterResetCount (X-Team also ResetDay, ResetWek, ResetMon and MasterResetDay / Wek / Mon for the daily, weekly and monthly limits). The server reads and...
Not verifiedEscrito por MuADMINSHow do I reset a character with SQL on IGCN files (RESETS, GrandResets) with the server closed?
Columns in IGCN Character: RESETS (int, all seasons), GrandResets (tinyint, Season 16, 17, 18), GRANDRESET (Season 12), plus cLevel, Experience, LevelUpPoint and the stats. 1. Close the G...
Not verifiedEscrito por MuADMINSWith dynamic EXP by resets the Master Level EXP also changes. How do I control ML EXP separately?
1. Use ExperienceTable.txt, which has MinMasterLevel and MaxMasterLevel columns. 2. Add lines per ML range, for example 400 800 0 50 * * * * 24, then 51 100 with 20, and so on. 3. The rat...
✓ Confirmado por el autor del temaCreandoMU · 2021-02-11What does the DmN CMS setup change in the MU database (columns, Character.id, WZ_CONNECT_MEMB) and what can break?
The DmN CMS 1.2.3 setup does more than create its own tables: 1. It ALTERs the game databases: adds columns from its version files, for example MEMB_INFO Admin, last_login, activated, act...
Not verifiedEscrito por MuADMINSHow do I set a new password for one account in SQL on IGCN files (plain, WZ_MD5 or md5 text)?
Use the form that matches PasswordEncryptType in IGCDS.ini and the memb__pwd column type. Keep the account offline and always use WHERE. - Type 0 (varchar(20)): UPDATE MEMB_INFO SET memb_...
Not verifiedEscrito por MuADMINSWebEngine: accounts made on the website cannot log in (password encryption must match memb__pwd)
WebEngine 1.2.7 has four password modes (install/definitions.php PDO_PWD_ENCRYPT) and writes MEMB_INFO differently for each: - none: memb__pwd = :password (plain), for varchar columns (IG...
Not verifiedEscrito por MuADMINSUnicode (NVARCHAR) migration of a MuEmu / Louis Season 6 database: what is right and what breaks
Review of a Season 6 Unicode script set (a migration that converts the name columns to NVARCHAR plus new WZ_CreateCharacter, WZ_DeleteCharacter, WZ_CreateGuild procedures). Its table list...
Not verifiedEscrito por MuADMINSPlayers show online on the website after the server closed, or accounts stay "online" (MEMB_STAT.ConnectStat stuck at 1)
How it works in every MSSQL files family we read (IGCN, MuEmu, Louis, MSPro, X-Team, MuDevs, WebZen): at login the server runs WZ_CONNECT_MEMB, which inserts or updates MEMB_STAT with Con...
Not verifiedEscrito por MuADMINSHow do I turn MD5 passwords on or off (enable / disable) on IGCN files (PasswordEncryptType, memb__pwd)?
On IGCN files the password mode is chosen in the DataServer and the database column must be of the matching type. If they do not match, nobody can log in. 1. Close the whole server and ba...
Not verifiedEscrito por MuADMINS