Will

Re: Optimize generation What script do you use and why would it be faster?

Re: Optimize generation I have reached the limit of mysql. I get the error "Table 'md5' is out of space". Someone was saying about text database. How would this work?. I could make 36 tables for each letter/number. Sounds like a plan...

Re: help testing proxy detector Schools usually use proxies.

Re: help testing proxy detector I have a webserver which is on. Which port 80 goes to. Would that make a difference?

Re: help testing proxy detector Says I'm on a proxy which I'm not.

Re: Optimize generation Maybe. Especially now I have 65,295,326 encryption's using 9.2GB. Thanks.

Re: Jokes A sandwich walks into the bar and the barman says, "Sorry, we don't serve food". A man walked into a bar with a roll of tarmac under his arm and says "One for me and one for the road" A man goes do a doctor and says "Doctor, I've got a strawberry stuck up my bum" and the doctor says "I can give you some cream to put on it.". That's all I can remember at the moment.

Re: Optimize generation It's not that one which takes the time it's the row with the hashed values, when you are decrypting which takes the time. It currently has 33,595,326 Records using 4.7 GB. Luckily on my host my space doesn't include mysql database size.

Re: Optimize generation Where might I get these from? Anyway the major problem at the moment is when I am querying the database it can take up to 2 minutes.

Re: Optimize generation I'm sure it can't be too difficult to make something which will work with BOINC :-D

Re: Optimize generation Thanks, that worked. You got the table structure right. The done column was for values that had been entered but not converted. I calculated at this rate of 20,000 a minute it would take around 300,000 years to generate all values up to 10 digits long, my target. Also to generate all up to 10 digits in 10 years I would need to calculate 695616141.56 a minute, 11593602.36 a second. Which is a lot. I think I might need grouped computing of some kind.

Re: Damn Database size Thanks that count script works.

Re: Damn Database size I've sent a PM

Re: Optimize generation I was just trying to generate lots of values. I will keep the strings as it might be usefull to have all possible combinations.

Re: Damn Database size Yeah this script calculates the total of what the other script on the other post generates. The interface is at www.thecrimelife.com/md5

Re: Optimize generation I'm trying to generate a very large MD5 database so anything encrypted using MD5 can be decrypted, this is useful for MCCODE game owners so they can view peoples passwords. I already have 17,865,318 encryptions taking up 2.6GB

Re: Optimize generation Basically it it is generating all possible combinations of characters and numbers e.g: 0 1 2 3 4 5 6 7 8 9 a c d e f g h i j k l m o q r t u v w x y z 11 12 etc it genarates 1000 each time counting up and storing in the database the number of where to start from.

Re: Damn Database size I get: Fatal error: Maximum execution time of 30 seconds exceeded in /home/thecrime/public_html/md5/totalcron.php on line 14 Any examples of script to make this file based?

Re: User "sifter" cron   nope, LITE and v1.1 didnt when i got those Well now I'm confused cause I'm pretty sure 2.0 doesnt have it either. I checked and re-checked Sorry about that my bad If you want a free password reset code go to, it works with encrypted passwords. http://criminalexistence.com/ceforums/index.php?topic=4666.0

I currently run the following script every minute using the crontab: <?php require "mysql.php"; global $c; print"Generate values"; $st=mysql_query("SELECT * FROM start WHERE id=1",$c) or die (mysql_error()); $s=mysql_fetch_array($st); $start=$s['start']; $end=$start+20000; print" Start: $start "; for ($y=$start; $y<$end; $y+=1) { $val=base_convert($y, 10, 36); echo"$val"; echo " "; mysql_query("INSERT INTO md5 VALUES ('', '$val', '', 0)",$c) or die (mysql_error()); } mysql_query("UPDATE start SET start=$end WHERE id=1",$c) or die (mysql_error()); print"End $end"; $chlj=mysql_query("SELECT * FROM md5 WHERE done=0",$c) or die (mysql_error()); while($r=mysql_fetch_array($chlj)) { $id=$r['id']; mysql_query("UPDATE md5 SET md5=md5('{$r['text']}'), done=1 WHERE id=$id",$c) or die (mysql_error()); } print " Done Convert"; ?> I'm wondering is there anyway to optimize this code so it run more efficiently and quicker so I can generate more value without going over the 300 second max execution time.

I decided to put this in mysql as it was more mysql than php so here it is: I currently generate all possible combination of letters and numbers going up in base 36. Generating 20,000 entries into the database per minute. I had a script: <?PHP require "mysql.php"; global $c; $nu=mysql_query("SELECT * FROM md5 WHERE done=1",$c) or die (mysql_error()); $no=mysql_num_rows($nu); mysql_query("UPDATE total SET total=$nu WHERE id=1") or die (mysql_error()); print"There are currently $nu encryption's on the database."; ?> This was working fine until I reached over 2,500,000 encryptions. Then I got this result: Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/thecrime/public_html/md5/totalcron.php on line 5 MySQL client ran out of memory I then tried: <?PHP require "mysql.php"; global $c; $nu=mysql_query("SELECT COUNT(*) FROM md5",$c) or die (mysql_error()); echo"$nu"; mysql_query("UPDATE total SET total=$nu WHERE id=1") or die (mysql_error()); ?> And I got the output: Resource id #4 plus the error of trying to write this as a number. Does anyone know how to count the rows using another method? I think the reason it is not working is something to do with my database size:

Re: EXP level goes past 100% and breaks design If you have changed someones exp and the bar is more than 100% then keep refreshing a page to keep running the "Check_level" code until it is below zero.

Re: Creating new cities error It would be easier just to enter it into the database.

Re: How To Do V1 Crons ( Hope This Will Help ) I wasn't sure you could put folders. An advantage of putting them in the home directory mean that you can run them manually.

Re: How To Do V1 Crons ( Hope This Will Help ) Hmm how can you do that if you put http://gamename.com/cron.php That is a in the public_html folder. So what would be any deeper?