azrail13's Forum Posts

  • I am making a small juggling game and had trouble with balls colliding using box2d. I started using chipmunk physics so that I could filter collisions. Chipmunk physics is awesome, but I don't understand the parameters very well. How do I apply force to the bottom of the ball so it pops up when tapped via touch? Any help with this juggling mechanic would greatly help.

    I uploaded the capx file to http://bityummy.com/jugtap.capx

  • Will this work when exporting to mobile or is it just for web?

  • Ahh I knew I was screwing something up in there. I haven't messed with php/mysql coding for years. A lot has changed and I've been corrected on a few occasions for using depreciated code. I actually had that set up differently before and my return worked out fine. everything worked as planned, I may have sent an edited file that no longer works. As I've added code after realizing things where not working when I built the .apk

    I will go through with a fine tooth comb and straighten it all out.

    I'm thinking it's a much better deal to get my highscore functions from google play instead of using my own db and code in the end.

    Edit: I forgot to thank you both for going through my mess of code. So thank you so much. I really do appreciate the help. I always wish I could do something for people that take the time out of their day to help another. So if there is anything I can do...

  • Ok I put the code above into the .htaccess file on my domain. I also put:

    header('Access-Control-Allow-Origin: *');[/code:312q5gjm]

in my .php files 

I'm uploading my .php files and my .capx file if anyone would care to take a look.

I replaced the the mysql db username and password in all the php files but i assure you they are set correctly in the originals. i just changed them here for obvious purposes. 

I zipped all the files and uploaded them to my own space. 
[url]http://ponytron.com/forumzip.zip[/url]

I obviously still can't get anything to work. The login doesn't work after I build it in xdk. I'm building with crosswalk and exporting via cordova. Once I get the .apk and test it, I can't login. It works fine when uploaded as html 5 to my website.

  • I have tried building my php/mysql based html5 game with intel's xdk (building with crosswalk) and though the game connects and sends and posts data from the db online when uploaded, it doesn't seem to work after building the app with xdk. I've built a few game in construct and successfully exported them and are in the play store and work without a hitch. I feel like I'm missing something and not sure what. Maybe I'm missing a plugin check box. What should I have checked to make sure that the app can talk to the data base. I have my domain listed in the domain list or whitelist as well. Any ideas? I'm not sure what plugins to include. The app uses nothing like camera or vibration. I have the browser and ajax objects in my c2 made game. It works great as a web app.

  • I would check out and read up on the "anchor" behavior. I think it would be pretty easy if you where familiar with the slicing tool in photoshop. You could get the x,y cords from photoshop. Shouldn't be too hard with a little thought.

  • Have you checked this?

    https://www.scirra.com/tutorials/1010/g ... hievements

    It gives instructions for xdk though it was meant for browser. I'm currently looking around for some more in depth stuff as well. I'll update this thread when I find it.

  • I'm not sure what that error is all about. I lokked up about 3 other errors that I got after fixing that one. Then there was ne on line 26. I commented out the connection close and it works now so I'm not sure what did it. Oh annnddd I also screwed up and chmodded the wrong file when I shouldn't have done it at all. Yep. Derp. That was just one of many issues. I wouldn't have even started to scratch the surface of what the problem was unless you guys hadn't helped me. Thanks so much. I wish I could buy you a round.

  • Try Construct 3

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

    Try Now Construct 3 users don't see these ads

  • I get error:

    -------------

    Warning: mysql_query() [function.mysql-query]: Access denied for user '3ixteam'ibl@'localhost' (using password: NO) in /home/eponaonl/public_html/logintest/update.php on line 16

    Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/eponaonl/public_html/logintest/update.php on line 16

    Access denied for user '3ixteam'ibl@'localhost' (using password: NO)

    ------------------

    with this code

    ----------------------------------

    <?php
$uid = $_POST['uid']; 
$score = $_POST['score']; 
$servername = "localhost";
$username = "eponaonl_admin";
$password = "****";
$dbname = "eponaonl_horse";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
$sql = "UPDATE members   SET score = $score  WHERE id = $uid ";
      $result = mysql_query($sql);
      if (!$result) {
      echo mysql_error();
      exit;
      }

$conn->close();
?>[/code:9cbr76xc]

[img="http://i.imgur.com/b5sWMjM.png"]

  • I decided to include my event page for the first page (the login layout)

    and the full even sheet for the score sending. The first AJAX request works fine. It just echos table data though.

  • <?php
$uid = $_POST['uid']; 
$score = $_POST['score']; 
$servername = "localhost";
$username = "eponaonl_admin";
$password = "****";
$dbname = "eponaonl_horse";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
mysql_query("
    UPDATE members 
    SET score = '".$score."'
    WHERE id = '".$uid."'
");

$conn->close();
?>[/code:qbzr854i]

Here is what I have 
[img="http://i.imgur.com/7mTP33I.png"]

Obviously just starred out the pass in the code.

UserID is a global variable in C2 and was defines on login on layout before. score is a global variable that is updated every tick. Thats what I want to pass into the table based on what the id is. Id is auto increment in the table

  • Thanks, I really appreciate the response . I'm still struggling with updating my db with ajax requests. I can login, pull up table data... but can't seem to write to the db based on user id

  • They are the same and I've tried it with both POST and GET. It still doesn't update the mysql table with the new score. My global variable in C2 is called "UserID"

  • Thank you for the response. I have that set up correctly in C2 (I think). The problem may just be in my php. I took a screencap of my code minus passwords ect.

    Just incase it's a problem I'm causing in C2, here is what I have:

    Sorry... I am so lost. I can't figure out what I'm doing wrong. I'm really rusty in php/ mysql and have little experience with AJAX.

    Oddly my login script works fine and I can even print out my scores, usernames and ids into a text field with no issue. I'm using an entirely different code for the score however. The entire thing is a mishmash from scattered tutorials as none of them seem current.

  • I'm trying to figure out how to pass my global variable "UserID" into an AJAX request to that I can post another global variable "Score" into the correct user table data. The global variable "UserID" is already set on the log in layout and should match up with the user id my the mysql database. So far, everything else is working. I can login and call up data from my table, but I'm hung up on how to update my database with player scores.