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*
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

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