G7470

  There are good/proper ways to design web based mmorpg databases; however, that could very well be limited based upon your budget and time. In my opinion, the more time you spend analyzing what you want to be able to do in your game, including any possible modifications, feature additions, etc, the better off you will be. With a solid database foundation, you will have a much easier time accessing the data that you need to run your game properly. This is something I feel that many web games are lacking. RDD I believe is a good strategy to go down for these type of games. This type of design (done properly) will give you a great database foundation to expand upon in the future. I believe these games are using a form of RDD; however, their implementation is probably not up to par. They are probably not following all of the good practices, including normalization, that you should be doing in RDD. If your database is designed in a way that is normalized properly, database interaction in real-time may not be so bad; however, like anything else, there are some limitations. If you need to update the database constantly in real-time, then you should probably utilize cookies or the user's session to store said information until a database update is needed to store said data. As mentioned in #4, if real-time updates are needed constantly, then these should be utilized to store necessary information until the time is allocated to update the database appropriately.  

Just by looking at the HTML, I can tell that this is from a template, which don't get me wrong, is absolutely fine, but where did you get this template from? Also, I can tell by looking at the HTML that your HTML is invalid. You're missing a closing div after your first slide. I also tested your carousel animations, and they DO work; however, your previous/next slide links are completely invisible and are on the far-left of that upper area. My suggestion: strip this out and take it piece-by-piece instead of copying/pasting the entire template and attempting to implement the entire thing at once. Trust me, taking this bit-by-bit will prove not only to be much easier, but you will also learn much more about the template that you're using as well as how to manipulate it to fit your needs. ~G7470  

He's referring to the gif that is on your login page. It took me ~15 seconds to load that in the background, which means that the gif is way too large. I would suggest getting rid of it too. ~G7470

How long ago was this mod created/posted onto MCCodes market? Facebook connect functions A LOT different than it used to 5-6 years ago. ~G7470

From what I can tell, as MCCodes 2.0.5 uses password salts, this I don't think will work alongside that. You have to either Remove password salts altogether (NOT recommended), or Add in the password salt generation script (located in the autenticate.php file for reference) into this in order to get this to work properly. ~G7470

I'm guessing that in this current gym, the user puts in the number of times they want to train, and that's where the $_POST['amnt'] variable is used. As for using "sets", you can do it that way, but you have to answer a couple of questions for yourself first before you actually start to code it: What exactly does using "sets" solve that the current gym system does not have an answer for? How will you determine the gains based upon sets (i.e. will the gain be the same for each set)? Side note: $i is just a placeholder for a number to go through the for loop. ~G7470

That tells me that gang_index() is not a function, or if it is, the script can't get to it. ~G7470

What are the differences between this method and your idea of a "Pawn Shop"? ~G7470

[uSER=68711]KyleMassacre[/uSER] in v2, yes it does. All that would have to be done is to create/utilize a new logs table and check for sell price > $5 on the itemsell file. ~G7470

That's pretty cool! I've been working with Unity the past few months. I like the fact that the logic is in C# (which I'm very much familiar with). Level design though? I can't say that's something I'm good at, haha. ~G7470

Are you referring to validating a $_POST request that has a description of mixed text? ~G7470

They felt that knowing the host was of some importance to the users of MCC (which it certainly might have been at the time and still might) IPv6 was hardly ever used at the time of MCC v2 release   ~G7470

Assuming the location column is the "name" you're talking about, use an ORDER BY clause.(yes, I used w3schools for the documentation) The end of your query would look something like this (including the cityid condition for context):   AND `cityid` != {$ir['location']} ORDER BY location ASC");   ~G7470  

There are a couple of ways that I can think of off the top of my head to accomplish what you're looking for. Option #1 - Create As Many "Location" Columns as you need in the shops table (not recommended) This option is essentially to create extra location "slots" for your shops so that they can be setup in multiple cities. So shopLOCATION, shopLOCATION2, etc. To get ALL cities, you could have a default value to look for in shopLOCATION that's impossible as a city location (like -5 for example) that would tell you that this shop is meant for ALL cities. Option #2 - Make shopLOCATION be an array (recommended) This option is a little trickier, but could be more rewarding in the end. This will require the following steps: Change the shopLOCATION field to be a "varchar" field in the database. Update that shopLOCATION field in the database to include every city that you want this shop to be available separated by a comma (so for example - you would have 1,3,5 in your shopLOCATION field if you want cities 1, 3, and 5 to have this shop). Update the PHP according to this setup with the following: Where you're adding a shop, you will have to allow for as many cities as you want in your options. I'm not 100% sure of the best way to accomplish this, so I'll leave that part up to you to determine how you would prefer your setup to be conducted. When it comes to seeing which shops are available for that city, the query will look something like this:     $db->query("SELECT * FROM shops WHERE shopLOCATION LIKE '%" . $ir['location'] . "%'");   Hopefully this will help you get started. ~G7470    

