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.

[Demonslayer]

I made the sql table myself but it doesn't seem to work properly....

[Lanigironu]

Hmmm.... Something is wrong. I copied and pasted the outputed command that PHPMyAdmin gave me, but when I try it in the SQL window it gives me the same error.

I'll see if I can figure it out.

[Lanigironu]

Ignore this post. Thanks to futureal, the query is in my next post.

[Demonslayer]

I still get errors...

(Btw. shouldn't this "CREATE TABLE 'flash2'" say flash, not flash2?

[Lanigironu]

Ok, here's the fixed query, thanks to futureal:

CREATE TABLE flash (
   flashid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
   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) UNSIGNED NOT NULL DEFAULT '0',
   leaderboardurl VARCHAR(50) NOT NULL,
   INDEX (userid)
 )

[Lanigironu]

Yes, yes it should. Sorry about that. I was trying to make a new table to see if it works, instead of overwriting my own one.

[Lanigironu]

There, it's all fixed now. I'll replace it in the instructions.

[Lanigironu]

Done.

[Demonslayer]

thanks

[Demonslayer]

you should fix your instructions and that query with 1 thing.....the table name is flash, not flash2