Need Query for !!!EQUIPED!!! New character default items.

Results 1 to 8 of 8
  1. #1
    Member Andriusha is offline
    MemberRank
    Nov 2017 Join Date
    LithuaniaLocation
    36Posts

    Need Query for !!!EQUIPED!!! New character default items.

    Need Query for !!!EQUIPED!!!, not in inventory , equiped New character default items.


  2. #2
    HITMAN CAPITOL is offline
    True MemberRank
    Apr 2013 Join Date
    PhilippinesLocation
    706Posts

    Re: Need Query for !!!EQUIPED!!! New character default items.

    “Knowledge, like air, is vital to life. Like air, no one should be denied it.”

  3. #3
    Account Upgraded | Title Enabled! gmrote is offline
    True MemberRank
    May 2013 Join Date
    284Posts

    Re: Need Query for !!!EQUIPED!!! New character default items.

    Last edited by gmrote; 01-02-18 at 01:54 PM. Reason: fffff
    • skype live:rote2011 Click "Like" button if I helped you.

  4. #4
    KarLi is offline
    ModeratorRank
    May 2009 Join Date
    Not in my headLocation
    16,014Posts

    Re: Need Query for !!!EQUIPED!!! New character default items.

    Quote Originally Posted by gmrote View Post
    and where's the sql code?

  5. #5
    Member Andriusha is offline
    MemberRank
    Nov 2017 Join Date
    LithuaniaLocation
    36Posts

    Re: Need Query for !!!EQUIPED!!! New character default items.

    @CAPITOL i need query for already EQUIPED items on start

  6. #6
    Alpha Member DragonSeth is online now
    Alpha MaleRank
    Aug 2011 Join Date
    2,712Posts

    Re: Need Query for !!!EQUIPED!!! New character default items.

    Quote Originally Posted by Andriusha View Post
    @CAPITOL i need query for already EQUIPED items on start
    Use this thread: Newly created Character with starting items [ SQL Query Script] and replace the serial numbers with your own.

  7. #7
    Member Andriusha is offline
    MemberRank
    Nov 2017 Join Date
    LithuaniaLocation
    36Posts

    Re: Need Query for !!!EQUIPED!!! New character default items.

    EQUIPED ! not in inventory

  8. #8
    Alpha Member DragonSeth is online now
    Alpha MaleRank
    Aug 2011 Join Date
    2,712Posts

    Re: Need Query for !!!EQUIPED!!! New character default items.

    Just Read The Thread Don't Do The Update Part.

    NOTE:

    This is only tested in MSSQL 2000

    If you want to test this in to other SQL Server version
    USE IT IN YOUR OWN RISK (Make sure you backup your Database

    Requirements:

    MSSQL 2000
    Titan Editor (Not sure with Mu Editor)
    A brain :)

    Sample Code :

    Leather Set +13 + Luck + FO Serials + 2 sword of assasin

    Code:
    04EFFF000000007F0000000000000000 <-- SERIAL OF sword of assasin
    056FFF000000007F0070000000000000 helm
    056FFF000000007F0080000000000000 armor
    056FFF000000007F0090000000000000 pants
    056FFF000000007F00A0000000000000 gloves
    056FFF000000007F00B0000000000000 boots
    866FFF000000007F00C0000000000000 wings
    You just need to copy the serial of the item and paste it in notepad

    This is the chronological order of the characters equipment

    right hand, left hand , helm, armor, pants, gloves, boots, wings, pet, pendant, right ring, left ring

    NOTE:

    It must be in chronological order or your characters item will be a walking KRIS :)

    check my sample code above

    now this time the SQL Script

    Code:
    Use [MuOnline]
    UPDATE DefaultClassType
    SET Inventory = 0x04EFFF000000007F000000000000000004EFFF000000007F0000000000000000056FFF000000007F0070000000000000056FFF000000007F0080000000000000056FFF000000007F0090000000000000056FFF000000007F00A0000000000000056FFF000000007F00B0000000000000866FFF000000007F00C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF14081E000000000000D000000000000014101E000000000000D0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
    WHERE Class = '16'

    check the red text its the serial of sword of assasin
    the blue text is the class number of character 16 = dark knight

    NOTE:
    If you dont want the new characters to have a specified item you need to add this
    FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF

    Example you only want 1 sword of assasin
    this will be the code

    Code:
    UPDATE DefaultClassType
    SET Inventory = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF04EFFF000000007F0000000000000000056FFF000000007F0070000000000000056FFF000000007F0080000000000000056FFF000000007F0090000000000000056FFF000000007F00A0000000000000056FFF000000007F00B0000000000000866FFF000000007F00C0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF14081E000000000000D000000000000014101E000000000000D0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
    WHERE Class = '16'
    the right hand will be empty slot

    For those people who messed up their starting items this is the code for the default starting items

    Code:
    UPDATE DefaultClassType
    SET Inventory = 0x
    WHERE Class = '16'
    Again change the Class code
    Spoiler:

    ClassID
    DK = 16
    ELF = 32
    WIZ = 0
    MG = 48
    DL = 64
    SUM = 80
    RF = 96


    This will put it on the character and not the (INVENTORY)



Advertisement