[Tutorial]Criando Website Com Xampp

[Piabeta Kun 359]

  Em 10/10/2013 em 12:09, Caliorta19 disse:

instalo esse xamp mais nao entra em localhost? fala q n encontrou o link....

liga o apache o mysql né meu caro!

[Alexclusive 687]

Baixem o xampp 1.7.3, ele é melhor...

[Lordbaxx 291]

Deu Certo Aqui Parabéns e Obrigado REP+

[oguisccp 0]

Erro

Mensagens do MySQL :

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

[Piabeta Kun 359]

  Em 17/10/2013 em 06:30, Druidoviskk disse:

Erro

Mensagens do MySQL :

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

 

http://127.0.0.1/security/xamppsecurity.php

 

defina a senha do root mano!

[Felliperenato 0]

Erro

Comando SQL:

[...]

Mensagens do MySQL :

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLite format 3' at line 1

alguem ajuda ? tenho noção nenhuma sobre isso ...

[BorgesRicardo 3]

Estava tudo certo aqui, até que eu liberei as portas e o mysql não quis mais dar start. Da esse erro aqui:

 

Erro resolvido, reinstalei o xampp e voltou a funcionar.

Editado Novembro 18, 2013 por BorgesRicardo

[mrs0beit 0]

Me ajudou muito tavo precisando de um topico deste valewwww

[zeruella 0]

Se alguem puder me ajudar eu to com probleminha na hora de executar meu server meu site ta tudo certim fumcionado so meu servidor que nao quer accesar deta base meu encryption tbm nao muda pra plain meu servidor so acc sha1

 

  Mostrar conteúdo oculto

 

accountManager = true
namelockManager = true
newPlayerChooseVoc = true
newPlayerSpawnPosX = 655
newPlayerSpawnPosY = 1014
newPlayerSpawnPosZ = 7
newPlayerTownId = 5
newPlayerLevel = 10
newPlayerMagicLevel = 1
generateAccountNumber = false
generateAccountSalt = false

useFragHandler = true
redSkullLength = 50 * 62 * 70 * 90
blackSkullLength = 64 * 72 * 80 * 95
dailyFragsToRedSkull = 150
weeklyFragsToRedSkull = 150
monthlyFragsToRedSkull = 150
dailyFragsToBlackSkull = dailyFragsToRedSkull
weeklyFragsToBlackSkull = weeklyFragsToRedSkull
monthlyFragsToBlackSkull = monthlyFragsToRedSkull
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = true
advancedFragList = false

notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 7 * 24 * 60 * 60
killsBanLength = 7 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 10
violationNameReportActionType = 2
autoBanishUnknownBytes = false

worldType = "open"
protectionLevel = 60
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 60 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = false
removeWeaponAmmunition = false
removeWeaponCharges = true
removeRuneCharges = true
whiteSkullTime = 15 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = false
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 6.8
stairhopDelay = 2 * 1000
pushCreatureDelay = 2 * 1000
deathContainerId = 1988
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true
fistBaseAttack = 7

worldId = 0
ip = "127.0.0.1"
bindOnlyGlobalAddress = false
loginPort = 7171
gamePort = 7172
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 1000
motd = "Bem vindo ao Azeroth Server!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Azeroth"
loginMessage = "Bem vindo ao Azeroth Server!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false

rsaPrime1 = "14299623962416399520070177382898895550795403345466153217470516082934737582776038882967213386204600674145392845853859217990626450972452084065728686565928113"
rsaPrime2 = "7630979195970404721891201847792002125535401292779123937207447574596692788513647179235335529307251350570728407373705564708871762033017096809910315212884101"
rsaPublic = "65537"
rsaModulus = "109120132967399429278860960508995541528237502902798129123468757937266291492576446330739696001110603907230888610072655818825358503429057592827629436413108566029093628212635953836686562675849720620786279431090218017681061521755056710823876476444260558147179707119674283982419152118103759076030616683978566631413"
rsaPrivate = "46730330223584118622160180015036832148732986808519344675210555262940258739805766860224610646919605860206328024326703361630109888417839241959507572247284807035235569619173792292786907845791904955103601652822519121908367187885509270025388641700821735345222087940578381210879116823013776808975766851829020659073"

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""  --- onde coloka senha  do meu root que foi criada
sqlDatabase = "azerothdetabase" essa e nome da detabase que eu criei
sqlFile = "otserv.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5

ingameGuildManagement = true
levelToFormGuild = 80
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20

highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 20

