xanxion's Recent Forum Activity

  • It looks great Gigatron !

    Is there a place i can download and try it out?

    i would be so happy if i can use this fx in our game!

  • if anyone has any tips on how to get greenlit, we would love to get some advice!

  • I found the error, it was because im using php7 so mysql connect is deprecated.

    Maybe someone can update it for php7?

    The avatar is from the awesome commodore 64 game "Retrograde"

    My all time favorite old-school game

  • Hi Constructers and fellow game developers!

    Its been a while, and we have been working hard on our game "GemBreak" for steam!

    Today we finally added our game for greenlight, and we would be extremely happy if anyone would like to vote for our game. We have a huge passion for games, and we hope to release this game soon!

    You can vote here:

    http://steamcommunity.com/sharedfiles/f ... =651749566

    Thank you so much for all the help in the forums and to the awesome community of C2!

  • Gigatron

    Thanks a lot! i tried some different parameters, but it dont think it helped much overall.

  • Hi Everyone,

    I used to use a getscores.php and savescores.php for a online highscore system.

    But on my new server, this does not work.

    I get these errors:

    Fatal error: Uncaught Error: Call to undefined function mysql_connect() [/code:91zd5q7n]
    
    and
    
    [code:91zd5q7n] Stack trace: #0 {main} thrown in[/code:91zd5q7n]
    
    Im guessing mysql_connect() does not work anymore? i think i might be on php7
    
    Is there anyone here who can help me you?
    
    Here is the scripts:
    getscores.php
    
    [code:91zd5q7n]<?php
     // Date in the past
     header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
     // always modified
     header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
     // HTTP/1.1
     header("Cache-Control: no-store, no-cache, must-revalidate"); 
     header("Cache-Control: post-check=0, pre-check=0", false);
     // HTTP/1.0
    header("Pragma: no-cache");
    header('Access-Control-Allow-Origin: *');
    $host="HOTNAME"; // Host name 
    $username="USERNAME"; // Mysql username 
    $password="PASSWORD"; // Mysql password 
    $db_name="MYDB"; // Database name 
    $tbl_name="scores"; // Table name
    
    // Connect to server and select database.
    mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
    mysql_select_db("$db_name")or die("cannot select DB");
    
    // Retrieve data from database 
    $sql="SELECT * FROM scores ORDER BY score DESC LIMIT 30";
    $result=mysql_query($sql);
    
    // Start looping rows in mysql database.
    while($rows=mysql_fetch_array($result)){
    echo $rows['name'] . "|" . $rows['score'] . "|";
    
    // close while loop 
    }
    // close MySQL connection 
    mysql_close();
    ?>[/code:91zd5q7n]
    
    And here is savescores.php
    
    [code:91zd5q7n]<?php
    $db = "DBNAME";//Your database name
    $dbu = "DBUSERt";//Your database username
    $dbp = "PASS";//Your database users' password
    $host = "HOSTNAME";//MySQL server - usually localhost
    $dblink = mysql_connect($host,$dbu,$dbp);
    $seldb = mysql_select_db($db);
    
    if(isset($_GET['name']) && isset($_GET['score'])){
    
         //Lightly sanitize the GET's to prevent SQL injections and possible XSS attacks
         $name = strip_tags(mysql_real_escape_string($_GET['name']));
         $score = strip_tags(mysql_real_escape_string($_GET['score']));
    
         //Tjek om brugeren findes
         $sql = mysql_query("SELECT * FROM scores WHERE name = '".$name."' ");
    
         //Findes brugeren (tjekker om SQL er ok, og om der mere end 0 rækker retur)
         if($sql && mysql_num_rows($sql)>0)
         {
              //DEr findes allerede en med dette navn, shit!
              //Vi finder lige højeste score lidt kluntet.
              $highest = 0;
              while($r = mysql_fetch_array($sql))
              {
                   if($r['score']>$highest)
                   {
                        $highest = $r['score'];
                   }
              }
              //Hvis den nye score er højere end den højeste!
              if($score>$highest)
              {
                   //Ny highscore!
                   mysql_query("DELETE FROM scores WHERE name = '".$name."'");
              }
         }
         //Indsæt ny highscore!
         $sql = mysql_query("INSERT INTO `$db`.`scores` (`id`,`name`,`score`) VALUES ('','$name','$score');");
         
         if($sql){
         
              //The query returned true - now do whatever you like here.
              echo 'Your score was saved. Congrats!';
              
         }else{
         
              //The query returned false - you might want to put some sort of error reporting here. Even logging the error to a text file is fine.
              echo 'There was a problem saving your score. Please try again later.';
              
         }    
    }else{
         echo 'Your name or score wasnt passed in the request. Make sure you add ?name=NAME_HERE&score=1337 to the tags.';
    }
    mysql_close($dblink);//Close off the MySQL connection to save resources.
    ?>[/code:91zd5q7n]
  • Is this now using the builtin C2 save/load slot system?

    • because wouldnt that be a problem when updating the game with new levels and such?

    i just downloaded this again to hopefully use localstorage, that saves only current levels and highscore.

  • I tried this on a level select screen i made, but everyone who tried it, says its lagging a lot.

    Not sure if it is?

    • im on a gamer pc, so maybe thats why i didnt notice?

    Is there a parameter i can disable or lower so that it wont be so CPU intensive?

  • By the way, is there a way to load music into the simplicity?

    From C2 i mean, so it will move with the beat, like in your demo?

  • Try Construct 3

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

    Try Now Construct 3 users don't see these ads
  • Gigatron

    Thank you so much for your help with the simplicity fx.

    You sir, are really kind!

    And awesome you packed the multiple fx in smaller ones. Im gonna give them a try too!

  • Great plugin, any chance it will work with NW.js in the future, so we can build radio player in .exe format?

    • and does this work on mobiles? - i mean compiled through CocoonJS or similar?

    Great plugin!

  • Looks great, i'll check it out soon!

xanxion's avatar

xanxion

Member since 18 Aug, 2009

None one is following xanxion yet!

Trophy Case

  • 15-Year Club
  • RTFM Read the fabulous manual
  • Email Verified

Progress

17/44
How to earn trophies