cotonti.com : [HELP][WIP] Plugin: User Comments

musiconly

Zo, 25 Okt 2009 19:30:16 -0000

Thanks Koradhil for a great explanation Now I finally get that sed_import part (I always wondered where it's used).

I'm not a PHP programmer (C++ is my playground), but I forced myself to learn it because of some mods/plugs that I'll need for my website.

If I get stuck on another thing, I'll post it here

GHengeveld

Zo, 25 Okt 2009 05:58:41 -0000

You need to import the $ui variable from GET, otherwise your query won't work. Also it's better to cast or check any variables used in an SQL query. Integers should be cast using (int)$variable and strings need to be prepped using sed_sql_prep(). Another minor detail is that you shouldn't put quotes around an integer, since that would require it to be converted from string to integer.
Try this:

$ui = sed_import('ui', 'G', 'INT');
$sql2 = sed_sql_query("SELECT * FROM $db_com WHERE com_authorid=".(int)$ui);

For the rest of it, it's looking good, keep it up. Glad to see my guide gets used too

musiconly

Zo, 25 Okt 2009 04:38:00 -0000

I caught some god damn cold and I'm stuck at home on saturday night Anyways, I decided to use it for a learning session.

I'm trying to create a plugin which I called User Comments.

Features:

I got stuck!!!

I got the count part working It shows total count of user comments and when you click on that number it takes you to /plug.php?e=usercomments&ui=USERID.
I can only see the content of div "You look like you did before", but no ROW data?

What did I miss?
I'm reading Koradhil's tutorial on plugins
Thanks