Results 1 to 9 of 9

Thread: MySQL

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User Djaniko0o's Avatar
    Join Date: Jan:2016
    Location: West Coast - Varna
    Posts: 86

    MySQL

    ! InSim, . InSim . InSim , , .

    . SQL Database :
    SQL : Cars 2 , :
    CarID|Player|Car|
    1 |Ivan |BMW|
    2 |Ivan |Audi|
    . , .. , ..

    : Car:BMW Car Owner: Ivan, ...

    :

    HTML Code:
    MySqlConnection mysqlvruzka = new MySqlConnection("Server=localhost;Database=IGRI;Uid=root;Pwd='nqmaparola678900';");
                                                mysqlbaglan.Open();
                                                MySqlCommand mda = new MySqlCommand("SELECT * FROM cars WHERE Car_Owner='" + Conn.Username + "' UNION SELECT * FROM cars WHERE Car_Owner='" + Conn.Username + "'", mysqlvruzka);
                                                MySqlDataReader mdr = mda.ExecuteReader();
                                                    while (mdr.Read())
                                                    {
                                                        Conn.CarOwner = mdr[1].ToString();
                                                        Conn.CarType = mdr[2].ToString();
                                                       
                                                        byte LocationX = 70;
                                                        byte ButtonID1 = 120;
                                                    insim.Send("Car:" + Conn.CarType + "Car Owner:" + Conn.CarOwner, H = 6, W = 85, T = LocationX, L = 46, ClickID = ButtonID1,);
                                                       LocationX += 4;
                                                        ButtonID1++;
                                                    }
     mysqlvruzka.Close();

  2. #2
    Registered User
    Join Date: Nov:2018
    Location:
    Posts: 106
    ?

  3. #3
    Registered User Djaniko0o's Avatar
    Join Date: Jan:2016
    Location: West Coast - Varna
    Posts: 86
    , ingame ,

    . .. Union-a SELECT . Union ?
    Last edited by Djaniko0o; 31st December 2018 at 01:02.

  4. #4
    Product of Science
    Join Date: Aug:2016
    Location:
    Posts: 294
    Quote Originally Posted by Djaniko0o View Post
    , ingame ,

    . .. Union-a SELECT . Union ?
    UNION .
    SELECT , 2, 2 .
    SELECT, ( 1 ), SELECT:
    Code:
    "SELECT * FROM cars WHERE Car_Owner='" + Conn.Username + "'";
    , .
    Last edited by c3p0; 31st December 2018 at 07:08.

  5. #5
    Registered User Djaniko0o's Avatar
    Join Date: Jan:2016
    Location: West Coast - Varna
    Posts: 86
    , Union-a, - . :
    3 . UF1, XFG XRG, XRG XFG, XRG . ..

  6. #6
    Registered User syman's Avatar
    Join Date: Aug:2016
    Location: Sofia
    Posts: 1,232
    2 .

    SELECT * FROM cars WHERE Car_Owner='" + Conn.Username + "' UNION SELECT * FROM cars WHERE Car_Owner='" + Conn.Username + "'"
    3 6 car_owner = Djaniko0o


    Conn.CarOwner = mdr[1].ToString();
    Conn.CarType = mdr[2].ToString();

    2 . array .

Posting Permissions

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

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |