Custom PHP forums

[turb_]

[QUOTE=Tuntis;23062913]Or just use [url=http://php.net/manual/en/book.pdo.php]a modern database access layer[/url] that supports parametrized queries.[/QUOTE]

this.

[Omar Rodriguez]

[QUOTE=Tuntis;23062913]Or just use [url=http://php.net/manual/en/book.pdo.php]a modern database access layer[/url] that supports parametrized queries.[/QUOTE]

You can use mysqli as well. I do, because I've had some problems with PDO (it's good though).

[Crhem van der B]

Alright, I'm working on changing MySQL to MySQLi with prepared statements at the moment, forums are down until I'm done.

Already got my first prepared statement running, now to change the whole forum!
Yay!

[andersonmat]

You wouldn't have to change the whole forum if you wrote a class that used prepared statements. tbh

[Crhem van der B]

I'll look into that too then, thanks for the advice.

[Crhem van der B]

Well here's a little changelog:
*All queries are now prepared statements (and mysqli)
*Change the register page so now you can add contact information such as Steam, Xfire, Skype, Website etc.
*Remaking the user profile page so everyone could actually your Steam , Xfire etc.
*Changed design. It kinda looks the same, just now uses the whole screen. Also, light colours in some parts, looks better in general in my opinion.
*Updated Admin CP so an admin could add new forums.
*Search for users in Admin CP, and get their UserID, UserName, Rank, Email, Join date and BanStatus.
*Ability to ban/unban users through Admin CP
*Can search for one user by entering his username or just type * to view all registered users (yet to add pagination there though).

I guess that's it for now.
Still need to work on other stuff such as deleting forums, deleting threads, editing threads and a ton of other stuff that I can't think of right now.

EDIT:

Was hoping for auto-merge, didn't work for some reason :D

Another update:

*Changing table structure a bit in order to make pages load faster. (By making less queries per page)

[Marlamin]

Pretty cool to see something like this get better over time. Good job!

[AndrewPH]

This makes me want to pick up Blorg again and get to work on it :v:

It broke at a very early time in development, right after I finished styling the main page. I fucked up the login script and haven't been assed to fix it.

Ah well, best of luck to you :v:

[Crhem van der B]

Thanks to both of you..
And if I'm already posting, little changelog:

*Added indexes inside my database, which results in faster queries.
*Optimised other queries.
*Removed some unneeded queries and merged them to make them subqueries.
*Changed the login/login mechanism:
---*When you login in, you'll always be redirected to the same page you were before.
---*When you logout, you'll always be redirected to the same page you were before.
*Ability to delete threads. While it says delete, it actually makes them invisible and inaccessible in any way beside through phpMyAdmin. I'll might leave this as is, or let Admins (highest rank) to view deleted threads when wanted.
*Added subforums:
---*Admins are able to add subforums through the admin control.this needs some polishing though.
*Added "time ago" for last post when viewing the index.
*Added statistics at the bottom of the page:
---*Active users (counts both members and guests)
---*Active members
---*Total numbers of threads, posts and members.

Also, there is this little bug at the moment, the the last posted indicated actually no longer exists.

[nivek]

Nice