We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Help me my site won't work anymore :( | Forum

Simone
Simone Sep 21 '15
Hi,

yesterday my VPS hosting had some problem in IO raid disk.


When they solved it my site http://goo.gl/Z3YOpq won't work anymore.


I have enabled DEV debugger but it doesn't give me any error.


I have repaired db database and it give me some theme problem.


In fact mobile version works but not desktop version.


Can you help me?


Thank you

ross Team
ross Sep 21 '15
What do you mean your site does not work anymore? Read this please: http://www.oxwall.org/forum/topic/5092

I see notices on your website. See screenshots. 

Switch to the default theme and see if notices persist. 

The Forum post is edited by ross Sep 21 '15
Simone
Simone Sep 21 '15
Hi ross <3


it is becouse of i have start page plugin.


Try to login with 

username: user2

password: 123456


thank you

Simone
Simone Sep 21 '15
how can switch theme in database? i'm not able to open admin page (same problem)
ross Team
ross Sep 21 '15
go to ow_base_config table and find selected theme configuration, put origin instead of your theme. 
Simone
Simone Sep 21 '15

I had write origin in DB but it does't work.


I also tryed to put it in maintenance mode. 


It works only with mobile version

ross Team
ross Sep 21 '15
Please check your error logs for apache server, these notices can't make your website go down, something else is wrong. 
Simone
Simone Sep 21 '15
ok i'll update you thanks
Simone
Simone Sep 23 '15
hi ross, i see that was messages plugin that charge cpu load and make my site down.


I have a 4000 members in my community.


Do you think Arvixe VPS is not fast enought?

ross Team
ross Sep 23 '15
Simone, what is your software version and messages plugin version?
ross Team
ross Sep 23 '15
As to 4000 members- that depends on the activity, on the amount of concurrent users, the content they put in the messages. 
Simone
Simone Sep 24 '15
I use lastest platform and messages version as today.


They says me that i have not enought ram (1,5Gb is not good?)

ross Team
ross Sep 24 '15
How many concurrent users do you have? How many active users? How many users online? 
Simone
Simone Sep 24 '15
How many concurrent users do you have? 4764

How many active users? I think 2000+

How many users online? Now i have about 20 user online, after this, my site is inacessible due to slow

ross Team
ross Sep 24 '15
Can you please provide us queries log or trace log, so we could find out the reason? Contact your hosting provider and request this info from them. 
Simone
Simone Sep 24 '15
First email..now i have send your question to arvixe's users support

I have checked that high load is due to number of web-requests for your website:

======
gio 26845 0.4 0.9 285404 14296 ? S 03:05 0:00 /usr/bin/php /home/gio/public_html/index.php
gio 26866 0.6 0.9 285404 14300 ? S 03:05 0:00 /usr/bin/php /home/gio/public_html/index.php
gio 26882 2.4 1.5 293944 24212 ? R 03:05 0:03 /usr/bin/php /home/gio/public_html/index.php
gio 26890 0.6 0.9 285404 14300 ? S 03:05 0:00 /usr/bin/php /home/gio/public_html/index.php
gio 26950 6.3 2.4 306424 37016 ? R 03:05 0:06 /usr/bin/php /home/gio/public_html/index.php
gio 26997 0.8 0.9 285404 14308 ? S 03:06 0:00 /usr/bin/php /home/gio/public_html/index.php
gio 27006 0.7 0.9 285404 14300 ? S 03:06 0:00 /usr/bin/php /home/gio/public_html/index.php
gio 27016 0.7 0.9 285404 14300 ? S 03:06 0:00 /usr/bin/php /home/gio/public_html/index.php
gio 27020 1.1 0.8 130032 12596 ? S 03:06 0:00 webmaild - serving 176.3 --llu=1443011393 --listen=3,4,5,6,7,8,9,10
gio 27022 1.2 0.8 130032 12380 ? S 03:06 0:01 webmaild - serving 176.3 --llu=1443011393 --listen=3,4,5,6,7,8,9,10
gio 27023 1.1 0.8 130032 12280 ? S 03:06 0:00 webmaild - serving 176.3 --llu=1443011393 --listen=3,4,5,6,7,8,9,10
gio 27040 1.0 0.8 130032 12392 ? S 03:06 0:00 webmaild - serving 176.3 --llu=1443011393 --listen=3,4,5,6,7,8,9,10
gio 27041 1.0 0.8 130032 12428 ? S 03:06 0:00 webmaild - serving 176.3 --llu=1443011393 --listen=3,4,5,6,7,8,9,10
gio 27043 1.0 0.8 130404 13124 ? S 03:06 0:00 webmaild - serving 176.3 --llu=1443011393 --listen=3,4,5,6,7,8,9,10
gio 27106 4.4 1.4 291516 21752 ? R 03:06 0:02 /usr/bin/php /home/gio/public_html/index.php
gio 27108 2.2 0.8 138388 12920 ? S 03:06 0:01 /usr/local/cpanel/3rdparty/php/54/bin/php-cgi -c /usr/local/cpanel/3rdparty/php/54/etc/horde /usr/local/cpanel/base/horde/imp/dynamic.php
gio 27151 21.0 2.7 311060 41516 ? S 03:06 0:09 /usr/bin/php /home/gio/public_html/index.php
gio 27157 3.9 1.1 288432 18280 ? R 03:06 0:01 /usr/bin/php /home/gio/public_html/index.php
gio 27159 1.9 0.9 285404 14300 ? S 03:06 0:00 /usr/bin/php /home/gio/public_html/index.php
gio 27161 2.2 0.9 285404 14304 ? S 03:07 0:00 /usr/bin/php /home/gio/public_html/index.php
gio 27165 0.1 0.1 138500 2384 ? Ss 03:07 0:00 wget -q -O /dev/nullhttp://facemusik.com/ow_cron/run.php
gio 27166 19.3 2.3 306052 36452 ? R 03:07 0:06 /usr/bin/php /home/gio/public_html/ow_cron/run.php
gio 27175 23.0 2.1 302620 32908 ? R 03:07 0:05 /usr/bin/php /home/gio/public_html/ir2/index.php
gio 27177 23.5 2.1 302504 33020 ? R 03:07 0:05 /usr/bin/php /home/gio/public_html/index.php
gio 27214 21.1 1.5 293772 23960 ? R 03:07 0:02 /usr/bin/php /home/gio/public_html/index.php
gio 27215 21.0 1.5 293680 24044 ? R 03:07 0:02 /usr/bin/php /home/gio/public_html/index.php
gio 27226 6.5 0.7 130032 11884 ? S 03:07 0:00 webmaild - serving 176.3 --llu=1443011393 --listen=3,4,5,6,7,8,9,10
gio 27234 19.8 1.2 289200 19088 ? R 03:07 0:01 /usr/bin/php /home/gio/public_html/index.php
gio 27243 18.8 1.1 287224 17084 ? R 03:07 0:01 /usr/bin/php /home/gio/public_html/index.php
gio 27246 17.4 0.7 137328 11420 ? R 03:07 0:00 /usr/local/cpanel/3rdparty/php/54/bin/php-cgi -c /usr/local/cpanel/3rdparty/php/54/etc/horde /usr/local/cpanel/base/horde/index.php
gio 27258 22.5 0.8 284888 13388 ? R 03:07 0:00 /usr/bin/php /home/gio/public_html/index.php
======

MySQL queries:

