Complete List of Maps on sneaK's + toolkit

[pbjpie]

This is a list of all the maps available on sneaK's, in varying formats:
Updated 9/5/2017
-fixed surf_666 and maps missing underscores and hyphens
-added all new maps listed in the above update
Excel document listing all maps tiered by column <-- You need this for the tutorial below.

Updated 8/31/2017
Excel document listing all maps tiered by column + tier also featured on map name
Text-Only Map list T1-T6
T1 | T2 | T3 | T4 | T5 | T6


Map Toolkit Progress:
Ill publish a github for the rest of you to goof around with later. Currently redesigning the code using listboxes instead of textboxes (which might do nothing, so i'm considering alternative methods..)

Whats the issue with the program?!?!?!?!? Why haven't you uploaded it??
Initially thought to be a straightforward process, the program i'd ideally like to make would take a raw format from console of completed maps on sneaK's and update the complete maplist so you had a constantly refreshing page of unbeaten maps, named and tiered.

So in a nutshell we are taking an output similar to this:

surf_prime_time_r3vamp
surf_2012_beta12, Time: 20:04:52, Rank: 98/103
surf_2pacisalive, Time: 00:36:62, Rank: 276/310
surf_abstract_final, Time: 00:26:27, Rank: 137/167
surf_ace, Time: 00:50:74, Rank: 493/2983
surf_acp_fix, Time: 20:10:03, Rank: 199/205
surf_aether, Time: 00:54:58, Rank: 415/829
surf_aircontrol_ksf__, Time: 00:42:36, Rank: 729/9571
surf_akai_final, Time: 00:51:79, Rank: 617/1789
surf_and_destroy, Time: 00:44:32, Rank: 321/455
surf_aqua_fix, Time: 01:03:86, Rank: 117/133
surf_autism, Time: 00:43:47, Rank: 374/2369
surf_autism_2, Time: 01:35:34, Rank: 259/552
surf_aweles, Time: 01:34:17, Rank: 920/1622
surf_beginner, Time: 00:51:69, Rank: 628/5094
surf_bluewall, Time: 07:23:03, Rank: 76/96

Matching it to all the maps on server, and deleting entries of maps you have already beaten so you have a constantly refreshing page of unbeaten maps.

Althought the code works with virtually every other input I've tried, it doesn't want to work with the map list. Keep in mind this isn't all my code by any means, its just the part that keeps breaking over and over. Feel free to take a look below and offer insight because i have 0 more ideas tbqh

 Private Sub btnStart_Click(sender As Object, e As EventArgs) Handles btnStart.Click
        ''tbx2.Copy()
        ''tbx2.Paste(tbx1.Text)
        ''RemoveWords()
        'make array of words from both the files
        'make array of words from both the files
        Dim text1Array() As String = ListBox1.Text.Split(",")
        Dim text2Array() As String = ListBox2.Text.Split("-")
        Dim NewText As String
        NewText = ListBox2.Text
        'loop through all the words in first array
        For i = 0 To text1Array.Length - 1
            'loop through all the words in second array
            For j = 0 To text2Array.Length - 1
                'match the words
                If text1Array(i) = text2Array(j) Then
                    'replace the found word with an empty character
                    NewText = NewText.Replace(text2Array(j), String.Empty)
                    'delete double space
                    NewText = NewText.Replace("  ", " ")
                End If
            Next
        Next
        'save it into third textbox
        TextBox3.Text = NewText
    End Sub

I decided it would be worthwhile to try using a listbox instead of a textbox thanks to the kind folks over at stackoverflow, so i'll be trying that later.

 

[pbjpie]

In lieu of this program being impossible to make, s p o o k y has come up with a great idea that I will be making a tutorial for below!
You will need excel for this program to work.

All highlighted fields are maps that I have beaten.

 

[pbjpie]

Pre-requirements for this tutorial:
Microsoft Excel
Notepad++

Alright, lets get started.
First things first, you are going to want to hop on Easy surf and type !profile in the chatbox.
A list of names will appear. Find yours, and select the appropriate number. Mine is 1.

This messagebox will appear. Select 3.

Navigate to your developer console and copy the output. Paste this output in a Notepad++ New document.

It should look something like this.

Next, press CTRL + F and navigate to the "Replace" tab. Under "Find what :" type this:

,.*

Leave "Replace with : " blank.
Make sure "Regular expression" is selected under search mode, then click replace all.

The output should be nice and clean, like this:

Copy all the values of this list.
Next, open the excel document called "All maps on sneaK's" that I listed above. Paste the values anywhere outside of the map listing, I pasted mine in the H column.

Select ALL the values in the excel document, the entire map list, your map list, all of it.
Then, go to conditional formatting and select duplicate values.

This screen will show up. Hit OK.

And you're done! All maps in red will be maps you have beaten .

I'll try to keep the list up-to-date so it works accurately.

 

[Toasty]

Any way to get around using excel? im too broke to by it and to lazy to figure out what the hell my microsoft account user used to be

 

[pbjpie]

Any way to get around using excel? im too broke to by it and to lazy to figure out what the hell my microsoft account user used to be

Yup, you can do it in google drive. Requires a bit of coding knowledge but not too rough.
https://developers.google.com/apps-script/articles/removing_duplicates

 

[Toasty]

if im too autistic to figure this out ima have you plug in the maps ive completed and send me the thing mkay?

 

[pbjpie]

if im too autistic to figure this out ima have you plug in the maps ive completed and send me the thing mkay?

ye i got u fam
tomorrow ill make another tutorial for google drive users

 

[s p o o k y]

You don't have to import in notepad first, you can just drop the data straight into a column in excel and do a find a replace on ,* to get rid of the extraneous info. Also the map names on the left that you made need to be updated with the extra -'s and _'s

 

[sneaK]

This would all be avoidable if I knew SQL well and could just print a map list in-game of unfinished maps sorted by tier...

 

[pbjpie]

This would all be avoidable if I knew SQL well and could just print a map list in-game of unfinished maps sorted by tier...

where's the fun in that tho!!!
I hear taylor is whipping up something dope tho