PapitoMyKing's Recent Forum Activity

  • Nvm, I fixed it.

    I removed all the "mysql_real_escape_string" statements.

  • Hi guys,

    I'm trying to insert into a mySQLi DB, but nothing is happening This is my code:

    <?php
    $db = "db";//Your database name
    $dbu = "user";//Your database username
    $dbp = "pass";//Your database users' password
    $host = "host";//MySQL server - usually localhost
    
    $dblink = mysqli_connect($host,$dbu,$dbp,$db);
    if (!$dblink) { exit('Verbindung schlug fehl: '.mysqli_connect_error()); }
    echo 'Verbindung zum Host steht!';
         
    if(isset($_GET['name']) && isset($_GET['score'])&& isset($_GET['last_name'])&& isset($_GET['nickname'])&& isset($_GET['email'])){
         
         $name = strip_tags(mysql_real_escape_string($_GET['name']));
         $score = strip_tags(mysql_real_escape_string($_GET['score']));
         $last_name = strip_tags(mysql_real_escape_string($_GET['last_name']));
         $nickname = strip_tags(mysql_real_escape_string($_GET['nickname']));
         $email = strip_tags(mysql_real_escape_string($_GET['email']));  
       
         $string = "INSERT INTO sbo_scores (id,name,score,last_name,nickname,email) VALUES ('','$name','$score','$last_name','$nickname','$email');";
         $sql = mysqli_query($dblink, $string);
         
    }else{
         echo 'error.';
    }
    
    mysqli_close($dblink); //Close off the MySQL connection to save resources.
    ?>[/code:3ry24jy5]
    
    Any ideas?
  • My project is halfway done guys, how do you mean I should use Unity?

    So you wanna say, apps made in Construct 2 are not intended to work well on phones? Well, that's a shame!..

    A lot of people has tried to use C2 to publish on mobile, but we get framerate and sound lag issues. However, I have read of some other people that have been successful, although I have no idea how.

    I think your best bet is to ask for paid help, since mobile optimization and using XDK or phonegap is an art on itself.

  • It's not working because you are mentioning the same object twice. Construct won't know each instance to pick. A workaround is to create two families with the same object and then, on creation, put their UIDs in a family's instance variable(let's say ObjUID). Now you just need to verify if family1 is overlapping family2 and check if family1.ObjUID is different from family2.ObjUID. If its different then you know that you are dealing with two different instances of the same object.

    Sounds reasonable. Thanks! I'll try it.

  • Try Construct 3

    Develop games in your browser. Powerful, performant & highly capable.

    Try Now Construct 3 users don't see these ads
  • Yes, and I checked that the collision box covers the entire object.

  • Hi guys,

    So I have a really weird problem. When I try to register if an object is overlapping with a different instance of the same object, construct doesn't register it! Look at the pics:

    I create 10 boxes at the start, then check if a box is overlapping another box, but construct never returns it. Only returns when it is not overlapping.

    What is happening?

    Thanks!

  • My project runs perfectly while previewing on my laptop's browser. When running through Debug Mode the CPU usage is 20%.

    While previewing on phone, it runs like 2 frames per second and causes the device to overheat. The problem is that my Samsung smartphone has no WebGL, so it uses its processor for rendering, and when previewing on phones that have WebGL (like Xperia), there is no problem at all, though it still overheats the phone...

    So, I've seen many others have this problem, but can somebody actually share their solution?

    Use Unity for mobile games.

  • You dont event need an array, you know.

    https://www.dropbox.com/s/sxg0khhtic2iq ... .capx?dl=0

    Hey!,

    Thanks for your replies. That's an awesome example, but I cannot set room instances in my game, I have to use floor and room coordenates.

    I wil try to create all coordinates at the start as you suggest, and then assign them randomly as guests are created.

  • Hi guys,

    So I am spawning objects and setting their coordenates randomly, so far so good, but I don't want them to end up in the same place, therefore if the coordenates repeat, they should be re-rolled untill you find new ones.

    Run the project in debug mode, so you can see the coordinates array filling up:

    https://mega.nz/#!TBx3CCCR!BYYcxop2zC-Tok1pLwz2QwjBx_DflcYHK8ggFvrvteU

    And here is what i am trying that's not working:

    Thanks!

  • Not that I have personally done this but I would assume that you would have the client register a Google developer account and then they can add you as a user.

    https://support.google.com/googleplay/a ... 8691?hl=en

    Yes, I was thinking something similar, thanks!

  • No one? Sad.

  • Hi!,

    So I want to start working as freelancer and sell apps to clients, and then they publish it, own it, etc. But I have the following question, how do they get the revenue, if I upload the game to google play myself?

    I know with ads is easy, they give me their ad id and I put in the code, but how about IAP? This money is going to the uploader of the game atm, how do I do so that revenue goes to a 3rd party?

    Delivering the apk so the client uploads it is not an option, because you have to setup the achievements, leaderboards, etc, within the developer's console.

    Thanks guys!

PapitoMyKing's avatar

PapitoMyKing

Member since 11 May, 2014

Twitter
PapitoMyKing has 2 followers

Trophy Case

  • 10-Year Club
  • Forum Contributor Made 100 posts in the forums
  • RTFM Read the fabulous manual
  • Email Verified

Progress

13/44
How to earn trophies