Printable View
Hi all, I want to make an app that will add to an online counter every time it is tapped by a user. I also want a counter to show how mny times it has been clicked by people who use the app. I'm guessing i'd have to use the GET object or something. Can someone please point me in the right direction. If you have any questions about it, let me know. :-)
Yes you have to use the GET object, JosephFTaylor...
Furthermore you need a database (best option) or a simple text file on a webserver where you can store and count the button taps...
So with the GET object you send data through the URL and parameters (GET or POST) and on your server you recieve the data.
You will need a PHP script (i.e. "counter.php") to manipulate the text file or database.
Your app will only initiate the process and the PHP-file does the rest :).
With "echo" or "print" (in PHP) you get back the counter information which is stored on your server.
If you arenīt familiar with PHP I can help you and attach an example file.
http://community.clickteam.com/showthread.php?t=69985
Take a look here. This was for a counter using an SQL database and the GET extension.
You can just change the update procedure from being on each unique start up to your button click.
Thanks you two, I'm currently having a play around and brushing off my basic PHP skills. I'm trying to devise a plan on how I would remove the player's count after 5 seconds. I don't want to retrieve the value and subtract 1 from it and then send that back to the server, because the slim chance there is, more than one people would be doing that request at the same time.
Maybe an easier way to explain it and for the sake of making any examples you rustle up ;) easier, you could make a 'Current Online Users' count, have it add 1 to the count on launch and then subtract 1 from the count when they leave/get disconnected. This isn't what I'll be doing though. I just though it might explain it easier.
I'm no PHP genius but looking at the PHP code, I've noticed a + 1 bit, would I just replace the + 1 with - 1 and give it another name so I can shoot the request to run that action from the app?
if ($_GET["onlinestatus"])
{
$sqlselect=mysql_query("SELECT * FROM $table"); //$table should be changed to your table name.
$array5=mysql_fetch_array($sqlselect);
$downloads=$array5['$column'];
$newdownloads = $downloads + 1;
$sqlupdate=mysql_query("UPDATE $table SET $column = $newdownloads"); //$column should be changed to your column name.
exit;
}
The server will complete the first task before it goes on with the other request...Quote:
Originally Posted by JosephFTaylor
On every webpage (for example on webpages with a shoutbox) there would be this problem if the server completes tasks at the same time.
In this case you need a database to connect with...Quote:
Originally Posted by JosephFTaylor
Here is your customized PHP script:
So now if you call the function within your app (with the GET method: "http://www.your-site.com/index.php?onlinestatus=true") you get no value back but the counter in your database gets lowered...PHP Code:<?php
if (isset($_GET["onlinestatus"]) && ($_GET["onlinestatus"] == true))
{
mysql_connect("localhost", "username","password") or die ("connection failed."); //Connect with the sql-database
mysql_select_db("database") or die ("database does not exist.");
$sqlselect=mysql_query("SELECT * FROM $table"); //get all the content of one table
$array5=mysql_fetch_array($sqlselect); //...and store it in an array
$online_users=$array5['$column'];
$new_online_users = $online_users - 1;
$sqlupdate=mysql_query("UPDATE $table SET $column = $newdownloads"); //get the value of the online counter, subtract one from it and update the database
mysql_close();
?>
I hope that I hevenīt misunderstood your problem :D
Okay, now I'm confused and to make it even worse, I can't seem to get anything working, it says it's connected but it doesn't do anything.
Sorry for confusing xD
So you have a real database and a webserver and you have customized the code I posted above?
You changed some vars in this code?
And as I said already you wonīt SEE anything within your app cause the webpage will be empty if there is no error message...
In your database you will see that the counter gets lowered if the GET object sends the parameter (in this case "onlinestatus=true") to the server.
Hi Atrox! Would it be possible with get and php to add some Facebook functionality to iOS Apps?
Hi StingRay,
i have no account on facebook so I am not sure wether it is possible or not. I think it could be done... pls tell me what you want to do within your app so i can do some research :D
Hi Atrox,
Login to facebook inside the app, tell friends that you're using the App NOW, invite friends,
show images from friends and much more...
i think maybe we dont need a special extension for that. if we are lucky ;)
woodyboy, why when I run the MFA does it say Connected, even if I haven't even modified it to connect to my server?
I've had a play around but wouldn't know what to do in MMF. Here is my code.
Have I got the right idea?Code:<?PHP
if ($_GET["connect"])
{
$countlog = "count.txt";
## Get the countlog file ready
$count = file($countlog);
}
if ($_GET["add"])
{
$count = $count[0] + 1;
}
if ($_GET["subtract"])
{
$count = $count[0] - 1;
}
if ($_GET["end"])
{
$fp = fopen($countlog, "w");
fwrite($fp, $count);
}
?>
Solved it :-)
Code:<?PHP
if ($_GET["connect"])
{
echo "online";
exit;
}
if ($_GET["add"])
{
$countlog = "count.txt";
$count = file($countlog);
$count = $count[0] + 1;
$fp = fopen($countlog, "w");
fwrite($fp, $count);
echo $count;
exit;
}
if ($_GET["subtract"])
{
$countlog = "count.txt";
$count = file($countlog);
$count = $count[0] - 1;
$fp = fopen($countlog, "w");
fwrite($fp, $count);
echo $count;
exit;
}
?>
Why does the text file become blank if more than one instance of the application is open (exe - not on iphones)
I am not sure but try to use this code:
PHP Code:<?php
if (isset($_GET["connect"]) && $_GET["connect"]==true)
{
echo "online";
exit;
}
if (isset($_GET["add"]) && $_GET["add"]==true)
{
$countlog = "count.txt";
$count = file($countlog);
$count = $count[0] + 1;
$fp = fopen($countlog, "w");
fwrite($fp, $count);
echo $count;
exit;
}
if (isset($_GET["subtract"]) && $_GET["subtract"]==true)
{
$countlog = "count.txt";
$count = file($countlog);
$count = $count[0] - 1;
$fp = fopen($countlog, "w");
fwrite($fp, $count);
echo $count;
exit;
}
?>
What does this do? It seems to make it slower. Is there a better, quicker, more reliable way to do it?
It checks wether a varibale is set and if it is not it does not output error messages...Quote:
What does this do?
Cause when I tested your code on my local server i got some errors when for example "connect" wasnīt set.
Yes there is a better way :DQuote:
Is there a better, quicker, more reliable way to do it?
You should use a database instead of a textfile as I said in my first or second post ;)
You have to connect to a db and manipulate the values in it - this is much faster than your current method
How do I do that? I need a bit more explanation and support as I have no idea about databases really.
Do you own a web domain or are you using any web hosting?
They typically give you access to your own SQL databases, which you can use. Then you use PHP to insert data and retrieve data into this database.
I mean I don't know what code to use and how to modify it to work for what I want. I do have web hosting and a domain name.
Hey JosephFTaylor,
I have adapted your PHP code so you only have to replace some variables as you can read in my comments within the code... I hope that I made no mistakes cause I havenīt tested it yet :)
PHP Code:<?php
if (isset($_GET["connect"]) && $_GET["connect"]==true)
{
echo "online";
exit;
}
if (isset($_GET["add"]) && $_GET["add"]==true)
{
mysql_connect("localhost", "username","password") or die ("connection failed.");
/*Replace 'localhost', 'username' and password' with your db login data*/
mysql_select_db("database") or die ("database does not exist.");
$sqlselect=mysql_query("SELECT * FROM your_table");
/*Replace 'your_table' with your table :) in the database (for example 'counter_table')*/
$my_array=mysql_fetch_array($sqlselect);
$count=$my_array['column'];
/*Replace 'column' for example with 'counter'
but then 'counter' has to exist within your table as a column*/
$new_count = $count + 1;
$sqlupdate=mysql_query("UPDATE your_table SET column = $new_count")
/*Replace variables in the line above as you did before*/
mysql_close();
echo $new_count;
}
if (isset($_GET["subtract"]) && $_GET["subtract"]==true)
{
mysql_connect("localhost", "username","password") or die ("connection failed.");
/*Replace 'localhost', 'username' and password' with your db login data*/
mysql_select_db("database") or die ("database does not exist.");
$sqlselect=mysql_query("SELECT * FROM your_table");
/*Replace 'your_table' with your table :) in the database (for example 'counter_table')*/
$my_array=mysql_fetch_array($sqlselect);
$count=$my_array['column'];
/*Replace 'column' for example with 'counter'
but then 'counter' has to exist within your table as a column*/
$new_count = $count - 1;
$sqlupdate=mysql_query("UPDATE your_table SET column = $new_count")
/*Replace variables in the line above as you did before*/
mysql_close();
echo $new_count;
}
?>
Okay, so I've made the modifications. My domain name is josephftaylor.com would I just replace localhost with that? On another note, it's not working. It's not echoing 'online' when I request 'connect'.
Have you made sure you have the "http://" at the start of your get URL event in MMF2?Quote:
Originally Posted by JosephFTaylor
Also, most people generally just use localhost for the connection, so you can just leave that.
Sorry i made two little mistakes... i forgot ";" in two lines
The code below should work now.
The request should be as the following to get "online" back: "http://www.your-site.com/index-or-something-else.php?online=true"PHP Code:<?php
if (isset($_GET["connect"]) && $_GET["connect"]==true)
{
echo "online";
exit;
}
if (isset($_GET["add"]) && $_GET["add"]==true)
{
mysql_connect("localhost", "username","password") or die ("connection failed.");
/*Replace 'localhost', 'username' and password' with your db login data*/
mysql_select_db("database") or die ("database does not exist.");
$sqlselect=mysql_query("SELECT * FROM your_table");
/*Replace 'your_table' with your table :) in the database (for example 'counter_table')*/
$my_array=mysql_fetch_array($sqlselect);
$count=$my_array['column'];
/*Replace 'column' for example with 'counter'
but then 'counter' has to exist within your table as a column*/
$new_count = $count + 1;
$sqlupdate=mysql_query("UPDATE your_table SET column = $new_count");
/*Replace variables in the line above as you did before*/
mysql_close();
echo $new_count;
}
if (isset($_GET["subtract"]) && $_GET["subtract"]==true)
{
mysql_connect("localhost", "username","password") or die ("connection failed.");
/*Replace 'localhost', 'username' and password' with your db login data*/
mysql_select_db("database") or die ("database does not exist.");
$sqlselect=mysql_query("SELECT * FROM your_table");
/*Replace 'your_table' with your table :) in the database (for example 'counter_table')*/
$my_array=mysql_fetch_array($sqlselect);
$count=$my_array['column'];
/*Replace 'column' for example with 'counter'
but then 'counter' has to exist within your table as a column*/
$new_count = $count - 1;
$sqlupdate=mysql_query("UPDATE your_table SET column = $new_count");
/*Replace variables in the line above as you did before*/
mysql_close();
echo $new_count;
}
?>
Hi Atrox! Sorry to bump, but did you have got time to take a look at Facebook?
If the user login within the app, we could share that the user is playing the game now! invite friends, show which other friends are playing the game,....
Hey StingRay,
i havenīt found something that you were looking for (with the GET object) cause i donīt know anything about facebook and its interface...
But maybe this link will be helpful for you: https://developers.facebook.com/docs/mobile/ios/build/
But this would require manual coding in objective-C and on the weekend i will search again cause i had not enough time in the past to search for something that I have not been confronted with before.
(Hope you understand what i am trying to say, my english isnīt the best ;) )
Hi! I've found an interesting link, Thats maybe useful: http://thinkdiff.net/facebook/php-sd...nect-tutorial/
http://net.tutsplus.com/tutorials/ph...ebook-connect/
What do you think?!?
No I've got it so the buttons work and it comes back with online, but when I press the buttons it doesn't add, it only comes back with 1 and -1
Do you want me to take a look at this?
Yes please.