Pages: 1
Make personal sticky

gennady gurov






The raffle will be redrawn.
things i have so far that must be resolved before i go through with this:
NON members, that have names that do not match up.
mysql> select distinct username from ticketlist where not exists (select 1 from rev_users where rev_users.username = ticketlist.username); +------------------+ | username | +------------------+ | Justin Doucette | | Ryan Manickchand | | QG18DE.NET | +------------------+ 3 rows in set (0.00 sec)
total tickets:
mysql> select count(1) from ticketlist; +----------+ | count(1) | +----------+ | 201 | +----------+ 1 row in set (0.00 sec)
tickets from members:
mysql> select count(1) from ticketlist where username not in (select distinct username from ticketlist where not exists (select 1 from rev_users where rev_users.username = ticketlist.username)); +----------+ | count(1) | +----------+ | 198 | +----------+ 1 row in set (0.15 sec)
current list:
mysql> select * from ticketlist where username not in (select distinct username from ticketlist where not exists (select 1 from rev_users where rev_users.username = ticketlist.username)) order by id; +------+------------------+ | id | username | +------+------------------+ | 1 | Curtisftracing | | 2 | Curtisftracing | | 3 | Curtisftracing | | 4 | Curtisftracing | | 5 | Curtisftracing | | 6 | bartak007 | | 7 | DiloSpecV | | 8 | Patsfan93 | | 9 | trevlya006 | | 10 | trevlya006 | | 11 | trevlya006 | | 12 | dementedmf | | 13 | dementedmf | | 14 | dragonsamus | | 15 | Mariodspecv | | 16 | Mariodspecv | | 17 | Mariodspecv | | 18 | 2k4spec | | 19 | luter_1 | | 20 | luter_1 | | 21 | Mtbsinger85 | | 22 | DiloSpecV | | 23 | DiloSpecV | | 24 | 2new4u | | 25 | DBarnett | | 26 | bruno91w | | 27 | bruno91w | | 28 | ourblk03 | | 29 | ourblk03 | | 30 | smithjw | | 31 | babojams | | 32 | babojams | | 33 | Kid101985 | | 34 | Joe_B | | 35 | TheHighestCrew | | 36 | NismoFreak | | 37 | NismoFreak | | 38 | NismoFreak | | 39 | Oxxyclean123 | | 40 | NM04spec-V | | 41 | NM04spec-V | | 42 | NM04spec-V | | 43 | NM04spec-V | | 44 | In4mation | | 45 | Pwolff | | 46 | fleabaggs | | 47 | bazooki | | 48 | rob5625 | | 49 | rob5625 | | 50 | joelsvspec | | 51 | Curtisftracing | | 52 | Curtisftracing | | 53 | r0nnii | | 54 | Barry LIncoln | | 55 | Barry LIncoln | | 56 | Barry LIncoln | | 57 | limp_noodle | | 58 | supaboy105 | | 59 | alfa_1366 | | 60 | ZOMBIE RX7 | | 61 | Kileak | | 62 | oc_joe_86 | | 63 | oc_joe_86 | | 64 | roger8a | | 65 | Mirage00 | | 66 | Cappasjr | | 67 | SpecV-Boy | | 68 | SpecV-Boy | | 69 | Big Bob | | 70 | Big Bob | | 71 | Big Bob | | 72 | Big Bob | | 73 | Big Bob | | 74 | kingxavier24 | | 75 | ztsgonespecv | | 76 | ztsgonespecv | | 77 | ztsgonespecv | | 78 | clcdom | | 79 | clcdom | | 80 | Chad | | 81 | D.Berry | | 82 | The J. Spec | | 83 | Gaspecv | | 84 | Gaspecv | | 85 | headoftemple | | 86 | mykee069 | | 87 | urbanjacup | | 88 | cwebbspecv | | 89 | ayuds | | 90 | blackout_v | | 91 | blackout_v | | 92 | dan_the_man | | 93 | dan_the_man | | 94 | dan_the_man | | 95 | PBGator1880 | | 96 | littlepyro678 | | 97 | 02whitespecv | | 98 | clcdom | | 99 | clcdom | | 100 | silver target | | 101 | serag | | 102 | jackaljohn | | 103 | black_spec | | 104 | textureofreality | | 105 | destrukt | | 106 | destrukt | | 107 | destrukt | | 108 | destrukt | | 109 | destrukt | | 110 | PsychoZX | | 111 | NismoFreak | | 112 | ibreakayouface | | 113 | MrRage | | 114 | MrRage | | 115 | bruno91w | | 116 | Tweek | | 117 | ryoko | | 118 | Curtisftracing | | 119 | Curtisftracing | | 120 | blackout_v | | 121 | blackout_v | | 122 | enear1121 | | 123 | enear1121 | | 124 | enear1121 | | 125 | enear1121 | | 126 | enear1121 | | 127 | enear1121 | | 128 | SER_Mini_Me | | 129 | SER_Mini_Me | | 130 | SER_Mini_Me | | 131 | SER_Mini_Me | | 132 | SER_Mini_Me | | 133 | Army_Matt | | 134 | Army_Matt | | 135 | freakykitty | | 136 | freakykitty | | 137 | roger8a | | 138 | VP-SE-R | | 139 | usedengine | | 140 | Curtisftracing | | 141 | Specvman12 | | 142 | Specvman12 | | 143 | rancidpunkroger | | 144 | dan_the_man | | 145 | dan_the_man | | 146 | dan_the_man | | 147 | dan_the_man | | 148 | dan_the_man | | 149 | dan_the_man | | 150 | daveo | | 151 | PBGator1880 | | 152 | snarelovin | | 153 | westbdabest | | 154 | westbdabest | | 155 | westbdabest | | 156 | westbdabest | | 157 | clcdom | | 158 | clcdom | | 159 | bruno91w | | 160 | bruno91w | | 161 | PuffyM | | 162 | NM04spec-v | | 163 | NM04spec-v | | 164 | NM04spec-v | | 165 | NM04spec-v | | 166 | BZ | | 167 | Jonnymcc | | 168 | Mtbsinger85 | | 169 | 06BLACKOUT | | 170 | 06BLACKOUT | | 171 | 06BLACKOUT | | 174 | armadnigeneral | | 175 | armadnigeneral | | 176 | 06SPEC-T | | 177 | 06SPEC-T | | 178 | 06SPEC-T | | 179 | 06SPEC-T | | 180 | 06SPEC-T | | 181 | enear1121 | | 182 | enear1121 | | 183 | enear1121 | | 184 | The Pitt | | 185 | NM04spec-v | | 186 | NM04spec-v | | 187 | Red_Spec | | 188 | Red_Spec | | 189 | Red_Spec | | 190 | Red_Spec | | 191 | Red_Spec | | 192 | 07Spec | | 193 | meisterschutze | | 194 | saint0421 | | 197 | saint0421 | | 199 | Illestfob | | 200 | CarKid | | 201 | 02whitespecv | | 202 | westbdabest | | 203 | westbdabest | +------+------------------+ 198 rows in set (0.14 sec)
this is the list of people and number of tickets they bought:
mysql> select username, count(1) from ticketlist where username not in (select distinct username from ticketlist where not exists (select 1 from rev_users where rev_users.username = ticketlist.username)) group by username order by 2 desc, 1; +------------------+----------+ | username | count(1) | +------------------+----------+ | Curtisftracing | 10 | | NM04spec-V | 10 | | dan_the_man | 9 | | enear1121 | 9 | | clcdom | 6 | | westbdabest | 6 | | 06SPEC-T | 5 | | Big Bob | 5 | | bruno91w | 5 | | destrukt | 5 | | Red_Spec | 5 | | SER_Mini_Me | 5 | | blackout_v | 4 | | NismoFreak | 4 | | 06BLACKOUT | 3 | | Barry LIncoln | 3 | | DiloSpecV | 3 | | Mariodspecv | 3 | | trevlya006 | 3 | | ztsgonespecv | 3 | | 02whitespecv | 2 | | armadnigeneral | 2 | | Army_Matt | 2 | | babojams | 2 | | dementedmf | 2 | | freakykitty | 2 | | Gaspecv | 2 | | luter_1 | 2 | | MrRage | 2 | | Mtbsinger85 | 2 | | oc_joe_86 | 2 | | ourblk03 | 2 | | PBGator1880 | 2 | | rob5625 | 2 | | roger8a | 2 | | saint0421 | 2 | | SpecV-Boy | 2 | | Specvman12 | 2 | | 07Spec | 1 | | 2k4spec | 1 | | 2new4u | 1 | | alfa_1366 | 1 | | ayuds | 1 | | bartak007 | 1 | | bazooki | 1 | | black_spec | 1 | | BZ | 1 | | Cappasjr | 1 | | CarKid | 1 | | Chad | 1 | | cwebbspecv | 1 | | D.Berry | 1 | | daveo | 1 | | DBarnett | 1 | | dragonsamus | 1 | | fleabaggs | 1 | | headoftemple | 1 | | ibreakayouface | 1 | | Illestfob | 1 | | In4mation | 1 | | jackaljohn | 1 | | joelsvspec | 1 | | Joe_B | 1 | | Jonnymcc | 1 | | Kid101985 | 1 | | Kileak | 1 | | kingxavier24 | 1 | | limp_noodle | 1 | | littlepyro678 | 1 | | meisterschutze | 1 | | Mirage00 | 1 | | mykee069 | 1 | | Oxxyclean123 | 1 | | Patsfan93 | 1 | | PsychoZX | 1 | | PuffyM | 1 | | Pwolff | 1 | | r0nnii | 1 | | rancidpunkroger | 1 | | ryoko | 1 | | serag | 1 | | silver target | 1 | | smithjw | 1 | | snarelovin | 1 | | supaboy105 | 1 | | textureofreality | 1 | | The J. Spec | 1 | | The Pitt | 1 | | TheHighestCrew | 1 | | Tweek | 1 | | urbanjacup | 1 | | usedengine | 1 | | VP-SE-R | 1 | | ZOMBIE RX7 | 1 | +------------------+----------+ 94 rows in set (0.14 sec)

