[UPDATE] New PackersHome

Zero2Cool
Elite Member Topic Starter

12 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

12 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

12 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

12 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

12 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

12 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

12 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

12 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

12 years ago

sp_helptext 'GetUsersByUserName'

Zero2Cool
Elite Member Topic Starter

12 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

Martha Careful (10h) : Z, could you please combine my thread with yours please. I obviously did not see it when I Created it

Martha Careful (14h) : Re: 'Kool-Aid' McKinstry. Other than Icky Woods, has there ever been a good NFLer with a childish nickname?

Martha Careful (15h) : Packers looking to trade up

Martha Careful (17h) : Flag?

Martha Careful (17h) : Sag?

Nonstopdrivel (18h) : It rhymes with "bag."

beast (26-Apr) : Family? That's Deadpool's F word

Nonstopdrivel (26-Apr) : Not THAT f-word.

Zero2Cool (26-Apr) : fuck

beast (25-Apr) : 49ers are Cap Tight

beast (25-Apr) : Fuck

Mucky Tundra (25-Apr) : Kanata, I will be when I'm on my lunch later

TheKanataThrilla (25-Apr) : Love you NSD

Nonstopdrivel (25-Apr) : Huh. I guess the F-word is censored in this fan shout.

Nonstopdrivel (25-Apr) : Anyone who doesn't hang out in the chat probably smokes pole.

TheKanataThrilla (25-Apr) : GoPackGo Thinking CB is the pick tonight

TheKanataThrilla (25-Apr) : Anyone hanging out in the chat tonight?

Zero2Cool (25-Apr) : whoa...49ers have had trade conversations about both Deebo Samuel and Brandon Aiyuk

Zero2Cool (25-Apr) : I hope they take a Punter at 9th overall. Be bold!

Mucky Tundra (25-Apr) : I may end up eating those words but I think they need a lot more talent then their 4 picks can provide

Mucky Tundra (25-Apr) : I really hope they stand pat and Draft a WR

Mucky Tundra (25-Apr) : @DMRussini

Mucky Tundra (25-Apr) : The Chicago Bears are very open for business at 9 and telling teams they are ready to move for the right price, per source

buckeyepackfan (24-Apr) : Lions extend Penei Soul 4yrs - 112mil

buckeyepackfan (24-Apr) : Lions extend St. Brown 4 years 120mil and

Mucky Tundra (24-Apr) : Now look, trading up to 13 to take a TE might not seem like a good idea later but it will be later!

dfosterf (24-Apr) : (Your trade up mock post)

dfosterf (24-Apr) : Mucky- The only thing fun to watch would be me flipping the f out if Gute goes up to 13 and grabs Brock Bowers, lol

beast (24-Apr) : DT Byron Murphy II, Texas... whom some believe is the next Aaron Donald (or the closest thing to Donald)

Zero2Cool (24-Apr) : What? And who?

Mucky Tundra (24-Apr) : *sad Mucky noises*

Mucky Tundra (24-Apr) : @JoeJHoyt Murphy said he’s been told he won’t slide past pick No. 16.

wpr (23-Apr) : Just about time to watch Sonny Weaver stick it to the seahags. I never get tired of it.

Martha Careful (23-Apr) : *game plan

Martha Careful (23-Apr) : IMHO, not even close. He is not a guy you game play around.

Mucky Tundra (23-Apr) : is Aiyuk worth a 1st rounder?

Zero2Cool (23-Apr) : 49ers are seeking a 1st round pick in exchange for WR Brandon Aiyuk

Mucky Tundra (22-Apr) : Based on Gutes comments, now I don't feel as silly having 13 picks in my mock the other day

Zero2Cool (22-Apr) : Zach Wilson to Broncos.

Zero2Cool (22-Apr) : Gutekunst says he'd love to have 13 or 14 picks. He's trading back huh lol

beast (22-Apr) : Someday we'll have a draft betting scandal

beast (21-Apr) : Sometimes looking extremely amazing, sometimes looking extremely lost

beast (21-Apr) : I haven't looked into the QBs, but some have suggested Maye has some of the most extremely inconsistent tape they've seen

beast (21-Apr) : Well it also sounds like Patriots are listening to trade offers, not that seriously considering any, but listening means they aren't locked

Zero2Cool (21-Apr) : Maye needs to be AFC

Mucky Tundra (21-Apr) : Not liking the idea of the Vikings getting Maye

Zero2Cool (21-Apr) : Vikings HC joked that he may or may not have sent flowers to Bob Kraft. That's where rumor came from.

beast (21-Apr) : Can't tell if this is real or BS, but some rumors about a possible Patriots/Vikings trade for #3 overall

dfosterf (21-Apr) : One playbook to my knowledge. I was shooting for facetious.

beast (20-Apr) : I'm not sure they have different playbooks for different OL positions, and Dillard run blocking is supposedly worse than his pass blocking..

Please sign in to use Fan Shout

2023 Packers Schedule

Sunday, Sep 10 @ 3:25 PM

Bears

38 - 20

Sunday, Sep 17 @ 12:00 PM

Falcons

24 - 25

Sunday, Sep 24 @ 12:00 PM

SAINTS

18 - 17

Thursday, Sep 28 @ 7:15 PM

LIONS

20 - 34

Monday, Oct 9 @ 7:15 PM

Raiders

13 - 17

Sunday, Oct 22 @ 3:25 PM

Broncos

17 - 19

Sunday, Oct 29 @ 12:00 PM

VIKINGS

10 - 24

Sunday, Nov 5 @ 12:00 PM

RAMS

20 - 3

Sunday, Nov 12 @ 12:00 PM

Steelers

19 - 23

Sunday, Nov 19 @ 12:00 PM

CHARGERS

23 - 20

Thursday, Nov 23 @ 11:30 AM

Lions

29 - 22

Sunday, Dec 3 @ 7:20 PM

CHIEFS

27 - 19

Monday, Dec 11 @ 7:15 PM

Giants

22 - 24

Sunday, Dec 17 @ 12:00 PM

BUCCANEERS

20 - 34

Sunday, Dec 24 @ 12:00 PM

Panthers

33 - 30

Sunday, Dec 31 @ 7:20 PM

Vikings

33 - 10

Sunday, Jan 7 @ 3:25 PM

BEARS

17 - 9

Sunday, Jan 14 @ 3:30 PM

Cowboys

48 - 32

Saturday, Jan 20 @ 7:15 PM

49ers

21 - 24