Module Social Plugins

[breitsch]

Docu and Downloadlink here: http://www.phpwcms-howto.de/wiki/doku.p ... al_plugins

Thanks to claus for help in beta testing and some hints & tipps!
Thanks to flip flop to provide a new home for the docu's! Within the next weeks/month all the docus on casa-loca.com will be transferred to the wiki.

[update]

Go get it - this is really cool!

[nameless1]

thanks. awesome.

[Jensensen]

installation failed.
output when clicking the module the first time:

Code: Select all

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /is/htdocs/abc654_YQDE04PWKX/www/include/inc_module/mod_socialplugins/backend.default.php on line 56

Module Social Plugins Setup
Module Social Plugins setup successful. Please click the module link again to start working with the module!

clicking the module again the error appears again.
the table `phpwcms_modfb`has been created successfully.

mysql 5.1.49
php 5.2.17
hmmm

[flip-flop]

Mhhh,

for me it is working like a charme.

A little test:

Insert into the file "include/inc_module/mod_socialplugins/backend.default.php" direct before

Code: Select all

  if (mysql_fetch_row(mysql_query('SHOW TABLES FROM ' . $GLOBALS['phpwcms']['db_table'] . ' LIKE "%phpwcms_modfb"'))) { ...

the following lines:

Code: Select all

dumpVar('SHOW TABLES FROM ' . $GLOBALS['phpwcms']['db_table'] . ' LIKE "%phpwcms_modfb"');
dumpVar(mysql_query('SHOW TABLES FROM ' . $GLOBALS['phpwcms']['db_table'] . ' LIKE "%phpwcms_modfb"'));
dumpVar(mysql_fetch_row(mysql_query('SHOW TABLES FROM ' . $GLOBALS['phpwcms']['db_table'] . ' LIKE "%phpwcms_modfb"')));

Result for me ("wcms_r420" is my db name):

Code: Select all

SHOW TABLES FROM wcms_r420 LIKE "%phpwcms_modfb"

Resource id #51

Array
(
    [0] => phpwcms_modfb
)

Knut

[Jensensen]

Hi Knut,

thank you very much for your help.

The output is:
SHOW TABLES FROM db2274123-cms LIKE "%phpwcms_modfb"

Code: Select all

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /is/htdocs/abc654_YQDE04PWKX/www/include/inc_module/mod_socialplugins/backend.default.php on line 60

Code: Select all

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /is/htdocs/abc654_YQDE04PWKX/www/include/inc_module/mod_socialplugins/backend.default.php on line 65

Module Social Plugins Setup
Module Social Plugins setup successful. Please click the module link again to start working with the module!

[flip-flop]

I think you have an db connection problem.
-> mysql_query("SHOW DATABASES") ohne Connection?!?

Please make a second test:

Change

Code: Select all

  if (mysql_fetch_row(mysql_query('SHOW TABLES FROM ' . $GLOBALS['phpwcms']['db_table'] . ' LIKE "%phpwcms_modfb"'))) {

to

Code: Select all

  if (_dbQuery('SHOW TABLES  LIKE "%phpwcms_modfb"','COUNT_SHOW')) {

I hope it will run.

Knut

[nameless1]

thx knut, works for me

[isac]

Very nice module.

I have a problem when put the replacement tag in template>inc_cnpart>articlesummary>list>sample.tmpl it only render in the first article.

Code: Select all

[SPACE]<hr />[/SPACE]
<table cellspacing="0" cellpadding="0" border="0" width="100%" summary="">
	<tr>
		<td width="150" valign="top">
			[IMAGE]<div><a href="{ARTICLELINK}">{IMAGE}</a></div>[/IMAGE]
			[CAPTION]<div align="center">{CAPTION}</div>[/CAPTION]
		</td>
		<td width="10"><img src="img/leer.gif" border="0" width="10" height="1" alt="" /></td>
		<td width="98%" valign="top">
			[TITLE]<h1>{TITLE}</h1>[/TITLE]
			[SUB]<h2>{SUB}</h3>[/SUB]
			[SUMMARY]<div><strong>{DATE:F lang=DE}</strong> {SUMMARY}</div>[/SUMMARY]
			[MORE]<p><a href="{ARTICLELINK}"{TARGET}>{MORE}</a></p>[/MORE]
			<p class='meta facebook'>{MSP_FB_LIKE:1}</p>
		</td>
	</tr>
</table>

[update]

It certainly makes no sense in listing mode: How will the reader be able to judge if an article is to be "liked" (or whatever) by reading some parts of a teaser text only???

[axelko]

Hi Jensensen,

I got the same error (Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource ) with the cm_calendar (I saw you did also had it there) at one phpwcms site. The module was working fine on an other site at the same server with the same phpwcms version. After trying a lot of solutions I noticed that the databasename used a - (dash) in it. After renaming the database all worked ok.

So don't use a - (dash) in the database name if you have.

Greetz,

Axel

[novallis]

First of all: Thank you breitsch for the great module.

Now my 2 questions:
Is there a possibility to have the buttons active after one more click like this here:
http://www.heise.de/ct/artikel/2-Klicks ... 33879.html?
Any solution in combination with your module?

And another question:
If i hit the "like"-button in Facebook without a personal comment it is shown at the "pinwand" for all (everybody).
If i combine with a comment it is shown for friends only (my desired option).
So will the hit of the like-button differently processed?
How can I do, that for a blank hit of the like-button (without comment) the secure options (privacy options) will take effect like do with personal comment ?

Thanks in advance for helping.

Best regards,
Ralf
(novallis)

P.S.: Sorry for my bad english

[breitsch]

Is there a possibility to have the buttons active after one more click like this here

I'll try to integrate this in the next update

How can I do, that for a blank hit of the like-button (without comment) the secure options (privacy options) will take effect like do with personal comment ?

I honestly don't know. I'll have a look at this but I fear that it's facebook who desides what happens when data comes anywhere near their servers.

[breitsch]

Get the new version!
now with Google+ and an optional 2-Click-Solution
see: http://www.phpwcms-howto.de/wiki/doku.p ... al_plugins