Results 1 to 11 of 11
  1. #1
    Join Date
    Feb 2004
    Posts
    6

    Unanswered: help me pleeease, im so confused

    ok i have a mysql database setup
    i also have an image gallery setup on my site where people can upload their own pics after registering

    in another section of my site i have a message forum where people can register to post messages
    now heres the problem

    what i wanna do is so that when someone signs up in the image gallery section they can use the same usernam and password to sign in to the forum and vise versa
    i have no idea how to do this, its really bugging me

    pleeeease help

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    The solution depends on the complexity of your requirement.

    If you do not require separate privelages for individual pages of the web site, then create a single users table.
    Last edited by r123456; 02-09-04 at 22:07.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Feb 2004
    Posts
    6
    how do i create a single user table?
    im so sorry but im an absoloute beginner and have noo idea what that even means

  4. #4
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Simplified,

    Create table users
    (
    username varchar2(15),
    password varchar2(15)
    );
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  5. #5
    Join Date
    Feb 2004
    Posts
    6
    where do i type that?

  6. #6
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    The MySQL Console.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  7. #7
    Join Date
    Feb 2004
    Posts
    6
    lol where is that?

    maybe i should say this

    i got the forum script from www.phpbb.com and the image script from http://www.4homepages.de

    if that helps in anyway, i just uploaded them on to my subdomains and linked them to the mysql database i created in my hosting control panel
    in the control panel theres no option for any console of any sort, all i can do is create new users and edit passwords

  8. #8
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    If you need to execute DML statements then you need access to a "console" or "interface" that can accept the statements and pass them to the DBMS.

    As an alternative consider editing the source code for both scripts, such that both access the same users table.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  9. #9
    Join Date
    Feb 2004
    Posts
    6
    i downloaded a program and am now editing the tables
    i found this

    4images_users

    inside that i found these values:

    column_____________type____________null

    user_name varchar(255) no
    user_password varchor(255) no9


    do i change these? to the stuff u wrote up there?

    thats for the image gallery
    for the chat forum it has these settings phpbb_users

    column __________type______________ null
    username varchar(25) no
    user_password varchar(32) no


    please help me
    Last edited by purepersian786; 02-09-04 at 23:00.

  10. #10
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Script A - Select * from userA
    Script B - Select * from userB

    userA
    --------
    username
    password

    userB
    ---------
    username
    password

    users_AB
    ---------
    username
    password

    A temporary solution may be,

    Drop table userA;
    Drop table userB;

    Create view userA as select * from users_AB;
    Create view userB as select * from users_AB;

    I would recommend not using the scripts, instead write your own code specifically for your requirements. Furthermore the database tables can be designed according to your specifications.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  11. #11
    Join Date
    Feb 2004
    Posts
    6
    thats greek to me
    forget it i give up

    thanks very much for all ur help anyway, i appreciate it very much

Posting Permissions

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