That's kind of wierd in a way, i just did a fresh install with smokinz28 yesterday, on a site that didn't have timeslips on the site...when completed, it worked out perfectly:
http://www.f-bodyhideout.com/forums/timeslips.php?
It has all of the wording, and accept's all of the comands. I even put in my car's timeslip information and it took........I am wondering if my instruction's are kind of confusing since this post is all over the place? I had thought about doing a new thread for vb3.6 since it does update to vb3.6....
The one bit of confusion that i have noticed is about my query run's. If you go to your phpmyadmin, and look in the left hand column for profilefield, you will have to see what your field is named. My profilefield in phpmyadmin is vb3profilefield, some are vbprofilefield, and other's are just profilefield...you need to set the intitial queries to this setting as such:
PHP Code:
ALTER TABLE `vbprofilefield` ADD `title` VARCHAR( 25 ) DEFAULT 'aa' NOT NULL AFTER `profilefieldid` ;
or
PHP Code:
ALTER TABLE `vb3profilefield` ADD `title` VARCHAR( 25 ) DEFAULT 'aa' NOT NULL AFTER `profilefieldid` ;
or
PHP Code:
ALTER TABLE `profilefield` ADD `title` VARCHAR( 25 ) DEFAULT 'aa' NOT NULL AFTER `profilefieldid` ;
all this query is doing is adding the word "title" back to the profilefield, it was there on previous version's of vbulletin, but has been removed.
Then the second query is basically the same, you need to see what your profilefield name is, just like above:
PHP Code:
ALTER TABLE `profilefield` ADD `description` VARCHAR( 250 ) DEFAULT 'a' NOT NULL AFTER `title` ;
or
PHP Code:
ALTER TABLE `vb3profilefield` ADD `description` VARCHAR( 250 ) DEFAULT 'a' NOT NULL AFTER `title` ;
or
PHP Code:
ALTER TABLE `vbprofilefield` ADD `description` VARCHAR( 250 ) DEFAULT 'a' NOT NULL AFTER `title` ;
All this query is doing is adding the word "description" back to the profile field, again, it was there on previous version's of vbulletin, but has been removed from vb3.6.
These 2 queries, need to be the very first thing you do in order to not get confused on what is happening here. Then, after you run these 2 queries, make the following file edit's:
###### In image.php find:
if ($_REQUEST['type'] == 'profile') // do not modify this $_REQUEST
###### REPLACE IT WITH:
if ($_REQUEST['type'] == 'profile' or $_REQUEST['type'] == 'timeslip') // do not modify this $_REQUEST
###### FIND:
else
{
$table = 'customavatar';
}
###### ABOVE THIS ADD:
else if ($_REQUEST['type'] == 'timeslip')
{
$data = 'timeslippicdata';
$table = 'customfile';
}
###### In member.php find:
// *********************
// CUSTOM PROFILE FIELDS
// CUSTOM PROFILE FIELDS
$profilefields = $db->query_read_slave("
SELECT profilefieldid, required, type, data, def, height
FROM " . TABLE_PREFIX . "profilefield
WHERE form = 0 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
AND hidden = 0") . "
ORDER BY displayorder
");
###### Replace it with:
// *********************
// CUSTOM PROFILE FIELDS
$profilefields = $db->query_read_slave("
SELECT profilefieldid, required, title, type, data, def, height
FROM " . TABLE_PREFIX . "profilefield
WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND form = 0 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), "
AND hidden = 0") . "
ORDER BY displayorder
");
###### In includes/functions_user.php find:
'signature',
'profile',
###### Add below:
'vehicleprofile',
###### Find:
// ###################### Start getprofilefields #######################
function fetch_profilefields($formtype = 0) // 0 indicates a profile field, 1 indicates an option field
{
global $vbulletin, $stylevar, $customfields, $bgclass, $show;
global $vbphrase, $altbgclass, $bgclass1, $tempclass;
// get extra profile fields
$profilefields = $vbulletin->db->query_read_slave("
SELECT * FROM " . TABLE_PREFIX . "profilefield
WHERE editable IN (1,2)
AND form " . iif($formtype, '>= 1', '= 0'). "
ORDER BY displayorder
");
###### Replace it with:
// ###################### Start getprofilefields #######################
function fetch_profilefields($formtype = 0) // 0 indicates a profile field, 1 indicates an option field
{
global $vbulletin, $stylevar, $customfields, $bgclass, $show;
global $vbphrase, $altbgclass, $bgclass1, $tempclass;
// get extra profile fields
$profilefields = $vbulletin->db->query_read_slave("
SELECT * FROM " . TABLE_PREFIX . "profilefield
WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND editable IN (1,2)
AND form " . iif($formtype, '>= 1', '= 0'). "
ORDER BY displayorder
");
###### In your USERCP_SHELL template find:
<tr>
<td class="$navclass[profile]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td>
</tr>
###### Below it add:
<tr>
<td class="$navclass[vehicleprofile]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=edittimeslip">$vbphrase[edit_timeslip]</a></td>
</tr>
###### In your navbar template find:
<td class="vbmenu_control"><a href="memberlist.php?$session[sessionurl]">$vbphrase[members_list]</a></td>
###### Below it add:
<td class="vbmenu_control"><a href="timeslips.php?$session[sessionurl]">$vbphrase[timeslips]</a></td>
Once these edit's are completed and saved back into your site's database, upload timeslips.php to your forum's root directory (/forums/) then // Upload slipicon.gif to your forum's misc image directory (/forums/images/misc/) or what ever your forums root directory is. Mine happen's to be forums/.....
After all of this has been done, you will now Go to your product link, then add new product by uploading the product-timeslips.xml file.
If you did this step by step, you shoudn't see the "aa" or the "a"......
However, if you have already run the query and are having issue's with this not showing correctly, go back to your phpmyadmin, open the profilefield, and look to see if you have the word "title" and "description" in there. If so, put a check mark in front of "title" and "description", and look up just a bit and click on the word "drop", this will remove "title" and "description" from your server. With that done, run the query that best fit's your site from the above queries (Still in phpmyadmin), look at the left navigation bar, and up at the top, the third icon over "sql", is where you need to run the queries from.
After you have rerun the queries, and you know for sure that you have all the file edit's done, go back to your admincp, and rerun the product timeslips.xml, and select overwrite......now check your www/yoursite/forums/timeslips.php and see what is there, and then click on submit your timeslip at the bottom of the box that appears.....It may take about 15 minutes to reupdate depending on the size of your site, but it WILL work......
hotwheels
More Information