station.com Sign In / Change User Join Free Why Join? See the world of SONY
   
Search the Knowledge Base Games Community Store My Account Help
Star Wars Galaxies
Jedi
Sign In  ·  Help
Jump to Page:   1 · 2 · 3  |  Next Page
 
Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
Vashner
Jedi
Posts: 11627
Registered: 06-26-2003


Vashner

Reply 1 of 38

Viewed 2141 times


You click create a character when your finished the server picks 5 random numbers and puts that list into the Oracle DB for your character. The range of numbers is the profession numbers. Each number is a profession.

Clicking on USE on a holocron executes a SQL query for the line items in that list 1-5  ... and reads it to you.

When you master the profession's listed it get's checked off.

I don't think there is a pattern because it's 100% random from char creation.

Ok this is just my theory on how it works.

 

--------------------------------------------------------
01-03-2004 03:24 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
LepickDR
SWG Chief Petty Officer
Posts: 15
Registered: 10-01-2003



Reply 2 of 38

Viewed 314 times


ok so how can i know what profession these are after i created my character months ago, i dont remember! i am at my silent holo and have no idea what it is!
01-03-2004 03:32 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
JoNakU
Jedi
Posts: 1960
Registered: 07-26-2003


JoNakU

Reply 3 of 38

Viewed 394 times



 

Clicking on USE on a holocron executes a SQL query for the line items in that list 1-5  ... and reads it to you.



Can you supply the syntax for me to be able to do a SQL query to get my 5th profession from the Oracle database? Thx, w00000t!!!!

01-03-2004 03:40 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
WickedAsh
SWG Chief Petty Officer
Posts: 102
Registered: 07-03-2003


WickedAsh
PA: Fremen Industries
Server: Gorath

Reply 4 of 38

Viewed 299 times


Don't mean to be a party pooper here but once again, there is no such thing as totally random in programming. You may have a vast and complex method of generating an end result, but that end result has a starting point and ending point.

For example if you were to choose numbers corresponding to creation of a toon, as has been verified by jedi deleting their main and then their jedi and having their fs unlock taken away, you could base this end result on any number of factors involved in creator creation. Things like Station name, Toon name, starting race, starting planet, starting city, starting profession etc etc. As I am sure you can see there is quite alot of things you could use as a begining point. Personally I think the professions are based on a combination of things, like starting planet/city, station name and toon name.

I can not recall the post exactly but there is a post somewhere wherein the devs confirmed your begining city has something to do with it. Which is one of the reasons your datapad has a wp to your starting city, this serves as a place holder in your db record from which to keep track of some of the things you need to do.

You are correct in that the holocron  does a sql type of search to find whats next on the list, as well as checks to see if you have met the reqs for the silent message.

However based on my rl years of programming xp I can say with absolute certainty that a 100 percent random program would make the inventor a very rich man.

Does this help the discussion, no not really. However I will say this with some amount of certainty, if you want to find the solution to your silent holo revisit at-at's theory only stop thinking of the list as linear and look for the pattern. Most of the patterns I saw in there that did not unlock were incorrect. Look at it this way, instead of from the top down look at the list from the inside out and then find the pattern, and also keep in mind some patterns are so complex 3 or 4 exampls of trying to find a pattern are not enough to find it. So even if you have all for 4 holos then silent it may not be enough samples.

Ashens ConDion
Mos Krayt on Tatooine - Gorath
01-03-2004 05:19 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
F3tch
Wing Commander
Posts: 1297
Registered: 11-30-2003


F3tch

Reply 5 of 38

Viewed 300 times




JoNakU wrote:

 

Clicking on USE on a holocron executes a SQL query for the line items in that list 1-5  ... and reads it to you.



Can you supply the syntax for me to be able to do a SQL query to get my 5th profession from the Oracle database? Thx, w00000t!!!!


SELECT holo_profession FROM user_holo_professions WHERE forum_user_id = 'JoNakU' AND holo_profession_state != "complete";

1 rows returned:

holo_profession
--------------------
Bounty Hunter

