Event Chronology Hack v1.0

[cinq]

Event Chronology Hack v1.0

Hack by : cinq
Tested and working with vb3.0.3 (earlier version untested but should work)


WHATS IT DO ?
This hack allows the administrator to maintain a listing of the past events that your site has organized.
This allows you to document past event history in a quick summary, and may be useful for potential sponsors to view.
Such events can be in the form of talks, outings, conventions, auctions, competitons, and so on. You are only limited by your imagination. As this hack uses phrases, you can easily change the context to make it suit your requirements.

FEATURES

AdminCP
Installer script

Admin options

Manage current events
- view all current events at one go
- allows for the following ( edit event - remove event - add event )

Add event has the following fields:
- event title
- event image
- event description
- event display order (to order how they will be displayed)

Fully template based, alter the 2 templates created to suit your desired layout.



INSTALLATION
This Hack is tested and working on vb 3.0.3 but should work on ALL 3.x.x versions as well.
Please read the install_readme.txt file in the package for installation instructions



DEMO SITES
Feel free to submit your sites if u installed this hack so it can be listed as another live demo site


SUPPORT
I cannot promise full support on this hack but I will try my best to fix all bugs or answer all queries. Any support offered will be done strictly through this thread.
If you are using this hack , pls click the INSTALL (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=72635) button
to be kept in the loop of any bug reports, add-ons and hack version updates.



DONATIONS
Use of this hack is entirely free but any donations are hugely appreciated if you like this hack and wish to offer something for my time.
You can donate by dropping me a private message.

Huge thanks in advance to those who donate!

[cinq]

The following are some admincp screenshots.

[cinq]

More screenies.

[cinq]

Bug Reports and Fixes

- Phrases not showing up ( fixed in v1.0 )


Feature Requests

- none.

[alkatraz]

very cool idea!

[moley]

nice one.

[Lethal]

i like this, but also, would it be possible to make a list of future events maybe like events for the next 30 days or however many days you want to show?

[Lethal]

also do you have a list of what the list will look like?

[cinq]

Thanks folks :)


i like this, but also, would it be possible to make a list of future events maybe like events for the next 30 days or however many days you want to show?
You can always add in future events too, choice is yours, just mention it in the event description part. Perhaps you can clarify in greater detail exactly what you want and I will see if it is possible ? :)

[Itworx4me]

Like your idea but I need to see what the end result is before I decide to install your hack. Visualization sells hacks. Need to have more of what the page looks like then what the back end looks like.

Thanks,
Itworx4me

[cinq]

SS uploaded as requested.
It's a rather simple layout , but remember the layout can be totally customized and determined by you. It's all in the templates :D

Future versions feature requests are also welcome. :)

[Oblivion Knight]

So I gather that this is completely separate from the Calender feature? :)

[cinq]

Yep.

[gmarik]

Loooks good

[ChrisBaktis]

All works good for me but when I go to add an event there is no description of what each input field is - now i got the info by looking at your screen shot - all the fields are present but on the left side their is no description.

[X-Sector]

great hack, ive been waiting for this one :D

[X-Sector]

Besides the fact that this is a great hack, I have some problems with it :/

It won't show what the title is in the admin CP. Screenshots:

[cinq]

I presume both ChrisBaktis and X-sector are experiencing the same problems ?
Got to do with the phrases addition, I will go through it tmr and provide a fix for it.

Thanks for the feedback folks :)

[HarryBO]

I have a little MySQL error

Datenbankfehler in vBulletin 3.0.3:

Ungueltige SQL-Abfrage:
INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'deleted_event_successfully', 'Event has been deleted successfully', 9000)

mysql error: Duplicate entry 'deleted_event_successfully-0-9000' for key 2

mysql error number: 1062

[ChrisBaktis]

yup those pictures are what I get also.

[cinq]

I have a little MySQL error
That's odd.
Is this your first installation ?

[cinq]

ChrisBaktis and X-sector, did the installation script complete for both of you guys ?

[cinq]

Have updated the zip file.
Notification has been sent to all who installed this hack. :)

