[Release] IGCN - MuEmu Server Season 12 ep 2 + Sources

[flyba]

Hello guys i run the server for test all works fine but when client connects it has error on dataserver/database it says

[07:31:51] [test] - characters: [ohyuo][sdfsdf][][][]
[07:31:51] [test] - Account Data: [SU:1][RF:1][Expanded WH:0]
[07:31:54] [SQL Error] Error executing: SELECT cLevel, mLevel, Class, LevelUpPoint, mlPoint, Experience, mlExperience, mlNextExp, Strength, Dexterity, Vitality, Energy, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, CtlCode, Leadership, ChatLimitTime, FruitPoint, RESETS, Married, MarryName, InventoryExpansion, WinDuels, LoseDuels, BlockChatTime, PenaltyMask, Ruud FROM Character WHERE Name='sdfsdf' AND AccountID='test'
[07:31:54] SQLSTATE: 42S22, Diagnosis: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Ruud'

im using my database from season 9 E2 with existing accounts

[Natzugen]

Hello guys i run the server for test all works fine but when client connects it has error on dataserver/database it says

[07:31:51] [test] - characters: [ohyuo][sdfsdf][][][]
[07:31:51] [test] - Account Data: [SU:1][RF:1][Expanded WH:0]
[07:31:54] [SQL Error] Error executing: SELECT cLevel, mLevel, Class, LevelUpPoint, mlPoint, Experience, mlExperience, mlNextExp, Strength, Dexterity, Vitality, Energy, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, CtlCode, Leadership, ChatLimitTime, FruitPoint, RESETS, Married, MarryName, InventoryExpansion, WinDuels, LoseDuels, BlockChatTime, PenaltyMask, Ruud FROM Character WHERE Name='sdfsdf' AND AccountID='test'
[07:31:54] SQLSTATE: 42S22, Diagnosis: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Ruud'

im using my database from season 9 E2 with existing accounts

Your database doesn't have the column Ruud in character table

[galuacon]

Hi all,

I tried to set on IGC_Common.ini

;-------------------------------------------------------------------------------------------------------------;-- Switch 16/28 Max Options can be added using Jewel of Life :: VALUES 0/1;-------------------------------------------------------------------------------------------------------------Is28Option = 1

But when i use Jewel of life to upgrade item , it limit only +16

Should i check other file to enhance to + 28 option ?

[PheonixMU]

Is someone able to repack this will the bugs fixed?

[GameMoiRa]

Hello guys i run the server for test all works fine but when client connects it has error on dataserver/database it says

[07:31:51] [test] - characters: [ohyuo][sdfsdf][][][]
[07:31:51] [test] - Account Data: [SU:1][RF:1][Expanded WH:0]
[07:31:54] [SQL Error] Error executing: SELECT cLevel, mLevel, Class, LevelUpPoint, mlPoint, Experience, mlExperience, mlNextExp, Strength, Dexterity, Vitality, Energy, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, CtlCode, Leadership, ChatLimitTime, FruitPoint, RESETS, Married, MarryName, InventoryExpansion, WinDuels, LoseDuels, BlockChatTime, PenaltyMask, Ruud FROM Character WHERE Name='sdfsdf' AND AccountID='test'
[07:31:54] SQLSTATE: 42S22, Diagnosis: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Ruud'

im using my database from season 9 E2 with existing accounts

Fix like this: add column Ruud to your table Character

USE [MuOnline]
GO

ALTER TABLE [dbo].[Character]
ADD [Ruud] [int] NOT NULL
GO

[flyba]

@GameMoiRa ty for the reply but sql wont allow NOT NULL
Msg 4901, Level 16, State 1, Line 2
ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'Ruud' cannot be added to non-empty table 'Character' because it does not satisfy these conditions.

[GameMoiRa]

@GameMoiRa ty for the reply but sql wont allow NOT NULL
Msg 4901, Level 16, State 1, Line 2
ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of the previous conditions are satisfied the table must be empty to allow addition of this column. Column 'Ruud' cannot be added to non-empty table 'Character' because it does not satisfy these conditions.

