[Done] Online Time Mod [v0.3a]

[vorapoap (vory)]

This mod will display the online time on the profile page and member list.  (The ICQ column is replaced with OnlineTime column)

*** Run these queries first ***

ALTER TABLE yabbse_members ADD COLUMN onlineTime bigint DEFAULT 0;
UPDATE yabbse_members SET onlineTime = 0;

(You can run them by using php file in here. (Put it into the Yabb SE dir.)

*** And add this to the language file. ***

$txt['ontime1'] = 'Online Time';
$txt['ontime2'] = 'hour';
$txt['ontime3'] = 'minute';
$txt['ontime4'] = 'second';
$txt['ontime5'] = 's';
$txt['ontime6'] = '<NOBR>Online for</NOBR>';

*** And apply this mod (v0.3).



I recommend you to update to this v0.2 version, I have changed a few important things, which you wouldn't notice.

In v0.3:

• I have modify Register.php in order to set the default value with the insertion of new UPDATE query instead of replacing original INSERT INTO. So this can be compatible with future mod such as my Collapsable Category Mod which also modify Register.php.
  
• In addition,  one step is reduced in Subs.php. It now uses $GLOBALS array  instead of declaration of  global-scope variable.

FOR USER FROM OLD VERSION
This is due to my stupidity.
In version 0.3a there is nothing new except the change to database.

You can recover your old Register.php
and run this query

ALTER TABLE yabbse_members ALTER COLUMN onlineTime SET DEFAULT 0;

[PHX]

ALTER TABLE yabbse_members ADD COLUMN board bigint;
UPDATE yabbse_members SET onlineTime = 0;

?? the colum is mising?? is onlinetime?

[Chris Cromer]

I think your missunderstanding, you need to make onlinetime.

[PHX]

it was wrong typed men

[iamdamnsam]

any screen shots?

[David]

any screen shots?

Pretty simple to figure out.  It inserts a row in the profile that has a number and a label.

My only question, since I havn't read the source yet, is does it keep track of total time or time from the last time they logged in?

[iamdamnsam]

Actually it removes your ICQ spot, which a screen shot would of shown

[vorapoap (vory)]

It determines the length of time between each click, and then add it to the onlineTime. It also gives you the new option to display the sorted of  the member list according to online time.

The reason I removed ICQ column is.. it is no used to me. (and it is strange to display only ICQ, despite having AOL,YMSN,MSN) if you have any other idea just tell me. Anyway, screenshort is added to the first thread.

It is a medium size mod.. and would be my last mod for a few weeks from now. I have to concentrate on my exam and etc.

It is pretty simple. my mod is clean, just try it. if you don't like you can undo.

[Sava]

*** Run these queries first ***

ALTER TABLE yabbse_members ADD COLUMN onlineTime bigint;
UPDATE yabbse_members SET onlineTime = 0;

 I got problem w/ this stuff. I'd be fine if u also write a file to run those querries, so for newbie like me we can feel easier to apply the mod
 
 Remember last time when u published the other mod , called ... sth , and the other guy gotta write the who_db.php for me? coz I dont know how to run the queeries thinggie

[vorapoap (vory)]

Ok..I think now you can get the zip file from the first post.

[Sava]

Mod Team memb ? congrad vory

[vorapoap (vory)]

FOR USER FROM OLD VERSION
This is due to my stupidity.
In version 0.3a there is nothing new except the change to database.

You can recover your old Register.php
and run this query

ALTER TABLE yabbse_members ALTER COLUMN onlineTime SET DEFAULT 0;

[joshxpcable11]

Ok, it works for all registerd members, but all the newbies that just signed up, it aint counting for them..

How do I fix this?

[vorapoap (vory)]

YAK

The current online_db.z is wrong.
Please run this query

ALTER TABLE yabbse_members ALTER COLUMN onlineTime SET DEFAULT 0;

For any new member name
Run this
UPDATE yabbse_members SET onlineTime = 0 WHERE memberName = 'NAMEHERE';

[joshxpcable11]

Ok, im a really a newbie at mySQL, can u make me one of them db files?