Vincewinb - I registered just to thank and compliment you for the iPost project, I will put it to good use, and also, to help those that may have been stumped with the "Where does the database information go" issue I had when setting this thing up.
For those of you less educated, here is a simple guide to help you connect your MYSQL database with iPost:I am assuming you know your database username, name, and password for the following steps:1. in
INDEX.PHP find line
52 "//Conntects", enter the required information as so for lines
53 and 54:
- Code: Select all
//Conntects
mysql_connect("localhost", "YOUR_DATABASE_USERNAME", "YOUR_DATABASE_PASSWORD") or die(mysql_error());
mysql_select_db("YOUR_DATABASE_NAME") or die(mysql_error());
Note: Vincewinb has it setup so that
YOUR_DATABASE_NAME should be "
ipost".
2. in
POST.PHP find line
54 "//check for existance". Enter the required information as so for lines
57 and 58:
- Code: Select all
//Conntects
mysql_connect("localhost", "YOUR_DATABASE_USERNAME", "YOUR_DATABASE_PASSWORD") or die(mysql_error());
mysql_select_db("YOUR_DATABASE_NAME") or die(mysql_error());
(So step two's instructions are virtually the same as step one)
For Noobs like me:Replace YOUR_DATABASE_USERNAME, YOUR_DATABASE_PASSWORD and YOUR_DATABASE_NAME with your database information, do NOT remove the "", rather place your database information within the "", so for example:
- Code: Select all
//Conntects
mysql_connect("localhost", "hello123databaseusername", "myfavoritedatabasepassword") or die(mysql_error());
mysql_select_db("myfavoritedatabasename") or die(mysql_error());
Hopefully this will help some people, and thanks again Vincewinb.
I will be building something cool with this, implementing login/register stuff, ect, when I'm done, with your permission, I will release it as a modification to iPost.
For those who want a new white bubble per post, move the </UL></IL>'s in INDEX.PHP two lines after echo ($body);. This will give a new bubble per submitted post.EDIT: For those who want the newest posts to apppear at the top, rather then the bottom, you need to make a small edit in
INDEX.PHP. You wont be able to do it by date, since the date code is very unspecific, and it would only group per 24 hours, you need to order the posts by ID.
To do so, go to line:
57 and replace the line with this new one:
$getnews = mysql_query("SELECT * FROM news
ORDER BY id DESC") or die(mysql_query());
That should fix the issue for the people posting above me.
David
- FelixApplications.com
@FelixAppsInc