Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSConfig ScannerZip deiner Dateien hochladen: Rates, Drops, Spots, LimitsÖffnenAuf MuADMINSTriff uns auf DiscordFrag nach Hilfe, zeig, woran du arbeitest, und sprich mit anderen Serverbetreibern über MU.Öffnen

MuADMINS

Lösungen

Kurze Fixes für häufige Probleme mit Server, Client und Website bei MU Online, jeweils mit Quelle und Datum. “Bestätigt” heißt: Die Person, die gefragt hat, hat gesagt, dass der Fix funktioniert hat.

2 Lösungen für “query” in Gameplay · Zurücksetzen

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

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-08-22
  2. 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...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2018-10-15

Weitere Antworten für „query“

2 in Gameplay, 20 in anderen Kategorien und Serverdateien:

  1. Server-SetupMuDevsS18

    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 verifiedVon MuADMINS geschrieben
  2. Server-SetupMSProS2, 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 verifiedVon MuADMINS geschrieben
  3. Server-Setupany

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

    ✓ Vom Threadersteller bestätigtTUServerMU · 2021-03-30
  4. Server-SetupMuEmu / 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...

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2018-04-09
  5. Server-SetupIGCNS9, 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 verifiedVon MuADMINS geschrieben
  6. Server-SetupAndere 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...

    ✓ Vom Threadersteller bestätigtTuServerMU · 2017-03-23
  7. Server-SetupSeason 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...

    ✓ Vom Threadersteller bestätigtTUServerMU · 2021-05-09
  8. Website

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

    ✓ Vom Threadersteller bestätigtRaGEZONE · 2022-06-26

Alle 22 ohne Filter ansehen

Videos auf MUTube

Mehr Videos zu „query“

Kommst du immer noch nicht weiter? Frag den MU-Assistenten MuGPS durchsuchen

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.