Green Bay Packers Forum

Welcome to your Green Bay Packers Online Community!

Since 2006, PackersHome has been providing a unique experience for fans.
Your participation is greatly anticipated!
Login or Register.
2 Pages12>
Options
Go to last post Go to first unread
Offline Zero2Cool  
#1 Posted : Monday, May 16, 2011 1:41:13 PM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,389
Applause Received: 3,742
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.
Offline vikesrule  
#2 Posted : Monday, May 16, 2011 4:20:35 PM(UTC)
Rank: Registered

Joined: 8/4/2007(UTC)
Applause Given: 60
Applause Received: 193
" said: Go to Quoted Post
...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.
Offline Zero2Cool  
#3 Posted : Monday, May 16, 2011 4:30:23 PM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,389
Applause Received: 3,742
" said: Go to Quoted Post
" said: Go to Quoted Post
...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.
Offline vikesrule  
#4 Posted : Monday, May 16, 2011 6:59:17 PM(UTC)
Rank: Registered

Joined: 8/4/2007(UTC)
Applause Given: 60
Applause Received: 193
" said: Go to Quoted Post
" said: Go to Quoted Post
" said: Go to Quoted Post
...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:
Offline 68md  
#5 Posted : Monday, May 16, 2011 8:37:16 PM(UTC)
Rank: Member

Yahoo! NCAA March Madness - Gold: 2009

United States
Joined: 10/1/2008(UTC)
Location: Deep South
Applause Given: 78
Applause Received: 80
" said: Go to Quoted Post
" said: Go to Quoted Post
...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:
Offline Zero2Cool  
#6 Posted : Monday, May 16, 2011 11:26:25 PM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,389
Applause Received: 3,742
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.
Offline Pack93z  
#7 Posted : Tuesday, May 17, 2011 1:26:23 PM(UTC)
Rank: Select Member

PackersHome NFL Pick'em - Bronze: 2012

United States
Joined: 3/16/2007(UTC)
Location: North Central Wisconsin
Applause Given: 436
Applause Received: 1,207
Hmmm... can't seem to log into the new environment.. can't even resend a password..
Offline Zero2Cool  
#8 Posted : Tuesday, May 17, 2011 1:43:41 PM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,389
Applause Received: 3,742
" said: Go to Quoted Post
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.


Code:

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.
Offline Zero2Cool  
#9 Posted : Tuesday, May 17, 2011 1:59:21 PM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,389
Applause Received: 3,742
Code:
sp_helptext 'GetUsersByUserName'
Offline Zero2Cool  
#10 Posted : Tuesday, May 17, 2011 4:26:44 PM(UTC)
Rank: Premier Member

Yahoo! NCAA March Madness - Gold: 2015Yahoo! Fantasy Football - Gold: 2009FleaFlicker Fantasy Football - Silver: 2010Yahoo! NCAA March Madness - Silver: 2011ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,389
Applause Received: 3,742
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.
Rss Feed 
Users browsing this topic
Guest
Similar Topics
You can help create the NEW PackersHome! (Feedback, Suggestions and Issues)
by Zero2Cool 4/26/2011 8:43:27 PM(UTC)
2 Pages12>
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error


