Map server

[gatin]

it connect but in the end shoutdown
please someone read the log and tell me what to do

i'm not that good with sql or there stuff but there is few dragon raja servers

 

[Rekace]

try changing the port. at least that help me

 

[gatin]

hmmm , that did work , but now i got somthing else

after i login to the character lest and chose my character and priss connect
i get faild to connect code -1

 

[Thralas]

Socketbind might fail indeed.
Edit: That means the map is not up.

 

[gatin]

so what should i do , where do i look ^^; login and character work
so i it's in the map but where ?

 

[bbblack]

Isn't that error 'cause the mapserver that's connecting is not in the proxy.ini? Otherwise, try to execute the map server and verify that in both inis (mapserver.ini, proxy.ini) are same ips, and in proxy.ini there mustn't be any ; in front of it =o

 

[gatin]

thx guys got it work ^^ , map port couldn't connect to proxy .

anyway i tried to change my tactic lvl but couldn't do it with sql in drserver
UPDATE Chr_Info

SET tac_skillEXP = 0x219C457D219C457D219C457D219C457D219C457D219C457D 219C457D219C457D219C457D219C457D219C457D219C457D21 9C457D
WHERE (name = 'noob')

 

[Thralas]

Syntax seems fine. Errors?

 

[gatin]

i get this error

Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near '219'.

 

[guties]

there is a space right before the 219 that you need to remove.

 

[gatin]

lol i get this now

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'Chr_Info'.

 

[wirlow]

Try with this query:
UPDATE Chr_Info

SET tac_skillEXP = 0x219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D
WHERE (name = 'noob')

 

[bbblack]

or even better...

UPDATE [DragonRajaDB].[dbo].[Chr_Info] SET tac_skillEXP = 0x219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D219C457D WHERE name = 'whatever'

 

[gatin]

thx bbblack , that work like a charm

what about the other ?
exp and money ?

 

[wirlow]

thx bbblack , that work like a charm

what about the other ?
exp and money ?

In the same folder are the other querys.

 

[gatin]

i know there are in sqls folder but they don't same to work with me

but the one that bbblack did, it did work nice for me

 

[Thralas]

Remove any spaces left then. Or paste some errors + queries.

 

[bbblack]

XP:
update [DragonRajaDB].[dbo].[NPC_Generation_SP] set NpcExp = NpcExp * xprate

Money:
UPDATE [DragonRajaDB].[dbo].{NPC_Generation_SP] SET Money_min = Money_min* rate, Money_Max = Money_Max*rate

 

[gatin]

thx bbblack!!

^^; ok , how do i change craft exp ? like mining and blacksmithing how fast i can lvl thim

 

[bbblack]

UPDATE skill_lvexp SET
F2 = F2/3, F3 = F3/3, F4 = F4/3, F5 = F5/3, F6 = F6/3, F7 = F7/3, F8 = F8/3, F9 = F9/3, F10 = F10/3,
F11 = F11/3,
F12 = F12/3,
F13 = F13/3,
F14 = F14/3,
F15 = F15/3,
F16 = F16/3,
F17 = F17/3,
F18 = F18/3,
F19 = F19/3,
F20 = F20/3,
F21 = F21/3,
F22 = F22/3,
F23 = F23/3,
F24 = F24/3,
F25 = F25/3,
F26 = F26/3,
F27 = F27/3,
F28 = F28/3,
F29 = F29/3,
F30 = F30/3,
F31 = F31/3,
F32 = F32/3,
F33 = F33/3,
F34 = F34/3,
F35 = F35/3,
F36 = F36/3,
F37 = F37/3,
F38 = F38/3,
F39 = F39/3,
F40 = F40/3,
F41 = F41/3,
F42 = F42/3,
F43 = F43/3,
F44 = F44/3,
F45 = F45/3,
F46 = F46/3,
F47 = F47/3,
F48 = F48/3,
F49 = F49/3,
F50 = F50/3,
F51 = F51/3,
F52 = F52/3,
F53 = F53/3,
F54 = F54/3,
F55 = F55/3,
F56 = F56/3,
F57 = F57/3,
F58 = F58/3,
F59 = F59/3,
F60 = F60/3,
F61 = F61/3,
F62 = F62/3,
F63 = F63/3,
F64 = F64/3,
F65 = F65/3,
F66 = F66/3,
F67 = F67/3,
F68 = F68/3,
F69 = F69/3,
F70 = F70/3,
F71 = F71/3,
F72 = F72/3,
F73 = F73/3,
F74 = F74/3,
F75 = F75/3,
F76 = F76/3,
F77 = F77/3,
F78 = F78/3,
F79 = F79/3,
F80 = F80/3,
F81 = F81/3,
F82 = F82/3,
F83 = F83/3,
F84 = F84/3,
F85 = F85/3,
F86 = F86/3,
F87 = F87/3,
F88 = F88/3,
F89 = F89/3,
F90 = F90/3,
F91 = F91/3,
F92 = F92/3,
F93 = F93/3,
F94 = F94/3,
F95 = F95/3,
F96 = F96/3,
F97 = F97/3,
F98 = F98/3,
F99 = F99/3,
F100 = F100/3,
F101 = F101/3,
F102 = F102/3


/3 = rate.. it should be all available skills, mining.. just as hurling and archery and so on.. and skills that actually don't exist *coughs*