G7470

I've been working from home now, which in doing so I have actually gotten more work done than I did at the work office 🙂 Also - with a new home purchase recently, being home all the time has given me the time to do some projects around the house. The only big negative is due to the current lock down (still in lock down here) absolutely everything is being ordered online. My food supplies are only the necessity needed to live, not so much the luxuries that I had before. But in true retrospect, I can't really complain. ~G7470

Glad to see you back Dayo. Certainly been a while! Glad to hear that you're doing well for yourself and are now a full-time developer. Hope to hear more about your projects soon! ? ~G7470

I'm liking it so far! Have to give you props, building something like this takes quite a lot of work. Just a couple of comments I noticed while watching the videos: In your conversation with "Captain", you were typing out what I'm assuming were key phrases in chat in order to work with the NPC. What is your plan for making sure that the user knows what those commands are? I noticed when you were using what I'm guessing are spells, the entire game lags quite a bit. How do you plan on cleaning that up? During your attack sequence, I was having a hard time splitting up between the levels of the building in the map. I'm hoping that using your own graphics will clean that up, so this might be a moot point, but something to consider. Like I said, this takes a lot of work to do, and for a game at this scale, you've done a good job so far. Keep it going, and I'm looking forward to giving it a try once it is available. ~G7470

Thanks! It is good to see this back. This really helped continue to spark my interest in outside development. I hope that it continues to do so. I forgot to mention, I also help run a local group with all different programming levels. It just hit over 500 members last month I believe. Yes I have, haha. I'm one of those people that always seems to be doing something. Which reminds me that I need to update my website and blog...been a little behind on that lately. Thanks! I would say, all of my game projects I have come onboard after the game was "purchased". So they either used MCC or GRPG (PHP/JS), or in the case where I made the purchase, it was entirely custom (again, PHP/JS). If I would have to write it all over again from scratch, PHP would still be the way to go, utilizing an existing framework and building custom. I did start doing this for a project I was working on, but the project lead (client) lost interest in his own project, causing the project to be abandoned. ~G7470

I hope so! It took some time for me to learn it, haha. I've heard about it for quite a while, so I figured I would give it a try. ~G7470

I have used typescript for work with the website re-implementation I'm in the process of finishing up for work. It has had its benefits, that's for sure. At least for me, since I didn't really have a whole lot of JavaScript to work with in the re-implementation process to begin with, I didn't use it much. ~G7470

Let's see - well for me, I'm working on a side project called Mobster Story. Other than that, I have a few other side projects in the works, including a home-grown VoIP application, which right now is still in the bare bones development phase, but it is getting there. I know that these exist, but I do have some personal investment in this market, and with this sort of product, I could sell it for a much better price point than others could, as well as give them custom configuration options that others may not be able to do (benefits of a home-grown system). When it comes to my work projects, I have been working on assisting in multiple large projects, including a new look/feel for our enterprise system as well as a website re-implementation. On top of which, since I work primarily for my University's financial aid office, I usually am creating programs for them to help calculate aid for students, which as you can probably imagine is quite complicated. ~G7470

Hey everyone! I'm known here as G7470, or for some people, Goliath. I've been here since 2014; however, I started development in 2009 with the purchase of a game that some of you may remember called Mafia Caper, which turned into Gangster Sanctuary. I have been involved with side game projects since then, including Mobster Story (which I am just starting to get back into again), and Killers Instinct Mafia, which has since last I have talked about it here been sold. I currently live in the United States working for a University in their software development and security administration divisions. I work with an enterprise software system as well as do website development. I have been here for over 5 years now. In my free time, I bowl currently in a league. I'm by far not the best bowler, but it's a work in progress. I finally got a well put-together PC, which I use primarily for my development side project work. I do play video games occasionally on it too - just gotta find the time in the day. I am more than happy to help out whomever needs it. I have been quite active in this community before it disappeared, and I do plan on continuing to be active here now that it is back. Don't hesitate to message me about whatever it is you need. I'm more than happy to share my knowledge or lend a helping hand if I'm able to do so. Glad to be back! ? ~G7470

Been a while, that's for sure. Glad to see it back. ? ~G7470

I use the "New Topics" view too, but I can't seem to find it anymore. This is all I see at the top: [ATTACH=JSON]{"data-align":"none","data-size":"full","title":"new_topics_missing.PNG","data-attachmentid":378993}[/ATTACH] ~G7470

You may be able to get one or the other here - it's difficult to find someone who is good at both, as those skill sets are entirely different. ~G7470

[uSER=70347]NonStopCoding[/uSER] / [uSER=67703]adamhull[/uSER] isn't this something that's on GRPG? I can't really remember since it's been so long, but I know I've seen this before somewhere. If so, this could quite easily be translated to MCCodes lite. ~G7470

