Convert items to r63b

Results 1 to 3 of 3
  1. #1
    Valued Member Flowy Otaku is offline
    MemberRank
    Feb 2013 Join Date
    113Posts

    Convert items to r63b

    TokenID: 0Invalid Dario bug duing user login: System.NullReferenceException: Object reference not set to an instance of an object.
    at Butterfly.HabboHotel.Items.UserItem..ctor(UInt32 Id, UInt32 BaseItem, String ExtraData, UInt32 rareid, String groupstring, UInt32 placedBy) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\HabboHotel\Items\UserItem.cs:line 48
    at Butterfly.HabboHotel.Users.UserDataManagement.UserDataFactory.GetUserData(String sessionTicket, String ip, Byte& errorCode) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\HabboHotel\Users\UserDataManagement\UserDataFactory.cs:line 300
    at Butterfly.HabboHotel.GameClients.GameClient.tryLogin(String AuthTicket) in C:\Users\Felipe\Desktop\Reverse\Debug\Swift - AKllX Edition\Butterfly\HabboHotel\GameClients\GameClient.cs:line 242

    i get that when i use this sql becuase i'm trying to convert my phoenix items to r63b items, i'm using the swift revision 5, do anyone know the problem?

    INSERT INTO items_users (item_id, user_id) SELECT id, user_id FROM items;
    INSERT INTO items_extradata (item_id, data) SELECT id, extra_data FROM items WHERE extra_data != '';
    ALTER TABLE `items`
    DROP COLUMN `user_id`,
    DROP COLUMN `room_id`,
    DROP COLUMN `extra_data`,
    DROP COLUMN `x`,
    DROP COLUMN `y`,
    DROP COLUMN `z`,
    DROP COLUMN `rot`,
    DROP COLUMN `wall_pos`,
    CHANGE COLUMN `id` `item_id` int(10) UNSIGNED NOT NULL FIRST ,
    CHANGE COLUMN `base_item` `base_id` int(11) UNSIGNED NOT NULL AFTER `item_id`,
    ADD COLUMN `rareid` int(11) NOT NULL AFTER `base_id`,
    ADD COLUMN `group_data` varchar(200) NOT NULL AFTER `rareid`,
    ADD COLUMN `placedBy` int(10) NOT NULL AFTER `group_data`;
    Best wishes
    Flowy


  2. #2
    Check http://arcturus.pw The General is offline
    DeveloperRank
    Aug 2011 Join Date
    7,610Posts

    Re: Convert items to r63b

    It'd be more efficient to modify your emulator instead of your database.

  3. #3
    Valued Member Flowy Otaku is offline
    MemberRank
    Feb 2013 Join Date
    113Posts

    Re: Convert items to r63b




Advertisement