Join date script working!

User avatar
Vector
Event Founder
Event Founder
Posts: 239
Joined: Fri Jul 04, 2003 6:00 pm
City: Portland
State: Oregon
Contact:

Join date script working!

Post by Vector » Thu Jul 19, 2018 6:17 pm

A few of you had asked if we could migrate the join date from your old user profile. Staff member Pietzaaah wrote a cute little script to look at both the username and email address in both forums, and if there is a match, it updates your "join date and time"

If you have questions on how it worked, I am sure he'd be glad to tell ya.

Thanks Pietz!
=Vector=

User avatar
CyberCrist
Moderator
Moderator
Posts: 38
Joined: Sun Jan 21, 2007 4:30 pm
City: Vancouver
State: Washington

Re: Join date script working!

Post by CyberCrist » Thu Jul 19, 2018 7:25 pm

:like:
--
<End of Line>

User avatar
Ghostwalker
Specialist
Specialist
Posts: 36
Joined: Mon May 02, 2005 11:36 am
City: Los Angeles
State: California
Contact:

Re: Join date script working!

Post by Ghostwalker » Thu Jul 19, 2018 10:35 pm

Thanks Pietz! :like:
"...All those moments will be lost in time, like tears in rain..."

User avatar
xeromist
Chief Moderator
Chief Moderator
Posts: 74
Joined: Fri Dec 07, 2007 8:20 am
City: Sacramento
State: California

Re: Join date script working!

Post by xeromist » Fri Jul 20, 2018 9:53 am

Now we can all feel old again. :D
At a bus station, a bus stops. At a train station, a train stops. On my desk, I have a work station.

User avatar
Zubaru
Private
Private
Posts: 7
Joined: Wed Feb 23, 2005 4:31 pm
City: Beaverton
State: Oregon

Re: Join date script working!

Post by Zubaru » Fri Jul 20, 2018 11:02 am

xeromist wrote:
Fri Jul 20, 2018 9:53 am
Now we can all feel old again. :D
or younger than we should be. :)
My sig is too small, for me to add what i wan

ccoelnwhack
Private First Class
Private First Class
Posts: 21
Joined: Fri Aug 12, 2005 8:36 pm
City: Hillsboro
State: Oregon

Re: Join date script working!

Post by ccoelnwhack » Fri Jul 20, 2018 11:11 am

Hey it worked with my change in username!

pietzaaah share the source code :D

User avatar
Moogle388
PDXLAN Staff
PDXLAN Staff
Posts: 26
Joined: Thu Oct 25, 2012 11:11 am
City: Newberg
State: Oregon

Re: Join date script working!

Post by Moogle388 » Fri Jul 20, 2018 11:23 am

all hail pietzahh
PDX LAN 21-32B, Vector LAN 3-8, Nov LAN '12-'17 AGE 1-4, PDXLAN STAFF -SPRING 2019

User avatar
Yeti
PDXLAN Staff
PDXLAN Staff
Posts: 10
Joined: Sat Mar 19, 2005 12:47 am
City: Portland
State: Oregon

Re: Join date script working!

Post by Yeti » Fri Jul 20, 2018 11:33 am

Neat

User avatar
Ghostwalker
Specialist
Specialist
Posts: 36
Joined: Mon May 02, 2005 11:36 am
City: Los Angeles
State: California
Contact:

Re: Join date script working!

Post by Ghostwalker » Fri Jul 20, 2018 12:36 pm

Yeah, totally out of curiosity: Is there a git repo for this code? :)
"...All those moments will be lost in time, like tears in rain..."

User avatar
Tessa
Private
Private
Posts: 9
Joined: Sun Feb 19, 2017 4:59 pm
City: Marysville
State: Washington
Contact:

Re: Join date script working!

Post by Tessa » Fri Jul 20, 2018 1:25 pm

You are the best! (Because if you weren't the best, you'd accidentally delete the DB...) =)
Samsung 960 EVO 1T & 500GB m.2
DDR4 32GB 2666MHz
Nvidia GTX1080
Intel i7 7700K
Asus z270 mobo

User avatar
CyberCrist
Moderator
Moderator
Posts: 38
Joined: Sun Jan 21, 2007 4:30 pm
City: Vancouver
State: Washington

Re: Join date script working!

Post by CyberCrist » Fri Jul 20, 2018 2:03 pm

It's kinda funny... you look at peoples join dates, back in 2005 and 2007 and they have 3 or 4 posts. :D
--
<End of Line>

User avatar
Someguyrb
Private
Private
Posts: 9
Joined: Sat Feb 18, 2012 11:48 am
City: PORTLAND
State: Oregon

Re: Join date script working!

Post by Someguyrb » Fri Jul 20, 2018 3:34 pm

Mine isn't working... shame =/

