Best of joomla gives you news, joomla templates, tutorials and websites about Joomla , FireBoard and FireMessage official page.
| No account yet?   |
Welcome, Guest
Please Login or Register.    Lost Password?
SOLVED: Ordering, View Type, Oldest First & Flat (1 viewing) (1) Guest
Go to bottom Favoured: 1
TOPIC: SOLVED: Ordering, View Type, Oldest First & Flat
#15473
SOLVED: Ordering, View Type, Oldest First & Flat 1 Year, 1 Month ago  
Okay guys, everyone wants to know how to fix the default ordering and view type problem when you have Community Board cb plugin installed. Here's how I fixed it:
NB- you need to have the Fireboard Plugin for CB!

First, make sure you have fixed the language file problem-
if you already have, go to step 4:

1) Create the necessary forum fields for CB using the Fireboard configuration:
Components > Fireboard Forum > Fireboard Configuration > Integration > Community Builder
"Create Community Builder forum profile" Click link
- if you have already changed them in the past, make sure you change them back to the correct values. Here they are again if you need to check:

Name: fbviewtype
Title: _UE_FB_VIEWTYPE_TITLE
Value1: _UE_FB_VIEWTYPE_FLAT
Value2: _UE_FB_VIEWTYPE_THREADED

Name: fbordering
Title: _UE_FB_ORDERING_TITLE
Value1: _UE_FB_ORDERING_OLDEST
Value2: _UE_FB_ORDERING_LATEST

Name: fbsignature
Title: _UE_FB_SIGNATURE


3) Navigate to JOOMLADIRECTORY/components/com_comprofiler/plugin/language/default_language/default_language.php
Add the following code:
Code:

DEFINE('_UE_FB_TABTITLE', 'Forum Settings' );
DEFINE('_UE_FB_ORDERING_OLDEST', 'Oldest post first' );
DEFINE('_UE_FB_ORDERING_LATEST', 'Newest post first' );
DEFINE('_UE_FB_ORDERING_TITLE', 'Message Ordering' );
DEFINE('_UE_FB_SIGNATURE', 'Your board signature' );
DEFINE('_UE_FB_VIEWTYPE_FLAT', 'View flat' );
DEFINE('_UE_FB_VIEWTYPE_THREADED', 'View threaded' );
DEFINE('_UE_FB_VIEWTYPE_TITLE', 'Prefered Viewtype' );
DEFINE('_UE_FB_TABDESC', 'General profile options' );



Now your field values will all be correct on the front end. If not, you did something wrong! Try again, but watch out you dont create duplicate fields!

Now your language file problem is fixed, we can sort the ordering problem out.
For this I used SQL in PhpMyAdmin.

4) Navigate to your comprofiler table in your Joomla database: jos_comprofiler

5) Click SQL and enter the following codes and hit 'Go':
Code:

 ALTER TABLE `jos_comprofiler`
CHANGE `fbordering` `fbordering`
VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '_UE_FB_ORDERING_OLDEST'


This changes the default view to Oldest post first.

Code:

 ALTER TABLE `jos_comprofiler`
CHANGE `fbviewtype` `fbviewtype`
VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '_UE_FB_VIEWTYPE_FLAT'


This changes the default view to flat.

Now whenever a new user signs up, their default views will be Oldest Post First in Flat view. You can alter those defaults if you need to, but they are most common.

6) To change all existing users to the same defaults, navigate to your comprofiler table again, Click on SQL, and enter the following code then hit 'Go':
Code:

UPDATE LOW_PRIORITY `jos_comprofiler`
   SET `fbviewtype` = '_UE_FB_VIEWTYPE_FLAT', 
   WHERE 1


This will change all users view types to Flat

Code:

UPDATE LOW_PRIORITY `jos_comprofiler`
   SET `fbordering` = '_UE_FB_ORDERING_OLDEST'
   WHERE 1


This will change all users view type to Oldest post first.

I hope this all helps! I am very much a novice with all of this sort of stuff, but I am good at solving problems! If this helped you out, post here and let me know! If you have any problems, post here and let me know!

Cheers
Alex
alexburn (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2007/07/23 17:06 By alexburn.
 
The administrator has disabled public write access.  
#16249
Re:SOLVED: Ordering, View Type, Oldest First & Flat 1 Year, 1 Month ago  
your last 2 snippets of SQL code dont work...

Cheers,

Pete
PeteL (User)
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#16252
Re:SOLVED: Ordering, View Type, Oldest First & 1 Year, 1 Month ago  
This may be related to version type or something similar. I just tried the code again from MyPHPAdmin Panel and it worked fine.

You may wish to try a variation. Find a field that has a common variable for all the data within your jos_comprofiler table and use this in your WHERE clause. For the example below, I have chosen to use the field 'banned' as all my users have this option as '0':

Code:


 UPDATE LOW_PRIORITY `jos_comprofiler`

   SET `fbordering` = '_UE_FB_ORDERING_OLDEST'

   WHERE `banned` = '0'


Code:




 UPDATE LOW_PRIORITY `jos_comprofiler`

   SET `fbviewtype` = '_UE_FB_VIEWTYPE_FLAT'

   WHERE `banned` = '0'



This should set the correct options for anyone who is not banned from your site.
Remember to look out for the correct quote reference types
as there is a difference between ' and ` .
Hope this sorts it out for you.
alexburn (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2007/07/30 17:17 By alexburn.
 
The administrator has disabled public write access.  
#17652
Re:SOLVED: Ordering, View Type, Oldest First & Flat 1 Year ago  
Thank YOU THANK YOU THANK YOU! I could hug you I am so happy. This solved my problem within about two minutes. All of the code worked for me perfectly. I appreciate it immensely as I could not figure out how to fix this problem and my forum is very active. THANKS!!!
hollymann (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Gender: Female Honest Work From Home Forum Location: Thailand Birthdate: 1982-09-01
Logged Logged
 
 
The administrator has disabled public write access.  
#24617
Re:SOLVED: Ordering, View Type, Oldest First & Flat 11 Months, 2 Weeks ago  
Omg thank you! I would hug u if you where standing next to moa..

EDIT: NVM! WORK AGAIN:::!!!! THANKS
TiaZe (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
Last Edit: 2007/09/26 09:32 By TiaZe.
 
The administrator has disabled public write access.  
#37820
Re:SOLVED: Ordering, View Type, Oldest First & Flat 8 Months ago  
It fixed my problem too... Thanks a lot guys! more power!
Jing (User)
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
Go to top
Powered by FireBoard - Creditsget the latest posts directly to your desktop