User talk:Jarrbox - Revision history

Arioch at 11:14, 28 January 2019

2019-01-28T11:14:38Z

Jarrbox at 19:43, 25 January 2019

2019-01-25T19:43:12Z

Jarrbox at 08:35, 25 January 2019

2019-01-25T08:35:11Z

Jarrbox at 10:01, 24 January 2019

2019-01-24T10:01:02Z

Arioch: /* wiki: cards templates */

2018-10-23T17:43:21Z

‎wiki: cards templates

Arioch: /* wiki: cards templates */

2018-10-23T17:42:06Z

‎wiki: cards templates

Arioch: /* wiki: cards templates */

2018-10-16T09:00:35Z

‎wiki: cards templates

Arioch: /* wiki: cards templates */

2018-10-16T08:58:34Z

‎wiki: cards templates

Arioch: /* wiki: cards templates */

2018-10-16T08:55:18Z

‎wiki: cards templates

Arioch: /* wiki: cards templates */

2018-10-11T12:52:23Z

‎wiki: cards templates

← Older revision		Revision as of 11:14, 28 January 2019
Line 297:		Line 297:

	Looks like Peter&Tink M either have very a unconvential levelling (not the first one) or has incorrect back-arts... However typo in back-arts is impossible if back-arts is really auto-generated form the in-game DB. Weird.		Looks like Peter&Tink M either have very a unconvential levelling (not the first one) or has incorrect back-arts... However typo in back-arts is impossible if back-arts is really auto-generated form the in-game DB. Weird.
		+
		+	---------
		+
		+	Lol, I even made like 300 screenshots in December to make detailed track of few cards different rarity levelling up. No use now :-)
		+	redd.it / 8uc5p6 - maybe a path to load all the arts/profile data from
		+	redd.it / 436571 - 2016 post about Fantasica decay, that was already there
		+
		+	It was snowballing and expected. Pity they would not be repeating Colo - my first event, those spaceship girls....
		+
		+	And no selling 11* inbox :-D
		+	[[User:Arioch\|Arioch]] ([[User talk:Arioch\|talk]]) 11:14, 28 January 2019 (UTC)

