open All Channels
seplocked Sell Orders
blankseplocked [lottery] Win a Tempest Tribal Issue (TRIBAL) - Winner announced
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: first : previous : 1 2 3 4 [5] 6 7 8 9 ... : last (10)

Author Topic

Chribba
Otherworld Enterprises
Otherworld Empire
Posted - 2009.04.23 16:09:00 - [121]
 

Regarding the SQL statement, like V0ny said, if pilot purchases 10 tickets, he/she will get 10 entries rather than one single.

And to the statement itself, the one stated is a shortened one from the one that is actually used as I don't wanted to reveal the table name.

But the full statement that is executed is:

SELECT TOP 1 FROM theTableName WHERE MESSAGE = 'TRIBAL' ORDER BY NEWID()

theTableName obvsiously replaced with the real name. NEWID() is MSSQL's variant for returning random entries, and the "TOP 1" is MSSQL's statement to return one single record ("LIMIT 1" on the end in MySQL iirc).

While I could leave out TOP 1 and simply read the first name coming up or displaying just a single entry with "TOP" doesn't really matter imo as if I wanted to do a selective drawing I could just skip the whole database query all over.

My apologies if my description of the database query was vauge, I blame the character limit of a post that made me shorten it a bit.

Xiaodown
Guiding Hand Social Club
Posted - 2009.04.23 16:17:00 - [122]
 

Originally by: Chribba
Regarding the SQL statement, like V0ny said, if pilot purchases 10 tickets, he/she will get 10 entries rather than one single.

And to the statement itself, the one stated is a shortened one from the one that is actually used as I don't wanted to reveal the table name.

But the full statement that is executed is:

SELECT TOP 1 FROM theTableName WHERE MESSAGE = 'TRIBAL' ORDER BY NEWID()

theTableName obvsiously replaced with the real name. NEWID() is MSSQL's variant for returning random entries, and the "TOP 1" is MSSQL's statement to return one single record ("LIMIT 1" on the end in MySQL iirc).

While I could leave out TOP 1 and simply read the first name coming up or displaying just a single entry with "TOP" doesn't really matter imo as if I wanted to do a selective drawing I could just skip the whole database query all over.

My apologies if my description of the database query was vauge, I blame the character limit of a post that made me shorten it a bit.


In before "Postgres has more random randomness than any other database, but those MySQL / MSSQL people just don't know it yet!".

Siri Blue
Gallente
Arachnea Phoenix Battalion
Phalanx Alliance
Posted - 2009.04.23 16:23:00 - [123]
 

You should just roll dice - non-digital randomness ftw Razz

Taizu Lilith
Minmatar
Re-Awakened Technologies Inc
Posted - 2009.04.23 16:40:00 - [124]
 

Bought 5 tickets, the Hel was tempting but this is even more so.


bonkerss
Gallente
NucleoTech
Posted - 2009.04.23 17:07:00 - [125]
 

5 for me pls Smile

Mifter Hogdido
Amarr
Dark-Rising
IT Alliance
Posted - 2009.04.23 17:17:00 - [126]
 

I paid for 25 tickets with TRIBAL in the reason but the check tickets page is still not showing them almost a day later... Confused

Quazal Atreides
Gallente
Low Orbit Industries
Posted - 2009.04.23 17:24:00 - [127]
 

Originally by: Mifter Hogdido
I paid for 25 tickets with TRIBAL in the reason but the check tickets page is still not showing them almost a day later... Confused


it is on there :) have checked mself and this is result

Mifter Hogdido 2009-04-22 22:45:00 250 000 000 25

Remeber you need to enter your name fully

comrade captain
Posted - 2009.04.23 17:35:00 - [128]
 

Isk sent for 5 tickets, fingers and toes crossedVery Happy

Mifter Hogdido
Amarr
Dark-Rising
IT Alliance
Posted - 2009.04.23 17:40:00 - [129]
 

Ah weird. I see them now. Smile

Rheinkraft
Eternity INC.
-Mostly Harmless-
Posted - 2009.04.23 18:02:00 - [130]
 

iskies sent


Apostrophe Man
Posted - 2009.04.23 18:55:00 - [131]
 

