[DEV] Guest management MOD

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Fearless
Registered User
Posts: 664
Joined: Mon Mar 31, 2003 6:16 am

Post by Fearless »

Hmmm, if I understand what this mod does exactly, it might be a very handy tool for re-assigning posts from a deleted profile to a new profile (for example, someone who decided to leave a forum for a while and then came back).
User avatar
Lalaman
Registered User
Posts: 26
Joined: Wed Jan 08, 2003 9:06 pm

Further Help?

Post by Lalaman »

bourmad wrote: You can download now version 1.0.0a2.

I have included correction for names with special characters.
I have added a preview of all posts from a guest username.

If this version have no problems, I will release it as official 1.0.0 in mods database.
Don't hesitate to post your feedback here.



Hey Bourmad, can you take a look at this post? (it has to do with your "guestmgmt mod")
http://www.phpbb.com/phpBB/viewtopic.php?p=550842
(my second post)

I am having an issue with your very nicely done mod. It seems that after moving one or more posts from the "guest username" accounts, if you go into that forum to the "viewforum" it still shows as "guest" as the author and not the NEW user that the post was moved to. But if you go into the actual post view it indeed shows the new user.

See the example here: http://kidsdirect.net/phpBB2/viewforum.php?f=72
If you look at both of those "guests" under author, those are the ones that I moved from one guest to a regular user.

THanks in advance
User avatar
bourmad
Registered User
Posts: 43
Joined: Sun Mar 10, 2002 6:28 pm

Post by bourmad »

I have a lot of work now, but I will try to have a look to this problem.
User avatar
Mav
Former Team Member
Posts: 2261
Joined: Wed May 15, 2002 9:19 am
Location: England
Contact:

Post by Mav »

i think the problem is that the user_id is stored in the topics table as well as the posts tables. the MOD doesn't update this from -1 (guest) to the user_id of the reassigned user.
User avatar
bourmad
Registered User
Posts: 43
Joined: Sun Mar 10, 2002 6:28 pm

Post by bourmad »

Yes, I think it's a problem like that. Maybe easy to correct.
User avatar
Lalaman
Registered User
Posts: 26
Joined: Wed Jan 08, 2003 9:06 pm

Great

Post by Lalaman »

bourmad wrote: Yes, I think it's a problem like that. Maybe easy to correct.


Great, thanks for the reply. Did you have a chance to check out why this doesnt update?

I will be waiting for this fix. Thank you for your time

:D
Talanithus_UOLS
Registered User
Posts: 47
Joined: Tue May 27, 2003 3:20 am
Contact:

Any updates on this?

Post by Talanithus_UOLS »

I'd love to use it, when the topic modifications are added in!
User avatar
bourmad
Registered User
Posts: 43
Joined: Sun Mar 10, 2002 6:28 pm

Post by bourmad »

sorry, I really have no time these days (monthes).
I will try to do that, but I don't know why.
|AW|DeeDee
Registered User
Posts: 4
Joined: Tue Jul 01, 2003 8:25 pm
Location: Earth
Contact:

Post by |AW|DeeDee »

hmmm.... nice little tidbit to find.... thanx primedomain....

Maybe I should have searched for "guest to registered" instead of "accidentally deleted user"...

http://www.phpbb.com/phpBB/viewtopic.php?t=115449

Anyways.... I solved the topic thing with:

--- topics_fix.php ---
<?

$dbuser = "root";
$dbpass = "####";
$dbhost = "localhost";
$dbname = "forum";

/* db connection */
function dbcnx() {

global $dbname, $dbuser, $dbpass, $dbhost;
$dbcon = @mysql_connect($dbhost,$dbuser,$dbpass) or die("Houtson....");
mysql_select_db($dbname,$dbcon);
return $dbcon;

}

/* db tables */
$db = array(posts => "phpbb_posts", topics => "phpbb_topics");

dbcnx();

$topics = mysql_query("SELECT * FROM $db[topics]");

while($topic=mysql_fetch_array($topics)) {

$first_post = mysql_query("SELECT * FROM $db[posts] WHERE topic_id = '$topic[topic_id]' ORDER BY post_time LIMIT 1");

while($post=mysql_fetch_array($first_post)) {

mysql_query("UPDATE $db[topics] SET topic_poster='$post[poster_id]' WHERE topic_id='$post[topic_id]'");

}

}

?>
#EOF

For every topic, finds first poster and updates topic_poster with poster_id.
What's this button do?
User avatar
nubianniht
Registered User
Posts: 338
Joined: Thu Jun 05, 2003 4:02 am

Post by nubianniht »

simple mod to install.
just copied everything over with no prob.
correct me if im doing this wrong but ...
my situation is that in the acp i go into the guest management.
- i click on "list guest usernames
- i click on sort on in all of it's combinations

nothing happens. :(
yes i do have a guest thread that is just erking the hell out of me.
i do want to assign it to a registered username.
or what are the neccesary steps taken in order to make this guest thread authored by a registered user?
any ideas?


thanks in advance
User avatar
nubianniht
Registered User
Posts: 338
Joined: Thu Jun 05, 2003 4:02 am

Post by nubianniht »

-edit-
indra sunrise
Registered User
Posts: 54
Joined: Thu May 29, 2003 6:47 am
Contact:

Post by indra sunrise »

This mod worked beautifully, on my php 2.0.6 board (which has a TON of mods). Installed in seconds, did exactly what I had needed done, no bugs, no problems.
Thank you, very much.
Indra
User avatar
RCAmerica1
Registered User
Posts: 49
Joined: Tue May 06, 2003 3:36 am
Location: Hawaii
Contact:

Re: Further Help?

Post by RCAmerica1 »

Lalaman wrote:
bourmad wrote:You can download now version 1.0.0a2.

I have included correction for names with special characters.
I have added a preview of all posts from a guest username.

If this version have no problems, I will release it as official 1.0.0 in mods database.
Don't hesitate to post your feedback here.



Hey Bourmad, can you take a look at this post? (it has to do with your "guestmgmt mod")
http://www.phpbb.com/phpBB/viewtopic.php?p=550842
(my second post)

I am having an issue with your very nicely done mod. It seems that after moving one or more posts from the "guest username" accounts, if you go into that forum to the "viewforum" it still shows as "guest" as the author and not the NEW user that the post was moved to. But if you go into the actual post view it indeed shows the new user.

See the example here: http://kidsdirect.net/phpBB2/viewforum.php?f=72
If you look at both of those "guests" under author, those are the ones that I moved from one guest to a regular user.

THanks in advance

bourmad, Has this been corrected? Thank you!
jebur
Registered User
Posts: 18
Joined: Sat Jul 10, 2004 7:05 pm
Location: Stockholm, Sweden

Post by jebur »

Ye, I have the same problem as the poster above (real nick doesn¨t show in viewforum.php).

And another issue: can you make it so that it's possible to assign guests who doesn't enter a name when they post. They are all only listed as "Guest" in this mod, but the thing is that they are all from different posters. Would be good if you could search all posts from IP address also.
jebur
Registered User
Posts: 18
Joined: Sat Jul 10, 2004 7:05 pm
Location: Stockholm, Sweden

Post by jebur »

please fix this !
Post Reply

Return to “[2.0.x] MODs in Development”