[ajuda XAMPP]

[Leolinduxo 0]

Quando netro em admin no xampp quando abre o localhost e clico nas steps para começar a criar site aparece esses erros nas steps.

 

step 2

Check database connection
If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.
Parse error: syntax error, unexpected ';', expecting T_FUNCTION in C:\xampp\htdocs\pot\OTS_DB_SQLite.php on line68

 

STEP 3

Parse error: syntax error, unexpected ';', expecting T_FUNCTION in C:\xampp\htdocs\pot\OTS_DB_SQLite.php on line68

 

ALGUEM ME AJUDA?

 

[Danihcv 607]

Poste seu arquivo OTS_DB_SQLite.php que está na pasta C:\xampp\htdocs\pot

[Leolinduxo 0]

<?php

/**#@+
 * @version 0.0.1
 */

/**
 * @package POT
 * @version 0.1.3
 * @author Wrzasq <[email protected]>
 * @copyright 2007 (C) by Wrzasq
 * @license http://www.gnu.org/licenses/lgpl-3.0.txt GNU Lesser General Public License, Version 3
 */

/**
 * SQLite connection interface.
 * 
 * <p>
 * At all everything that you really need to read from this class documentation is list of parameters for driver's constructor.
 * </p>
 * 
 * @package POT
 * @version 0.1.3
 */
