flashgocrazy wrote:
Magnie wrote:
flashgocrazy wrote:
1. For the code, Users. For one of the first lines in scratch live php? Users again
2. its not working #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Users'
(
Username varchar(20),
' at line 1
Do you have the code for the qwery?
edit: oh i frogot to add the ` but there is still an error after i add the `Can you give me the code of the entire query you put in?
Code:
CREATE TABLE `Users` ( Username varchar(20), Value varchar(20), );
Remove the comma after "Value varchar(20)" and that should fix it.
Offline
I have talked to an xTreemhost employee and the chances of getting the Scratch Live host flagged is high because the clients are requesting data from the server every 0.5 seconds. And that's just the Abuse Detector, if this gets past that, then there will be the bandwidth limit, which probably won't be passable.
Math for time it takes for one person to idle on ScratchChat: 10KB ( estimate of 5KB every 0.5 seconds ) per second * 60 seconds ( 1 minute ) = 600KB * 60 minutes ( 1 hour ) = 36000KB * 24 hours ( 1 day ) = 864000KB / 1024KB = 843.75MB per day
So if someone wanted to idle for 121 days you would reach the 100GB limit. Now since that is just one person, it will be cut in half for every person that idles.
1 person = 121 days
2 people = 60.5 days
3 people = 30.25 days
4 people = 15.125 days
5 people = 7.5625 days
6 people = 3.78125 days
You can probably see where this is going. Once about 12 people are idling it reaches the hours it takes and then 20 reaches minutes it will take to clean out the bandwidth limit of the Free plan which I think is what JD1 is using.
And that is just ScratchChat, other people are probably using ScratchLive as well.
Is there a possibility of finding a way to use less bandwidth or make it so the server sends the data out to the clients instead of the clients needing to request the data every 0.5 seconds? I've created the Python code for a Python server, but it requires a Python mirror connected to it and Scratch, which is even harder to use than the current Scratch Live.
Is anyone good at Squeak programming that can create another Remote Connections so instead of another program connecting to Scratch, have Scratch connect to the program? Something like Mesh, but with an external program instead of another Scratch program?
Maybe even make those blocks for Panther?
Offline
It works? It works!
Offline
_-_-_- wrote:
how to u get the usernames and passwords of scratch accounts?
yours? Not at all because the API doesn't work with unusual characters (unless they can be URL encoded, not sure I understood that properly).
Offline
http://scratchlive.xtreemhost.com/set.php?user=variable&pass=1 wrote:
Warning: mysql_connect() [function.mysql-connect]: User xth_7668455 already has more than 'max_user_connections' active connections in /home/vol5/xtreemhost.com/xth_7668455/htdocs/set.php on line 13
Could not connect: User xth_7668455 already has more than 'max_user_connections' active connections
If I host a copy myself, will this problem be fixed?
Offline
Magnie wrote:
I have talked to an xTreemhost employee and the chances of getting the Scratch Live host flagged is high because the clients are requesting data from the server every 0.5 seconds. And that's just the Abuse Detector, if this gets past that, then there will be the bandwidth limit, which probably won't be passable.
Math for time it takes for one person to idle on ScratchChat: 10KB ( estimate of 5KB every 0.5 seconds ) per second * 60 seconds ( 1 minute ) = 600KB * 60 minutes ( 1 hour ) = 36000KB * 24 hours ( 1 day ) = 864000KB / 1024KB = 843.75MB per day
So if someone wanted to idle for 121 days you would reach the 100GB limit. Now since that is just one person, it will be cut in half for every person that idles.
1 person = 121 days
2 people = 60.5 days
3 people = 30.25 days
4 people = 15.125 days
5 people = 7.5625 days
6 people = 3.78125 days
You can probably see where this is going. Once about 12 people are idling it reaches the hours it takes and then 20 reaches minutes it will take to clean out the bandwidth limit of the Free plan which I think is what JD1 is using.
And that is just ScratchChat, other people are probably using ScratchLive as well.
Is there a possibility of finding a way to use less bandwidth or make it so the server sends the data out to the clients instead of the clients needing to request the data every 0.5 seconds? I've created the Python code for a Python server, but it requires a Python mirror connected to it and Scratch, which is even harder to use than the current Scratch Live.
Is anyone good at Squeak programming that can create another Remote Connections so instead of another program connecting to Scratch, have Scratch connect to the program? Something like Mesh, but with an external program instead of another Scratch program?
Maybe even make those blocks for Panther?
Is it possible to bother the MySql server without the php? I think that might be faster and use less bandwidth?
Offline
LiquidMetal wrote:
Magnie wrote:
I have talked to an xTreemhost employee and the chances of getting the Scratch Live host flagged is high because the clients are requesting data from the server every 0.5 seconds. And that's just the Abuse Detector, if this gets past that, then there will be the bandwidth limit, which probably won't be passable.
Math for time it takes for one person to idle on ScratchChat: 10KB ( estimate of 5KB every 0.5 seconds ) per second * 60 seconds ( 1 minute ) = 600KB * 60 minutes ( 1 hour ) = 36000KB * 24 hours ( 1 day ) = 864000KB / 1024KB = 843.75MB per day
So if someone wanted to idle for 121 days you would reach the 100GB limit. Now since that is just one person, it will be cut in half for every person that idles.
1 person = 121 days
2 people = 60.5 days
3 people = 30.25 days
4 people = 15.125 days
5 people = 7.5625 days
6 people = 3.78125 days
You can probably see where this is going. Once about 12 people are idling it reaches the hours it takes and then 20 reaches minutes it will take to clean out the bandwidth limit of the Free plan which I think is what JD1 is using.
And that is just ScratchChat, other people are probably using ScratchLive as well.
Is there a possibility of finding a way to use less bandwidth or make it so the server sends the data out to the clients instead of the clients needing to request the data every 0.5 seconds? I've created the Python code for a Python server, but it requires a Python mirror connected to it and Scratch, which is even harder to use than the current Scratch Live.
Is anyone good at Squeak programming that can create another Remote Connections so instead of another program connecting to Scratch, have Scratch connect to the program? Something like Mesh, but with an external program instead of another Scratch program?
Maybe even make those blocks for Panther?Is it possible to bother the MySql server without the php? I think that might be faster and use less bandwidth?
It could be possible. You may be able to create an external script (with Python or some other language) and then have that script connect to the MySQL server and request there. But that still wastes bandwidth for checking every 0.5 seconds, which is why I suggest coding the server manually instead of using HTTP and MySQL.
Offline
Dominic1 wrote:
GeonoTRON2000 wrote:
Download links are dead...
The whole project is currently dead...
Don't even get me started...
>:-( x 10000
Offline
GeonoTRON2000 wrote:
Dominic1 wrote:
GeonoTRON2000 wrote:
Download links are dead...
The whole project is currently dead...
Don't even get me started...
>:-( x 10000
If you really want it, I could get you a copy, but no one will be on. Also, it's not the best system.
Offline
Dominic1 wrote:
GeonoTRON2000 wrote:
Dominic1 wrote:
The whole project is currently dead...Don't even get me started...
>:-( x 10000If you really want it, I could get you a copy, but no one will be on. Also, it's not the best system.
That's O.K.
Offline