heard yesterday that wlodb is gonna close permanently, please please please keep it open. I can never make head nor tail of the forums for compounding and this site is the most comprehensive, there are still compounders in wlo and we need wlodb.

I just recently came back to wlo and i also use this site to check the quests and stuff. This site has been very helpful to me for the past years so I'd hate to see it go.

Links to important stuff:
Transport Quests: http://wlodb.com/topics/99
WLO Pets: http://wlodb.com/topics/13670
WLO Emoticons: http://wlodb.com/topics/6195

PSN :)

Spoiler:

TAURUS SERVER (NOT UPDATED - NO LONGER PLAY)

Spoiler:

DRAGON CAVE - Click or see them if u will lol ^^

Spoiler:

Right now WLODB is having issues with the host provider due to the mere fact that we have a whole lot of data on our hands (New accounts that don't post nothing, spamming bots and whatnot) that just give this site a lot more weight than it should have.

I know that Scott is doing whatever he can to keep it up and running and I am planning to ask the IGG staff to see if they could host the site for us players, I'll write a formal letter when I've got the time.

In the meanwhile, do your best to stick around and I'll hopefully be able to keep you all posted about the future of WLODB.

Godspeed,
Adam the ruler of Chicken Nuggets.

Metatron's looks, compliments of my friend~

Spoiler:

"Leo" Server.

Spoiler:

Earths -
Metatron - 176 Reborn Killer [633/190/31/48/86] (Earth main).
Orelia - 131 Reborn Wit [4/225/341/48/100].
Seraphel - 153 Reborn Mage Knight [31/208/276/60/341].
Zachriel - 81 Reborn Priest [0/395/76/77/0].
Daedalus - 85 Reborn Wit [0/165/312/48/35].

Waters -
Nuriel - 175 Reborn Wit [18/185/507/60/150] (Water main).
Meimiel - 101 Reborn Seer [0/170/172/60/206].
Rhamiel - 81 Reborn Priest [0/395/6/77/0].
Noctus - 88 Reborn Mage Knight [39/193/146/78/308].
Opheus - 83 Reborn Wit.

Winds -
Heimdall - 81 Reborn Wit [0/130/304/49/65].
Anael - 81 Reborn Knight [6/26//10/26/510].
Zofiel - 99 Reborn Killer [586/94/39/39/39].
Anelia - 81 Reborn Knight [190/80/7/49/227].
Hox - 187 Reborn Knight.

Fires -
Zelix - 156 Reborn Killer [615/155/13/42/13] (Fire Melee main).
Alilidier - 160 Reborn Wit [13/167/615/42/13] (Fire Mage Main).
Zeliel - 86 Reborn Killer [476/66/9/45/12].
Seraphinus - 117 Reborn Killer [375/104/9/51/126].
Shadders - 172 Reborn Killer [606/164/4/42/15] (Given alt).
Kronos - 86 Reborn Wit [6/144/395/42/6].
Hades - 86 Reborn Killer [395/144/6/42/6].
Atariel - 136 Reborn Killer [492/180/18/47/66].
Tariel - 130 Reborn Wit [6/145/510/42/22].

Manufacturing Slaves - Dazmond, Misane, Coeus, Perses, Lapetus, Oceanus.
Collection Slaves - SecretC2, SecretC3, SecretC4.
Fish Storage Slaves - Fishslayer, Kronosx, Totoxin.
Equipment Storage Slaves - Oranos, Menoetius.
Burst Slaves:
ShexSlave - 85 Reborn Killer [520/2/2/42/4].
ShwexSlave - 85 Reborn Killer [514/0/0/42/4].
Cusser - 82 Reborn Wit [0/20/511/20/0].

Names for Safekeeping: Dovahkiin

If IGG hosts the site, don't believe there would be as much liberty as there once was, but I guess that's better than having no wlodb at all.

Ruler of the Chicken Tenders

Wanna take care of the useless users that register? Ones with 0 in everything?

1. Post a message informing everyone that a user purge is scheduled for this date.

2. Instruct them that anyone who wishes to keep their account must have 5 in one stat (Posts, Compounds, Etc.) If you have less than 5 in a stat please spam this post until you get 5 Posts.

3. On date of purge Shutdown and purge user list of any user with less than 5 post, etc.

4. Reopen site with a much leaner database.

Wanna try to reduce overhead even more?

Try to setup a mechanism that all added items must be approved by an admin before inserting into the database. This will get rid of redundant Items.

For compounding getting the compound calculator would almost totally alleviate the need to have user added compounds. I am currently working on a private one using my in-house WAMP (Windows 2k8, Apache, MySQL, Php) Server. This will trim the database significantly and make the site more dynamic driven rather than data driven.

See each action on this site will ping the database. The goal is to get as much content dynamically driven rather than static as possible. I can imagine the day when all you have to do is add the new items in a version to the site and then all the compounds that can be used to make the item or use the item will be automatically generated. No more user spam adding compounds to database.

As for the Spam Posting all is needed is a simple captcha to be entered when hitting Post.

-- dark

                                   My Guides
Spoiler: 
                                   Guide to Pet Stats and Scrolling
                                   Linux Wonderland Online Guide
                                   Lazy Man Compounding Series
                                   Guide to the Alchemies of WLo
                                   Goddess Skill bursting for Pets
                                   Normal Training with Equip on for lv1-75 Pets and Low-Lvl RBs
                                   Interesting place to Burst Train
                                   Disposible Equipment Guide
                                   How to price your own Items for sell
                                   Pet Return Scrolls - Revisited
                                   Win7/WinVista: Restore your screenshot and auto-update
[Guide] Donation to wlodb.com

                                   wloDB Quick Links
                                   How to search Forums
                                   HTML and BBCodeizer Tags

Gotta Love Virgo Server

Spoiler:

deavs that sounds awesome, and so much easier too... u gonna be putting ur private one on net for peeps like me to access too *smiles sweetly*

Holy cow! I really hope this site doesn't go away. I suggest it to all new players and I use it a lot myself. It would make compounding a lot harder too, and that's something we already are having issues with on my server. >.<

Caitrina wrote:

Holy cow! I really hope this site doesn't go away. I suggest it to all new players and I use it a lot myself. It would make compounding a lot harder too, and that's something we already are having issues with on my server. >.<

I agree, the wiki is just painful to use and seems like it hasn't been moderated in years. Multiple posts for the same item, they never link materials to all the machines that use it or all the places where you can find them as drops or collection. It's just so annoying, wlodb is way neater.

@ Dark.

Scott and I already thought of that, to have a once-in-a-month purge of any user who didn't post anything, add anything for at least a month.
Might as well add a confirm registration email to prevent people from making spam accounts.

And I know that ever since Melone began to act up, WLODB has been the source for formulas and such to most of us. Me included..

Adam,
The Ruler of all Rulers.

Metatron's looks, compliments of my friend~

Spoiler:

"Leo" Server.

Spoiler:

Earths -
Metatron - 176 Reborn Killer [633/190/31/48/86] (Earth main).
Orelia - 131 Reborn Wit [4/225/341/48/100].
Seraphel - 153 Reborn Mage Knight [31/208/276/60/341].
Zachriel - 81 Reborn Priest [0/395/76/77/0].
Daedalus - 85 Reborn Wit [0/165/312/48/35].

Waters -
Nuriel - 175 Reborn Wit [18/185/507/60/150] (Water main).
Meimiel - 101 Reborn Seer [0/170/172/60/206].
Rhamiel - 81 Reborn Priest [0/395/6/77/0].
Noctus - 88 Reborn Mage Knight [39/193/146/78/308].
Opheus - 83 Reborn Wit.

Winds -
Heimdall - 81 Reborn Wit [0/130/304/49/65].
Anael - 81 Reborn Knight [6/26//10/26/510].
Zofiel - 99 Reborn Killer [586/94/39/39/39].
Anelia - 81 Reborn Knight [190/80/7/49/227].
Hox - 187 Reborn Knight.

Fires -
Zelix - 156 Reborn Killer [615/155/13/42/13] (Fire Melee main).
Alilidier - 160 Reborn Wit [13/167/615/42/13] (Fire Mage Main).
Zeliel - 86 Reborn Killer [476/66/9/45/12].
Seraphinus - 117 Reborn Killer [375/104/9/51/126].
Shadders - 172 Reborn Killer [606/164/4/42/15] (Given alt).
Kronos - 86 Reborn Wit [6/144/395/42/6].
Hades - 86 Reborn Killer [395/144/6/42/6].
Atariel - 136 Reborn Killer [492/180/18/47/66].
Tariel - 130 Reborn Wit [6/145/510/42/22].

Manufacturing Slaves - Dazmond, Misane, Coeus, Perses, Lapetus, Oceanus.
Collection Slaves - SecretC2, SecretC3, SecretC4.
Fish Storage Slaves - Fishslayer, Kronosx, Totoxin.
Equipment Storage Slaves - Oranos, Menoetius.
Burst Slaves:
ShexSlave - 85 Reborn Killer [520/2/2/42/4].
ShwexSlave - 85 Reborn Killer [514/0/0/42/4].
Cusser - 82 Reborn Wit [0/20/511/20/0].

Names for Safekeeping: Dovahkiin

It is so very hard to keep up with the database when I don't play, or I would help. I try to keep all of the dead spammer accounts deleted but since getting a job it's much harder to do.

WLODB will stand as long as the game does. but I do agree that we need a clean up.

It could take days or weeks, though.

Sorry for being a crappy addy..

Aries: Klayton

Kojika wrote:

They must be drunk since they are part liquor and I DON'T even want to know what the hard tissue is referring too so lets just say that's their bones, obviously. Since my mind may have been thinking of something else

"Laughter at the midnight hour, in our own little tower"

Random topics

My chars on Scorpio
Collection of Negative speed items
Show off your tents~
My favorite thing is... [game]
Melon, Doala and others here
Victoria!

USE GOOGLE OR THE SEARCH BUTTON FOR SIMPLE QUESTIONS

darkdeaver wrote:

As for the Spam Posting all is needed is a simple captcha to be entered when hitting Post.

Captchas are nasty. Brishes think Imma a frippin drunkard or something :/ would be annoying to do that, perhaps setting up a timer like the official forum would be a better choice. I think the official forum has a 15 second cooldown before you can post again. Guess if it's really severe, could have like a 5 minute one here, 5 minutes from which you can post again in one thread or just 5 minutes from when you can post again in any thread.

Ruler of the Smexy Abs.

pswk2 wrote:

Captchas are nasty. Brishes think Imma a frippin drunkard or something :/ would be annoying to do that, perhaps setting up a timer like the official forum would be a better choice. I think the official forum has a 15 second cooldown before you can post again. Guess if it's really severe, could have like a 5 minute one here, 5 minutes from which you can post again in one thread or just 5 minutes from when you can post again in any thread.

Hmm I think I rather have the quick and easy 3-4 character Captcha :P We will make a special timer for you JL

- dark

                                   My Guides
Spoiler: 
                                   Guide to Pet Stats and Scrolling
                                   Linux Wonderland Online Guide
                                   Lazy Man Compounding Series
                                   Guide to the Alchemies of WLo
                                   Goddess Skill bursting for Pets
                                   Normal Training with Equip on for lv1-75 Pets and Low-Lvl RBs
                                   Interesting place to Burst Train
                                   Disposible Equipment Guide
                                   How to price your own Items for sell
                                   Pet Return Scrolls - Revisited
                                   Win7/WinVista: Restore your screenshot and auto-update
[Guide] Donation to wlodb.com

                                   wloDB Quick Links
                                   How to search Forums
                                   HTML and BBCodeizer Tags

Gotta Love Virgo Server

Spoiler:

darkdeaver wrote:

Hmm I think I rather have the quick and easy 3-4 character Captcha :P We will make a special timer for you JL

- dark

Sounds like a plan. Don't find it necessary to go through that effort for me though :P I rarely get on the site and post.

I was wondering if the compoundings could be reduced. A lot of them are really not necessary to be there and just take space massevily. It would make more sense to me to only make it able to post compoundings for equipment instead of the 100th crap compounding for something like an Aluminium Block or a Cypress Wood.

Also why not delete the fake compoundings instead of just "hiding" them?

I have said in the past I could take care of deleting the fake ones instead of just turning them into useless compoundings or mark them as fake.

It won't be like the google captcha's right???
i hate the google captcha's!....words all smooshed together takes me 10 mins to figure out wth it is staring a the "n" looking like a screwed up "h" =.= I like alphabet codes that looks straight and correct not quirky and twitchy!

*random thought* kramer from Seinfeld lol

well im glad those spambots won't be coming here anymore. I don't know how they came her in the first place but everytime i wanted to see a compound they got in the way every second registering and it caused so much lag! took 5-15 mins for a compound item to even show lol

The problem isn't the size of the database. Here is what the database looks like:

Here's a bigger picture: http://wlodb.com/files/db.png

You can see it's only 150MB and the compounds only take up about 6MB. It looks like there were some bots or something hammering the site creating accounts non stop which was making it pretty much unusable. The server started swapping a lot of memory and my hosting site kept shutting down my virtual machine until I fixed it.

Unfortunately, wlodb doesn't make much money and I've only had one donation in the past 4 years. I usually end up paying a bit out of pocket every month to keep it up and running even though I haven't played in over 4 years.

I did make some improvements last night. I blacklisted a bunch of the ip's that were creating tons of user accounts. I also fixed the create manufacturing page. I removed the compound and recycle listings from the items pages for now to speed it up a little bit. Since it didn't split those up into pages, someone clicking on common stone would pull up about 1000 compounds which really lagged the site.

Here are the main reasons why the site is slow:

-There is no page caching, every page requires a databse query. This was originally done so the new compounds and items would show up right away. I tried to do some caching a while back, but I'm had a hard time getting it to work.
-The server is slow. It has a quad core AMD processor with only 1GB of memory. It usually sites at about 800-900MB in use and when it goes over and starts swapping, the site doesn't work very well. I have been monitoring the site the past 24 hours and the fixed I made seemed to at least stopped it from swapping so it hopefully won't get shutdown again.
-The bots creating endless user accounts. I think I'm going to at least put a question on the user account page that hopefully the bot won't be smart enough to figure out. Since this is a custom forum and not something like phpbb it might not be smart enough. Once I get this is place I'll open up the user creation again. I do think it will be good to clean up all the useless accounts, but I don't think it will speed up the site at all. Since the DB is so small, it's not the size of the database tables slowing it down, but the amount of databases queries that take place.

The items pages will be like theyre now? I mean, before when i searched for an item, for example cotton, it said its stats, how to obtain it, how to compound it and what it compounds, recycles, etc. Now it only says its stats, i think it was better before. Just saying, i know that wlodb is hard to maintain, im already used to it being unstable for some days, but if it doesnt make the site have problems, please change that thing about the items to how it was before. This is just a suggestion, please dont take it as an offensive post cause thats not my intention.
Sorry if my english is hard to understand.

I reverted the items page back for now.

After checking some of the performance problems I could definitely see some of it was related to the number of users, since it was querying that table on every page visit. I removed all the user id's that did not have any content associated with them. When the botters started creating accounts, they added about 140,000 bogus ones. I deleted about 150,000 accounts today which should definitely help.

I also have a script to monitor the swap usage and restart the web services so this will hopefully stop the hosting company from suspending my server. So if you see the bad gateway error, the services are probably just restarting and should be up within 30 seconds.

I added a security question to the user creation page which I hope will stop the bots. I will keep an eye on the user accounts the next few weeks. I banned some of their ip address and setup some new firewall rules to better protect the server.

I spent some time tweaking the web server and mysql settings. I'm experimenting with some different settings, but the server seems to be running better now.

scott wrote:

I reverted the items page back for now.

After checking some of the performance problems I could definitely see some of it was related to the number of users, since it was querying that table on every page visit. I removed all the user id's that did not have any content associated with them. When the botters started creating accounts, they added about 140,000 bogus ones. I deleted about 150,000 accounts today which should definitely help.

I also have a script to monitor the swap usage and restart the web services so this will hopefully stop the hosting company from suspending my server. So if you see the bad gateway error, the services are probably just restarting and should be up within 30 seconds.

I added a security question to the user creation page which I hope will stop the bots. I will keep an eye on the user accounts the next few weeks. I banned some of their ip address and setup some new firewall rules to better protect the server.

I spent some time tweaking the web server and mysql settings. I'm experimenting with some different settings, but the server seems to be running better now.

Thanks a lot scott! Lets wish no more problems arise here. Why would someone use bots here in wlodb? Being that this site is so used and doesnt harm anyone, i cant understand it

markaux wrote:

Thanks a lot scott! Lets wish no more problems arise here. Why would someone use bots here in wlodb? Being that this site is so used and doesnt harm anyone, i cant understand it

Boredom or some unknown evil reason will make some people do such things. Glad tho that scott have things under control :)

I thought everytime i see that bad gateway thing it was just my laptop or internet messing up on me again XD

Links to important stuff:
Transport Quests: http://wlodb.com/topics/99
WLO Pets: http://wlodb.com/topics/13670
WLO Emoticons: http://wlodb.com/topics/6195

PSN :)

Spoiler:

TAURUS SERVER (NOT UPDATED - NO LONGER PLAY)

Spoiler:

DRAGON CAVE - Click or see them if u will lol ^^

Spoiler: