Search found 969 matches

by AcousticJames
Fri Oct 27, 2006 4:38 am
Forum: 2.0.x Support Forum
Topic: Need help - wanting to check for SID[SOLVED]
Replies: 9
Views: 616

This KB article should tell you how to keep sessions running across your website. It's not all that hard to do, really. Just include the appropriate phpBB code at the beginning of each page and make sure to use append_sid() on all links.
by AcousticJames
Thu Oct 26, 2006 11:46 am
Forum: 2.0.x Support Forum
Topic: how-to select * from user group?
Replies: 3
Views: 203

Quite welcome. To flesh out the query I posted above, you could do something like this: $sql = "SELECT u.username FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug WHERE u.user_id = ug.user_id AND ug.group_id = $group_id"; if (!($result = $db->sql_query($sql))) { message_die(GENERAL_ERROR, 'So...
by AcousticJames
Thu Oct 26, 2006 11:43 am
Forum: 2.0.x Support Forum
Topic: One database for multiple forums without using phpMyAdmin
Replies: 6
Views: 490

First off, yes, you will want to remove the phpbb_ from the table names in the database.

Secondly, if you want to run separate forums, they need to be installed in different directories.
by AcousticJames
Thu Oct 26, 2006 11:41 am
Forum: 2.0.x Support Forum
Topic: WTF... SITE HAS BEEN TOOK DOWN BY SOME IDIOT
Replies: 6
Views: 305

Chances are your site was removed by your host, since you mentioned something about "terms of service". In which case it has nothing to do with phpBB and you should be contacting your host.
by AcousticJames
Thu Oct 26, 2006 8:26 am
Forum: 2.0.x Support Forum
Topic: how-to select * from user group?
Replies: 3
Views: 203

phpBB style:

Code: Select all

$sql = "SELECT u.username FROM " . USERS_TABLE . " u, " . USER_GROUP_TABLE . " ug WHERE u.user_id = ug.user_id AND ug.group_id = $group_id";
Assuming that the group_id you want to search for is assigned to a variable named $group_id.
by AcousticJames
Thu Oct 26, 2006 8:19 am
Forum: 2.0.x Support Forum
Topic: One database for multiple forums without using phpMyAdmin
Replies: 6
Views: 490

phpMyAdmin is simply a web-based interface to your MySQL database. Hence, any type of interface to your database where you can modify the names of the tables is required. phpMyAdmin was suggested because it is the most widely used database interface out there. Most hosting companies offer phpMyAdmin...
by AcousticJames
Wed Oct 25, 2006 9:20 am
Forum: 2.0.x Support Forum
Topic: Multiple accounts sharing same username
Replies: 5
Views: 251

Now that is strange. I'm fairly certain that phpBB checks to see if the username chosen already exists in the database, and throws an error if it is. I apologize, I have no clue.
by AcousticJames
Wed Oct 25, 2006 9:18 am
Forum: 2.0.x Support Forum
Topic: Aishah's Questions
Replies: 121
Views: 7022

the only reason i wanted it is because i wanted a login box on the home page and a member sed that u needed to make the site a portal. is this true? Not necessarily. Have a look at this KB article about integrating login (and other phpBB functionality) across your website. Should be enough to get y...
by AcousticJames
Wed Oct 25, 2006 8:15 am
Forum: [2.0.x] MOD Writers Discussion
Topic: Why aren't db_update files required of mods?
Replies: 6
Views: 900

Most MODs that I have run across have directions in the MOD files where SQL queries are concerned that remind the user to replace the table prefix when necessary. Any PHP code that deals with tables (such as defining new table names in constants.php) should be utilizing the $table_prefix variable.
by AcousticJames
Wed Oct 25, 2006 8:12 am
Forum: 2.0.x Support Forum
Topic: I'm getting the critical error cannot connect to database?
Replies: 5
Views: 322

As was stated, the information in config.php is most likely incorrect. Be sure that the hostname ($dbhost) variable is correct ("localhost" in most cases), the database name ($dbname) variable is set correctly, and the username and password for the database ($dbuser and $dbpass respectively) are cor...
by AcousticJames
Wed Oct 25, 2006 8:09 am
Forum: 2.0.x Support Forum
Topic: Page not found error when viewing post
Replies: 5
Views: 263

Sounds like a permissions issue. Make sure that the permissions on the folder containing your forum files is set to 775, and that all files (and directories) within are set to 775 EXCEPT the config.php file, which should be set to 644. If your site is running on a Windows server, the above doesn't p...
by AcousticJames
Wed Oct 25, 2006 8:05 am
Forum: 2.0.x Support Forum
Topic: Align text problem
Replies: 10
Views: 467

The best thing for you to do is to fill out and post the Support Request Template (link in my signature). This will tell us the version of phpBB you are using, as well as the MODs and styles installed, and will give us a better understanding of your environment. Also, posting a link to your forum fo...
by AcousticJames
Wed Oct 25, 2006 8:03 am
Forum: 2.0.x Support Forum
Topic: Setting up MySQL
Replies: 2
Views: 175

I don't believe it makes a difference, honestly. All phpBB does is open a connection to the database server to send queries and receive results.
by AcousticJames
Wed Oct 25, 2006 8:02 am
Forum: 2.0.x Support Forum
Topic: FAQ problem
Replies: 4
Views: 323

Yes, I understand, but the error message you posted was incomplete. The error message is a standard PHP syntax error message, and they always tell you the filename and line number where the error occured. This will tell you which file and which line the PHP parser is choking on.
by AcousticJames
Wed Oct 25, 2006 8:00 am
Forum: 2.0.x Support Forum
Topic: Multiple accounts sharing same username
Replies: 5
Views: 251

Usernames are case-sensitive. Are the usernames exactly the same, or are they just the same name with dIFFereNT cASeS? Check for underscores too.

That is odd indeed.

Go to advanced search