Magictallguy

SELECT * FROM some_table WHERE text_column IS NOT NULL ORDER BY some_column

Gross! Use literally any Jetbrains product

Got a weird character for your newline? C_playerPerc=:playerPerc -- here WHERE

Got a bind value for :playerPerc?

Don't change vendor files! Make a custom.css (or equivalent) and source it in after the bootstrap.css

That cable management, though ❤️

Strongly recommending a VESA desk-mount. I've got one for my dual screens and it really does save space. Here's pretty much the one I'm using, though they do come with more arms

Welp, my mistake! Does your server have some form of control panel? If so, and if it's cPanel, the directions above stand. If it's Plesk, then you'll need to visit the domain, click on Databases in the top right menu, then phpMyAdmin. The "how to navigate phpMyAdmin" part still stands here too. If it's something else (or nothing), let me know and I'll see if I can provide a walk-through for ya - if not, someone else probably can

Note: This walkthrough is based on the freely-available Gangster-Legends-V2 repo. I do not have access to a paid copy. Log into your database. If memory serves, you've previously stated you're hosting with MWG; so you'll be able to do this via your cPanel by clicking on phpMyAdmin and selecting your database. Once you're on your database, click on the SQL tab. If you've got this far, you're prepared to restore the table. Copy lines 9 - 20 of install/schema.sql From CREATE TABLE IF NOT EXISTS `crimes` ( all the way to ) DEFAULT CHARSET=utf8; Paste it into the SQL tab you opened up a moment ago, then click on .. either "Run" or "Go" (I can't quite remember which verb is used). If it successfully ran, that's your table restored. Now, if you want the default crimes that come with GLv2: Copy lines 11 - 13 of install/data.sql and paste that into the SQL tab too

Bah, humbug! Have a ... day!

Think ya should go through 'em, fix 'em, and submit a pull request 😉

What if you were to release a modding guide? Ya know, a list of Dos and Don'ts when it comes to modding GLv2. 3rd-party modders would then be enabled to do as they want while keeping in line with the engine's systems, ultimately not breaking the mod (hopefully)

As one of the owners of gRPG, I second this. v1 is not a great basis to work with if you're wanting to learn up-to-date methods, though it can be useful if you want to learn how and why things break. v2, while an improvement over v1, is pending updates to be compatible with more systems (and not rely so heavily on Composer!). Finally, while it may damage gRPG's reputation (or what's left of it), I would recommend GLv2 over gRPGv2 as it currently stands. Bluntly put, it's better written.

This isn't the topic for flaming each other. OP posted a genuine request for help. You don't have to respond to that request at all but, please, be respectful.

Looks like a session garbage collection - usually, happens at random (no way to easily reproduce) - with a misconfigured session location. As previously stated, I have little to no experience with GL, but PHP's PHP. Look for calls to session_save_path(). I have a feeling something is setting an invalid path

I strongly recommend a method known as Rubber Duck Debugging. The concept may sound daft, but I know it works for some. Grab a rubber duck, put it on your desk, talk it through your code next time you're debugging

On a dark theme, this is fine. Still valid advice though - not everyone uses a dark theme

I'm sure it is! I wouldn't be able to think straight if I was a cider either. Original snippet: $lv = date('F j, Y, g:i a', $ir['laston']); // Then, $lv is simply echoed Replacement: $lv = $ir['laston'] > 0 ? date('F j, Y, g:i a', $ir['laston']) : 'Today';

The `updates` table contains the timestamps of each "cron". Use the 5min timestamp to calculate how long is left until the next tick and format that result. For live counters, combine with a little JavaScript

Awesome. How about helping the OP achieve the same effect? 😉

PayPal released breaking changes to their API about 5-6 years after this was originally released. The listener part of this IPN implementation will not work.

A donator package system with perks for donators

Horrible markup aside, you're missing a <script> tag and a " <link href="DailyPlanner.css" rel="stylesheet"/> <table id="game"> <tbody> <tr id="8" onclick="myFunction(this.id)"> <th>08:00</th> <td colspan="4" rowspan="2" class="stage-saturn">Welcome</td> </tr> <tr id="830" onclick="myFunction(this.id)"> <th>08:30</th> </tr> <tr id="9" onclick="myFunction(this.id)"> <th>09:00</th> <td id="9text" colspan="4" class="stage-earth">Speaker One <span>Earth Stage</span></td> </tr> <tr id="930" onclick="myFunction(this.id)">" > <th>09:30</th> <td id="930text" colspan="4" class="stage-earth">Speaker Two <span>Earth Stage</span></td> </tr> <tr id="10" onclick="myFunction(this.id)"> <th>10:00</th> <td colspan="4" class="stage-earth">Speaker Three <span>Earth Stage</span></td> </tr> <tr id="1030" onclick="myFunction(this.id)"> <th>10:30</th> <td colspan="4" class="stage-earth">Speaker Four <span>Earth Stage</span></td> </tr> <tr id="11"> <th>11:00</th> <td rowspan="5" class="stage-mercury">Speaker Five <span>Mercury Stage</span></td> <td rowspan="5" class="stage-venus">Speaker Six <span>Venus Stage</span></td> <td rowspan="5" class="stage-mars">Speaker Seven <span>Mars Stage</span></td> <td rowspan="2" class="stage-saturn">Lunch</td> </tr> <tr id="1130"> <th>11:30</th> </tr> <tr id="12"> <th>12:00</th> <td rowspan="3" class="stage-saturn">Break</td> </tr> <tr id="1230"> <th>12:30</th> </tr> <tr> <tr id="1"> <th>1</th> <td colspan="4" rowspan="2" class="stage-earth">Speaker Eight <span>Earth Stage</span></td> </tr> <tr id="2"> <th>2:00</th> </tr> <tr> <th>2:30</th> <tr> <th>3:00</th> </tr> <tr> <th>3:30</th> </tr> <tr> <th>4</th> </tr> <tr> <th>4:30</th> </tr> <tr> <th>5:00</th> </tr> <tr> <th>5:30</th> </tr> <tr> <th>6:00</th> </tr> <tr> <th>6:30</th> <td colspan="4" class="stage-earth">Speaker Nine <span>Earth Stage</span></td> </tr> <tr> <th>7:00</th> <td colspan="2" rowspan="2" class="stage-earth">Speaker Ten <span>Earth Stage</span></td> <td colspan="2" rowspan="2" class="stage-jupiter">Speaker Eleven <span>Jupiter Stage</span></td> </tr> <tr> <th>7:30</th> </tr> <tr> <th>20:00</th> <td colspan="2" class="stage-mars">Speaker Twelve <span>Mars Stage</span></td> <td class="stage-jupiter">Speaker Thirteen <span>Jupiter Stage</span></td> <td class="stage-jupiter">Speaker Fourteen <span>Jupiter Stage</span></td> </tr> <tr> <th>20:30</th> <td colspan="4" rowspan="2" class="stage-saturn">Drinks</td> </tr> <tr> <th>21:00</th> </tr> </tbody> </table> <script> $(function () { $("#dialog").dialog({ autoOpen: false, show: { effect: "blind", duration: 1000let }, hide: { effect: "explode", duration: 1000 } }); }); </script> <div id="dialog" title="Basic dialog"> <p> This is an animated dialog which is useful for displaying information. The dialog window can be moved, resized and closed with the &apos; x &apos; icon. </p> </div> <script type="text/javascript"> let x; let allowedActions = [ "Grand Theft Auto", "Hacking", "Robbery", "Mugging", "Forgery", "Randomness*" ]; let planner = [ "8", "830", "9", "930", "10", "1030", "11", "1130", "12", "1230", "1", "130", "2", "230", "3", "330", "4", "430", "5", "530", "6", "630", "7", "730" ]; for (x = 0; x < planner.length; x++) { planner[x] = ""; } function myFunction(ID) { $("#dialog").dialog("open"); alert(ID); // let IDRef = ID + "text"; let x = document.getElementById(ID + "text"); document.body.innerHTML = document.body.innerHTML.replace(x.innerHTML, 'Hello World'); } </script>

*Very* minor thing here; you can shorthand your elem.on('click', function () {}); to elem.click(() => {});