Flash Gallery Hack v 1.1

New version 1.1 released, screenshots and what's new in the new version available here.

This is an extension of Erwin's Flash player hack. It creates a semi-database-driven gallery for all games/movies you have available with information such as author of Flash, size of file, thumbnail, link to run the file, username (if available) of person that sumbitted it, and a link to a leaderboard if available (currently only the Tetris available from john.eovie has that).

The Flash file controls work pretty much like the announcement ones (I got most of the code from there), and are very simple.

There are only two edits to files (an entry for Who's Online and inserting a link to the options in the admin control panel), plus an optional edit if you want to be able to prevent certain groups/people from using the gallery.

This is designed for vB 2.2.6 only, I did not test it with any other version of the board, technically it should work, but I cannot promise anything. This is my first hack as I am new to PHP, but I have done extensive testing to this and will try to help solve any problems if they arise to the best of my knowledge.

Thanks to Fallout2Man for helping me a lot with this hack.

Screenshots coming up in the next posts.

[Lanigironu]

I already did both.

[Lanigironu]

Ok, new version released. In this version you can turn off the gallery for maintanance, disable thumbnails and specify the number of entries per row/column. Extra entries split off into pages with the usual vB controls.

Here's a screenshot of the new admin controls (located with the rest of the vB settings):

[Lanigironu]

Here's a screenshot of the way it looks (I only had 2 entries per page because I have 4 in total, I wanted to see how it splits into pages, you can specify as many as you want):

[snyx]

I cant run any of these queries?

INSERT INTO `settinggroupid` ( `settinggroupid` , `title , `displayorder` ) VALUES ('32', 'Arcade Gallery Options', '32');

You have an error in your SQL syntax near 'displayorder` ) VALUES ('32', 'Arcade Gallery Options', '32')' at line 1

INSERT INTO `setting` ( `settingid` , `settinggroupid` , `title` , `varname` , `value` , `description` , `optioncode` , `displayorder` ) VALUES (NULL , '32', 'Aracde Gallery Active', 'aracde_on', '1', 'This will turn off the gallery. It can be useful when trying to add Aracde files or making modifications.', yesno', '1');

You have an error in your SQL syntax near '', '1')' at line 1

ack, what now

[Lanigironu]

Ok, I know what the problem is, the way PHPMySQL shows the queries is not even accepted by itself, quite funny. Basically you need to take out all the ` characters and it will work. I'll fix the instructions in a second.

Meanwhile, I have a little announcement about the future of this hack. I decided to integrate it with Erwin's Flash Player hack and make my own, free version of an arcade that will also play movies, manage the files and much more. The next version should be a fully functional gallery, and I hope to release it by the end of the week.

[Lanigironu]

Ok, I fixed the instructions, both for upgrading and installing, just redownload the attachment.

[snyx]

thx man

[snyx]

same deal man? huh..

INSERT INTO settinggroupid ( settinggroupid , title , displayorder ) VALUES ('32', 'Flash Gallery Options', '32');

Table 'formkao_vb.settinggroupid' doesn't exist

INSERT INTO setting ( settingid , settinggroupid , title , varname , value , description , optioncode , displayorder ) VALUES (NULL , '32', 'Flash Gallery Active', 'flash_on', '1', 'This will turn off the gallery. It can be useful when trying to add Flash files or making modifications.', yesno', '1');

You have an error in your SQL syntax near '', '1')' at line 1

[Lanigironu]

ARGH! This is absolutely ridiculous. Try these two queries:

INSERT INTO `settinggroupid` ( settinggroupid , title , displayorder ) VALUES ('32', 'Flash Gallery Options', '32');

And

INSERT INTO `setting` ( settingid , settinggroupid , title , varname , value , description , optioncode , displayorder ) VALUES (NULL , '32', 'Flash Gallery Active', 'flash_on', '1', 'This will turn off the gallery. It can be useful when trying to add Flash files or making modifications.', yesno', '1');

Or better yet, wait until futureal releases the vBProArcade hack. I will be integrating this hack into it.

[NeRilkA]

Great hack ! useful ! bravo

but it doesn't "recognize" DCR file.. when i add a DCR game to the gallery it shows 0kb

i think there is somethin to add but i don't exactly how..

PHP Code:

if (!strpos($filename,".")){
    $size = filesize("../".$filename.".swf");
    if ($size >= 1024){
      $size = (int)($size / 1024);
    }
  }else{
    $extra = strpos($filename,".");
    $cleanname = substr_replace($filename,'',$extra+4);
    $size = filesize("../".$cleanname);
    if ($size >= 1024){
      $size = (int)($size / 1024);
    }
  } 


thanks