Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

How To Change Piero(GM) Color

Junior Spellweaver
Joined
Aug 1, 2012
Messages
145
Reaction score
16
Just run this query in your sql changing the following data

Code:
USE [Talesrunner]GO


DECLARE    @return_value int


EXEC    @return_value = [dbo].[usp_GM_SetPieroColor]
        @NickName = N'Yuui',
        @Color = 4


SELECT    'Return Value' = @return_value



GO
@NickName = N'Yuui', <--- Piero name
@Color = 4 <--- Color code

That was what
Red is what is changed at your convenience

*-Here I leave the Number of Each Color-*
0 Red
1 Orange
2 yellow
3 Green
4 Light Blue
5 dark blue
6 Purple
7 Santa Clos
8 Angel Piero
9 Devil Piero
10 Piero Ambulance
11 Piero With Jacket
 
Initiate Mage
Joined
Aug 22, 2013
Messages
45
Reaction score
0
I can keep the piero name as "Yuui" or I need to change it with the color codes?
And "0" is not "Nothing"?
I mean play without piero?
 
Initiate Mage
Joined
Aug 22, 2013
Messages
45
Reaction score
0
@NickName = N'Yuui' <---- is the name of your "Piero" if you call Yuui So let it xD
Sorry for being a noob, I'm just newbie here you know ><
"0" is not "Nothing"?
I mean play without piero?
And 3 is invisible gm ><
 
Initiate Mage
Joined
Aug 22, 2013
Messages
45
Reaction score
0
Did it, But still when I'm getting in I'm still not piero ><
My query:
Code:
USE [TR]GO




DECLARE    @return_value int




EXEC    @return_value = [dbo].[usp_GM_SetPieroColor]
        @NickName = N'Yuui',
        @Color = 10




SELECT    'Return Value' = @return_value






GO
 
Joined
Jul 13, 2010
Messages
48
Reaction score
4
if you want to make your user a GM Piero what you need to do is change the information on the ' dbo.UserInfo ' tabLe
search for your username, and change the fdAttribute to 1 (***in your username***)

after that you can run the query that kevin posted so you can change the coLors on piero.
in the query that kevin posted you see this: ' @NickName = N'Yuii', ' depending on the username that you have, you wiLL need to change that to your username.
exampLe: my username is Kuri, i wiLL have my code as ' @NickName = N'Kuri',

after you have done the 2 steps, cLose TR and reopen TR so they can both take effect

hope this heLps.
 
Last edited:
Initiate Mage
Joined
Aug 22, 2013
Messages
45
Reaction score
0
if you want to make your user a GM Piero what you need to do is change the information on the ' dbo.UserInfo ' tabLe
search for your username, and change the fdAttribute to 1 (***in your username***)
you wiLL need to cLose and re-open Tales Runner for it to take effect.

after that you can run the query that kevin posted so you can change the coLors on piero.
in the query that kevin posted you see this: ' @NickName = N'Yuii', ' depending on the username that you have, you wiLL need to change that to your username.
exampLe: my username is Kuri, i wiLL have my code as ' @NickName = N'Kuri',

hope this heLps.
Do I need to relog after I've run the query?
 
Initiate Mage
Joined
Aug 22, 2013
Messages
45
Reaction score
0
yea, it wont work unless you relog in
or if you didnt had the TR open you can just open it.
Well this is what I did:
1. Went to UserInfo and changed the fdAtrribute in my user to 1.
2. Relogged and run the query and then relogged again.
3. When I got into the game I was still the red piero..
 
Junior Spellweaver
Joined
Aug 1, 2012
Messages
145
Reaction score
16
Well this is what I did:
1. Went to UserInfo and changed the fdAtrribute in my user to 1.
2. Relogged and run the query and then relogged again.
3. When I got into the game I was still the red piero..

Now

Just run this query in your sql changing the following data

Code:

USE [Talesrunner]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[usp_GM_SetPieroColor]
@NickName = N'Yuui',
@Color = 4

SELECT 'Return Value' = @return_value


GO



@NickName = N'
Yuui', <--- Piero name
@Color = 4 <--- Color code

That was what
Red is what is changed at your convenience

*-Here I leave the Number of Each Color-*
0 Red
1 Orange
2 yellow
3 Green
4 Light Blue
5 dark blue
6 Purple
7 Santa Clos
8 Angel Piero
9 Devil Piero
10 Piero Ambulance
 
Initiate Mage
Joined
Aug 22, 2013
Messages
45
Reaction score
0
Now

