Project - Messenger

[xolara]

Hey all

Im currently working on a messenger some sort of msn wannabe <!-- s:lol: --><img src="{SMILIES_PATH}/icon_lol.gif" alt=":lol:" title="Laughing" /><!-- s:lol: -->

Ideas is appreciated and progress will be posted here aswell <!-- s --><img src="{SMILIES_PATH}/icon_e_smile.gif" alt="" title="Smile" /><!-- s -->

[brandonio21]

Sweet. I can't wait to see the first version in action!

[xolara]

I have aborted this project for a while and started a new one i have decided to call Tutorializer

All submitted tutorials will get a random ID number if you need any help you will need to write the ID number aswell

it will feature

Admin submitted tutorials
User submitted tutorials
Contact
Friendlist with online offline status
Private Messaging to other users
Comment on tutorials
User Chat
very basic webbrowser that will only show <!-- m --><a class="postlink" href="http://www.vb2008forum.xtreemhost.com">http://www.vb2008forum.xtreemhost.com</a><!-- m --> with back forward and Front page buttons
Version Check
Built in Updater
Agreement of use
Login system + Registration
Users will be able to delete their own tutorials but only their own
User Profile and will count how many comments you have posted and how many tutorials you have posted
Some more will be added

To the Admin part application

All above but allso
but ofc their tutorials will go in the Admin tutorial section
Delete User
Ban User (Witch will mean IP and Mac Adress, and either permanent or just a temporary ban)
Delete Tutorials (means all live tutorials)
Admin status in Chat (Kick and Ban)
Will have a special command prompt and with a complete command list
More will be added

[xolara]

All who wish to come with some ideas are welcome to aswell

[xolara]

Hello again ive forgotten how 2 make vb read from a mysql have been trying for some time now but can't really get it working if anyone know how i would really like 2 know <!-- s --><img src="{SMILIES_PATH}/icon_e_smile.gif" alt="" title="Smile" /><!-- s -->

- Xolara

[brandonio21]

Well since Xolara here said I need to post more on the forum....
Lets have a progress update! <!-- s --><img src="{SMILIES_PATH}/icon_e_biggrin.gif" alt="" title="Very Happy" /><!-- s -->

[xolara]

Yeah well im still trying to get the app to read from a database but i have made friendlist,pm,chat so far

[brandonio21]

Well heres the code to read from a database :

Code:

conn = New MySqlConnection
        conn.ConnectionString = "server=SERVER.COM;Port=3306; user id=USERID; password=PASSWORD; database=DATABASE"
        Try
            conn.Open()
            Dim sqlquery = "SELECT * From Users WHERE username='" & textbox1.text & "'"
            Dim command As New MySqlCommand
            Dim adapter As New MySqlDataAdapter
            Dim data As MySqlDataReader
command.Connection = conn
            command.CommandText = sqlquery
            adapter.SelectCommand = command
            data = command.ExecuteReader

Thats to open the connection. To check if a username exists, use this (for logging in)

Code:

If data.HasRows = 0 Then
                MsgBox("Error! - Wrong User ID or Password", MsgBoxStyle.Critical, "Error!")
                conn.Close()
            Else

                data.Close()
                conn.Close()
                command.Connection = conn
                command.CommandText = "SELECT * From Users WHERE username='" & login_username.Text & "'AND PASSWORD='" & login_password.Text & "';"
                conn.Open()
                data = command.ExecuteReader

Then to create a new account...

Code:

sqlquery = "INSERT INTO Users (Username, Password) VALUES('" & txtbox_username.Text & "','" & txtbox_password.Text &  "' )"
                command.Connection = conn
                command.CommandText = sqlquery
                registerfinal.SelectCommand = command
                data = command.ExecuteReader
                MsgBox("Account has been created! - Please try logging in with these credentials to test the account!", MsgBoxStyle.Information, "Account Created!")

Hope this helps!

[Josh]

hi everyone! I am new on here!

I just wanted to reply about the registering through mysql connection! I cant seem to make it work..