Project 1999

Go Back   Project 1999 > Red Community > Red Server Chat

Closed Thread
 
Thread Tools Display Modes
  #21  
Old 10-04-2011, 02:34 PM
Knuckle Knuckle is offline
Planar Protector

Knuckle's Avatar

Join Date: Dec 2010
Posts: 3,897
Send a message via AIM to Knuckle
Default

Quote:
Originally Posted by Rogean [You must be logged in to view images. Log in or Register.]
System has been in place since the start of beta and will be in place for the live launch. You are missing the details of this system though, such as the last time online check.
thanks rogean, so if 'knuckle' hasn't been online in YEARS ill be able to get my name? awesome.
__________________
  #22  
Old 10-04-2011, 02:47 PM
Atmas Atmas is offline
Planar Protector


Join Date: Jun 2011
Location: In the bushes outside your window
Posts: 1,009
Default

Quote:
Originally Posted by Softcore PK [You must be logged in to view images. Log in or Register.]
the 84 days seemed to be part of an equation though..
(i know nothing about sql)
The code is looking for an existing account row with certain properties.

There is a comparison on these values "a.timelaston, UNIX_TIMESTAMP(),". I can assume by name a.timelaston is last login time and the UNIX_TIMESTAMP() is a current time stamp (what ever the time is when caled). I don't use MySQL. The function is subtracting the last login from the current time to see if the value is bigger than 84 days. Time is often stored in DBs as an incrememt of units from some starting point.

The "7257600" value I just made a guess was seconds cause other formats like milliseconds were impractical.

/60 = 120,960 minutes
/60 = 2016 hours
/24 = 84 days

I could be wrong, I'm making a couple of assumptions.

Edit for more clarifciation: The function is basically doing other checks on the status of the account (if it exists) to return a value as to whether or not you can create a character with this name. They include if an account is banned if and if it's the same account using that name.
__________________
60 Wixxor - Atmas
60 Paladin - Opmeter
54 Rogue - Ories
Some other toons
Formerly of TZ
Last edited by Atmas; 10-04-2011 at 02:56 PM..
  #23  
Old 10-04-2011, 02:57 PM
Atmas Atmas is offline
Planar Protector


Join Date: Jun 2011
Location: In the bushes outside your window
Posts: 1,009
Default

Quote:
Originally Posted by Knuckle [You must be logged in to view images. Log in or Register.]
thanks rogean, so if 'knuckle' hasn't been online in YEARS ill be able to get my name? awesome.
Funny enough I created a Knuckle on Beta to mess with you but I havent played on the toon. I won't be creating it when server goes live and can delete the one I made if you want it.
__________________
60 Wixxor - Atmas
60 Paladin - Opmeter
54 Rogue - Ories
Some other toons
Formerly of TZ
  #24  
Old 10-05-2011, 11:24 AM
Rogean Rogean is offline
¯\_(ツ)_/¯

Rogean's Avatar

Join Date: Oct 2009
Location: Massachusetts
Posts: 5,377
Default

I like pasting code and letting people try to interpret it. I should do it more often.
__________________
Sean "Rogean" Norton
Project 1999 Co-Manager

Project 1999 Setup Guide
  #25  
Old 10-05-2011, 11:43 AM
Atmas Atmas is offline
Planar Protector


Join Date: Jun 2011
Location: In the bushes outside your window
Posts: 1,009
Default

Quote:
Originally Posted by Rogean [You must be logged in to view images. Log in or Register.]
I like pasting code and letting people try to interpret it. I should do it more often.
R I am right?
__________________
60 Wixxor - Atmas
60 Paladin - Opmeter
54 Rogue - Ories
Some other toons
Formerly of TZ
  #26  
Old 10-05-2011, 12:22 PM
Softcore PK Softcore PK is offline
Planar Protector

Softcore PK's Avatar

Join Date: Sep 2011
Location: Red99
Posts: 1,236
Default

lol
__________________
“Smile, breathe, and go slowly.”
  #27  
Old 10-05-2011, 01:40 PM
L1ch L1ch is offline
Banned


Join Date: Jun 2011
Location: your fears
Posts: 81
Default

AMEN
Closed Thread


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:07 PM.


Everquest is a registered trademark of Daybreak Game Company LLC.
Project 1999 is not associated or affiliated in any way with Daybreak Game Company LLC.
Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.