Offline

gennady gurov






if someone can shed some light on who : Justin Doucette , and Ryan Manickchand , might be, i would greately appreciate it.

Offline

gennady gurov






first post updated,at the bottom, 2 lists, list of people over all, and number of tickets per person,

Offline

Alex


holy shit some of you are buying 10 tickets?

Offline

Allen




damn, G is doing this all high tech and stuff
Online

Jeff


The list matches with my info G. Everything looks good.
Offline

gennady gurov






Red_Spec wrote:
The list matches with my info G. Everything looks good.
still 3 outstanding names that must be resolved to either get refunded, or set to proper name

Offline


well what time do you plan on drawing? maybe shoot out some emails to them and give them until a certain time to respond before giving them refunds

Offline

gennady gurov






destrukt wrote:
well what time do you plan on drawing? maybe shoot out some emails to them and give them until a certain time to respond before giving them refunds
i don't have their email addresses. if i did, it would give me something else to look up in the database.

Offline

Kevin




gurov wrote:
destrukt wrote:
well what time do you plan on drawing? maybe shoot out some emails to them and give them until a certain time to respond before giving them refunds
i don't have their email addresses. if i did, it would give me something else to look up in the database.
what happened to the spreadsheet? it had emails on it

Offline


what about their paypal addresses? dont you have access to them?

