[oldengine]

Installation Mistake: vBulletin 3.0.8 - Version 1.82

Instructions: Step 3. in inc\classes\sendLoginInfo.php

Find ;

				$stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE ispublic IS NOT NULL AND ispermanent IS NULL ORDER BY created");
				if($rs = $stmt->process()) {
					while($rec = $rs->next()) {
						$this->sendBack(new Message('adr', null, $rec['id'], $rec['name']));
						if( $rec['password'] != '' ) $this->sendBack(new Message('srl', null, $rec['id'], 'true'));
						$rooms[$rec['id']] = 0;
					}
				}
			}

What I find in the unmodified code is:

                                $stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE ispublic IS NOT NULL AND ispermanent IS NOT NULL ORDER BY ispermanent");
                                if($rs = $stmt->process()) {
                                        while($rec = $rs->next()) {
                                                $this->sendBack(new Message('adr', null, $rec['id'], $rec['name']));
                                                if( $rec['password'] != '' ) $this->sendBack(new Message('srl', null, $rec['id'], 'true'));
                                                $rooms[$rec['id']] = 0;
                                        }
                                }

Notice that there is one less } in the unmodified code.

Replace with ;

				$stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE ispublic IS NOT NULL AND ispermanent IS NULL ORDER BY created");
				if($rs = $stmt->process()) {
					while($rec = $rs->next()) {
						$this->sendBack(new Message('adr', null, $rec['id'], $rec['name']));
						if( $rec['password'] != '' ) $this->sendBack(new Message('srl', null, $rec['id'], 'true'));
						$rooms[$rec['id']] = 0;
					}
				}
				// # Paul M # load permanant private rooms if Admin.
				if(ChatServer::userInRole($this->userid, ROLE_ADMIN)) {
					$stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE ispublic IS NULL AND ispermanent IS NOT NULL ORDER BY created");
					if($rs = $stmt->process()) {
						while($rec = $rs->next()) {
							$this->sendBack(new Message('adr', null, $rec['id'], $rec['name']));
							$rooms[$rec['id']] = 0;
						}
					}
				}
			}

What happens is the flashchat hangs on the blue background screen after login. If I put this code back to original, flashchat functions. If I mess with taking out a } after the modded code, it also functions, but I'm just not completely sure what to do now except dig in further.

My final code:

//
                                $stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE ispublic IS NOT NULL AND ispermanent IS NULL ORDER BY created");
                                if($rs = $stmt->process()) {
                                        while($rec = $rs->next()) {
                                                $this->sendBack(new Message('adr', null, $rec['id'], $rec['name']));
                                                if( $rec['password'] != '' ) $this->sendBack(new Message('srl', null, $rec['id'], 'true'));
                                                $rooms[$rec['id']] = 0;
                                        }
                                }
                                // # Paul M # load permanant private rooms if Admin.
                                if(ChatServer::userInRole($this->userid, ROLE_ADMIN)) {
                                        $stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE ispublic IS NULL AND ispermanent IS NOT NULL ORDER BY created");
                                        if($rs = $stmt->process()) {
                                                while($rec = $rs->next()) {
                                                        $this->sendBack(new Message('adr', null, $rec['id'], $rec['name']));
                                                        $rooms[$rec['id']] = 0;
                                                }
                                        }
                                }
//

Notice that I took out the last } (there were four there.)