Topic: pnLastLogin
myths
avatar
Helper
Helper
Posts: 117

Posted:
5.Mar 2007 - 01:39

very cool idea, but I'm a bit confused on how to apply the settings, anyone was lucky to set this correctly and got it to work?
backharlow

Freshman
Freshman
Posts: 31

Posted:
7.Mar 2007 - 04:12

No. But you aren't alone. I'd like to figure this one out too.
quan
avatar
Freshman
Freshman
Posts: 22

Posted:
7.Mar 2007 - 18:45

Hi!

I'm, the author of this module. If you specify the problems a little bit more detailed I'll try to help you icon_wink

Greetings, Flo (quan)



edited by: quan, Mar 07, 2007 - 01:46 PM
myths
avatar
Helper
Helper
Posts: 117

Posted:
7.Mar 2007 - 20:22

well, there's some points I cant really understand:

How the lastlogin info (and the userid) will be stored in an existing field? shouldnt we create a new field instead or new table?
quan
avatar
Freshman
Freshman
Posts: 22

Posted:
7.Mar 2007 - 22:37

You can deactivate an existing field in your dynamic user data and use this one.
Fields that can be added via the dynamic user data can NOT be used.
Disable te occupation-field for example, create a new occupation field as dynamical user data (if your users want o have such a field listed) and use the old occupation field to store the lastlogin value (as an example).
You can also create a new table but consider that the new table has to have an user-id field as a row.

Greetings, Flo
myths
avatar
Helper
Helper
Posts: 117

Posted:
9.Mar 2007 - 04:27

Flo,
Thanks for the clarification, its really great module.
silverscout
avatar
Helper
Helper
Posts: 408

Posted:
17.Mar 2007 - 17:34

I am still confused, I would rather this be in its own table.

I created two new cells. and it didn't work

can you provide a SQL code to make it work? That would be great.

SS.

quan
avatar
Freshman
Freshman
Posts: 22

Posted:
20.Mar 2007 - 16:00

did you create new cells in the core users table of PostNuke? then you just have to specify the new cell as the cell in which the data should be stored and the uid cell to idenfity the user's row in the table.

if you want to use an external extra table make sure that there is a row for the user-id and a row has to exist for EVERY user in this table before the last login value can be stored.
silverscout
avatar
Helper
Helper
Posts: 408

Posted:
23.Mar 2007 - 01:15

I guess I am getting confused

in my core users I created 2 new columns.

filed in which the last login date should be stored =
_users.lastlogindate

field for the iser-id(needs to be in the same table as the filed above) =
_users.iser-ID
quan
avatar
Freshman
Freshman
Posts: 22

Posted:
24.Mar 2007 - 01:19

no - you don't need TWO cells, just one. use the _uid for the user-ID (not iser-ID, thats a typo in the english language file)
tazmon95
avatar
Helper
Helper
Posts: 137

Posted:
3.Jul 2007 - 19:58

Howdy and thank you for this module. I found that in the PNphpBB tables in the PN tables there are two that work well for this module to link to

pn_phpbb_users.user_lastvisit
and
pn_phpbb_users.user_id

I do have one question to go with this. What is the best way to only allow admins to see the new block that came with this as of .20?

--
Member of the PNphpBB Development Team
Melinda
avatar
Helper
Helper
Posts: 101

Posted:
28.Feb 2008 - 12:16

OK, so how do I add a column to an existing database?
I have mySQL 5.0 running on a linux server - but it's a hosted account and the "tech" support doesn't support mySQL questions. (in other words, they can't answer my question)
I want to add a column to the pn_users database in order to use the pnlastlogin module, but I don't know how to add the column using mySQL queries or whatever.
I figure it's easiest to just add the column or field to the existing database for users - since I can't find the table for pn_profile - but how?
"Dummies" version works best for me. :D
Thanks in advance,
Mickey

--edit--
ok, never mind the above post, I found it and added it.
Next question, which file in my Xanthia theme do I need to add the code? From the module:

Quote

To user the module in Xanthia-Themes include the following code in your theme:

Code

<!--[pnmodapifunc modname="LastLogin" type="admin" func="LogLastLogin"]-->

Do I need to edit the theme.php, the master.htm or the home.htm?
Thanks, Mickey



edited by: Melinda, Feb 28, 2008 - 02:41 AM

--
Mickey
http://hraus.net
http://hraforums.hraus.net
Melinda
avatar
Helper
Helper
Posts: 101

Posted:
28.Feb 2008 - 13:40

Another question, where's the block for the pnLastLogin module?
According to the site, there's supposed to be a block with it. When I tried to set up the block, it wasn't listed.
If there's not one with the download, where can I get the block? It seems the NOC is down - at least I can't log into it.
Thanks,
Mickey
videokid
avatar
Professional
Professional
Posts: 924

Posted:
28.Feb 2008 - 19:54

Code

To user the module in Xanthia-Themes include the following code in your theme:
<!--[pnmodapifunc modname="LastLogin" type="admin" func="LogLastLogin"]-->

There is no Xanthia theme? No problem. include before the line "// Get variables " the following line in index.php in the root postnuke folder.:
pnModAPIFunc('LastLogin','admin','LogLastLogin');


I wanted to check on your site, but... it's so slow... every click takes up 1 minute.... this is taking too much time, sorry...

- Igor

--
Have a nice day
zikulapro.be is currently running
Zikula 1.0.2
Melinda
avatar
Helper
Helper
Posts: 101

Posted:
28.Feb 2008 - 22:04

Igor, I know it's slow, I'm going to work on that this weekend.
Sorry it's so slow, I don't know why yet.
Mickey
spcharlie
avatar
Freshman
Freshman
Posts: 4

Posted:
29.Feb 2008 - 09:02

[quote=videokid]

Code

To user the module in Xanthia-Themes include the following code in your theme:
<!--[pnmodapifunc modname="LastLogin" type="admin" func="LogLastLogin"]-->

There is no Xanthia theme? No problem. include before the line "// Get variables " the following line in index.php in the root postnuke folder.:
pnModAPIFunc('LastLogin','admin','LogLastLogin');


But which file for the theme does that code go into?
quan
avatar
Freshman
Freshman
Posts: 22

Posted:
1.Mar 2008 - 18:42

Your problem seems to be a database-administration problem.
So, the module is not configured the right way. The block will only be shown with a working configuration of pnlastlogin.

but:
====
pnLastLogin will not be developed any more. PostNuke .8 will have a lastlogin field in the users database table.
So this litte module is not needed any more.

Flo
Melinda
avatar
Helper
Helper
Posts: 101

Posted:
5.Jun 2008 - 20:30

I have a quick question that someone asked here before but didn't get an answer.
When I first started using the pnLastLogin module, I was using the ExtraLite theme and got it to work fine. Now, I've gone to using Xanthia themes.
The admin section says to include the

Code

<!--[pnmodapifunc modname="LastLogin" type="admin" func="LogLastLogin"]-->
in your theme. But it doesn't say where to put it. Does it need to go into the theme.php or the master.htm or where? icon_confused
I am not upgrading to .8 until it's all happy, happy, joy, joy. icon_biggrin And the modules that I'm using are ported over to .8 - which most of them seem to be so far.
So, if someone can tell me where to put the code in the Xanthia theme, I would be greatly appreciative.

Thanks in advance,
Mickey
hilope

Helper
Helper
Posts: 112

Posted:
6.Jun 2008 - 01:55

Put in in the master.htm and modules/home.htm (if exists) in your themes folder to get all pages. Then clear pnRender/Xanthia_compiled and reload page.


--
scribite! - pimp your Zikula
Melinda
avatar
Helper
Helper
Posts: 101

Posted:
7.Jun 2008 - 23:28

Sven,
Thanks, that worked perfectly.
Have no clue where my brain went when I tried to install and use it the first time. I knew it was one of the .php or .htm files. Takes someone who's actually thinking to remind me to put my brain back in gear. :D
Mickey