Kyle

Hey, Maybe check your hosting panel and see what's the MySQL access info, user info. ETC. Also, another suggestion, maybe create a new MySQL User and then point out the permissions to your VA's database and change the local.config info to your new db access.

simpilot's right. It's too complex to work on that. I would have to figure out how I will able trigger the auto awards, somehow cronjob would work. Sorry guys, I'll consider it in the future maybe. ----------- Also, I have something in my mind..... How many people are interested to have a "Create Pilot Account" in the admin center? Same thing as the sign up page, but different way which whenever you'll create an account, but the password will be automatically regenerated to phpVMS's Password encryption. And it will add to the email. Anyone interested into this idea? BTW, I have added the poll. Please Vote! Thanks!

Hey everyone, I just recently released a module and I ran out of ideas of what other modules I could make and free for phpVMS users. If anyone has a good module idea, please let me know. Not something that is too complex to work on. Something not too much. Let know if you are looking for something and then I'll consider your ideas. Thanks!

Well, you keep screwing up and making it worst. Basiclly you have no clue of how to fix it. I seen few topics of you giving wrong answers. So grow up.

Sorry Mark, I forgot about your request, I will add that later tonight or tomorrow for the Count of last IP address.

No problem guys!

When you delete it, it will save the IP, but it won't parse the Pilot ID and the name though. I usally keep the pilots in the system and mark their status as Deleted.

Ok, Sounds fine. but if there is no table prefix defined in the install, then it won't use the prefix. Thanks for letting me know that it works everyone!

Welcome! Did it work guys? Like is it getting the IP and info of everything it should be?

