Sub CopyValuesAndAddFormula() Dim sourceSheet As Worksheet Dim targetSheet As Worksheet Dim itemsSheet As Worksheet Dim lastRow As Long Dim i As Long

Application.ScreenUpdating = False Set sourceSheet = ThisWorkbook.Worksheets("NetSuite-BottomPriceList") Set targetSheet = ThisWorkbook.Worksheets("bottom price update") Set itemsSheet = ThisWorkbook.Worksheets("Items") lastRow = sourceSheet.Cells(sourceSheet.Rows.Count, "A").End(xlUp).Row targetSheet.Cells(1, 1).Value = "Bottom Price id" targetSheet.Cells(1, 2).Value = "Item" targetSheet.Cells(1, 3).Value = "Item ID" targetSheet.Cells(1, 4).Value = "Sales Department" targetSheet.Cells(1, 5).Value = "Currency" targetSheet.Cells(1, 6).Value = "Bottom Price" For i = 2 To lastRow targetSheet.Cells(i, 2).Value = sourceSheet.Cells(i, 1).Value targetSheet.Cells(i, 4).Value = sourceSheet.Cells(i, 2).Value targetSheet.Cells(i, 5).Value = sourceSheet.Cells(i, 3).Value targetSheet.Cells(i, 6).Value = sourceSheet.Cells(i, 4).Value targetSheet.Cells(i, 1).FormulaArray = "=INDEX(Items!B:B,MATCH(1,(Items!A:A=B" & i & ")*(Items!I:I=D" & i & ")*(Items!H:H=E" & i & "),0))" targetSheet.Cells(i, 1).Value = targetSheet.Cells(i, 1).Value targetSheet.Cells(i, 3).FormulaArray = "=INDEX(Items!f:f,MATCH(1,(Items!A:A=B" & i & ")*(Items!I:I=D" & i & ")*(Items!H:H=E" & i & "),0))" targetSheet.Cells(i, 3).Value = targetSheet.Cells(i, 1).Value Next i Application.ScreenUpdating = True 

End Sub
This code produces the desired output, the issue is that it takes 20 minutes. I do not have access to xlookup either as I run an older version of Excel. How would you optimise my code so the same output is given.
To summarise I have 3 sheets.
Sheet 1 has my values Sheet 2 is blank Sheet 3 has more values
I generate sheet 1s values in another file.
I need columns A,B,C,D from sheet 1 to be copy and pasted into sheet 2 in columns B, D, E, F starting from row 2. There are 6 total columns in Sheet 2. The headers are in the vba code.
Once the values have been filled I then want to match the values in column B,D,E sheet 2 with the values in Column A,H,I respectively in sheet 3. If all 3 values in the same row from sheet 2 match all 3 values in the same row in sheet 3 I want to return the value in column B in sheet 3 to column A in sheet 2, I also want to return the value from column 6 in sheet 3 to column 3 in sheet 2.
Currently stumped trying to optimise this.

I've been trying to do research to find what smartwatch to get for my SO, but there's so much information out there I'm finding it hard to parse out everything I need.
She's told me she wants

• basic features like step counting and a timer, which I assume they all have
• smartphone integration allowed but not automatic (I don't know if it's ever required for use)
• A smallish profile for her medium-woman wrists
• She's a nurse, so she'd like to be able to easily run a timer on the watch that remains on without her having to do the whole wrist-movement to light it back up

It's the last criteria that's giving me trouble. From reading this sub and elsewhere, it sounds like she'd want an MIP display that's always on - is that right? Are there other key words I should be looking for?
Are there any watches that come to mind that meet these criteria? Or, what keywords should I be looking for in my search?
Thanks in advance

THANK YOU. 🙏🏼 To anyone who currently is and was and employee, THANK YOU! You guys made it so easy to go into a shop and ask questions, try new games and find whatever we were looking for. Thank you for making it a safe place to go and talk about on of our passions. I can’t tell you how many times I was in a particular situation where I felt like life had me down for the count and walking into my local GameStop helped. The employees were always happy to just chat when things weren’t busy. I’ve been in this sub for a few weeks and it really does sadden me by how much things have changed. To anyone reading this, you DO matter. No matter how things end up I wish you all nothing but the best in your future endeavors. Thank you again with much love. ❤️ - That one kid that always came in

Since I've been lurking in this sub-reddit for a good part of the last two years, I figured it was time to contribute by this debut post introducing an excellent little web novel that was completed during the tumultuous beginning stage of the pandemic in 2020.
无上女仙君 (Supreme Immortal Lord) by author 淡淡竹君， tells the story of An Ran 鄢然 （ which I suspect is a play on the homophone 安然 - peaceful - the complete opposite of the protagonist's life and personality), a young Dao practicioner from Earth. The story sets in an alternative universe where the Sun, one day, suddenly disappears from the solar system but in return, divine atmosphere （灵气）floods the planets giving rise to mages with talents and affinity like An Ran. Our MC soon proves herself a genius in her Dao practices, which descend from the 天河圣莲 - The Galaxy Lotus - a supremely divine object that acts as a cosmic balancer that she eventually encounters, and soon master all cosmic powers (which she demonstrates in forms of lotus insignia). However, on one occasion when she is brought to visit Northern Divine Realm -a higher realm- by an immortal friend, many secrets are revealed and she is eventually plunged into a cosmic conspiracy that ends with her being sacrificed by a group of immortals to revive their Saintess for the sake of their realm. Her consciousness however survives and manifests a physical body, restarts her cultivation and progresses the cultivation level（修为）up to incredible levels that enable her to master the Heavenly Flags - holy items that signifies the reign over all universes, of which there are nine. As the later chapters progress, she cultivates Chaotic energy, masters all nine flags and becomes Immortal Lord of the Nine Heavens （九天仙君), conjures a new Sun and Moon to the system, tames the universe, destroys the Devil emperor and his generals as well as his son, pushes back a galactic Undead invasion, liberates all holy beasts from Heaven's obligation, retrieves an important cosmic treasure that helps stabilizing all space and ends up progressing into a true Saintess/Sage that resides above all nine heavens (cosmos).
An Ran is a complex character with myriad of dynamic personalities that make her a believable heroic protagonist. She is fiercely fair, steadfast, pragmatic, loyal, benevolent but not without an infernal streak of vindictive vengeance. This is one lady who is liberal with her kill count so the action is plenty. The author takes good care of describing her actual effort in cultivation progress in tandem with her emtional maturity and strategy and in not one moment will the reader ever doubt An Ran's agency in her powers, authority or decisions as an Immortal Lord.
The supporting casts are also, surprisingly wholesome, fleshed out, and proactive. In such a hero-centric story yet this cast of characters - all immortals and mages - is fullly developed, strong and mostly independent of An Ran in the face of crises. This Xianxia also avoids romance completely with only the slightest implication at a relationship between An Ran and Yue Yin, the immortal that brought her to the higher realm in the first place and thus, out of guilt, spends years making up for her suffering.
Thus ends my long winded clumsy debut. Hope everyone will not find it a complete bore.
Note: This novel is available only in Simplified Chinese but I intend to translate it into English in the future.
Cheers.

39M, 16M NW fully liquid, but have made some of the worst investment decisions ever so that my IRR over the past 10 years is negative.
Have gained lot of perspective from discussions here.
Need some advice but first some context.
Got laid off job at 29. Was earning around 200k +options back then. Had just invested 400k all cash deal in a house back in home country as investment.
So at 30, I was without a job and 90% of my savings locked illiquid. The real estate firm went bankrupt. Not a single brick laid till date. Depression set in. Round one.
Tried looking for a job for 6 months but started reading on the side and got fascinated with a topic in public policy (negative effects of big tech). Over the next 2 years, worked on a book. Launched it at the age of 32. Wife's job kept us going but just about in VHCOL city.
Book became a bestseller and has crossed 1M copies now. Been on the speaking circuit 2015-19. Speaking fees started at early five figures and went close to 6 figures per speech just before covid.
Earning by year 2013: 0 2014: insignificant (5 figures) 2015: 1M 2016: 2.5M 2017: 3M 2018: 3.2M 2019: 3.9M
Covid happened and speaking circuit evaporated overnight. Went into identity crisis for 5 months. Round two.
Hadn't had time to invest till now because of breakneck growth. I know cash is trash but I was traveling 200 days a year on the speaking circuit.
Around mid of 2020, speaking still dried up but started seeing people make millions in the market.
Panicked about not having invested all these years. Jumped into the market. Bought 100k worth of index funds but they were growing at 10% while switching were growing 10x.
Fomo + greed set in. I had to make up for years of idle cash.
Long story short, I had put in 5M into stocks by Nov 2021. This had grown to 9M (huge positions in Asana, Snow, Zm, Tsla, Rblx etc). I kept on pumping but just held waiting for party to continue. I felt I had found my second act. Everything was turning to gold. That has today fallen to 1.8M. Everything from COIN to OPEN. No diversification. Didn't exit anything because, well, buy and hold.
Went into depression for a few months. Round three.
Got my act together early 2022. Decided to reinvent from traveling keynote speaker to remote consultant and boards. Helps spend more time with the kid. Built a huge network from speaking days and personal brand + continuing book sales help.
Income since covid 2020: 500K (Big drop compared to previous years) 2021: 1M 2022: 4M (with new board + consultant model)
Finally started going more into index funds 2022 onwards but still in the red with that as well.
I'm trying to get my act together now. Need some advice here (and perhaps just some psychological help)

1. I have always loved what I do and still do. So plan to still continue. But I can't get over the money I lost in the market which I may never recover. Also cant forgive myself for not investing all those years. But I was too scared to lose everything again the way I did.with my real estate investment. Wanted peace of mind through principal protection.

Essentially I have been the worst investor over the past decade. How do I forgive myself for that? I sit up nights sometime thinking about where I could have reached had I just done indexfunds.

