Block Names at the Amex (upper ones)..

A

Another Berkshire Seagull

Well-known member

Sep 20, 2003

1,652

Brighton and now regret the username

• Sep 8, 2012

• #1

Strange request....

I got bored counting the numbers of tickets from the club ticker site so decided to start writing some code to automatically count them. (I know bit sad...too much time when no footy is on)

Problem is I quickly realized I dont know what we call the upper blocks. i.e. The tickets in the north are N1A, N1B thru to N1D etc... West Lower W1A, W1B thru to W1I etc..

What are the blocks in the ESU and WSU called? I would suspect even knowing a single block name in either of these stands will allow me to quiz the ticket system to include counding these blocks.

(attached the ones I have counting now)...View attachment 34547

Thanks in advance!

 

Attachments

• 
  Blocks.png

  56.9 KB · Views: 434

Last edited: Sep 8, 2012

Conkers

Well-known member

Jan 11, 2006

4,523

Haywards Heath

• Sep 8, 2012

• #2

But surely for league games you don't need to know as the number available will always be zero?

 

A

Another Berkshire Seagull

Well-known member

Sep 20, 2003

1,652

Brighton and now regret the username

• Sep 8, 2012

• Thread starter
• #3

Some go occasionally in the ESU, and I 'd rather code it once and it can be used for cup games too....

 

Titanic

Super Moderator

Helpful Moderator

Jul 5, 2003

39,069

West Sussex

• Sep 8, 2012

• #4

We are in W3H.

 

TottonSeagull

Well-known member

Mar 5, 2011

4,466

Totton (Nr Southampton)

• Sep 8, 2012

• #5

How bored can a person be?

 

A

Another Berkshire Seagull

Well-known member

Sep 20, 2003

1,652

Brighton and now regret the username

• Sep 8, 2012

• Thread starter
• #6

Thats it thx...sorted now...3 is the magic number. I guess for consistency they consider the 1901 as level 2 and top tier as 3.

Seems the East is matched E3C etc...

 

A

Another Berkshire Seagull

Well-known member

Sep 20, 2003

1,652

Brighton and now regret the username

• Sep 8, 2012

• Thread starter
• #7

TottonSeagull said:

How bored can a person be?

Click to expand...

Very!

 

TottonSeagull

Well-known member

Mar 5, 2011

4,466

Totton (Nr Southampton)

• Sep 8, 2012

• #8

Another Berkshire Seagull said:

Very!

Click to expand...

Not much happening in Berkshire?

 

A

Another Berkshire Seagull

Well-known member

Sep 20, 2003

1,652

Brighton and now regret the username

• Sep 8, 2012

• Thread starter
• #9

Nope...it's very similar to Totton in this regard.

 

Notters

Well-known member

Oct 20, 2003

24,869

Guiseley

• Sep 8, 2012

• #10

there's no "e" in the west upper.

 

dingodan

New member

Feb 16, 2011

10,080

• Sep 8, 2012

• #11

Notters said:

there's no "e" in the west upper.

Click to expand...

 

B

Brovion

Well-known member

NSC Patron

Jul 6, 2003

19,363

• Sep 8, 2012

• #12

Notters said:

there's no "e" in the west upper.

Click to expand...

dingodan said:

Click to expand...

Completely off this topic, bit that reminds me of a VERY thick girl I used to work with. Someone in the office said "Is there an 'h' in Harvey Nichols?", and she replied laughing "Yeah of course! H -a -r!"

 

A

Another Berkshire Seagull

Well-known member

Sep 20, 2003

1,652

Brighton and now regret the username

• Sep 8, 2012

• Thread starter
• #13

Notters said:

there's no "e" in the west upper.

Click to expand...

nor in the WSL (I guess it's the press area)

Anyway got the thing counting seats... this is the output from todays data.
Will expose it as some sort of web page so people can easy look it up rather than keep creating new how many tix left on sale threads.

 

clippedgull

Hotdogs, extra onions

Aug 11, 2003

20,789

Near Ducks, Geese, and Seagulls

• Sep 9, 2012

• #14

Another Berkshire Seagull said:

nor in the WSL (I guess it's the press area)

Anyway got the thing counting seats... this is the output from todays data.
Will expose it as some sort of web page so people can easy look it up rather than keep creating new how many tix left on sale threads.

View attachment 34552

Click to expand...

Impressed!

Any chance of sorting out the mess that is the Seagulls Website?!?!

 

A

amexee

New member

Jun 19, 2011

979

haywards heath

• Sep 9, 2012

• #15

If the database is that easy to access, what else can you do, on that server?

 

Lankyseagull

One Step Beyond

Jul 25, 2006

1,839

The Field of Uck

• Sep 9, 2012

• #16

Another Berkshire Seagull said:

I got bored counting the numbers of tickets from the club ticker site so decided to start writing some code to automatically count them. (I know bit sad...too much time when no footy is on)...

Click to expand...

Try turning the computer OFF and going OUTSIDE.

Believe me, There's a whole world of things to do out there!

 

W

Wardy

NSC's Benefits Guru

Oct 9, 2003

11,219

In front of the PC

• Sep 9, 2012

• #17

amexee said:

If the database is that easy to access, what else can you do, on that server?

Click to expand...

All he has done is write some code that logs on to the ticket database and then looks to see what is unsold. Works in the same way that price comparison websites work.

 

pornomagboy

wake me up before you gogo who needs potter when

May 16, 2006

6,015

peacehaven

• Sep 9, 2012

• #18

Another Berkshire Seagull said:

Strange request....

I got bored counting the numbers of tickets from the club ticker site so decided to start writing some code to automatically count them. (I know bit sad...too much time when no footy is on)

Problem is I quickly realized I dont know what we call the upper blocks. i.e. The tickets in the north are N1A, N1B thru to N1D etc... West Lower W1A, W1B thru to W1I etc..

What are the blocks in the ESU and WSU called? I would suspect even knowing a single block name in either of these stands will allow me to quiz the ticket system to include counding these blocks.

(attached the ones I have counting now)...View attachment 34547

Thanks in advance!

Click to expand...

I am sure the stadium plan for the north is wrong as I am n1a and by west stand

 

Cars

New member

Feb 13, 2012

561

Haywards Heath

• Sep 9, 2012

• #19

pornomagboy said:

I am sure the stadium plan for the north is wrong as I am n1a and by west stand

Click to expand...

Just noticed that too! It is the wrong way round, should be n1a next to the west as you said.

 

A

amexee

New member

Jun 19, 2011

979

haywards heath

• Sep 9, 2012

• #20

Wardy said:

All he has done is write some code that logs on to the ticket database and then looks to see what is unsold. Works in the same way that price comparison websites work.

Click to expand...

Technically extracting the data is probably simple. I am just surprised that anyone can get the servers directory structure, and the schema of a database without asking for explicit permission.