-
Notifications
You must be signed in to change notification settings - Fork 0
/
tables.txt
170 lines (149 loc) · 54 KB
/
tables.txt
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
CREATE TABLE IF NOT EXISTS `e107_games` (
`id` int(50) NOT NULL AUTO_INCREMENT,
`Title` text NOT NULL,
`Slug` text NOT NULL,
`NewsTags` text NOT NULL,
`NewsTagsSELECTED` text NOT NULL,
`NewsIds` text NOT NULL,
`NewsIdsSelected` text NOT NULL,
`Category` text NOT NULL,
`CategorySELECTED` text NOT NULL,
`Known` text NOT NULL,
`Region` text NOT NULL,
`Year` text NOT NULL,
`Developer` text NOT NULL,
`Platform` text NOT NULL,
`platformSelected` text NOT NULL,
`ReleaseDate` text NOT NULL,
`ReviewIDs` text NOT NULL,
`reviewSelected` text NOT NULL,
`Players` text NOT NULL,
`Series` text NOT NULL,
`ReleaseDate2` text NOT NULL,
`Review` text NOT NULL,
`UserSays` text NOT NULL,
`UserSaysFull` text NOT NULL,
`Content` text NOT NULL,
`Media` text NOT NULL,
`Screenshot1` text NOT NULL,
`Screenshot2` text NOT NULL,
`Screenshot3` text NOT NULL,
`Screenshot4` text NOT NULL,
`Screenshot5` text NOT NULL,
`Screenshot6` text NOT NULL,
`test` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
INSERT INTO `e107_games` (`id`, `Title`, `Slug`, `NewsTags`, `NewsTagsSELECTED`, `NewsIds`, `NewsIdsSelected`, `Category`, `CategorySELECTED`, `Known`, `Region`, `Year`, `Developer`, `Platform`, `platformSelected`, `ReleaseDate`, `ReviewIDs`, `reviewSelected`, `Players`, `Series`, `ReleaseDate2`, `Review`, `UserSays`, `UserSaysFull`, `Content`, `Media`, `Screenshot1`, `Screenshot2`, `Screenshot3`, `Screenshot4`, `Screenshot5`, `Screenshot6`, `test`) VALUES
(1, 'test 1', 'test-1', 'kolmas', 'Test,kolmas', '', '', 'platformer', 'FPS,horror,platformer', 'test', 'test', 'test', 'test', 'PS4', 'PS4', 'test', '', '', 'test', 'test', 'test', 'test', 'test', 'test', 'lühidalt', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal.png', '', '', '', '', 'test'),
(2, 'test 2', 'test-2', '', '', '', '', '', '', '2', '2', '2', '2', '', '', '2', '', '', '2', '2', '2', '2', '2', '2', '2', '{e_MEDIA_IMAGE}2020-04/gears5hero.jpg', '', '', '', '', '', '', '2'),
(3, 'test 3', 'test-3', '', '', '', '', '', '', 'test', 'test', 'test', 'test', '', '', 'test', '', '', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal.png', '', '', '', '', 'test'),
(4, 'test 4', 'test-4', '', '', '', '', '', '', '2', '2', '2', '2', '', '', '2', '', '', '2', '2', '2', '2', '2', '2', '2', '{e_MEDIA_IMAGE}2020-04/gears5hero.jpg', '', '', '', '', '', '', '2'),
(6, 'test 5', 'test-5', 'welcome', 'welcome', '', '', 'FPS', 'FPS', 'test', 'test', 'test', 'test', 'XONE', 'PS4,XONE', 'test', '', '', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal.png', '', '', '', '', 'test'),
(7, 'test 6', 'test-6', '', '', '', '', '', '', '2', '2', '2', '2', '', '', '2', '', '', '2', '2', '2', '2', '2', '2', '2', '{e_MEDIA_IMAGE}2020-04/gears5hero.jpg', '', '', '', '', '', '', '2'),
(8, 'test 77', 'test-7', 'Test', 'Test', '', '', '', '', 'test', 'test', 'test', 'test', '', '', 'test', '', '', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal.png', '', '', '', '', 'test'),
(9, 'test 8', 'test-8', '', '', '', '', '', '', '2', '2', '2', '2', '', '', '2', '', '', '2', '2', '2', '2', '2', '2', '2', '{e_MEDIA_IMAGE}2020-04/gears5hero.jpg', '', '', '', '', '', '', '2'),
(13, 'test 9', 'test-9', '', '', '', '', 'horror', 'horror', 'test', 'test', 'test', 'test', 'XONE', 'PS4,XONE', 'test', '', '', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal.png', '', '', '', '', 'test'),
(14, 'test 10', 'test-10', 'test Abcd', 'test Abcd', '', '', '', '', '2', '2', '2', '2', '', '', '2', '', '', '2', '2', '2', '2', '2', '2', '2', '{e_MEDIA_IMAGE}2020-04/gears5hero.jpg', '', '', '', '', '', '', '2'),
(15, 'test 11', 'test-11', '', '', '', '', '', '', 'test', 'test', 'test', 'test', '', '', 'test', '', '', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal.png', '{e_MEDIA_IMAGE}2020-09/IAT_Crash_Bandicoot.png', '', '', '', 'test'),
(16, 'test 12', 'test-12', '', '', '', '', 'platformer', 'platformer', '2', '2', '2', '2', 'PS4', 'PS4', '2', '', '', '2', '2', '2', '2', '2', '2', '2', '{e_MEDIA_IMAGE}2020-04/gears5hero.jpg', '', '', '', '', '', '', '2'),
(17, 'test 13', 'test-13', '', '', '', '', 'FPS', 'FPS', 'test', 'test', 'test', 'test', 'XONE', 'PS4,XONE', 'test', '', '', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal.png', '', '', '', '', 'test'),
(18, 'test 14', 'test-14', '', '', '', '', 'FPS', 'FPS', '2', '2', '2', '2', 'XONE', 'XONE', '2', '', '', '2', '2', '2', '2', '2', '2', '2', '{e_MEDIA_IMAGE}2020-04/gears5hero.jpg', '', '', '', '', '', '', '2'),
(19, 'test 15', 'test-15', 'welcome', 'welcome', '', '', '', '', 'test', 'test', 'test', 'test', '', '', 'test', '', '', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal_.png', '{e_MEDIA_IMAGE}2020-04/220px-Cover_Art_of_Doom_Eternal.png', '', '', '', '', 'test'),
(20, 'test 16', 'test-16', 'test Abcd', 'test Abcd', '', '', 'platformer', 'FPS,platformer', '2', '2', '2', '2', 'PS4', 'PS4', '2', '', '', '2', '2', '2', '2', '2', '2', '2', '{e_MEDIA_IMAGE}2020-04/gears5hero.jpg', '', '', '', '', '', '', '2');
CREATE TABLE IF NOT EXISTS `e107_games_categories` (
`gameCatID` int(11) NOT NULL AUTO_INCREMENT,
`gameCatName` text NOT NULL,
PRIMARY KEY (`gameCatID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
INSERT INTO `e107_games_categories` (`gameCatID`, `gameCatName`) VALUES
(1, 'FPS'),
(2, 'horror'),
(3, 'platformer');
CREATE TABLE IF NOT EXISTS `e107_games_platforms` (
`platform_id` int(50) NOT NULL AUTO_INCREMENT,
`platform_name` text NOT NULL,
PRIMARY KEY (`platform_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
INSERT INTO `e107_games_platforms` (`platform_id`, `platform_name`) VALUES
(1, 'PS4'),
(2, 'XONE');
CREATE TABLE IF NOT EXISTS `e107_games_reviews` (
`ID` int(50) NOT NULL AUTO_INCREMENT,
`Title` text NOT NULL,
`ReviewsGame` text NOT NULL,
`ReviewGameSelected` text NOT NULL,
`UniqueReviewTitle` text NOT NULL,
`Content` text NOT NULL,
`Description` text NOT NULL,
`ReviewType` text NOT NULL,
`TheGood` text NOT NULL,
`TheBad` text NOT NULL,
`Rating` text NOT NULL,
`Image` text NOT NULL,
`Member` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
INSERT INTO `e107_games_reviews` (`ID`, `Title`, `ReviewsGame`, `ReviewGameSelected`, `UniqueReviewTitle`, `Content`, `Description`, `ReviewType`, `TheGood`, `TheBad`, `Rating`, `Image`, `Member`) VALUES
(1, 'test', '20', '1,13,20', '', '[html]<p>There's no easing into making a competitive game in 2020. Already inundated with games like Overwatch, Rainbow Six Siege, the battle royales, the MOBAs, and the auto chesses, players have plenty of choices, so if you want to present an alternative, it had better be ready for prime time. <a href="https://www.gamespot.com/bleeding-edge/" data-ref-id="5000-497654">Bleeding Edge</a>, the new third-person competitive brawler from DmC developer Ninja Theory, doesn't feel like it's there yet. There's plenty of potential: Its four-on-four scrums blend the mashy feeling of an old school beat-em-up with the tactical considerations of MOBAs and hero shooters, setting it apart from anything you're going to find in popular competitive scenes. However, it suffers from "early days" growing pains that may push players away, rather than draw them in.</p>\r\n<p>Bleeding Edge is a self-described competitive multiplayer "brawler," but what does that actually mean? Depending on your point of reference, you could call it a "boots on the ground-style MOBA" or a "third-person hero shooter." It's an action game where two teams of four fight within the narrative framework of competing in one of two team sports--a King of the Hill-style "Objective Control" scenario and "Power Collection," a resource-hoarding mode where players need to break energy canisters and return their contents to designated points at specific times. Though the two variants have their quirks, both boil down to dynamic point control. Whether you're delivering energy or protecting your "hills," you need to defend a position. If you're trying to block your enemy from scoring in either mode, you need to take a position.</p>\r\n<div data-embed-type="video" data-ref-id="2300-6452556" data-src="/videos/lets-play-bleeding-edge/2300-6452556/" data-width="100%" data-height="100%" data-video-start="0"><iframe width="100%" height="100%" src="https://www.gamespot.com/videos/embed/6452556/" scrolling="no" webkitallowfullscreen="webkitallowfullscreen" mozallowfullscreen="mozallowfullscreen" allowfullscreen="allowfullscreen" frameborder="0"></iframe></div>\r\n<p>Both of these things require all four players to work as a team. Though some fighters are better suited for one-on-one combat than others, moving and fighting as a squad is mandatory because the team with larger numbers almost always wins, regardless of skill. Inevitably, each match becomes a series of teamfights for control of an area. In the moment, these battles can feel a bit mashy and sloppy as you rapidly jam on the attack button, but there's a good deal of strategy involved around creating favorable matchups, combining skills to maximize damage dealt and minimize damage taken, and positioning yourself to avoid wide-reaching crowd control attacks. On top of that, all of the levels present some kind of environmental hazard around one or more of the key points on the map, which can throw a wrench in the gears of the most pivotal moments in a match.</p>\r\n<p>The caveat, though, is that everyone needs to "play their class" as expected. With only four people to a team, having even one person who isn't paying attention to the objective or using their skills to help the team can drain the fun out of the game very quickly. This turns matchmaking into a bit of a crapshoot. You never know whether you're going to get teammates who know the score, or will drop everything to start fights, or play the objective too hard and ignore the team. Despite a warning when you turn on the game for the first time that communication is important, only a handful of players used headsets in my experience. While there is an Apex Legends-style ping system that works pretty well for silent players, many players don't pay attention to it. Even with solid communication options, the rigid demands of the gameplay make it easy for a single uncooperative person to spoil the match for the rest.</p>\r\n<p>When you get eight situationally aware players, though, there's a lot to love. The characters-- their design and balance--are the best part of Bleeding Edge. From the conventionally cool graffiti-artist street samurai Daemon to Maeve, the cyberpunk witch, to Cass, an emo assassin with robotic bird legs, each of the 11 characters in the initial roster has a distinctive and interesting look.</p>\r\n<p>More importantly, they also have a set of abilities that makes them especially well-suited to their specific kind of play. In modern competitive fashion, each character has a unique set of stats and rechargeable special moves that make them useful in a specific context, which really only presents itself when coordinating with your teammates. The characters are broken up into three classes--Damage, Support, Tank--but each character's approach to the role is unique. For example, Buttercup--a human-motorcycle hybrid--is a Tank made for crowd control: She forces enemies to engage with her by dragging enemies to her with a grappling hook and use an "oil slick" ability to slow them down. By contrast, fellow Tank El Bastardo is slightly less durable but deals more damage thanks to a very powerful standard attack and a crowd-clearing spin attack that will push enemies away from him. It takes a little practice to fully understand those distinctions well enough to take advantage of them, but it's easy to see how each fighter works.</p>\r\n<figure data-align="center" data-size="large" data-img-src="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653105-my great capture screenshot 2020-04-07 16-59-30.png" data-ref-id="1300-3653105" data-ratio="0.5625" data-width="1920" data-embed-type="image" style="width: 1920px;"><a class="fluid-height" style="padding-bottom: 56.3%;" href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653105-my%20great%20capture%20screenshot%202020-04-07%2016-59-30.png" data-ref-id="1300-3653105">[img width=0]https://gamespot1.cbsistatic.com/uploads/scale_super/1575/15759911/3653105-my great capture screenshot 2020-04-07 16-59-30.png[/img]</a></figure>\r\n<figure data-embed-type="gallery" data-img-src="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653116-my great capture screenshot 2020-04-07 15-23-16.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653117-my great capture screenshot 2020-04-07 15-24-03.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653118-my great capture screenshot 2020-04-07 15-26-20.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653119-my great capture screenshot 2020-04-07 15-26-38.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653120-my great capture screenshot 2020-04-07 15-30-15.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653121-my great capture screenshot 2020-04-07 15-31-27.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653122-my great capture screenshot 2020-04-07 15-33-44.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653123-my great capture screenshot 2020-04-07 15-34-55.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653124-my great capture screenshot 2020-04-07 15-35-24.png" data-ref-id="1300-3653116,1300-3653117,1300-3653118,1300-3653119,1300-3653120,1300-3653121,1300-3653122,1300-3653123,1300-3653124" data-resize-urls="https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653116-my great capture screenshot 2020-04-07 15-23-16.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653117-my great capture screenshot 2020-04-07 15-24-03.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653118-my great capture screenshot 2020-04-07 15-26-20.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653119-my great capture screenshot 2020-04-07 15-26-38.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653120-my great capture screenshot 2020-04-07 15-30-15.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653121-my great capture screenshot 2020-04-07 15-31-27.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653122-my great capture screenshot 2020-04-07 15-33-44.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653123-my great capture screenshot 2020-04-07 15-34-55.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653124-my great capture screenshot 2020-04-07 15-35-24.png"><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653116-my%20great%20capture%20screenshot%202020-04-07%2015-23-16.png" data-ref-id="1300-3653116">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653116-my great capture screenshot 2020-04-07 15-23-16.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653117-my%20great%20capture%20screenshot%202020-04-07%2015-24-03.png" data-ref-id="1300-3653117">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653117-my great capture screenshot 2020-04-07 15-24-03.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653118-my%20great%20capture%20screenshot%202020-04-07%2015-26-20.png" data-ref-id="1300-3653118">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653118-my great capture screenshot 2020-04-07 15-26-20.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653119-my%20great%20capture%20screenshot%202020-04-07%2015-26-38.png" data-ref-id="1300-3653119">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653119-my great capture screenshot 2020-04-07 15-26-38.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653120-my%20great%20capture%20screenshot%202020-04-07%2015-30-15.png" data-ref-id="1300-3653120">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653120-my great capture screenshot 2020-04-07 15-30-15.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653121-my%20great%20capture%20screenshot%202020-04-07%2015-31-27.png" data-ref-id="1300-3653121">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653121-my great capture screenshot 2020-04-07 15-31-27.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653122-my%20great%20capture%20screenshot%202020-04-07%2015-33-44.png" data-ref-id="1300-3653122">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653122-my great capture screenshot 2020-04-07 15-33-44.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653123-my%20great%20capture%20screenshot%202020-04-07%2015-34-55.png" data-ref-id="1300-3653123">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653123-my great capture screenshot 2020-04-07 15-34-55.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653124-my%20great%20capture%20screenshot%202020-04-07%2015-35-24.png" data-ref-id="1300-3653124">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653124-my great capture screenshot 2020-04-07 15-35-24.png[/img]</a></figure>\r\n<p>There's even a little room for customization: Between matches, you can equip a set of mods--which you can earn by playing with specific characters or buy with in-game currency--to amplify your stats and skills in different ways. If you consider one attack or special ability more important than the others, you can min-max those boons to accommodate your playstyle. Each character begins with a set of default mods, so there is an inherent feeling of trading emphases, rather than building power over time. Customization in competitive multiplayer games is often a fool's gambit--many games destroy their balance with overpowerful gear--but Bleeding Edge's mods thread the needle. They're powerful to punctuate specific skills, without making them unstoppable.</p>\r\n<p>While each character is well-balanced individually, the roster as a whole feels unbalanced at times. Given that you only have four players on each team, it's easy to get forced into a specific role or even a specific character. With 11 characters (and one more announced fighter on the way), there are a limited number of choices at each position. On top of that, certain characters fill the role better than others. Zerocool, the hacker, is the only pure healer, for example. Unless teammates use the other two support characters in tandem, it's hard to justify not picking him when playing that role. The lack of choice can be frustrating: In matchmaking, it can make you feel obligated to play as a character you don't like and may lead to you playing out of character, which isn't very fun.</p>\r\n<p>We should also address the hyper-intelligent 800-pound gorilla in the room. Bleeding Edge cribs a lot from Overwatch. Though unique and clever, the character designs collectively exude the same faux-Pixar veneer as the Overwatch cast. Then again, they cut it pretty close sometimes. Mekko, the 12th Bleeding Edge character, is a dolphin controlling a giant robot, which sounds a lot like Wrecking Ball, Overwatch's Hamster in a giant robot. On a technical level, both of Bleeding Edge's modes feel very similar to Overwatch's "Control." Don't get me wrong: King of the Hill is not unique to Overwatch by any means--multiplayer games have been riffing on the form for years--but the MOBA-esque skillsets of Bleeding Edge's characters lead you to approach those scenarios with hero shooter tactics.</p>\r\n<p>In some ways, building on the foundation created by other esports works to Bleeding Edge's advantage. Despite the fact that it's a new game with a lot of rules and idiosyncrasies to learn, it will quickly feel familiar and comfortable to fans of competitive games because so many of its gameplay elements, from game types to character abilities, are modeled off ideas from other games. No character takes long to learn, which means you're going to find your groove and start having fun quickly. And, ultimately, Bleeding Edge's third-person perspective and a roster with lots of melee and ranged fighters distinguishes itself from the rest of the pack. Once you start playing, it's easy to look past the things you recognize and appreciate the benefits of this new configuration.</p>\r\n<p>Still, for all that Bleeding Edge gets right, it really feels like the game's "early days." It’s missing crucial staples of competitive games, like ranked play, which allows you to invest the experience and keeps people playing, long-term. I'd like to believe Microsoft and Ninja Theory will keep tweaking and expanding the game so it can compete with other competitive multiplayer games, but right now it feels like a temporary multiplayer fix for players looking to break up the monotony, rather than the next esports obsession.</p>[/html]', 'eh', '', 'qerty\r\nghdfdgsf\r\ngsdgsdgsgsdg', 'sdgsdgs\r\nfdgsgs', '9', '{e_MEDIA_IMAGE}2020-04/gears5hero.jpg', ''),
(2, 'qwerty', '13', '13', '', '[html]<p>There's no easing into making a competitive game in 2020. Already inundated with games like Overwatch, Rainbow Six Siege, the battle royales, the MOBAs, and the auto chesses, players have plenty of choices, so if you want to present an alternative, it had better be ready for prime time. <a href="https://www.gamespot.com/bleeding-edge/" data-ref-id="5000-497654">Bleeding Edge</a>, the new third-person competitive brawler from DmC developer Ninja Theory, doesn't feel like it's there yet. There's plenty of potential: Its four-on-four scrums blend the mashy feeling of an old school beat-em-up with the tactical considerations of MOBAs and hero shooters, setting it apart from anything you're going to find in popular competitive scenes. However, it suffers from "early days" growing pains that may push players away, rather than draw them in.</p>\r\n<p>Bleeding Edge is a self-described competitive multiplayer "brawler," but what does that actually mean? Depending on your point of reference, you could call it a "boots on the ground-style MOBA" or a "third-person hero shooter." It's an action game where two teams of four fight within the narrative framework of competing in one of two team sports--a King of the Hill-style "Objective Control" scenario and "Power Collection," a resource-hoarding mode where players need to break energy canisters and return their contents to designated points at specific times. Though the two variants have their quirks, both boil down to dynamic point control. Whether you're delivering energy or protecting your "hills," you need to defend a position. If you're trying to block your enemy from scoring in either mode, you need to take a position.</p>\r\n<div data-embed-type="video" data-ref-id="2300-6452556" data-src="/videos/lets-play-bleeding-edge/2300-6452556/" data-width="100%" data-height="100%" data-video-start="0"><iframe width="100%" height="100%" src="https://www.gamespot.com/videos/embed/6452556/" scrolling="no" webkitallowfullscreen="webkitallowfullscreen" mozallowfullscreen="mozallowfullscreen" allowfullscreen="allowfullscreen" frameborder="0"></iframe></div>\r\n<p>Both of these things require all four players to work as a team. Though some fighters are better suited for one-on-one combat than others, moving and fighting as a squad is mandatory because the team with larger numbers almost always wins, regardless of skill. Inevitably, each match becomes a series of teamfights for control of an area. In the moment, these battles can feel a bit mashy and sloppy as you rapidly jam on the attack button, but there's a good deal of strategy involved around creating favorable matchups, combining skills to maximize damage dealt and minimize damage taken, and positioning yourself to avoid wide-reaching crowd control attacks. On top of that, all of the levels present some kind of environmental hazard around one or more of the key points on the map, which can throw a wrench in the gears of the most pivotal moments in a match.</p>\r\n<p>The caveat, though, is that everyone needs to "play their class" as expected. With only four people to a team, having even one person who isn't paying attention to the objective or using their skills to help the team can drain the fun out of the game very quickly. This turns matchmaking into a bit of a crapshoot. You never know whether you're going to get teammates who know the score, or will drop everything to start fights, or play the objective too hard and ignore the team. Despite a warning when you turn on the game for the first time that communication is important, only a handful of players used headsets in my experience. While there is an Apex Legends-style ping system that works pretty well for silent players, many players don't pay attention to it. Even with solid communication options, the rigid demands of the gameplay make it easy for a single uncooperative person to spoil the match for the rest.</p>\r\n<p>When you get eight situationally aware players, though, there's a lot to love. The characters-- their design and balance--are the best part of Bleeding Edge. From the conventionally cool graffiti-artist street samurai Daemon to Maeve, the cyberpunk witch, to Cass, an emo assassin with robotic bird legs, each of the 11 characters in the initial roster has a distinctive and interesting look.</p>\r\n<p>More importantly, they also have a set of abilities that makes them especially well-suited to their specific kind of play. In modern competitive fashion, each character has a unique set of stats and rechargeable special moves that make them useful in a specific context, which really only presents itself when coordinating with your teammates. The characters are broken up into three classes--Damage, Support, Tank--but each character's approach to the role is unique. For example, Buttercup--a human-motorcycle hybrid--is a Tank made for crowd control: She forces enemies to engage with her by dragging enemies to her with a grappling hook and use an "oil slick" ability to slow them down. By contrast, fellow Tank El Bastardo is slightly less durable but deals more damage thanks to a very powerful standard attack and a crowd-clearing spin attack that will push enemies away from him. It takes a little practice to fully understand those distinctions well enough to take advantage of them, but it's easy to see how each fighter works.</p>\r\n<figure data-align="center" data-size="large" data-img-src="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653105-my great capture screenshot 2020-04-07 16-59-30.png" data-ref-id="1300-3653105" data-ratio="0.5625" data-width="1920" data-embed-type="image" style="width: 1920px;"><a class="fluid-height" style="padding-bottom: 56.3%;" href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653105-my%20great%20capture%20screenshot%202020-04-07%2016-59-30.png" data-ref-id="1300-3653105">[img width=0]https://gamespot1.cbsistatic.com/uploads/scale_super/1575/15759911/3653105-my great capture screenshot 2020-04-07 16-59-30.png[/img]</a></figure>\r\n<figure data-embed-type="gallery" data-img-src="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653116-my great capture screenshot 2020-04-07 15-23-16.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653117-my great capture screenshot 2020-04-07 15-24-03.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653118-my great capture screenshot 2020-04-07 15-26-20.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653119-my great capture screenshot 2020-04-07 15-26-38.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653120-my great capture screenshot 2020-04-07 15-30-15.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653121-my great capture screenshot 2020-04-07 15-31-27.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653122-my great capture screenshot 2020-04-07 15-33-44.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653123-my great capture screenshot 2020-04-07 15-34-55.png,https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653124-my great capture screenshot 2020-04-07 15-35-24.png" data-ref-id="1300-3653116,1300-3653117,1300-3653118,1300-3653119,1300-3653120,1300-3653121,1300-3653122,1300-3653123,1300-3653124" data-resize-urls="https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653116-my great capture screenshot 2020-04-07 15-23-16.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653117-my great capture screenshot 2020-04-07 15-24-03.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653118-my great capture screenshot 2020-04-07 15-26-20.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653119-my great capture screenshot 2020-04-07 15-26-38.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653120-my great capture screenshot 2020-04-07 15-30-15.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653121-my great capture screenshot 2020-04-07 15-31-27.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653122-my great capture screenshot 2020-04-07 15-33-44.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653123-my great capture screenshot 2020-04-07 15-34-55.png,https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653124-my great capture screenshot 2020-04-07 15-35-24.png"><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653116-my%20great%20capture%20screenshot%202020-04-07%2015-23-16.png" data-ref-id="1300-3653116">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653116-my great capture screenshot 2020-04-07 15-23-16.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653117-my%20great%20capture%20screenshot%202020-04-07%2015-24-03.png" data-ref-id="1300-3653117">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653117-my great capture screenshot 2020-04-07 15-24-03.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653118-my%20great%20capture%20screenshot%202020-04-07%2015-26-20.png" data-ref-id="1300-3653118">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653118-my great capture screenshot 2020-04-07 15-26-20.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653119-my%20great%20capture%20screenshot%202020-04-07%2015-26-38.png" data-ref-id="1300-3653119">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653119-my great capture screenshot 2020-04-07 15-26-38.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653120-my%20great%20capture%20screenshot%202020-04-07%2015-30-15.png" data-ref-id="1300-3653120">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653120-my great capture screenshot 2020-04-07 15-30-15.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653121-my%20great%20capture%20screenshot%202020-04-07%2015-31-27.png" data-ref-id="1300-3653121">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653121-my great capture screenshot 2020-04-07 15-31-27.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653122-my%20great%20capture%20screenshot%202020-04-07%2015-33-44.png" data-ref-id="1300-3653122">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653122-my great capture screenshot 2020-04-07 15-33-44.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653123-my%20great%20capture%20screenshot%202020-04-07%2015-34-55.png" data-ref-id="1300-3653123">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653123-my great capture screenshot 2020-04-07 15-34-55.png[/img]</a><a href="https://gamespot1.cbsistatic.com/uploads/original/1575/15759911/3653124-my%20great%20capture%20screenshot%202020-04-07%2015-35-24.png" data-ref-id="1300-3653124">[img width=0]https://gamespot1.cbsistatic.com/uploads/square_avatar/1575/15759911/3653124-my great capture screenshot 2020-04-07 15-35-24.png[/img]</a></figure>\r\n<p>There's even a little room for customization: Between matches, you can equip a set of mods--which you can earn by playing with specific characters or buy with in-game currency--to amplify your stats and skills in different ways. If you consider one attack or special ability more important than the others, you can min-max those boons to accommodate your playstyle. Each character begins with a set of default mods, so there is an inherent feeling of trading emphases, rather than building power over time. Customization in competitive multiplayer games is often a fool's gambit--many games destroy their balance with overpowerful gear--but Bleeding Edge's mods thread the needle. They're powerful to punctuate specific skills, without making them unstoppable.</p>\r\n<p>While each character is well-balanced individually, the roster as a whole feels unbalanced at times. Given that you only have four players on each team, it's easy to get forced into a specific role or even a specific character. With 11 characters (and one more announced fighter on the way), there are a limited number of choices at each position. On top of that, certain characters fill the role better than others. Zerocool, the hacker, is the only pure healer, for example. Unless teammates use the other two support characters in tandem, it's hard to justify not picking him when playing that role. The lack of choice can be frustrating: In matchmaking, it can make you feel obligated to play as a character you don't like and may lead to you playing out of character, which isn't very fun.</p>\r\n<p>We should also address the hyper-intelligent 800-pound gorilla in the room. Bleeding Edge cribs a lot from Overwatch. Though unique and clever, the character designs collectively exude the same faux-Pixar veneer as the Overwatch cast. Then again, they cut it pretty close sometimes. Mekko, the 12th Bleeding Edge character, is a dolphin controlling a giant robot, which sounds a lot like Wrecking Ball, Overwatch's Hamster in a giant robot. On a technical level, both of Bleeding Edge's modes feel very similar to Overwatch's "Control." Don't get me wrong: King of the Hill is not unique to Overwatch by any means--multiplayer games have been riffing on the form for years--but the MOBA-esque skillsets of Bleeding Edge's characters lead you to approach those scenarios with hero shooter tactics.</p>\r\n<p>In some ways, building on the foundation created by other esports works to Bleeding Edge's advantage. Despite the fact that it's a new game with a lot of rules and idiosyncrasies to learn, it will quickly feel familiar and comfortable to fans of competitive games because so many of its gameplay elements, from game types to character abilities, are modeled off ideas from other games. No character takes long to learn, which means you're going to find your groove and start having fun quickly. And, ultimately, Bleeding Edge's third-person perspective and a roster with lots of melee and ranged fighters distinguishes itself from the rest of the pack. Once you start playing, it's easy to look past the things you recognize and appreciate the benefits of this new configuration.</p>\r\n<p>Still, for all that Bleeding Edge gets right, it really feels like the game's "early days." It’s missing crucial staples of competitive games, like ranked play, which allows you to invest the experience and keeps people playing, long-term. I'd like to believe Microsoft and Ninja Theory will keep tweaking and expanding the game so it can compete with other competitive multiplayer games, but right now it feels like a temporary multiplayer fix for players looking to break up the monotony, rather than the next esports obsession.</p>[/html]', 'eheheheh', '', 'qerty\r\nghdfdgsf\r\ngsdgsdgsgsdg', 'sdgsdgs\r\nfdgsgs', '1', '{e_MEDIA_IMAGE}2020-04/gears5hero.jpg', '');
CREATE TABLE IF NOT EXISTS `e107_game_comment` (
`commentID` int(50) NOT NULL AUTO_INCREMENT,
`commentUserID` text NOT NULL,
`postID` text NOT NULL,
`commentRating` text NOT NULL,
`commentPlatform` text NOT NULL,
`commentTitle` text NOT NULL,
`postComment` text NOT NULL,
`userImage` text NOT NULL,
`commentDate` text NOT NULL,
PRIMARY KEY (`commentID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
INSERT INTO `e107_game_comment` (`commentID`, `commentUserID`, `postID`, `commentRating`, `commentPlatform`, `commentTitle`, `postComment`, `userImage`, `commentDate`) VALUES
(1, '1', '1', '1', 'PS4', 'test', 'test<br>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '25-04-2020'),
(2, '1', '2', '1', 'Select Platform', '2', '<div>\r\n<h2>What is Lorem Ipsum?</h2>\r\n<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and\r\n typesetting industry. Lorem Ipsum has been the industry''s standard \r\ndummy text ever since the 1500s, when an unknown printer took a galley \r\nof type and scrambled it to make a type specimen book. It has survived \r\nnot only five centuries, but also the leap into electronic typesetting, \r\nremaining essentially unchanged. It was popularised in the 1960s with \r\nthe release of Letraset sheets containing Lorem Ipsum passages, and more\r\n recently with desktop publishing software like Aldus PageMaker \r\nincluding versions of Lorem Ipsum.</p>\r\n</div><div>\r\n<h2>Why do we use it?</h2>\r\n<p>It is a long established fact that a reader will be distracted by the\r\n readable content of a page when looking at its layout. The point of \r\nusing Lorem Ipsum is that it has a more-or-less normal distribution of \r\nletters, as opposed to using ''Content here, content here'', making it \r\nlook like readable English. Many desktop publishing packages and web \r\npage editors now use Lorem Ipsum as their default model text, and a \r\nsearch for ''lorem ipsum'' will uncover many web sites still in their \r\ninfancy. Various versions have evolved over the years, sometimes by \r\naccident, sometimes on purpose (injected humour and the like).</p>\r\n</div>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '25-04-2020'),
(3, '1', '19', '10', '', 'Lipsum', 'Test test test also test', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '27-04-2020'),
(4, '1', '3', '6', '', 'test', 'srtgsdgsdgad<br>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '08-05-2020'),
(5, '1', '20', '10', '', 'test', '<div>\r\n<h2>What is Lorem Ipsum?</h2>\r\n<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and\r\n typesetting industry. Lorem Ipsum has been the industry''s standard \r\ndummy text ever since the 1500s, when an unknown printer took a galley \r\nof type and scrambled it to make a type specimen book. It has survived \r\nnot only five centuries, but also the leap into electronic typesetting, \r\nremaining essentially unchanged. It was popularised in the 1960s with \r\nthe release of Letraset sheets containing Lorem Ipsum passages, and more\r\n recently with desktop publishing software like Aldus PageMaker \r\nincluding versions of Lorem Ipsum.</p>\r\n</div>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '08-05-2020'),
(6, '1', '4', '6', '', 'tegsdgsdvdvdv', 'xadvdsbdfngfndfb fsdgsdgsdg<br>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '08-05-2020'),
(7, '3', '1', '3', '', 'test', '<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and\r\n typesetting industry. Lorem Ipsum has been the industry''s standard \r\ndummy text ever since the 1500s, when an unknown printer took a galley \r\nof type and scrambled it to make a type specimen book. It has survived \r\nnot only five centuries, but also the leap into electronic typesetting, \r\nremaining essentially unchanged. It was popularised in the 1960s with \r\nthe release of Letraset sheets containing Lorem Ipsum passages, and more\r\n recently with desktop publishing software like Aldus PageMaker \r\nincluding versions of Lorem Ipsum.</p>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '12-05-2020'),
(8, '3', '14', '3', '', 'test', 'test<br>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '12-05-2020'),
(9, '1', '18', '6', '', 'Where does it come from?', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It\r\n has roots in a piece of classical Latin literature from 45 BC, making \r\nit over 2000 years old. Richard McClintock, a Latin professor at \r\nHampden-Sydney College in Virginia, looked up one of the more obscure \r\nLatin words, consectetur, from a Lorem Ipsum passage, and going through \r\nthe cites of the word in classical literature, discovered the \r\nundoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 \r\nof "de Finibus Bonorum et Malorum" (The Extremes of Good and Evil) by \r\nCicero, written in 45 BC. This book is a treatise on the theory of \r\nethics, very popular during the Renaissance. The first line of Lorem \r\nIpsum, "Lorem ipsum dolor sit amet..", comes from a line in section \r\n1.10.32.</p><p>The standard chunk of Lorem Ipsum used since the 1500s is\r\n reproduced below for those interested. Sections 1.10.32 and 1.10.33 \r\nfrom "de Finibus Bonorum et Malorum" by Cicero are also reproduced in \r\ntheir exact original form, accompanied by English versions from the 1914\r\n translation by H. Rackham.</p>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '13-05-2020'),
(10, '1', '8', '6', 'Select Platform', '', '<br>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '13-05-2020'),
(11, '1', '6', '10', '', 'njaah', 'ok<br>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '21-05-2020'),
(12, '1', 'i', '1', '', '', '<br>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '12-12-2020'),
(13, '1', 'i', '1', '', '', '<br>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '12-12-2020'),
(14, '1', 'i', '1', '', '', '<br>', 'http://algorithm.ee/e107_plugins/games/images/blank_avatar.jpg', '12-12-2020');
CREATE TABLE IF NOT EXISTS `e107_news` (
`news_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`news_title` varchar(255) NOT NULL DEFAULT '',
`news_sef` varchar(200) NOT NULL DEFAULT '',
`news_body` longtext NOT NULL,
`news_extended` longtext NOT NULL,
`news_meta_keywords` varchar(255) NOT NULL DEFAULT '',
`news_meta_description` text NOT NULL,
`news_datestamp` int(10) unsigned NOT NULL DEFAULT 0,
`news_author` int(10) unsigned NOT NULL DEFAULT 0,
`news_category` tinyint(3) unsigned NOT NULL DEFAULT 0,
`news_allow_comments` tinyint(3) unsigned NOT NULL DEFAULT 0,
`news_start` int(10) unsigned NOT NULL DEFAULT 0,
`news_end` int(10) unsigned NOT NULL DEFAULT 0,
`news_class` varchar(255) NOT NULL DEFAULT '0',
`news_render_type` varchar(20) NOT NULL DEFAULT '0',
`news_comment_total` int(10) unsigned NOT NULL DEFAULT 0,
`news_summary` text NOT NULL,
`news_thumbnail` text NOT NULL,
`news_sticky` tinyint(3) unsigned NOT NULL DEFAULT 0,
`news_template` varchar(50) DEFAULT NULL,
PRIMARY KEY (`news_id`),
KEY `news_category` (`news_category`),
KEY `news_start_end` (`news_start`,`news_end`),
KEY `news_datestamp` (`news_datestamp`),
KEY `news_sticky` (`news_sticky`),
KEY `news_render_type` (`news_render_type`),
KEY `news_class` (`news_class`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
INSERT INTO `e107_news` (`news_id`, `news_title`, `news_sef`, `news_body`, `news_extended`, `news_meta_keywords`, `news_meta_description`, `news_datestamp`, `news_author`, `news_category`, `news_allow_comments`, `news_start`, `news_end`, `news_class`, `news_render_type`, `news_comment_total`, `news_summary`, `news_thumbnail`, `news_sticky`, `news_template`) VALUES
(1, 'Welcome to e107', 'welcome-to-e107', '[html]<p>Lorem ipsum dolor sit amet, no meis semper dicunt est, petentium eloquentiam quo ne. At vero facer eam. Ex nam altera oportere, nisl natum prima id pro. Rebum augue dissentiet eum te, vel veniam eirmod option ea, at eos velit repudiare. Ius sumo dicit adolescens id, an cum efficiantur concludaturque.<br><br>Summo sensibus cum ne, et duo torquatos conceptam. No aeque elitr constituam qui. Nostro corpora nec no, diam verterem tincidunt has et. Altera accumsan urbanitas pro eu, ei assum voluptaria sed. Eam tibique nominavi consequuntur an.<br><br>Ei perfecto delicata usu, quo eius noster blandit te. Eu doctus volumus pri. Meis argumentum an nam, eos odio prima autem an. Te complectitur intellegebat pro, ius id alterum maiestatis. Ea facer accusata sed, ex illum antiopam quo.<br><br>Altera putent pri ad, in phaedrum dissentiunt per. Te eum everti dolores. Ut mea vero autem viderer, mel brute harum senserit id. Minim senserit eloquentiam duo in, sit ei justo graece petentium. Sea id homero oporteat invenire.<br><br>Pri semper dolorum ad. Cu eius repudiare eos. Eum in eleifend necessitatibus. Ne has mutat intellegebat.</p>[/html]', '[html]<p><strong>Lorem ipsum</strong> is a pseudo-Latin text used in web design, typography, layout, and printing in place of English to emphasise design elements over content. It's also called placeholder (or filler) text. It's a convenient tool for mock-ups. It helps to outline the visual elements of a document or presentation, eg typography, font, or layout. Lorem ipsum is mostly a part of a Latin text by the classical author and philosopher Cicero. Its words and letters have been changed by addition or removal, so to deliberately render its content nonsensical; it's not genuine, correct, or comprehensible Latin anymore.</p>\r\n<p>While <strong>lorem ipsum</strong>'s still resembles classical Latin, it actually has no meaning whatsoever. As Cicero's text doesn't contain the letters K, W, or Z, alien to latin, these, and others are often inserted randomly to mimic the typographic appearence of European languages, as are digraphs not to be found in the original.</p>[/html]', 'Test', 'Description for Facebook and search engines.', 1454367600, 1, 1, 0, 0, 0, '0', '0', 4, 'Summary of the news item', '{e_MEDIA_IMAGE}2020-05/news1_.jpg,,,,', 0, 'default'),
(2, 'Welcome to e107 First', 'welcome-to-e107', '[html]<p>Lorem ipsum dolor sit amet, no meis semper dicunt est, petentium eloquentiam quo ne. At vero facer eam. Ex nam altera oportere, nisl natum prima id pro. Rebum augue dissentiet eum te, vel veniam eirmod option ea, at eos velit repudiare. Ius sumo dicit adolescens id, an cum efficiantur concludaturque.<br><br>Summo sensibus cum ne, et duo torquatos conceptam. No aeque elitr constituam qui. Nostro corpora nec no, diam verterem tincidunt has et. Altera accumsan urbanitas pro eu, ei assum voluptaria sed. Eam tibique nominavi consequuntur an.<br><br>Ei perfecto delicata usu, quo eius noster blandit te. Eu doctus volumus pri. Meis argumentum an nam, eos odio prima autem an. Te complectitur intellegebat pro, ius id alterum maiestatis. Ea facer accusata sed, ex illum antiopam quo.<br><br>Altera putent pri ad, in phaedrum dissentiunt per. Te eum everti dolores. Ut mea vero autem viderer, mel brute harum senserit id. Minim senserit eloquentiam duo in, sit ei justo graece petentium. Sea id homero oporteat invenire.<br><br>Pri semper dolorum ad. Cu eius repudiare eos. Eum in eleifend necessitatibus. Ne has mutat intellegebat.</p>[/html]', '[html]<p><strong>Lorem ipsum</strong> is a pseudo-Latin text used in web design, typography, layout, and printing in place of English to emphasise design elements over content. It's also called placeholder (or filler) text. It's a convenient tool for mock-ups. It helps to outline the visual elements of a document or presentation, eg typography, font, or layout. Lorem ipsum is mostly a part of a Latin text by the classical author and philosopher Cicero. Its words and letters have been changed by addition or removal, so to deliberately render its content nonsensical; it's not genuine, correct, or comprehensible Latin anymore.</p>\r\n<p>While <strong>lorem ipsum</strong>'s still resembles classical Latin, it actually has no meaning whatsoever. As Cicero's text doesn't contain the letters K, W, or Z, alien to latin, these, and others are often inserted randomly to mimic the typographic appearence of European languages, as are digraphs not to be found in the original.</p>[/html]', 'welcome,test Abcd', 'Description for Facebook and search engines.', 1609159212, 1, 1, 0, 0, 0, '0', '0', 4, 'Summary of the news item', '{e_MEDIA_IMAGE}2020-05/news1.jpg,,,,', 0, 'default'),
(3, 'Kolmas', 'welcome-to-e107', '[html]<p>Lorem ipsum dolor sit amet, no meis semper dicunt est, petentium eloquentiam quo ne. At vero facer eam. Ex nam altera oportere, nisl natum prima id pro. Rebum augue dissentiet eum te, vel veniam eirmod option ea, at eos velit repudiare. Ius sumo dicit adolescens id, an cum efficiantur concludaturque.<br><br>Summo sensibus cum ne, et duo torquatos conceptam. No aeque elitr constituam qui. Nostro corpora nec no, diam verterem tincidunt has et. Altera accumsan urbanitas pro eu, ei assum voluptaria sed. Eam tibique nominavi consequuntur an.<br><br>Ei perfecto delicata usu, quo eius noster blandit te. Eu doctus volumus pri. Meis argumentum an nam, eos odio prima autem an. Te complectitur intellegebat pro, ius id alterum maiestatis. Ea facer accusata sed, ex illum antiopam quo.<br><br>Altera putent pri ad, in phaedrum dissentiunt per. Te eum everti dolores. Ut mea vero autem viderer, mel brute harum senserit id. Minim senserit eloquentiam duo in, sit ei justo graece petentium. Sea id homero oporteat invenire.<br><br>Pri semper dolorum ad. Cu eius repudiare eos. Eum in eleifend necessitatibus. Ne has mutat intellegebat.</p>[/html]', '[html]<p><strong>Lorem ipsum</strong> is a pseudo-Latin text used in web design, typography, layout, and printing in place of English to emphasise design elements over content. It's also called placeholder (or filler) text. It's a convenient tool for mock-ups. It helps to outline the visual elements of a document or presentation, eg typography, font, or layout. Lorem ipsum is mostly a part of a Latin text by the classical author and philosopher Cicero. Its words and letters have been changed by addition or removal, so to deliberately render its content nonsensical; it's not genuine, correct, or comprehensible Latin anymore.</p>\r\n<p>While <strong>lorem ipsum</strong>'s still resembles classical Latin, it actually has no meaning whatsoever. As Cicero's text doesn't contain the letters K, W, or Z, alien to latin, these, and others are often inserted randomly to mimic the typographic appearence of European languages, as are digraphs not to be found in the original.</p>[/html]', 'kolmas', 'Description for Facebook and search engines.', 1609274459, 1, 1, 0, 0, 0, '0', '0', 4, 'Summary of the news item', '{e_MEDIA_IMAGE}2020-05/news1.jpg,,,,', 0, 'default');