Vizualizare inventar jucator [MYSQL]
-
CjMt2
-
- Mesaje: 291
- Membru din: 20 Sep 2014, 07:01
- Server: CjMt2
- Regat: Shinsoo
- Aprecieri: 18
- Mulţumiri: 22
- Discord: Copiază ID
- Contact:
Medalii
Eu as zice:
Cod: Selectaţi tot
SELECT player.id, item.pos, item.window, player.`name`, item.vnum, item_proto.locale_name FROM player.player INNER JOIN player.item ON item.owner_id = player.id INNER JOIN player.item_proto ON item.vnum = item_proto.vnum WHERE player.`name` = "TeVreau" ORDER BY item.pos;Sau asa, ca sa selecteze automat baza de date playerCjMt2 scrie:Eu as zice:Cod: Selectaţi tot
SELECT player.id, item.pos, item.window, player.`name`, item.vnum, item_proto.locale_name FROM player.player INNER JOIN player.item ON item.owner_id = player.id INNER JOIN player.item_proto ON item.vnum = item_proto.vnum WHERE player.`name` = "TeVreau" ORDER BY item.pos;
Arata ce are jucatorul respectiv in depozit dar si in inventar ?
Daca da , merci fain !
Daca da , merci fain !
-
FRANCIS
-
- Mesaje: 7879
- Membru din: 06 Noi 2015, 19:52
- Regat: Chunjo
- Aprecieri: 334
- Mulţumiri: 54529
- Discord: Copiază ID
Medalii
Arhivat !
If you talk to a man in a language he understands, that goes to his head. If you talk to him in his own language, that goes to his heart.
ENJOY
Afișează semnătura
de 
de 
de