Jump to content

MYSQL 50 QUERYS?

Monkuar

By Monkuar
in PHP Coding Help

 Share

Recommended Posts

Monkuar Advanced Member

Monkuar

Posted
Posted

Help me GOD.

 

 

0.00057  	SELECT u.*, g.*, o.logged, o.idle FROM users AS u INNER JOIN groups AS g ON u.group_id=g.g_id LEFT JOIN online AS o ON o.user_id=u.id WHERE u.id=2
0.00021 	UPDATE online SET logged=1247640127 WHERE user_id=2
0.00017 	UPDATE online SET current_page='/forums/viewforum.php', current_ip='127.0.0.1', current_page_id='1' WHERE user_id='2'
0.00015 	SELECT * FROM online WHERE logged<1247639827
0.00027 	SELECT f.forum_name, pf.forum_name AS parent_forum, f.redirect_url, f.moderators, f.num_topics, f.sort_by, f.parent_forum_id, fp.post_topics FROM forums AS f LEFT JOIN forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=1) LEFT JOIN forums AS pf ON f.parent_forum_id=pf.id WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND f.id=1
0.00035 	SELECT COUNT(id) FROM reports WHERE zapped IS NULL
0.01845 	SELECT COUNT(id) FROM messages WHERE showed=0 AND owner=2
-0.01855 	SELECT f.forum_desc, f.forum_name, f.id, f.last_post, f.last_post_id, f.last_poster, f.moderators, f.num_posts, f.num_topics, f.redirect_url, p.poster_id AS last_poster_id FROM forums AS f LEFT JOIN posts AS p ON (p.id=f.last_post_id) WHERE parent_forum_id=1 ORDER BY disp_position
0.01836 	SELECT imgaward FROM users WHERE username="monkuar"
0.00073 	SELECT t.id, t.poster, t.subject, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, p.poster_id AS last_poster_id FROM topics AS t INNER JOIN posts AS p ON (p.id=t.last_post_id) WHERE forum_id=1 ORDER BY sticky DESC, last_post DESC LIMIT 0, 20
-0.00389 	SELECT imgaward FROM users WHERE username="monkuar"
  	SELECT imgaward,id FROM users WHERE username="monkuar"
0.01822 	SELECT imgaward FROM users WHERE username="monkuar"
0.00019 	SELECT imgaward,id FROM users WHERE username="monkuar"
-0.01910 	SELECT imgaward FROM users WHERE username="monkuar"
0.01838 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.00023 	SELECT imgaward FROM users WHERE username="monkuar"
0.00016 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.00014 	SELECT imgaward FROM users WHERE username="monkuar"
0.00015 	SELECT imgaward,id FROM users WHERE username="monkuar"
-0.02070 	SELECT imgaward FROM users WHERE username="monkuar"
0.01833 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.00025 	SELECT imgaward FROM users WHERE username="monkuar"
0.01824 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.00014 	SELECT imgaward FROM users WHERE username="monkuar"
0.00016 	SELECT imgaward,id FROM users WHERE username="monkuar"
-0.01942 	SELECT imgaward FROM users WHERE username="monkuar"
0.01833 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.00023 	SELECT imgaward FROM users WHERE username="monkuar"
-0.01919 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.01833 	SELECT imgaward FROM users WHERE username="monkuar"
0.01822 	SELECT imgaward,id FROM users WHERE username="monkuar"
-0.01855 	SELECT imgaward FROM users WHERE username="monkuar"
0.01830 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.00020 	SELECT imgaward FROM users WHERE username="monkuar"
0.00015 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.00015 	SELECT imgaward FROM users WHERE username="monkuar"
0.00015 	SELECT imgaward,id FROM users WHERE username="monkuar"
-0.02048 	SELECT imgaward FROM users WHERE username="monkuar"
0.01829 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.01822 	SELECT imgaward FROM users WHERE username="monkuar"
0.00017 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.00016 	SELECT imgaward FROM users WHERE username="monkuar"
-0.01947 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.01836 	SELECT imgaward FROM users WHERE username="monkuar"
0.00024 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.00016 	SELECT imgaward FROM users WHERE username="monkuar"
0.00015 	SELECT imgaward,id FROM users WHERE username="monkuar"
0.00014 	SELECT imgaward FROM users WHERE username="monkuar"
0.00016 	SELECT imgaward,id FROM users WHERE username="monkuar"
Total query time: 0.08461 s

 

Im using imgawards mod here is a picture:

 

 

k0lk7m.jpg

 

I mean that's what i want it look like but why does it loop through the query ..

 

here is my code:

 

 

<?php

// Fetch list of topics to display on this page
if ($pun_user['is_guest'] || $pun_config['o_show_dot'] == '0')
{
// Without "the dot"
    $sql = 'SELECT t.id, t.poster, t.subject, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, p.poster_id AS last_poster_id FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'posts AS p ON (p.id=t.last_post_id) WHERE forum_id='.$id.' ORDER BY sticky DESC, '.(($cur_forum['sort_by'] == '1') ? 'posted' : 'last_post').' DESC LIMIT '.$start_from.', '.$pun_user['disp_topics'];
}
   

$result = $db->query($sql) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());

