Announcements like IPB's

[Vinspire]

Jay, i've gotten this error when i go into the sub-board

Code Select Expand

Unknown column 'ga.gaOrder' in 'field list'
File: /home/korobox/public_html/forum/Sources/MessageIndex.php
Line: 675

I am using SMF 1.1 RC 2 and this error occur only with the latest GlobalAnnouncements_0-3a.tar mod.

[JayBachatero]

Umm that error is caused by not running the query that I provided.  I fixed this in the 0-3b version.  Install that one or run the query.

[JayBachatero]

Also something that I would appreciate is it you check the help messages and so on.  I suck at explaining things at time .

[Vinspire]

Umm that error is caused by not running the query that I provided.  I fixed this in the 0-3b version.  Install that one or run the query.

I did run a query that you provide in phpmyadmin before i post up the error but it gave me an error too ....

Anyway, maybe i will try again later or maybe just use the 0.2b till the final one is out

[JayBachatero]

Can you please PM me an admin account for the forum and phpMyAdmin access.

[Vinspire]

Can you please PM me an admin account for the forum and phpMyAdmin access.

Nvm Jay ... I think i will just wait for the final release as i am not in a rush for this mod

Oh ... Thanks for the offer sir

[JayBachatero]

Umm just check if the column was added.  is best to check now since the mod uninstall leaves the tables and data.

[Vinspire]

Umm just check if the column was added.  is best to check now since the mod uninstall leaves the tables and data.

Jay, i tried ur code but it came out error that it couldn't find the query but i tried installing GlobalAnnouncements_0-3b.tar.gz and everything seems to work very fine but i dont understand ur instruction on this statement.

EDIT2: Forgot an apostrophe in a query.  Fresh file uploaded.  If you want to do a manual change do.
In GlobalAnnouncementsAdmin.php

Code (find) Select Expand


INSERT INTO {$db_prefix}global_announcements
(ID_MEMBER, time, icon, subject, body, enabled, countViews, gaOrder)
VALUES ('$ID_MEMBER'," . time() . ", '$_POST[icon]', '$_POST[subject]', '$_POST[body]', '$_POST[enabled]', '$_POST[countViews]', '$_POST[gaOrder])", __FILE__, __LINE__);


Code (replace) Select Expand


INSERT INTO {$db_prefix}global_announcements
(ID_MEMBER, time, icon, subject, body, enabled, countViews, gaOrder)
VALUES ('$ID_MEMBER'," . time() . ", '$_POST[icon]', '$_POST[subject]', '$_POST[body]', '$_POST[enabled]', '$_POST[countViews]', '$_POST[gaOrder]')", __FILE__, __LINE__);


[JayBachatero]

If you have 0.3b installed then you're good.  That was an error in 0.3.  I had '$_POST[gaOrder]) instead of '$_POST[gaOrder]')

[Vinspire]

If you have 0.3b installed then you're good.  That was an error in 0.3.  I had '$_POST[gaOrder]) instead of '$_POST[gaOrder]')

I didnt see any error ... Everything work smoothly.

[JayBachatero]

Ok so that's good.  Next release should work fine for you also.  If you ahve any errors in error log just let me know.

[JayBachatero]

Ok here is another release.  This one is just one feature addition and some code cleaning.

Ver 0.4
! Cleaned up query on MessageIndex to work with the new sorting method. (install.xml)
+ Added the ability to preview the Global Announcement before you submit it. (GlobalAnnouncementsAdmin.php, GlobalAnnouncementsAdmin.template.php, language entries)
+ Added credits page (GlobalAnnouncementsAdmin.php, GlobalAnnouncementsAdmin.template.php, language entries)

Same as before remove other mod then install this one.  If everything goes well this will be the last release before final.  Aka 1.0

[Vinspire]

Jay, is it possible to make it like a pinned topic where we could have more than 1 post in the global announcement thread ?

[JayBachatero]

Vinspire can you please explain this a bit more?  Also if it does get added it wont be any time soon.  I reached a feature frozen state and just doing bug testing and code cleaning for now.  Have a few other mods that I want to do .

[Vinspire]

Vinspire can you please explain this a bit more?  Also if it does get added it wont be any time soon.  I reached a feature frozen state and just doing bug testing and code cleaning for now.  Have a few other mods that I want to do .

What i mean is ... Is it possible to add more post in the global announcement thread ?

3 separate post in 1 global announcement thread or smthing like that coz sometimes the thread might contain a long infos you know ?

Example : The forum rules & regulations

[JayBachatero]

Oh ok I got it now.  At the moment no it's not possible.  When ever I have time AFTER final is released I'll look into it and see what I can do since it would require template changes and so on.

[ghostfreak]

What would the code changes if someone wanted this cod in a custom template?

[JayBachatero]

Ghostfreak take a look at this post.
http://www.simplemachines.org/community/index.php?topic=93129.msg663800#msg663800

[Cool Surfer]

will this feature be there is 1.1rc3 ? 

[JayBachatero]

will this feature be there is 1.1rc3 ? 

Nope.