+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
Windows Thread, Quite a big moodle problem in Technical; ah in that case you want to look at the roles table. Code: SELECT * FROM 'mdl_role_assignments' WHERE 'userid' = ...
  1. #16

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Quite a big moodle problem

    ah in that case you want to look at the roles table.

    Code:
    SELECT * FROM 'mdl_role_assignments' WHERE 'userid' = 145;

  2. #17
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,986
    Thank Post
    287
    Thanked 269 Times in 193 Posts
    Rep Power
    115

    Re: Quite a big moodle problem

    how do you edit the tables through mysql?

  3. #18

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Quite a big moodle problem

    Use the 'UPDATE' keyword to change rows. Use the 'INSERT' keyword to create new ones. Use 'DELETE' to remove them.

  4. #19
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    2,986
    Thank Post
    287
    Thanked 269 Times in 193 Posts
    Rep Power
    115

    Re: Quite a big moodle problem

    Cheers
    Ill give it ago
    Just want to say thanks to everyone that has helped me out on this topic

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. dunno if this is an exchange or moodle problem
    By timbo343 in forum Windows
    Replies: 1
    Last Post: 23rd January 2007, 02:56 PM
  2. Moodle - Problem
    By wesleyw in forum Virtual Learning Platforms
    Replies: 8
    Last Post: 9th November 2006, 09:07 AM
  3. Moodle Problem.
    By Quackers in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 18th September 2006, 03:42 PM
  4. Moodle Problem
    By jamieallonby in forum Virtual Learning Platforms
    Replies: 2
    Last Post: 16th May 2006, 06:54 AM
  5. Moodle or not to Moodle
    By alan-d in forum Web Development
    Replies: 5
    Last Post: 20th January 2006, 11:56 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •