Looking for psychostats module.

Hangin' Around Joined: Sep 30, 2003 Posts: 35

It's done!!!!!
I had to modify the script some, just for users and rerun it.
Everyone is there. Thank you so much Raven. I will offer up a sacrifice now...lol!!!

TWO LITTLE THINGS:
Avatars show up in "your account", but they are not showing up on posts.
Do you have any ideas or can you point me in a direction and I'll take it from there?

Also, I signed up the super user as reg and super. When I login as reg user, it doesn't sign me into the forums. Any ideas?

Thank you again for ALL of your help and patience.
I will continue to post here and read. I am trying to learn PHP and SQL.
I guess I am still noob. hehe. Rolling Eyes

Posted: Sat Oct 04, 2003 2:38 am

Actually, there are some problems.
Some of the posts, topics are not there from the old forum.
Can you help me? Embarassed

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

I have used the script, or a version of it, many times and always had 100% success. Here is a complete breakdown of what I do.

1 - Run the import script
2 - Change the -1 userid to 0 or (1 if 1 is not already used) in nuke_users.
3 - Using phpMyAdmin, change all poster_id from -1 to 0 in nuke_bbposts.
4 - Using phpMyAdmin, change all topics_poster from -1 to 0 in nuke_bbtopics.
5 - Using phpMyAdmin, change all forum_last_poster_id from -1 to 0 in nuke_bbforums.
6 - Manually export/import the wordlist and wordmatch tables.

If you are getting duplicate entry errors it's because you are importing parts of the table that you already imported.

Posted: Sat Oct 04, 2003 4:59 pm

Did all that. Some posts haven't shown up yet. If you have any other ideas.
I would really appreciate it.
The bulk of it is there. So I am not too concerned.
The users work as far as I can tell. I have had a few people beta test and so far so good.

Do you have any idea how to keep the forum post text from expanding all the way out and not staying resized within say the "header" image?
Also, the avatar forum max size option is not working. Do you know what this is?

I want to say again that Raven did an excellent job in helping me. He is extremely helpful and intuitive. Thanks again for your help Raven!!!!

I will probably have more questions as I am noob and trying my best to soak up this knowledge. Wink

Posted: Sun Oct 05, 2003 2:39 pm

Uh... hello?
What the heck! Times aren't showing up correctly. hmmm.

Posted: Mon Oct 06, 2003 12:49 am

Raven! I need help again!
New users can NOT register.
I tested this. You can sign up, everything looks good, you are sent an email.
Then the link that is in the email goes to a page that says "There is no user in the database with this information. You can register a new user from here."

Please help me someone. What do I need to do?

Thank you for any help in advance. Wink

Posted: Mon Oct 06, 2003 4:43 am

Please verify by using phpMyAdmin that you have a table in your database named nuke_users_temp. Some people end up with one named prefix_users_temp and if you are one of those, then use phpMyAdmin to rename it to nuke_users_temp.

If you have those tables, check the auto increment value in the nuke_users table. is it some extremely large number? If so, did you change the userid of the anonymous user from -1 to zero or one BEFORE you tried registering a new user?

If you have changed the anonymous user from -1 to 0 or 1 and your auto increment value is a very large number, you need to reset it. First of all edit any entries that already have a very large number. Give that user_id a correct small number, in sequence, from 1. Then, use phpMyAdmin and select the user table. Then select the SQL tab. In that window type the following

Code:

ALTER TABLE nuke_users auto_increment=XXX

where XXX is the next user_id to be issued.

Posted: Mon Oct 06, 2003 3:32 pm

