[WMTech] Time Spent Online [Paid] 2.0.3

[Nirjonadda]

Yugensoft updated Time Spent Online with a new update entry:

v2.0.5



Read the rest of this update entry...

What is this functionality? Do you have any preview?

 

[Nirjonadda]

@Yugensoft Uploaded this v2.0.5 files but no upgrade button.

 

[Yugensoft]

What is this functionality? Do you have any preview?

Aggregate time in forum statistics widget

@Yugensoft Uploaded this v2.0.5 files but no upgrade button.

Oops, download & try again

 

[Nirjonadda]

Aggregate time in forum statistics widget

Does not showing time.

 

[Yugensoft]

Wait for cache

 

[Nirjonadda]

Wait for cache

Can be change Xd Xh Xm to XD XH XM capital letters?

 

[Nirjonadda]

@Yugensoft Please do you have fix and compatible update form this post?

 

[Yugensoft]

Yugensoft updated Time Spent Online with a new update entry:

v2.0.6

Fix regarding possible 3rd party addon interaction

Read the rest of this update entry...

 

[rdn]

Can I use this on User Group Promotion?
Like: User has been online at least X hours for the last X Days

 

[Yugensoft]

Can I use this on User Group Promotion?
Like: User has been online at least X hours for the last X Days

It can be used for promotions, but only on total time online (it doesn't track which days they spent the time).

 

[rdn]

I hope it can be added in future version .

(it doesn't track which days they spent the time).

 

[Xon]

@Yugensoft The xf_tso_record table is being created as MyIASM which causes locking issues when mixed with InnoDB tables (ie xf_user).

 

[FloV]

Also, you're logging the time spent online by guests (at least in the 1.x version).

 

[Nirjonadda]

@Yugensoft Getting Server error log.

XF\Db\DeadlockException: MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction src/XF/Db/AbstractStatement.php:212

Generated by: Starling Dec 23, 2018 at 7:11 PM

Stack trace

                UPDATE xf_user AS u
                SET u.time_spent=u.time_spent +
                    if(u.true_last_activity,
                      if((1545570701 - u.true_last_activity) < 900,
                        (1545570701 - u.true_last_activity),
                        0
                      ),
                      0
                    ),
                u.true_last_activity=1545570701
                WHERE u.user_id=332
           
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1213, '40001')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1213, '40001')
#2 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#3 src/addons/Yugensoft/TimeSpentOnline/XF/Repository/SessionActivity.php(23): XF\Db\AbstractAdapter->query('
              ...')
#4 src/addons/xenMade/LAU/XF/Repository/SessionActivity.php(29): Yugensoft\TimeSpentOnline\XF\Repository\SessionActivity->updateSessionActivity(332, '87.10.129.2', 'XF\\Pub\\Controll...', 'AddReply', Array, 'valid', '')
#5 src/XF/Pub/Controller/AbstractController.php(66): xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity(332, '87.10.129.2', 'XF\\Pub\\Controll...', 'AddReply', Array, 'valid', '')
#6 src/XF/Pub/Controller/AbstractController.php(41): XF\Pub\Controller\AbstractController->updateSessionActivity('AddReply', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#7 src/XF/Mvc/Controller.php(278): XF\Pub\Controller\AbstractController->postDispatchType('AddReply', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#8 src/XF/Mvc/Dispatcher.php(271): XF\Mvc\Controller->postDispatch('AddReply', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#9 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'AddReply', 'json', Object(XF\Mvc\ParameterBag), 'forums', Object(TickTackk\ContentCopyProtection\XF\Pub\Controller\Thread), NULL)
#10 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(1934): XF\Mvc\Dispatcher->run()
#12 src/XF.php(333): XF\App->run()
#13 index.php(13): XF::runApp('XF\\Pub\\App')
#14 {main}

Request state

array(4) {
  ["url"] => string(45) "/threads/part-3.49305/add-reply"
  ["referrer"] => string(58) "/threads/part-3.49305/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(8) {
    ["message_html"] => string(92) "<p>[img][/img]</p><p><br></p>"
    ["last_date"] => string(10) "1545570694"
    ["last_known_date"] => string(10) "1545570343"
    ["klPage"] => string(0) ""
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(36) "/threads/part-3.49305/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[Oblivion Knight]

@Yugensoft The xf_tso_record table is being created as MyIASM which causes locking issues when mixed with InnoDB tables (ie xf_user).

Stupid question time.. Is setting this to InnoDB enough to resolve the issue, or is it more complicated than that?

 

[Xon]

Stupid question time.. Is setting this to InnoDB enough to resolve the issue, or is it more complicated than that?

Should be enough.

 

[Flagy_]

Hello @Yugensoft! Is this add-on working with the latest version of Xenforo 2.1? And if not, are there any plans in the future on making it work?

 

[Yugensoft]

This resource has been removed and is no longer available. The following reason was provided:

This resource has been deleted by XenForo Ltd. in line with our resource housekeeping criteria.

 

[ERSAN.NET]

very nice addon

 

[wmtech]

wmtech updated [WMTech] Time Spent Online with a new update entry:

v2.0.0 Initial WMTech Version, Updated for XF 2.1.x

Initial Release from WMTech

New Add-On ID, Updated for XF 2.1.x

Read the rest of this update entry...