[Help] Binary data in SQL

Results 1 to 3 of 3
  1. #1
    The truth seeker -_- Dode is offline
    MemberRank
    Feb 2013 Join Date
    384Posts

    [Help] Binary data in SQL

    Hello, I'd like to ask if someone knows how can I view binary data in my column "<Binary>" I want to copy from 1 column and make it as default Heximal code, if not then I want another thing does anyone has Binary code of Dark Stone (Combo quest)???


  2. #2

    Re: Binary data in SQL

    I also tried to figure this out but failed lol here was my attempt:


    No Quest
    1111 1111 =(11111111)2 = (FF)16 = FFh

    Scroll Of Emperor
    1111 1110 = (11111110)2 = (FE)16 = FEh

    Treausures Of Mu
    1111 1010 = (11111010)2 = (FA)16 = FAh

    Hero Status
    1110 1010 = (11101010)2 = (EA)16 = EAh

    Dark Stone
    1010 1010 = (10101010)2 = (AA)16 = AAh

    Proof of Strenght
    1010 1010 1111 0110 = (1010101011110110)2 = (AAF6)16 = AAF6h

    Kill Balgass's Minions
    1010 1010 1111 1010 = (1010101011111010)2 = (AAFA)16 = AAFAh

    The Dark Elf General
    1010 1010 1111 1010 1111 0110 = (101010101111101011110110)2 = (AAFAF6)16 = AAFAF6h


    0 = 0000
    1 = 0001 = 2*5 = 0010
    2 = 0010
    3 = 0011
    4 = 0100 = 4*25 = 0100
    5 = 0101
    6 = 0110 = 4*25+


    im trying to figure out how mumaker Class codes multiply * 2 when updating Class Code
    ex: FEFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF = first quest
    FAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF = Second quest
    etc etc
    FF = 0
    then FE = 1
    and then FA =
    then EA =
    then AA =


    SM = +1

    0 = DW

    16 = DK

    32 = ELF

    48 = MG

    64 = DL

    80 = SUM

    96 = RF

  3. #3
    [Help] Binary data in SQL LarvasFaint is offline
    MemberRank
    Nov 2008 Join Date
    IngressLocation
    1,307Posts

    Re: Binary data in SQL

    1.If you need binary code for darkstone pass that quest in-game.
    2.Use SELECT statement to view binary data.
    3. ????
    4.Profit.
    Last edited by LarvasFaint; 18-01-17 at 03:41 PM.



Advertisement