[NA - 2011] File Fixes

[fiestanerd69]

Re: Odin File Fixes

Other known bugs:
Can only have 4 characters instead of 5.
Knock backs don't work.
Dupe bug
Bottom of Adealia doesn't work. Or there is no way to access it.
Psiken mansion outside and inside is not complete. (Not really a bug)
Can't have more than 21 gems.
Kahal Plain monsters need to be added.
Portals to new maps need to be added.

Angelus what is this flame walker symbol you keep talking about? Do you mean you can't click on the flame walker?

 

[xWhiteCore]

Re: Odin File Fixes

Can't have more than 21 gems.

Wrong !

 

[Angelus]

Re: Odin File Fixes

no.. when u start the Flamewalker than comes the Fireballs... and a burning Symbol .. the Symbol is it what i mean^^
its Abstate ... i think .. and Abstate do not work
its not good english but i think u understand^^

Look on the picture from the last side ..u post it

next edit ^^ WhiteCore was it

 

[xWhiteCore]

Re: Odin File Fixes

What was it?

Write it on german and englisch..

 

[Black12]

Re: Odin File Fixes

DECLARE @before_money bigint
DECLARE @after_money bigint
DECLARE @procName nvarchar(128)
DECLARE @moneysub bigint
IF UPDATE(nMoney)
BEGIN
SELECT @before_money = del.nMoney FROM deleted del
SELECT @after_money = ins.nMoney FROM inserted ins
SET @moneysub = @after_money - @before_money
IF @moneysub >= 9999999999999
BEGIN
-- Audit OLD record.
INSERT INTO auditCharacterData (audit_log_type, audit_char_no, audit_char_money)
SELECT 'OLD', del.nCharNo, del.nMoney
FROM deleted del

-- Audit NEW record.
INSERT INTO auditCharacterData (audit_log_type, audit_char_no, audit_char_money)
SELECT 'NEW', ins.nCharNo, ins.nMoney
FROM inserted ins
END
END

 

[fiestanerd69]

Re: Odin File Fixes

no.. when u start the Flamewalker than comes the Fireballs... and a burning Symbol .. the Symbol is it what i mean^^
its Abstate ... i think .. and Abstate do not work
its not good english but i think u understand^^

Look on the picture from the last side ..u post it

next edit ^^ WhiteCore was it

Oh you mean the debuff symbol for when someone gets attacked by the flame walkers?

Wrong !

What do you mean?

DECLARE @before_money int
DECLARE @after_money int
DECLARE @procName nvarchar(128)
DECLARE @moneysub int
IF UPDATE(nMoney)
BEGIN
SELECT @before_money = del.nMoney FROM deleted del
SELECT @after_money = ins.nMoney FROM inserted ins
SET @moneysub = @after_money - @before_money
IF @moneysub >= 9999999999999
BEGIN
-- Audit OLD record.
INSERT INTO auditCharacterData (audit_log_type, audit_char_no, audit_char_money)
SELECT 'OLD', del.nCharNo, del.nMoney
FROM deleted del

-- Audit NEW record.
INSERT INTO auditCharacterData (audit_log_type, audit_char_no, audit_char_money)
SELECT 'NEW', ins.nCharNo, ins.nMoney
FROM inserted ins
END
END

Do I create a new query and execute it with this black?

 

[Black12]

Re: Odin File Fixes

Oh you mean the debuff symbol for when someone gets attacked by the flame walkers?



What do you mean?



Do I create a new query and execute it with this black?

No No this is a Trigger in tCharacter

 

[xWhiteCore]

Re: Odin File Fixes

No No this is a Trigger in tCharacter

What a poop ?

wich query/procedur ?

 

[Angelus]

Re: Odin File Fixes

@ WhiteCore ich meinte das Symbol das auf dem Boden erscheint wenn du den Flamewalker ausführst

 

[xWhiteCore]

Re: Odin File Fixes

@ WhiteCore ich meinte das Symbol das auf dem Boden erscheint wenn du den Flamewalker ausführst

And you can't fix it ?

You mean this ?

Spoiler

 

[RenegadeBenny]

Re: Odin File Fixes

Kahal Plain monsters need to be added.

Do you mean this?:

You must be registered to see links

 

[Angelus]

Re: Odin File Fixes

Yeahhhh .. this its what i mean^^ i havnt this when i make the Flamewalker

How can i fix it?

 

[xWhiteCore]

Re: Odin File Fixes

Yeahhhh .. this its what i mean^^ i havnt this when i make the Flamewalker

How can i fix it?

Try this:

You must be registered to see links

 

[Uberarrogant]

Re: Odin File Fixes

@xWhiteCore

Other bugs:
Metamorphosis bird doesn´t show up correctly.
Fix: Copy from OS/Gamigo reschar.

 

[xKeRnx]

Re: Odin File Fixes

I have a strange problem. I use the Odin Cash shop on my old server, everything went perfectly.
So now I have a new server. Everything Adapted from the Old Server. So now who do I buy an item once it is in premium inventory can take it out but again and again.
Have you ever replaced the Outspark.dll and everything changed at rest! It just does not work! Stu also could not help me, Maybe you can!

 

[xWhiteCore]

Re: Odin File Fixes

@Uberarrogant

I have an German Database idk how to execute this xD

 

[Black12]

Re: Odin File Fixes

@Uberarrogant

I have an German Database idk how to execute this xD

You must be registered to see links

us this xD

 

[cieto12345]

Re: Odin File Fixes

Using navicat just open Design Table for dbo.tCharacter and choose triggers.
There you can edit it

 

[Uberarrogant]

Re: Odin File Fixes

@Uberarrogant

I have an German Database idk how to execute this xD

Sags doch gleich
Die beiden haben recht, mit SQL Server Management Studio läufts auch aber egal

They are both right but using SQL Server Management Studio would work too.

 

[xWhiteCore]

Re: Odin File Fixes

Verratest du mir wie ? mit SQL Server

Explain me how to get this working on SQL Server