Community AlphaAlpha MUADMINS
VITiếng Việt
Đăng nhập
Trên MuADMINSConfig ScannerTải lên zip file của bạn: rate, rơi đồ, spot, giới hạnMởTrên MuADMINSGặp chúng tôi trên DiscordNhờ giúp đỡ, chia sẻ những gì bạn đang làm và trò chuyện về MU với các chủ server khác.Mở

MuADMINS

Giải pháp

Các cách sửa ngắn gọn cho những lỗi thường gặp của server, client và website MU Online, mỗi cách đều kèm nguồn và ngày. “Đã xác nhận” nghĩa là người đặt câu hỏi cho biết cách sửa đã hiệu quả.

50 giải pháp cho “sql script” · Xóa lọc

  1. Cài đặt serverMuEmu / 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...

    ✓ Được người mở chủ đề xác nhậnTUServerMU · 2020-05-04
  2. Cài đặt serverBộ file khácS2

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

    ✓ Được người mở chủ đề xác nhậnTuServerMU · 2016-12-14
  3. Công cụWebZen 97d / 99b

    Reset Generator: how to make the SQL reset script and run it automatically with SQL Server Agent

    1. Tick the options you want for a character reset (the settings of your server) and press Generate Reset. 2. The program writes the SQL code (script) of your reset system. 3. Copy it and...

    MuADMINS viết lại từ nguồnNot verifiedDarksTeam · 2008-04-22
  4. Cài đặt serverIGCNS9, 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 verifiedDo MuADMINS biên soạn
  5. Cài đặt server

    Every time I leave the game my account is banned (after adding an anti-dupe ban script)

    The ban-dupers SQL script that was added to the database does not work with every version and bans normal accounts. 1. Remove that script (trigger / job) from the MuOnline database. 2. Un...

    ✓ Được người mở chủ đề xác nhậnDarksTeam · 2010-01-05
  6. Cài đặt server

    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 verifiedDo MuADMINS biên soạn
  7. Cài đặt serverMuEmu / 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 verifiedDo MuADMINS biên soạn
  8. Cài đặt serverMSProS2, 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 verifiedDo MuADMINS biên soạn
  9. GameplayMuEmu / LouisSeason 6

    MuEmu (Emerson repack update 25): new characters get welcome items; where is that removed? It is not a SQL script

    1. The start items are given by the server file MuServer\Data\Custom\CustomStartItem.txt, not by a database script. 2. Remove or comment the item lines there (or switch the system off in...

    ✓ Được người mở chủ đề xác nhậnTUServerMU · 2021-06-03
  10. Cài đặt serverIGCNS16, S17, S18

    IGCN: players have negative WCoin or Goblin Points (shipped maintenance script)

    IGCN ships 2. Update Scripts\Maintenance Scripts\Check & Fix negative Coins.sql. It works in two runs and says "Take server offline before proceeding with the script": 1. With @Update = 0...

    Not verifiedDo MuADMINS biên soạn
  11. Cài đặt server

    I changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)

    The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment l...

    Not verifiedDo MuADMINS biên soạn
  12. Cài đặt serverS2, S6, S16, S17, S18, S20

    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 verifiedDo MuADMINS biên soạn
  13. Cài đặt serverS6, 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 verifiedDo MuADMINS biên soạn
  14. Cài đặt serverS2, 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 verifiedDo MuADMINS biên soạn
  15. Cài đặt serverIGCNS9, 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 verifiedDo MuADMINS biên soạn
  16. Cài đặt serverIGCNS9, 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 verifiedDo MuADMINS biên soạn
  17. Cài đặt serverIGCNS16, S17, S18

    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 verifiedDo MuADMINS biên soạn
  18. Công cụBộ file khácS6

    BeastMaker admin tool: how to set up the SQL connection and the allowed user (and SQL 2000 without "Edit Top 200 Rows")

    1. Run the table script from the release post to create the BeastMaker table (columns BeastMaker_Allowed, BeastMaker_Logs) in the MuOnline database. 2. Add your allowed entry {"YOURNAME":...

    MuADMINS viết lại từ nguồnNot verifiedRaGEZONE · 2015-07-14
  19. Cài đặt serverIGCNS9, S12, S16, S17, S18

    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 verifiedDo MuADMINS biên soạn
  20. WebsiteS1 to S12

    DTweb 2.0 (MuOnline CMS for all seasons): how do I install it and log into its admin panel the first time?

    1. Run Script.sql in your SQL query analyzer on the server database. 2. Put the website in the main web directory, not in a subfolder: some files use the document root and images or inclu...

    MuADMINS viết lại từ nguồnNot verifiedGitHub (r00tmebaby/DT-Web-2.0-MuOnline-CMS-All-Seasons) · 2019-04-12

Video trên MUTube

Thêm video cho “sql script”

Vẫn còn vướng mắc? Hỏi Trợ lý MU Tìm trên MuGPS

MuADMINS Community Alpha: miễn phí, do cộng đồng xây dựng, đang được phát triển tích cực.