ACDB  Log In
Search

READ ONLY MODE IS ACTIVATED

Post Reply
Posted 15 year(s) ago Re: # 5048

Rei
ダメ人間

Rei Avatar
10 Stars
Head Admin
Joined on 05-24-07
Posts 2102

Guild Software is still coming along... did some work today setting the country your Guild will hail from. Options include: Central, North, South, East and West.

I also want to be able to display country populations based on each members primary guild. Like, if you are a member of 50 guilds, we wont count you 50 times... only once, for your primary guild. I'm a little stuck how to do this...... guess I can force the guild order field to have to always have one guild with the value 1 (aka primary guild) just that it'll be hard to code that tight. I'd much rather use loose numbering... like you could have 10 #1's but only the first #1 in a MySQL sort would be counted..... but I dunno how to pull that off yet.


Also I'll be creating a complete monetary system. The council will be the central bank, and the guilds will be the banks that lend to the guild members. I also want there to be a Merchants Guild (think Spice and Wolf) where you pay the merchants guild a membership fee.... and so long as you uphold the tenets of your membership, you are allowed to buy and sell items through that guild, earning currency. I love the currency system in Dragon Age Origins... so we'll be using that.

100 bronze to 1 silver
100 silver to 1 gold

As said on IRC....


so much to do... i just wanttt to sleeeeeeep
Kuyukly, kenshin648_emrfish6 sportsrmyname
i want to create a Merchants Guild
on ACDB
any ideas how to make this possible, fair, and work?
i'll say what i've thought so far.. on the bus ride home
a merchants guild, eh
so people join a merchants guild.. they have to pay to be a member,
kinda like Lawrence in SPice and Wolf and his guild affiliation
so as a member of the guild.. they can buy and sell items... and they can also borrow
money from the guild to buy items
the guild can also sell all the items the merchants own.. but at a higher price..?
or.. the guild provides a list of all the merchants and what they sell?
oh! OK, importantL
the items people sell will include a lot of things
BOOKS - text based items. they'll have an icon, a title, and content. the contnent is
hidden until bought
once bought.. you own a full copy you can do whatever you want with. can even sell
many of them
IMAGES - pretty images
the cover would be a thumbnail, and the content the full sized image
i'm also thinking of partnering with online content providers so that
we can sell Amazon credit
ANime Video downloads
itunes music
and other premium web content
but!
o-o
for any of that to be possible
i need one hell of a tight monitary system...
such that.... again everything is fair
and i don't want to be selling gold >< all of it is earned by barter. either selling
stuff you found, or stuff you made
the Council will be the central bank. Guilds will act like banks... they can borrow from
the council... thus increasing the amount of currency in the lands
(oh ya! every guild gets to choose it's land. North SOuth East or West. eventually...
we'll name the countries.. and use a google map to locate cities and guilds)
kinda like the Fiary Tail world map and the guilds on it... or Elder Scrolls and the provinces... lol
enough of that tangent
topic at hand
currency
OK
your thoughts?
* Jino shuts up
i'll start coding the foundation. most of the ideas go on top.
Hrm.
so we need Accounts and Transactions. given i want guilds to manage money,
they'll need accounts as well.
I don't really understand it, but it sounds ok if we can manage it.
ahhh ya.. my ideas are kinda all over the place :S
at the basic level.....
I want a currency system in our Guild World.
everything else.... is just talk on how it could look
How do people earn currency?
How much do they get, and when?
What can they do with it?
How are the amount of currency in the world controled and managed?
How is new currency added?
How is existing currency destroyed?
How can insanely high prices be avoided?
How can we avoid horders?
How can we keep it fair where most people have the same amount of currency?
What can people buy?
What can people sell?
Where do they buy it?
How do they find it?
Why would they buy it?
X_X
Economy is scary...
if you have an awesome answer to any of those. tell me. or if you want my
answer so far to any... just ask
hahaha not nearly as scary as politics! and we have that too! lol
Kuyukly, you'll need to start a guild so i can appoint you to some of the various
prestigious commetities. lol
anyways.. back to the economic aspect
Trade disputes....
like.. i already see it being a problem... someone makes an image.. someone
buys it... then that buyer starts selling it
the original creator gets pissed off
and wants them to stop
soooooo we need a commitity! some kinda of Trade Dispute Orginization..
where complaints can be forwarded and resolved. lol
since there will be transaction records... it'd be possible to transfer any money
from sales back to the person
or.. hmm... well.. huh...
i also want... the option to LOCK in things before they are sold
such that no modifications can be made
cause i was thinking... do people buy a COPY or a REFERENCE ?
COPY means... well duplicating the data...... waste of space
REFERENCE means passing an ID
but if the content can be changed.. then someone might buy something that is
ever changing. BAD
so passing a LOCKED reference.. saves space. kinda think of it as Publishing
they write a book, publish it... and if they want to make changes.. well publish a v2 or a v3... ya
BUT what if they are selling URL's ? can't lock those. actually, can hardly verify those.....
so this is what the Merchants GUilds are for
if people get into a guild... so long as they maintain crediability...
they stay in the guild, and they can be trusted, right?
cause if they screw someone over, they'd be kicked out of the guild
ahhhhhh!! damnit. so many things that have to be done before all of this can
fit together :S:S:S::S:S:S:S
what;'s the right order?!?!?!?!?
* Jino jumps off a cliff
x_x;
* Jino respawns
OK.. so.... in the guilds table.... i'll make Parents Guild... if > 0 then it is a
subguild AKA commitity AKA meh
as for the bank accounts
do i need anything more than
an id and balance?
oh.. right.. uid or guildid
anything else?
should be enough
then the transation records....
i could use several fields
to someone, from someone, to guild, from guild
or i could use a chooser field, and one reference
hmm hmmm
4*4 bytes... vs 1+4 bytes....
given there could be billions of these
guess i'll go with the 1+4....... 5 bytes * a billion is a lot less than 16 btes * a billion. lol
gah
now how do i query and present this info.... the transations...
will need to transate the references into names of course.. but...
2 of them use e107.e107_user.user_name from translations, and the other 2
user char1.guilds .... how to do these.. in one query.. doing translations on 3 tables...
and orderting them by date..
blast.. not easy..
maybe the wrong approach.. huh.. but how else could it be done..
unless... i go with this... and LEFT JOIN blah ON blah.blah = blah AND blah = blah
LEFT JOIN blah ON blah.blah = blah AND blah = blah ..... maybe buy ahhh damnit.. the
SELECT portion... will vary depenind on the JOIN....
er.. hmm..ahh
sweeeeeeeeeet! it CAN be done. but done best if the columns match up...
the query looks really crazy, but it works! it works! haha
8D
mysql> SELECT guild_transations.*,a.name,b.name,c.user_name,d.user_name FROM
guild_transations LEFT JOIN guilds AS a ON a.id = tr_from AND tr_type IN(3,4) LEFT JOIN guilds AS
b ON b.id = tr_to AND tr_type IN(1,4) LEFT JOIN e107.e107_user AS c ON tr_from = c.user_id AND
tr_type IN(1,2) LEFT JOIN e107.e107_user AS d ON tr_to = d.user_id AND tr_type IN(2,3);
+----+---------+-------+------------+------------+---------+------------+------------+-----------+-----------+
| id | tr_from | tr_to | tr_ammount | tr_date | tr_type | name | name | user_name | user_name |
+----+---------+-------+------------+------------+---------+------------+------------+-----------+-----------+
| 1 | 1 | 1 | 111111 | 1262117845 | 1 | NULL | Fairy Tail | Rei | NULL |
| 2 | 1 | 1 | 111111 | 1262117846 | 2 | NULL | NULL | Rei | Rei |
| 3 | 1 | 1 | 111111 | 1262117847 | 3 | Fairy Tail | NULL | NULL | Rei |
| 4 | 1 | 1 | 111111 | 1262117848 | 4 | Fairy Tail | Fairy Tail | NULL | NULL |
+----+---------+-------+------------+------------+---------+------------+------------+-----------+-----------+
4 rows in set (0.06 sec)
ir works.... LOL
nothing coffee and doughtnuts can fuel my brain to solve
can't*
oh shit
i spelt transactions wrong..
http://pastebin.ca/1731086
too awesome. lol
rahhhh moderation work......
don't wanna do it :(
* Jino hacks a Duplicate
into submod.php
always wanted one of those... too lazy to code it until now. lol
having fun?
no



Anyways, will try to code some minor things tonight and New Year Eve and on New Years. I love working on holidays!!!

[ Edited Dec 30, 2009 ]
[Image]

私は日本語を少し読むと書くをできます。あなたも?

[Image]
Top PM Rei
Posted 15 year(s) ago Re: # 5744

Wish


Wish Avatar
1 Stars

Joined on 03-26-10
Posts 46

What's a Civilian rank? xP
Top PM Wish
Posted 15 year(s) ago Re: # 5752

Rei
ダメ人間

Rei Avatar
10 Stars
Head Admin
Joined on 05-24-07
Posts 2102

The lowest of ranks! hehe. Higher ranks reflect your level of trust, and general moderation abilities across the site. As I start implementing new moderation tools for user submitted content, the guild rank will play an important part. For now, it's just a fancy Star Trek title. ;-)

I still have big plans from our Guild System scattered across old posts here... The Guilds System remains a dream I hold dearest, but it'll have to wait until ACDBv2 is completed and the Forums are completed.... then! We'll all have fun merging in the Guild features into the site one by one.
[Image]

私は日本語を少し読むと書くをできます。あなたも?

[Image]
Top PM Rei
Posted 15 year(s) ago Re: # 5818

Alraune
Why hello there :3

Alraune Avatar
1 Stars

Joined on 05-14-10
Posts 4

Rei

Working on some alternative ranking sets this weekend.

Say, for example... being a long time fan of Star Trek TNG, their ranking system feels more natural to me. ^_^ And that includes:

Admiral, Captain, Commander, Lieutenant, Ensign, Crewman

Now, if there is a ranking system that you prefer, give me the titles, and a name for the system, then I can code it in and give you the option to select it.

I do like this type.. gives me a little of a military feeling too.. xd
Oh and hi.. Alraune here.. xd


[ Edited Jun 26, 2010 ]
[Image]
Top PM Alraune
Posted 15 year(s) ago Re: # 5819

Rei
ダメ人間

Rei Avatar
10 Stars
Head Admin
Joined on 05-24-07
Posts 2102

Hi Alraune! I saw your name a lot when modding comments, so I bumped up your rank to Lieutenant. While at the same time, the entire staff here has been demoted for being MIA. lol

13x31 and Alraune can change the rank of anyone ranked lower than them.
http://www.animecharactersdatabase.com/guildrank.php

I know lots of people use the forums and not the site, or the site and not the forums..... so until the new forum is finalized, the Guild System really only applies to the people on the main site.
[Image]

私は日本語を少し読むと書くをできます。あなたも?

[Image]
Top PM Rei
Posted 15 year(s) ago Re: # 5824

Kyareshi
The Plotmeister

Kyareshi Avatar
10 Stars

Joined on 01-08-09
Posts 940

Rei
I know lots of people use the forums and not the site

Yeah, sorry about that.

Hopefully that will change one day.
[Image]
Top PM Kyareshi
Posted 15 year(s) ago Re: # 5828

Alraune
Why hello there :3

Alraune Avatar
1 Stars

Joined on 05-14-10
Posts 4

Eheh I made a few contributions.. I'm happy to be of help.. ^^
I absolutely love anime and I was so happy when I found out about ACDB.. it also helped me in finding my actual favourite character.. xd
Just a question now.. characters in cg from and games JRPG can be added or are they required to be at least designed in anime style..? Sorry for being off topic..
[Image]
Top PM Alraune
Posted 15 year(s) ago Re: # 5830

Rei
ダメ人間

Rei Avatar
10 Stars
Head Admin
Joined on 05-24-07
Posts 2102

haha, no prob Kyareshi. i hope with the new forum, and gradual expansion of the guild software, you'll find more and more things to do on ACDB. ^_^

thanks Alraune. is your favourite character the same character in your avatar and signature image? :-) impressive graphic designing too!

any character someone somewhere might someday wonder "Who's that character and where are they from" - can be added to the database. So cg and JRPG characters are fine... but we'll need the character name, the title of the what they are from, and a URL to where people can find more info. ie) home page, wiki

which reminds me... i still need to code an ACDBv2 add character system, add title system, edit character system, and assign character system.

Try out the existing ones, and if any improvements come to mind, ask here and i shall code.
Source: https://www.animecharactersdatabase.com/addtitle.php
Character: https://www.animecharactersdatabase.com/submitforum.php
[Image]

私は日本語を少し読むと書くをできます。あなたも?

[Image]
Top PM Rei
Posted 15 year(s) ago Re: # 5837

Alraune
Why hello there :3

Alraune Avatar
1 Stars

Joined on 05-14-10
Posts 4

Yes, she is.. I know she's from um.. an eroge game but I liked the character alot.. xd Well thank you very much.. ^^
[Image]
Top PM Alraune


Post Reply