Fetch offline and online players
#9

Quote:
Originally Posted by Kwarde
View Post
With MySQL you could do it like this. Le's assume we have three tables:
Code:
Table `fations`:
[ID] [Name]     [Owner]
1    MyFaction  Kwarde
1    MyFaction2 Kwarde

Table `faction_members`:
[ID] [Faction_ID] [Member]
1     1              1
2     1              5
3     1              3            
4     2              1

Table `users`:
[ID] [Name]
1    Kwarde
2    Merel
3    Petah
4    x_fjskd29
5    John_Doe
If you don't mind me asking, why would he have 3 tables (factions, member/faction association, members) instead of just 2 tables (factions, members including faction Id)?
Reply


Messages In This Thread
Fetch offline and online players - by ImTobi - 29.11.2019, 09:58
Re: Fetch offline and online players - by Mugala - 29.11.2019, 11:00
Re: Fetch offline and online players - by ImTobi - 29.11.2019, 11:03
Re: Fetch offline and online players - by ImTobi - 03.12.2019, 12:27
Re: Fetch offline and online players - by Mugala - 03.12.2019, 13:07
Re: Fetch offline and online players - by Kwarde - 03.12.2019, 13:11
Re: Fetch offline and online players - by Symon - 03.12.2019, 13:30
Re: Fetch offline and online players - by Calisthenics - 03.12.2019, 14:08
Re: Fetch offline and online players - by Joe Staff - 03.12.2019, 15:03
Re: Fetch offline and online players - by Kwarde - 03.12.2019, 16:35

Forum Jump:


Users browsing this thread: 1 Guest(s)