NEW #1
Avatar
Zero2Cool Elite Member
Joined: Oct 14, 2006
Posts: 44,952
Avatar
Zero2Cool
Elite Member
Joined:Oct 14, 2006
Posts:44,952
Thank you to all who registered and posted and provided help. In the next coming weeks to months the transition to the new site will be completed.


It was far more difficult than probably worth, but I have all of the members from here imported over and ready to authorize their accounts with the new PackersHome. I'll write up a doc on how to do that next week.

The DotNetNuke (main CMS framework) took to the new members flawlessly with the module I hacked. The YAF (YetAnotherForum) software however took each member and put them in alphabetical order and assigned them the wrong UserId. What does this mean to you? Well, each post is tied to a UserId and if that UserId is wrong, the post will appear to have been made by someone else.

The issue with this is the UserId field is an auto identify field and I'm having trouble figuring out how to update said field. Once that's figure out, I'll be able to import the topics and then the posts.

The forum categories have been created successfully as well. I had to re-identify them which is why the site was down yesterday for a few hours.


Anyhooters ...

I'm leaving Thursday after work for Green Bay, WI to bring Keiana to her mother's for the summer. This means, I probably won't be touching the new website until I get back sometime late next week.

Today, we'll probably have movie night.
Tuesday, hit Buffalo Wild Wings then watch the two NCIS finales
Wednesday, getting our hair(s) cut
Thursday, driving to Wisconsin


I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.
0
SlickVision, Methodikal, Kevin and 5 others
NEW #2
Avatar
vikesrule Registered
Joined: Aug 04, 2007
Posts: 2,121
Avatar
vikesrule
Registered
Joined:Aug 04, 2007
Posts:2,121
"Zero2Cool"...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.


Just chill on the site Z2C....spend time with your daughter!
The site will go on or not, whatever.... but your daughter is growing up and before you know it, she'l be grown.
0
SlickVision, Methodikal, Kevin and 5 others
NEW #3
Avatar
Zero2Cool Elite Member
Joined: Oct 14, 2006
Posts: 44,952
Avatar
Zero2Cool
Elite Member
Joined:Oct 14, 2006
Posts:44,952
"vikesrule"
"Zero2Cool"...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.


Just chill on the site Z2C....spend time with your daughter!
The site will go on or not, whatever.... but your daughter is growing up and before you know it, she'l be grown.


Definitely, however, she's 9 and is already wanting to play with her friends because "Daddy, I won't see them ALL summer long!!".
LoL

We had a lot of fun over the weekend.
0
SlickVision, Methodikal, Kevin and 5 others
NEW #4
Avatar
vikesrule Registered
Joined: Aug 04, 2007
Posts: 2,121
Avatar
vikesrule
Registered
Joined:Aug 04, 2007
Posts:2,121
"Zero2Cool"
"vikesrule"
"Zero2Cool"...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.


Just chill on the site Z2C....spend time with your daughter!
The site will go on or not, whatever.... but your daughter is growing up and before you know it, she'l be grown.


Definitely, however, she's 9 and is already wanting to play with her friends because "Daddy, I won't see them ALL summer long!!".
LoL

We had a lot of fun over the weekend.


Dang...she's 9? I was still thinking of your daughter as being about 6 years old.
Time flies.....and I can understand her
and the friends thing.

You're doing fine......carry on. :icon_smile:
0
SlickVision, Methodikal, Kevin and 5 others
NEW #5
Avatar
68md Member
Joined: Oct 02, 2008
Posts: 269
Avatar
68md
Member
Joined:Oct 02, 2008
Posts:269
"vikesrule"
"Zero2Cool"...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.


Just chill on the site Z2C....spend time with your daughter!
The site will go on or not, whatever.... but your daughter is growing up and before you know it, she'l be grown.


Second that ! As slow as things are in the NFL period...enjoy your family and a sometime around titletown.
:thumbleft:
0
SlickVision, Methodikal, Kevin and 5 others
NEW #6
Avatar
Zero2Cool Elite Member
Joined: Oct 14, 2006
Posts: 44,952
Avatar
Zero2Cool
Elite Member
Joined:Oct 14, 2006
Posts:44,952
It's crazy, in a few months, she's gonna be 10.
I definitely am not robbing time from her for anything. Usually the site steals sleep time, lol.
0
SlickVision, Methodikal, Kevin and 5 others
NEW #7
Avatar
Pack93z Select Member
Joined: Mar 17, 2007
Posts: 13,278
Avatar
Pack93z
Select Member
Joined:Mar 17, 2007
Posts:13,278
Hmmm... can't seem to log into the new environment.. can't even resend a password..
0
SlickVision, Methodikal, Kevin and 5 others
NEW #8
Avatar
Zero2Cool Elite Member
Joined: Oct 14, 2006
Posts: 44,952
Avatar
Zero2Cool
Elite Member
Joined:Oct 14, 2006
Posts:44,952
"Pack93z"Hmmm... can't seem to log into the new environment.. can't even resend a password..


That's good, I've asked everyone to keep away. If someone logs in and makes a post, it'll ruin the structure, at least, until I figure out how the heck to get the userid's to match between DNN and YAF.

The DNN to YAF user importer put all of the DNN users in alphabetical order, then imported them. So now all the userid's are wrong. Just my friggin luck.



SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%order by user%'







Shawn, would you be able to make a backup of the database and upload it for me? I can't access it from work via management studio. I have to go through the stored procedures and find which one is doing the alphabetizing and comment it out and then redo a mass user import once again.
0
SlickVision, Methodikal, Kevin and 5 others
NEW #9
Avatar
Zero2Cool Elite Member
Joined: Oct 14, 2006
Posts: 44,952
Avatar
Zero2Cool
Elite Member
Joined:Oct 14, 2006
Posts:44,952
sp_helptext 'GetUsersByUserName'
0
SlickVision, Methodikal, Kevin and 5 others
NEW #10
Avatar
Zero2Cool Elite Member
Joined: Oct 14, 2006
Posts: 44,952
Avatar
Zero2Cool
Elite Member
Joined:Oct 14, 2006
Posts:44,952
Stupid ass Guest account in YAF is screwing shit up.

Work around..
Current Site, merge Zero2Cool and SlickVision, keep SlickVision UserID of 4 to avoid offsetting every UserID by 1 when imported to YAF.

Prior to DNN user import, add UserID 3 with bogus values.

This will maintain UserID integrity for topics and posts import.
0
SlickVision, Methodikal, Kevin and 5 others