[uSER=64687]Dominion[/uSER] has the right idea. Essentially, the user will be inputting HTML, and I will be taking that, splitting it apart, and saving each piece separately throughout the file system. I did manage to find a way to get this to work; however, what I don't know is that if this is the best method for doing so with PHP and JS at my disposal. I'm just displaying the CSS I got for now, but I will be writing it to a file a little bit later. Here it is semi-completed:   $htmldoc = new DOMDocument(); $htmldoc->loadHTML($_POST['shtml']); // make directories mkdir($_POST['name']); mkdir($_POST['name'] . "/images"); mkdir($_POST['name'] . "/css"); $cssstuff = $htmldoc->getElementsByTagName('style'); foreach($cssstuff as $css) { $cssdata = $css->nodeValue; $cssdataarr = explode(";", $cssdata); // split CSS line by line $num = count($cssdataarr); $count = 1; foreach($cssdataarr as $cssinfo){ $getpos = strpos($cssinfo, "url"); // find URLs if($getpos !== false) { // If URL exists, split string, copy image, and change URL $string1 = substr($cssinfo, 0, $getpos); $string2 = substr($cssinfo, $getpos+4); copy("/sheets/{$string2}", "/{$_POST['name']}/{$string2}"); $newcssdata .= $string1 . " url(../" . $string2 . ";<br />"; } else { if($num == $count) { $newcssdata .= $cssinfo . "<br />"; } else { $newcssdata .= $cssinfo . ";<br />"; } } $count++; } } echo $newcssdata;   ~G7470

Hey all, I'm attempting to parse through a HTML file and split the file up accordingly (CSS goes in one section, images goes in another, etc). I managed to get to a good point where I am getting the CSS data using PHP's DOMDocument class; however, I'm hitting a roadblock once I get the data. This data may have some image URLs in them (background image), so I would like to be able to update this with the "proper" URL of where it will be once this "process" completes. This is where I'm at:   $htmldoc = new DOMDocument(); $htmldoc->loadHTML($uhtml); $cssstuff = $htmldoc->getElementsByTagName('style'); if($cssstuff <> "") { // check if there are any elements foreach($cssstuff as $css) { $cssdata = $css->nodeValue; } }   As you can see, I have extracted the CSS data into the $cssdata variable (as I am going to put this into a CSS file); however, I'm stuck on how to update an image URL in that CSS from here. Any help would be greatly appreciated. Thanks! ~G7470

A little off-topic here, but many of us here use Skype to communicate. It may be good for you to create one in order to get the support that you need for things that are paid mods (like with this chat for example). ~G7470

I haven't been able to successfully install it myself either, so don't worry, you're not alone on this. I just know that it for sure doesn't work with PHP 5.2 and earlier. I'm stuck where you are at. I've been tinkering with it, but so far to no avail. I'm waiting to hear back from him (as I contacted him directly), but if others have other forms of contact information for the creator, if you could get a hold of him to get him back on MWG to get an install working, that would be great. If I could get it working, I would gladly help support this engine further (and even toss in some plugins), but until I can get it up and running, I'm dead in the water. ~G7470

What's the PHP version on the server that you're running this on? I know that there are issues with this engine with PHP version 5.2 and older. ~G7470

Well, it looks like some people have found interest in this topic, so I wouldn't say that my time was wasted providing what I knew about it. Maybe others will see this topic and contribute - who knows. ~G7470  

Search engines use meta tags to get an idea of (hopefully) what your site is about. So to go off of the example I gave [uSER=69001]Zettieee[/uSER], if I type into Google "Web Game", if I have a meta tag with "Web Game" in it, the site is going to be in the results. Will it be on the first page? Highly doubt it (as they use the site's popularity and page content to rank them in the results), but it will be in the results somewhere. If you want your site to be high up in the results, either A) use keywords that are not very commonly searched (which is counter-intuitive for SEO), or B) use other SEO techniques, which again, I'm no SEO expert, so I'm not sure what those might be. EDIT: Also, if you're one that advertises your site outside of word-of-mouth, meta tags are used on social media sites as well. If you copy/paste a site's URL into Facebook for example, the value of the meta tag's "description" field will fall underneath the site's title on a "tile" link (if you're on Facebook, I hope you know what I mean by that - I don't know the term for it!). ~G7470

I'm no SEO expert; however, meta tags are certainly a good place to start. Setting "keywords" in those tags that relate to what your site is about. If you have a "Web Game", then have a key phrase of "Web Game" somewhere in a tag. Things like that. ~G7470

As others have posted here, your game will never be 100% secure or impervious to hackers/attackers finding your site. It doesn't matter where you are on a search engine, those users will find your site. If they somehow don't, then your site is most certainly not successful (and probably dead at that point). The balance of security is cost VS benefit. The most valuable thing to most hackers is their time. If you waste their time with them trying various methods to no avail, most will simply give up and leave, as it is too costly for them to continue further to get said benefit. If you have the basic protections in place that others have mentioned here, this will happen in most cases. Something very important to consider with security though is that no matter how "secure" you make your game, if someone really wants your game to go down in flames, they will find a way to do so. ~G7470

Also, to follow up [uSER=69869]alexander7567[/uSER], the mysql_ extension will be removed - the mysqli_ extension will still work just fine in PHP 7. ~G7470

Just treat "maxenergy" as "100" in order to find percentage - so for example:   `maxenergy` / 6   Turns into:   100 / 6   Which is ~16.67. This means that for donator days it is increasing by that percentage every time this is called. Make sense? ~G7470