Luke Hickton
Members-
Posts
22 -
Joined
-
Last visited
-
Days Won
2
Luke Hickton last won the day on September 23 2019
Luke Hickton had the most liked content!
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
Luke Hickton's Achievements
-
Good Afternoon, I'm having some problems with a few members. When they go to their Personal Operations Centre ad view their Report in Record, its showing the record of another member. In the example below, Sgt Mjr Edwards has the profile of one of our ACdr's, this is happening with a few of my members, but not all.
-
Hi Jon, I just did some testing and it takes the order from the Combat Unit Positions list in the AdminCP. Whichever position is the highest shows first, working it's way down. This part works fine. Even if I set the list only order by paygrade, I still get the same issues.
-
Good Afternoon, I have changed the paygrades of all my ranks to follow E-0 to E-12 and O-1 to O-11, however, it seems that this doesn't work well with our roster: I have sort by Combat Position first (So the leadership is first, then listed by section), then sort by paygrade. All our ranks can be seen here: https://www.webcadets.com/perscom/ranks/ Not sure where to go from here? Thanks Luke
-
Good Afternoon, please let me know when you get fed up of my suggestions! lol Would it be possible when someone is promoted to a rank, that they are assigned a group with this? And preferably removal of groups as well? For example: We have JNCO and SNCO groups (as they control permissions on the forum), so when someone is promoted to SSgt, they are removed from the JNCO group and added to the SNCO group. The option to remove from any of the following groups would be beneficial, as sometimes we go down in rank for voluntary/punitive demotions, so an option to remove any groups (multiple choice box, to add all rank groups to) then add to one specific group for their new rank. Similar to what happens when appointed an admin position and they're added to a group, with the addition of removing any other groups from a selection. Let me know if this isn't explained well and I'll try again. Thanks
-
Good Evening, At the moment, we have assignment records for moving combat units/positions, however when adding or removing an administrative role, there is no record of it within their profile. Is it possible to have this the same as Assignments for Combat Units? Just a select box with "add administrative position" and "remove administrative position", then a drop down to select the position (preferably multi-select) to add or remove (obviously remove list will only show current roles). This would then put a record in the Assignment Records stating "Appointed as Role Name" or "Resigned as Role Name".
-
This may be slightly more difficult to do, but I was wondering if the supervisor could be set within a setting based on the Combat Unit and Position they hold? An example of how we operate: 3 Divisions, each containing a Division Officer, Division Senior NCO and 2 Sections. I would like the Supervisor for all members of "A" Division, to have their supervisor as the "A" Division Officer and/or Division Senior NCO. I would like the Supervisor for all members of "B" Division, to have their supervisor as the "B" Division Officer and/or Division Senior NCO. I would like the Supervisor for all members of "C" Division, to have their supervisor as the "C" Division Officer and/or Division Senior NCO. This means that as we move people around, we don't have to change their Supervisor each time, or if we change a Division Officer, we don't have to change the supervisor for 20 different people. The latter being the main headache. Thank you
-
Good Evening, I love the new feature to be able to send notifications with the Personnel Action Requests. I was wondering if this could be expanded in the future, to allow us to select multiple groups? Because of how we have our forums permissions, our groups are effectively the position they hold, so our Training Officer and NCO College Instructor are two different groups, but I want then both to receive notifications of an NCO College application.
-
Good Evening, I was wondering if there's any chance of showing Administrative Roles in the forum authorPane? I know my layout is different to default, but I would like to show at the bottom the list of Administrative Roles assigned to a person. Maybe a setting in the Administrative Role settings to show/hide the position, so we can select which do and don't show?
-
We have 6 sections to our ranks (Army, Marines, Navy, Coastguard, Air Force, Space). We are organised into 3 services (Land, Air & Sea), but I want to organise by rank as such. At the moment because the Army and Marines are together, it shows all Army ranks, then all Marine Ranks, so an Army Corporal is above a Marine Lieutenant for example. If we could organise them by paygrade (all forces use the same paygrade for each level), then it would allow us to show our services in the correct formation (highest rank first)
- 1 reply
-
- 1
-
Hi Jon, I was wondering if the above is possible? I will be importing our medals in directly into the database and will make a new column in the database so we don't lose previous citations if this is possible, named service_records_citation. It would be unfeasible for us to utilise the documents system for what we do, as it would strip out the uniformed look and we would be required to write 3000 documents for our previous medals alone that we are copying over. I dread to think what that would look like when trying to select a document. Thanks Luke
-
Importing into Database
Luke Hickton replied to Luke Hickton's topic in Peer to Peer Technical Support
Fantastic! Thank you Ashton, Guides all over the internet don't mention when to use them and when to not! -
Importing into Database
Luke Hickton replied to Luke Hickton's topic in Peer to Peer Technical Support
Unfortunately, I'm finding the old system is nothing like standard, it's been over years by various people adding bits and pieces and is a mess - hence the move to Perscom ? This is the code I'm using: <?php $db = new mysqli('servername', 'username', 'password', 'dbname'); if($db->connect_errno > 0){ die('Unable to connect to database [' . $db->connect_error . ']'); } $sql = "INSERT INTO perscom_service_records (service_records_soldier, service_records_text, service_records_date, service_records_document, service_records_notification, service_records_item_class, service_records_item_id, service_records_action) VALUES ('1', 'Appointed as Updates NCO (Army)', '1349110800', '5', '0', 'NULL', 'NULL', '1') ('1', 'Appointed as Unit Updates Officer (Unit Updates)', '1357149600', '5', '0', 'NULL', 'NULL', '1') ('1', 'Appointed as NCOC Instructor (Training)', '1349049600', '5', '0', 'NULL', 'NULL', '1') ('1', 'Appointed as Corps Administration Officer (Administration)', '1356998400', '5', '0', 'NULL', 'NULL', '1') ('1', 'Appointed as Officers Academy Registrar (Training)', '1393982097.9999998', '5', '0', 'NULL', 'NULL', '1') ('1', 'Appointed as Port Section Officer - Illustrious (Navy)', '1393113600', '5', '0', 'NULL', 'NULL', '1') ('1', 'Appointed as Unit Updates Officer (Navy)', '1393891200', '5', '0', 'NULL', 'NULL', '1') ('1', 'Appointed as Officers Academy Commanding Officer (Training)', '1404086400', '5', '0', 'NULL', 'NULL', '1') ('1', 'Appointed as Officers Academy Instructor (Training)', '1414540800', '5', '0', 'NULL', 'NULL', '1') ('1', 'Appointed as Forums Officer (Site Maintenance)', '1420502400', '5', '0', 'NULL', 'NULL', '1') ('1', 'Appointed as Logistics Officer (WCC)', '1452643200', '5', '0', 'NULL', 'NULL', '1') ('1', 'Appointed as Officers Academy Instructor (Training)', '1420588800', '5', '0', 'NULL', 'NULL', '1') "; if ($db->query($sql) === true) { echo "Records inserted successfully."; } else { echo "ERROR: Could not able to execute $sql. " .$db->error; } $db->close(); ?> and this is the error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '('1', 'Appointed as Unit Updates Officer (Unit Updates)', '1357149600', '5', '0'' at line 4 I will admit, this is one of my first ever attempts at coding some like this so, so I do apologise! Thanks for the help so far Luke -
Good Morning, I am currently looking at importing a wealth of information into the perscom_service _records table I tried a variety of methods through phpMyAdmin to import it including a manual test and I believe the date is causing us an issue. Our old database has recorded it as "01/10/2012 17:00" rather than the int(10) that perscom uses. Is there a method I can use to convert the dates or any method that would allow me to import all the information. We currently have 4400 records of just position appointments and resigning. I don't mind if the method is done through a php script or something, all data is currently held in a CSV file from our old database. King regards Luke
-
Block to extract data
Luke Hickton replied to Luke Hickton's topic in Peer to Peer Technical Support
Hi Jon, thanks for the assistance, apologies for the lateness, we've just transferred all our data to IPS and changed host all in one night lol. I've tried both of these in a PHP Custom Block, error messages below: Straight up PHP: ParseError: syntax error, unexpected 'as' (T_AS), expecting ',' or ')' (0) #0 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/FormAbstract.php(377): IPS\cms\Blocks\_Block->IPS\cms\Blocks\{closure}('$position = 22;...') #1 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/TextArea.php(119): IPS\Helpers\Form\_FormAbstract->validate() #2 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/FormAbstract.php(165): IPS\Helpers\Form\_TextArea->validate() #3 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/FormAbstract.php(142): IPS\Helpers\Form\_FormAbstract->setValue(true) #4 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/TextArea.php(66): IPS\Helpers\Form\_FormAbstract->__construct('block_content', '', false, Array, Object(Closure), NULL, NULL, 'block_content') #5 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/Codemirror.php(68): IPS\Helpers\Form\_TextArea->__construct('block_content', '', false, Array, Object(Closure), NULL, NULL, 'block_content') #6 /home/sites/6b/5/5faa0124ea/public_html/applications/cms/sources/Blocks/Block.php(668): IPS\Helpers\Form\_Codemirror->__construct('block_content', '', false, Array, Object(Closure), NULL, NULL, 'block_content') #7 /home/sites/6b/5/5faa0124ea/public_html/system/Node/Controller.php(489): IPS\cms\Blocks\_Block->form(Object(IPS\Helpers\Form)) #8 /home/sites/6b/5/5faa0124ea/public_html/system/Node/Controller.php(388): IPS\Node\_Controller->_addEditForm(Object(IPS\cms\Blocks\Block)) #9 /home/sites/6b/5/5faa0124ea/public_html/system/Dispatcher/Controller.php(85): IPS\Node\_Controller->form() #10 /home/sites/6b/5/5faa0124ea/public_html/system/Node/Controller.php(62): IPS\Dispatcher\_Controller->execute() #11 /home/sites/6b/5/5faa0124ea/public_html/applications/cms/modules/admin/pages/blocks.php(39): IPS\Node\_Controller->execute() #12 /home/sites/6b/5/5faa0124ea/public_html/system/Dispatcher/Dispatcher.php(152): IPS\cms\modules\admin\pages\_blocks->execute() #13 /home/sites/6b/5/5faa0124ea/public_html/admin/index.php(14): IPS\_Dispatcher->run() #14 {main} IPS Syntax: ParseError: syntax error, unexpected '\' (T_NS_SEPARATOR), expecting '(' (0) #0 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/FormAbstract.php(377): IPS\cms\Blocks\_Block->IPS\cms\Blocks\{closure}('{{$position = 2...') #1 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/TextArea.php(119): IPS\Helpers\Form\_FormAbstract->validate() #2 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/FormAbstract.php(165): IPS\Helpers\Form\_TextArea->validate() #3 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/FormAbstract.php(142): IPS\Helpers\Form\_FormAbstract->setValue(true) #4 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/TextArea.php(66): IPS\Helpers\Form\_FormAbstract->__construct('block_content', '', false, Array, Object(Closure), NULL, NULL, 'block_content') #5 /home/sites/6b/5/5faa0124ea/public_html/system/Helpers/Form/Codemirror.php(68): IPS\Helpers\Form\_TextArea->__construct('block_content', '', false, Array, Object(Closure), NULL, NULL, 'block_content') #6 /home/sites/6b/5/5faa0124ea/public_html/applications/cms/sources/Blocks/Block.php(668): IPS\Helpers\Form\_Codemirror->__construct('block_content', '', false, Array, Object(Closure), NULL, NULL, 'block_content') #7 /home/sites/6b/5/5faa0124ea/public_html/system/Node/Controller.php(489): IPS\cms\Blocks\_Block->form(Object(IPS\Helpers\Form)) #8 /home/sites/6b/5/5faa0124ea/public_html/system/Node/Controller.php(388): IPS\Node\_Controller->_addEditForm(Object(IPS\cms\Blocks\Block)) #9 /home/sites/6b/5/5faa0124ea/public_html/system/Dispatcher/Controller.php(85): IPS\Node\_Controller->form() #10 /home/sites/6b/5/5faa0124ea/public_html/system/Node/Controller.php(62): IPS\Dispatcher\_Controller->execute() #11 /home/sites/6b/5/5faa0124ea/public_html/applications/cms/modules/admin/pages/blocks.php(39): IPS\Node\_Controller->execute() #12 /home/sites/6b/5/5faa0124ea/public_html/system/Dispatcher/Dispatcher.php(152): IPS\cms\modules\admin\pages\_blocks->execute() #13 /home/sites/6b/5/5faa0124ea/public_html/admin/index.php(14): IPS\_Dispatcher->run() #14 {main} Thanks -
Block to extract data
Luke Hickton replied to Luke Hickton's topic in Peer to Peer Technical Support
Many thanks Jon!