MySQL

Technická podpora k herním serverům Minecraft a Tekkit
Message
Autor
MinePublic
Příspěvky: 103
Registrován: 14 led 2013, 17:38
Reputation: 0

MySQL

#1 Příspěvekod MinePublic » 17 úno 2013, 20:58

Server: 93.91.250.126:27265
prosim neviem si s tim dat rady ako dam ultrabans, iconomy do mysql databazi dik
tu je confirm iconomy
Spoiler: zobrazit

Kód: Vybrat vše

# iConomy 6.0.8b
# @author     Nijikokun <nijikokun@gmail.com>
# @license    GPLv2
# @copyright  Copyright AniGaiku LLC (C) 2010-2011
##
# Setup Notes
#   - Seconds
#         Basic Table:
#           1 minute = 60 seconds
#           1 hour = 1 minute * 60 = 3600 seconds
#           1 day = 1 hour * 24 = 86400 seconds
#           1 week = 1 day * 7 = 604800 seconds
#   - Database
#           Do not use remote databases from free sites, please use either a
#           remote database from a personal hosted VPS or DEDI or a local
#           database. This will prevent any 'timeout' or 'invalid settings'
#           or 'cannot connect to database' issues. Thank you :)!
##

System:
  Permissions:
    Use:
      # Should a user have the 'iConomy.holdings' to use /money
      # By default this is false, so that people stop complaining that
      # iConomy doesn't work. Yes, people actually report that.
      # If you are one of those people, leave this false.
      Holdings: false

  Default:
    Currency:
      # Major is the first segment [Major].Minor

      # Major ([Major].Minor) 1.00 Dollar (With Seperate 1 Dollar)
      Major: [ 'Dollar', 'Dollars' ]

      # Minor (Major.[Minor]) 0.23 Coins  (With Seperate 0 Dollars, 23 Coins)
      Minor: [ 'Coin', 'Coins' ]

    Account:
      # Default account balance when created
      Holdings: 150.0

  # Controls how money is formatted through methods
  Formatting:
    # Minor allows you to use the Minor amounts for amounts <1
    # Example (true) 0.23 Coins and 1.23 Dollars (false) 0.23 Dollars and 1.23 Dollars
    Minor: false

    # Seperate allows your money to be shown in an alternative way,
    # instead of 1.32 it will show as 1 Dollar 23 Coins
    # !!! NOTICE: This only works if Minor is set to true !!!
    Seperate: false                               # Example (true) 1 Dollar, 23 Coins (false) 1.23 Dollars (Only if Minor is true)

    # Single shows your money in another alternative way.
    # Instead of 1.23 Dollars you will see: 1 Dollar.
    # If your money is 0.23 you will see 0 Dollars if Minor is false, 23 Coins if Minor is true.
    # !!! Notice: This overrides seperate !!!
    Single: false

  # Logs all monetary transactions passed through iConomy
  Logging:
    Enabled: false

  # Purges Default Balances at Loading
  # Good way to keep unused accounts or default accounts wiped out and lower database usage.
  Purging:
    Enabled: true

  # Controls amount of money gained at a set interval.
  Interest:
    Enabled: false

    # Only give interest to players who are currently online?
    Online: true

    Announce:
      # Send a message when the player gains interest?
      Enabled: false

    Interval:
      #  Interval is done in seconds, here is a easy reference table for commonly set intervals:
      #   1 minute = 60 seconds
      #   1 hour = 1 minute * 60 = 3600 seconds
      #   1 day = 1 hour * 24 = 86400 seconds
      #   1 week = 1 day * 7 = 604800 seconds
      Seconds: 60

    Amount:
      # The balance to be met where we stop giving interest.
      # 0.0 for no limit
      Cutoff: 0.0

      # Percentage of holdings to give / take (Negative to take) (Overrides Min/Max)
      Percent: 0.0

      # This is range based, to set a "flat" or "constant" rate, set each (Maximum and Minimum) to the same number.
      # If the two numbers are different, it will be a random amount in-between the two.
      Maximum: 1
      Minimum: 2

  Database:
    # Databases Supported:
    # Flatfile, FF, mini, minidb
    #  - These all equate to miniDB
    ##
    # item, items, inventory, inventoryDB
    #  - These all equate to InventoryDB, which uses inventory for storage
    ##
    # xp, exp, orb, xpdb, expdb, orbdb
    #  - These all equate to ExperienceDB, which relies on Experience for balance.
    ##
    # mysql, mysqldb
    #  - These will attempt to connect to MySQL
    ##
    # sqlite, sqlite2, sqlite3, sqlitedb
    #  - These will attempt to create & connect to SQLite
    ##
    # postgre, postgreSQL, postgreDB
    #  - These will attempt to connect to PostgreSQL
    Type: 'minidb'
   
    # These are for InventoryDB only.
    #
    # InventoryDB is essentially Physical Money.
    #   It isn't logged in a database, its based on the users inventory
    #   and the two items selected below.
    #
    # MajorItem is the item or block ID of the major currency
    # MinorItem is the item or block ID of the minor currency
    # e.g. MajorItem: 266, MinorItem: 265 for Gold/Iron
    MajorItem: 266
    MinorItem: 265

    # This controls the database name, by default it is iConomy
    Table: 'iConomy'

    # URL is for SQL Databases Only
    ##
    # Path to iConomy folder is easy, it's the COMPLETE path.
    # (Mine) G:\MineCraft\plugins\iConomy\
    # Won't be the same as yours, but it usually looks like that.
    ##
    # [H2DB Default] h2:path/to/iConomy/folder/iConomy;AUTO_RECONNECT=TRUE
    # [SQLite Default] sqlite:path/to/iConomy/folder/iConomy.db
    ##
    # Binary Databases use ip:port style connections.
    # ip
    #  - is the connection identifier (internet protocol)
    #  - for ipv6 usually encased in brackets [::1]
    # port
    #  - the port that the database is listening on
    #  - defaults: 3306 for mysql, postgre is either 5740 or 5432
    ##
    # [MySQL Default] mysql://localhost:3306/iConomy
    # [Postgre Default] postgresql://localhost:5740/iConomy
    URL: 'mysql://localhost:3306/iConomy'

    # Login details for binary databases
    Username: 'root'
    Password: ''

    ##############################################################
    # !!! Conversion is not your database settings !!!
    ##############################################################
    # Conversion allows you to convert your old 5.x to the new 6.x
    # All is currently unused.
    ##############################################################
    # URL is for MySQL only, H2DB doesn't use it.
    ##############################################################
    Conversion:
      # Set to True, After converting, change this back to false!
      Enabled: false

      # Database Type, H2DB or MySQL
      Type: 'MySQL'

      # Database Table
      Table: 'iConomy'

      # Database URL without table at the end.
      URL: 'mysql://localhost:3306'

      # Username / Password
      # H2DB does not use this. MySQL Only.
      Username: 'root'
      Password: ''

      # Unused ATM.
      All: true