Offline

Jeff


just settle down, G is just making sure everything is 100%.
Offline

gennady gurov






destrukt wrote:
what about their paypal addresses? dont you have access to them?
shane has that info, i was asked to redraw from this list. i've fixed all the usernames i could that were misspelled, but these are outstanding still.
reddragon: http://myspecv.com/raffle20/list.html is the only sheet i have

Offline

Justin

So G is doing the drawing not shane?

Offline

Kevin




gurov wrote:
destrukt wrote:
what about their paypal addresses? dont you have access to them?
shane has that info, i was asked to redraw from this list. i've fixed all the usernames i could that were misspelled, but these are outstanding still.
reddragon: http://myspecv.com/raffle20/list.html is the only sheet i have
what about this one? it still has the guys name and shit on it so that one has to have the other guys names and emails in this format
Look at the last 4 people on the list!

Offline

gennady gurov






Bcamos wrote:
So G is doing the drawing not shane?
yes, i will be doing the drawing

Offline

gennady gurov






stand by

Offline

Bill


thanks gurov!
doubly thanks for making sure all 6 of my tickets got in.
-Bill
Offline

Curtis

Sweet sounds good Gurov 
Offline

gennady gurov






2 resolved, one still outstanding
mysql> select username, email from rev_users where email like 'doucett%'; +------------+------------------------+ | username | email | +------------+------------------------+ | doucettejr | doucettejr@charter.net | +------------+------------------------+ 1 row in set (0.00 sec) mysql> select username, email from rev_users where email like 'kentbae%'; +-----------+----------------------+ | username | email | +-----------+----------------------+ | Principle | kentbaez@hotmail.com | +-----------+----------------------+ 1 row in set (0.00 sec) mysql> select username, email from rev_users where email like '%manik%'; Empty set (0.01 sec) mysql> select username, email from rev_users where email like '%manick%'; Empty set (0.01 sec)
| Ryan Manickchand | is outstanding

