Database Upgrade (11/14/2014)

Any site related announcements from the Admins/Mods will appear here.

Moderators: Mackinlee, Franchise

User avatar
Franchise
Hall of Famer
Posts: 32001
Joined: Sat Apr 12, 2003 7:10 pm
Has thanked: 2 times
Been thanked: 5 times

Re: Database Upgrade (11/14/2014)

Post by Franchise » Fri Nov 21, 2014 5:14 pm

Ok, now that makes some sense. I'm home now so I'll check it out...
- 5x SW
- 31x TW
- 2x PPV
- 3x MITB
- 2x EWars
- 4x Survivor
- 2x TV Wars
- 2x Cup Games
- 3x PPV Wars
- 1x iWars
- 1x Ultimate Endurance
- 3x Jobber Wars
- 2x Bracket Brawl
- 6x Tag Team Challenge
- 1x Last Man Standing
- 1x SW Draft
- 1x Play-Per-View League

User avatar
legendkiller003
Titlewars NXT Champion
Posts: 25069
Joined: Tue Nov 13, 2007 8:54 pm
Has thanked: 3 times

Re: Database Upgrade (11/14/2014)

Post by legendkiller003 » Fri Nov 21, 2014 5:20 pm

I been running with 1 new message for over a year. It would go back to 0 when I would have picks automatically PM'd, because it never alerted you on the board as having a new message, so when viewing it it treated it as reading that one message. Then when someone would send a real PM it would go back to the 1 new message.
Image

User avatar
Franchise
Hall of Famer
Posts: 32001
Joined: Sat Apr 12, 2003 7:10 pm
Has thanked: 2 times
Been thanked: 5 times

Re: Database Upgrade (11/14/2014)

Post by Franchise » Fri Nov 21, 2014 7:14 pm

Ok...I *think* I fixed it. One thing I noticed, though, is that there are some users that have an absurd amount of unread PMs (like over 200) that look legit based on the secondary table. I'm guessing they may be of the PPV/TW confirmation email variety. Please check again and if it didn't reset, let me know and I will send you a new blank PM that should force a recalculation. If not, it's really messy to go into the messages table as there are two tables that tie this together and I'd have to loop through one, check the second count against the first, and then update it. Just let me know via PM and I'll take a look.

One other thing, I didn't notice any PMs unread or new anywhere for MVH. Not sure why he is getting that count but I couldn't find any.
- 5x SW
- 31x TW
- 2x PPV
- 3x MITB
- 2x EWars
- 4x Survivor
- 2x TV Wars
- 2x Cup Games
- 3x PPV Wars
- 1x iWars
- 1x Ultimate Endurance
- 3x Jobber Wars
- 2x Bracket Brawl
- 6x Tag Team Challenge
- 1x Last Man Standing
- 1x SW Draft
- 1x Play-Per-View League

User avatar
legendkiller003
Titlewars NXT Champion
Posts: 25069
Joined: Tue Nov 13, 2007 8:54 pm
Has thanked: 3 times

Re: Database Upgrade (11/14/2014)

Post by legendkiller003 » Fri Nov 21, 2014 7:27 pm

Looks good on my end :th:
Image

User avatar
The Lawnmower
Post Whore
Posts: 22600
Joined: Tue Apr 11, 2006 4:53 pm

Re: Database Upgrade (11/14/2014)

Post by The Lawnmower » Fri Nov 21, 2014 7:28 pm

Is there an improved version of YouTube embedding that supports HTTPS? We've been having to edit the URLs for quite a while now to make them work.
[center][img]http://i48.tinypic.com/1212wed.png[/img][/center]

User avatar
Franchise
Hall of Famer
Posts: 32001
Joined: Sat Apr 12, 2003 7:10 pm
Has thanked: 2 times
Been thanked: 5 times

Re: Database Upgrade (11/14/2014)

Post by Franchise » Fri Nov 21, 2014 8:37 pm

I was under the impression that the youtube bbcode already did this. I've never actually used the YouTube embedding I don't think tho; can you please provide an example of what comes up and what you have to change and I can look into it?
- 5x SW
- 31x TW
- 2x PPV
- 3x MITB
- 2x EWars
- 4x Survivor
- 2x TV Wars
- 2x Cup Games
- 3x PPV Wars
- 1x iWars
- 1x Ultimate Endurance
- 3x Jobber Wars
- 2x Bracket Brawl
- 6x Tag Team Challenge
- 1x Last Man Standing
- 1x SW Draft
- 1x Play-Per-View League

