Help with adding iption through SQL

[deepa]

the guide which i have seen here helped me a lot but i cant understand how to edit the m_body thng to add option through SQL

Plz make a completely adding options guide plz dont show the link the other one has posted i saw it but could not add plz make a guide on the basis

thk you:O:

 

[gantolaakshay]

which sql are u using?
if its sql 2005, there will be a software called sql 2005 management express isntall that which has to be done before as this will enable u to create databases. now click on the asd database it will expand and then click on tables which will again expand then rightclick on charac0 and select open table in the table u can find the m/body column and edit it to ur liking
Cheers

 

[deepa]

iam using SQL 2000 plz explain for that

 

[gantolaakshay]

iam using SQL 2000 plz explain for that

Sorry I never used Sql 2000 let som1 else help u or else switch to 2005 Tc
Cheers

 

[ramankamboj]

EXP=0\_1SKILL=2147483648;0;0\_1PK=0\_1RTM=0\_1SINFO=1114112\_1WEAR=3621;3121;266089;3601;4129;266089;3611;5169;397161;3641;6179;397161;36399;416801;266089\_1INVEN=\_1PETINV=\_1CQUEST=65535;0;0;0;0;0;0;0\_1WAR=0;0;0\_1SQUEST=0\_1FAVOR=0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;132710400;132710400;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0\_1PSKILL=0;0;0;0;0;0\_1SKLSLT=0;0;0;0;0;0;0;0;0;0;0;0;0\_1CHATOPT=255;31;227\_1TYR=0;0;0\_1SKILLEX=0;0;0\_1SKLSLTEX=0;0;0;0;0;0;0;0;0;0;0;0;0\_1PETACT=66542;135033;125829121;2146674816\_1LORE=4000000000\_1LQUEST=0\_1RESRV0=0\_1RESRV1=0\_1

These are the contents of m_body field of charac0 table.

The function of them is as follows

EXP - current exp of character.
SKILL - Shows skills learnt by the char. But these codes are tedious for editing for single skill. So better spawn skill scroll ingame nd learn skill or use SKILLMASTER?

\_1WEAR - Sets , weapon, ring and necklace currently worn by the char.

\_1INVEN - The items present in the inventory. For adding things in inventory use the code in this way -> item code; inventory slot number; item code; inventory slot number and so on.

\_1PETACT - Shue worn by the char.

\_1LORE - Lore of char

\_1PSKILL - Passive skills learnt by char

\_1CHATOPT - Chat options set for the char

I think these are enuf. Mainly editing the WEAR and INVEN and PETACT field in SQL is preferable. Rest of things are easy to manipulate ingame.

 

[deepa]

thx ramankamboj thx a lot this helped me a lot can any one send a link for SQL 2005 ??

 

[gantolaakshay]

thx ramankamboj thx a lot this helped me a lot can any one send a link for SQL 2005 ??

1)

You must be registered to see links

2)

You must be registered to see links

1st is the sql express
2nd is the mangement studio express

Google it re plenty of download options

 

[knightH@wk]

http://forum.ragezone.com/f98/how-to-add-option-through-sql-220371/


Check out this link... hope it helps you out...



Raptor

 

[deepa]

thx bhai Knight aka Raptor

 

[onyourrisk]

Knight Hawk dude contect me asap !