tu je ultrabans
Spoiler: zobrazit

Kód: Vybrat vše

#Change to MySQL for mysql support#
#Change to SQLite for sqlite support#
Database: SQLite
#MySQL Information#
MySQL:
  Database: 'jdbc:mysql://localhost:3306/minecraft'
  User: 'root'
  Password: 'root'
  Table: 'banlist'
  IPTable: 'banlistip'
#SQLite Information#
SQLite:
  Filename: 'banlist'
#delete dat on ban#
CleanOnBan: true
#clear warnings on ban#
ClearWarnOnBan: false
Log:
  Enabled: true
#Max Warnings#
MaxWarning:
  Enable: false
  Amt: 5
  #ban,kick,ipban,perma,tempban,tempipban#
  Result: ban
  Silent: true
  Reason: 'Max Warnings'
  #Used with Temporary actions#
  Temp:
    Amt: 5
  #sec,min,hour,day,week,month#
    Mode: day
#Default labels#
Label:
  Console: 'Server'
  Reason: 'Unsure'
#change to true or false to enable lockdown#
#also can be done ingame /lockdown#
Lockdown: false
Login:
#Check for duplicates on Login#
  DupeCheck:
    Enable: true
#PingBack joining players, and kick if unreachable. //Experimental#
  ProxyPingBack:
    Enable: false
    #How long in milliseconds to Timeout#
    Timeout: 10000
#This will set the server to sync the database if multiple servers are in place.#
Sync:
  Enabled: false
  #Timing is in Long format Example:#
  #1 Hour = 60 Seconds * 60 Minutes * 20 ServerTickRatePerSec = 72000L
  Timing: 72000L
#Auto Updater#
AutoUpdater:
  Enabled: true
