Question

我在MySQL数据库中储存了一张底卡的掩体和黑色劫持游戏。为了填充这些卡片,我随意使用RAND(RAER)的表格,并将卡片插入一个不同的表格。使用RAND(RAND)是否会产生实事求是的难题,会发现这些困难与真实的卡片和身体上的缺陷,或者这一功能是否不够随意?

Answer 1

如果你不做很多事情,那么用真实的卡片进行打真的就是这样。很容易以不正确的方式加以扼杀,使包装的顶部或底部都 well得好。

利用RAND(RAND)(ORDER)sh,是一种合理的做法,但有一些事情需要了解:

A slight bias is introduced if two exactly equal random numbers are generated by RAND() as it will not shuffle those two cards correctly with respect to each other.
RAND() is not cryptographically secure. By seeing some of the first cards in the deck it might be possible for a skilled attacker to deduce the internal state of the PRNG used to shuffle the deck and therefore predict the remaining cards.
ORDER BY RAND() requires O(n log(n)) operations. It will most likely have acceptable performance for shuffling 52 rows, but it is probably not something you want to use for shuffling millions of rows, for example.

For entertainment purposes your approach should be fine. If this is for serious money you might want to use a better shuffle algorithm such as the Fisher Yates shuffle and cryptographically secure random number generator.

Answer 2

供您使用:可原谅。

从赌博行业角度看: 页: 1

Nevada Gaming委员会负责监督这里核准的游戏的奇迹和随机性。为此,消除循环器的可能性符合房屋的利益,因此,真正的赌博软件使用到期的“随机”种子,必须通过认证方法获得(通常使用一些自然混乱的输入)。银行经常使用类似的工具。

供进一步阅读,见LavaRand

http://www.lavarand.com/。

友情链接