[Help] Login Freeze when dropping too many items.

12/18/2008 01:46 justprownage#1
When people on my server drop too many items, login freeze occurs and then there's this error on my console. I forgot what it said, so ill post it on Friday. When I try to login it will say Connecting to the server...please wait.... and it stays like that until I restart the server. I want to fix this so we can drop as many items as we can. I have an auto-refresher every 5 minutes so it wont lag. Can someone help me with this?
12/18/2008 04:53 -Reflexis-#2
look my signature it will fix everything
12/18/2008 05:12 tao4229#3
I can top that

Code:
#include <iostream>
using namespace std;

int main()
{
     cout << "Writing shit doesn't do anything.";
     cin.get();
}
12/18/2008 05:15 -Reflexis-#4
tao is was only a joke;s

but justprownage you can make account table and character table into ini files i did that to
12/18/2008 20:21 ~*NewDuuDe*~#5
convert your files to ini :P
Then u wont get any mysql overloads atleast lol so no login freeze
12/18/2008 21:24 justprownage#6
Quote:
Originally Posted by -FireBlaze- View Post
tao is was only a joke;s

but justprownage you can make account table and character table into ini files i did that to
Does it fix Login Freeze permanently? If so, can you teach me how to convert them into ini without messing up the accounts & characters in MySQL?
12/18/2008 22:20 taylor2846#7
it will fix login but u will have a item and wh bug unless u no how to fix it
12/18/2008 22:25 tao4229#8
Quote:
Originally Posted by taylor2846 View Post
it will fix login but u will have a item and wh bug unless u no how to fix it
I bet my way of doing items is more efficient than your way...

Either way, you don't freaking have to convert to .ini's.
I had a perfectly stable LOTF base using MySQL(And Im terrible with SQL <_<), it's not that complicated.
That's what SQL was made for, to make things easier for developers to store data.
12/18/2008 22:38 taylor2846#9
xD then share what u no
12/19/2008 22:49 Tw3ak#10
Quote:
Originally Posted by tao4229 View Post
I bet my way of doing items is more efficient than your way...

Either way, you don't freaking have to convert to .ini's.
I had a perfectly stable LOTF base using MySQL(And Im terrible with SQL <_<), it's not that complicated.
That's what SQL was made for, to make things easier for developers to store data.

LOL agreed:D

everyones solution to freeze is " ohhh change to ini it fix all !! " rather then stop being noobs and learn sql.
12/20/2008 11:15 ~*NewDuuDe*~#11
Quote:
Originally Posted by Tw3ak View Post
LOL agreed:D

everyones solution to freeze is " ohhh change to ini it fix all !! " rather then stop being noobs and learn sql.
you know that aint gonna happen :P