+- BP Forums (https://bpforums.info)
+-- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=55)
+--- Forum: Archived Forums (https://bpforums.info/forumdisplay.php?fid=56)
+---- Forum: VB.NET (Visual Basic 2010/2008) (https://bpforums.info/forumdisplay.php?fid=8)
+---- Thread: Project - Messenger (/showthread.php?tid=269)
Project - Messenger - xolara - 11-25-2010
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 -->
Re: Project - Messenger - brandonio21 - 11-25-2010
Sweet. I can't wait to see the first version in action!
Re: Project - Messenger - xolara - 11-29-2010
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
Re: Project - Messenger - xolara - 11-29-2010
All who wish to come with some ideas are welcome to aswell
Re: Project - Messenger - xolara - 12-02-2010
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
Re: Project - Messenger - brandonio21 - 12-18-2010
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 -->
Re: Project - Messenger - xolara - 12-18-2010
Yeah well im still trying to get the app to read from a database but i have made friendlist,pm,chat so far
Re: Project - Messenger - brandonio21 - 12-18-2010
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.ExecuteReaderThats 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.ExecuteReaderThen 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!
Re: Project - Messenger - Josh - 12-01-2013
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..