Community AlphaAlpha MUADMINS
PTPortuguês (Brasil)
Entrar
No MuADMINSConfig ScannerEnvie o zip dos seus arquivos: rates, drops, spots, limitesAbrirNo MuADMINSEncontre-nos no DiscordPeça ajuda, mostre o que está criando e converse sobre MU com outros donos de servidores.Abrir

MuADMINS

Soluções

Correções curtas para problemas comuns de servidor, cliente e site de MU Online, cada uma com a fonte e a data. “Confirmado” significa que quem perguntou disse que a correção funcionou.

22 soluções para “query” · Limpar

  1. Configuração do servidorMuDevsS18

    MuDevs Season 18: Invalid column name 'LastGateIndex' (the extra query of the pack)

    The MuDevs Season 18 pack ships, next to the database scripts, a file Execute query.sql with one statement: ALTER TABLE dbo.Character ADD LastGateIndex [int] NOT NULL DEFAULT(-1); If the...

    Not verifiedEscrito pelo MuADMINS
  2. Configuração do servidorMSProS2, S3, S6

    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 verifiedEscrito pelo MuADMINS
  3. Configuração do servidorany

    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...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2021-03-30
  4. Configuração do servidorMuEmu / LouisS4

    DataServer floods '[QueryManager] State (24000) ... [ODBC SQL Server Driver] Invalid' when a character gets PK status (MuEmu S4 with the Ferrarezi website)

    1. The cause was not ODBC: the Ferrarezi website adds a trigger Z_PK_HERO on dbo.Character that fires when PkCount changes, and its old version broke the DataServer queries. 2. In SQL Ser...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2018-04-09
  5. Configuração do servidorIGCNS9, S12, S16, S17, S18

    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 verifiedEscrito pelo MuADMINS
  6. Configuração do servidorOutros server filesS2

    Season 2 files on SQL Server 2000: after creating the MuOnline database with the query, DataServer shows a database error. What was wrong?

    1. Run the database creation query in Query Analyzer logged in as sa, without selecting another database first. 2. Check the ODBC admin: the files' ODBC.reg had created the entries under...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2017-03-23
  7. GameplayIGCNS12

    Lowering the stat limit from 65000 to 32000 with a SQL query on IGCN-based S12 files does not work in game.

    1. No SQL query is needed. 2. Edit MuServer/IGCData/IGC_PlayerInfo.xml and change the Max values per class (MaxStrenghtDW, MaxAgilityDW, MaxVitalityDW, MaxEnergyDW, MaxCommandDW and the s...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-08-22
  8. Configuração do servidorSeason 6

    How to remove the master skill tree skills from every character at once (S6 Up15 GamingMaster files); DELETE MasterSkillTree did not remove them

    The learned skills are stored in the MagicList column of the Character table. 1. Back up the database and close the server. 2. Run: USE MuOnline; UPDATE Character SET [MagicList] = CONVER...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2021-05-09
  9. Site

    DMN CMS Webshop 1.06 shows a broken toplist banner image and I cannot find where it is in the templates

    1. Hide the image by its alt text instead of hunting the template. 2. With jQuery: in a script block run on page ready $('img[alt="MMOSERVER Mu Online, Maplestory, Aion Private Server Top...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2022-06-26
  10. Configuração do servidorOutros server filesS2

    Season 2 Ep X (Evolution Team) files ship the database as SQL scripts, not a .bak. How do I create the database?

    1. On SQL Server 2008 or newer, restore the database backup if the files include one. 2. On SQL Server 2000 or 2005, open Query Analyzer (Start menu) and log in as sa. 3. Paste the script...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2016-12-14
  11. Configuração do servidorWebZen 97d / 99b97d

    DarksTeam 97d: accounts created on the web show NULL columns in the database and characters do not show up properly. How to fix it?

    1. Back up the MuOnline database first. 2. Open a new query on MuOnline in SQL Server Management Studio. 3. Run: UPDATE Character SET CtlCode = 0 WHERE CtlCode IS NULL 4. Restart the serv...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-10-15
  12. Configuração do servidor

    What breaks a MU server database? Safe SQL checklist before you run a query

    What breaks MU databases most often, and what the pack files themselves show: 1. UPDATE while the server runs: the server writes online characters back from memory (IGCN maintenance scrip...

    Not verifiedEscrito pelo MuADMINS
  13. Configuração do servidorany

    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...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2021-03-17
  14. Configuração do servidor

    The website always shows 2 players online even when the server is off

    Stale rows in MEMB_STAT still say the accounts are connected. 1. Open Query Analyzer / SSMS on the MuOnline database. 2. Run UPDATE MEMB_STAT SET ConnectStat='0' WHERE ConnectStat>0. 3. R...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2009-03-03
  15. Site

    DarksWeb 0.3: give stat points per reset (500 for the first reset, 1000 for the second and so on)

    1. Open the reset module of DarksWeb. 2. After the line $respoints = '500'; read the character's resets: Select Clevel,Resets From Character where Name='$char'. 3. Compute $resetpoints =...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2010-04-05
  16. Configuração do servidor97d+99i

    SQL command to give credits to every account (DarksTeam 97d+99i)

    1. Open SSMS / Query Analyzer on the MuOnline database. 2. For all accounts run UPDATE MEMB_CREDITS SET credits=credits+500. 3. For one account run UPDATE MEMB_CREDITS SET credits=credits...

    ✓ Confirmado pelo autor do tópicoDarksTeam · 2021-12-28
  17. Site

    How do I show the guild logo (G_Mark) of a guild, for example the Castle Siege owner, on a PHP website with MSSQL?

    1. G_Mark in the Guild table is binary: turn it into text with bin2hex(). You get 64 hex digits, one per cell of an 8x8 grid. 2. Map each digit to a color: 0 transparent, 1 #000000, 2 #8c...

    ✓ Confirmado pelo autor do tópicoRaGEZONE · 2020-07-01
  18. GameplayIGCNS13

    IGCN Season 13 files: how to give new characters a starting amount of zen.

    1. In SSMS run on MuOnline a query that creates an INSERT trigger on dbo.Character (named Bonus in the thread). 2. The trigger reads the new Name from INSERTED and runs UPDATE Character S...

    ✓ Confirmado pelo autor do tópicoTuServerMU · 2018-10-15
  19. Configuração do servidor

    Characters do not save and the DataServer log shows State (42S22)

    SQL state 42S22 means a column was not found: the server files query a column your database does not have, so the save fails. 1. Open the DataServer log and read which table and column th...

    ✓ Confirmado pelo autor do tópicoTUServerMU · 2021-03-24
  20. Configuração do servidorMSProS2, S3, S6

    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 verifiedEscrito pelo MuADMINS

Vídeos no MUTube

Mais vídeos de “query”

Ainda com problema? Pergunte ao Assistente MU Buscar no MuGPS

MuADMINS Community Alpha: grátis, feito pela comunidade e em desenvolvimento ativo.