cotonti.com : Announcments at the top

Trustmaster

вт, 21 июл 2009 23:40:33 -0000

I did not tend to affect active/popular topics. What that plug does is brings topics in this order:

Announcements
Sticky
Others
Locked

As active/popular topics are considered just "normal". They don't have special status, they only have different icon.

KillerSneak

вт, 21 июл 2009 23:23:43 -0000

Looks like it's working half.

You can see it's not showing the newest active topics ontop, altough it does finnaly have sticky's ontop :)

Trustmaster

вт, 21 июл 2009 14:50:10 -0000

That sounds a bit strange because

ORDER by ft_"
.$o." ".$w."

is still applied, so it should sort by date within of those 4 groups.

Yes, forum filters might stop working. I can't guarantee everything is fine with such a dirty hack. Seditio/Cotonti topic state/structure flags don't allow you to do it in a neat way.

Kingsley

вт, 21 июл 2009 07:40:22 -0000

I find it rather disappointing form KillerSneak and Kilandor to beat eachother up like that. There was no need for it. There's enough shit in the world, so can we keep this place friendly? Mkee, thanks.

NOW KISS AND MAKE UP :p

@Trust

Thx dude, apriciate your troubles..

KillerSneak

вт, 21 июл 2009 07:27:49 -0000

Code still doesn't work as it should it's working half:

