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: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,500
Applause Received: 4,044
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: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,500
Applause Received: 4,044
" 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: 79
Applause Received: 81
" 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: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,500
Applause Received: 4,044
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: 437
Applause Received: 1,233
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: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,500
Applause Received: 4,044
" 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: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,500
Applause Received: 4,044
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: 2011FleaFlicker Fantasy Football - Bronze: 2016ESPN NCAA March Madness - Bronze: 2010Yahoo! NCAA March Madness - Bronze: 2013

United States
Joined: 10/13/2006(UTC)
Location: Green Bay, WI
Applause Given: 2,500
Applause Received: 4,044
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
uffda udfa (1h) : Back to football: Julio says he's going to play Sunday. Did NOT say he wouldn't be limited in the game.
uffda udfa (1h) : Anyone ever used their dishwasher to make their Thanksgiving turkey?
uffda udfa (1h) : Favorite Ronnie Milsap song? Smokey Mountain Rain or Any Day Now?
uffda udfa (4h) : Favorite GM candidate... Wolf or Gutekunst?
uffda udfa (5h) : I'd rather sit them than play them too compromised.
uffda udfa (5h) : Yeah, Z. More pressure cooker talk and smoked turkeys.
Zero2Cool (5h) : If this were a regular-season game, Nelson, Adams and Allison probably would not play, MM says.
Smokey (6h) : Mason Crosby is ill, hope it's not the Flu.
Smokey (6h) : Great, can we move past that story and get back to the Atlanta game ?
Zero2Cool (6h) : Packers exec Eliot Wolf has withdrawn his name for 49ers' GM job, as @TomPelissero reported. He didn't feel it was the right time.
TheKanataThrilla (7h) : We'll just have to score TDs then.
Zero2Cool (7h) : That's what we know.
Zero2Cool (7h) : Crosby, Mason K Illness
Smokey (8h) : Is He ill or not ?
Smokey (8h) : Raiderpride asked, "Anyone know what Crosby's illness is?"
Zero2Cool (8h) : Davante Adams expected to play- KFFL
Porforis (9h) : Alright, my opinion on Jordy has changed. If he's medically cleared to play, play him.
hardrocker950 (10h) : By Sunday we won't have any WRs
Zero2Cool (11h) : Geronimo hamstring, Janis quad. BEAUTIFUL.
Smokey (11h) : Mason Crosby, is his health OK ?
Smokey (11h) : Hello
FLORIDA PACKER88 (11h) : Davis, G-Mo, and Janis will need to step up, but all three did score last time we played ATL!
FLORIDA PACKER88 (11h) : Does Janis become a playoff hero second year in a row? Looks we're gonna have to find out either way regardless. Thank God for a healthy Cob
Smokey (11h) : Is Mason Crosby's health OK ?
Smokey (12h) : What's in your Coffee ?
uffda udfa (18-Jan) : Sit Davante if he has a bad ankle. We remember 2015.
uffda udfa (18-Jan) : Davante is not going to practice until SAT at earliest.
uffda udfa (18-Jan) : Davante and Jordy may be inactive at ATL.
Smokey (18-Jan) : ROFL !!
Cheesey (18-Jan) : The Packers SMOKED the COWBOYS!!!LOL!
Smokey (18-Jan) : Ever Smoke a Turkey, it takes lots of rolling papers. LOL
Smokey (18-Jan) : Thanks Cheesey. LOL
Cheesey (18-Jan) : Smokey, it was chicken gizzards (and hearts)!
Cheesey (18-Jan) : So let's just start by saying, I love you!
Zero2Cool (18-Jan) : Great, Geronimo Allison is on the injury report.
Please sign in to use Fan Shout

2016 Packers Schedule
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 @ 3:25 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 @ 7:30 PM
at Lions

Think About It
Think About It

Recent Topics
now / Green Bay Packers Talk / beast

52m / Green Bay Packers Talk / uffda udfa

1h / Green Bay Packers Talk / uffda udfa

1h / Green Bay Packers Talk / uffda udfa

1h / Green Bay Packers Talk / The_Green_Ninja

2h / Green Bay Packers Talk / Dulak

4h / Green Bay Packers Talk / TheKanataThrilla

4h / Around The NFL / wpr

4h / Around The NFL / wpr

5h / Green Bay Packers Talk / wpr

5h / Green Bay Packers Talk / Smokey

6h / Around The NFL / Smokey

6h / Green Bay Packers Talk / TheKanataThrilla

7h / Green Bay Packers Talk / TheKanataThrilla

9h / Green Bay Packers Talk / uffda udfa


Packers Headlines