From what I've tested out so far, besides what you have noted already: Images appear broken in the items/buildings area, but appear OK on the maker (Firefox, IE 11, Chrome) Zoom crashes the maker (Firefox) Panning the map crashes the maker (Firefox) Otherwise, it's certainly a good start. My suggestion would be to make these tiles bigger and easier to see. The items and buildings are so small that it's really hard to tell what the item is. I don't have much to comment on the source code itself right now, but if time permits, I may take a closer look at it. ~G7470

That sounds like quite a lot with a limited budget, but maybe that's just my opinion on it. By the way, what is your budget? "Limited" does not really explain it, as limited for you could be quite a lot for us or vise-versa. ~G7470

I personally prefer using unix timestamps because PHP and MySQL make it very easy to create and use them. However, that doesn't mean that what I prefer is the "preferred method" across the board. It's really what you would prefer, as it is your database and game. ~G7470

My guess is that your time column in your stock table is using a TIMESTAMP data type, which if you want to use time() or UNIX_TIMESTAMP, that will not work. Those times are generating a "unix timestamp", which is of an INTEGER data type. So, to use those, you have to set your time column to be an INTEGER data type. ~G7470

In that case, DISTINCT is "kind of" what you need, but it doesn't solve your problem yet. What you need to do is make a nested query. By doing this, you can then get the minimum value for that particular stockID, and thus be able to only get 1 row per stock. The query would look something like this:   SELECT DISTINCT st1.stockID, st1.stockNAME, st1.stockPRICE FROM shares st1.WHERE st1.stockSELL > 0 and st1.stockPRICE = (SELECT MIN(st2.stockPRICE) FROM shares st2 WHERE st2.stockID = st1.stockID) ORDER BY st1.stockPRICE ASC   I left the DISTINCT in there because in case that multiple people are selling the stock for the same price, only 1 row for that stock will be pulled instead of multiple rows. Nested queries are important for solving more complex query issues, so now is a good time to start learning about how they work with the example I gave you for this issue. ~G7470

It is recommended to only use the GROUP BY clause when you are using an aggregate function within your query. Since I cannot see the error message on your post, I cannot confirm that this is the problem, but I have a feeling that's why this query is failing. For this query, there's no need for the GROUP BY clause, so just remove it. EDIT: Also, if there are multiple people selling the stock and you only want 1 row, use the DISTINCT keyword in your query. Not 100% sure what results you are trying to get here (post is rather vague), but maybe that's it? ~G7470

That's not going to work - reason why is because one row in the battle_members table will not contain both users in it. Remember, SELECT statements are going to retrieve rows for you, and each row has to meet ALL of the criteria that you specify. The first SELECT will have to look something like this:   "SELECT lad1.bmemberLadder, lad1.bmemberUser, lad2.bmemberUser FROM battle_members lad1 JOIN battle_members lad2 ON lad1.bmemberLadder = lad2.bmemberLadder WHERE lad1.bmemberUser = {$_GET['ID']} AND lad2.bmemberUser = {$userid}"   You'll also have to adjust your count SELECT query, but I'll let you give that part a try now that you can see what it should look like. ~G7470

There are a couple of things you need to consider here: You cannot simply copy/paste these JS functions and expect them to work multiple times over. Just like PHP functions, you can't have the same function name written multiple times throughout the course of your program without causing inconsistent results. This includes the onload function, the setInterval function, etc. window.onload is a base JavaScript DOM function that can only be called once, unless you are running multiple threads, which JS does not support "out of the box". Doing so is far beyond the scope of this forum - if others would like to elaborate on that they can do so. This again brings me back to point 1 that you cannot do a copy/paste of JS code - you have to actually dig into what it's doing. In terms of a solution to your issue, it won't be an "easy fix" - it will require quite a lot of rework, but the best suggestion is to lead more towards something like this: http://stackoverflow.com/questions/22796620/multiple-countdown-timers-on-one-page but instead activating those timers on load rather than via a click of a button. ~G7470

It could work - it just depends on how you set it up. If you set "time" in the wait table to be the time that the user should leave the jail/hospital, then the delete query will work, as it will only delete those rows where the time has passed. Otherwise, I agree, it will not serve its intended purpose. FYI: You should probably avoid using "time" as a column in a table as it is a reserved word in MYSQL. I'm not saying that it won't work the way that you have it, but using reserved words as columns in a table is a bad practice. ~G7470

Well, this example could demonstrate the need for $h->endpage(), as well as including a footer for your site, which was its initial intention. However, to answer your question, the function doesn't have to be in the header. It was probably put in the header in the first place to remove any extra clutter in the globals file, as this function is called on every page. ~G7470

On phpcodechecker, it is probably not using PHP 7 when validating the syntax, so it thinks <=> is an invalid comparison operator even though in PHP 7 it is valid. ~G7470