buyableAndSellableHouses = true
houseNeedPremium = false
bedsRequirePremium = false
levelToBuyHouse = 100
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 1000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false

timeBetweenActions = 200
timeBetweenExActions = 1000
hotkeyAimbotEnabled = true

mapName = "Azeroth.otbm"
mapAuthor = "Luan"
randomizeTiles = true
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = ""

defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"

startupDatabaseOptimization = true
updatePremiumStateAtStartup = true
confirmOutdatedVersion = false

formulaLevel = 5.0
formulaMagic = 1.0
bufferMutedOnSpellFailure = false
spellNameInsteadOfWords = false
emoteSpells = false
unifiedSpells = true

allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
addonsOnlyPremium = true

dataDirectory = "data/"
logsDirectory = "data/logs/"
bankSystem = true
displaySkillLevelOnAdvance = false
promptExceptionTracerErrorBox = true
maximumDoorLevel = 500
maxMessageBuffer = 4
tradeLimit = 100

separateVipListPerCharacter = false
vipListDefaultLimit = 20
vipListDefaultPremiumLimit = 100

saveGlobalStorage = true
useHouseDataStorage = false
storePlayerDirection = false

checkCorpseOwner = true
monsterLootMessage = 3
monsterLootMessageType = 25

ghostModeInvisibleEffect = false
ghostModeSpellEffects = true

idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
reportsExpirationAfterReads = 1
playerQueryDeepness = 2
tileLimit = 0
protectionTileLimit = 0
houseTileLimit = 0

freePremium = false
premiumForPromotion = false

blessings = true
blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecrement = 5
eachBlessReduction = 8

experienceStages = true
rateExperience = 30
rateExperienceFromPlayers = 0
rateSkill = 20.0
rateMagic = 18.0
rateLoot = 2.2
rateSpawn = 1

rateMonsterHealth = 1.0
rateMonsterMana = 1.0
rateMonsterAttack = 1.0
rateMonsterDefense = 1.0

rateStaminaLoss = 1
rateStaminaGain = 3
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 40 * 60
staminaRatingLimitBottom = 14 * 60
staminaLootLimit = 14 * 60
rateStaminaAboveNormal = 1.5
rateStaminaUnderNormal = 0.5
staminaThresholdOnlyPremium = true

experienceShareRadiusX = 30
experienceShareRadiusY = 30
experienceShareRadiusZ = 1
experienceShareLevelDifference = 2 / 3
extraPartyExperienceLimit = 20
extraPartyExperiencePercent = 5
experienceShareActivity = 2 * 60 * 1000

globalSaveEnabled = false
globalSaveHour = 8
globalSaveMinute = 0
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = false

deSpawnRange = 2
deSpawnRadius = 50

maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = flse

statusPort = 7171
ownerName = "Azeroth"
ownerEmail = "luanmax21@hotmail.com"
url = ""
location = "Brazil"
displayGamemastersWithOnlineCommand = false

displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outputLog = ""
truncateLogOnStartup = false

managerPort = 7171
managerLogs = true
managerPassword = ""
managerLocalhostOnly = true
managerConnectionsLimit = 1

adminPort = 7171
adminLogs = true
adminPassword = ""
adminLocalhostOnly = true
adminConnectionsLimit = 1
adminRequireLogin = true
adminEncryption = ""
adminEncryptionData = ""

 

 

Meu servidor ta assim na hora de ligar

Editado Novembro 29, 2013 por Alexclusive
spoiler

[BorgesRicardo 3]

 

  Mostrar conteúdo oculto

 

  Em 28/11/2013 em 00:26, luanmax disse:

Se alguem puder me ajudar eu to com probleminha na hora de executar meu server meu site ta tudo certim fumcionado so meu servidor que nao quer accesar deta base meu encryption tbm nao muda pra plain meu servidor so acc sha1

accountManager = true
namelockManager = true
newPlayerChooseVoc = true
newPlayerSpawnPosX = 655
newPlayerSpawnPosY = 1014
newPlayerSpawnPosZ = 7
newPlayerTownId = 5
newPlayerLevel = 10
newPlayerMagicLevel = 1
generateAccountNumber = false
generateAccountSalt = false

useFragHandler = true
redSkullLength = 50 * 62 * 70 * 90
blackSkullLength = 64 * 72 * 80 * 95
dailyFragsToRedSkull = 150
weeklyFragsToRedSkull = 150
monthlyFragsToRedSkull = 150
dailyFragsToBlackSkull = dailyFragsToRedSkull
weeklyFragsToBlackSkull = weeklyFragsToRedSkull
monthlyFragsToBlackSkull = monthlyFragsToRedSkull
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = true
advancedFragList = false

notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 7 * 24 * 60 * 60
killsBanLength = 7 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 10
violationNameReportActionType = 2
autoBanishUnknownBytes = false

worldType = "open"
protectionLevel = 60
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 60 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = false
removeWeaponAmmunition = false
removeWeaponCharges = true
removeRuneCharges = true
whiteSkullTime = 15 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = false
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 6.8
stairhopDelay = 2 * 1000
pushCreatureDelay = 2 * 1000
deathContainerId = 1988
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true
fistBaseAttack = 7

worldId = 0
ip = "127.0.0.1"
bindOnlyGlobalAddress = false
loginPort = 7171
gamePort = 7172
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 1000
motd = "Bem vindo ao Azeroth Server!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Azeroth"
loginMessage = "Bem vindo ao Azeroth Server!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false

rsaPrime1 = "14299623962416399520070177382898895550795403345466153217470516082934737582776038882967213386204600674145392845853859217990626450972452084065728686565928113"
rsaPrime2 = "7630979195970404721891201847792002125535401292779123937207447574596692788513647179235335529307251350570728407373705564708871762033017096809910315212884101"
rsaPublic = "65537"
rsaModulus = "109120132967399429278860960508995541528237502902798129123468757937266291492576446330739696001110603907230888610072655818825358503429057592827629436413108566029093628212635953836686562675849720620786279431090218017681061521755056710823876476444260558147179707119674283982419152118103759076030616683978566631413"
rsaPrivate = "46730330223584118622160180015036832148732986808519344675210555262940258739805766860224610646919605860206328024326703361630109888417839241959507572247284807035235569619173792292786907845791904955103601652822519121908367187885509270025388641700821735345222087940578381210879116823013776808975766851829020659073"

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""  --- onde coloka senha  do meu root que foi criada
sqlDatabase = "azerothdetabase" essa e nome da detabase que eu criei
sqlFile = "otserv.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5

ingameGuildManagement = true
levelToFormGuild = 80
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20

highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 20

buyableAndSellableHouses = true
houseNeedPremium = false
bedsRequirePremium = false
levelToBuyHouse = 100
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 1000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false

timeBetweenActions = 200
timeBetweenExActions = 1000
hotkeyAimbotEnabled = true

mapName = "Azeroth.otbm"
mapAuthor = "Luan"
randomizeTiles = true
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = ""

defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"

startupDatabaseOptimization = true
updatePremiumStateAtStartup = true
confirmOutdatedVersion = false

formulaLevel = 5.0
formulaMagic = 1.0
bufferMutedOnSpellFailure = false
spellNameInsteadOfWords = false
emoteSpells = false
unifiedSpells = true

allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
addonsOnlyPremium = true

dataDirectory = "data/"
logsDirectory = "data/logs/"
bankSystem = true
displaySkillLevelOnAdvance = false
promptExceptionTracerErrorBox = true
maximumDoorLevel = 500
maxMessageBuffer = 4
tradeLimit = 100

separateVipListPerCharacter = false
vipListDefaultLimit = 20
vipListDefaultPremiumLimit = 100

saveGlobalStorage = true
useHouseDataStorage = false
storePlayerDirection = false

checkCorpseOwner = true
monsterLootMessage = 3
monsterLootMessageType = 25

ghostModeInvisibleEffect = false
ghostModeSpellEffects = true

idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
reportsExpirationAfterReads = 1
playerQueryDeepness = 2
tileLimit = 0
protectionTileLimit = 0
houseTileLimit = 0

freePremium = false
premiumForPromotion = false

blessings = true
blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecrement = 5
eachBlessReduction = 8

experienceStages = true
rateExperience = 30
rateExperienceFromPlayers = 0
rateSkill = 20.0
rateMagic = 18.0
rateLoot = 2.2
rateSpawn = 1

rateMonsterHealth = 1.0
rateMonsterMana = 1.0
rateMonsterAttack = 1.0
rateMonsterDefense = 1.0

rateStaminaLoss = 1
rateStaminaGain = 3
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 40 * 60
staminaRatingLimitBottom = 14 * 60
staminaLootLimit = 14 * 60
rateStaminaAboveNormal = 1.5
rateStaminaUnderNormal = 0.5
staminaThresholdOnlyPremium = true

experienceShareRadiusX = 30
experienceShareRadiusY = 30
experienceShareRadiusZ = 1
experienceShareLevelDifference = 2 / 3
extraPartyExperienceLimit = 20
extraPartyExperiencePercent = 5
experienceShareActivity = 2 * 60 * 1000

