summary refs log tree commit diff stats
path: root/includes/session.php
Commit message (Collapse)AuthorAgeFilesLines
* Changed comments' user indexStarla Insigna2009-01-051-0/+18
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Previously, the comments table referenced users by username. However, if user ever changed their username, everything would become messed up. To fix this, the index has been changed to the user ID. This change obviously requires maintenance: This SQL must be run: "ALTER TABLE `comments` ADD `user_id` INT( 11 ) NOT NULL AFTER `page_id`;" This PHP will generate some SQL that must be run: <?php $getusers = "SELECT DISTINCT username FROM comments WHERE is_anon = 0"; $getusers2 = mysql_query($getusers); while ($getusers3 = mysql_fetch_array($getusers2)) { $getuser = "SELECT * FROM phpbb_users WHERE username = \"" . $getusers3['username'] . "\""; $getuser2 = mysql_query($getuser); $getuser3 = mysql_fetch_array($getuser2); echo("UPDATE comments SET user_id = " . $getuser3['user_id'] . " WHERE username = \"" . $getuser3['username'] . "\" AND is_anon = 0;<BR>"); } $getusers = "SELECT * FROM anon_commenters"; $getusers2 = mysql_query($getusers); while ($getusers3 = mysql_fetch_array($getusers2)) { echo("UPDATE comments SET user_id = " . $getusers3['id'] . " WHERE username = \"" . $getusers3['username'] . "\" AND is_anon = 1;<BR>"); } ?> This SQL must be run: "ALTER TABLE `comments` DROP `username`;"
* Restricted Admin panel to AdminsStarla Insigna2009-01-051-1/+1
| | | | | Previously, when phpBB3 was integrated, the user group 2 was mistaken as the Admin group when it was actually the Registered group, thus allowing anyone who could log in to access the admin panel.
* Integreated Fourm usersStarla Insigna2009-01-051-17/+53
|
* Fixed permissionsStarla Insigna2008-11-191-0/+0
|
* Imported sourcesStarla Insigna2008-11-191-0/+61