User database and a personal questionnaire for each user

I run a WordPress based website for a sports club. Due to current COVID-19 restrictions every member must fill out a form answering Covid related questions before they come to every training session. This is currently done using paper.

I would like to move this process online however, I’m not sure how to achieve this.

I was thinking of getting every user to register for an account on the website and then have them complete the form electronically.

Every member has a membership number. Is there a way they could register by putting in the membership number and making a password? This way I wouldn’t have to make all the accounts myself and not everyone can register, only people with an membership number.

I also do not know how to make a form for each user. I would have to be able to keep track of who has completed the form and who hasn’t.

If anyone can help I’d really appreciate it.

How to setup GSA for each project has its own base?

I have a pack of projects in different niches but one language (en). The preferred TLD is a .com and this is easy setup. But!

I have a specially prepared bases for

project 1 = base1  (niche websites  list) 
project 2 = base2  (niche websites  list) 

Can I use (and how to set up) in one interface this idea?

4 project works in one time and get websites  list each project own website list? Likes this way:

project 1 from  folder C:/project1-base/identified
project 2 from  folder C:/project2-base/identified

Thank you !

Randomly assign n elements to n agents such that each agent only knows its own element


Problem

I’m working on an app that involves shuffling and distributing playing cards to players. As a challenge, I tried to solve this problem in a way that doesn’t require a trusted intermediary.

In other terms, the task is to find a distributed algorithm that

  • uniquely assigns $ n$ agents numbers $ 1..n$
  • allows each agent to know nothing about the assignment but its own
  • when revealing the assignment, allows other players to verify the assignment

We also assume that knowing other’s assignment is an advantage for each agent, and revealing its own prematurely a disadvantage. Agents are also assumed to be able to talk with each other in a way hidden from all other agents.

Partial solution

The solution I came up with works only under the assumption that adversaries do not collaborate.

The idea is to create a set of $ n$ nonces, and assign each agent exactly one nonce. The set is then passed from agent to agent in an agreed upon order, hidden from all others, until each agent received the set exactly once. Each time an agent receives the set, it swaps its nonce with a new one, memorizes the new nonce, and confirms receival of the set to the others. This entire procedure is done twice, at which point, all agents have received the set at least once after all other agents swapped their nonces, making it impossible to recognize and hence map the nonces to the other agents.

When the last agent receives the set the second time, it shares it with everyone, and all agents confirm to the others that their nonce is contained in the set. The agents then assign a number to each nonce in the set based on an agreed upon random seed, giving us the required unique assignment.

To allow ownership verification, instead of the nonces, agents put the hash value of their nonce on the set, revealing the actual nonce only when verification is required.


The problem with this solution is that if adversaries are allowed to collaborate, each time an adversary receives the set, they can compare their versions, identify changes and potentially derive which nonce belongs to other agents, allowing them to know what number got assigned to them.

All ideas are appreciated!

How to leave trails that are equidistant apart from each other

I want bunch of circles to follow the player while keeping a distance apart. So far I have this:

local p = {   x=0,   y=0,   life={     {x=0,y=0},     {x=0,y=0},     {x=0,y=0},     {x=0,y=0}   } }   local last={x=p.x,y=p.y} for l in all(p.life) do   l.x = lerp(last.x,l.x,0.5)   l.y = lerp(last.y,l.y,0.5)   circfill(l.x,l.y,2,7)   last={x=l.x,y=l.y} end 

But this makes it so the circles collapse into each other and the player. I want the circles to have a distance between themselves and the player.

arythmia follow life

I’ve also tried this:

  l.x = lerp(last.x*0.8,l.x,0.5) 

This leaves a distance as I want but the trail is always on the upper left, barely following player.

I want the trail to stay always behind the player.

Probably I can achieve this by stop following if the distance is less than threshold.

CEO wants to terminate fifty developers (three developers each month with the interval of ten days) based on the lowest test scores

