Messages

1

WP-PostRatings / Re: Parenthesis necessary for inner joins on get_highest_rated_category?

« on: 04 August 2008, 10:49 »

Thanks for the info

2

WP-PostRatings / Parenthesis necessary for inner joins on get_highest_rated_category?

« on: 04 August 2008, 01:17 »

Hi Lester,
Thanks for your plugins, I learn a lot from poring through your code. I have two questions about get_highest_rated_category's sql query:
Why do you use left join here:

...FROM $wpdb->posts LEFT JOIN $wpdb->postmeta...

instead of INNER JOIN?

Also, later in the query, (as well as in other queries for other functions,) sometimes your join predicate is in parentheses, but sometimes not. Of course I understand parenthesis when used for nesting and grouping, but I was wondering if they were necessary in cases like this, taken from function get_highest_rated_category:
SELECT....
FROM $wpdb->post
LEFT JOIN $wpdb->postmeta AS t1 ON t1.post_id = $wpdb->posts.ID ....
INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships_id)

See, on that first join there's no parentheses on the join predicate. But later in the query, on the INNER JOIN, there's parentheses.
Is there a significance to have parentheses in the one but not the other?

thanks

3

WP-DBManager / Re: Warning: gmdate() expects parameter 2 to be long, string given...

« on: 30 May 2008, 22:23 »

Yeah - removed them, and now no errors

4

WP-DBManager / Warning: gmdate() expects parameter 2 to be long, string given...

« on: 30 May 2008, 05:12 »

In the Manage Backup DB page of DBManager v2.30:
Warning: gmdate() expects parameter 2 to be long, string given in C:\Practicesite\wordpress\wp-content\plugins\wp-dbmanager\database-manage.php on line 174

And it prints this error twice.

5

Chit-Chat / Re: Are the current wp2.5 plugin betas mostly finished?

« on: 30 April 2008, 19:44 »

Ok Thanks

6

Chit-Chat / Re: Are the current wp2.5 plugin betas mostly finished?

« on: 29 April 2008, 20:06 »

Will the additional features change the core functionality of postratings and postviews, as they are now?
Or will it be more like having a new brand new feature that can now be enabled?

7

Chit-Chat / Re: Are the current wp2.5 plugin betas mostly finished?

« on: 28 April 2008, 22:16 »

I'm asking about postratings, pagenavi, dbmanager, and postviews.

8

Chit-Chat / Are the current wp2.5 plugin betas mostly finished?

« on: 28 April 2008, 08:23 »

Are they in the stage where the core is done, and now it's just a matter of smoothing out little bugs here and there?
Or are there major changes planned before final release?

9

WP-PostRatings / Re: I think global $post can be avoided:

« on: 26 March 2008, 02:29 »

Oh, alright.

10

PHP + MYSQL / Re: Need help writing a simple plugin that puts it's link in admin dashboard

« on: 26 March 2008, 02:26 »

That second link had everything! Thanks, didn't know that page would so explanatory.

11

PHP + MYSQL / Need help writing a simple plugin that puts it's link in admin dashboard

« on: 24 March 2008, 03:45 »

Hi, I was wondering if anyone could help me write a very simple wordpress plugin. I understand php decently, but wordpress's hooks and api's and such are beyond me atm.
Anyways, all I need is to be able to put a link in the top row of the admin dashboard, right after Options, like were wp-ratings puts it's link.
Then, when I click this link, it'll run my code that I have put in the plugin's file. That's it!

Anybody?

TIA

12

WP-PostRatings / I think global $post can be avoided:

« on: 24 March 2008, 03:39 »

In the functions available in this great plugin, such as get_most_rated(), the global $post object is used in order to be able to use wordpress functions like get_the_title() and get_permalink() to get the post's title and url... however, you can just reference the guid and post_title keys in the array instead, thus avoiding having to declare global $post. Then, these functions can be used inside a loop.

For instance, take a look at lines 509, 511, 515, and 517 of postratings.php. This is in the get_most_rated function. (I use notepad++ for editing, it has built in line counts in the margin).

Now, instead of $post_title = get_the_title(); use $post_title = $post->post_title;
(You might want to wrap $post->post_title with htmlspecialchars just in case).
And instead of get_permalink() to get the url, use $post->guid

Now, get_most_rated() doesn't need to declare the global $post, so now it can be used safely while inside a loop.

13

Site & Forum Issues / Hey Lester, 2 suggestions for all future plugins:

« on: 08 October 2007, 05:00 »

I assume that for most people, if they use 1 of your plugins they probably use more than 1. This causes crowding of the admin dashboard, since there's all these links to your plugin's admin pages along with admin pages from all the other plugins they're using.

So suggestion #1, is to configure all your plugins to install their admin pages under one umbrella page, let's say, "Gamerz Plugins", and put that link in the dashboard right after 'Options' (where 'Ratings' is right now). Each plugin must carry the code to create that main directory if it does not already exist. Now your collection of plugins feels like a suite of plugins. Which then paves the way for suggestion #2:

Include a link to your donation page at the bottom of every plugin's admin page.

The only problem I can see with the umbrella page, is whether the dashboard architecture allows you to have subpages of a subpage.

Anyways, good luck on that and thanks for the great stuff

14

WP-PostRatings / Re: What's the "Max Ratings" option for?

« on: 16 September 2007, 06:07 »

Yes, solved, thanks!

15

WP-PostRatings / Re: What's the "Max Ratings" option for?

« on: 12 September 2007, 05:26 »

Ah, thanks.

16

WP-PostRatings / What's the "Max Ratings" option for?

« on: 12 September 2007, 03:49 »

After that number it stops taking ratings, but you can still rate?
Or it stops taking ratings altogether? Or something else?

I'm setting up my install in a production environment, so all my posts only get rated a maximum of once (by me).

Also here's a suggestion: in the sort page where you can see all the ratings, it would be nice if the posts had their links included so the admin could go direct to the post.

Thanks for the great stuff!

17

WP-PostViews / Re: how to remove the - views part?

« on: 25 May 2007, 21:48 »

THANKS LESTER!

18

WP-PostViews / Re: how to remove the - views part?

« on: 25 May 2007, 17:58 »

can u clarify a little?

a) I don't need to mess with the snippet line since I'm not using wp-stats
b) deleting $post_views from the other line won't have any adverse affects on the count or anything else

Am I correct on both?

TIA

19

WP-PostViews / Re: how to remove the - views part?

« on: 25 May 2007, 01:37 »

Now it shows
- n

If I delete the - $post_views part, then the number count doesn't show up either,  and now it's where I want it to be.

However, there's a similar line in the php file but it refers to snippet_chars... should I alter that line as well?

Also,  will deleting the $post_views var from that line have any adverse affects on the count or anything else?

TIA

20

WP-PostViews / how to remove the - views part?

« on: 23 May 2007, 22:03 »

Hi,

Great plugin  - I use it to display the most viewed posts in the sidebar. However, since the count increments immediately, sometimes ppl click a whole bunch of times just to push a post up the list for no reason.
So, I'm wondering how I could delete the part after the post's link, where it shows:
- X views

then there's less incentive to madly click.
TIA