MuADMINS
Mga Solusyon
Maiikling fix para sa mga karaniwang problema sa MU Online server, client at website, bawat isa ay may source at petsa. Ang ibig sabihin ng “Kinumpirma” ay sinabi ng nagtanong na gumana ang fix.
8 solusyon para sa “ssms” · I-clear
WebEngine CMS install keeps saying 'Could not connect to database (1)' with SQL Server 2008 and XAMPP (PDO ODBC), even though SSMS connects fine.
1. The thread found a conflict between SQL Server 2008 and WebEngine's connection. 2. Install a newer SQL Server (2012 worked for the topic starter; another user had 2019 working). 3. Res...
✓ Kinumpirma ng nagsimula ng topicRaGEZONE · 2023-10-06I cannot delete a MU database in SQL Server Management Studio, it gives an error because it is in use. How do I remove it?
1. Stop DataServer, JoinServer, the editors and the web that use the database. 2. In Management Studio right click the database > Delete. 3. In the Delete Object window tick Close existin...
✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2018-01-06SQL Server Management Studio shows "Value cannot be null. Parameter name: viewInfo" when opening Databases on the MU server. What causes it?
1. Check the free space on the drive where Windows, SQL Server and its temp folder live. 2. In this case the disk was full. 3. Free space: clear temp folders, old server logs and old back...
✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2019-06-19New characters show 65535 kills and deaths.
1. Fix existing ones: UPDATE dbo.Character SET Kills=0 WHERE Kills=65535 and the same for Deads. 2. In SSMS design the Character table and set the Default Value of Kills and Deads to 0. 3...
✓ Kinumpirma ng nagsimula ng topicCreandoMU · 2020-08-20How do I give GoblinPoints each time a character resets (Season 6 MuEmu)?
1. In SSMS edit the procedure WZ_SetResetInfo. 2. Below the line that starts with UPDATE Character add UPDATE CashShopData SET GoblinPoint=GoblinPoint+100 WHERE AccountID=@Account. 3. Exe...
✓ Kinumpirma ng nagsimula ng topicCreandoMU · 2021-01-21The 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...
✓ Kinumpirma ng nagsimula ng topicDarksTeam · 2009-03-03SQL 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...
✓ Kinumpirma ng nagsimula ng topicDarksTeam · 2021-12-28IGCN 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...
✓ Kinumpirma ng nagsimula ng topicTuServerMU · 2018-10-15
Mga video sa MUTube
Paano Mag-setup ng SQL Server 2008 para sa MuOnline
MuADMINS · 4:43 · 2016
Paano Mag-setup ng MSSQL 2000 para sa MuOnline
MuADMINS · 7:20 · 2013
Tutorial SQL Server 2008 R2 MuOnline
LayerGaming · 4:14 · 2021
I-install ang Sql Server 2008 R2 MuOnline
EXProject Mu - Desarrollo de MuOnline · 10:44 · 2024