finally joining this fine forum :-) .. to contribute - well thats at least what i intend to.
You might prove me wrong, - but i've found a weird fix to the problem where users complain that
articles are locked by another user (as in they've used the back button, closed the browser etc, without
using the buttons in the editor.
Of course you can link to "check in my items" in frontend, OR do a "global checkin" in backend every now and then.
But its Just Not Functional when you got a few user, and are administrating too many sites...
This causes a Lot of Hazzle!
So here is what i did: I've mounted the Joomla in a subfolder "cms" under webroot.
In webroot I've put an "index.asp" (im more comfy with asp you see. sorry,
you can do the same with PHP, i just dont know "how" yet..)
this index.asp runs a SQL UPDATE statement, and before it redirects to the /cms (joomla) folder.
The SQL statement simply sets "checked_out" to "0" in every record in "content" where "checked_out" doesnt exist in Sessions.Userid. The SQL string looks like this:
Code: Select all
"UPDATE jos_content SET jos_content.checked_out = '0' WHERE jos_content.checked_out > '0' And jos_content.checked_out Not In (SELECT userid from jos_session) "
Code: Select all
<%
'STARTUP SCRIPT
on error resume next
dim Connection1, strQuery, MM_serverside_STRING
'database connection
MM_serverside_STRING = "DRIVER={MySQL ODBC 3.51 Driver}; Server=localhost; Port=3306; Option=3; Socket=; Stmt=; Database=thedatabase; Uid=userid; Pwd= password"
Set Connection1 = Server.CreateObject("ADODB.Connection")
Connection1.open MM_serverside_STRING
'set checked_out status to 0 for all content items that doesnt exist in session table
strQuery = "UPDATE jos_content SET jos_content.checked_out = '0' WHERE jos_content.checked_out > '0' And jos_content.checked_out Not In (SELECT userid from jos_session) "
'do it
Connection1.Execute strQuery
'tidy up and close
Connection1.Close
Set Connection1 = Nothing
'then redirect to live site
response.Redirect("http://www.yourdomain.com/cms")
'no error handler yet....
%>
Why the &^&£$&^! isnt this a part of the CORE, fireing everytime joomla starts - to clean up,.??!!
are anyone up for developing a mambot - i just dont have the skills.....
OH. i heard this is resolved in 1.5, i just cant migrate all these sites. so had to tweak the 1.0.15
looking forward to hear your comments...
best
STIAN