Here a mod that lets you add a Skype phone address to your profile. A icon will be posted in members profile and posts. Admins can turn this on and off in the admin panel.
Download link: http://www.snitzbitz.com/mods/details.asp?Version=&mid=205
Version 1, Last update: 7 feb '05 Version 1.1, Last update: 20 oct '05 Version 1.2, Last update: 1 nov '05

Screenshot:

A demo?, look at my site where the mod is operational (its in dutch).
Login: gast
pass: gast

http://www.scoutingforum.nl
Questions and posible bugs can be posted here.<

Hi Bassman

There is no db_skype.asp in the ZIP-file !!!!
/K.Storm<

Woops
Zip updated.<

Thanx Bassman

/K.Storm<

I have installed it, and it works fine...
PS: one small modification, i will try to get it into the members_list also, if you have that please post
Thanx alot Bassman, keep up the good work.
Best Regards
K.Storm

<

Hi!
Thank you for the MOD!
I'm trying to figure out how to save your work here at home on my PC.
What is the official name of your MOD?
Is it "Skype to Snitz" (as listed here at Snitz) or "Skype Addon for members" (as listed at SnitzBitz)?
Thanks,

Etymon
<

Skype Addon for members, I will change the name.
K.Storm zipfile updated with members.asp skype layout.<

Hi Bassman

members.asp modification installed and again it works fine. Thanx alot, i hope that other will use this MOD, its great.
se u

Best Regards
K.Storm<

Very nice mod, I have added the same field in MEMBERS_PENDING and the lines in memebers_pending.asp to let new users to insert their address. And in register also

And I think some lines are required in pop_help.... and if you have private mess also in privateread.asp<

Hello,

having a problem in implementation of this MOD with members.asp ...when calling it, I receive this error msG:

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/members.asp, line 233


The line 233 is this

rs.open strSql & strSql2 & strSql3 & strSql4, my_Conn, adOpenStatic

I've checked, all edited files are OK....any help?

Thank you<

Run the db_skype.asp from the admin menu. Looks like you forgod this on.<

Originally posted by Bassman
Run the db_skype.asp from the admin menu. Looks like you forgod this on.

no no bassman, I run it....infact in any post the skype icon appears and it works well. The problem is only in members.asp........<

I found the bug causing the problem: in the INSTALL_README.TXT file, at line 586, where there is the line replacing the 106 one of members.asp file, it should be
M_SKYPE
and not
M.M_SKYPE

Corrected, now members.asp works great!<

Need to add this to the dbs file too:

[ALTER] MEMBERS_PENDING
ADD#M_SKYPE#varchar(100)#NULL#
[End]
vmplanet's Skype Mod is no longer available?<

Originally posted by rabufo

M_SKYPE
and not
M.M_SKYPE

it's necessary to make the same change also in topic.asp<

it's necessary to make the same change also in topic.asp

Can't find M.M_SKYPE in topic.asp.
@StephenD

[ALTER] MEMBERS_PENDING
ADD#M_SKYPE#varchar(100)#NULL#
[End]

Forgot that one, its added to the snitz bitz file...thanks.
<

Originally posted by Bassman
A demo?, look at my site where the mod is operational.
Login: gast
pass: gast

http://www.scoutingforum.nl

I can't figure out how to see this, sorry.
Is it on a English forum too?<

Try http://www.stephendoyle.net/ its StephenD's site. I don't have one sry.<

Need to take this include out of your finished config.asp:
<!--#INCLUDE FILE="weblogvars.asp"-->
grtz
Romee<

Thanks Romee, line delete and uploaded to snitz.<

Hello Bassman
The mod works fine. Do you realize that in your finished members.asp file you have hardcoded several lines with a Dutch translation. Might not be appreciated outside our country. grtz
Romée
<

Hmmm, strange. I will make a new one from a fresh instalation.<

hi,
I have a small problem, I have followed your guide I pass to footstep, but I don't succeed in understanding because when enter the menù PROFILE and I insert the number SKYPE
and I make OK, the number of skype is saved me, but when I go to see in the page MEMBER. ASP, places side by side the icon of Yahoo Messanger to my name it appears. The data are saved in inverted way, If I insert the datum of Yahoo it goes out me the icon of Skype and vice versa

Have I checked all the passages and are they correct, where can the error be?


Can you help me? Thanks
<

I have tried to modify the file pop_profile. asp in these lines

Before: (line 175) (with this code it saves me the value of the box Skype in the box M_YAHOO )

strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_PASSWORD"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_AIM"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_ICQ"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_SKYPE"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_MSN"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_YAHOO"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_COUNTRY"

Later: (with this code it saves me the value of the box Skype in the box M_SKYPE )

strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_PASSWORD"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_AIM"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_ICQ"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_MSN"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_YAHOO"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_SKYPE"
strSql = strSql & ", " & strMemberTablePrefix & "MEMBERS.M_COUNTRY"


with this change the value of skype is saved in the database in the field Skype

Now the problem is in the page member. asp, here in fact even if the value is correctly saved in the field of skype, this page I place side by side to my name visualizes me the icon of Yahoo and opening the page of yahoo with the number inserted in skype! !

Now the problem is alone in the page member. asp both in the page topic. asp and in the page of visualization profile I don't get problems


Because it makes this error?

Thanks
<

ok resolved problem I had been wrong to put M_SKYPE in members. asp thanks however. . regards Excellent this mod<

Sry Azzur, mist the post. Glad you got it working now.<

My MEMBERS would LOVE to have a SKYPE icon in our Forums...but I can't seem to make it work.
I'm using 'Snitz Forums 2000 Version 3.4.03' with minor modifications, PLUS the SMILE MANAGER MOD installed.

The following are the two errors I'm getting:


MOD: SKYPE Icon v1.1

Adding Column M_SKYPE... ALTER TABLE FORUM_MEMBERS ADD M_SKYPE nvarchar(100) NULL
ALTER TABLE FORUM_MEMBERS ADD M_SKYPE nvarchar(100) NULL
-2147217900 | Column names in each table must be unique. Column name 'M_SKYPE' in table 'FORUM_MEMBERS' is specified more than once.
--------------------------------------------------------------------------------

Adding Column M_SKYPE... ALTER TABLE FORUM_MEMBERS_PENDING ADD M_SKYPE nvarchar(100) NULL
ALTER TABLE FORUM_MEMBERS_PENDING ADD M_SKYPE nvarchar(100) NULL
-2147217900 | Column names in each table must be unique. Column name 'M_SKYPE' in table 'FORUM_MEMBERS_PENDING' is specified more than once.


I've installed a few mods in the past with no trouble, but after five tries on this one, I get the same identical errors over and over. I have only half a brain for coding, so I'm stumped. Can anyone please offer some guidance for me?

Mike

---

www.PianoMagic.com<

Sounds like you already M_SKYPE in MEMBERS_PENDING and MEMBERS. I just installed this mod this morning and found that the readme (3.0v1.2) had some errors in it, so I updated/edited the readme for anyone who would like a copy of it.<

JBaldwin, THANK YOU VERY MUCH! IT WORKS!
My members are already buzzing and loving it!
I really appreciate Bassman for creating this mod, and JBaldwin for making it work for ME! I'm a bit dense at this ASP stuff, but with a little extra help, even a dummy like ME could make it work!
THANK YOU ONE AND ALL...and especially to the SNITZ team for this wonderful Forum! You're the best!!

Mike

---

www.pianomagic.com<