vb.org Archive - Flash Gallery Hack v 1.1

Page 2 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Flash Gallery Hack v 1.1 (https://vborg.vbsupport.ru/showthread.php?t=42674)

NeRilkA

09-06-2002 04:28 PM

and there is another problem, if we have more than 3 pages, the third page turn back to the first one... :(

Lesane

10-15-2002 07:26 AM

Quote:

Originally posted by Lanigironu
ARGH! This is absolutely ridiculous. Try these two queries:

Code:

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

And

Code:

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.

settinggroupid don't exists! You need to add it in settinggroup. The query should be:

Code:

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

And for the second query, you forgot a ' near yesno' so it should be:

Code:

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

And in step2 you have: 'unsigneddefault' 2 times. That ain't working, it must be 'unsigned default'. ;)

Cyberhouse

10-29-2002 06:34 AM

Quote:

Originally posted by Lesane

settinggroupid don't exists! You need to add it in settinggroup. The query should be:

Code:

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

Code:

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

mysql error: Duplicate entry '32' for key 1



mysql error number: 1062

I?m getting this error when i?m trying to run that query. Can somebody tell me why ? ;)

Cyberhouse

10-29-2002 09:57 AM

Quote:

Originally posted by Cyberhouse

Code:

Invalid SQL: INSERT INTO `settinggroup` ( settinggroupid , title , displayorder ) VALUES ('32', 'Flash Gallery Options', '32'); mysql error: Duplicate entry '32' for key 1 mysql error number: 1062

I?m getting this error when i?m trying to run that query. Can somebody tell me why ? ;)

Hmm sorry, but I have found why it?s not working ;)

Erwin

10-29-2002 05:43 PM

change the value 32, to NULL and it will work. :)

Visionray

10-30-2002 10:08 PM

This hack works great, much better than the other addon in my opinion.

You really should update your zip file on the first page though, I had to debug a lot of your code.

Thanks though, works great now!

Visionray

10-30-2002 11:27 PM

$user = $DB_site->query_first("SELECT username FROM user WHERE

userid='$flashinfo[userid]'");
$username = $user[username];
$userid = $flashinfo[userid];

There seems to be a problem with this code here. In the gallery, the "submitted by" never shows the username.

Oxygen

01-18-2003 03:37 PM

When I surpase several pages (2) it continues to load the first pages worth of flash files/thumbs?

Any ideas

Oxygen

01-18-2003 06:33 PM

you have incorrect PHP (or it could have been my mistake implementing it)

$pagestart = ($pagenumber - 1) * $ppage;
should be:
$pagestart = ($pagenumber - 1) * $perpage;

Shadow_NL

03-01-2003 05:25 AM

I have this hack installed but I don't really like it, could anyone tell me how I can remove the database entries?

Thanks in advance.

Termi

03-10-2003 08:50 PM

Hi there

i've a litte prob

look at the picture pls

thx

Bison

04-24-2003 12:59 PM

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

07-29-2003 06:24 PM

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

08-02-2003 04:05 PM

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

09-20-2003 06:43 PM

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

10-14-2003 11:50 PM

Bison, I am getting the exact same message.

Come on. Please post a fix for this.

Holidazed

10-15-2003 01:49 AM

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

10-19-2003 04:41 PM

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

All times are GMT. The time now is 12:56 AM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01069 seconds Memory Usage 1,757KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (18)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: