PilotLogins_V1.0 (UN-SUPPORTED)

[joeri]

van i have 1 question suggestion.

curently every logg in is show would it be possible to filter it (same ip,...)as for now i have about 15 logins from some pilots who use home,work,laptop,cell,... to look at our website

[Kyle]

Yeah I did,

I'm not sure what is going on,

But the error seems to tell me that you don't have the data class file uploaded to your common folder. Maybe try redownloading it and upload the files again and see what happens. Maybe a faulty download. . .

van i have 1 question suggestion.curently every logg in is show would it be possible to filter it (same ip,...)as for now i have about 15 logins from some pilots who use home,work,laptop,cell,... to look at our website

hey joeri, I would have to update the module to filter it. But the login action is recorded every time you log on.

[Virtualei]

excellent. all works for me. thank you Kyle

[Tylor Eddy]

Thanks Kyle,

Works like a charm.

Keep up the great work

Tylor

[michael Kraan]

Works thanks!

[Kyle]

Works thanks!

No problem!

[Kyle]

Module now has been uploaded to Github : https://github.com/Vansers/phpVMS_PilotLogin

Download Here

[twincessna340a]

In order to not have to worry about overwriting your admin core_navigation.tpl during updates and having to rewrite the code again you can put this code in the PilotLogins.php above public function index (line 26)

public function navbar()
{
if(PilotGroups::group_has_perm(Auth::$usergroups, FULL_ADMIN))
{
echo '<li><a href="'.SITE_URL.'/admin/index.php/PilotLogins/">View All Pilot Logins</a></li>';
}
}

This will put the link under the 'Addons' bar in the Admin Center

Edited March 3, 2012 by Kyle (Vansers)
Please put the php codes in code tags.

[Kyle]

In order to not have to worry about overwriting your admin core_navigation.tpl during updates and having to rewrite the code again you can put this code in the PilotLogins.php above public function index (line 26)

public function navbar()

{

if(PilotGroups::group_has_perm(Auth::$usergroups, FULL_ADMIN))

{

echo '<li><a href="'.SITE_URL.'/admin/index.php/PilotLogins/">View All Pilot Logins</a></li>';

}

}

This will put the link under the 'Addons' bar in the Admin Center

Ekkk!!!

I almost forgot to put it in the update! I'll fix that right away.

Thanks!

[Kyle]

Module Updated

Files Changed:

• admin/modules/PilotLogins/PilotLogins.php
  

View Changes

Download Here

[twincessna340a]

The table in the admin center isn't populating....the sql db is parsing the logins and the logindataclass works not sure whats going on

[Kyle]

There was a table changes.

If the table "phpvms_pilotlogins" is that. Then run this query in phpMyAdmin to change the database table title. Be sure your in your phpVMS database and run that SQL Query.

RENAME TABLE phpvms_pilotlogins TO pilotlogins

[twincessna340a]

RENAME TABLE phpvms_pilotlogins TO pilotlogins

i installed it as pilotlogins.....the Pilot Login History isn't pulling out of the db tbl either

[Kyle]

Do me a favour...

Go to core/common/PilotLoginData.class.php and go to line 21-24

See if these lines are the same to this code?

 $sql = 'SELECT l.*, p.*
   FROM pilotlogins l
   LEFT JOIN pilots p ON p.pilotid = l.pilotid
   ';

If not, then remove the following lines and put the one as I posted the code.

[twincessna340a]

they are correct

[Kyle]

Give a few mins. I'll download my module and see what I can debug. I'll let you know what the issue is.

Thanks!

[Kyle]

Okay, found the bug. Why the heck did I remove the table prefix from the SQL? LOL.

Go to core/common/PilotLoginData.class.php and go to line 21-24 - find the code...

 $sql = 'SELECT l.*, p.*
FROM pilotlogins l
LEFT JOIN pilots p ON p.pilotid = l.pilotid
';

And replace with that new code....

 $sql = 'SELECT l.*, p.*
FROM pilotlogins l
LEFT JOIN '.TABLE_PREFIX.'pilots p ON p.pilotid = l.pilotid
';

That should fix the issue.

Will release a new build in a sec.

[Kyle]

Module Updated

Files Changed:

• core/common/PilotLoginsData.class.php
  

View Changes

Download Here

[twincessna340a]

Sorry to keep bugging you Kyle, but the pilot login history isn't working. It shows up, but it displays 'the pilot has not logged in yet' . I've looked at this several ways and i'm stuck. also, is there a way we could select how many in the history to display?

Another feature request: Add a last login date field to pilots_list.tpl

[Edwin]

any new link on this one, all links I tried are dead

Update: i found it by google search, so no need for me to link anymore.

Now if I want someone blocked by IP, how do I do that?

I found this topic http://forum.phpvms.net/topic/6763-block-an-ip-address/ but its not clear for me what to do and where to add. Hope some can help me out here.

[Luke2000]

offline !

[Kapitan]

Fatal error: Class 'PilotLoginsData' not found in /public_html/core/modules/Login/Login.php on line 147

That problem , i uploaded PilotLoginsData

Sorted , my ftp client change file name from PilotLoginsData to pilotloginsdata.