27 replies to this topic

[MrBenn]

Just throwing out a hypothetical for everyone...If you could get any piece of data out of the "The Neopets Database", what would it be? Assuming they have data on EVERYTHING in the game that's gone on since it started, which they probably haven't.

 

How many MSPPs are there hidden away? Who has the most NP in a bank? What's the most amount of stocks anyone has? Anyone got a million codestones hidden away? etc etc. I'm sure you can all come up with more interesting things that, just some examples. I'm bored, can you tell?

 

 

Thought this might appeal since there are some many other data nerds on here...

Edited by MrBenn, 12 February 2013 - 07:25 AM.

[Cript]

What algorithms do the bots use for automatic freezing.

[MrBenn]

What algorithms do the bots use for automatic freezing.

Ha, good answer!

 

I wonder if anyone in the cheating community has ever tried to run any large-scale tests to try and improve their understanding of auto-freezing. I.e. making a ton of accounts using different cheating strategies.

[Doomsday]

What algorithms do the bots use for automatic freezing.

What about the algorithm to just input NP or items into any account.  One would have to exist, as TNT are able to do so when rewarding users for site events etc.

 

Ha, good answer!

 

I wonder if anyone in the cheating community has ever tried to run any large-scale tests to try and improve their understanding of auto-freezing. I.e. making a ton of accounts using different cheating strategies.

Despite it not being known for certain, a large number of users have managed to cheat for years without having accounts frozen.  It's more stupid risks and mistakes that get people auto-frozen by doing something they KNOW they shouldn't do but see the pay-off as worth it.

[MrBenn]

I meant more like snippets/summaries/totals of information you could pull out of their databases rather than dissecting their code, but all answers welcome

[shrouded]

What algorithms do the bots use for automatic freezing.

 

Everyone's efforts are over at this point. It's been easier to just move on to more devious methods of getting NP to sell.

[Doomsday]

I meant more like snippets/summaries/totals of information you could pull out of their databases rather than dissecting their code, but all answers welcome

I gathered as much but when Cript gave his answer, I was curious as to why he'd look at that rather then the legitimate generation of items and/or Neopoints.

[MrBenn]

I'd be interested to know the numbers behind frequency of restocks and frequency of restocks of set rarity items. So you could work see how many r99s are likely to stock per day/week etc. Not that you could do a huge amount with that data, but I'd be interested to know!

 

Mind you, I guess we could compile a rough estimate of that from what we have have in the item Db here...There must be thousands of instances of Abrosia running and monitoring restocks...

[Waser Lave]

I'd be interested to know the numbers behind frequency of restocks and frequency of restocks of set rarity items. So you could work see how many r99s are likely to stock per day/week etc. Not that you could do a huge amount with that data, but I'd be interested to know!

 

Mind you, I guess we could compile a rough estimate of that from what we have have in the item Db here...There must be thousands of instances of Abrosia running and monitoring restocks...

 

We now provide some information on when previous restocks for each item have been seen but obviously we don't have information on every single restock of every single item.

[Scot]

I'd like to know what they were smoking when they drew this

[MrBenn]

We now provide some information on when previous restocks for each item have been seen but obviously we don't have information on every single restock of every single item.

 

Yea I know. But there is potential there for it to be taken further with some analysis to be done using that data that could give answers to questions like "Abrosia has seen 12 rarity 99 items restock in shop X in the past week" or whatever. That's not a request, just sharing my thoughts

[Syntax]

I'd want to know how to get admin access. That would be a lot better than knowing the rarities and stuff, cause basically you can set it to whatever you want.

[Waser Lave]

Yea I know. But there is potential there for it to be taken further with some analysis to be done using that data that could give answers to questions like "Abrosia has seen 12 rarity 99 items restock in shop X in the past week" or whatever. That's not a request, just sharing my thoughts

 

Well that's the kind of idea for what we're looking to do in the future but it's a bit early to be able to get anything meaningful out of the information yet so it'll have to wait while we work on other projects.

[MrBenn]

I'd want to know how to get admin access. That would be a lot better than knowing the rarities and stuff, cause basically you can set it to whatever you want.

 

Ha

 

Maybe less of the "I would wish for another wish" style responses What sort of information would you be really interested to see?

[Doomsday]

By looking at the database you wouldn't be able to see how you could get admin access, but hypothetically if we have the time to change the 1 item of information we are looking at, we would be able to change our user access level to that of a higher level.

 

There have been a number of NP sinks over the years to try and scrub some NP out of the economy.  An interesting (albeit useless) piece of information to see would be two-fold;

What is the total amount of pure NP currently in the economy (calculated by the number of NP on hand + in shop tills + in user banks at the time of looking) vs how many NP has been created since the site began.

Edited by Doomsday, 12 February 2013 - 08:23 AM.

[Syntax]

Oh. Alright then. I'd probably like to know exactly how they freeze accounts. Lets say you get a reviewed score on a game. I'd like to know info like how much can the reviewer see about your account. Can they see the transfer of pets/items/nps etc and does that come into play when considering freezing? I don't AB in the high profit shops so I don't really care about the rarities, but it'd be nice to know how far you can push before it gets too suspicious.

 

