hello friends I have a problem installing my flux cp. when I try to install it (when I am asked for the db username and password) it gives me this error and it does not allow to continue.
This could be due to a variety of problems, such as a bug in the application.
However, normally it is caused by misconfiguration.
Exception Details
Error: PDOException
Message: SQLSTATE[HY000] [1130] Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server
File: /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php:81
File Line Function/Method
/storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php 81 PDO::__construct()
/storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php 94 Flux_Connection::connect()
/storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php 159 Flux_Connection::getConnection()
/storage/ssd2/501/6525501/public_html/fluxcp/modules/install/index.php 17 Flux_Connection::getStatement()
/storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Template.php 375 include()
/storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Dispatcher.php 170 Flux_Template::render()
/storage/ssd2/501/6525501/public_html/fluxcp/index.php 169 Flux_Dispatcher::dispatch()
Exception Trace As String
#0 /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php(81): PDO->__construct(*hidden*)
#1 /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config))
#2 /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php(159): Flux_Connection->getConnection()
#3 /storage/ssd2/501/6525501/public_html/fluxcp/modules/install/index.php(17): Flux_Connection->getStatement('SELECT VERSION(...')
#4 /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Template.php(375): include('/storage/ssd2/5...')
#5 /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Dispatcher.php(170): Flux_Template->render()
#6 /storage/ssd2/501/6525501/public_html/fluxcp/index.php(169): Flux_Dispatcher->dispatch(Array)
#7 {main}
Otherwise, when I configure it for a local server with wamp; in the local server does not give me that error.
this is my application.php configuration:
Spoiler
<?php
// This is the application configuration file. All values have been set to
// the default, and should be changed as needed.
return array(
'ServerAddress' => 'mywebhost', // This value is the hostname:port under which Flux runs. (e.g., example.com or example.com:80)
'BaseURI' => 'fluxcp', // The base URI is the base web root on which your application lies.
'InstallerPassword' => 'mysecretpass', // Installer/updater password.
'RequireOwnership' => true, // Require the executing user to be owner of the FLUX_ROOT/data/ directory tree? (Better for security)
// WARNING: This will be mostly IGNORED on non-POSIX-compliant OSes (e.g. Windows).
'DefaultLoginGroup' => null,
'DefaultCharMapServer' => null,
'DefaultLanguage' => 'en_us', // Specify the default control panel language (see FLUX_ROOT/lang/ directory for available languages.)
'SiteTitle' => 'SFJRO Control Panel', // This value is only used if the theme decides to use it.
'ThemeName' => array('default', 'bootstrap'), // Names of the themes you would like list for use in the footer. Themes are in FLUX_ROOT/themes.
'ScriptTimeLimit' => 0, // Script execution time limit. Specifies (in seconds) how long a page should run before timing out. (0 means forever)
'MissingEmblemBMP' => 'empty.bmp', //
'ItemIconNameFormat' => '%d.png', // The filename format for item icons (defaults to {itemid}.png).
'ItemImageNameFormat' => '%d.png', // The filename format for item images (defaults to {itemid}.png).
'MonsterImageNameFormat' => '%d.gif', // The filename format for monster images (defaults to {monsterid}.gif).
'JobImageNameFormat' => '%d.gif', // The filename format for job images (defaults to {jobid}.gif).
'ForceEmptyEmblem' => false, // Forcefully display empty guild emblems, helpful when you don't have GD2 installed.
'EmblemCacheInterval' => 12, // Hourly interval to re-cache guild emblems (set to 0 to disable emblem cache).
'SessionCookieExpire' => 48, // Duration in hours.
'AdminMenuGroupLevel' => AccountLevel::LOWGM, // The starting group ID for which module actions are moved into the admin menu for display.
'DateDefaultTimezone' => 'UTC', // The default timezone, consult the PHP manual for valid timezones: http://php.net/timezones (null for defaut system TZ)
'DateFormat' => 'Y-m-d', // Default DATE format to be displayed in pages.
'DateTimeFormat' => 'Y-m-d H:i:s', // Default DATETIME format to be displayed in pages.
'ShowSinglePage' => true, // Whether or not to show the page numbers even if there's only one page.
'ResultsPerPage' => 20, // The number of results to display in a paged set, per page.
'PagesToShow' => 10, // The number of page numbers to display at once.
'PageJumpMinimumPages' => 1, // Minimum number of required pages before page jump box is shown. (0 to always show!)
'ShowPageJump' => true, // Whether or not to show the "Page Jump" box.
'SingleMatchRedirect' => true, // Whether or not to redirect to view action from index page if only one match is returned (and action is allowed).
'SingleMatchRedirectItem' => false, // Same as above, for item module.
'SingleMatchRedirectMobs' => false, // Same as above, for monster module.
'UsernameAllowedChars' => 'a-zA-Z0-9_', // PCRE Format Pattern. default: 'a-zA-Z0-9_' (alphanumeric and underscore)
// WARNING: This string isn't escaped so be careful which chars you use!
// PCRE Pattern Ref: http://php.net/manual/en/pcre.pattern.php
'MinUsernameLength' => 4, // Minimum username length.
'MaxUsernameLength' => 23, // Maximum username length.
'MinPasswordLength' => 8, // Minimum password length.
'MaxPasswordLength' => 31, // Maximum password length.
'PasswordMinUpper' => 1, // Number of upper-case letters to require in passwords.
'PasswordMinLower' => 1, // Number of lower-case letters to require in passwords.
'PasswordMinNumber' => 1, // Number of numbers to require in passwords.
'PasswordMinSymbol' => 0, // Number of symbols to require in passwords.
'GMMinPasswordLength' => 8, // Minimum password length for GM accounts.
'GMPasswordMinUpper' => 1, // Number of upper-case letters to require in passwords for GM accounts.
'GMPasswordMinLower' => 1, // Number of lower-case letters to require in passwords for GM accounts.
'GMPasswordMinNumber' => 1, // Number of numbers to require in passwords for GM accounts.
'GMPasswordMinSymbol' => 1, // Number of symbols to require in passwords for GM accounts.
'RandomPasswordLength' => 16, // This is the length of the random password generated by the "Reset Password" feature. (NOTE: Hardcoded minimum value of
'AllowUserInPassword' => false, // Whether or not to allow the password to contain the username. (NOTE: A case-insensitive search is performed)
'AllowDuplicateEmails' => false, // Whether or not to allow duplicate e-mails to be used in registration. (See Mailer config options)
'RequireEmailConfirm' => false, // Require e-mail confirmation during registration.
'RequireChangeConfirm' => false, // Require confirmation when changing e-mail addresses.
'EmailConfirmExpire' => 48, // E-mail confirmations expire hours. Unconfirmed accounts will expire after this period of time.
'PincodeEnabled' => true, // Whether or not the pincode system is enabled in your server. (Check your char_athena.conf file. Enabled by default.)
'MailerFromAddress' => 'noreply@localhost', // The e-mail address displayed in the From field.
'MailerFromName' => 'MailerName', // The name displayed with the From e-mail address.
'MailerUseSMTP' => false, // Whether or not to use a separate SMTP server for sending mail.
'MailerSMTPUseSSL' => false, // Whether or not mailer should connect using SSL (yes for GMail).
'MailerSMTPUseTLS' => false, // Same as above SSL setting, but for TLS. This setting will override the SSL setting.
'MailerSMTPPort' => null, // When MailerUseSMTP is true: SMTP server port (mailer will default to 25).
'MailerSMTPHosts' => null, // When MailerUseSMTP is true: A string host or array of hosts (e.g., 'host1' or array('host1', 'backuphost')).
'MailerSMTPUsername' => null, // When MailerUseSMTP is true: Authorized username for SMTP server.
'MailerSMTPPassword' => null, // When MailerUseSMTP is true: Authorized password for SMTP server (for above user).
'ServerStatusCache' => 2, // Store a cached server status and refresh every X minutes. Default: 2 minutes (value is measured in minutes).
'ServerStatusTimeout' => 2, // For each server, spend X amount of seconds to determine whether it's up or not.
'SessionKey' => 'fluxSessionData', // Shouldn't be changed, just specifies the session key to be used for session data.
'DefaultModule' => 'main', // This is the module to execute when none has been specified.
'DefaultAction' => 'index', // This is the default action for any module, probably should leave this alone. (Deprecated)
'GzipCompressOutput' => false, // Whether or not to compress output using zlib.
'GzipCompressionLevel' => 9, // zlib compression level. (1~9)
'OutputCleanHTML' => true, // Use this if you have Tidy installed to clean your HTML output when serving pages.
'ShowCopyright' => true, // Whether or not to show the copyright footer.
'ShowRenderDetails' => true, // Shows the "page rendered in X seconds" and "number of queries executed: X" in the default theme.
'UseCleanUrls' => false, // Set to true if you're running Apache and it supports mod_rewrite and .htaccess files.
'DebugMode' => false, // Set to false to minimize technical details from being output by Flux. WARNING: DO NOT USE THIS OPTION ON A PUBLICALLY-ACCESSIBLE CP.
'UseCaptcha' => true, // Use CAPTCHA image for account registration to prevent automated account creations. (Requires GD2/FreeType2)
'UseLoginCaptcha' => false, // Use CAPTCHA image for account logins. (Requires GD2/FreeType2)
'EnableReCaptcha' => false, // Enables the use of reCAPTCHA instead of Flux's native GD2 library (http://www.google.com/recaptcha)
'ReCaptchaPublicKey' => '...', // This is your reCAPTCHA public key [REQUIRED FOR RECAPTCHA] (sign up at http://www.google.com/recaptcha)
'ReCaptchaPrivateKey' => '...', // This is your reCAPTCHA private key [REQUIRED FOR RECAPTCHA] (sign up at http://www.google.com/recaptcha)
'ReCaptchaTheme' => 'light', // ReCaptcha theme to use (Value: dark or light) (see: https://developers.google.com/recaptcha/docs/display#render_param)
'DisplaySinglePages' => true, // Whether or not to display paging for single page results.
'ForwardYears' => 15, // (Visual) The number of years to display ahead of the current year in date inputs.
'BackwardYears' => 30, // (Visual) The number of years to display behind the current year in date inputs.
'ColumnSortAscending' => ' ▲', // (Visual) Text displayed for ascending sorted column names.
'ColumnSortDescending' => ' ▼', // (Visual) Text displayed for descending sorted column names.
'CreditExchangeRate' => 1.0, // The rate at which credits are exchanged for dollars.
'MinDonationAmount' => 2.0, // Minimum donation amount. (NOTE: Actual donations made that are less than this account won't be exchanged)
'DonationCurrency' => 'USD', // Preferred donation currency. Only donations made in this currency will be processed for credit deposits.
'MoneyDecimalPlaces' => 2, // (Visual) Number of decimal places to display in amount.
'MoneyThousandsSymbol' => ',', // (Visual) Thousandths place separator (a period in European currencies).
'MoneyDecimalSymbol' => '.', // (Visual) Decimal separator (a comma in European currencies).
'AcceptDonations' => true, // Whether or not to accept donations.
'PayPalIpnUrl' => 'www.sandbox.paypal.com',// The URL for PayPal's IPN responses (www.paypal.com for live and www.sandbox.paypal.com for testing)
'PayPalBusinessEmail' => 'admin@localhost', // Enter the e-mail under which you have registered your business account.
'PayPalReceiverEmails' => array( // These are the receiver e-mail addresses who are allowed to receive payment.
//'admin2@localhost', // -- This array may be empty if you only use one e-mail
//'admin3@localhost' // -- because your Business Email is also checked.
),
'PaypalHackNotify' => true, // Send email notification if hack attempt detected (Notification will be send for each address in list PayPalBusinessEmail and PayPalReceiverEmails)
'GStorageLeaderOnly' => false, // Only allow guild leader to view guild storage rather than all members?
'DivorceKeepChild' => false, // Keep child after divorce?
'DivorceKeepRings' => false, // Keep wedding rings after divorce?
'IpWhitelistPattern' => // PCRE Format Pattern. It's recommended you add your gameserver, webserver and server owner's IPs here.
'(127\.0\.0\.1|0(\.[0\*]){3})', // WARNING: This string isn't escaped so be careful which chars you use!
// By default, whitelists 127.0.0.1 (localhost) and 0.0.0.0 (all interfaces; whitelists all wildcard bans that can achive this too)
'AllowIpBanLogin' => false, // Allow logging into account from banned IP.
'AllowTempBanLogin' => false, // Allow logging in of temporarily banned accounts.
'AllowPermBanLogin' => false, // Allow logging in of permanently banned accounts.
'AutoRemoveTempBans' => true, // Automatically remove expired temporary bans on certain pages.
'ItemShopMaxCost' => 99, // Max price an item can be sold for.
'ItemShopMaxQuantity' => 99, // Max quantity the item may be sold at once for.
'ItemShopItemPerPage' => 5, // The number of items to display per page in the "Item Shop" page.
'ShowItemDesc' => false, // Displays generated item descs from parsed itemInfo.lua
'HideFromWhosOnline' => AccountLevel::LOWGM, // Levels greater than or equal to this will be hidden from the "Who's Online" page.
'HideFromMapStats' => AccountLevel::LOWGM, // Levels greater than or equal to this will be hidden from the "Map Stats" page.
'EnableGMPassSecurity' => AccountLevel::LOWGM, // Levels greater than or equal to this will be required to use passwords that meet the earlier GM Password settings.
'ChargeGenderChange' => 0, // You can specify this as the number of credits to charge for gender change. Can be 0 for free change.
'BanPaymentStatuses' => array( // Payment statuses that will automatically ban the account owner if received.
'Cancelled_Reversal', // -- 'Cancelled_Reversal'
'Reversed', // -- 'Reversed'
),
'HoldUntrustedAccount' => 0, // This is the time in hours to hold a donation crediting process for, if the account
// isn't a trusted account. Specify 0 or false to disable this feature.
'AutoUnholdAccount' => false, // Enable this to auto-unhold an account and credit it if the transaction is still
// valid. This only applies if you are using the HoldUnstrustedAccount feature.
// If you want to run a cron job instead, you can make a request to the '/donate/update'
// module/action with the InstallerPassword as the password to run the update task.
// With clean URLs: http://<server>/<baseURI>/donate/update?password=<InstallerPassword>
// Without clean URLs: http://<server>/<baseURI>?module=donate&action=update&password=<InstallerPassword>
// NOTE: This option is HIGHLY inefficient, it's recommended to run a cron job instead.
'AutoPruneAccounts' => false, // Enable this to automatically prune expired accounts. Enabling this is a performance
// performance killer. See 'AutoUnholdAccount' for running this task as a cron job,
// the module is 'account' and the action is 'prune'.
// With clean URLs: http://<server>/<baseURI>/account/prune?password=<InstallerPassword>
// Without clean URLs: http://<server>/<baseURI>?module=account&action=prune&password=<InstallerPassword>
'ShopImageExtensions' => array( // These are the image extensions allowed for uploading in the item shop.
'png', 'jpg', 'gif', 'bmp', 'jpeg'
),
'NoResetPassGroupLevel' => AccountLevel::LOWGM, // Minimum group level of account to prevent password reset using control panel.
'RankingHideGroupLevel' => AccountLevel::LOWGM, //
'InfoHideZenyGroupLevel' => AccountLevel::LOWGM, // Minimum group level of account to hide zeny from in server information page.
'CharRankingThreshold' => 0, // Number of days the character must have logged in within to be listed in character ranking. (0 = disabled)
'ZenyRankingThreshold' => 0, // Number of days the character must have logged in within to be listed in zeny ranking. (0 = disabled)
'DeathRankingThreshold' => 0, // Number of days the character must have logged in within to be listed in death ranking. (0 = disabled)
'AlchemistRankingThreshold' => 0, // Number of days the character must have logged in within to be listed in death ranking. (0 = disabled)
'HomunRankingThreshold' => 0, // Number of days the character must have logged in within to be listed in homunculus ranking. (0 = disabled)
'HideTempBannedCharRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedCharRank' => true, // Hide permanently banned characters from ranking.
'HideTempBannedZenyRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedZenyRank' => true, // Hide permanently banned characters from ranking.
'HideTempBannedDeathRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedDeathRank' => true, // Hide permanently banned characters from ranking.
'HideTempBannedAlcheRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedAlcheRank' => true, // Hide permanently banned characters from ranking.
'HideTempBannedSmithRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedSmithRank' => true, // Hide permanently banned characters from ranking.
'HideTempBannedStats' => false, // Hide temporarily banned accounts from statistics.
'HidePermBannedStats' => true, // Hide permanently banned accounts from statistics.
'HideTempBannedHomunRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedHomunRank' => true, // Hide permanently banned characters from ranking.
'SortJobsByAmount' => false, // Sort job class information on statistics page by descending quantity (false = Sort by Job ID).
'CpLoginLogShowPassword' => false, // Show password in CP login log (also see access.php's SeeCpLoginLogPass).
'CpResetLogShowPassword' => false, // Show password in CP "password resets" log (also see access.php's SeeCpResetPass).
'CpChangeLogShowPassword' => false, // Show password in CP "password changes" log (also see access.php's SeeCpChangePass).
'AdminMenuNewStyle' => true, // Use new-style admin menu; Applies to 'default' theme.
'EnablePeakDisplay' => true, // Display Peak User count on Server Status page.
// News Options
'CMSNewsOnHomepage' => true, // Display News on Home Page instead of "You've Just Installed FluxCP" message?
'CMSNewsType' => 1, // Type = source of news feed:
// 1 = Built-in news page
// 2 = RSS Import
'CMSNewsRSS' => 'https://rathena.org/board/rss/1-latest-community-announcements.xml/', // Use if CMSNewsType = 2
'CMSNewsLimit' => 4, // Number of news items to display
'CMSDisplayModifiedBy' => false, // If a news item has been modified, display modified date under news item?
// Service Desk
'StaffReplyColour' => 'brown',
'FontResolvedColour' => 'green',
'FontPendingColour' => 'orange',
'FontClosedColour' => 'darkgrey',
'SDEnableCreditRewards' => true, // Show option in Service Desk to reward player X credits for reporting bugs/abuse/etc.
'SDCreditReward' => 10, // Number of credits to award account.
'AllowMD5PasswordSearch' => false,
'ReallyAllowMD5PasswordSearch' => false, // Are you POSITIVELY sure?
// Specifies which modules and actions should be ignored by Tidy
// (enabled/disabled by the OutputCleanHTML option).
'TidyIgnore' => array(
array('module' => 'captcha'),
array('module' => 'guild', 'action' => 'emblem')
),
// Job classes, loaded from another file to avoid cluttering this one.
// There isn't normally a need to modify this file, unless it's been
// modified in an update. (In English: DON'T TOUCH THIS.)
'JobClasses' => include('jobs.php'),
// Alchemist job classes, mostly used for alchemist rankings.
// Should be left alone unless new alchemist-related job classes are introduced.
'AlchemistJobClasses' => include('jobs_alchemist.php'),
// Blacksmith job classes, mostly used for blacksmith rankings.
// Should be left alone unless new blacksmith-related job classes are introduced.
'BlacksmithJobClasses' => include('jobs_blacksmith.php'),
// Gender-linked Job class IDs and their corresponding names.
// Should be left alone unless new gender-specific job classes are introduced.
'GenderLinkedJobClasses' => include('jobs_gender_linked.php'),
// Homunculus class IDs and their corresponding names.
// Best not to mess with this either.
'HomunClasses' => include('homunculus.php'),
// Item Types with their corresponding names.
// Shouldn't touch this either.
'ItemTypes' => include('itemtypes.php'),
// Special Item Types with their corresponding names (For Weapons & Ammo by default).
// Shouldn't touch this either.
'ItemTypes2' => include('itemtypes2.php'),
// Common Equip Location Combinations with their corresponding names.
// Shouldn't touch this unless you've added custom combinations.
'EquipLocationCombinations' => include('equip_location_combinations.php'),
// Error Code -> Error Type mapping.
// Shouldn't need touching, however modifying loginerrors.php should be relatively safe.
'LoginErrors' => include('loginerrors.php'),
// rA equip jobs mapping.
'EquipJobs' => include('equip_jobs.php'),
// rA equip locations mapping.
'EquipLocations' => include('equip_locations.php'),
// rA equip upper mapping.
'EquipUpper' => include('equip_upper.php'),
// rA monster sizes mapping.
'MonsterSizes' => include('sizes.php'),
// rA monster races mapping.
'MonsterRaces' => include('races.php'),
// rA elements mapping.
'Elements' => include('elements.php'),
// rA attributes mapping.
'Attributes' => include('attributes.php'),
// rA monster modes mapping.
'MonsterModes' => include('monstermode.php'),
<?php
return array(
// Example server configuration. You may have more arrays like this one to
// specify multiple server groups (however they should share the same login
// server whilst they are allowed to have multiple char/map pairs).
array(
'ServerName' => 'SFJRO',
// Global database configuration (excludes logs database configuration).
'DbConfig' => array(
//'Socket' => '/tmp/mysql.sock',
//'Port' => 3306,
//'Encoding' => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is.
'Convert' => 'utf8',
// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
'Hostname' => 'my vps ip',
'Username' => 'my username',
'Password' => 'pass',
'Database' => 'database',
'Persistent' => true,
'Timezone' => null // Example: '+0:00' is UTC.
// The possible values of 'Timezone' is as documented from the MySQL website:
// "The value can be given as a string indicating an offset from UTC, such as '+10:00' or '-6:00'."
// "The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'." (see below continuation!)
// **"Named time zones can be used only if the time zone information tables in the mysql database have been created and populated."
),
// This is kept separate because many people choose to have their logs
// database accessible under different credentials, and often on a
// different server entirely to ensure the reliability of the log data.
'LogsDbConfig' => array(
//'Socket' => '/tmp/mysql.sock',
//'Port' => 3306,
//'Encoding' => null, // Connection encoding -- use whatever here your MySQL tables collation is.
'Convert' => 'utf8',
// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
'Hostname' => 'my vps ip',
'Username' => 'my username',
'Password' => 'pass',
'Database' => 'database',
'Persistent' => true,
'Timezone' => null // Possible values is as described in the comment in DbConfig.
),
// Login server configuration.
'LoginServer' => array(
'Address' => 'my vps ip',
'Port' => 6900,
'UseMD5' => false,
'NoCase' => true, // rA account case-sensitivity; Default: Case-INsensitive (true).
'GroupID' => 0, // Default account group ID during registration.
//'Database' => 'mydatabase'
),
'CharMapServers' => array(
array(
'ServerName' => 'SFJRO',
'Renewal' => true,
'MaxCharSlots' => 9,
'DateTimezone' => null, // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones)
'ResetDenyMaps' => 'sec_pri', // Defaults to 'sec_pri'. This value can be an array of map names.
// 'Database' => 'mydatabase', // Defaults to DbConfig.Database
'ExpRates' => array(
'Base' => 100, // Rate at which (base) exp is given
'Job' => 100, // Rate at which job exp is given
'Mvp' => 100 // MVP bonus exp rate
),
'DropRates' => array(
// The rate the common items (in the ETC tab, besides card) are dropped
'Common' => 100,
'CommonBoss' => 100,
// The rate healing items (that restore HP or SP) are dropped
'Heal' => 100,
'HealBoss' => 100,
// The rate usable items (in the item tab other then healing items) are dropped
'Useable' => 100,
'UseableBoss' => 100,
// The rate at which equipment is dropped
'Equip' => 100,
'EquipBoss' => 100,
// The rate at which cards are dropped
'Card' => 100,
'CardBoss' => 100,
// The rate adjustment for the MVP items that the MVP gets directly in their inventory
'MvpItem' => 100
),
'CharServer' => array(
'Address' => 'my vps ip',
'Port' => 6121
),
'MapServer' => array(
'Address' => 'my vps ip',
'Port' => 5121
),
// -- WoE days and times --
// First parameter: Starding day 0=Sunday / 1=Monday / 2=Tuesday / 3=Wednesday / 4=Thursday / 5=Friday / 6=Saturday
// Second parameter: Starting hour in 24-hr format.
// Third paramter: Ending day (possible value is same as starting day).
// Fourth (final) parameter: Ending hour in 24-hr format.
// ** (Note, invalid times are ignored silently.)
'WoeDayTimes' => array(
//array(0, '12:00', 0, '14:00'), // Example: Starts Sunday 12:00 PM and ends Sunday 2:00 PM
//array(3, '14:00', 3, '15:00') // Example: Starts Wednesday 2:00 PM and ends Wednesday 3:00 PM
),
// Modules and/or actions to disallow access to during WoE.
'WoeDisallow' => array(
array('module' => 'character', 'action' => 'online'), // Disallow access to "Who's Online" page during WoE.
array('module' => 'character', 'action' => 'mapstats') // Disallow access to "Map Statistics" page during WoE.
)
)
)
)
);
?>
Question
geminy05
hello friends I have a problem installing my flux cp. when I try to install it (when I am asked for the db username and password) it gives me this error and it does not allow to continue.
This could be due to a variety of problems, such as a bug in the application. However, normally it is caused by misconfiguration. Exception Details Error: PDOException Message: SQLSTATE[HY000] [1130] Host 'xxx.xxx.xxx.xxx' is not allowed to connect to this MySQL server File: /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php:81 File Line Function/Method /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php 81 PDO::__construct() /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php 94 Flux_Connection::connect() /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php 159 Flux_Connection::getConnection() /storage/ssd2/501/6525501/public_html/fluxcp/modules/install/index.php 17 Flux_Connection::getStatement() /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Template.php 375 include() /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Dispatcher.php 170 Flux_Template::render() /storage/ssd2/501/6525501/public_html/fluxcp/index.php 169 Flux_Dispatcher::dispatch() Exception Trace As String #0 /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php(81): PDO->__construct(*hidden*) #1 /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config)) #2 /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Connection.php(159): Flux_Connection->getConnection() #3 /storage/ssd2/501/6525501/public_html/fluxcp/modules/install/index.php(17): Flux_Connection->getStatement('SELECT VERSION(...') #4 /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Template.php(375): include('/storage/ssd2/5...') #5 /storage/ssd2/501/6525501/public_html/fluxcp/lib/Flux/Dispatcher.php(170): Flux_Template->render() #6 /storage/ssd2/501/6525501/public_html/fluxcp/index.php(169): Flux_Dispatcher->dispatch(Array) #7 {main}Otherwise, when I configure it for a local server with wamp; in the local server does not give me that error.
this is my application.php configuration:
<?php
// This is the application configuration file. All values have been set to
// the default, and should be changed as needed.
return array(
'ServerAddress' => 'mywebhost', // This value is the hostname:port under which Flux runs. (e.g., example.com or example.com:80)
'BaseURI' => 'fluxcp', // The base URI is the base web root on which your application lies.
'InstallerPassword' => 'mysecretpass', // Installer/updater password.
'RequireOwnership' => true, // Require the executing user to be owner of the FLUX_ROOT/data/ directory tree? (Better for security)
// WARNING: This will be mostly IGNORED on non-POSIX-compliant OSes (e.g. Windows).
'DefaultLoginGroup' => null,
'DefaultCharMapServer' => null,
'DefaultLanguage' => 'en_us', // Specify the default control panel language (see FLUX_ROOT/lang/ directory for available languages.)
'SiteTitle' => 'SFJRO Control Panel', // This value is only used if the theme decides to use it.
'ThemeName' => array('default', 'bootstrap'), // Names of the themes you would like list for use in the footer. Themes are in FLUX_ROOT/themes.
'ScriptTimeLimit' => 0, // Script execution time limit. Specifies (in seconds) how long a page should run before timing out. (0 means forever)
'MissingEmblemBMP' => 'empty.bmp', //
'ItemIconNameFormat' => '%d.png', // The filename format for item icons (defaults to {itemid}.png).
'ItemImageNameFormat' => '%d.png', // The filename format for item images (defaults to {itemid}.png).
'MonsterImageNameFormat' => '%d.gif', // The filename format for monster images (defaults to {monsterid}.gif).
'JobImageNameFormat' => '%d.gif', // The filename format for job images (defaults to {jobid}.gif).
'ForceEmptyEmblem' => false, // Forcefully display empty guild emblems, helpful when you don't have GD2 installed.
'EmblemCacheInterval' => 12, // Hourly interval to re-cache guild emblems (set to 0 to disable emblem cache).
'SessionCookieExpire' => 48, // Duration in hours.
'AdminMenuGroupLevel' => AccountLevel::LOWGM, // The starting group ID for which module actions are moved into the admin menu for display.
'DateDefaultTimezone' => 'UTC', // The default timezone, consult the PHP manual for valid timezones: http://php.net/timezones (null for defaut system TZ)
'DateFormat' => 'Y-m-d', // Default DATE format to be displayed in pages.
'DateTimeFormat' => 'Y-m-d H:i:s', // Default DATETIME format to be displayed in pages.
'ShowSinglePage' => true, // Whether or not to show the page numbers even if there's only one page.
'ResultsPerPage' => 20, // The number of results to display in a paged set, per page.
'PagesToShow' => 10, // The number of page numbers to display at once.
'PageJumpMinimumPages' => 1, // Minimum number of required pages before page jump box is shown. (0 to always show!)
'ShowPageJump' => true, // Whether or not to show the "Page Jump" box.
'SingleMatchRedirect' => true, // Whether or not to redirect to view action from index page if only one match is returned (and action is allowed).
'SingleMatchRedirectItem' => false, // Same as above, for item module.
'SingleMatchRedirectMobs' => false, // Same as above, for monster module.
'UsernameAllowedChars' => 'a-zA-Z0-9_', // PCRE Format Pattern. default: 'a-zA-Z0-9_' (alphanumeric and underscore)
// WARNING: This string isn't escaped so be careful which chars you use!
// PCRE Pattern Ref: http://php.net/manual/en/pcre.pattern.php
'MinUsernameLength' => 4, // Minimum username length.
'MaxUsernameLength' => 23, // Maximum username length.
'MinPasswordLength' => 8, // Minimum password length.
'MaxPasswordLength' => 31, // Maximum password length.
'PasswordMinUpper' => 1, // Number of upper-case letters to require in passwords.
'PasswordMinLower' => 1, // Number of lower-case letters to require in passwords.
'PasswordMinNumber' => 1, // Number of numbers to require in passwords.
'PasswordMinSymbol' => 0, // Number of symbols to require in passwords.
'GMMinPasswordLength' => 8, // Minimum password length for GM accounts.
'GMPasswordMinUpper' => 1, // Number of upper-case letters to require in passwords for GM accounts.
'GMPasswordMinLower' => 1, // Number of lower-case letters to require in passwords for GM accounts.
'GMPasswordMinNumber' => 1, // Number of numbers to require in passwords for GM accounts.
'GMPasswordMinSymbol' => 1, // Number of symbols to require in passwords for GM accounts.
'RandomPasswordLength' => 16, // This is the length of the random password generated by the "Reset Password" feature. (NOTE: Hardcoded minimum value of
'AllowUserInPassword' => false, // Whether or not to allow the password to contain the username. (NOTE: A case-insensitive search is performed)
'AllowDuplicateEmails' => false, // Whether or not to allow duplicate e-mails to be used in registration. (See Mailer config options)
'RequireEmailConfirm' => false, // Require e-mail confirmation during registration.
'RequireChangeConfirm' => false, // Require confirmation when changing e-mail addresses.
'EmailConfirmExpire' => 48, // E-mail confirmations expire hours. Unconfirmed accounts will expire after this period of time.
'PincodeEnabled' => true, // Whether or not the pincode system is enabled in your server. (Check your char_athena.conf file. Enabled by default.)
'MailerFromAddress' => 'noreply@localhost', // The e-mail address displayed in the From field.
'MailerFromName' => 'MailerName', // The name displayed with the From e-mail address.
'MailerUseSMTP' => false, // Whether or not to use a separate SMTP server for sending mail.
'MailerSMTPUseSSL' => false, // Whether or not mailer should connect using SSL (yes for GMail).
'MailerSMTPUseTLS' => false, // Same as above SSL setting, but for TLS. This setting will override the SSL setting.
'MailerSMTPPort' => null, // When MailerUseSMTP is true: SMTP server port (mailer will default to 25).
'MailerSMTPHosts' => null, // When MailerUseSMTP is true: A string host or array of hosts (e.g., 'host1' or array('host1', 'backuphost')).
'MailerSMTPUsername' => null, // When MailerUseSMTP is true: Authorized username for SMTP server.
'MailerSMTPPassword' => null, // When MailerUseSMTP is true: Authorized password for SMTP server (for above user).
'ServerStatusCache' => 2, // Store a cached server status and refresh every X minutes. Default: 2 minutes (value is measured in minutes).
'ServerStatusTimeout' => 2, // For each server, spend X amount of seconds to determine whether it's up or not.
'SessionKey' => 'fluxSessionData', // Shouldn't be changed, just specifies the session key to be used for session data.
'DefaultModule' => 'main', // This is the module to execute when none has been specified.
'DefaultAction' => 'index', // This is the default action for any module, probably should leave this alone. (Deprecated)
'GzipCompressOutput' => false, // Whether or not to compress output using zlib.
'GzipCompressionLevel' => 9, // zlib compression level. (1~9)
'OutputCleanHTML' => true, // Use this if you have Tidy installed to clean your HTML output when serving pages.
'ShowCopyright' => true, // Whether or not to show the copyright footer.
'ShowRenderDetails' => true, // Shows the "page rendered in X seconds" and "number of queries executed: X" in the default theme.
'UseCleanUrls' => false, // Set to true if you're running Apache and it supports mod_rewrite and .htaccess files.
'DebugMode' => false, // Set to false to minimize technical details from being output by Flux. WARNING: DO NOT USE THIS OPTION ON A PUBLICALLY-ACCESSIBLE CP.
'UseCaptcha' => true, // Use CAPTCHA image for account registration to prevent automated account creations. (Requires GD2/FreeType2)
'UseLoginCaptcha' => false, // Use CAPTCHA image for account logins. (Requires GD2/FreeType2)
'EnableReCaptcha' => false, // Enables the use of reCAPTCHA instead of Flux's native GD2 library (http://www.google.com/recaptcha)
'ReCaptchaPublicKey' => '...', // This is your reCAPTCHA public key [REQUIRED FOR RECAPTCHA] (sign up at http://www.google.com/recaptcha)
'ReCaptchaPrivateKey' => '...', // This is your reCAPTCHA private key [REQUIRED FOR RECAPTCHA] (sign up at http://www.google.com/recaptcha)
'ReCaptchaTheme' => 'light', // ReCaptcha theme to use (Value: dark or light) (see: https://developers.google.com/recaptcha/docs/display#render_param)
'DisplaySinglePages' => true, // Whether or not to display paging for single page results.
'ForwardYears' => 15, // (Visual) The number of years to display ahead of the current year in date inputs.
'BackwardYears' => 30, // (Visual) The number of years to display behind the current year in date inputs.
'ColumnSortAscending' => ' ▲', // (Visual) Text displayed for ascending sorted column names.
'ColumnSortDescending' => ' ▼', // (Visual) Text displayed for descending sorted column names.
'CreditExchangeRate' => 1.0, // The rate at which credits are exchanged for dollars.
'MinDonationAmount' => 2.0, // Minimum donation amount. (NOTE: Actual donations made that are less than this account won't be exchanged)
'DonationCurrency' => 'USD', // Preferred donation currency. Only donations made in this currency will be processed for credit deposits.
'MoneyDecimalPlaces' => 2, // (Visual) Number of decimal places to display in amount.
'MoneyThousandsSymbol' => ',', // (Visual) Thousandths place separator (a period in European currencies).
'MoneyDecimalSymbol' => '.', // (Visual) Decimal separator (a comma in European currencies).
'AcceptDonations' => true, // Whether or not to accept donations.
'PayPalIpnUrl' => 'www.sandbox.paypal.com',// The URL for PayPal's IPN responses (www.paypal.com for live and www.sandbox.paypal.com for testing)
'PayPalBusinessEmail' => 'admin@localhost', // Enter the e-mail under which you have registered your business account.
'PayPalReceiverEmails' => array( // These are the receiver e-mail addresses who are allowed to receive payment.
//'admin2@localhost', // -- This array may be empty if you only use one e-mail
//'admin3@localhost' // -- because your Business Email is also checked.
),
'PaypalHackNotify' => true, // Send email notification if hack attempt detected (Notification will be send for each address in list PayPalBusinessEmail and PayPalReceiverEmails)
'GStorageLeaderOnly' => false, // Only allow guild leader to view guild storage rather than all members?
'DivorceKeepChild' => false, // Keep child after divorce?
'DivorceKeepRings' => false, // Keep wedding rings after divorce?
'IpWhitelistPattern' => // PCRE Format Pattern. It's recommended you add your gameserver, webserver and server owner's IPs here.
'(127\.0\.0\.1|0(\.[0\*]){3})', // WARNING: This string isn't escaped so be careful which chars you use!
// By default, whitelists 127.0.0.1 (localhost) and 0.0.0.0 (all interfaces; whitelists all wildcard bans that can achive this too)
'AllowIpBanLogin' => false, // Allow logging into account from banned IP.
'AllowTempBanLogin' => false, // Allow logging in of temporarily banned accounts.
'AllowPermBanLogin' => false, // Allow logging in of permanently banned accounts.
'AutoRemoveTempBans' => true, // Automatically remove expired temporary bans on certain pages.
'ItemShopMaxCost' => 99, // Max price an item can be sold for.
'ItemShopMaxQuantity' => 99, // Max quantity the item may be sold at once for.
'ItemShopItemPerPage' => 5, // The number of items to display per page in the "Item Shop" page.
'ShowItemDesc' => false, // Displays generated item descs from parsed itemInfo.lua
'HideFromWhosOnline' => AccountLevel::LOWGM, // Levels greater than or equal to this will be hidden from the "Who's Online" page.
'HideFromMapStats' => AccountLevel::LOWGM, // Levels greater than or equal to this will be hidden from the "Map Stats" page.
'EnableGMPassSecurity' => AccountLevel::LOWGM, // Levels greater than or equal to this will be required to use passwords that meet the earlier GM Password settings.
'ChargeGenderChange' => 0, // You can specify this as the number of credits to charge for gender change. Can be 0 for free change.
'BanPaymentStatuses' => array( // Payment statuses that will automatically ban the account owner if received.
'Cancelled_Reversal', // -- 'Cancelled_Reversal'
'Reversed', // -- 'Reversed'
),
'HoldUntrustedAccount' => 0, // This is the time in hours to hold a donation crediting process for, if the account
// isn't a trusted account. Specify 0 or false to disable this feature.
'AutoUnholdAccount' => false, // Enable this to auto-unhold an account and credit it if the transaction is still
// valid. This only applies if you are using the HoldUnstrustedAccount feature.
// If you want to run a cron job instead, you can make a request to the '/donate/update'
// module/action with the InstallerPassword as the password to run the update task.
// With clean URLs: http://<server>/<baseURI>/donate/update?password=<InstallerPassword>
// Without clean URLs: http://<server>/<baseURI>?module=donate&action=update&password=<InstallerPassword>
// NOTE: This option is HIGHLY inefficient, it's recommended to run a cron job instead.
'AutoPruneAccounts' => false, // Enable this to automatically prune expired accounts. Enabling this is a performance
// performance killer. See 'AutoUnholdAccount' for running this task as a cron job,
// the module is 'account' and the action is 'prune'.
// With clean URLs: http://<server>/<baseURI>/account/prune?password=<InstallerPassword>
// Without clean URLs: http://<server>/<baseURI>?module=account&action=prune&password=<InstallerPassword>
'ShopImageExtensions' => array( // These are the image extensions allowed for uploading in the item shop.
'png', 'jpg', 'gif', 'bmp', 'jpeg'
),
'NoResetPassGroupLevel' => AccountLevel::LOWGM, // Minimum group level of account to prevent password reset using control panel.
'CharRankingLimit' => 20, //
'GuildRankingLimit' => 20, //
'ZenyRankingLimit' => 20, //
'DeathRankingLimit' => 20, //
'AlchemistRankingLimit' => 20, //
'BlacksmithRankingLimit' => 20, //
'HomunRankingLimit' => 20, //
'MVPRankingLimit' => 20, //
'RankingHideGroupLevel' => AccountLevel::LOWGM, //
'InfoHideZenyGroupLevel' => AccountLevel::LOWGM, // Minimum group level of account to hide zeny from in server information page.
'CharRankingThreshold' => 0, // Number of days the character must have logged in within to be listed in character ranking. (0 = disabled)
'ZenyRankingThreshold' => 0, // Number of days the character must have logged in within to be listed in zeny ranking. (0 = disabled)
'DeathRankingThreshold' => 0, // Number of days the character must have logged in within to be listed in death ranking. (0 = disabled)
'AlchemistRankingThreshold' => 0, // Number of days the character must have logged in within to be listed in death ranking. (0 = disabled)
'HomunRankingThreshold' => 0, // Number of days the character must have logged in within to be listed in homunculus ranking. (0 = disabled)
'HideTempBannedCharRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedCharRank' => true, // Hide permanently banned characters from ranking.
'HideTempBannedZenyRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedZenyRank' => true, // Hide permanently banned characters from ranking.
'HideTempBannedDeathRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedDeathRank' => true, // Hide permanently banned characters from ranking.
'HideTempBannedAlcheRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedAlcheRank' => true, // Hide permanently banned characters from ranking.
'HideTempBannedSmithRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedSmithRank' => true, // Hide permanently banned characters from ranking.
'HideTempBannedStats' => false, // Hide temporarily banned accounts from statistics.
'HidePermBannedStats' => true, // Hide permanently banned accounts from statistics.
'HideTempBannedHomunRank' => false, // Hide temporarily banned characters from ranking.
'HidePermBannedHomunRank' => true, // Hide permanently banned characters from ranking.
'SortJobsByAmount' => false, // Sort job class information on statistics page by descending quantity (false = Sort by Job ID).
'CpLoginLogShowPassword' => false, // Show password in CP login log (also see access.php's SeeCpLoginLogPass).
'CpResetLogShowPassword' => false, // Show password in CP "password resets" log (also see access.php's SeeCpResetPass).
'CpChangeLogShowPassword' => false, // Show password in CP "password changes" log (also see access.php's SeeCpChangePass).
'AdminMenuNewStyle' => true, // Use new-style admin menu; Applies to 'default' theme.
'EnablePeakDisplay' => true, // Display Peak User count on Server Status page.
// News Options
'CMSNewsOnHomepage' => true, // Display News on Home Page instead of "You've Just Installed FluxCP" message?
'CMSNewsType' => 1, // Type = source of news feed:
// 1 = Built-in news page
// 2 = RSS Import
'CMSNewsRSS' => 'https://rathena.org/board/rss/1-latest-community-announcements.xml/', // Use if CMSNewsType = 2
'CMSNewsLimit' => 4, // Number of news items to display
'CMSDisplayModifiedBy' => false, // If a news item has been modified, display modified date under news item?
// Service Desk
'StaffReplyColour' => 'brown',
'FontResolvedColour' => 'green',
'FontPendingColour' => 'orange',
'FontClosedColour' => 'darkgrey',
'SDEnableCreditRewards' => true, // Show option in Service Desk to reward player X credits for reporting bugs/abuse/etc.
'SDCreditReward' => 10, // Number of credits to award account.
// Discord Webhooks
'DiscordUseWebhook' => false,
'DiscordWebhookURL' => 'enter_webhook_url_from_discord_here',
'DiscordSendOnRegister' => true,
'DiscordSendOnNewTicket' => true,
'DiscordSendOnWebCommand' => true,
'DiscordSendOnMarketing' => true,
// These are the main menu items that should be displayed by themes.
// They route to modules and actions. Whether they are displayed or
// not at any given time depends on the user's account group level and/or
// their login status.
'MenuItems' => array(
'MainMenuLabel' => array(
'HomeLabel' => array('module' => 'main'),
//'ForumLabel' => array('exturl' => 'http://www.fluxro.com/community'), // External forum link
//'ForumLabel' => array('module' => 'forums'), // Built-in forum link
'NewsLabel' => array('module' => 'news'),
// Sample items for pages function.
'DownloadsLabel' => array('module' => 'pages','action'=>'content&path=downloads'),
'RulesLabel' => array('module' => 'pages','action'=>'content&path=rules'),
// End sample items for pages function.
),
'AccountLabel' => array(
'AccountCreateHeading' => array('module' => 'account', 'action' => 'create'),
'LoginTitle' => array('module' => 'account', 'action' => 'login'),
'MyAccountLabel' => array('module' => 'account', 'action' => 'view'),
'HistoryLabel' => array('module' => 'history'),
'ServiceDeskLabel' => array('module' => 'servicedesk'),
'LogoutTitle' => array('module' => 'account', 'action' => 'logout'),
),
'DonationsLabel' => array(
'PurchaseLabel' => array('module' => 'purchase'),
'DonateLabel' => array('module' => 'donate'),
),
'InformationLabel' => array(
'ServerInfoLabel' => array('module' => 'server', 'action' => 'info'),
'ServerStatusLabel' => array('module' => 'server', 'action' => 'status'),
'WoeHoursLabel' => array('module' => 'woe'),
'CastlesLabel' => array('module' => 'castle'),
'WhosOnlineLabel' => array('module' => 'character', 'action' => 'online'),
'MapStaticsLabel'=> array('module' => 'character', 'action' => 'mapstats'),
'RankingInfoLabel' => array('module' => 'ranking', 'action' => 'character'),
'VendingInfoLabel' => array('module' => 'vending'),
'BuyingstoreInfoLabel' => array('module' => 'buyingstore'),
),
'DatabaseLabel' => array(
'ItemDatabaseLabel' => array('module' => 'item'),
'MobDatabaseLabel' => array('module' => 'monster'),
),
'SocialLabel' => array(
'JoinUsInFacebookLabel' => array('exturl' => 'https://www.facebook.com/<change_me>'),
'RateUsOnRMSLabel' => array('exturl' => '<link_to_RMS>'),
),
'Service Desk' => array(
'ServiceDeskLabel' => array('module' => 'servicedesk', 'action' => 'staffindex'),
),
'Misc. Stuff' => array(
'AccountLabel' => array('module' => 'account'),
'CharacterLabel' => array('module' => 'character'),
'CPLogsLabel' => array('module' => 'cplog'),
'PagesLabel' => array('module' => 'pages'),
'NewsLabel' => array('module' => 'news', 'action' => 'manage'),
'GuildsLabel' => array('module' => 'guild'),
'IPBanListLabel' => array('module' => 'ipban'),
'rALogsLabel' => array('module' => 'logdata'),
'ReInstallLabel' => array('module' => 'install', 'action' => 'reinstall'),
'SendMailLabel' => array('module' => 'mail'),
'WCTitleLabel' => array('module' => 'webcommands'),
'Cash Shop' => array('module' => 'cashshop'),
//'Auction' => array('module' => 'auction'),
//'Economy' => array('module' => 'economy')
)
),
// Sub-menu items that are displayed for any action belonging to a
// particular module. The format it simple.
'SubMenuItems' => array(
'history' => array(
'gamelogin' => 'Game Logins',
'cplogin' => 'CP Logins',
'emailchange' => 'E-Mail Changes',
'passchange' => 'Password Changes',
'passreset' => 'Password Resets'
),
'account' => array(
'index' => 'List Accounts',
'view' => 'View Account',
'changepass' => 'Change Password',
'changemail' => 'Change E-mail',
'changesex' => 'Change Gender',
'transfer' => 'Transfer Credits',
'xferlog' => 'Credit Transfer History',
'cart' => 'Go to Shopping Cart',
'login' => 'Login',
'create' => 'Register',
'resetpass' => 'Reset Password',
'resend' => 'Resend E-mail Confirmation'
),
'guild' => array(
'index' => 'List Guilds',
'export' => 'Export Guild Emblems'
),
'server' => array(
'status' => 'View Status',
'status-xml' => 'View Status as XML'
),
'logdata' => array(
'branch' => 'Branches',
'char' => 'Characters',
'cashpoints' => 'CashPoints',
'chat' => 'Chat Messages',
'command' => 'Commands',
'feeding' => 'Feeding',
'inter' => 'Interactions',
'pick' => 'Item Picks',
'login' => 'Logins',
'mvp' => 'MVP',
'npc' => 'NPC',
'zeny' => 'Zeny'
),
'cplog' => array(
'paypal' => 'PayPal Transactions',
'create' => 'Account Registrations',
'login' => 'Logins',
'resetpass' => 'Password Resets',
'changepass' => 'Password Changes',
'changemail' => 'E-mail Changes',
'ban' => 'Account Bans',
'ipban' => 'IP Bans'
),
'purchase' => array(
'index' => 'Shop',
'cart' => 'Go to Cart',
'checkout' => 'Checkout',
'clear' => 'Empty Cart',
'pending' => 'Pending Redemption'
),
'donate' => array(
'index' => 'Make a Donation',
'history' => 'Donation History',
'trusted' => 'Trusted PayPal E-mails'
),
'ipban' => array(
'index' => 'IP Ban List',
'add' => 'Add IP Ban'
),
'ranking' => array(
'character' => 'Characters',
'death' => 'Deaths',
'alchemist' => 'Alchemists',
'blacksmith' => 'Blacksmiths',
'homunculus' => 'Homunculus',
'mvp' => 'MVPs',
'guild' => 'Guilds',
'zeny' => 'Zeny'
),
'item' => array(
'index' => 'List Items',
'add' => 'Add Item',
'iteminfo' => 'Add Item Info',
),
'pages' => array(
'index' => 'Manage Pages',
'add' => 'Add New Page',
),
'news' => array(
'index' => 'Latest News',
'manage' => 'Manage',
'add' => 'Add News',
),
'servicedesk' => array(
'staffindex' => 'View Active',
'staffviewclosed'=> 'View Closed',
'staffsettings' => 'Staff Settings',
'catcontrol' => 'Category Control',
),
'vending' => array(
'index' => 'Vendors',
),
'buyingstore' => array(
'index' => 'Buyers',
),
),
'AllowMD5PasswordSearch' => false,
'ReallyAllowMD5PasswordSearch' => false, // Are you POSITIVELY sure?
// Specifies which modules and actions should be ignored by Tidy
// (enabled/disabled by the OutputCleanHTML option).
'TidyIgnore' => array(
array('module' => 'captcha'),
array('module' => 'guild', 'action' => 'emblem')
),
// Job classes, loaded from another file to avoid cluttering this one.
// There isn't normally a need to modify this file, unless it's been
// modified in an update. (In English: DON'T TOUCH THIS.)
'JobClasses' => include('jobs.php'),
// Alchemist job classes, mostly used for alchemist rankings.
// Should be left alone unless new alchemist-related job classes are introduced.
'AlchemistJobClasses' => include('jobs_alchemist.php'),
// Blacksmith job classes, mostly used for blacksmith rankings.
// Should be left alone unless new blacksmith-related job classes are introduced.
'BlacksmithJobClasses' => include('jobs_blacksmith.php'),
// Gender-linked Job class IDs and their corresponding names.
// Should be left alone unless new gender-specific job classes are introduced.
'GenderLinkedJobClasses' => include('jobs_gender_linked.php'),
// Homunculus class IDs and their corresponding names.
// Best not to mess with this either.
'HomunClasses' => include('homunculus.php'),
// Item Types with their corresponding names.
// Shouldn't touch this either.
'ItemTypes' => include('itemtypes.php'),
// Special Item Types with their corresponding names (For Weapons & Ammo by default).
// Shouldn't touch this either.
'ItemTypes2' => include('itemtypes2.php'),
// Common Equip Location Combinations with their corresponding names.
// Shouldn't touch this unless you've added custom combinations.
'EquipLocationCombinations' => include('equip_location_combinations.php'),
// Error Code -> Error Type mapping.
// Shouldn't need touching, however modifying loginerrors.php should be relatively safe.
'LoginErrors' => include('loginerrors.php'),
// rA equip jobs mapping.
'EquipJobs' => include('equip_jobs.php'),
// rA equip locations mapping.
'EquipLocations' => include('equip_locations.php'),
// rA equip upper mapping.
'EquipUpper' => include('equip_upper.php'),
// rA monster sizes mapping.
'MonsterSizes' => include('sizes.php'),
// rA monster races mapping.
'MonsterRaces' => include('races.php'),
// rA elements mapping.
'Elements' => include('elements.php'),
// rA attributes mapping.
'Attributes' => include('attributes.php'),
// rA monster modes mapping.
'MonsterModes' => include('monstermode.php'),
// Item shop categories.
'ShopCategories' => include('shopcategories.php'),
// Cash shop categories.
'CashShopCategories' => include('cashshopcategories.php'),
// Item pick and zeny log types.
'PickTypes' => include('picktypes.php'),
// Type of feeding
'FeedingTypes' => include('feedingtypes.php'),
// Castle names.
'CastleNames' => include('castlenames.php'),
// DON'T TOUCH. THIS IS FOR DEVELOPERS.
'FluxTables' => array(
'CreditsTable' => 'cp_credits',
'CreditTransferTable' => 'cp_xferlog',
'ItemShopTable' => 'cp_itemshop',
'TransactionTable' => 'cp_txnlog',
'RedemptionTable' => 'cp_redeemlog',
'AccountCreateTable' => 'cp_createlog',
'AccountBanTable' => 'cp_banlog',
'IpBanTable' => 'cp_ipbanlog',
'DonationTrustTable' => 'cp_trusted',
'AccountPrefsTable' => 'cp_loginprefs',
'CharacterPrefsTable' => 'cp_charprefs',
'ResetPasswordTable' => 'cp_resetpass',
'ChangeEmailTable' => 'cp_emailchange',
'LoginLogTable' => 'cp_loginlog',
'ChangePasswordTable' => 'cp_pwchange',
'OnlinePeakTable' => 'cp_onlinepeak',
'CMSNewsTable' => 'cp_cmsnews',
'CMSPagesTable' => 'cp_cmspages',
'CMSSettingsTable' => 'cp_cmssettings',
'ServiceDeskTable' => 'cp_servicedesk',
'ServiceDeskATable' => 'cp_servicedeska',
'ServiceDeskCatTable' => 'cp_servicedeskcat',
'ServiceDeskSettingsTable' => 'cp_servicedesksettings',
'WebCommandsTable' => 'cp_commands',
'ItemDescTable' => 'cp_itemdesc',
)
);
?>
and my servers.php config
<?php
return array(
// Example server configuration. You may have more arrays like this one to
// specify multiple server groups (however they should share the same login
// server whilst they are allowed to have multiple char/map pairs).
array(
'ServerName' => 'SFJRO',
// Global database configuration (excludes logs database configuration).
'DbConfig' => array(
//'Socket' => '/tmp/mysql.sock',
//'Port' => 3306,
//'Encoding' => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is.
'Convert' => 'utf8',
// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
'Hostname' => 'my vps ip',
'Username' => 'my username',
'Password' => 'pass',
'Database' => 'database',
'Persistent' => true,
'Timezone' => null // Example: '+0:00' is UTC.
// The possible values of 'Timezone' is as documented from the MySQL website:
// "The value can be given as a string indicating an offset from UTC, such as '+10:00' or '-6:00'."
// "The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'." (see below continuation!)
// **"Named time zones can be used only if the time zone information tables in the mysql database have been created and populated."
),
// This is kept separate because many people choose to have their logs
// database accessible under different credentials, and often on a
// different server entirely to ensure the reliability of the log data.
'LogsDbConfig' => array(
//'Socket' => '/tmp/mysql.sock',
//'Port' => 3306,
//'Encoding' => null, // Connection encoding -- use whatever here your MySQL tables collation is.
'Convert' => 'utf8',
// -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available.
// -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8)
'Hostname' => 'my vps ip',
'Username' => 'my username',
'Password' => 'pass',
'Database' => 'database',
'Persistent' => true,
'Timezone' => null // Possible values is as described in the comment in DbConfig.
),
// Login server configuration.
'LoginServer' => array(
'Address' => 'my vps ip',
'Port' => 6900,
'UseMD5' => false,
'NoCase' => true, // rA account case-sensitivity; Default: Case-INsensitive (true).
'GroupID' => 0, // Default account group ID during registration.
//'Database' => 'mydatabase'
),
'CharMapServers' => array(
array(
'ServerName' => 'SFJRO',
'Renewal' => true,
'MaxCharSlots' => 9,
'DateTimezone' => null, // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones)
'ResetDenyMaps' => 'sec_pri', // Defaults to 'sec_pri'. This value can be an array of map names.
// 'Database' => 'mydatabase', // Defaults to DbConfig.Database
'ExpRates' => array(
'Base' => 100, // Rate at which (base) exp is given
'Job' => 100, // Rate at which job exp is given
'Mvp' => 100 // MVP bonus exp rate
),
'DropRates' => array(
// The rate the common items (in the ETC tab, besides card) are dropped
'Common' => 100,
'CommonBoss' => 100,
// The rate healing items (that restore HP or SP) are dropped
'Heal' => 100,
'HealBoss' => 100,
// The rate usable items (in the item tab other then healing items) are dropped
'Useable' => 100,
'UseableBoss' => 100,
// The rate at which equipment is dropped
'Equip' => 100,
'EquipBoss' => 100,
// The rate at which cards are dropped
'Card' => 100,
'CardBoss' => 100,
// The rate adjustment for the MVP items that the MVP gets directly in their inventory
'MvpItem' => 100
),
'CharServer' => array(
'Address' => 'my vps ip',
'Port' => 6121
),
'MapServer' => array(
'Address' => 'my vps ip',
'Port' => 5121
),
// -- WoE days and times --
// First parameter: Starding day 0=Sunday / 1=Monday / 2=Tuesday / 3=Wednesday / 4=Thursday / 5=Friday / 6=Saturday
// Second parameter: Starting hour in 24-hr format.
// Third paramter: Ending day (possible value is same as starting day).
// Fourth (final) parameter: Ending hour in 24-hr format.
// ** (Note, invalid times are ignored silently.)
'WoeDayTimes' => array(
//array(0, '12:00', 0, '14:00'), // Example: Starts Sunday 12:00 PM and ends Sunday 2:00 PM
//array(3, '14:00', 3, '15:00') // Example: Starts Wednesday 2:00 PM and ends Wednesday 3:00 PM
),
// Modules and/or actions to disallow access to during WoE.
'WoeDisallow' => array(
array('module' => 'character', 'action' => 'online'), // Disallow access to "Who's Online" page during WoE.
array('module' => 'character', 'action' => 'mapstats') // Disallow access to "Map Statistics" page during WoE.
)
)
)
)
);
?>
Link to comment
Share on other sites
3 answers to this question
Recommended Posts