======
| 97012 | gio_utenteir | localhost:56221 | gio_inc2666 | Sleep | 1 | | | 1 | 3 | 3 |
| 97013 | gio_test | localhost | gio_inc2666test | Sleep | 1 | | | 1 | 1 | 1 |
| 97014 | gio_utenteir | localhost:56222 | gio_inc2666 | Sleep | 0 | | | 86 | 172 | 172 |
| 97016 | gio_utenteir | localhost:56224 | gio_inc2666 | Sleep | 3 | | | 1 | 3 | 3 |
| 97017 | gio_utenteir | localhost:56225 | gio_inc2666 | Sleep | 2 | | | 1 | 1 | 1 |
| 97018 | gio_utenteir | localhost:56226 | gio_inc2666 | Sleep | 4 | | | 1 | 1 | 1 |
| 97019 | gio_utenteir | localhost:56228 | gio_inc2666 | Sleep | 1 | | | 1 | 1 | 1 |
| 97020 | gio_utenteir | localhost:56229 | gio_inc2666 | Sleep | 11 | | | 54 | 54 | 54 |
| 97021 | gio_utenteir | localhost:56230 | gio_inc2666 | Sleep | 10 | | | 54 | 54 | 54 |
| 97022 | gio_utenteir | localhost:56231 | gio_inc2666 | Sleep | 8 | | | 54 | 54 | 54 |
| 97024 | gio_utenteir | localhost:56232 | gio_inc2666 | Sleep | 4 | | | 54 | 54 | 54 |
| 97025 | gio_utenteir | localhost:56234 | gio_inc2666 | Sleep | 2 | | | 54 | 54 | 54 |
======



Simone
Simone Sep 24 '15


Hello,

I have checked that currently following MySQL queries are executing:

