Archived copy of war3source.com, the War3Source forum (2009–2020), rebuilt from the Internet Archive by wc3mods.net. This page was captured on 2012-09-22 (original capture). Forum · All archived topics · Wiki · Bug tracker · Blog
Chat

War3:Source
September 21, 2012, 09:46:38 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Download: http://war3source.com/index.php?board=9.0
What is War3Source?: http://war3source.com/index.php?topic=200.0
Sample Stats: http://war3source.com/war3stats
Steam Community Group: http://steamcommunity.com/groups/war3source
War3Source SVN Checkout: http://ownageclan.com/svn/war3source/
War3Source servers: http://www.game-monitor.com/search.php?vars=war3_version=
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Are you good with Databases?  (Read 72 times)
-El Diablo
Full Member
***
Posts: 175


View Profile
« on: May 21, 2012, 08:55:30 AM »

Need to find a way to append the date of a person whom joins the server to the database if it already doesn't do it..

Then create a addon to the war3admin menu that allows a war3admin to start a pruning system, where if a user hasn't been playing in 1 to 2 years, then to remove them from the database.

If nobody is able to create this, I'll eventually work on it myself.

There is no way in the world I'll let my player database get wiped every year.  .. need a pruning system.
Logged
Glider⠠⠵
Global Moderator
Sr. Member
*****
Posts: 402


⠠⠵


View Profile
« Reply #1 on: May 21, 2012, 01:43:15 PM »

There's a already a last seen column. Just "DELETE FROM <whateverthefuckthattablewascalledwar3sourceIthink?> WHERE LAST_SEEN < SYSDATE - 360" or something like that
Logged

Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!