Just run this query in your sql changing the following data

Code:

USE [Talesrunner]GODECLARE @return_value intEXEC @return_value = [dbo].[usp_GM_SetPieroColor] @NickName = N'Yuui', @Color = 4SELECT 'Return Value' = @return_valueGO

@NickName = N'Yuui', <--- Piero name
@Color = 4 <--- Color code

That was what
Red is what is changed at your convenience

*-Here I leave the Number of Each Color-*
0 Red
1 Orange
2 yellow
3 Green
4 Light Blue
5 dark blue
6 Purple
7 Santa Clos
8 Angel Piero
9 Devil Piero
10 Piero Ambulance
Run this query when I'm in the game and then relog?
 
Initiate Mage
Joined
Aug 22, 2013
Messages
45
Reaction score
0
i suggest you to run the query when you have tr closed.
I'm still the red one.. Here's my query:
Code:
USE [TR]GO


DECLARE @return_value int


EXEC @return_value = [dbo].[usp_GM_SetPieroColor] 
@NickName = N'Symbiotic', 
@Color = 9


SELECT 'Return Value' = @return_value




GO
 
Joined
Jul 13, 2010
Messages
48
Reaction score
4
first of aLL, is TR your database name? if its not, then change TR to your DB's name
if TR its your DB's name then do this:

****COPY THE CODE BELLOW****

USE [DB's Name]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[usp_GM_SetPieroColor]
@NickName = N'Symbiotic',
@Color = 9

SELECT 'Return Value' = @return_value


GO

****DON'T COPY ANYMORE****
after you have pasted the code on the new query, you wiLL need to run the query, you can do so by pressing the F5 key in your keyboard.

****pLease note that the code is in different Lines
USE [TR]
GO
****and not in the same Line
USE [TR]GO
 
Last edited:
Initiate Mage
Joined
Aug 22, 2013
Messages
45
Reaction score
0
first of aLL, is TR your database name? if its not, then change TR to your DB's name
if TR its your DB's name then do this:

****COPY THE CODE BELLOW****

USE [DB's Name]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[usp_GM_SetPieroColor]
@NickName = N'Symbiotic',
@Color = 9

SELECT 'Return Value' = @return_value


GO

****DON'T COPY ANYMORE****
after you have pasted the code on the new query, you wiLL need to run the query, you can do so by pressing the F5 key in your keyboard.

****pLease note that the code is in different Lines
USE [TR]
GO
****and not in the same Line
USE [TR]GO
I did the same thing, I think that its changing my piero, but not his look.
I mean when I running the query with piero #10, I got different stats on my piero but not his look /=
And if I trying to put 2 in fdAtrribute I'm without piero.. Just a normal character like Rough/Charlie etc..
 
Joined
Jul 13, 2010
Messages
48
Reaction score
4
uhmmm... wiLL try to investigate a few things, since im not on my pc at the moment, im not abLe to try a different coLor
 
Last edited:
Joined
Jul 13, 2010
Messages
48
Reaction score
4
i have tried aLL coLor codes, and they work properLy, incLuding the santa claus, angeL, deviL, piero ambulance and piero with jacket.

seems you are doing something wrong, symbo, again, show me what you have.
 
Initiate Mage
Joined
Aug 22, 2013
Messages
45
Reaction score
0
i have tried aLL coLor codes, and they work properLy, incLuding the santa claus, angeL, deviL, piero ambulance and piero with jacket.

seems you are doing something wrong, symbo, again, show me what you have.
First I'm putting "1" in fdAtrribute and then logging out of the game.
Then I'm running this query:
Code:
[COLOR=#333333][I]USE [TR][/I][/COLOR]
[COLOR=#333333][I]GO[/I][/COLOR]

[COLOR=#333333][I]DECLARE @return_value int[/I][/COLOR]

[COLOR=#333333][I]EXEC @return_value = [dbo].[usp_GM_SetPieroColor][/I][/COLOR]
[COLOR=#333333][I]@NickName = N'Symbiotic',[/I][/COLOR]
[COLOR=#333333][I]@Color = 9[/I][/COLOR]

[COLOR=#333333][I]SELECT 'Return Value' = @return_value[/I][/COLOR]


[COLOR=#333333][I]GO[/I][/COLOR]
Then I'm join the game but nope, I'm still red piero.. But, His stats has changed, So I think that its changed the piero, But not his look..

EDIT: Fixed, All this time my avatar mode was on, And all I was need to do is turn him off ><
 
Last edited:
Back
Top