vb.org Archive - vBGarage v3.1.1 (now with GD-Lib support!)

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)

And also... is there a way that in the template, instead of "Check out my ride" I can be like "My Ride: 1999 Ford Mustang" and get that info from the info I put in teh vbgarage?

Quote:

Originally Posted by magnus

Just an update. v3.2.0 is coming along nicely. There's much more AdminCP control over how vBGarage acts now. I'm also devising a variable template engine, which will sort of allow you to design HOW you want the users detail input to be displayed. The template will be populated by the users input, rather than having the user design the "template" themselves, as they do now.

I'm also considering making some of the variables more 'global', so you can call them rather easily from other portions of the site. For instance, if you wanted to call the "Latest Uploads" from FORUMHOME, etc. Though, this is secondary, at the moment. :)

Oh, and there is definately going to be a need for database restructuring in v3.2.0. I'm hoping I can devise a "migration"-type script. Otherwise, there's going to be a little (read: repititious/tedious) work involved for the admin (read: YOU!). :)

If anyone here is a SQL genius, and would like to help with this migration-script, shoot me a PM. I'm decent with SQL, but by no means do I know it inside and out (yet).

I'm just wondering when this new one will come out and whats its new features?

If I can make a suggestion.....it would be cool that you would be able to sort by year of car, make, model, newest car, etc. When our sites get huge and have thousands of cars, it would be hard to sort out all the ones that you want. For example if you loved SVT's, you wouldn't want to look at the V6's and so on :)

Also, a feature that would be cool would be some kind of a rating system, something like cardomain uses. You know you can rate everything on their ride like the overall appearance, sound, performance, etc.

I think those would be some cool freatures. But hey, I'm lovin this hack so far, one of the best in my books!

Quote:

Originally Posted by muscle-mustangs

Yes, sorting is implemented. At the momemt, I do have rating, however it's not what I would consider ready to be released. So, I'm not sure if it'll be out in v3.2.0. Possibly as an upgrade.

Keep in mind, v3.2.0 is a major upgrade. I still have to shift alot of focus on (hopefully) developing a migration script for your current database. I'll feel terrible if people are forced to start their databases from scratch.

Quote:

Originally Posted by Shahrum

I think something's wrong with the variable used in the if statement because w/o the if statement, it works fine!

Use this query instead:

[SQL] $posts = $DB_site->query("
SELECT
post.*, vbgarage_users.*, vbgarage_users.userid AS vbgarage, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*,
" . iif($forum['allowicons'], 'icon.title as icontitle, icon.iconpath,') . "
" . iif($vboptions['avatarenabled'], 'avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,') . "
" . iif($vboptions['reputationenable'], 'level,') . "
" . iif(!$deljoin, 'NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,') . "
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
" . iif(!can_moderate(), $datastore['hidprofilecache']) . "
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
" . iif($forum['allowicons'], "LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON(icon.iconid = post.iconid)") . "
" . iif($vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)") .
iif($vboptions['reputationenable'], " LEFT JOIN " . TABLE_PREFIX . "reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)") . "
" . iif(!$deljoin, "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')") . "
LEFT JOIN " . TABLE_PREFIX . "editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "vbgarage_users AS vbgarage_users ON(vbgarage_users.userid = user.userid)
WHERE $postids
ORDER BY dateline $postorder
");[/SQL]

Quote:

Originally Posted by Shahrum

And also... is there a way that in the template, instead of "Check out my ride" I can be like "My Ride: 1999 Ford Mustang" and get that info from the info I put in teh vbgarage?

Then, use this in your postbit:

HTML Code:

<if condition="$post['vbgarage']"><br><div><a href="vbgarage.php?$session[sessionurl]do=view&id=$post[userid]">My Ride: $post[year] $post[make] $post[model]</a></div></if>

That should do it! ;)

Since 3.2 will be a major upgrade, for those of us who are holding off installing until it's release...IF WE ALL SWEAR NOT TO HOLD YOU TO IT UNDER PENALTY OF HOT BAMBOOSHOOTS STUCK UNDER OUR FINGERNAILS...could you give us a guesstimate on when you might release 3.2? Days...or weeks?
Thanks.

Quote:

Originally Posted by spence2

Well, provided your prior disclaimer holds true.. about a week. I'm shooting for next weekend (possibly sooner). I was trying for this weekend, except I've been out of town in training this weekend. /sigh

Quote:

Originally Posted by magnus

We aren't in any hurry, just make it easy to install for us Newbes, and we won't mind :)

Won't mind at all.
Thanks!

Geeze, I go away for a few days and there is all this now.........Whew.

Question, has anyone come up with how to place the "latest uploads" panel on other pages, such as the forum home or vba page?

Quote:

Originally Posted by joeychgo

Geeze, I go away for a few days and there is all this now.........Whew.

Question, has anyone come up with how to place the "latest uploads" panel on other pages, such as the forum home or vba page?

Just place the following code in the respective PHP file:

PHP Code:


		
			
$result_latest = $DB_site->query("

    SELECT vbgarage_images.* 

    FROM " . TABLE_PREFIX . "vbgarage_images

    ORDER BY vbgarage_images.id DESC 

    LIMIT 5

");

    

while ($latest = $DB_site->fetch_Array($result_latest))

{

    eval('$latestbits .= "' . fetch_template('vbgarage_latestbits') . '";');

}



$DB_site->free_result($result_latest);

Be sure to add the following line to the $globaltemplates(); array, too.

PHP Code:


		
			
        'vbgarage_latestbits',

Then, just add [high]$latestbits[/high] into the template you want it displayed in.

X vBulletin 3.8.12 by vBS Debug 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_html_printable (2)bbcode_php_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01801 seconds Memory Usage 1,767KB 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_html_printable (2)bbcode_php_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)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
Messages: