UBB.Developers Forums UBB.threads 6 V6 Modifications Forum Design Integration Integrated Index Page (IIP) 5.3.1

Use phpmyadmin and select the table to drop and drop it.

sorry Dave ya lost me allready.Where is phpmyadmin?
I have WinMYSQLAdmin but I dont see where to drop the table

Ahhh sorry I asked the wrong question. You are in deed on a windows machine but not running IIS. I'll upload an updated IIP 5.3 zip in a moment that will check for both upper/lower case table names. This should keep this from happening again.

Hehe oh well I figured out what PHPMyAdmin is and I downloaded it but have yet to install it.Should I go ahead and do that and then drop the table and start over or just download your updated IIP?

I'm going to update the zip after this post. Download it and give it a try and let me know if it works. Hopefully this will help others in the same situation.

*bump*

Updated IIP.modifydatabase.php to check for both upper and lower case table names just in case we are being used on a windows machine. Thanks for finding this one ChAoS.

I hate being "Special" sometimes

I will reupgrade after this post.Thanks for pointing me to PHPMYSQLAdmin.I want to learn more about managing SQL databases and working with PHP anyway. Added to the list of things to do

After running again this is what I get

Upgrading IIP 5.1 cache to 5.3 cache...
Upgrade completed.

Modifying w3t_Users to allow for optional enhanced 'Last Seen' tracking.
SQL ERROR: Unable to do_query: ALTER TABLE w3t_Users ADD U_LastSeen INT(11) UNSIGNED
Duplicate column name 'U_LastSeen'Modification completed.

Hmm..If you look at my page everything seems to be working except for the last seen section.It seems to be blank

The duplicate column may have already been installed the first time you ran the script and it thought that the cache table didn't exist. It should be working for you now.

Last seen column still isnt showing any data. I do have PHPMYAdmin installed and working now though

You will need to follow the additional instructions located in the Last Seen area of IIP's configure panel. Additional code needs to be added to ubbt.inc.php to fill the new field.

phpMyAdmin makes life much simpler with the database.

These are the only additional instructions in the "Last Seen" section
[]
You need to run the "Modify My Database" link in initial setup before using this step.[/]

What did I miss

*Update* I reset enhanced tracking to "0",Updated the config then changed the variable back to "1" and that solved my problem.

Thanks for all your help Dave

You should see something like this in the "Last Seen" area:

Use enhanced tracking? 1=yes 0=no
Before using this option you must follow THESE setup instructions or this WILL NOT WORK CORRECTLY!


Click on the THESE link to view the additional instructions.

I'm glad you got it all going smoothly now.

Others using windows machines will be thankfull for your trail blazing.

Sorry Dave my mistake.advanced tracking doesnt work on my page at the moment. These are the only instructions from that link.

You need to run the "Modify My Database" link in initial setup before using this step.

Did you forget to write the instructions?

[]Others using windows machines will be thankfull for your trail blazing.[/] Do I hear Unix laughter in the background?

LoL you know I probably need to fix that script as well. I'll take a look right now.

LoL ok Unix laughter is over..

I updated the zip to include a new lastseensetup.php file that will take into account upper and lower case table names as well.

Download the zip and upload that file and try that link again.

There are two lines in ubbt.inc.php that match

$phpurl = $config['phpurl'];

Do I add that code above both of those lines?

// If they aren't logged in they get the standard menu
// ================== IIP "Last Seen" code change START.
$date = $this -> get_date();
$query = "
UPDATE {$config['tbprefix']}Users
SET U_LastSeen = $date
WHERE U_Number = '{$user['U_Number']}'
";
$dbh -> do_query($query);
// ================== IIP "Last Seen" code change END.
$phpurl = $config['phpurl'];




// We need to check for a temporary cookie and if we don't find
// one then this is their first visit for that browser session
// so we get rid of the TempRead values in their profile
if ( !${$config['cookieprefix']."w3t_visit"} ) {
$date = time();
$query = "
UPDATE {$config['tbprefix']}Users
SET U_Laston = $date,
U_TempRead = ''
WHERE U_Username = '$Username'
AND U_Laston < ($date - 14300)
";
$dbh -> do_query($query);
}
// ================== IIP "Last Seen" code change START.
$date = $this -> get_date();
$query = "
UPDATE {$config['tbprefix']}Users
SET U_LastSeen = $date
WHERE U_Number = '{$user['U_Number']}'
";
$dbh -> do_query($query);
// ================== IIP "Last Seen" code change END.
$phpurl = $config['phpurl'];

Hmmmm... guess I need to change that. Place the code after these lines:



That should do it.

Ok now we are cooking with Oil.
Its all working good (I think)
What is enhanced tracking anyway? I can't find the difference yet.

Oh and what are you doing up so late Dave?

hehe thanks for all the help

Enhanced tracking will record registered users "last seen" time with every call to send_header. It's way more accurate than using the U_Laston field that is updated by .threads. There wont be many users showing up at first because their fields are not updated yet with a time stamp. This will happen when they visit.

Me? Up late? Never!

LoL well actually tonight I'm cleaning things up around here some.

LOL

Dave NEVER sleeps. He sleeps less than me, and I NEVER sleep. LOL

LoL looking around here lately I don't think any of us are getting the daily allowance on shut eye... LoL

I'm having wierd problem at Shoutbox

I configured the shoubox option as below:

* Should we allow unregistered users to use the shout box? (Yes)


* Should we allow unregistered users to specify a nickname with the shout? (No)

When guest click the "SHOUT" button, they gets "please enter your name...." massage.

But if guest hit the "Enter" on the keyboards, it works normally..

You can see it here
http://www.doobic.co.kr

Thanks
Junhyok

I may need to go over the javascript for the shoutbox again. I had made some changes earlier in this area which may have affected this.

I'll let you know what I find/fix.

Thanks Dave.

Junhyok

I have an issue where if I navigate away from a page of posts that have not been read and then subsequently return to that page that the unread posts will end up being marked read. I noticed that this happened in the previous version of IIP/Threads also.I believe it didnt start happening until after the IIP install. It really creates havok when I have 200 unread posts that dissappear. I haven't actually documented the sequence of events leading up to this yet but I will the next time it happens and I will post.

That's actually a threads thing, IIP doesn't do anything with read/unread... the new posts within threads are not tracked individually.... (too intensive) it's the postlist.php page that actually marks them read. So if you visit the postlist page, those posts will *typically* be marked read. They system is not perfect yet.

Hi Again, I got sidetracked at work and had to leave the iip for a while... Anyways, I got back onto trying to make it work today and I tried that compare program that you suggested and a lot of files were different, So I uploaded everything again and now I get new errors... eek

here goes:
SQL ERROR: Unable to do_query: SELECT Ca_TimeStamp,Ca_ShortStats,Ca_TopPosters,Ca_LastSeen,
Ca_LastSeen2,Ca_RandomProfile,Ca_TopThreads,
Ca_CurrentThreads,Ca_HotTopic,Ca_TopRatedPosts,Ca_News,
Ca_PastThreads,Ca_CustomB1,Ca_CustomB2,Ca_CustomB3,
Ca_CurrentPollName,Ca_CurrentPollVote,Ca_CurrentPollResult FROM w3t_IIPcache WHERE Ca_Number = 1
Unknown column 'Ca_LastSeen2' in 'field list'
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\wwwthreads\mysql.inc.php on line 130

and loads of other errors at the bottoms of the page...
Any ideas? Is my database ok?

Thanks.



Laura

Is this board we are using the result of the Integrated Index Page or are there more modification here?

Is this how it is going to look?
Looks very nice.
I would only change it to ad a link for last posts in 24, 48, and one week on top... many use that feature...

Thanks

Hi Dave

I have just looked at your test site and noticed that you have, well, how can I put this, or which way do I put this.

1.You have the threads and the calendar coming up next to the pal boxes. or the other way ??

I have been looking for this for ages, looking like postnuke every day.

So is the going to be an update or addon?

This means we can use the IIP for what it's supposed to be an index page, instead of it disapearing once you go to threads.

And does this mean we can have all our navs in the menu pal box to.

Is the calendar an update to Calendar - 6.2.
http://www.chattersonline.com/test/ubbthreads/iip/calendar.php?Cat=
I love it.

OR AM I DREAMING. zzzzzzzzzz

Can you give me any info on you latest creation...

Thanks

What's currently in use at my test site (IIP pro)? is something I'm putting together for myself and anyone that may care to purchase it when it's finished. The left/right/center columns in the display are template based but are not like how the sidebars are done here. The calendar I'm putting together there isn't related to the calendar addon that's here. It's a seperate set of scripts all to itself to make it easier to set up.

The front page of this site is how IIP looks. The forum is using the Side Bar modification located in the beta modifications board. I did some additional modifying here to place the information in the sidebar. It's not that hard to do and I'll post the "how to" on it as soon as possible.

Hi Dave

I'm Interested.

Any more info - finish - price etc.

PM me or post here.

Thanks.

Thanks for even considering to purchase it!

I'm not even sure what to ask for a price as of yet. Heck, it's not even finished.

I'll definately let you know when it's done so you can give it a closer inspection.

Hi

Your welcome

keep me posted

Thanks

I think a number of people here will realize a GOOD thing when they see IIP Pro. IIP is far more than a "hack" or "modification" like others here.... it's a full scale system.

I'll be spending the money to have it when it's available as I know it'll be worth it, and JustDave's time and efforts deserve to be rewarded.

By the looks of the error you haven't ran the "Modify My Database" script. What version are you upgrading from?

IIP pro huh!?!

I knew there was a catch

Nah,

I'm in. I would definately go for it.

My Motto

Send Money !!

Great work Dave

What all is gonna be include with Pro?? Or did I miss it?