Printable View
Okay so i have done a small winsock program that opens up a port
I have done some coding to my site like the server online functions
These are simple things that will tell my site when a GM is online,
but only if they run the program and expose their port
i am not satisfied
Was wondering if anyone could help me out with a stored procedure or something that will write to a db table when a certain character logs in or out
arc files btw
Why not just read the online status of characters with php?
You can program it to change the color of the script if the character has an access level over 300
Showing them online is as simple as reading the 'lastchar' value from the database and making a few comparrisons. I don't remember the exact code i used to set it up in my server but it works fine.
GM chars show up in blue ( or are hidden entirely based on a config value) while regular players are in yellow.
Online status is displayed for all of them
see the problem is you are talking about osrose
i use the arcturus server files
Not specifically i'm not
You have a database in Arcturus don't you?
There must be something you can use in the tables.
php can read from mssql easily enough. I've written dozens of utilities that use it.
Purple no the db does not record a online status.
it records logins and logouts but that is not reliable at all
example
say the player gets disconnected or just alt+f4's out of the game, the server does not log it as a proper logout so the user looks as if they are still logged in
i will play around with some stored procs and try and figure this tricky stuff out
if i figure it out most definitely will release it
Sounds like it's going to be a bit tricky then. Good luck.
Purple msn me please
ben trying for a while. We never seem to be online at the same timeQuote:
Originally Posted by lCON