[GUIDE] How to add Startitems

    • [GUIDE] How to add Startitems

      Startitems
      Also vorweg es gibt 2 Möglchkeiten:
      1. über die Event.lua (gut für welche die nicht gut mit der DB umgehen können.
      AddEvent ( "Anfangsitem" )
      --{
      SetTime( "2009-09-29 00:00", "2020-01-01 00:00" )
      SetLevelUpGift( 2, "all", "II_SYS_BLI_TWO_TOWNBLINKWING", 5 )
      SetLevelUpGift( 2, "all", "II_GEN_FOO_INS_LOLLIPOP", 5 )
      SetLevelUpGift( 2, "all", "II_GEN_FOO_INS_BISCUIT", 1 )
      --}
      II_SYS_BLI_TWO_TOWNBLINKWING => Name des Items
      5 => Anzahl

      =======

      2. Direkt über die DB (macht das am besten mit testserver der ne leere db hat da findet man die sachen schneller)

      1. Also als erstes braucht ihr 2 Chars (male und female)
      diese Rüstet ihr mir den Sachen aus und pakt die Sachen ins Inventar die jeder neue Chars bekommen soll.

      2. geht in die CHARACTER_TBL und schreibt euch die m_idPlayer auf. (schreibt euch dahinter welche male bzw female ist, weil sont könntet ihr sie verwechseln)

      3. geht jetz in die INVENTORY_DBF und sucht die IDs der chars.

      4. öffnet nun parallel folgendes CHARACTER_01_DBF --> Programmierbarkeit --> CHARACTER_STR --> Rechtsklick + Ändern

      5. Sucht folgenden Eintrag IF @im_dwSex = '1' (die Einträge oben sind für den female char)

      6. so und nun kopiert Ihr 1:1 die Eintrge der Spalten m_Inventory, m_apIndex, m_adwEquipment, m_ObjIndex

      7.so jetz nurnoch oen auf [Ausführen] drückn.




      Ich hafte NICHT für eventuelle Fehler die Ihr macht, dürchführung auf eigene Verantwortung.

      Support wird ebenfalls nicht über PN gegeben.

      Und wer fragt wie er mit der Datenbank umgehen muss sollte sich mal gedanken machen ob er wirklich nen Pserver betreiben will.





      =================




      Hier habt Ihr ein Beispiel für 5 TownBlinkwing, 5 Lollipo und 1 Biscuit

      Quellcode

      1. IF @im_dwSex = '1'
      2. BEGIN
      3. SET @invi1 = '0,512,0,0,,1,0,4500000,0,0,0,-1118993182,0,0,0,0,0/1,504,0,0,,1,0,9000000,0,0,0,946307614,0,0,0,0,0/2,2801,0,0,,1,0,-1,0,0,2,1695360208,0,0,0,0,0/42,508,0,0,,1,0,5850000,0,0,0,750110947,0,0,0,0,0/43,2800,0,0,,5,0,-1,0,0,2,-440263533,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,-2111939376,0,0,0,0,0/45,4805,0,0,,5,0,-1,0,0,2,579001730,0,0,0,0,0/$'
      4. SET @invi2 = '45/43/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/-1/-1/1/-1/42/0/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      5. SET @invi3 = '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$'
      6. SET @invi4 = '47/44/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/46/1/52/0/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      7. END
      8. ELSE
      9. BEGIN
      10. SET @invi1 = '0,506,0,0,,1,0,5850000,0,0,0,-2005860201,0,0,0,0,0/1,502,0,0,,1,0,9000000,0,0,0,688242964,0,0,0,0,0/2,510,0,0,,1,0,4500000,0,0,0,583094601,0,0,0,0,0/42,2800,0,0,,5,0,-1,0,0,2,-2142136381,0,0,0,0,0/43,2801,0,0,,1,0,-1,0,0,2,1657616448,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,-2111939376,0,0,0,0,0/45,4805,0,0,,5,0,-1,0,0,2,2028177266,0,0,0,0,0/$'
      11. SET @invi2 = '45/42/43/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/-1/-1/1/-1/0/2/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      12. SET @invi3 = '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$'
      13. SET @invi4 = '46/44/47/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/1/2/52/0/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      14. END
      Alles anzeigen


      English trnaslation by: HolySinX
      First off, there are two methods:
      1. Through Event.lua (Good for the ones that can't work with databases very well)
      II_SYS_BLI_TWO_TOWNBLINKWING => Item name
      5 => Amount

      =======

      2. Directly through the database (I suggest you to do this on a test-server, because it would have an empty database, and it would make things much easier)

      1. First off you'll need two characters (male and female)
      You have to equip the items. Make sure you put the items that every character should get, in your inventory.

      2. Open the CHARACTER_TBL table and write the m_idPlayer down. (make sure you write down which character has which gender, so you won't confuse anything)

      3. Now open INVENTORY_DBF and search for your character ID's

      4. At the same time, open: CHARACTER_01_DBF --> Programmability --> CHARACTER_STR --> Right-click + Modify

      5. Look for the following entry: IF @im_dwSex = '1' (that entry is for the female character)

      6. Now copy the entries of the columns: m_Inventory, m_apIndex, m_adwEquipment, m_ObjIndex

      7. Last, but not least, click on Execute.

      =================




      Heres an example for 5 Town blinkwings, 5 lollipops and 1 Biscuit

      Quellcode

      1. IF @im_dwSex = '1'
      2. BEGIN
      3. SET @invi1 = '0,512,0,0,,1,0,4500000,0,0,0,-1118993182,0,0,0,0,0/1,504,0,0,,1,0,9000000,0,0,0,946307614,0,0,0,0,0/2,2801,0,0,,1,0,-1,0,0,2,1695360208,0,0,0,0,0/42,508,0,0,,1,0,5850000,0,0,0,750110947,0,0,0,0,0/43,2800,0,0,,5,0,-1,0,0,2,-440263533,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,-2111939376,0,0,0,0,0/45,4805,0,0,,5,0,-1,0,0,2,579001730,0,0,0,0,0/$'
      4. SET @invi2 = '45/43/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/-1/-1/1/-1/42/0/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      5. SET @invi3 = '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$'
      6. SET @invi4 = '47/44/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/46/1/52/0/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      7. END
      8. ELSE
      9. BEGIN
      10. SET @invi1 = '0,506,0,0,,1,0,5850000,0,0,0,-2005860201,0,0,0,0,0/1,502,0,0,,1,0,9000000,0,0,0,688242964,0,0,0,0,0/2,510,0,0,,1,0,4500000,0,0,0,583094601,0,0,0,0,0/42,2800,0,0,,5,0,-1,0,0,2,-2142136381,0,0,0,0,0/43,2801,0,0,,1,0,-1,0,0,2,1657616448,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,-2111939376,0,0,0,0,0/45,4805,0,0,,5,0,-1,0,0,2,2028177266,0,0,0,0,0/$'
      11. SET @invi2 = '45/42/43/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/-1/-1/1/-1/0/2/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      12. SET @invi3 = '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$'
      13. SET @invi4 = '46/44/47/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/1/2/52/0/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      14. END
      Alles anzeigen

      ===

      Registerpage (mit einfachen Captcha)

      PHP-Quellcode

      1. <?php
      2. $MD5Code = "kikugalanet"; // Your Neuz MD5 Code
      3. $dbAddr = 'YOURSERVER'; // Your MSSQL Host IP
      4. $dbUser = 'sa'; // Your Database user
      5. $dbPass = 'YOURSQLPASS'; // Your Database User password
      6. $dbName = "ACCOUNT_DBF"; // Your Account Database
      7. $server_name = "FlyForEver"; // Define your Servername here
      8. $reg_allow = 1; // Um Registrierung anzuschalten eine "1" hinschreiben
      9. if(!extension_loaded("mssql")) {
      10. echo "Das benötigte Modul MSSQL ist auf Ihren Server nicht aktiviert. Bitte aktivieren Sie es.";
      11. exit();
      12. }
      14. $link = mssql_connect($dbAddr, $dbUser, $dbPass) or die ("Es konnte keine Verbindung zur Datenbank hergestellt werden. Bitte überprüfen sie Ihre Einstellungen.");
      15. mssql_select_db($dbName, $link);
      16. ?>
      18. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
      19. <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en">
      20. <head>
      21. <title><?php echo ('..:: '.$server_name.' - Registrierung ::..'); ?></title>
      22. </head>
      23. <body>
      24. <?php
      25. if ($reg_allow == 1) {
      27. function cleanFormData($text) {
      28. $data = strtolower($text);
      29. $data = trim($text);
      30. $data = htmlentities($text);
      31. $data = strip_tags($text);
      32. return $data;
      33. }
      35. if(isset($_POST['submit'])) {
      36. $userName = cleanFormData($_POST['user']); // Username
      37. $userPass = cleanFormData($_POST['pass']); // Password non-encrypted
      38. $userPass2 = cleanFormData($_POST['pass2']); // Password non-encrypted
      39. $captcha = cleanFormData($_POST['captcha']); // Password non-encrypted
      41. $checkUserName = mssql_query("SELECT account FROM ACCOUNT_TBL WHERE account='".$userName."'");
      43. if(empty($userName) || empty($userPass) || empty($userPass2) || empty($captcha)) {
      44. echo "Bitte alle Felder ausfüllen!";
      45. exit();
      46. }elseif(mssql_num_rows($checkUserName) >= 1) {
      47. echo "Der Nutzername <b>".$_POST['user']."</b> ist bereits in Verwendung.";
      48. exit();
      49. }elseif($_POST['pass'] != $_POST['pass2']) {
      50. echo "Passwörter stimmen nicht überein.";
      51. exit();
      52. }elseif($_POST['captcha'] != $_POST['captcha_check']) {
      53. echo "Captcha stimmt nicht.";
      54. exit();
      55. } else {
      56. $passHash = md5($MD5Code . $userPass);
      58. // Create a new stored prodecure
      59. $stmt = mssql_init("createaccount", $link);
      61. // Bind the field names
      62. mssql_bind($stmt, '@account', $userName, SQLVARCHAR, false, false, 15);
      63. mssql_bind($stmt, '@password', $passHash, SQLVARCHAR, false, false, 15);
      65. // Execute
      66. mssql_execute($stmt) or die ("Something is wrong on the execution");
      68. // Free statement
      69. mssql_free_statement($stmt);
      71. echo "Der Account <b>".$_POST['user']."</b> wurde erfolgreich erstellt!<br><br>Wir wünschen euch viel Spaß beim Spielen.";
      72. }
      73. } else {
      74. $zahl1 = rand(10,20); //Erste Zahl 10-20
      75. $zahl2 = rand(1,10); //Zweite Zahl 1-10
      76. $operator = rand(1,2); // + oder -
      77. if($operator == "1"){
      78. $operatorzeichen = " + ";
      79. $ergebnis = $zahl1 + $zahl2;
      80. }else{
      81. $operatorzeichen = " - ";
      82. $ergebnis = $zahl1 - $zahl2;
      83. }
      84. $rechnung = $zahl1.$operatorzeichen.$zahl2." = ?";
      85. echo'
      86. <form method="post">
      87. <table border="0" cellpadding="0" cellspacing="0" >
      88. <tr><td width="75">Username:</td><td><input type="text" name="user" size="15" maxlenght="15" /></td></tr>
      89. <tr><td>Password:</td><td><input type="password" name="pass" size="15" /></td></tr>
      90. <tr><td><font size="-2">Passwort<br>(wiederholen)<font></td><td><input type="password" name="pass2" size="15" /></td></tr>
      91. <tr><td>'.$rechnung.'</td><td><input type="text" name="captcha" size="15" /></td></tr>
      92. <input type="hidden" name="captcha_check" value="'.$ergebnis.'">
      93. </table>
      94. <br>
      95. <tr><td></td><td><input type="submit" name="submit" value="Register" /></td></tr>
      96. </form>';
      97. }
      98. }
      99. else
      100. {
      101. echo 'Derzeit sind keine Registrierungen möglich!';
      102. exit();
      103. }
      104. ?>
      105. </body>
      106. </html>
      Alles anzeigen


      English translation by: Creed0116

      PHP-Quellcode

      1. <?php
      2. $MD5Code = "kikugalanet"; // Your Neuz MD5 Code
      3. $dbAddr = 'YOURHOST'; // Your MSSQL Host IP
      4. $dbUser = 'sa'; // Your Database user
      5. $dbPass = 'YOURPASSWORD'; // Your Database User password
      6. $dbName = "ACCOUNT_DBF"; // Your Account Database
      7. $server_name = "Flyff"; // Define your Servername here
      8. $reg_allow = 1; // To turn on registering a write "1"
      9. if(!extension_loaded("mssql")) {
      10. echo "The required module is not enabled on your MSSQL server. Please enable it.";
      11. exit();
      12. }
      14. $link = mssql_connect($dbAddr, $dbUser, $dbPass) or die ("Could not connect to the database. Please check your settings.");
      15. mssql_select_db($dbName, $link);
      16. ?>
      18. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
      19. <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en">
      20. <head>
      21. <title><?php echo ('..:: '.$server_name.' - Registration ::..'); ?></title>
      22. </head>
      23. <body>
      24. <?php
      25. if ($reg_allow == 1) {
      27. function cleanFormData($text) {
      28. $data = strtolower($text);
      29. $data = trim($text);
      30. $data = htmlentities($text);
      31. $data = strip_tags($text);
      32. return $data;
      33. }
      35. if(isset($_POST['submit'])) {
      36. $userName = cleanFormData($_POST['user']); // Username
      37. $userPass = cleanFormData($_POST['pass']); // Password non-encrypted
      38. $userPass2 = cleanFormData($_POST['pass2']); // Password non-encrypted
      39. $captcha = cleanFormData($_POST['captcha']); // Password non-encrypted
      41. $checkUserName = mssql_query("SELECT account FROM ACCOUNT_TBL WHERE account='".$userName."'");
      43. if(empty($userName) || empty($userPass) || empty($userPass2) || empty($captcha)) {
      44. echo "Please complete all fields!";
      45. exit();
      46. }elseif(mssql_num_rows($checkUserName) >= 1) {
      47. echo "The username <b>".$_POST['user']."</b> is already in use.";
      48. exit();
      49. }elseif($_POST['pass'] != $_POST['pass2']) {
      50. echo "Passwords do not match.";
      51. exit();
      52. }elseif($_POST['captcha'] != $_POST['captcha_check']) {
      53. echo "Captcha is not true.";
      54. exit();
      55. } else {
      56. $passHash = md5($MD5Code . $userPass);
      58. // Create a new stored prodecure
      59. $stmt = mssql_init("createaccount", $link);
      61. // Bind the field names
      62. mssql_bind($stmt, '@account', $userName, SQLVARCHAR, false, false, 15);
      63. mssql_bind($stmt, '@password', $passHash, SQLVARCHAR, false, false, 15);
      65. // Execute
      66. mssql_execute($stmt) or die ("Something is wrong on the execution");
      68. // Free statement
      69. mssql_free_statement($stmt);
      71. echo "The Account <b>".$_POST['user']."</b> was successfully created!<br><br>We wish you much fun playing.";
      72. }
      73. } else {
      74. $zahl1 = rand(10,20); //First Number 10-20
      75. $zahl2 = rand(1,10); //Second number 1-10
      76. $operator = rand(1,2); // + Or --
      77. if($operator == "1"){
      78. $operatorzeichen = " + ";
      79. $ergebnis = $zahl1 + $zahl2;
      80. }else{
      81. $operatorzeichen = " - ";
      82. $ergebnis = $zahl1 - $zahl2;
      83. }
      84. $rechnung = $zahl1.$operatorzeichen.$zahl2." = ?";
      85. echo'
      86. <form method="post">
      87. <table border="0" cellpadding="0" cellspacing="0" >
      88. <tr><td width="75">Username:</td><td><input type="text" name="user" size="15" maxlenght="15" /></td></tr>
      89. <tr><td>Password:</td><td><input type="password" name="pass" size="15" /></td></tr>
      90. <tr><td><font size="-2">Password<br>(repeat)<font></td><td><input type="password" name="pass2" size="15" /></td></tr>
      91. <tr><td>'.$rechnung.'</td><td><input type="text" name="captcha" size="15" /></td></tr>
      92. <input type="hidden" name="captcha_check" value="'.$ergebnis.'">
      93. </table>
      94. <br>
      95. <tr><td></td><td><input type="submit" name="submit" value="Register" /></td></tr>
      96. </form>';
      97. }
      98. }
      99. else
      100. {
      101. echo 'Currently, no registrations are available!';
      102. exit();
      103. }
      104. ?>
      105. </body>
      106. </html>
      Alles anzeigen


      Bevor jemand sagt das das mit den Startitems von Godlikerz[MMORPG-Core] geleecht ist möchte ich vorweg sagen das Rejun und ich ein und die selbe Person sind.

      Change here the startpenya, Above the part for the startitems

      Quellcode

      1. INSERT CHARACTER_TBL
      2. (
      3. m_idPlayer,
      4. serverindex,
      5. account,
      6. m_szName,
      7. playerslot,
      8. dwWorldID,
      9. m_dwIndex,
      10. m_vScale_x,
      11. m_dwMotion,
      12. m_vPos_x,
      14. m_vPos_y,
      15. m_vPos_z,
      16. m_fAngle,
      17. m_szCharacterKey,
      18. m_nHitPoint,
      19. m_nManaPoint,
      20. m_nFatiguePoint,
      21. m_nFuel,
      22. m_dwSkinSet,
      23. m_dwHairMesh,
      24. m_dwHairColor,
      25. m_dwHeadMesh,
      26. m_dwSex,
      27. m_dwRideItemIdx,
      28. m_dwGold,
      29. m_nJob,
      30. m_pActMover,
      31. m_nStr,
      32. m_nSta,
      33. m_nDex,
      34. m_nInt,
      35. m_nLevel,
      36. m_nMaximumLevel,
      37. m_nExp1,
      38. m_nExp2,
      39. m_aJobSkill,
      40. m_aLicenseSkill,
      41. m_aJobLv,
      42. m_dwExpertLv,
      43. m_idMarkingWorld,
      44. m_vMarkingPos_x,
      45. m_vMarkingPos_y,
      46. m_vMarkingPos_z,
      47. m_nRemainGP,
      48. m_nRemainLP,
      49. m_nFlightLv,
      50. m_nFxp,
      51. m_nTxp,
      52. m_lpQuestCntArray,
      53. m_aCompleteQuest,
      54. m_chAuthority,
      55. m_dwMode,
      56. m_idparty,
      57. m_idCompany,
      58. --m_nNumKill,
      59. m_idMuerderer,
      60. --m_nSlaughter,
      61. m_nFame,
      62. m_nDeathExp,
      63. m_nDeathLevel,
      65. m_dwFlyTime,
      66. m_nMessengerState,
      67. blockby,
      68. TotalPlayTime,
      69. isblock,
      70. End_Time,
      71. BlockTime,
      72. CreateTime,
      73. m_tmAccFuel,
      74. m_tGuildMember,
      75. m_dwSkillPoint,
      76. m_dwReturnWorldID,
      77. m_vReturnPos_x,
      78. m_vReturnPos_y,
      79. m_vReturnPos_z
      80. )
      81. VALUES
      82. (
      83. @om_idPlayer,
      84. @iserverindex,
      85. @iaccount,
      86. @im_szName,
      87. @iplayerslot,
      88. @idwWorldID,
      89. @im_dwIndex,
      90. '1',
      92. '0',
      93. @im_vPos_x,
      94. @im_vPos_y,
      95. @im_vPos_z,
      96. '0',
      97. @im_szCharacterKey,
      98. '230',
      99. '63',
      100. '32',
      101. -1, --m_nFuel
      102. @im_dwSkinSet,
      103. @im_dwHairMesh,
      104. @im_dwHairColor,
      105. @im_dwHeadMesh,
      106. @im_dwSex,
      107. '0',
      108. '1000', --Start Gold
      109. '0',
      110. '1,0',
      111. '15',
      112. '15',
      113. '15',
      114. '15',
      115. '1',
      116. '1', --m_nMaximumLevel
      117. '0',
      118. '0',
      119. '',
      120. '',
      121. '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$',
      122. '0',
      123. '0',
      124. '0',
      125. '0',
      126. '0',
      127. '0',
      128. '0',
      129. '0',
      130. '0',
      131. '0',
      132. '$',
      133. '$', -- m_aCompleteQuest
      134. 'F',
      135. '131072',
      136. '0',
      137. '0', -- m_idCompany
      138. --@om_nNumKill,
      139. '0',
      140. --@om_nSlaughter,
      141. '0',
      142. '0',
      143. '0',
      144. '0' ,
      145. '0',
      146. @oblockby,
      147. '0',
      148. 'F',
      149. '200811030000',
      150. CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112),
      151. GETDATE(),
      152. 0,
      153. CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112)
      154. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,-1,GETDATE()))),2)
      155. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,-1,GETDATE()))),2)
      156. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,-1,GETDATE()))),2),
      157. 0, --m_dwSkillPoint
      158. 1,
      159. 0,
      160. 0,
      161. 0
      162. )
      Alles anzeigen

    • Werbung zur Unterstützung des Forums ( Bitte AddBlocker deaktivieren )