Fan Shout
hardrocker950 (8h) : Just wonderful - my pick em didn't register....
beast (17h) : I'm not sure if it's still true, but it used to be hard to get sacks on Eli because he'd toss one up when linemen got semi-close (which lead
Zero2Cool (18h) : Slam Eli a lot very early. Once rattled he can't regain composure.
beast (18h) : since slot WRs might be the Packers strength depth/talent wise
beast (18h) : With AR's passing % down field so low, I've been saying they should go with short passes like the Pats used to do, especially since slot WRs
beast (18h) : What's going to be needed against the Giants is OL and DBs (IMO)
Smokey (28-Sep) : Cook(TE) has time to heal, but may not be needed against NYG on Oct 9th .
Zero2Cool (27-Sep) : . Aaron Rodgers has a completion percentage of 33.3 on 10+ air yard passes this season (tied for the lowest in NFL).
Zero2Cool (27-Sep) : High-ankle sprain could sideline Cook
Zero2Cool (26-Sep) : Odell Beckham Jr, Dez Bryant, Alshon Jeffery and Julio Jones on tap for Packers. Yippie.
Cheesey (26-Sep) : Arnold Palmer was a class act all around. RIP
Smokey (26-Sep) : Rest in Peace Arnold Palmer, you blessed us all .
hardrocker950 (26-Sep) : What a strange weekend of football
jdlax (26-Sep) : What's up, friends? It's like bizzaro world right now trailing the Vikings. Blah.
GoPack1984 (25-Sep) : Ryan Fitzpatrick threw 6 interceptions!
TheKanataThrilla (25-Sep) : Cleveland loses.
The_Green_Ninja (25-Sep) : I swear, Jacksonville's hot weather must be a huge advantage. Kept it super close with the Ravens
TheKanataThrilla (25-Sep) : Su'a Cravens with a big INT. A guy I wanted.
TheKanataThrilla (25-Sep) : Can Cleveland win?
Zero2Cool (25-Sep) : T.J. Lang said after one of Aaron Rodgers' TD passes the Packers quarterback head-butted Lang in excitement and said "I'm back."
Zero2Cool (25-Sep) : Terrelle Pryor could see snaps at quarterback
Zero2Cool (25-Sep) : inactives 6 Callahan 37 Shields 42 Burnett 52 Matthews 68 Murphy 95 Jones 98 Guion
Mucky Tundra (25-Sep) : GET HYPE
Zero2Cool (25-Sep) : Packers aim to showcase speed of Ty Montgomery, Trevor Davis
Zero2Cool (25-Sep) : CB Quinten Rollins will start for Shields. Micah Hyde for Burnett. Julius Peppers for Matthews. Kenny Clark for Guion.
Tezzy (25-Sep) : Probably will not be on the top of the Pick'Em leaderboard after today, soaking it in beforehand
Tezzy (25-Sep) : Foosball!
yooperfan (25-Sep) : Game day, tee it up and get this show on the road!
dyeah_gb (25-Sep) : Dyeah! Go Pack!
buckeyepackfan (25-Sep) : GOOD MORNING PACKER FANS! GAMEDAY! GO! PACK! GO!
flep (25-Sep) : Gameday!!! Will see you all in chat later
The_Green_Ninja (25-Sep) : Also, I'm not sure if you guys know. I'm a Memphis Tigers fan. Start looking a Riley Ferguson, QB. He is the real deal.
The_Green_Ninja (24-Sep) : Big whoop, we have Aaron. We are going to win. H8ers.
Zero2Cool (24-Sep) : Matthews, Burnett out; Guion, Jones doubtful
Zero2Cool (24-Sep) : thank ya
Please sign in to use Fan Shout

Road To Super Bowl LI
Sunday, Sep 11 @ 12:00 PM
at Jaguars
Sunday, Sep 18 @ 7:30 PM
at Vikings
Sunday, Sep 25 @ 12:00 PM
LIONS
Sunday, Oct 2 @ 12:00 AM
BYE
Sunday, Oct 9 @ 7:30 PM
GIANTS
Sunday, Oct 16 @ 3:25 PM
COWBOYS
Thursday, Oct 20 @ 7:25 PM
BEARS
Sunday, Oct 30 @ 12:00 PM
at Falcons
Sunday, Nov 6 @ 3:25 PM
COLTS
Sunday, Nov 13 @ 12:00 PM
at Titans
Sunday, Nov 20 @ 7:30 PM
at Redskins
Monday, Nov 28 @ 7:30 PM
at Eagles
Sunday, Dec 4 @ 12:00 PM
TEXANS
Sunday, Dec 11 @ 3:25 PM
SEAHAWKS
Sunday, Dec 18 @ 12:00 PM
at Bears
Saturday, Dec 24 @ 12:00 PM
VIKINGS
Sunday, Jan 1 @ 12:00 PM
at Lions

Think About It
Think About It

Recent Topics
19m / Green Bay Packers Talk / yooperfan

4h / Green Bay Packers Talk / The_Green_Ninja

4h / Around The NFL / Cheesey

4h / Green Bay Packers Talk / Cheesey

9h / Green Bay Packers Talk / steveishere

12h / Green Bay Packers Talk / wpr

14h / Green Bay Packers Talk / nerdmann

16h / Green Bay Packers Talk / blueleopard

16h / Around The NFL / Mucky Tundra

16h / Green Bay Packers Talk / DarkaneRules

20h / Fantasy Sports Talk / Smokey

29-Sep / Green Bay Packers Talk / wpr

29-Sep / Green Bay Packers Talk / blueleopard

28-Sep / Green Bay Packers Talk / The_Green_Ninja

28-Sep / Green Bay Packers Talk / DoddPower


Packers Headlines