// If there are topics in this forum.
if ($db->num_rows($result))
{
while ($cur_topic = $db->fetch_assoc($result))
{
	$icon_text = $lang_common['Normal icon'];
	$item_status = '';
	$icon_type = 'e2';
$result4 = $db->query('SELECT imgaward FROM users WHERE username="'.$cur_topic['last_poster'].'" ') or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());

    
    $post_user = $db->fetch_assoc($result4);

             // Image Award Mod Block Start
            //figure out the size of the award (Name of award should be in teh form:  Test_Award_100x20.png ... where png is format, 100x20 is dimensions and Test_Award is name of award (seen in admin interface)
            $lol2=$post_user['imgaward'];

		if ($post_user['imgaward'] == "") { 
            $lol12 = "";
		}
		else {
		$lol12 = "<img src='img/stars/$lol2'>";
		}
	if ($cur_topic['moved_to'] == null)

		$last_post = '<a href="viewtopic.php?pid='.$cur_topic['last_post_id'].'#p'.$cur_topic['last_post_id'].'">'.format_time($cur_topic['last_post']).'</a><br /><span class="byuser">'.$lang_common['by'].' <a href="profile.php?id='.$cur_topic['last_poster_id'].'">'.pun_htmlspecialchars($cur_topic['last_poster']).'</a>'.$lol12.'</span>';
else
		$last_post = ' ';



		$result4 = $db->query('SELECT imgaward,id FROM users WHERE username="'.($cur_topic['poster']).'" ') or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());

    
    $post_user = $db->fetch_assoc($result4);

             // Image Award Mod Block Start
            //figure out the size of the award (Name of award should be in teh form:  Test_Award_100x20.png ... where png is format, 100x20 is dimensions and Test_Award is name of award (seen in admin interface)
            $lol23=$post_user['imgaward'];

		if ($post_user['imgaward'] == "") { 
            $lol123 = "";
		}
		else {
		$lol123 = "<img src='img/stars/$lol23'>";
		}
	if ($pun_config['o_censoring'] == '1')
		$cur_topic['subject'] = censor_words($cur_topic['subject']);

	if ($cur_topic['moved_to'] != 0)

		$subject = $lang_forum['Moved'].': <a href="viewtopic.php?id='.$cur_topic['moved_to'].'">'.pun_htmlspecialchars($cur_topic['subject']).'</a> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_topic['poster']).''.$lol123.'</span>';
	else if ($cur_topic['closed'] == '0')
		$subject = '<a href="viewtopic.php?id='.$cur_topic['id'].'">'.pun_htmlspecialchars($cur_topic['subject']).'</a> <span class="byuser">'.'';
	//monk@
	else
	{
		$subject = '<font color=red>Closed: <a href="viewtopic.php?id='.$cur_topic['id'].'">'.$cur_topic['subject'].'</a></font>'.'';
		$icon_text = '<tr class="cl bc1"> 
';
	}

	if (!$pun_user['is_guest'] && $cur_topic['last_post'] > $pun_user['last_visit'] && $cur_topic['moved_to'] == null)
	{

		$item_status .= ' inew';
		$icon_type = 'e1';
		$subject = '<strong>'.$subject.'</strong>';
		$subject_new_posts = '[ <a href="viewtopic.php?id='.$cur_topic['id'].'&action=new" title="'.$lang_common['New posts info'].'">'.$lang_common['New posts'].'</a> ]';
	}
	else
		$subject_new_posts = null;

	// Should we display the dot or not? 
	if (!$pun_user['is_guest'] && $pun_config['o_show_dot'] == '1')
	{
		if ($cur_topic['has_posted'] == $pun_user['id'])
			$subject = '<strong>·</strong> '.$subject;
		else
			$subject = '  '.$subject;
	}

	if ($cur_topic['sticky'] == '1')
	{
		$subject = '<b>'.'Pinned'.':</b> '.$subject;


	}


	$num_pages_topic = ceil(($cur_topic['num_replies'] + 1) / $pun_user['disp_posts']);

	if ($num_pages_topic > 1)
		$subject_multipage = '[ '.paginate($num_pages_topic, -1, 'viewtopic.php?id='.$cur_topic['id']).' ]';
	else
		$subject_multipage = null;

	// Should we show the "New posts" and/or the multipage links?
	if (!empty($subject_new_posts) || !empty($subject_multipage))
	{
		$subject .= '  '.(!empty($subject_new_posts) ? $subject_new_posts : '');
		$subject .= !empty($subject_multipage) ? ' '.$subject_multipage : '';
	}
	$rowbg = $rowbg == 'ce' ? 'ce bc1' : 'ce';

?>

<tr<?php if ($item_status != '') echo ' class="'.trim($item_status).'"'; ?>>
<tr class="<?php echo $rowbg ?>">
<?php echo trim($icon_text) ?>
<td align="left"><div class="<?php echo $icon_type ?>"><div class="nosize"></div></td> 

<td align="left"> <?php echo $subject ?><br><span class="desc">Objective</span></td> 
<td align="left">

<?php echo '<a href=profile.php?id='.$post_user['id'].'>'.($cur_topic['poster']).''.$lol123.'</a>' ?>


<br><span class="desc"><?php echo format_time($cur_topic['posted']) ?></span></td> 
<td align="left"><?php echo ($cur_topic['moved_to'] == null) ? $cur_topic['num_replies'] : ' ' ?></td> 
<td align="left"><?php echo ($cur_topic['moved_to'] == null) ? $cur_topic['num_views'] : ' ' ?></td> 
<td align="left"><?php echo $last_post ?></td> 
</tr>

 

See how it's in the while function? but i have to have in the while function because that way I can use my $cur_post variable for my MYSQL WHERE Clause, otherwise it wont bring up the right image,

 

Im talking about this query 

$result4 = $db->query('SELECT imgaward FROM users WHERE username="'.$cur_topic['last_poster'].'" ') or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());

 

Anyone know any ideas on how to make it's only 1 Query or maybe im doing something totally wrong?? please help thx..

Link to comment
Share on other sites
aschk Newbie

aschk

Posted
Posted

Just to clarify here, because it's a rather convoluted question: what is it you want?

Are you asking for all the open & closed items for a particular user? If this is the case, please let us know what your schema is. If this isn't the case then I think you need to clarify your question some more.

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • 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.