vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBGarage v3.1.1 (now with GD-Lib support!) (https://vborg.vbsupport.ru/showthread.php?t=63681)

Silverstangs 11-24-2004 10:24 PM

Do I need to change the top one to
PHP Code:

vbgarage_images ORDER BY vbgarageid DESC LIMIT 5 

Actually it didn't work...

Silverstangs 11-24-2004 10:29 PM

Is there a different way to get the latest images to show up on another page?

Natch 11-24-2004 10:32 PM

OK: I'm not sure if this has been posted yet, but I was working on a client vB and they were running this hack...

I had never seen this hack before, but a mod jumped out at me as needing doing...

find:
PHP Code:

    $navbits construct_navbits(array('' => 'vBGarage'));
    eval(
'$navbar = "' fetch_template('navbar') . '";');
    
    eval(
'print_output("' fetch_template('vbgarage_viewgarage') . '");'); 

replace with
PHP Code:

    $navbits construct_navbits(array('vbgarage.php' => 'vBGarage''' => "$user[username]'s Garage"));
    eval(
'$navbar = "' fetch_template('navbar') . '";');
    
    eval(
'print_output("' fetch_template('vbgarage_viewgarage') . '");'); 

This will create an easy link back to the Garage homepage in the navbar, and the viewed garage will have the user's name in the navbar and consequently the <title tags also...

Action-N 11-24-2004 11:56 PM

Quote:

Originally Posted by magnus
Action-N, have you gotten any of my PM's? I haven't gotten any replies, so I'm just wondering.. :D

Yeah, I get'em an read them. Never been good at getting back to people's emails, probably why I don't have a girlfriend as there always wanting to talk. I wanted to get the lastest work into the installer then add some comments for you then I'll zip you up a copy. No word from Integra99 so I don't think people want to wait for him, I'll send you the zip he gave me so you can see what work he did from your version.


Silverstangs, assuming your getting that error from the index.php code you can swap part of it with the code below. Replace the query part with this that's not critical of what the tables name is. Hopefully this will work for you, since I have never tried to put vbgarage images on the forum index before.

Code:

$result_latest = $DB_site->query("
    SELECT *
    FROM " . TABLE_PREFIX . "vbgarage_images
    ORDER BY vbgarageid DESC
    LIMIT 5
");


Natch, yeah I already had that one pointed out a few times. But my post is lost amongst these posts now, lol. The next version will have all the breadcrumb links going on, plus they'll be using phrases so the newbies won't have to hack the vbgarage code.

Ya know, there outta be a way for the thread owner to tag a post as important/must read so we can click a link that will list all the important/tagged posts.

Silverstangs 11-25-2004 01:06 AM

Quote:

Originally Posted by Action-N

Silverstangs, assuming your getting that error from the index.php code you can swap part of it with the code below. Replace the query part with this that's not critical of what the tables name is. Hopefully this will work for you, since I have never tried to put vbgarage images on the forum index before.

Code:

$result_latest = $DB_site->query("
    SELECT *
    FROM " . TABLE_PREFIX . "vbgarage_images
    ORDER BY vbgarageid DESC
    LIMIT 5
");


BINGO!!!!!!!

That was it, thank you so much!!!

My lession of the day... don't hack while sick!

alkatraz 11-25-2004 07:07 AM

Great hack, thank you!

Rick Sample 11-25-2004 04:45 PM

Any word on the new release yet lol or should another coder or I try to code one for you guys :)

PennylessZ28 11-25-2004 04:58 PM

Yes, I'm interested in the same subject as well.

flstreetscene 11-25-2004 06:14 PM

EDIT: the garage is working (at least I can view it as an admin);

http://www.floridastreetscene.com/fo...ge.php?do=list

however you can't view it as a member and there is no option in admincp to set up permissions...

This could be from the error I received during installation;

Code:

Database error in vBulletin 3.0.3:

Invalid SQL:
                CREATE TABLE vbgarage_images (
                  `vbgarageid` smallint(6) unsigned NOT NULL auto_increment,
                  `userid` int(10) unsigned NOT NULL default '0',
                  `name` varchar(50) NOT NULL default '',
                  `data` longblob NOT NULL,
                  `type` varchar(50) NOT NULL default '',
                  PRIMARY KEY  (`vbgarageid`)
                ) TYPE=MyISAM AUTO_INCREMENT=1
       
mysql error: Table 'vbgarage_images' already exists

mysql error number: 1050

Date: Thursday 25th of November 2004 08:33:47 PM
Script: http://www.floridastreetscene.com/forums/admincp/install_vbgarage.php
Referer: http://www.floridastreetscene.com/forums/admincp/install_vbgarage.php

There is already a previous database that I tried to install it over. How could I fix this?

Action-N 11-25-2004 07:23 PM

Quote:

Originally Posted by flstreetscene
however you can't view it as a member and there is no option in admincp to set up permissions...

There is already a previous database that I tried to install it over. How could I fix this?

Set permisions by going to Usergroups/Usergroup Manager click go button next to registered users an scroll down to General Permissions. At the bottom of that table you should see "Can use vBGarage?". However you could have another problem specified earlier. Open up your Int.php file like in the install readme and post the last few fieds of the genericpermissions field. You don't want to see to numbers there the same.

If the installation gets interupted it wont finish, obviously, but when going back through it doesn't check itself for previous versions an does what you noticed breaks an doesn't finish. I made an uninstaller that you can use to uninstall the database files an truly start over without having already exsists errors. The link to the file is posted in the original post at the bottom.


All times are GMT. The time now is 05:09 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02589 seconds
  • Memory Usage 1,756KB
  • 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
  • (3)bbcode_code_printable
  • (3)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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