Skype Integration

[hadesflames]

Thanks Costa ^^

[Cain2nd]

Hy folks,

when I try to unistall the mod I get the following error message:

An Error Has Occurred!
This package cannot be uninstalled, because there is no uninstaller!
Please contact the mod author for more information

I tried looking in this thread and found this

Ok, found the small error.

To uninstall this mod, you need to go into your /Packages directory, and download the mod. Then from there, open package-info.xml and remove the following line:

Code Select Expand

<remove-file name="$themedir/images/skype.gif">

Doing this will permit you to uninstall the mod. I will include a fix on this on the next release.

but there ain't that line in my package-info.xml

I'm still running the Skype version 1.1 on SMF 1.1.11

[Pinball Nation]

I'm having the same problem.Im using 1.1.11.Is there an easier way to fix this.Help.

My initial installation was SMF 1.1.5 and I installed skype_int_master_1.1 successfully.
Today I updated to SMF 1.1.6 and had to re-install all packages.  This went OK except for Skype.
I get the following error:

Duplicate column name 'skype'
File: /home/xxxxxxxxx/public_html/smforum/Packages/temp/skype_settings.php
Line: 13

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.6, while your database is at version 1.1.5. The above error might possibly go away if you execute the latest version of upgrade.php.


"xxxxxxxxx" above replaces real name.
Can you advise what I need to fix?  I tried Deleteing Skype and Downloading it again etc. but no change.

Regards

how i fixed this was, i exported my database down to my desktop..

i then used notepad++ and searched for the entries of "skype" and then deleted them.. then i went into the members table and deleted the spot where in the memebers tables it shows.. (3rd from right) i deleted all the collums for it as well.. then i reupped the sql file into the database, and even tho it made 4 errors unable to edit the files, i installed, with out any more "duplicate issues" and then i edited the files that didnt get the data for this mod..

if you get lost, i am sure that CCB can assist you with this

[d0brin]

how to make the Skype Status Image to display when an user make a post and on the profile info to show me the image... of the skype status?
I am with SMF 1.1.11

[JayT]

Awesome mod... thanks! Just one problem with my install...

I get: "Execute Modification   ./Themes/default/Display.template.php   Test failed" when applying mod...

I would bet that it's because I already applied the TwitterField mod... but just a guess on my part. What is the best method for me to install this mod, wait for you to look at this, or try to install it manually, or other?

Oh, and I'm running SMF 1.1.11...

Thanks!
Jason

[hadesflames]

Wow, I should check this thread more often.

@cain + pinball nation you should try using the latest version of the mod 2.1.1. You shouldn't get such errors then.

@d0brin It should already display this information. If you mean that it's always showing off line, please read this:

NOTE:

for the new image to display your online status (such as online, away, busy, offline ect...) You need to set your skype to "Allow my status to be shown on the web" Otherwise it will always display you as offline! To do this go into your skype options > Privacy then tick the box that says "Allow my status to be shown on the web"

@JayT Your best bet would be to try to install manually, or uninstall the twitter mod, install the skype mod, then try to re-install the twitter mod.

[Pinball Nation]

I'm getting the same error.

Code Select Expand

Database Error
Duplicate column name 'skype'
File: /home/blah/public_html/Packages/temp/skype_settings.php
Line: 28 
                                                                     

[hadesflames]

using phpmyadmin look at smf_members. Search for a column called "skype" and remove it. It should be the very last one. Then try installing it again.

[Pinball Nation]

using phpmyadmin look at smf_members. Search for a column called "skype" and remove it. It should be the very last one. Then try installing it again.

Thanks that solved my problem.Everything is good now.

[eng_HK]

If you want to have Italian Language add this part to the languages.xml before install.

<file name="$languagedir/Modifications.italian.php" error="skip">

<operation>

<search position="end" />

<add><![CDATA[$txt['skype'] = 'Skype';
  $txt['skype_in'] = 'Questo è il nome utente di Skype.';
  $txt['skype_image'] = 'Mostra la mia immagine';
  ]]></add>
</operation>

</file>

[hadesflames]

using phpmyadmin look at smf_members. Search for a column called "skype" and remove it. It should be the very last one. Then try installing it again.

Thanks that solved my problem.Everything is good now.

Glad that solved the problem =]

If you want to have Italian Language add this part to the languages.xml before install.

<file name="$languagedir/Modifications.italian.php" error="skip">

<operation>

<search position="end" />

<add><![CDATA[$txt['skype'] = 'Skype';
  $txt['skype_in'] = 'Questo è il nome utente di Skype.';
  $txt['skype_image'] = 'Mostra la mia immagine';
  ]]></add>
</operation>

</file>

Thanks for the translation!

[sattninja]

hi i have went through all the pasring for RC2 everything seems to work fine the only problem i have is shows i am offline all the time image attached



this is the only icon that ever shows

i thik it has something to do with this line in the code

http://mystatus.skype.com/smallicon/

that like is no good as far as i can tell

[sattninja]

forget it i got it you have to allow it in skype

[hadesflames]

NOTE:

for the new image to display your online status (such as online, away, busy, offline ect...) You need to set your skype to "Allow my status to be shown on the web" Otherwise it will always display you as offline! To do this go into your skype options > Privacy then tick the box that says "Allow my status to be shown on the web"

gotta read those side notes

[TFO Louis]

How can I get this to work with a theme other than the default one?

[hadesflames]

You're going to have to apply the template edits to the files that your theme includes that this mod edits. Please take a look at this:

Manual Installation of Mods

[Swer]

no updates for rc2?

[snoopy_virtual]

