If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Oops - deleted an entry -?  XML
Forum Index » Advanced Guestbook Forum
Author Message
Cezmer
Beginner

Joined: 13/03/2007 01:26:51
Messages: 12
Offline

2.4.2

Several times a day I use the Easy Administration to delete spam comments. I was a little hasty in clicking delete yesteday and deleted an entry I wanted to keep.
Hitting the back button right away allowed me to copy the comment from the screen and save it elsewhere even though it's actually gone from the guestbook.
So I could redo the entry myself, but the header info - date, time - wouldn't be right. Anyway I could make the entry and then change the date/time on it ?

Thanks,
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

http://proxy2.de/forum/viewtopic.php?t=6998&highlight=change+date

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
Cezmer
Beginner

Joined: 13/03/2007 01:26:51
Messages: 12
Offline

I read that thread before posting my question and it doesn't help. It just suggests using php MyAdmin and http://www.unixtimestamp.com/ but gives no directions on what you're supposed to do. Thanks anyway.
Carbonize
Master
[Avatar]

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

Use the unixtimestamp site to generate your required timestamp then use phpMyAdmin to change the timestamp of the entry to the required one.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus
[Email] [WWW] [Yahoo!] aim icon [MSN] [ICQ]
Cezmer
Beginner

Joined: 13/03/2007 01:26:51
Messages: 12
Offline

Thanks, figured it out.
For anyone else:

Use http://www.unixtimestamp.com/ to convert your date.

Go into phpMyAdmin.

Choose the database you want to edit from drop-down menu on the panel on the left.

From the right panel, find row dbname_data.
Click the "Browse" icon next to it.
(Icon is first one in the row, looks like a piece of paper.)

Scroll down to the row with the entry you need to edit and check its box.
Scroll to the bottom of the table and click the pencil icon for "Change".

In the date value box, paste the number you got from the Unix conversion.

Save and exit.

Cezmer
Xarah
Beginner

Joined: 28/02/2008 17:48:19
Messages: 6
Location: Zurich
Offline

I have added a "captcha" and now I have no more spam comments. This does not solve your immediate problem but your future ones

Feel like a challenge?
www.UvXarah.com
[WWW] [Yahoo!]
 
Forum Index » Advanced Guestbook Forum
Go to:   
Based on the open source JForum