MuADMINS
Çözümler
Yaygın MU Online sunucu, client ve web sitesi sorunları için kısa düzeltmeler; her biri kaynağı ve tarihiyle. “Onaylanmış”, soruyu soran kişinin düzeltmenin işe yaradığını söylediği anlamına gelir.
60 çözüm “source” için Sunucu kurulumu kategorisinde · Temizle
MSPro: the shipped query "Dar coin ganador gs" (WCoin for the Castle Siege winner) is broken
The file Tools - Querys Y Otros\Query-Sql\Dar coin ganador gs.txt has three problems: 1. Line 1 update CashShopData set WCoinC= WCoinC+1000 where AccountID in has nothing after IN (syntax...
Not verifiedMuADMINS tarafından yazıldıWhat are the MSPro database settings (ODBC, MD5Encryption, DisconnectOnlineAccount) and the update queries?
MSPro files connect through the ODBC DSN named MuOnline: - JoinServer\JoinServer.ini: JoinServerODBC = MuOnline, CaseSensitive = 0, MD5Encryption = 0, MaxIPLimit = 0, MaxHwIDLimit = 0, Di...
Not verifiedMuADMINS tarafından yazıldıLouis / MuEmu Season 6: "Invalid column name" after updating the server files (which Update script adds which column)
Louis (JogandoMU) Season 6 files ship one SQL file per update. If the files are newer than the database, the server logs Invalid column name 'X'. Find X below and run that script (and the...
Not verifiedMuADMINS tarafından yazıldıHow 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 verifiedMuADMINS tarafından yazıldıHow do I ban and unban accounts or characters with an end date on Louis / MuEmu Season 6 files (bloc_code, CtlCode, Bloc_Expire)?
Louis Season 6 Update 11 added the ban columns: MEMB_INFO.Bloc_Expire and Character.Bloc_Expire (smalldatetime). The procedure WZ_DesblocAccount @Account lifts a block only when it expire...
Not verifiedMuADMINS tarafından yazıldıHow do I make a character GM on MuEmu, Louis, MSPro, X-Team or MuDevs files (GameMaster.txt, not CtlCode)?
In MuEmu based files the GM list is a file, not a database column: GameServer\Data\Util\GameMaster.txt, one line per GM: "account1" "GMName" 2 - Louis Season 6: columns Account, Name, Lev...
Not verifiedMuADMINS tarafından yazıldıHow do I add WCoinC, WCoinP or Goblin Points with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (CashShopData)?
The table is CashShopData (AccountID, WCoinC, WCoinP, GoblinPoint). 1. Account offline (best: server closed), backup first, look at the row: SELECT AccountID, WCoinC, WCoinP, GoblinPoint...
Not verifiedMuADMINS tarafından yazıldıHow do I give VIP (AccountLevel) to an account with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files?
In MuEmu based files VIP is MEMB_INFO.AccountLevel (0 = normal, the AL1 / AL2 / AL3 levels of your configs) with MEMB_INFO.AccountExpireDate. Use the shipped procedure, account offline: E...
Not verifiedMuADMINS tarafından yazıldıHow do I turn MD5 on (MD5Encryption in JoinServer.ini) on MuEmu, Louis, MSPro, X-Team or MuDevs files, and what does the database need?
In MuEmu based files the switch is JoinServer\JoinServer.ini, MD5Encryption = 0/1 (next to CaseSensitive = 0). Every pack we read ships 0. What the databases have: - X-Team Season 2 and 1...
Not verifiedMuADMINS tarafından yazıldıIGCN Me_MuOnline (shared accounts): login fails or new accounts are not found after enabling it
Me_MuOnline is a separate accounts database. It has its own MEMB_INFO, MEMB_STAT, T_VIPList, ConnectionHistory, IGC_MachineID_Banned, fn_md5, WZ_CONNECT_MEMB and WZ_DISCONNECT_MEMB. 1. IG...
Not verifiedMuADMINS tarafından yazıldıIGCN: players cannot create Summoner, Rage Fighter or other card classes (AccountCharacter flags)
IGCN stores the class unlocks per account in AccountCharacter. Season 17 has the flags Summoner, RageFighter, GrowLancer, MagicGladiator, DarkLord, RuneWizard, Slayer, GunCrusher, LightWi...
Not verifiedMuADMINS tarafından yazıldıHow 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 verifiedMuADMINS tarafından yazıldıHow do I make a character Game Master (GM) or Administrator on IGCN files (CtlCode)?
On IGCN files the GM rights are on the character: Character.CtlCode (tinyint, default 0). - The IGCN command documentation says GM commands such as /item and /spawn "require Administrator...
Not verifiedMuADMINS tarafından yazıldıHow do I give or extend VIP for an account with SQL on IGCN files (IGC_VipAdd, T_VIPList)?
IGCN keeps the active VIP in T_VIPList (AccountID, Date, Type); MEMB_INFO also has VipType, VipStart, VipDays. The shipped procedure is IGC_VipAdd @szCharName, @DayAdd, @VipType. Despite...
Not verifiedMuADMINS tarafından yazıldıHow do I add WCoin or Goblin Points to an account with a SQL query on IGCN files?
The table is T_InGameShop_Point, but the columns changed between seasons: - Season 9 and 12: AccountID, WCoinC, WCoinP, GoblinPoint (float) - Season 16, 17, 18: AccountID, WCoin, GoblinPo...
Not verifiedMuADMINS tarafından yazıldıWhich databases do IGCN files need (MuOnline, Me_MuOnline, Events, Ranking, BattleCore) and in which order do the update scripts run?
IGCN files use up to five databases: - MuOnline: accounts (MEMB_INFO, MEMB_STAT), characters, guilds, warehouse, cash shop (T_InGameShop_Point), VIP (T_VIPList). - Me_MuOnline: optional s...
Not verifiedMuADMINS tarafından yazıldıWhy did IGCN CreateDatabase.sql delete my databases, and what must I change before running it?
Database\1. Full Scripts\CreateDatabase.sql starts with two switches: - DECLARE @DropExistingDatabases INT = 1: with 1 it DROPS existing databases named Me_MuOnline, MuOnline, Events, Ran...
Not verifiedMuADMINS tarafından yazıldıHow 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 verifiedMuADMINS tarafından yazıldıIGCN WZ_MD5 (PasswordEncryptType 1): fn_md5 fails or XP_MD5_EncodeKeyVal is not found
IGCN's fn_md5(@data VARCHAR(20), @data2 VARCHAR(10)) RETURNS BINARY(16) does only one thing: EXEC master.dbo.XP_MD5_EncodeKeyVal @data, @data2, @hash OUT (password first, account second)....
Not verifiedMuADMINS tarafından yazıldıHow 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 verifiedMuADMINS tarafından yazıldı