Only 2 simple requests

[MaDenGo*]

1# I want know how to make start items for female characters different with male characters
2# I Disabled ( Removed ) D11 drop lines , anyone have query to back it ( back lines or give me again etc )

Thank you

[Anonymous-6723]

Hint for your first problem: IF statement will do the trick, look for @RefCharID
About your second problem, restore original database and use this query:

SELECT * INTO YourDBname.dbo._TableName FROM OriginalDB.dbo._TableName

[MaDenGo*]

Thanks for answer , but more hints !

[abdo1020]

Originally Posted by Zed*

Hint for your first problem: IF statement will do the trick, look for @RefCharID
About your second problem, restore original database and use this query:

SELECT * INTO YourDBname.dbo._TableName FROM OriginalDB.dbo._TableName

i guess
FOR EUROPE FEMALE

PHP Code:

else if (@RefCharID >= 14888 and @RefCharID <= 14900) 


FOR EUROPE MALE

PHP Code:

else if (@RefCharID >= 14875 and @RefCharID <= 14887) 


FOR CHINESE FEMALE

PHP Code:

else if (@RefCharID >= 1920 and @RefCharID <= 1932) 


FOR CHINESE MALE

PHP Code:

if   (@RefCharID >= 1907 and @RefCharID <= 1919) 


[MaDenGo*]

Originally Posted by abdo1020

i guess
FOR EUROPE FEMALE

PHP Code:

else if (@RefCharID >= 14888 and @RefCharID <= 14900) 


FOR EUROPE MALE

PHP Code:

else if (@RefCharID >= 14875 and @RefCharID <= 14887) 


FOR CHINESE FEMALE

PHP Code:

else if (@RefCharID >= 1920 and @RefCharID <= 1932) 


FOR CHINESE MALE

PHP Code:

if   (@RefCharID >= 1907 and @RefCharID <= 1919) 


Thank you will test

[Anonymous-6723]

It's enough to write 1 exception for all the male chars...

IF blablalba=malechars
BEGIN
all items for male chars here
END
ELSE
BEGIN
all items for female chars here
END

Post #200