another sql query

[pizdolcea]

hello guyz ,
well i want a sql query or a way or anything u recommend me ,
to make :

every new character starts or created and started playing my server will have :

15 days custume ( the new summer set i have all )
+5 18% Talismans
Magic Health Pack 300 EA
10 Coppers
Health Regenerator
10 Portal Scrolls

maybe send on mail ,
or can be on his inventory

if send on mail , have to write mail

from [GM]Team
Subject : Begin Event
Body Text : Welcome To My Dekaron , We Give Free Items As Event . Enjoy

thank you

[CROvic]

by zombe

Have you ever wanted to give an item(s) to every character as soon as it is created?
Well, I am here to show you how!

First we will open up the MSSQL's Enterprise Manager, and we will take a lot at the user_character table in the character database.
Have you ever noticed the [DEV] characters in there? Well, that is what we are looking for. They all have an user_no of 19999999999991, so you can find them by searching for that user_no in user_character table.

Ok, first lets take a look at their names.
[DEV]KNIGHT, [DEV]HUNTER, [DEV]MAGICIAN , etc. Obviously a char for each class.

Lets take a look at the stats of [DEV]KNIGHT. 6 str, 3 dex, 4 con, 2 spr. Nothing special. Except... Wait, aren't these the stats that all knights have when the chart is created by default? Yes, they are! So what if we would change all those stats to lets say 2000, save and then create a character?
WOW! My newly created character has 2k stats!

Ok, so that is the method how to customize the character, like starting level, starting health, starting shield, etc. You can make it different for each class, if you want.

Ok, but how about items, you ask?

I will do it so that the items would be equipped by default.
So lets go to user_suit, but leave user_character table open.
Lets say we are customizing a knight. Note the character no of [DEV]KNIGHT, that is DEKARON0000001.
Lets find that in the user_suit table. Ok, we found it. 1 entry.

line_no 4, wIndex 2421.

Hmm... Wait, that is a lvl 1 1h-sword! The very same one a newly created character gets, when he makes a new character!

So this is what we do.
We will make ourselves a new character. Then, mail the items you want the newly created character to have to the char you just created, or you can drop them by killing mobs/treasureboxes. Anyway, once you have the items you want, equip them. Make sure you equip ONLY what you want the newly created character to have, so check your mount/wings slot, your potion quickslots, everything.
Once you have it equipped, logout and go to your enterprise manager, user_character, find your character. Get it's character number, I will use A09090520000000003 as an example, because that is my number.
Then, go to user_suit, find the character_no DEKARON0000001 (for knight).
DELETE the 1 row that it has. Then find your character's no (A09090520000000003 as an example). Change the character_no on all lines to DEKARON0000001. Log back into your account again (Yes, all of your items you equipped will be gone), then create a new character.
Wow! He has all the items!

The same can be used for all classes, and it can be used the same way for inventory, skillls, almost everything. Also, you can edit the guild's MASTERCODE to change the default guild created.

by pieter

No more SQL Manager jobs that keep looping and lag your server!

open sql profiler
go to character > stored procedures
find SP_CHAR_CREATE
rightclick it > Edit

scroll down and look for:

COMMIT TRANSACTION
SET @sp_rtn = 0
RETURN



thats the line that returns the client, "OK Your character has been made, u can login!"

example of a mailbox script to send an argate to new characters right after they have been made

COMMIT TRANSACTION
/* Custom content by Henkie2 / Pieter / KissMyBow
Sends new characters a argate in mailbox to welcome them */
declare @itemnum INT
SET @itemnum = 9901
EXEC character.dbo.SP_POST_SEND_OP @character_no,'[DEV] Henkie2',1,'Welcome Gift!!','Welcome to -servername- here a gift',@itemnum,'0',0
SET @sp_rtn = 0
RETURN



NOTE! u cannot SAVE stored procedures to save changes u made to a stored procedure using SQL-Profiler u have to EXECUTE it
press ALT+X to execute the SP and save your changes

[pizdolcea]

Originally Posted by CROvic

by zombe




by pieter