PilotLogins_V1.0 What this module does, it captures every login that your pilots login and it enters into the database table. Even you can view all login in the admin panel with the JSON Table. This module will be handy for all phpVMS users, so you can ban all IP's that the pilots used. Created Under: http://creativecommo...s/by-nc-sa/3.0/ Completed By: Vansers Thanks To: lorathon (For Helping to understand, and fixing the SQL Query to grab the pilot's info from another table) I take no credit from this module, this module is just to help you guys and you are free to expand it, but please respect to whoever completed it. Screenshot of Module: How To Install: 1) Download the file that is attached here... 2) Unzip the file... 3) Upload/Import the SQL file called phpvms_pilotlogins.sql into the database that your VMS install sits. 4) Upload the files same as the structure as your phpvms files. 5) Go to "core/modules/Login/Login.php" after the following lines..... (Line 131) PilotData::updateLogin($pilotid); After that code, add the following code to Login.php PilotLoginsData::AddLogin($pilotid); This function will run and it will grab the login info when they login 6) Then, go to admin/templates/core_navigation.tpl..... After the line... <li><a href="<?php echo adminurl('/pilotadmin/viewpilots');?>">View All Pilots</a></li> Add this... <?php } if(PilotGroups::group_has_perm(Auth::$usergroups, FULL_ADMIN)) { ?> <li><a href="<?php echo adminurl('/PilotLogins/');?>">View All Pilot Logins</a></li> Then your done! Login, and then head to Admin, and go to View All Pilot Logins. Then your done! ------------------------------------------------------- Also, I have a request, if you could let me know if it really works, if it is capturing your ip address correctly, compare it from yours in the list, to that link. http://www.whatismyip.com/ Let me know if it works. If you have any questions or requests (sometimes it may be filled or not), let me know! Enjoy the new tool. Removed:[attachment=689:PilotLogin_V1.0.zip] Download Here

Soon, As we speak. I'm just finishing up with the JSON table, and then I have to gather the stuff around it, and then add one more data class that you requested to show in profile, then I want to give it a run on a live server to make sure it's working. I should have it out later tonight, or early time in phpVMS's timezone.

Simple! Add the delete data class in the operations data class, and then in the module, you need to add the delete function and then add the delete link with the id in the tpl file. Something I can take a look into it later today. I'll post it later.

Now, it's working, I learned something new to deal with JSON tables! You have been a very big help here! Thanks for all of your help! All reps given in the posts.

For the json loop, I believe this is what you need? # Add each row to the above array foreach ($pilotlogins as $row) { $pilotid = PilotData::getPilotCode($row->code, $row->pilotid); $tmp = array( 'id' => $row->id, 'cell' => array( # Each column, in order $row->id, $pilotid, $pilotname, $row->datestamp, $row->ip, $row->client, ), ); $json['rows'][] = $tmp; }

Little confused here, I putted the code you gave in my PilotLoginsData.class and it didn't give me all of the pilot logins. This is what my current sql query to get all of the login. $sql = 'SELECT l.*, p.* FROM '.TABLE_PREFIX.'pilotlogins l LEFT JOIN '.TABLE_PREFIX.'pilots p ON p.pilotid = l.pilotid '; $sql .= DB::build_where($params); if (strlen($order_by) > 0) { $sql .= ' ORDER BY ' . $order_by; } if (strlen($count) != 0) { $sql .= ' LIMIT ' . $count; } if (strlen($start) != 0) { $sql .= ' OFFSET ' . $start; } $ret = DB::get_results($sql); return $ret; Where should I be putting that code you gave me?

Yep! It works now. So, I have to name the prefix, and join the tables. But on the other side, I been looking though the pilotData.class to find a way to get the pilots name in by pilot id, I tried many ways to display the pilot's name, something like... $pilotname = PilotData::getPilotData($row->pilotid, $firstname, $lastname); But, it returned "ojectObject", somehow, I must be doing something wrong to parse the pilot's name by pilotid. And thanks for your help as well!

it's custom part, It's in phpvms_pilotlogins. And the code you gave me, it doesn't show all the logins. But I had it like this, and it works. $sql = 'SELECT * FROM ' . TABLE_PREFIX . 'pilotlogins'; But with the JSON table and in the module file, I wanted to pull the data into Pilot Code, ID and their names.. I seen that you would have to join the tables to the pilots, so it can get it's data for pilot's first name, last name, and their pilot id. It's like the schedules JSON, like it gets the Aircraft info by id, ETC.

Need help here. So what I am trying to do, like JSON. The SQL query needs to be connected to the pilot tables. $sql = 'SELECT p.*, p.pilotid, p.firstname, p.lastname, FROM ' . TABLE_PREFIX . 'pilotlogins p LEFT JOIN ' . TABLE_PREFIX . 'pilots AS p ON p.pilotid = p.pilotid '; Does anyone know what I am doing wrong? Any help would be great! Thanks!

It just annoying when pilots join with different names or emails. It's always good to have an IP Address Tool to get these lying fools. Mark, I can take a look into it after I polish up the IP Login Module. You would have to add a Data.class, and get the IP by pilotid where you are looking at the profile, plus, some Admin Link serucity too. All, Update! I had to do some changes around. Since when you update phpVMS, you would lose this module. So I have changed and put the coding into a new module, however, for the PilotAdmin, I have removed the tab thing. So, I have created a one page that will use JSON to list all the login. Heck, JSON been a hard thing to work with, but I had fun learning it! I know, there are false and numbers, but I'm almost there. I have to add something that can grab by pilot id to get pilot ID with code and pilot names. It'll be easier for you guys to keep this in all one and you can search by IP, Name, Code. ETC.

Thanks, Yeah I will remove it till I can get the tables and rows working later tonight.

Update, just got the JSON table all in! Now time to code the table in the module. It needs to grab the row info, from the module php file. I'll get into it, tonight. Sounds fun!

Update... Login History is Sorted by latest date first. Next, will be looking into getting the JSON Table into it, like you see in the schedules and pilot list. So you don't want a long list of history. God Knows that pilots log in everyday!

I would say you would need something like Page Visit Activity, Maybe on my next module I can look into it, later this year. I want to work on this module first and build it till it's good enough.

Hey Everyone, I wanted to let you guys know that I'm working on little nice module. Basically, what this module does that whenever you login, the date and time, your IP Address, and your client will be recorded. Here's a shot, you'll understand it. So, if you are viewing Pilot ID 1, then you will see Pilot 1's Login history. Same, You are viewing Pilot ID 2, then you will see Pilot 2's login history. This is niffy stuff! , it's working so damn well and highly useful, whenever you can get all IP Logs and ban your pilots. Here's how it works, In the Login, to Process Login, I have added a DataClass to grab the info when they login. But I'm working on a different way so it won't get overwritten in updates. However, it's almost custom and you would lose everything in the update. Don't worry, I'll try my best to get it working, and it won't get overwritten in updates. Also, I'll try my best to integrate a pagination so you wouldn't get a long long list of login. Lastly, I have to ask to anyone who keeps asking me when this will be released, I'll delay if you keep asking when it will be released. Give me time to do testing and making sure it works. If you have any questions about it, or any requests, let me know! I'll be putting this module to test on a live server later. I want to fill this niffy module in!

GOT IT, Sorry for this post.