قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
أدوات الموضوع | انواع عرض الموضوع |
18-08-2014, 01:14 AM | #1 | ||||||||||
|
و يا ريت فيفر |
||||||||||
|
18-08-2014, 01:37 AM | #2 | ||||||||||
|
افتح ملفات ini ملف اسمو Srshard اتاكد ان بيانت sql موجود فيه صح ورح C >input>wwwort >DbConnect اتاكد ان ملف dbconnect بيانات sql مكتوب فيه صح و اتاكد من odbc |
||||||||||
|
18-08-2014, 02:17 AM | #3 | ||||||||||
|
اعمل كلين و اتاكد من ال DbConnect الصيغة الصحيحة كود PHP:
|
||||||||||
|
18-08-2014, 04:58 AM | #4 | ||||||||||
|
والله كولو صح والله |
||||||||||
|
18-08-2014, 05:05 AM | #5 | ||||||||||
|
هيرو تعالا فيفر او فيس مستنيك |
||||||||||
|
18-08-2014, 05:05 AM | #6 | ||||||||||
|
بص يا باشا مشكلتك ديه سهلة بس انت صحصح فى مشكلة فى account db يعنى account db مش متعرف و مش محطوط صح تمام افتح Ini و اتاكد من كل حاجة ممكن يكون فى space عملة مشكلة و هات صورة لى SQL لى db account وصورة من db connect وصورة من ini srGlobalService SrShard هنا المشكلة 95 % من ini |
||||||||||
|
18-08-2014, 05:13 AM | #7 | ||||||||||
|
ما تيجى فيفر :S |
||||||||||
|
18-08-2014, 05:17 AM | #8 | ||||||||||
|
بوص اهوم |
||||||||||
|
18-08-2014, 05:17 AM | #9 | ||||||||||
|
|
||||||||||
|
18-08-2014, 05:18 AM | #10 | ||||||||||
|
|
||||||||||
|
18-08-2014, 05:36 AM | #11 | ||||||||||
|
حضرتك الــ DBConnect غلط !! خد لي hero قالك عليها و حطها و عدل و جرب !! |
||||||||||
|
18-08-2014, 05:45 AM | #12 | ||||||||||
|
صورة بعد التعديل و بردو نفس الكلام |
||||||||||
|
18-08-2014, 05:48 AM | #13 | ||||||||||
|
طيب اعمل كلين و اتاكد من ال odbc |
||||||||||
|
18-08-2014, 05:57 AM | #14 | ||||||||||
|
انا هتجنن كولو با الصور اهو |
||||||||||
|
18-08-2014, 12:38 PM | #15 | ||||||||||
|
اولا شوف ال DBconnect و ديه الصيغة الصحيحه كود:
<% Dim DBConnA, strConnectA Set DBConnA = Server.CreateObject("ADODB.Connection") strConnectA = "Provider=SQLOLEDB;Data Source=MEMO-PC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=123456789;" DBConnA.Open strConnectA %> SRO_VT_ACCOUNT كود:
USE [SRO_VT_ACCOUNT] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SK_gamebang_ip]( [nID] [smallint] NOT NULL, [ip] [int] NOT NULL, [capacity] [smallint] NOT NULL ) ON [PRIMARY] GO كود:
USE [SRO_VT_ACCOUNT] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO DROP TABLE [dbo].[_PrivilegedIP] GO CREATE TABLE [dbo].[_PrivilegedIP]( [IP1] [tinyint] NOT NULL, [IP2] [tinyint] NOT NULL, [IP3] [tinyint] NOT NULL, [IP4] [tinyint] NOT NULL, [IP5] [tinyint] NOT NULL, [IP6] [tinyint] NOT NULL, [IP7] [tinyint] NOT NULL, [IP8] [tinyint] NOT NULL ) ON [PRIMARY] GO كود:
USE [SRO_VT_ACCOUNT] GO TRUNCATE TABLE [dbo].[__SiegeFortressStatus__] TRUNCATE TABLE [dbo].[_BlockedUser] TRUNCATE TABLE [dbo].[_CasGMChatLog] TRUNCATE TABLE [dbo].[_Notice] TRUNCATE TABLE [dbo].[_Punishment] TRUNCATE TABLE [dbo].[_ServiceManagerLog] TRUNCATE TABLE [dbo].[_ShardCurrentUser] TRUNCATE TABLE [dbo].[_SMCLog] TRUNCATE TABLE [dbo].[QuaySoEpoint] TRUNCATE TABLE [dbo].[SK_CharRenameLog] TRUNCATE TABLE [dbo].[SK_DownLevelLog] TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog] TRUNCATE TABLE [dbo].[SK_ItemSaleLog] TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog] TRUNCATE TABLE [dbo].[SK_PK_UpdateLog] TRUNCATE TABLE [dbo].[SK_ResetSkillLog] TRUNCATE TABLE [dbo].[SK_Silk] TRUNCATE TABLE [dbo].[SK_SilkBuyList] TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS] TRUNCATE TABLE [dbo].[SR_ShardCharNames] TRUNCATE TABLE [dbo].[TB_Net2e] TRUNCATE TABLE [dbo].[TB_Net2e_Bak] TRUNCATE TABLE [dbo].[tb_partnerInfo] TRUNCATE TABLE [dbo].[tb_paygate_trans] TRUNCATE TABLE [dbo].[TB_User] TRUNCATE TABLE [dbo].[TB_User_Bak] TRUNCATE TABLE [dbo].[Test_HN] UPDATE [dbo].[_ShardService] SET ShardID = '64' كود:
USE [SRO_VT_SHARD] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[_ExistsServiceOffRentItem] as if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) ) begin return -1 end GO كود:
USE [SRO_VT_SHARD] GO TRUNCATE TABLE [dbo].[_Chest] TRUNCATE TABLE [dbo].[_ChestInfo] TRUNCATE TABLE [dbo].[_User] TRUNCATE TABLE [dbo].[_OpenMarket] DELETE FROM [dbo].[_AccountJID] TRUNCATE TABLE [dbo].[_GuildWar] TRUNCATE TABLE [dbo].[_GuildMember] TRUNCATE TABLE [dbo].[_GuildChest] TRUNCATE TABLE [dbo].[_SiegeFortressStruct] TRUNCATE TABLE [dbo].[_SiegeFortressObject] TRUNCATE TABLE [dbo].[_SiegeFortressItemForge] DELETE FROM [dbo].[_SiegeFortress] INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (1) INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (3) INSERT INTO [dbo].[_SiegeFortress](FortressID) VALUES (6) UPDATE [dbo].[_AlliedClans] SET Ally1 = '0', Ally2 = '0', Ally3 = '0', Ally4 = '0', Ally5 = '0', Ally6 = '0', Ally7 = '0', Ally8 = '0' DELETE FROM [dbo].[_Guild] WHERE ID > 0 DELETE FROM [dbo].[_AlliedClans] WHERE ID > 0 TRUNCATE TABLE [dbo].[_InventoryForAvatar] TRUNCATE TABLE [dbo].[_TrainingCampSubMentorHonorPoint] TRUNCATE TABLE [dbo].[_BlockedWhisperers] TRUNCATE TABLE [dbo].[_TrainingCampMember] TRUNCATE TABLE [dbo].[_CharTrijobSafeTrade] DELETE FROM [dbo].[_CharTrijob] WHERE CharID > 0 TRUNCATE TABLE [dbo].[_TimedJob] TRUNCATE TABLE [dbo].[_StaticAvatar] TRUNCATE TABLE [dbo].[_Inventory] TRUNCATE TABLE [dbo].[_Memo] TRUNCATE TABLE [dbo].[_FleaMarketNetwork] TRUNCATE TABLE [dbo].[_Friend] TRUNCATE TABLE [dbo].[_CharSkillMastery] TRUNCATE TABLE [dbo].[_CharSkill] TRUNCATE TABLE [dbo].[_InvCOS] DELETE FROM [dbo].[_CharCOS] WHERE ID > 0 DELETE FROM [dbo].[_Char] WHERE CharID > 0 TRUNCATE TABLE [dbo].[_CharCollectionBook] TRUNCATE TABLE [dbo].[_CharInstanceWorldData] TRUNCATE TABLE [dbo].[_CharNameList] TRUNCATE TABLE [dbo].[_CharNickNameList] TRUNCATE TABLE [dbo].[_CharQuest] TRUNCATE TABLE [dbo].[_ClientConfig] TRUNCATE TABLE [dbo].[_DeletedChar] TRUNCATE TABLE [dbo].[_GPHistory] TRUNCATE TABLE [dbo].[_InventoryForLinkedStorage] TRUNCATE TABLE [dbo].[_ItemPool] DELETE FROM [dbo].[_Items] WHERE ID64 > 0 TRUNCATE TABLE [dbo].[_Skill_BaoHiem_TNET] TRUNCATE TABLE [dbo].[_TimedJobForPet] TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus] TRUNCATE TABLE [dbo].[_TrainingCampHonorRank] INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49) INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50) EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK] DELETE FROM [dbo].[_TrainingCamp] TRUNCATE TABLE [dbo].[Tab_RefRanking_HunterContribution] TRUNCATE TABLE [dbo].[Tab_RefRanking_RobberContribution] TRUNCATE TABLE [dbo].[Tab_RefRanking_TraderContribution] كود:
USE [SRO_VT_LOG] GO TRUNCATE TABLE [dbo].[_LogCashItem] TRUNCATE TABLE [dbo].[_LogEventChar] TRUNCATE TABLE [dbo].[_LogEventItem] TRUNCATE TABLE [dbo].[_LogEventSiegeFortress] TRUNCATE TABLE [dbo].[_LogSchedule] TRUNCATE TABLE [dbo].[_LogServerEvent] |
||||||||||
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
بـعيدا عن الرفـاهــية! شاهـد سيــارات زعمـاء العــالم مــن فخـر صناعــة بلادهــم | Mr.Android | بـعـيـدآ عـن سـيـلـك رود | 5 | 08-11-2014 01:14 AM |
وادي آلغي , وادي الويل و وادي سقر .. ماذا تعرف عنهم ..! | shihap | القـسـم الإسـلامـى الـعـام | 6 | 15-10-2012 05:19 PM |
شيخ يقول إلهام شاهين : كم واحد قبلك و كم واحد حضنك وكم واحد إعتلاكي’ في أعمالك الفنية | MịηaTσ | بـعـيـدآ عـن سـيـلـك رود | 47 | 28-08-2012 03:41 PM |
ادخل و قول رايك مين احسن واحد بيلعب PVP ومين اكتر واحد نووووب في ال pvp | _LOVELY_BOY_ | Feronia | 18 | 19-06-2011 11:19 PM |
يا شباب كل واحد يدخل يقول انهى اجدع واحد قبله فى اللعبة | cccccc132 | قسم المواضيع المكررة و المخالفة | 20 | 10-04-2009 01:47 AM |