Results 1 to 14 of 14

Thread: [2008] Binary to Hexadecimal (String)

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Jan 2009
    Posts
    51

    [2008] Binary to Hexadecimal (String)

    So the server I am running has a database of players equipment, I am trying to write a program to see if they are hacking by comparing the item requirement with the stats the player has, to do this I need to convert the varbinary(512) column from the SQL Database too a Hexadecimal string, then from that string remove certain parts of it.

    Example:
    This is the hexadecimal code for an item:
    Code:
    0x440047000028000000000000896B4685
    the part I need is "4400" numbers (Position 3,4,5,6 from start) I then need to flip these backwards so it reads "0044". I then will compare this itemIDX with a list of items I have set aside that people mainly use this hack for.

    So the main things I need help with, are converting varbinary(512) to hexadecimal and then making my program bring a list of accountID's up who are using the hack, here is how the databases are set out:

    Account:
    Contains account data ONLY
    Game:
    Contains the Character and Equipment DB

    i need to compare the equipmentDB, then return the CharacterID from the equipmentID, compare that ID with the CharacterID in CharacterDB, then extract the accountID then return the account name from the accountDB

    I don't know how the binary is split up from item too item, although I would imagine, it isn't, i would have thought it just goes onto the next item when the item ends.
    Although, all the items start with hex string "0x" so this may be the separator!

    If somone knows a set of SQLQuerys this would also help, thanks a lot!

    -02goswej
    Last edited by 02goswej; Jan 26th, 2009 at 04:50 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width