Hi there

i've a litte prob

look at the picture pls

thx

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

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

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

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.

Bison, I am getting the exact same message.

Come on. Please post a fix for this.

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

<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?