-
Scroll to Change Name on Game
RefObjCommon
PHP Code:
1 43606 ITEM_MALL_CHANGENAME ???? ???? ??? (???) xxx SN_ITEM_MALL_CHANGENAME SN_ITEM_MALL_CHANGENAME_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr Premium\etc\changename.ddj xxx xxx 22006
RefObjItem
PHP Code:
22006 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ????(?) 1 [USU1:SKILL_MALL_CHANGENAME] -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
RefSkill
PHP Code:
1 34006 1013 SKILL_MALL_CHANGENAME ???? ???? SKILL_MALL_CHANGENAME 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_CHANGENAME xxx SN_SKILL_MALL_CHANGENAME_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Procedure
_TimedJob
PHP Code:
if(@JobID = '34006') -- Mudar nome do char
begin
declare @CharName16 varchar(64)
Select @CharName16=CharName16 from _Char where CharID = @CharID
Update _Char Set CharName16 = '@'+ @CharName16 Where CharID = @CharID
return -3
end
Execute
PHP Code:
USE [SRO_VT_SHARD]
GO
/****** Fixed And Modified By Jangan ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-----------------------------------------------------------------------------------------------------
ALTER procedure [dbo].[_RenameCharNameByID]
@CharID int,
@NewName varchar(64)
as
if (not exists (select charid from _char where charid = @charid))
return -1
set xact_abort on
begin transaction
if (exists (select charid from _charnamelist with (updlock) where charname16 = @NewName))
begin
rollback transaction
return -3
end
declare @old_name varchar(64)
select @old_name = charname16 from _char where charid = @charid
update _char set charname16 = @NewName where charid = @charid
if (@@error <> 0 or @@rowcount = 0)
begin
rollback transaction
return -4
end
insert _CharNameList values(@NewName, @charid)
UPDATE _Char set CharName16 = @NewName where CharID = @CharID
update _Friend set friendcharname = @NewName where friendcharid = @charid
update _GuildMember set charname = @NewName where charid = @charid
update _Memo set fromcharname = @NewName where fromcharname = @old_name
update _TrainingCampMember set charname = @NewName where charid = @charid
declare @cos_id int
declare cos_cursor cursor fast_forward for
select id
from _charcos
where ownercharid = @CharID
open cos_cursor
fetch next from cos_cursor into @cos_id
while( @@fetch_status = 0 )
begin
update _Items set CreaterName = @NewName
where ID64 in
(select ItemID from _InvCOS where COSID = @cos_id and ItemID > 0)
and CreaterName = @old_Name
if (@@error <> 0 )
begin
close cos_cursor
deallocate cos_cursor
rollback transaction
return -5
end
fetch next from cos_cursor into @cos_id
end
close cos_cursor
deallocate cos_cursor
declare pc_inv_cursor cursor fast_forward for
select it.Data
from _Inventory as inv join _Items as it on inv.ItemID = it.ID64
where
(inv.CharID = @CharID and inv.Slot >= 13 and inv.ItemID > 0) and
(it.Data <> 0) and
(exists (select top 1 ID from _RefObjCommon where ID = it.RefItemID and TypeID1 = 3 and TypeID2 = 2))
open pc_inv_cursor
fetch next from pc_inv_cursor into @cos_id
while( @@fetch_status = 0 )
begin
update _Items set CreaterName = @NewName
where ID64 in
(select ItemID from _InvCOS where COSID = @cos_id and ItemID > 0)
and CreaterName = @old_Name
if (@@error <> 0 )
begin
close pc_inv_cursor
deallocate pc_inv_cursor
rollback transaction
return -6
end
fetch next from pc_inv_cursor into @cos_id
end
close pc_inv_cursor
deallocate pc_inv_cursor
if (CHARINDEX('@', @old_name, 0) > 0)
begin
select * from _Char
where CharID = ''
end
commit transaction
return 1
-
Re: Scroll to Change Name on Game
please use code tags instead of php tags, the php tags remove the tab and replace them with space, or add the lines as a text file, other than that thanks!
but why do you release all those things in many threads, why not posting them as e.g. MGProject Package or sth like that in one post ^^ you released many stuff now and i like that but they are very similar so you could put them in one post ..
//Edit:
oh btw the stored procedure is named _AddTimedJob, not _TimedJob ^^
//Edit2:
maybe you should also add textdata_object.txt lines, some people might ask for it to give a like for you ^^
//Edit3:
the icon is missing too ..
-
Re: Scroll to Change Name on Game
hello refobjitem
insert line problem
saying column does not allow nulls insert fails !!
any solve ? fast pls
-
Re: Scroll to Change Name on Game
you have to replace spaces with tabs, the lines wer broken thanks to php tags ^^
-
Re: Scroll to Change Name on Game
As Lemon said.. we need it on .txt
and Media lines - icons.
thnx .
-
Re: Scroll to Change Name on Game
how to add timedjob i dont find :S any one help ?
-
Re: Scroll to Change Name on Game
the stored procedure is called _AddTimedJob, and you have to add the given lines to it, make sure you replace "34006" inside the stored procedure with your skill id in case you have to change it!
-
Re: Scroll to Change Name on Game
Well i got an crush ..
thier is my .txt
common.txt
some one check it ....
-
Re: Scroll to Change Name on Game
yeah the crash is normal, but after you log back in you have @ in front of your name which then leads to the rename interface to pop up while logging in with that char
-
Re: Scroll to Change Name on Game
Quote:
Originally Posted by
lemoniscool
yeah the crash is normal, but after you log back in you have @ in front of your name which then leads to the rename interface to pop up while logging in with that char
this is not the problem
the main problem is !!
when i make the scrol
its not drop in the ground..
coz the media line not correct ! and im sure it is correct
and i gave the item to my chr with a Query from the sql then the chr keep crashing .
could u share ur itemdata? media line
-
1 Attachment(s)
Re: Scroll to Change Name on Game
as requested here it is everything in a txt file, i did not search for an icon for this nor did i add textdata_object.txt lines as i skipped working on this when i noticed it will disconnect/crash the player .. i dont like that ..
-
Re: Scroll to Change Name on Game
Sh it this to notworking with me nathing happend :@
-
Re: Scroll to Change Name on Game
if its not working for you, you did something wrong tell me what exactly you did maybe i can help you if you really want this ..
-
Re: Scroll to Change Name on Game
lol there is a problem wired problem.......
when chr teleport its back to lvl 100 and stats reset..... !!! automatic
any answer?
-
Re: Scroll to Change Name on Game
to avoid crash, simply take out the return -3 part. still chars need to relog to be able to change name
-
Re: Scroll to Change Name on Game
Quote:
Originally Posted by
lemoniscool
if its not working for you, you did something wrong tell me what exactly you did maybe i can help you if you really want this ..
why dont u make a new topic with fully working :)
believe me all will be thankful
-
Re: Scroll to Change Name on Game
Quote:
Originally Posted by
thebigbody
why dont u make a new topic with fully working :)
believe me all will be thankful
+1 :)
-
Re: Scroll to Change Name on Game
well this one actually is working, i copied everything from here and just set it up right ..
you just have to make sure to replace the spaces with tabs and aside of that make sure the id of your _RefSkill entry is standing in the _AddTimedJob procedure where you added the snippet of this release as i said b4 already and execute the other stored procedure changes he copied from Jangan .. then its working
-
Re: Scroll to Change Name on Game
Tested and its working.
Full lines.
common
PHP Code:
1 50310 ITEM_MALL_CHANGENAME ???? ???? ??? (???) xxx SN_ITEM_MALL_CHANGENAME SN_ITEM_MALL_CHANGENAME_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr Premium\etc\changename.ddj xxx xxx 30310
objitem
PHP Code:
30310 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ????(?) 1 [USU1:SKILL_MALL_CHANGENAME] -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
refskill
PHP Code:
1 34006 1013 SKILL_MALL_CHANGENAME ???? ???? SKILL_MALL_CHANGENAME 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_CHANGENAME xxx SN_SKILL_MALL_CHANGENAME_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
client
PHP Code:
1 50310 ITEM_MALL_CHANGENAME ???? ???? ??? (???) xxx SN_ITEM_MALL_CHANGENAME SN_ITEM_MALL_CHANGENAME_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr Premium\etc\changename.ddj xxx xxx 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ????(?) 1 [USU1:SKILL_MALL_CHANGENAME] -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
-
Re: Scroll to Change Name on Game
Quote:
Originally Posted by
DieEyes
Tested and its working.
Full lines.
common
PHP Code:
1 50310 ITEM_MALL_CHANGENAME ???? ???? ??? (???) xxx SN_ITEM_MALL_CHANGENAME SN_ITEM_MALL_CHANGENAME_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr Premium\etc\changename.ddj xxx xxx 30310
objitem
PHP Code:
30310 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ????(?) 1 [USU1:SKILL_MALL_CHANGENAME] -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
refskill
PHP Code:
1 34006 1013 SKILL_MALL_CHANGENAME ???? ???? SKILL_MALL_CHANGENAME 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_CHANGENAME xxx SN_SKILL_MALL_CHANGENAME_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
client
PHP Code:
1 50310 ITEM_MALL_CHANGENAME ???? ???? ??? (???) xxx SN_ITEM_MALL_CHANGENAME SN_ITEM_MALL_CHANGENAME_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr Premium\etc\changename.ddj xxx xxx 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ????(?) 1 [USU1:SKILL_MALL_CHANGENAME] -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
i think the problem not on the lines :)
if you can help via Team viewer :)
or gimme your skype
maybe i made something wrong xD
-
Re: Scroll to Change Name on Game
every time when i use this query i got this msg
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@JobID".
Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@CharID".
Msg 178, Level 15, State 1, Line 6
A RETURN statement with a return value cannot be used in this context.
-
Re: Scroll to Change Name on Game
Quote:
Originally Posted by
MaDenGo
i think the problem not on the lines :)
if you can help via Team viewer :)
or gimme your skype
maybe i made something wrong xD
gosh again: CHECK THE ID FROM REFSKILL DATABASE (THE LINE OF THE BUFF YOU ADDED THERE) AND THE ID INSIDE THE _AddTimedJob snippet you added to it they HAVE TO BE THE SAME .. if you dont get it stop trying ... seriously isnt it obvious that when checking for a special skill to be used you have to specify the right ID of that skill? else it wont work of course damn ...
Quote:
Originally Posted by
keshk2007
every time when i use this query i got this msg
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@JobID".
Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@CharID".
Msg 178, Level 15, State 1, Line 6
A RETURN statement with a return value cannot be used in this context.
youre useing mssql 2005 i suppose? you could either rewrite everything for mssql 2005 or download mssql 2008
-
Re: Scroll to Change Name on Game
Quote:
Originally Posted by
lemoniscool
gosh again: CHECK THE ID FROM REFSKILL DATABASE (THE LINE OF THE BUFF YOU ADDED THERE) AND THE ID INSIDE THE _AddTimedJob snippet you added to it they HAVE TO BE THE SAME .. if you dont get it stop trying ... seriously isnt it obvious that when checking for a special skill to be used you have to specify the right ID of that skill? else it wont work of course damn ...
well what if i have added everything in right way and when i press on the scroll nothing happen the scroll appear like a timed scroll for 1.5 sec only and nothing happens.:?:
-
Re: Scroll to Change Name on Game
Quote:
Originally Posted by
Metamore
well what if i have added everything in right way and when i press on the scroll nothing happen the scroll appear like a timed scroll for 1.5 sec only and nothing happens.:?:
Just re-login and choose your character.
-
Re: Scroll to Change Name on Game
Quote:
Originally Posted by
lemoniscool
gosh again: CHECK THE ID FROM REFSKILL DATABASE (THE LINE OF THE BUFF YOU ADDED THERE) AND THE ID INSIDE THE _AddTimedJob snippet you added to it they HAVE TO BE THE SAME .. if you dont get it stop trying ... seriously isnt it obvious that when checking for a special skill to be used you have to specify the right ID of that skill? else it wont work of course damn ...
youre useing mssql 2005 i suppose? you could either rewrite everything for mssql 2005 or download mssql 2008
i use SQL 2008 R2
