Discover Habbo's history
Treat yourself with a Secret Santa gift.... of a random Wiki page for you to start exploring Habbo's history!
Happy holidays!
Celebrate with us at Habbox on the hotel, on our Forum and right here!
Join Habbox!
One of us! One of us! Click here to see the roles you could take as part of the Habbox community!


Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: random notes

  1. #1
    Join Date
    Jul 2004
    Location
    Scotland
    Posts
    17,702
    Tokens
    60,948
    Habbo
    Habbic

    Latest Awards:

    Default random notes

    Uploaded ibProArcade to the test forum and disabled vBArcade

    The 3 primary tables seem to be data, game, session

    data


    game


    session


    So session seems to hold every game attempt and game/data hold the info on each game.

    Can you send me through the following 52 games please

    Asteroids
    Ms Pacman
    Bejeweled 2
    2 Ball Pool
    Chopper
    Asha Golf
    Snake
    Tetris
    FA18 Strike Force
    Optus Tennis Challenge
    Crazycars
    Pepsi Pinball
    Monkey Flight
    Pepsi Handball
    Ball A Track
    Ballistic Biscuit
    Ping Pong II
    Space Invaders
    Bajabug
    Angry Birds
    Bloody Pingu
    1-i
    2048 Flash
    Big Diamond 2
    Bozzle
    Froggy 2
    Ace Blackjack
    Bass Fishing Pro
    BattleShip
    Breakout
    An Irritating Game
    Balance 2
    Archery 2000
    Brain Buster
    Solitaire
    Whack a Space Mole
    Winter Bells
    Atomic Puzzle
    Crazy Chess
    Chess
    3D Pool
    Ball Bounce
    Blocks
    Connect2
    Bonus Pong
    Flash Stars
    Over The Bridge
    Basketball Christmas
    Click Santa
    Christmas Shooter
    Slay With Santa
    Santas Cannon v2


    if you can get me them I can add them to ibProArcade then try importing the scores from the current sessions table.

    @Chris; you're probably best person for the games as I believe you added them? if they're on the server let me know where and I'll grab them from there.

  2. #2
    Join Date
    Jul 2004
    Location
    Scotland
    Posts
    17,702
    Tokens
    60,948
    Habbo
    Habbic

    Latest Awards:

    Default

    Ms Pacman
    Bejeweled 2
    2 Ball Pool
    Chopper
    Asha Golf
    FA18 Strike Force
    Crazycars
    Ballistic Biscuit
    Bloody Pingu


    are now the only games I'm missing as they're not on the server.

  3. #3
    Join Date
    Jul 2004
    Location
    Scotland
    Posts
    17,702
    Tokens
    60,948
    Habbo
    Habbic

    Latest Awards:

    Default

    Okay so currently done:

    - Fixed issue where existing arcade had '0' as the time finished, this would cause problems going forward (as it has timestarted set so the time different would be negative 1700000 odd which isnt a valid amount of time spent in a game), simply set this to copy the 'timestarted' field so timespent will be 0 rather than invalid

    - Imported session ID, member ID, score, comments and the date in which the score was obtained from existing arcade
    - Imported user names into table (previous table didn't use names, only user IDs)
    - Imported time spent (simply the time finished less time started on existing tables)
    - Imported Game IDs (existing IDs were 'Asteroid', 'Tetris, 'Snake' etc where as now it's 1, 2, 3)
    - Imported total score (didn't exist previously)
    - Imported total time spent in the game (didn't exist previously)
    - Imported best score (just finding max score on existing table)
    - Imported best user (just finding member ID of best scorer)
    - Imported best time (just finding timespent based on highest score)
    - Imported total plays (didn't exist previously)


    Tomorrow I'll be looking to import the 'champs' table and I think that's pretty much it.

  4. #4
    Join Date
    Jul 2004
    Location
    Scotland
    Posts
    17,702
    Tokens
    60,948
    Habbo
    Habbic

    Latest Awards:

    Default

    nvm score tools takes care of that rather than having to import it into the database.

    So it seems like it's good to go now, will speak to ghana tomorrow.
    Like xxMATTGxx Liked

  5. #5
    Join Date
    Jun 2005
    Posts
    2,850
    Tokens
    3,979
    Habbo
    Skynus

    Latest Awards:

    Default

    @scottish; I sent a link in Skype, but to also put it here:
    http://habboxforum.com/hidbcoidmcpo3cnsn8/1iibpro.zip

    The missing games should be in there (I checked for a couple).

    Don't know if you've seen, but there's also 4 inactive games - not sure if there's a reason for them being inactive but they are:
    3D Pool
    Basketball Christmas
    Bonus Pong
    Chess

    Some have plays (though not very high)
    Last edited by Tom; 24-10-2016 at 08:15 AM.
    Like scottish Liked

  6. #6
    Join Date
    Jul 2004
    Location
    Scotland
    Posts
    17,702
    Tokens
    60,948
    Habbo
    Habbic

    Latest Awards:

    Default

    Yeah I was just going to port them over and deactivate on hew arcade, don't want to lose any scores really cause you know what people are like

    I'll have a look when I'm on comp, I grabbed all the ones from ./dbtech/vbarcade/import I think it was

  7. #7
    Join Date
    Jul 2004
    Location
    Scotland
    Posts
    17,702
    Tokens
    60,948
    Habbo
    Habbic

    Latest Awards:

    Default

    okay I'm on computer, yeah those are the main game files so missing the file for install (includes the objective, keys, game name, etc).

    Regardless I've imported the scores but just used high game ID's for them, all games are gid between 1 and 47.

    Chopper is using gid 1001
    FA18StrikeForceDR_v32 1002
    etc

    so if we do find them and import them it's simply a case of updating 1001 to 48 depending on the game ID that each game uses and I don't think we'll reach 1001 gid any time soon

  8. #8
    Join Date
    Jun 2005
    Posts
    2,850
    Tokens
    3,979
    Habbo
    Skynus

    Latest Awards:

    Default

    Ah, sorry! Hmm strange... I'll try and find them but I can't say I know where they'd be

    - - - Updated - - -

    # find . -name "*crazycars*"
    ./dbtech/vbarcade/media/Crazycars/crazycars.PNG
    ./dbtech/vbarcade/media/Crazycars/crazycars.swf

    # find . -name "*bejeweled*"
    ./dbtech/vbarcade/import/minebejeweled.zip
    ./dbtech/vbarcade/import/temp/minebejeweled
    ./dbtech/vbarcade/import/temp/minebejeweled/minebejeweled.swf
    ./dbtech/vbarcade/import/temp/minebejeweled/__MACOSX/._minebejeweled.swf

    Not sure where they are, unless they're oddly named

  9. #9
    Join Date
    Jul 2004
    Location
    Scotland
    Posts
    17,702
    Tokens
    60,948
    Habbo
    Habbic

    Latest Awards:

    Default

    yeah I found them but that's extracted unfortunately.

    oh well we can import them later if we find them but it doesn't seem they're currently on the forum at least in the import format.

    - - - Updated - - -

    - Removed 'class="postdetails"' from dbtech_thanks_postbit_entries
    on <div ... id="dbtech_thanks_entries_{vb:var post.postid}">
    - Removed '<vb:if condition="!$show['thanks_nouserinfo']">class="userinfo"</vb:if>' from dbtech_thanks_postbit_entries_entrybit
    on <div ... style="width:auto;">


    Site Skin 2011 - Done
    The Dojo - Done
    Habboxed - Done
    Avenger - Fixed - Done
    vB4 Default - Won't be touching this
    Habbox Site Skin 2010 - Done
    Halloween 2011 - Done
    Classic - Done
    Non Habbo Light - Done
    Non Habbo Pink - Done
    Non Habbo Dark - Done
    Last edited by scottish; 24-10-2016 at 08:55 PM.

  10. #10
    Join Date
    Jul 2004
    Location
    Scotland
    Posts
    17,702
    Tokens
    60,948
    Habbo
    Habbic

    Latest Awards:

    Default

    can we get mod in this forum and have some kind of changelog

    i don't like changing stuff and not having it documented

Page 1 of 2 12 LastLast

Posting Permissions

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