class OTS_DB_SQLite extends OTS_Base_DB
{
/**
 * Creates database connection.
 * 
 * <p>
 * Connects to SQLite database on given arguments.
 * <p>
 * 
 * <p>
 * List of parameters for this drivers:
 * </p>
 * 
 * <ul>
 * <li><var>database</var> - database name.</li>
 * </ul>
 * 
 * @version 0.0.7
 * @param array $params Connection parameters.
 * @throws PDOException On PDO operation error.
 */
    public function __construct($params)
    {
        if( isset($params['prefix']) )
        {
            $this->prefix = $params['prefix'];
        }

        // PDO constructor
	try
	{
		parent::__construct('sqlite:' . $params['database']);
	}
	catch(PDOException $error)
	{
		echo 'Can\'t connect to SQLite database.</font>';
			exit;
	}

}

/**#@-*/

?>

[Danihcv 607]

Tenta assim:

<?php

/**#@+
 * @version 0.0.1
 */

/**
 * @package POT
 * @version 0.1.3
 * @author Wrzasq <[email protected]>
 * @copyright 2007 (C) by Wrzasq
 * @license http://www.gnu.org/licenses/lgpl-3.0.txt GNU Lesser General Public License, Version 3
 */

/**
 * SQLite connection interface.
 * 
 * <p>
 * At all everything that you really need to read from this class documentation is list of parameters for driver's constructor.
 * </p>
 * 
 * @package POT
 * @version 0.1.3
 */
class OTS_DB_SQLite extends OTS_Base_DB
{
/**
 * Creates database connection.
 * 
 * <p>
 * Connects to SQLite database on given arguments.
 * <p>
 * 
 * <p>
 * List of parameters for this drivers:
 * </p>
 * 
 * <ul>
 * <li><var>database</var> - database name.</li>
 * </ul>
 * 
 * @version 0.0.7
 * @param array $params Connection parameters.
 * @throws PDOException On PDO operation error.
 */
    public function __construct($params)
    {
        if( isset($params['prefix']) )
        {
            $this->prefix = $params['prefix'];
        }

        // PDO constructor
	try
	{
		parent::__construct('sqlite:' . $params['database']);
	}
	catch(PDOException $error)
	{
		echo 'Can\'t connect to SQLite database.</font>';
			exit;
	}

}

/**#@-*/
}
?>

[Leolinduxo 0]

apareceu isso

Can't connect to SQLite database.

[Danihcv 607]

Amigo, va n oseu config.lua e veja se o seu sqlType está assim:

sqlType = "mysql"

Se ñ estiver, deixe do jeito que eu coloquei.

[Leolinduxo 0]

mais na hora de criar site eu botei o sqlite não mysql tem problema nisso ai?

[Danihcv 607]

Sim. O certo pra ñ dar problemas (o que aconteceu) é colocar o mysql.

[Leolinduxo 0]

cara está dando o mesmo erro, acho que já era =/

[Danihcv 607]

O phpmyadmin tá ligado? Veja no xampp se está.

[Leolinduxo 0]

está sim, será que é problema no meu config.lua? é para dar load no localhost no mysql.sql ou mysql.dll?

dei load no mysql.sql

Editado Dezembro 24, 2014 por Leolinduxo (veja o histórico de edições)

[Danihcv 607]

Dx eu ver como ta seu config.lua

[Leolinduxo 0]

accountManager = true
namelockManager = true
newPlayerChooseVoc = true
newPlayerSpawnPosX = 870
newPlayerSpawnPosY = 1002
newPlayerSpawnPosZ = 7
newPlayerTownId = 2
newPlayerLevel = 130
newPlayerMagicLevel = 0
generateAccountNumber = false

	
	
redSkullLength = 30 * 24 * 60 * 60
blackSkullLength = 45 * 24 * 60 * 60
dailyFragsToRedSkull = 999999
weeklyFragsToRedSkull = 999999
monthlyFragsToRedSkull = 999999
dailyFragsToBlackSkull = 999999
weeklyFragsToBlackSkull = 999999
monthlyFragsToBlackSkull = 999999
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = false
useFragHandler = 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 = false
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false

	
	
worldType = "pvp"
protectionLevel = 1
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 2 * 1000
huntingDuration = 100 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = false
whiteSkullTime = 1 * 60 * 2000
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = true
fieldOwnershipDuration = 2 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 5 * 1000
deathLostPercent = 5
stairhopDelay = 2 * 1000
pushCreatureDelay = 0 * 2000
deathContainerId = 1987
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true

	
worldId = 0
ip = "142.4.195.96"
bindOnlyConfiguredIpAddress = false
loginPrt = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 100
motd = "Bem Vindo Ao Storm War!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Storm War"
loginMessage = "Bem Vindo Ao Storm War!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false

	
	
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "xxxxxxx"
sqlDatabase = "stormwar"
sqlFile = "stormwar.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

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

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

	
highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 10

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

	
timeBetweenActions = 200
timeBetweenExActions = 1150
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 500

	
	
mapName = "War"
mapAuthor = "leandro Oliveira"
randomizeTiles = true
useHouseDataStorage = false
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = "-1"

	
	
defaultPriority = "high"
niceLevel = 5
coresUsed = "0, 1, 2, 3, 4, 5, 6, 7"
optimizeDatabaseAtStartup = true
removePremiumOnInit = true
confirmOutdatedVersion = false

	
maxMessageBuffer = 800
bufferMutedOnSpellFailure = false

	
dataDirectory = "data/"
allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
bankSystem = true
saveGlobalStorage = true
displaySkillLevelOnAdvance = true
spellNameInsteadOfWords = false
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false

	
ghostModeInvisibleEffect = true
ghostModeSpellEffects = false


idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0

	
freePremium = true
premiumForPromotion = true

	

blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 0

	
experienceStages = false
rateExperience = 10
rateExperienceFromPlayers = 10.0
rateSkill = 100.0
rateMagic = 100.0
rateLoot = 0
rateSpawn = 10.0

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

	
minLevelThresholdForKilledPlayer = 0
maxLevelThresholdForKilledPlayer = 0

	
rateStaminaLoss = 1
rateStaminaGain = 3
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 41 * 60
staminaRatingLimitBottom = 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
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = false


deSpawnRange = 2
deSpawnRadius = 50

	
maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = false

	
ownerName = "StormWar"
ownerEmail = [email protected]""
url = "http://localhost"
location = "Brasil"
	displayGamemastersWithOnlineCommand = false

	
adminLogsEnabled = false
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false

Editado Dezembro 24, 2014 por Leolinduxo (veja o histórico de edições)

[Danihcv 607]

A linha que diz: displayGameMasterWithOnlineCommand ta mt pra direita e isso n pode. Apaga esse espaço que ta do lado esquerdo dela, até ela encostar na parte lateral esquerda igual as demais linhas.

[Leolinduxo 0]

cara está dando o  mesmo erro =/ afs

[f.silva 45]

tenta agr :

 

accountManager = true
namelockManager = true
newPlayerChooseVoc = true
newPlayerSpawnPosX = 870
newPlayerSpawnPosY = 1002
newPlayerSpawnPosZ = 7
newPlayerTownId = 2
newPlayerLevel = 130
newPlayerMagicLevel = 0
generateAccountNumber = false

redSkullLength = 30 * 24 * 60 * 60
blackSkullLength = 45 * 24 * 60 * 60
dailyFragsToRedSkull = 999999
weeklyFragsToRedSkull = 999999
monthlyFragsToRedSkull = 999999
dailyFragsToBlackSkull = 999999
weeklyFragsToBlackSkull = 999999
monthlyFragsToBlackSkull = 999999
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = false
useFragHandler = 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 = false
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false

worldType = "pvp"
protectionLevel = 1
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 2 * 1000
huntingDuration = 100 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = false
whiteSkullTime = 1 * 60 * 2000
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = true
fieldOwnershipDuration = 2 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 5 * 1000
deathLostPercent = 5
stairhopDelay = 2 * 1000
pushCreatureDelay = 0 * 2000
deathContainerId = 1987
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true

worldId = 0
ip = "142.4.195.96"
bindOnlyConfiguredIpAddress = false
loginPrt = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 100
motd = "Bem Vindo Ao Storm War!"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "Storm War"
loginMessage = "Bem Vindo Ao Storm War!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false

sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "root"
sqlPass = "xxxxxxx"
sqlDatabase = "stormwar"
sqlFile = "stormwar.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

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

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

highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 10

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

timeBetweenActions = 200
timeBetweenExActions = 1150
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 500

mapName = "War"
mapAuthor = "leandro Oliveira"
randomizeTiles = true
useHouseDataStorage = false
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = "-1"

defaultPriority = "high"
niceLevel = 5
coresUsed = "0, 1, 2, 3, 4, 5, 6, 7"
optimizeDatabaseAtStartup = true
removePremiumOnInit = true
confirmOutdatedVersion = false

maxMessageBuffer = 800
bufferMutedOnSpellFailure = false


dataDirectory = "data/"
allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
bankSystem = true
saveGlobalStorage = true
displaySkillLevelOnAdvance = true
spellNameInsteadOfWords = false
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false

ghostModeInvisibleEffect = true
ghostModeSpellEffects = false

idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0

freePremium = true
premiumForPromotion = true

blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 0

experienceStages = false
rateExperience = 10
rateExperienceFromPlayers = 10.0
rateSkill = 100.0
rateMagic = 100.0
rateLoot = 0
rateSpawn = 10.0

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

minLevelThresholdForKilledPlayer = 0
maxLevelThresholdForKilledPlayer = 0

rateStaminaLoss = 1
rateStaminaGain = 3
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 41 * 60
staminaRatingLimitBottom = 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
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = false

deSpawnRange = 2
deSpawnRadius = 50

maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = false

ownerName = "StormWar"
ownerEmail = [email protected]""
url = "http://localhost"
location = "Brasil"
displayGamemastersWithOnlineCommand = false

adminLogsEnabled = false
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false 

 

 

 

Não se esqueça de coloca sua senha  sqlPass = "xxxxxxx" ....

sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "root"
sqlPass = "xxxxxxx"
sqlDatabase = "stormwar"
sqlFile = "stormwar.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"

abrçs

Editado Dezembro 25, 2014 por f.silva (veja o histórico de edições)