Community AlphaAlpha MUADMINS
TRTürkçe
Giriş yap
MuADMINS'teConfig ScannerDosyalarının zip'ini yükle: rate'ler, droplar, spotlar, limitlerAçMuADMINS'teDiscord'da buluşalımYardım iste, üzerinde çalıştığın şeyleri paylaş ve diğer sunucu sahipleriyle MU hakkında konuş.Aç

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.

21 çözüm “memb_info” için Sunucu kurulumu kategorisinde · Temizle

  1. Sunucu kurulumu

    "Account does not exist" or the login fails although the account is in MEMB_INFO: what to check in the database

    Check these in order (all read only, nothing changes): 1. Is the server reading the same database? MuEmu, Louis, MSPro, X-Team, MuDevs use the ODBC DSN in JoinServer.ini (JoinServerODBC =...

    Not verifiedMuADMINS tarafından yazıldı
  2. Sunucu kurulumuany

    How to get the list of e-mail addresses of all registered accounts from the MU database

    1. Open SQL Server Management Studio and connect to the server that holds your MU database. 2. Run: USE MuOnline; SELECT mail_addr FROM MEMB_INFO; 3. The result is the e-mail of every acc...

    ✓ Konu sahibi tarafından onaylandıTUServerMU · 2021-03-17
  3. Sunucu kurulumuany

    How to back up only the accounts and characters (inventory, warehouse, stats) instead of the whole MU database

    1. First make a full backup of the current database as it is (SQL Server Management Studio > Tasks > Back Up). 2. To move players to a clean database, copy over only the tables that hold...

    ✓ Konu sahibi tarafından onaylandıTUServerMU · 2020-07-23
  4. Sunucu kurulumu

    Replacing WZ_DISCONNECT_MEMB for MuCore gives 'Msg 468 ... Cannot resolve the collation conflict between Latin1_General_CS_AS and SQL_Latin1_General_CP1_CI_AS'

    1. The procedure compares memb___id from MEMB_INFO with memb___id from MEMB_STAT, and the two columns use different collations. 2. In SQL Server Management Studio set the same collation o...

    ✓ Konu sahibi tarafından onaylandıRaGEZONE · 2015-11-30
  5. Sunucu kurulumuIGCNS9, S12, S16, S17, S18

    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ı
  6. Sunucu kurulumuany

    SQL query to delete only characters and guilds but keep the accounts and their warehouse

    1. Make a full backup of the database first. 2. In SQL Server Management Studio run: USE MuOnline; DELETE Character (characters). 3. For guilds run: DELETE Guild; DELETE GuildMember. 4. M...

    ✓ Konu sahibi tarafından onaylandıTUServerMU · 2021-03-30
  7. Sunucu kurulumuMuEmu / LouisSeason 6 Episode 3

    Creating a character fails with 'Nombre de personaje incorrecto o ya existe' after installing a SQL script that gives points and zen to new characters (MuEmu S6 EP3 Louis Update 13)

    The new character script wrote to columns that do not exist in this database. 1. Open the script (trigger) you added in SQL Server Management Studio. 2. Compare its column names with your...

    ✓ Konu sahibi tarafından onaylandıTUServerMU · 2020-05-04
  8. Sunucu kurulumuMuEmu / LouisS6

    Unicode (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 verifiedMuADMINS tarafından yazıldı
  9. Sunucu kurulumu

    Korean, Cyrillic, Greek or other character names turn into ?? (collation and Unicode in MU databases)

    In every MSSQL files family we read, names are VARCHAR: Character.Name varchar(10), AccountCharacter.GameID1 ... varchar(10), Guild.G_Name varchar(8), MEMB_INFO.memb___id varchar(10). A V...

    Not verifiedMuADMINS tarafından yazıldı
  10. Sunucu kurulumuWebZen 97d / 99bS2, S3

    How do I set a new password for one account on a WebZen Season 2 / 3 MD5 database (SP_MD5_ENCODE_VALUE)?

    The Season 3 mumatrix and Season 2 namech databases ship SP_MD5_ENCODE_VALUE @btInStr VARCHAR(10), @btInStrIndex VARCHAR(10) ("Created By WebZen, Adapted By [CzF]Deathway" in the Season 3...

    Not verifiedMuADMINS tarafından yazıldı
  11. Sunucu kurulumuDV-TeamS19

    Where are accounts, VIP, credits, resets and bans in the DV-Team Season 19 database (MySQL / MariaDB)?

    DV-Team does not use SQL Server: the database is a MySQL / MariaDB dump (Navicat), databases muonline (127 tables) and log (22 tables). There is no MEMB_INFO and no stored procedure, so S...

    Not verifiedMuADMINS tarafından yazıldı
  12. Sunucu kurulumuX-TeamS2, S15, S17, S18

    What 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 verifiedMuADMINS tarafından yazıldı
  13. Sunucu kurulumuMuEmu / LouisS6

    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ı
  14. Sunucu kurulumuMuEmu / LouisS6

    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ı
  15. Sunucu kurulumuS6, S16, S17, S18, S20

    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ı
  16. Sunucu kurulumuS2, S6, S16, S17, S18, S20

    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ı
  17. Sunucu kurulumuS6, S16

    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ı
  18. Sunucu kurulumuIGCNS12, S16, S17, S18

    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ı
  19. Sunucu kurulumuIGCNS9, S12, S16, S17, S18

    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ı
  20. Sunucu kurulumuIGCNS9, S12, S16, S17, S18

    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ı
Hâlâ takıldınız mı? MU Asistanı'na sor MuGPS'te ara MUTube'da ara

MuADMINS Community Alpha: ücretsiz, topluluk tarafından yapılıyor, aktif geliştirmede.