Muratus del Mur

Analysing the associated data of the deleted accounts, i can tell that these were accoutns that were never actualy too active (90% of them not all). From 120k accounts there were for example only 163 pm messages. Only half of the creatures in game were associated with those accounts even if compared to the remaining 30k accounts they were the majority. I think this was a much needed cleanup, but i am woried how many people give up before they do anything. I might change the initial phases of the game to be more permissive (and addictive) so that more new players reach later stages. I think if they simply quit the same day they join they do not realise what they are missing

fighting will be slow for a bit more, currently i am deleting old and unused combat strategy records, quite a lot of them. After this there is only the market items cleanup and then the inventory and transfer of items will be slow, but thats not a problem. Remember the site will become faster and faster as the cache loads again. someone do me a favor and test a brand new acount untill it reaches mp4 please? login logout several times also during story mode to check dna-story bug too. Thank you

OFF TOPIC (you can (re)move) i just checked an ancient account, look at the age of this creature (id is around 600 !)

MD is back 4 more processes to run , but i will run them later today and they will not cause to much trouble except one mysql reset.

this procedure will never be so heavy again, i think that next time when i will run it, it will have just a few thousands records to process and will take just a few minutes, so this is one time event. ..almost done

no the contest wont be restarted, why should it? the site is down for all

worst case scenario is that i will put a backup up from 2 days ago and repeat the procedure, but the backup might contain the modified accounts allready because this is allready happening for a day...and on top of that, i never used the system backups, i have no clue if they work Second scenario, the most probable one, is that the removed accounts wont be recovarable with all their data. I messed one of the settings table that holds info such as spelldocs, friends, a few mdshop features, but the rest should be just fine. This scenario might be the good one. Its about 200 lines of mysql code to run, i had to do it several times because it took over 6 hours to run and it didnt seem to finish. I found out later that this is because of mysql bug. Now the script runs in about one hour, but i am still working on it. Once this is complete, the next time things will go much much faster and safer, but now its first time and its running on data for over 2 years ..so ... I think in about one hour or less will be up, currently transfering about 200.000 creatures...the remaining data is much smaller I have to keep md closed during this process because tables get locked and you would see only errors from 5 to 5 minutes and the process will run much slower. i wonder why the 8 cpu cores are so relaxed instead of doing a "team effort" to finish this .... i will probably torture hosting after this...

seems the cleanup query is very heavy, it runs for some time now, one of them failed due to lost connection, but if i stay one more minute i sleep on the keyboard. I let it run untill tomorow, no MD untill then.

Today (its running while i write this actualy) i deleted old inactive accounts. I am sad to tell that it was a huge number of accounts removed, 121000 out of about 156000. I checked several times to make sure i am not deleting the wrong accounts. The accounts along with the associated data, creatures, docs, messages, etc, were transfered to a backup table and they will remain there untill the next cleanup that will be probably done in two/three month or so. Tehnicaly they can be recovered but i do not have a way yet to do that easily. I hope everything went right and then there is no need to recover anything, but if somehow i deleted IMPORTANT accounts, please post here and i will conduct an investigation and recove whatever i can from them. Do not bother me for alts that are 10-20 days old. Once i will finish a system to recover these accounts automaticaly, you will see this option when trying to register or login with such a disabled account, but untill then its dificult, but possible, to recover them if realy needed. The rules used to determine the inactive accounts are these: - More than 2 month since last login and less than 5 active days and no valid email confirmed - More than 4 month since last login and less than 10 active days - More than 6 month since last login and less than 40 active days - More than 8 month since last login - All rules filter out also NPC and RPC accounts (but not PWR) Please let me know if you consider there is a problem with these rules. Important note, the avatars of such disabled accounts will go back in the avatar gallery and will be available for anyone to get. There are over 400 avatars in game right now but in time many accounts become inactive so their avatars go wasted without good reason. I will update you as soon as the process is finished, right now its still running and seems to be very very slow. I hope that after this the database will be much faster. The player table alone had over 1Gb in size.

156954 total accounts in the DB todays stats: New last 30/60days: 3681/5449 Registered today: 70 (104 in 24h) Playing over 6 month: 681 Advanced to MP4 today: 1 Active today: 550 (653 in 24h) Active in 48h: 914 Note that advertising was stoped for a large period of time and that this is basicaly one of the worse period for traffic and newcommers. usualy there are about 150 new and about 1500 active daily. During intensive campaigns there are 500-600 new and 3-4000 active Accounts cleanup will be done for accounts inactive in the past 4-6 month or so. I am even considering 1 year inactivity for deleting accounts, because some players that become legends still remain legends after a long time and its not what i want to have those accounts deleted. I am considering also a temporary hold method so that i can move inactive accounts to a different database and like that never delete them entirely. With 150k accounts is not such a big problem right now....or is it? .... user table is about 1Gb in size which is quite heavy for text data.

can you keep a updated list with video links and player name/ids? It would be great

) some of you stayed too much in the sun i guess. Conclusion: I should be afraid of the mighty SALAD ...its the death of the tomato!!!! beware of the salad!!