@hadesflames

First of all congratulations for this mod.

Very useful for the people who use Skype a lot more than the telephone (as I do) 

I'm going to give you a tip you could use for this mod if you want.

I had no problem installing your mod version 2.1.1 inside my 1.1.11 forum but, after installation, I went to my profile to add my Skype ID and didn't see it there.

Then I realized why:

Some time ago I did a few changes manually to my Profile.template.php so I'm not using the one inside the default Theme folder, but a copy of it (the modified one) inside my particular Theme folder.

So your installer was doing the modifications properly to the default file, but not to the one I'm actually using.

So I uninstalled your mod, and changed your installer. I went to your file install.xml and told him to do the changes to the file I'm actually using:

"$boarddir/Themes/my_template/Profile.template.php"

instead of the default one:

"$themedir/Profile.template.php"

But then, when I try to install it again now, I got the error some other people have been reporting here:

"Duplicate column name 'skype' etc"

So I opened your file skype_settings.php and realized why:

This file will try always to create the column skype in the members table without looking first if that column already exists.

So I changed that file using the same trick I always use on my mods when something like this happens, I changed:

Code Select Expand


if(!$bool)
{
db_query("
ALTER TABLE {$db_prefix}members ADD COLUMN
skype VARCHAR(50) NOT NULL default ''", __FILE__, __LINE__);

if(SMF == 'SSI')
    echo '<b>The Skype setting has been added~.</b>';
}


For this:

Code Select Expand


if(!$bool)
{
$result = db_query("DESCRIBE
{$db_prefix}members skype
",__FILE__,__LINE__);

$updating = mysql_num_rows($result);
mysql_free_result($result);

if (!$updating)
{
db_query("
ALTER TABLE {$db_prefix}members ADD COLUMN
skype VARCHAR(50) NOT NULL default ''", __FILE__, __LINE__);

if(SMF == 'SSI')
    echo '<b>The Skype setting has been added~.</b>';
}
else
{
if(SMF == 'SSI')
    echo '<b>The Skype setting was already added~.</b>';
}
}


And now I installed it with no errors at all.

As I said before, if you want to use this trick for future updates or for your other mods, it's all yours. 

And once again, thank you for this useful mod. Keep the good work.



PS.- modified to sort a typo.

[hadesflames]

no updates for rc2?

This mod should work on RC2 and RC3, however, I did drop support for RC1.2 as development for SMF 2.0 moves on.

@hadesflames

First of all congratulations for this mod.

Very useful for the people who use Skype a lot more than the telephone (as I do) 

I'm going to give you a tip you could use for this mod if you want.

I had no problem installing your mod version 2.1.1 inside my 1.1.11 forum but, after installation, I went to my profile to add my Skype ID and didn't see it there.

Then I realized why:

Some time ago I did a few changes manually to my Profile.template.php so I'm not using the one inside the default Theme folder, but a copy of it (the modified one) inside my particular Theme folder.

So your installer was doing the modifications properly to the default file, but not to the one I'm actually using.

So I uninstalled your mod, and changed your installer. I went to your file install.xml and told him to do the changes to the file I'm actually using:

"$boarddir/Themes/my_template/Profile.template.php"

instead of the default one:

"$themedir/Profile.template.php"

But then, when I try to install it again now, I got the error some other people have been reporting here:

"Duplicate column name 'skype' etc"

So I opened your file skype_settings.php and realized why:

This file will try always to create the column skype in the members table without looking first if that column already exists.

So I changed that file using the same trick I always use on my mods when something like this happens, I changed:

Code Select Expand


if(!$bool)
{
db_query("
ALTER TABLE {$db_prefix}members ADD COLUMN
skype VARCHAR(50) NOT NULL default ''", __FILE__, __LINE__);

if(SMF == 'SSI')
    echo '<b>The Skype setting has been added~.</b>';
}


For this:

Code Select Expand


if(!$bool)
{
$result = db_query("DESCRIBE
{$db_prefix}members skype
",__FILE__,__LINE__);

$updating = mysql_num_rows($result);
mysql_free_result($result);

if (!$updating)
{
db_query("
ALTER TABLE {$db_prefix}members ADD COLUMN
skype VARCHAR(50) NOT NULL default ''", __FILE__, __LINE__);

if(SMF == 'SSI')
    echo '<b>The Skype setting has been added~.</b>';
}
else
{
if(SMF == 'SSI')
    echo '<b>The Skype setting was already added~.</b>';
}
}


And now I installed it with no errors at all.

As I said before, if you want to use this trick for future updates or for your other mods, it's all yours. 

And once again, thank you for this useful mod. Keep the good work.



PS.- modified to sort a typo.

By default, mods should install to the default theme files. Making it work on custom themes is something the user has to do manually

As for checking the db, I could have sworn I added in the check when I upgraded this mod to work with SMF 2.0 (I must have mixed up the files XD, that's what you get for being messy =P)

I have added the checks, thanks for pointing it out to me =]

[eng_HK]

Hi all..
I have 2 Problems...

1)
I tried to install the 2.1.2 after removing the 2.1.1... but received this error

PATH/Packages/temp/skype_settings.php
Line: 20

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.9. The above error might possibly go away if you execute the latest version of upgrade.php.

So i cannot install the new version.. my db is updated already but I continue to receive this error and I cannot go fw..

2)
When I removed the 2.1.1 I didn't think that the script remove also column of skype id to my users...So now when i move back to 2.1.1 I have all the SkypeID clean.. There's a way to upgrade without remove it?
I'm going send an email to all to tell them that they have to re-insert the skype id..