Jedi Archive

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.

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

---

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 holorevisit 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.

---

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

---

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 holorevisit 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

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.

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

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.

---

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.