Coly010

I really like this approach. Looks great and I think, if the content was good enough, then it would keep me playing

Probably the best quote ive seen aha

From reading that post alone, it seems almost impossible to prevent an attacker from getting code into the webserver. I'll need to read into ways of making sure it is a video, and I think the best solution for that could in fact be ffmpeg :/

I'll take a look at DigitalOcean, and look into VPS as I've never used one before. Using the Content-Type seems like a good idea, but does <video> not only work with ogg/mp4/webm ? I suppose I could filter it if I had the file type stored. The only other problem that arises from that, is security. Is there a way to check that the file is video and not say a text file saved as a video type?

Yeah thats very well done. My mind has been blown aha

Ok, so in my site I want to allow users to upload videos. The problem I'm facing is cross-compatibility for playing different video types across different browsers. As an upload is basically a users choice, and many wont have a say in what type of file their video is. Therefore I need a way of playing all types of video files and get the dimensions of the video, so it can be resized proportionally. One solution was to convert all uploaded files to .mp4 and then simply use html5's video tag to play it, or if need be, <embed> But I learned the server that my hosting is with doesn't support ffmpeg,(or crons for that matter so I'm considering leaving, if you have any suggestions that would be great) Does anyone know of any other solutions to my problem?

Thanks sniko, I'll look into that :) Got it working now, thanks for the help :)

I was looking at Facebook and Twitter and noticed that when you view a user, in the address it bar it has say facebook.com/username My question is can I do a similar thing with PHP, instead of having /viewuser.php?id= I'm not exactly sure what to search for on google either, so if someone can give me a proper name for this then I can do a bit of digging

Well then I must look up how to make a flat design flashy and see if it is the sort of thing I'm going for. I still have other forms of graphics on the site, icons, pictures of items etc. Just not a template so to speak. I can usually put various shades of grey into an attractive web page all set against a black background, but I don't know how feasible this would be for a game.

Quick question, do games that use flat templates look good or do I need to design something that looks flashy? I dont want to distract users too much and make it hard to actually view the page, plus I don't think I'd have the skill to design something professional :s

Still can't really get my head wrapped around the "matches" part of it. does it only take the row from the other table which has the same column name and value as all the column names in the first table? Or does it give you the full row if as long as one column matches a certain column in the other table? inner join didnt work, left join did work :S

Okay, so when doing it, do I: SELECT u.*, t.*, a.* FROM user u INNER JOIN table t ON u.userid = t.userid INNER JOIN another_table ON u.userid = a.userid WHERE u.userid = $userid Should that work?

I'm a bit confused on what type of JOIN to use for this. I have three tables, all containing the column USERID. I want to join them all together into one query so that i can place them into an array. Right so i want the row from the tables as long as the userid is the same between them all. Do i use inner join, left join, right join, full join? (what even is the difference) and how would i arrange it in a query? thanks for any help

The error I'm getting: Catchable fatal error: Object of class mysqli_result could not be converted to string in C:\xampp\htdocs\Chaos-Era\register.php on line 289 I don't understand why I am getting this error because its not to say I'm echoing the query. my line of code is literally: mysqli_query($c, "UPDATE user SET race = $race WHERE userid = $userid");   should i be assigning the query to a variable? Someone lock or delete this please, found the error. my userid variable had an issue

I like it a lot now,but i'm a fan of greys and blacks anyways :P

happy? sheesh....

Very true, I think I was talking out of my ass that stage.

Don't blame your mate for the errors. you dont have the knowledge to fix it, so why cant this elusive "mate" of yours sort out the problems he created? mean that in the least hurtful way possible, i just think you need to learn to code if your going to try and make a game. honestly if you need proper help with your files then i'm open to helping you, for free, you'll just have to understand that i cant be dedicated, and i would need to see the files, but if your mate coded everything he should be able to fix it all If you've found out the problem mind sharing it so that we can benefit as well?

couldnt help but laugh when I read this!!

rudeboiix, i was looking through other posts you have put on this site. You look like you've jumped in at the deep and are drowning badly. Very badly, fro one, you don't seem to know how to use a server properly, and you look like you have no SQL knowledge or even PHP knowledge for that matter. Do yourself a favour, google how to code in html, then in css, next php. You always seem to look for the quick fix, you need to learn whats wrong, why its wrong, and steps to fix it. It's the only way to get good at programming, and run a good game. You cant run a game if your constantly running to others to fix your games problems, and you definitely wont get a userbase.

Right well I'm not 100% sure where your problem is actually coming from, but if its taking you straight back the home after you click the login button maybe its something to do with this bit of code:   if($_SERVER['HTTP_REFERER'] != 'http://www.dangerouscity.com/home.php' && $_SERVER['HTTP_REFERER'] != 'http://dangerouscity.com/home.php') { header("location:home.php"); } else {   from your authent.php file. right, somewhat unrelated but could be a bit of helpful advice. NEVER use tables simply to style the page, your wasting resources. its not needed, especially with CSS which you should be utilizing, especially for speed sake. another thing, i would personally put the $pass = $_POST['pass'];   then do your security stuff outside your mysql query. Another thing, use mysqli because mysql is or will very soon be deprecated. one other thing, im not 100% sure about but: $granted = mysql_query("SELECT `playerid`,`playername` FROM `members` WHERE `player_login_name` = '".mysql_real_escape_string($_POST['name'])."' && `player_login_pass` = '".mysql_real_escape_string(md5($_POST['pass']))."'");   do the quotes clash at this part? :   `player_login_name` = '".mysql_real_escape_string($_POST['name'])."' && `player_login_pass` = '".mysql_real_escape_string(md5($_POST['pass']))."'");   one last thing : $granted = mysqil_query($c, "SELECT `playerid`,`playername` FROM `members` WHERE `player_login_name` = '".mysql_real_escape_string($_POST['name'])."' AND `player_login_pass` = '".mysql_real_escape_string(md5($_POST['pass']))."'"); that should work if you use mysqli. dont know how helpful that is, but it should be something to think about. And this is completely unrelated, but your code is ugly. split the register and login into two different files, your file seems cluttered because of the functions, if you must you can keep the functions, just use include 'file.php';   - - - Updated - - - rudeboixx you seem a bit inexperienced, where did you learn how to code your login and authent file?

All of this information is definitely helping me. I'm planning out a new game and basically taking notes off of this topic. I've learned a lot of what I should and shouldn't be doing, so if I can pick it up then I'm sure other Game Owners who feel their games are a bit dead might be able to work out why and how they can combat it with this. For some people, I think a relaunch might be a good idea. For the owner of this thread, I think a relaunch might be a good idea, but it would take a bit of work. For one, you need a massive update - your reason for the relaunch. Then maybe change your template out and ingame. Also update and improve a few smaller things, maybe make training a little or more interactive, or give your users an option of a quick train all, or a way to use certain amount of energy, but make it interesting. Then other things, like maybe the attack system could be revamped. You'll definitely need community things. Chat and Forum are good, but they don't always cut it in games. Give players a reason to interact with each: - Player run businesses ( can sell stuff from their inventory for x price ) - Competitions ( that make sense, don't over do it ) - Random Events - Factions ( Gangs whatever, but give them a reason to play. For example gang with most inf points at end of month get a reward, but the player that has earned the most inf points from each gang get a reward as well (inf = influence)) - More things to do ( a game will get repetitive quickly if there is only a certain amount of things to do - Monitor abusive players ( players that are abusive to others ( even if they donate the most ) should be discouraged, warned and finally banned, because they can do massive damage to your game) - includes staff members Just some things I think might help

Ahhh!! I understand now, at last :P thanks everyone with all the help, I just wanted to be sure because money is involved.

So I take it the ipn file is constantly running?

so paypal sends the notification that payment went through to the ipn, how does my code interpret the code and find what user to update? i think i'll need to look at code samples and tutorials properly