It is currently Wed May 07, 2025 12:35 pm View unanswered posts | View active topics |


Board index » General Gaming » Final Fantasy XI


Post new topic Reply to topic  [ 17 posts ] 
Author Message
 Post subject: So I kinda know how to work around the boards crashing.
PostPosted: Thu Oct 14, 2004 5:21 pm 
Star-Spangled Subligar
Star-Spangled Subligar
User avatar

Joined: Wed Dec 31, 1969 7:00 pm
Posts: 15671
Location: THE DOJO
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

\:D/

_________________
COBRA KAI DOJO NEVER DIES
RIP Shiloh


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 14, 2004 5:41 pm 
Star-Spangled Subligar
Star-Spangled Subligar
User avatar

Joined: Wed Dec 31, 1969 7:00 pm
Posts: 15671
Location: THE DOJO
For the love of all that is holy

you guys just burnt through 50,000 in like 15 min :shock: :shock: :shock: :shock:

_________________
COBRA KAI DOJO NEVER DIES
RIP Shiloh


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 14, 2004 5:42 pm 
Decent Challenge
Decent Challenge
User avatar

Joined: Thu Aug 12, 2004 3:50 am
Posts: 499
Location: New York
I spend all day on this site... its my home page for god sakes.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 14, 2004 5:51 pm 
The legend. Teh Ponuh™
User avatar

Joined: Thu Oct 07, 2004 6:36 pm
Posts: 7134
Location: I will eat you alive I will eat you alive
Yes, I spend a good deal here too.

I just started posting...


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 14, 2004 5:51 pm 
Crumpet
Crumpet
User avatar

Joined: Thu Jul 01, 2004 5:57 am
Posts: 5363
Location: England
I think Reg actually posted you a script ages ago to automatically cycle through usernames. No idea what happened to it. :P


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 14, 2004 5:54 pm 
The legend. Teh Ponuh™
User avatar

Joined: Thu Oct 07, 2004 6:36 pm
Posts: 7134
Location: I will eat you alive I will eat you alive
I saw the script the other day....

It went something like..../^&Postscript^_^wtf/b<(^^)Yarrthepirate.com/bbcode61ninerrr^/scootydoo.dmg

...or was it /scootyda?


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 14, 2004 5:55 pm 
Tough!
Tough!
User avatar

Joined: Thu Jul 01, 2004 1:27 pm
Posts: 840
Location: Surrey, UK
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.

_________________
Kasdaye Regnar


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 14, 2004 5:56 pm 
Decent Challenge
Decent Challenge
User avatar

Joined: Thu Aug 12, 2004 3:50 am
Posts: 499
Location: New York
Yarrthepirate.com=life :shock:


Top
 Profile  
 
 Post subject:
PostPosted: Thu Oct 14, 2004 5:58 pm 
Star-Spangled Subligar
Star-Spangled Subligar
User avatar

Joined: Wed Dec 31, 1969 7:00 pm
Posts: 15671
Location: THE DOJO
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....

_________________
COBRA KAI DOJO NEVER DIES
RIP Shiloh


Top
 Profile  
 
 Post subject:
PostPosted: Fri Oct 15, 2004 3:37 am 
Tough!
Tough!
User avatar

Joined: Thu Jul 01, 2004 1:27 pm
Posts: 840
Location: Surrey, UK
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% :)

_________________
Kasdaye Regnar


Last edited by Regnar on Fri Dec 21, 2018 8:12 am, edited 1 time in total.

Top
 Profile  
 
 Post subject:
PostPosted: Fri Oct 15, 2004 3:55 am 
Yarr's bane
Yarr's bane
User avatar

Joined: Fri May 14, 2004 10:38 am
Posts: 6097
hello andrew

_________________
Job 10: 20
The mikey's have a plan. Djay isn't all powerful.
Image


Top
 Profile  
 
 Post subject:
PostPosted: Fri Oct 15, 2004 4:38 am 
Tough!
Tough!
User avatar

Joined: Thu Jul 01, 2004 1:27 pm
Posts: 840
Location: Surrey, UK
:oops: 8)

{Nice to meet you!}

_________________
Kasdaye Regnar


Top
 Profile  
 
 Post subject:
PostPosted: Fri Oct 15, 2004 8:11 am 
Too Weak
Too Weak

Joined: Tue Sep 21, 2004 7:46 am
Posts: 160
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).


Top
 Profile  
 
 Post subject:
PostPosted: Fri Oct 15, 2004 8:34 am 
Tough!
Tough!
User avatar

Joined: Thu Jul 01, 2004 1:27 pm
Posts: 840
Location: Surrey, UK
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 ^^

_________________
Kasdaye Regnar


Top
 Profile  
 
 Post subject:
PostPosted: Fri Oct 15, 2004 8:39 am 
Too Weak
Too Weak

Joined: Tue Sep 21, 2004 7:46 am
Posts: 160
6 sets of credentials, 50000 queries per hour for a total of 300000 queries. Think thats enough?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Oct 15, 2004 8:53 am 
Onionhead
Onionhead
User avatar

Joined: Thu May 20, 2004 6:38 pm
Posts: 7560
Location: Houston
hello david

_________________
RIP Shiloh - I'll never forget ya


Top
 Profile  
 
 Post subject:
PostPosted: Fri Oct 15, 2004 8:54 am 
Too Weak
Too Weak

Joined: Tue Sep 21, 2004 7:46 am
Posts: 160
Would you like to play a game of chess?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 17 posts ] 

Board index » General Gaming » Final Fantasy XI


Who is online

Users browsing this forum: No registered users and 7 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group