[Beta]Shoutbox

Hello MPGH.

~ Information ~

I created a system within VB.Net and PHP to easily manage a customizeable shoutbox.

Important: THIS SYSTEM DOES WORK WITH DATABASES THAT DO NOT ALLOW EXTERNAL ACCESS!!!

You can therefore use any free database in the ********* rather than paying for one that allows external access.
The whole system works locally, so it does not require any external access.

It is very easy to setup and use.

~ Files ~

• SBox.dll(library to easily access everything)
• admin.php
• box.php
• conn.php
• exists.php
• insert.php
• install.php
• pagecount.php
• Full dll project
• Example project for usage

Note: Rename the admin.php!



~ Setup ~

1. Upload all .php files to your website using any ftp client(f.e. Filezilla) or your CPanel.

2. Browse the install.php in your webbrowser www.websitelink.com/install.php

Set your information like this:



If you are done, simply hit "Save"(obvious). If no error appears, everything is fine

The whole database stuff is already done, awesome eh?

~ Library Usage ~

1. Add the library as reference



2. Code sample

[php]Public Class frmMain

Private ShoutBox As New Sbox("http://localhost/shoutbox")

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'0 = Username, 1 = Post, 2 = Email, 3 = Date, 4 = Time
For Each s As String In ShoutBox.GetAllEntrys("|")
Dim x() As String = Split(s, "|")

Dim full As String = x(0) + " posted(" + x(3) + "," + x(2) + "): " + x(1)
lvMain.Items.Add(full)
Next
End Sub

Private Sub cmdSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSubmit.Click
ShoutBox.AddPost(txtUsername.Text, txtPost.Text, txtEmail.Text)
End Sub
End Class[/php]

~ Function Overview ~



~ Database Overview ~

shoutbox - This table contains all entrys

• ID[INT(11)] - Auto Increment - Primary Key
• Username[VARCHAR(30)]
• Post[VARCHAR(255)]
• PostMD5[VARCHAR(50)]
• Email[VARCHAR(30)]
• IP[VARCHAR(20)]
• HWID[VARCHAR(50)]
• Date[VARCHAR(12)]
• Time[VARCHAR(6)]

~ Requirements ~

• .Net Framework 2.0
• A MySQL database
• A Brain

~ License ~

You may merge it into your program but only with credits.

If you have any further ideas on what can be added into this system, please let me know.

All rights reserved to me.

~ Virusscans ~
VirusTotal
Jotti


Enjoy this