01-03-2004 05:35 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
Durzel
Forum Zombie
Posts: 1561
Registered: 06-30-2003


Durzel
PA: DLE
Server: Intrepid

Reply 6 of 38

Viewed 447 times




WickedAsh wrote:

Don't mean to be a party pooper here but once again, there is no such thing as totally random in programming. You may have a vast and complex method of generating an end result, but that end result has a starting point and ending point.

For example if you were to choose numbers corresponding to creation of a toon, as has been verified by jedi deleting their main and then their jedi and having their fs unlock taken away, you could base this end result on any number of factors involved in creator creation. Things like Station name, Toon name, starting race, starting planet, starting city, starting profession etc etc. As I am sure you can see there is quite alot of things you could use as a begining point. Personally I think the professions are based on a combination of things, like starting planet/city, station name and toon name.

I can not recall the post exactly but there is a post somewhere wherein the devs confirmed your begining city has something to do with it. Which is one of the reasons your datapad has a wp to your starting city, this serves as a place holder in your db record from which to keep track of some of the things you need to do.

You are correct in that the holocron  does a sql type of search to find whats next on the list, as well as checks to see if you have met the reqs for the silent message.

However based on my rl years of programming xp I can say with absolute certainty that a 100 percent random program would make the inventor a very rich man.

Does this help the discussion, no not really. However I will say this with some amount of certainty, if you want to find the solution to your silent holo revisit at-at's theory only stop thinking of the list as linear and look for the pattern. Most of the patterns I saw in there that did not unlock were incorrect. Look at it this way, instead of from the top down look at the list from the inside out and then find the pattern, and also keep in mind some patterns are so complex 3 or 4 exampls of trying to find a pattern are not enough to find it. So even if you have all for 4 holos then silent it may not be enough samples.




You are of course 100% correct.

I touched on this in another post.  No programmatic "random" system is truly random, its just another computer function that uses weighted numbers or similar to produce quasi-random numbers.  However, since we (the players) neither know the seed value nor all of the numbers in even a small sequence of the results (since to do this we would have to know what profession people were given sequentially on a given server, if not all the servers) - the result is that, as far as we're concerned, the numbers are completely and utterly unpredictable.

There is no pattern, I really wish people would wake up to that.  The fact that someone can have 4 holo crafting professions, and another person can have 4 basic professions (including the one that unlocked the slot) just proves that the only pattern that exists is that the numbers are completely random.

333333333333333333333333333333333333333
333333333333333333333333333333333333333
333333333333333333333333333333333333333
333333333333333333333333333333333333333
333333333333333333333333333333333333333
333333333333333333333333333333333333333
333333333333333333333333333333333333333
333333333333333333333333333333333333333
333333333333333333333333333333333333333

Dracz / Jashin Acroyear / Ikarus Sterling
Pre-pub 9 Jedi
- Intrepid (email)

01-03-2004 06:56 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
Vashner
Jedi
Posts: 11627
Registered: 06-26-2003


Vashner

Reply 7 of 38

Viewed 223 times


kewl thx. Well personally I wish it was easier but I think it's possible. I spent about 3 years maxing out my necromancer in EQ and it was a fun ride. Figure the same 3 years will get me Padawan.

 

 

--------------------------------------------------------
01-05-2004 02:16 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
skewk
SWG Second Lieutenant
Posts: 296
Registered: 06-26-2003


skewk

Reply 8 of 38

Viewed 223 times


there are patterns to EVERYTHING....didnt you guys remember the guy that figured out how to beat video keno...he hit the jackpot 3 times in 10 minutes...thats pretty much like winning the lottery 3 times in a row.
01-05-2004 02:36 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
Metroid
Jedi
Posts: 1563
Registered: 06-26-2003


Metroid
PA: Darkfalls
Server: Lowca

Reply 9 of 38

Viewed 224 times


How stupid are people to think they are using MySQL for this game?

