PortalParts.com Site

 Forum Index > Geeklog > Misc Projects New Topic Post Reply
 glEventMgr - number of attendees?
 |  Printable Version
Blaine
 August 19 2007 19:37 PM  
Forum Admin
Admin

Status: offline

Registered: 03/01/02
Posts: 3576

Back from holidays and starting to catch up. Maybe youn can re-cap where your at now with this mod and what you need help with. Glad to hear that you found it usefull.


Please consider contributing to support my efforts ..
 
Profile Email Website PM
Quote
macwunder
 August 19 2007 21:30 PM  
Forum Junior
Junior

Status: offline

Registered: 08/12/07
Posts: 8

Hi Blaine;

Welcome back! Rested?

At this point, the mod is complete with the exception of setting the logic to get the sum of the added quantity field instead of the record count of the registered attendees (in all places... compare, display). Every time I put in a db_query to find the sum, I get sql errors telling me I can't perform the query.

Otherwise, I've got what I need.

I can zip up the project and send it (or a link) so you can have it.

Jeff


 
Profile Email PM
Quote
Dazzy
 August 20 2007 12:59 PM  
Forum Big Cheese
Big Cheese

Status: offline

Registered: 08/17/03
Posts: 191

I have a use for this too :D


Dazzy test
 
Profile Email Website PM
Quote
Blaine
 August 20 2007 20:41 PM  
Forum Admin
Admin

Status: offline

Registered: 03/01/02
Posts: 3576

Quote by: macwunder

Hi Blaine;

Welcome back! Rested?

At this point, the mod is complete with the exception of setting the logic to get the sum of the added quantity field instead of the record count of the registered attendees (in all places... compare, display). Every time I put in a db_query to find the sum, I get sql errors telling me I can't perform the query.

Otherwise, I've got what I need.

I can zip up the project and send it (or a link) so you can have it.

Jeff



Let me know what the SQL error is and if you send me your updated code, I can review it and if need refine it so it can be part of the general release.


Please consider contributing to support my efforts ..
 
Profile Email Website PM
Quote
macwunder
 August 20 2007 21:08 PM  
Forum Junior
Junior

Status: offline

Registered: 08/12/07
Posts: 8

In admin/plugins/registration/index.php, I tried to get a sum of the quantity field by replacing your line (in function displayEvents():

PHP Formatted Code
//        $registered = DB_count($_TABLES['reg_attendees'],'eid', $eid);
        $registered = DB_query("SELECT SUM(attendee.quantity) FROM {$_TABLES['reg_attendees']} attendee WHERE attendee.eid='$eid'");


I get a resource id #90 error for the output.


 
Profile Email PM
Quote
Content generated in: 0.22 seconds
New Topic Post Reply



 All times are CDT. The time is now 05:12 AM.
Normal Topic Normal Topic
Locked Topic Locked Topic
Sticky Topic Sticky Topic
New Post New Post
Sticky Topic W/ New Post Sticky Topic W/ New Post
Locked Topic W/ New Post Locked Topic W/ New Post
View Anonymous Posts 
Anonymous users can post 
Filtered HTML Allowed 
Censored Content