TalkAction [TFS 0.2.5] Ingame Highscores

[Dixtoxx]

Please , Can someone Give me a Page There i Can download 8.1 Realmap Ot , and a Ot Work 100% , Please Some Info =/

 

[Nesaj]

Wow i test it on my server (v0.2.11) and it work!! but i still have a small error when i use !ranks...

[13/04/2008 09:44:48] Lua Script Error: [TalkAction Interface]
[13/04/2008 09:44:48] data/talkactions/scripts/highscores.luanSay

[13/04/2008 09:44:48] data/talkactions/scripts/highscores.lua:158: LuaSQL: there are open cursors


How may i fix it??


-- edit --

I have another error when i log some character

[13/04/2008 09:54:36] ADM Nesaj has logged out.
[13/04/2008 09:54:36] SQLITE ERROR sqlite_exec: UPDATE `players` SET `online` = 0 WHERE `id` = 2 database is locked
[13/04/2008 09:54:36] SQLITE ERROR sqlite_exec: COMMIT; database is locked
[13/04/2008 09:54:36] SQLITE ERROR sqlite_exec: BEGIN; cannot start a transaction within a transaction
[13/04/2008 09:54:36] SQLITE ERROR sqlite_exec: BEGIN; cannot start a transaction within a transaction
[13/04/2008 09:54:36] Error while saving player: ADM Nesaj

 

[kinglewey]

dude i added it and will add credits to you on the highscores (if its possible, and when i work out how) Thx Good job!

 

[Merchant]

cool!
I'll give you some reputation..

 

[Colandus]

You can shorten this script down quite alot! Do it!

I luff it xD

 

[jumboQ]

I'll use it to 100%! Thanks.

 

[Markey]

I got an error but that's because of TFS 0.3 trunk.
But I though I could post it here...
I get an error in the console that luasql = nil
I saw that in database.lua there are some functions for the database, but do I have to overwrite all the parts of the script that it works, or is there an easyer way so I can use this

env = assert(luasql.mysql())
con = assert(env:connect(mysqlDatabase, mysqlUser, mysqlPass, mysqlHost, mysqlPort))

 

[Roman]

Can you sort it out? What does it work on and what doesnt it work on?

 

[AGS]

Sorry for bumping this post, but does anyone knows how to make this work on TFS 0.3?
I couldn't make it work:
(part of the code, I don't think the whole code is needed, just the part that gets the data from the database)

if param == "level" or param == "exp" or param == "lvl" then
		local topPlayers = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` <= "..maxgroupid.." ORDER BY `experience` DESC LIMIT 0,"..players..";")
		str = "# [Level] - Name - (Experience)\n"
		local i = 0
		local level = topPlayers:getDataInt(level)
		local name = topPlayers:getDataString(name)
		local experience = topPlayers:getDataInt(experience)
		while(true) do
			str = str.."\n#"..(i+1).." ["..level.."] - "..name.." - ("..experience..")"
			i = i+1
			if not(topPlayers:next()) then
					break
			end
		end
		topPlayers:free()

I get these errors:

[17/11/2008 12:56:10] Error during getDataInt().
[17/11/2008 12:56:10] Error during getDataString().
[17/11/2008 12:56:10] Error during getDataInt().

 

[Znote]

Not neccesary, TFS allready got a version of in-game highscores.

Add to actions.xml: [if you don't got it already by default]

	<!-- Highscore Book -->
	<action itemid="1981" function="highscoreBook"/>

Club Fighting in-game highscore book.
ItemID: [1981].
ActionID: [151].
UniqueID: [4861].


Keep using item id 1981,

action id: 151 - 158 and it will show diffrent skills. (club, sword, axe, fishing, fist, magic, level, distance)

Add unique id and it will be stuck to the ground or at that place its suppose to belong to stick to.

 

[AGS]

Yeah, I know, but I prefer the !ranks command

 

[EvulMastah]

Sorry for bumping this post, but does anyone knows how to make this work on TFS 0.3?
I couldn't make it work:
(part of the code, I don't think the whole code is needed, just the part that gets the data from the database)

if param == "level" or param == "exp" or param == "lvl" then
		local topPlayers = db.getResult("SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` <= "..maxgroupid.." ORDER BY `experience` DESC LIMIT 0,"..players..";")
		str = "# [Level] - Name - (Experience)\n"
		local i = 0
		local level = topPlayers:getDataInt(level)
		local name = topPlayers:getDataString(name)
		local experience = topPlayers:getDataInt(experience)
		while(true) do
			str = str.."\n#"..(i+1).." ["..level.."] - "..name.." - ("..experience..")"
			i = i+1
			if not(topPlayers:next()) then
					break
			end
		end
		topPlayers:free()

I get these errors:

0.3 functions are:

result.getDataInt(resId, s)
result.getDataLong(resId, s)
result.getDataString(resId, s)
result.getDataStream(resId, s, length)
result.next(resId)
result.free(resId)

 

[Szakal]

Great !!! :d

 

[AGS]

0.3 functions are:

result.getDataInt(resId, s)
result.getDataLong(resId, s)
result.getDataString(resId, s)
result.getDataStream(resId, s, length)
result.next(resId)
result.free(resId)

They are the same, look at classes/database.lua

And I also based my script on the deathlist command, I basically just changed queries and variables.

 

[zednem]

i have downloaded the version 0.3, but i got this error

Lua script error: [TalkAction Interface]
data/talkactions/scripts/highscores.luanSay

data/talkactions/scripts/highscores.lua:7: attempt to index global 'luasql' < a nil value >
stack traceback:
data/talkactions/scripts/highscores.lua:7: in function <data/talkactions/scripts/highscores.lua:1>

 

[EvulMastah]

i have downloaded the version 0.3, but i got this error

It is for TFS 0.2.

 

[mamon_2]

Script isnt working at tfs 0.3

I added it as
result.getDataInt(resId, s)
result.getDataLong(resId, s)
result.getDataString(resId, s)
result.getDataStream(resId, s, length)
result.next(resId)
result.free(resId)

But isnt working... someone could post a one working?

 

[mamon_2]

Any script for TFS alpha 4?

 

[mamon_2]

For Beta 1?

 

[Atentador]

Doesn't work, I tried to fix it, but I can't.
If anyone have the script for 0.3 I will be happy.