Help with Sql Account Manager

[DarkD12]

Hi, I'm a complete noob to Sql and I wanted to know if anyone knows how to edit with the new characters can get when they make an account in a server, like my new chars dragon plate set and i wanted to change that any help if appreciated

Also, I wasnt sure where to put this but, does anyone know how I can get a script for like premium bridge just like in Real Tibia Rook, Much Thnx

Nooby Joe

 

[Backy]

If you are using TFS you can set new player equipment in:
...data/creaturescripts/scripts/firstitems.lua

Post it here and we try to remake it.

btw. if in Your server players must buy a premium, you dont have any chance to have much players... better way is make VIP status.

 

[ChiSka]

First Add in data/creaturescripts/creaturescripts.xml

      <event type="login" name="FirstItems" script="firstitems.lua"/>

Then in data/creaturescripts/scripts Create firstitems.lua
Then Add in it

function onLogin(cid)
	if getPlayerGroupId(cid) == 1 and getPlayerStorageValue(cid, 50000) == -1 then
		if isSorcerer(cid) then
			local bp = doPlayerAddItem(cid, 1988, 1)
	
			doAddContainerItem(bp, 2120, 1)
			doAddContainerItem(bp, 2554, 1)
			doAddContainerItem(bp, 2152, 2)
		
			doPlayerAddItem(cid, 2175, 1)
			doPlayerAddItem(cid, 2190, 1)
			doPlayerAddItem(cid, 8819, 1)
			doPlayerAddItem(cid, 8820, 1)
			doPlayerAddItem(cid, 2468, 1)
			doPlayerAddItem(cid, 2643, 1)

		setPlayerStorageValue(cid, 50000, 1)

		elseif isDruid(cid) then
			local bp = doPlayerAddItem(cid, 1988, 1)
			doAddContainerItem(bp, 2120, 1)
			doAddContainerItem(bp, 2554, 1)
			doAddContainerItem(bp, 2152, 2)
		
			doPlayerAddItem(cid, 2175, 1)
			doPlayerAddItem(cid, 2182, 1)
			doPlayerAddItem(cid, 8819, 1)
			doPlayerAddItem(cid, 8820, 1)
			doPlayerAddItem(cid, 2468, 1)
			doPlayerAddItem(cid, 2643, 1)

			setPlayerStorageValue(cid, 50000, 1)

		elseif isPaladin(cid) then
			local bp = doPlayerAddItem(cid, 1988, 1)
			doAddContainerItem(bp, 2120, 1)
			doAddContainerItem(bp, 2554, 1)
			doAddContainerItem(bp, 2152, 2)
		
			doPlayerAddItem(cid, 2456, 1)
			doPlayerAddItem(cid, 2544, 100)
			doPlayerAddItem(cid, 2660, 1)
			doPlayerAddItem(cid, 2480, 1)
			doPlayerAddItem(cid, 8923, 1)
			doPlayerAddItem(cid, 2643, 1)

			setPlayerStorageValue(cid, 50000, 1)

		elseif isKnight(cid) then
			local bp = doPlayerAddItem(cid, 1988, 1)
			doAddContainerItem(bp, 2120, 1)
			doAddContainerItem(bp, 2554, 1)
			doAddContainerItem(bp, 2152, 2)
			doAddContainerItem(bp, 2439, 1)
			doAddContainerItem(bp, 8601, 1)
		
			doPlayerAddItem(cid, 2509, 1)
			doPlayerAddItem(cid, 8602, 1)
			doPlayerAddItem(cid, 2465, 1)
			doPlayerAddItem(cid, 2481, 1)
			doPlayerAddItem(cid, 2478, 1)
			doPlayerAddItem(cid, 2643, 1)

			setPlayerStorageValue(cid, 50000, 1)
		end
	end
 	return TRUE
end

Hope i Helped u

 

[DarkD12]

Ty a bunch, this help alot :w00t: :w00t: :w00t:

Also does anyone know if their is a way to make skill stages just like level stages?? if not den w/e

 

[ChiSka]

First in data\XML
There's Stages.xml u can Fix in it Like that:

<?xml version="1.0" encoding="UTF-8"?>
<stages>
	<world id="0" multiplier="1">
		<stage minlevel="1" maxlevel="50" multiplier="2000"/>
		<stage minlevel="51" maxlevel="100" multiplier="1000"/>
		<stage minlevel="101" maxlevel="150" multiplier="500"/>
		<stage minlevel="151" maxlevel="180" multiplier="400"/>
		<stage minlevel="181" maxlevel="200" multiplier="300"/>
		<stage minlevel="201" maxlevel="230" multiplier="200"/>
		<stage minlevel="231" maxlevel="260" multiplier="100"/>
		<stage minlevel="261" maxlevel="280" multiplier="50"/>
		<stage minlevel="281" maxlevel="300" multiplier="40"/>
		<stage minlevel="301" maxlevel="320" multiplier="30"/>
		<stage minlevel="321" maxlevel="350" multiplier="20"/>
		<stage minlevel="351" multiplier="15"/>
	</world>
</stages>

 

[DarkD12]

Man your helpful, thnx


Also one more thing, i know im goin out of my topic but, my beach thing aint workin >.>, anyone know how to fix dat?