-
Notifications
You must be signed in to change notification settings - Fork 0
/
cms.sql
226 lines (184 loc) · 123 KB
/
cms.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 19, 2021 at 11:35 AM
-- Server version: 8.0.23
-- PHP Version: 8.0.7
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `cms`
--
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (
`cat_id` int NOT NULL,
`cat_title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- Dumping data for table `categories`
--
INSERT INTO `categories` (`cat_id`, `cat_title`) VALUES
(36, 'Anime'),
(37, 'Programming'),
(38, 'News'),
(39, 'Career'),
(40, 'Gaming');
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE `comments` (
`comment_id` int NOT NULL,
`comment_post_id` int NOT NULL,
`comment_author` varchar(255) NOT NULL,
`comment_email` varchar(255) NOT NULL,
`comment_content` text NOT NULL,
`comment_status` varchar(255) NOT NULL,
`comment_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- Dumping data for table `comments`
--
INSERT INTO `comments` (`comment_id`, `comment_post_id`, `comment_author`, `comment_email`, `comment_content`, `comment_status`, `comment_date`) VALUES
(28, 69, 'aayush', 'aayush@gmail.com', 'Concise and well-written.', 'approved', '2021-10-19'),
(29, 64, 'bhanu', 'naveen@gmail.com', 'Love anime', 'unapproved', '2021-10-19');
-- --------------------------------------------------------
--
-- Table structure for table `posts`
--
CREATE TABLE `posts` (
`post_id` int NOT NULL,
`post_category_id` int NOT NULL,
`post_title` varchar(255) NOT NULL,
`post_author` varchar(255) NOT NULL,
`post_date` date NOT NULL,
`post_image` text NOT NULL,
`post_content` text NOT NULL,
`post_tags` varchar(255) NOT NULL,
`post_comment_count` int NOT NULL DEFAULT '0',
`post_status` varchar(255) NOT NULL DEFAULT 'draft',
`post_view_count` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- Dumping data for table `posts`
--
INSERT INTO `posts` (`post_id`, `post_category_id`, `post_title`, `post_author`, `post_date`, `post_image`, `post_content`, `post_tags`, `post_comment_count`, `post_status`, `post_view_count`) VALUES
(64, 36, '7 BEST ANIME BLOGS EVERY OTAKU SHOULD KNOW ABOUT', 'naveen', '2021-10-19', 'anime.jpg', '<h3>1. ANIME SCIENCE 101</h3><p>Established by Christopher Meharg, <a href=\"http://www.animescience101.com/\">Anime Science 101</a> is a blog that intends to shed some light on the scientific ideas shown in various Japanese animation shows. You can say that this site is unique because it focuses on how accurate or inaccurate the science is in a particular anime.</p><p>As a science teacher with two years of experience in medical school, Meharg creates “lessons” inspired by anime-related scientific concepts. He grades in-show science using three marks: confirmed, plausible and busted.</p><p>What’s great about this blog is that it makes learning fun in a way that is relatable for anime fans. So, while readers are poring over a blog entry that talks about their favorite shows, they are also learning the scientific concepts that are (or should have been) behind the things they see on the show.</p><h3>2. HONEY’S ANIME</h3><p><a href=\"https://honeysanime.com/\">Honey’s Anime</a> started out like an episode review blog but has now evolved into a large community that tackles a variety of anime-related topics. The site focuses on giving a list of top 10 shows in all genres, from shounen to shoujo series and movies!</p><p>A fun thing about this blog is that it has official mascots! Honey-chan is the kimono-wearing face of the website, while Bee-kun is her shapeshifter companion. Aside from Honey-chan and Bee-kun, the site also has mascots for its Hispanic readers. The Spanish-speaking duo, Bombon and Mo-chan are best friends who have opposite preferences in shows.</p><h3>3. LITTLE ANIME BLOG</h3><p>Giving a more socially aware twist in anime-related blogging, <a href=\"https://littleanimeblog.com/\">Little Anime Blog</a> offers insightful takes on various series. It applies critical analysis when reviewing episodes, series and movies, tackling issues such as technology, pop culture and sexuality.</p><p>Aside from providing refreshingly stimulating reviews, the blog also provides reliable news for anime and manga fans. The site brings a mischievous spin to its content by reporting on industry-related rumors, casting news and many other aspects of the <a href=\"https://dubbedanimehq.com/anime-industry/\">animation and comic industry</a> in Japan.</p><p>The writers in this blog are both poets and it is no surprise that they also write poems about their favorite characters and plots.</p><h3>4. RANDOMC</h3><p>Starting as a blog on Blogger, <a href=\"https://randomc.net/\">RandomC</a> is now a simple yet dense blog, with a huge following. It offers a huge variety of content, from reviews of current and popular series. Because of the expansive content of this site, you can start by going to the categories page in which you can choose to read about anime news, best-of lists, as well as first and final impressions.</p><p>One thing you will notice about its homepage is that there is a huge calendar detailing the season schedule releases. So, if you want to keep yourself updated about new and current shows, you can simply visit these <a href=\"https://dubbedanimehq.com/anime-streaming-websites/\">Anime websites</a>.</p><h3>5. TOKYO OTAKU MODE</h3><p><a href=\"https://otakumode.com/\">Tokyo Otaku Mode</a> (TOM) is known as the biggest news site dedicated to Japanese pop culture. It has more than 20 million likes on its Facebook page, giving in a huge audience. Unlike the first four, where the content is somewhat casual, TOM offers a more “official” experience as it specializes in the news. The website gains international support through translations, making it a truly global page.</p><p>Aside from providing quality content through the site, it also offers manga and anime related items through the Tokyo Otaku Mode Shop. To reach creators and buyers, TOM also holds exhibitions in which it allows participants to showcase their products at conventions abroad.</p><h3>6. WRONG EVERY TIME</h3><p>With such an attention-grabbing name, this site offers a wide variety of content, from essays and reviews to lists and episode write-ups. The founder, simply known as Bobduh, is fond of creating characters, storytelling and fiction writing!</p><p><a href=\"https://wrongeverytime.com/\">Wrong Every Time</a> offers valuable perspectives on various characters, shows and episodes, giving readers a taste of what to expect. It even gives recommendations for shows similar to a series in questions, making it easier for fans to seek out more content they would love.</p><h3>7. DUBBED ANIME HQ</h3><p>Yes, this is a shameless plug for <a href=\"https://dubbedanimehq.com/blog/\">Dubbed Anime HQ’s blog</a> =) But what can I say… we like to think of ourselves as the new up and coming blogs in the anime space. We’re working hard to pump out quality and engaging content that fans want to read. We talk about popular English dubbed anime shows, movies, and also where you can watch anime online. We hope you come back and visit often.</p><h2>WRAP-UP</h2><p>Feed your anime-related cravings by delving into these <strong>Anime blogs</strong>. You are sure to find hidden gems, whether it is excellently written reviews, great insights or spot-on recommendations. So, give these sites a visit. You may even become a part of these blogs someday!</p>', 'anime', 0, 'published', 10),
(65, 36, 'TOP 10 STRONGEST NARUTO CHARACTERS', 'naveen', '2021-10-19', 'unnamed.png', '<p>It is no secret that Naruto serves as a home to dozens of powerful characters. From annihilating an entire clan to bringing people back to life. There comes a long list of impressive abilities most of its characters possess. But, who are the strongest Naruto characters in the series?</p><p>In this article, we will share who made the top 10 list. Keep reading…</p><p>The <a href=\"https://dubbedanimehq.com/naruto-hokage-characters/\">Naruto Shippuden series’ has had a long list of powerful characters</a> and for nearly two decades, the question of who reigns supreme among all ninjas always comes up. This remains to be an ongoing debate among all Naruto fans.</p><p>To put this long debate to rest, join us as we countdown the strongest heroes and villains in this legendary franchise. Take a look.</p><h2>SEE LIST OF TOP 10 STRONGEST NARUTO CHARACTERS</h2><h3>#10: MIGHT GUY</h3><p><img src=\"https://ws-na.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=B079DWWTHR&Format=_SL500_&ID=AsinImage&MarketPlace=US&ServiceVersion=20070822&WS=1&tag=networkcapt0d-20&language=en_US\" alt=\"Might Guy \"></p><p>At first glance, Guy might appear to be the typical overly confident and optimistic character. Who is no good in battle – well, at least that’s how most anime newcomers see him. However, behind his iconic thumbs up, wink, and winning smile, there lies a remarkable power that had gained the respect of many.</p><p>Unlike most strong characters who had displayed remarkable talent and potential during their early years. Guy had little to no talent in ninjutsu and genjutsu as a child. However, his gradual and striking development as an extremely powerful shinobi. Ultimately proved his position as a formidable foe to his opponents.</p><p>Displaying pure speed, strength, and mastery in taijutsu. <a href=\"https://naruto.fandom.com/wiki/Might_Guy\">Might Guy</a> has even been acknowledged by dozens of other strong characters in the series. This includes Itachi Uchiha, who advised the entire Akatsuki not to underestimate Guy. Kakashi Hatake, who revealed that Guy was stronger than himself in the Fourth Shinobi World War, and Madara Uchiha, who shared that Guy was the most exciting opponent he had faced since Hashirama Senju.</p><h3>#9: OROCHIMARU</h3><p><img src=\"https://ws-na.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=B0126R4LM2&Format=_SL500_&ID=AsinImage&MarketPlace=US&ServiceVersion=20070822&WS=1&tag=networkcapt0d-20&language=en_US\" alt=\"Orochimaru \"></p><p>Regarded as one of Konohagakure’s three legendary Sannin, <a href=\"https://naruto.fandom.com/wiki/Orochimaru\">Orochimaru</a> holds the 9th position in our top powerful list. Driven by his ambition to learn all of the world’s secrets and attain immortality in the process. Naruto Part I’s biggest antagonist is, no doubt, a threatening enemy whose power makes him one of the most feared shinobi in the ninja world.</p><p>Even his forbidden Jutsu, the Reanimation Jutsu, which brings fallen warriors back to life. It is a powerful and fearsome ability that could make even the bravest ninjas cower in fear.</p><h3>#8: OBITO UCHIHA</h3><p><img src=\"https://ws-na.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=B088DJMRPZ&Format=_SL500_&ID=AsinImage&MarketPlace=US&ServiceVersion=20070822&WS=1&tag=networkcapt0d-20&language=en_US\" alt=\"Obito Uchiha \"></p><p>Many would agree that <a href=\"https://hero.fandom.com/wiki/Obito_Uchiha\">Obito Uchiha</a> displayed the most surprising character development in the series. A former student of the Fourth Hokage and friend to Kakashi. Obito went from the lovable comic relief to one of the most fearsome antagonists in the anime.</p><p>From being a character who seems to watch only on the sideline. Obito was revealed to be a manipulative mastermind who had caused untold disasters throughout the ninja world.</p><h3>#7: NAGATO</h3><p><img src=\"https://ws-na.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=B00TNRAYQG&Format=_SL500_&ID=AsinImage&MarketPlace=US&ServiceVersion=20070822&WS=1&tag=networkcapt0d-20&language=en_US\" alt=\"Nagato \"></p><p>From being a shinobi of Amegakure, a descendant of the Uzumaki clan, and one of the Akatsuki’s founding members. <a href=\"https://naruto.fandom.com/wiki/Nagato\">Nagato</a> bears an impressive set of credentials that made him one of the most powerful characters in Naruto. Moreover, his Rinnegan eyes, which lets him control gravity and bring the souls of the dead back to the world of the living. That made him even more formidable and a great risk to all ninjas.</p><h3>#6: ITACHI UCHIHA</h3><p><img src=\"https://ws-na.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=B082V2T3LT&Format=_SL500_&ID=AsinImage&MarketPlace=US&ServiceVersion=20070822&WS=1&tag=networkcapt0d-20&language=en_US\" alt=\"Itachi Uchiha \"></p><p>Regarded by Masashi Kishimoto himself as the single most powerful character in Naruto for some time. Sasuke’s powerful brother, <a href=\"https://villains.fandom.com/wiki/Itachi_Uchiha\">Itachi Uchiha</a>, stands as our 6th strongest character.</p><p>At an early age, Itachi had proven himself to be a prodigy. He is a master of illusions, a skilled swordsman, and master tactician of combat.</p><p>Although the full extent of Itachi’s powers might not truly be known, his unparalleled potentials and capabilities. Which even made him responsible for wiping out his entire village. It is a proof that he is one of the most powerful characters in the Naruto universe.</p><h3>#5: MADARA UCHICHA</h3><p><img src=\"https://ws-na.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=B071ZKZHB8&Format=_SL500_&ID=AsinImage&MarketPlace=US&ServiceVersion=20070822&WS=1&tag=networkcapt0d-20&language=en_US\" alt=\"Madara Uchiha \"></p><p>Co-founder of the Hidden Leaf Village and a rival to Hashirama Senju. <a href=\"https://narutoshippuuden.fandom.com/wiki/Uchiha_Madara\">Madara Uchiha</a> stands as our 5th strongest Naruto Shippuden character. Although it was later revealed that Madara is not the main antagonist of the series. His distinct personality and powerful abilities made him one of the biggest and most memorable villains in the franchise. Not only is he the man behind the disillusionment of Obito, but he is also the cause of the Fourth Great Ninja War.</p><p>He was also regarded to be the strongest member of the Uchiha clan. And even one of the most gifted shinobi in history.</p><h3>#4: HASHIRAMA SENJU (FIRST HOKAGE)</h3><p><img src=\"https://ws-na.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=B08F53GNFN&Format=_SL500_&ID=AsinImage&MarketPlace=US&ServiceVersion=20070822&WS=1&tag=networkcapt0d-20&language=en_US\" alt=\"Hashirama Senju \"></p><p>Hailed as the <i>“God of Shinobi”</i> due to his unrivaled ninja ability. <a href=\"https://naruto.fandom.com/wiki/Hashirama_Senju\">Hashirama Senju</a> stands as the 4th strongest Naruto character. Not only did he manage to capture and control the eight tailed beasts. But he also proved himself to be one the most influential among all ninjas.</p><p>Serving as a co-founder of the Hidden Leaf Village, along with this friend-turned-rival Madara. Hashirama is known to be a rare wood Jutsu user and the Hidden Leaf Village’s First Hokage.</p><h3>#3: SASUKE UCHIHA</h3><p><img src=\"https://ws-na.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=B081TQ1T6X&Format=_SL500_&ID=AsinImage&MarketPlace=US&ServiceVersion=20070822&WS=1&tag=networkcapt0d-20&language=en_US\" alt=\"Sasuke Uchiha\"></p><p>No other anti-hero tops <a href=\"https://naruto.fandom.com/wiki/Sasuke_Uchiha\">Sasuke Uchiha</a> in being the most popular in the anime realm.</p><p>Having been able to possess the power of the Rinnegan. Sasuke is arguably the strongest among all members of the Uchiha clan and even stands as one of the most formidable opponents for the main protagonist, Naruto.</p><p>Despite his questionable decisions, Sasuke is able to redeem himself in the end. And even grew to be one of the most powerful ninjas in all the lands with his exceptional skills. His Sharingan, and his Rinnegan eyes.</p><h3>#2: NARUTO UZUMAKI</h3><p><img src=\"https://ws-na.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=B07ZGDTLWW&Format=_SL500_&ID=AsinImage&MarketPlace=US&ServiceVersion=20070822&WS=1&tag=networkcapt0d-20&language=en_US\" alt=\"Naruto\"></p><p>Second on our list is no other than everyone’s favorite yellow-haired ninja, <a href=\"https://naruto.fandom.com/wiki/Naruto_Uzumaki\">Naruto Uzumaki</a>. Following the usual pattern of an overpowered protagonist, Naruto Uzumaki possesses a massive reserve of chakra in his body. Along with the Nine-Tailed beast sealed inside of him.</p><p>Despite failing to graduate the academy thrice, Naruto was able to prove his unparalleled power through sheer determination, training, and battles.</p><p>By adulthood, he was able to achieve his dream of becoming the Seventh Hokage. And is even regarded as the strongest shinobi of his era and in history.</p><h3>#1: KAGUYA OOTSUTSUKI</h3><p><img src=\"https://ws-na.amazon-adsystem.com/widgets/q?_encoding=UTF8&ASIN=B0791K2DC2&Format=_SL500_&ID=AsinImage&MarketPlace=US&ServiceVersion=20070822&WS=1&tag=networkcapt0d-20&language=en_US\" alt=\"Kaguya Otsutsuki\"></p><p>You bet it. Our top spot for the strongest Naruto character goes to no other than the mastermind of all chaos in the Naruto universe, <a href=\"https://comicvine.gamespot.com/kaguya-otsutsuki/4005-92516/\">Kaguya Ootsutsuki</a>.</p><p>Known to be the <i>“Mother of Chakra,”</i> Kaguya served as the alien mother of the Sage of the Six Paths and the first wielder of chakra. She is the ultimate evil – the one formidable foe that would bring fear, surprise, and despair to many shinobi.</p><p>Among his most terrifying and remarkable abilities include being able to merge herself with nature, telepathy, chakra absorption, flight, regeneration, and many more.</p><p>All through the series, Kaguya has served as the biggest and most powerful foe Naruto and all the other characters had faced.</p><h2>CONCLUSION</h2><p>Do you agree in our list of the top ten strongest Naruto characters? Who among these names appealed to you the most? Surely, whether they may be on the good side or part of the archetypal league of villains. There are dozens of Naruto characters that have managed to leave a permanent mark in the <a href=\"https://dubbedanimehq.com/dubbed-anime-shows/\">anime series you adore most</a>. If you liked this list, you should also check out our list of the <a href=\"https://dubbedanimehq.com/strongest-naruto-female-characters/\">strongest female characters in Naruto</a> too!</p>', 'anime, naruto', 0, 'published', 5),
(66, 37, 'Best Tools and Deals for Developers and Designers', 'aayush', '2021-10-19', 'ui.jpg', '<h2><a href=\"https://dashboardpack.com/\">1. Free and Premium Bootstrap 4 Admin Themes & UI Kits</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/1.jpg\" alt=\"\"><br>DashboardPack is a top choice when looking for free and premium Dashboard themes and templates. They are building awesome HTML5, React, Angular, and Vue themes that are free and premium. All their products have a top-quality, come with complete documentation and support, and are super simple to use.</p><p>A premium theme made by them that I personally love is ArchitectUI Dashboard Vue PRO. It uses only widgets and components specially built for Vue 2, updated to their latest versions. As a base framework, ArchitectUI Vue is powered by @vue/CLI version 3.4.1 and Bootstrap 4 Vue implementation (bootstrap-vue.js.org).</p><p>It contains over 50 handpicked Vue widgets and components that are perfectly integrated with each other in order to create a common design language. It features a modular stylesheets architecture so that it will be easy to customize and exclude the components that you’re not going to use in your app.</p><p>Also, ArchitectUI Vue Pro features 9 different dashboard pages designs, 9 different color schemes for Bootstrap based elements and multiple styles for the header and sidebar components.</p><p>Between November 29 and 3rd of December, you have 50% discount for all templates and all license types (Personal, Developer, and Lifetime). Use this coupon code: MADBF50.</p><h2><a href=\"https://total.wpexplorer.com/\">2. Total Theme</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/2.jpg\" alt=\"\"></p><p>Total Theme is a brilliant WordPress theme that will help you build any kind of WordPress website you need, in minutes, without having any prior experience or special skills. There are over 38,000 happy customers using it Total Theme with great success, and thousands of people are just finding out of how cool this theme is.</p><p>Use it to create websites from these niches: Business, One Page, Portfolio, Personal, Creative, Shop, Blog, Photography, and many others. To save time you can start from the 40+ included demos that you can install with 1-click, or you can start from scratch by using the included Visual Page Builder plugin. Total Theme has included 4 premium plugins for free: the famous page builder we just mentioned, Templatera, Slider Revolution and LayerSlider.</p><p>Don’t wait, create a super WordPress website with Total Theme, the whole process is highly enjoyable and fast. The interface is brilliant and quick.</p><p>Limited time 50% off Total Theme offer valid 26th November 2019 12pm AEDT through 3rd December 2019 8pm AEDT. Discount already applied.</p><h2><a href=\"ttps://www.tailorbrands.com/\">3. Tailor Brands</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/3.jpg\" alt=\"\"></p><p>Do you know how much a great logo design costs? Governments are paying even millions of dollars for a logo, the same happens for huge corporations. Why don’t they use an automated logo creator like Tailor Brands? This is by far the best logo and brand identity automated creator, and the results are outstanding. Many times you cannot even tell if a logo was created by Tailor Brands or by a talented designer. Why spend tens of thousands of dollars, or even millions, when this powerful AI software can make a great job?</p><p>The costs for using Tailor Brands are a fraction of the normal cost that a graphic designer is asking for.<br>We strongly recommend you to try this platform. You can register with your Facebook account, and after a few simple steps, the platform will present you with tens of logo designs to choose from.</p><h2><a href=\"https://www.hellobonsai.com/freelance-taxes\">4. Freelance Taxes</a></h2><p>Do you wonder why 100,000+ professional creatives chose Bonsai as the go-to tool for their freelance business? The answer is simple: a deeply integrated suite of products covering everything you need for your projects, from proposal, contract, and invoice, to tax season.</p><p>Freelance taxes can get complicated, and are generally time-consuming. Let Bonsai help you out with your annual or quarterly taxes. The product looks at all your transactions, and will quickly show your taxable net income, categorize all your expenses, and guide you on what business tax deductions you can use.</p><p>Get more time on your hands to do the work that you love. Start your free trial of Bonsai today and get a feel of the power this integrated software suite has to offer.</p><h2><a href=\"https://www.codester.com/\">5. Codester</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/5.jpg\" alt=\"\"><br>If you are a web designer or web developer, you always need tens of different templates, PHP scripts, app templates, plugins, and much more. For all your needs, check Codester. This huge marketplace is loaded with tens of thousands of premium items, covering all the niches you need.</p><h2><a href=\"https://testingbot.com/\">6. Mobile App Testing</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/6.jpg\" alt=\"\"><br>Trusted by some of the world’s most innovative companies like Microsoft, Grammarly, FOX, and many others, TestingBot is a professional, popular, and very efficient app and browser testing service. Used it to run automated tests on over 2,000 browsers and devices, to test the performance of your website and app, for live web testing, and much more.</p><h2><a href=\"https://www.functionfox.com/demo\">7. FunctionFox</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/7.jpg\" alt=\"\"><br>FunctionFox is a popular and super simple to use time tracking, project management, and reporting service for teams. Say good-bye to budget overruns. Quick access to the status of each project helps you anticipate and head off problems — whether you bill by the hour, by project or by retainer. See FunctionFox in action, in a 14-day free trial, no credit card required.</p><h2><a href=\"https://www.taskade.com/\">8. Taskade — Simple Tasks, Notes, Chat</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/8.jpg\" alt=\"\"><br>Taskade is the unified workspace for distributed teams. Automate your workflows, chat with your team, and get work done, in one unified workspace.</p><p>Use Taskade as your unified team workspace to organize ideas, manage tasks, and get work done. Start by creating a workspace and add your team members. From there you can work together, assign tasks to team members, and chat live alongside your projects.</p><p>You can create a fully customized workspace from scratch, it is super simple and enjoyable, or you can edit one of the included templates (there are hundreds).</p><h2><a href=\"https://www.appypie.com/live-chat\">9. Live Chat Software</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/9.jpg\" alt=\"\"></p><p>AppyPie is a powerful live chat software that will help you engage your website visitors in no time, without having any programming or coding skills. Help your customers with quick answers, and they will be happy. Help your website visitors with the right information, and they will become your customers. Anybody can do it.</p><h2><a href=\"https://mobirise.com/extensions/kit/\">10. Mobirise Website Builder</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/10.jpg\" alt=\"\"></p><p>Mobirise is a popular website builder that is loaded with tons of cool stuff: over 2,000 awesome website templates, with sliders, galleries, forms, popups, icons, eCommerce and Shopping Cart, and much more.</p><p>Anybody can create a super website with Mobirise, without having any programming or designer skills. Give it a try.</p><h2><a href=\"https://www.mailmunch.com/newsletter-templates/\">11. Newsletter Templates</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/11.jpg\" alt=\"\"></p><p>MailMunch is a super email marketing platform that you can use to create beautiful email newsletters in a matter of minutes, using the included drag-and-drop builder and the gorgeous newsletter templates. No coding or designer skills required. Boost your email conversions with MailMunch.</p><h2><a href=\"http://catswhocode.com/go/astra/\">12. Astra Theme – Elementor Templates</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/12.jpg\" alt=\"\"><br>Elementor is great, anybody knows it, but did you know that you can supercharge it, and make it even better? Using the Astra bundle, you can easily add over 100 free and premium Elementor templates, making your website stand out of the crowd.</p><h2><a href=\"https://wpschema.com/\">13. Schema Pro</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/13.jpg\" alt=\"\"></p><p>Adding schema markups are time-consuming and because of that many people didn’t use it. With Schema Pro, you can add all the necessary schema markups in seconds, with 1-click, making your website rank higher in search engines.</p><h2><a href=\"https://rankmath.com/wordpress/plugin/seo-suite/\">14. Rank Math SEO</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/14.jpg\" alt=\"\"></p><p>Looking for a WordPress SEO plugin that is efficient, easy to install and configure? Rank Math SEO will help your website rank higher in search engines in no time and without your intervention. This autonomous SEO plugin works excellent, being already super popular among website owners.</p><h2><a href=\"https://unlayer.com/\">15. Email Template Builder</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/15.jpg\" alt=\"\"></p><p>Unlayer is a professional and simple to use email editor and page builder for SaaS, that will help your customers create emails and landing pages directly from your website. They don’t need to have any special or designer skills, as the platform will help them with tons of gorgeous templates, with a drag-and-drop builder, and a clean interface that will guide them every moment.</p><h2><a href=\"https://wixtowordpress.pro/\">16. WixToWordPress.PRO</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/16.jpg\" alt=\"\"></p><p>WixToWordPress.PRO guarantees professional Wix to WordPress website migration with special attention to details and accuracy of each step involved. The experts working for the service are competent in providing website transfer services and, thus, they are available for quick and easy access. The details and special parameters of each project are taken into account to ensure the best result possible and to leave clients satisfied.</p><h2><a href=\"https://contentsnare.com/\">17. Content Snare</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/17.jpg\" alt=\"\"></p><p>Content Snare is a must-have web tool for anybody that works with content received from customers and partners. We all know how many follow-ups we do to get the content, and usually, we don’t get it time, which translates into huge delays.</p><p>This platform will collect the content and files on time, in your place. The configuration is super simple and straightforward, let Content Snare do the hard work while you can focus on working.</p><h2><a href=\"https://www.logaster.com/logo/\">18. Logaster online logo maker</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/18.jpg\" alt=\"\"></p><p>Logaster is among the most used logo makers on the market, for creating a gorgeous and unique logo and brand identities. You write down the logo name, you add a slogan, and after a few seconds, the platform will show you tons of designs to choose from. The results are impressive, give it a try.</p><h2><a href=\"https://herothemes.com/themes/knowall-wordpress-knowledge-base/\">19. KnowAll Knowledge Base Theme</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/19.jpg\" alt=\"\"></p><p>KnowAll is the number 1 knowledge base theme for WordPress that you can use in many ways. A great idea is to use it as a support or presales page, helping your existing or future customers. This translates into happier customers or more sales.</p><h2><a href=\"https://8b.com/\">20. 8b Website Builder</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/20.jpg\" alt=\"\"></p><p>8b is the right website builder to use if you have literally 0 coding and designer skills. It is loaded with over 250 awesome templates that you can easily edit, with a clean interface that will guide you every moment, and with a lot more. Create your website now with 8b.</p><h2><a href=\"https://www.24x7wpsupport.com/\">21. 24x7WPSupport</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/21.jpg\" alt=\"\"></p><p>Fix all your website issues with 24x7wpsupport in the most economical way. Pricing plans tailored keeping in mind the needs of the customers, 24x7wpsupport extend their services from half-hour based to hourly, monthly and lifetime plans. Choose the one that serves your purpose best and optimize your website without much effort. To know more, visit their website, drop a message or call them. Their experts would get back to you, at the earliest.</p><h2><a href=\"https://wix2wp.pro/\">22. Wix2WP.Pro</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/22.jpg\" alt=\"\"></p><p>Wix2WP.Pro makes it possible to successfully transfer websites from Wix to WordPress without any coding and preliminary web design experience involved. The service has been in the market for several years, having won the trust of dozens of their clients. The team of the service includes only experienced web developers, who are skilled at completing such tasks in the best way possible. Their effective cooperation lets you get the most of your website migration process.</p><h2><a href=\"https://mmthomasblog.com/\">23. MMThomasBlog.com</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/23.jpg\" alt=\"\"></p><p>MMThomasBlog.com makes it possible to look through the reviews and comparisons of DIY web building software, which is indispensable when it comes to the choice of the best service. The resource was launched and is now managed by Malcolm Thomas, who personally tests, analyzes and describes the best systems one can use to start and manage a quality website.</p><h2><a href=\"https://www.ucoz.com/\">24. uCoz</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/24.jpg\" alt=\"\"></p><p>uCoz is a website builder with a module structure and an integrated CMS. That means you don’t have to be a coding expert: the drag-and-drop builder requires no special knowledge. Whatever you want to create (a website, blog, forum, online store), uCoz is your solution. Get access to uCoz API and FTP, adapt HTML, CSS, PHP, and JS and the site is ready to use!</p><h2><a href=\"https://www.48hourslogo.com/\">25. 48HoursLogo</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/25.jpg\" alt=\"\"></p><p>There are over 40,000 small businesses and entrepreneurs who used 48HoursLogo with great success. On this platform, you can launch your own logo design content where real and talented graphic designers compete for your design. The results are impressive, give it a try.</p><h2><a href=\"https://htmltowordpress.pro/\">26. HTMLtoWordPress.pro</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/26.jpg\" alt=\"\"></p><p>HTMLtoWordPress.Pro guarantees seamless, fast and reliable migration of HTML websites to WordPress completed by the professionals. The service allows completing all the steps of the project transfer process with precise attention to details and individual approach to each client. There is no need to possess web design or coding skills to cope with the task on your own as the system experts will do that for you.</p><h2><a href=\"https://www.brizy.cloud/\">27. Brizy Cloud Website Builder</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/27.jpg\" alt=\"\"></p><p>Brizy is a super sophisticated, yet free and simple to use, landing page and website builder, is loaded with lots of gorgeous templates, a clean interface, a drag-and-drop builder, and lots of other cool stuff.</p><p>Creating a super landing page with Brizy takes a couple of minutes, and you need 0 coding or special skills.<br>Use the discount code: BF40OFF in the shopping cart on https://www.brizy.cloud/#pricing – available from 29 Nov to 2 Dec. You also get access to Brizy PRO WordPress plugin with your Brizy Cloud purchase.</p><h2><a href=\"https://wp2wix.com/\">28. WP2Wix.com</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/28.jpg\" alt=\"\"></p><p>WP2Wix.Com has distinguished itself as a professional, reliable and safe service that allows moving websites from WordPress to Wix. The service has been around for a couple of years, winning the trust of new and returning clients. The team of pros takes special care of the correct transfer of all website elements, entities, and assets.</p><h2><a href=\"https://themeforest.net/item/shella-ultimate-fashion-responsive-shopify-theme/22804833?ref=jbj\">29. Shella – Ultima Fast Responsive Shopify Theme</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/29.jpg\" alt=\"\"></p><p>Looking for the most powerful and complete Shopify theme for fashion stores? Shella is a complete package, is loaded with lots of skins, templates, elements, and everything you need to have a high-converting and out of the crowded shop.</p><h2><a href=\"https://www.pixpa.com/\">30. Pixpa – Portfolio Websites</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/30.jpg\" alt=\"\"></p><p>You can use Pixpa every time you need to create a website, store, blog, and client gallery, all-in-one place. There is no need to have any special skills or previous experience. The platform has everything you need: gorgeous templates, a drag-and-drop builder, and a clean interface.</p><h2><a href=\"https://www.invoiceberry.com/free-invoice-templates\">31. Free Invoice Templates</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/31.jpg\" alt=\"\"></p><p>InvoiceBerry is probably the best invoicing software for small companies, entrepreneurs, and freelancers. To create and send a fully customized invoice takes 60 seconds or less.<br>Try InvoiceBerry for 30 days, for free, no credit card required.</p><h2><a href=\"https://www.rumbletalk.com/\">32. Chat platform for live events</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/32.jpg\" alt=\"\"></p><p>RumbleTalk will help you add an online group chat to your website in 2 minutes or less, without having any coding or programming skills. Get in touch with your website visitors and help your business better convert.<br>Get a free chat now.</p><h2><a href=\"https://www.fotor.com/\">33. Fotor Free Photo Editor</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/33.jpg\" alt=\"\"></p><p>Fotor is the most used online photo editor and design maker on the market, being used by over 300 million happy people. You can now easily create high-converting images with Fotor, as the platform has everything you need.</p><h2><a href=\"https://www.wrappixel.com/blackfriday\">34. WrapPixel</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/34.jpg\" alt=\"\"></p><p>WrapPixel is providing top quality free and premium Bootstrap, Angular, React, Vuejs, Admin templates, and UI Kits, including the biggest bundle ever made that contains tons of items and it is sold with a huge discount – a super offer of 95% discount.</p><h2><a href=\"https://adminmart.com/\">35. Adminmart</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/35.jpg\" alt=\"\"></p><p>With Adminmart, a powerful, yet free to use Bootstrap 4 admin theme, you can build web applications and dashboard in no time, without having any coding or designer skills. It comes loaded with over 25 page templates and tons of other cool stuff.</p><h2><a href=\"https://www.cahoot.ai/\">36. Cahoot</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/36.jpg\" alt=\"\"></p><p>Cahoot is an innovative warehouse sharing solution for Brands and Retailers to expand their geographic footprint by fulfilling orders for one another. As a result, top-rated Merchants offer 2-day free shipping using ground shipping by exchanging warehouse space. Nationwide fast and free shipping is now much more profitable.</p><h2><a href=\"https://photos.icons8.com/\">37. Icons8 Photos</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/37.jpg\" alt=\"\"></p><p>With the upgraded Icons8 Photos, every user is able to influence the world of stock photography without a camera. Get photos of models reflecting the diversity of genders, ages, cultures and body types, filters for better search results, and ability to recompose existing photos.</p><p>All the photos are downloaded high-quality and free for a link. In case you want to use the photos without credits, buy the license: it’s $20/month and except photos, it also opens full access to icons, vectors, and royalty-free music.</p><h2><a href=\"https://themerex.net/downloads/gutentype-a-trendy-gutenberg-wordpress-theme/\">38. Gutentype</a></h2><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/11/38.jpg\" alt=\"\"></p><p>Gutentype WordPress theme is a clean and fresh web solution based on the Gutenberg page builder. It includes everything needed to create an informative and user-friendly web resource. The theme supports all the Gutenberg blocks that are available in the latest versions of the editor.</p>', 'programming, productive', 0, 'published', 1),
(67, 37, 'CSS Vertical Alignment: Tips and Techniques', 'aayush', '2021-10-19', 'css.jpg', '<p>As long as CSS has been around, <strong>centering elements vertically</strong> has always been a frustrating task for many front-end web developers.</p><p>Unlike horizontal alignments, which can be achieved easily using the text-align property, vertical alignments are often much more tricky to put into action.</p><p>Nowadays, vertically centering text or any element using CSS is a simple task. This article demonstrates various CSS vertical alignment techniques: Using a Flexbox, using positioning + transform, using vertical padding, and using line-height.</p><h2>CSS Vertical Align using Flex</h2><p>Introduced with the CSS3 specification, the display: flex property/value makes it easier to design flexible responsive layout structures without using floats or positioning.</p><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/08/css-flex-align.png\" alt=\"CSS Text Align\"></p><p>Along with display:flex, you can easily align anything from table cells to inline elements with the align-items, align-self, and justify-content properties.</p><p><a href=\"https://codepen.io/webdevblog/pen/wvwqyer\">Click here</a> to view the demo for this technique. For the HTML part, we only need a simple container, so let’s consider the following:</p><p> </p><p> I am vertically centered!</p><p> </p><p>Here is the CSS code for vertically centering the text:</p><p>.align-vertically { background: #13b5ea; color: #fff; display: flex; align-items: center; height: 200px; }</p><p>Let’s see how it works:</p><ul><li>On line 4 of the CSS code, I define the display as flex, which enables the flexbox layout for the container.</li><li>Line 5 vertically centers the text in the flexbox, using the align-items CSS property and center as a value.</li></ul><p>This technique is very reliable and works well in a <a href=\"https://webdevblog.com/responsive-web-design-techniques/\">responsive web design</a> context. Unfortunately, CSS Flexbox isn’t supported by IE9 and earlier versions.</p><h2>CSS Vertical Align Using The Transform Property</h2><p>This is an interesting technique, as it allows you to easily center vertically any HTML element: Paragraphs, images, etc.</p><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/08/css-code-align.png\" alt=\"CSS Code Align\"></p><p>To make it work, we need two containers in our HTML: The following examples use a div as a parent, and a paragraph containing the text I want to vertically align:</p><p> </p><p> </p><p>I am centered!</p><p> </p><p>Here’s the related CSS code, that will make our paragraph vertically (and horizontally) centered:</p><p>.vertical-align { color: #fff; height: 200px; position: relative; background: #13b5ea; } .vertical-align p { margin: 0; position: absolute; top: 50%; left: 50%; transform: translate(-50%, -50%); }</p><p>Let’s have a look at the properties used to make it work (You can check out the <a href=\"https://codepen.io/webdevblog/pen/KKPvQgo\">demo</a> if you want to see this technique in action):</p><ul><li>The .vertical-align class defines a fixed 200px height. This can be changed to fit your site’s needs. Also, note the use of position: relative, which is used to prevent display problems of the child element, which has a position: absolute defined.</li><li>The child element (.vertical-align p) uses a top: 50%; to display the paragraph at 50% of the parent element’s top. This alone won’t center the content vertically.</li><li>The transform property on line 13 is used to compensate the extra space created by both top and left.</li></ul><p>This is what I’ve used to make WebDevBlog’s post title and meta vertically centered. It’s a simple, quick and efficient technique. The only problem is that the transform property is not supported in IE8 and earlier versions.</p><h2>CSS Vertical Alignment Using Vertical Padding</h2><p>Using padding, we can create a centered text. This technique is very widely used, for example when creating buttons and navigation menu items.</p><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/08/css-padding-align.png\" alt=\"CSS Padding\"></p><p>Consider this simple bit of HTML below, or have a look at the <a href=\"https://codepen.io/webdevblog/pen/OJLjQEO\">demo</a>.</p><p> </p><p> I look centered!</p><p> </p><p>Here is the CSS class we’re using:</p><p>.vertical-align{ background: #13b5ea; color: #fff; border-radius: 5px; width: 200px; text-align: center; padding: 2rem 0; }</p><p>As you can see, I specified a top and bottom padding of 2 rems (On line 7). This creates space at the top and bottom of the element, which will look vertically centered.</p><h2>CSS Vertical Alignment Using Line Height</h2><p>This technique is very similar to the padding technique explained above. The only difference is that we will be using the line-height CSS property to vertically center our element.</p><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/08/line-height.png\" alt=\"line-height center\"></p><p>Let’s use the same HTML code we’ve used in the previous example. As before, there’s a <a href=\"https://codepen.io/webdevblog/pen/gOYxvdx\">demo</a> available for you to test and experiment with this technique.</p><p> </p><p> I look centered!</p><p> </p><p>The CSS code isn’t much different from the one used in the previous example:</p><p>.vertical-align{ background: #13b5ea; color: #fff; border-radius: 5px; width: 200px; text-align: center; line-height: 4rem; }</p><p>In this technique, we have used the line-height CSS property to vertically center the text of a button.</p><p>While this technique works well with buttons or navigation items, you have to use it very carefully: If for some reason your text goes on multiple lines, the whole thing will look completely broken. This is why I tend to use the padding technique instead of this when vertically centering text on a button.</p><h2>CSS Vertical Alignment Using display:table-cell</h2><p>This technique requires 2 containers, and uses display: table on a parent element and display: table-cell on its child.</p><p><img src=\"https://webdevblog.com/wp-content/uploads/2019/09/css-table-cell.png\" alt=\"table-cell vertical-align\"></p><p>This allows you to replicate how text and content are aligned on a HTML table cell. Let’s consider the following HTML code:</p><p> </p><p> </p><p>I am centered</p><p> </p><p>Here is the related CSS:</p><p>#parent { background: #13b5ea; color: #fff; height: 200px; display: table; } #child { display: table-cell; vertical-align: middle; }</p><p>Nothing complicated here: The parent element is assigned a table display, and its child uses display: table-cell. The content of the child element is then vertically centered using the vertical-align: middle property.</p><p>If you also need to align the content horizontally, you simply need to use text-align: center on the parent element.</p><p>This technique works great in all modern browsers. Please note that display: table and display: table-cell are not supported on IE7 and earlier versions.</p>', 'programming, web develop, css', 0, 'published', 2);
INSERT INTO `posts` (`post_id`, `post_category_id`, `post_title`, `post_author`, `post_date`, `post_image`, `post_content`, `post_tags`, `post_comment_count`, `post_status`, `post_view_count`) VALUES
(68, 40, '30+ Great Examples of Gaming Blogs (2021)', 'bhanu', '2021-10-19', 'game.jpg', '<p>Are you just getting into gaming or simply looking for inspiration? Perhaps you’ve mastered the art of gaming and already know everything there is to know about technology? Whether you want to learn more or share your knowledge with the world, few things are more helpful than blogs. You can choose to pick up tips and tricks from others or <a href=\"https://firstsiteguide.com/start-blog/\">start your own blog</a> and share your hard-earned wisdom.</p><p>If you want to be known as a great gamer, learning all that there is to know is a must. This is why many top gamers run a blog or read the best ones daily. Why not do the same? I’ve prepared a list of more than 30 gaming blogs that can help you to achieve any goal you have set. Let’s dive deeper to learn more.</p><h2><strong>35 best gaming blogs</strong></h2><p>The process of selecting only the best of the best gaming blogs was challenging. These days, anyone can consider themselves a gaming blogger and expert, so it took some time to separate the wheat from the chaff.</p><p>I have found 35 gaming blogs with valuable information about different types of gaming, including some bloggers familiar with the mysterious world of tech. Now, it’s your turn to learn more about them and hopefully find the inspiration you need.</p><h3><strong>1. </strong><a href=\"https://kotaku.com/\"><strong>Kotaku</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/kotaku.jpg\" alt=\"Kotaku Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/kotaku.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/kotaku-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/kotaku-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/kotaku-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/kotaku-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>Kotaku is one of the longest-standing gaming blogs out there, covering topics ranging from video game reviews to daily news. Contributors to the blog fill every post with intelligent humor. It was launched in 2004 as part of the Gawker Media network but underwent a transition in 2019. The blog is easy to navigate, so even newcomers can find what they’re looking for.</p><p><strong>Main topics covered</strong>: gaming, news, cosplay, impressions, reviews<br><strong>Built with</strong>: Express<br><strong>The main source of income</strong>: product sales, affiliate marketing, collaborations<br><strong>The most popular post</strong>: <a href=\"https://kotaku.com/the-nier-replicant-remaster-does-many-good-things-and-o-1846743596\">The Nier Replicant Remaster Does Many Good Things And One Awful Thing</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/kotakudotcom/?hl=en\">@kotakudotcom</a></p><h3><strong>2. </strong><a href=\"https://wolfsgamingblog.com/\"><strong>Wolf’s Gaming Blog</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/WolfsGamingBlog.jpg\" alt=\"Wolf’s Gaming Blog Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/WolfsGamingBlog.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/WolfsGamingBlog-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/WolfsGamingBlog-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/WolfsGamingBlog-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/WolfsGamingBlog-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>This blog’s creator was just a regular guy with interests in gaming and tech when he started running the blog. With time, interest in what he had to say spiked, leading top companies to create deals with him. Although he now regrets the blog’s name, he doesn’t regret sticking with it. Check it out to learn something new about gaming every day.</p><p><strong>Main topics covered</strong>: Xbox, PlayStation, PC games, VR, reviews, interviews<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: collaborations, donations, advertising<br><strong>The most popular post</strong>: <a href=\"https://wolfsgamingblog.com/2021/02/21/ps5-media-remote-review-who-is-this-for/\">PS5 Media Remote Review – Who Is This For?</a></p><h3><strong>3. </strong><a href=\"https://www.thatvideogameblog.com/\"><strong>That Video Game Blog</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/ThatVideoGameBlog.jpg\" alt=\"That Video Game Blog Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/ThatVideoGameBlog.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/ThatVideoGameBlog-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/ThatVideoGameBlog-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/ThatVideoGameBlog-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/ThatVideoGameBlog-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>That Video Game Blog team consists of more than 20 experts on gaming, so you know you’re in for a treat. This team works hard to deliver the support that you need for gaming and the latest news and reviews about top games. You can also scroll through some editorials if those are more your cup of tea.</p><p><strong>Main topics covered</strong>: Xbox, PlayStation, PC games, reviews, gear, news<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: advertising, collaborations<br><strong>The most popular post</strong>: <a href=\"https://www.thatvideogameblog.com/trigger-witch-enspells-consoles-this-summer/\">Trigger Witch Enspells Consoles This Summer</a></p><h3><strong>4. </strong><a href=\"https://attackofthefanboy.com/\"><strong>Attack of the Fanboy</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/AttackOfTheFanboy.jpg\" alt=\"Attack of the Fanboy Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/AttackOfTheFanboy.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/AttackOfTheFanboy-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/AttackOfTheFanboy-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/AttackOfTheFanboy-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/AttackOfTheFanboy-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>AOTF started as a passion project in 2010 and now consists of a team of content creators who produce new gaming content on a daily basis. Visitors can learn more about games of all sorts, plus read reviews and news in the same domain. The blog also covers the world of tech and entertainment.</p><p><strong>Main topics covered</strong>: PlayStation, Nintendo, Xbox, PC/MAC, mobile, news, reviews<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: collaborations, advertising<br><strong>The most popular post</strong>: <a href=\"https://attackofthefanboy.com/articles/five-nintendo-switch-games-we-want-to-see-more-of-at-e3-2021/\">Five Nintendo Switch Games We Want to See More of at E3 2021</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/attackofthefanboy/?hl=en\">@attackofthefanboy</a></p><h3><strong>5. </strong><a href=\"https://nichegamer.com/\"><strong>Niche Gamer</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/NicheGamer.jpg\" alt=\"Niche Gamer Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/NicheGamer.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/NicheGamer-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/NicheGamer-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/NicheGamer-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/NicheGamer-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>Brandon Orselli is the person behind Niche Gamer, a true gamer, game design student, activist, and tech wiz. His blog covers all types of games, and it even has a dedicated tech section that will help you with anything you might need. If you’re into unusual games, this is the blog to find more about them.</p><p><strong>Main topics covered</strong>: PC, Xbox, mobile, Nintendo, PlayStation, news, reviews, previews<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: collaborations, advertising, product sales<br><strong>The most popular post</strong>: <a href=\"https://nichegamer.com/2021/04/23/only-1-6-of-cyberpunk-2077-copies-refunded-cost-cd-projekt-9-of-2020-total-game-revenue/\">Only 1.6% of Cyberpunk 2077 Copies Refunded; Cost CD Projekt 9% of 2020 Total Game Revenue</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/nichegamer/?hl=en\">@nichegamer</a></p><h3><strong>6. </strong><a href=\"https://www.gameinformer.com/\"><strong>Game Informer</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GameInformer.jpg\" alt=\"Game Informer Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GameInformer.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameInformer-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameInformer-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameInformer-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameInformer-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>Game Informer is an online magazine that features everything gaming-related. So, it’s not a surprise that the site also comes with a dedicated blog. Here, interested readers can find out everything there is to know about games, including Xbox, PlayStation, GTA, etc. Plus, the site also reviews and writes posts about general entertainment.</p><p><strong>Main topics covered</strong>: news, reviews, guides, features, video, hubs, magazine, entertainment<br><strong>Built with</strong>: Drupal<br><strong>The main source of income</strong>: collaborations, advertising, product sales<br><strong>The most popular post</strong>: <a href=\"https://www.gameinformer.com/2021/05/04/xbox-game-pass-adds\">Xbox Game Pass Adds 15 New Games Starting Today</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/gameinformermagazine/\">@gameinformermagazine</a></p><h3><strong>7. </strong><a href=\"https://thegamefanatics.com/\"><strong>The Game Fanatics</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/TheGameFanatics.jpg\" alt=\"The Game Fanatics Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/TheGameFanatics.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/TheGameFanatics-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/TheGameFanatics-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/TheGameFanatics-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/TheGameFanatics-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>The Game Fanatics describe themselves as a diverse community of geek creators. What more can you ask from a gaming blog? You can learn everything you need to know about Mortal Kombat and similar games from these friendly faces. They also do video game reviews, so you can follow their YouTube channel for more content.</p><p><strong>Main topics covered</strong>: video game and gadget reviews, movies, TV, cosplay, anime comics<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, collaborations<br><strong>The most popular post</strong>: <a href=\"https://thegamefanatics.com/hitman-3s-season-of-pride-is-live/\">Hitman 3’s Season of Pride is Live</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/thegamefanatics/?hl=en\">@thegamefanatics</a></p><h3><strong>8. </strong><a href=\"https://gnomestew.com/\"><strong>Gnome Stew</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GnomeStew.jpg\" alt=\"Gnome Stew Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GnomeStew.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/GnomeStew-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/GnomeStew-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/GnomeStew-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/GnomeStew-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>Gnome Stew is another group of gaming fanatics with immense knowledge about the industry. You’ll find anything from bite-sized articles to full-on reviews on the site, featuring some of the most intriguing games out there. You can also join their podcast or even become a writer for the team.</p><p><strong>Main topics covered</strong>: editorials, game making, game mastering, news, reviews<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, collaborations, product sales<br><strong>The most popular post</strong>: <a href=\"https://gnomestew.com/where-to-draw-the-line-on-horror-gaming/\">Where To Draw the Line on Horror Gaming</a></p><h3><strong>9. </strong><a href=\"https://blog.playstation.com/\"><strong>PlayStation.Blog</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationBlog1.jpg\" alt=\"PlayStation.Blog Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationBlog1.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationBlog1-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationBlog1-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationBlog1-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationBlog1-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>This blog is the official PlayStation blog that features all PS-related news, including PS4, PS5, PS VR, and more. If PlayStation is your main point of interest, this is as close as it gets to discover all of the latest information about this global gaming leader.</p><p><strong>Main topics covered</strong>: PlayStation<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, collaborations, advertising, product sales<br><strong>The most popular post</strong>: <a href=\"https://blog.playstation.com/2021/05/19/story-driven-2d-action-exploration-game-reina-jericho-coming-to-ps5/\">Story-Driven 2D Action-Exploration Game Reina & Jericho Coming to PS5</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/playstation/\">@playstation</a></p><h3><strong>10. </strong><a href=\"https://www.playstationlifestyle.net/\"><strong>PlayStation Lifestyle</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationLifestyle.jpg\" alt=\"PlayStation Lifestyle Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationLifestyle.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationLifestyle-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationLifestyle-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationLifestyle-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/PlayStationLifestyle-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>As you can guess by the name, this blog is dedicated to hardcore PlayStation fans. It was created by die-hard PlayStation fans for the same audience. The blog provides unbiased coverage of all PS-related news. It also features glimpses about other topics.</p><p><strong>Main topics covered</strong>: PS5, PS4, PS VR, PSLS originals<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, collaborations, advertising<br><strong>The most popular post</strong>: <a href=\"https://www.playstationlifestyle.net/2021/05/17/report-starfield-ps5-exclusive-xbox-pc/\">Report: Bethesda’s Starfield is Exclusive to Xbox and PC, Won’t Be Coming to PlayStation</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/playstationlifestyledotnet/\">@playstationlifestyledotnet</a></p><h3><strong>11. </strong><a href=\"https://www.vg247.com/\"><strong>VG24/7</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/VG24-7.jpg\" alt=\"VG24/7 Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/VG24-7.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/VG24-7-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/VG24-7-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/VG24-7-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/VG24-7-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>VG24/7 has been delivering video game justice (as they call it) since 2008. The site posts dozens of articles every day about reviews, guides, or something else. The content is fresh and abundant. Here, you’ll find coverage of a diverse selection of games, from GTA to the Pokemon series.</p><p><strong>Main topics covered</strong>: PlayStation, Nintendo, Xbox, PC, GTA, Pokemon, Animal Crossing, reviews, guides<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, collaborations, advertising<br><strong>The most popular post</strong>: <a href=\"https://www.vg247.com/2021/05/19/last-us-part-2-performance-patch-ps5-targets-60-fps/\">The Last of Us Part 2 Performance Patch for PS5 Targets 60 FPS</a></p><h3><strong>12. </strong><a href=\"https://www.thesixthaxis.com/\"><strong>The Sixth Axis</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/TheSixthAxis.jpg\" alt=\"The Sixth Axis Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/TheSixthAxis.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/TheSixthAxis-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/TheSixthAxis-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/TheSixthAxis-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/TheSixthAxis-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>The Sixth Axis is one of those blogs that share regular posts about everything gaming-related. You can expect a couple of posts every day relating to anything you need to know about news relating to video and mobile games. You’ll also come across some entertainment stories relating to the gaming world.</p><p><strong>Main topics covered</strong>: PlayStation, Nintendo, Xbox, PC/MAC, mobile, news, reviews, previews, movies, books, TV<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://www.thesixthaxis.com/2021/05/18/r-type-final-2-review/\">R-Type Final 2 Review</a></p><h3><strong>13. </strong><a href=\"https://www.destructoid.com/\"><strong>Destructoid</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/Destructoid.jpg\" alt=\"Destructoid Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/Destructoid.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/Destructoid-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/Destructoid-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/Destructoid-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/Destructoid-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>This blog was started in 2006 by the cartoonist and author Yanier Gonzales. The blog posts around 50 posts every day, and has been one of the first to break the news on major news and launches. Enthusiast Gaming bought the site in 2017, but it still runs just as well as it did in its glory days. You can expect to learn a lot about the latest developments in the iGaming world here.</p><p><strong>Main topics covered</strong>: reviews, features, PC games<br><strong>Built with</strong>: N/A<br><strong>The main source of income</strong>: affiliate marketing, advertising, collaborations<br><strong>The most popular post</strong>: <a href=\"https://www.destructoid.com/stories/which-marvel-characters-would-you-like-to-see-in-their-own-game--628993.phtml\">Which Marvel Characters Would You Like to See in Their Own Game?</a><br><strong>Instagram</strong>: <a href=\"https://www.instagram.com/destructoid/?hl=en\">@destructoid</a></p><h3><strong>14. </strong><a href=\"https://www.rockpapershotgun.com/\"><strong>Rock Paper Shotgun</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/RockPaperShotgun1.jpg\" alt=\"Rock Paper Shotgun Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/RockPaperShotgun1.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/RockPaperShotgun1-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/RockPaperShotgun1-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/RockPaperShotgun1-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/RockPaperShotgun1-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>Rock Paper Shotgun is a UK-based website with the latest news and guides primarily related to PC games. The blog operated independently from 2007 until 2017 when it was bought by the Gamer Network. Don’t worry; the blog still posts regularly and you get all of the info you need about video, indie, simulation, tabletop, and more games, including news, projects, and reviews.</p><p><strong>Main topics covered</strong>: news, reviews, hardware, features, guides<br><strong>Built with</strong>: N/A<br><strong>The main source of income</strong>: affiliate marketing, advertising, collaborations, product sales<br><strong>The most popular post</strong>: <a href=\"https://www.rockpapershotgun.com/why-do-you-all-want-to-hump-garrus-so-much\">Why Do You All Want to Hump Garrus so Much?</a><br><strong>Instagram</strong>: <a href=\"https://www.instagram.com/rockpapershot/?hl=en\">@rockpapershot</a></p><h3><strong>15. </strong><a href=\"http://toucharcade.com/\"><strong>Touch Arcade</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/TouchArcade.jpg\" alt=\"Touch Arcade Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/TouchArcade.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/TouchArcade-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/TouchArcade-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/TouchArcade-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/TouchArcade-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>It would be safe to say that Touch Arcade covers mostly iOS-related content. The flourishing gaming market that is the iOS system is closely followed and reported on by specialists at Touch Arcade. You’ll get the latest news, previews, and game reviews available for the iOS platform.</p><p><strong>Main topics covered</strong>: gaming news and reviews, hot games, product reviews<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, donations, advertising, collaborations<br><strong>The most popular post</strong>: <a href=\"https://toucharcade.com/2021/05/19/pubg-new-state-android-closed-alpha-registrations-ios-pre-orders-to-begin-soon-krafton/\">‘PUBG: New State’ Closed Alpha Registrations to Begin in a Few Days, iOS Pre-Orders to Go Live Very Soon</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/toucharcadeofficial/?hl=en\">@toucharcadeofficial</a></p><h3><strong>16. </strong><a href=\"https://www.eurogamer.net/\"><strong>Euro Gamer</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/EuroGamer.jpg\" alt=\"Euro Gamer Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/EuroGamer.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/EuroGamer-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/EuroGamer-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/EuroGamer-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/EuroGamer-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>This global site has been covering the latest news about video games since 1999. Its primary focus was PC games, but it has since switched to covering every aspect of gaming, including console and indie games, board games, and anything else the knowledgeable team finds interesting, including PlayStation, Xbox, Nintendo, and more.</p><p><strong>Main topics covered</strong>: video games, tech<br><strong>Built with</strong>: N/A<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://www.eurogamer.net/articles/digitalfoundry-2021-resident-evil-village-tech-review\">Resident Evil Village Tech Review: Capcom Transitions Beautifully to Next-Gen</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/eurogamerofficial/?hl=en\">@eurogamerofficial</a></p><h3><strong>17. </strong><a href=\"https://www.droidgamers.com/\"><strong>Droid Gamers</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/DroidGamers.jpg\" alt=\"Droid Gamers Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/DroidGamers.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/DroidGamers-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/DroidGamers-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/DroidGamers-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/DroidGamers-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>As you might have guessed by the name, this blog is all about Android games. Knowledgeable writers about everything Android-related are behind it, so you can bookmark the site if you’re an avid Android user. It covers everything you need regarding gaming on Android devices, including game news, reviews, previews, and more.</p><p><strong>Main topics covered</strong>: news, reviews, features, Android games<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://www.droidgamers.com/2021/02/21/android-gaming-headlines-warhammer-40k-star-wars-hunter-polytopia-and-more/\">Android Gaming Headlines: Warhammer 40k, Star Wars: Hunter, Polytopia, and More</a></p><h3><strong>18. </strong><a href=\"https://monstervine.com/\"><strong>MonsterVine</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/MonsterVine.jpg\" alt=\"MonsterVine Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/MonsterVine.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/MonsterVine-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/MonsterVine-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/MonsterVine-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/MonsterVine-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>William Saw and James Cobb created this site in 2008 with the goal of providing the latest gaming reviews, news, previews, features, and commentary. Both founders are incredibly passionate about gaming, so you know MonsterVine is the real deal. </p><p><strong>Main topics covered</strong>: video game reviews, previews, features, news, podcast<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://monstervine.com/2021/05/resident-evil-village-review-im-lycan-this-direction/\">Resident Evil Village Review – I’m Lycan This Direction</a></p><h3><strong>19. </strong><a href=\"https://www.gameogre.com/\"><strong>GameOgre</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GameOgre.jpg\" alt=\"GameOgre Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GameOgre.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameOgre-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameOgre-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameOgre-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameOgre-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>GameOgre is one of the few online blogs that only cover MMO and indie games. If you’re into these types of games, you won’t find a better online community than this one. You can also take part in multiple group sessions and take advantage of frequent giveaways.</p><p><strong>Main topics covered</strong>: MMO games, indie games, news, reviews<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising, product sales, collaborations<br><strong>The most popular post</strong>: <a href=\"https://www.gameogre.com/heres-consider-using-vpns-gaming-online/\">Here’s Why You Should Consider Using VPNs When Gaming Online</a></p><h3><strong>20. </strong><a href=\"https://www.cgmagonline.com/\"><strong>CGM</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/CGM.jpg\" alt=\"CGM Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/CGM.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/CGM-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/CGM-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/CGM-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/CGM-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>This site started as a Canadian print publication in 2010 but has since moved online. CGM explores the culture and news of gaming, comics, and movies — something that all geeks enjoy. With a clean-cut site, you won’t go wrong if you decide to follow it for the latest news about DC or Fortnite.</p><p><strong>Main topics covered</strong>: tech, gaming, entertainment, news, reviews<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://www.cgmagonline.com/2021/05/20/ps5-outsold-xbox-series-xs/\">PS5 Estimated To Have Outsold Xbox Series X|S by More Than Double</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/cgmagonline/?hl=en\">@cgmagonline</a></p><h3><strong>21. </strong><a href=\"https://www.gamepur.com/\"><strong>Gamepur</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/Gamepur.jpg\" alt=\"Gamepur Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/Gamepur.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/Gamepur-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/Gamepur-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/Gamepur-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/Gamepur-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>Gamepur started in 2010 as a passion project for a couple of hardcore gaming fans. Today, it is a place where you go to find out the latest news and developments in the video game industry. You can also get help from expert guides when it comes to playing games.</p><p><strong>Main topics covered</strong>: news, features, guides, reviews<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://www.gamepur.com/features/seven-interesting-details-we-noticed-playing-the-resident-evil-village-demo\">Seven interesting details we noticed playing the Resident Evil Village demo</a></p><h3><strong>22. </strong><a href=\"https://www.geekysweetie.com/\"><strong>Geeky Sweetie</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GeekySweetie.jpg\" alt=\"Geeky Sweetie Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GeekySweetie.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/GeekySweetie-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/GeekySweetie-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/GeekySweetie-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/GeekySweetie-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>This blog creator had a particular thing in mind when creating this site — to create a place for geeky and sweet things that girls are interested in. That’s what you can find here — a lot of game reviews, but also anime, manga, toys, gadgets, and more. The site is quite cute to look at, and the design is user-friendly. </p><p><strong>Main topics covered</strong>: anime RPG game news and reviews for girls<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising, collaborations<br><strong>The most popular post</strong>: <a href=\"https://www.geekysweetie.com/flipped-in-love-anime-dressup-game-review/\">Flipped In Love Anime Dressup Game Review</a></p><h3><strong>23. </strong><a href=\"https://www.gematsu.com/\"><strong>Gematsu</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/Gematsu.jpg\" alt=\"Gematsu Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/Gematsu.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/Gematsu-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/Gematsu-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/Gematsu-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/Gematsu-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>Gematsu covers all video gaming news and information while focusing primarily on Japan. Don’t worry; the site is not in Japanese, so you’re good to go. If you’re interested in such content, this is the right place for you. The reporting is straightforward, and it has been since the blog was founded in 2008.</p><p><strong>Main topics covered</strong>: PlayStation, Xbox, PC, mobile, arcade, reviews, news<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising, collaborations<br><strong>The most popular post</strong>: <a href=\"https://www.gematsu.com/2021/05/deep-silver-announces-reformation-of-free-radical-design-to-develop-next-timesplitters-game\">Deep Silver announces reformation of Free Radical Design to develop next TimeSplitters game</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/gematsucom/?hl=en\">@gematsucom</a></p><h3><strong>24. </strong><a href=\"https://www.intoindiegames.com/\"><strong>Into Indie Games</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/IntoIndieGames.jpg\" alt=\"Into Indie Games Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/IntoIndieGames.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/IntoIndieGames-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/IntoIndieGames-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/IntoIndieGames-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/IntoIndieGames-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>If you’re interested in indie game development, you’ve just found your favorite blog. The content creators cover everything related to the indie gaming industry, so you won’t have to worry about missing out on any news. You can even apply to write an article for their blog if that’s something you’re interested in.</p><p><strong>Main topics covered</strong>: features, reviews, previews, news, walkthroughs<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising, collaborations<br><strong>The most popular post</strong>: <a href=\"https://www.intoindiegames.com/how-to-find-the-rarest-most-overlooked-indie-games-to-play/\">How To Find the Rarest, Most Overlooked Indie Games To Play</a></p><h3><strong>25. </strong><a href=\"https://www.gamespew.com/\"><strong>GameSpew</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GameSpew.jpg\" alt=\"GameSpew Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GameSpew.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameSpew-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameSpew-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameSpew-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameSpew-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>Two lifelong gamers and friends in the UK decided to start a blog in 2015 to turn their passion into something productive. Now, GameSpew is one of the most popular blogs visited by a couple of hundred thousand people every day. You can find gaming-related news daily, plus learn something tech-wise that might interest you.</p><p><strong>Main topics covered</strong>: features, reviews, previews, news, guides, tech<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://www.gamespew.com/2021/05/days-gone-pc-review/\">Days Gone PC Review</a></p><h3><strong>26. </strong><a href=\"https://purenintendo.com/\"><strong>Pure Nintendo</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/PureNintendo.jpg\" alt=\"Pure Nintendo Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/PureNintendo.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/PureNintendo-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/PureNintendo-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/PureNintendo-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/PureNintendo-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>If you’re interested in staying updated on all things Nintendo-related, this is your blog. The creators put out daily posts about anything you might need to know about Nintendo. You can also read useful things about Wii and 3DS.</p><p><strong>Main topics covered</strong>: Nintendo reviews and news<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://purenintendo.com/pn-review-citizens-of-earth-3ds/\">PN Review: Citizens of Earth (3DS)</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/purenintendo/\">@purenintendo</a></p><h3><strong>27. </strong><a href=\"https://n4g.com/\"><strong>N4G</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/N4G.jpg\" alt=\"N4G Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/N4G.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/N4G-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/N4G-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/N4G-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/N4G-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>N4G is part of the NewsBoiler network of social news sites. This blog operates a bit differently when compared to the blogs that you’re used to. Namely, you get to post news stories along with participating in discussions once you become a regular member. This is the perfect opportunity for any bloggers-to-be to give the blogging world a chance.</p><p><strong>Main topics covered</strong>: PS5, PS4, Xbox, Xbox One, PC, Switch<br><strong>Built with</strong>: N/A<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://n4g.com/news/2415246/microsoft-calls-the-last-of-us-2-significantly-ahead-of-anything-on-console-and-pc-in-leaked-review\">Microsoft Calls The Last of Us 2 “Significantly Ahead” of Anything on Console & PC in Leaked Review</a></p><h3><strong>28. </strong><a href=\"https://www.fanatical.com/en/blog\"><strong>Fanatical Blog</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/FanaticalBlog.jpg\" alt=\"Fanatical Blog Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/FanaticalBlog.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/FanaticalBlog-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/FanaticalBlog-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/FanaticalBlog-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/FanaticalBlog-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>Fanatical Blog is a virtual place where gamers write about games for other gamers. You’ll get all of the latest info about video games and tech. This blog publishes news about games like Mario Kart and FIFA, so you know you’re in for a diverse ride. </p><p><strong>Main topics covered</strong>: gaming, news<br><strong>Built with</strong>: N/A<br><strong>The main source of income</strong>: affiliate marketing, advertising, sponsorships, product sales<br><strong>The most popular post</strong>: <a href=\"https://www.fanatical.com/en/blog/best-new-pc-game-releases-for-summer-2021\">The Best New PC Game Releases for Summer 2021</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/wearefanatical/?hl=en\">@wearefanatical</a></p><h3><strong>29. </strong><a href=\"https://gamecritics.com/\"><strong>Game Critics</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GameCritics.jpg\" alt=\"Game Critics Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GameCritics.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameCritics-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameCritics-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameCritics-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/GameCritics-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>If you’re interested in getting insightful, entertaining, and useful gaming content from a diverse collection of authors, Game Critics is the blog for you. With around 17 content creators, this blog posts regular reviews and news about video games, including Nintendo, Xbox, and other major providers, but also some smaller and less-known names.</p><p><strong>Main topics covered</strong>: PlayStation, Nintendo, reviews, news, arcade, Xbox<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://gamecritics.com/c-j-salcedo/luckslinger-review/#comment-18411\">Luckslinger Review</a></p><h3><strong>30. </strong><a href=\"https://www.pcinvasion.com/\"><strong>PC Invasion</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/PCInvasion.jpg\" alt=\"PC Invasion Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/PCInvasion.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/PCInvasion-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/PCInvasion-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/PCInvasion-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/PCInvasion-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>PC Invasion was created in 2015 with the idea to make PC gaming fans feel more included. The blog provides cutting-edge content, updated a few times a day. You can learn more about gaming itself, get the latest news, and keep up with the current PC gaming tech.</p><p><strong>Main topics covered</strong>: PC-related game news, reviews, guides, features<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://www.pcinvasion.com/male-viera-final-fantasy-xiv-endwalker/\">Male Viera coming to Final Fantasy XIV in Endwalker</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/pc.invasion/?hl=en\">@pc.invasion</a></p><h3><strong>31. </strong><a href=\"https://gamingbolt.com/\"><strong>Gaming Bolt</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GamingBolt.jpg\" alt=\"Gaming Bolt Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/GamingBolt.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/GamingBolt-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/GamingBolt-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/GamingBolt-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/GamingBolt-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>Gaming Bolt prides itself on being a site built for gamers by gamers. Readers can discover the latest gaming-related news and reviews on the go, including access to a gaming community online. The blog also covers all major gaming events, so you’ll get the latest scoop on them as well.</p><p><strong>Main topics covered</strong>: PlayStation, Xbox, Wii, Switch, 3DS, Mac, iOS, news, reviews, guides<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising, collaborations<br><strong>The most popular post</strong>: <a href=\"https://gamingbolt.com/top-10-mass-effect-squadmates\">Top 10 Mass Effect Squadmates</a></p><h3><strong>32. </strong><a href=\"https://www.alphabetagamer.com/\"><strong>Alpha Beta Gamer</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/AlphaBetaGamer.jpg\" alt=\"Alpha Beta Gamer Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/AlphaBetaGamer.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/AlphaBetaGamer-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/AlphaBetaGamer-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/AlphaBetaGamer-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/AlphaBetaGamer-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>This blog is a bit different than all of the rest that I’ve listed as it mostly deals with free video game alpha and beta tests. What’s more, the site proudly displays its title as the world’s biggest beta testing site. You’ll also find links to download the latest games here. </p><p><strong>Main topics covered</strong>: mainstream and indie games, iOS and Android games<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising, collaborations<br><strong>The most popular post</strong>: <a href=\"https://www.alphabetagamer.com/resident-evil-reverse-open-beta-playstation-xbox-steam/\">Resident Evil Re: Verse – Open Beta (Playstation, Xbox & Steam)</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/alpha_beta_gamer/?hl=en\">@alpha_beta_gamer</a></p><h3><strong>33. </strong><a href=\"https://blog.amigaguru.com/\"><strong>AmigaGuru</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/AmigaGuru.jpg\" alt=\"AmigaGuru Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/AmigaGuru.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/AmigaGuru-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/AmigaGuru-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/AmigaGuru-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/AmigaGuru-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>Tony Aksnes is the name behind AmigaGuru, and he describes himself as a retro gamer. So, you can expect to learn a lot from his blog as he is truly dedicated to gaming. He started the blog with his friend Gianluca Girelli in hopes of bringing gaming closer to everyone.</p><p><strong>Main topics covered</strong>: PlayStation, arcade, Nintendo, SEGA, free-to-play games<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising, collaborations<br><strong>The most popular post</strong>: <a href=\"https://blog.amigaguru.com/the-games-we-never-talk-about-wendetta-2175\">The Games We Never Talk About: Wendetta 2175</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/the_amiga_guru/\">@the_amiga_guru</a></p><h3><strong>34. </strong><a href=\"https://techraptor.net/\"><strong>TechRaptor</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/TechRaptor.jpg\" alt=\"TechRaptor Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/TechRaptor.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/TechRaptor-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/TechRaptor-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/TechRaptor-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/TechRaptor-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>TechRaptor is a blog committed to helping people get the most out of digital and physical games. It also covers a wide range of gaming news, reviews, and gives honest opinions about questions that every gamer has thought about at least once.</p><p><strong>Main topics covered</strong>: video games, news, reviews, features<br><strong>Built with</strong>: Drupal<br><strong>The main source of income</strong>: affiliate marketing, advertising<br><strong>The most popular post</strong>: <a href=\"https://techraptor.net/gaming/opinions/wheres-wario-unrealized-potential-of-wario-land\">Where’s Wario? – The Unrealized Potential of Wario Land</a><br><strong>Instagram account</strong>: <a href=\"https://www.instagram.com/tech_raptor/?hl=en\">@tech_raptor</a></p><h3><strong>35. </strong><a href=\"https://novacrystallis.com/\"><strong>Nova Crystallis</strong></a></h3><p><img src=\"https://firstsiteguide.com/wp-content/uploads/2021/06/NovaCrystallis.jpg\" alt=\"Nova Crystallis Homepage\" srcset=\"https://firstsiteguide.com/wp-content/uploads/2021/06/NovaCrystallis.jpg 1688w, https://firstsiteguide.com/wp-content/uploads/2021/06/NovaCrystallis-300x144.jpg 300w, https://firstsiteguide.com/wp-content/uploads/2021/06/NovaCrystallis-1024x491.jpg 1024w, https://firstsiteguide.com/wp-content/uploads/2021/06/NovaCrystallis-768x369.jpg 768w, https://firstsiteguide.com/wp-content/uploads/2021/06/NovaCrystallis-1536x737.jpg 1536w\" sizes=\"100vw\" width=\"1688\"></p><p>If you’re an avid gamer, you can probably guess by the blog’s name that this is a strictly Final Fantasy-related blog. If that’s your cup of tea, you’ll find all of the important information, news, and reviews on this site. It’s a great online community for all Final Fantasy fans.</p><p><strong>Main topics covered</strong>: Final Fantasy-related news and content<br><strong>Built with</strong>: WordPress<br><strong>The main source of income</strong>: affiliate marketing, advertising, collaborations<br><strong>The most popular post</strong>: <a href=\"https://novacrystallis.com/2021/05/final-fantasy-vii-remake-details-episode-intermissions-fort-condor-minigame-characters-and-new-summon/\">Final Fantasy VII Remake Details Episode Intermission’s Fort Condor Minigame, Characters and New Summon</a></p><h2><strong>Conclusion</strong></h2><p>Hopefully, you’ll find what you’re looking for among some of these blogs. Whether you’re a gaming geek in search of your next favorite blog or an ambitious gamer with hopes of becoming the next big thing in the blogging world, the information listed here is worthwhile. You’ll also come across many blogs that will introduce you to the latest happenings in this extremely competitive industry. So, start your engines and reach your goals with help from this article.</p>', 'gaming, entertainment', 0, 'published', 1);
INSERT INTO `posts` (`post_id`, `post_category_id`, `post_title`, `post_author`, `post_date`, `post_image`, `post_content`, `post_tags`, `post_comment_count`, `post_status`, `post_view_count`) VALUES
(69, 39, 'How to Answer “Why Are You a Great Match for This Role?” Without Feeling Like You’re Bragging', 'john', '2021-10-19', 'inter.jpg', '<p>In any interview, your ultimate goal is to show that you’re a great match for the job. But you still might get thrown for a loop if you’re asked point blank <i>why</i> you’re such an ideal candidate. An <a href=\"https://www.themuse.com/advice/interview-questions-and-answers\">interview question</a> like “What makes you a great match for this role?” or “Why are you a good candidate for this position?” can catch you off guard—isn’t it your interviewer’s job to decide whether you’re a great match?</p><p>An alternate phrasing like, “<a href=\"https://www.themuse.com/advice/3-better-ways-to-answer-why-should-we-hire-you\">Why should we hire you?</a>” or, “Why are you the <i>best </i>candidate for this job?” could further throw you—how can you know if you’re the <i>best</i>? You may think you’re well suited for the job, but you don’t know who the other candidates are, so you might feel uncomfortable declaring yourself the top choice. Besides, so many people find it hard to boast about themselves, even in a job interview.</p><p>But in reality, you don’t need to objectively prove that you’re the number one candidate in every way. Instead, interviewers are looking to see that you’ve put thought into how you’d thrive in this job and understand how you’re uniquely qualified for the position, says Muse career coach <a href=\"https://www.themuse.com/coaches/elena-pastore\">Elena Pastore</a>, who <a href=\"https://elenapastore.com/\">focuses</a> on leadership coaching and career development. (If you’re still looking for jobs to apply and interview for, you can find <a href=\"https://www.themuse.com/search\">search thousands of open roles on The Muse</a>!)</p><p><strong>Why Do Interviewers Ask Why You’re a Great Match or Candidate for a Role?</strong></p><p>When they’re considering whether you’re the right person to fill a position, interviewers “want to see if you fully understand what they are seeking in a new hire,” Pastore says. “Or they may want to see if you can clearly articulate your competitive advantage as an applicant.”</p><p>Recruiters and hiring managers can only do so much on their own when it comes to lining up your background with the job. When interviewers ask this question, they want to know that the interviewee has connected the dots between their skills and the requirements of the role, says Muse career coach <a href=\"https://www.themuse.com/coaches/tara-goodfellow-mba-ctacc\">Tara Goodfellow</a>, owner of <a href=\"https://www.consultathena.com/\">Athena Consultants</a>.</p><p>Often when working with clients, Pastore finds that they’re not struggling in their job searches because they’re not a strong match for a role, but because “they do not know how to clearly articulate their value in a resume or interview.” Show that you’ve taken the time to really understand what <i>you </i>specifically will bring to their workplace. Not only will it tell employers what they’ll get from hiring you, but it will also demonstrate that you care enough about the position to really consider it.</p><p>Additionally, interviewers are looking for an applicant who is confident in their ability to perform, Goodfellow says. Your answer to this question can communicate that you can do the job—and that you <i>know</i> you can do the job and why. After all, confident employees will often need less oversight and spend less time second-guessing themselves.</p><p><strong>5 Tips for Crafting an Answer That Reflects You and the Company</strong></p><p>If you want to be prepared to answer this question well, there are a few tips you should follow:</p><h3><strong>1. Understand What the Company Needs</strong></h3><p>Again, interviewers want to know that you understand what the company is looking for—both for this specific position and for any employee on their team. You can’t answer this question if you don’t first know exactly what a great match for the role would be. So study the job posting and <a href=\"https://www.themuse.com/advice/the-ultimate-guide-to-researching-a-company-preinterview\">research the company</a> ahead of your interview—and check out their <a href=\"https://www.themuse.com/companies\">Muse profile</a> if they have one. Don’t be afraid to network on <a href=\"https://www.themuse.com/advice/linkedin-profile-tips\">LinkedIn</a>, Pastore says. You can reach out to the company’s recruiters and current employees to really “get a feel for the team,” Goodfellow says, and glean any internal insights into what the company is looking for.</p><p>Also, remember that your answer isn’t set in stone. This question often comes up toward the end of an interview, so you can incorporate things you’ve learned during the conversation (or during any earlier interview sessions or <a href=\"https://www.themuse.com/advice/phone-screen-definition-preparation\">phone screens</a>). “I always recommend jotting down comments during the interview (and [asking] if that’s OK),” Goodfellow says. Pay close attention to anything that sounds especially important to the role, and incorporate these “clues” in your answer. Maybe they emphasized a big upcoming project they need this person to lead or they mentioned that the team has an issue with keeping their digital files organized and accessible. “You want to show you have been an <a href=\"https://www.themuse.com/advice/what-is-active-listening-definition-examples\">active listener</a>, connect with the position, and are <i>the</i> person for the role,” Goodfellow says.</p><h3><strong>2. Determine How You’re </strong><i><strong>Uniquely</strong></i><strong> Qualified</strong></h3><p>Once you know what a company needs, you can figure out how you fit the bill. With your answer you’ll want to “try to demonstrate why you’ll succeed in the role [and] be a value add to the team—and why you’re excited for the role,” Goodfellow says. So think about it: What pain points are you going to solve in the job? What additional skills do you bring to the team or company beyond the requirements of the job description? Do you have a unique perspective on the industry or the company’s product? Are you aligned with the company’s values in a way that will help you thrive, support the mission, and add to the culture?</p><p>“Go beyond a simple response such as, ‘I do X skill in my current role,’ or, ‘I have experience in X, so I am equipped to take on this role,’” Pastore says. “The same can be true for many other candidates.” Instead, you want to give an answer that blends your current and past experiences, unique skills, and personal passions and interests in a way that’s specific to the company and unique to you. For example, Pastore once worked with a client with sales and marketing experience who was also a retired professional athlete. He was applying to a role at an athletic equipment company, so he was able to show how he was a great match because he not only had the professional background, but had also used the company’s products and understood what customers were looking for.</p><p>This answer is also a spot to address concerns, Goodfellow says. For example, if an interviewer seems concerned that you don’t have experience in a certain software skill, you could mention a related program you’ve used or talk about how quickly you pick up new tech.</p><h3><strong>3. Incorporate Examples</strong></h3><p>It’s not enough to just know what qualities and traits you want to mention. “Don’t just rattle [off] a bunch of adjectives,” Goodfellow says. “Stories resonate much better than just listing all of the skills for the position.”</p><p>So wherever possible, you want to work examples into your answer. “Examples are always great because they not only are unique to you but they also give great context and insight,” Pastore says. Strong examples will back up what you’re saying and help you stand out from the pack. What’s more memorable: “I’m detail oriented,” or, “I once managed to find the one error in our thousands of lines of source code that was making our application fail to run”?</p><p>Come to your interview prepared with several <a href=\"https://www.themuse.com/advice/6-types-of-stories-you-should-have-on-hand-for-job-interviews\">stories</a> that demonstrate different skills and qualities, so that you can select the most relevant one (or ones) to incorporate into your answer to this question. You can structure it using the STAR method, Goodfellow says, and you can read more about exactly how to do that <a href=\"https://www.themuse.com/advice/star-interview-method\">here</a>.</p><h3><strong>4. Keep It Concise</strong></h3><p>For your answer, Goodfellow recommends sharing around three reasons you’re a great match for the role. “Make it memorable but not a long list of things,” she says. This doesn’t necessarily mean going through three full examples structured with the STAR method, though. You’ll need to make sure you’re not rambling on. For example, you might use one story to emphasize two key skills you bring to the role, or briefly remind your interviewer of something you spoke of earlier that makes you a good candidate.</p><p>For all of your points, Pastore suggests, “Only provide information that is relevant and necessary for the interviewer to understand your response. Avoid going off on tangents, providing too much information, or being too vague.”</p><h3><strong>5. Don’t Be Afraid to Toot Your Own Horn</strong></h3><p>You may be reading all this advice and worrying that you’ll have trouble pulling it off without feeling like you’re bragging or being cocky. “Many people are very uncomfortable answering this [question] because it feels boastful to them,” Goodfellow says. But don’t worry. Interviewers are looking for hires who are confident in their skills, and job interviews are meant for showing off your accomplishments.</p><p>However, if you’re someone who has trouble talking themselves up, you can:</p><ul><li><strong>Mention how others have praised your skills and found them useful. </strong>For example, saying, “My managers always came to me as the X resource,” makes your answer a bit more objective than, “I am so organized...” Goodfellow says.</li><li><strong>Back your points up with examples, details, and numbers. </strong>Rather than saying something like, “I was one of the best sales development reps on my team,” cite some numbers or other details to back yourself up. For example, “I averaged 32 new meetings booked a month compared to the overall team average of 21.” This is also where your examples come in. A story about how you organized a big group project shows your interviewer your leadership skills, so they can see for themselves how you arrived at the assessment that you’re “a good leader.”</li><li><strong>Make objective connections to the role. </strong>If you know that a company or team is looking to launch a new project or struggles in a certain area, for example, you can mention these things and then talk about how you might be able to help based on what you’ve done before. If you find it hard to brag about yourself, simply stating a few facts about your background may come more easily to you.</li></ul><p><i><strong>Read More: </strong></i><a href=\"https://www.themuse.com/advice/brag-better-meredith-fineman\"><i>Why You Should “Brag Better” to Help Your Career—and How You Can Get Started Today</i></a></p><p><strong>What Does an Answer to This Question Look Like?</strong></p><p>If you want to see how this advice might come together, check out these example answers. But remember that any answer to this question should be highly specific to you and the role you’re interviewing for.</p><p>For example a designer might say:</p><p><i>“I’m a great match for this role because not only do I have the experience in designing logos, websites, and other graphics for tech companies, but you can also see from my portfolio that my preferred style is very similar to your brand’s. Earlier when you mentioned that the original logo came from graffiti art influences like Lady Pink, I got so excited I almost interrupted you. In college, I did my senior project on her work and studied her use of shape and color to evoke emotion. She’s definitely one of my major influences to this day and being able to bring that part of my art to work with me each day would be a dream come true. And it would help me deliver results more efficiently, since I’m using the style I’m most comfortable and experienced with.</i></p><p><i>“You also mentioned that the first project for this role would likely be the design work for a marketing campaign to raise awareness for the new “individual” subscription tier for your software that has more features than the free plan, but fewer than the “pro” plan designed for multiple users. I was with my last company when we did a similar product launch, and as someone who uses software designed for businesses in my freelance work, I was really able to share my insights on what draws me to different productivity programs and makes me willing to spend money on an individual license. The graphics I designed for social media brought in over 500 conversions in the first month after launch alone. So I’d love to take what I learned from that project and apply it here.”</i></p><p>An entry-level candidate for a administrative assistant role could give an answer like:</p><p><i>“We’ve already talked about my experience as a staff assistant at my university’s admissions office, but I think that one area we haven’t touched on as much is how much multitasking and priority juggling I had to do in that role. For instance, one day, I was responsible for organizing mailers to be sent out to high school students, but at the last minute, I was asked by someone else to go help with check-in at a recruitment event that was short staffed. My manager—who’d told me to work on the mailers—wasn’t in the office, but I knew that an in-progress event took precedence, so I went, and when I returned, I was able to seek help from a coworker to still finish up the mailers on time. My manager was impressed by my judgement and initiative, which from what you’ve mentioned, will come in handy in this job when I may have competing requests from a number of departments and employees.</i></p><p><i>“I also spent four years in a community service club during school, and we often organized after-school tutoring and childcare sessions for events, so I know some of the logistics that go into planning events for kids. During my senior year, I was the club’s treasurer who was responsible for budgeting, planning, and booking our volunteer trips, which would help me book travel for employees and manage event logistics as needed. Plus, I was in charge of tracking the money we spent and reporting it to the university as well as reimbursing members who paid for things out of pocket, so I’ll be able to handle expense reports and similar tasks with ease.”</i></p>', 'interview, career, productivity', 0, 'published', 4),
(70, 38, 'Natwar Singh writes on champion of the downtrodden Dr BR Ambedkar', 'john', '2021-10-19', 'amb.jpg', '<p>The author of the book \'Ambedkar\', is a member of The Planning Commission, an establishment totally or almost totally lacking creativity, innovation or imagination. Professor Jadhav is a distinguished exception. He studied in the United States, obtaining PhD in Economics. The last worthwhile book on Ambedkar was written by Dr. Dhananjay Keer. It was published in 1954. Dr. B.R. Ambedkar was arguably among the most brilliant Indian intellectuals of the 20th century. His life is a triumph of character over circumstances.</p><figure class=\"image\"><img src=\"https://smedia2.intoday.in/indiatoday/images/stories/2014March/natwar-2-4_032314022240.jpg\" alt=\"\"></figure><p>He,for the first thirty five years of his life was subjected to the most appalling humiliations, brutal discrimination and indignities for being an untouchable. The dice was loaded against him right from his birth.</p><p>He was born in a Mahar family on 14 April 1893. He died at the age of fifty six on 6th December 1956. He made it to the Elphiston College in Bombay. He could neither buy books nor clothes. He was lent books by one of his professors who also gave him clothes.</p><p>At the age of 22, he was given scholarship by the enlightened Gaikward of Baroda, which enable him to join Columbia University in New York. He passed his M.A and obtained a PhD with high distinction. Similarly he did exceptionally at the London School of Economics. THE LOT of the untouchables in India were worse then that of Negros (Blacks) in America.</p><p>This was a blot on Hinduism which outraged Gandhiji. He called them Harijans, now referred to as Dalits. Ambedkar considered Gandhi\'s approach to the problem of untouchability and untouchables both flawed and wooly. The two clashed at the second Round Table Conference in 1931. Ambedkar denigrated Gandhi in sharp language. \"Unfortunately, the Congress chose Mr. Gandhi as its representative.</p><figure class=\"image\"><img src=\"https://smedia2.intoday.in/indiatoday/images/stories/2014March/natwar-1-3_032314022240.jpg\" alt=\"\"></figure><p>It was only in the nineteen eighties that Ambedkar attained legendary status. He is today the second most popular after Gandhi but his dream of a caste-free India remains unfulfilled.</p><p>A worse person could not have been chosen to guide India\'s destiny. As a unifying force he was failure. Mr. Gandhi presents him as a man of humility. But his behavior at the Round Table Conference showed that in the flush of victory Mr. Gandhi could be petty minded.\" Gandhi petty minded!! Well, well. Throughout their lives, the Mahatma and the Mahar could never see eye to eye on the vital issue of caste/ untouchability. The year 1942 was a defining year for both. On July 2, 1942 Dr. Ambedkar was appointed Labour minister in the Executive Council (cabinet of the Viceroy). He thus became a high profile member of the Raj establishment. It was an example of a good man fallen among thieves. On 8th August 1942 Gandhiji launched the Quit India movement at Bombay. The next day he and his colleagues in the Congress were arrested. On 10th February 1943 Gandhi went on a three week fast in the Agha Khan Palace Prison in Poona. He almost died. Three Indians of the Executive Council resigned- M.S. Aney, N.R. Sarkar and Homi Mode against the Viceroy\'s obduracy about realising Gandhi.</p><p>Dr. Ambedkar did not. Not only that. In June 1945 his seminal book, \"What Congress and Gandhi Have Done to the Untouchables\" came out. It is a well argued, well prepared obsessional book. On 15th August 1947, Jawaharlal Nehru included Ambedkar as Law Minister in his cabinet. Both Gandhiji and Sardar Patel supported Ambedkar\'s inclusion. Nehru and Patel appointed him Chairman of the Drafting Committee of the Constitution.</p>', 'news, ambedkar', 0, 'draft', 2);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`user_id` int NOT NULL,
`username` varchar(255) NOT NULL DEFAULT '',
`user_firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`user_lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`user_email` varchar(255) NOT NULL,
`user_password` varchar(255) NOT NULL,
`user_image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
`user_role` varchar(255) NOT NULL,
`randSalt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '$2y$10$iusesomecrazystrings22'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`user_id`, `username`, `user_firstname`, `user_lastname`, `user_email`, `user_password`, `user_image`, `user_role`, `randSalt`) VALUES
(26, 'naveen', 'Naveen', 'Kumar', 'naveen@gmail.com', '$2y$10$IZenwYj7KnJacbZmHxnTveVLhF1DvUY5T8dy9irGukA53p6Daf45e', '', 'admin', '$2y$10$iusesomecrazystrings22'),
(39, 'aayush', 'Aayush', 'Gupta', 'aayush@gmail.com', '$2y$10$YTXT40PxCB9Sy/vYIWmcMup1wF7lJBYMafxE11QZpmaL9suUj1QHO', NULL, 'subscriber', '$2y$10$iusesomecrazystrings22'),
(40, 'bhanu', 'Bhanu Pratap', 'Singh', 'bhanu@gmail.com', '$2y$10$fktvTRI1cBICMTFzfObfh.CkG7eoIgq5KR9ukJ3SN2pxBi.5VjyCm', NULL, 'subscriber', '$2y$10$iusesomecrazystrings22'),
(41, 'john', 'John', 'Doe', 'johndoe@gmail.com', '$2y$10$BX3KXF02Q4isFpooirqNn.ooayEx.cRiPR.5tmROGt/bLJcx27CU.', NULL, 'subscriber', '$2y$10$iusesomecrazystrings22'),
(42, 'alice', 'Alice', 'Ray', 'alice@gmail.com', '$2y$10$uSrLEezamuXX3C/JpDr5MepUkp4qwoGX4rD3cbeQquImiRsHDG5Di', NULL, 'subscriber', '$2y$10$iusesomecrazystrings22');
-- --------------------------------------------------------
--
-- Table structure for table `users_online`
--
CREATE TABLE `users_online` (
`id` int NOT NULL,
`session` varchar(255) NOT NULL,
`time` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- Dumping data for table `users_online`
--
INSERT INTO `users_online` (`id`, `session`, `time`) VALUES
(8, 'aotcbptv18abb7jb19l31dc8ou', 1633283033),
(9, 'ivacndf6p40efj62h38fgu3pu4', 1633319193),
(10, 'o5ejrdvdslf29qsnv0640scmr3', 1633492293);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
ADD PRIMARY KEY (`cat_id`);
--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
ADD PRIMARY KEY (`comment_id`);
--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
ADD PRIMARY KEY (`post_id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`user_id`);
--
-- Indexes for table `users_online`
--
ALTER TABLE `users_online`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
MODIFY `cat_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;
--
-- AUTO_INCREMENT for table `comments`
--
ALTER TABLE `comments`
MODIFY `comment_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
MODIFY `post_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `user_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;
--
-- AUTO_INCREMENT for table `users_online`
--
ALTER TABLE `users_online`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;