Does anybody know the secrets of Myspace/CSS ??

Thanks a bunch man, it will be a slow building process for us but we have alot of work to do anyways, we are still lacking pro-sounding recordings and professional pictures and all that fun stuff. We are really bad at the business side of this whole music thing, we need a manager haha.
 
I've added things to get you around the two biggest pitfalls for making the links. Look for **(notes to make it work)**
 
DUDE!
Definitely thanks for that spreadsheet shit tip. That's awesome.
Do you have a link to that OpenOffice.org text to column extension?
I cna't find that junk on their site anywheres!
 
ok, well our other guitarist had exel on his computer here so i hooked that shit up.
here's the thing...

have you tried making a macro for it?
also, is there away to add friends and bypassing the "do you really want to add this user as a friend" thing...
 
Ok, this is really interesting, so I'm gonna try to streamline this process and hopefully create a macro so you can just throw in the page source and get the links out easy.
This should work with the search feature on myspace as well, so you can target your links towards whatever region you want, like if your gonna be in a city for a tour, you can add all people within 5 miles of that city etc....
 
Well, I've got a macro that kind of works, but I've gotta find a way to selected multiple cells based on a specified string.

Here's a good way to make the links so far:
1. Paste a friend page source into Excel
2. Select COLUMN A
3. Data > Sort by Column A
4. Find <a title="*"
5. Select all rows that include <a title="*" and copy them
- There are gonna be two for each friend on the page, no big deal.
6. Paste all those rows in a blank sheet. Insert > Worksheet if you don't have another open
7. Edit > Replace
Code:
Find what:
                                                                    <a title="*" href="http://profile.myspace.com/index.cfm?fuseaction=user.viewprofile
Replace with:
<a href="http://collect.myspace.com/index.cfm?fuseaction=invite.addfriend_verify&friendID=

Make sure you include all that space in the Find what: field to tidy it up.

8. Now you should have proper links that you can put into an html file and clickity clack all day.




- Here's basically that in a macro, but the selection part needs to be variable instead of those fixed values, but this should get you in the general area...
Code:
Sub FUCKINGMACRO()
'
' FUCKINGMACRO Macro
' Macro recorded 1/22/2008 by The Wizard
'

'
    Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
    Selection.Find(What:="<a title=""*""", After:=ActiveCell, LookIn:= _
        xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
        xlNext, MatchCase:=False).Activate
    Rows("1466:1466").Select
    ActiveWindow.SmallScroll Down:=90
    Rows("1466:1545").Select
    Selection.Copy
    Sheets.Add
    ActiveSheet.Paste
    ActiveWindow.SmallScroll Down:=-6
    Application.CutCopyMode = False
    Selection.Replace What:= _
        "                                                                    <a title=""*"" href=""http://profile.myspace.com/index.cfm?fuseaction=user.viewprofile" _
        , Replacement:= _
        "<a href=""http://collect.myspace.com/index.cfm?fuseaction=invite.addfriend_verify&friendID=" _
        , LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False
End Sub

I'll keep you guys updated if I end up finding out how to make it any easier...
 
