[Release] Titans Tech 10.07.65 Season 6 By Antiferna

Hello, there i`m testing this files for 2 weeks now and i have some errors.

I use server 2003 SP2 x32 (I tryed server 2008 and sql 2008, server 2003 sql 2000, server 2008 sql 2005, but what i have now is the best)
SQL 2005 express advanced.
I use Startup.exe and now i use 0LauncherServerMu.exe for startup.
The Server have good configuration.

Everithing is good configured.

1. Sometimes after 2hours, or 12, or 18 the data server crash. It stay on standby and nobody can enter the server, buy i see the server.
Data server Log:
"0 Server delete"
"1 Server delete"
...
all the servers.

SQLSTATE:42000, Diagnosis:[Microsoft][ODBC_SQL Server Driver][SQL Server]Could not find procedure 'WZ_PeriodItemSelect'.

Only Data 1 and 2 crash. The cs server data dont crash, and commonserver cfg was configured the same on all 3 servers, scf data and other settings.
Should i try to make to separate database for mu subserver?
Sould i try to change data server 1 and 2?
Should i try another gs for the subserver?
What could be wrong?

2. I get in the data server this errors (in the logs):
error : coppy 1440
error : coppy 844
error : coppy 248
error : coppy 1092
error : coppy 496
error : coppy 48
error : coppy 1724

Verry frecvently, what's rong what could not copy?
How should i fix this?
I searched this thred, i read all.
I searched on the net, but still nothing. Some advice?

But the big problem is the database changing to standbymode and not letting anyone enther the server. I can't be 24/24 h online to check the server, and i don't know when i'ts gonna crash.

Can anyone have an aswer for this?
I tryed the dablo files but this one is better.

PheonixMU
you should try this: 2shared - download serverlauncher.rar
Or you should try startup.exe from diablo files season 6.

Avira antivirus showing spy.ardamax.juq and Hupigon.lcrr at files.. I checked and ardamax is keylogger's virs..

is it False alarm ? or smt?

Avira the worst antivirus, if you do not set him properly you cant to anything. He detect Meny backdours and other fake stuff.

Every cracked file have a backdor or something like that.

Abot my problems nobody knows nothing?

friends, which password are now for V5 files ? I tried to use: www.antifernagames.com doesn't work (
Maybe now can download better server files than this repak ? I don't know about new releases, because doesn't have mu server more than 3 years.
Thanks for answers ;)

Quote:

---

Originally Posted by andreiehh

Hello, there i`m testing this files for 2 weeks now and i have some errors.

I use server 2003 SP2 x32 (I tryed server 2008 and sql 2008, server 2003 sql 2000, server 2008 sql 2005, but what i have now is the best)
SQL 2005 express advanced.
I use Startup.exe and now i use 0LauncherServerMu.exe for startup.
The Server have good configuration.

Everithing is good configured.

1. Sometimes after 2hours, or 12, or 18 the data server crash. It stay on standby and nobody can enter the server, buy i see the server.
Data server Log:
"0 Server delete"
"1 Server delete"
...
all the servers.

SQLSTATE:42000, Diagnosis:[Microsoft][ODBC_SQL Server Driver][SQL Server]Could not find procedure 'WZ_PeriodItemSelect'.

Only Data 1 and 2 crash. The cs server data dont crash, and commonserver cfg was configured the same on all 3 servers, scf data and other settings.
Should i try to make to separate database for mu subserver?
Sould i try to change data server 1 and 2?
Should i try another gs for the subserver?
What could be wrong?

2. I get in the data server this errors (in the logs):
error : coppy 1440
error : coppy 844
error : coppy 248
error : coppy 1092
error : coppy 496
error : coppy 48
error : coppy 1724

Verry frecvently, what's rong what could not copy?
How should i fix this?
I searched this thred, i read all.
I searched on the net, but still nothing. Some advice?

