msg52NickName error

[derwisz]

hello,
few days I tested new commands with hlscriptcmd and i thought it bugged my char that;
-it displays msg52 before NickName,
-relog cancelles all char changes (learned skills, taken items etc) made during last login,
-relog is always from the same point no matter where I logout ("give Space and time tunnel 1" and "give Shuttle space and time 1" from original JiFen work?
-nickname is pale blue instead of white - like skilled rented mob - is this vip ****?
everything was no problem untill...
ONE OF THE PLAYERS GOT SAME DISEASE
and what he did?
gave all items weared, logout, login (given items duplicated as no change registered), gave all items, logut, login, etc etc...
this time prompt help is neccessary
thx

 

[Demonic]

Bit Confusing to read that lot but See if I can help a little

Time & Space / Time Shuttle - How this works is one Scroll Sets the location, nothing Visible Happens until you Press the Other Scroll which then Takes you back to the Place where you clicked the other Scroll. Think of this as something to recall you to a place (say Near a Boss Mob) so you can go off hunting and come back to it when you hear the Boss is there.

There is IP (important Person), VIP - Very Important Person. These give you More Exp for XX Days (set in CD.ini) and colour your Char name plus puts a title on your head (again in CD.ini).

There is also Rebirth (10 Levels) - this knocks you back XX Levels, also colours your name but gives you stats and you keep what you have.

 

[derwisz]

I worte a lot 'cause my situation could effect of dome npc/gm commands
but what happened to player?
he has got "msg61" instead of nickname
i talked to him, that after first infected login he had linenotice.txt messages apperaing like time is x10 :/
I'm digging logs etc. but with no results,

attached you would find error in dbserver i see for some days, do you recognize it?
maybe it has something common with this disease?
btw, what is this error?

 

[Coly]

XD DB Error ...

You must change in your Char and Abil DB the Level and other. 17ng has this explant for long time with newer CD Server version. set the thinks to
Integer (Int) then it work fine ;-)

 

[derwisz]

you mean all all 'not-text' data to integer type
yes?
or only some of them?

still, any clue with msg52 error?

 

[TritoN]

problem with duping items may be related to db double entries...look for that charname in db and c if its there more than once
for a wierd reason double entries sometimes happen (though very seldom) in ms sql server especialy after big db operations like copy from another db and stuff like that

 

[derwisz]

problem with duping items may be related to db double entries...look for that charname in db and c if its there more than once
for a wierd reason double entries sometimes happen (though very seldom) in ms sql server especialy after big db operations like copy from another db and stuff like that

yes i've come across item duplication several times but this time it is not the same;
no matter how long 'msg52nickname' character is online - even 3-4hours - any changes like new spells, item change etc is not recorded and next login is like this 3-4hour play never took place.
by duplication i meant players concious action regarded with obove error, he gives away everything from bag and what he wears and after next login the same items are there again

 

[Jesterhead]

try to change every field in your DB with numaric values into Integer, like Coly said.
Problem is that one field(s) in your DB´s aren´t declared as Int, on your Screenie a field is declared as TinyInt (max +/- 128?), but the server tries to write a higher value (in this case 1535) into it.
->Overflow
seems like a HP/MP/FP entry.

 

[TritoN]

yes check all the things mentioned here but from my experiences the exact odd phenomeny u described above happens if a char has a double entry in db..we had that on olymp after we switched from EI to JoB server ..all the chars which had this double entry in db never saved there actions ingame so they could give away all items/gold they had and after relog they had it again while the other char who took the items still had them (100% dupes hehe)

 

[Coly]

On the Abil DB is this problem, on this is not a Primary Index -.- and in the Server the Player Duplicate Function dosn't work Success. The Server Make a
copy of the User for some thinks.

 

[derwisz]

well, the ability and other bases from game3g were correct
i had wrong definitions in HL_Stditems (float instead of int and tinyint)
it should solve database error
but still:
what is wrong with charactername, charactername colour, not registering database changes from last login??

 

[Coly]

your CD Version ? and look in the Character DB if your name changet

 

[Coly]

hmmm or look in the Plugin on the GM Panel if you in Game, then change the
Extra Abil, this change your Name and you color.

 

[Coly]

Please look here : http://www.lomcn.co.uk/forum/showthread.php?t=38393 and open the Pic 2_1

Alter Settings and Title if Interst for you ;-) you must change to 0

have fun ^^

 

[Demonic]

I see your problem, look in the CruelDragon.ini:

Holley_msg51=conclusion!  \ you altogether obtain the experience:  %d Fame value
Holley_msg52=[VIP]
Holley_msg53=[Star]
Holley_msg54=[High]
Holley_msg55=[Military]
Holley_msg56=[Holy]
Holley_msg57=[England]
Holley_msg58=[Honor]
Holley_msg59=[dictator]
Holley_msg60=[Saint]
Holley_msg61=[??]

A simple slip up in there and instead it say msg52 instead of [VIP]

 

[derwisz]

Coly: name in base is not changed,
Mauldor: I just add 200 Integrals to your virtual account on LostWorld server
now I've got VIP_Promilex
but what happened to my player if those options were only available on GM map, where no player can go? He had Msg61NickName name :/

 

[Demonic]

Well from what I can gather, MSG52 to 61 is to do Im sure with Rebirth. Bascially when you reach Level XX, you can go down XX levels and it then displays a Title, Re-check your INI file if it said MSG61 instead of what you wanted it to say.

 

[Coly]

I Know, Alter Settings and Title in GM Tab is the Setting for this Name System.

 

[RoNeZ]

yes check all the things mentioned here but from my experiences the exact odd phenomeny u described above happens if a char has a double entry in db..we had that on olymp after we switched from EI to JoB server ..all the chars which had this double entry in db never saved there actions ingame so they could give away all items/gold they had and after relog they had it again while the other char who took the items still had them (100% dupes hehe)

them 3 days was fun for my tao untill u banned it =/

:mooned::brows:

/ontopic hmm not played with cd much but erm try clear all dupes in db

 

[Jesterhead]

it must be a wrong entry in the db, cause the db isnt updated from the server.
look at the server message log, and find out how often the server updates the player (must be ~5 mins)
the use the utitilites provided by the MS-SQl Server to log the transfer between db and Game, and you should find out which entry is wrong.