Thread reset

[DemOnstar]

Hello.

During the time I have waited for a stable version, I have created a site but left it closed. I have worked upon it as if it were open and treated it as such. When the time comes and I am more confident of it's functionality, is there a reset command or option that allows the date of threads etc to be reset?

Thank you. . . .

[Replicant]

No.

[DemOnstar]

Originally Posted by Replicant

No.

Surprise, surprise. . . . .

Okay, I guess that concludes the whole matter. . .

Thanks. .

[Replicant]

There is on the other hand a way to do it via SQL queries. I know you like to tinker, so if you want to investigate that, I'll point you in the right direction.

[DemOnstar]

Originally Posted by Replicant

There is on the other hand a way to do it via SQL queries. I know you like to tinker, so if you want to investigate that, I'll point you in the right direction.

Tinkering is probably the best way to learn. .
There are something like 214 tables in the DB. Just let me know which one to sit at.

Fire away when ready. . . .

:up:

[Replicant]

In the node table, you will find columns named 'created' and 'publishdate'. They are unix timestamps. Changing these will change the dates shown in the posts. There are other timestamps that need to be changed. Any dates in other tables such as nodevisit, nodestats, nodevotes, picturecomment, picturecomment_hash, pollvote, postedhistory.........and so forth that correspond to that nodeid should also be changed. This is where a php script script would come in handy. I've changed dates on posts before in just the node table with no direct issues. But for an entire site, there may be underlying issues with search functions, edit functions and administration issues. Any function that relies on timestamps could directly be affected. There are at least 50 tables which have a dateline column in them.

How many posts, threads and channels do you have? There may be other options.

[DemOnstar]

Originally Posted by Replicant

How many posts, threads and channels do you have? There may be other options.

Thanks for getting back.

That is quite a lot of messing around for approximately 50 posts that were solely created just to populate the site. . .
It might be just as well to leave them as they are or do them again?
The only reason for doing it would be to bring them back into focus within search modules, latest posts etc...

[Replicant]

Is the forum accessible or is it still setup private?

[DemOnstar]

Still switched off until vB get it together enough to release something worthy. . .
I won't be posting anything anymore, there is enough to be going on with for test purposes. . .

[Replicant]

There is more than one way to skin a cat. I have a hunch that might be something that would work for your sitch. I'll investigate it and let you know via PM. I may need access to your site though to try it out.