Pages: 1 2 3 4 [5] 6 7 8 9 10 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
|
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.
Win a Tempest Tribal Issue for 10M ISK |
|
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 Hoodlums Associates
|
Posted - 2009.04.23 16:23:00 -
[123]
You should just roll dice - non-digital randomness ftw
People for Stuff Raffle - No ISK needed
|
Taizu Lilith
Minmatar Re-Awakened Technologies Inc Electus Matari
|
Posted - 2009.04.23 16:40:00 -
[124]
Bought 5 tickets, the Hel was tempting but this is even more so.
|
bonkerss
Gallente SoulFuric Industries The Lancea Sanctum
|
Posted - 2009.04.23 17:07:00 -
[125]
5 for me pls
together we're invincible |
Mifter Hogdido
Amarr The 0ri
|
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...
|
Quazal Atreides
Gallente Veldspar Mafia
|
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...
it is on there :) have checked mself and this is result
Mifter Hogdido2009-04-22 22:45:00250 000 00025
Remeber you need to enter your name fully
|
comrade captain
Revelation Space
|
Posted - 2009.04.23 17:35:00 -
[128]
Isk sent for 5 tickets, fingers and toes crossed
|
Mifter Hogdido
Amarr The 0ri
|
Posted - 2009.04.23 17:40:00 -
[129]
Ah weird. I see them now.
|
Rheinkraft
D00M. Triumvirate.
|
Posted - 2009.04.23 18:02:00 -
[130]
iskies sent
Under The Black Flag Est 2004
|
|
Apostrophe Man
|
Posted - 2009.04.23 18:55:00 -
[131]
Chribba: I had an issue with a multiple donation (sent X amount, then a while later, sent Y amount). Double checked, both donations say TRIBAL. Only the first donation shows up in the tool at http://eve-files.com/tools/tribal.dxd - check your /msg on IRC, I PM'd you about it. |
Chayni
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
Royal Amarr Institute
|
Posted - 2009.04.23 19:43:00 -
[133]
isk sent.. my first time and Chribba popped my chrry
|
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 Wildly Inappropriate.
|
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
|
Mang0o
Caldari coracao ardente Triumvirate.
|
Posted - 2009.04.23 21:11:00 -
[136]
i will never win, but still worth buying a ticket or two
I love you Mang0o, take a guess why -Eris |
Pipecock Jackxon
Gallente IDLE EMPIRE
|
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
|
burek
Mercenary Forces
|
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 |
elnukeo
Failed Diplomacy Heretic Nation
|
Posted - 2009.04.23 23:38:00 -
[140]
Isk sent for 6 tickets! i am a winner
|
|
Devilish Ledoux
Caldari Stimulus Rote Kapelle
|
Posted - 2009.04.24 00:32:00 -
[141]
Originally by: Siri Blue You should just roll dice - non-digital randomness ftw
WTB 10,000 sided die. _
|
Raneru
Euphoria Released Force Of Evil
|
Posted - 2009.04.24 00:36:00 -
[142]
Tickets purchased, hopefully I'll never have to do another mission again
|
Pokerizer
Shut Up And Play
|
Posted - 2009.04.24 00:39:00 -
[143]
20 fer me
|
MrAssasin
Minmatar Hells Army
|
Posted - 2009.04.24 00:48:00 -
[144]
ok thanks chribba sent the right ammount this time 5 tickets plez
|
Sun Ra
The Royal Syndicate
|
Posted - 2009.04.24 01:21:00 -
[145]
I want this so bad
|
Jormungand Altruis
Amarr
|
Posted - 2009.04.24 01:23:00 -
[146]
Edited by: Jormungand Altruis on 24/04/2009 01:24:52
Originally by: Devilish Ledoux
Originally by: Siri Blue You should just roll dice - non-digital randomness ftw
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. -- "Like sending messages in bottles. Bottles with superior firepower." |
Liranan
M'8'S Frontal Impact
|
Posted - 2009.04.24 01:34:00 -
[147]
Five tickets please. Farjung is my God
You people need to open your eyes and read threads before you mindlessly spam the New Thread link. |
Val Kaleth
Minmatar Kippered Snacks
|
Posted - 2009.04.24 01:52:00 -
[148]
got 2 tickets Shifty eyes... |
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..
|
Phelix Jung
The Golden Apple Corps IDLE EMPIRE
|
Posted - 2009.04.24 02:18:00 -
[150]
cool, isk sent for 1 ticket
|
|
|
|
|
Pages: 1 2 3 4 [5] 6 7 8 9 10 :: one page |
First page | Previous page | Next page | Last page |