[8.1&8.11][SQL]The Best War by Gesior (beta)

[Crewe]

Could you help me?
My error after editing with the Manager:

[29/05/2008 22:46:39] sqlite3_step(): SQLITE ERROR: constraint failed
[29/05/2008 22:46:39] > ERROR: Couldn't estabilish connection to SQL database!

 

[Crewe]

could anyone help me?

 

[Unbelievable]

Really really ty ;b

 

[eNki]

I downloaded SQLite Database Editor and opened war.s3db but now I don't know how to change gm nick etc..
Can someone help me? ;d


#down
that I readed but there isn't any info how to change omg --'


#edit
k, nvm
I found it \o/

 

[lyczos]

@read All Post! Omg...

here's One Link: sqlite Database Editor

It Works Perfectly But Before You Edit It Your Server Must Were Closed And Remove This File: War.s3db-journal And Then Open The Database War.s3db And Change Your Gm Name And The Password
Then Save!

If You Can't Login With Tibia 8.1 Then Try Tibia 8.11 I Worked Perfectly For Me!

This Work Perfect But I Prefer You To Use Tibia 8.11 If You Login To Your Gamemaster!

 

[eNki]

ye.. I found, but have same problem like Cliffe

[01/06/2008 20:39:30] sqlite3_step(): SQLITE ERROR: constraint failed
[01/06/2008 20:39:30] > ERROR: Couldn't estabilish connection to SQL database!

can someone help? ;x

 

[eNki]

bringUpMyPost.

 

[Fare]

this rox xD!!!!!!!!!!

 

[eNki]

any advice with the error? ...

 

[Dator tek]

Enki try with like i said but dont remove the journal

 

[eNki]

at least .. working
but I had to change all account ids from 22 to new
nvm, thanks ;d

#edit
is it possible to hide god name from best fragers list?
and how to repair !online command?

 

[Cm Himen]

what do i import to mysql? that's the only thing i need help with. thanks

 

[lyczos]

@up
This is SQLite - you don't need to import anything.
But if you think about import database from SQLite to MySQL you must do this mannualy(I don't know any converter )

Sorry for my english

 

[eNki]

so.. how to repair !online command? ..
take the code!

function onSay(cid,words,param)
local players = getOnlinePlayers()
local strings = {}
local curStr = 1
local nrGMs = 0
for i, player in ipairs(players) do
if i > curStr * 7 then
curStr = curStr + 1
end
if strings[curStr] == nil then
strings[curStr] = ""
breakline = ""
elseif strings[curStr] ~= "" then
breakline = ", "
end
if getConfigInfo('displayGamemastersWithOnlineCommand') == "no" then
nrGMs = nrGMs + 1
else
strings[curStr] = strings[curStr] .. breakline .. player .. " [" .. getPlayerLevel(getPlayerByName(player)) .. "]"
end
end
doPlayerSendTextMessage(cid,MESSAGE_STATUS_CONSOLE_BLUE, #players - nrGMs .. " player(s) online:")
for i,string in ipairs(strings) do
if string ~= "" then
doPlayerSendTextMessage(cid,MESSAGE_STATUS_CONSOLE_BLUE,string .. ".")
end
end
end

 

[Fate]

Database error - can't open SQLite database. Possible reasons:
C:/Users/Mike Jarvis/Desktop/Nova war/war.s3db - file isn't valid SQLite database.
C:/Users/Mike Jarvis/Desktop/Nova war/war.s3db - doesn't exist.


Why is this happening, I know its there.

 

[Gory]

hello man mm i have a problem, when i create the data base in phpmyadmin i can't find the SQL file to upload the data base >.< where is it pls

 

[Ralls]

how i used =( sorry i'm noob in this =(

 

[Gesior.pl]

hello man mm i have a problem, when i create the data base in phpmyadmin i can't find the SQL file to upload the data base >.< where is it pls

You don't have to upload anything. It's SQLite database. All data is in file: war.s3db

 

[Linkx]

Gesior.

First, it's the best pvp enforced, really congratulations!.

Second. i need u help if u can, i open my server. all good .. but other players enters with the same account of your gm, "22", "gmaccount".

And the question is, how i can edit/delete the gamemaster account i don't know where ;/.

Srry for my bad english cause im chilean.

~

 

[Nizar]

Could someone do a tutorial on how to make the gm account thing work and such? i always get the same error when i try and lauch the server