Search options (Page 10 of 13)

Try this instead, where you see the "SEECT COUNT(x) FROM y WHERE x"

$result = $db->query("SELECT x FROM y WHERE x") or error("message");

// Now you should see something along the lines of this:
// $num_online = $db->result($result);
// Change to this:
$num_online = $db->num_rows($result);

Now there is the occational COUNT(x)-1 or SELECT COUNT(x), z FROM y... so yah... this is just a tip to get you in the right direction...

Hurmm... "SELECT COUNT(x) FROM y" is used in a few places in punbb... you might want to grep through the code... I think it's used to find out the next valid topic id, post id,  forum id, user id, etc...

There's gonah be some additional problems with timezoning too...

The states just changed the date they go back/forward, and I ~think~ North america followed the states too. Dono about Europ or asia or what not though...

Hurm, this should be easy...

line 300ish in ./include/functions.php

find:
                <ul>
?>">Preview</a></li>
                    <li<?php if ($page == 'essentials') echo ' class="isactive"'; ?>><a href="profile.php?section=essentials&id=<?php echo $id ?>"><?php echo $lang_profile['Section essentials'] ?></a></li>
                    <li<?php if ($page == 'personal') echo ' class="isactive"'; ?>><a href="profile.php?section=personal&id=<?php echo $id ?>"><?php echo $lang_profile['Section personal'] ?></a></li>

replace with:
                <ul>
                    <li<?php if ($page == 'preview') echo ' class="isactive"'; ?>><a href="profile.php?section=preview&id=<?php echo $id ?>">Preview</a></li>
                    <li<?php if ($page == 'essentials') echo ' class="isactive"'; ?>><a href="profile.php?section=essentials&id=<?php echo $id ?>"><?php echo $lang_profile['Section essentials'] ?></a></li>
                    <li<?php if ($page == 'personal') echo ' class="isactive"'; ?>><a href="profile.php?section=personal&id=<?php echo $id ?>"><?php echo $lang_profile['Section personal'] ?></a></li>

Now profile.php line 910ish

find:

// View or edit?
if ($pun_user['id'] != $id &&
    ($pun_user['g_id'] > PUN_MOD ||
    ($pun_user['g_id'] == PUN_MOD && $pun_config['p_mod_edit_users'] == '0') ||
    ($pun_user['g_id'] == PUN_MOD && $user['g_id'] < PUN_GUEST)))
{

replace with:

// View or edit?
if (($pun_user['id'] != $id &&
    ($pun_user['g_id'] > PUN_MOD ||
    ($pun_user['g_id'] == PUN_MOD && $pun_config['p_mod_edit_users'] == '0') ||
    ($pun_user['g_id'] == PUN_MOD && $user['g_id'] < PUN_GUEST)))
    || (!$section ||  $section == 'preview'))
{

again in profile.php, around line 1050

find:
}
else
{
    if (!$section || $section == 'essentials')
    {

replace with:

}
else
{
    if ($section == 'essentials')
    {

Now you default to the preview, and still have all the admin, mod, and personal options

You can visit my website, and sign-up for an account to see this in action, great idea! This bugged me too

Well... It's not as easy as you think... depending...

$cur_post['g_title'] is the name of the group, as far as administrators are concirned (It's the first line that's displayed when you edit a group)
$cur_post['g_user_title'] is the description (or display name, or title) of the group (as long as ranks are disabled and the user title hasn't been set; second line in edit groups).

Just add ", g.g_title " after the first ", g.g_user_title" to get the group name. Then $cur_post['g_title'] will be set, and you can echo it wherever

Now if you want the title, of the group to display... well that's work, since sometimes g_user_title is NULL, and sometime users.title is NULL and sometimes ranks don't exists or are turned off...

http://www.w3.org/TR/REC-html40/interac … ef-enctype

<form action="blah" method="post" enctype="multipart/form-data">
<!-- blah -->
<input type="file" ...>

That should upload the file in the post data, and not to a temporary location, as far as I know anyways... But I suppose I could be wrong... It be the first time lol

EDIT --

http://www.ietf.org/rfc/rfc2388.txt

Looks like the specs specify what the httpd app can do with that data... it has to go to the perl script in the same way that a multi-part e-mail message would show up in telnet. I'm unsure how php handles this, but i'm assuming it's the same thing. If something ends up in tmp, it's probably due to the way profile.php and/or php stores that data, and very litle to do with the w3 specs.

EDIT --

Hummm, found this:
http://www.thescripts.com/forum/thread925.html looks like php uses tmp for the FILES variable...

Might have to use something with power server side, like perl... I really wish php was just perl with ?> substituted as END; and <?php substituted as print <<END... but such is life...

Lemme see if there's a way to "bypass" the FILES variable...

EDIT --

Hurm... almost there... gimme a few more...

"Unable to fetch table status" is caused in admin_index.php and it happends when a mysql server doesn't return it's version information correctly. I suggest opening admin_index.php and remove these lines:

// Collect some additional info about MySQL
if ($db_type == 'mysql' || $db_type == 'mysqli')
{
    $db_version = 'MySQL '.$db_version;

    // Calculate total db size/row count
    $result = $db->query('SHOW TABLE STATUS FROM `'.$db_name.'`') or error('Unable to fetch table status', __FILE__, __LINE__, $db->error());

    $total_records = $total_size = 0;
    while ($status = $db->fetch_assoc($result))
    {
        $total_records += $status['Rows'];
        $total_size += $status['Data_length'] + $status['Index_length'];
    }

    $total_size = $total_size / 1024;

    if ($total_size > 1024)
        $total_size = round($total_size / 1024, 2).' MB';
    else
        $total_size = round($total_size, 2).' KB';
}

PS I take no responsibility for what goes wrong, if something does ;p

Can it do ogg? mp3s are to circled in copyrights for me... the ogg format is open to public.

Well in my particular situation, ssh'in into my own box would be silly, hehe, but true nuff, if it's on a remote box, grab it locally... and if you want to, break out the big boys ;p

Meh, it's kindah like your story up above... Things that arn't "commercial product" quality, or size, don't require this, or that, to modify... You want to drive the car there, and get there first; drive the bike and come second, or walk the way and come last? Well when the distance is short, it doesn't matter

The being said, I couldn't see much use in vi (or the acompanying bach apps) for you, other then the special occation. For me, even with a large project, vi is the way to go. Remeber I'm running linux as a desktop, so I don't have ssh anywhere to get vi up and running, and I have as many v-terminals as I like. The simple fact is, I have more screen realestate then 10 of me could handle, and enough "do this" scripts in the home folder to accomplish anything a Windows app could do for me. Going back to windows, or using wine to run anything other then games would be like moving from a 10 acre house in the country to a bachlor in the heart of the city (Which is an odd analogy... I actually prefer my bachlors, in the city, lol).

Meh, it work in perl, or c/c++... heck I think even in java...
I was hoping I was just forget to cast it or add extra brackets or something...