Junior Spellweaver
- Joined
- Aug 1, 2012
- Messages
- 145
- Reaction score
- 16
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
Sorry for being a noob, I'm just newbie here you know ><@NickName = N'Yuui' <---- is the name of your "Piero" if you call Yuui So let it xD
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
Do I need to relog after I've run the query?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.
Well this is what I did: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..
Run this query when I'm in the game and then relog?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
I'm still the red one.. Here's my query:i suggest you to run the query when you have tr closed.
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
I did the same thing, I think that its changing my piero, but not his look.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
First I'm putting "1" in fdAtrribute and then logging out of the game.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.
[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]