UBB.Developers Forums UBB.threads 6 V6 Modifications Beta-[6.3] User Selectable Dateslip 1.0

Mod Name / Version: User Selectable Dateslip 1.0

Description: This will allow an individual user to override the forum's dateslip feature in their display preferences. The dateslip function determines if the posts are sorted by replies, or original post date on the postlist page.

Working Under: UBB.Threads 6.3

Mod Status: Beta

Any pre-requisites: none

Author(s): JoshPet

Date: 10/15/03

Credits: Commissioned by RocLobsta of www.mameworld.net

Files Altered: editdisplay.php, changedisplay.php, editdisplay.tmpl, postlist.php

New Files: none

Database Altered: New Field, U_DateSlip, added to the w3t_Users table.

Info/Instructions:

Disclaimer: Please backup every file that you intend to modify.
If the modification modifies the database, it's a good idea to backup your database before doing so.

Note: If you modify your UBB.Threads code, you may be giving up your right for "official" support from Infopop.If you need official support, you'll need to restore unmodified files.

Users are always happy to get new toys.

Fantastic, some of my users will be really happy for this, at least when I've upgraded so that it can be installed. =]

Installed, some users are happy (cause our board is expanded thread view by default).

One suggested addition would be to add this to the admin's profile editor as well (admin/showoneuser.php)

Other scripts need altering too for this mod:

addpost.php - After adding a post the page to send them back to is based on dateslip.

showflat.php/showthreaded.php - queries for prev/next post are based on dateslip and if the default doesn't match the user's option prev/next won't go in the right order.

I get this SQL error (I run 6.5) after installing the mod:
How please can I correct this? can someone please give me the correct syntax? I'm no expert on mySQL.

Script: /home/ac2/public_html/board/changedisplay.php
Line#: 137
SQL Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'U_TimeFormat = 'short1' WHERE U_Username = 'bcc'' at line
SQL Error #: 1064
Query: UPDATE w3t_Users SET U_LastOn = '1103681073', U_Display = 'flat', U_View = 'collapsed', U_PostsPer = '40', U_TextCols = '60', U_TextRows = '5', U_StyleSheet = 'greenday', U_Preview = 'on', U_PictureView = 'on', U_PicturePosts = 'on', U_Language = 'english', U_FlatPosts = '40', U_TimeOffset = '0', U_FrontPage = 'ubbthreads', U_StartPage = 'mi', U_ShowSigs = 'yes', U_DateSlip = '2' U_TimeFormat = 'short1' WHERE U_Username = 'bcc'

In changedisplay.php...

CHANGE THIS:



TO THIS:



That error will occur if you aren't using v6.3 and apply the changes exactly as mentioned in the mod.

Thank you VERY much indeed. This solved the problem.