(ggggggggggggggggggxnnntnnnntnnnxgggggggggggggggggg)
- Zorlon Starwind - Leader of Imperial Special Tactics Strike Force Darkfalls -
~ Master Shipwright ~
"NOOOOOOOOOOOoooooooooooooooooooooooooo" - VADER
01-05-2004 02:39 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
lavoir
SWG Ensign
Posts: 129
Registered: 06-26-2003


lavoir
PA: Apocalyspe
Server: Bloodfin

Reply 10 of 38

Viewed 223 times


Where did someone mention MySQL  in this thread? Oracle was mentionned.

Last I checked in a dev diary, Daoc was using Mysql as a backend DB.

 MySQL is a great DB for the price

Ander Tek
01-05-2004 02:44 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
Metroid
Jedi
Posts: 1563
Registered: 06-26-2003


Metroid
PA: Darkfalls
Server: Lowca

Reply 11 of 38

Viewed 223 times


You have NO clue what your talking about, to the point I'm not even going to argue with you.

DAoC does not use MySQL. MySQL would create a horrendous amount of lag because of the way it que's requests. It works fine for websites, it would not work for an MMORPG that wasn't very simplistic.

(ggggggggggggggggggxnnntnnnntnnnxgggggggggggggggggg)
- Zorlon Starwind - Leader of Imperial Special Tactics Strike Force Darkfalls -
~ Master Shipwright ~
"NOOOOOOOOOOOoooooooooooooooooooooooooo" - VADER
01-05-2004 03:02 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
J27
SWG Petty Officer
Posts: 165
Registered: 11-07-2003


J27
PA: Pirate Lords
Server: Bloodfin

Reply 12 of 38

Viewed 223 times


Will you shut up about MySQL, nobody's talking about it, you brought it up yourself, dude...
01-05-2004 03:19 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
Vashner
Jedi
Posts: 11627
Registered: 06-26-2003


Vashner

Reply 13 of 38

Viewed 223 times




skewk wrote:
there are patterns to EVERYTHING....didnt you guys remember the guy that figured out how to beat video keno...he hit the jackpot 3 times in 10 minutes...thats pretty much like winning the lottery 3 times in a row.


There are not patterns for a random number roll... that number roll of 5 randoms 1-%number of professions is what makes your random FS profession tree.

This way the dev's where able to eliminate any template or pattern issues.

 

 

--------------------------------------------------------
01-05-2004 03:40 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
Darksfallen
Jedi
Posts: 3919
Registered: 06-27-2003


Darksfallen
PA: S.O.L.D.
Server: Corbantis

Reply 14 of 38

Viewed 223 times


Now I realize the flaws in this but here is my personal opinion.

1. You create a Character.

2. It checks whatever DB that keeps the data in and picks you the 5 lowest populated professions at the time.

This will fluxuate widely and will be fueled by the process itself, just a guess.

High amount of Musician, Carbineers, Pikeman, and Squad Leader's grinders right now because of holos. This of course was discussed along with entertainer friends while Mastering Musician...

While playing music my son and 4 of my friends got carbineer, that is what I'm working on next.

Miriam

Holo 1: Master Weaponsmith

Holo 2: Master Musician

Holo 3: Silent

Miriam
Master Doctor
Master Shipwright (10/27, 10:54am)
134 Badges Hero Of Tatooine

Yasmin
Dark Jedi Knight
Reborn
01-05-2004 03:41 PM  

Report Abuse to a Moderator
 
Re: Forget patterns - This is how FSCS is unlocked (Vash Theory)
Options    Options  
Darksfallen
Jedi
Posts: 3919
Registered: 06-27-2003


Darksfallen
PA: S.O.L.D.
Server: Corbantis

Reply 15 of 38

Viewed 223 times


To clarify, I think it's the lowest populated currently active in the galaxy at the tick of clicking.

Miriam

Holo 1: Master Weaponsmith

Holo 2: Master Musician

Holo 3: Silent

Miriam
Master Doctor
Master Shipwright (10/27, 10:54am)
134 Badges Hero Of Tatooine

Yasmin
Dark Jedi Knight
Reborn
01-05-2004 03:44 PM  

Report Abuse to a Moderator
Jump to Page:   1 · 2 · 3  |  Next Page