TaigaChat Pro - Realtime chat/shoutbox [Deleted]
- Thread starter Luke F
- Start date
cclaerhout
Well-known member
About the files that Luxus was talking above, is there a way to hash them or will it take too much server resource?
cclaerhout
Well-known member
I've just noticed that the Shoutbox was using more than 10 queries to the database... that's a lot.
Without Shoutbox, XenForo total queries: 12 queries
With Shoutbox + speedmode, XenForo total queries: 23 queries
With Shoutbox without speedmode, XenForo total queries: 16 querries
Without Shoutbox, XenForo total queries: 12 queries
With Shoutbox + speedmode, XenForo total queries: 23 queries
With Shoutbox without speedmode, XenForo total queries: 16 querries
DBA
Well-known member
Uh my full chat page is only using 6 queries and forum home is 8 (chat is shown at the top). BTW I don't have Speed mode enabled.
cclaerhout
Well-known member
Test without speedmode: 3 extra queries which are:
It seems it loads by hitself the Custom BBCodes Manager
Code:
__________________________________________________________________________________________________________________
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('dark_shoutbox')
Params: 10
Run Time: 0.000296
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_phrase_compiled const PRIMARY PRIMARY 231 const,const 1
__________________________________________________________________________________________________________________
SELECT *
FROM kingk_bbcm
ORDER BY tag
Run Time: 0.001036
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE kingk_bbcm ALL 30 Using filesort
__________________________________________________________________________________________________________________
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('dark_taigachat')
AND style_id = ?
AND language_id = ?
Params: 2, 10
Run Time: 0.000550
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_template_compiled const PRIMARY PRIMARY 160 const,const,const 1
__________________________________________________________________________________________________________________It seems it loads by hitself the Custom BBCodes Manager
Luke F
Well-known member
1st: Will get that phrase cached for next update
2nd: BBCode manager is because of MOTD rendering presumably
3rd: Template is due to hook, just turn on templates in filesystem if it matters
cclaerhout
Well-known member
Test with speedmode: 10 extra queries which are
It seems there is a loop somewhere.
Code:
__________________________________________________________________________________________________________________
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('dark_shoutbox')
Params: 10
Run Time: 0.000358
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_phrase_compiled const PRIMARY PRIMARY 231 const,const 1
__________________________________________________________________________________________________________________
SELECT *, IF(user.username IS NULL, taigachat.username, user.username) AS username, IF(DATEDIFF(NOW(), FROM_UNIXTIME(date)) = 0, 1, 0) AS today
FROM dark_taigachat AS taigachat
LEFT JOIN xf_user AS user ON
(user.user_id = taigachat.user_id)
WHERE taigachat.id > ?
ORDER BY taigachat.id DESC
LIMIT 75
Params: 0
Run Time: 0.001205
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE taigachat range PRIMARY PRIMARY 4 3 Using where
SIMPLE user eq_ref PRIMARY PRIMARY 4 afioc_xenpublic.taigachat.user_id 1
__________________________________________________________________________________________________________________
SELECT *, IF(user.username IS NULL, taigachat.username, user.username) AS username, IF(DATEDIFF(NOW(), FROM_UNIXTIME(date)) = 0, 1, 0) AS today
FROM dark_taigachat AS taigachat
LEFT JOIN xf_user AS user ON
(user.user_id = taigachat.user_id)
WHERE taigachat.id > ?
ORDER BY taigachat.id DESC
LIMIT 25
Params: 0
Run Time: 0.001001
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE taigachat range PRIMARY PRIMARY 4 3 Using where
SIMPLE user eq_ref PRIMARY PRIMARY 4 afioc_xenpublic.taigachat.user_id 1
__________________________________________________________________________________________________________________
SELECT *
FROM kingk_bbcm
ORDER BY tag
Run Time: 0.001004
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE kingk_bbcm ALL 30 Using filesort
__________________________________________________________________________________________________________________
SELECT *
FROM dark_taigachat_activity AS activity
LEFT JOIN xf_user AS user ON
(user.user_id = activity.user_id)
WHERE activity.date > UNIX_TIMESTAMP()-150
ORDER BY activity.date DESC
Run Time: 0.000757
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE Impossible WHERE noticed after reading const tables
__________________________________________________________________________________________________________________
SELECT count(*)
FROM dark_taigachat_activity AS activity
WHERE activity.date > UNIX_TIMESTAMP()-150
Run Time: 0.000133
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE Impossible WHERE noticed after reading const tables
__________________________________________________________________________________________________________________
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'cron', 'simpleCache', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'smilies', 'bbCode', 'threadPrefixes', 'trophyUserTitles', 'reportCounts', 'moderationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.002576
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_data_registry range PRIMARY PRIMARY 77 20 Using where
__________________________________________________________________________________________________________________
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'dark_taigachat_list')
AND style_id = ?
AND language_id = ?
Params: 2, 10
Run Time: 0.000434
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_template_compiled range PRIMARY PRIMARY 160 5 Using where
__________________________________________________________________________________________________________________
SELECT *
FROM kingk_bbcm
ORDER BY tag
Run Time: 0.000905
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE kingk_bbcm ALL 30 Using filesort
__________________________________________________________________________________________________________________
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('dark_taigachat')
AND style_id = ?
AND language_id = ?
Params: 2, 10
Run Time: 0.000435
Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
SIMPLE xf_template_compiled const PRIMARY PRIMARY 160 const,const,const 1Luke F
Well-known member
Do you mean randomise the url?
cclaerhout
Well-known member
I've used TMS to do the template edit. I'm going to try without if you want.
I really need an option to switch off MOTD off in a futur release ^^
cclaerhout
Well-known member
I didn't look inside the code so may be what I'm saying is stupid but I was thinking to "crypt" the content of templateHtml. But if we can change the location of those datas (for people who wants to have private shoutbox) it's also a good way to make it private.
cclaerhout
Well-known member
P.S: I've just tested, nothing to do with TMS
chrisj
Active member
Any reason that speed mode should be able to mess with a secondary style? Speed mode seems to cause my light style to start using the majority of css of the dark default style.
It seems your forum has the same issue as when I try the mobile theme on your website, the front page uses the default theme but when you click on a forum it goes back to the mobile theme. Same behavior that I have.
It seems your forum has the same issue as when I try the mobile theme on your website, the front page uses the default theme but when you click on a forum it goes back to the mobile theme. Same behavior that I have.
Forsaken
Well-known member
I can confirm this; it was happening in the beta and I didn't narrow it down to Taigachat.
CivilWarTalk
Active member
Chat room itself is working well, but it seems that the "Members in Chat" block in xenporta only works if you actually install that chat block in the portal as well. I assume that's why I can't get the "Members in Chat" block on the forum to work either...
Is there a way to make this work? I have members who would like to see who is in chat before they enter...
.....................
Also, on a separate note, is it possible to have an option for the forum activity display links to open in a new browser tab?
Is there a way to make this work? I have members who would like to see who is in chat before they enter...
.....................
Also, on a separate note, is it possible to have an option for the forum activity display links to open in a new browser tab?
CivilWarTalk
Active member
Also, any reason why the chat won't work on an iPad?
Luke F
Well-known member
Currently that's not possible as both the chat and the members in chat content come from the same refresh system
That being said, it sounds like you are only using the full size/popup chat, so you could simply add a css rule to EXTRA.css:
Code:
.taigachat_alt, #taigachat_sidebar { display: none; }I will add this as an option in 1.0.2
Luke F
Well-known member
I don't own any Apple mobile devices to test with, what exactly is the problem?
It works 90% perfectly on android, sans some very minor scrolling issues
CivilWarTalk
Active member
I had a member report this issue last night with the free version, but I didn't get any specifics. I know it works on in Safari on my Mac, and also on our Kindle Fire. I'll ask for some details next time I chat with him.
cclaerhout
Well-known member
No problem for me on Ipad (iOS5-Safari) with pro version. So far I can remember the free version didn't have any problem either.
lasertits
Active member
Confirmed here as well, had to disable speed mode.
Also I get the following error if I have nothing in my 'BBCode buttons' option, yet the 'BBCode toolbar' is set to 'Enabled in all views, including sidebar' and this is enabled in order to use Smilies, and BBCode Buttons is blank because I have my 'BBCode Parser level' set to 'none'
If I go to the home page it says "An unexpected error occurred. Please try again later."
My goal is to have the BBCode toolbar enabled, but only for smilies. I actually wanted to just disable the parsing of 'color' since I'm using a light and dark style, but since that's included in the other basic bbcodes I had to disable the parsing completely and only use it on email and url.
Similar threads
- Question
- Question