#Chat#
Chat:
  #Checks Chat Messages for a valid IP address#
  #If its not valid, trust me they can't connect to it#
  IPCheck:
    Enable: true
    #Wildcards %scramble% will scramble the ip and %replace% will show your ip instead#
    #If no wildcards are present the message entered will replace the ip#
    #leave blank to erase#
    Blocking: '{Block}'
    #kick,jail,warn,ban,ipban, leave blank for no action#
    Result: warn
    Silent: false
    Reason: 'Advertising'
  #This will allow you to filter out messages containing any words that you define#
  SwearCensor:
    Enable: true
    #Use your imagination these are not for me to decide#
    Words: 'test testing tests'
    #Wildcards %scramble% will scramble the word#
    #If no wildcards are present the message entered will replace the word#
    #leave blank to erase#
    Blocking: '{Block}'
    #kick,jail,warn,ban,ipban, leave blank for no action#
    Result: warn
    Silent: false
    Reason: 'Language'
  #Checks if the message is duplicate and disables it#
  SpamCheck:
    Enable: true
    #The amount of messages to give a result#
    Counter: 10
    #kick,jail,warn,ban,ipban, leave blank for no action#
    Result: kick
    Silent: false
    Reason: 'Spam'
Muted:
  Vannila: true
  #When Vanilla: true allowed commands.#
  AllowedCommands:
  - '/login'
  - '/register'
#Jail Configuration#
Jail:
  Mute: true
  Vanilla: true
  #When Vanilla: true allowed commands.#
  AllowedCommands:
  - '/login'
  - '/register'
