Yarr The Pirate! https://w.yarrthepirate.com/phpbb3/ |
|
So I kinda know how to work around the boards crashing. https://w.yarrthepirate.com/phpbb3/viewtopic.php?f=1&t=1559 |
Page 1 of 1 |
Author: | Yarr [ Thu Oct 14, 2004 5:21 pm ] |
Post subject: | So I kinda know how to work around the boards crashing. |
Basically the way SQL works is that after 50,000 queries made(per hour) by the login name it stops working. Since this site is getting hammered with hits that runs out really fast. So I created a few more loggins for the SQL database and I can just edit the config file and change the login once the 50,000 limit is made. Now I just need to figure out how to make it into a script so it does it automatically /em looks at ridere and regnar ![]() |
Author: | Yarr [ Thu Oct 14, 2004 5:41 pm ] |
Post subject: | |
For the love of all that is holy you guys just burnt through 50,000 in like 15 min ![]() ![]() ![]() ![]() |
Author: | Aleks [ Thu Oct 14, 2004 5:42 pm ] |
Post subject: | |
I spend all day on this site... its my home page for god sakes. |
Author: | Ponuh [ Thu Oct 14, 2004 5:51 pm ] |
Post subject: | |
Yes, I spend a good deal here too. I just started posting... |
Author: | Ketrebu [ Thu Oct 14, 2004 5:51 pm ] |
Post subject: | |
I think Reg actually posted you a script ages ago to automatically cycle through usernames. No idea what happened to it. :P |
Author: | Ponuh [ Thu Oct 14, 2004 5:54 pm ] |
Post subject: | |
I saw the script the other day.... It went something like..../^&Postscript^_^wtf/b<(^^)Yarrthepirate.com/bbcode61ninerrr^/scootydoo.dmg ...or was it /scootyda? |
Author: | Regnar [ Thu Oct 14, 2004 5:55 pm ] |
Post subject: | |
hmmm i made that script up on the spot i dont have it anymore however i think i know about 2000 different scripts that could work. ill try and make you a few options over the weekend. |
Author: | Aleks [ Thu Oct 14, 2004 5:56 pm ] |
Post subject: | |
Yarrthepirate.com=life ![]() |
Author: | Yarr [ Thu Oct 14, 2004 5:58 pm ] |
Post subject: | |
ok well so far we are on the 4th login now meaning this site is getting hammered super super hard. /em looks at 40 people online.... |
Author: | Regnar [ Fri Oct 15, 2004 3:37 am ] |
Post subject: | |
Yarr for me to do this effectivly could you download the forum files and email them zipped up for me, then i can edit the code and send you it back, of course ill put in a file with notes of changes too, also to keep the database secure make sure to edit your current username and password fields for the database unless you dotn mind me having those :P This is the best way for me to get it working and test it all (in fact on the testing side could you export the sql table constructions then i can setup my pc at home with it all and can make sure the script works 100% ![]() |
Author: | Mikey [ Fri Oct 15, 2004 3:55 am ] |
Post subject: | |
hello andrew |
Author: | Regnar [ Fri Oct 15, 2004 4:38 am ] |
Post subject: | |
![]() ![]() {Nice to meet you!} |
Author: | Taeuvyn [ Fri Oct 15, 2004 8:11 am ] |
Post subject: | |
Can you edit the source where the queries occur? If so, you can rotate login credentials as needed. Or, I am assuming your on an apache server I haven't looked at your headers, you can create several static connections with each set of credentials and rotate through those rather than spawning up connection instances(slow). |
Author: | Regnar [ Fri Oct 15, 2004 8:34 am ] |
Post subject: | |
i have an idea for a fun script, when selecting the mysql_connect have it use a random user/pass out of say 6 options then you get a random chance of gettign it, if you fail once hit refresh and your in, would be really annoying and kinda like playing russian roulette ^^ |
Author: | Taeuvyn [ Fri Oct 15, 2004 8:39 am ] |
Post subject: | |
6 sets of credentials, 50000 queries per hour for a total of 300000 queries. Think thats enough? |
Author: | Whisp [ Fri Oct 15, 2004 8:53 am ] |
Post subject: | |
hello david |
Author: | Taeuvyn [ Fri Oct 15, 2004 8:54 am ] |
Post subject: | |
Would you like to play a game of chess? |
Page 1 of 1 | All times are UTC - 5 hours |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |