![]() |
|
MTS temporarily offline - Printable Version +- Southperry.net (https://www.southperry.net) +-- Forum: Main (https://www.southperry.net/forumdisplay.php?fid=11) +--- Forum: Nexon Announcements (https://www.southperry.net/forumdisplay.php?fid=20) +--- Thread: MTS temporarily offline (/showthread.php?tid=39851) |
MTS temporarily offline - SaptaZapta - 2011-03-28 Eosian Wrote:There is no built in reason for a game server to ever crash based on the actions of a player, ever. That sort of thing can always be fixed. That's exactly it. Their server and database were apparently built quite incompetently. Hence, the bugs are currently built-in. It can be fixed, or more accurately rewritten/restructured, but it's not something they can do in hours while MTS is "temporarily" down. Eosian Wrote:They could easily add a purge-all-items-with-duplicate-ids query to their weekly maintenance checks even. A lot less incentive to dupe if both the original and the dupe are going to be wiped regardless of who has either. Are you sure they have individual item ids? If that's so and they are not using that info to take care of duplication, what is it even there for? Also, what about valuable non-equips that can be duped? Surely a stack of 100 whitescrolls doesn't have an id attached to each scroll? MTS temporarily offline - ShanghaiDizzy - 2011-03-28 Game's down now, too. MTS temporarily offline - Pixie - 2011-03-28 ShanghaiDizzy Wrote:Game's down now, too. No post on the site yet, just "MapleStory game is currently offline. Please check back shortly for updates!". MTS temporarily offline - Dark Zero - 2011-03-28 ShanghaiDizzy Wrote:Game's down now, too. this is nexon complete fail now.... MTS temporarily offline - Eos - 2011-03-28 http://www.southperry.net/showthread.php?t=41753 MTS temporarily offline - Stereo - 2011-03-28 SaptaZapta Wrote:Are you sure they have individual item ids? If that's so and they are not using that info to take care of duplication, what is it even there for? Equips have the potential to have unique stats (in the actual meaning of the word), so they need individual item IDs to know what each player has in their inventory. I don't really know what happens when you dupe items, though... maybe the MTS has its own unique IDs, and it spawns new item IDs every time you remove an item from the MTS. Would not surprise me. Valuable non-equips are still a problem, but not as big. Techniques like duping 5 slot gloves, 30%ing them all, duping the success, etc. turn multiplicative probabilities for scroll success into additive ones - you can make a +5 30% glove for only 1 item + 17 scrolls, instead of 411 scrolls and ~350 equips. MTS temporarily offline - Eos - 2011-03-28 SaptaZapta Wrote:That's exactly it. Their server and database were apparently built quite incompetently. Hence, the bugs are currently built-in. It can be fixed, or more accurately rewritten/restructured, but it's not something they can do in hours while MTS is "temporarily" down. Honey I'm a professional DBA, we can fix their database structure in virtually no time, even while the game is online and running, by adding in columns that to the game don't exist/matter but to the DB do. A few constraints, a trigger here and there, or even a job that runs nightly or gets run during maintenance and most of what they experience would be addressed. As for IDs, each unique instance in memory can have an ID at the time it's created. It's very simple to do this. Stacked items are merged - One ID survives, the others don't and the quantities increase. Here's a very basic two minute dupe-check I wrote & released for SMAUG for in-memory testing back in '99-'01. Today's modern programming and this being a database-saved game makes it even easier because you can just add an identity column to do all the work without even touching the actual source code.
Spoiler
MTS temporarily offline - SaptaZapta - 2011-03-28 nvm @Eosian: I defer to your greater knowledge. MTS temporarily offline - Eos - 2011-03-28 SaptaZapta Wrote:If it's a unique id, defined in the database as a Unique Key If Brazil was indicative, they didn't make it unique, primary, add constraints or even indexes. MTS temporarily offline - SaptaZapta - 2011-03-28 Eosian Wrote:If Brazil was indicative, they didn't make it unique, primary, add constraints or even indexes. *facepalm* MTS temporarily offline - Stereo - 2011-03-28 Too bad you can't get a competent DBA for the prices NXAM will pay. Lol. MTS temporarily offline - Eos - 2011-03-28 Stereo Wrote:Too bad you can't get a competent DBA for the prices NXAM will pay. Lol. I know people who'd do it pro bono under an NDA just for the satisfaction of knowing they made it better. Including myself. MTS temporarily offline - KhainiWest - 2011-03-28 Eosian Wrote:I know people who'd do it pro bono under an NDA just for the satisfaction of knowing they made it better. Including myself. Then shut the pineapple up and volunteer@@@@. Seriously though. I hate how maplestory is a great game with poor management. I grew up with it, I want to go back to it, but the farther I step back the more I see that the game is just about surviving the next exploit. MTS temporarily offline - Eos - 2011-03-28 DustBunny Wrote:Then shut the pineapple up and volunteer@@@@. How do you know I haven't? :f6: MTS temporarily offline - KhainiWest - 2011-03-28 Eosian Wrote:How do you know I haven't? :f6: I know I haven't been exposed much but the @'s imply sarcasm with me. But have you? What was their response, I'm honestly curious. MTS temporarily offline - Eos - 2011-03-28 DustBunny Wrote:What was their response, I'm honestly curious. Quote:Hello Eosian, MTS temporarily offline - Sarah - 2011-03-28 Eosian Wrote:.Hahaha, she didn't even read your inquiry. You should've responded with "Read what was said, not what you think was said" MTS temporarily offline - KhainiWest - 2011-03-28 Thats when you do the Live free or die hard* approach and burst into their main office, take a laptop, cause the server to crash, pull up two more laptops with links to all the hacking websites where you got the information on how to crash their server. MTS temporarily offline - SaptaZapta - 2011-03-28 Sarah Wrote:Hahaha, she didn't even read your inquiry. What makes you think they'd read that? Automated mail response, same as their ticket responses. They block themselves so tight from those pesky players, they can't even hear when someone wants to help them. MTS temporarily offline - Sarah - 2011-03-28 SaptaZapta Wrote:What makes you think they'd read that? It was a joke, as Hime is famous for saying exactly that instead of responding to serious questions / criticism about anything she says. Well, I don't know if she still does, but she used to. |