[HarryBO]

Yeah I became that error at the first install! After that i delete the entry in the Database and try it again!

[HarryBO]

Now i tried to add the Querys at phpmyadmin!

Result:

MySQL meldet:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "phrase( languageid,
varname,
text,
phrasety

[cinq]

Which entries in the DB did you delete?
Also you should not be getting that error if you are using the updated attached file.
Download it again and try it out Harry :)

[HarryBO]

I´ve deleted the eventchrono. I tried the Update ---> Same error as before!

[cinq]

Give me the full error

[HarryBO]

https://vborg.vbsupport.ru/showpost.php?p=582258&postcount=19

and here

https://vborg.vbsupport.ru/showpost.php?p=582532&postcount=25

[ChrisBaktis]

That update on step 7 corrected the problem - thank you - great hack!

[cinq]

https://vborg.vbsupport.ru/showpost.php?p=582258&postcount=19

and here

https://vborg.vbsupport.ru/showpost.php?p=582532&postcount=25

The first error is because you installed more than once and the query reports duplicate entries in your phrase table.

The second is not a full error message ?

Btw.....are you using the installation script to install again or are you copying the queries and inserting them manually ....

[HarryBO]

I copy the queries and install manually!

[cinq]

Then the error is because you have


" . TABLE_PREFIX . "


in the copied SQL query.
Remove that portion as you will not have the same problem again.

[HarryBO]

It seems to be working!

Big Thx!

[cinq]

You're welcome :)

[HarryBO]

Argh!

See this error message:

Warning: copy(./images/eventchrono/back2.gif): failed to open stream: No such file or directory in /srv/www/htdocs/web2/html/talk-world/admincp/eventchrono.php on line 78

[jamesk]

Where is the end result supposed to show up?
I don't see it anywhere

[cinq]

Argh!

See this error message:

Did you follow the instructions carefully about creating the images/eventchrono folder and enabling write permissions ... ?
Installation Step 5

[cinq]

Where is the end result supposed to show up?
I don't see it anywhere

http://www.yourodmain/forumdir/eventslist.php

[X-Sector]

works perfectly now. Great hack :)

[cinq]

I might carry on work on this in the future but am right now busy with my original articles hack ( which I might release pending a few issues ).

Feature considerations for this hack include :
- past events grouping
-future events grouping
- draft an event ( pending event )
- comments system

:)

[jamesk]

Thanks cinq. Good stuff!

[stan68]

how would i go about having this show in a side bar on my site?

[cinq]

Whatya mean side bar ?

[stan68]

i have a side bar on my forum / it has a small calander vbradio ect..
i was just wondering if there was a way to have it output the image or something so i could put it on the sidebar.

so people would be able to see whats up for new events on the forum home.

[cinq]

Yes you can, but it is outside the scope of this hack.
You will need to add code to your forum index.php to query the eventchrono table, and amend the FORUMHOME template accordingly :)

[zurih]

great hack!
installed!

btw, what about page navigation? i.e: 10 events on one page.

[zurih]

anyone knows how to get the page split after X events?
links threads...

[cinq]

I will continue work on this after completing my vbArticles Hack, thanks for the suggestion zurih :)

[Gary King]

Why is the image required? It should be optional.

[Koutaru]

The pagination would be great :) That's all I really would need to compeltly install this hack! Nice!

[Titus]

This mod is exactly what I've needed at my board. It could use some improvements, certainly, but so far it's pretty good. I got annoyed with the requirement for an image for every time you added an event, so I removed it. I'm about 70% sure I only changed the one line, so if this doesn't work don't blame me. ;)

On line 93 find: else
{
print_stop_message('invalid_file_specified');
}
Substitue:else
{
$_POST['do'] = 'doadd1';
}For new features I'd like to see nested events. For use on my board each 'event' is going to be a timeslot in our RPG timeline, and the event description will be filled with the actual events. This could be made a lot easier, while yet maintaining the flexibility of this mod by allowing nested events.

[Lionel]

Is there a way to do without the image?

[cinq]

Not at the moment, but in the next version it'll be the case.