[UPDATE] New PackersHome

Zero2Cool
Elite Member Topic Starter

13 years ago

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.

Wanna join the discussion?! Login to your PACKERSHOME forum account or Register a new forum account

vikesrule
Registered

13 years ago

...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.

"Zero2Cool" wrote:

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.

Zero2Cool
Elite Member Topic Starter

13 years ago

...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.

"vikesrule" wrote:

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.

"Zero2Cool" wrote:

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.

vikesrule
Registered

13 years ago

...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.

"Zero2Cool" wrote:

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.

"vikesrule" wrote:

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.

"Zero2Cool" wrote:

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:

68md
Member

13 years ago

...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.

"vikesrule" wrote:

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.

"Zero2Cool" wrote:

Second that ! As slow as things are in the NFL period...enjoy your family and a sometime around titletown. :thumbleft:

Zero2Cool
Elite Member Topic Starter

13 years ago

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.

Pack93z
Select Member

13 years ago

Hmmm... can't seem to log into the new environment.. can't even resend a password..

"The oranges are dry; the apples are mealy; and the papayas... I don't know what's going on with the papayas!"

Zero2Cool
Elite Member Topic Starter

13 years ago

Hmmm... can't seem to log into the new environment.. can't even resend a password..

"Pack93z" wrote:

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.

Zero2Cool
Elite Member Topic Starter

13 years ago

sp_helptext 'GetUsersByUserName'

Zero2Cool
Elite Member Topic Starter

13 years ago

#10

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.

Important Information:

The PACKERSHOME uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Fan Shout

Mucky Tundra (12h) : Mahomes Magic baby! *cough*

TheKanataThrilla (12h) : KC the luckiest team in the league

Zero2Cool (16h) : Frigging host issues for site again

beast (16h) : For the first time in their long history, the Bears fire their head coach mid-season. Which comes after three very close in-division losses.

Zero2Cool (29-Nov) : At the game now. Kampman and Cullen Jenkins are here.

buckeyepackfan (29-Nov) : Happy Thanksgiving Packer Fans! Gonna celebrate with some grilled Dolphin later!

buckeyepackfan (29-Nov) : Inactive 23 CB Jaire Alexander 56 LB Edgerrin Cooper 62 OL Jacob Monk 87 WR Romeo Doubs

dhazer (29-Nov) : Just a talking point, do we try and trade Jaire next year to get out from the contract as he can't stay healthy

Zero2Cool (28-Nov) : Happy Thanksgiving! About to head to game.

wpr (28-Nov) : Happy Thanksgiving

Martha Careful (28-Nov) : Happy Thanksgiving Everybody...Go Packers!!!

Zero2Cool (28-Nov) : That is what a lot of people seem to think. Even though when he was on Giants, he was trash.

Martha Careful (27-Nov) : Brilliant move by Vikings!!! The signing provide great leverage in Darnold negotiations

Mucky Tundra (27-Nov) : Boo!

Zero2Cool (27-Nov) : Packers have ruled out Jaire Alexander, Edgerrin Cooper, and Romeo Doubs for Thursday's game against the Dolphins.

Zero2Cool (27-Nov) : Daniel Jones joins Vikings

Zero2Cool (27-Nov) : Tomorrow high 32° and low 19°

beast (27-Nov) : Thanks Mucky!

Mucky Tundra (27-Nov) : beast, forecast is looking like 27-28 degrees at kickoff, slight chance of snow flurries

Zero2Cool (27-Nov) : Oh? It wasn't on the injury report. That sucks, but it's what is best.

packerfanoutwest (26-Nov) : Doubs is out due to concussion

beast (26-Nov) : What does the weather look like?

Martha Careful (26-Nov) : You can wear long-johns mittens and a hat. We want Hill and their other skill guys FROZEN

Zero2Cool (26-Nov) : I'm not sure I hope for that. I'll be at the game.

Martha Careful (25-Nov) : I hope it is colder than a well-diggers ass on Thanksgiving night.

Zero2Cool (25-Nov) : doubt he wants to face the speedsters

beast (25-Nov) : Dolphins offense can be explosive... I wonder if we'll have Alexander back

Zero2Cool (25-Nov) : No Doubs could be issue Thursday

Mucky Tundra (25-Nov) : Bears. Santos. Blocked FG

Zero2Cool (24-Nov) : Bears. Vikings. OT

Mucky Tundra (24-Nov) : Thems the breaks I guess

Mucky Tundra (24-Nov) : Two players out and Williams had an injury designation this week but Oladapo is a healthy scratch

Zero2Cool (24-Nov) : Packers inactives vs 49ers: • CB Jaire Alexander • S Kitan Oladapo • LB Edgerrin Cooper • OL Jacob Monk

TheKanataThrilla (24-Nov) : Aaron Jones with a costly red zone fumble

Zero2Cool (24-Nov) : When we trade Malik for a 1st rounder, we'll need a new QB2.

packerfanoutwest (23-Nov) : Report: Aaron Rodgers wants to play in 2025, but not for the Jets

beast (23-Nov) : That's what I told the Police officer about my speed when he pulled me over

packerfanoutwest (23-Nov) : NFL told Bears that Packers’ blocked field goal was legal

packerfanoutwest (22-Nov) : 49ers are underdogs at Packers, ending streak of 36 straight games as favorites

Zero2Cool (22-Nov) : 49ers might be down their QB, DL, TE and LT?

packerfanoutwest (22-Nov) : Jaire Alexander says he has a torn PCL

Zero2Cool (20-Nov) : Even with the context it's ... what?

Mucky Tundra (20-Nov) : Matt LaFleur without context: “I don’t wanna pat you on the butt and you poop in my hand.”

beast (20-Nov) : We brought in a former Packers OL coach to help evaluate OL as a scout

beast (20-Nov) : Jets have been pretty good at picking DL

Zero2Cool (20-Nov) : He landed good players thanks to high draft slot. He isn't good.

Zero2Cool (20-Nov) : He can shove his knowledge up his ass. He knows nothing.

beast (20-Nov) : More knowledge, just like bring in the Jets head coach

Zero2Cool (19-Nov) : What? Why? Huh?

beast (19-Nov) : I wonder if the Packers might to try to bring Douglas in through Milt Hendrickson/Ravens connections

Please sign in to use Fan Shout

2024 Packers Schedule

Friday, Sep 6 @ 7:15 PM

Eagles

29 - 34

Sunday, Sep 15 @ 12:00 PM

COLTS

16 - 10

Sunday, Sep 22 @ 12:00 PM

Titans

30 - 14

Sunday, Sep 29 @ 12:00 PM

VIKINGS

29 - 31

Sunday, Oct 6 @ 3:25 PM

Rams

24 - 19

Sunday, Oct 13 @ 12:00 PM

CARDINALS

34 - 13

Sunday, Oct 20 @ 12:00 PM

TEXANS

24 - 22

Sunday, Oct 27 @ 12:00 PM

Jaguars

30 - 27

Sunday, Nov 3 @ 3:25 PM

LIONS

14 - 24

Sunday, Nov 17 @ 12:00 PM

Bears

20 - 19

Sunday, Nov 24 @ 3:25 PM

49ERS

38 - 10

Thursday, Nov 28 @ 7:20 PM

DOLPHINS

30 - 17

Thursday, Dec 5 @ 7:15 PM

Lions

Sunday, Dec 15 @ 7:20 PM

Seahawks

Monday, Dec 23 @ 7:15 PM

SAINTS

Sunday, Dec 29 @ 12:00 PM

Vikings

Saturday, Jan 4 @ 11:00 PM

BEARS