you can see it usually by putting something next to the closing quote in that query so if its "; you can put ss"; and it will spit out the string. You may not have any group only events? Hmm let me know I may have to add a check in it.
SELECT Bo_Keyword FROM w3t_Boards WHERE Bo_Read_Perm = '0' ORDER BY Bo_Keyword ASC
on two different threads database and I recieved no error can you try that in you phpmyadmin?
this is the line that sets it that way if ($Grouppostsquery == ""){$Grouppostsquery = "Bo_Read_Perm = '0'";}
and thats only cause there are no groups for the person who is viewing the eventspal because he isn't logged in, but if he logs in and say is in group 4 the query should be
SELECT Bo_Keyword FROM w3t_Boards WHERE Bo_Read_Perm LIKE '%-4-%' ORDER BY Bo_Keyword ASC
No error, but I don't understand why it's set to 0. I'm logged-in when I run the script. And when I comment out the line, it just returns the same error to the next line.
so thats also 0 when your logged in hmm ok.. that sheds some light on it..
only way for that to set to 0 is if $Grouppostsquery is empty that all relies on these lines..
[] if (!$user['U_Groups']) { $user['U_Groups'] = "-4-"; } $calGrouparray = split("-",$user['U_Groups']); $calgsize = sizeof($calGrouparray); $Usergroupquery = "("; $Grouppostsquery = "("; $calg = 0; $calgroupcheck = 0; for ($i=0; $i<$calgsize;$i++) { if (!preg_match("/[0-9]/",$calGrouparray[$i])) { continue; }; if ($adminmodshow == '0') { if ($calGrouparray[$i] == '1') { $calgroupcheck = 1; } if ($calGrouparray[$i] == '2') { $calgroupcheck = 2; } } $calg++; if ($calg > 1) { $Usergroupquery .= " OR "; $Grouppostsquery .= " OR "; } $Usergroupquery .= "`U_Groups` LIKE '%-$calGrouparray[$i]-%'"; $Grouppostsquery .= "`Bo_Read_Perm` LIKE '%-$calGrouparray[$i]-%'"; } [/]
so I am wondering if in fact this line $user['U_Groups'] is working for you. I have seen where some servers can get away with that line and some have to actually set it to a number like $user[2] depending on what element in the $user array has placed the groups function.
if your willing to try one more thing take any custompal box or heck even this script and somewhere towards the top place this
thats what I thought. the $user['U_Groups'] is not working for you
hmm can you try one last thing.. do a print_r($user); somewhere near the top or in an empty pal and see if you see $user['U_Groups'].. should be around the 14th element. see if you see it whether your logged in or not..
okay one more thing.. disable the eventspal.php and put the print_r($user); in any other palbox. Let me know what happens because at this point I don't know how your running threads or IIP because everything is based off the array($user).
Disable the eventspal? I put the script in an empty pal box. Maybe I'm doing something wrong. How about you attach a file for me to run and I'll tell you what happens?
I probably missed a setting somewhere...but here is a question or clarification.
Events that are added to the calendar via the "Add an Event" button (ie not related to a post) are placed in the w3t_Calendars table.
When I run eventspal, everything looks good for me. If I log in as a regular user (non-admin), they cannot see PUBLIC events that were added in this way. Is this correct, or did I miss a switch somewhere?
I downloaded the eventspal off of post #1 in this thread.
// show all Group Dates or just the users in events pal // 0 - Show all dates for okay board's for all // 1 - Show all dates for okay board's just for user $showallgroupdates = '1';
#1 - settings I had were as follows, and this is viewing as an ADMIN: $adminmodshow = '1'; $groupshow = '0'; $showallgroupdates = '0'; $birthdayshow = '0';
#2 - settings I had were as follows, and this is viewing as an ADMIN: $adminmodshow = '1'; $groupshow = '1'; $showallgroupdates = '0'; $birthdayshow = '0';
#3 - same settings as #2 above, but viewing as a regular user. FYI this Regular User is the one that added the "test" event (visible in #2)...but even though he added it, he cannot see it.
Again...not sure if anything is wrong or not, I JUST started looking through the code. Hope this might help.
I will get back to looking at this once I finish the pollpal. I am one click away from the poll pal. it can do everything but display without hitting submit twice
BTW it opens up a popup box of showday.php you can either remove the _blank from the line with showday.php in it or ask me for the popup box I used on my site at www.couch-tomatoe.cc
Will try to get this uploaded this afternoon. Mondays are crazy sometimes.
Many thanks scroungr! I started to look in here to tinker with it myself...but you know how when you write something you tend to know where the potential issue is a LOT better than if you are just sorting through code?
That is where I was...felt like I was reading without my glasses, and figured I would let the pro handle it
Allrighty - the groupshow issue seems to be resolved, that works great.
The only issues I could find all have to do with the Javascript event popups. In the Upcoming Events section...the popups do not reference any particular page or event. I thought it had to do with possibly calling /pals/showday.php, so I removed the /pals piece, still did not work.
Messing with that a bit.
Other than that, there are some minor glitches in the showday popup, and I think that could be eventspal not pushing some correct variables across. But again, I have not looked at it in depth, just tinkered with it.
I've been waiting for this to get ready. Looks like you're almost there. I've got some other fixes and such ready in IIP - so if this is good to go - I'll get it all posted.
yeah I have a popup I have on my site that pops up using calendar or events.. it use to open the ubbthreads/showday.php but that also sent the header and footer and well... so I created a showdaypal.php without footer and header...
Hmmm well I updated this one. the only difference is the settings for this version is listed in this pal and the settings for IIP's is listed in the configpal.php
I'll take another swing at it when I get home. I've been coding heavily the past two weeks trying to wrap up this project, so I can say I have at least one thing done. It's started affecting my mind... I'm writing code in my sleep again...
I had downloaded the latest IIP and then proceeded to use the previous version, since they happened to be right next to each other in my threads hacks archive. I was one file off.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.