Messages:
  Ban:
    MsgToVictim: '&6You have been banned by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was banned by &7%admin%&6. Reason: &7%reason%&6!'
    Failed: '&4%victim%&c is already in banned.'
    Denied: '&cYour ban attempt has been denied!'
    Emo: '&cYou cannot ban yourself!'
    Login: '&7%admin%&6 banned you from this server! Reason: &7%reason%&6!'
  CheckBan:
    Header: '&6Found &7%amt%&6 records for &7%victim%&6.'
    None: '&cNo records found for &4%victim%&c.'
  Clean:
    Complete: '&6Deleted &7%amt%&6 player.dat files.'
  DupeIP:
    Failed: '&cUnable to view ip for &4%victim% &c!'
    Header: '&6Scanning Current IP of &7%victim%&6: &7%ip% !'
    Completed: '&aScanning Complete!'
  Empty:
    MsgToVictim: '&7%admin%&6 has cleared your inventory!'
    MsgToSender: '&7%admin%&6 has cleared the inventory of &7%victim%&6!'
    Online: '&4%victim%&c must be online.'
  Export:
    Failed: '&cCould not export ban lists.'
    Completed: '&aExported banlists.'
  History:
    Header: '&6Ultrabans Listing &7%amt%&6 Records.'
    Failed: '&cUnable to find any bans.'
  Import:
    Loading: '&cBe patient. Loading...'
    Failed: '&cCould not import ban list.'
    Completed: '&aSystem imported the banlist to the database.'
  InvOf:
    Failed: '&cUnable to find player.'
    Console: '&cThis command must be executed by a &4player&c.'
  IPBan:
    MsgToVictim: '&6You have been ipbanned by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was ipbanned by &7%admin%&6. Reason: &7%reason%&6!'
    IPNotFound: '&cIP address not found. &6Processed as a normal ban for &7%victim%&6!'
    Failed: '&4%victim%&c is already in banned.'
    Denied: '&cYour ipban attempt has been denied!'
    Emo: '&cYou cannot ipban yourself!'
    Login: '&7Your IP is banned!'
  Jail:
    MsgToVictim: '&6You have been jailed by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was jailed by &7%admin%&6. Reason: &7%reason%&6!'
    SetJail: '&aJail has been set!'
    SetRelease: '&aRelease has been set!'
    Failed: '&4%victim%&c is already in jail.'
    Online: '&4%victim%&c must be online to be jailed.'
    Denied: '&cYour jail attempt has been denied!'
    Emo: '&cYou cannot jail yourself!'
    PlaceMsg: '&cYou cannot place blocks while you are jailed!'
    BreakMsg: '&cYou cannot break blocks while you are jailed!'
  Kick:
    MsgToAll: '&6Everyone has been kicked by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToVictim: '&6You have been kicked by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was kicked by &7%admin%&6. Reason: &7%reason%&6!'
    Online: '&4%victim%&c must be online.'
    Denied: '&cYour kick has been denied!'
    Emo: '&cYou cannot kick yourself!'
  Lockdown:
    Start: '&cLockdown initiated. &4Player Login&c disabled.'
    End: '&aLockdown ended. &2Player Login&a reenabled.'
    Status: '&cLockdown is disabled.'
    LoginMsg: '&4Server is under a lockdown, Try again later!&c Sorry.'
  Mute:
    MuteMsgToSender: '&6You have muted &7%victim%&6.'
    MuteMsgToVictim: '&4You have been muted!'
    UnmuteMsgToSender: '&6You have unmuted &7%victim%&6.'
    UnmuteMsgToVictim: '&aYou have been unmuted.'
    Denied: '&cYour mute has been denied!'
    Emo: '&cYou cannot mute yourself!'
    Chat: '&cYour cry falls on deaf ears.'
  Pardon:
    Msg: '&7%victim%&6 was released from jail by &7%admin%&6!'
  PermaBan:
    MsgToVictim: '&6You have been permabanned by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was permabanned by &7%admin%&6. Reason: &7%reason%&6!'
    Failed: '&4%victim%&c is already banned.'
    Online: '&4%victim%&c must be online.'
    Denied: '&cYour permaban has been denied!'
    Emo: '&cYou cannot permaban yourself!'
  Spawn:
    MsgToVictim: '&cYou have been sent to spawn!'
    MsgToSender: '&7%victim%&6 is now at spawn!'
    Failed: '&4%victim%&c is not online.'
  Starve:
    MsgToVictim: '&cYou are now starving!'
    MsgToSender: '&6%victim%&7 is now starving!'
    Failed: '&4%victim%&c is not online.'
    Denied: '&cYour starve attempt has been denied!'
    Emo: '&cYou cannot starve yourself!'
  TempBan:
    MsgToVictim: '&6You have been tempbanned by &7%admin%&6 for &7%amt% %mode%s.&6 Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was tempbanned by &7%admin%&6 for &7%amt% %mode%s.&6 Reason: &7%reason%&6!'
    Failed: '&4%victim%&c is already tempbanned!'
    Denied: '&cYour tempban has been denied!'
    Emo: '&cYou cannot tempban yourself!'
    Login: '&6You have been tempbanned by &7%admin%&6 for &7%time%&6. Reason: &7%reason%&6!'
  TempIpBan:
    MsgToVictim: '&6You have been tempipbanned by &7%admin%&6 for &7%amt% %mode%s.&6 Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was tempipbanned by &7%admin%&6 for &7%amt% %mode%s.&6 Reason: &7%reason%&6!'
    Failed: '&4%victim%&c is already tempipbanned!'
    Denied: '&cYour tempipban has been denied!'
    Emo: '&cYou cannot tempipban yourself!'
    IPNotFound: '&cIP address not found.&6 Processed as a normal tempban for &7%victim%&6!'
  TempJail:
    MsgToVictim: '&6You have been tempjailed by &7%admin%&6 for &7%amt% %mode%s.&6 Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was tempjailed by &7%admin%&6 for &7%amt% %mode%s.&6 Reason: &7%reason%&6!'
    Failed: '&4%victim%&c is already jailed!'
    Denied: '&cYour tempjail has been denied!'
    Emo: '&cYou cannot tempjail yourself!'
  Unban:
    MsgToBroadcast: '&7%victim%&6 was unbanned by &7%admin%&6!'
    PermaBanned: '&cUnable to unban, &7%victim%&c was Permabanned.'
    Failed: '&4%victim%&c is already unbanned!'
  Warn:
    MsgToVictim: '&6You have been warned by &7%admin%&6. Reason: &7%reason%&6!'
    MsgToBroadcast: '&7%victim%&6 was warned by &7%admin%&6. Reason: &7%reason%&6!'
    Denied: '&cYour warning has been denied!'
    Emo: '&cYou cannot warn yourself!'
  MaxWarn:
    MsgToBroadcast: '&7%cmd%&6 performed by Ultrabans on &7%victim%&6. Reason: &7Reached Max Warnings&6!'
  Permission: 'You do not have the required permissions.'
#Do Not Change Values Below#
jail:
  x: 0
  y: 0
  z: 0
  yaw: 0
  pitch: 0

dakujem
Ked som ti pomohol daj mi Karmu

Uživatelský avatar
Mysteria
Příspěvky: 9122
Registrován: 26 pro 2009, 15:40
Reputation: 7
Bydliště: Česká republika
Kontaktovat uživatele:

Re: MySQL

#2 Příspěvekod Mysteria » 17 úno 2013, 21:02

A sekce návodu je tu pro srandu králíkům? viewtopic.php?f=85&t=3628


Zpět na „Minecraft, Tekkit“

Kdo je online

Uživatelé prohlížející si toto fórum: Žádní registrovaní uživatelé a 37 hostů