JavaScript is required to use Bungie.net

Destiny

Discuss all things Destiny.
Edited by Phuzakie: 12/14/2014 4:56:24 AM
296

TOPIC CHANGED: Example Code Of How To Rotate Different Strikes Based On Content Purchased

[b]I hijacked my own thread, because I can, but fret not, this will be my second to last post ever.[/b] [b]And oh yeah, the solution below allows PlayStation exclusives into the rotation for PlayStation users as well.[/b] ALSO SEE: MY LAST POST: Instead of buying TDB, I'll donate to charity [url]http://www.bungie.net/en/Forum/Post/84383811[/url] So this post started about me talking to two people about Destiny and them choosing not to buy it after I explained to them how I was locked out of part of this game, all because other people bought the expansion and I had not. Spend the time not replying to my rants by trying to come up with your own way of not excluding people. Try to open your mind and see, no one wants free shit... no one wants your strikes. Let them continue playing the way they have been. DLC should only add, never lock out... but whatever... So many people don't get the reason why I am choosing to take a stand. It is simple. I, along with others don't feel like non-dlc owners should have been punished by not being given an alternate strike as the weekly heroic / nightfall instead of the new strike. 1) I like the game, I don't like bullying people into buying a content pack by holding weekly rewards (even the old ones) as ransom. 2) This is not about money. I was a couple of button clicks away from buying the season pass. 3) This isn't just for one week. This will happen every time DLC content is used in the daily/weekly/nightfall rotation. It will only get worse as time goes on. 4) Implementing alternate strikes with tiered rewards for lower content owners doesn't hurt anyone who buys the expansions. So... [b]The alternate solution[/b] is to pick a different strike for each player based upon the most inclusive content pack they have bought. I present to you exhibit A. Is it perfect? No, but it takes into consideration that no one should be punished for not buying an expansion. It took me all of 30 minutes tops. Imagine what Bungie devs could do with a week on this issue. [u]The Table[/u] [spoiler] CREATE TABLE [dbo].[StrikePlaylist]( [Platform] [nvarchar](50) NOT NULL, [ContentPack] [nvarchar](50) NOT NULL, [Strike] [nvarchar](50) NOT NULL, [LastPlayed] [datetime] NULL, [/spoiler] [u]The Data (38 Rows including House of Wolves future strike)[/u] [spoiler] PlayStation Destiny Cerberus Vae III 2014-09-29 00:00:00.000 PlayStation Destiny Dust Palace 2014-10-06 00:00:00.000 PlayStation Destiny The Devils' Lair 2014-09-01 00:00:00.000 PlayStation Destiny The Nexus 2014-09-15 00:00:00.000 PlayStation Destiny The Summoning Pits 2014-09-08 00:00:00.000 PlayStation Destiny Winter's Run 2014-09-22 00:00:00.000 PlayStation House of Wolves Cerberus Vae III 2014-09-29 00:00:00.000 PlayStation House of Wolves Dust Palace 2014-10-06 00:00:00.000 PlayStation House of Wolves Moon Strike NULL PlayStation House of Wolves The Devils' Lair 2014-09-01 00:00:00.000 PlayStation House of Wolves The Nexus 2014-09-15 00:00:00.000 PlayStation House of Wolves The Summoning Pits 2014-09-08 00:00:00.000 PlayStation House of Wolves Will of Crota 2014-12-09 00:00:00.000 PlayStation House of Wolves Winter's Run 2014-09-22 00:00:00.000 PlayStation The Dark Below Cerberus Vae III 2014-09-29 00:00:00.000 PlayStation The Dark Below Dust Palace 2014-10-06 00:00:00.000 PlayStation The Dark Below The Devils' Lair 2014-09-01 00:00:00.000 PlayStation The Dark Below The Nexus 2014-09-15 00:00:00.000 PlayStation The Dark Below The Summoning Pits 2014-09-08 00:00:00.000 PlayStation The Dark Below Will of Crota NULL PlayStation The Dark Below Winter's Run 2014-09-22 00:00:00.000 XBox Destiny Cerberus Vae III 2014-09-29 00:00:00.000 XBox Destiny The Devils' Lair 2014-10-06 00:00:00.000 XBox Destiny The Nexus 2014-09-15 00:00:00.000 XBox Destiny The Summoning Pits 2014-09-08 00:00:00.000 XBox Destiny Winter's Run 2014-09-22 00:00:00.000 XBox House of Wolves Cerberus Vae III 2014-09-29 00:00:00.000 XBox House of Wolves Moon Strike NULL XBox House of Wolves The Devils' Lair 2014-09-01 00:00:00.000 XBox House of Wolves The Nexus 2014-09-15 00:00:00.000 XBox House of Wolves The Summoning Pits 2014-09-08 00:00:00.000 XBox House of Wolves Will of Crota 2014-12-09 00:00:00.000 XBox House of Wolves Winter's Run 2014-09-22 00:00:00.000 XBox The Dark Below The Devils' Lair 2014-09-01 00:00:00.000 XBox The Dark Below The Nexus 2014-09-15 00:00:00.000 XBox The Dark Below The Summoning Pits 2014-09-08 00:00:00.000 XBox The Dark Below Will of Crota NULL XBox The Dark Below Winter's Run 2014-09-22 00:00:00.000 [/spoiler] [u]The Query[/u] [spoiler] SELECT TOP 1 * FROM [dbo].[StrikePlaylist] WHERE Platform = '[b]PLATFORM OF USER[/b]' AND ContentPack = '[b]MOST INCLUSIVE CONTENT PACK USER OWNS[/b]' ORDER BY (CASE WHEN [LastPlayed] IS NULL THEN 1 ELSE 0 END) DESC, LastPlayed [/spoiler] [u]Results[/u] [quote] An XBox player with no DLC packs would get: The Summoning Pits An XBox player with The Dark Below would get: Will of Crota An XBox player with House of Wolves would get: Moon Strike A PlayStation player with no DLC packs would get: The Devils' Lair A PlayStation player with The Dark Below would get: Will of Crota A PlayStation player with House of Wolves would get: Moon Strike [/quote] Also, Destiny In The Media [spoiler]Destiny: The Dark Below – there’s no excuse for the paywall on weeklies [url]http://www.vg247.com/2014/12/10/destiny-the-dark-below-paywalls-heroic-nightfall-weekly-weeklies/[/url] Destiny The Dark Below Expansion puts some old content behind DLC paywall [url]http://attackofthefanboy.com/news/destiny-dark-expansion-puts-old-content-behind-dlc-paywall/[/url] Destiny's Weekly Strike Is Now Locked Behind DLC [url]http://kotaku.com/destinys-weekly-strike-is-now-locked-behind-dlc-1668709133[/url][/spoiler]
English
#Destiny

Posting in language:

 

Play nice. Take a minute to review our Code of Conduct before submitting your post. Cancel Edit Create Fireteam Post

View Entire Topic
  • I'm pretty sure a bunch of games do the same thing where the content is already there and you pay to unlock it, so you did nothing special

    Posting in language:

     

    Play nice. Take a minute to review our Code of Conduct before submitting your post. Cancel Edit Create Fireteam Post

1 2
You are not allowed to view this content.
;
preload icon
preload icon
preload icon