random notes

[scottish]

Uploaded ibProArcade to the test forum and disabled vBArcade

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

Show Hide data

dbtech_vbarcade_data
gameid, local_winner, global_user, global_link, global_score, local_plays, local_avgscore, local_timespent, global_plays, global_avgscore, global_timespent, ratings, avgrating, favorites, comments, history_winner, commentthreadid, reportthreadid

52 rows

Show Hide game

dbtech_vbarcade_game
gameid, enabled, displayorder, title, description, instructions, controls, keywords, author, copyright, timestamp, width, height, decimals, scoring, tourns, system, license, flashfile, icon, badge, jackpot

52 rows

Show Hide session

dbtech_vbarcade_session
sessionid, global, gameid, label, userid, ipaddress, timestart, timefinish, status, record, score, verify, chain, comment, matchid

44,200 rows

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.

[scottish]

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.

[scottish]

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.

[scottish]

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.

[Tom]

@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)

[scottish]

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

[scottish]

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

[Tom]

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

[scottish]

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

[scottish]

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

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