Of course, it's just smart to assume they can see everything right now.

[Doomsday]

Oh. Alright then. I'd probably like to know exactly how they freeze accounts. Lets say you get a reviewed score on a game. I'd like to know info like how much can the reviewer see about your account. Can they see the transfer of pets/items/nps etc and does that come into play when considering freezing? I don't AB in the high profit shops so I don't really care about the rarities, but it'd be nice to know how far you can push before it gets too suspicious.

 

Of course, it's just smart to assume they can see everything right now.

Finding out how they freeze accounts wouldn't be accessible by looking at the database as posed in the OP.  That would come under looking at their procedures.  I guess it's possible to write a database query to find out some of the information that you're interested in knowing, but for all of that information, it's more likely that a query of server logs would be required rather then the database.

[MrBenn]

By looking at the database you wouldn't be able to see how you could get admin access, but hypothetically if we have the time to change the 1 item of information we are looking at, we would be able to change our user access level to that of a higher level.

 

There have been a number of NP sinks over the years to try and scrub some NP out of the economy.  An interesting (albeit useless) piece of information to see would be two-fold;

What is the total amount of pure NP currently in the economy (calculated by the number of NP on hand + in shop tills + in user banks at the time of looking) vs how many NP has been created since the site began.

 

Yea it'd definitely be interesting to see how much NP has been released into the game, how much is in active accounts, how much is frozen etc.

[Syntax]

Finding out how they freeze accounts wouldn't be accessible by looking at the database as posed in the OP.  That would come under looking at their procedures.  I guess it's possible to write a database query to find out some of the information that you're interested in knowing, but for all of that information, it's more likely that a query of server logs would be required rather then the database.

 

That's a good point. I'm assuming that the Neo DB covers everything, including office/admin matters. I'm most interested in how they handle accounts; board policing, freezings, even the monitoring of sites like Codex.

[Doomsday]

Yea it'd definitely be interesting to see how much NP has been released into the game, how much is in active accounts, how much is frozen etc.

I was only thinking about amount in active accounts vs total amount generated.  I never considered frozen accounts.

 

I guess what I would like to see would be 3 parts of information;

Total amount of pure NP in active accounts

Total amount of pure NP in frozen accounts

Total amount of pure NP generated by the server

 

Server - Active - Frozen would show the amount that was 'donated' by users into sinks (as well as continued to be 'donated' as the Wishing Well is still a small time NP sink)

[MrBenn]

I was only thinking about amount in active accounts vs total amount generated.  I never considered frozen accounts.

 

I guess what I would like to see would be 3 parts of information;

Total amount of pure NP in active accounts

Total amount of pure NP in frozen accounts

Total amount of pure NP generated by the server

 

Server - Active - Frozen would show the amount that was 'donated' by users into sinks (as well as continued to be 'donated' as the Wishing Well is still a small time NP sink)

 

It's funny to think about the fact the the majority of the NP in the game must have been introduced via flash games and possibly stocks. Aside from Lenny conundrum and dailies dishing out a few NP I can't think of many of sources that actually inject NP into the game. Unless I'm missing something hugely obvious.

[Doomsday]

It's funny to think about the fact the the majority of the NP in the game must have been introduced via flash games and possibly stocks. Aside from Lenny conundrum and dailies dishing out a few NP I can't think of many of sources that actually inject NP into the game. Unless I'm missing something hugely obvious.

Both Flash and HTML games (such as Jub Jub Blackjack / Poker / Kacheek Seek).  Although most of these have got limits as to how much could be generated in a day (ie 3k per flash game per day, so many plays of the HTML games per day etc)

Stocks

Dailies

Site competitions

 

If we're looking at statistics regarding NP, I guess looking at how much NP was generated via various methods would also be some information that could be interesting to look at.

[andyhoi]

Don't forget food club as a way to generate Nps. I spend 90k a day on food club and get around 150k out of it just by following other people's bests.

[MrBenn]

Don't forget food club as a way to generate Nps. I spend 90k a day on food club and get around 150k out of it just by following other people's bests.

Yea good point, I forgot about FC. I sometimes do it but usually forget.

[darktank]

Both Flash and HTML games (such as Jub Jub Blackjack / Poker / Kacheek Seek).  Although most of these have got limits as to how much could be generated in a day (ie 3k per flash game per day, so many plays of the HTML games per day etc)

Stocks

Dailies

Site competitions

 

If we're looking at statistics regarding NP, I guess looking at how much NP was generated via various methods would also be some information that could be interesting to look at.

 

I'd actually be pretty interested in how much NP could be gained from all the passive ways in Neopets. Games and other things I think take too much time. For example, food club and the stock market are two things you can do that take less than 5 minutes a day and you can make a lot of NP. I wonder what the what things you can do that have the best Neopoints to time used ratio.

Edited by darktank, 14 February 2013 - 01:42 PM.