Change to this, Default = 0
USE [MuOnline]
GO

ALTER TABLE [dbo].[Character]
ADD [Ruud] [int] NOT NULL DEFAULT(0)

GO

[Exclikers]

how was this server files so far?

[whiner123]

Hi,

does anyone have Mu Maker? The latest one which works for IGCN Season 12? Unfortunately, I really can't make Mu Editor work properly due to errors in odbc setup :( the server and client work fine though.

[pachu11]

1. Fix Elemental Monster Spawn randomly with Element=6
2. Fix Shop Mithril and Mithril Fragment

Files update:
- gObjMonster.cpp
- MonsterSetBase.cpp
- PentagramSystem.cpp
- PentagramSystem.h
- Shop.cpp
Copy to your GameServer source code then rebuild.

Example Monster spawn config:
<Spawn Index="670" Distance="5" StartX="194" StartY="26" EndX="198" EndY="26" Dir="-1" Count="5" Element="6" />

Example Shop config:
<!-- Mithril Fragment -->
<Item Cat="12" Index="144" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="-1" SetItem="0" SocketCount="0" Elemental="1" Serial="0" />
<Item Cat="12" Index="144" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="-1" SetItem="0" SocketCount="0" Elemental="2" Serial="0" />
<Item Cat="12" Index="144" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="-1" SetItem="0" SocketCount="0" Elemental="3" Serial="0" />
<Item Cat="12" Index="144" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="-1" SetItem="0" SocketCount="0" Elemental="4" Serial="0" />
<Item Cat="12" Index="144" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="-1" SetItem="0" SocketCount="0" Elemental="5" Serial="0" />
<!-- Mithril -->
<Item Cat="12" Index="145" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="-1" SetItem="0" SocketCount="0" Elemental="1" Serial="0" />
<Item Cat="12" Index="145" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="-1" SetItem="0" SocketCount="0" Elemental="2" Serial="0" />
<Item Cat="12" Index="145" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="-1" SetItem="0" SocketCount="0" Elemental="3" Serial="0" />
<Item Cat="12" Index="145" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="-1" SetItem="0" SocketCount="0" Elemental="4" Serial="0" />
<Item Cat="12" Index="145" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="-1" SetItem="0" SocketCount="0" Elemental="5" Serial="0" />

You could fix the creation of errtel?

[vipfarm]

Cannot show effect bar

[ispyder]

Cannot show effect bar

Does this help?
http://forum.ragezone.com/f197/relea...eason-1170612/

[whiner123]

Hello, I posted in Mu Help but still no luck so Ill try here.

How do you add sockets and pink option to any items for this server? I tried what I did for season 6-3 zteam files but it does not work here..

[dezner]

has anyone experienced this problem?
[18:05:31] [NOTICE]: IOCP Thread Handles get 32
[18:05:31] [NOTICE]: IOCP Thread Handles set to 16
  with that I can't access another server or another room on the server

function

GetSystemInfo(&SystemInfo);

	g_dwThreadCount = SystemInfo.dwNumberOfProcessors * 2;
	g_Log.AddC(TColor::Orange, "[NOTICE]: IOCP Thread Handles get %d", g_dwThreadCount);
	if ( g_dwThreadCount >= MAX_IO_THREAD_HANDLES )
	{
		g_dwThreadCount = MAX_IO_THREAD_HANDLES;
		g_Log.AddC(TColor::Orange, "[NOTICE]: IOCP Thread Handles set to 16");
	}

[mrmadmadman]

Can someone collect all the fixes done so far and upload the update so we can all continue fixing the server files from the same starting point?

This community has potential to help each other out. The problem is everyone is too busy fixing their own server instead of sharing their progress. We can benefit from each other but we need team work.

All seasons of MU, we have the same problems. Many bugs and disperse fixes across different threads but never an unified/collective update with all the fixes made over time for each of the seasons...