@@ Line 135: / Line 135: @@
 {{!}} {{{rarity}}}
 {{!}} {{{skill1}}}{{#if: {{{skill2}}} | ,<br> {{{skill2}}}}}{{#if: {{{arenaskill}}} | ,<br> {{{arenaskill}}}}}
 {{!}}- }}{{#clear_external_data:}}
 {{!}}}

@@ Line 78: / Line 78: @@
 {{#get_db_data:db=fantawiki
 |from=monsters
-|where=released=0
+|where=released=0 and name NOT LIKE "Arouette_9_m" and name NOT LIKE "Bonus_Pot_m" and name NOT LIKE "Sand_Wraith" and name NOT LIKE "Arouette_6_m" and name NOT LIKE "D._Gray" and name NOT LIKE "Excalibur" and name NOT LIKE "Ghost_Drum" and name NOT LIKE "Jack" and name NOT LIKE "KillUrn_m" and name NOT LIKE "Lampy" and name NOT LIKE "Walter_M_Elon" and name NOT LIKE "Mariette_5_m"
 |order by=rarity DESC, name
 |data=name2=`name`,rarity2=`rarity`,source2=`source`}}
@@ Line 91: / Line 91: @@
 {{!}} {{{rarity2}}}
 {{!}} {{{source2}}}
 {{!}}- }}{{#clear_external_data:}}
 {{!}}}

← Older revision		Revision as of 10:01, 24 January 2019
Line 1:		Line 1:
		+	__NOTOC__
		+	{\| class="wikitable mw-collapsible mw-collapsed"
		+	\|-
		+	! Broken Card Check
		+	\|-
		+	\|\|
		+	<tabber>
		+
		+	\|-\|
		+	Missing Rarity=
		+	{{#tag:tabber\|
		+	{{!}}-{{!}}
		+	Units=
		+	{{#get_db_data:db=fantawiki
		+	\|from=units
		+	\|where=rarity=0
		+	\|order by=rarity DESC, name
		+	\|data=name=`name`,rarity=`rarity`,source=`source`}}
		+
		+	{{{!}} class="wikitable sortable" style="text-align:center;"
		+	! Name
		+	! {{*}}
		+	! Source
		+	{{!}}-
		+	{{#for_external_table:<nowiki/>
		+	{{!}} [[Image:{{{name}}}_icon.png{{!}}link={{{name}}}]]<br/>[[{{{name}}}]]
		+	{{!}} {{{rarity}}}{{*}}
		+	{{!}} {{{source}}}
		+	{{!}}- }}{{#clear_external_data:}}
		+	{{!}}}
		+
		+	{{!}}-{{!}}
		+	Monsters=
		+	{{#get_db_data:db=fantawiki
		+	\|from=monsters
		+	\|where=rarity=0
		+	\|order by=rarity DESC, name
		+	\|data=name2=`name`,rarity2=`rarity`,source2=`source`}}
		+
		+	{{{!}} class="wikitable sortable" style="text-align:center;"
		+	! Name
		+	! {{*}}
		+	! Source
		+	{{!}}-
		+	{{#for_external_table:<nowiki/>
		+	{{!}} [[Image:{{{name2}}}_icon.png{{!}}link={{{name2}}}]]<br/>[[{{{name2}}}]]
		+	{{!}} {{{rarity2}}}
		+	{{!}} {{{source2}}}
		+	{{!}}- }}{{#clear_external_data:}}
		+	{{!}}}
		+	}}
		+
		+	\|-\|
		+	Missing Release=
		+	{{#tag:tabber\|
		+	{{!}}-{{!}}
		+	Units=
		+	{{#get_db_data:db=fantawiki
		+	\|from=units
		+	\|where=released=0
		+	\|order by=rarity DESC, name
		+	\|data=name=`name`,rarity=`rarity`,source=`source`}}
		+
		+	{{{!}} class="wikitable sortable" style="text-align:center;"
		+	! Name
		+	! {{*}}
		+	! Source
		+	{{!}}-
		+	{{#for_external_table:<nowiki/>
		+	{{!}} [[Image:{{{name}}}_icon.png{{!}}link={{{name}}}]]<br/>[[{{{name}}}]]
		+	{{!}} {{{rarity}}}
		+	{{!}} {{{source}}}
		+	{{!}}- }}{{#clear_external_data:}}
		+	{{!}}}
		+
		+	{{!}}-{{!}}
		+	Monsters=
		+	{{#get_db_data:db=fantawiki
		+	\|from=monsters
		+	\|where=released=0
		+	\|order by=rarity DESC, name
		+	\|data=name2=`name`,rarity2=`rarity`,source2=`source`}}
		+
		+	{{{!}} class="wikitable sortable" style="text-align:center;"
		+	! Name
		+	! {{*}}
		+	! Source
		+	{{!}}-
		+	{{#for_external_table:<nowiki/>
		+	{{!}} [[Image:{{{name2}}}_icon.png{{!}}link={{{name2}}}]]<br/>[[{{{name2}}}]]
		+	{{!}} {{{rarity2}}}
		+	{{!}} {{{source2}}}
		+	{{!}}- }}{{#clear_external_data:}}
		+	{{!}}}
		+	}}
		+	</tabber>
		+	\|}
		+
		+	<hr>
	Hey thanks for taking care of front page. I am fine doing the wiki uploads and the new unit adds, but Toraella use to take care of the linking pages. I need to go back and grab all card and event links from the 9th to now.		Hey thanks for taking care of front page. I am fine doing the wiki uploads and the new unit adds, but Toraella use to take care of the linking pages. I need to go back and grab all card and event links from the 9th to now.
	You want to learn how to upload in case something happens to me or I quit?		You want to learn how to upload in case something happens to me or I quit?

@@ Line 76: / Line 76: @@
 Anyway, you might be interested to look into formulas I tried there in that Spreadsheet for guesstimation.
 There is often an "off by one" error though with real data, which shows that Fanta actually applies formulas in different order than my spreadsheet does. Though that makes no practical difference.
 If not formulas there might be some sampling for you, but note, being poor newb I was not interested in wasting 11* onto souls, so I was sampling 6-8 units with a very few 5* : they are the local optimum. W.R.T. your formulas - please, define X and Z before using them, those formulas quite confused me, I read them in reverse order that ascension decrease stats :-D
@@ Line 108: / Line 106: @@
 That is optimal for marketing. You can hardly squeeze much $ from players who do not want much. So you have to squeeze tighter and tighter those fewer and fewer who still pay. That may be called death spiral...

← Older revision		Revision as of 09:00, 16 October 2018
Line 102:		Line 102:

	On Fanta state in total - Varner, Clysma, Suzue - after 2-3 weeks after their event they are still TL. No comment.		On Fanta state in total - Varner, Clysma, Suzue - after 2-3 weeks after their event they are still TL. No comment.
		+
		+	> Seems like the more you want a unit, the less likely you're gonna get it
		+
		+	That is optimal for marketing. You can hardly squeeze much $ from players who do not want much. So you have to squeeze tighter and tighter those fewer and fewer who still pay. That may be called death spiral...

← Older revision		Revision as of 08:58, 16 October 2018
Line 99:		Line 99:
	Maybe there should be a dedicated page for raw data, not only about units themselves, but also about how wiki-editors came to this and that conclusion. Like, again, the Gifting.		Maybe there should be a dedicated page for raw data, not only about units themselves, but also about how wiki-editors came to this and that conclusion. Like, again, the Gifting.

−	On DB access - someone should have it, someone who pays for domain and traffic, there is to be someone there...	+	On DB access - someone should have it, someone who pays for domain and traffic, there is to be someone there... Granted, MySQL is not my beloved DB, but most basic SQL is the same but everywhere (with MySQL at least with version 5+) and fewer FT players mean less load on the wiki and on the DB, so suboptimal decisions would not hurt much. At least, self-education, if not community help :-D
		+
		+	On Fanta state in total - Varner, Clysma, Suzue - after 2-3 weeks after their event they are still TL. No comment.

@@ Line 91: / Line 91: @@
 Of course no one would give SQL direct access left and right cause things like bobby-tables.com
-Biggest problem with all those tutorials and raw stats gathering is - who would ever need it? Okay, I am a little down over abysmal pull rates and new pretty Adley missed
+Biggest problem with all those tutorials and raw stats gathering is - who would ever need it? Okay, I am a little down over abysmal pull rates and new pretty Adley missed for me...
- for me...

← Older revision		Revision as of 12:52, 11 October 2018
Line 84:		Line 84:

	Biggest problem is that Fanta was dying even in February when I quit, and being back this August I can sadly see it is dying yet worse. I was thinking about writing down my newb experiences as a kind of crash course, but since Fanta is in "squeeze it dry" death spiral I no more feel an urge for it...		Biggest problem is that Fanta was dying even in February when I quit, and being back this August I can sadly see it is dying yet worse. I was thinking about writing down my newb experiences as a kind of crash course, but since Fanta is in "squeeze it dry" death spiral I no more feel an urge for it...
		+
		+	-------------
		+
		+	Basically there is some person paying for fantasicawiki.com domain name registration, and then there is person (probably same) paying for hosting and traffic. They probably have a bunch of logins/passwords to the server. Ranging from some low-level stuff like SSH access to the server command line to more limited and easy to use like phpMyAdmin or some other WWW wrapper over MySQL engine (which probably runs the databases on the site, as "LAMP" is a common toolbox for simple web sites).
		+
		+	Of course no one would give SQL direct access left and right cause things like bobby-tables.com
		+
		+	Biggest problem with all those tutorials and raw stats gathering is - who would ever need it? Okay, I am a little down over abysmal pull rates and new pretty Adley missed
		+	for me...