This is a read-only archive of the old Scratch 1.x Forums.
Try searching the current Scratch discussion forums.

#101 2011-11-29 17:47:52

Magnie
Scratcher
Registered: 2007-12-12
Posts: 1000+

Re: ScratchChat--A global chat program in Panther!

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

 

#102 2011-12-03 12:09:34

Magnie
Scratcher
Registered: 2007-12-12
Posts: 1000+

Re: ScratchChat--A global chat program in Panther!

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

 

#103 2011-12-03 12:13:27

scratcher7_14
New Scratcher
Registered: 2011-10-25
Posts: 5

Re: ScratchChat--A global chat program in Panther!

It works? It works!

Offline

 

#104 2012-02-06 12:41:41

_-_-_-
New Scratcher
Registered: 2011-06-23
Posts: 7

Re: ScratchChat--A global chat program in Panther!

how to u get the usernames and passwords of scratch accounts?

Offline

 

#105 2012-02-06 14:14:55

sparks
Community Moderator
Registered: 2008-11-05
Posts: 1000+

Re: ScratchChat--A global chat program in Panther!

_-_-_- 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).


http://img541.imageshack.us/img541/7563/scratchbetabanner.png

Offline

 

#106 2012-04-09 20:24:20

LiquidMetal
Scratcher
Registered: 2011-06-15
Posts: 500+

Re: ScratchChat--A global chat program in Panther!

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

 

#107 2012-04-09 20:26:58

LiquidMetal
Scratcher
Registered: 2011-06-15
Posts: 500+

Re: ScratchChat--A global chat program in Panther!

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

 

#108 2012-04-09 21:48:28

Magnie
Scratcher
Registered: 2007-12-12
Posts: 1000+

Re: ScratchChat--A global chat program in Panther!

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

 

#109 2012-04-09 23:27:46

GeonoTRON2000
Scratcher
Registered: 2009-12-24
Posts: 1000+

Re: ScratchChat--A global chat program in Panther!

Download links are dead...


http://i.imgur.com/BAEgGDL.png

Offline

 

#110 2012-06-10 19:48:52

Dominic1
Scratcher
Registered: 2009-07-30
Posts: 89

Re: ScratchChat--A global chat program in Panther!

GeonoTRON2000 wrote:

Download links are dead...

The whole project is currently dead...


http://i49.tinypic.com/oiwvh5.jpg

Offline

 

#111 2012-06-10 20:36:37

GeonoTRON2000
Scratcher
Registered: 2009-12-24
Posts: 1000+

Re: ScratchChat--A global chat program in Panther!

Dominic1 wrote:

GeonoTRON2000 wrote:

Download links are dead...

The whole project is currently dead...

Don't even get me started...
>:-( x 10000


http://i.imgur.com/BAEgGDL.png

Offline

 

#112 2012-06-14 16:44:00

Dominic1
Scratcher
Registered: 2009-07-30
Posts: 89

Re: ScratchChat--A global chat program in Panther!

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.


http://i49.tinypic.com/oiwvh5.jpg

Offline

 

#113 2012-06-14 16:57:15

GeonoTRON2000
Scratcher
Registered: 2009-12-24
Posts: 1000+

Re: ScratchChat--A global chat program in Panther!

Dominic1 wrote:

GeonoTRON2000 wrote:

Dominic1 wrote:


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.

That's O.K.  big_smile


http://i.imgur.com/BAEgGDL.png

Offline

 

Board footer