XYZ Soft is facing a big loss in the industry. Therefore, the company has started to offload its software developers. It started to conduct a test of hundred developers on daily basis and store their test scores in a data structure. After ten days, its CEO wants to terminate fifty developers (three developers each month with the interval of ten days) based on the lowest test scores.

Suppose you are working as a most senior developer in the company then which of the following data structure you will recommend to the CEO in the above given scenario.

  1. 1.  AVL Tree 
  2. 2.  Heap 

Justify your answer with solid reason.

Can a Path of the Totem Warrior barbarian have different totems chosen for each subclass feature at the same time?

I was creating a goliath Path of the Totem Warrior barbarian (PHB, p. 50), and had chosen the Bear totem for his 3rd-level Totem Spirit feature. The 6th-level Aspect of the Beast feature, however, is redundant for a Bear totem/goliath combination, since they both basically double his carrying capacity. I wondered if I could choose a different totem at 6th level.

I did notice the following language for each subsequent totem choice after the first (at levels 6 and 14):

At ___ level, you gain a magical benefit based on the totem animal of your choice. You can choose the same animal you selected at 3rd level or a different one.

My first assumption was that this is like swapping out spells known when you level in some spell casting classes, such as the bard (i.e. if you choose Wolf at 6th level, your abilities switch over to a Wolf Totem barbarian). After all, in online discussions, people often refer to a Bear Totem barbarian, or a Wolf Totem barbarian, but never do I see reference to a multi-totemed Barbarian. However, I wanted the 6th-level Wolf ability, but didn’t want to give up the 3rd level Bear ability.

Can a Path of the Totem Warrior barbarian have multiple totems? That is, can they have different totems chosen for each subclass feature at the same time?

Get top 5 students for each class in many-to-many relationship

So I’m doing this in MySQL.

I have the table students and classes. There is a many-to-many relationship between which I track through the student_class_rel table. Below are the tables and their columns.


students

student_id | name | email | GPA


classes

class_id | name | room


student_class_rel

student_id | class_id


I want to get a student_id of the 5 students for each class with the highest GPAs (along with the class info). How would I do this?

For example, this query gets 100 classes and then gets every student_id for all students in that class

SELECT *,      JSON_ARRAYAGG(student_id)  FROM classes      INNER JOIN student_class_rel      USING(class_id)  GROUP BY class_id;  LIMIT 100 

I want that query, expect the JSON_ARRAYAGG(student_id) only holds the ID to the top 5 students in terms of GPA for each class rather than every student.

Also, assume there could be upwards of millions of students and hundreds of thousands of classes and that there are around 50 to 1000 students per class. So performance is key for this query.

And I’m aware of hacky type solutions (like make multiple queries, once for each class) but so far those have been WAY too slow. I’ve spent too much time trying to figure this out, any help is greatly appreciated! (Also let me know if there’s any additional info needed).

Is there a standard hierarchy when two supplemental books contradict each other?

The spell, Energy Vortex, is found in:

  • Complete Divine (p.164) as a 4th level Cleric/Druid spell (published May 2004)
  • Spell Compendium (p.81) as a 3rd level Cleric/Druid spell (published Dec 2005)

In both books, the spell does the exact same effect/range/damage (choice of acid/fire/electricity/cold), aside from CD allowing Sonic as a 5th choice for damage type.

Since these books were published more than a year apart, I assumed this was more a correction than a typo. Is it standard to use the most recent book as a general hierarchy, or is there another, more preferred method?

Is a concentration check required for each of my following spells if I buff myself with Mage Armor

Player’s Handbook 1, p. 170, "Concentration" – "Spell" says:

"If you are affected by a spell while attempting to cast a spell of your own, you must make a Concentration check or lose the spell you are casting."

Now I have the feeling I played DnD wrong for years – this means if I buff myself with e.g. "Mage Armor" and try to cast "Magic Missiles" the next round, I have to do a concentration check, correct? And someone I buff with another spell, too?

There is no mentioning of the spell affecting me being from someone else or hostile.