Welcome, Guest. Please Login or Register.
August 08, 2022, 10:43:15 PM
Home Help Search Login Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  Development  |  Completed mods  |  Topic: [Done] Online Time Mod [v0.3a] « previous next »
Pages: [1] 2 3 4 Reply Ignore Print
Author Topic: [Done] Online Time Mod [v0.3a]  (Read 37506 times)
vorapoap (vory)
Sr. Member
****
Posts: 424


Not considered either a living or death


WWW
[Done] Online Time Mod [v0.3a]
« on: May 07, 2002, 07:43:49 PM »
Reply with quote

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;

« Last Edit: May 13, 2002, 08:34:46 PM by vorapoap (vory) » Logged

On the route to hell...
PHX
Noobie
*
Posts: 47


Bad Ass Mothercrappity smacker!


WWW
Re:[Done] Online Time Mod
« Reply #1 on: May 07, 2002, 08:40:53 PM »
Reply with quote

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

?? the colum is mising?? is onlinetime?
Logged

. : : Phyrexia : : .
Jedi Master

ICQ#: 63918674
MSN: phyrexia@hotmail.com

Email: phyrexia@vtr.net
Chris Cromer
The Strange One
Mod Team
YaBB God
*****
Posts: 3152


I am just a figment of your imagination.


WWW
Re:[Done] Online Time Mod
« Reply #2 on: May 07, 2002, 08:43:10 PM »
Reply with quote

I think your missunderstanding, you need to make onlinetime.
Logged

Chris Cromer

I am not suffering from insanity, I am enjoying every minute of it.
PHX
Noobie
*
Posts: 47


Bad Ass Mothercrappity smacker!


WWW
Re:[Done] Online Time Mod
« Reply #3 on: May 07, 2002, 08:48:05 PM »
Reply with quote

it was wrong typed men
Logged

. : : Phyrexia : : .
Jedi Master

ICQ#: 63918674
MSN: phyrexia@hotmail.com

Email: phyrexia@vtr.net
iamdamnsam
Full Member
***
Posts: 225


RamchargerCentral.Com


WWW
Re:[Done] Online Time Mod
« Reply #4 on: May 07, 2002, 08:52:12 PM »
Reply with quote

any screen shots?
Logged

RamchargerCentral.Com
http://ramchargercentral.com
David
Destroyer Dave
Global Moderator
YaBB God
*****
Posts: 5761


I'm not a llama!


WWW
Re:[Done] Online Time Mod
« Reply #5 on: May 07, 2002, 09:17:53 PM »
Reply with quote


any screen shots?

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

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?
Logged

iamdamnsam
Full Member
***
Posts: 225


RamchargerCentral.Com


WWW
Re:[Done] Online Time Mod
« Reply #6 on: May 07, 2002, 11:45:13 PM »
Reply with quote

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

RamchargerCentral.Com
http://ramchargercentral.com
vorapoap (vory)
Sr. Member
****
Posts: 424


Not considered either a living or death


WWW
Re:[Done] Online Time Mod
« Reply #7 on: May 08, 2002, 02:27:46 AM »
Reply with quote

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.
« Last Edit: May 08, 2002, 03:07:27 AM by vorapoap » Logged

On the route to hell...
Sava
Noobie
*
Posts: 42


I'm a llama!


Re:[Done] Online Time Mod [Update]
« Reply #8 on: May 08, 2002, 12:58:01 PM »
Reply with quote

Quote

*** 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 :)
Logged
vorapoap (vory)
Sr. Member
****
Posts: 424


Not considered either a living or death


WWW
Re:[Done] Online Time Mod [Update]
« Reply #9 on: May 08, 2002, 02:41:21 PM »
Reply with quote

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

On the route to hell...
Sava
Noobie
*
Posts: 42


I'm a llama!


Re:[Done] Online Time Mod [v0.3]
« Reply #10 on: May 10, 2002, 11:16:48 PM »
Reply with quote

Mod Team memb ? ;) congrad vory
Logged
vorapoap (vory)
Sr. Member
****
Posts: 424


Not considered either a living or death


WWW
Re:[Done] Online Time Mod [v0.3a]
« Reply #11 on: May 13, 2002, 08:35:12 PM »
Reply with quote


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;

Logged

On the route to hell...
joshxpcable11
Full Member
***
Posts: 232


Eat my shorts


Re:[Done] Online Time Mod [v0.3a]
« Reply #12 on: May 19, 2002, 05:40:38 PM »
Reply with quote

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?
Logged

Check out my boards: ~~~J-Boards~~~
vorapoap (vory)
Sr. Member
****
Posts: 424


Not considered either a living or death


WWW
Re:[Done] Online Time Mod [v0.3a]
« Reply #13 on: May 19, 2002, 06:48:08 PM »
Reply with quote

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';


Logged

On the route to hell...
joshxpcable11
Full Member
***
Posts: 232


Eat my shorts


Re:[Done] Online Time Mod [v0.3a]
« Reply #14 on: May 19, 2002, 07:15:57 PM »
Reply with quote

Ok, im a really a newbie at mySQL, can u make me one of them db files?
« Last Edit: May 19, 2002, 07:16:33 PM by joshxpcable11 » Logged

Check out my boards: ~~~J-Boards~~~
Pages: [1] 2 3 4 Reply Ignore Print 
YaBB SE Community  |  Development  |  Completed mods  |  Topic: [Done] Online Time Mod [v0.3a] « previous next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.0.18 | SMF © 2021, Simple Machines
Valid XHTML 1.0! Valid CSS!
Page created in 0.181 seconds with 19 queries.