Jump to content

nipplesalad

Member
  • Posts

    105
  • Joined

  • Last visited

Awards

This user doesn't have any awards

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

793 profile views

nipplesalad's Achievements

  1. Hello, i am trying to create an SQL query for my processmaker process and im stuck on deleting multiple entries. I have two tables; PMT_COURSEINPLAN and PMT_PLAN PMT_PLAN has two fields: ID (The ID of the student) PLANID (The ID of the plan) PMT_COURSEINPLAN also has two fields: COURSE (The ID of the course) PLANID (The ID of the plan) I also have a variable called $student which is the current student using the system I need a query that does the following: When a student is accepted, they need to create an educational plan with courses in it When the query is done, there should be no entries in PMT_COURSEINPLAN that have the same PLANID as a plan that is in PMT_PLAN that has a ID that is the same as the student id ($student) of the student using the system I realize this may not make sense so i will add some screenshots of my database that should help understand my problem. https://ibb.co/RChNKWw https://ibb.co/R3sywjf https://ibb.co/NCjst7k https://ibb.co/bWbbWvW https://ibb.co/q1CTbW9 https://ibb.co/HxQvYnk Since i am using processmaker, a query would look like this: $approved = @@check_student[0]; $student = @@student; if ($approved == 1) { $query = "DELETE FROM PMT_PLAN WHERE ID = $student;"; @@test = $query; executeQuery($query); } This query removes an old plan if a student is accepted and thus makes a new one I know how to create a one to many query, i just dont know how to make a delete one... A one to many query would look like this in processmaker SELECT c.ID AS k, c.NAME AS v FROM PMT_COURSE AS c, PMT_COURSEINPLAN AS p, PMT_PLAN as m WHERE c.ID = p.COURSE AND p.PLANID = m.PLANID AND m.ID = '@=student' This query shows all the courses from the (current user) students educational plan I believe processmaker uses a custom SQL called PMQL but since there is no flair for that i am going to flair this as MySQL, sorry! Thank you for your help!
  2. Hello everyone My pc has frequent BSOD's and they happen mostly when i boot up my pc and sometimes when i shut it down. It happens about every 2 days and its bothering me alot. I've got alot of BSOD's messages that are memory related like MEMORY MANAGEMENT of PAGED FAULT IN NON PAGED AREA. Because i've been told these are memory issues i've run the windows memory scanner and memtest86, they both show no issues. I've also switched my ram sticks around and it didn't fix my issue. I've done SFC scannow and some other automatic repair things but nothing works. When viewing the minidump in BlueScreenView it says its caused by driver ntoskrnl.exe and address ntoskrnl.exe+3f6c20 Here is a minidump of the most recent BSOD (onedrive): https://1drv.ms/u/s!AnCV9r6SGqrYjmA3vUuioMEXaqpt Here are some more dumps: https://1drv.ms/u/s!AnCV9r6SGqrYjl-uvK2ZNNvhpowD https://1drv.ms/u/s!AnCV9r6SGqrYjl4l19fbQlM6wXwT https://1drv.ms/u/s!AnCV9r6SGqrYjl1SNGWpoLf0GaZl Thank you!
  3. Its a nice bonus, i was already looking at the G502 doom eternal is just a bonus, i dont really care for it
  4. Hello everyone I need to choose what mousse i buy today because of a sale and i cant decide which one Im struggling to choose between the g502 hero and the g703 hero. They are both 60$ and the g502 comes with doom eternal and the g703 is just on sale. Currently i have the G403 which i love but i have issues with the scrollwheel and the sides are getting sticky and letting go. I heard some people complain about the same issues on the g703 but i dont know if these issues are still a thing. I like the weight and shape of the g403 so the g703 would be the logical choice but i dont want the same issues as the ones i have now on my g403. What do you guys think? Thanks for reading!
  5. Hello everyone I'm looking for wireless earbuds but i can't really decide if 100 euros for the Galaxy Buds Plus is worth it. I plan to use bluetooth earbuds in the gym, at school and maybe at work. Are the Galaxy Buds Plus worth the 100 euros if other wireless earbuds like the QCY T5 or the SOUNDPEATS truedots are also an option for around 20-30 dollars? (I'm also using a Samsung phone) Thank you for your time!
  6. I only have the GPU in right now and plan on buying the rest on christmas, basicly what you are saying is that the extra performance isn't worth the potential issues it could give? (correct me if im wrong )
  7. But are the driver's any good now? I've seen alot of people have issues with them.
  8. I play on 1080p 144hz (i also have a 1080p 60hz 2nd monitor) and i don't plan on streaming/recording but having the option would be nice. If i wanted the RTX 2060 Super Gaming x i would've paid €50 more which didn't seem worth it to me
  9. Hey guys Im putting together a new pc and for the GPU i decided on the RTX 2060 Super because i heard some bad stories about the RX 5700XT's drivers. Now im second guessing my decision, and i want to know what you guys think (i have bought the RTX 2060 Super but can still return it). I previously decided on the RTX 2060 Super because: - good drivers (I've had my fair share of buggy amd drivers) - cool and quiet - good performance Do you guys think i should return it for an RX 5700XT? The prices are: - MSI RTX 2060 Super Armor OC (€370) - MSI RX 5700XT Gaming X (€410) Thanks alot!
  10. I'll do that actually! Im also debating upgrading the SSD from the BX500 240GB to the MX500 500GB for a little more than double the price, what do you think about that?
  11. Ill keep that in mind, thanks for your reply!
  12. Im planning on using the BX500 as a boot drive and have a 1TB HDD for my games, would that work or is it worth it to spend more for the OS Primary drives listed here? Thanks for your help!
  13. Do you think an Kingston A2000 250GB NVMe is better for 10 bucks more?
  14. I will, i very much dont mind paying 5 bucks more for that, thanks for the save!
  15. I haven't, is the Crucial so much faster? I thought it was only like a 10MB/s diffrence
×