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.

[Termi]

Hi there

i've a litte prob

look at the picture pls

thx

[Bison]

Hey guys,

I keep getting this error when I run the first query of this hack:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: CREATE TABLE flash (
flashid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
userid INT( 10 ) UNSIGNEDDEFAULT '0' NOT NULL ,
name VARCHAR( 100 ) NOT NULL ,
filesize INT( 5 ) DEFAULT '0' NOT NULL ,
filename VARCHAR( 50 ) NOT NULL ,
thumb VARCHAR( 100 ) NOT NULL ,
author VARCHAR( 50 ) NOT NULL ,
type VARCHAR( 50 ) NOT NULL ,
height INT( 5 ) DEFAULT '480' NOT NULL ,
width INT( 5 ) DEFAULT '640' NOT NULL ,
dateline INT( 10 ) UNSIGNEDDEFAULT '0' NOT NULL ,
leaderboardurl VARCHAR( 50 ) NOT NULL ,
INDEX ( userid )
)
mysql error: You have an error in your SQL syntax near 'UNSIGNEDDEFAULT '0' NOT NULL ,
name VARCHAR( 100 ) NOT NULL ,
filesize INT( 5 ' at line 3

[WCW Fan]

Would it be possible to be able to link the flash media from another source other than your forum root as I want to put the flash on my personal server and then use it for the gallery so is it possible

[Gizmo99]

Ok Installed change the relavent bits as the download is wrong.

Question

3b says u can stop people seeing the gallery. How ??? have set a user so they cant see it and they still can !!! Also can find re reference to the checking if they can/cant see it it in gallery.php

Please help I and trying to make it so some user groups can't see it

Cheers

Giz

[StrykerContact]

Oh man this hack is totally bogus...so far the first 3 sql queries do not work and I have had to change some of the parts to get it to work, now I'm stuck on the third one. This hack should not be here, the instructions for the mysql queries are not working. Somebody post a correct install.txt with fixed queries. Thanks.

[Holidazed]

Bison, I am getting the exact same message.

Come on. Please post a fix for this.

[Holidazed]

Bison, I figured this part out.

This is the query you should use.

CREATE TABLE flash (
flashid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
userid INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ,
name VARCHAR( 100 ) NOT NULL ,
filesize INT( 5 ) DEFAULT '0' NOT NULL ,
filename VARCHAR( 50 ) NOT NULL ,
thumb VARCHAR( 100 ) NOT NULL ,
author VARCHAR( 50 ) NOT NULL ,
type VARCHAR( 50 ) NOT NULL ,
height INT( 5 ) DEFAULT '480' NOT NULL ,
width INT( 5 ) DEFAULT '640' NOT NULL ,
dateline INT( 10 ) UNSIGNE DDEFAULT '0' NOT NULL ,
leaderboardurl VARCHAR( 50 ) NOT NULL ,
INDEX ( userid )
);

[gmarik]

<a href="http://www.otaku-haven.com/forum/showgallery.php?gallery=games" target="_blank">http://www.otaku-haven.com/forum/sho...?gallery=games</a> is not working for me. Any demos?