Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Help]anyone know mssql add skills script HELP ME!

Newbie Spellweaver
Joined
Jan 6, 2007
Messages
96
Reaction score
3
i want to edit mycp.
chageclass + skills. i found this http://forum.ragezone.com/f528/share-babyran-complete-web-php-776336/
but don't know where script to add skills (i want this fuction to another cp)
anyone know this help me.

now found code http://forum.ragezone.com/f444/guide-analysis-skilldata-487399/
Code:
if($Nation == '1'){  mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaSkills = 0x00010000080000005F000000030000000800000003000200080000000300030008000000030004000800000003000500080000000300060008000000030007000800000003000800080000000300090008000000020000000800000002000100080000000200020008000000020003000800000002000400080000000200050008000000020006000800000002000700080000000200080008000000020009000800000002000A000800000002000B000800000002000C000800000002000D000800000002000E000800000002000F0008000000020010000800000002001100080000000200120008000000020013000800000002001400080000000200150008000000020016000800000002001700080000000200180008000000020019000800000002001A000800000002001B000800000002001C000800000002001D000800000002001E0008000000010000000800000001000100080000000100020008000000010003000800000001000400080000000100050008000000010006000800000001000700080000000100080008000000010009000800000001000A000800000001000B000800000001000C000800000001000D000800000001000E000800000001000F0008000000010010000800000001001100080000000100120008000000010013000800000001001400080000000100150008000000010016000800000001001700080000000100180008000000010019000800000001001A000800000001001B0008000000000000000800000000000100080000000000020008000000000003000800000000000400080000000000050008000000000006000800000000000700080000000000080008000000000009000800000000000A000800000000000B000800000000000C000800000000000D000800000000000E000800000000000F0008000000000010000800000000001100080000000000120008000000000013000800000000001400080000000000150008000000000016000800000000001700080000000000180008000000000019000800000000001A0008000000   WHERE ChaName = '$name'");   }      if($Nation == '2'){  mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaSkills = 0x00010000080000005700000007000000080000000700030008000000070004000800000007000500080000000700060008000000070007000800000007000800080000000700090008000000060000000800000006000100080000000600020008000000060003000800000006000400080000000600050008000000060006000800000006000700080000000600080008000000060009000800000006000A000800000006000B000800000006000C000800000006000D000800000006000E000800000006000F00080000000600100008000000060011000800000006001200080000000600130008000000060014000800000006001500080000000600160008000000060017000800000006001800080000000600190008000000050000000800000005000100080000000500020008000000050003000800000005000400080000000500050008000000050006000800000005000700080000000500080008000000050009000800000005000A000800000005000B000800000005000C000800000005000D000800000005000E000800000005000F0008000000050010000800000005001100080000000500120008000000050013000800000005001400080000000500150008000000050016000800000005001700080000000500180008000000050019000800000005001A0008000000040000000800000004000100080000000400020008000000040003000800000004000400080000000400050008000000040006000800000004000700080000000400080008000000040009000800000004000A000800000004000B000800000004000C000800000004000D000800000004000E000800000004000F00080000000400100008000000040011000800000004001200080000000400130008000000040014000800000004001500080000000400160008000000040017000800000004001800080000000400190008000000   WHERE ChaName = '$name'");  }       if($Nation == '4'){  mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaSkills = 0x00010000080000005D0000000B000000080000000B000100080000000B000300080000000B000400080000000B000600080000000B000700080000000B000800080000000B000900080000000B000A00080000000A000000080000000A000100080000000A000200080000000A000300080000000A000400080000000A000500080000000A000600080000000A000700080000000A000800080000000A000900080000000A000A00080000000A000B00080000000A000C00080000000A000D00080000000A000E00080000000A000F00080000000A001000080000000A001100080000000A001200080000000A001300080000000A001400080000000A001500080000000A001600080000000A001700080000000A001800080000000A001900080000000A001A00080000000A001B00080000000A001C0008000000090000000800000009000100080000000900020008000000090003000800000009000400080000000900050008000000090006000800000009000700080000000900080008000000090009000800000009000A000800000009000B000800000009000C000800000009000D000800000009000E000800000009000F0008000000090010000800000009001100080000000900120008000000090013000800000009001400080000000900150008000000090016000800000009001700080000000900180008000000090019000800000009001A000800000009001B0008000000080000000800000008000100080000000800020008000000080003000800000008000400080000000800050008000000080006000800000008000700080000000800080008000000080009000800000008000A000800000008000B000800000008000C000800000008000D000800000008000E000800000008000F0008000000080010000800000008001100080000000800120008000000080013000800000008001400080000000800150008000000080016000800000008001700080000000800180008000000080019000800000008001A0008000000    WHERE ChaName = '$name'");   }           if($Nation == '8'){  mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaSkills = 0x00010000080000005D0000000F000200080000000F000300080000000F000400080000000F000500080000000F000600080000000F000700080000000E000000080000000E000100080000000E000200080000000E000300080000000E000400080000000E000500080000000E000600080000000E000700080000000E000800080000000E000900080000000E000A00080000000E000B00080000000E000C00080000000E000D00080000000E000E00080000000E000F00080000000E001000080000000E001100080000000E001200080000000E001300080000000E001400080000000E001500080000000E001600080000000E001700080000000E001800080000000E001900080000000E001A00080000000E001B00080000000E001C00080000000E001D00080000000D000000080000000D000100080000000D000200080000000D000300080000000D000400080000000D000500080000000D000600080000000D000700080000000D000800080000000D000900080000000D000A00080000000D000B00080000000D000C00080000000D000D00080000000D000E00080000000D000F00080000000D001000080000000D001100080000000D001200080000000D001300080000000D001400080000000D001500080000000D001600080000000D001700080000000D001800080000000D001900080000000D001A00080000000D001B00080000000D001C00080000000C000000080000000C000100080000000C000200080000000C000300080000000C000400080000000C000500080000000C000600080000000C000700080000000C000800080000000C000900080000000C000A00080000000C000B00080000000C000C00080000000C000D00080000000C000E00080000000C000F00080000000C001000080000000C001100080000000C001200080000000C001300080000000C001400080000000C001500080000000C001600080000000C001700080000000C001800080000000C001900080000000C001A00080000000C001B0008000000   WHERE ChaName = '$name'");   }       if($Nation == '16'){  mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaSkills = 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000A000800150021000B000800150021000C000800150021000D000800150021000E000800150021000F0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001A000800150021001B000800150021001C000800150021001D000800150021001E0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000A000800150020000B000800150020000C000800150020000D000800150020000E000800150020000F0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001A000800150020001B000800150020001C000800150020001D000800150020001E000800150020001F00080015001F000000080015001F000100080015001F000200080015001F000300080015001F000400080015001F000500080015001F000600080015001F000700080015001F000800080015001F000900080015001F000A00080015001F000B00080015001F000C00080015001F000D00080015001F000E00080015001F000F00080015001F001000080015001F001100080015001F001200080015001F001300080015001F001400080015001F001500080015001F001600080015001F001700080015001F001800080015001F001900080015001F001A00080015001F001B00080015001F001C00080015001F001D00080015001F001E00080015001F001F00080015001F002500080015001E000000080015001E000100080015001E000200080015001E000300080015001E000400080015001E000500080015001E000600080015001E000700080015001E000800080015001E000900080015001E000A00080015001E000B00080015001E000C00080015001E000D00080015001E000E00080015001E000F00080015001E001000080015001E001100080015001E001200080015001E001300080015001E001400080015001E001500080015001E001600080015001E001700080015001E001800080015001E001900080015001E001A00080015001E001B00080015001E001C00080015001E001D00080015001E001E00080015001E001F00080015001E00200008001500   WHERE ChaName = '$name' ");   }   if($Nation == '32'){  mssql_query ("UPDATE RanGame1.dbo.ChaInfo SET ChaSkills = 0x000100000800000081000000210000000800150021000100080015002100020008001500210003000800150021000400080015002100050008001500210006000800150021000700080015002100080008001500210009000800150021000A000800150021000B000800150021000C000800150021000D000800150021000E000800150021000F0008001500210010000800150021001100080015002100120008001500210013000800150021001400080015002100150008001500210016000800150021001700080015002100180008001500210019000800150021001A000800150021001B000800150021001C000800150021001D000800150021001E0008001500200000000800150020000100080015002000020008001500200003000800150020000400080015002000050008001500200006000800150020000700080015002000080008001500200009000800150020000A000800150020000B000800150020000C000800150020000D000800150020000E000800150020000F0008001500200010000800150020001100080015002000120008001500200013000800150020001400080015002000150008001500200016000800150020001700080015002000180008001500200019000800150020001A000800150020001B000800150020001C000800150020001D000800150020001E000800150020001F00080015001F000000080015001F000100080015001F000200080015001F000300080015001F000400080015001F000500080015001F000600080015001F000700080015001F000800080015001F000900080015001F000A00080015001F000B00080015001F000C00080015001F000D00080015001F000E00080015001F000F00080015001F001000080015001F001100080015001F001200080015001F001300080015001F001400080015001F001500080015001F001600080015001F001700080015001F001800080015001F001900080015001F001A00080015001F001B00080015001F001C00080015001F001D00080015001F001E00080015001F001F00080015001F002500080015001E000000080015001E000100080015001E000200080015001E000300080015001E000400080015001E000500080015001E000600080015001E000700080015001E000800080015001E000900080015001E000A00080015001E000B00080015001E000C00080015001E000D00080015001E000E00080015001E000F00080015001E001000080015001E001100080015001E001200080015001E001300080015001E001400080015001E001500080015001E001600080015001E001700080015001E001800080015001E001900080015001E001A00080015001E001B00080015001E001C00080015001E001D00080015001E001E00080015001E001F00080015001E00200008001500   WHERE ChaName = '$name' ");   }

tested on mssql query and got Error :
The data types image and varbinary are incompatible in the add operator ( in ChaSkills colum Is Null)

Thanks To all.
 
Last edited:
Back
Top