Edit: I wonder if it's because my name had a slight typo previously. In the old forum it was SOmeguyrb, when it should be Someguyrb
Proud attendee of PDXLAN 28, 29, 30, 31, 32b, Fall 2018

User avatar
Vector
Event Founder
Event Founder
Posts: 239
Joined: Fri Jul 04, 2003 6:00 pm
City: Portland
State: Oregon
Contact:

Re: Join date script working!

Post by Vector » Fri Jul 20, 2018 9:49 pm

Someguyrb wrote:
Fri Jul 20, 2018 3:34 pm
Mine isn't working... shame =/

Edit: I wonder if it's because my name had a slight typo previously. In the old forum it was SOmeguyrb, when it should be Someguyrb
I believe it attempts to match by email or username.
=Vector=

User avatar
Pietzaahh
PDXLAN Staff
PDXLAN Staff
Posts: 34
Joined: Mon Jul 01, 2013 8:38 am
City: Portland
State: Oregon

Re: Join date script working!

Post by Pietzaahh » Sat Jul 21, 2018 12:41 am

It's a super simple MySQL Trigger that matches up by email only. I can modify it to match additionally by username, but I wanted to prevent username squatting.

I'm happy to share the source. I'll post it when I get home from a weekend trip. I shared it with the staff if one of them wants to repost the screenshot.
ɥɥɐɐzʇǝᴉԀ | Matt #3 | Staff since PDXLAN 23

User avatar
Vector
Event Founder
Event Founder
Posts: 239
Joined: Fri Jul 04, 2003 6:00 pm
City: Portland
State: Oregon
Contact:

Re: Join date script working!

Post by Vector » Sat Jul 21, 2018 10:20 am

Here you go.
You do not have the required permissions to view the files attached to this post.
=Vector=

User avatar
Someguyrb
Private
Private
Posts: 9
Joined: Sat Feb 18, 2012 11:48 am
City: PORTLAND
State: Oregon

Re: Join date script working!

Post by Someguyrb » Sat Jul 21, 2018 8:02 pm

hmm... I originally used my new updated email, but when I realized it was a different email then I used before, I changed it to the one I used... Did I ruin my chances because of that?
Proud attendee of PDXLAN 28, 29, 30, 31, 32b, Fall 2018

User avatar
Pietzaahh
PDXLAN Staff
PDXLAN Staff
Posts: 34
Joined: Mon Jul 01, 2013 8:38 am
City: Portland
State: Oregon

Re: Join date script working!

Post by Pietzaahh » Sun Jul 22, 2018 11:21 pm

Someguyrb wrote:
Sat Jul 21, 2018 8:02 pm
hmm... I originally used my new updated email, but when I realized it was a different email then I used before, I changed it to the one I used... Did I ruin my chances because of that?
The match happens only during user creation. I can run it manually though, one sec...

EDIT: Updated
ɥɥɐɐzʇǝᴉԀ | Matt #3 | Staff since PDXLAN 23

User avatar
thetruejaster
Sergeant
Sergeant
Posts: 137
Joined: Sun Feb 19, 2012 2:30 pm
City: Gresham
State: Oregon
Contact:

Re: Join date script working!

Post by thetruejaster » Tue Jul 24, 2018 4:51 pm

Pretty cool! Thanks Matt!
T24 Group Lead since 22
PDXLAN: 20-32ab, F18
NovLAN: 20.5, 2015-2017
VectorLAN: 5, 7, 8

User avatar
NightFox45
Private
Private
Posts: 2
Joined: Mon Dec 03, 2018 6:09 pm
City: Aloha
State: Oregon

Re: Join date script working!

Post by NightFox45 » Mon Dec 03, 2018 9:03 pm

Hi all,

It doesn't appear that the join date script successfully triggered when I recreated my account using my original handle and original email address.

Could I get some help on this front if I cannot have my new handle (NightFox) updated with my join date?

Thanks
18, 18.5, 20, 22, 24, VL 2017, 32-A, 33, 34

Had to create 2nd acc and all I got was this join date.

User avatar
Pietzaahh
PDXLAN Staff
PDXLAN Staff
Posts: 34
Joined: Mon Jul 01, 2013 8:38 am
City: Portland
State: Oregon

Re: Join date script working!

Post by Pietzaahh » Sun Dec 09, 2018 4:28 pm

NightFox45 wrote:
Mon Dec 03, 2018 9:03 pm
Hi all,

It doesn't appear that the join date script successfully triggered when I recreated my account using my original handle and original email address.

Could I get some help on this front if I cannot have my new handle (NightFox) updated with my join date?

Thanks
Your original account "NightFox" has been updated.
ɥɥɐɐzʇǝᴉԀ | Matt #3 | Staff since PDXLAN 23

Post Reply