Archived copy of warcraft-source.com, the Warcraft: Source (WCS) forum (2007–2011), rebuilt from the Internet Archive by wc3mods.net. This page was captured on 2009-02-19 (original capture). Home · Forum · All archived topics · Downloads
Warcraft-Source.com - WCS mod for CSS
February 19, 2009, 07:37:37 AM *
Welcome, Guest. Please login or register.
Login with username, password and session length
News: Hall of Fame - Designer
Must Visit it
Google  
  Home   Forum   Help Search Login Register   *
Pages: [1]   Go Down
  Print  
Author Topic: sqldb Editor  (Read 62 times)
ashitaka666
Level 2 Apprentice
**
Offline Offline

United States United States

Posts: 44


Pic from 2 years ago.


WWW
ashes666101666

myServer 174.36.4.226:27015
(Warning: click connects through Steam)
« on: February 16, 2009, 11:21:30 PM »

I already have the editor. I use SQlite Database Browser Program.

I need to know the string I have to add into the execute sql so I can remove anyone that hasnt been on for more then 7 days. Can anyone help me? Thank You!
Logged

Namolem
Level 7 Expert
*****
Offline Offline

Russian Federation

Posts: 204




Namolem
« Reply #1 on: February 17, 2009, 12:21:08 AM »

type in server's console:
es_xset t 0
es_xgettime t
t

then remembers t's value. It's number of seconds since some date
in sqldb there is field named lastplayed
Do you understand what to do then?
Logged
ashitaka666
Level 2 Apprentice
**
Offline Offline

United States United States

Posts: 44


Pic from 2 years ago.


WWW
ashes666101666

myServer 174.36.4.226:27015
(Warning: click connects through Steam)
« Reply #2 on: February 17, 2009, 05:52:19 PM »

um no here's the number. I've never done anything like this. I believe it would be WHERE id something something t

1234889220
Logged

WCA | Berettonawak [FR]
Watchdogs
Level 7 Expert
*****
Offline Offline

France France

Posts: 1578


Big Berettonawak is watching you...



Bifkids

myServer 81.93.251.44:27015
(Warning: click connects through Steam)
« Reply #3 on: February 17, 2009, 10:24:18 PM »

the number you get is number of seconds while the server was online..
Logged


MY INTERNET:
ashitaka666
Level 2 Apprentice
**
Offline Offline

United States United States

Posts: 44


Pic from 2 years ago.


WWW
ashes666101666

myServer 174.36.4.226:27015
(Warning: click connects through Steam)
« Reply #4 on: February 18, 2009, 01:22:35 AM »

yes I know this but I need to know the syntax to cut the people that havent been playing in 7 days. To clean up the userfile where the everyones lvls are saved. I need that syntax.

Thanks
Logged

WCA | Berettonawak [FR]
Watchdogs
Level 7 Expert
*****
Offline Offline

France France

Posts: 1578


Big Berettonawak is watching you...



Bifkids

myServer 81.93.251.44:27015
(Warning: click connects through Steam)
« Reply #5 on: February 18, 2009, 08:20:55 AM »

Oh no sry was confusing with another command.
This one gets the real number of seconds after 1970.
Take both number, then divide per 60, per 60, and per 24, and per 7 (in temp var).
If temp var >= 1, delete key
Logged


MY INTERNET:
ashitaka666
Level 2 Apprentice
**
Offline Offline

United States United States

Posts: 44


Pic from 2 years ago.


WWW
ashes666101666

myServer 174.36.4.226:27015
(Warning: click connects through Steam)
« Reply #6 on: February 18, 2009, 05:52:17 PM »

temp var >= 1, delete key

so should be

temp 2041 >=1 delete id   correct?
or
temp 7 >=1 delete id  correct?

Since I took the number I gave in my 2nd post and did the divide thing and came out with 2041. I also dont have any coding experience so best way would be tell me everything u need and then the code can written by u Smiley.

Tyvm,.
Logged

WCA | Berettonawak [FR]
Watchdogs
Level 7 Expert
*****
Offline Offline

France France

Posts: 1578


Big Berettonawak is watching you...



Bifkids

myServer 81.93.251.44:27015
(Warning: click connects through Steam)
« Reply #7 on: February 18, 2009, 05:58:19 PM »

If
previous value - current value >= 604800
then he hasn't been playing for more than a week Tongue
Logged


MY INTERNET:
ashitaka666
Level 2 Apprentice
**
Offline Offline

United States United States

Posts: 44


Pic from 2 years ago.


WWW
ashes666101666

myServer 174.36.4.226:27015
(Warning: click connects through Steam)
« Reply #8 on: February 18, 2009, 06:07:36 PM »

ic, but still doesnt help with syntax lol.

Need everything written out as maybe an example.

so it will delete ALL users who havent been on for more then 7 days. so I can tone down our wcsuserfile .sql database.

tyvm
Logged

Pages: [1]   Go Up
  Print  
 
Jump to:  

Last 7 Shouts:
February 18, 2009, 10:19:23 PM
Cheesy
February 18, 2009, 10:18:58 PM
MITCHEL GET ON MSN
February 18, 2009, 09:00:41 PM
oh lol namo
you feared us Tongue
which then would be:
oh lol namo
you scared us:P
February 18, 2009, 08:39:17 PM
is there an wcs_ultimates file with nearly all ultimate blocks?!
cuz there is a bug in my file and i don't want to search every ulti block for the races =/
February 18, 2009, 08:33:54 PM
omfg Cheesy
thanks for it Smiley
February 18, 2009, 06:32:23 PM
now that made me laugh
February 18, 2009, 05:39:23 PM
oh lol namo
you feared us Tongue
Recent
[Today at 07:33:24 AM]

[Today at 07:16:59 AM]

[Today at 07:03:13 AM]

[Today at 04:46:03 AM]

[Today at 02:17:02 AM]

[Today at 12:58:31 AM]

[Today at 12:41:35 AM]

[Today at 12:33:01 AM]

[Today at 12:19:49 AM]

[February 18, 2009, 11:56:43 PM]
Theme switch

Powered by MySQL Powered by PHP Powered by SMF 1.1.4 | SMF © 2006-2007, Simple Machines LLC
TinyPortal v0.9.8 © Bloc
Valid XHTML 1.0! Valid CSS!
Page created in 0.045 seconds with 26 queries.