1. How do I invest now? Yes cash was trash, but its giving me 4-5% now while my stocks are a lost cause. How do I start diversifying with around 10+M cash still available and adding 200-300k every month to it.
   
2. I'm not interested in RE. But the fear of losing it all again like I did at 30 keeps coming back especially after losing money on shit stocks in 2021. How do I fix that?
   
3. I still can't spend freely without counting even for sub 100 dollar amounts because I keep blaming myself for the money lost.
   

Essentially, how have you guys got over bad money decisions? And what should I do going forward to get it right?
Any and all advice appreciated. Thanks for listening.

I have a feeling this post probably won’t stay up on this subreddit for long, but I feel like it needs to be talked about and someone needs to say something. I also think this post will be good for people to maybe open their mind about the situation more. (Also I hope I used the right flair, sorry if i didn't!)
I’m posting this on a throw away account for the sake of safety and comfort, as honestly I don’t want to see what the comments will be like after. Also please leave the CCs mentioned out of it. They most likely don’t want to be involved in discourse and topics like this. Also quick disclaimer: nothing mentioned in this is meant to be targeting!! I think everyone is pretty relaxed most of the time.
As we all know, in mcc29 a bit of ‘tomfoolery’ happened that caused discourse and upset people - rightfully so. And the situation has pretty much boiled over into it becoming an argument about Misogyny, Double standards and the hypocritical nature of the community’s reaction.
For those not in the loop, In the final game of the event (TGTTOS) George was camping at the end of the races and trying to stop players from completing. The main part of it that has pretty much blown up and clips are being shared around are of in round 6 where George spent a solid 18 seconds hitting False repeatedly, knocking her back and it ended with her not being able to complete that round. The other thing is in round 3 when George tries to block off the NPCs so Michael couldn’t finish.
In the clip that's been circling around, False ends up saying that it was ‘Cringe’ and ‘Gross’. After the clip ends, in the vod/stream she then also mentions that she doesn’t want to hate on him for it, and that it wasn’t that big of a deal. Before I touch on the problem with George’s actions and the counter-arguments to every argument I have seen so far about it, I want to touch on the community’s reaction of False showing frustration or annoyance about it, as well as how they’ve escalated it and where there’s a double standard.
Essentially, a lot of people have been saying that False is overreacting or over-emotional about the situation, saying she’s ‘Angry’ and acting as if she’s having a tantrum over it. (Honestly False has been meaner to X on stream than she was towards George LOL). Obviously some people reading this can pick up on exactly what I'm hinting at here; the blatant misogyny in those comments. This isn’t the first time the community has said stuff like this to or of a female player for getting a bit frustrated or even crying on stream from being stressed/anxious/overwhelmed. From that point, some fans on Twitter started insulting False’s appearance (e.g: “is she doing a skeleton cosplay or does she just look like that” is one of the many tweets i’ve seen), as well as calling people soft/pathetic for explaining how George’s actions weren’t funny, and also going as far to tell people to die for not being happy that George acted that way. While this could be bait and trolling (and probably is), it is still very disrespectful to her and people expressing upset in the community.
*Arguments
The community’s response has then set people off into the conversation of misogyny and double standards, due to a lot of people saying that “it’s just a game”. To that argument, people have countered it with “If the roles were reversed everyone would be angry”, which considering the track record when it comes to Dteam members in MCC, is true. For example, back in MCC 22 when Snifferish did exactly what George did, there was a lot of hate. Tweets and posts with death threats, insults, saying they’re annoying and shouldn’t be in MCC, etc. In fact most of Blue bats got the same treatment as Sniff did for it, especially because it affected a dsmp member. Even on this subreddit, people have said that “this wasn’t toxic, blue in mcc 22 was though”.
An argument that I’ve seen a lot has been “If they didn’t want it to happen, punching wouldn’t be in the game.” In response to that: Punching is expected, yes. It’s part of the game. You’re gonna get hit off the course a couple times. But camping and trying to stop players from stopping is abusing that mechanic of the game. As people have pointed out, it’s a bannable offense in MCCI for a reason (It’s counted as griefing!). It’s also generally expected to play fair and be a good sport, and be respectful and mature about it. It’s like how people don’t cross-team. Because that’s a general rule on any server and in most events. (This isn’t Squidcraft, people! Since I keep seeing that comparison. Squidcraft is an annual event, and MCC is a monthly event in which there is a strong culture of predictions and analyzing statistics). At this point it’s common sense to be a good sport, and to be respectful to other players.
People have also been saying “It’s just a game” and that “it was funny.” Personally I think H had a good quote about it: “it might be funny from his perspective, but it’s painful from everyone else’s." Not everyone is friends with George, not everyone knows him that well, and certainly not everyone knows his humour. A lot of people wouldn’t find it funny if someone they didn’t know pulled a “joke” on them like that. It’s not a joke if it upsets the person who's the butt of the joke. And the fact that multiple people had the same reaction of “that wasn’t cool”, “that was an a-hole move”, or even “that was pretty mean” says a lot. Instead of that coming across as light-hearted or funny, a lot of viewers from certain POVs and even players themselves took it as being rude, or trying to sabotage Aqua from being in second place. (and that would’ve been quite the mess if that had happened.) Of course, some players have been vocal about how what George did was fine, but some players felt upset, and these differing views can coexist. I think it also stems from certain players being more laid back, respectful and good sports when playing MCC, if not in most/all events (twitch rivals being an example of other events). In turn the viewers tend to also reflect that. Some viewerships just aren’t used to that behaviour and having it being shown as a joke, especially with MCC seen as a “for fun” tournament. While coins and placements might not be affected, the viewing experience, morale, and vibes could be. In one MCC, Phil and Grian were spam punching each other at the start of the course. That was funny because they knew each other, knew each others humour and had interacted in the past. It was also at the very start, and not a situation of ‘camping’ the end and targeting the last players left. Grian is also known for being a bit of a prankster on hermitcraft, so that sort of behaviour is normal for him, especially as a joke or to mess around light-heartedly. You can have fun and not be disrespectful or grief.
*The misogyny
As I previously mentioned, this situation has ended up bubbling into a lot of people also being sick and fed up with misogyny. Mainly due to how people have treated False for being annoyed, as well as the community downplaying female players' emotions in the event or using it as a way to say “Look! She’s over-emotional and shouldn’t be in MCC!” and wanting to point out the hypocritical nature of it. And False was not even that upset or bothered. She didn’t even raise her voice. There has been multiple times where a woman in mcc has ended up getting upset, frustrated or stressed on stream and gotten hate for it. Even worse if they cried on stream from anxiety or being overwhelmed. But if a man playing mcc, for example Dream or Sapnap, got upset or angry, their reactions were warranted and valid. They could rant about something and the community would be in an uproar for them.
The sudden switch from supporting a male player for getting angry about something that couldn’t be controlled, or because they just weren’t good at a certain minigame to hating on a female player for getting frustrated at something another player is purposefully doing is ridiculous honestly, and the fact that it is always the women who get hated on for showing any sign of an emotion that isn’t happiness or hype is something we shouldn’t be ignoring in this community.
I think some really good examples of misogyny, whether intentional or not are: - False being the first B2B winner (Mcc9 & Mcc10) and George winning B2B (Mcc11 & Mcc12) and portions of the community (especially on Twitter) treating George or saying outright that George was the first B2B winner. - Niki crying on stream during an Mcc and getting hounded with harassment for months after, didn’t matter who she was teamed with. A lot of people saying she was a crybaby, and that she better not cry on stream around certain teammates (Dream, Tommy, etc) - Jojo being ignored as a consistent top player, and also having her 1st placement this Mcc downplayed. - Women in teams that are mainly Men tend to be ignored or not listened to.
In general, Misogyny and Double standards are rampant in this community, and no one is immune to avoiding it (yes, even women can be misogynistic and have double standards.) This situation is no longer essentially about what George did in Mcc, and as I mentioned at the start of this post, I think it’s very much due to fans feeling done and fed up with it every Mcc. I think the showing of double standards in the community has been the pushing point for a lot of people, as well as the fact that a lot of people seem to think fans on the other side of the situation are angry at George for what he did, when really those fans are angry at the community’s reaction.

I've taken the liberty to update the sub with post flairs, user flairs, and a better ruleset.
The rules may get worked on and improved further over time, but so far there has been a rule break percentage lower than that of the quietest areas of Los Santos, which is good.
If you know of a crew or member breaking any of these rules, please do contact the team via the mod message function and we'll get right to it smiting those pesky modders and what have you.
Notable changes: Crew showcases; you can post videos and pictures of your crew and what you do without it counting as an actual recruitment post. The post cap for those is three per week, resetting every Monday at 00:00 EST (I chose an American timezone, even though I myself am European). The recruitment post cap is still two per week, resetting at the same time.
Modding & Cheating; we will strike down hard on any crews found accepting such filth into their ranks.
Flairs; you now have to flair your posts according to what platform you are recruiting for. And for users, I added flairs to signal whether or not you are in a crew or looking for a crew. So flair up, you filthy casual (it's not a requirement, but I do recommend it) <3
Filter by flairs; you can now filter post types by their flairs over in the sidebar.
Any questions and suggestions may go in this post or to the mod mail. I will read and answer them all.

I have this listbox to pull the information and filter it.
However, I put information from 3 columns starting with column B, and defined that it would pull through the offset the information of a column before and a column after.
It's working... but I'd like to filter the information from column F and that the information from column A and column H also appear in the listbox.
So what I'm looking for is for my listbox to appear as follows:
Code (Column A) City with filter option (Column F) Country (Column H)
I really appreciate anyone who can help me :D

Option Explicit Dim wPlan As Worksheet Private Sub cmdfechar_click() Unload Me End Sub Private Sub listaClientes_Dblclick(ByVal Cancel As MSForms.ReturnBoolean) On Error Resume Next Dim n As Long Dim ncliente As String n = Format(Me.listaClientes.List(listaClientes.ListIndex, 0), "0") ncliente = Me.listaClientes.List(listaClientes.ListIndex, 1) Cadastroclientes.txtcodigo.Value = n Unload Me End Sub Private Sub UserForm_Activate() Call CriaCabecalhoLb(Me.listaClientes, Me.lbCab, Array("Cód.", "Cliente", "Celular")) End Sub Private Sub UserForm_Initialize() Dim rg As Range Dim linf As Integer Dim Cor01 As Variant Dim Cor02 As Variant Dim Cor03 As Variant Dim vLin As Integer Cor01 = RGB(35, 207, 222) 'RGB(253, 6, 100) Cor02 = RGB(43, 46, 51) 'RGB(231, 232, 237) Set wPlan = Planilha1 Set wPlan = Application.Worksheets("Teste1") vLin = Application.WorksheetFunction.CountA(wPlan.Range("B:B")) Set rg = wPlan.Range("B2:B" & vLin) listaClientes.ForeColor = Cor01 txtCliente.ForeColor = Cor01 listaClientes.BackColor = Cor02 For linf = 1 To rg.Rows.Count With Me.listaClientes .ColumnWidths = "60;190;100" .ColumnCount = 3 .AddItem Format(rg.Cells(linf, 0), "00000") .List(listaClientes.ListCount - 1, 1) = rg.Cells(linf, 1) .List(listaClientes.ListCount - 1, 2) = rg.Cells(linf, 2) End With Next Me.Contalbl.Caption = Me.listaClientes.ListCount & " clientes" End Sub Private Sub txtCliente_Change() Dim lstCli As Range Dim vProc As Range Dim vCod As Range Dim vCel As Range Dim vInic As Range Dim vLin As Integer Dim vteste As Range Dim vtest As Range On Error Resume Next Me.listaClientes.Clear If Len(Me.txtCliente) = 0 Then Call UserForm_Initialize lblPesq.Visible = True Else vLin = Application.WorksheetFunction.CountA(wPlan.Range("S:S")) Set lstCli = wPlan.Range("B2:B" & vLin) Set vProc = lstCli.Find(Me.txtCliente, , , xlPart) Set vCod = vProc.Offset(0, -1) 'valores do codigo, mudar a coluna para esquerda (0 = coluna S, 1 = coluna S - 1) Set vCel = vProc.Offset(0, 1) 'valores do celular, mudar a coluna para direita (0 = coluna S, 1 = coluna S + 1) lblPesq.Visible = False If Not vProc Is Nothing Then Set vInic = vProc Do With Me.listaClientes .ColumnWidths = "60;190;100" .ColumnCount = 3 .AddItem Format(vCod, "00000") .List(listaClientes.ListCount - 1, 1) = vProc .List(listaClientes.ListCount - 1, 2) = vCel End With Set vProc = lstCli.FindNext(vProc) Set vCod = vProc.Offset(0, -1) Set vCel = vProc.Offset(0, 1) Loop Until vProc.Address = vInic.Address End If Me.Contalbl.Caption = Me.listaClientes.ListCount & " clientes" End If End Sub Public Sub CriaCabecalhoLb(LbPrincipal As MSForms.ListBox, LbCabecalho As MSForms.ListBox, cabecalho As Variant) With LbCabecalho ' cabecalho do userform 'Iguala o numeros de colunas do ListBox Cabeçalho ao do ListBox Principal .ColumnCount = LbPrincipal.ColumnCount .ColumnWidths = LbPrincipal.ColumnWidths 'Adiciona os elementos dos cabeçalhos .Clear .AddItem Dim i As Integer For i = 0 To UBound(cabecalho) .List(0, i) = cabecalho(i) Next i 'Formata o visual .ZOrder (0) .Font.Size = 9 .Font.Bold = True .SpecialEffect = fmSpecialEffectFlat .BackColor = RGB(35, 207, 222) 'RGB(229, 13, 90) .Height = 13 'Alinha a posição e dimensões do ListBox Cabeçalho ao ListBox Principal .Width = LbPrincipal.Width .Left = LbPrincipal.Left .Top = LbPrincipal.Top - (.Height - 1) End With LbPrincipal.ZOrder (1) End Sub 

​
https://preview.redd.it/7ie08bt97bpa1.jpg?width=810&format=pjpg&auto=webp&s=e821ebcf755a21058aae7370bd9fa6b799508ef2

Little bit of a follow-up to my last submission. First time DM, and we've just finished our first module as of last night. It was originally intended to be a one shot, but that was an underestimation on my part as we didn't even 100% the module and it still took us two sessions, with our second running about an hour over.
It was a lot of fun, to be sure. While I didn't manage to lure the party deeper into my favorite area of the module, I did end up planting the seeds for a potential return.
When we last left off, I allowed my players a short rest and level up in a small, oppressively quiet room that muffled all sound. It was unsettling, but one of the safer rooms of the wizard's tower. They had a short debate about whether they should go back and slay the two enemies they'd previously seen guarding a door. They ultimately decided against this action as the guards were just that - they didn't initiate combat against the PCd and simply stood there, watching and twitching next to each other as the party never approached their door. This allowed them to conserve some resources, but their decision would have consequences.
Instead, our intrepid adventurers continued upward into the tower, dread and apprehension building with every step they take climbing the walls. Upon coming to the next door this dread hit a peak, and due to the ranger's favored enemy and backstory I clued him into the Abyssal nature of whatever was behind that door.
The party began to panic, expecting a demonic monster on the other side of the door. What they found instead was the Abyss itself, stretching off into eternity around them, with only a single door across the black expanse of nothingness. Deep in the darkness, at distances impossible to tell they could see titanic shapes and drifting forms, limbs and bodies and faces, flashing then gone. The ranger felt something calling to him, urging him to come closer through the darkness. At the same time they encountered an odd traveler, utterly inhuman, yet friendly enough. This one similarly encouraged them to travel with it for a time, to abandon the Wizard's tower in favor of safer travels in the infinite darkness. Ultimately the party was too afraid to venture into the Abyss and instead made a mad dash for the other door - much to the Wizard's amusement.
They continued on with trepidation to new sights and horrors. As they set foot on the newest floor they could hear the Wizard's mad laughter, cackling around them in delight. Their path opened to a circular room with an odd, droning shape in the center. An utterly alien shape, comprised of pale blue tendrils that twisted and looped around each other in the air while emitting that low drone. The ranger used his mage hand to poke the floating shape with one of his arrows, and quickly found out that the tendrils reacted violently, smashing the arrow to pieces and partially corroding it. This was all the incentive the party needed to book it to the next door and stumble into the grisly sight of a dismembered man, still speaking and moving, his various body parts reaching for the party while his head babbled madly.
The smell was awful, but the party didn't back down from a few limbs. The sorcerer had the idea to geab the babbling head and drop it into a hole in the floor, plunging the screaming thing into the Abyss to be lost forever. This pleased the wizard, and he granted them a boon. The remaining body parts ceased movement and transformed, turning thick and gummy, and I learned that my players have less moral qualms about what they consume than I would have expected.
With their combat completed, they traveled through pitch black hallways, feeling amall somethings squirm and brush against them in the darkness, sharp and wet. The hallway led to another Abyssal space, a dark expanse with three doors suspended in the darkness, held by strange ropes that stretched up into the blackness, the source unseen. As they attempt to enter a new door the ropes jerked upward, preventing their escape. What followed was a desperate attempt to move through the doorways as they flew around the black expanse, changing exits each time someone crossed through. Eventually they managed to find themselves in the next room, though chattered and bruised from the doorways, the Wizard's cackle fading behind them.
After some exploration my heroes found the Wizard's trophy room and took their pickings from it. The Wizard remembers this. Backtracking through the rooms they realized some gargantuan creature was approaching the tower from the darkness, with only its eyes visible. The sorcerer panicked and made a mad dash to the next room, where the party encountered their next combat as two young Wizardlings assaulted them with their bladed arms and many, many legs. Partway through the fight an unnatural, Abyssal eel pushed its way through the floor and joined the fray. The party was able to dispatch their foes, taking a beating in the process and coming to two more doors. One, marked Exit. The other, plain.
The party got their final short rest and wisely ignored the exit door, venturing directly into the Wizard's lair. They finally came face to face with the creature that had been stalking and toying with them.
He was normal. With a perfectly average amount of limbs. He wore a pointed hat. And as he raised himself up on limbs that were not there, he shifted into the darkness above. His body was out of sight, concealed in magical darkness, leaving only pieces of himself exposed to the attacks of the party.
It was a very difficult fight, with two members being cursed by the Wizard, and all of them barely clinging to life as it threw Wizardlings at them between its own attacks, feasting on them to restore its strength. The druid morphed into a bear for the fight, battering Wizardlings away as the fighter tried to keep his body together while stabbing at whatever he could with his pike. At critical health the party was facing a TPK when the sorcerer was struck down.
In this darkest hour the party couldn't land a hit, everything was missing as the Wizard scurried around the room, skittering in the darkness, bleeding thick globs of blue onto the floor as it prepared for its final strike. One Wizardling remained, full health and eqger to feast. The sorcerer crit succeeded on his death save, standing back up just before the Wizard's next strike and launching a single ray of frost at the Wizard's main body, his sight enhanced by a magical grub to grant him vision through the darkness. It connected, tearing through the unspeakable Wizard and tearing its body apart, putting an end to the terror of the mad creature.
Or not. After leaving the tower and discovering it gone without a trace, the ranger found a simple note in his pocket.
BE SEEING YOU.
Overall I felt the session went well, but it had a few places I wasn't happy with or could've been done better. To me, the section with the flying doors felt like a real low point. Admittedly, I struggled to keep everything straight on this one, and I was worried this part dragged for my party due to the extra time I had to occasionally take to make sure things were right. It didn't help that I opened this with an error and had to quickly backtrack myself and tell them I'd messed up a bit. It didn't change anything major, but it made it messier than necessary. I also almost accidentally gave them a long rest because I misspoke, only catching it because one of my more experienced players double checked to confirm my intention.
I also fear my combat was a little dull at places, so I'll be asking for some feedback on that between sessions. Loot was light from the Wizard, the sorcerer took his hat and the party was rewarded with the 40 gold bounty, but I plan on giving them a little extra when they make it back to a bigger city.
With the module done, next comes the truly hard part of piecing the world together more, bit by bit. I had originally planned this one shot to be a stand-alone, but my players enjoy their characters and the adventure has given some interesting developments, so I'll see what happens. I won't keep spamming the sub with these posts after my sessions, fear not, but I just had to share some of my joy and excitement from this module I've been looking forward to for so long.

With one exception, (where I was traveling) I have hosted the Great Giveaway every Wednesday for what is coming on TWO YEARS!
While true: I'm easily excitable, the GG does it for me every time! I get excited! Some come to chill, others come to win. Hell, I'm sure some come just to say they came! I'm pleased to say people just keep coming and coming!
There It Is! Soak It In! That's This Week's GG! ...Well This 1BILLION CREDITS, & TWO 60-DAY SUBS TO SWTOR!
TO ENTER you do NOT have to sub! You do NOT have to follow! You do NOT have to like me! Just say the magic words when they come up to qualify! THAT'S IT!
TO RECIEVE credits and in-game goods we pass out winnings on Satele Shan! If you don't have a toon on that server, WHAT ARE YOU WAITING FOR!? JOIN US! To use/receive the subscription code(s)/Opal Code you can be on ANY SERVER! A-N-Y SERVER! I give you the code, and you enter it! ** POOF ** Magic!
TL;DR: I organize, and MC the largest giveaway SWTOR has to offer EVERY WEEK! This week with over 100 winners!
You want in?! Get it! I'll see you & the Clean-Up-Crew TONIGHT at 8:00 PM PDT right HERE!
GL & GG!!

First Prev
Patreon Series wiki Official subreddit Discord
---
Memory transcription subject: Chief Hunter Isif, Arxur Dominion Sector Fleet
Date [standardized human time]: December 6, 2136
The Prophet-Descendant had grown irritated, as Shaza’s spectacle dragged on at Sillis. The female Chief Hunter had failed to mop up the human remnants; she had sacrificed her entire sector, and not even taken the planet she lost her assets to capture. So when Giznel summoned me to a physical location, I figured it was for my input on that debacle. What else could be too sensitive to discuss on comms?
Before I returned to my duties, I parsed through Jones’ tooth drive. The human general had included instructions on how to search for bugs. I turned my shuttle upside-down before retrieving my secret holopad. My defective side compelled me to answer Felra, who had been persistent in checking in on me.
We ended up chatting for hours. The Dossur discussed her favorite celebrities, her days training to be a ship inspector, and how the war affected her, among other topics. Felra was unfazed by my non-answers; if anything, it seemed to encourage her nosiness. The prospect of discussing my life made me feel fraudulent and exposed. How could I ever explain anything genuine about myself?
By the way, I’m the Arxur Chief Hunter responsible for the deaths of millions. Don’t mind that.
The Dossur sent a request for a video chat, and that paralyzed me in my seat. Just when I’d begun to ease my guard, there was the reminder that friendship was impossible. I told her that I was on the way to meet my boss, which I suppose was true. Felra (damn her) pleaded that a few minutes would make her day.
Why wasn’t I able to refuse that request? It took me a few seconds to set my video to off, and apply a voice modulator filter to my audio. This was all going to come to an end, when she asked why I’d switched off my camera and disguised my voice. There was no prey-like explanation to that effect.
“Siffy! Oh…” A young Dossur with ginger-and-white fur blinked onto my screen. “Where’s your video? You can’t be that ugly, man; I showed my face.”
I drew a shuddering breath. “Felra…I don’t know how to say this.”
“Robotic voice. Okay, not gonna lie, this is creepy. Are you actively hiding everything about yourself, or trying to be weird?”
“It’s better if the camera is off, and if you don’t hear my real voice. I’m a predator.”
Felra was silent for a long moment, mulling over my confession. I could see the gears spinning in her beady eyes, before her nostrils twitched with surprise. The Dossur proceeded to express relief, followed by a bout of laughter. She gave me an encouraging ear flick, which wasn’t the reaction I was expecting.
“You’re a human!” she exclaimed. “That explains everything; why you’re so closed off and peculiar. Uh, no offense. I wondered what you all were like.”
I recoiled in my pilot’s seat, hissing in disbelief. That was not the interpretation I intended for her to take, but I suppose it was a good cover. Perhaps that would lend an excuse for my social ineptitude, though it was unfair to the Terrans’ reputation. Humans were more than capable of chatting it up, and mimicking emotions in appropriate ways.
Felra is definitely going to have the wrong impression of humans. If she talked to one of them, she’d never have suspected a thing.
I decided not to confirm or deny her assertion. “What do you think of humans?”
“Well, I think if you’d befriend a species like the Dossur, you can’t be all bad. Even the Arxur recognize that we’re shitty cattle,” she answered. “Oh, and I think it was shit that the Krakotl attacked your homeworld. I can see why you have some walls up talking with an alien…just saying, wasn’t us.”
“Wait, so you’re not bothered by me being a predator? I’m not anything like an average human, to be frank. My emotions deviate far from a Terran baseline.”
“You told me you deserved to be alone, and I’ll assume it was because of that. I’m sorry that your culture made you feel that way. If you feel safe reaching out to me, I’m honored.”
“I…I see. And the Federation? What do you think of them?”
“I understand the whole cultural tampering, and that I should feel hatred…but honestly? We would’ve never industrialized without their uplift. How would we build great machines from scratch? Even walking…we use carts to traverse alien cities.”
I guffawed in spite of myself, picturing this creature perched on a motorized stand. Felra made a valid point about the Dossur’s debt to the Federation. Had those meddlers not noticed the native wildlife bore signs of sapience, Mileau would be a different planet today. In their particular case, outside intervention was necessary to facilitate their advancement.
Felra flashed her tiny front teeth. “Don’t laugh at me! Let me guess; humanity will look down on us for our size?”
“Ah, I cannot speak for Earth,” I growled awkwardly. “My assessment is that many Terrans will want to pick you up or pet you. Humans think small animals are…cute.”
“But you don’t?”
“I don’t debase myself by infantilizing creatures! It’s not something I’ve given active thought to.”
“Testy, are we?”
“I am insulted by the premise! As if I could find an alien cute, and do that whole fawning expression and baby voice.”
“I wouldn’t mind. I bet you could do it well. Please, show me this baby voice? No filter?”
“GRRR! Very few herbivores try to rile up a predator!”
“Well, I’m a special gal, Siffy. You’re sure funny when you’re fired up.”
“I am tired of this conversation! I said I was only speaking for a little bit, and I don’t want to hear from you for a few hours!”
I hung up with a huff, refocusing on the landing protocols. Despite my best attempts to scare Felra off, I’d only seemed to invite provocation. With such important tasks ahead, I needed to quash whatever of my defective side had arisen. Prophet-Descendant Giznel was hosting our meeting in an unmanned station, and he had just confirmed my docking request.
Focusing on neutralizing my expression, I steeled myself for Betterment’s unavoidable demands. My shuttle coasted down at a leisurely pace; the time to clear my thoughts was welcome. If Giznel ever learned that I was befriending prey from my sector, he’d see that my head was removed from my shoulders. There could only be my fanatic persona among my people.
Imagine how much better life would be, if I were a human. I wouldn’t have all this…baggage to my name.
The shuttle slotted into the docking clamps, and I heaved a weary sigh. At least my disdain for Shaza didn’t require acting. If I could persuade Giznel to withdraw from Sillis, that would take a weight off the UN’s back. There was also valuable information I could attain for General Jones; it was my role to keep Earth apprised of threats.
Giznel was without his normal guards, and I contemplated whether I could get away with killing him. Betterment likely knew who he was meeting with today; he’d be replaced by a Descendant not as partial to me. Assassination was a surefire way to blow my cover. I disembarked, dipping my head with respect.
“Isif. We are alone here,” Giznel hissed. “I have important matters to discuss, free of lesser ears.”
I narrowed my eyes. “Hallowed Prophet—”
“Drop the Venlilshit. I know everything.”
The Dominion leader’s proclamation chilled my bones, and the debate of whether to strike him down renewed in my mind. Giznel said on the call that he doubted my loyalty; he didn’t believe I was willing to clash with the Terrans. Perhaps General Jones had been right about me tipping my true allegiance off to Betterment. Was this the moment where I’d be executed for my defectiveness?
“I don’t know what you mean, Your Savageness,” I growled evenly.
Giznel bared his teeth. “I think you do. I wondered why you coddle the humans, and I knew it was more than Shaza’s report stated. You imitate them and chase after them at every turn. But now I get it; you think they’re smarter than us.”
“I beg your pardon?”
“You heard me. I couldn’t make sense of it, until I replayed our conversation during the prisoner execution. You talked about ‘maximizing our resources’ and obtaining entire planets as our catch.”
“I did, but I don’t see…”
“You think the humans can solve all our problems. You think they’re smarter, and they hunt in the optimal way. Those Zurulian ‘pets’ you took were given to the Terrans to earn goodwill. Tell me I’m wrong, Isif.”
“No, I suppose you’re not. Perhaps this is treasonous, but we could do better. The humans can feed us, and I could make it happen.”
“There’s the truth. Then, we can conquer the Federation and go on our merry way, yes?”
“Stronger. Capable.”
Fear surged in my veins, but I met Giznel’s stare with feigned impassivity. The Prophet-Descendant was off on the extent of my motives, though he’d discerned some of the truth. Questioning Betterment was the highest form of treason; I had just admitted that I didn’t think the Arxur way was the superior one. My champions were empathetic, leaf-licking predators. Why hadn’t he signed me up for execution?
“You’re right that humans could alleviate our food shortages. But you’re wrong about it making the Dominion stronger,” Giznel said.
What? That wasn’t what he was supposed to say.
The Prophet-Descendant heaved a sigh. “If we get fat and lazy, Isif, we will be susceptible to future attacks. You don’t appreciate what you don’t have to struggle for.”
“With respect…the humans are a strong culture, and they’re well-fed. A warrior culture.”
“The humans have weak individuals, because they have a cushion to provide for them. What happens to Betterment when the food problem is resolved? How do we keep the masses on the right path?”
“Cruel One, are you saying that you want our people to starve?”
“Precisely. It keeps them dependent on us, and hating the Federation. The prey aren’t fully to blame for our woes, but the masses don’t need to know that.”
“You mean because we don’t try to solve the food problem.”
“No. Isif, the Prophets and our inner circle have kept this secret close to the vest. Never mention what I’m about to tell you to anyone, yes?”
It was difficult to process this rhetoric, but I tilted my head to show I was listening. The Federation had admitted their culpability, when Nikonus discussed the meat-allergy serum. Was Giznel implying that Betterment was complicit in the cure’s spread? That was not a logical conclusion, since the volunteers weren’t weeded through as a culling of the weak.
“My silence can be counted on, Your Savageness. I am honored,” I managed.
Giznel lashed his tail against the floor. “Very well. The Federation was fully responsible for the cure, which caused many Arxur to starve. The Northwest Bloc, under the Prophet’s guidance, seized the moment to weaken the Morvim Charter.”
“I…how so?”
“The cattle virus was unleashed on the Charter’s livestock by us. The ‘cure’ was the perfect cover; we could blame it on the aliens, and not break the truce. But it spread across our borders, somehow. We lost our food to our own bioweapon.”
“It wasn’t all the Kolshians. So billions of Arxur starved, because of rivalries from the world war?”
“Yes, and it was a blessing in disguise. It helped Betterment solidify control. It made the entirety of Wriss see things our way!”
My maw hung agape, as I fitted this new information into my past knowledge. That explained why Chief Nikonus had denied the cattle allegations during Cilany’s interview; the Kolshians had no part in slaughtering livestock with pathogens. The herbivores deserved our hatred, but the worst blow to Arxur civilization was self-inflicted. That entirely altered my perspective of why we were starving.
It could have just been a few hundred thousand volunteers killed by the cure. Instead…my entire race has been reduced to animals.
I was livid at the Betterment office for perpetrating such falsehoods. There were so many factions that could use this information; General Jones needed this on her desk promptly. The Arxur rebels, who were searching for fuel to resist Betterment, could gain support too. Even non-defective citizens would seek consequences against those responsible for starvation.
This revelation could destabilize the Dominion’s grasp on society, just as Cilany had crippled the Federation. Unfortunately, Giznel wasn’t stupid enough to blab about this to a reporter. I was his lone confidant, and I had no proof that such claims weren’t Terran propaganda. Betterment could dismiss me as a human sympathizer, if I spoke out to my peers.
“So you see, we need to maintain the balance of power, Isif. If there was a surplus of food, that would spell the end for us,” Giznel concluded. “I need you to limit your trade and…infatuation with the humans.”
I forced a neutral expression. “Of course. I would not wish to weaken Betterment. You needed only to say as much.”
“Good. As for ending the war…the Federation doesn’t want the war to end any more than we do. The Kolshians and the Farsul couldn’t maintain control over such a large herd without an enemy.”
“They hate us! They wish we didn’t exist.”
“Oh, of course they do. But there’s a reason they teach other prey to run away and never attack. If we pressed the Federation core worlds, I have a hunch they could muster up their numbers all of a sudden.”
Giznel’s theory made gruesome sense, the longer I contemplated it. It explained why the Kolshians mounted a bold-faced offensive on Terran allies, but never went after Dominion worlds and outposts. The United Nations wasn’t content to raid a few planets and call it a day; nor did they plot a forever war for control. The humans sought peace and reconciliation, and that made them an immediate threat.
Zhao wants to destroy the Federation. Add in exposing the truth about omnivores…humans set that in motion.
“That theory holds water.” I blinked my eyes, and my thoughts drifted to Felra. The Dossur were at risk of attack just for siding with the humans. “Our cruelty helps the ringleaders keep the other prey afraid.”
Giznel chuckled to himself. “I knew you would get it, Isif. You’re more cunning than Shaza, so I’m asking you for a favor. Do you still think you can handle humans?”
“Of course I do. I’m not the Chief Hunter that lost my sector to them.”
“Then handle this fucking mess. I want the battle of Sillis ended at once, with as many assets recovered as possible. If you think you can talk the monkeys into a truce, do it.”
“Easy enough. It’s not my sector though. What do I do about Shaza’s forces?”
“Those are your forces now. I’m putting her sector under your control, effective immediately. While you’re getting a handle on the situation…dispose of Shaza.”
“It will be handled, Cruel One. I will summon my fleet and leave for Sillis at once.”
The Prophet-Descendant watched with calculating eyes, as I clambered back into my shuttle. The advice that endangered my cover had earned me greater power today. In retrospect, negotiating with the humans was the less humiliating option. There was a lot to unpack from the Dominion’s secrets, but my first order of business was eliminating Shaza.
Getting the United Nations to cease hostilities would be the most difficult part. However, a continuing battle was not beneficial to Earth’s cause. Humans were a spiteful bunch, but I’d try my best to find a diplomatic resolution.
---
First Prev
Patreon Venlil Foster Program (Finished This Week!) Series wiki Official subreddit Discord

Are you a fan of Austrian firearms?
Do you know of the famous Herr Mannlicher?
Is Die Hard your favorite movie?
Then fear not, for that thou shall be the Stryker!
Okay. Believe it or not guys, I was hoping to get to this gun sooner than later. And since I hit 300 karma with the last post (I appreciate all of you guys, I'm glad I could entertain you ^^), consider this as a celebration, yeah?
Awright. Time to talk about the sexy rifle. Looks, behavior, and some trivia.
K1 Stryker, in other words, Armee Universale Gewehr, has a rather interesting in game history if you ask me.
At first, PikPok tried to pair it with the X-12 Tyrant, as if they knew that those two would be the most OP combo in the whole entire game. When I say "paired", I meant that when this gun was introduced with its premiere event, they made the X-12 Tyrant the only gun with a 2x multiplier. I'm not kidding, no other weapons had a multiplier. Only the AUG and the DP-12. I used to play Outbreak back then, and I struggled very very hard to be able to get just enough parts to build it because of that.
Then in came the Legacy event (a very solid event, however a short one) and for some reason PikPok decided that the timid idiot that is our protagonist should have the AUG as her primary weapon.
Yes, I call her a timid idiot because she blames herself for literally everything and she pays no mind to her surroundings. She doesn't even consider amputating her arm to get rid of the infection, nuh-uh. She instead considers running around like a headless chicken hoping to find someone who wants to raise a kid so that the baby won't have to die with her. Tragic, but also idiotic.
Anyway, short sub-rant over, moving on. Gots to talk about them sexy curves of this beast.
The gun's in-game rendition is a very faithful representation of the Sturmgewehr 77 (that was the designation by the Austrian military for the Steyr AUG A1, folks) and I love it. I myself am more of an A3 guy but A1's iconic carry handle scope, overall slim and hot looks and simple controls win the day either way.
Quick side note: The gun was made in 1977 and adopted by the Austrians. Glock 17, is also adopted by Austrians. I see a pattern here, involving very solid guns and Austrians. Anyway.
The animations, I really dig. The reload, the H&K slap on the charging handle (even though it is not that easy to slap AUG's charging handle in real life), the end-game animation where we fold the foregrip or check our magazine, they're all very solid. I love it. I. Love. It.
The gunshots out of this beast is straight up from CS:GO's SFX archive. I'm not kidding guys, take a look at both games' SFX for AUG firing. Now, that's not a bad thing.
BECAUSE IT SOUNDS SO SHARP AND SOLID. It feels like a sniper rifle every time you use it. A very mechanical sort of "bang!" and there goes a guy down.
I have no words that can truly do justice to how sharp and clean the gunshot is out of this thing. It feels so satisfying to pull the trigger, hear that sound along with a zombie just bleeding on the ground. I LOVE IT. This gun is up there with the Cobalt in terms of mechanicality of the gunshot.
However, there is one significant issue to this gun, and it is something I can waive.
They incorporated a mode selector. Not visually, but gameplay-wise it exists.
The problem is, guys, AUG is a progressive trigger rifle. That is, you pull the trigger really long and hard for full auto, and rather short for semi auto. It has two separate breaking points. That causes a lot of complaints in the firearms community, as it results in a very mushy trigger, but there are aftermarket kits that can get the AUG to a very clean trigger pull, so eh.
But what this also means is that the AUG shouldn't have any mode selectors. The mode selector is your trigger finger, you consciously pull hard for full auto, you tap for semi auto.
But instead, we have a mode selector on this baby.
I will ignore that and count it as a positive thing for the rifle. And I can hear you all screaming at me for being a biased piece of shit, but let me explain.
As I said before, this selector isn't visually there. They didn't butcher the gun to make this happen. Which is very good and removes a big chunk of the problem.
And, this mode selector isn't for the gun. It's for James. The mode selector literally decides how hard James pulls the trigger. Just like any of us would behind a progressive trigger gun. When semi-auto, he lightly pulls the trigger. When full-auto, he yanks the trigger.
So I'm fine with it, and THANK YOU LORD PIKPOK FOR ATTENTION TO DETAIL. I love you guys for not adding some abomination to the gun to make this work.
Anyway. There is a decoration for this gun, which is of Legendary quality. And it gives...drumroll...built-in Crate Ammo. Sadly it was available during last Christmas via a login event, however that doesn't make it any less awesome.
Personally, I don't like the colors of the decoration. The snow effect on the gun and the freeze effect on targets are very cool, but the color scheme is just way too off for my taste. And that comes out of a person who appreciates graffitis. At least it isn't intolerable I guess.
Overall, this gun is goated with the taitonaito sauce. It is my favorite rifle, and favorite firearm. I will always girl over it, and cherish it. Regardless of what the in-game stats say.
Now that we mentioned everything that is skin deep about this beast, let's talk numbers. I one-upped this rifle so far many times, right? This must be the best thing in the ItD2 world!
Okay. So the AUG is capable of 19,200hp damage per shot on maxout, with a fire rate of 600 in-game units for semi-auto. The full auto fire rate doesn't show, but it is fast enough to give a lot of SMGs run for their money, so it is decent quick.
Although you may wanna stick to semi-auto, why that in a minute.
The reload speed is an astonishing 500 in-game units (so far the lead of the pack for assault rifles), and the magazines hold 32 rounds.
Now, I have a bit of a peeve about that magazine capacity. You see, the Austrian standards for AUG magazines are 30 and 42 rounds. But there is an SMG version of the AUG that has 32 round magazines. What pisses me off is that they could have just gone with the 30 or 42, but they ruined it with the wrong magazine capacity. I don't get why.
Well anyway, the rifle has built-in Piercing Ammo (basically a way faster Javelin) and the Piercing Ammo kicks in when the rifle is on semi auto (way more ammo friendly than Shadow). On full auto, the rifle acts like a rifle, just on a lot of Redbull cans.
Okay then. That, I believe, makes the stats for me. Now, the verdict.
Verdict: THE BEST ASSAULT RIFLE IN THE GAME. PERIOD. NO QUESTIONS ASKED. ABSOLUTELY BUILD.
There are a few things that makes this rifle potentially the second best weapon in the game, if not the best.
​

1. Built-in Piercing Ammo with a very spammable fire rate. This rifle is basically Cobalt on Bonfire Night. Sure it cannot one-tap a Lumberjack, but a double-tap shouldn't be that much of a pain in the ass at the rate of fire it spews out.
2. (If you have the skin) Built-in Crate Ammo. Guns like this usually suffer from only one drawback: poor ammo pool. Now, while regular AUG ammo pool isn't terrible, it's mediocre, and this skin just makes it even better. The rifle becomes perfection.
3. It is a side story weapon, which means you are guaranteed the parts rather than hoping for a rerun. You can always wait for the Legacy event and crank out 100 parts for your AUG.

​
Now, some of y'all may be considering Shadow as the major contender. But keep in mind, Shadow has its Piercing Ammo on burst mode. That means you spend 200% more ammunition per trigger pull when trying to use Piercing Ammo, for very underwhelming gains, considering that shooting three rounds out of a semi-auto AUG isn't terribly slow.
Besides, Shadow doesn't get to have 2 built-in perks at the same time now, does it?
Well anyway. Now that the verdict has been made, let's go for tactics.
Before we begin, use Puma with this rifle for the best of results. You will want a lot of hordes to break, oh yes you WILL.
​

1. Stick to semi-auto as often as possible, as that is this rifle's ace. Since the fire rate is very spammable, you can break an entire horde by just spam tapping the semi-auto. While full auto is still a good and solid option, it doesn't give Piercing Ammo, draining your multikill capabilities to a good ol' nought.
2. Try to use this rifle wherever possible. Consider it as a Swiss Army knife, as it can do pretty much anything: hordebreaking, survival, (if your reflexes are good) cornfield surfing, the works. And with the skin on, you'll be getting a military worth of ammo. May as well burn it on some extra zombies.
3. Try tapping in the packs of 2 when you see a small-to-medium horde in the distance and you cannot confirm if there is a Lumberjack (ONLY IN APOCALYPSE). The gun cannot double tap a Lumberjack, and there is a possibility that you may just end up getting grabbed by a Lumberjack you hit only once. Go 2-2-2-2-2-2-2-....
4. If you see a big crowd, and you confirm that there are Lumberjacks, forget advice 3 and just spray the area. You'll eventually end up killing all of the zombies.

​
And here are the perks.
​

1. Explosive Ammo: What is better than a crazy powerful assault rifle with M855A1 green tips and a lot of ammo? The answer is a crazy powerful assault rifle with explosive green tips and a lot of ammo! With this, you're basically untouchable!
2. Faster Reload: I added this not because the gun needs it, but it's pretty much the only other perk that amounts to some sense (apart from Incendiary, I'll explain why in a bit). It's already reloading pretty quick. However, why refuse another dollar even if you have a million dollars?
3. Incendiary Ammo: I normally wouldn't recommend this, but there are 2 crucial reasons why it would actually make sense to a degree.
   1. AUG without Incendiary Ammo cannot one-tap a Lumberjack (neither can any assault rifle for that matter). Adding that little bit of damage boost we need can prevent dying to an unexpectedly alive Lumberjack.
   2. (If you have the skin) This gun's Incendiary effect on target is very very pretty. I highly recommend to check it out at least once. I love it.

​
Thanks for suggesting this, folks! A review about a rifle I love a lot. I quite much enjoyed talking about it ^^

Hallo my lovelies! Paulie, your friendly, neighborhood, British Expat, Princess-Bride loving, hat-wearing, tea-drinking, TTRPG-gaming mod here.
Reddit recently launched an "Insights" function for mods that tell us all about how well our community is doing, activities of mods, etc. For those of you interested in the "meta" of how this place runs, here are some of the stats.

Community Growth and Views

• We have around half a million pageviews of our content a month, about 125,000 views a week. Over the last year, we achieved almost five million views!
• We have between 4,500 and 5,500 visitors here each day. Our highest month for visits was January - probably writers looking to start a new career in a new year. Welcome!
• People visit by various means - most to least popular are: New Reddit (web), iOS, Mobile Web, Android, Old Reddit.
• Just over 500 people subscribe to this sub per week, and around 130 people unsubscribe (we still love you!)
• Projecting out, that means we can expect member counts to grow by around 20,000 people a year.
• We're in the "Top 1%" of subreddits, ranked by size. this means we're in the top 1,500 subreddits on the site. myog malelifestyle and stocktips are just ahead of us. actionfigures and ferrets are nipping at our heels. (You should definitely visit ferrets if only for lots of photos of the cute critters!)

Team Health (Moderators)

Alright, here's what myself, u/gigmistress and u/danielmattiawriter get up to!
We receive around 700 modmail messages a year, and send around 1,200 a year (the disparity is because we often hold discussions among ourselves in modmail).
In terms of mod activities, it turns out I am the laziest mod! (hangs head in shame), whereas u/gigmistress is our busiest, and u/danielmattiawriter is in the middle. Here's how many actions we each took over the last year:

• u/GigMistress: 3,700 actions taken in total: 65 content approvals, 179 content removals, 3,300 content creation (posts, comments), 126 modmails, 29 other mod actions (bans, mutes, mod notes, etc.)
• u/DanielMattiaWriter: 3,200 actions taken in total: 223 content approvals, 590 content removals, 1,600 content creation (posts, comments), 340 modmails, 394 other mod actions (bans, mutes, mod notes, etc.)
• Paulie the slacker: 2,700 actions taken in total: 254 content approvals, 415 content removals,1,600 content creation (posts, comments), 238 modmails, 141 other mod actions (bans, mutes, mod notes, etc.)

This means that in total the mods take almost 10,000 actions a year for the community. This includes approving just over 500 posts and removing around 1,200 posts or comments. This is in addition to posts / comments that are auto-removed by AutoMod for breaking our rules.

Community Health

Our community members successfully publish around 300 posts a month, about 10 a day. Our members comment just over 4,000 times a month, and we have about five posts and 12 comments reported every month.
Post approvals and removals
It might surprise you to know that almost half of all posts submitted are removed by us or (in the vast majority of cases) our automoderator for breaking our rules. In the last year, 2,700 posts were successfully published, while 2,400 posts were removed. Members are welcome to appeal any removed posts to us, and if they meet our rules, we will approve them.
Comment approvals and removals
The vast majority of comments are not autoremoved. In the last 12 months, we had more than 40,000 comments published, and fewer than 3,000 are removed.
​
Alright, I think that's it! Feel free to comment on any of this stuff and we'll share our thoughts. After all, it's not like I am doing anything else ;)

Looking for someone experienced in not just moderation but also the themes of this community. Hoping to get some help with finishing the old.reddit version's stylesheet as well as future projects n shit.

• Must have an account age of at least 1 year
• At least 500 karma in both post and comment (Awarder and awardee karma don't count)
• Prefer someone knowledgeable in CSS and Python
• Knowledgeable in foss, cryptocurrency, privacy etc
• As a mod of the sub you will be required to either upload your current or generate a public PGP encryption key to the dedicated wiki section. If you don't have one or any idea about no worries

Please either send me a message via PM NOT chat
HiddenWeb

Didn’t get any feedback on the other sub I posted to, so posting here in the chance someone has experience with this: I have a general idea based on different website’s estimates but just want to hear from real people. I’m doing mixed arrangements, probably some roses, carnations, greenery, etc.
Here’s what I’m estimating:
6 bridesmaid bouquets (20 stems/bouquet)- 120 stems
Bridal bouquet- 30 stems
6 medium centerpieces (20 stem/centerpiece)- 120 stems
6 tall arrangements (40 stems/arrangement)- 240 stems
Total stem count- 510 stems
This seems like a lot and isn’t including extra I may need to cover for any flowers that arrive dead/can’t be used. Thoughts?

Alright, so i am trying to output the job_id and average salary (main query) for the job id’s i found in the job_history table (through my intended sub query). Problem is nothing i have tried is working, i tried WHERE and HAVING.
Both queries give me the result i want independently but not together. What can i do? Here is what i have come up with.
First part:

SELECT employees.job_id, AVG(employees.salary) FROM HR.employees, HR.job_history WHERE employees.job_id = job_history.job_id GROUP BY employees.job_id ; 

My sub query:

SELECT job_id FROM HR.job_history GROUP BY job_id ORDER BY COUNT(*) DESC FETCH FIRST 2 ROWS ONLY; 

For those that are interested in the gray area of online money making, I have decided to create a small tutorial on how to make some money with free movie streaming sites
Another reason for this post is that I've been seeing posts asking for ways that one can make money online with a limited budget and i thought that this would be a useful resource for such people.
I went ahead to create a landing page and a movie streaming leech site that essentially allows for free movie streaming. You can edit the CSS and HTML to add ads, content lockers, offer walls, donation pages etc as you see fit.
Since the site is hot linking to other websites with the content, I think no laws are being broken here.
A portfolio of free movie streaming niche sites that haven’t been up for a long time has been making $400 to $4000 a month. This can be more if marketing was more aggressive.
I have provided the complete source code for the movie sites on the links below if you want to try your hand at it.
If you are non technical and need a hand at hosting the site (node JS and MongoDB for the back-end, bootstrap for the UI ), you can always DM me and I can set it up for you.
So here we go:
There’s a certain user who is making an average of $500 a month with a few niche sites. He is monetizing it with a single popup over a 24 hour period meaning that the daily income could be much higher if he was more aggressive with ad serving. There’s also no mention of up-selling using email meaning that the income from the streaming sites would even go to $x,xxx per day if he exploited them to the max.
Here’s an attached screenshot of income from streaming sites HERE
why you should consider creating a few niche movie streaming sites

1. ppl like movies and they like free things. All it takes is a single tweet or mention to go viral
2. very little investment is needed. The scripts in the links below cost around $20 for a fully functional site
3. high likelihood of making money

why you maybe shouldn’t make movie streaming sites

1. You might have to deal with the legality of said sites in your country
2. hosting can be expensive if your site starts getting traction or if you decide to self host content
3. getting an affiliate network that works for your kind of traffic might be tricky, although not impossible.
4. There’s a lot of competition in the space meaning that you have to niche down e.g maybe make a site for a certain type of scifi movie

What you need to build the site

1. a domain – from what I’ve seen, you should choose from one of the following TLDs: .com, .site, .to, .today, .ru, .it, .pw, .ac, .ws . It seems that these are harder to be taken down than others but you are free to experiment with others
   
2. a hosting provider: you should use an offshore bulletproof hosting provider just to be safe.
   
3. a website/ script: you can either code one yourself or buy a starter kit. If you want a kit, there’s one in the links section below
   
4. something to sell: this can be anything e.g en eBook, an online course, an affiliate product etc. I personally have sold a lot of self published KDP ebooks. Also I have found some success with the CPAgrip affiliate network. What I did is change the script around and put some movies behind an offer wall.
   
5. A themoviedb.org API key: This free API key is gotten on the API section of the aforementioned site. The streaming site provider uses this free API to list movie details. You can set up a free account here
   

A word about the provided starter kit
The starter kit in the links below is a fully functional movie streaming website and landing page combo.
The landing page is made with normal CSS and HTML so uploading it to a static hosting provider should be straightforward.
The actual streaming site is a NodeJS, ExpressJS app hooked up to a MongoDB database. The site is hot linking to a third party hosting site for simplicity and also to solve the legal dilemma of hosting such content.
The MongoDB database code is ready to do but the code that connects to it is commented out because you need a unique connection string to connect to it. The site can still work without the db connection since it’s being used to collect emails and user data. You can always DM me to set up a custom db for you if you so need to.
I hosted the landing page and the steaming site on Vercel and Render respectively and it was fairly easy to do. There are many YouTube videos that explain in better detail how to do this.
As always, if you have any questions on how to host the sites, you can always DM me for clarifications.
The following are the live versions of the starter kit templates being offered:
landing page – here
streaming site - here
The easiest way is to use a CI solution with GitHub to the hosting platform. This set up process varies from platform to platform and there’s no need to go into the details in this non technical tutorial
getting traffic
I used the 3 major things to get traffic. They include:

1. SEO
2. influencer marketing on TikTok
3. YouTuber traffic

SEO
The only SEO I did was in the web pages. I made sure I used proper words in the websites without coming off as spammy. There was no off-page SEO because I was opting to go with word of mouth as the main traffic source.
YouTube Traffic
I used a website called channel crawler (just google it). It has a free tier that gives a list of YouTube channels based on, among other things, niche and YouTube subscriber count.
I figured that I should go for smaller YouTubers since the larger ones tend to already have monetized their channels with all sorts of things (membership sites, affiliate links etc). I decided to go for niche channels with under 50k subs that didn't have much of a monetization strategy.
After getting a list of YouTubers, the email extraction was repetitive and time consuming. I'd go to the channel, go to the about page and reveal the email. After doing this a number of times, YT would ask me to solve a capta. I wanted to write a bot to automate this but I decided to first do it manually to see if the idea would pan out.
Now, I noticed that YT only allows you to get about 10 emails every 24 hours. How I went around this was by creating another channel. A new channel on the same account meant a new profile that I could extract around 10 more emails. YT allows around around 50 (or is it 75) channels for a single account. So that means one can extract >500 emails per day with one email account (very tedious by hand, a python script would have made this much easier)
I extracted around around 1200 emails with this method and put them in an excel sheet.
Next came the cold emailing.
I made sure that the email copy had the following characteristics:

1. short, about 100 to 200 words
2. got straight to the point (no fluff words like ‘how is your day’)
3. had a clear call to action. In this case, I wanted a video review and a link on the description

I should also add that I used gmail to send out the emails. I don't think the emails were going to spam because I wasn't send too many from one account. around 40 per email account.
TikTok traffic
I basically opened an account and started following and cold messaging small TikTok creators until some decided to review the extension.
While I got some leads here, most of the traffic has come from the previous 2 traffic sources.
resources needed:
Here are the links to the resources you’ll need if you want to try this method for yourself
required:
movie streaming site starter kit (paid, very little for a fully working site)– here
movie streaming site starter kit (free but content locked) - here
movie list API key (free) - here
optional
MongoDB connection string (free) - here

Introduction
Before I started chrome extension development, I had looked around various sites to see if browser extension development was viable income stream but all I found were discouraging comments about how people had thousands, tens of thousands of users but no viable income.
Fortunately, I had enough interest in programming and chrome extension development to give it a shot.
I am glad I did.
A chrome extension with a few hundred users has been making around $500 per month on average.
Aside from the initial coding and a few hours fixing bugs and responding to customer issues, the app runs automatically without much of a back-end to speak of.
I decided to write a post explaining how to create the chrome extension, how to upload upload and market it.
requirements
You need a chrome developer account. It costs $5 for lifetime access and you’ll be able to upload 20 different extensions. Google allows you to open an unlimited number of such developer accounts. Alternatively, you can upload the extension to the edge extension store which for now is free.
You can read through the tutorial to understand the details or

1. you can just get the source code,
2. modify it as I have mention in the tutorial
3. upload it to your developer account
4. start developing another income source.

Creating the extension
A chrome extension consists of the following major parts:

1. the manifest.json file
2. the background JS file (or files)
3. the content script JS file (or files)
4. the popup page
5. the options page

The manifest file is essentially a ledger that shows which scripts are allowed to run
the background script is where most of the extension’s functionalities reside. For the source code provided, you don’t need to add or modify any functionality
the content scripts are activated and executed on web pages. You can choose which content scripts get executed in which web pages using the permissions attribute.
the popup is a small web page that’s rendered when you click the icon on the browser menu. It therefore consists of a HTML file, a CSS file and a JS file
the options page is also web page that’s rendered when you go to the options of the installed extension. It also consists of a HTML file, a CSS file and a JS file
Since this is not a coding tutorial but more for a non technical person to upload a chrome extension, I’ll just mention the things you’ll want to change in the source code I give if you want to try this method out.
If readers are interested, I can follow up this tutorial with an I depth article where I jump into the code and the choices that were made therein.
Things to modify
If you are going to use the source code provided in the links, the things you should modify to customize your extension include:

1. name in the manifest.json file
2. description in the manifest.json file
3. author value in the manifest.json file
4. version number in the manifest file although this isn’t necessary
5. icons. Keep the names identical to the original ones or if you choose different names, change the names in the manifest file.
6. donate link in the popup JS file. Change the PayPal link on line 38 to your own link

extension submission
As I mentioned above, you’ll need a google web store developer account. You’ll pay a one time free of $5 and be able to publish around 20 extensions.
You’ll need a description for the extension. The following is the description I used. You can rewrite it so that google doesn’t flag your version as duplicate content.
clone a webpage by downloading all links as files
Easily download several links from a website.
Easily download a large number of links from a website.
Do you want to download a large number of PDFs, podcasts, or other items from a website without having to right-click and select "Save As" for each one? Batch Link Downloader can take care of this for you!
Perfect research tool for students, developers, hobbyists, professionals etc.
NB: The extension is supported with contextual ads and donations. Please consider aiding further development and in keeping this extension ad light with kind donations
After paying for this account, the following are the resources you need for the listing:

1. a store icon of 128 * 128 px
2. between 1 to 5 screenshots of the various parts extension of either 1280x800 or 640x400 px
3. small promo image of 440x280 px

You can choose any category you want. I choose blogging but you can choose something like productivity or one you see is a better fit for the extension.
Since extensions have scripts that require permissions to run, you have to give the reasons why you need specific permissions.
This is a security measure to avoid an extension that asks for permissions that may compromise a users browsecomputer.
The following are the permissions that the extension needs and the associated permission. You can reword the reason if you see fit.
activeTab - to be able to run content scripts that extracts web page content on the tab in focus
downloads - to enable to download selected content to the local storage
storage - to be able to save user defined preferences. ie the pages that the user wants to download
host - the extension has to work on all types of web pages
In the section that asks if you are using remote code, just select No because the extension isn’t using any CDNs any other remotely hosted code.
Also, since the extension isn't taking any payments but just asking for donations, you can select free of Charge in the pricing and distribution section
The review process may take a few hours to a few days so just be patient.
getting traffic
I used the 3 major things to get traffic. They include:

1. SEO
2. influencer marketing on TikTok
3. YouTuber traffic

At the time of making this extension I had no money to use for advertising so I decided to take the 3 free traffic sources that I felt I could work on for an extended period of time.
SEO
The only SEO I did was in the description. I made sure I used proper words in the description without coming off as spammy.
YouTube Traffic
I used a website called channel crawler (just google it). It has a free tier that gives a list of YouTube channels based on, among other things, niche and YouTube subscriber count.
I figured that I should go for smaller YouTubers since the larger ones tend to already have monetized their channels with all sorts of things (membership sites, affiliate links etc). I decided to go for niche channels with under 50k subs that didn't have much of a monetization strategy.
After getting a list of YouTubers, the email extraction was repetitive and time consuming. I'd go to the channel, go to the about page and reveal the email. After doing this a number of times, YT would ask me to solve a capta. I wanted to write a bot to automate this but I decided to first do it manually to see if the idea would pan out.
Now, I noticed that YT only allows you to get about 10 emails every 24 hours. How I went around this was by creating another channel. A new channel on the same account meant a new profile that I could extract around 10 more emails. YT allows around around 50 (or is it 75) channels for a single account. So that means one can extract >500 emails per day with one email account (very tedious by hand, a python script would have made this much easier)
I extracted around around 1200 emails with this method and put them in an excel sheet.
Next came the cold emailing.
I made sure that the email copy had the following characteristics:

1. short, about 100 to 200 words
2. got straight to the point (no fluff words like ‘how is your day’)
3. had a clear call to action. In this case, I wanted a video review and a link on the description

I should also add that I used gmail to send out the emails. I don't think the emails were going to spam because I wasn't send too many from one account. around 40 per email account.
TikTok traffic
I basically opened an account and started following and cold messaging small TikTok creators until some decided to review the extension.
While I got some leads here, most of the traffic has come from the previous 2 traffic sources
resources used
Here are the resources you need to try this method out for yourself
link to extension: https://chrome.google.com/webstore/detail/webpage-cloneffjnfifmelbmglnajefiipdeejghkkjg
source code on Gumroad: https://saffron555.gumroad.com/l/web-cloner-chrome-extension
landing page I used: https://mega.nz/file/uPZiHTgB#T8MsQnGCsC6FR4a8qpors_CqfNUvxS6wHLPoxV_pEnQ

Introduction
Before I started chrome extension development, I had looked around various sites to see if browser extension development was viable income stream but all I found were discouraging comments about how people had thousands, tens of thousands of users but no viable income.
Fortunately, I had enough interest in programming and chrome extension development to give it a shot.
I am glad I did.
A chrome extension with a few hundred users has been making around $500 per month on average.
Aside from the initial coding and a few hours fixing bugs and responding to customer issues, the app runs automatically without much of a back-end to speak of.
I decided to write a post explaining how to create the chrome extension, how to upload upload and market it.
requirements
You need a chrome developer account. It costs $5 for lifetime access and you’ll be able to upload 20 different extensions. Google allows you to open an unlimited number of such developer accounts. Alternatively, you can upload the extension to the edge extension store which for now is free.
You can read through the tutorial to understand the details or

1. you can just get the source code,
2. modify it as I have mention in the tutorial
3. upload it to your developer account
4. start developing another income source.

Creating the extension
A chrome extension consists of the following major parts:

1. the manifest.json file
2. the background JS file (or files)
3. the content script JS file (or files)
4. the popup page
5. the options page

The manifest file is essentially a ledger that shows which scripts are allowed to run
the background script is where most of the extension’s functionalities reside. For the source code provided, you don’t need to add or modify any functionality
the content scripts are activated and executed on web pages. You can choose which content scripts get executed in which web pages using the permissions attribute.
the popup is a small web page that’s rendered when you click the icon on the browser menu. It therefore consists of a HTML file, a CSS file and a JS file
the options page is also web page that’s rendered when you go to the options of the installed extension. It also consists of a HTML file, a CSS file and a JS file
Since this is not a coding tutorial but more for a non technical person to upload a chrome extension, I’ll just mention the things you’ll want to change in the source code I give if you want to try this method out.
If readers are interested, I can follow up this tutorial with an I depth article where I jump into the code and the choices that were made therein.
Things to modify
If you are going to use the source code provided in the links, the things you should modify to customize your extension include:

1. name in the manifest.json file
2. description in the manifest.json file
3. author value in the manifest.json file
4. version number in the manifest file although this isn’t necessary
5. icons. Keep the names identical to the original ones or if you choose different names, change the names in the manifest file.
6. donate link in the popup JS file. Change the PayPal link on line 38 to your own link

extension submission
As I mentioned above, you’ll need a google web store developer account. You’ll pay a one time free of $5 and be able to publish around 20 extensions.
You’ll need a description for the extension. The following is the description I used. You can rewrite it so that google doesn’t flag your version as duplicate content.
clone a webpage by downloading all links as files
Easily download several links from a website.
Easily download a large number of links from a website.
Do you want to download a large number of PDFs, podcasts, or other items from a website without having to right-click and select "Save As" for each one? Batch Link Downloader can take care of this for you!
Perfect research tool for students, developers, hobbyists, professionals etc.
NB: The extension is supported with contextual ads and donations. Please consider aiding further development and in keeping this extension ad light with kind donations
After paying for this account, the following are the resources you need for the listing:

1. a store icon of 128 * 128 px
2. between 1 to 5 screenshots of the various parts extension of either 1280x800 or 640x400 px
3. small promo image of 440x280 px

You can choose any category you want. I choose blogging but you can choose something like productivity or one you see is a better fit for the extension.
Since extensions have scripts that require permissions to run, you have to give the reasons why you need specific permissions.
This is a security measure to avoid an extension that asks for permissions that may compromise a users browsecomputer.
The following are the permissions that the extension needs and the associated permission. You can reword the reason if you see fit.
activeTab - to be able to run content scripts that extracts web page content on the tab in focus
downloads - to enable to download selected content to the local storage
storage - to be able to save user defined preferences. ie the pages that the user wants to download
host - the extension has to work on all types of web pages
In the section that asks if you are using remote code, just select No because the extension isn’t using any CDNs any other remotely hosted code.
Also, since the extension isn't taking any payments but just asking for donations, you can select free of Charge in the pricing and distribution section
The review process may take a few hours to a few days so just be patient.
getting traffic
I used the 3 major things to get traffic. They include:

1. SEO
2. influencer marketing on TikTok
3. YouTuber traffic

At the time of making this extension I had no money to use for advertising so I decided to take the 3 free traffic sources that I felt I could work on for an extended period of time.
SEO
The only SEO I did was in the description. I made sure I used proper words in the description without coming off as spammy.
YouTube Traffic
I used a website called channel crawler (just google it). It has a free tier that gives a list of YouTube channels based on, among other things, niche and YouTube subscriber count.
I figured that I should go for smaller YouTubers since the larger ones tend to already have monetized their channels with all sorts of things (membership sites, affiliate links etc). I decided to go for niche channels with under 50k subs that didn't have much of a monetization strategy.
After getting a list of YouTubers, the email extraction was repetitive and time consuming. I'd go to the channel, go to the about page and reveal the email. After doing this a number of times, YT would ask me to solve a capta. I wanted to write a bot to automate this but I decided to first do it manually to see if the idea would pan out.
Now, I noticed that YT only allows you to get about 10 emails every 24 hours. How I went around this was by creating another channel. A new channel on the same account meant a new profile that I could extract around 10 more emails. YT allows around around 50 (or is it 75) channels for a single account. So that means one can extract >500 emails per day with one email account (very tedious by hand, a python script would have made this much easier)
I extracted around around 1200 emails with this method and put them in an excel sheet.
Next came the cold emailing.
I made sure that the email copy had the following characteristics:

1. short, about 100 to 200 words
2. got straight to the point (no fluff words like ‘how is your day’)
3. had a clear call to action. In this case, I wanted a video review and a link on the description

I should also add that I used gmail to send out the emails. I don't think the emails were going to spam because I wasn't send too many from one account. around 40 per email account.
TikTok traffic
I basically opened an account and started following and cold messaging small TikTok creators until some decided to review the extension.
While I got some leads here, most of the traffic has come from the previous 2 traffic sources
resources used
Here are the resources you need to try this method out for yourself
link to extension: https://chrome.google.com/webstore/detail/webpage-cloneffjnfifmelbmglnajefiipdeejghkkjg
source code on Gumroad: https://saffron555.gumroad.com/l/web-cloner-chrome-extension
landing page I used: https://mega.nz/file/uPZiHTgB#T8MsQnGCsC6FR4a8qpors_CqfNUvxS6wHLPoxV_pEnQ