MOD: Skype Addon for members - Posted (4708 Views)
Bassman
Junior Member
Bassman
Posts: 256
256
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.<
Last edited by Bassman on 01 November 2005, 14:29
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Bassman
Junior Member
Bassman
Posts: 256
256
Hmmm, strange. I will make a new one from a fresh instalation.<
Posted
Azzur
Starting Member
Azzur
Posts: 13
13
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
<
Posted
Azzur
Starting Member
Azzur
Posts: 13
13
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
<
Last edited by Azzur on 21 November 2005, 17:09
Posted
Azzur
Starting Member
Azzur
Posts: 13
13
ok resolved problem I had been wrong to put M_SKYPE in members. asp thanks however. . regards Excellent this mod<
Posted
Bassman
Junior Member
Bassman
Posts: 256
256
Sry Azzur, mist the post. Glad you got it working now.<
Posted
pianomagic
Starting Member
pianomagic
Posts: 18
18
My MEMBERS would LOVE to have a SKYPE icon in our Forumsbigsmile...but I can't seem to make it work. sad
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?question

Mike
www.PianoMagic.com<
Last edited by pianomagic on 23 July 2006, 22:23
Posted
JBaldwin
Junior Member
JBaldwin
Posts: 137
137
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.<
AbsolutelyFreerolls.com - Poker Freeroll Listings, Poker Forum and Poker News
Posted
pianomagic
Starting Member
pianomagic
Posts: 18
18
JBaldwin, THANK YOU VERY MUCH! IT WORKS! bigsmile
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!blush
THANK YOU ONE AND ALL...and especially to the SNITZ team for this wonderful Forum! You're the best!!

Mike
www.pianomagic.com<
You Must enter a message