Need help with a v19 server

Results 1 to 9 of 9
  1. #1
    Newbie ergilly is offline
    MemberRank
    Apr 2018 Join Date
    4Posts

    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
    Registered Bartjak is offline
    MemberRank
    May 2013 Join Date
    NetherlandsLocation
    23Posts

    Re: Need help with a v19 server

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

  3. #3
    Newbie ergilly is offline
    MemberRank
    Apr 2018 Join Date
    4Posts

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

  4. #4
    dεεz иυтѕ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    636Posts

    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 AM ONLY KETCHUP ON RAGEZONE!
    ALL GAME RELATED PM'S WILL BE IGNORED.
    Discord [¤] Facebook [¤] Rules [¤] Subscribe [¤] Support

  5. #5
    It's a lemon thing FilixXx is online now
    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
    Newbie ergilly is offline
    MemberRank
    Apr 2018 Join Date
    4Posts

    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
    dεεz иυтѕ Ketchup is offline
    ModeratorRank
    Jan 2009 Join Date
    636Posts

    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 AM ONLY KETCHUP ON RAGEZONE!
    ALL GAME RELATED PM'S WILL BE IGNORED.
    Discord [¤] Facebook [¤] Rules [¤] Subscribe [¤] Support

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

    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
    Newbie ergilly is offline
    MemberRank
    Apr 2018 Join Date
    4Posts

    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.



Advertisement