Results 1 to 9 of 9
Thread: MySQL
Hybrid View
-
30th December 2018 20:02 #1
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();
-
30th December 2018 22:08 #2Registered User
Join Date: Nov:2018
Location:
Posts: 106
?
-
30th December 2018 22:20 #3
, ingame ,

. .. Union-a
SELECT . Union ?
Last edited by Djaniko0o; 31st December 2018 at 01:02.
-
31st December 2018 06:58 #4Product of Science
Join Date: Aug:2016
Location:
Posts: 294
-
31st December 2018 08:29 #5
, Union-a,
- . :
3 . UF1, XFG XRG, XRG XFG, XRG . ..
-
31st December 2018 09:24 #6
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 .




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in