Hi,

If you activate statistic, you will have "Login Counter"
See http://www.xwiki.org/xwiki/bin/view/AdminGuide/Configuration section
Enabling/Disabling Statistics

And a sample code:

1.1 Last user connected

<%
sql = "select stats.name, max(stats.endDate) from VisitStats as stats
group by stats.name order by 2 desc";
result = xwiki.search(sql, 100, 0)

for (item in result) {
 user = item[0]
 userdate = item[1]
 try {
  userlink = xwiki.getUserName(user)
 } catch(Exception e) {
  userlink = user
 }
 println "* ${userlink}: ${userdate}"
}
%>



Regards,

Arnaud.

[EMAIL PROTECTED] wrote on 02/11/2007 12:25:
> Hi,
>
> Please help me out,
>
> Help for XWiki - User Login Counter
>       ([EMAIL PROTECTED])
>
> Hi All,
>
>  
>
> I want to be creating the XWiki - User / Admin Login Counter. - (Page
> visited for intranet through respective Login).
>
> Please help me, how to do that? If anyone has xwiki code, please send to
> me. I am new to XWiki.
>
>
> Regards,
> Prabhakar Gopalsamy
> ______________________________
> Wipro Technologies
>
> Regards,
> Prabhakar Gopalsamy
> ______________________________
> Wipro Technologies
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of [EMAIL PROTECTED]
> Sent: Friday, November 02, 2007 4:28 PM
> To: [email protected]
> Subject: users Digest, Vol 4, Issue 6
>
> Send users mailing list submissions to
>       [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
>       http://lists.xwiki.org/mailman/listinfo/users
> or, via email, send a message with subject or body 'help' to
>       [EMAIL PROTECTED]
>
> You can reach the person managing the list at
>       [EMAIL PROTECTED]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of users digest..."
>
>
> Today's Topics:
>
>    1. Login counter ([EMAIL PROTECTED])
>    2. Re: Login counter (goldring, richard)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 2 Nov 2007 16:15:37 +0530
> From: <[EMAIL PROTECTED]>
> Subject: [xwiki-users] Login counter
> To: <[email protected]>
> Message-ID:
>       
> <[EMAIL PROTECTED]>
> Content-Type: text/plain;     charset="us-ascii"
>
>
> Hi,
>
> Please help me out,
>
> Help for XWiki - User Login Counter
>       ([EMAIL PROTECTED])
>
> Hi All,
>
>  
>
> I want to be creating the XWiki - User / Admin Login Counter. - (Page
> visited for intranet through respective Login).
>
> Please help me, how to do that? If anyone has xwiki code, please send to
> me. I am new to XWiki.
>
>
> Regards,
> Prabhakar Gopalsamy
> ______________________________
> Wipro Technologies
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of [EMAIL PROTECTED]
> Sent: Friday, November 02, 2007 4:11 PM
> To: [email protected]
> Subject: users Digest, Vol 4, Issue 5
>
> Send users mailing list submissions to
>       [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
>       http://lists.xwiki.org/mailman/listinfo/users
> or, via email, send a message with subject or body 'help' to
>       [EMAIL PROTECTED]
>
> You can reach the person managing the list at
>       [EMAIL PROTECTED]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of users digest..."
>
>
> Today's Topics:
>
>    1. Re: Porblem Installing w/Oracle (Vincent Massol)
>    2. Class attributes (goldring, richard)
>    3. Re: Adding a document in XWiki.org (Esbach, Brandon)
>    4. Access rights on XWiki space (Marie Sauvage [EBM WebSourcing])
>    5. Re: Access rights on XWiki space (Esbach, Brandon)
>    6. Re: Access rights on XWiki space (Marie Sauvage [EBM WebSourcing])
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 2 Nov 2007 09:24:56 +0100
> From: Vincent Massol <[EMAIL PROTECTED]>
> Subject: Re: [xwiki-users] Porblem Installing w/Oracle
> To: XWiki Users <[email protected]>
> Message-ID: <[EMAIL PROTECTED]>
> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
>
> Hi Craig,
>
> Have you followed the instructions on
> http://www.xwiki.org/xwiki/bin/view/AdminGuide/InstallationOracle 
>   and especially the part about the oracle HBM file?
>
> Also what version of xwiki are you installing?
>
> Thanks
> -Vincent
>
> On Nov 2, 2007, at 12:59 AM, Fye Kan wrote:
>
>   
>> Hello,
>>
>> We're investingating a few wiki options and were trying to use Xwiki  
>> with Tomcat 6 and Oracle 10g using the war installation process.  
>> We've modified all of the config files per the instructions on the  
>> site but are getting the following errors when trying to access the  
>> default page:
>>
>> 17:25:31,106 [http-129.147.132.30-80-1] ERROR  
>> store.XWikiHibernateBaseStore   - Failed updating schema: 2
>> 17:25:31,213 [http-129.147.132.30-80-1] ERROR  
>> store.XWikiHibernateBaseStore   - While executing query: update  
>> xwikidoc set xwd_translation=0 where xwd_translati on is null
>> 17:25:31,213 [http-129.147.132.30-80-1] ERROR  
>> store.XWikiHibernateBaseStore   - Failed updating schema: ORA-00942:  
>> table or view does not exist
>>
>> followed by a lot more errors. This is a brand new install so no  
>> tables exist yet. The user account we have for the DB has access to  
>> create/modify/remove tables so we're at a bit of a loss as to what  
>> the problem is. Does anyone out there have any suggestions as to  
>> what the problem could be? Do we need to create the tables a head of  
>> time? Is there a script to do so? Any help would be appreciated,  
>> thanks!
>>
>> Craig
>> ________________________
>>     
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 2 Nov 2007 09:47:46 -0000 
> From: "goldring, richard" <[EMAIL PROTECTED]>
> Subject: [xwiki-users] Class attributes
> To: "'XWiki Users'" <[email protected]>
> Message-ID:
>       
> <[EMAIL PROTECTED]>
> Content-Type: text/plain
>
> Hi,
>
> Does anyone know how to set the various Class properties? There appears
> to
> be no documentation on this - if there's anyone in the know who could
> provide some documentation then it would be really really useful for
> developing inline forms to access page object properties to help develop
> real applications on XWiki.
>
> i.e. for a display selection list on an inline form ... 
>
> Name: 
>  
> Pretty Name: 
>  
> Tooltip: 
>  
> Custom Display: 
>  
> Unmodifiable: 
> ---
> Yes
> No
> Number: 
>  
> Validation Regular Expression: 
>  
> Validation Message: 
>  
> Size: 
>  
> Rows: 
>  
> Editor: 
> ---TextPureTextWysiwyg 
> Content: 
> FullyRenderedTextVelocityCodePureText 
> TaskMainTypeName: 
>  
> Pretty Name: 
>  
> Tooltip: 
> Task main type 
> Custom Display: 
>  
> Unmodifiable: 
> ---
> Yes
> No
> Number: 
>  
> Validation Regular Expression: 
>  
> Validation Message: 
>  
> Display Type: 
> inputselectradiocheckbox 
> Multiple Select: 
> ---
> Yes
> No
> Relational Storage: 
> ---
> Yes
> No
> Use Picker: 
> ---
> Yes
> No
> Size: 
>  
> Join separator: 
>  
> Sort: 
> noneidvalue 
> Cache: 
> ---
> Yes
> No
> Values: 
>  
> Separators: 
>  
>
> Regards,
>
> Richard
>
> Thales UK Ltd (Wells) DISCLAIMER: The information contained in this
> e-mail
> is confidential. It may also be legally privileged. It is intended only
> for
> the stated addressee(s) and access to it by any other person is
> unauthorised. If you are not an addressee, you must not disclose, copy,
> circulate or in any other way use or rely on the information contained
> in
> this e-mail. Such unauthorised use may be unlawful. We may monitor all
> e-mail communications through our networks. If you have received this
> e-mail
> in error, please inform us immediately on +44 (0) 1749 672081 and delete
> it
> and all copies from your system. We accept no responsibility for changes
> to
> any e-mail which occur after it has been sent.  Attachments to this
> e-mail
> may contain software viruses which could damage your system.  We
> therefore
> recommend you virus-check all attachments before opening. A business of
> Thales UK Ltd. Registered Office: 2 Dashwood Lang Road, The Bourne
> Business
> Park, Addlestone, Weybridge, Surrey KT15 2NX Registered in England No.
> 868273
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 2 Nov 2007 09:57:08 -0000
> From: "Esbach, Brandon" <[EMAIL PROTECTED]>
> Subject: Re: [xwiki-users] Adding a document in XWiki.org
> To: "XWiki Users" <[email protected]>
> Message-ID:
>       
> <[EMAIL PROTECTED]>
>       
> Content-Type: text/plain; charset="iso-8859-1"
>
> Given that I can't access outside servers from our server network
> (company policy), I adjusted this to reflect my own database - changing
> only the db name and user details.  I setup a table to mimic your column
> name as well.
>  
> On 1.1 it seems to work; though my environment is a bit different to
> standard release (not completely standard xwiki install).
>
> ________________________________
>
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
> Of Your XEN ICT Team - Ricardo Rodriguez
> Sent: 01 November 2007 19:15
> To: XWiki Users
> Subject: Re: [xwiki-users] Adding a document in XWiki.org
>
>
> Esbach, Brandon wrote: 
>
>       Xwiki.org sandbox: you don't normally get programming rights
> (admin rights don't guarantee programming rights on the .org sites).
>       Someone on the xwiki team will have to open and save the page
> for you in order to test it.
>       
>         
>
> Thanks for the information. I didn't realize about the required
> programming rights. It is perfectly reasonable that this rights must be
> given by an administrator.
>
> But the site is not accessible yet. This link
> http://sandbox.xwiki.org/xwiki/bin/view/Main/WebHome keeps generating an
> exception while reading document XWiki.XWikiPreferences.
>
> In any case, it there were a problem with programming rights, I
> understand that no script will be executed. In this case, scripts
> recovering a single record work fine or printing simple lines by using
> println work fine.
>
>
>
>       If it's a local xwiki instance that's also causing the problem,
> I'm not sure.  Accessing mysql databases seems to work fine for me for
> my own local databases.
>
>
> Could you be so kind as to trying the following script in your xwiki
> installation to see if it is my server the only one that is having
> problems while printing iterations? Thanks!
>
>
> <%
> import groovy.sql.Sql;
> println "This is a sample to access epec in *mire*"
> def sendSQL =
> Sql.newInstance("jdbc:mysql://mire.environmentalchange.net/epec","epec_R
> eadOnly", "epec_ReadOnly", "com.mysql.jdbc.Driver") 
> sendSQL.eachRow("SELECT * FROM epec.spot s") {row ->println
> "${row.code}"}
> %>
>
>
> I've run it in three boxes all of them running 1.2-milestone-1.5235 and
> always get the same result.
>
> Please, could anybody else try this? Thank you so much.
>
> Best,
>
>
>   
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to