sorry nothing helped me ,
nothing of that way i want ,
i dont want to make a character and have all this ***** then remove character and replace with DEKARON0000001 ,
i want a sql query to do that ,

maybe make it like a job , to start and send this items when new character created

[pieter]

he gave u my script and that script does exactly what u want

it just takes a little more reading to understand it

the procedure SP_CHAR_CREATE gets run everytime someone creates a new character, so alterring that is the best way to do it!

[pizdolcea]

Originally Posted by pieter

he gave u my script and that script does exactly what u want

it just takes a little more reading to understand it

the procedure SP_CHAR_CREATE gets run everytime someone creates a new character, so alterring that is the best way to do it!

were to put that code ?
i have alot things on this stored produse thing

declare @itemnum INT
SET @itemnum = 9901
EXEC character.dbo.SP_POST_SEND_OP @character_no,'[DEV] Henkie2',1,'Welcome Gift!!','Welcome to -servername- here a gift',@itemnum,'0',0
SET @sp_rtn = 0
RETURN

[CROvic]

were to put that code ?

open sql profiler
go to character > stored procedures
find SP_CHAR_CREATE
rightclick it > Edit

scroll down and look for:

COMMIT TRANSACTION
SET @sp_rtn = 0
RETURN



and change it to this


declare @itemnum INT
SET @itemnum = enter index of item
EXEC character.dbo.SP_POST_SEND_OP @character_no,' MyName',1,'Enter Mail name!!','Enter text here',@itemnum,'0',0
SET @sp_rtn = 0
RETURN

[CROvic]

#remove this post
sry for double posting...

[pizdolcea]

Originally Posted by CROvic

open sql profiler
go to character > stored procedures
find SP_CHAR_CREATE
rightclick it > Edit

scroll down and look for:

COMMIT TRANSACTION
SET @sp_rtn = 0
RETURN



and change it to this


declare @itemnum INT
SET @itemnum = enter index of item
EXEC character.dbo.SP_POST_SEND_OP @character_no,' MyName',1,'Enter Mail name!!','Enter text here',@itemnum,'0',0
SET @sp_rtn = 0
RETURN

on this script send only 1 item ,
i changed the copper index to my 15 days custume
but i need 4 more items so ?

and i want to send for each char a custume , so i think this way not working ?

[naruto820]

You can use zombe's script to give many items as start as well. just get the character number of 6 DEV characters. go to user_bag and find the rows with those character numbers and add the lines to give them items. So whenever someone makes a new character those items will be in the inventory.

[pieter]

sadly the timed items will instantly expire in that way

[pizdolcea]

Originally Posted by pieter

sadly the timed items will instantly expire in that way

yes i tried , that way
they get removed when i crate the character

[pieter]

thats why u can use my script.

just look at what it does, after that its easy to make it sent 2 or more items

1 hint, u can only add 1 item per mailbox message

[pizdolcea]

Originally Posted by pieter

thats why u can use my script.

just look at what it does, after that its easy to make it sent 2 or more items

1 hint, u can only add 1 item per mailbox message

yes but i tried ,
i copied 2 scripts i mean like this

COMMIT TRANSACTION
declare @itemnum INT
SET @itemnum = enter index of item
EXEC character.dbo.SP_POST_SEND_OP @character_no,' MyName',1,'Enter Mail name!!','Enter text here',@itemnum,'0',0
SET @sp_rtn = 0
RETURN
declare @itemnum INT
SET @itemnum = enter index of item
EXEC character.dbo.SP_POST_SEND_OP @character_no,' MyName',1,'Enter Mail name!!','Enter text here',@itemnum,'0',0
SET @sp_rtn = 0
RETURN
END

but not working xD

[pieter]

what error does it give if u parse it in sql profiler?

[pizdolcea]

Originally Posted by pieter

what error does it give if u parse it in sql profiler?

nothing ,
i just get 1 item only on mail box .
1 mail with 1 item , but i think it must send 2 items with 2 mails right ?

i mean for example i run the first sql code to send mana potion ,
and secend to send hp potion , but it send mana potion only .