More Functions in Edit Post if you are an Admin

Hi folks!

After my server has had problems last night, so the date was incorrect, an the posts had the dateline of October, I start programming this hack, to change a bit more of the Posting informations if you are an Admin of the board.

Now you can change
1. The Userid of this Post (don't know when, but perhaps you'll need it sometimes)
2. The Threadid of the Post (if you want to take this post to another thread)
3. Date and time postet
4. IP Address saved with the Post
5. can make post uneditable for original Author/Mods/Supermods (priority level system) or even editable to the author when timelimit is over...

If you like it Please click on install Button
Screenshot

vB3 Version of this hack can be found here

[Xenon]

nope, currently not, and i don't have much time these days for releasing new versions.

it's on my plan of the vb3 version, but for now you have to update threadcounters if you want to change the dateline of a thread

[Sharg]

Thanks for your answer.
Well, In fact I tried to update all counters (except search index reindex) and still vbhome did show the non modified date.

Cordially,
Sharg

[Boofo]

Yesterday at 11:45 AM Xenon said this in Post #121
nope, currently not, and i don't have much time these days for releasing new versions.

it's on my plan of the vb3 version, but for now you have to update threadcounters if you want to change the dateline of a thread

This seems to work fine:

Add:

PHP Code:

  updatethreadcount($threadinfo[threadid]);
  updateforumcount($threadinfo[forumid]); 


Right above:

PHP Code:

  eval("standardredirect(\"".gettemplate("redirect_editthanks")."\",\"showthread.php?s=$session[sessionhash]&postid=$postid#post$postid\");"); 


My question is, will this add any extra queries or server load?

[Boofo]

Yesterday at 11:51 AM Sharg said this in Post #122
Thanks for your answer.
Well, In fact I tried to update all counters (except search index reindex) and still vbhome did show the non modified date.

Cordially,
Sharg

What version of vbHome Lite are you using? I use 3.8 and had the same problem but just fixed it.

[Xenon]

Boofo: yes, because the forum and the thread tables have to be updated, it will add queries

so make sure they're just called if you've done an admin edit

[Boofo]

Today at 07:30 AM Xenon said this in Post #125
Boofo: yes, because the forum and the thread tables have to be updated, it will add queries

so make sure they're just called if you've done an admin edit

It will only add 2 queries, right?

And where do I need to put them to only do it after an Admin edit? Right now I have them below:

PHP Code:

 //Admin Edit Hack
  if ($bbuserinfo[usergroupid] == 6) {
    $datetime=mktime($datetime[hours],$datetime[minutes],0,$datetime[mon],$datetime[mday],$datetime[year])-3600*($bbuserinfo['timezoneoffset']-$timeoffset);
    $adminsql .= "ipaddress='".addslashes($ipadd)."',dateline='$datetime',editable='$editable',userid='$userid',threadid='$pthreadid',";
  }
  $DB_site->query("UPDATE post SET " . $adminsql . "title='".addslashes(htmlspecialchars($title))."',pagetext='".addslashes($message)."',allowsmilie='$allowsmilie',showsignature='$signature',showimage='$showimage',iconid='$iconid'$editedbysql$attachmentsql WHERE postid='$postid'"); 


[Xenon]

it will add 4 queries per function so in sum 8 queries in total

the position is right, but you should put it into an if block so it will just be executed if you're an admin

[Boofo]

Today at 07:51 AM Xenon said this in Post #127
it will add 4 queries per function so in sum 8 queries in total

the position is right, but you should put it into an if block so it will just be executed if you're an admin

Like this?

PHP Code:

  if ($bbuserinfo[usergroupid] == 6) {
  updatethreadcount($threadinfo[threadid]);
  updateforumcount($threadinfo[forumid]);
  } 


I didn't know that each of those functions added 4 queries. How come so many?

Also, is there a way to make a checkbox that when ticked will update the post with the current date and time that you are editing the post (like a newreply or newthread) and if not ticked, will just update it as normal (like if you manually change the date or time)?

[nhlrat]

04-19-03 at 01:35 PM Xenon said this in Post #113
nope normally impossible with my hack, that's another problem.

Any experts care to help a newbie and shed some light on this file of mine? I'm guessing it's something pretty simple, but don't have enough knowledge yet. Thanks guys!

[Xenon]

@nhl: as it's not a problem with my hack you should start an sepearat thread if you have such problems!

@boofo: correctly that was what i meant
look into functions.php to see why so many queries are needed
also yes it would be possible to add a checkbox for that, but i don't have any time to work on this these days...