Add user id in mysql

bonbon · **Joined:** Mon Oct 20, 2008 11:47 am **Posts:** 22

Hi,
I want add user id when an user register, but i have difficult to find where the register code are in source.
It's certainly in server part but i didn't find.

paxtenus · **Joined:** Tue Mar 17, 2009 3:48 pm **Posts:** 238

I believe it already assigns each user an ID.

bonbon · **Joined:** Mon Oct 20, 2008 11:47 am **Posts:** 22

paxtenus wrote:

I believe it already assigns each user an ID.

No, if you see in vbgore.sql you didn't see user id for each user so in phpmyadmin i have add an fields whose name is "user_id" but when i register with the client the user id in phpmyadmin is always 0

paxtenus · **Joined:** Tue Mar 17, 2009 3:48 pm **Posts:** 238

In FileIO.bas:

In Sub Load_User

After:

Code:

With DB_RS

Add:

Code:

UserList(UserIndex).id = Val(!id)

--

In TCP.bas:

In Sub User_ConnectNew:

After:

Code:

        TempObjs(i).Amount = Int(Rnd * 10) + 1
    Next i

Add:

Code:

DB_Conn.Execute "SELECT * FROM users ORDER BY id DESC LIMIT 1"

UserList(UserIndex).id = Val(DB_RS!id) + 1

In Declares.bas:

In Declarations:

After:

Code:

Type User 'Holds data for a user

Add:

Code:

id As Integer

That should work, though it hasn't been tested. Let me know if it doesn't. You'll have to replace all currently-existing users' IDs, though.

bonbon · **Joined:** Mon Oct 20, 2008 11:47 am **Posts:** 22

paxtenus wrote:

In FileIO.bas:

In Sub Load_User

After:

Code:

With DB_RS

Add:

Code:

UserList(UserIndex).id = Val(!id)

--

In TCP.bas:

In Sub User_ConnectNew:

After:

Code:

        TempObjs(i).Amount = Int(Rnd * 10) + 1
    Next i

Add:

Code:

DB_Conn.Execute "SELECT * FROM users ORDER BY id DESC LIMIT 1"

UserList(UserIndex).id = Val(DB_RS!id) + 1

In Declares.bas:

In Declarations:

After:

Code:

Type User 'Holds data for a user

Add:

Code:

id As Integer

That should work, though it hasn't been tested. Let me know if it doesn't. You'll have to replace all currently-existing users' IDs, though.

Hey, thank you very much it's nice of you, alternatively i had deleted register from client and i make an web register

vbGore Free Online RPG Engine

Add user id in mysql