Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Need help with a v19 server

Newbie Spellweaver
Joined
Apr 27, 2018
Messages
7
Reaction score
0
Hi everyone i've been attempting to set up a server with files from here: http://forum.ragezone.com/f457/release-dragon-cross-files-1118686/index2.html but am having the same problem as others there. There's replies telling you to use the CHARACTER_STR listed on that thread but i have a lot of errors with that. The last reply regarding the error is to remove the lines where the broken variables feature, but if i do that and keep doing it it never actually solves anything. Any help is much appreciated :)
 
Newbie Spellweaver
Joined
May 14, 2013
Messages
21
Reaction score
0
Can you post your errors? Are you using the correct database?
 
Newbie Spellweaver
Joined
Apr 27, 2018
Messages
7
Reaction score
0
I'm using the database included in the download on the thread. When i try to execute a query for the CHARACTER_STR the errors i get are:
Code:
Msg 102, Level 15, State 1, Procedure CHARACTER_STR, Line 168
Incorrect syntax near '@Oplayerslot'.
Msg 137, Level 15, State 1, Procedure CHARACTER_STR, Line 381
Must declare the scalar variable "@om_chLoginAuthority".
Msg 137, Level 15, State 2, Procedure CHARACTER_STR, Line 385
Must declare the scalar variable "@om_chLoginAuthority".
From what i can tell the first one can be fixed with a comma but when i fix that i then get these errors:
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 475
Invalid column name 'm_SkillPoint'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 476
Invalid column name 'm_SkillLv'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 477
Invalid column name 'm_SkillExp'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 502
Invalid column name 'm_dwMadrigalGiftExp'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 503
Invalid column name 'm_tmLogout'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 504
Invalid column name 'm_nPvpKills'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 505
Invalid column name 'm_nPvpDeads'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 507
Invalid column name 'GlowArmLeft'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 508
Invalid column name 'GlowArmRight'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 509
Invalid column name 'GlowLegLeft'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 510
Invalid column name 'GlowLegRight'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 511
Invalid column name 'GlowBody'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 512
Invalid column name 'GlowHandLeft'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 513
Invalid column name 'GlowHandRight'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 691
Invalid column name 'm_SkillPoint'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 692
Invalid column name 'm_SkillLv'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 693
Invalid column name 'm_SkillExp'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 718
Invalid column name 'm_dwMadrigalGiftExp'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 719
Invalid column name 'm_tmLogout'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 720
Invalid column name 'm_nPvpKills'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 721
Invalid column name 'm_nPvpDeads'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 723
Invalid column name 'GlowArmLeft'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 724
Invalid column name 'GlowArmRight'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 725
Invalid column name 'GlowLegLeft'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 726
Invalid column name 'GlowLegRight'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 727
Invalid column name 'GlowBody'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 728
Invalid column name 'GlowHandLeft'.
Msg 207, Level 16, State 1, Procedure CHARACTER_STR, Line 729
Invalid column name 'GlowHandRight'.
Which is basically impossible to fix, I've tried everything i can think of.
 
Last edited by a moderator:
Inactive
Joined
Jan 20, 2009
Messages
1,015
Reaction score
1,830
Please post in the correct section otherwise i will have to infract you.

-> Moved from Tutorials to Help.
 
It's a lemon thing
Joined
Dec 19, 2007
Messages
257
Reaction score
112
You're missing these columns, just create them:
Code:
'm_SkillPoint'

'm_SkillLv'

'm_SkillExp'

'm_dwMadrigalGiftExp'

'm_tmLogout'

'm_nPvpKills'

'm_nPvpDeads'

'GlowArmLeft'

'GlowArmRight'

'GlowLegLeft'

'GlowLegRight'

'GlowBody'

'GlowHandLeft'

'GlowHandRight'

'm_SkillPoint'

'm_SkillLv'

'm_SkillExp'

'm_dwMadrigalGiftExp'

'm_tmLogout'

'm_nPvpKills'

'm_nPvpDeads'

'GlowArmLeft'

'GlowArmRight'

'GlowLegLeft'

'GlowLegRight'

'GlowBody'

'GlowHandRight'
 
Newbie Spellweaver
Joined
Apr 27, 2018
Messages
7
Reaction score
0
I've just checked and i don't think i am missing the columns:


 
Junior Spellweaver
Joined
Dec 29, 2012
Messages
126
Reaction score
0
probably you used wrong database and readdad the character_str procedure. But do what the guys above me told you to solve
 
Newbie Spellweaver
Joined
Apr 27, 2018
Messages
7
Reaction score
0
Thanks for the help there, dunno why theres so many errors with this but just got a new one when i sorted the previous ones:
Code:
Msg 257, Level 16, State 3, Procedure CHARACTER_STR, Line 742
Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query.
 
Newbie Spellweaver
Joined
Apr 27, 2018
Messages
7
Reaction score
0
Literally cant figure this out, is there any easy way (for someone completely new to private server creating) to get a vanilla v19 server? or can someone make it for me and send me the files i need all sorted so i dont need to fix anything?
 
Inactive
Joined
Jan 20, 2009
Messages
1,015
Reaction score
1,830
Literally cant figure this out, is there any easy way (for someone completely new to private server creating) to get a vanilla v19 server? or can someone make it for me and send me the files i need all sorted so i dont need to fix anything?

You have some very unreal expectations if you think someone will give you a secure, fixed set of files for free.
 
Newbie Spellweaver
Joined
Apr 27, 2018
Messages
7
Reaction score
0
You have some very unreal expectations if you think someone will give you a secure, fixed set of files for free.

Why though? Nobody seems to give any help to new people here, I want to be able to start with a clean server, even if it's just fluff gold with 3rd job, elliun, Barbara and then I can figure out the rest from there.
 
Inactive
Joined
Jan 20, 2009
Messages
1,015
Reaction score
1,830
Why though? Nobody seems to give any help to new people here, I want to be able to start with a clean server, even if it's just fluff gold with 3rd job, elliun, Barbara and then I can figure out the rest from there.

Because flyff is now filled with a greedy and cancerous community that only cares about themselves. Sadly this has been the trend for awhile and has gotten worse over time. If someone was even nice enough to release such a thing people would easily resell it.

Start with a 15, merge 16+ in and fool around and then start adding the skin in.
 
Back
Top