Change name problem

[!Ego]

hello
Now as we know there is a change name scroll
So i can scam a player then change my name so gm won't even know how scammed him
So what about making a table which register every name change with the right time that the player used the scroll in
So the table have the time of use
Old name
New name
So gm can manage him any time
Thanks can u help me in that ?

[Anonymous-9238]

... what....

[blapanda]

Name change scroll. Were people even able to use those on the older Silkroad files, except CSRO-R?
It is easy to declare and define those actions. You just simply need the triggered eventID (used name change scroll should have it's own eventID), listen for the usage of it inside of your log procedures (item specific one log proc, if this specific item being used -> then), select the current name and temp save it, register the new name as well, use the date function of SQL, add them into a new table inside the shard database.

Not going to post anything "ready to use" related content here. If I do so, or anyone else, you won't learn anything.

[Konami$]

that what you talking about

[Royalblade*]

CREATE TABLE _CharnameChanges (OldCharname VARCHAR(32), NewCharName VARCHAR(32), [Timestamp] SMALLDATETIME)

is what you are looking for.

[!Ego]

So i created the able
but how could i know the event id
so i can make the produce register the Old(Easy)
but how could i make the SQL w8 the new char name to register it ?

[​Exo]

Originally Posted by BuiLt4KiLl

So i created the able
but how could i know the event id
so i can make the produce register the Old(Easy)
but how could i make the SQL w8 the new char name to register it ?

-> Scroll procedure\lines and INSERT INTO blablabla...

[witchymoo]

Make a scroll to trigger the name change procedure, I think old vSRO has one, u only need to read its activity using [_LogEventItem] (@EventID 41 = scroll usage). But don't make the scroll "Return Scroll" type, make it "expendable" type with empty skill so it can call [_AddTimedJob], and you can dc the client from there. Name change procedure needs to DC the client. Believe me, I tried

do not forget to review your [_RenameCharName] and [_RenameCharNameByID], those are the SP the name change procedure calls. It's original SP, you need to make sure they works.

Just a tip, triggering name change is very simple, you only have to change character name of a char from "My_Char_Name" to "@My_Char_Name" <-- add "@", the client will automatically force the player to change the char name on next login. Yes, on next login, that's why you have to DC the client.

clear example:

 Spoiler

good luck

[B1Q B0SS]

Originally Posted by witchymoo

Make a scroll to trigger the name change procedure, I think old vSRO has one, u only need to read its activity using [_LogEventItem] (@EventID 41 = scroll usage). But don't make the scroll "Return Scroll" type, make it "expendable" type with empty skill so it can call [_AddTimedJob], and you can dc the client from there. Name change procedure needs to DC the client. Believe me, I tried

do not forget to review your [_RenameCharName] and [_RenameCharNameByID], those are the SP the name change procedure calls. It's original SP, you need to make sure they works.

Just a tip, triggering name change is very simple, you only have to change character name of a char from "My_Char_Name" to "@My_Char_Name" <-- add "@", the client will automatically force the player to change the char name on next login. Yes, on next login, that's why you have to DC the client.

clear example:

 Spoiler

good luck

you're always helpful bro

these guys are saying insert and **** but he dont know what the hell they're talking about because he's a newbie

good luck

[​Exo]

Originally Posted by witchymoo

Make a scroll to trigger the name change procedure, I think old vSRO has one, u only need to read its activity using [_LogEventItem] (@EventID 41 = scroll usage). But don't make the scroll "Return Scroll" type, make it "expendable" type with empty skill so it can call [_AddTimedJob], and you can dc the client from there. Name change procedure needs to DC the client. Believe me, I tried

do not forget to review your [_RenameCharName] and [_RenameCharNameByID], those are the SP the name change procedure calls. It's original SP, you need to make sure they works.

Just a tip, triggering name change is very simple, you only have to change character name of a char from "My_Char_Name" to "@My_Char_Name" <-- add "@", the client will automatically force the player to change the char name on next login. Yes, on next login, that's why you have to DC the client.

clear example:

 Spoiler

good luck

I guess he already got that working. He just wants to write logs, or that's what he said!

[!Ego]

Really guy's ?!
It's the first time for me
I can't under stand 1 single word from the replies up !!
Please i need to understand how it goes from A to Z

[Aaron*]

Originally Posted by BuiLt4KiLl

Really guy's ?!
It's the first time for me
I can't under stand 1 single word from the replies up !!
Please i need to understand how it goes from A to Z

Here you go.
1- Use this query

USE SRO_VT_SHARD
CREATE TABLE _RenameCharLog
(OldName varchar(16)
,CharID INT
,NewName varchar(16))

2- Go to your _RenameCharNameByCharID procedure in SRO_VT_SHARD, modify it
Add code B right after Code A (code a already exists, you just need to add code b after it)
Code A:

declare @old_name varchar(64)
select @old_name = charname16 from _char where charid = @charid

Code B:

INSERT _RenameCharLog
SELECT @old_name,@CharID,@NewName

Can explaining this be clearer? Think not.

[Equinox,]

i think wichymoo said well too

[​Exo]

Do you have the scroll working or not?