Introducing MPGH's AIGA. The latest advancement in artificial intelligence. Click here now to learn more!

Thread: Databases

Page 1 of 2 12 LastLast
Results 1 to 15 of 27
  1. #1
    DawgiiStylz's Avatar
    Join Date
    Aug 2009
    Gender
    male
    Location
    Dawg House
    Posts
    7,811
    Reputation
    219
    Thanks
    2,896
    My Mood
    Tired

    Databases

    I'm not very good with databases and don't really know much about the language.. I forget what it was called, but can anyone guide me through to
    loading a single columned into a list and
    submitting a 9 character length string into it?

    I already figured out that I needed mysql connector and I have it installed and imported to my project already. Other than that, I'm lost

  2. #2
    Vormz's Avatar
    Join Date
    Feb 2012
    Gender
    male
    Posts
    25
    Reputation
    10
    Thanks
    344
    My Mood
    Aggressive
    I hardly suggest you to use php / mysql otherwise you will just get hacked. I will send you some functions tomorrow.. Going to sleep 4:42 am atm o.o

  3. The Following User Says Thank You to Vormz For This Useful Post:

    DawgiiStylz (04-04-2013)

  4. #3
    DawgiiStylz's Avatar
    Join Date
    Aug 2009
    Gender
    male
    Location
    Dawg House
    Posts
    7,811
    Reputation
    219
    Thanks
    2,896
    My Mood
    Tired
    Quote Originally Posted by Vormz View Post
    I hardly suggest you to use php / mysql otherwise you will just get hacked. I will send you some functions tomorrow.. Going to sleep 4:42 am atm o.o
    Thank you.

    Also, it don't have to be protected.

  5. #4
    Vormz's Avatar
    Join Date
    Feb 2012
    Gender
    male
    Posts
    25
    Reputation
    10
    Thanks
    344
    My Mood
    Aggressive
    Quote Originally Posted by DawgiiStylz View Post

    Thank you.

    Also, it don't have to be protected.
    Well you have always to be protected, otherwise there is no sense with completing a project which was made for making the life easier.
    Believe me, it makes you feel shit when you get hacked..

    Sent you something via pm. Goodluck!

  6. The Following User Says Thank You to Vormz For This Useful Post:

    DawgiiStylz (04-05-2013)

  7. #5
    rileyjstrickland's Avatar
    Join Date
    Jun 2012
    Gender
    male
    Location
    Florida
    Posts
    649
    Reputation
    90
    Thanks
    4,008
    My Mood
    Relaxed
    If it's MySQL then inserting is something like
    INSERT INTO `Database`.`Table` (`Column `) VALUES ('Value');

    If You Like My Releases, Hit The Thanks button!
    Follow the rules.

    Successful Purchases: 2
    @The403
    @sundy42
    Successful Sales: 1
    @wZ. Gali
    Scammed: 1

    Favorite Quotes:
    Quote Originally Posted by Doc View Post
    Who cares about simplified mandarin. The only problem here is that Cantonese (and Hokkien) is no longer being taught, but guess what, times change. There have been thousands of languages that have been lost to the ages, you'd be pissing in the wind to try and stop that.

  8. #6
    DawgiiStylz's Avatar
    Join Date
    Aug 2009
    Gender
    male
    Location
    Dawg House
    Posts
    7,811
    Reputation
    219
    Thanks
    2,896
    My Mood
    Tired
    Quote Originally Posted by rileyjstrickland View Post
    If it's MySQL then inserting is something like
    INSERT INTO `Database`.`Table` (`Column `) VALUES ('Value');
    Could you tell me what each word means, please?
    Thats the only thing I don't get is that language.

  9. #7
    Blubb1337's Avatar
    Join Date
    Sep 2009
    Gender
    male
    Location
    Germany
    Posts
    5,915
    Reputation
    161
    Thanks
    3,108
    Quote Originally Posted by DawgiiStylz View Post

    Could you tell me what each word means, please?
    Thats the only thing I don't get is that language.
    MySQL has a pretty advanced documentation.

    MySQL :: MySQL 5.1 Reference Manual :: 13.2.5 INSERT Syntax

    You need to learn SQL.
    SQL Tutorial (or any other site)



  10. The Following User Says Thank You to Blubb1337 For This Useful Post:

    DawgiiStylz (04-07-2013)

  11. #8
    DawgiiStylz's Avatar
    Join Date
    Aug 2009
    Gender
    male
    Location
    Dawg House
    Posts
    7,811
    Reputation
    219
    Thanks
    2,896
    My Mood
    Tired
    I appreciate the help from everyone

  12. #9
    LilGho$t's Avatar
    Join Date
    Nov 2011
    Gender
    male
    Posts
    419
    Reputation
    9
    Thanks
    330
    My Mood
    Twisted
    First of all, like a previous comment was intending to say, you should always use php + mysql and simply have the vb.net script act as shell. The vb.net simply should post the needed data at the server to prevent potential server comprising.

    Second, to recall information you can say:
    "SELECT * FROM `DatabaseName`.`TableName`"
    or, let's say you only want to select things from the last 2 weeks (this will be written in php):
    "SELECT * FROM `DatabaseName`.`TableName` WHERE `TableName`.`TimeSubmitted` > '" . (time() - (24 * 60 *60 *14)) . "'"

    And now, for the kicks and giggles, let's say we want to get information from the last 2 weeks and want it sorted by most recent:
    "SELECT * FROM `DatabaseName`.`TableName` WHERE `TableName`.`TimeSubmitted` > '" . (time() - (24 * 60 *60 *14)) . "' ORDER BY `TableName`.`TimeSubmitted` DESC"

    Again, these examples are php based as, in my opinion, php is a much better option for sql interaction.

  13. The Following User Says Thank You to LilGho$t For This Useful Post:

    DawgiiStylz (04-11-2013)

  14. #10
    DawgiiStylz's Avatar
    Join Date
    Aug 2009
    Gender
    male
    Location
    Dawg House
    Posts
    7,811
    Reputation
    219
    Thanks
    2,896
    My Mood
    Tired
    Quote Originally Posted by LilGho$t View Post
    First of all, like a previous comment was intending to say, you should always use php + mysql and simply have the vb.net script act as shell. The vb.net simply should post the needed data at the server to prevent potential server comprising.

    Second, to recall information you can say:
    "SELECT * FROM `DatabaseName`.`TableName`"
    or, let's say you only want to select things from the last 2 weeks (this will be written in php):
    "SELECT * FROM `DatabaseName`.`TableName` WHERE `TableName`.`TimeSubmitted` > '" . (time() - (24 * 60 *60 *14)) . "'"

    And now, for the kicks and giggles, let's say we want to get information from the last 2 weeks and want it sorted by most recent:
    "SELECT * FROM `DatabaseName`.`TableName` WHERE `TableName`.`TimeSubmitted` > '" . (time() - (24 * 60 *60 *14)) . "' ORDER BY `TableName`.`TimeSubmitted` DESC"

    Again, these examples are php based as, in my opinion, php is a much better option for sql interaction.
    How could I get the data and add it to a list?

    This what I have so far
    Code:
    Try            conn.Open()
    
    
                Dim sqlString As String = "SELECT Code FROM MonsterWarlord ORDER BY Index"
                Dim reader As MySqlDataReader
                Dim adapter As New MySqlDataAdapter
                Dim command As New MySqlCommand
                With command
                    .CommandText = sqlString
                    .CommandType = CommandType.Text
                    .Connection = conn
                End With
                adapter.SelectCommand = command
                reader = command.ExecuteReader
                While reader.Read()
                    codeList.Add(reader.GetString(1))
                End While
    
    
            Catch ex As Exception
    
    
            End Try
    Last edited by DawgiiStylz; 04-08-2013 at 08:36 PM.

  15. #11
    rileyjstrickland's Avatar
    Join Date
    Jun 2012
    Gender
    male
    Location
    Florida
    Posts
    649
    Reputation
    90
    Thanks
    4,008
    My Mood
    Relaxed
    Quote Originally Posted by DawgiiStylz View Post

    How could I get the data and add it to a list?

    This what I have so far
    Code:
    Try            conn.Open()
    
    
                Dim sqlString As String = "SELECT Code FROM MonsterWarlord ORDER BY Index"
                Dim reader As MySqlDataReader
                Dim adapter As New MySqlDataAdapter
                Dim command As New MySqlCommand
                With command
                    .CommandText = sqlString
                    .CommandType = CommandType.Text
                    .Connection = conn
                End With
                adapter.SelectCommand = command
                reader = command.ExecuteReader
                While reader.Read()
                    codeList.Add(reader.GetString(1))
                End While
    
    
            Catch ex As Exception
    
    
            End Try
    Mind giving some example results that the query should be returning?

    If You Like My Releases, Hit The Thanks button!
    Follow the rules.

    Successful Purchases: 2
    @The403
    @sundy42
    Successful Sales: 1
    @wZ. Gali
    Scammed: 1

    Favorite Quotes:
    Quote Originally Posted by Doc View Post
    Who cares about simplified mandarin. The only problem here is that Cantonese (and Hokkien) is no longer being taught, but guess what, times change. There have been thousands of languages that have been lost to the ages, you'd be pissing in the wind to try and stop that.

  16. #12
    DawgiiStylz's Avatar
    Join Date
    Aug 2009
    Gender
    male
    Location
    Dawg House
    Posts
    7,811
    Reputation
    219
    Thanks
    2,896
    My Mood
    Tired
    I figured it all out. Thank you.

  17. #13
    King Aldrin's Avatar
    Join Date
    May 2012
    Gender
    male
    Posts
    76
    Reputation
    10
    Thanks
    134
    My Mood
    Amazed
    Quote Originally Posted by Vormz View Post
    I hardly suggest you to use php / mysql otherwise you will just get hacked. I will send you some functions tomorrow.. Going to sleep 4:42 am atm o.o
    Could you Give it to me too? I hardly need it !
    Imports MPGH.NET
    Public Class King_Aldrin

    Private Sub King_Aldrin_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    Dim thanks = mpgh.user.kingaldrin
    Dim help As Boolean
    If mpgh.user.other = Ask.question Then
    help = True
    Else
    help = False
    End If

    If help = True Then
    If mpgh.user.kingaldrin.answers > 0 Then
    MsgBox("Did I helped you? then press the Thanks button!", MsgBoxStyle.Information)
    Else
    MsgBox("I'm sorry! I think I can't answer your question")
    End If

    Else
    MsgBox("You didn't ask a question, Please ask a new question now by posting a new thread or PM'ing me!")
    End If
    End Sub
    End Class

  18. #14
    LilGho$t's Avatar
    Join Date
    Nov 2011
    Gender
    male
    Posts
    419
    Reputation
    9
    Thanks
    330
    My Mood
    Twisted
    Quote Originally Posted by DawgiiStylz View Post

    How could I get the data and add it to a list?

    This what I have so far
    Code:
    Try            conn.Open()
    
    
                Dim sqlString As String = "SELECT Code FROM MonsterWarlord ORDER BY Index"
                Dim reader As MySqlDataReader
                Dim adapter As New MySqlDataAdapter
                Dim command As New MySqlCommand
                With command
                    .CommandText = sqlString
                    .CommandType = CommandType.Text
                    .Connection = conn
                End With
                adapter.SelectCommand = command
                reader = command.ExecuteReader
                While reader.Read()
                    codeList.Add(reader.GetString(1))
                End While
    
    
            Catch ex As Exception
    
    
            End Try
    If you're getting the data in vb.net, i don't know. If you get it in php you can output it via the echo command inside of a while loop for the query and then put a delimiter between each one.

    Just saw you figured it out which makes my post kind of useless, but oh well. Again, i still very strongly recommend using php + vb.net.

  19. The Following User Says Thank You to LilGho$t For This Useful Post:

    DawgiiStylz (04-11-2013)

  20. #15
    DawgiiStylz's Avatar
    Join Date
    Aug 2009
    Gender
    male
    Location
    Dawg House
    Posts
    7,811
    Reputation
    219
    Thanks
    2,896
    My Mood
    Tired
    Ok, I'm curious about the security risks that everyone was talking about. How would you go about this while being 'secured'.

    Which I'm thinking.. people can check where the program is communicating with.. such as websites and ect.. or via the code where you can look at strings on databases information that no one should have..

    I read here that sql and php isn't secured.. what is a better alternative?

Page 1 of 2 12 LastLast

Similar Threads

  1. DataBase errors
    By skull100 in forum Combat Arms Hacks & Cheats
    Replies: 15
    Last Post: 08-24-2008, 10:25 PM
  2. database error
    By scimmyboy in forum General
    Replies: 7
    Last Post: 08-19-2008, 10:09 PM
  3. [REL] Cooly WarRock Hacks Database
    By HeXel in forum WarRock - International Hacks
    Replies: 23
    Last Post: 02-14-2008, 12:19 PM
  4. [request]how to make a database log in
    By brownsfan91 in forum Visual Basic Programming
    Replies: 2
    Last Post: 01-10-2008, 07:53 AM
  5. How to hack Knight online Database?
    By AN1MAL in forum General Game Hacking
    Replies: 7
    Last Post: 03-28-2007, 01:57 PM