* Forum filters don't work at all anymore (Topics / Started | Last post | Posts Views)
* The newest post now go down the list instead of up (so newest post get's at the end of the list and not beginning)

Trustmaster

вт, 21 июл 2009 05:02:22 -0000

This code is for 0.0.6, sorry. 0.0.5 doesn't have poll_code. The query for 0.0.5 would be just:

$sql = sed_sql_query("(SELECT t.* FROM $db_forum_topics AS t
WHERE t.ft_sectionid='$s' $cond
AND t.ft_sticky = 1 AND t.ft_state = 1
ORDER by ft_".$o." ".$w.")
UNION
(SELECT t.* FROM $db_forum_topics AS t
WHERE t.ft_sectionid='$s' $cond
AND t.ft_sticky = 1 AND t.ft_state = 0
ORDER by ft_".$o." ".$w.")
UNION
(SELECT t.* FROM $db_forum_topics AS t
WHERE t.ft_sectionid='$s' $cond
AND t.ft_sticky = 0 AND t.ft_state = 0
ORDER by ft_".$o." ".$w.")
UNION
(SELECT t.* FROM $db_forum_topics AS t
WHERE t.ft_sectionid='$s' $cond
AND t.ft_sticky = 0 AND t.ft_state = 1
ORDER by ft_".$o." ".$w.")
LIMIT $d, ".$cfg['maxtopicsperpage']);

KillerSneak

вт, 21 июл 2009 03:59:45 -0000

Fatal error : SQL error : Unknown column 'p.poll_code' in 'on clause'

Seems to be an error with the plugin it doesn't work. Above code is the error i get

tensh

вт, 21 июл 2009 00:59:20 -0000

Trustmaster, you're my idol :0)
Seriously, I wish I had brains for such fast coding as you have.

KillerSneak

пн, 20 июл 2009 22:06:11 -0000

Well thanks again Trustmaster atleast someone understands me Ill try this asap when i get home today and report back. Ill try the plugin version asap. I'm glad someone here is able to give a reasonable responce and be clear about it in the same post. Again thanks, people should take an example from you.

Trustmaster

пн, 20 июл 2009 21:25:24 -0000

Actually the way sticky/lock/annoucnement is designed, you can't do it with a simple query because if you use:

$sql = sed_sql_query("SELECT t.*, p.poll_id FROM $db_forum_topics AS t LEFT JOIN
$db_polls AS p ON t.ft_id=p.poll_code  WHERE t.ft_sectionid='$s' $cond AND (p.poll_type='forum' OR p.poll_id IS NULL)
ORDER by ft_sticky DESC, ft_lock DESC, ft_".$o." ".$w."
LIMIT $d, ".$cfg['maxtopicsperpage']);

It will show announcements on top, then locked topics and after that normal topics. The only obvious solution for me, without changing the database, would be a spaghetti UNION query like:

$sql = sed_sql_query("(SELECT t.*, p.poll_id FROM $db_forum_topics AS t LEFT JOIN
$db_polls AS p ON t.ft_id=p.poll_code  WHERE t.ft_sectionid='$s' $cond AND (p.poll_type='forum' OR p.poll_id IS NULL)
AND t.ft_sticky = 1 AND t.ft_state = 1
ORDER by ft_".$o." ".$w.")
UNION
(SELECT t.*, p.poll_id FROM $db_forum_topics AS t LEFT JOIN
$db_polls AS p ON t.ft_id=p.poll_code  WHERE t.ft_sectionid='$s' $cond AND (p.poll_type='forum' OR p.poll_id IS NULL)
AND t.ft_sticky = 1 AND t.ft_state = 0
ORDER by ft_".$o." ".$w.")
UNION
(SELECT t.*, p.poll_id FROM $db_forum_topics AS t LEFT JOIN
$db_polls AS p ON t.ft_id=p.poll_code  WHERE t.ft_sectionid='$s' $cond AND (p.poll_type='forum' OR p.poll_id IS NULL)
AND t.ft_sticky = 0 AND t.ft_state = 0
ORDER by ft_".$o." ".$w.")
UNION
(SELECT t.*, p.poll_id FROM $db_forum_topics AS t LEFT JOIN
$db_polls AS p ON t.ft_id=p.poll_code  WHERE t.ft_sectionid='$s' $cond AND (p.poll_type='forum' OR p.poll_id IS NULL)
AND t.ft_sticky = 0 AND t.ft_state = 1
ORDER by ft_".$o." ".$w.")
LIMIT $d, ".$cfg['maxtopicsperpage']);

(it is system/core/forums/forums.topics.inc.php at line 311).

The last one will work for you, but speed is the price.

Added 3 minutes later:

And you could do it without a corehack, with a plugin:

Call it ft_order.topics.php and supply the ft_order plugin with some simple ft_order.setup.php file.

Added 5 minutes later:

And here is your ft_order plugin. I hope it is a good lesson to everyone here. Have a nice day.

KillerSneak

пн, 20 июл 2009 21:12:54 -0000

Again, your still posting useless crap, Do you have anything usefull to say / add? Or is crap posting the only thing your good at?

And try me @ programming never said i can't programm, said I don't see the use of having a friggin forum for a CMS that can't answer normally asked questions for "PEOPLE WHO CAN'T CODE" and I'm not talking about myself here.

making a friggin plugin for Cotonti is a piece of cake, and yes i can do it within 2 mins so WTF are you talking your BS for again adding that it can't be done. If you can't code a plugin for Cotonti within 2 mins you shouldn't be calling/naming yourself coder(s)

musiconly

пн, 20 июл 2009 21:05:46 -0000

Then go back to neocrome community where "CMS developer" was listening to the community! No one's going to stop you!

In case you havent noticed(though it would be hard to notice with your head stuck up in your ass), COTONTI is implementing all those features that ex Neocrome community was desperately expecting in THE GREAT 125 version (subforums were the most expected thing and they got excluded from that version).

To make myself clear, I DONT TALK SHIT ABOUT OLIVIER, NEOCROME OR SEDITIO. Olivier did a great job, developed LDU, progressed with SEDITIO but he just didn't have enough time (due to his job obligations and his growing family) to include new things in Seditio and that's why community started to suffer.
He also gave a green light for the development team of Cotonti, and I can't thank him enough for that.

Cotonti is going in the right direction, but you don't seem to like it.

You also have the wrong perception of donations - people aren't supposed to jump every time you say jump just because you donated some €. It's a gift for which you don't expect anything in return. If you think that is the way it's supposed to be, than please, keep your money for yourself.

If you dislike this community, I'd kindly ask you to leave. I don't see the reason for your staying since you think that "so called light CMS" and people who are working on it are worthless piece of garbage who only care for themselves. Have you seen Trustmaster's new Ferrari? He got it by working on this project. Heck, Kilandor is even buying a new house. That's the third one he bought since he started working on "so called" CMS.

Programming is the thing I wont discuss with you because you don't know anything about it. Whipping up something in 2 minutes?

KillerSneak

пн, 20 июл 2009 19:54:16 -0000

# Kilandor : Well, I really dislike your attitude KillerSneak. First I don't see where you have donated to Cotonti or Neocrome. As well I can't say for neocrome for sure if you donated or not, I know without a doubt you haven't donated any money to Cotonti, as I am the maintainer of that.
http://www.cotonti.com/donate
http://www.neocrome.net/plug.php?e=services

On another note, everyone helps out when they can, maybe someone doesn't know how to do this, or they don't have the time.

I started out with Seditio not knowing a thing, and this is where I am now.

If you need something urgent done for your site you have 2 options, learn yourself, or pay someone. People will help you when/if they can, but no one is obligated to help you.

As for what you want, it will require more than just a minor little thing. You basically need a plugin that queries specifically announcements and or stickies. While it is simple, its not something someone can whip up in 2 minutes. As also they have to change the normal query some how to exclude announce/stickies some how.

So you either have to wait for someone to do this, learn how to yourself, or goto the offers forum and offer to pay someone to do it.

So you assume just because i don't want my name in that list no money was send? hmmm good attitude you have there yourself. Glad we got that sorted out as I don't like you neither. You know without a doubt your talking more shit out your mouth than your ass now.

Glad SEDETIO 1.25 is back on track as with your attitude, and all the miss information (wtf listening to the commnunity / making the CMS for the community etc etc etc all of this was/is BS as you guys are making what you want and don't listen to the community at all. This shows, as best plugs/idea's and add-ons came from the community and not you guys who keep adding shit to this so called "light weight" CMS.)

And WTF is this attitude with HAVE TO LEARN YOURSELF. I come here because you guys are the so called CMS developers and should know your CMS code from head / within 2 mins. So your BS lame remark "its not something someone can whip up in 2 minutes" is outmost BS as you should be able as DEVELOPER OF YOUR OWN CMS to "whip" it up within 2 minutes without even doing your best THIS AGAIN SHOWS!! the false remarks about being here for the community.

Kilandor

чт, 16 июл 2009 08:35:22 -0000

Well, I really dislike your attitude KillerSneak. First I don't see where you have donated to Cotonti or Neocrome. As well I can't say for neocrome for sure if you donated or not, I know without a doubt you haven't donated any money to Cotonti, as I am the maintainer of that.
http://www.cotonti.com/donate
http://www.neocrome.net/plug.php?e=services

On another note, everyone helps out when they can, maybe someone doesn't know how to do this, or they don't have the time.

I started out with Seditio not knowing a thing, and this is where I am now.

If you need something urgent done for your site you have 2 options, learn yourself, or pay someone. People will help you when/if they can, but no one is obligated to help you.

As for what you want, it will require more than just a minor little thing. You basically need a plugin that queries specifically announcements and or stickies. While it is simple, its not something someone can whip up in 2 minutes. As also they have to change the normal query some how to exclude announce/stickies some how.

So you either have to wait for someone to do this, learn how to yourself, or goto the offers forum and offer to pay someone to do it.

musiconly

ср, 15 июл 2009 22:02:28 -0000

1. Don't talk about money cuz you also don't know how much any of members invested/donated/paid

2. I talked about effort you put in this corehack/plugin/modification, not the effort you put in the community or something else.

3. No, I haven't heard you asking for anything in return for your 200+ donations. They are called donations, aren't they?

4. This is the thing between my point of view, and yours. You don't have to generalize everyone here and call them self fed just because I am.

5. When i first started with Seditio, I didn't have any PHP or MYSQL knowledge. I'm not saying that I'm master of PHP now, but I can do some small PHP modifications on my Sed site. I mainly learned because the lack of support, but thank god Lombi, Kilandor, Trustmaster, oc, Stam and other members were kind enough to point me in the right direction.

There is no need for deleting your account, this site is big enough for the two of us.

I don't know why you feel insulted, I was just referring you to the right direction because as you might have noticed, no one else offered you a solution

KillerSneak

ср, 15 июл 2009 21:14:38 -0000

No efford? I for sure know I have put more money into this than most of you !! And you come and claim here without any knowledge what so ever and tell me i don't?

Have you ever heard me to ask anything in return for my 200+ eu donations I have made in total across the years for Neocrome and Cotonti? So 3 questions for 200 Eu while i could have asked one of the many php communities for 10eu to write me a plugin so thats the worst 200 Eu's ever spend if the Cotonti DEV TEAM & COMMUNITY can't even answer/help me with the 3 most simple questions ever here. Show's how self fed most of you are.

And does it seem to you I have PHP knowledge? This is for sure the last time I ask for anything here with the useless crap you keep posting. I would like to ask friendly for an admin/mod to delete/close my account and wish the Cotonti team the best of luck I for sure won't recommend Cotonti to anybody anymore nor will I be making any more donations in the future.

musiconly

ср, 15 июл 2009 19:55:41 -0000

# KillerSneak : (also a note/point why COTONTI won't make it big time as the community isn't real helpfull tbh)

and what do you expect? everything on golden plate?

Team is working their a*** off, most of members are on holidays and I believe that you learned on Neocrome that guys will help you - but only when you show that you made some effort (like started coding, but you got stuck because you don't know how to hide sticky posts when you already made them appear separated above the forum, which is btw something i did last night).

You never made any effort, you only kept asking 3 questions again, again and again.

So far, you could have learned a bit of php and sql and try to do it, so when you're stuck on SPECIFIC problem, ask someone here to help you out.

NHF, I don't want to argue, but that's just my point of view.

tensh

ср, 15 июл 2009 18:46:02 -0000

The development Team works pretty hard as far as I see in Trac. Don't blame them, there should be more coders in our community anyway. The bigger community, the better help.

I'll try to come up with something as far as your solution is concerned.

EDIT

Solution to distinguish the rows... logic blocks.


blabla

It will allow you to change the whole row look and feel :P

Now I think that thing you want might be written in a plugin, I'll check this out.

KillerSneak

ср, 15 июл 2009 17:14:58 -0000

# Dyllon : honestly that is not hard to achieve at all, and a lot more people than just spartan could post that really quickly. i used to have a core hack on all of my sites to do this just because i thought it looked better, although i dont have the code anymore. but it really isnt that hard..

you just have to manipulate the sql query to seperate the ft_sticky, and the ft_stick/ft_lock. you could even add a whole new section in the tpl just for announcments.

im not really into the whole coding scene anymore, i kind of just float around to give advice where needed or i would whip it up and post it here, but im sure anyone who has even a little php knowledge could show you this fairly easily.

Well if you could help me i would be more than glad to invest some $$$$ as most answers here on the forums are useless and raise more questions than answers (also a note/point why COTONTI won't make it big time as the community isn't real helpfull tbh)

Dyllon

вт, 14 июл 2009 09:10:20 -0000

honestly that is not hard to achieve at all, and a lot more people than just spartan could post that really quickly. i used to have a core hack on all of my sites to do this just because i thought it looked better, although i dont have the code anymore. but it really isnt that hard..

you just have to manipulate the sql query to seperate the ft_sticky, and the ft_stick/ft_lock. you could even add a whole new section in the tpl just for announcments.

im not really into the whole coding scene anymore, i kind of just float around to give advice where needed or i would whip it up and post it here, but im sure anyone who has even a little php knowledge could show you this fairly easily.

musiconly

пн, 13 июл 2009 22:02:29 -0000

Seditio 125.

NOTE: All the posts in that section were just regular posts ( NO STICKY OR ANNOUNCEMENTS). I played with them just for you to show you that stickys and announcements are placed ABOVE the regular posts.
And, as you can see, the new post is placed under last sticky one.

You got yourself an answer in your older posts, browse through them.

I KNOW THAT you are looking for a SKIN way of separation, and on that question no one here except maybe Spartan could give you the exact guide because he has it on his site villagaming.

I also referred you to the "Invest" option, which could probably get you a fast solution but you need some $$$.

And last tip: get a freelancer!

KillerSneak

пн, 13 июл 2009 18:14:06 -0000

# musiconly : your posts were always referring to closed topics at the end of the forums, which isn't case at any CMS or FORUM system.. and that was my point..

as for the announcements on the top of the forums and sticky ones i believe that's the case in seditio..

what you are looking for is separation between sticky and normal posts, and that's probably not something that all users want.

It's not the case, unless i have to change something (i don't know about) in the admin panel and it's not described anywhere. My topics are always about the same as none of the dev's/users/contributors can give a normal clear answer but like you always refer to other posts so yes ill keep asking the same questions unless someone can and is willing to help me.

musiconly

пн, 13 июл 2009 03:20:20 -0000

i don't know.. i never managed to find it.. i know that Spartan has it done (villagaming), but he never shared his code..

pieter

вс, 12 июл 2009 19:41:24 -0000

I thought at Neocrome there was once a topic about this with a core hack.

musiconly

вс, 12 июл 2009 16:41:18 -0000

# KillerSneak : once again what? What's your point? You don't see the block with Announcements at the top? Those will always be ontop like they should be.

your posts were always referring to closed topics at the end of the forums, which isn't case at any CMS or FORUM system.. and that was my point..

as for the announcements on the top of the forums and sticky ones i believe that's the case in seditio..

what you are looking for is separation between sticky and normal posts, and that's probably not something that all users want.

Kingsley

пт, 10 июл 2009 19:45:08 -0000

I think KillerSneak means something like this:

http://www.vilegaming.com/forums.x/3

See that the sticky posts are above and a bit seperated from the normal posts.

I'd like to see this feature to, at least for sticky and announcements.. I do not care about locked posts, but it would be nice to see a separation of sticky and announcements..

KillerSneak

пт, 10 июл 2009 18:10:03 -0000

once again what? What's your point? You don't see the block with Announcements at the top? Those will always be ontop like they should be.

musiconly

пт, 03 июл 2009 03:14:30 -0000

http://img44.imageshack.us/i/lockedz.jpg/

once again..

KillerSneak

чт, 02 июл 2009 15:58:30 -0000

Like my closed topics at the end (and the statement that no other CMS has this isn't true)

I would also like to have Announcements always at the top like they are supposed to. Now if you post a Announcement and a new post get's posted it get's posted above the Announcement.

Shouldn't it be

* Announcement - Always at the top of forums like any otehr CMS
* Sticky - Always under the Announcements but above the posts
* post - Always above the locked but under Announcements / sticky
* locked - Always at the end of the forums (what isn't the case and won't be done?)

Like here for instance: http://forums.mushkin.com/phpbb2/viewforum.php?f=11