[Silverstangs]

Hey Magnus & Action-N
For the Add-on Add "latest Uploads" to FORUMHOME by magnus..

When I use the following in your instructions for Vb 3.0.1 it works fine but......
it does not work when I use those for vb 3.0.3. on my test machine or main forum.


In index.php:
FIND:

PHP Code:

// ### WELCOME MESSAGE ################################################# 


Add ABOVE:

PHP Code:

// START VBGARAGE HACK 
// ### VBGARAGE ######################################################### 
$result_latest = $DB_site->query(" 
    SELECT vbgarage_images.* 
    FROM " . TABLE_PREFIX . "vbgarage_images 
    ORDER BY vbgarage_images.vbgarageid DESC 
    LIMIT 5 
"); 
      
while ($latest = $DB_site->fetch_Array($result_latest)) 
{ 
    eval('$latestbits .= "' . fetch_template('vbgarage_latestbits') . '";'); 
} 

$DB_site->free_result($result_latest); 
// END VBGARAGE HACK 


In includes/init.php
Find:

PHP Code:

// field names for general permissions
$_BITFIELD['usergroup']['genericpermissions'] = array(
    'canviewmembers'           => 1,
    'canmodifyprofile'         => 2,
    'caninvisible'             => 4,
    'canviewothersusernotes'   => 8,
    'canmanageownusernotes'    => 16,
    'canseehidden'             => 32,
    'canbeusernoted'           => 64,
    'canprofilepic'            => 128,
    'canuseavatar'             => 512,
    'canusesignature'          => 1024,
    'canusecustomtitle'        => 2048,
    'canseeprofilepic'         => 4096,
    'canviewownusernotes'       => 8192,
    'canmanageothersusernotes' => 16384,
    'canpostownusernotes'      => 32768,
    'canpostothersusernotes'   => 65536,
    'caneditownusernotes'      => 131072,
    'canseehiddencustomfields' => 262144, 


And add:

PHP Code:

    'canvbgarage'              => 524288, 


************************************* CHANGES I HAD TO DO***************
For vb 3.0.3. I had to use the following changes to your instructions in
order to get the Add-on Add "latest Uploads" to FORUMHOME by magnus..
for vbgarage to work. I tried it on 4 different test machines, two running 3.0.1
and two running 3.0.3. Freash installs for all 4 attempts, with the timeslips
hack and vbadvanced installed. I seem to run into two issues. The first issue
is with index.php. I get the error that I posted earlier

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT vbgarage_images.*
FROM vb3vbgarage_images
ORDER BY vbgarage_images.vbgarageid DESC
LIMIT 5

mysql error: Unknown table 'vbgarage_images'

mysql error number: 1051

Date: Wednesday 24th of November 2004 08:19:06 AM
Script: http://www.stangcountry.com/forums/index.php?
Referer: http://www.stangcountry.com/forums/...dex.php?do=head
Username: Silverstangs
IP Address: 69.xxx.xxx.xxx

The second is with init.php. I'm not sure exactly what the issue is
but I have noticed that I can not use any number higher than 262144.
When I attempt to use the number 524288 it seems to have the option
Can use vBGarage? in the Usergroup Manager under
General Permissions to always be set to No for all the
users except for the admins. I attempt to switch it on, with several different
computers, and it won't stick. I get the same results with the test machines.
I don't know if you can confirm the issue I have found, but hopefully this can
help you all or someone else.

************************************************** **********************


In index.php:
FIND:

PHP Code:

// ### WELCOME MESSAGE ################################################# 


Add ABOVE:

PHP Code:

// START VBGARAGE HACK 
// ### VBGARAGE ######################################################### 
$result_latest = $DB_site->query(" 
    SELECT * 
    FROM " . TABLE_PREFIX . "vbgarage_images 
    ORDER BY vbgarageid DESC 
    LIMIT 5 
"); 
      
while ($latest = $DB_site->fetch_Array($result_latest)) 
{ 
    eval('$latestbits .= "' . fetch_template('vbgarage_latestbits') . '";'); 
} 

$DB_site->free_result($result_latest); 
// END VBGARAGE HACK 


In includes/init.php
Find:

PHP Code:

// field names for general permissions
$_BITFIELD['usergroup']['genericpermissions'] = array(
    'canviewmembers'           => 1,
    'canmodifyprofile'         => 2,
    'caninvisible'             => 4,
    'canviewothersusernotes'   => 8,
    'canmanageownusernotes'    => 16,
    'canseehidden'             => 32,
    'canbeusernoted'           => 64,
    'canprofilepic'            => 128,
    'canuseavatar'             => 512,
    'canusesignature'          => 1024,
    'canusecustomtitle'        => 2048,
    'canseeprofilepic'         => 4096,
    'canviewownusernotes'       => 8192,
    'canmanageothersusernotes' => 16384,
    'canpostownusernotes'      => 32768,
    'canpostothersusernotes'   => 65536,
    'caneditownusernotes'      => 131072,
    'canseehiddencustomfields' => 262144, 


REPLACE with:

PHP Code:

// field names for general permissions
$_BITFIELD['usergroup']['genericpermissions'] = array(
    'canviewmembers'           => 1,
    'canmodifyprofile'         => 2,
    'canvbgarage'              => 4,
    'canviewothersusernotes'   => 8,
    'canmanageownusernotes'    => 16,
    'canseehidden'             => 32,
    'canbeusernoted'           => 64,
    'canprofilepic'            => 128,
    'canuseavatar'             => 512,
    'canusesignature'          => 1024,
    'canusecustomtitle'        => 2048,
    'canseeprofilepic'         => 4096,
    'canviewownusernotes'       => 8192,
    'canmanageothersusernotes' => 16384,
    'canpostownusernotes'      => 32768,
    'canpostothersusernotes'   => 65536,
    'caneditownusernotes'      => 131072,
    'canseehiddencustomfields' => 262144,
    'caninvisible'             => 524288, 


Thanks --Scott
--Silverstangs