Just Bug Report and solutions
Error report , used data and files = [Only registered and activated users can see links. Click Here To Register...]
exec dbo.smp_insert_guild N'Test',1,2,0,0,1,300,N'New Recruit',N'Rank 4',N'Rank 3',N'Rank 2',N'Rank 1',N'Officer'
Msg 8144, Level 16, State 2, Procedure smp_insert_guild, Line 0
Procedure or function smp_insert_guild has too many arguments specified.
FİXED
-----------------------
exec dbo.smp_set_guild_permission 2,7
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'dbo.smp_set_guild_permission'.
FİXED
---------------------
NPC. lua files are missing
Arcadia secret_dungeon empty
Arcadia SkillTreeDisplay wrong data
Hair paint error
exec dbo.smp_update_character_hair 4,101,0,2815
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'dbo.smp_update_character_hair'.
------------------------------------------------
declare @p1 int
set @p1=NULL
exec dbo.smp_insert_state @p1 output,2,0,1005,111,11100,2055,0,-9045,0,N'',1
select @p1
Msg 201, Level 16, State 4, Procedure smp_insert_state, Line 0
Procedure or function 'smp_insert_state' expects parameter '@IN_REMAIN_TIME_3', which was not supplied.
-------------------------------------------------------------
exec dbo.smp_update_character_hide_equip_flag 3,4177920
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'dbo.smp_update_character_hide_equip_flag'.
And auth 2012 backup = [Only registered and activated users can see links. Click Here To Register...]
And data SHRINK
USE Telecaster
And Big Data .sql import
Start / run / cmd
Clean data and Files..
Error report , used data and files = [Only registered and activated users can see links. Click Here To Register...]
exec dbo.smp_insert_guild N'Test',1,2,0,0,1,300,N'New Recruit',N'Rank 4',N'Rank 3',N'Rank 2',N'Rank 1',N'Officer'
Msg 8144, Level 16, State 2, Procedure smp_insert_guild, Line 0
Procedure or function smp_insert_guild has too many arguments specified.
FİXED
-----------------------
exec dbo.smp_set_guild_permission 2,7
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'dbo.smp_set_guild_permission'.
FİXED
---------------------
NPC. lua files are missing
Arcadia secret_dungeon empty
Arcadia SkillTreeDisplay wrong data
Hair paint error
exec dbo.smp_update_character_hair 4,101,0,2815
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'dbo.smp_update_character_hair'.
------------------------------------------------
declare @p1 int
set @p1=NULL
exec dbo.smp_insert_state @p1 output,2,0,1005,111,11100,2055,0,-9045,0,N'',1
select @p1
Msg 201, Level 16, State 4, Procedure smp_insert_state, Line 0
Procedure or function 'smp_insert_state' expects parameter '@IN_REMAIN_TIME_3', which was not supplied.
-------------------------------------------------------------
exec dbo.smp_update_character_hide_equip_flag 3,4177920
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'dbo.smp_update_character_hide_equip_flag'.
FİXEDQuote:
I made a procedure for hide equip.
And auth 2012 backup = [Only registered and activated users can see links. Click Here To Register...]
And data SHRINK
USE Telecaster
PHP Code:
GO
ALTER DATABASE Telecaster SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(Telecaster_log)
ALTER DATABASE Telecaster SET RECOVERY FULL WITH NO_WAIT
GO
Start / run / cmd
PHP Code:
SQLCMD -S Seyit-PC\SQLEXPRESS -d Arcadia -E -i C:\script.sql
Clean data and Files..