Random Number in HUD?

[Olaf72]

I'd like to have a random Number in the HUD.
It should change every HUD-update.

It doesn't have to be that perfectly random. The milliseconds or seconds of an actual timestamp would do.

[kraada]

This can be done. What kind of precision did you want - from 1 to 10, 1 to 100, 1 to 1000?

[Olaf72]

Great - thanks.

1 to 100 would be fine

[kraada]

Create a new column as follows:
live_random_number: (SELECT extract(milliseconds from now())::int % 100) * (live_cash_table.amt_bb / live_cash_table.amt_bb)

This will give you the last two digits of the current time to the millisecond. Create a stat using it and you should see it working in your HUD directly.

[Olaf72]

Didn't work.
But this one does.

(SELECT extract(milliseconds from now())::int % 100) * max(cash_hand_summary.id_hand / cash_hand_summary.id_hand)

thanks.

[kraada]

That one works but you must name the column starting with "live_". It should work better for you as time goes on as the live stats are just based on the very last hand data and will be queried separately.

[Olaf72]

Aha... That live_..... columns don't work with Pokerstars-Zoom-Tables? right?

[kraada]

I think it still should but I haven't tested it.

[QqNwG207phyYezgo]

Hi,

I want to add 3 a 6 random numbers in my HUD.

I have used the following for first one and it works.
live_random_number: (SELECT extract(milliseconds from now())::int % 100) * (live_cash_table.amt_bb / live_cash_table.amt_bb)

The moment I copy the above in a second column (in an attempt to create another random number) it just generates the same output as the first column.
Something like
SELECT RAND() AS [live_random_number02]
and some variations upon it also does not works.

Do you know a method to create multiple random numbers?

Thanks in advance

[kraada]

You'll get the same number for your second column because the query for live tables are all run at the same instant - so you'll only get one millisecond answer.

The actual postgres function is called random() so what's probably easiest is to create a custom non cached column that just reads:

select random()

and then a stat whose value expression is that number. random() gives you a random number between 0 and 1 -- see here for more details.