Jump to content

SyncViews

Members
 View Profile  See their activity

  • Posts

    75

  • Joined

  • Last visited

    Never

 Content Type 

Posts posted by SyncViews

    Mysql 'Commands out of sync; you can't run this command now'

    in PHP Coding Help

    Posted

    This worked fine untill I made one of the sql statements into a prodcedure. Now I'm getting some error about commands being out of sync :(

    <?php
...
$result = $sql->query("CALL forum_get_index()") or exit(__LINE__.':'.$sql->error);
$i = -1;
while($row = $result->fetch_assoc())
{
	//check if viewing is allowed. If viewing of a section is dissallowed but viewing of the contained forums is allowed the forum will appear in the section "above"
	if(!($user_admin || $row["visible"]))
	{
		//check all valid permissions
		forum_permission($row["forum_id"], $permissions);
		if(!$permissions["visible"]) continue;			
	}	

	unset($row["visible"]);

	if($row["depth"] == 0)
	{
		//increment counter and reduce amount of needed data
		$sections[++$i]["data"] = array(
			'id'	=> $row["forum_id"],
			'name'	=> $row["forum_name"],
			'desc'	=> $row["forum_desc"]
		);
	}
	else
	{
		$row["last_post_time"] = date("M j Y, h:i A",$row["last_post_time"]);
		unset($row["depth"]);
		$sections[$i]["forums"][] = $row;
	}
}
$result->close();
...
?>


    <?php