how i feel about this....... .....worried O.o..... *blinks repeatedly*

when i am invited but for now i think there are plenty of lecture / debate subjects to discuss based on the "Best Question" competition... so i know you enjoy mine, but why not let others try too.

she means that by "saving" those areas, what they did was actualy to "modernise" them and bring commerce and lots of uneducated people into them , people that caused a lot fo damage....or at least thats what i think she ment. Esmerelda.... none of the rich people i know...and i mean NONE..and i know rich ranging from above average to millionairs .. throw their garbage on the street just because is more confortable... none. dst, in this matter its not so important what the people in charge do, its about what the majority does, and thats changed by education. Put same rules in a "civilised" country and you will see how people do not abuse them. I go crazy when i see this indifference and careless attitude towards environement. We feel more confortable to blame others. THe best thing we could possibly do is to try to convince others of doing these small environement friendly things, like i do now, because one recycled paper wont matter, but one from a lot will matter a lot. btw, you know this? [url="http://www.youtube.com/watch?v=jqxENMKaeCU"]http://www.youtube.com/watch?v=jqxENMKaeCU[/url]

education i think. what is lazy about buying the one bag or the other? its a matter of choice. its the same effort to throw the package at home in the right place than on the street. Its not lazy its lack of education and the simple fact we do not care and that we think it wont matter anyway..... well i say it does matter, even the smalles act. Multiply it by millions or billions of people and see how important is then.

"supposed to be civilised" is what brought us in the situation of almost depleting natures resources. I think a more practival approuch is better. True we don;t have many options to help with this but if you think from the start we hate the environment just because we cant help it a lot, it will be much worse. I think that even the smallest steps matter a lot, and even if we do tiny things in this regard, it will still matter. dst, you should know that better than all. In our country, civilisation is an issue because of these small things i am talking about. If each person would think just a second that not throwing the biscuits packing behind that parked car would help greatly with the overall civilisation level of the entire country, we would live in a much cleaner city with a lot less garbage and such things....but its in our bad nature that we think that small things do not matter so we keep doing them and complain its a bad situation overall and that nobody does, or can do, anything about it. We are like ants comparing to the situation, but ants are strong because they work together. For example a small gesture like using recycled paper which is almost the same white and quality overall, will matter quite a lot. Just by picking between biodegradable things and non bio degradable things, like the plastic vs paper bag in the shopping center, matters a lot. I am not talking about using environement friendly houses, doing our own electricity, consuming bio food, and such things...thats science fiction for most....but i think its more important that 1000.000 people buy a biodegradable bag instead of just one to build a environement friendly house. "My humble opinion."

I don't think you could go more generaly offtopic with any other subject...lol i can't imagine myself doing something as offtopic as this entire topic ..but its funny. anyway, speaking about environemen, i proudly announce that MD is hosted on servers with low carbon signature / friendly to nature. I put a link on the bottom of the interface. Its not advertising to hosting, its just that i am very into this 'green' things, from recycled paper to nature friendly server, its a small thing, but big things are done from lots of such small things.

list, where

hehe i never ment for the fighting system to be clear and mathematical (even if it is at its base). I ment it to be used and understood at a more intuitive level. You fight, you get the desired results, you learn that is "good". Its much more relaxing, and i bet the results are afterall the same on the long run as when you try to calculate all the odds. My "test" for the fighting system is to create a character and attack randomly just adjusting/healing from time to time creatures but not for a purpose and looking 70% of the time to honor just not to destroy it entirely. Last time i checked like that was indeed long ago, but it worked like a charm. While most of you complained something is wrong and they cant get enough won , or lost, fights, my test account passed through the nightmares any noob passes but then it became stable and quite usable. The new fighting system is even more abstract because of its nature. I don't think i will make public any values like with the creatures. Overall it will be simpler to master than the creatures system. The fights will be slowmotion events that you can train yourself into before doing. I plan to put more focus on the results achieving than on understanding the mechanism behind the fight itself. but i talked enough, so far its damn comlicated and i think i got stuck again. The little crits won't breed whatever i do to them ... grrr..and they wont kill either..they just move around and group in gangs.

Archivists sent me the calendar for this month , its entirely my fault is not up. sorry

movies about md , i hope ok, let me explain it differently, i am putting a rustgold , with one token...so what are you waiting for. p.s. yes i said rustgold, not drachorn.

there will be one more round of questions, i will read my "question pms" soon and post them here, then, i will read the forum pms, even if i told you NOT to send me by forum pm, but lets see if its something interesting in there. So no, i will not reply or post your questions as you send them, but all at once at the end. one , or two more days.

whatever the reward for this contest is, i will double it

yes anyone can initiate a debate BUT that person must also hold it, organise the even by getting an archivist to document it, establish time and day, make a plan for himself about what will be discussed (if needed) etc. Not just ask a question in chat and think that was a lecture. The reward is not disclosed because it will be tailored based on the final winning question(s).