But the big problem is the database changing to standbymode and not letting anyone enther the server. I can't be 24/24 h online to check the server, and i don't know when i'ts gonna crash.

Can anyone have an aswer for this?
I tryed the dablo files but this one is better.

PheonixMU
you should try this: 2shared - download serverlauncher.rar
Or you should try startup.exe from diablo files season 6.

---

I Got Same Problem! Still no Progress..


I use the new realese 7.09.12
But it stay Loding when i press Connect on the chacrter,,

Realy good files.

Server Uptime = 7 days (no crash)
Castle Siege = OK (the only error/bug/badconf i found is that you need press CTRL to hit enemys)
Some skills not working = is server/client side, i already fix some
ragefighter new char ancient sets Add Server/side and client/side and Working 100%
Btw will continue my confs at this files.

Cya

Quote:

---

Originally Posted by Pr0vider

Realy good files.

Server Uptime = 7 days (no crash)
Castle Siege = OK (the only error/bug/badconf i found is that you need press CTRL to hit enemys)
Some skills not working = is server/client side, i already fix some
ragefighter new char ancient sets Add Server/side and client/side and Working 100%
Btw will continue my confs at this files.

Cya

---

What configuration have your server sql an os version? Because my DB sitll crash, now the server have 32h no crash but i donno when its gonna grash.
The problem with skills i have it to, expecialy 5shot.

Quote:

---

Originally Posted by andreiehh

What configuration have your server sql an os version? Because my DB sitll crash, now the server have 32h no crash but i donno when its gonna grash.
The problem with skills i have it to, expecialy 5shot.

---

Im using Winxp SP3 with SQL2000

about skills, still working on that.

hi how to fix Bug in Castle Szego NPC do not? Bug and a item is in error gives help :glare:

Hi everybody,
I got a error when I use Mumaker or mix Item to 15, I put it in inventory is ok but when I wear it I got disconnect game.
Someone can show me how to fix it or how to chance max Item level is 13.
Thank for read. Sorry my bad En.

I downloaded again the all pack i reconfigured carefuly pice by pice and i found some things.
I fix some errors, it is posible to get that data server crash because i think i use db MuOnline from repack 4. ? I saw that db from repack 5 have some new things in it.

Tnx, about that errors above, nobody know nothing?

Hello all, files are number1 but i have 1 strange problem, when someone use /move /warp or M for move commands sometimes Main.exe got exiting (without distonect) I try 10 clients and its same. And too have problem when click select server have Disconnected.

Quote:

---

SQLSTATE:42000, Diagnosis:[Microsoft][ODBC_SQL Server Driver][SQL Server]Could not find procedure 'WZ_PeriodItemSelect'.

---

here is:

Code:

---

CREATE Procedure WZ_PeriodItemSelect

        @UserGuid                int,
        @CharacterName        varchar(10)
AS
BEGIN
        DECLARE @ErrorCode int
        DECLARE @ItemInfoCount int
        DECLARE @PeriodIndex int
        DECLARE @ExpireDate smalldatetime
        DECLARE @UsedInfo tinyint

        SET @PeriodIndex = 0
        SET @ErrorCode = 0
        SET @ItemInfoCount = 0
        SET @UsedInfo = 0

        SET NOCOUNT ON
        DECLARE CUR CURSOR FOR SELECT [PeriodIndex], [ExpireDate], [UsedInfo]  FROM T_PeriodItem_Info WHERE UserGuid = @UserGuid AND CharacterName = @CharacterName AND UsedInfo = 1 FOR UPDATE
        OPEN CUR
        FETCH NEXT FROM CUR INTO @PeriodIndex, @ExpireDate, @UsedInfo
        WHILE( @@fetch_status <> -1 )
        BEGIN
                IF( @@fetch_status <> -2 )
                BEGIN
                        IF( @ExpireDate < GetDate() )
                        BEGIN
                                UPDATE T_PeriodItem_Info SET UsedInfo = 0 WHERE PeriodIndex = @PeriodIndex
                        END
                END
                FETCH NEXT FROM CUR INTO @PeriodIndex, @ExpireDate, @UsedInfo
        END

        SELECT *, DATEDIFF( minute, BuyDate, GETDATE() ) AS UsedMinutes, DATEDIFF( minute, GETDATE(), ExpireDate ) AS LeftMinutes FROM T_PeriodItem_Info where UserGuid = @UserGuid AND CharacterName = @CharacterName AND UsedInfo = 1
        IF( @@Error <> 0 )
        BEGIN
                SET @ErrorCode = -1
        END

        CLOSE CUR
        DEALLOCATE CUR

        SET NOCOUNT OFF
END

GO

---

Quote:

---

Originally Posted by aecrimch

here is:

Code:

---

CREATE Procedure WZ_PeriodItemSelect

        @UserGuid                int,
        @CharacterName        varchar(10)
AS
BEGIN
        DECLARE @ErrorCode int
        DECLARE @ItemInfoCount int
        DECLARE @PeriodIndex int
        DECLARE @ExpireDate smalldatetime
        DECLARE @UsedInfo tinyint

        SET @PeriodIndex = 0
        SET @ErrorCode = 0
        SET @ItemInfoCount = 0
        SET @UsedInfo = 0

        SET NOCOUNT ON
        DECLARE CUR CURSOR FOR SELECT [PeriodIndex], [ExpireDate], [UsedInfo]  FROM T_PeriodItem_Info WHERE UserGuid = @UserGuid AND CharacterName = @CharacterName AND UsedInfo = 1 FOR UPDATE
        OPEN CUR
        FETCH NEXT FROM CUR INTO @PeriodIndex, @ExpireDate, @UsedInfo
        WHILE( @@fetch_status <> -1 )
        BEGIN
                IF( @@fetch_status <> -2 )
                BEGIN
                        IF( @ExpireDate < GetDate() )
                        BEGIN
                                UPDATE T_PeriodItem_Info SET UsedInfo = 0 WHERE PeriodIndex = @PeriodIndex
                        END
                END
                FETCH NEXT FROM CUR INTO @PeriodIndex, @ExpireDate, @UsedInfo
        END

        SELECT *, DATEDIFF( minute, BuyDate, GETDATE() ) AS UsedMinutes, DATEDIFF( minute, GETDATE(), ExpireDate ) AS LeftMinutes FROM T_PeriodItem_Info where UserGuid = @UserGuid AND CharacterName = @CharacterName AND UsedInfo = 1
        IF( @@Error <> 0 )
        BEGIN
                SET @ErrorCode = -1
        END

        CLOSE CUR
        DEALLOCATE CUR

        SET NOCOUNT OFF
END

GO

---

---

Tnx for the procedure, i saw this on the internet about my problem but i didint run it.

Now i run it and this line i dont think is good. I dont have T_PeriodITEM_info.

UPDATE T_PeriodItem_Info SET UseTime = 0 WHERE memb__char = @CharName

So my Log say now SQLSTATE:42S02, DIagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'T_Perioditem_Info'

hmmm

Quote:

---

Originally Posted by tochik2

‪MuServer StartUp‬‏ - YouTube
People, what can i do, to fix my server, any ideas with my problem ?
I can't connect to server... I think gameserver and something else work's uncorectly ?

---

bro what ur prob? u got DC when joining server?
Bro Seriously i got this file change ip and db pass
and hex main=start client and u are ready to play..but some skill is not working..anyways i work hard for it..
the server perfectly working my server uptime 25 hour no crash..u should double check ur config :thumbup1:

Quote:

---

Originally Posted by FahmimRezuan

bro what ur prob? u got DC when joining server?
Bro Seriously i got this file change ip and db pass
and hex main=start client and u are ready to play..but some skill is not working..anyways i work hard for it..
the server perfectly working my server uptime 25 hour no crash..u should double check ur config :thumbup1:

---

