I am busy changing the world

When browsing the Tikiwiki forum, I noticed the Back-to-Top button which is pretty useful and I want to bring it to my own Tikiwiki. But, the thing is there is no documentation about it so I have to look into the HTML source of the forum. It turned out that It's quite simple: 1. What you need to do first is to create a custom module: http://your-tikiwiki-url/tiki-admin_modules.php In the Custom Modules tab -> Add this to the Data text field: <div class="backtotop"><a href="#top" title="Back To Top">⌅</a></div> -> Click Save 2. Then, assign the custom module to the Bottom section: Go to Assigned Modules -> Bottom tab -> Add module -> Select your Back to Top module Make sure these parameter was set: Position: bottom Parameters: nobox=y -> Click Assign 3. Go to Look & Feel, Customization tab, add this CSS: .backtotop { bottom: 3rem; position: fixed; right: 3rem; } .backtotop a:af...

In many cases, the web engine that generates data tables (html) is close-sourced and you cannot sort those tables. It is not because the engine does not have a mechanism to sort data. It's just that its behaviors does not satisfy your need. For example, the PowerSchool customization engine. In PowerSchool, I can output a table of lunch balance information of a student using this template syntax: ~[tlist;gldetail;studentid=~(curstudid);alternatecolor;sortcmd;date, > ,time, > ;]   <td>~(date)</td>   <td>~(time)</td>   <td>~(neteffect)</td>   <td>~(runninglunchtotalbalance.students)</td>   <td colspan="3">~(transdescription)</td> Did you see the >  (greater than) sign? It says that the table will sort by the date and time columns in ascending order. What I want is to make it sort date and time in descending order. So I tried to replace the > with the < (less than) ho...

It's quite useful displaying the bell schedule info of the day on the admin and teachers pages's header in PowerSchool. Here is how to do it: 1. Go to PS Administrator >> Custom Pages 2. Add this following code to wildcards/admin_header_css.txt and wildcards/teacher_header_css.txt <span id="ssis-date" style="padding-right:20px;"> ~[tlist_sql; select b.name as name, listagg(p.ABBREVIATION || ',') WITHIN GROUP ( ORDER BY bi.START_TIME) AS periods     from ps.calendar_day c inner join ps.BELL_SCHEDULE b on c.BELL_SCHEDULE_ID = b.ID         inner join ps.BELL_SCHEDULE_ITEMS bi on bi.BELL_SCHEDULE_ID = b.ID         inner join ps.PERIOD p on p.ID = bi.PERIOD_ID     where TO_CHAR(c.DATE_VALUE, 'DD-MM-YYYY') = TO_CHAR(CURRENT_DATE, 'DD-MM-YYYY')         and c.SCHOOLID = ~(curschoolid)     group by b.name; ]     <span style="color:#195f7d">~(name):</span> ~(p...

I was trying to display some custom field data (I will take ssis_student_nickname as an example in this article) in the classattendance.html page in PowerSchool Teachers. But, to be honest, I'm not sure about the customization syntax of PowerSchool. I couldn't make it work with this following syntax: ~([01]ssis_student_nickname) or ~([Students.U_STUDENTSUSERFIELDS]ssis_student_nickname) As fas as I acknowledged, the classattendance page accessing the attendance database using some javascript. So, in the end, I have to do some hack to display the custom field in that page. Here is the details: 1. Add an additional column in the page, and name it: ...              <th align="left" class="cvDemarcation">~[text]psx.html.teachers.classattendance.students[/text]</th>             <th class="cvDemarcation">Student Nick Name</th> ...             <tr class="s...