sizcoz's Forum Posts

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 27 Apr, 2019
  • Quote

  This works I have tested it.

  first you must put the "name" you want to get like this.

  

  The &name& is your variable.

  Then the php is.

  $user=$_GET['name'];

  $select = "SELECT * FROM drawings WHERE name = '$user' LIMIT 0, 1";

  $query = mysql_query($select) or die(mysql_error());

  $result = mysql_fetch_assoc($query);

  //echos the array back to construct

  echo $result['name'] . "|";

  echo $result['artist'] . "|";

  echo $result['score'] . "|";

  // close MySQL connection

  mysql_close();

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 27 Apr, 2019
  • Quote

  https://www.w3schools.com/sql/sql_select.asp

• Try Construct 3

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

  Try Now Construct 3 users don't see these ads
• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 26 Apr, 2019
  • Quote

  hi, just wondering what the best way to tween sprite fonts.

  here you go.

  http://www.sizzle-games.com/bouncy_spritefont.c3p

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 24 Apr, 2019
  • Quote

  I was playing around with c3 this afternoon and made a nice water-like effect using the sin(x)/x function

  Maybe someone can make a game out of it :D

  I used a very similar method for this.

  https://play.google.com/store/apps/details?id=com.sizzgames.boatman

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 23 Apr, 2019
  • Quote

  I'm a bit late to the party, but I finally was able to try out an idea to make motion on the curves smoother. It also lets you place cars at exact distances on the tracks so spacing stays good too. Other than that it's pretty bare bones with only one track.

  Impressive, I had 16 carriages at 100 acceleration, and 2000 speed in debug on laptop, maintaining 60 fps, and 9 % cpu.

  changing to a 30 or 15 degree arc, would give a lot more track design variety, food for thought.

  Anyway, brilliant as usual.

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 19 Apr, 2019
  • Quote

  https://www.scirra.com/manual/161/persist

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 2

  • 18 Apr, 2019
  • Quote

  You could use CSS, but it stays on top of canvas.

  https://www.sizzle-games.com/cardflip

  It's ok on pc, but slow on android.

  I have CSS rudimentary z-ordering implemented in this example.

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 30 Mar, 2019
  • Quote

  Yep

  Sorry about the late post, there were several errors on the events.

  1. There was as explained no need to request.
  2. The first event was not updating because it was "on start of layout".
  3. There was an incorrect "tag"

  Anyway here is the C3 tested events, this works, the php file does not have to change, I will put a link to an example in C3 below, it will be sent to your Junk mail.

  Just as a side note in the php you have to use a valid 'from' and 'to' email address (usually yours)

  

  Link to C3 test

  https://www.sizzle-games.com/C3mailtest/

  Have also updated the tutorial to reflect the changes made https://www.construct.net/en/tutorials/sending-email-construct2-1068

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 29 Mar, 2019
  • Quote

  This is a great development, also noticed bezier spline paths/smart waypoints is also in development !

  C3 just keeps getting better..

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 28 Mar, 2019
  • Quote

  Make sure your server file permissions are ok

  644 for files

  755 for directories

  Your events look ok.

  I once had a problem with my server when I used their website builder, so I had to disable that.

  Other than that, I'm afraid its just a process of elimination.

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 28 Mar, 2019
  • Quote

  greenleafvt

  For the purposes of my tutorial add these 2 events, and it will work.

  

  I will now update the Tutorial for c3.

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 28 Mar, 2019
  • Quote

  Cheers for the explanation, I have got it to work now.

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 27 Mar, 2019
  • Quote

  Call me stupid, but I haven't got it to work yet.

  To be honest It was a simple process in C2, but without any working event examples, it's hard to work out how to implement it, obviously whoever wrote the Binary plugin knows how to do it, and it wouldn't take much to show a simple example to us.

  There is also a way to convert the snapshot binary back to base64, but yet again, until an example is shown, I have no idea how to do it.

  Anyway I suppose someone will work it out oneday.

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 27 Mar, 2019
  • Quote

  File structure

  

  You don't have to call your folder index, just call it something like, New Project.

  Have you got any project to run on your server, like a game?

• • sizcoz
  • 
  • • Joined 19 Apr, 2014
    • 
    • 47 topics • 607 posts
  • 1

  • 27 Mar, 2019
  • Quote

  Just put the php file in the public folder.

  Your c2 project should be in its own folder in the public folder, so just drag the exported c2 folder to the public folder, with filezilla, and call it something other than index.

  see if that works