moderate.php

[sabret00the]

just a quick question, i was just reading the script (as i need to make a moderation script) and i'm left wondering, whehter or not this could've been done so much simpler than it was done by jelsoft?

[NTLDR]

I guess it depends what your moderating. Personally I don't find moderate.php overly complex.

[sabret00the]

i just want to take some text in a database and display it, with the options to leave it in the queue, authorise it or delete, i guess my limited knowledge of php is causing problems here, i dunno i just read the script and it seemed to be doing so much more than it needed to

i expected to see;

an if //moderation is on
and a while // to show the data and give the options to moderate it

and that's it really.

[NTLDR]

You can probably get away with just adding a column to the table called visible and set it to either 1 (visible) or 0 (invisible/hidden) and add that to the where clause on the query.

eg to get all unmoderated items:

[sql]SELECT *
FROM tablename
WHERE visible = 0[/sql]

[sabret00the]

that''s how i've got the database set up, it's just a matter of getting the page in the admincp to moderate the items, i guess i'll have to stop being lazy and actually learn how to make an admincp page, to think all i need is;

 text to moderate | option to approve | option to delete | option to do nothing

that has to be a pretty easy to do

[sabret00the]

i hate the admin cp, it baffles me completely, everything is 20 times harder than coding for vB front end i just don't seem to be able to comprehend the coding, well i can kinda, i can read and understand what it's saying in the moderate.php but then it comes to applying that, it's practically impossible

[high]* sabret00the goes for a breather before heading back in for round 3[/high]

[Brad]

Just keep at it, the only way to learn is to get your hands dirty. That admin cp will look much harder to code for at first, because their is alot of extra code for html output.

[sabret00the]

thanks for that, i'll keep at it

i think my main problem is how i would've gone about it and how vb went about doing it is so different, so i'm trying to think like someone else would and it's causing problems but i'll persevere(sp:?)

[assassingod]

Originally Posted by sabret00the

i hate the admin cp, it baffles me completely, everything is 20 times harder than coding for vB front end

That's weird becaues I find coding scripts for the Admin CP so much easier than the front-end. I love coding AdminCP scripts

[sabret00the]

well i strapped on my php hat and dove right in, and it's not proving to be all that hard, bar one line that refuses to work

PHP Code:

print_label_row('<b> Posted: By </b>', iif($confession['userid'], "<a href=\"user.php?$session[sessionurl]do=viewuser&userid=$confession[userid]\" target=\"_blank\">$confession[username]</a>", "Anonymous")); 


but i think it's cos the username is stored in teh user table and the left join on the confessions table i made for the array hates me, can i do it via a left join for the array or do i need to have that as a seperate query?