The cfq dont have big modification, only drop, chaos machine rate, fenir stuff like that.
Maybe the server work perfectly when nobody is playing. Because before when i didint had players online the server was online for 5 days and NO CRASH.
But now when ppl are playing problems are starting to show.

If i let the default cfg and setings i have the same problem.
Is starting to bother me...Because i cant be 24/24 on the server to see when data server crash.

Anyone with the same problem? (I founded on the help section a similar post with this porblem, i posted there but no aswer, so i am posting here to get more atention)

The only problem i have with this files and i instaled the 10.09.12 is about DATA SERVER Crash. It sudently switch to safe mode even if the players are paying (mobs drop only zen, and any progress is not saved, and you cant enter the server, the screen stay in freeze mode after you enter your login detailes when you try to enter the server).
Maybe is because my DB was setup incorectly, but i doubt that because is no big thing to install an sql server 2000/2005 and restore some db that already exists. They are tables missing from the db? or procedures that was not installed?

And i created that procedure and i have another error. And with this new procedure data server crashed.

The link between the server and sql server i think is the problem.
I tryed to find a solution for almoast a week, and i decided to start posting here, maybe somebody who got this files had the same problem and he/she can help me to spare time.

I use the most stabile platform for the server:
Server 2003 X86 R2 Enterprise SP2. + Full updates + Net framework and all the programs needed for SQL.
SLQ Server2005 (because meny ppl say that sql 2000 is outdated)

So do you have any recomandation, a solid platform?
What should i try, because i tryed already server 2003. Server 2008 (this one is more dificult to install because of the net framework)

I love scmt files and i know it verry well, but for this problem i didint find a solution yet.

Yes i am a newbie because i dont post much i just read and read and try everything. I have some experience in mu.
Please dont ignore my post and try to give some advice.

I didint find any solution by myself, so now i try to ask on the forum.

Hello,

please post your problems on help section.


karli

i have a server which runs this server file. smooth and no problems at all EXCEPT:

--> login freezes(after you input the account and password and hit ENTER then it loads to your characters but i wont get through just stuck on the login screen.)

it randomly occurs sometimes it dont sometimes it does. my server is running almost 3 weeks now but its pretty annoying xD the files is great but this is the downside. Ports and every configs is properly written and forwarded. i have 32 Online players daily(peak times) but worst it also occurs even i have only 5 players (off peak xD). jeez wtf xD i have seen alot of people having thisproblem not only related to this antiferna file. tried their solution (such as changing joinserver,connectserver,disabling logs etc etc) no avail problem still persist. xD

btw my server specs is:
AMD phenoM ii X4 3.8GHz
8GIG DDR3 1600 Memory.

bottom line: i do not claim this as a fact but as a fellow server owner which experience some unexpected downfall xD i rate this file as :7/10 xD not *TOO* stable. i am still using this file up to now xD and seeking possible solution. if anybody have similar problems please share your ideas thanks!

thanks!

EDITED: yep dataserver is causing the login freeze problem. xD i've seen old threads about this problem and still remains a mystery hahaha xD they only say *I GOT IT FIXED Thanks* but no solution disclosed. (sorry for the caps not meant for shouting xD).

Quote:

---

Originally Posted by andreiehh

Tnx for the procedure, i saw this on the internet about my problem but i didint run it.

Now i run it and this line i dont think is good. I dont have T_PeriodITEM_info.

UPDATE T_PeriodItem_Info SET UseTime = 0 WHERE memb__char = @CharName

So my Log say now SQLSTATE:42S02, DIagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'T_Perioditem_Info'

hmmm

---

try make missing table:

Code:

---

