Event attendance

Request by: DaveLogic

With this hack when you create an event you can give the users an option to "register" to the event. Then you can view which people have registered to that event.

This could be used so you create an event and then other people notify that they will be attending to the event. You can then keep track of all the people that would be attending each event.

Info for hackers:
You may modify, improve, upgrade, redistribute this hack, include it
in another hack or yours or translate it provided you do it free of
charge and you distribute it in www.vbulletin.org at least, there is no
need to pm me asking for permission
Some portions of the code are (c) Jelsoft Enterprises Ltd.

[SamirDarji]

What's CVS?

[buro9]

Originally Posted by SamirDarji

What's CVS?

CVS = Concurrent Versioning System

It's used widely by software developers around the world to track and marge changes in code bases. It allows multiple developers to work on the same code, each one can see what the other has done, merge changes, view differences, etc.

SourceForge, Apache, Mozille... they all use CVS systems of some sort or other.

Microsoft use CVS systems, as does Sun, as does IBM... as does everyone.

They come in many shapes and sizes, the worst is probably Visual SourceSafe from MS, the good ones are Subversion, Perforce, Merant, WinCVS, etc.

Even Jelsoft use CVS, which is how you get those headers in the files saying the CVS file version

I am just increasingly of the opinion that as a lot of the hacks evolve thanks to the contributions of many hackers, that if the author consented, that they could be made open to all to improve, and placed within a CVS system whereby all changes can get rolled into one package for end users.

Having a CVS system for hacks would prevent the need for you to search through this thread for improvements, bug-fixes, differences, etc... as you would just fetch the latest version from CVS and that would simply be the version that featured all contributions.

[Benj]

Originally Posted by buro9

Here's the psuedo SQL:

PHP Code:

$query = "SELECT `eventid` , `userid` , `event` , `title` , `allowsmilies` , `recurring` , `recuroption` , `calendarid` , `customfields` , `visible` , `dateline` , `utc` , `dateline_from` , `dateline_to` , `useroll` , `roll`
FROM `" . TABLE_PREFIX . "event`
WHERE `roll` LIKE '%i:" . $bbuserinfo['userid'] . ";s:" . strlen($bbuserinfo['userid']) . ":\"" . $bbuserinfo['username'] . "\"%' LIMIT 0, 30"; 


That would return all events that a user was attending.

Note that the SQL matches the entire user information, as performing wildcard LIKE's are never good because if we just did the userid we might match events that had the same number of attendees as the user id... or worse, if we compared on username, there may be a user named Rob and one named RobSmith and we'd match that.

So that's the SQL... and it works... so it shouldn't be too hard to write the rest

Please, when writing the rest, bear in mind whether the event is publicly viewable, i.e. that the calendar that it appears on is viewable.

sorry im lost is any1 looking at coding this

[SamirDarji]

I haven't had a chanced to do more than glance at it. We have the psuedocode for the sql, now we just need the supporting code that will end up in the php files as well as the html templates.

[y2krazy]

Originally Posted by Pseudomizer

Sounds like a PHP problem of the post and get parameters of a HTML form. Do you have global variables on or off? This could cause this problem.

If you do not have them enabled and for security reasons, you should let them disabled, you can replace the variables with $_POST[variablenames] or $_GET[variablenames] and it should work.

Cheers,

Would be great if someone could clarify what Pseudo meant for me to do. I really would like to get this working, preferrably within the next 2 weeks! Thanks! :cry:

Original post:

Originally Posted by y2krazy

For every event in my calendar, when I click on [I will be attending this event.], it send me to a forum error message that states the following:

"Invalid Event specified. If you followed a valid link, please notify the webmaster"

This is for every event, they do not show up twice, and this is on vB 3.0.3. I've check the db via phpMyAdmin and the events exist in the correct table and rows, but they just don't seem to be called correctly with the [I will be attending this event.] link. Any help would be greatly appreciated!

It's been over a month and I still have no help from anyone. Would someone please help me figure out what is going wrong?! Thanks.

[D|ver]

is it possible to show the number of attendees of an event next to the event titel on forumhome where the next events are shown?

can somebody help me with this?

that would be really great

[SamirDarji]

I don't have time to code it, but the logic would be to count the attendees as it lists them, put that count into a variable that gets passed to the template and then modify the template to use the variable. Should be fairly easy. Someone code this.

[attroll]

buro9

Is there any chance we can get you to post a zipped file or start a new thread with all that updates and instuctions that have taken place since the owner of this mod has posted it? Since he does not seem to participate in this thread anymore.

[buro9]

Originally Posted by attroll

buro9

Is there any chance we can get you to post a zipped file or start a new thread with all that updates and instuctions that have taken place since the owner of this mod has posted it? Since he does not seem to participate in this thread anymore.

I don't know if I'm allowed to do that.

Can a mod advise whether this would be alright?

In the case where a hack is abandoned and unsupported by it's creator, is it ok for the wider community to take ownership of it and fix outstanding bugs and issues with it and re-package it in a new thread for new users to benefit from?

I wouldn't want to help you all in this way if all it results in is my getting a kick from the moderators... afterall, it works fine on my board

I can't report my own post of course, but I'll report yours so that someone reads this and can advise on whether we would be allowed to do this.

[SamirDarji]

I think this would be a good idea if the project is abandoned. I'd definitely like to be one of the coders for the revised version since my site so heavily relies on this hack. Any improvements and additions benefit me greatly and I'm willing to do my part to give back to the community.