http://www.wpwp.org/forums/tags/query WassUp Forums » Tag: query - Recent Posts en-US Thu, 09 Feb 2012 08:13:11 +0000 http://bbpress.org/?v=1.0.3 q http://www.wpwp.org/forums/search.php http://www.wpwp.org/forums/topic/no-search-queries-php-warning#post-730 Tue, 19 May 2009 18:32:23 +0000 helene 730@http://www.wpwp.org/forums/ <p>Thanks the heads up. That's one bug that we had already caught and squashed for the next revision. Let us know if you spot any more. </p> http://www.wpwp.org/forums/topic/no-search-queries-php-warning#post-729 Tue, 19 May 2009 17:30:29 +0000 dez 729@http://www.wpwp.org/forums/ <p>I modified the code. Fix if you feel necessary. Here are the lines affected.</p> <blockquote><p> if ($top_results &gt; 0) {<br /> foreach ($top_results as $top10) { ?&gt;<br /> &lt;li class="charts"&gt;&lt;?php echo $top10-&gt;top_count.': <a>top_link.'" target="_BLANK"&gt;'.stringShortener(preg_replace('/'.preg_quote($siteurl,'/').'/i', '', $top10-&gt;top_item)<br /> ,$char_len).'</a>'; ?&gt;&lt;?php } ?&gt;&lt;/td&gt;&lt;?php<br /> }<br /> else { ?&gt;<br /> &lt;li class="charts"&gt;&lt;?php echo "No Results";<br /> }<br /> } // end if topsearch </p></blockquote> http://www.wpwp.org/forums/topic/no-search-queries-php-warning#post-728 Tue, 19 May 2009 17:19:39 +0000 dez 728@http://www.wpwp.org/forums/ <p>When there are no search queries in the lightbox for the top-ten, the area fatals with this message:</p> <p>Warning: Invalid argument supplied for foreach() in ../htdocs/wp-content/plugins/wassup/lib/action.php on line 259</p> <p>This goes away when there's a valid search referrer with keyword. </p> http://www.wpwp.org/forums/topic/sql-query-to-fetch-ip-addresses-of-some-date-x#post-705 Thu, 30 Apr 2009 19:06:14 +0000 enli 705@http://www.wpwp.org/forums/ <p>Thanks for the explanatory reply, the query really helps a lot.</p> <p>Also another plugin "WP-SpamFree" sounds good too. </p> http://www.wpwp.org/forums/topic/sql-query-to-fetch-ip-addresses-of-some-date-x#post-704 Thu, 30 Apr 2009 18:23:23 +0000 helene 704@http://www.wpwp.org/forums/ <p>Nope. Nothing wrong with accessing your own data.<br /> The timestamp value for 24 hours ago is <code>time()-24*60*60</code>. If you set a variable in PHP <code>$yesterday=time()-24*60*60;</code> you can use it to build your Mysql query.<br /> ex: <code>$query = &quot;SELECT...WHERE...AND timestamp &gt;$yesterday&quot;;</code></p> <p>If you are working directly in MySql, the syntax is:<br /> <code>SELECT...WHERE...AND timestamp&gt;(UNIX_TIMESTAMP()-24*60*60);</code><br /> There are some timezone issues that I am ignoring here, but I will leave it up to you to add or subtract more seconds from "unix_timestamp()" to get exactly 24 hours worth of data.</p> <p>Good luck with your banning effort. I found it to be a lot of hard work for little gain, myself. Spammers learned years ago to quickly rotate their IP addresses and domains to get around IP and domain blocking. </p> <p>Might I suggest that in addition to WP-Ban, you add an anti-spam plugin like Akismet, add a security question or captcha to your comments via a comment or contact plugin, and possibly install another gatekeeper plugin like <a href="http://wordpress.org/extend/plugins/bad-behavior/">Bad Behavior</a> that uses a more heuristic method to find and block spammers before they get to your blog. This "triple-block" method is very effective on my own site. </p> http://www.wpwp.org/forums/topic/sql-query-to-fetch-ip-addresses-of-some-date-x#post-703 Wed, 29 Apr 2009 13:03:08 +0000 enli 703@http://www.wpwp.org/forums/ <p>Why was my previous account was deleted for no reason?</p> <p>I just need to know how to get date from wassup table.</p> <p>All i am trying to achieve is, make a query to MY OWN sql database and get the count of pagevisits of some visitor. The purpose is to ban abuser after looking for entry in <a href="http://www.projecthoneypot.org/" rel="nofollow">http://www.projecthoneypot.org/</a>. Whats wrong in that?</p> <p>Anyways, so far i have this query that will tell me number of hits by certain IP.</p> <p>SELECT count(timestamp) from wp_wassup where ip="XYZ";</p> <p>I just need to add condition that will specify to get only TODAYS hits. </p> http://www.wpwp.org/forums/topic/sql-query-to-fetch-ip-addresses-of-some-date-x#post-702 Tue, 28 Apr 2009 07:48:26 +0000 Sninnyliada 702@http://www.wpwp.org/forums/ <p>Hi, I have lots of spammers on my site and I am using wp-ban plugin to ban them all individually. For this, i need to know the IP of spammers which wassup already tracks.</p> <p>Now the problem is I dont know how to get all IP addresses of some date. I see the column timestamp in wassup table structure, but not sure how it is calculated.</p> <p>I would be great if somebody would give me a SQL query to get all visitors IP addresses of some date X, or atleast todays visitors.</p> <p>Thanks,<br /> EnLi </p>