======
| 97728 | gio_utenteir | localhost:57106 | gio_inc2666 | Query | 0 | Copying to tmp table | SELECT activity.* FROM ow_newsfeed_activity activity 
WHERE activity.actionId IN(58380, | 0 | 50 | 50 |
| 97736 | gio_utenteir | localhost:57114 | gio_inc2666 | Sleep | 0 | | | 1 | 1 | 1 |
| 97737 | gio_utenteir | localhost:57115 | gio_inc2666 | Query | 0 | closing tables | INSERT INTO `ow_mailbox_user_last_data` (`userId`,`data`,`id`) VALUES (427,'{\"userOnlineCount\":0,\ | 0 | 0 | 0 |
| 97740 | gio_utenteir | localhost:57119 | gio_inc2666 | Sleep | 0 | | | 0 | 0 | 0 |
| 97742 | gio_utenteir | localhost:57121 | gio_inc2666 | Query | 0 | Sending data | SELECT * FROM ow_base_question_data WHERE `userId` IN('15','114','119','124','134','206','256','462 | 1 | 0 | 0 |
| 97743 | gio_utenteir | localhost:57122 | gio_inc2666 | Sleep | 0 | | | 3 | 20 | 20 |
| 97746 | gio_utenteir | localhost:57125 | gio_inc2666 | Sleep | 0 | | | 1 | 1 | 1 |
| 97750 | gio_utenteir | localhost:57130 | gio_inc2666 | Query | 5 | Sorting result | SELECT `p`.*, `a`.`userId`
======

Can you please ask them if they need MySQL querie logs or web-access logs. 

Simone
Simone Sep 25 '15

150925  8:12:50  4761 Query     SELECT * FROM ow_base_user_online WHERE  `userId` = 911 LIMIT 0, 1

                 4763 Query     SELECT * FROM ow_base_authorization_moderator ORDER BY id

                 4761 Query     UPDATE LOW_PRIORITY `ow_base_user_online` SET `activityStamp`=1443193970 WHERE id=212530

                 4763 Query     SELECT * FROM ow_base_authorization_moderator_permission

                 4761 Query     UPDATE LOW_PRIORITY `ow_base_user` SET `activityStamp`=1443193970 WHERE id=911

                 4763 Query     SELECT * FROM ow_base_authorization_action

                 4761 Query     SELECT * FROM ow_base_user_suspend WHERE  `userId` = 911 LIMIT 0, 1

                 4761 Query     SELECT * FROM ow_base_question_account_type WHERE  `name` IN('290365aadde35a97f11207ca7e4279cc') ORDER BY sortOrder

                 4763 Query     SELECT `roleId` FROM ow_base_authorization_user_role WHERE `userId`=2525

                 4761 Query     SELECT * FROM ow_base_preference WHERE  `key` IN('profile_details_update_stamp')

                 4761 Query     SELECT * FROM ow_base_preference_data WHERE  `userId` IN('911') AND `key` IN('profile_details_update_stamp')

                 4761 Query     ( SELECT `friends_friendship`.`userId` FROM `ow_friends_friendship` AS `friends_friendship`

            INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `friends_friendship`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`

            WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND `friends_friendship`.`status` = 'active' AND `friends_friendship`.`friendId` = 911

             )

            UNION

            ( SELECT `friends_friendship`.`friendId` AS `userId` FROM `ow_friends_friendship` AS `friends_friendship`

            INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `friends_friendship`.`friendId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`

            WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND `friends_friendship`.`status` = 'active' AND `friends_friendship`.`userId` = 911

             )

            LIMIT 0, 100

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 916

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 298

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 2113

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 2803

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 2088

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 2270

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 2979

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 3008

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 554

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 2991

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 3011

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 3115

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 2577

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 1531

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 3185

                 4763 Query     SELECT * FROM ow_base_authorization_permission

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 206

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 3172

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 2375

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 3779

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 4032

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 4072

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 4257

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 2208

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 5467

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 6031

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 100

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 151

                 4761 Query     SELECT * FROM ow_base_user WHERE `id` = 3206

                 4761 Query     SELECT * FROM ow_watchdog_white_list WHERE  `ip` = '79.21.78.95' LIMIT 0, 1

                 4761 Query     SELECT * FROM ow_watchdog_black_list WHERE  `ip` = '79.21.78.95' LIMIT 0, 1

                 4761 Query     SELECT * FROM ow_watchdog_email_list WHERE  `email` = 'seiferown@yahoo.it' LIMIT 0, 1

                 4761 Query     SELECT * FROM ow_mailbox_user_last_data WHERE  `userId` = 911 LIMIT 0, 1

                 4761 Query     SELECT `m`.* FROM `ow_mailbox_message` as `m`

        LEFT JOIN `ow_mailbox_conversation` as `conv` ON (`conv`.`id` = `m`.`conversationId`)

        WHERE ( ( ( ( `conv`.`initiatorId` = 911 AND (`conv`.`deleted` != 1 OR `m`.`timeStamp`>`conv`.`initiatorDeletedTimestamp` ) )

        OR ( `conv`.`interlocutorId` = 911 AND (`conv`.`deleted` != 2 OR `m`.`timeStamp`>`conv`.`interlocutorDeletedTimestamp`) ) )

        AND `m`.`recipientId` = 911 AND `m`.`recipientRead` = 0  ) OR ( `m`.`senderId` = 911 AND `m`.`timeStamp` > 1442505390 ))  AND `conv`.subject = 'mailbox_chat_conversation'

        ORDER BY `m`.`id`, `m`.`timeStamp` DESC

                 4761 Query     SELECT `conv`.`id` FROM `ow_mailbox_conversation` AS `conv`


                                 WHERE (( `conv`.`initiatorId` = 911 AND (`conv`.`deleted` != 1 OR `conv`.`lastMessageTimestamp` > `conv`.`initiatorDeletedTimestamp`) ) OR ( `conv`.`interlocutorId` = 911 AND ( `conv`.`deleted` != 2 OR `conv`.`lastMessageTimestamp` > `conv`.`interlocutorDeletedTimestamp`) ))

AND ( `conv`.`read` <> 3

AND (( `conv`.`initiatorId` = 911 AND NOT `conv`.`read` & 1) OR ( `conv`.`interlocutorId` = 911 AND NOT `conv`.`read` & 2 ))

                                                )

                                                 AND `conv`.subject = 'mailbox_chat_conversation'  AND `conv`.`lastMessageId` != 0

                 4761 Quit

                 4763 Query     SELECT * FROM ow_base_authorization_role ORDER BY `sortOrder` ASC

                 4763 Query     SELECT * FROM ow_base_document WHERE  `uri` = 'base/ping/index' AND `isStatic` = 1 LIMIT 0, 1

                 4763 Query     SELECT * FROM ow_base_theme WHERE  `name` = 'simplicity' LIMIT 0, 1

                 4763 Query     SELECT * FROM ow_base_theme_content WHERE  `themeId` = 987

                 4763 Query     SELECT * FROM ow_base_theme_master_page WHERE  `themeId` = 987

                 4763 Query     SELECT * FROM ow_base_theme WHERE  `name` = 'facemusik' LIMIT 0, 1

                 4763 Query     SELECT * FROM ow_base_theme WHERE  `name` = 'facemusik' LIMIT 0, 1

                 4763 Query     SELECT * FROM ow_base_theme_content WHERE  `themeId` = 982

                 4763 Query     SELECT * FROM ow_base_theme_master_page WHERE  `themeId` = 982

                 4763 Query     SELECT * FROM ow_base_document WHERE  `isStatic` = 1 AND `isMobile` = 0

                 4763 Query     SELECT *

                        FROM `ow_base_menu_item`

                        WHERE `visibleFor` & 2 AND `externalUrl` IS NULL AND `type` = 'main'

                        ORDER BY `order` ASC

                        LIMIT 1

                 4763 Query     SELECT * FROM ow_base_user_online WHERE  `userId` = 2525 LIMIT 0, 1

                 4762 Query     SELECT * FROM ow_base_authorization_group

                 4763 Query     UPDATE LOW_PRIORITY `ow_base_user_online` SET `activityStamp`=1443193970 WHERE id=212527

                 4763 Query     UPDATE LOW_PRIORITY `ow_base_user` SET `activityStamp`=1443193970 WHERE id=2525

                 4762 Query     SELECT * FROM ow_base_authorization_moderator ORDER BY id

                 4762 Query     SELECT * FROM ow_base_authorization_moderator_permission

                 4762 Query     SELECT * FROM ow_base_authorization_action

                 4762 Query     SELECT `roleId` FROM ow_base_authorization_user_role WHERE `userId`=5969

                 4762 Query     SELECT * FROM ow_base_authorization_permission

                 4762 Query     SELECT * FROM ow_base_authorization_role ORDER BY `sortOrder` ASC

                 4763 Query     SELECT * FROM ow_base_user_suspend WHERE  `userId` = 2525 LIMIT 0, 1

                 4762 Query     SELECT * FROM ow_base_document WHERE  `uri` = 'base/ping/index' AND `isStatic` = 1 LIMIT 0, 1

                 4762 Query     SELECT * FROM ow_base_theme WHERE  `name` = 'simplicity' LIMIT 0, 1

                 4762 Query     SELECT * FROM ow_base_theme_content WHERE  `themeId` = 987

                 4763 Query     SELECT * FROM ow_base_question_account_type WHERE  `name` IN('290365aadde35a97f11207ca7e4279cc') ORDER BY sortOrder

                 4762 Query     SELECT * FROM ow_base_theme_master_page WHERE  `themeId` = 987

                 4762 Query     SELECT * FROM ow_base_theme WHERE  `name` = 'facemusik' LIMIT 0, 1

                 4763 Query     SELECT * FROM ow_base_preference WHERE  `key` IN('profile_details_update_stamp')

                 4763 Query     SELECT * FROM ow_base_preference_data WHERE  `userId` IN('2525') AND `key` IN('profile_details_update_stamp')

                 4762 Query     SELECT * FROM ow_base_theme WHERE  `name` = 'facemusik' LIMIT 0, 1

                 4762 Query     SELECT * FROM ow_base_theme_content WHERE  `themeId` = 982

                 4762 Query     SELECT * FROM ow_base_theme_master_page WHERE  `themeId` = 982

                 4763 Query     ( SELECT `friends_friendship`.`userId` FROM `ow_friends_friendship` AS `friends_friendship`

            INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `friends_friendship`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`

            WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND `friends_friendship`.`status` = 'active' AND `friends_friendship`.`friendId` = 2525

             )

            UNION

            ( SELECT `friends_friendship`.`friendId` AS `userId` FROM `ow_friends_friendship` AS `friends_friendship`

            INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `friends_friendship`.`friendId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`

            WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND `friends_friendship`.`status` = 'active' AND `friends_friendship`.`userId` = 2525

             )

            LIMIT 0, 100

                 4762 Query     SELECT * FROM ow_base_document WHERE  `isStatic` = 1 AND `isMobile` = 0

                 4762 Query     SELECT *

                        FROM `ow_base_menu_item`

                        WHERE `visibleFor` & 2 AND `externalUrl` IS NULL AND `type` = 'main'

                        ORDER BY `order` ASC

                        LIMIT 1

                 4763 Query     SELECT * FROM ow_base_user WHERE `id` = 4164

                 4763 Query     SELECT * FROM ow_base_user WHERE `id` = 235

                 4763 Query     SELECT * FROM ow_base_user WHERE `id` = 6038

                 4763 Query     SELECT * FROM ow_watchdog_white_list WHERE  `ip` = '95.232.3.163' LIMIT 0, 1

                 4763 Query     SELECT * FROM ow_watchdog_black_list WHERE  `ip` = '95.232.3.163' LIMIT 0, 1

                 4763 Query     SELECT * FROM ow_watchdog_email_list WHERE  `email` = 'lord_mortimer@alice.it' LIMIT 0, 1

                 4762 Query     SELECT * FROM ow_base_user_online WHERE  `userId` = 5969 LIMIT 0, 1

                 4763 Query     SELECT * FROM ow_mailbox_user_last_data WHERE  `userId` = 2525 LIMIT 0, 1

                 4763 Query     SELECT `m`.* FROM `ow_mailbox_message` as `m`

        LEFT JOIN `ow_mailbox_conversation` as `conv` ON (`conv`.`id` = `m`.`conversationId`)

        WHERE ( ( ( ( `conv`.`initiatorId` = 2525 AND (`conv`.`deleted` != 1 OR `m`.`timeStamp`>`conv`.`initiatorDeletedTimestamp` ) )

        OR ( `conv`.`interlocutorId` = 2525 AND (`conv`.`deleted` != 2 OR `m`.`timeStamp`>`conv`.`interlocutorDeletedTimestamp`) ) )

        AND `m`.`recipientId` = 2525 AND `m`.`recipientRead` = 0  ) OR ( `m`.`senderId` = 2525 AND `m`.`timeStamp` > 1443193873 ))  AND `conv`.subject = 'mailbox_chat_conversation'

        ORDER BY `m`.`id`, `m`.`timeStamp` DESC

                 4762 Query     UPDATE LOW_PRIORITY `ow_base_user_online` SET `activityStamp`=1443193970 WHERE id=212523

                 4762 Query     UPDATE LOW_PRIORITY `ow_base_user` SET `activityStamp`=1443193970 WHERE id=5969

                 4763 Query     SELECT `conv`.`id` FROM `ow_mailbox_conversation` AS `conv`


                                 WHERE (( `conv`.`initiatorId` = 2525 AND (`conv`.`deleted` != 1 OR `conv`.`lastMessageTimestamp` > `conv`.`initiatorDeletedTimestamp`) ) OR ( `conv`.`interlocutorId` = 2525 AND ( `conv`.`deleted` != 2 OR `conv`.`lastMessageTimestamp` > `conv`.`interlocutorDeletedTimestamp`) ))

AND ( `conv`.`read` <> 3

AND (( `conv`.`initiatorId` = 2525 AND NOT `conv`.`read` & 1) OR ( `conv`.`interlocutorId` = 2525 AND NOT `conv`.`read` & 2 ))

                                                )

                                                 AND `conv`.subject = 'mailbox_chat_conversation'  AND `conv`.`lastMessageId` != 0

                 4762 Query     SELECT * FROM ow_base_user_suspend WHERE  `userId` = 5969 LIMIT 0, 1

                 4763 Quit

150925  8:12:51  4762 Query     SELECT * FROM ow_base_question_account_type WHERE  `name` IN('290365aadde35a97f11207ca7e4279cc') ORDER BY sortOrder

                 4762 Query     SELECT * FROM ow_base_preference WHERE  `key` IN('profile_details_update_stamp')

                 4762 Query     SELECT * FROM ow_base_preference_data WHERE  `userId` IN('5969') AND `key` IN('profile_details_update_stamp')

                 4762 Query     ( SELECT `friends_friendship`.`userId` FROM `ow_friends_friendship` AS `friends_friendship`

            INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `friends_friendship`.`userId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`

            WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND `friends_friendship`.`status` = 'active' AND `friends_friendship`.`friendId` = 5969

             )

            UNION

            ( SELECT `friends_friendship`.`friendId` AS `userId` FROM `ow_friends_friendship` AS `friends_friendship`

            INNER JOIN `ow_base_user` base_user_table_alias ON base_user_table_alias.`id` = `friends_friendship`.`friendId` LEFT JOIN `ow_base_user_suspend` base_user_suspend_table_alias ON base_user_suspend_table_alias.`userId` = `base_user_table_alias`.`id`

            WHERE (`base_user_suspend_table_alias`.`id` IS NULL) AND `friends_friendship`.`status` = 'active' AND `friends_friendship`.`userId` = 5969

             )

            LIMIT 0, 100

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 116

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 182

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 206

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 922

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 971

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 999

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 2023

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 2088

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 3197

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 3266

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 4785

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 5237

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 5588

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 5803

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 5882

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 5901

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 5929

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 5988

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 6015

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 6024

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 6031

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 6038

                 4762 Query     SELECT * FROM ow_base_user WHERE `id` = 6040

                 4762 Query     SELECT * FROM ow_watchdog_white_list WHERE  `ip` = '37.177.29.28' LIMIT 0, 1

                 4762 Query     SELECT * FROM ow_watchdog_black_list WHERE  `ip` = '37.177.29.28' LIMIT 0, 1

                 4762 Query     SELECT * FROM ow_watchdog_email_list WHERE  `email` = 'riccardocuoghi3@libero.it' LIMIT 0, 1

                 4762 Query     SELECT * FROM ow_mailbox_user_last_data WHERE  `userId` = 5969 LIMIT 0, 1

                 4762 Query     SELECT `m`.* FROM `ow_mailbox_message` as `m`

        LEFT JOIN `ow_mailbox_conversation` as `conv` ON (`conv`.`id` = `m`.`conversationId`)

        WHERE ( ( ( ( `conv`.`initiatorId` = 5969 AND (`conv`.`deleted` != 1 OR `m`.`timeStamp`>`conv`.`initiatorDeletedTimestamp` ) )

        OR ( `conv`.`interlocutorId` = 5969 AND (`conv`.`deleted` != 2 OR `m`.`timeStamp`>`conv`.`interlocutorDeletedTimestamp`) ) )

        AND `m`.`recipientId` = 5969 AND `m`.`recipientRead` = 0  ) OR ( `m`.`senderId` = 5969 AND `m`.`timeStamp` > 1443176294 ))  AND `conv`.subject = 'mailbox_chat_conversation'

        ORDER BY `m`.`id`, `m`.`timeStamp` DESC

                 4762 Query     SELECT `conv`.`id` FROM `ow_mailbox_conversation` AS `conv`


                                 WHERE (( `conv`.`initiatorId` = 5969 AND (`conv`.`deleted` != 1 OR `conv`.`lastMessageTimestamp` > `conv`.`initiatorDeletedTimestamp`) ) OR ( `conv`.`interlocutorId` = 5969 AND ( `conv`.`deleted` != 2 OR `conv`.`lastMessageTimestamp` > `conv`.`interlocutorDeletedTimestamp`) ))

AND ( `conv`.`read` <> 3

AND (( `conv`.`initiatorId` = 5969 AND NOT `conv`.`read` & 1) OR ( `conv`.`interlocutorId` = 5969 AND NOT `conv`.`read` & 2 ))

                                                )

                                                 AND `conv`.subject = 'mailbox_chat_conversation'  AND `conv`.`lastMessageId` != 0


Simone
Simone Sep 25 '15
Ross if you want I can send complete log on private conversation...
Simone
Simone Sep 25 '15
another piece of mysql 


                 5216 Query     SELECT * FROM ow_base_user WHERE `id` IN('7','8','15','30','46','49','66','87','92','95','103','105','107','108','109','111','114','118','119','120','126','134','140','151','154','163','168','174','177','1

84','192','197','206','207','215','219','228','235','256','260','261','263','274','275','276','281','289','297','298','305','329','336','340','355','383','412','415','441','450','454','491','501','507','512','515','525','541','544','554'

,'565','589','590','593','598','602','653','701','738','765','796','809','832','837','842','843','860','864','875','888','904','907','916','922','927','931','933','936','940','941','946','951','952','957','962','969','970','971','976','9

83','984','987','990','997','999','1009','1021','1023','1039','1073','1074','1076','1087','1092','1107','1140','1146','1165','1172','1174','1175','1178','1193','1230','1275','1291','1305','1309','1311','1315','1333','1342','1380','1398',

'1414','1415','1417','1419','1440','1443','1447','1453','1455','1470','1494','1502','1532','1554','1560','1571','1594','1610','1618','1629','1659','1664','1678','1687','1692','1694','1704','1711','1713','1726','1741','1743','1748','1759'

,'1763','1766','1767','1777','1778','1782','1794','1800','1810','1832','1839','1847','1854','1855','1862','1869','1890','1893','1899','1911','1922','1927','1929','1957','1965','1969','1982','1983','1990','1992','1995','1996','1997','1998

','1999','2001','2002','2012','2020','2023','2024','2029','2031','2054','2055','2061','2063','2064','2076','2089','2093','2110','2114','2131','2132','2138','2142','2145','2155','2156','2161','2173','2194','2195','2199','2208','2232','223

3','2252','2262','2274','2288','2295','2299','2323','2325','2326','2331','2333','2338','2340','2341','2347','2350','2354','2363','2365','2367','2370','2375','2376','2378','2382','2391','2395','2425','2436','2471','2474','2487','2497','25

26','2527','2530','2541','2554','2555','2556','2562','2577','2581','2585','2594','2599','2603','2613','2620','2624','2628','2629','2634','2651','2652','2658','2659','2661','2670','2675','2680','2713','2720','2726','2742','2753','2764','2

771','2785','2792','2803','2804','2807','2812','2815','2824','2842','2856','2862','2875','2896','2921','2960','2967','2971','2979','2991','3008','3011','3027','3032','3084','3107','3110','3121','3140','3151','3153','3159','3160','3185','

3189','3197','3207','3234','3237','3266','3285','3290','3308','3313','3327','3332','3347','3360','3364','3399','3400','3439','3448','3457','3471','3472','3474','3494','3514','3534','3543','3555','3558','3559','3565','3570','3576','3594',

'3597','3605','3608','3612','3613','3618','3619','3622','3627','3643','3678','3681','3694','3702','3704','3711','3717','3725','3753','3766','3773','3775','3780','3786','3788','3789','3796','3802','3819','3822','3828','3830','3833','3835'

,'3837','3844','3850','3856','3861','3863','3879','3882','3892','3894','3895','3909','3912','3918','3919','3925','3935','3951','3956','3960','3973','3982','4005','4017','4021','4032','4041','4046','4048','4065','4070','4091','4102','4131

','4140','4142','4155','4159','4164','4173','4176','4227','4241','4243','4256','4259','4274','4276','4304','4306','4409','4417','4435','4457','4468','4478','4480','4494','4501','4505','4584','4588','4597','4609','4619','4623','4624','463

2','4680','4681','4689','4692','4700','4703','4718','4738','4739','4779','4813','4821','4835','4838','4895','4924','4937','4960','4977','4987','4997','5001','5059','5064','5072','5076','5077','5082','5084','5103','5196','5204','5227','52

34','5237','5250','5253','5260','5328','5340','5341','5349','5358','5369','5378','5379','5389','5399','5407','5409','5412','5414','5422','5430','5434','5438','5444','5445','5467','5471','5472','5482','5485','5515','5554','5577','5578','5

580','5610','5615','5617','5635','5689','5691','5695','5716','5719','5720','5749','5765','5777','5803','5832','5839','5865','5882','5904','5923','5931','5949','5959','5966','6008','6031','6069','6078')

                 5215 Query     SELECT * FROM ow_base_question WHERE  `name` = 'googlemap_location' LIMIT 0, 1

                 5215 Query     SELECT * FROM ow_googlelocation_data WHERE  `entityId` = 6024 AND `entityType` = 'user' LIMIT 0, 1

                 5215 Query     INSERT INTO `ow_mailbox_user_last_data` (`userId`,`data`,`id`) VALUES (527,'{\"userOnlineCount\":5,\"userList\":[{\"opponentId\":116,\"displayName\":\"Gwendolyn\",\"avatarUrl\":\"http:\\/\\/www.facemusik.c

om\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_116_1401046999.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/Gwendolyn\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":144196

7135,\"convId\":3413,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Gwendolyn<\\/b><br\\/>Donna<br\\/>Turin, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/116\",\"canInvite\":true,\"wasBlocked\":false},{\"opponent

Id\":206,\"displayName\":\"luna_dark\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_206_1401284329.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/luna

_dark\",\"isFriend\":false,\"status\":\"status_online\",\"lastMessageTimestamp\":1442959935,\"convId\":3769,\"wasCorrespondence\":true,\"shortUserData\":\"<b>luna_dark<\\/b><br\\/>Donna<br\\/>Salerno SA, Italy\",\"url\":\"http:\\/\\/

facemusik.com\\/messages\\/chat\\/206\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":372,\"displayName\":\"Arishal\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_372_14017443

09.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/Arishal\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1431365626,\"convId\":3593,\"wasCorrespondence\":true,\"shortUserData\":\"

<b>Arishal<\\/b><br\\/>Donna<br\\/>Bari, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/372\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":554,\"displayName\":\"Annie\",\"avatarUrl\":\"http:\\/\\/www.facem

usik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_554_1430735873.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/Annie\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":0,\"c

onvId\":0,\"wasCorrespondence\":false,\"shortUserData\":\"<b>Annie<\\/b><br\\/>Donna<br\\/>75100 Matera, Matera, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/554\",\"canInvite\":true,\"wasBlocked\":false},{\"opponen

tId\":737,\"displayName\":\"Dark Jade\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_737_1435409913.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/Dar

kInJade\",\"isFriend\":false,\"status\":\"status_online\",\"lastMessageTimestamp\":1441963736,\"convId\":221,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Dark Jade<\\/b><br\\/>Donna<br\\/>Florence, Italy\",\"url\":\"http:\\/\\/www.f

acemusik.com\\/messages\\/chat\\/737\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":999,\"displayName\":\"Alessandra\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_999_140337

9795.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/DarkAngel77\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":1442613095,\"convId\":7469,\"wasCorrespondence\":true,\"shortUserData

\":\"<b>Alessandra<\\/b><br\\/>Donna<br\\/>Pescia PT, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/999\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":1146,\"displayName\":\"Vale\",\"avatarUrl\":\"http:\\

/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_1146_1434574908.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/ValeMetalhead\",\"isFriend\":false,\"status\":\"offline\",\"lastM

essageTimestamp\":1430464248,\"convId\":3411,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Vale<\\/b><br\\/>Donna<br\\/>Pavia PV, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/1146\",\"canInvite\":true,\"wasBlock

ed\":false},{\"opponentId\":1153,\"displayName\":\"Antonella\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_1153_1404078115.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.fa

cemusik.com\\/user\\/Anto\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":0,\"convId\":0,\"wasCorrespondence\":false,\"shortUserData\":\"<b>Antonella<\\/b><br\\/>Donna<br\\/>Chieti CH, Italy\",\"url\":\"http:\\/\\/www

.facemusik.com\\/messages\\/chat\\/1153\",\"canInvite\":false,\"wasBlocked\":false},{\"opponentId\":1190,\"displayName\":\"Autumn Breeze\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_11

90_1404339753.jpg\",\"avatarLabel\":\"R\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/AutumnBreeze\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":1438985214,\"convId\":3774,\"wasCorrespondence\":true,\"sho

rtUserData\":\"<b>Autumn Breeze<\\/b><br\\/>Donna<br\\/>Pordenone PN, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/1190\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":1455,\"displayName\":\"Lina\",\"avat

arUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_1455_1430217649.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/linat\",\"isFriend\":false,\"status\":\"offline\

",\"lastMessageTimestamp\":1430222370,\"convId\":3322,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Lina<\\/b><br\\/>Donna<br\\/>Lecce LE, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/1455\",\"canInvite\":true,\

"wasBlocked\":false},{\"opponentId\":1494,\"displayName\":\"SerenaDelioncourt\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_1494_1429177178.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"

http:\\/\\/www.facemusik.com\\/user\\/SerenaDelioncourt\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1430419640,\"convId\":3426,\"wasCorrespondence\":true,\"shortUserData\":\"<b>SerenaDelioncourt<\\/b><br\\/>Donna

<br\\/>Milan, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/1494\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":1690,\"displayName\":\"SuperS\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\

\/plugins\\/base\\/avatars\\/avatar_1690_1436024756.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/SuperS\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":0,\"convId\":0,\"wasCorresp

ondence\":false,\"shortUserData\":\"<b>SuperS<\\/b><br\\/>Donna<br\\/>Trieste, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/1690\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":1755,\"displayName\":\"Prim

iano il vikingo\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_1755_1408545807.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/primianoi\",\"isFriend\"

:true,\"status\":\"offline\",\"lastMessageTimestamp\":0,\"convId\":0,\"wasCorrespondence\":false,\"shortUserData\":\"<b>Primiano il vikingo<\\/b><br\\/>Uomo<br\\/>Foggia FG, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/cha

t\\/1755\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":2262,\"displayName\":\"Silvia\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_2262_1441709488.jpg\",\"avatarLabel\":\"M

\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/silviab\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1440421171,\"convId\":7023,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Silvia<\\/b><br\\/>Donna<

br\\/>Modena MO, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/2262\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":2536,\"displayName\":\"rosa nera\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_user

files\\/plugins\\/base\\/avatars\\/avatar_2536_1413811276.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/crissyrogers\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":0,\"convId\":0,

\"wasCorrespondence\":false,\"shortUserData\":\"<b>rosa nera<\\/b><br\\/>Donna\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/2536\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":2558,\"displayName\":\"Francesca\

",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_2558_1412855065.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/francescag\",\"isFriend\":true,\"status\

":\"offline\",\"lastMessageTimestamp\":0,\"convId\":0,\"wasCorrespondence\":false,\"shortUserData\":\"<b>Francesca<\\/b><br\\/>Donna\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/2558\",\"canInvite\":true,\"wasBlocked\":fa

lse},{\"opponentId\":2866,\"displayName\":\"Tanja\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_2866_1414260181.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com

\\/user\\/Ithil\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1425308272,\"convId\":1038,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Tanja<\\/b><br\\/>Donna<br\\/>Venice, Italy\",\"url\":\"http:\\/\\/www.face

musik.com\\/messages\\/chat\\/2866\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":3172,\"displayName\":\"frankencherry666\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_3172_

1415406034.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/frankencherry\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":0,\"convId\":0,\"wasCorrespondence\":false,\"shortUserData\":

\"<b>frankencherry666<\\/b><br\\/>Donna\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/3172\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":3185,\"displayName\":\"Skadi\",\"avatarUrl\":\"http:\\/\\/www.facemusik.

com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_3185_1432072931.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/Skadi\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":14310942

39,\"convId\":3676,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Skadi<\\/b><br\\/>Donna<br\\/>Bologna, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/3185\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\

":3197,\"displayName\":\"SilverTear85\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_3197_1440601411.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/Si

lverTear85\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":1442940237,\"convId\":3775,\"wasCorrespondence\":true,\"shortUserData\":\"<b>SilverTear85<\\/b><br\\/>Donna<br\\/>Milan, Italy\",\"url\":\"http:\\/\\/www.face

musik.com\\/messages\\/chat\\/3197\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":3236,\"displayName\":\"lucrezia\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_3236_14157134

49.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/lucrezia\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":0,\"convId\":0,\"wasCorrespondence\":false,\"shortUserData\":\"<b>lucrezia

<\\/b><br\\/>Donna<br\\/>Treviso TV, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/3236\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":3266,\"displayName\":\"LokicPlague_REV\",\"avatarUrl\":\"http:\\/\\/w

ww.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_3266_1443038054.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/LokicPlague_REV\",\"isFriend\":false,\"status\":\"offline\",\"lastMess

ageTimestamp\":1442013176,\"convId\":6993,\"wasCorrespondence\":true,\"shortUserData\":\"<b>LokicPlague_REV<\\/b><br\\/>Donna<br\\/>07100 Sassari SS, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/3266\",\"canInvite\"

:true,\"wasBlocked\":false},{\"opponentId\":3290,\"displayName\":\"Hedera87\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_3290_1439147236.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"ht

tp:\\/\\/www.facemusik.com\\/user\\/hedera87\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1438985092,\"convId\":6467,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Hedera87<\\/b><br\\/>Donna<br\\/>Monza MB, Ita

ly\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/3290\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":3570,\"displayName\":\"Elisa\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\

/avatars\\/avatar_3570_1418253606.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/Elly\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1439037289,\"convId\":6456,\"wasCorrespondence

\":true,\"shortUserData\":\"<b>Elisa<\\/b><br\\/>Donna<br\\/>Varese VA, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/3570\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":3833,\"displayName\":\"Ninfadora\"

,\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_3833_1442585773.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/ninfadorachan\",\"isFriend\":false,\"stat

us\":\"offline\",\"lastMessageTimestamp\":1429313474,\"convId\":2990,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Ninfadora<\\/b><br\\/>Donna<br\\/>04100 Rome, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/3833\

",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":3850,\"displayName\":\"Blue_\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_static\\/themes\\/facemusik\\/images\\/no-avatar.png\",\"avatarLabel\":\"M\",\"profileUrl\":\"htt

p:\\/\\/www.facemusik.com\\/user\\/Varanasi\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1438938698,\"convId\":4358,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Blue_<\\/b><br\\/>Donna<br\\/>Milan, Italy\",\"

url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/3850\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":4142,\"displayName\":\"Sissy\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatar

s\\/avatar_4142_1428421229.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/Lawless\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":0,\"convId\":0,\"wasCorrespondence\":false,\"shortU

serData\":\"<b>Sissy<\\/b><br\\/>Donna<br\\/>Cagliari, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/4142\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":4653,\"displayName\":\"Linkye\",\"avatarUrl\":\"htt

p:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_4653_1424693351.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/Linkye\",\"isFriend\":false,\"status\":\"offline\",\"lastMess

ageTimestamp\":1424801578,\"convId\":264,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Linkye<\\/b><br\\/>Donna<br\\/>Padua, Padua, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/4653\",\"canInvite\":true,\"wasBlo

cked\":false},{\"opponentId\":4700,\"displayName\":\"Sharon La VipraNegra\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_4700_1441561987.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http

:\\/\\/www.facemusik.com\\/user\\/sharon\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1431534564,\"convId\":3080,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Sharon La VipraNegra<\\/b><br\\/>Donna<br\\/>85100

 Potenza, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/4700\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":4738,\"displayName\":\"Bonnie\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/pl

ugins\\/base\\/avatars\\/avatar_4738_1437925563.jpg\",\"avatarLabel\":\"S\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/nicolec\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":0,\"convId\":0,\"wasCorrespond

ence\":false,\"shortUserData\":\"<b>Bonnie<\\/b><br\\/>Donna<br\\/>Vicenza VI, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/4738\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":4997,\"displayName\":\"Mari

a\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_4997_1428419674.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/mariav\",\"isFriend\":false,\"status\"

:\"offline\",\"lastMessageTimestamp\":1430389063,\"convId\":3377,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Maria<\\/b><br\\/>Donna<br\\/>Brescia BS, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/4997\",\"canI

nvite\":true,\"wasBlocked\":false},{\"opponentId\":5036,\"displayName\":\"Gabriella\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5036_1428790844.jpg\",\"avatarLabel\":\"M\",\"profileUr

l\":\"http:\\/\\/www.facemusik.com\\/user\\/gabriellap\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":1431340777,\"convId\":3725,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Gabriella<\\/b><br\\/>Donna<br\\/>071

00 Sassari SS, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5036\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":5246,\"displayName\":\"Silvia\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles

\\/plugins\\/base\\/avatars\\/avatar_5246_1431595128.jpg\",\"avatarLabel\":\"S\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/silvia\",\"isFriend\":true,\"status\":\"status_mobile\",\"lastMessageTimestamp\":0,\"convId\":0,\"was

Correspondence\":false,\"shortUserData\":\"<b>Silvia<\\/b><br\\/>Donna<br\\/>Florence, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5246\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":5341,\"displayName\

":\"Medea77\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5341_1432459702.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/francescagalvani\",\"isFrien

d\":true,\"status\":\"offline\",\"lastMessageTimestamp\":0,\"convId\":0,\"wasCorrespondence\":false,\"shortUserData\":\"<b>Medea77<\\/b><br\\/>Donna<br\\/>Padua, Province of Padua, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/message

s\\/chat\\/5341\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":5356,\"displayName\":\"Chiara\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5356_1432633583.jpg\",\"avatarLabe

l\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/chiaraz\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1433504746,\"convId\":4359,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Chiara<\\/b><br\\/

>Donna<br\\/>35010 Trebaseleghe PD, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5356\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":5490,\"displayName\":\"pamelarockdoll1\",\"avatarUrl\":\"http:\\/\\/ww

w.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5490_1433940763.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/pamelarockdoll1\",\"isFriend\":false,\"status\":\"offline\",\"lastMessa

geTimestamp\":1434001554,\"convId\":4554,\"wasCorrespondence\":true,\"shortUserData\":\"<b>pamelarockdoll1<\\/b><br\\/>Donna<br\\/>Milan, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5490\",\"canInvite\":true,\"wasB

locked\":false},{\"opponentId\":5580,\"displayName\":\"Lapsa\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5580_1434906845.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.fa

cemusik.com\\/user\\/lilithstr8edge\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":1441974187,\"convId\":7426,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Lapsa<\\/b><br\\/>Donna<br\\/>Ferrara, Province of Ferra

ra, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5580\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":5681,\"displayName\":\"blacknewage\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plu

gins\\/base\\/avatars\\/avatar_5681_1438706276.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/blacknewage\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":1441173912,\"convId\":6449,

\"wasCorrespondence\":true,\"shortUserData\":\"<b>blacknewage<\\/b><br\\/>Donna<br\\/>Varese VA, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5681\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":5694,\"di

splayName\":\"Insidia\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5694_1437323896.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/Insidia\",\"isFrie

nd\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1440286750,\"convId\":6421,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Insidia<\\/b><br\\/>Donna<br\\/>Mirano VE, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\

\/chat\\/5694\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":5800,\"displayName\":\"DarkBoodGirl89\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5800_1438358878.jpg\",\"avat

arLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/DarkBloodGirl89\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1442011237,\"convId\":7424,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Dark

BoodGirl89<\\/b><br\\/>Donna<br\\/>Sicily, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5800\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":5826,\"displayName\":\"veronica\",\"avatarUrl\":\"http:\\/\\/ww

w.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5826_1438773028.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/veronica\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimes

tamp\":1438946300,\"convId\":6455,\"wasCorrespondence\":true,\"shortUserData\":\"<b>veronica<\\/b><br\\/>Donna<br\\/>Friuli-Venezia Giulia, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5826\",\"canInvite\":true,\"wa

sBlocked\":false},{\"opponentId\":5832,\"displayName\":\"vera\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5832_1440710899.jpg\",\"avatarLabel\":\"R\",\"profileUrl\":\"http:\\/\\/www.f

acemusik.com\\/user\\/vera\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1438982213,\"convId\":6422,\"wasCorrespondence\":true,\"shortUserData\":\"<b>vera<\\/b><br\\/>Donna<br\\/>Rome, Italy\",\"url\":\"http:\\/\\/

www.facemusik.com\\/messages\\/chat\\/5832\",\"canInvite\":false,\"wasBlocked\":false},{\"opponentId\":5847,\"displayName\":\"DesdemonaVampireHell\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\

/avatar_5847_1439138325.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/DesdemonaVampireHell\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1440417200,\"convId\":6996,\"wasCorrespo

ndence\":true,\"shortUserData\":\"<b>DesdemonaVampireHell<\\/b><br\\/>Donna<br\\/>Trento, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5847\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":5882,\"displayNa

me\":\"jackie.black\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5882_1440952092.jpg\",\"avatarLabel\":\"R\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/jackieblack\",\"isFr

iend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":1442567837,\"convId\":7640,\"wasCorrespondence\":true,\"shortUserData\":\"<b>jackie.black<\\/b><br\\/>Donna<br\\/>Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/cha

t\\/5882\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":5945,\"displayName\":\"keyranevermind\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5945_1440755715.jpg\",\"avatarLab

el\":\"R\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/keyranevermind\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1442615864,\"convId\":7845,\"wasCorrespondence\":true,\"shortUserData\":\"<b>keyranever

mind<\\/b><br\\/>Donna<br\\/>Rome, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5945\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":6008,\"displayName\":\"Lalu\",\"avatarUrl\":\"http:\\/\\/www.facemusik.

com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6008_1442933007.jpg\",\"avatarLabel\":\"R\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/Lalu\",\"isFriend\":true,\"status\":\"status_mobile\",\"lastMessageTimestamp\":1442

942462,\"convId\":7524,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Lalu<\\/b><br\\/>Donna<br\\/>Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/6008\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":6013

,\"displayName\":\"pauliabonham\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6013_1441980678.jpg\",\"avatarLabel\":\"R\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/pauliabo

nham\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":1441987904,\"convId\":7549,\"wasCorrespondence\":true,\"shortUserData\":\"<b>pauliabonham<\\/b><br\\/>Donna<br\\/>Chioggia VE, Italy\",\"url\":\"http:\\/\\/www.face

musik.com\\/messages\\/chat\\/6013\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":6018,\"displayName\":\"arwen\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6018_1442005592.

jpg\",\"avatarLabel\":\"R\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/arwen\",\"isFriend\":false,\"status\":\"offline\",\"lastMessageTimestamp\":1442010622,\"convId\":7576,\"wasCorrespondence\":true,\"shortUserData\":\"<b>ar

wen<\\/b><br\\/>Donna<br\\/>Milan, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/6018\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":6024,\"displayName\":\"Lucy\",\"avatarUrl\":\"http:\\/\\/www.facemusik.

com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6024_1442152051.jpg\",\"avatarLabel\":\"R\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/lucy\",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":1442488270

,\"convId\":7634,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Lucy<\\/b><br\\/>Donna<br\\/>Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/6024\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":6038,\"dis

playName\":\"Lorena\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6038_1442909026.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/SleazeOnSunsetStrip\

",\"isFriend\":true,\"status\":\"offline\",\"lastMessageTimestamp\":1443109160,\"convId\":7802,\"wasCorrespondence\":true,\"shortUserData\":\"<b>Lorena<\\/b><br\\/>Donna<br\\/>Ferrara, Province of Ferrara, Italy\",\"url\":\"http:\\/\\/ww

w.facemusik.com\\/messages\\/chat\\/6038\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":6040,\"displayName\":\"VanGoth\",\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6040_144

2580123.jpg\",\"avatarLabel\":\"M\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/vangoth\",\"isFriend\":false,\"status\":\"status_online\",\"lastMessageTimestamp\":1442580364,\"convId\":7818,\"wasCorrespondence\":true,\"shortUs

erData\":\"<b>VanGoth<\\/b><br\\/>Donna<br\\/>13100 Vercelli VC, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/6040\",\"canInvite\":true,\"wasBlocked\":false},{\"opponentId\":6068,\"displayName\":\"elektra93\",\"avat

arUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6068_1443040765.jpg\",\"avatarLabel\":\"R\",\"profileUrl\":\"http:\\/\\/www.facemusik.com\\/user\\/giuliat\",\"isFriend\":false,\"status\":\"offlin

e\",\"lastMessageTimestamp\":1443131970,\"convId\":7940,\"wasCorrespondence\":true,\"shortUserData\":\"<b>elektra93<\\/b><br\\/>Donna<br\\/>Reggio Emilia, Province of Reggio Emilia, Italy\",\"url\":\"http:\\/\\/www.facemusik.com\\/messag

es\\/chat\\/6068\",\"canInvite\":true,\"wasBlocked\":false}],\"conversationsCount\":48,\"convList\":[{\"userId\":6068,\"conversationId\":7940,\"opponentId\":6068,\"mode\":\"chat\",\"conversationRead\":1,\"avatarUrl\":\"http:\\/\\/www.fac

emusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6068_1443040765.jpg\",\"avatarLabel\":\"R\",\"displayName\":\"elektra93\",\"dateLabel\":\"Set 24\",\"previewText\":\"qui \\u00e8 impossibile chattare ormai\",\"subject\":\"mai

lbox_chat_conversation\",\"lastMessageTimestamp\":1443131970,\"reply\":false,\"newMessageCount\":0,\"hasAttachment\":false,\"timeLabel\":\"Set 24, 23:59\",\"onlineStatus\":false,\"winkReceived\":0,\"shortUserData\":\"<b>elektra93<\\/b><b

r\\/>Donna<br\\/>Reggio Emilia, Province of Reggio Emilia, Italy\",\"conversationViewed\":true,\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/6068\"},{\"userId\":6038,\"conversationId\":7802,\"opponentId\":6038,\"mode\":\"cha

t\",\"conversationRead\":1,\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6038_1442909026.jpg\",\"avatarLabel\":\"M\",\"displayName\":\"Lorena\",\"dateLabel\":\"Set 24\",\"previewText\":\"

Padova \\u00e8 scomodo per me , sarei venuta volentieri ...\",\"subject\":\"mailbox_chat_conversation\",\"lastMessageTimestamp\":1443109160,\"reply\":true,\"newMessageCount\":0,\"hasAttachment\":false,\"timeLabel\":\"Set 24, 17:39\",\"on

lineStatus\":false,\"winkReceived\":0,\"shortUserData\":\"<b>Lorena<\\/b><br\\/>Donna<br\\/>Ferrara, Province of Ferrara, Italy\",\"conversationViewed\":true,\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/6038\"},{\"userId\":

206,\"conversationId\":3769,\"opponentId\":206,\"mode\":\"chat\",\"conversationRead\":1,\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_206_1401284329.jpg\",\"avatarLabel\":\"M\",\"displayN

ame\":\"luna_dark\",\"dateLabel\":\"Set 23\",\"previewText\":\"ciaoooo\",\"subject\":\"mailbox_chat_conversation\",\"lastMessageTimestamp\":1442959935,\"reply\":true,\"newMessageCount\":0,\"hasAttachment\":false,\"timeLabel\":\"Set 23, 0

0:12\",\"onlineStatus\":\"1\",\"winkReceived\":0,\"shortUserData\":\"<b>luna_dark<\\/b><br\\/>Donna<br\\/>Salerno SA, Italy\",\"conversationViewed\":true,\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/206\"},{\"userId\":6008,

\"conversationId\":7524,\"opponentId\":6008,\"mode\":\"chat\",\"conversationRead\":1,\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6008_1442933007.jpg\",\"avatarLabel\":\"R\",\"displayNam

e\":\"Lalu\",\"dateLabel\":\"Set 22\",\"previewText\":\"buona serata! ciao rocker!!!\",\"subject\":\"mailbox_chat_conversation\",\"lastMessageTimestamp\":1442942462,\"reply\":false,\"newMessageCount\":0,\"hasAttachment\":false,\"timeLabe

l\":\"Set 22, 19:21\",\"onlineStatus\":\"2\",\"winkReceived\":0,\"shortUserData\":\"<b>Lalu<\\/b><br\\/>Donna<br\\/>Italy\",\"conversationViewed\":true,\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/6008\"},{\"userId\":3197,\

"conversationId\":3775,\"opponentId\":3197,\"mode\":\"chat\",\"conversationRead\":1,\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_3197_1440601411.jpg\",\"avatarLabel\":\"M\",\"displayName

\":\"SilverTear85\",\"dateLabel\":\"Set 22\",\"previewText\":\"oila\' ciao :)\",\"subject\":\"mailbox_chat_conversation\",\"lastMessageTimestamp\":1442940237,\"reply\":false,\"newMessageCount\":0,\"hasAttachment\":false,\"timeLabel\":\"S

et 22, 18:43\",\"onlineStatus\":false,\"winkReceived\":0,\"shortUserData\":\"<b>SilverTear85<\\/b><br\\/>Donna<br\\/>Milan, Italy\",\"conversationViewed\":true,\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/3197\"},{\"userId\

":5945,\"conversationId\":7845,\"opponentId\":5945,\"mode\":\"chat\",\"conversationRead\":1,\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5945_1440755715.jpg\",\"avatarLabel\":\"R\",\"dis

playName\":\"keyranevermind\",\"dateLabel\":\"Set 19\",\"previewText\":\".....\",\"subject\":\"mailbox_chat_conversation\",\"lastMessageTimestamp\":1442615864,\"reply\":true,\"newMessageCount\":0,\"hasAttachment\":false,\"timeLabel\":\"S

et 19, 00:37\",\"onlineStatus\":false,\"winkReceived\":0,\"shortUserData\":\"<b>keyranevermind<\\/b><br\\/>Donna<br\\/>Rome, Italy\",\"conversationViewed\":true,\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5945\"},{\"userId

\":999,\"conversationId\":7469,\"opponentId\":999,\"mode\":\"chat\",\"conversationRead\":1,\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_999_1403379795.jpg\",\"avatarLabel\":\"M\",\"displ

ayName\":\"Alessandra\",\"dateLabel\":\"Set 18\",\"previewText\":\"yeah!\",\"subject\":\"mailbox_chat_conversation\",\"lastMessageTimestamp\":1442613095,\"reply\":false,\"newMessageCount\":0,\"hasAttachment\":true,\"timeLabel\":\"Set 18,

 23:51\",\"onlineStatus\":false,\"winkReceived\":0,\"shortUserData\":\"<b>Alessandra<\\/b><br\\/>Donna<br\\/>Pescia PT, Italy\",\"conversationViewed\":true,\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/999\"},{\"userId\":604

0,\"conversationId\":7818,\"opponentId\":6040,\"mode\":\"chat\",\"conversationRead\":1,\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6040_1442580123.jpg\",\"avatarLabel\":\"M\",\"displayN

ame\":\"VanGoth\",\"dateLabel\":\"Set 18\",\"previewText\":\"mah non si sa mai XD\",\"subject\":\"mailbox_chat_conversation\",\"lastMessageTimestamp\":1442580364,\"reply\":true,\"newMessageCount\":0,\"hasAttachment\":false,\"timeLabel\":

\"Set 18, 14:46\",\"onlineStatus\":\"1\",\"winkReceived\":0,\"shortUserData\":\"<b>VanGoth<\\/b><br\\/>Donna<br\\/>13100 Vercelli VC, Italy\",\"conversationViewed\":true,\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/6040\"},

{\"userId\":5882,\"conversationId\":7640,\"opponentId\":5882,\"mode\":\"chat\",\"conversationRead\":1,\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_5882_1440952092.jpg\",\"avatarLabel\":\

"R\",\"displayName\":\"jackie.black\",\"dateLabel\":\"Set 18\",\"previewText\":\";)\",\"subject\":\"mailbox_chat_conversation\",\"lastMessageTimestamp\":1442567837,\"reply\":false,\"newMessageCount\":0,\"hasAttachment\":false,\"timeLabel

\":\"Set 18, 11:17\",\"onlineStatus\":false,\"winkReceived\":0,\"shortUserData\":\"<b>jackie.black<\\/b><br\\/>Donna<br\\/>Italy\",\"conversationViewed\":true,\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/5882\"},{\"userId\"

:6024,\"conversationId\":7634,\"opponentId\":6024,\"mode\":\"chat\",\"conversationRead\":1,\"avatarUrl\":\"http:\\/\\/www.facemusik.com\\/ow_userfiles\\/plugins\\/base\\/avatars\\/avatar_6024_1442152051.jpg\",\"avatarLabel\":\"R\",\"disp

layName\":\"Lucy\",\"dateLabel\":\"Set 17\",\"previewText\":\"ci sentiamo, bye!\",\"subject\":\"mailbox_chat_conversation\",\"lastMessageTimestamp\":1442488270,\"reply\":true,\"newMessageCount\":0,\"hasAttachment\":false,\"timeLabel\":\"

Set 17, 13:11\",\"onlineStatus\":false,\"winkReceived\":0,\"shortUserData\":\"<b>Lucy<\\/b><br\\/>Donna<br\\/>Italy\",\"conversationViewed\":true,\"url\":\"http:\\/\\/www.facemusik.com\\/messages\\/chat\\/6024\"}]}',NULL)

                 5215 Query     SELECT `m`.* FROM `ow_mailbox_message` as `m`

        LEFT JOIN `ow_mailbox_conversation` as `conv` ON (`conv`.`id` = `m`.`conversationId`)

        WHERE ( ( ( ( `conv`.`initiatorId` = 527 AND (`conv`.`deleted` != 1 OR `m`.`timeStamp`>`conv`.`initiatorDeletedTimestamp` ) )

        OR ( `conv`.`interlocutorId` = 527 AND (`conv`.`deleted` != 2 OR `m`.`timeStamp`>`conv`.`interlocutorDeletedTimestamp`) ) )

        AND `m`.`recipientId` = 527 AND `m`.`recipientRead` = 0  ) OR ( `m`.`senderId` = 527 AND `m`.`timeStamp` > 1443131970 ))  AND `conv`.subject = 'mailbox_chat_conversation'

        ORDER BY `m`.`id`, `m`.`timeStamp` DESC

                 5215 Query     SELECT `conv`.`id` FROM `ow_mailbox_conversation` AS `conv`


                                 WHERE (( `conv`.`initiatorId` = 527 AND (`conv`.`deleted` != 1 OR `conv`.`lastMessageTimestamp` > `conv`.`initiatorDeletedTimestamp`) ) OR ( `conv`.`interlocutorId` = 527 AND ( `conv`.`deleted` != 2 OR `c

onv`.`lastMessageTimestamp` > `conv`.`interlocutorDeletedTimestamp`) ))

AND ( `conv`.`read` <> 3

AND (( `conv`.`initiatorId` = 527 AND NOT `conv`.`read` & 1) OR ( `conv`.`interlocutorId` = 527 AND NOT `conv`.`read` & 2 ))

                                                )

                                                 AND `conv`.subject = 'mailbox_chat_conversation'  AND `conv`.`lastMessageId` != 0


Pages: 1 2 »