Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Dunny, Ruben), 48 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 709
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 24
Dunny 15
SteveS 13
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#222945 - 02/24/09 03:16 PM Adding pre dated posts.
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
I have a forum where the contents are minutes from meetings.
Several months are missing from previous years that I wish to add. Meaning there are gaps for some months that I wish to add
I want the posts to display in chronological order.
Quick view in the tables says no problem I even tried one.
Post a topic and change the date in the table.

Before I start adding old Posts.
Any other issues I should be concerned with?
_________________________
Blue Man Group
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#222977 - 02/24/09 07:06 PM Re: Adding pre dated posts. [Re: Ruben]
DLWebmaestro Offline
enthusiast
Registered: 03/26/08
Posts: 333
Loc: North Carolina
If I'm following you correctly, I don't think there should be a problem. What is the exact method you are using to add these missing minutes?
_________________________
Marching Percussion ( Drumline ) Community
Top
#222983 - 02/24/09 07:15 PM Re: Adding pre dated posts. [Re: DLWebmaestro]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Nothing special just a post it is just out of order trying to catch missing months.
Say post a topic today but it will appear as today. So I edit the table for that post and change the date to 12/12/07. It works just not sure if it causes other problems that I did not see.
I have about 40 or so to post so before I go past one post I wanted some opinions.
_________________________
Blue Man Group
Top
#223024 - 02/25/09 12:04 AM Re: Adding pre dated posts. [Re: Ruben]
DLWebmaestro Offline
enthusiast
Registered: 03/26/08
Posts: 333
Loc: North Carolina
It would probably be a good idea to Rebuild Topics and Forums after you're done. Other than that, I can't think of anything else since you're adding the posts by using the scripts and not directly through MySQL.
_________________________
Marching Percussion ( Drumline ) Community
Top
#223029 - 02/25/09 12:18 AM Re: Adding pre dated posts. [Re: DLWebmaestro]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
ubbt_POSTS (POST_POSTED_TIME) and ubbt_TOPICS (TOPIC_CREATED_TIME) should do it smile
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#223096 - 02/25/09 04:26 PM Re: Adding pre dated posts. [Re: SD]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Thanks You know when I tested this I think I edited a different date field in ubbt_topics than your suggestion. It worked but just seemed like it was not right as far as unread topics/Active topics are concerned.
I will give it a try your way.
_________________________
Blue Man Group
Top
#223252 - 02/26/09 06:37 PM Re: Adding pre dated posts. [Re: Ruben]
SGHB1138 Offline

member
Registered: 12/12/06
Posts: 195
Loc: UK
Pardon my ignorance but when I'm in phpMyAdmin, all I see for the date in ubbt_POSTS (POST_POSTED_TIME) and ubbt_TOPICS (TOPIC_CREATED_TIME) is a sequence of numbers like 1234511796

How can I change that to reflect the date I want?
_________________________
Stephen G
Geek Out @ Cinema Geek
Top
#223253 - 02/26/09 06:41 PM Re: Adding pre dated posts. [Re: SGHB1138]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Sirdude posted a link for this a while back on another topic. Can't find it right now.
But:
The format is in Unix time. There are lots of on-line converters HERE is one of them.
_________________________
Blue Man Group
Top
#223270 - 02/26/09 11:14 PM Re: Adding pre dated posts. [Re: Ruben]
SGHB1138 Offline

member
Registered: 12/12/06
Posts: 195
Loc: UK
Many thanks Ruben, just what the doctor ordered

smile
_________________________
Stephen G
Geek Out @ Cinema Geek
Top



Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image