You are not logged in. Please login or register.
PunBB Forums → Posts by lie2815
lie2815 wrote:I guess, but I don't know. I guess there is something wrong with the ORDER BY statement
Any suggestions how to fix it?
I don't know, do you have to do the ascending/descending?
Sweet, thanks.
I'll look tomorrow if that helps.
I guess, but I don't know. I guess there is something wrong with the ORDER BY statement
Thanks, it does help. I will try that right away. I just don't have a clue how to "properly" handle the div-columns management thing
I like what you did to your front page. Did you use the PunPortal mod to do the news and stuff?
I have a lot of other blocks there. So, if you need any other code for other blocks (like a nice whosonline block), just ask me... 
Oh, but it looks like you're not working with blocks anyways.
Never mind 
Just by the way, what were you trying to do anyways?
No problem. Just out of interest: Could I see your website, pleaaaaase?
You might have to put all the row names instead of *
Ok, now I see what you meant. My calendar works again and now the whosonline box at the bottom of the forum page is wrong. I have absolutely no clue what's going on.
Help?
By the way, Smartys forgot the FROM
$result = $db->query('SELECT id, username,... FROM '.$db->prefix.'users WHERE id = '.$pun_user['id']) or error('Unable to fetch user data', __FILE__, __LINE__, $db->error());Replace the ... with everything you need.
EDIT: Oops, I guess, Smartys was faster.
Oops, yeah, I should have asked what exactly Peter wanted 
You probably just have to delete a line like
require footeror something like that at the bottom of the file
Could you post some more code?
What exactly do you want to do?
Something like that! You forgot the db->prefix
$result = $db->query('SELECT id, username FROM '.$db->prefix.'users ORDER BY id DESC') or error('Unable to fetch user data', __FILE__, __LINE__, $db->error());
$var = $db->result($result);I guess you could change it in your database, just change the default.
Here is my main.tpl file.
I see no mistake.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html dir="<pun_content_direction>">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<pun_char_encoding>" />
<style type="text/css">
#main
{
margin-left: 190px;
}
#left
{
float: left;
width: 180px
}
</style>
<pun_head>
</head>
<body>
<div id="punwrap">
<div id="pun<pun_page>" class="pun">
<div id="brdheader" class="block">
<div class="box">
<div id="brdtitle" class="inbox">
<pun_title>
<pun_desc>
</div>
<pun_navlinks>
<pun_status>
</div>
</div>
<pun_portal_ads>
<div id="left">
<pun_online>
<pun_portal_forum_search>
<div class="block">
<h2 class="block2"><span>More Links</span></h2>
<div class="box">
<div class="inbox">
<ul>
<li><a href="http://www.blueletterbible.org" target="new">blueletterbible.org</a></li>
<li><a href="http://www.preceptaustin.org" target="new">preceptaustin.org</a></li>
<li><a href="http://www.crosswalk.com" target="new">crosswalk.com</a></li>
<li><a href="../downloads" target="new">Downloads</a></li>
</ul>
</div>
</div>
</div>
<pun_portal_textbox>
<pun_portal_recent_topics>
<pun_portal_recent_posts>
<!--<div class="block">
<h2 class="block2"><span>Upcoming Events</span></h2>
<div class="box">
<pun_events>
</div>
</div>-->
<!--<div class="block">
<h2><span>Extra Block</span></h2>
<div class="box">
<div class="inbox">
<p>Here is an extra block, use it wisely. Simply copy this code and paste it under this blocks code to create a duplicate block. Then simply configure its content.</p>
</div>
</div>
</div>-->
</div>
<div id="container">
<div id="main">
<pun_announcement>
<pun_main>
</div>
</div>
<div class="clearer"></div>
<pun_footer>
</div>
</div>
</body>
</html>EDIT: Just by the way: Is google really your homepage? That would mean...
Wait a second... do you mean the whosonline block on the left side? That should be on top of the sidebar.
What about it?
Gotcha. Thanks.
I want it in the announcement box.
Oh, would I have to do that in the header.php file then?
oh, oops. Which width? The main block?
It kinda dropped down a "little".
Go to Administration->User groups!
There you can edit the guest group and allow/disallow different things.
I wanna show a special test for my guests in my forum announcement, just an easy return statement. How can I do that?
PunBB Forums → Posts by lie2815
Powered by PunBB, supported by Informer Technologies, Inc.