Admin tool 3.5 (full worked)

Quote:

---

Originally Posted by sami37

Look at the first page...

---

Yeah what is on the procedur? i look at that... but dont find anything curious

Quote:

---

Originally Posted by Cherti

Attachment 133841
How do i Solve this?

Can anyone help pls?

i got atum & callweb

---

Problem in procedure, run this query to fix it:

Code:

---

USE [atum2_db_1]
GO

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[atum_admin_GetCharacterByCharacterName]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[atum_admin_GetCharacterByCharacterName]
GO

USE [atum2_db_1]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[atum_admin_GetCharacterByCharacterName]
        @i_CharName        VARCHAR(20)
AS
        -- // 2007-07-30 by cmkwon, SCAdminTool¿¡¼­ ¿©´Ü¸í º¯°æ ±â´É ?ß°¡ - ij¸¯ÅÍ Á¤º¸¸¦ °¡Á®¿?¶§ td_Guild Å×À?ºíÀ» ÂüÁ¶ÇÏ¿© ¾÷µ¥À?Æ®ÇÑ À?ÈÄ¿¡ °¡Á®¿Â´Ù
        IF NOT EXISTS(SELECT c.UniqueNumber FROM td_character c, td_guild g, td_guildMember gm WITH(NOLOCK) WHERE c.charactername = @i_CharName AND c.GuildUniqueNumber = g.GuildUniqueNumber AND gm.GuildUniqueNumber = c.GuildUniqueNumber AND gm.CharacterUniqueNumber = c.UniqueNumber)
        BEGIN
                UPDATE td_character
                SET GuildName = NULL, GuildUniqueNumber = 0
                FROM td_character c        WITH (NOLOCK)
                WHERE c.charactername = @i_CharName
        END
        ELSE
        BEGIN
                UPDATE td_character
                SET GuildName = g.GuildName
                FROM td_character c, td_Guild g        WITH (NOLOCK)
                WHERE c.charactername = @i_CharName AND c.GuildUniqueNumber = g.GuildUniqueNumber
        END

        SELECT *
        FROM td_Character
        WITH (NOLOCK)
        WHERE charactername = @i_CharName


GO

---

http://i159.photobucket.com/albums/t...pse110a3f9.jpg

It's funny how no one deletes those Korean comments in the stored procedures...

Maybe it is because some retards think they are relevant for the procedure to work... -.-

Not funny if you try it or see end of procedure and compare it with old procedure.
I deleted some Korean comments to easy see. I not think like you.

Quote:

---

Originally Posted by FutureAR

It's funny how no one deletes those Korean comments in the stored procedures...

Maybe it is because some retards think they are relevant for the procedure to work... -.-

---

For your info, those comments can actually be converted to Korean and be google translated.

Thx You!

Does it show tricks control admin tool?