vb.org Archive
Page 1 of 5 1 23 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBgarage (https://vborg.vbsupport.ru/forumdisplay.php?f=104)
-   -   Multiple Cars/Garages for vBGarage (https://vborg.vbsupport.ru/showthread.php?t=75014)

noppid 01-24-2005 04:42 PM
Multiple Cars/Garages for vBGarage
 
I wrote some code today. I'm using some code snippets and the basic logic that magnus sent me. I believe the author was Action-N and magnus. Thanks again to both of them for sharing. We needed some logic, code, and templates to do this addition and again they cheerfully provided them.

vBGarage public release will be an adaptation using the above logic, some edited code, and some edited templates. If you have seen those branchs of the code, you may see some similarities and some differences in the adaptation.

You can see what I have so far at my Computer Rigs Forum. I have two garages set up to view. I really need a few testers to register and login to test using the garage to provide feedback on addition work.

There are database changes, template changes, template additions, and an updated vbgarage.php so far. URL's are also affected by including/passing addition variables.

Comments are needed in this thread, please give us your two sense and we'll see where the chips fall.

Here's the list of changes so far...
Quote:
// New vbgarage.php

// New vB file edits
Who's online instructions will be included

// Database changes

Table: vbgarage_comments
added field `vbgarageid`
added index on field `vbgarageid`

Table: vbgarage_users
dropped Primary Index on field `userid`
added field `garageid` int(10) unsigned NOT NULL auto_increment,
added index PRIMARY KEY (`garageid`),
added index KEY `userid` (`userid`)

Table: vbgarage_images
added field `id` smallint(6) unsigned NOT NULL default '0',
added index KEY `id` (`id`),
added index KEY `userid` (`userid`)

// templates changed

vbgarage_editgarage
vbgarage_editimagebits
vbgarage_imagebits
vbgarage_latestbits
vbgarage_listbits
vbgarage_viewgarage
vbgarage_commentbits
vbgarage_listgarage
vbgarage_popup

// template additions

vbgarage_editparkedbits
vbgarage_parkedbits
vbgarage_parkedlist
vbgarage_randombits
vbgarage_inactive_warning
vbgarage_error

//new settings
vbgwysiwyg
grouptitle = vbgarage
value = 1
default = 1
optioncode = yesno
displayorder = 60
advanced = 0
volatile = 0

// new phrases
Globals
vbgarage_alert_off = The Garage is Currently Turned OFF!!! Only Admins can see the Garage!
vbgarage_parked_cars = Car List
vbgarage_gallery = Photo Gallery
vbgarage_add_edit = (Add/Edit your Car)

Setting Phrases
setting_vbgwysiwyg_desc = Use the WYSIWYG Editor?
setting_vbgwysiwyg_title = Editor Options

// images
Two new images
forums/images/misc/deletegarage.gif
forums/images/misc/editgarage.gif
Thanks for your time.

cinq 01-24-2005 11:32 PM
Here's what I am using for mine ( well not exactly, i changed it quite a bit, but this should present the gist of the table structures. )

Code:
#
# Table structure for table `vbgarage_comments`
#

CREATE TABLE `vbgarage_comments` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `garageid` int(10) unsigned NOT NULL default '0',
  `username` varchar(50) NOT NULL default '',
  `pagetext` text NOT NULL,
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `vbgarage_images`
#

CREATE TABLE `vbgarage_images` (
  `imageid` int(10) unsigned NOT NULL auto_increment,
  `garageid` 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  (`imageid`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `vbgarage_ratings`
#

CREATE TABLE `vbgarage_ratings` (
  `rateid` int(10) NOT NULL auto_increment,
  `garageid` int(10) NOT NULL default '0',
  `userid` int(10) NOT NULL default '0',
  `rating` int(10) NOT NULL default '0',
  PRIMARY KEY  (`rateid`)
) TYPE=MyISAM AUTO_INCREMENT=1;

# --------------------------------------------------------

#
# Table structure for table `vbgarage_users`
#

CREATE TABLE `vbgarage_users` (
  `garageid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `text` text,
  `lastactivity` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`garageid`)
) TYPE=MyISAM AUTO_INCREMENT=1;

noppid 01-24-2005 11:54 PM
Quote:
Originally Posted by cinq
Here's what I am using for mine ( well not exactly, i changed it quite a bit, but this should present the gist of the table structures. )

Appreciate it, but I'm done. The list above reflects what I did, not intened to do. ;)

In case you're interested, here's what the tables look like...

PHP Code:
CREATE TABLE `vbgarage_users` (
 `userid` int(10) unsigned NOT NULL default '0',
 `year` varchar(50) NOT NULL default '',
 `make` varchar(50) NOT NULL default '',
 `model` varchar(50) NOT NULL default '',
 `text` mediumtext NOT NULL,
 `lastactivity` int(10) unsigned NOT NULL default '0',
 `garageid` int(10) unsigned NOT NULL auto_increment,
 PRIMARY KEY  (`garageid`),
 KEY `userid` (`userid`)
) TYPE=MyISAM



CREATE TABLE `vbgarage_images` (
 `vbgarageid` smallint(6) unsigned NOT NULL auto_increment,
 `userid` int(10) unsigned NOT NULL default '0',
 `id` smallint(6) unsigned NOT NULL default '0',
 `name` varchar(50) NOT NULL default '',
 `data` longblob NOT NULL,
 `type` varchar(50) NOT NULL default '',
 `thumb` longblob NOT NULL,
 PRIMARY KEY  (`vbgarageid`),
 KEY `id` (`id`),
 KEY `userid` (`userid`)
) TYPE=MyISAM

CREATE TABLE `vbgarage_comments` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `vbgarageid` int(10) unsigned NOT NULL default '0',
 `username` varchar(50) NOT NULL default '',
 `pagetext` mediumtext NOT NULL,
 `dateline` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 KEY `vbgarageid` (`vbgarageid`)
) TYPE=MyISAM 

cinq 01-25-2005 12:32 AM
Opps.
What kind of comments are you looking for then ?

noppid 01-25-2005 12:47 AM
Quote:
Originally Posted by cinq
Opps.
What kind of comments are you looking for then ?
You're right, I was not very clear. I need some folks to go to my computer site and beat on the garage there for testing.

Thanks

noppid 01-26-2005 04:02 PM
OK folks, I can't call this new code tested till I get some folks to try it out. I'm not ready to let anyone beta test it yet and I have no immediate plans for release, but I need help debugging.

Come on over to http://www.cpurigs.com/forums please and register and test the multicar vBGarage.

P.S. Upgrading to multicar mode will require vBGarage 4.0.0 to have been installed first.

oly51 01-26-2005 11:35 PM
Just uploaded "Multiples" to the test page.
Only issue, After you upload the image, you are taken back to the Submit screen. Hit "Submit' and you remain at that screen. It does not take you to the garage so you don't know if it uploaded or not.

Works great otherwise. I'll give it a shot whenever you are ready! :D

Also noticed that when you click on the thumb, the google ads are in front of the full size image.

noppid 01-27-2005 01:32 AM
Quote:
Originally Posted by oly51
Just uploaded "Multiples" to the test page.
Only issue, After you upload the image, you are taken back to the Submit screen. Hit "Submit' and you remain at that screen. It does not take you to the garage so you don't know if it uploaded or not.

Works great otherwise. I'll give it a shot whenever you are ready! :D

Also noticed that when you click on the thumb, the google ads are in front of the full size image.
You know if the image was uploaded because it appears in the uploaded images list on the edit page you are taken back to. Then I have edited my directions next to that panel to let the users know to click on members garages to exit that page. This way you can upload a few images in a row easily.

What browser are you using when you see the ads in front of the full size image? I cannot duplicate that in IE or Firefox.

Thanks

oly51 01-27-2005 02:16 AM
Quote:
Originally Posted by noppid
What browser are you using when you see the ads in front of the full size image? I cannot duplicate that in IE or Firefox.
Thanks
Opera 7.54 (It does work ok on IE)

noppid 01-27-2005 02:24 AM
Interesting. That may be a show stopper? The script is from 2003. I wonder if there is an update or similar more current version?


All times are GMT. The time now is 02:46 AM.
Page 1 of 5 1 23 Last »
Show 40 post(s) from this thread on one page

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.01699 seconds
  • Memory Usage 1,771KB
  • 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
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (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