User avatar
The Lawnmower
Post Whore
Posts: 22600
Joined: Tue Apr 11, 2006 4:53 pm

Re: Database Upgrade (11/14/2014)

Post by The Lawnmower » Fri Nov 21, 2014 9:09 pm

YouTube URLs are all HTTPS now. So...

[youtube]https://www.youtube.com/watch?v=1sgQPVmeonY[/youtube]

Doesn't work. Delete the s and it does.

[youtube]http://www.youtube.com/watch?v=1sgQPVmeonY[/youtube]

It's just a bit annoying and half the people here forget what to do to get it work. Figured since you've been doing all the upgrades it could be worth looking in to.
[center][img]http://i48.tinypic.com/1212wed.png[/img][/center]

User avatar
Franchise
Hall of Famer
Posts: 32001
Joined: Sat Apr 12, 2003 7:10 pm
Has thanked: 2 times
Been thanked: 5 times

Re: Database Upgrade (11/14/2014)

Post by Franchise » Sat Nov 22, 2014 2:44 am

Ah gotcha. I will check it out, but I'm honestly not sure I can. The board, as of right now, isn't hosted with a secure socket layer (ssl) to my knowledge so I'm not sure I can do anything to allow that to work that way. I could try to change the setting for the forum from normal (http) to ssl (https) and see if it allows it. But to be honest, I'm not sure the rest of the site would be accessible if I did (well the forum at least). I shall look into that this week tho.
- 5x SW
- 31x TW
- 2x PPV
- 3x MITB
- 2x EWars
- 4x Survivor
- 2x TV Wars
- 2x Cup Games
- 3x PPV Wars
- 1x iWars
- 1x Ultimate Endurance
- 3x Jobber Wars
- 2x Bracket Brawl
- 6x Tag Team Challenge
- 1x Last Man Standing
- 1x SW Draft
- 1x Play-Per-View League

User avatar
PimpinSmurf
Hall of Famer
Posts: 40014
Joined: Fri Feb 07, 2003 4:49 am
Has thanked: 4 times

Re: Database Upgrade (11/14/2014)

Post by PimpinSmurf » Sat Nov 22, 2014 9:20 am

Cool mine's gone! Thanks Chise.

Are you saying if I read my automatic PMs for main event games, it will stay away? I believe those are the only ones I don't read.
"Cut my jeans into pieces. These are my badass jorts." (riff kicks in)

How I Got Over - Braun Strowman

User avatar
Franchise
Hall of Famer
Posts: 32001
Joined: Sat Apr 12, 2003 7:10 pm
Has thanked: 2 times
Been thanked: 5 times

Re: Database Upgrade (11/14/2014)

Post by Franchise » Sat Nov 22, 2014 10:48 am

It should. Like Bike said tho, if you delete them without reading losing first, I think that sometimes can cause it. Honestly not sure if that was just a bug from before or not as we were very behind on releases. You can uncheck the PM me my picks box when entering too and you won't get the PM for games.
- 5x SW
- 31x TW
- 2x PPV
- 3x MITB
- 2x EWars
- 4x Survivor
- 2x TV Wars
- 2x Cup Games
- 3x PPV Wars
- 1x iWars
- 1x Ultimate Endurance
- 3x Jobber Wars
- 2x Bracket Brawl
- 6x Tag Team Challenge
- 1x Last Man Standing
- 1x SW Draft
- 1x Play-Per-View League

User avatar
GM Bike
Post Whore
Posts: 24075
Joined: Fri Dec 09, 2005 5:13 pm
Has thanked: 1 time

Re: Database Upgrade (11/14/2014)

Post by GM Bike » Sat Nov 22, 2014 12:03 pm

Yesss! It says 0 now, thanks Chise! No more phantom PMs.

Oh hey there's 5 PMs you haven't read, oh you just clicked on your inbox guess what THEY'RE NOT THERE!
Image
ImageImage
First & ONLY 6, 7 AND 8-Time Stablewars Champion
17-Time Titlewars Champion, Current Tri-Champion (NXT/ROH Tag & ROH TV)
Longest Reigning Champion All-Time (1,316 Days)
16-Time PPV Champion
2017 WWE & ROH PPV Grand Champion

nWo 4 Life
🤘

