[Solved] Changing the author of a thread through the database (Page 1 of 2)

It's easily done using SQL...

ALTER TABLE posts SET user_id=X WHERE id=Y;

replace X by the new user id and Y by the post id.

This is not something very dangerous or anything, but be careful playing around with your database if you are not comfortable doing it. Better make a backup before if you are not sure of what you're doing.

OMG... i just forgot the ABC of SQL... sorry {embarrassed mode}
thanks smartys. this is particularly funny if one reads what i wrote together with that fine piece of 'personal' SQL.

vanslide, it is:

UPDATE TABLE posts SET user_id=X WHERE id=Y;

eheheh... I wonder if vanslyde  or any other person will actually trust me with any tips after this.
It's the mnemonic i have in my head... "update table set...where" sorry...

ok.. so... let's see if the 3rd is the final one:

UPDATE posts SET user_id=X WHERE id=Y;

lol naaa I'm trusting you guys. I was at the movies so didn't tried the first few queries

But still, the last one (with smarty's comment about poster_id) didn't work. I ran the following;
UPDATE posts SET poster_id=83 WHERE id=591;

and got the following results;
Instead of having the username of poster 83 next to post 591, I get the original username BUT it now has the poster id 83...

It works, thanks guys!

edit: so you have to run the 2 ^^ queries.
first one for the authors' names appearing in the list of topics and 2nd one for the name displayed in the first post of said topic

Make the first query

update topics set poster="name", last_poster="name" where id=topic_id

and run update_forum

It's a PHP function.

No, it needs to be called within your file: include/functions.php simply defines what the function is and does, it doesn't execute it.

OK.
You just want to add the following code

update_forum(number);

where number is the ID of the forum where the topic is. This assumes you've included include/functions.php somehow (most likely using include/common.php)

That is the function you have to call indeed. Just post in the forum you changed and it should be done.

well if I only have to browse to this php file:

<?php
define('PUN_ROOT', './');
require PUN_ROOT.'include/functions.php';

update_forum(7);

?>

I'm getting the error
Fatal error: Call to a member function query() on a non-object in C:\wamp\www\forums\include\functions.php on line 364
__ __ __
line 364 of function.php is
$result = $db->query('SELECT COUNT(id), SUM(num_replies) FROM '.$db->prefix.'topics WHERE moved_to IS NULL AND forum_id='.$forum_id) or error('Unable to fetch forum topic count', __FILE__, __LINE__, $db->error());
    list($num_topics, $num_posts) = $db->fetch_row($result);

Then I'd get a blank page with no output whatsoever, is that normal?