really a mysql question

  • hello! when I set things up I took the default on ‘allowedusers’ being able to upload files. now I want to change that. I want to set the minimum level to a higher value.
    I think it best to alter the mysql table directly. unfortunately I can’t use phpmyadmin or such, I must do it by hand. I am not sure how to compose the sql command.
    the following snippet from upgrade-functions.php illuminates the table structure – I want to alter the ‘option_value’ field which in my case is now empty:
    “37” => “INSERT INTO $tableoptions (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES (37,’fileupload_allowedusers’, 3
    , ”, ‘…or you may authorize only some users. enter their logins here, separated by spaces. if you leave this variable blank, all users who have the minimum level are authorized to upload. examp
    le: \’barbara anne george\”, 8, 30)”,
    help with the incantation? thanks.
    Felmon

Viewing 2 replies - 1 through 2 (of 2 total)

  • I suggest downloading sqlyog, https://www.sqlyog.com and using it to manipulate the mysql databases, if it is on your machine.
    i would not use raw sql yourself unless you have a way to test and undo and are familiar with it.
    i have used sqlyog for a couple of years and it works great.

    Thread Starter felmon

    (@felmon)

    hello again!
    the mysql databases are not on my machine – that’s the problem. I’d have fixed this all up and been on to some other problem if I had control!
    I have fooled with the raw stuff before but obviously I don’t know it. however, this alteration – changing the one value – should be a piece o’ cake for someone who’s versed.
    I will look into sqlyog though for my home-system databases, thanks!
    Felmon

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘really a mysql question’ is closed to new replies.