.com.unity Forums
  The Official e-Store of Shrapnel Games

This Month's Specials

BCT Commander- $6.00
winSPMBT: Main Battle Tank- Save $5.00

   







Go Back   .com.unity Forums > The Camo Workshop > WinSPWW2
Notices


Reply
 
Thread Tools Display Modes
  #1  
Old April 5th, 2019, 08:31 PM

lukerduker123 lukerduker123 is offline
Corporal
 
Join Date: Jul 2013
Posts: 69
Thanks: 15
Thanked 13 Times in 12 Posts
lukerduker123 is on a distinguished road
Default Question about all this new SQL stuff

Howdy! So, after having a friend that's computer literate explain SQL to me in the dumbest of terms, I have to ask a rather strange question! Is it possible to use the SQL function to EDIT a scenario? That is, can I create a tank company in SQL and replace another company with it? I hope that makes sense!
Reply With Quote
  #2  
Old April 5th, 2019, 10:09 PM
zovs66's Avatar

zovs66 zovs66 is online now
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 404
Thanks: 369
Thanked 275 Times in 133 Posts
zovs66 is on a distinguished road
Default Re: Question about all this new SQL stuff

No you can't do that.
__________________
ASL
Reply With Quote
The Following 2 Users Say Thank You to zovs66 For This Useful Post:
  #3  
Old April 5th, 2019, 10:12 PM
zovs66's Avatar

zovs66 zovs66 is online now
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 404
Thanks: 369
Thanked 275 Times in 133 Posts
zovs66 is on a distinguished road
Default Re: Question about all this new SQL stuff

To do what you are asking you don't use SQL. You can do one of two things.

1. Use ScenHack to change one (or more than one) unit to another unit.
2. Use the Editor and change one unit to another unit (r).

The SQL in ScenHack is just to query (ask) for some information, not edit/change data.
__________________
ASL
Reply With Quote
The Following 2 Users Say Thank You to zovs66 For This Useful Post:
  #4  
Old April 5th, 2019, 10:16 PM
DRG's Avatar

DRG DRG is offline
National Security Advisor
 
Join Date: Mar 2005
Location: GWN
Posts: 9,739
Thanks: 1,869
Thanked 2,959 Times in 1,478 Posts
DRG will become famous soon enough
Default Re: Question about all this new SQL stuff

It's all about the information in a scenario not changing it and it's really more of a development tool we added because it would be useful if you were looking for a specific battle or designer and the search feature can zero in on things like that quickly but a lot of the more detailed SQL work wouldn't be of interest to the average gamer unless you wanted to find all the scenarios that used a specific tank or unit or how many times a particular unit graphic was used but it can have many uses depending on how curious you are and how much time you want to expend finding out things.

EDIT-------------Like this


select count(*) from sData uName
where ( LOWER(uName) like "%sherman%")

will reveal that "shermans" are used 740 times in *MY* scenario folder

and if you ask


select count(*) from sData uName
where (( LOWER(uName) like "%sherman%") or ( LOWER(uName) like "%m4%"))

the answer is 1831

and this

select count(*) from sData icon
where icon =125

tells me graphic 125 ( a Cromwell ) is used 84 times in the scenarios in my folder

And this

select distinct ScenNum, sTitle, Unit, uName from sData
where icon =125

will tell me exactly where they are

The number of scenarios has grown past the point anyone with a normal memory could remember or find ones but you might remember a keyword and that may be all you need to find one you played years ago but can't remember the number of it
__________________

Last edited by DRG; April 5th, 2019 at 10:55 PM..
Reply With Quote
The Following 2 Users Say Thank You to DRG For This Useful Post:
  #5  
Old April 5th, 2019, 10:22 PM

lukerduker123 lukerduker123 is offline
Corporal
 
Join Date: Jul 2013
Posts: 69
Thanks: 15
Thanked 13 Times in 12 Posts
lukerduker123 is on a distinguished road
Default Re: Question about all this new SQL stuff

Ah, I get it now! Thanks. It's a shame that there isn't a way to easily copy and paste certain units from one scenario to another, but that's the way the cookie crumbles, I reckon.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 On

Forum Jump


All times are GMT -4. The time now is 12:57 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©1999 - 2019, Shrapnel Games, Inc. - All Rights Reserved.