Only 2 simple requests

09/05/2013 01:34 MaDenGo*#1
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 :)
09/05/2013 05:30 Anonymous-6723#2
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:

Code:
SELECT * INTO YourDBname.dbo._TableName FROM OriginalDB.dbo._TableName
09/05/2013 18:43 MaDenGo*#3
Thanks for answer , but more hints !
09/05/2013 20:34 abdo1020#4
Quote:
Originally Posted by Zed* View Post
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:

Code:
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
09/06/2013 03:37 MaDenGo*#5
Quote:
Originally Posted by abdo1020 View Post
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 ;)
09/06/2013 10:18 Anonymous-6723#6
It's enough to write 1 exception for all the male chars...
Code:
IF blablalba=malechars
BEGIN
all items for male chars here
END
ELSE
BEGIN
all items for female chars here
END
Post #200