Help me Admin Tool 3.5

[abcdded]

Help me

[MentaL]

[SHREC]

Help me

error procedure value!!

[abcdded]

So how to fix it??

[SHREC]

So how to fix it??

sql server profiler see procedure correct creat procedure correct!!

[Future]

So how to fix it??

You are probably using mKeeys Database.
In this case, this will fix the problem unless you have Account Related Warpoints:

USE [atum2_db_1]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[atum_admin_GetCharacterByCharacterName]
	@i_CharName	VARCHAR(20)
AS
	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     dbo.td_Character.UniqueNumber, dbo.td_Character.CharacterName, dbo.td_Character.AccountName, dbo.td_Character.AccountUniqueNumber, 
                      dbo.td_Character.Gender, dbo.td_Character.Race, dbo.td_Character.UnitKind, dbo.td_Character.InfluenceType, dbo.td_Character.SelectableInfluenceMask, 
                      dbo.td_Character.PilotFace, dbo.td_Character.CharacterMode, dbo.td_Character.AutoStatType, dbo.td_Character.AttackPart, dbo.td_Character.DefensePart, 
                      dbo.td_Character.FuelPart, dbo.td_Character.SoulPart, dbo.td_Character.ShieldPart, dbo.td_Character.DodgePart, dbo.td_Character.GuildName, 
                      dbo.td_Character.GuildUniqueNumber, dbo.td_Character.[Level], dbo.td_Character.Experience, dbo.td_Character.DownExperience, dbo.td_Character.DownSPIOnDeath, 
                      dbo.td_Character.BodyCondition, dbo.td_Character.Propensity, dbo.td_Character.Status, dbo.td_Character.PKWinPoint, dbo.td_Character.PKLossPoint, 
                      dbo.td_Character.Material, dbo.td_Character.HP, dbo.td_Character.DP, dbo.td_Character.SP, dbo.td_Character.EP, dbo.td_Character.PetName, 
                      dbo.td_Character.PetLevel, dbo.td_Character.PetExperience, dbo.td_Character.Position_X, dbo.td_Character.Position_Y, dbo.td_Character.Position_Z, 
                      dbo.td_Character.MapIndex, dbo.td_Character.ChannelIndex, dbo.td_Character.MaxLevel, dbo.td_Character.CurrentHP, dbo.td_Character.CurrentDP, 
                      dbo.td_Character.CurrentSP, dbo.td_Character.CurrentEP, dbo.td_Character.BonusStat, dbo.td_Character.BonusStatPoint, dbo.td_Character.LastPartyID, 
                      dbo.td_Character.RacingPoint, dbo.td_Character.TotalPlayTime, dbo.td_Character.CreatedTime, dbo.td_Character.LastStartedTime, dbo.td_Character.LevelUpTime, 
                      dbo.td_Character.WarPoint, dbo.td_Character.CumulativeWarPoint, dbo.td_Character.ArenaWin, dbo.td_Character.ArenaLose, 
                      dbo.td_Character.ArenaDisConnect, dbo.td_Character.PCBangTotalPlayTime, dbo.td_Character.SecretInfoOption, dbo.td_Character.NickName
	FROM         dbo.td_Character WITH (NOLOCK) INNER JOIN
                      atum2_db_account.dbo.td_Account ON dbo.td_Character.AccountUniqueNumber = atum2_db_account.dbo.td_Account.AccountUniqueNumber
	WHERE charactername = @i_CharName

Put it into your MSSQL studio and execute it

[abcdded]

Work ! thank you so much