function forum_permission($forum, &$permissions)
{
global $sql, $user_id;

//check user permissions
$result = $sql->query("SELECT visible, create_topic, post_reply FROM permissions_forum_user WHERE user_id=$user_id AND forum_id=$forum") or exit(__LINE__.':'.$sql->error); //<---ERROR HERE<---
if($result->num_rows > 0)
{
	$data = $result->fetch_assoc();
	if($data["visible"])		$permissions["visible"]			= true;
	if($data["create_topic"])	$permissions["create_topic"]	= true;
	if($data["post_reply"])		$permissions["post_reply"]		= true;
}
$result->close();

//check users groups
$result = $sql->query("
	SELECT p.visible, p.create_topic, p.post_reply
	FROM group_users u, permissions_forum_group p
	WHERE p.group_id = u.group_id AND u.user_id = $user_id
	") or exit(__LINE__.':'.$sql->error);
while($row = $result->fetch_assoc())
{
	if($row["visible"])			$permissions["visible"]			= true;
	if($row["create_topic"])	$permissions["create_topic"]	= true;
	if($row["post_reply"])		$permissions["post_reply"]		= true;
}
$result->close();
}
?>

    The procedure

    	DELIMITER $$
	DROP PROCEDURE IF EXISTS forum_get_index$$

	CREATE PROCEDURE forum_get_index()
	BEGIN
		SELECT node.forum_id, node.forum_name, node.forum_desc,
		node.topics, node.posts,
		node.last_topic_id, node.last_topic_name, node.last_post_id, node.last_post_time,
		node.last_user_id, node.last_user_name, node.visible,
		sub.depth
		FROM forums AS node,
		(
			SELECT node.forum_id AS forum_id,
			COUNT( parent.forum_id ) -1 AS depth
			FROM forums AS node, forums AS parent
			WHERE node.left
			BETWEEN parent.left
			AND parent.right
			GROUP BY node.forum_id
			ORDER BY node.left
		) AS sub
		WHERE node.forum_id = sub.forum_id
		GROUP BY node.forum_id
		HAVING sub.depth < 2
		ORDER BY node.left;
	END$$

    Problem with update query

    in MySQL Help

    Posted

    So is there anyway I can get around it without having to make 1 query to get the forums list, make the results comma seperated and insert them into a second query?

     

    EDIT:

    Seeing as mysql now has stored procedures is there an easy way to use them to do this?

    Problem with update query

    in MySQL Help

    Posted

    I don't see why this shouldn't work...

    UPDATE forums
SET topics=topics+1, posts=posts+1,
last_topic_name='Test topic...', last_topic_id=14,
last_post_id=19, last_post_time=1209662581,
last_user_id=1, last_user_name='SyncViews'
WHERE forum_id IN
(
SELECT parent.forum_id
FROM forums AS forum, forums AS parent
WHERE forum.left BETWEEN parent.left AND parent.right
AND forum.forum_id = 5
)

    #1093 - You can't specify target table 'forums' for update in FROM clause

    Selecting all relevant records at once

    in PHP Coding Help

    Posted

    I was goign through that today using the "nested set model" from that page but I'm having some trobel with an update statement. It needs to update the last post/topic details of all the forums from the current one to the root but I'm getting an error and I'm not sure why :(

     

    The query thats sent to the server:

    UPDATE forums
SET topics=topics+1, posts=posts+1,
last_topic_name='Test topic...', last_topic_id=14,
last_post_id=19, last_post_time=1209662581,
last_user_id=1, last_user_name='SyncViews'
WHERE forum_id IN
(
SELECT parent.forum_id
FROM forums AS forum, forums AS parent
WHERE forum.left BETWEEN parent.left AND parent.right
AND forum.forum_id = 5
)

    The error:

    You can't specify target table 'forums' for update in FROM clause

    Selecting all relevant records at once

    in PHP Coding Help

    Posted

    Each of my records stores the id of the "parent" record or 0 if it's a top level record. Is there an easy way to select every record in this chain rather than this that makes tons of calls for long chains.

     

    from my new topic script

    ...$parent_id = id of forum for topic to be created in
<?php
//get parent forum list
$getparent = $sql->prepare("SELECT forum_name, parent_id FROM forums WHERE forum_id=?");
while($parent_id != 0)
{
	$forum_id = $parent_id;
	$getparent->bind_param("i", $parent_id);
	$getparent->execute();
	$getparent->bind_result($forum_name, $parent_id);
	$getparent->fetch();
	$parents[] = array('id' => $forum_id, 'name' => $forum_name);
}
if($parents)$smarty->assign('parent_forums', array_reverse($parents));
$getparent->close();

...

//update forums
$parents_str = '';
foreach($parents as $i=>$parent)
{
	if($i==0)$parents_str .=  $parent["id"];
	else     $parents_str .= ", $parent[id]";
}

$sql->query("
	UPDATE forums
	SET	topics=topics+1, posts=posts+1,
	last_topic_name='$subject', last_topic_id=$topic_id,
	last_post_id=$post_id, last_post_time=$time,
	last_user_id=$user_id, last_user_name='$user_name'
	WHERE forum_id IN ($parents_str)
") or exit(__LINE__.':'.$sql->error);
?>

    keeping data between scripts

    in PHP Coding Help

    Posted

    Right now almost every page is making the same sql querys to get things like paths to the users template directory etc.

    eg:

    $result = $mysqli->query("SELECT style_path, style_name FROM styles WHERE style_id=$_SESSION[style]");

    This seems a waste of resources and I'm certain it would be more efficent just to keep the whole lot in memory as an array...

    $styles
        0 =>
                'name'        => 'Default'
                'path'        => 'styles/default'
        1 =>
                'name'        => 'Deep Space'
                'path'        => 'styles/deepspace'

    So is there someway I can have this array present accross all my scripts? A shared global if you like.

    sql error...

    in PHP Coding Help

    Posted

    74:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 6

    <?php
...
//update forums
	$parents_str = '';
	foreach($parents as $i=>$parent)
	{
		if($i==0)$parents_str .  $parent["id"];
		else     $parents_str . ", $parent[id]";
	}

	$sql->query("
		UPDATE forums
		SET	topics=topics+1, posts=posts+1,
		last_topic_name='$subject', last_topic_id=$topic_id,
		last_post_id=$post_id, last_post_time=$time,
		last_user_id=$user_id, last_user_name='$user_name'
		WHERE forum_id IN ($parents_str)
	") or exit(__LINE__.':'.$sql->error);
...

    There must be a better way...

    in PHP Coding Help

    Posted

    1)

    I need to insert some data into two tables. The problem is the two records need to "point" to each other...

     

    <?php
mysql_query("INSERT INTO topics
(date, title, forum_id)
VALUES
($date, '$subject', $_GET[forum])
")or exit(mysql_error());
$topic_id = mysql_insert_id();

mysql_query("INSERT INTO posts
(date, content, topic_id, user_id)
VALUES
($time, '$content', $topic_id, $user_id)
")or exit(mysql_error());
$post_id = mysql_insert_id();
mysql_query("UPDATE topics SET first=$post_id WHERE topic_id=$topic_id")or exit(mysql_error());
?>

     

    I tried doing this but it seems it's not allowed..

    <?php
...
mysql_query("
INSERT INTO topics, posts
(topics.date, topics.title, topics.forum_id, topics.first,
posts.topic_id, posts.user_id, posts.content, posts.date)
VALUES
($time, '$subject', $_GET[forum], posts.post_id,
topics.topic_id, $user_id, '$content', $time)
")or exit(mysql_error());
...
?>

     

    Do I really need to make 3 seprate querys?

     

    2)This makes loads of querys I'd rather not...

    <?php
...
$con = mysql_connect($sql_host, $sql_user, $sql_pass) or exit('Failed to connect to database: ' . mysql_error());
$con2 = mysql_connect($sql_host, $sql_user, $sql_pass) or exit('Failed to connect to database: ' . mysql_error());
mysql_select_db($sql_db, $con2);
$con3 = mysql_connect($sql_host, $sql_user, $sql_pass) or exit('Failed to connect to database: ' . mysql_error());
mysql_select_db($sql_db, $con3);

//get sections
$result1 = mysql_query("
	SELECT section_id, section_name
	FROM sections
	ORDER BY display ASC
",$con)or exit(mysql_error($con));
for($i=0; $row1 = mysql_fetch_array($result1); ++$i)
{
	$sections[$i]["DATA"]['ID']		= $row1["section_id"];
	$sections[$i]["DATA"]['NAME']	= $row1["section_name"];		
	//get forums
	$result2 = mysql_query("
		SELECT forum_id, forum_name, forum_desc, forum_topics, forum_posts
		FROM forums
		WHERE section_id=$row1[section_id]
		ORDER BY display ASC
	", $con2) or exit(mysql_error($con2));
	for($i2=0; $row2 = mysql_fetch_array($result2); ++$i2)
	{
		$sections[$i]["FORUMS"][$i2]["ID"]		= $row2["forum_id"];
		$sections[$i]["FORUMS"][$i2]["NAME"]	= $row2["forum_name"];
		$sections[$i]["FORUMS"][$i2]["DESC"]	= $row2["forum_desc"];
		$sections[$i]["FORUMS"][$i2]["TOPICS"]	= $row2["forum_topics"];
		$sections[$i]["FORUMS"][$i2]["POSTS"]	= $row2["forum_posts"];
		//get last post data
		if($row2["forum_topics"])
		{
			$sections[$i]["FORUMS"][$i2]["LAST"] = true;
			$result3 = mysql_query("
				SELECT users.user_id, users.username,
				posts.date,
				topics.topic_id, topics.title
				FROM users, posts, topics
				WHERE topics.forum_id=$row2[forum_id] AND topics.topic_id=posts.topic_id AND posts.user_id=users.user_id
				ORDER BY posts.date DESC
				LIMIT 0,1
				", $con3) or exit(mysql_error($con3));
			$row3 = mysql_fetch_array($result3);
			$sections[$i]["FORUMS"][$i2]["LAST_TOPIC_ID"]	= $row3["topic_id"];
			$sections[$i]["FORUMS"][$i2]["LAST_TOPIC_NAME"]	= $row3["title"];
			$sections[$i]["FORUMS"][$i2]["LAST_TIME"]= date("M j Y, h:i A",$row3["date"]);
			$sections[$i]["FORUMS"][$i2]["LAST_USER_ID"]	= $row3["user_id"];
			$sections[$i]["FORUMS"][$i2]["LAST_USER_NAME"]	= $row3["username"];
		}
		else $sections[$i]["FORUMS"][$i2]["LAST"] = false;
	}
}
$smarty->assign ('SECTIONS', $sections);
...
?>

    more bb problems

    in PHP Coding Help

    Posted

    Ok it's addin quotes this time. I was going to do it the same way as the other bb codes (see parse_part) but the problem is it then won't work with say this because the quote tags are nolonger in the same string so won't be matched...

     

    [quote]

      [code]

        some quoted code

      [/code]

    [/quote]

     

    but if I prase it before spliting then this wouldn't work instead :(

     

    [code]

      [quote]

        this is what quote tags look like

      [/quote]

    [/code]

     

    I really have no idea how to do it so both the above examples work...

     

    <?php
function parse($str)
{
$parts = preg_split('#(\[/?code\])#i', $str, -1, PREG_SPLIT_DELIM_CAPTURE);

// every fourth index will contain content to be parsed (starting at 0)
foreach ($parts as $i => $part)
{
	switch($i % 4)
	{
		case 0: $parts[$i] = parse_part($part); break;
		case 1: $parts[$i] = '<div class="bb_code_outer"><span class="bb_code_title">CODE:</span><pre class="bb_code">'; break;//code header
		case 2: $parts[$i] = htmlentities($part, ENT_QUOTES); break;
		case 3: $parts[$i] = '</pre></div>'; break;//code footer
	}
}

return join('', $parts);
}
function parse_part($str)
{
$str = htmlentities($str, ENT_QUOTES);
//add new lines
$str = str_replace("\n","<br />\n",$str);

//smilies
$smilie_root = $url_root.'/smilies/';
$str = str_replace('','<img scr="'.$smilie_root.'smile.png"   alt="smile"   title="smile"   />',$str);
$str = str_replace('','<img scr="'.$smilie_root.'sad.png"     alt="sad"     title="sad"     />',$str);
$str = str_replace('','<img scr="'.$smilie_root.'biggrin.png" alt="biggrin" title="biggrin" />',$str);
$str = str_replace('','<img scr="'.$smilie_root.'tongue.png"  alt="tongue"  title="tongue"  />',$str);

//bb codes
$bb_codes = array(
	'/\[b\](.*?)\[\/b\]/is',                              //BOLD
	'/\[i\](.*?)\[\/i\]/is',                              //ITALIC
	'/\[u\](.*?)\[\/u\]/is',                              //UNDERLINE
	'/\[url\](.*?)\[\/url\]/is',                          //URL
	'/\[url\=(.*?)\](.*?)\[\/url\]/is',                   //URL2
	'/\[img\](.*?)\[\/img\]/is',                          //IMAGE
	'/\[mail\](.*?)\[\/img\]/is',                         //MAIL
	'/\[mail\=(.*?)\](.*?)\[\/mail\]/is',                 //MAIL2
	'/\[colo?r\=(.*?)\](.*?)\[\/colo?r\]/is',             //COLOUR
	'/\[size\=(.*?)\](.*?)\[\/size\]/is',                 //SIZE
	'/\[font\=(.*?)\](.*?)\[\/font\]/is',                 //FONT
	'/\[align\=(left|center|right)\](.*?)\[\/align\]/is', //ALIGN
	'/\[pre\](.*?)\[\/pre\]/is'                           //PREFORMATTED
);

$bb_html = array(
	'<span style="font-weight: bold">$1</span>',          //BOLD
	'<span style="font-style: italic">$1</span>',         //ITALIC
	'<span style="text-decoration: underline">$1</span>', //UNDERLINE
	'<a href="$1">$1</a>',                                //URL
	'<a href="$1">$2</a>',                                //URL2
	'<img src="$1" alt="$1" />',                          //IMAGE
	'<a href="mailto:$1">$1</a>',                         //MAIL
	'<a href="mailto:$1">$2</a>',                         //MAIL2
	'<span style="color: $1">$2</span>',                  //COLOUR
	'<span style="font-size: $1">$2</span>',              //SIZE
	'<span style="font-family: $1">$2</span>',            //FONT
	'<span style="text-align: $1">$2</span>',             //ALIGN
	'<pre>$1</pre>'                                       //PREFORMATTED
);
$str = preg_replace ($bb_codes, $bb_html, $str);

return $str;
}
?>

    Getting this in one query/result

    in MySQL Help

    Posted 

    tabel users
user_id
user_name
...

tabel pms
to
from
...

    The id's from the pms (to and from) tabel match up with the users in the users tabel. I though about doing it like below but thats makes two rows for one pm but I only want one row :(

     

    SELECT users.user_id, users.user_name,
           pms.pm_id, pms.time, pms.content, pms.subject
FROM users, pms
WHERE pms.to = users.user_id OR pms.from = users.user_id

     

    is there someway I can make it just one row per pm with a result like this?

    pm_id
time
content
subject
to.user_id
to.user_name
from.user_id
from.user_name

    Getting from sql database to something I can use

    in PHP Coding Help

    Posted

    database structure

    categorys:
category_id
category_name
category_display

sections:
section_id
category_id
section_name
section_decription
section_display

    The category_id in the sections tabel says what category the section is under. I need to query the database and get these into some arrays but I'm not sure what is the best way. Each "group" needs to be order by the _display valuse in assending order

     

    category
  |
  |--section -> section data
  |
  |--section -> section data

category
  |
  |--section -> section data

    So I should have 3 "layers" of arrays eg

    Eg to get the name of the first section in the first catagory:

    $data[0][0]["section_name"]

     

    I have got it to an extent but it doubles up the category data and I'm not sure it's a particualy fast query either... The other problem is I can't see a good way to seperate the catagorys so I can insert the catagory names in between where as with a big array I could just use a double foreach loop

     

    <?php
$query = mysql_query('
	SELECT
	category.category_name,
	sections.sections_name, sections.sections_desc
	FROM categorys, sections
	WHERE category.category_id=category.category_id
	ORDER BY categorys.display, sections.display
	') or exit(mysql_error());
?>

    mysql functions

    in PHP Coding Help

    Posted

    How should I be doing this as I get warnings and it doesn't work :(

    Warning: Wrong parameter count for mysql_fetch_array() in /home/flance/public_html/profile.php on line 23

    $query = mysql_query('SELECT COUNT(*) FROM posts WHERE user_id='.$_GET["id"]) or exit(mysql_error());
$data = mysql_fetch_array();

$smarty->assign('PROFILE_POSTS', $data["COUNT(*)"]);

    warning won't go away :(

    in PHP Coding Help

    Posted

    All have there names set...

    	<form action="{$URL_ROOT}login.php" method="post">
	<label for="login_name">Username:</label><input type="text" name="name" id="login_name" />
	<label for="login_pass">Password:</label><input type="password" name="pass" id="login_pass" />
	<label for="login_stay">Stay logged in:</label>	<input type="checkbox" name="stay" id="login_stay" />
	<input type="submit" value="Login" />
	</form>

     

    warning won't go away :(

    in PHP Coding Help

    Posted

    Warning: Unknown: Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42 or session.bug_compat_warn to off, respectively. in Unknown on line 0

    login.php <this is the page i'm displaying that gives the error...

    <?php
$page_name = 'Login';
$root_level= '';
include('include/config.php');//passwords etc
include('include/start.php');

if(!isset($_POST["stay"])) $_POST["stay"] = 0;
if(isset($_POST["name"]) && isset($_POST["pass"]))
{
	//shouldn't be here
	if($user_loggedin) header('location:' . $url_root);
	//login
	else
	{	
		$login = login($_POST["name"], $_POST["pass"], $_POST["stay"]);
		$smarty->assign("LOGIN_RESULT", $login);

		$smarty->display('header.tpl');
		$smarty->display('login.tpl');	
		$smarty->display('footer.tpl');
	}
}
//no data...
else header('location:' . $url_root);
?>

    start.php

    <?php
session_start();
//get functions
include ($root_level . 'include/functions.php');

//connect
$con = mysql_connect($sql_host, $sql_user, $sql_pass) or exit('Failed to connect to database: ' . mysql_error());
mysql_select_db($sql_db, $con);

$style = $def_style;
//only if it's set and true...
if(isset($_SESSION["loggedin"]) && $_SESSION["loggedin"])
{
	$user_loggedin = true;
	$user_name = $_SESSION["user_name"];
	$user_id   = $_SESSION["user_id"];
	$user_last = $_SESSION["user_last"];
	$user_pms  = 0;
}
else
{
	$user_loggedin = false;
	$user_name = "Visitor";
	$user_id   = 0;
	$user_last = 0;
	$user_pms  = 0;
}
...template stuff doesn't touch sessions...
?>

    functions.php

    <?php
//returns non-zero on fail
function login($name, $pass, $stay)
{
global $smarty, $user_loggedin, $user_name, $user_id, $user_pms, $user_last, $domain;

if(!valid($name, "name")) return 1;
if(!valid($pass, "password")) return 2;

//check user exists + correct password
$query = mysql_query('SELECT user_id, password, salt, banned, last FROM users WHERE username="'.$name.'"') or exit(mysql_error);
if(mysql_num_rows($query) != 1)return 3;
$data = mysql_fetch_array($query);
if($data["banned"]) return 5;
if(md5($data[salt] . $pass) != $data["password"])return 4;

//set varibles
$user_loggedin = true;
$user_name = $name;
$user_id   = $data["user_id"];
$user_pms  = 0;
$user_last = $data["last"];

$_SESSION["loggedin"]  = 1;
$_SESSION["user_name"] = $data["username"];
$_SESSION["user_id"]   = $data["user_id"];
$_SESSION["user_last"] = $data["last"];

//assign smarty varibles
$smarty->assign('USER_LOGGEDIN', $user_loggedin);
$smarty->assign('USER_NAME',     $user_name);
$smarty->assign('USER_ID',       $user_id);
$smarty->assign('USER_LAST',     date("H:i:s d-m-y",$data["last"]));
$smarty->assign('USER_PMS',      $user_pms);

//stay logged in
if($stay)
{
	$cookie['username'] = $name;
	$cookie['password'] = $pass;
	setcookie('login', serialize($cookie), time()+days(60), '/','.' . $domain);
}
//update last login time
mysql_query('UPDATE users SET last='.time().' WHERE user_id='.$user_id);
return 0;
}
?>

    [SOLVED] bb code help

    in PHP Coding Help

    Posted

    Ive made these to process bb codes:

    <?php
$bb_codes = array(
'/\[b\](.*?)\[\/b\]/is',                              //BOLD
'/\[i\](.*?)\[\/i\]/is',                              //ITALIC
'/\[u\](.*?)\[\/u\]/is',                              //UNDERLINE
'/\[url\](.*?)\[\/url\]/is',                          //URL
'/\[url\=(.*?)\](.*?)\[\/url\]/is',                   //URL2
'/\[img\](.*?)\[\/img\]/is',                          //IMAGE
'/\[mail\](.*?)\[\/img\]/is',                         //MAIL
'/\[mail\=(.*?)\](.*?)\[\/mail\]/is',                 //MAIL2
'/\[colo?r\=(.*?)\](.*?)\[\/colo?r\]/is',             //COLOUR
'/\[size\=(.*?)\](.*?)\[\/size\]/is',                 //SIZE
'/\[font\=(.*?)\](.*?)\[\/font\]/is',                 //FONT
'/\[align\=(left|center|right)\](.*?)\[\/align\]/is', //ALIGN
'/\[pre\](.*?)\[\/pre\]/is'                           //PREFORMATTED
);

$bb_html = array(
'<span style="font-weight: bold">$1</span>',          //BOLD
'<span style="font-style: italic">$1</span>',         //ITALIC
'<span style="text-decoration: underline">$1</span>', //UNDERLINE
'<a href="$1">$1</a>',                                //URL
'<a href="$1">$2</a>',                                //URL2
'<img src="$1" alt="$1" />',                          //IMAGE
'<a href="mailto:$1">$1</a>',                         //MAIL
'<a href="mailto:$1">$2</a>',                         //MAIL2
'<span style="color: $1">$2</span>',                  //COLOUR
'<span style="font-size: $1">$2</span>',              //SIZE
'<span style="font-family: $1">$2</span>',            //FONT
'<span style="text-align: $1">$2</span>',             //ALIGN
'<pre>$1</pre>'                                       //PREFORMATTED
);
$str = preg_replace ($bb_codes, $bb_html, $str);
?>

     

     

    The problem I'm havin is how to process the [code][/code] tags as I need to stop any of the other bbcodes effecting the code block.

    user systems

    in PHP Coding Help

    Posted

    I know how to store (using mysql) and handel the basic stuff like emails, passwords, usernames etc but where do I start with implementing more dynamic stuff eg:

     

    -Which groups a user is a member of

    -Users access rights for each section (eg can they see the section, are they allowed to post there, do they have moderator rights there etc)

    templates

    in PHP Coding Help

    Posted

    How do templatesa like the one from "phpbb3/styles/prosilver/template/viewforum_body.html" work?

    <!-- INCLUDE overall_header.html -->
<!-- IF U_MCP --><p>[ <a href="{U_MCP}">{L_MCP}</a> ]</p><!-- ENDIF -->
<h2><a href="{U_VIEW_FORUM}">{FORUM_NAME}</a></h2>

<!-- IF FORUM_DESC or MODERATORS or U_MCP -->
<p>
<!-- NOTE: remove the style="display: none" when you want to have the forum description on the forum body -->
<!-- IF FORUM_DESC --><span style="display: none">{FORUM_DESC}<br /></span><!-- ENDIF -->
<!-- IF MODERATORS --><strong><!-- IF S_SINGLE_MODERATOR -->{L_MODERATOR}<!-- ELSE -->{L_MODERATORS}<!-- ENDIF -->:</strong> {MODERATORS}<!-- ENDIF -->
</p>
<!-- ENDIF -->

<!-- IF S_FORUM_RULES -->
<div class="rules">
	<div class="inner"><span class="corners-top"><span></span></span>

	<!-- IF U_FORUM_RULES -->
		<a href="{U_FORUM_RULES}">{L_FORUM_RULES}</a>
	<!-- ELSE -->
		<strong>{L_FORUM_RULES}</strong><br />
		{FORUM_RULES}
	<!-- ENDIF -->

	<span class="corners-bottom"><span></span></span></div>
</div>
<!-- ENDIF -->
...

    I looked in the php filers and found that it defines all thosde varibles but I'm not sure how it actualy uses it to make the final page...

     

     

    view_forum.php

    ...
// Send vars to template
$template->assign_block_vars('topicrow', array(
'FORUM_ID' => $forum_id,
'TOPIC_ID' => $topic_id,
'TOPIC_AUTHOR' => get_username_string('username', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
'TOPIC_AUTHOR_COLOUR' => get_username_string('colour', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
'TOPIC_AUTHOR_FULL' => get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),
'FIRST_POST_TIME' => $user->format_date($row['topic_time']),
'LAST_POST_SUBJECT' => censor_text($row['topic_last_post_subject']),
'LAST_POST_TIME' => $user->format_date($row['topic_last_post_time']),
'LAST_VIEW_TIME' => $user->format_date($row['topic_last_view_time']),
'LAST_POST_AUTHOR' => get_username_string('username', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
'LAST_POST_AUTHOR_COLOUR' => get_username_string('colour', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
'LAST_POST_AUTHOR_FULL'	 => get_username_string('full', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),
...

    Why use OOP?

    in PHP Coding Help

    Posted

    I still don't really see a use of it in php.

     

    In c++ I used oop for stuff like making an ini praser as I want to have multiple files open at once. But then thats because I need to keep the ini file open between loops so that the data is updated all the time before being saved on exit. so "start program -> prase files(like 10) -> START LOOP -> get user input -> update ini data strutures -> CONTIUE TO LOOP UNTILL EXIT -> save files -> exit"

     

    Php doesn't loop like that as user input requires a new page so it ends up as "prase file A-> echo data -> prase file B -> send page to client " then the next page when the user presses submit "build fileA-> save file -> build fileB -> save file -> end"

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.