Sounds like a bad smp in telecaster and other than using a different telecaster I am not really sure how to correct it properly.
I am not running 7.4, I do have the files but they are not the original files, they are the files that contain my data after I ran them and corrected some things.
I would give you the stored procedures but I am not certain if they are the same from 7.4 to 8.1
These are the modify results I get from 8.1 however if it helps you out at all...
dbo.smp_read_item_equip_info
Code:
USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_read_item_equip_info] Script Date: 1/2/2014 2:10:13 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- smp_read_item_equip_info
ALTER PROCEDURE [dbo].[smp_read_item_equip_info]
@IN_SID INT
AS
SET NOCOUNT ON
SELECT wear_info, code, enhance, level, elemental_effect_type, elemental_effect_expire_time, appearance_code
--SELECT *
FROM dbo.Item WITH (NOLOCK)
WHERE account_id = 0 AND owner_id = @IN_SID AND summon_id = 0 AND auction_id = 0 AND keeping_id = 0 AND wear_info > -1
ORDER BY update_time
RETURN @@ERROR
-- smp_read_item_equip_info
dbo.smp_read_character_list
Code:
USE [Telecaster]
GO
/****** Object: StoredProcedure [dbo].[smp_read_character_list] Script Date: 1/2/2014 2:21:09 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- end of smp_login_character
-- start of smp_read_character_list
ALTER PROCEDURE [dbo].[smp_read_character_list]
@IN_ACCOUNT_ID INT
AS
SET NOCOUNT ON
--SET ROWCOUNT 1
--WHILE 1=1
--BEGIN
-- UPDATE dbo.Character SET name = '@' + name + ' '+ SUBSTRING( CONVERT(varchar(40), GETDATE(), 21) , 3, 18 ) WHERE account_id = @IN_ACCOUNT_ID AND delete_time <= GETDATE() and name not like '@%';
-- IF @@ROWCOUNT = 0 BREAK
--END
--SET ROWCOUNT 0
SELECT sid,
name,
race,
sex,
lv,
jlv,
exp,
hp,
mp,
job,
permission,
skin_color,
model_00,
model_01,
model_02,
model_03,
model_04,
hair_color_index,
hair_color_rgb,
hide_equip_flag,
texture_id,
permission,
convert(VARCHAR,create_time,111) as create_time,
convert(VARCHAR,delete_time,111) as delete_time,
login_time,
login_count,
logout_time,
play_time
FROM dbo.Character WITH (NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND name NOT LIKE '@%' ORDER BY sid;
RETURN @@ERROR
Im am sure there are a few others around here that are more familiar with the difference between the two epics and SQL
Good luck on it
Can't create Character