User avatar
Franchise
Hall of Famer
Posts: 32001
Joined: Sat Apr 12, 2003 7:10 pm
Has thanked: 2 times
Been thanked: 5 times

Re: Database Upgrade (11/14/2014)

Post by Franchise » Sat Nov 22, 2014 8:18 pm

The Lawnmower wrote:YouTube URLs are all HTTPS now. So...

[youtube]https://www.youtube.com/watch?v=1sgQPVmeonY[/youtube]

Doesn't work. Delete the s and it does.
Thanks for the example. I believe I jus need to update the bbcode mapping. Will do it next time I'm on the desktop PC so I can run tests.
- 5x SW
- 31x TW
- 2x PPV
- 3x MITB
- 2x EWars
- 4x Survivor
- 2x TV Wars
- 2x Cup Games
- 3x PPV Wars
- 1x iWars
- 1x Ultimate Endurance
- 3x Jobber Wars
- 2x Bracket Brawl
- 6x Tag Team Challenge
- 1x Last Man Standing
- 1x SW Draft
- 1x Play-Per-View League

User avatar
Franchise
Hall of Famer
Posts: 32001
Joined: Sat Apr 12, 2003 7:10 pm
Has thanked: 2 times
Been thanked: 5 times

Re: Database Upgrade (11/14/2014)

Post by Franchise » Sun Nov 23, 2014 3:59 am

Franchise wrote:
The Lawnmower wrote:YouTube URLs are all HTTPS now. So...

[youtube]https://www.youtube.com/watch?v=1sgQPVmeonY[/youtube]

Doesn't work. Delete the s and it does.
Thanks for the example. I believe I jus need to update the bbcode mapping. Will do it next time I'm on the desktop PC so I can run tests.
This has been done. You should be all set going forward using the https, but I don't think it will retroactively fix the old ones and also will make the ones previously using http not work. I suppose I could always have two --- keep the youtube bccode for the old ones and add a new one like youtubehttps for the new ones going forward. Let me see if that keeps the old ones correctly...
- 5x SW
- 31x TW
- 2x PPV
- 3x MITB
- 2x EWars
- 4x Survivor
- 2x TV Wars
- 2x Cup Games
- 3x PPV Wars
- 1x iWars
- 1x Ultimate Endurance
- 3x Jobber Wars
- 2x Bracket Brawl
- 6x Tag Team Challenge
- 1x Last Man Standing
- 1x SW Draft
- 1x Play-Per-View League

User avatar
legendkiller003
Titlewars NXT Champion
Posts: 25069
Joined: Tue Nov 13, 2007 8:54 pm
Has thanked: 3 times

Re: Database Upgrade (11/14/2014)

Post by legendkiller003 » Sun Nov 23, 2014 4:21 am

The post in the Survivor Series thread there where Dub fixed the link I posted doesn't work now.

So I edited my original post that didn't work, and now that works.
Image

User avatar
Franchise
Hall of Famer
Posts: 32001
Joined: Sat Apr 12, 2003 7:10 pm
Has thanked: 2 times
Been thanked: 5 times

Re: Database Upgrade (11/14/2014)

Post by Franchise » Sun Nov 23, 2014 4:29 am

Yea as soon as I changed it to use https, the http ones stopped working. I looked around and played around with the code, but I couldn't get the old ones back no matter what I did. Going forward using the https will work fine, can even use http, but this will not retroactively fix the old ones and also will make the ones previously using http not work. I'll look into it this week to see if there is a way to make those work right again, but I am not hopeful. At least it will still retain the url so if anyone wants to watch older embedded youtube clips, they can copy/paste.

That said, I did stumble upon an extension that is currently in beta that will automatically format and embed over 90 different types of media links without having to use bbcodes. From twitter links to youtube and on and on. Since it's in beta, I 'm hesitant to install a potentially unstable release, but once it gets cleared for GA, I will add that extension. That should probably retroactively fix the old ones I'd imagine.
- 5x SW
- 31x TW
- 2x PPV
- 3x MITB
- 2x EWars
- 4x Survivor
- 2x TV Wars
- 2x Cup Games
- 3x PPV Wars
- 1x iWars
- 1x Ultimate Endurance
- 3x Jobber Wars
- 2x Bracket Brawl
- 6x Tag Team Challenge
- 1x Last Man Standing
- 1x SW Draft
- 1x Play-Per-View League

Post Reply