Need help with a v19 server

Results 1 to 13 of 13
  1. #1
    Registered ergilly is offline
    MemberRank
    Apr 2018 Join Date
    8Posts

    Need help with a v19 server

    Hi everyone i've been attempting to set up a server with files from here: [Release] Dragon Cross Files 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 :)


  2. #2
    Member Bartjak is offline
    MemberRank
    May 2013 Join Date
    NetherlandsLocation
    26Posts

    Re: Need help with a v19 server

    Can you post your errors? Are you using the correct database?

  3. #3
    Registered ergilly is offline
    MemberRank
    Apr 2018 Join Date
    8Posts

    Re: Need help with a v19 server

    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 Ketchup; 17-05-18 at 02:40 AM. Reason: Please use code tags, easier on the eyes for everyone else! Thanks :)

  4. #4
    Retired Staff Ketchup is offline
    SubscriberRank
    Jan 2009 Join Date
    Flyff.CodesLocation
    694Posts

    Re: Need help with a v19 server

    Please post in the correct section otherwise i will have to infract you.

    -> Moved from Tutorials to Help.
    I may not respond to pm's due to a lack of time.

  5. #5
    It's a lemon thing FilixXx is offline
    True MemberRank
    Dec 2007 Join Date
    Why u care?Location
    520Posts

    Re: Need help with a v19 server

    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'

  6. #6
    Registered ergilly is offline
    MemberRank
    Apr 2018 Join Date
    8Posts

    Re: Need help with a v19 server

    I've just checked and i don't think i am missing the columns:


    https://imgur.com/qUsG6am

  7. #7
    Retired Staff Ketchup is offline
    SubscriberRank
    Jan 2009 Join Date
    Flyff.CodesLocation
    694Posts

    Re: Need help with a v19 server

    Quote Originally Posted by ergilly View Post
    I've just checked and i don't think i am missing the columns:


    https://imgur.com/qUsG6am
    He means columns in the CHARACTER_TBL not CHARACTER_STR.
    I may not respond to pm's due to a lack of time.

  8. #8
    Hardcore Member rickaapje is offline
    MemberRank
    Dec 2012 Join Date
    NederlandsLocation
    123Posts

    Re: Need help with a v19 server

    probably you used wrong database and readdad the character_str procedure. But do what the guys above me told you to solve

  9. #9
    Registered ergilly is offline
    MemberRank
    Apr 2018 Join Date
    8Posts

    Re: Need help with a v19 server

    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.

  10. #10
    Registered ergilly is offline
    MemberRank
    Apr 2018 Join Date
    8Posts

    Re: Need help with a v19 server

    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?

  11. #11
    Retired Staff Ketchup is offline
    SubscriberRank
    Jan 2009 Join Date
    Flyff.CodesLocation
    694Posts

    Re: Need help with a v19 server

    Quote Originally Posted by ergilly View Post
    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.
    I may not respond to pm's due to a lack of time.

  12. #12
    Registered ergilly is offline
    MemberRank
    Apr 2018 Join Date
    8Posts

    Re: Need help with a v19 server

    Quote Originally Posted by Ketchup View Post
    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.

  13. #13
    Retired Staff Ketchup is offline
    SubscriberRank
    Jan 2009 Join Date
    Flyff.CodesLocation
    694Posts

    Re: Need help with a v19 server

    Quote Originally Posted by ergilly View Post
    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.
    I may not respond to pm's due to a lack of time.



Advertisement