Well, I checked it out, and I found that there are two anonymous users (one with 1 user id which I changed it to and another one with a super high # for user id). Could this be the problem? Could I delete one of them? Oh and also the one with the really high # keeps jumping in front of any new users. Hmmmm? Ineteresting huh?

There is a nuke_users_temp. That was fine.
How do I change the auto-increment? All I saw was to choose auto_increment or nothing. I know there must be a connection here between the first part of my post and this. I just don't know what it is yet.

Thank you for you help Raven! Wink

Posted: Mon Oct 06, 2003 3:35 pm

Please reread my previous post to you. I answered all of these questions already Smile

Posted: Mon Oct 06, 2003 3:39 pm

Well, I don't know how to change the auto-increment. Is that just the user id? The first anonymous user ( which has #1 user id ) has auto-increment set way out to the side. None of the other users have this selected.
Then at the very end o f the list the next anonymous user ( which has the really high # for user id) doesn't have aut-increment set way out to the side. The auto-increment thing I am not understanding. Where exactly do I change that? Rolling Eyes

Posted: Mon Oct 06, 2003 3:43 pm

Please reread my last post to you and look closely for the ALTER statement.

Posted: Mon Oct 06, 2003 4:00 pm

Oops...hehe. Embarassed

I am a dummy. I will do that now.

Posted: Mon Oct 06, 2003 4:08 pm

Ok, it is fixed. Thank you so much.

New problem... after the new user signs, they get a red x for avatar for default avatar. I have read some about this, but I am not sure how to approach it. Do you have any ideas?

Posted: Mon Oct 06, 2003 4:17 pm

http://www.ravenphpscripts.com/modules.php?name=Forums&file=viewtopic&t=184#857

Posted: Mon Oct 06, 2003 5:02 pm

You are truly amazing. I am wondering, what school you attended for your undergrad...or if you're even out of highschool yet? I must assume with your knowledge and patience that you are well into a masters?
I will continue to read and post here. You have a wealth of information my friend. I am sure that this community is very appreciative of the effort you put into this. I will make a donation soon on your behalf.

Hope to learn alot more from you,

- Chris

Posted: Mon Oct 06, 2003 5:06 pm

I'll take that as a compliment.

Who is Raven you ask?

http://gaylenandmargie.com

No degree at all. Self taught. Seriously? Talent on loan from God Smile

Worker Joined: Sep 09, 2003 Posts: 165

ummm Master is an understatement here Laughing

he is amazing and very patient. Very Happy

Posted: Mon Oct 06, 2003 5:15 pm

Well, thank you for letting me see a little bit about you.
Are you Chris too? I may have mixed names up, which one are you? Laughing

Posted: Mon Oct 06, 2003 5:16 pm

I'm the old fart - Gaylen (53 years) Laughing

Posted: Mon Oct 06, 2003 5:23 pm

Ah, gotcha!
Well, you have a lovely family. Very Happy

I look forward to learning more from you and everyone else here too!

Posted: Mon Oct 06, 2003 6:01 pm

I would like to know how I could change everyone's avatar to one I want specified. I can change them each individually, but that would take forever.
How would I run a mass sql query to change everyone's avatar?
Any ideas? Rolling Eyes

Posted: Mon Oct 06, 2003 7:30 pm

First and foremost, BACKUP your nuke_users table.

Use phpMyAdmin and in the SQL window, execute this query

Code:

UPDATE nuke_users set user_avatar = 'AVATAR_NAME';

Now, depending on where the avatar is, you may/may-not have to include a directory. Look at a record for a user that has an avatar that is working. That will tell you where you want to point to.

Posted: Mon Oct 06, 2003 7:50 pm

Thank you! That worked... of course. hehe.

Say I wanted to make a forum rules page that would be linked from the main menu. How would I do that? Is there some example code that I could reference? Nothing extravagant. I just want it to use the current theme that is applied for that particular user. I wonder how this can be done.
Thanks for help in advance.

Posted: Mon Oct 06, 2003 8:13 pm

eek, ok some of them aren't showing up.
How should the directory path look...would it be the full URL plus directory path? Looks like the ones that have remote url avatars aren't showing up.
Any ideas?

[/edit]
Ok, some of the paths are different for different users. So, I need to bustle through some main PHP huh?

Posted: Mon Oct 06, 2003 9:36 pm

Well, I have been looking and trying different things and still nothing.
Just an update.