Angepinnt FragenThread [Offi V14]

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

    • Soo ich hab paar Cs Pets rein gemacht die jetz auch gehen aber wen ich World server Starte kommt einhaufen errors.
      "Errors"

      2010/ 2/ 4 00:30:28 FileName mdlDyna.inc(4949) : II_ARM_F_CHR_LEPRECHAUN01SUIT Not Found. : II_ARM_F_CHR_LEPRECHAUN01SUIT MODELTYPE_MESH "fCloLeprechaun01Upper" 0 MD_NEAR

      2010/ 2/ 4 00:30:28 FileName mdlDyna.inc(4950) : II_ARM_F_CHR_LEPRECHAUN01GLOVES Not Found. : II_ARM_F_CHR_LEPRECHAUN01GLOVES MODELTYPE_MESH "fCloLeprechaun01Hand" 0 MD_NEA

      2010/ 2/ 4 00:30:29 FileName mdlDyna.inc(4951) : II_ARM_F_CHR_LEPRECHAUN01SHOES Not Found. : II_ARM_F_CHR_LEPRECHAUN01SHOES MODELTYPE_MESH "fCloLeprechaun01Foot" 0 MD_NEAR

      2010/ 2/ 4 00:30:29 FileName mdlDyna.inc(4953) : II_ARM_M_CHR_IRELAND01HAT Not Found. : II_ARM_M_CHR_IRELAND01HAT MODELTYPE_MESH "mCloLeprechaun01Cap" 0 MD_NEAR 0 1.

      2010/ 2/ 4 00:30:29 FileName mdlDyna.inc(4954) : II_ARM_F_CHR_IRELAND01HAT Not Found. : II_ARM_F_CHR_IRELAND01HAT MODELTYPE_MESH "fCloLeprechaun01Cap" 0 MD_NEAR 0 1.

      2010/ 2/ 4 00:30:30 FileName mdlDyna.inc(5400) : II_PET_Mochi Not Found. : II_PET_Mochi MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1

      "Ge

      2010/ 2/ 4 00:30:30 FileName mdlDyna.inc(5401) : II_PET_Mushi Not Found. : II_PET_Mushi MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1

      "Ge

      2010/ 2/ 4 00:30:30 FileName mdlDyna.inc(5402) : II_PET_Luci Not Found. : II_PET_Luci MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1

      "Ge

      2010/ 2/ 4 00:30:32 FileName mdlDyna.inc(5403) : II_PET_STiger Not Found. : II_PET_STiger MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1

      "

      2010/ 2/ 4 00:30:32 FileName mdlDyna.inc(5404) : II_PET_SLoin Not Found. : II_PET_SLoin MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1

      "G

      2010/ 2/ 4 00:30:33 FileName mdlDyna.inc(5405) : II_PET_SHase Not Found. : II_PET_SHase MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1

      "G

      2010/ 2/ 4 00:30:34 FileName mdlDyna.inc(5406) : II_PET_SDrache Not Found. : II_PET_SDrache MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1



      2010/ 2/ 4 00:30:34 FileName mdlDyna.inc(5407) : II_PET_SPferd Not Found. : II_PET_SPferd MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1

      "

      2010/ 2/ 4 00:30:35 FileName mdlDyna.inc(5408) : II_PET_SFuchs Not Found. : II_PET_SFuchs MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1

      "

      2010/ 2/ 4 00:30:36 FileName mdlDyna.inc(5409) : II_PET_SGreif Not Found. : II_PET_SGreif MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1

      "

      2010/ 2/ 4 00:30:37 FileName mdlDyna.inc(5410) : II_PET_CHESHIRECAT Not Found. : II_PET_CHESHIRECAT MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1

      "G

      2010/ 2/ 4 00:30:37 FileName mdlDyna.inc(5411) : II_PET_WHITERABBIT Not Found. : II_PET_WHITERABBIT MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1

      "G

      2010/ 2/ 4 00:30:38 FileName mdlDyna.inc(5412) : II_PET_WHITETIGER02 Not Found. : II_PET_WHITETIGER02 MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX_NONE 1








      2010/ 2/ 4 00:30:38 FileName mdlDyna.inc(6043) : II_GEN_JEW_RIN_Kniring Not Found. : II_GEN_JEW_RIN_Kniring MODELTYPE_MESH "" 0 MD_NEAR 0 1.0f 0 1 ATEX

      2010/ 2/ 4 00:30:38 FileName mdlDyna.inc(24406) : MI_PET_MOCOMOCHI1 Not Found. : MI_PET_MOCOMOCHI1 MODELTYPE_ANIMATED_MESH "" 0 MD_MID 0 1.0f 0 1 ATEX_N

      2010/ 2/ 4 00:30:42 FileName mdlDyna.inc(24430) : MI_PET_MUSHPANG1 Not Found. : MI_PET_MUSHPANG1 MODELTYPE_ANIMATED_MESH "" 0 MD_MID 0 0.5f 0 1 ATEX_NONE

      2010/ 2/ 4 00:30:42 FileName mdlDyna.inc(24454) : MI_PET_LUCIFER01 Not Found. : MI_PET_LUCIFER01 MODELTYPE_ANIMATED_MESH "" 0 MD_MID 0 0.2f 0 1 ATEX_NONE

      2010/ 2/ 4 00:30:42 FileName mdlDyna.inc(24478) : MI_PET_STIGER Not Found. : MI_PET_STIGER MODELTYPE_ANIMATED_MESH "" 0 MD_MID 0 1.1f 0 1 ATEX_02 1

      {

      "

      2010/ 2/ 4 00:30:43 FileName mdlDyna.inc(24502) : MI_PET_SLION Not Found. : MI_PET_SLION MODELTYPE_ANIMATED_MESH "" 0 MD_MID 0 1.3f 0 1 ATEX_02 1

      {

      "

      2010/ 2/ 4 00:30:43 FileName mdlDyna.inc(24526) : MI_PET_SRABBIT Not Found. : MI_PET_SRABBIT MODELTYPE_ANIMATED_MESH "" 0 MD_MID 0 1.0f 0 1 ATEX_02 1

      {



      2010/ 2/ 4 00:30:43 FileName mdlDyna.inc(24550) : MI_PET_SDRAGON Not Found. : MI_PET_SDRAGON MODELTYPE_ANIMATED_MESH "" 0 MD_MID 0 1.0f 0 1 ATEX_02 1

      {



      2010/ 2/ 4 00:30:44 FileName mdlDyna.inc(24574) : MI_PET_SPFERD Not Found. : MI_PET_SPFERD MODELTYPE_ANIMATED_MESH "" 0 MD_MID 0 1.0f 0 1 ATEX_02 1

      {

      "

      2010/ 2/ 4 00:30:44 FileName mdlDyna.inc(24598) : MI_PET_SFOX Not Found. : MI_PET_SFOX MODELTYPE_ANIMATED_MESH "" 0 MD_MID 0 1.0f 0 1 ATEX_02 1

      {

      "st

      2010/ 2/ 4 00:30:45 FileName mdlDyna.inc(24622) : MI_PET_SGRIFFIN Not Found. : MI_PET_SGRIFFIN MODELTYPE_ANIMATED_MESH "" 0 MD_MID 0 1.0f 0 1 ATEX_02 1

      {


      Wen ich das Spiel Starte kommen auch diese Errors.
      Und ich krieg die einfach nich weg kann mir bitte einer helfen?

      Mfg Asterfix

    • Hallo erstmal, ich habe einen P-Server . Darauf zocke ich mit kollegen abunzu Guild War ,jedoch fehlt uns die neueren items wie Ginger Bread, Christmas Cake ect. Wir benutzen /haben die v14 Files.
      Wie kann man Ginger Bread ect hinzufügen oder wie kann man eine erweckung machen wie zb 35% Hprate. Ich hab schon im defindeskill.h geschaut doch ich kenn mich da nicht gescheit aus. Hab einiges probiert doch da kommen bei zahlen wie /sro 2 10000000000000100
      100%atk aber adnn auch minus Bow Atk kp wieso habs durch testen der zahlen iwie rausbekommen , näher kenne ich mich wie gesagt mir der sache nicht aus.
      Könntet ihr mir vll hierbei behilflich sein?

      mfg Raykin

    • nikox3;100681 schrieb:

      Morgen jungs und mädels,
      hab jetzt wieder ein anderes problem -.-
      wen ich mich einlogge char ausgewählt habe kommt dan verbindung zum server unterbrochen ohne das ich auf der welt war halt nur char auswälent dan auf next nach 10sec kommt dan die nachricht verbindung zum server unterbrochen?!:yuush:

      @ Raykin

      guck mal hier nach :[Offi Files]Fragen u. Disskussionsthread


      Errors lesen ftw mehr sag ich nicht ~.~

    • Errors lesen ftw mehr sag ich nicht ~.~

      ^^
      ist klar und was soll ich daraus lesen:

      2010/ 3/29 11:32:18 LoadObject : Part_maleHair05.o3d Àб⠽ÇÆÐ

      2010/ 3/29 11:32:18 Model\Part_maleHair05.o3d : ãÀ» ¼ö ¾øÀ½

      2010/ 3/29 11:32:18 LoadObject : Part_maleHead05.o3d Àб⠽ÇÆÐ

      2010/ 3/29 11:32:18 Model\Part_maleHead05.o3d : ãÀ» ¼ö ¾øÀ½

      2010/ 3/29 11:32:18 LoadObject : part_mVag01Upper.o3d Àб⠽ÇÆÐ

      2010/ 3/29 11:32:18 Model\part_mVag01Upper.o3d : ãÀ» ¼ö ¾øÀ½

      2010/ 3/29 11:32:18 LoadObject : part_mVag01Hand.o3d Àб⠽ÇÆÐ

      2010/ 3/29 11:32:18 Model\part_mVag01Hand.o3d : ãÀ» ¼ö ¾øÀ½

      2010/ 3/29 11:32:18 LoadObject : part_mVag01Foot.o3d Àб⠽ÇÆÐ

      2010/ 3/29 11:32:18 Model\part_mVag01Foot.o3d : ãÀ» ¼ö ¾øÀ½

      2010/ 3/29 11:32:18 CHousingMng::DestroyHousing() - Housing not found : 1

      2010/ 3/29 11:32:20 OP: 1470, 1440.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


      2010/ 3/29 11:33:17 Event.lua Àç½ÇÇà ¿Ï·á!!!

      2010/ 3/29 11:44:13 string error: IDS_PROPITEM_TXT_011104

      2010/ 3/29 11:44:13 string error: IDS_PROPITEM_TXT_011105

      2010/ 3/29 11:44:24 CDbManager::UpdateGuildRanking¿¡¼* (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01') ½ÇÆÐ

      2010/ 3/29 11:44:35 string error: IDS_PROPITEM_TXT_011104

      2010/ 3/29 11:44:35 string error: IDS_PROPITEM_TXT_011105

      2010/ 3/29 11:44:40 OP: 9408908, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


      2010/ 3/29 11:45:07 OP: 26983, 0.0, 0.0, 26981.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


      2010/ 3/29 11:45:19 OP: 11640, 0.0, 0.0, 0.0, 0.0, 0.0, 11637.0, 0.0, 0.0, 0.0, 0.0, 0.0, 1.0


      2010/ 3/29 11:47:31 OP: 1662, 1090.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0

    • nikox3;100685 schrieb:

      Errors lesen ftw mehr sag ich nicht ~.~

      ^^
      ist klar und was soll ich daraus lesen:

      [SIZE="4"][COLOR="Red"]2010/ 3/29 11:32:18 LoadObject : Part_maleHair05.o3d Àб⠽ÇÆÐ

      2010/ 3/29 11:32:18 Model\Part_maleHair05.o3d : ãÀ» ¼ö ¾øÀ½

      2010/ 3/29 11:32:18 LoadObject : Part_maleHead05.o3d Àб⠽ÇÆÐ

      2010/ 3/29 11:32:18 Model\Part_maleHead05.o3d : ãÀ» ¼ö ¾øÀ½

      2010/ 3/29 11:32:18 LoadObject : part_mVag01Upper.o3d Àб⠽ÇÆÐ

      2010/ 3/29 11:32:18 Model\part_mVag01Upper.o3d : ãÀ» ¼ö ¾øÀ½

      2010/ 3/29 11:32:18 LoadObject : part_mVag01Hand.o3d Àб⠽ÇÆÐ

      2010/ 3/29 11:32:18 Model\part_mVag01Hand.o3d : ãÀ» ¼ö ¾øÀ½

      2010/ 3/29 11:32:18 LoadObject : part_mVag01Foot.o3d Àб⠽ÇÆÐ

      2010/ 3/29 11:32:18 Model\part_mVag01Foot.o3d : ãÀ» ¼ö ¾øÀ½

      2010/ 3/29 11:32:18 CHousingMng::DestroyHousing() - Housing not found[/COLOR][/SIZE] : 1

      2010/ 3/29 11:32:20 OP: 1470, 1440.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


      2010/ 3/29 11:33:17 [COLOR="Red"][SIZE="4"] Event.lua Àç½ÇÇà ¿Ï·á!!![/SIZE][/COLOR]

      2010/ 3/29 11:44:13 string error: IDS_PROPITEM_TXT_011104

      2010/ 3/29 11:44:13 string error: IDS_PROPITEM_TXT_011105

      2010/ 3/29 11:44:24 CDbManager::UpdateGuildRanking¿¡¼* (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01') ½ÇÆÐ

      2010/ 3/29 11:44:35 string error: IDS_PROPITEM_TXT_011104

      2010/ 3/29 11:44:35 string error: IDS_PROPITEM_TXT_011105

      2010/ 3/29 11:44:40 OP: 9408908, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


      2010/ 3/29 11:45:07 OP: 26983, 0.0, 0.0, 26981.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


      2010/ 3/29 11:45:19 OP: 11640, 0.0, 0.0, 0.0, 0.0, 0.0, 11637.0, 0.0, 0.0, 0.0, 0.0, 0.0, 1.0


      2010/ 3/29 11:47:31 OP: 1662, 1090.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


      So ich denke mal du bist ziemlich verblödet oder ? Hast wohl deine Brain.exe in der Mülltonne? Guck dir das rote an -.- dann sollte dir was auffallen.

    • [FONT="Comic Sans MS"][COLOR="DimGray"][SIZE="2"]

      nikox3;100685 schrieb:

      Errors lesen ftw mehr sag ich nicht ~.~

      ^^
      ist klar und was soll ich daraus lesen:



      2010/ 3/29 11:44:13 string error: IDS_PROPITEM_TXT_011104

      2010/ 3/29 11:44:13 string error: IDS_PROPITEM_TXT_011105

      2010/ 3/29 11:44:35 string error: IDS_PROPITEM_TXT_011104

      2010/ 3/29 11:44:35 string error: IDS_PROPITEM_TXT_011105



      Fehler mit den IDs... Überprüfe sie nochmal[/SIZE][/COLOR][/FONT]

    • nikox3;100695 schrieb:

      OMG man kannst auch netter erklären ey,
      ich mache das zuum ersten mal du hast bestimmt beim ersten mall auch fehler gemacht -.-
      wen du keine lust hast zu antworten dan kannste es auch lassen.


      Wenn du kein English kannst solltest du die Files sofort von deinem Rechner löschen. Ja ich war auch Anfänger doch ich habe aus [SIZE="4"]Lesen[/SIZE] gelernt....

    • bloodcore;100740 schrieb:

      Kann mich nicht in den World einloggen

      Error

      Quellcode

      1. 2010/ 3/29 14:24:52 mvr_male.chr : ãÀ» ¼ö ¾øÀ½
      3. 2010/ 3/29 14:24:52 mvr_male_GenStand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½
      5. 2010/ 3/29 14:24:52 LoadObject : Part_femaleHair01.o3d Àб⠽ÇÆÐ
      7. 2010/ 3/29 14:24:52 Model\Part_femaleHair01.o3d : ãÀ» ¼ö ¾øÀ½
      9. 2010/ 3/29 14:24:52 LoadObject : Part_femaleHead01.o3d Àб⠽ÇÆÐ
      11. 2010/ 3/29 14:24:52 Model\Part_femaleHead01.o3d : ãÀ» ¼ö ¾øÀ½
      13. 2010/ 3/29 14:24:52 LoadObject : Part_femaleUpper.o3d Àб⠽ÇÆÐ
      15. 2010/ 3/29 14:24:52 Model\Part_femaleUpper.o3d : ãÀ» ¼ö ¾øÀ½
      17. 2010/ 3/29 14:24:52 LoadObject : Part_femaleLower.o3d Àб⠽ÇÆÐ
      19. 2010/ 3/29 14:24:52 Model\Part_femaleLower.o3d : ãÀ» ¼ö ¾øÀ½
      21. 2010/ 3/29 14:24:52 LoadObject : Part_femaleHand.o3d Àб⠽ÇÆÐ
      23. 2010/ 3/29 14:24:52 Model\Part_femaleHand.o3d : ãÀ» ¼ö ¾øÀ½
      25. 2010/ 3/29 14:24:52 LoadObject : Part_femaleFoot.o3d Àб⠽ÇÆÐ
      27. 2010/ 3/29 14:24:52 Model\Part_femaleFoot.o3d : ãÀ» ¼ö ¾øÀ½
      29. 2010/ 3/29 14:24:52 mvr_male_GenStand.ani : º»À» ·ÎµùÇÏÁö ¾Ê°í ¸ð¼ÇÀ» ÀÐÀ½
      31. 2010/ 3/29 14:24:52 LoadObject : Part_maleHair01.o3d Àб⠽ÇÆÐ
      33. 2010/ 3/29 14:24:52 Model\Part_maleHair01.o3d : ãÀ» ¼ö ¾øÀ½
      35. 2010/ 3/29 14:24:52 LoadObject : Part_maleHead03.o3d Àб⠽ÇÆÐ
      37. 2010/ 3/29 14:24:52 Model\Part_maleHead03.o3d : ãÀ» ¼ö ¾øÀ½
      39. 2010/ 3/29 14:24:52 LoadObject : part_mVag01Upper.o3d Àб⠽ÇÆÐ
      41. 2010/ 3/29 14:24:52 Model\part_mVag01Upper.o3d : ãÀ» ¼ö ¾øÀ½
      43. 2010/ 3/29 14:24:52 LoadObject : part_mVag01Hand.o3d Àб⠽ÇÆÐ
      45. 2010/ 3/29 14:24:52 Model\part_mVag01Hand.o3d : ãÀ» ¼ö ¾øÀ½
      47. 2010/ 3/29 14:24:52 LoadObject : part_mVag01Foot.o3d Àб⠽ÇÆÐ
      49. 2010/ 3/29 14:24:52 Model\part_mVag01Foot.o3d : ãÀ» ¼ö ¾øÀ½
      51. 2010/ 3/29 14:24:52 LoadObject : item_WeaSwoWooden.o3d Àб⠽ÇÆÐ
      53. 2010/ 3/29 14:24:52 Model\item_WeaSwoWooden.o3d : ãÀ» ¼ö ¾øÀ½
      55. 2010/ 3/29 15:08:20 rCnt=1 WorldServer.exe caused an EXCEPTION_ACCESS_VIOLATION in module WorldServer.exe at 001B:00558A34, CWorld::DeleteObj()+0020 byte(s), D:\ÇØ¿Ü\neurospace\Program\_Common\World.cpp, line 0431
      57. - Registers
      59. EAX=00000011 EBX=008128E8 ECX=00000000 EDX=00000000 ESI=0453F800
      60. EDI=00000000 EBP=00000000 ESP=0497FE10 EIP=00558A34 FLG=00010206
      61. CS=001B DS=0023 SS=0023 ES=0023 FS=003B GS=0000
      63. 001B:00558A34 (0x0453F800 0x004555E4 0x00610DD8 0x04564DA8) WorldServer.exe, CWorld::DeleteObj()+0020 byte(s), D:\ÇØ¿Ü\neurospace\Program\_Common\World.cpp, line 0431
      64. 001B:004C2D8C (0x00610DD8 0x04564DA8 0x0045555A 0x0453F800) WorldServer.exe, CObj::Delete()+0012 byte(s), D:\ÇØ¿Ü\neurospace\Program\_Common\Obj.cpp, line 0737
      65. 001B:004555E4 (0x0453F800 0x04531D58 0x00455A95 0x008128E8) WorldServer.exe, CRangda::ProcessReplace()+0068 byte(s), D:\ÇØ¿Ü\neurospace\Program\WorldServer\rangda.cpp, line 0103
      66. 001B:0045555A (0x008128E8 0x719426F0 0x004582AB 0x00000000) WorldServer.exe, CRangda::OnTimer()+0026 byte(s), D:\ÇØ¿Ü\neurospace\Program\WorldServer\rangda.cpp, line 0076+0008 byte(s)
      67. 001B:00455A95 (0x00000000 0x01A72A90 0x0497FF88 0x01A72A90) WorldServer.exe, CRangdaController::OnTimer()+0021 byte(s), D:\ÇØ¿Ü\neurospace\Program\WorldServer\rangda.cpp, line 0184+0007 byte(s)
      Alles anzeigen



      Jemand ne Idee?=.



      wie man sieht fehlen dir eine ganze menge Models und so ;D unteranderem soger welche vom Char ;P

    • So da ich gerade dabei bin die Vietnam Db von TwiLight zu entbuggen hab ich eine kleine Frage.

      Wie kann ich die Account_DBF von den XP Crypt Query befreien so das er sie ohne ausführt.

      Quellcode

      1. USE [ACCOUNT_DBF]
      2. GO
      3. /****** Object: User [ongate] Script Date: 10/28/2009 17:14:27 ******/
      4. CREATE USER [ongate] FOR LOGIN [ongate] WITH DEFAULT_SCHEMA=[dbo]
      5. GO
      6. /****** Object: User [billing] Script Date: 10/28/2009 17:14:27 ******/
      7. CREATE USER [billing] FOR LOGIN [billing] WITH DEFAULT_SCHEMA=[dbo]
      8. GO
      9. /****** Object: User [account] Script Date: 10/28/2009 17:14:27 ******/
      10. CREATE USER [account] FOR LOGIN [account] WITH DEFAULT_SCHEMA=[dbo]
      11. GO
      12. /****** Object: User [acc_on9@te] Script Date: 10/28/2009 17:14:27 ******/
      13. CREATE USER [acc_on9@te] FOR LOGIN [acc_on9@te] WITH DEFAULT_SCHEMA=[acc_on9@te]
      14. GO
      15. /****** Object: Schema [acc_on9@te] Script Date: 10/28/2009 17:14:28 ******/
      16. CREATE SCHEMA [acc_on9@te] AUTHORIZATION [account]
      17. GO
      18. /****** Object: Table [dbo].[CashHistory] Script Date: 10/28/2009 17:14:39 ******/
      19. SET ANSI_NULLS ON
      20. GO
      21. SET QUOTED_IDENTIFIER ON
      22. GO
      23. SET ANSI_PADDING ON
      24. GO
      25. CREATE TABLE [dbo].[CashHistory](
      26. [account] [varchar](32) NULL,
      27. [beforeCash] [int] NULL,
      28. [afterCash] [int] NULL,
      29. [regdate] [datetime] NULL
      30. ) ON [PRIMARY]
      31. GO
      32. SET ANSI_PADDING OFF
      33. GO
      34. /****** Object: Table [dbo].[ACCOUNT_TBL] Script Date: 10/28/2009 17:14:40 ******/
      35. SET ANSI_NULLS ON
      36. GO
      37. SET QUOTED_IDENTIFIER ON
      38. GO
      39. SET ANSI_PADDING ON
      40. GO
      41. CREATE TABLE [dbo].[ACCOUNT_TBL](
      42. [account] [varchar](32) NOT NULL,
      43. [password] [char](32) NOT NULL,
      44. [isuse] [char](1) NULL,
      45. [member] [char](1) NULL,
      46. [id_no1] [char](6) NULL,
      47. [id_no2] [char](255) NULL,
      48. [realname] [char](1) NULL,
      49. [reload] [char](1) NULL,
      50. [cash] [int] NULL
      51. ) ON [PRIMARY]
      52. GO
      53. SET ANSI_PADDING OFF
      54. GO
      55. CREATE UNIQUE CLUSTERED INDEX [ACCOUNT_ID1] ON [dbo].[ACCOUNT_TBL]
      56. (
      57. [account] DESC
      58. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
      59. GO
      60. EXEC sys.sp_addextendedproperty @name=N'123', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ACCOUNT_TBL', @level2type=N'COLUMN',@level2name=N'account'
      61. GO
      62. EXEC sys.sp_addextendedproperty @name=N'123', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ACCOUNT_TBL', @level2type=N'COLUMN',@level2name=N'password'
      63. GO
      64. /****** Object: Table [dbo].[ACCOUNT_TBL_DETAIL] Script Date: 10/28/2009 17:14:40 ******/
      65. SET ANSI_NULLS ON
      66. GO
      67. SET QUOTED_IDENTIFIER ON
      68. GO
      69. SET ANSI_PADDING ON
      70. GO
      71. CREATE TABLE [dbo].[ACCOUNT_TBL_DETAIL](
      72. [account] [varchar](32) NOT NULL,
      73. [gamecode] [char](4) NOT NULL,
      74. [tester] [char](1) NOT NULL,
      75. [m_chLoginAuthority] [char](1) NULL,
      76. [regdate] [datetime] NOT NULL,
      77. [BlockTime] [char](8) NULL,
      78. [EndTime] [char](8) NULL,
      79. [WebTime] [char](8) NULL,
      80. [isuse] [char](1) NULL,
      81. [secession] [datetime] NULL,
      82. [email] [varchar](100) NOT NULL
      83. ) ON [PRIMARY]
      84. GO
      85. SET ANSI_PADDING OFF
      86. GO
      87. CREATE UNIQUE CLUSTERED INDEX [ACCOUNT_TBL_DETAIL_ID1] ON [dbo].[ACCOUNT_TBL_DETAIL]
      88. (
      89. [account] DESC,
      90. [gamecode] DESC
      91. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
      92. GO
      93. /****** Object: Table [dbo].[PCZone] Script Date: 10/28/2009 17:14:40 ******/
      94. SET ANSI_NULLS ON
      95. GO
      96. SET QUOTED_IDENTIFIER ON
      97. GO
      98. SET ANSI_PADDING ON
      99. GO
      100. CREATE TABLE [dbo].[PCZone](
      101. [PCZoneID] [int] IDENTITY(1,1) NOT NULL,
      102. [PCZoneName] [varchar](100) NOT NULL,
      103. [Address] [varchar](100) NOT NULL,
      104. [Phone] [varchar](100) NOT NULL,
      105. [CPU] [varchar](100) NOT NULL,
      106. [VGA] [varchar](100) NOT NULL,
      107. [RAM] [varchar](100) NOT NULL,
      108. [Monitor] [varchar](100) NOT NULL,
      109. [Comment] [varchar](1000) NOT NULL,
      110. [Grade] [tinyint] NOT NULL,
      111. [Account] [varchar](32) NOT NULL,
      112. [RegDate] [datetime] NOT NULL,
      113. CONSTRAINT [PK_iCafeInfo_1] PRIMARY KEY CLUSTERED
      114. (
      115. [PCZoneID] ASC
      116. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
      117. ) ON [PRIMARY]
      118. GO
      119. SET ANSI_PADDING OFF
      120. GO
      121. /****** Object: Table [dbo].[mydata] Script Date: 10/28/2009 17:14:40 ******/
      122. SET ANSI_NULLS ON
      123. GO
      124. SET QUOTED_IDENTIFIER ON
      125. GO
      126. SET ANSI_PADDING ON
      127. GO
      128. CREATE TABLE [dbo].[mydata](
      129. [line] [varchar](8000) NULL
      130. ) ON [PRIMARY]
      131. GO
      132. SET ANSI_PADDING OFF
      133. GO
      134. /****** Object: StoredProcedure [dbo].[usp_MessengerList] Script Date: 10/28/2009 17:27:48 ******/
      135. SET ANSI_NULLS ON
      136. GO
      137. SET QUOTED_IDENTIFIER ON
      138. GO
      139. CREATE proc [dbo].[usp_MessengerList]
      140. @serverindex char(2),
      141. @m_szName varchar(32)
      142. as
      144. set nocount on
      146. declare @q1 nvarchar(4000)
      147. declare @m_idPlayer char(7)
      148. set @q1 = '
      149. select @m_idPlayer = m_idPlayer from CHR' + @serverindex + '.CHARACTER_' + @serverindex + '_DBF.dbo.CHARACTER_TBL where m_szName = ''' + @m_szName + ''''
      150. exec sp_executesql @q1, N'@m_idPlayer char(7) output', @m_idPlayer output
      152. set @q1 = '
      153. select c.m_szName, m_idPlayer
      154. from CHR' + @serverindex + '.CHARACTER_' + @serverindex + '_DBF.dbo.tblMessenger as m
      155. inner join CHR' + @serverindex + '.CHARACTER_' + @serverindex + '_DBF.dbo.CHARACTER_TBL as c on m.idFriend = c.m_idPlayer
      156. where m.idPlayer = ''' + @m_idPlayer + ''' and isblock = ''F'' and chUse = ''T'' order by m.idFriend'
      157. exec sp_executesql @q1
      158. GO
      159. /****** Object: Table [dbo].[AccountPlay] Script Date: 10/28/2009 17:27:48 ******/
      160. SET ANSI_NULLS ON
      161. GO
      162. SET QUOTED_IDENTIFIER ON
      163. GO
      164. SET ANSI_PADDING ON
      165. GO
      166. CREATE TABLE [dbo].[AccountPlay](
      167. [Account] [varchar](32) NOT NULL,
      168. [PlayDate] [int] NOT NULL,
      169. [PlayTime] [int] NOT NULL,
      170. CONSTRAINT [PK_AccountPlay] PRIMARY KEY CLUSTERED
      171. (
      172. [Account] ASC
      173. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
      174. ) ON [PRIMARY]
      175. GO
      176. SET ANSI_PADDING OFF
      177. GO
      178. /****** Object: Table [dbo].[PCZoneIP] Script Date: 10/28/2009 17:27:48 ******/
      179. SET ANSI_NULLS ON
      180. GO
      181. SET QUOTED_IDENTIFIER ON
      182. GO
      183. SET ANSI_PADDING ON
      184. GO
      185. CREATE TABLE [dbo].[PCZoneIP](
      186. [IPID] [int] IDENTITY(1,1) NOT NULL,
      187. [PCZoneID] [int] NOT NULL,
      188. [IPFrom1] [tinyint] NOT NULL,
      189. [IPFrom2] [tinyint] NOT NULL,
      190. [IPFrom3] [tinyint] NOT NULL,
      191. [IPFrom4] [tinyint] NOT NULL,
      192. [IPTo4] [tinyint] NOT NULL,
      193. [IsUse] [tinyint] NOT NULL,
      194. [RegDate] [datetime] NOT NULL,
      195. [OperID] [varchar](32) NULL,
      196. [OperDate] [datetime] NULL,
      197. CONSTRAINT [PK_iCafeIP_1] PRIMARY KEY CLUSTERED
      198. (
      199. [IPID] ASC
      200. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
      201. ) ON [PRIMARY]
      202. GO
      203. SET ANSI_PADDING OFF
      204. GO
      205. /****** Object: StoredProcedure [dbo].[usp_UpdateCashInfo] Script Date: 10/28/2009 17:27:48 ******/
      206. SET ANSI_NULLS ON
      207. GO
      208. SET QUOTED_IDENTIFIER ON
      209. GO
      210. create proc [dbo].[usp_UpdateCashInfo]
      211. @account varchar(32),
      212. @cash int
      213. as
      214. set nocount on
      215. set xact_abort on
      217. if exists (select * from ACCOUNT_TBL where account = @account)
      218. begin
      219. begin tran
      220. insert into CashHistory (account, beforeCash, afterCash)
      221. select @account, cash, @cash from ACCOUNT_TBL where account = @account
      223. update ACCOUNT_TBL
      224. set cash = @cash
      225. where account = @account
      226. if @@error <> 0
      227. begin
      228. rollback tran
      229. select -1
      230. end
      231. else
      232. begin
      233. commit tran
      234. select 1
      235. end
      236. end
      237. else
      238. begin
      239. select 0
      240. end
      241. GO
      242. /****** Object: StoredProcedure [dbo].[ACCOUNT_STR] Script Date: 10/28/2009 17:27:48 ******/
      243. SET ANSI_NULLS ON
      244. GO
      245. SET QUOTED_IDENTIFIER ON
      246. GO
      247. CREATE PROC [dbo].[ACCOUNT_STR]
      248. @iaccount VARCHAR(32),
      249. @ipassword VARCHAR(16)
      250. /***********************************************************************************
      251. ***********************************************************************************
      252. ***********************************************************************************
      253. ***********************************************************************************
      257. ACCOUNT_STR 스토어드
      258. 작성자 : 최석준
      259. 작성일 : 2004.01.18
      261. ex) ACCOUNT_STR 'beat','1234'
      263. ***********************************************************************************
      264. ***********************************************************************************
      265. ***********************************************************************************
      266. ***********************************************************************************/
      267. AS
      268. set nocount on
      269. IF EXISTS(SELECT a.account FROM ACCOUNT_TBL a,ACCOUNT_TBL_DETAIL b
      270. WHERE a.account = b.account AND a.account = @iaccount AND gamecode = 'A000')
      271. BEGIN
      272. IF EXISTS(SELECT account FROM ACCOUNT_TBL
      273. WHERE account = @iaccount AND password = @ipassword )
      274. -- BEGIN
      275. --
      276. -- DECLARE @birthyear CHAR(4),@currdate CHAR(8)
      277. -- SELECT @birthyear = CASE WHEN SUBSTRING(id_no2,1,1) IN ('9','0') THEN '18' + SUBSTRING(id_no1,1,2)
      278. -- WHEN SUBSTRING(id_no2,1,1) IN ('1','2') THEN '19' + SUBSTRING(id_no1,1,2)
      279. -- WHEN SUBSTRING(id_no2,1,1) IN ('3','4') THEN '20' + SUBSTRING(id_no1,1,2)
      280. -- WHEN SUBSTRING(id_no2,1,1) IN ('5','6') THEN '21' + SUBSTRING(id_no1,1,2)
      281. -- WHEN SUBSTRING(id_no2,1,1) IN ('7','8') THEN '22' + SUBSTRING(id_no1,1,2)
      282. -- END
      283. -- FROM ACCOUNT_TBL
      284. -- WHERE account = @iaccount
      285. --
      286. -- SELECT @currdate = CONVERT(CHAR(8),GETDATE(),112)
      287. --
      288. -- SELECT fError = CASE WHEN a.id_no1 = 'a00000'
      289. -- THEN '0'
      290. -- WHEN b.BlockTime >= @currdate AND b.EndTime < @currdate
      291. -- THEN '3'
      292. -- WHEN a.realname = 'F'
      293. -- THEN '4'
      294. -- WHEN @birthyear > DATEADD(Year,-13,@currdate)
      295. -- THEN '5'
      296. -- WHEN @birthyear >= DATEADD(Year,-11,@currdate) AND b.tester = '0'
      297. -- THEN '6'
      298. -- ELSE '0' END,
      299. --
      300. -- fText = CASE WHEN a.id_no1 = 'a00000'
      301. -- THEN '사원 및 기자'
      302. -- WHEN b.BlockTime >= @currdate AND b.EndTime < @currdate
      303. -- THEN '계정블럭이거나 유료화 초과'
      304. -- WHEN a.realname = 'F'
      305. -- THEN '실명처리가 안된것'
      306. -- WHEN @birthyear > DATEADD(Year,-13,@currdate)
      307. -- THEN '프리프는 12세 이상 이용가 이므로 게임접속을 할수 없습니다.'
      308. -- WHEN @birthyear >= DATEADD(Year,-11,@currdate) AND b.tester = '0'
      309. -- THEN '14세 미만 가입자 분들은 부모님 동의서를 보내주셔야 게임 접속이 가능합니다'
      310. -- ELSE '정상사용자 14세 이상' END
      311. -- FROM ACCOUNT_TBL a, ACCOUNT_TBL_DETAIL b
      312. -- WHERE a.account = b.account AND b.account = @iaccount AND a.[password] = @ipassword
      313. -- END
      314. BEGIN
      315. SELECT fError = '0', fText = 'OK'
      316. END
      317. ELSE
      318. BEGIN
      319. SELECT fError = '1', fText = 'Wrong Password !!'
      320. END
      321. END
      322. ELSE
      323. BEGIN
      324. SELECT fError = '2', fText = 'Account Not Exists !!'
      325. END
      326. RETURN
      328. -- 계정 검사 Rule
      329. -- 1. (fError=2 리턴) 계정있는지 확인. 계정확인시 "gamecode = A000" 만 프리프 회원.
      330. -- 2. (fError=1 리턴) 암호확인.
      331. -- 3. (fError=0 리턴) 사원 및 기자 확인( id_no1가 a0000 )으로 확인.계정.암호만 확인
      332. -- 4. (fError=3 리턴) 블럭타임과, 과금타임 확인.
      333. -- 5. (fError=4 리턴) 실명확인.
      334. -- 6. (fError=5 리턴) 12세 이상인지 확인. 이하이면 "프리프는 12세 이상 이용가 이므로 ]
      335. -- 게임접속을 할수 없습니다." 라고 알림.
      336. -- 7. (fError=6 리턴) 부모동의서가 없는 애덜 확인 tester = 0 이면 "14세 미만 가입자 분들은
      337. -- 부모등의서를 보내주셔야 게임 접속이 가능합니다"라고 알림.
      338. -- 8. (fError=0 리턴) 위의 예말고는 정상 사용자로 인정.
      339. set nocount off
      340. GO
      341. /****** Object: StoredProcedure [dbo].[usp_CreateNewAccount] Script Date: 10/28/2009 17:27:48 ******/
      342. SET ANSI_NULLS ON
      343. GO
      344. SET QUOTED_IDENTIFIER ON
      345. GO
      346. CREATE proc [dbo].[usp_CreateNewAccount]
      347. @account varchar(32),
      348. @pw varchar(32),
      349. @cash int = 0,
      350. @email varchar(100) = ''
      351. as
      352. set nocount on
      353. set xact_abort on
      355. if not exists (select * from ACCOUNT_TBL where account = @account)
      356. begin
      357. declare @hash char(32), @tpw varchar(40)
      358. set @tpw = 'dlrjsdn' + @pw
      360. exec master.dbo.xp_crypt @tpw, @hash output
      362. begin tran
      363. INSERT ACCOUNT_TBL(account,password,isuse,member,id_no1,id_no2,realname, cash)
      364. VALUES(@account, lower(@hash), 'T', 'A', '', '', '', @cash)
      365. INSERT ACCOUNT_TBL_DETAIL(account,gamecode,tester,m_chLoginAuthority,regdate,BlockTime,EndTime,WebTime,isuse,secession, email)
      366. VALUES(@account,'A000','2','F',GETDATE(),CONVERT(CHAR(8),GETDATE()-1,112),CONVERT(CHAR(8),DATEADD(year,10,GETDATE()),112),CONVERT(CHAR(8),GETDATE()-1,112),'T',NULL, @email)
      367. insert AccountPlay (Account, PlayDate)
      368. select @account, convert(int, convert(char(8), getdate(), 112))
      370. if @@error <> 0
      371. begin
      372. rollback tran
      373. select -1
      374. end
      375. else
      376. begin
      377. commit tran
      378. select 1
      379. end
      380. end
      381. else
      382. begin
      383. select 0
      384. end
      385. GO
      386. /****** Object: StoredProcedure [dbo].[sp_UpdateAccountPassword] Script Date: 10/28/2009 17:27:48 ******/
      387. SET ANSI_NULLS ON
      388. GO
      389. SET QUOTED_IDENTIFIER ON
      390. GO
      391. CREATE PROCEDURE [dbo].[sp_UpdateAccountPassword]
      392. @account varchar(32),
      393. @password varchar(32)
      394. AS
      395. SET NOCOUNT ON
      398. Update ACCOUNT_TBL SET Password = @password Where Account=@account
      399. GO
      400. /****** Object: StoredProcedure [dbo].[usp_ChangePW] Script Date: 10/28/2009 17:27:48 ******/
      401. SET ANSI_NULLS ON
      402. GO
      403. SET QUOTED_IDENTIFIER ON
      404. GO
      405. CREATE proc [dbo].[usp_ChangePW]
      406. @account varchar(32),
      407. @pw varchar(32)
      408. as
      409. set nocount on
      410. set xact_abort on
      412. if exists (select * from ACCOUNT_TBL where account = @account)
      413. begin
      414. declare @hash char(32), @tpw varchar(40)
      415. set @tpw = 'tpgk' + @pw
      417. exec master.dbo.xp_crypt @tpw, @hash output
      419. begin tran
      420. update ACCOUNT_TBL
      421. set [password] = lower(@hash)
      422. where account = @account
      424. if @@error <> 0
      425. begin
      426. rollback tran
      427. select -1
      428. end
      429. else
      430. begin
      431. commit tran
      432. select 1
      433. end
      434. end
      435. else
      436. begin
      437. select 0
      438. end
      439. GO
      440. /****** Object: StoredProcedure [dbo].[LOGIN_RELOAD_STR] Script Date: 10/28/2009 17:27:48 ******/
      441. SET ANSI_NULLS ON
      442. GO
      443. SET QUOTED_IDENTIFIER ON
      444. GO
      445. CREATE PROC [dbo].[LOGIN_RELOAD_STR]
      446. /**********************************************************************************
      447. ***********************************************************************************
      448. ***********************************************************************************
      449. ***********************************************************************************
      450. LOGIN_RELOAD_STR 스토어드
      451. 작성자 : 최석준
      452. 작성일 : 2005.01.24
      453. ex) LOGIN_RELOAD_STR
      455. **********************************************************************************
      456. ***********************************************************************************
      457. ***********************************************************************************
      458. ***********************************************************************************/
      460. AS
      461. set nocount on
      462. SELECT account FROM ACCOUNT_TBL WHERE reload='T'
      463. set nocount off
      465. RETURN
      466. GO
      467. /****** Object: StoredProcedure [dbo].[CREATE_ACCOUNT_STR] Script Date: 10/28/2009 17:27:48 ******/
      468. SET ANSI_NULLS ON
      469. GO
      470. SET QUOTED_IDENTIFIER ON
      471. GO
      472. CREATE PROC [dbo].[CREATE_ACCOUNT_STR]
      473. @iGu CHAR(1) = 'A',
      474. @k INT = 100
      475. AS
      476. DECLARE @i INT,@j INT,@oSeq CHAR(6)
      477. IF @iGu = 'A'
      478. BEGIN
      479. SET @j = 1
      480. SELECT @i = ISNULL(CONVERT(INT,(MAX(account))),0) + 1 FROM ACCOUNT_TBL
      481. SELECT CONVERT(INT,(MAX(account))) + @k FROM ACCOUNT_TBL
      482. WHILE @j < @k + 1
      483. BEGIN
      484. SET @oSeq = RIGHT('000000' + CONVERT(VARCHAR(6),@i),6)
      485. INSERT ACCOUNT_TBL
      486. (account,password,isuse,member,id_no1,id_no2,realname)
      487. VALUES
      488. (@oSeq,@oSeq,'T','A','','','')
      489. INSERT ACCOUNT_TBL_DETAIL
      490. (account,gamecode,tester,m_chLoginAuthority,regdate,BlockTime,EndTime,WebTime,isuse,secession)
      491. VALUES
      492. (@oSeq,'A000','2','F',GETDATE(),CONVERT(CHAR(8),GETDATE()-1,112),CONVERT(CHAR(8),DATEADD(year,6,GETDATE()),112),CONVERT(CHAR(8),GETDATE()-1,112),'T',NULL)
      493. SET @i = @i + 1
      494. SET @j = @j + 1
      495. IF (@j % 100 = 0)
      496. PRINT @oSeq
      497. END
      498. RETURN
      499. END
      500. GO
      501. /****** Object: StoredProcedure [dbo].[usp_og_ChangePassWord] Script Date: 10/28/2009 17:27:48 ******/
      502. SET ANSI_NULLS ON
      503. GO
      504. SET QUOTED_IDENTIFIER ON
      505. GO
      506. CREATE proc [dbo].[usp_og_ChangePassWord]
      507. @account varchar(32),
      508. @password varchar(32)
      509. as
      510. set nocount on
      511. set xact_abort on
      513. if exists (select * from ACCOUNT_TBL where account = @account)
      514. begin
      515. begin tran
      516. Update ACCOUNT_TBL SET Password = @password Where account=@account
      517. if @@error <> 0
      518. begin
      519. rollback tran
      520. select -1
      521. end
      522. else
      523. begin
      524. commit tran
      525. select 1
      526. end
      527. end
      528. else
      529. begin
      530. select 0
      531. end
      532. GO
      533. /****** Object: StoredProcedure [dbo].[LOGINJOIN_STR] Script Date: 10/28/2009 17:27:48 ******/
      534. SET ANSI_NULLS ON
      535. GO
      536. SET QUOTED_IDENTIFIER ON
      537. GO
      538. CREATE PROC [dbo].[LOGINJOIN_STR]
      539. @iGu CHAR(2) = 'A1',
      540. @iaccount VARCHAR(32)
      541. /***********************************************************************************
      542. ***********************************************************************************
      543. ***********************************************************************************
      544. ***********************************************************************************
      546. LOGINJOIN_STR 스토어드
      547. 작성자 : 송현석
      548. 작성일 : 2004.01.30
      549. 수정일 :
      551. ex) LOGINONOFF_STR 'A1','1234'
      553. ***********************************************************************************
      554. ***********************************************************************************
      555. ***********************************************************************************
      556. ***********************************************************************************/
      558. AS
      559. set nocount on
      561. IF @iGu = 'A1' -- ON
      562. BEGIN
      563. UPDATE ACCOUNT_TBL_DETAIL
      564. SET isuse = 'J'
      565. WHERE account = @iaccount
      566. RETURN
      567. END
      569. ELSE
      570. IF @iGu = 'A2' -- OFF
      571. BEGIN
      572. UPDATE ACCOUNT_TBL_DETAIL
      573. SET isuse = 'O'
      574. WHERE account = @iaccount
      575. RETURN
      576. END
      578. ELSE
      579. IF @iGu = 'A3' -- ALL OFF
      580. BEGIN
      581. UPDATE ACCOUNT_TBL_DETAIL
      582. SET isuse = 'O'
      583. RETURN
      584. END
      586. set nocount off
      587. GO
      588. /****** Object: StoredProcedure [dbo].[usp_ChangeEmail] Script Date: 10/28/2009 17:27:48 ******/
      589. SET ANSI_NULLS ON
      590. GO
      591. SET QUOTED_IDENTIFIER ON
      592. GO
      593. CREATE proc [dbo].[usp_ChangeEmail]
      594. @account varchar(32),
      595. @email varchar(100)
      596. as
      597. set nocount on
      598. set xact_abort on
      600. if exists (select * from ACCOUNT_TBL_DETAIL where account = @account)
      601. begin
      602. begin tran
      603. update ACCOUNT_TBL_DETAIL
      604. set email = @email
      605. where account = @account
      607. if @@error <> 0
      608. begin
      609. rollback tran
      610. select -1
      611. end
      612. else
      613. begin
      614. commit tran
      615. select 1
      616. end
      617. end
      618. else
      619. begin
      620. select 0
      621. end
      622. GO
      623. /****** Object: StoredProcedure [dbo].[USP_PCZoneIP_Check] Script Date: 10/28/2009 17:27:48 ******/
      624. SET ANSI_NULLS ON
      625. GO
      626. SET QUOTED_IDENTIFIER ON
      627. GO
      628. /*
      629. declare @o_Grade tinyint
      630. exec dbo.USP_PCZoneIP_Check '218.38.238.131', @o_Grade output
      631. select @o_Grade
      633. exec LOGIN_STR 'chipi', '85158c7b8a7f3113b0f32b70ed936b2c', '127.0.0.0'
      634. */
      635. create proc [dbo].[USP_PCZoneIP_Check]
      636. @i_IPAddress varchar(15)
      637. , @o_Grade tinyint output
      638. as
      639. set nocount on
      640. set transaction isolation level read uncommitted
      642. declare @i_IP1 tinyint
      643. declare @i_IP2 tinyint
      644. declare @i_IP3 tinyint
      645. declare @i_IP4 tinyint
      647. declare @index int
      649. --@i_IP1
      650. set @index = charindex('.', @i_IPAddress)
      651. set @i_IP1 = left(@i_IPAddress, @index-1)
      652. set @i_IPAddress = right(@i_IPAddress, len(@i_IPAddress)-@index)
      654. --@i_IP2
      655. set @index = charindex('.', @i_IPAddress)
      656. set @i_IP2 = left(@i_IPAddress, @index-1)
      657. set @i_IPAddress = right(@i_IPAddress, len(@i_IPAddress)-@index)
      659. --@i_IP3, @i_IP4
      660. set @index = charindex('.', @i_IPAddress)
      661. set @i_IP3 = left(@i_IPAddress, @index-1)
      662. set @i_IP4 = right(@i_IPAddress, len(@i_IPAddress)-@index)
      664. --PCZoneIP_Check
      665. select @o_Grade = b.Grade
      666. from PCZoneIP a
      667. inner join PCZone b
      668. on a.PCZoneID = b.PCZoneID
      669. where IsUse in (1, 9)
      670. and IPFrom1 = @i_IP1
      671. and IPFrom2 = @i_IP2
      672. and IPFrom3 = @i_IP3
      673. and IPFrom4 <= @i_IP4 and IPTo4 >= @i_IP4
      675. select @o_Grade = isnull(@o_Grade, 0)
      676. GO
      677. /****** Object: StoredProcedure [dbo].[LOGIN_STR] Script Date: 10/28/2009 17:27:48 ******/
      678. SET ANSI_NULLS ON
      679. GO
      680. SET QUOTED_IDENTIFIER ON
      681. GO
      682. CREATE PROC [dbo].[LOGIN_STR]
      683. @iaccount VARCHAR(32),
      684. @ipassword char(32)
      685. -- Ver. 14 PCZoneIP
      686. ,@i_IPAddress varchar(15) = '0.0.0.0'
      687. /***********************************************************************************
      688. ***********************************************************************************
      689. ***********************************************************************************
      690. ***********************************************************************************
      694. ACCOUNT_STR 스토어드
      695. 작성자 : 최석준
      696. 작성일 : 2004.01.18
      698. ex) ACCOUNT_STR 'beat','1234'
      699. SELECT * FROM ACCOUNT_TBL_DETAIL WHERE account='aeonsoft'
      701. ***********************************************************************************
      702. ***********************************************************************************
      703. ***********************************************************************************
      704. ***********************************************************************************/
      705. AS
      706. set nocount on
      708. -- Ver 14. PCZoneIP_Check
      709. declare @o_Grade tinyint
      710. exec dbo.USP_PCZoneIP_Check @i_IPAddress, @o_Grade output
      712. IF EXISTS(SELECT a.account FROM ACCOUNT_TBL a,ACCOUNT_TBL_DETAIL b
      713. WHERE a.account = b.account AND a.account = @iaccount ) -- AND gamecode = 'A000')
      714. BEGIN
      716. DECLARE @curDate char(8)
      718. IF EXISTS(SELECT account FROM ACCOUNT_TBL
      719. WHERE account = @iaccount AND password = @ipassword) BEGIN
      721. SELECT @curDate=CONVERT(CHAR(8), getdate(), 112)
      723. SELECT fError=CASE
      724. -- WHEN session<>@isession OR sessionExpireDt<getdate() THEN '91'
      725. WHEN BlockTime>=@curDate THEN '9'
      726. ELSE '0' END,
      727. fText= CASE
      728. -- WHEN session<>@isession OR sessionExpireDt<getdate() THEN 'Session Expired'
      729. WHEN BlockTime>=@curDate THEN 'Block' ELSE 'OK' END,
      730. fCheck=tester,
      731. f18='1'
      732. -- Ver14. PCZoneIP
      733. ,fPCZone = @o_Grade
      734. FROM ACCOUNT_TBL a INNER JOIN ACCOUNT_TBL_DETAIL b ON (a.account=b.account)
      735. WHERE a.account=@iaccount
      736. END
      737. ELSE BEGIN
      738. SELECT fError = '1', fText = 'Wrong Password !!',fCheck ='',f18='1', fPCZone = '0' -- PCZoneIP (, fPCZone = '0' 추가)
      739. END
      740. END
      741. ELSE BEGIN
      742. SELECT fError = '2', fText = 'Account Not Exists !!',fCheck ='',f18='1', fPCZone = '0' -- PCZoneIP (, fPCZone = '0' 추가)
      743. END
      745. RETURN
      747. -- 계정 검사 Rule
      748. -- 1. (fError=2 리턴) 계정있는지 확인. 계정확인시 "gamecode = A000" 만 프리프 회원.
      749. -- 2. (fError=1 리턴) 암호확인.
      750. -- 3. (fError=0 리턴) 사원 및 기자 확인( id_no1가 a0000 )으로 확인.계정.암호만 확인
      751. -- 4. (fError=3 리턴) 블럭타임과, 과금타임 확인.
      752. -- 5. (fError=4 리턴) 실명확인.
      753. -- 6. (fError=5 리턴) 12세 이상인지 확인. 이하이면 "프리프는 12세 이상 이용가 이므로 ]
      754. -- 게임접속을 할수 없습니다." 라고 알림.
      755. -- 7. (fError=6 리턴) 부모동의서가 없는 애덜 확인 tester = 0 이면 "14세 미만 가입자 분들은
      756. -- 부모등의서를 보내주셔야 게임 접속이 가능합니다"라고 알림.
      757. -- 8. (fError=0 리턴) 위의 예말고는 정상 사용자로 인정.
      758. set nocount off
      759. GO
      760. /****** Object: Default [DF_CashHistory_regdate] Script Date: 10/28/2009 17:14:39 ******/
      761. ALTER TABLE [dbo].[CashHistory] ADD CONSTRAINT [DF_CashHistory_regdate] DEFAULT (getdate()) FOR [regdate]
      762. GO
      763. /****** Object: Default [DF_ACCOUNT_TBL_cash] Script Date: 10/28/2009 17:14:40 ******/
      764. ALTER TABLE [dbo].[ACCOUNT_TBL] ADD CONSTRAINT [DF_ACCOUNT_TBL_cash] DEFAULT ((0)) FOR [cash]
      765. GO
      766. /****** Object: Default [DF_ACCOUNT_DETAIL_email] Script Date: 10/28/2009 17:14:40 ******/
      767. ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF_ACCOUNT_DETAIL_email] DEFAULT ('') FOR [email]
      768. GO
      769. /****** Object: Default [DF_PCZone_Grade] Script Date: 10/28/2009 17:14:40 ******/
      770. ALTER TABLE [dbo].[PCZone] ADD CONSTRAINT [DF_PCZone_Grade] DEFAULT ((1)) FOR [Grade]
      771. GO
      772. /****** Object: Default [DF_PCZone_Account] Script Date: 10/28/2009 17:14:40 ******/
      773. ALTER TABLE [dbo].[PCZone] ADD CONSTRAINT [DF_PCZone_Account] DEFAULT ('') FOR [Account]
      774. GO
      775. /****** Object: Default [DF_PCZone_RegDate] Script Date: 10/28/2009 17:14:40 ******/
      776. ALTER TABLE [dbo].[PCZone] ADD CONSTRAINT [DF_PCZone_RegDate] DEFAULT (getdate()) FOR [RegDate]
      777. GO
      778. /****** Object: Default [DF_AccountPlay_Account] Script Date: 10/28/2009 17:27:48 ******/
      779. ALTER TABLE [dbo].[AccountPlay] ADD CONSTRAINT [DF_AccountPlay_Account] DEFAULT ('') FOR [Account]
      780. GO
      781. /****** Object: Default [DF_AccountPlay_PlayDate] Script Date: 10/28/2009 17:27:48 ******/
      782. ALTER TABLE [dbo].[AccountPlay] ADD CONSTRAINT [DF_AccountPlay_PlayDate] DEFAULT ('') FOR [PlayDate]
      783. GO
      784. /****** Object: Default [DF_AccountPlay_PlayTime] Script Date: 10/28/2009 17:27:48 ******/
      785. ALTER TABLE [dbo].[AccountPlay] ADD CONSTRAINT [DF_AccountPlay_PlayTime] DEFAULT ((0)) FOR [PlayTime]
      786. GO
      787. /****** Object: Default [DF_PCZoneIP_IsUse] Script Date: 10/28/2009 17:27:48 ******/
      788. ALTER TABLE [dbo].[PCZoneIP] ADD CONSTRAINT [DF_PCZoneIP_IsUse] DEFAULT ((0)) FOR [IsUse]
      789. GO
      790. /****** Object: Default [DF_PCZoneIP_RegDate] Script Date: 10/28/2009 17:27:48 ******/
      791. ALTER TABLE [dbo].[PCZoneIP] ADD CONSTRAINT [DF_PCZoneIP_RegDate] DEFAULT (getdate()) FOR [RegDate]
      792. GO
      793. /****** Object: ForeignKey [FK_iCafeIP_iCafeInfo1] Script Date: 10/28/2009 17:27:48 ******/
      794. ALTER TABLE [dbo].[PCZoneIP] WITH CHECK ADD CONSTRAINT [FK_iCafeIP_iCafeInfo1] FOREIGN KEY([PCZoneID])
      795. REFERENCES [dbo].[PCZone] ([PCZoneID])
      796. GO
      797. ALTER TABLE [dbo].[PCZoneIP] CHECK CONSTRAINT [FK_iCafeIP_iCafeInfo1]
      798. GO
      Alles anzeigen

    • [COLOR="Pink"]Hat sich geregelt, danke an dieser stelle an Cletite und Psych0tik


      Edit/
      Noch ein Problem, hab jetzt schon 3 .rars runtergeladen bei denen mir versprochen wurde das diese Files komplett sind jedoch nicht waren.
      .inis, Script Order und vieles mehr fehlte.
      Falls jemand einen KOMPLETTEN v14 Files ordner hochladen könnte, und ihn hier teilen würde wäre ich sehr drüber erfreut      [/COLOR]