globalSaveEnabled = false
globalSaveHour = 8
globalSaveMinute = 0
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = false

deSpawnRange = 2
deSpawnRadius = 50

maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = flse

statusPort = 7171
ownerName = "Azeroth"
ownerEmail = "luanmax21@hotmail.com"
url = ""
location = "Brazil"
displayGamemastersWithOnlineCommand = false

displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outputLog = ""
truncateLogOnStartup = false

managerPort = 7171
managerLogs = true
managerPassword = ""
managerLocalhostOnly = true
managerConnectionsLimit = 1

adminPort = 7171
adminLogs = true
adminPassword = ""
adminLocalhostOnly = true
adminConnectionsLimit = 1
adminRequireLogin = true
adminEncryption = ""
adminEncryptionData = ""

Meu servidor ta assim na hora de ligar

 

 

 

 

 

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "" --- onde coloka senha do meu root que foi criada

sqlDatabase = "azerothdetabase" aqui é o nome da sua database

sqlFile = "otserv.s3db" aqui é aonde está sua database (tem q ter o msm nome da database ali em cima), repare se estiver na pasta "schemas", ficará assim: "schemas/otserv.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "sha1"

Em "sqldatabase" e "sqlfile" os nomes da database tem que ser iguais.

Editado Novembro 29, 2013 por Alexclusive
spoiler

[KaboFlow29 26]

STEP 3

Add tables and columns to DB

Installer try to add new tables and columns to database.

Add columns to table accounts

Can't add column page_lastday to table accounts, already exist?

Can't add column email_new to table accounts, already exist?

Can't add column email_new_time to table accounts, already exist?

Can't add column created to table accounts, already exist?

Can't add column rlname to table accounts, already exist?

Can't add column location to table accounts, already exist?

Can't add column page_access to table accounts, already exist?

Can't add column email_code to table accounts, already exist?

Can't add column next_email to table accounts, already exist?

Can't add column premium_points to table accounts, already exist?

Can't add column vote to table players, already exist?

Can't add column last posts to table accounts, already exist?

Can't add column flag to table accounts, already exist?

Add columns to table guilds

Can't add column description to table guilds, already exist?

Can't add column logo_gfx_name to table guilds, already exist?

Add columns to table players

Can't add column created to table players, already exist?

Can't add column nick_verify to table players, already exist?

Can't add column old_name to table players, already exist?

Can't add column hide_char to table players, already exist?

Can't add column worldtransfer to table players, already exist?

Can't add column comment to table players, already exist?

Can't add column comment to table players, already exist?

Can't add column comment to table players, already exist?

Can't add column comment to table players, already exist?

Can't add column comment to table players, already exist?

Can't add column comment to table players, already exist?

Add new tables to database

Table z_news_tickers not added. Already exist?

Table z_spells not added. Already exist?

Table z_monsters not added. Already exist?

Table z_ots_comunication not added. Already exist?

Table z_shop_offer not added. Already exist?

Table z_shop_history_item not added. Already exist?

Table z_shop_history_pacc not added. Already exist?

Table z_polls not added. Already exist?

Table z_polls_answers not added. Already exist?

Table zaypay_payment not added. Already exist?

Table z_bug_tracker not added. Already exist?

Table z_changelog not added. Already exist?

Table z_forum not added. Already exist?

 

Tables and columns added to database.

Go to STEP 4 - Add samples

STEP 5

Set Admin Account

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vip_time' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:237 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(237): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install.php(572): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 237

[zeruella 0]

KKK isso eu ja sei acho que o erro que seu executador nao liga em my sql

[5584759 0]

Bom tópico cara, só que eu fiz tudo certo pelo 8090 liberei tudo

entrei no site e deu, todo mundo entra só que o accounts, records,

personagens e outros não carrega.

Só carrega o CHAT, itens, saga e talz não sei que ta dando.

Me ajuda alguém ai por favor.

 

OLHEM O ERRO QUE DA DEPOIS DE UNS 5 MIN

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\site\include.inc.php on line 12

 

Obrigado. REP++ pra quem me ajuda

 

(MEU SITE É DE WODBO)

Editado Dezembro 10, 2013 por 5584759

[ultimate1996 102]

@5584759

Posta a linha 12 do arquivo include.inc.php que está no seu site.

 

 

p

 

[Killadors 1]

eu so nao entendi essa coisa de 8090 ajuda pf man