Offline

Jeff


anyone know this Ryan M?
Offline


Offline

Bill


can you email everyone before you do the drawing? I'll only have email access thru my phone until atleast saturday...
Offline

Allen




that might be ryan (who used to be named marve) but im not sure
Online

Ryan



Thats me. WTF I filled out the forums and MrRage is on 2 tickets. I got 3. If you look at the List It has MrRage beside ryan.manickchand@gmail.com
Last edited by MrRage (2008-08-07 22:05:28)

Offline

gennady gurov






MrRage wrote:
Thats me. WTF I filled out the forums and MrRage is on 2 tickets. I got 3.
when was the payment sent ?

Offline

gennady gurov






mrrage : respond to gmail pls.

Offline

Ryan



YES.. What do you need from me?

Offline

gennady gurov






MrRage wrote:
YES.. What do you need from me?
just respond to the gmail, anything works

Offline

Ryan



gurov wrote:
mrrage : respond to gmail pls.
Done

Offline

Bryan



I DID NOT buy two tickets. I PM'd Shane about my name being on the list twice (technically). Both my screen name and my e-mail address are on the list separately.






Offline

gennady gurov






saint0421 wrote:
I DID NOT buy two tickets. I PM'd Shane about my name being on the list twice (technically). Both my screen name and my e-mail address are on the list separately.
did you hit submit twice maybe ? and enter the name instead of your username ?

Offline

Eric


Thanks for working to get all of this settled gurov and others that helped!!!

Offline

Jeff


gurov wrote:
saint0421 wrote:
I DID NOT buy two tickets. I PM'd Shane about my name being on the list twice (technically). Both my screen name and my e-mail address are on the list separately.
did you hit submit twice maybe ? and enter the name instead of your username ?
I think thats the only way it could happen 
Offline

gennady gurov






okay, looks like we're all set:
mysql> select count(1) from ticketlist; +----------+ | count(1) | +----------+ | 200 | +----------+ 1 row in set (0.00 sec)

Offline

Bryan



gurov wrote:
saint0421 wrote:
I DID NOT buy two tickets. I PM'd Shane about my name being on the list twice (technically). Both my screen name and my e-mail address are on the list separately.
did you hit submit twice maybe ? and enter the name instead of your username ?
Nope. I made sure I was careful. I wanted to do things the right way. His 1st reply was that he was going to check into it. He had PM'd me back a 2nd time stating that he had put up the wrong list.






Offline

Justin

Not to bring up the subject in here, but, didn't anyone notice what I was trying to get at in the beggining of the other thread? I felt like something funny was up from the get-go. But I didn't want to say anything and have everyone on MSV coming down on me.

Offline

Jeff


saint0421 wrote:
gurov wrote:
saint0421 wrote:
I DID NOT buy two tickets. I PM'd Shane about my name being on the list twice (technically). Both my screen name and my e-mail address are on the list separately.
did you hit submit twice maybe ? and enter the name instead of your username ?
Nope. I made sure I was careful. I wanted to do things the right way. His 1st reply was that he was going to check into it. He had PM'd me back a 2nd time stating that he had put up the wrong list.
O i remember that. You and rage paid at like the same time or something? and you got his ticket by mistake. Someone was saying that happened during like the 1st raffle.
Offline

Ryan



So I've got 3 tickets now? 

Offline

Bryan
