MySQl schema

NohimX
Topic Author
Offline
Fresh Boarder

10 Apr 2020 09:19 - 10 Apr 2020 09:27 #45919 by NohimX

NohimX created the topic: MySQl schema

Cannot meet my friends now as Corona, and I have compiled official server from stable. But mysql schema is missing. Can i find it somewhere? I have created tables with fields, but it difficult to realize data type for each field. I want to connect to my server not as guest...

Please Log in or Create an account to join the conversation.

sp0ck
Offline
Administrator

10 Apr 2020 13:39 - 10 Apr 2020 13:42 #45920 by sp0ck

sp0ck replied.

There is no real need for DB schema except you want to use a password.

You can "login" with every nickname without password.

Ain't that ok for you?

Please take a look here: https://github.com/pokerth/pokerth/issues/386

Please Log in or Create an account to join the conversation.

Tyrant917
Offline
Fresh Boarder

10 Apr 2020 18:48 #45923 by Tyrant917

Tyrant917 replied.

Hi sp0ck, can you please elaborate on 'You can "login" with every nickname without password.'? I've built pokerth_server. It seems to work fine. I'm also having difficulty because of a lack of DB schema. If I log in as guest, the server auto assigns a username like "Guest###". And without the DB, I can't seem to specify my own username. It'd be confusing to have all my friends show up as "Guest" at the table. So how can I make it so all players have their own assigned names without using MySQL?

Please Log in or Create an account to join the conversation.

Tyrant917
Offline
Fresh Boarder

10 Apr 2020 18:56 #45924 by Tyrant917

Tyrant917 replied.

One more thing I want to add. The reason I'm trying to set up pokerth_server is because I also want to setup Live against it. When we play, we all join a teleconferencing app. And I want my non poker playing friends to be able to join the teleconference, chat, and have the option to watch the game as we play.

Please Log in or Create an account to join the conversation.

sp0ck
Offline
Administrator

10 Apr 2020 20:25 - 10 Apr 2020 21:14 #45925 by sp0ck

sp0ck replied.

Hi,

I reproduced it the following way:

qmake CONFIG+="c++11" -spec linux-g++ pokerth.pro

This will build the server without database.

Then do the manual server configuration and set nickname here:

https://drive.google.com/file/d/143h_Nk3wSM4YTdDEhSC_cLoimNW3BpFx/view

I hope it helps.

Regards.

Please Log in or Create an account to join the conversation.

sp0ck
Offline
Administrator

10 Apr 2020 20:34 #45926 by sp0ck

sp0ck replied.

Tyrant917 wrote: One more thing I want to add. The reason I'm trying to set up pokerth_server is because I also want to setup Live against it. When we play, we all join a teleconferencing app. And I want my non poker playing friends to be able to join the teleconference, chat, and have the option to watch the game as we play.

I don't see a problem with it. If you need help building the spectator tool - let me know.

Please Log in or Create an account to join the conversation.

Champions of

PokerTH - live

The PokerTH spectator tool.

>> Check in! <<

MySQl schema

Champions of

PokerTH - live

Member Login