The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
vB Timeslip Database - for Automotive websites Details »» | ||||||||||||||||||||||||||||
vB Timeslip Database - for Automotive websites
Developer Last Online: Jul 2011
Yes, finally I can release it here the converted version off Timeslips database for vbulletin 3.5.x. I made it as a product, try to change the file edits into plugin as best as I could but you still need to edit 2 files (optional). I can't think of an easy way to remove that but if anyone can, please pop in.
I've made the timeslips.php page XHTML valid. Of course the look has not been changed. Also made it fully phrased. The permission is granted here Please let me copy what EvilLS1 posted in the 3.0 hack Quote:
Files to edit: (2)- member.php (1), functions_user.php (2), image.php(2) Files to upload: (2)- timeslips.php, slipicon.gif Templates to edit: (2)- USERCP_SHELL, navbar Templates to add: 0 Phrases to add: 0 Why do I still have to edit files ? The reasons for those editions are because you don't want users to see the timeslips profile fields in the memberlist/member profile/edit profile and just that. So that means if you exclude those the hack will still work whatever Installation instructions: BACK UP EVERYTHING BEFORE INSTALLING ANY HACK Firstly please read the file Instructions.txt file on how to install this hack. the steps are: Import the product-timeslips.xml file. Do file and template editions. Upload files to correct folder. Then enjoy it ! I have tried all that I can by installing this hack on a fresh board and solved *almost* all the problem. But if you find any errors, please post it here (just do not duplicate things :P ). Upgrading I haven't had a chance to do the upgrade because I convert this for a fresh vb3.5 board. I've set up things that I think it's ready for the upgrade. I'm willing to test the upgrade on your board if anyone can give. For the upgrade to work, you must use the latest version of timeslips which can be taken from here: https://vborg.vbsupport.ru/showthread.php?t=60945 Support I'll try my best to give supports. But please understand due to my heavy busy I may miss your post. Please understand. Screenshots? The shots from its 3.0 version are fine. here's the link: https://vborg.vbsupport.ru/showthrea...ight=timeslips Changes Logs 03/18/2006: version 1.1 Fully phrased the hack. 03/19/2006: fix the problem showing your current timeslip image when editing your timeslip. To upgrade simply re-import product-timeslips.xml. 03/19/2006: fixed a few bugs in this post: https://vborg.vbsupport.ru/showpost....9&postcount=31 . Again to upgrade just reimport the product file. 03/20/2006: Hack version change to 1.1.3: Changed the field of field 52,53,55 to decimal (6,3). Added one more file editions into the instructions file to fix showing proper image. So bad to add another file edit but this is becaus there is no hook in image.php. this is how to do it: PHP Code:
03/23/2006: Update: fix a JS error when submitting the new timeslip. (Thanks Sidewindr). Also the new product will attempt to remove your old vb3.0 options then add the new ones, this is for upgrading from timeslips for vb3.0 to vb3.5 . I didn't test that tho. 12/05/2006: Version 1.2 for vb3.6 released. 12/09/2006: minor fix for missing adding field50. 12/12/2006: fix the error: Fatal error: Call to undefined function build_hiddenprofilefield_cache() in C:\Program Files\xampp\htdocs\folder\admincp\plugin.php(1468) : eval()'d code on line 6 Please click install if you use this hack for updates. https://vborg.vbsupport.ru/vborg_mis...hreadid=110717 This hack is free (why not?) but donation are welcome, my paypal is bloodynightcrawler@gmail.com . Thank you. end of presentation, hope I don't miss anything. Show Your Support
|
Благодарность от: | ||
too_cool_3 |
Comments |
#702
|
|||
|
|||
Adding an additional custom field to Timeslips. ************NOTES************ This is an update of EvilLS1's instructions located HERE. His instructions were for vB Timeslip Database v2.1 (for the 3.0.X version of VBulletin). The instructions below update his very helpful post for use with the newest version of the vB Timeslip Database (v1.2) utilizing 3.68 PL2. Adding an additional custom field to the Timeslips Database is a bit involved and due to the fact the original modification involves file edits, this addition does as well. In the example used below, we are adding a single selection dropdown menu to add a field "Vehicle Color". Obviously, you can add any field you want, but make sure to change the specific answers and field names from the example below to suit your needs. Also, (when reading the instructions below) please note that wherever you see "XX" on a file edit, you should be entering the fieldID # of the new custom profile field you created in place of "XX". Files to Edit (3): member.php, timeslips.php, includes/functions_user.php Templates to Edit (2): Timeslips, timeslipbit Products to Edit (2): Update timeslips data, vehicledetails As always, please backup your database and keep original copies of all modified files. ************CREATE NEW CUSTOM FIELD************ AdminCP > User Profile Fields > Add New User Profile Field Choose Single-Selection Menu from the dropdown menu and click Continue Fill out the profile form as follows (obviously replacing the profile field title, description and choices with your own) Title: Vehicle Color Description: Enter whatever description you would like Profile Field Category: (Uncategorized) Options: Separate each option with a new-line (carriage return): Red Blue Green Default Value: Leave blank Max Length of allowed user input: 25 Field Length: 25 Display order: Whatever you want Field Required: No Field Editable by user: Yes Private Field: No Field Searchable on Members List: No Show on Members List: No Allow user to input their own value for this option: No Max length of allowed user input: 25 Field Length: 25 Regular Expression: 0 Which page displays this option? Edit Profile Save this new profile field and MAKE NOTE OF THE FIELD ID# in the User Profile Field Manager. ************FILE EDITS************ Open members.php Find this line: Code:
WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND pf.form = 0 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), " Code:
WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,XX) AND pf.form = 0 " . iif(!($permissions['genericpermissions'] & $vbulletin->bf_ugp_genericpermissions['canseehiddencustomfields']), " Open includes/functions_user.php Find this line: Code:
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) Code:
WHERE profilefieldid NOT IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,XX) AND editable IN (1,2) Open timeslips.php Find this line: Code:
$natasp='N/A'; Code:
$red = 'Red'; $blue = 'Blue'; $green = 'Green'; Code:
else if ($_REQUEST['do'] == 'na') { $condition.=" AND userfield.field65='" . addslashes($natasp) . "' AND userfield.field55>'".intval($number)."'"; $cond.=" WHERE userfield.field65='" . addslashes($natasp) . "' AND userfield.field55>'".intval($number)."'"; $orderby="userfield.field55"; $direction=ASC; $bracket13="<b>[</b>"; $bracket14="<b>]</b>"; } add BELOW (again, replacing XX with your custom field name and changing the blue colored text to match your profile field choices): Code:
else if ($_REQUEST['do'] == 'red') { $condition.=" AND userfield.fieldXX='$red' AND userfield.field55>'".intval($number)."'"; $cond.=" WHERE userfield.field55!=''"; $orderby="userfield.field55"; $direction=ASC; $bracket133="<b>[</b>"; $bracket143="<b>]</b>"; } else if ($_REQUEST['do'] == 'blue') { $condition.=" AND userfield.fieldXX='$blue' AND userfield.field55>'".intval($number)."'"; $cond.=" WHERE userfield.field55!=''"; $orderby="userfield.field55"; $direction=ASC; $bracket133="<b>[</b>"; $bracket143="<b>]</b>"; } else if ($_REQUEST['do'] == 'green') { $condition.=" AND userfield.fieldXX='$green' AND userfield.field55>'".intval($number)."'"; $cond.=" WHERE userfield.field55!=''"; $orderby="userfield.field55"; $direction=ASC; $bracket133="<b>[</b>"; $bracket143="<b>]</b>"; } Still in timeslips.php, find this line: Code:
$spacer=" - "; and add the following below: Code:
$color = "---"; also find this line: Code:
$pos++; and add this below it (again, replacing XX with your custom field name): Code:
$color = $userinfo[fieldXX]; ************TEMPLATE EDITS************ In your timeslips template find: Code:
<td bgcolor="{categorybackcolor}" colspan="5" class="tcat"><b> Timeslip Database Replace with Code:
<td bgcolor="{categorybackcolor}" colspan="6" class="tcat"><b> Timeslip Database find: Code:
<option value="timeslips.php?$session[sessionurl]&do=na">N/A cars only</option> add below it: Code:
<option value="timeslips.php?$session[sessionurl]&do=red">Red</option> <option value="timeslips.php?$session[sessionurl]&do=blue">Blue</option> <option value="timeslips.php?$session[sessionurl]&do=green">Green</option> find: Code:
<td class="thead" align="center">$bracket13<b>Induction</b>$bracket14</td> add below it: Code:
<td class="thead" align="center">$bracket133<b>Color</b>$bracket143</td> find: Code:
<td class="tfoot" colspan="10"> replace with: Code:
<td class="tfoot" colspan="11"> In the timeslipbit template: Find: Code:
<td class="alt2">$induction</td> and below it add: Code:
<td class="alt1">$color</td> ************PRODUCT EDITS************ Go to Plugin manager and scroll down to the Timeslips Database section. Edit "Update timeslips data" Find this line: Code:
WHERE profilefieldid IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65) AND editable IN (1,2) Replace with this (replace XX with your new custom field number): Code:
WHERE profilefieldid IN (50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,XX) AND editable IN (1,2) Edit "vehicledetails" Find this line: Code:
WHERE profilefieldid IN (50,51,52,53,54,55,56,58,59,60,61,62,63,64,65) AND form = 0 Replace with this (replace XX with your new custom field number): Code:
WHERE profilefieldid IN (50,51,52,53,54,55,56,58,59,60,61,62,63,64,65,XX) AND form = 0 |
#703
|
|||
|
|||
I tried to install this on my new 3.6.8 v2 forum, but it hasn't gone smoothly so far. I followed the instructions that were in the instructions file for 3.6.
In UserCP there is a space where the "vehicle profile" should be but it is empty there's no link on the navbar either URL is http://stangtech.org/forums I have used this on an earlier version of vB and would really like to have in for my new site. Please help!! I'm about ready to restore to before the install and just hang it up |
#704
|
|||
|
|||
I tried accessing your timeslips.php page and got a database error, so something funky is going on.
Quote:
|
#705
|
|||
|
|||
I started getting multiple database errors and had to start over from scratch. Thankfully, the forum is brand new so nothing was really lost.
|
#706
|
|||
|
|||
Installed but when I click details, it only takes me to the users profile.
I think a lot of the phrasing is not correct for vb 3.6.8 which is some of my problem. The page title is also not showing up. There are a few items not showing up like the "Sort By". It only shows ":". But when I replaced the vbphrase with Sort By it showed up fine. Also the second last question when submitting the information has a yes or no question but nothing is written there. The yes and no options are listed but nothing else. How can I edit what needs to be there? SVT |
#707
|
||||
|
||||
|
#708
|
|||
|
|||
My only problem is the phrasing. It is not all showing up correctly like the page title, etc.
SVT |
#709
|
|||
|
|||
I got the same problem No prassing is showing up.
Mustang02 did you do anything that was not in the instruction? |
#710
|
||||
|
||||
Alright -- I guess I'm confused.
I had the old version back before 3.5 that worked great. I downloaded this version and followed the instructions.txt When I imposted the plugin (XML) (didn't click Allow Overright the first time -- did the second time) I got the below message both times Code:
Database error in vBulletin 3.6.8: Invalid SQL: INSERT INTO profilefield (profilefieldid,required,hidden,maxlength,size,displayorder,editable,type,data,height,def,optional,searchable,memberlist,regex,form,html) VALUES (50,0,0,'20','20','50','1','input','','0','0','0','0','0','0','','0'); MySQL Error : Duplicate entry '50' for key 1 Error Number : 1062 Code:
Database error in vBulletin 3.6.8: Invalid SQL: SELECT * FROM user AS user LEFT JOIN customfile AS customfile ON (customfile.userid = user.userid) LEFT JOIN userfield AS userfield ON (userfield.userid = user.userid) WHERE user.userid = userfield.userid AND userfield.field55>0 ORDER BY userfield.field55 ASC LIMIT 0,25; MySQL Error : Table 'moparsty_vbulletin.customfile' doesn't exist Error Number : 1146 Date : Monday, December 17th 2007 @ 01:21:39 AM thanx |
#711
|
|||
|
|||
Your database didnt create a necessary table. Upload the php file and than the xml file allowing overwrite. See which error you get since those are two different versions of errors.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|