Edited by: Apostrophe Man on 23/04/2009 19:10:52
I had a panic issue with my isk donation, and Chribba was kind enough to help me personally and solve the issue (which wasn't an issue at all, just an API-takes-longer-than-youd-like thing).

So, yeah, now two donations appear where they should.

Thanks, Chribba!

Chayni
Gallente
Revolution Industries
Dune Heretics
Posted - 2009.04.23 19:17:00 - [132]
 

5 tickets purchased. Will be watching for confirmation at the specified link.

sadid
Ministry of War
Posted - 2009.04.23 19:43:00 - [133]
 

isk sent.. my first time and Chribba
popped my chrry Laughing

Omnoms
Amarr
IDLE GUNS
IDLE EMPIRE
Posted - 2009.04.23 20:30:00 - [134]
 

I have met Eliott Manchild, and I would say you couldn't meet a nicer bloke. I hope he doesn't cry too much about selling off his Pest.
I know he loves it.


BTW if I win it, I'm gonna use it for mad PVP and gate camping.

F90OEX
F9X
Posted - 2009.04.23 21:03:00 - [135]
 

Originally by: Omnoms
I have met Eliott Manchild, and I would say you couldn't meet a nicer bloke. I hope he doesn't cry too much about selling off his Pest.
I know he loves it.


He won't cry when he see's the profit made from this auction Very HappyVery Happy


Mang0o
Caldari
North Eastern Swat
Pandemic Legion
Posted - 2009.04.23 21:11:00 - [136]
 

i will never win, but still worth buying a ticket or two Laughing

Pipecock Jackxon
Gallente
Posted - 2009.04.23 22:21:00 - [137]
 

friendly bump

CyrusXX
Posted - 2009.04.23 22:30:00 - [138]
 

bought 20 :P

i want this ship

Ludi Burek
The Player Haters Corp
Posted - 2009.04.23 23:15:00 - [139]
 

Let's try my luck again. Hopefully this lottery won't fail like the last time I won this ship Laughing

elnukeo
Minmatar
Heretic Army
Posted - 2009.04.23 23:38:00 - [140]
 

Isk sent for 6 tickets!
i am a winner

Devilish Ledoux
Caldari
GoonWaffe
Goonswarm Federation
Posted - 2009.04.24 00:32:00 - [141]
 

Originally by: Siri Blue
You should just roll dice - non-digital randomness ftw Razz


WTB 10,000 sided die.

Raneru
Combat and Recon
Posted - 2009.04.24 00:36:00 - [142]
 

Tickets purchased, hopefully I'll never have to do another mission again Very Happy

Pokerizer
Brutor Tribe
Posted - 2009.04.24 00:39:00 - [143]
 

20 fer me

MrAssasin
Minmatar
Nex Exercitus
Raiden.
Posted - 2009.04.24 00:48:00 - [144]
 

ok thanks chribba sent the right ammount this time 5 tickets plez

Sun Ra
Euphoria Released
HYDRA RELOADED
Posted - 2009.04.24 01:21:00 - [145]
 

I want this so bad Sad

Jormungand Altruis
Amarr
Posted - 2009.04.24 01:23:00 - [146]
 

Edited by: Jormungand Altruis on 24/04/2009 01:26:53
Originally by: Devilish Ledoux
Originally by: Siri Blue
You should just roll dice - non-digital randomness ftw Razz


WTB 10,000 sided die.

4 d10 of colors A, B, C, and D.
Color A is thousands
Color B is hundreds
Color C is tens
Color D is ones.
If they all come up "0", number 10,000 wins. Or just start the list at "0000" instead of "0001". As long as you define which color is which value before rolling, its fine.

ETA: How often does that checker update?

Liranan
Silver Snake Enterprise
Against ALL Authorities
Posted - 2009.04.24 01:34:00 - [147]
 

Five tickets please.

Val Kaleth
Minmatar
Kippered Snacks
Posted - 2009.04.24 01:52:00 - [148]
 

got 2 tickets

Jinn Death
Posted - 2009.04.24 02:07:00 - [149]
 

WOW Nice Prize, I am New to the Game and could only buy 10 tickets but its really cool that your doing this.. Laughing

Phelix Jung
Born-2-Kill
WE FORM VOLTRON
Posted - 2009.04.24 02:18:00 - [150]
 

cool, isk sent for 1 ticket Cool



Pages: first : previous : 1 2 3 4 [5] 6 7 8 9 ... : last (10)

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only