• Welcome to Mabinogi Duel Forum!
  • New themes...yay!
  • Specifics and feedback here
Hello There, Guest! Login RegisterLogin with Google+ FB

Dismiss this notice
A lot of smaller email providers seem to be blocking our activation mails. We are looking into this.

Known blocking providers: gmx (Germany), web.de (Germany), hostineuro (Germany), netsons (Italy), openmailbox.org (France)

Please use a gmail email address or contact an admin or mod in our chat to ask for a manual acitivation.

Dismiss this notice
Devcat did the unbelievable and revamped the whole game by dropping most of the tedious arenas and adding a weekly/monthly ladder system.
But pls check the update notes yourself:
Intro from devs,
Patch Notes, Rewards update,
New Summer Event


Card database - Suggestion, feedback & discussion thread (Phase: Brainstorming)
#1
This is planned to be the heart for nearly all automated feature in the forum:
Trading widget, daily mutant widget, card price widget and so on

Here the SQL structure for the cards database:
Code:
CARDS DB
Cards table
    - name (name plus set -> DragToHell_WNB) -> unique?-> ID?
    - set
    - card discussion forum link (via ingame name, since the set is irrelevant
    - mutant - yes/no -> redundant with the next?/card name
    - rotation mutant - yes/no -> redundant with table Rotation_mutants
    - Epoli's attributes:
        - Color
        - mutant "gene" -> redundant as well? -> Nah, we need that to filter out the mutants for the bad words DB for example
        - description
    - price link (current/last/median?)
    
Alternative_names table (abbreviations) - I try to make the card filter and other things work with this to make typing easier
    - ID
    - alt name
    - foreign key -> Cards_name [unique]


Rotation_mutants table
    - ID
    - foreign key -> Cards_name
    - when
    - drop chance

Ratings table
    - ID
    - foreign key -> Cards_name
    - rating
    - date
    - user
    - notes/reasons (optional)
    
Nerfs/boosts table
    - ID
    - foreign key -> Cards_name [unique]
    - what changed (old -> new)
    - date
    - user
    - notes/reasons (optional)

Price widget(selling!!!!) table
    - ID
    - foreign key -> Cards_name
    - price
    - date entered (sold?)
    - user
    
TRADING widget table
    - ID
    - foreign key -> Cards_name
    - set (auto from Cards_name) -> NOPE, per SELECT in the tool
    - condition
    - price
    - sell/buy
    - user
    - date entered

These are the tables I came up with so far.
If anyone knows what this is and has some more input on this, feel free to comment.
If you want to know more about specifics or what this is, just ask...I just didnt want to post a text wall if nobody reads it anyway.

Looking for rare/SE/AA/collab cards? -> my sales thread

If you want to support my work, send me some gems and/or leave some feedback Smile

 
Reply
  


Possibly Related Threads...
Thread Author Replies Views Last Post
  Arena Viewer (Top 10 decks) feedback thread sicut 5 1,478 03-28-2017, 09:40 AM
Last Post: sicut
Bug New Trading Widget - Suggestion, feedback & discussion thread (Phase: Brainstorming) sicut 34 8,899 02-01-2017, 06:35 PM
Last Post: sicut
Lightbulb Chat/Shoutbox - Suggestion, feedback & discussion thread InfiniteEvil 16 4,132 01-06-2017, 05:41 PM
Last Post: Khang
  Pricing Widget - Suggestion, feedback & discussion thread (Phase: Brainstorming) sicut 0 488 11-29-2016, 11:27 AM
Last Post: sicut
  [Suggestion] Card Color Camp Exclusivity Kasmot 5 1,469 08-08-2016, 05:30 AM
Last Post: sicut

Forum Jump:


Browsing: 1 Guest(s)