CREATE TABLE [T_PeriodItemInfo] (
        [PeriodIndex] [int] IDENTITY (1, 1) NOT NULL ,
        [UserGuid] [int] NOT NULL ,
        [CharacterName] [char] (10) NOT NULL ,
        [ItemCode] [int] NOT NULL ,
        [EffectType1] [tinyint] NOT NULL ,
        [EffectType2] [tinyint] NULL ,
        [UsedTime] [int] NOT NULL CONSTRAINT [DF_T_PeriodItemInfo_UsedTime] DEFAULT (0),
        [LeftTime] [int] NOT NULL ,
        [BuyDate] [smalldatetime] NOT NULL ,
        [ExpireDate] [smalldatetime] NOT NULL ,
        [UsedInfo] [tinyint] NOT NULL CONSTRAINT [DF_T_PeriodItemInfo_UsedInfo] DEFAULT (0),
        [OptionType] [tinyint] NOT NULL CONSTRAINT [DF_T_PeriodItemInfo_OptionType] DEFAULT (2)
) ON [PRIMARY]
GO

---

Any info about CashShop thing? is working?

Quote:

---

Originally Posted by Pr0vider

Any info about CashShop thing? is working?

---

Yea Its working perfectly
:laugh:

any one can help me ? I've been changing mob stats and they don't get stronger... WTF?! btw what config should i change ? Mosters.txt that located in ../data/ or ../data/monsters/ pls hellp )

Quote:

---

Originally Posted by aecrimch

try make missing table:

Code:

---

CREATE TABLE [T_PeriodItemInfo] (
        [PeriodIndex] [int] IDENTITY (1, 1) NOT NULL ,
        [UserGuid] [int] NOT NULL ,
        [CharacterName] [char] (10) NOT NULL ,
        [ItemCode] [int] NOT NULL ,
        [EffectType1] [tinyint] NOT NULL ,
        [EffectType2] [tinyint] NULL ,
        [UsedTime] [int] NOT NULL CONSTRAINT [DF_T_PeriodItemInfo_UsedTime] DEFAULT (0),
        [LeftTime] [int] NOT NULL ,
        [BuyDate] [smalldatetime] NOT NULL ,
        [ExpireDate] [smalldatetime] NOT NULL ,
        [UsedInfo] [tinyint] NOT NULL CONSTRAINT [DF_T_PeriodItemInfo_UsedInfo] DEFAULT (0),
        [OptionType] [tinyint] NOT NULL CONSTRAINT [DF_T_PeriodItemInfo_OptionType] DEFAULT (2)
) ON [PRIMARY]
GO

---

---

aecrimch thanks, you have been very helpful.
I will try to make that procedure and see if i resolve something.

Karli i can post this to help section, but its about this files. Is not only my problem. So thats why i posted here, maybe somebody come with an answer to this problem.

Tnx

how to remove the Chaos Card Master with the Elbelland, but it is not written in MonstrSetbase what he should stand his coordinates no how to fix? ":) coordinates 20 214
how to make use of GS_CS GHZ less, uses 50% Windows 7 SQL 2000?

Quote:

---

Originally Posted by IDemon

how to remove the Chaos Card Master with the Elbelland, but it is not written in MonstrSetbase what he should stand his coordinates no how to fix? ":) coordinates 20 214
how to make use of GS_CS GHZ less, uses 50% Windows 7 SQL 2000?

---

About Chaos Card Master:

Go to MuServer\SCFData\SCFSpawnMonsters.txt and change:

Code:

---

240 40 220 29 1
414 40 219 26 1

375 51 20 214 1

---

to

Code:

---

240 40 220 29 1
414 40 219 26 1

//375 51 20 214 1//just add//to make off, maybe you need in future

---

About GS_CS CPU Usage:

Go to MuServer\GameServerCS\SCF_Connect.ini and change:

Code:

---

[Connect]

SCFGsUdpPort=60220
SCF_SCFExDBIP=127.0.0.1
SCF_SCFExDBPort=55999

---

to

Code:

---

[Connect]

SCFGsUdpPort=60222
SCF_SCFExDBIP=127.0.0.1
SCF_SCFExDBPort=55999

---

Hope this help you



PS: If anyone have Cashshop working, please give some about how to make she works, Thks