OpenOffice is more of a pain for a novice to work with than excel =(.

I like your ideas with the find and replace. So I'm going to try and work on an Open Office macro with that method.
 
Yeah dude, this is really cool stuff.
I've never gotten into spreadsheets, but man it's great for organizing data and I can really see how powerful having a dynamic database could be, and not just for this stuff, for anything where you need data. It's TRILL!

Anyway, yeah, if you can figure out a way to be able to select multiple cells that contain a specific value or string, I think you could make the whole spreadsheet thing an almost one-click process.

I just spent the last few hours browsing myspace for specific criteria - women, 21-50, and within 50 miles from my area code. I went through every page and put all of the friends in a sheet and sorted out the actual viewprofile links as i went. it's taken about 5 hours because there were almost 30000 profiles, but about an hour or two into it, i had just gotten in the groove of it and it was very productive.

I took all the viewprofile links, changed them to addfriend links with the Replace feature (by far the most useful tool!), and then put HTML table tags around the links. then when I copied all that to a notepad file, i constructed an HTML/CSS table that makes the names easier to read so i can just hand it off to my buddyfriend guitarist and he can click shit all day long tomorrow. hahaha. he's gonna be FUCKING THRILLED.

Here's a screenshot of the final product:
myspaceattackscreen.jpg

It took a bit of extra time to make it pretty, but I feel that it's worth it in the long run to make it easier to understand and read.
I saved another copy of the HTML without the Excel information in it so I can just paste new data in and save it for another page later...



I'm pretty sure if one had a PHP database or something and were good at writing database shit, one could easily write something that fetched friend id's and generated a dynamic list that updated all the time. it would be crazy. That's a little out of my range though, I tried to mess with network database shit a few years ago and HATED it.
 
Sloan, Very nice work. You gave me some killer ideas too.

To get your links to the top of the page you can try making a formula in column B to flag them and then sort them up.

=IF(LEFT(A1,6)="<a tar",0,1) [all the cells that begin with whats in quotes is valued 0 so if you sort Column B ascending ,you get your links on top.

I replace " <a title" (note to get the exact spacing copy and paste from a sample of source) with "<a target="_blank" title"

copying and pasting as values in a new sheet is a good way keep things uniform.

You can then use the Eliminate Duplicates function if its the new version of Excel. If not you can use a formula to flag the dupes like:

=IF(A2=A1,"DUPE","NEW") [Copy the formula down then copy and paste the column as values, Sort and you have one complete set on top and a flag to know where to stop copying]
 
Another way to browse myspace is to use google search:

site:myspace.com <topic> <region> <sex> <anything you want to look for>

The view profile link is usually displayed so you don't even have to view source.
 
Hey Lowberg, look at this code. Its not the best method but it really works. It moves down the profile, places the band pictures, and then the buttons with their links. you should change the friend id with yours, so it really adds you (not us :p). just browse your friends profile and click on find your profile, click on it. in the url we'll see your friend ID : http://profile.myspace.com/index.cf...scripting like myself????:ill::ill::erk::erk:
 
You declare the attributes of your element (DIV) named "example" :

<style>
div.example {
position: absolute; (let it like that)
top: 210; (distance in pixels from the top of your page to the top of your image)
left: 50%; (distance in pourcentage from the left of your page to the center of your image ??, 50 % is to center)
margin-left: -415px; (that allows you to position horizontally your image on the screen, increase or decrease to move it)
width: 0px; (not necessary in fact)
height: 0px;(not necessary in fact)
}
</style>

then put your element (DIV) on the page

<div class="example"><img src="your image adress" border="0"></div>

you can add a link :

<div class="example"><a href="your link adress"><img src="your image adress" border="0"></a></div>

Look at my others DIVs, you can find the link for the myspace functions : add, view comments, view blog, etc... All you have to do, is copy the link and change the friend ID to yours. Look on google if you dunno how to find your friend ID.

Ask me detailled questions. If you don't understand anything, I think I cannot help you :erk:

You gonna need HTML/CSS knowledge to achieve this. If you don't have any, read the post from the beginning, try to understand my posts, create a fake myspace music profile and experiment without fucking up your band's one.

Good luck.
It's gonna take some time if it's the first time.
 
pifos_2
:erk:

div.example {IS THIS WERE THE LINK TO THE IMAGE GOES????
position: absolute; (let it like that)
top: 210; (distance in pixels from the top of your page to the top of your image)
left: 50%; (distance in pourcentage from the left of your page to the center of your image ??, 50 % is to center)
margin-left: -415px; (that allows you to position horizontally your image on the screen, increase or decrease to move it)
width: 0px; (not necessary in fact)
height: 0px;(not necessary in fact)
}
</style>
 
pifos_2
:erk:

div.example {IS THIS WERE THE LINK TO THE IMAGE GOES????
position: absolute; (let it like that)
top: 210; (distance in pixels from the top of your page to the top of your image)
left: 50%; (distance in pourcentage from the left of your page to the center of your image ??, 50 % is to center)
margin-left: -415px; (that allows you to position horizontally your image on the screen, increase or decrease to move it)
width: 0px; (not necessary in fact)
height: 0px;(not necessary in fact)
}
</style>

read better my post above :

then put your element (DIV) on the page

<div class="example"><img src="your image adress" border="0"></div>
 
Lets say you want to friend whore but waiting for profiles to load takes toooooo loooong. Well my copy and paste method and a little html make loading wait a thing of the past. BG stands for Blind Guardian, and MyFriender is Slayers first 390 friends. Just login to your myspace page, open any of the pages below in another tab or browser window and you get a list of friends from the band in question. Each link takes you to the confirm friend add page instead of the profile. This opens a new window for each add. So after clicking on confirm add or filling the captcha and the page reloads just key ctrl+w to close the friended window and go to the next link on the list.

http://saculus.googlepages.com/BG_1-400_Friendly.htm
http://saculus.googlepages.com/BG_401-800_Friendly.htm
http://saculus.googlepages.com/BG_801-1132_Friendly.htm
http://saculus.googlepages.com/Damage_Plan_500.htm
http://saculus.googlepages.com/Damage_Plan_501-1000.htm
http://saculus.googlepages.com/Damage_Plan_1001-1421.htm
http://saculus.googlepages.com/MyFriender.htm

Yeah some interesting stuff. It would be awesome if someone created a website that all you had to do was input the band name and the website did the rest.
Nothing illegal about it (i think). And you would have a popular website.

BTW it makes me login (even if I am already) if I click on one of those links.
 
read better my post above :

then put your element (DIV) on the page

<div class="example"><img src="your image adress" border="0"></div>

<img src="your image adress" border="0">
position: absolute; (let it like that)
top: 210; (distance in pixels from the top of your page to the top of your image)
left: 50%; (distance in pourcentage from the left of your page to the center of your image ??, 50 % is to center)
margin-left: -415px; (that allows you to position horizontally your image on the screen, increase or decrease to move it)
width: 0px; (not necessary in fact)
height: 0px;(not necessary in fact)
}
</style>

Is this what you meant??:oops::oops: