[SHARE] Shaiya Server with Video Guide

Quote:

---

Originally Posted by lajt5042870

Hi. i managed to solve it, thank you. I do not understand it the reg script onto what okay? OMG_GameWeb is not attached database. One more thing, gm exists 100% linking ? ty

---

100% GM Link Lapis guide:

Lapis List:

Code:

---

'Craft Lapis LV1' = 1
'Craft Lapis LV2' = 2
'Craft Lapis LV3' = 3
'Craft Lapis LV4' = 4
'Craft Lapis LV5' = 5
'Craft Lapis LV6' = 6
'Max Craft Lapis' = 7
'Safe Lapis LV1' = 8
'Safe Lapis LV2' = 9
'Safe Lapis LV3' = 10
'Safe Lapis LV4' = 11
'Safe Lapis LV5' = 12
'Safe Lapis LV6' = 13
'Max Safe Lapis' = 14
'Mystic Lapis LV1' = 15
'Mystic Lapis LV2' = 16
'Mystic Lapis LV3' = 17
'Mystic Lapis LV4' = 18
'Mystic Lapis LV5' = 19
'Mystic Lapis LV6' = 20
'Max Mystic Lapis' = 21
'Wise Lapis LV1' = 22
'Wise Lapis LV2' = 23
'Wise Lapis LV3' = 24
'Wise Lapis LV4' = 25
'Wise Lapis LV5' = 26
'Wise Lapis LV6' = 27
'Max Wise Lapis' = 28
'Shrewd Lapis LV1' = 29
'Shrewd Lapis LV2' = 30
'Shrewd Lapis LV3' = 31
'Shrewd Lapis LV4' = 32
'Shrewd Lapis LV5' = 33
'Shrewd Lapis LV6' = 34
'Max Shrewd Lapis' = 35
'Fortune Lapis LV1' = 36
'Fortune Lapis LV2' = 37
'Fortune Lapis LV3' = 38
'Fortune Lapis LV4' = 39
'Fortune Lapis LV5' = 40
'Fortune Lapis LV6' = 41
'Max Fortune Lapis' = 42
'Life Lapis LV1' = 43
'Life Lapis LV2' = 44
'Life Lapis LV3' = 45
'Life Lapis LV4' = 46
'Life Lapis LV5' = 47
'Life Lapis LV6' = 48
'Max Life Lapis' = 49
'Vigor Lapis LV1' = 50
'Vigor Lapis LV2' = 51
'Vigor Lapis LV3' = 52
'Vigor Lapis LV4' = 53
'Vigor Lapis LV5' = 54
'Vigor Lapis LV6' = 55
'Max Vigor Lapis' = 56
'Mental Lapis LV1' = 57
'Mental Lapis LV2' = 58
'Mental Lapis LV3' = 59
'Mental Lapis LV4' = 60
'Mental Lapis LV5' = 61
'Mental Lapis LV6' = 62
'Max Mental Lapis' = 63
'Flash Lapis Lv1' = 64
'Flash Lapis Lv2' = 65
'Max Flash Lapis' = 66
'Blaze-burn Lapis' = 67
'Water-fear Lapis' = 68
'Earth-shock Lapis' = 69
'Wind-gale Lapis' = 70
'Endure Lapis LV1' = 71
'Endure Lapis LV2' = 72
'Endure Lapis LV3' = 73
'Endure Lapis LV4' = 74
'Endure Lapis LV5' = 75
'Endure Lapis LV6' = 76
'Max Endure Lapis' = 77
'Assault Lapis LV3' = 78
'Assault Lapis LV4' = 79
'Assault Lapis LV5' = 80
'Assault Lapis LV6' = 81
'Max Assault Lapis' = 82
'Assault LapisLV1' = 83
'Assault LapisLV2' = 84
'Deceive Lapis LV3' = 85
'Deceive Lapis LV4' = 86
'Deceive Lapis LV5' = 87
'Deceive Lapis LV6' = 88
'Max  Deceive Lapis' = 89
'Deceive LapisLV1' = 90
'Deceive LapisLV2' = 91
'Forbid Lapis LV3' = 92
'Forbid Lapis LV4' = 93
'Forbid Lapis LV5' = 94
'Forbid Lapis LV6' = 95
'Max Forbid Lapis' = 96
'Forbid LapisLV1' = 97
'Forbid LapisLV2' = 98
'Wit Lapis LV1' = 99
'Wit Lapis LV2' = 100
'Wit Lapis LV3' = 101
'Wit Lapis LV4' = 102
'Wit Lapis LV5' = 103
'Wit Lapis LV6' = 104
'Max Wit Lapis' = 105
'Sonic Lapis Lv1' = 106
'Sonic Lapis Lv2' = 107
'Horizon Lapis Lv1' = 108
'Horizon Lapis Lv2' = 109
'Sleep Lapis' = 110
'Anti-Sleep Lapis' = 111
'Stun Lapis' = 112
'Anti-Stun Lapis' = 113
'Silence Lapis' = 114
'Anti-Silence Lapis' = 115
'Darkness Lapis' = 116
'Anti-Darkness Lapis' = 117
'Pause Lapis' = 118
'Anti-Pause Lapis' = 119
'Slow Lapis' = 120
'Anti-Slow Lapis' = 121
'Doom Lapis' = 122
'Anti-Doom Lapis' = 123
'Fear Lapis' = 124
'Anti-Fear Lapis' = 125
'Poison Lapis' = 126
'Anti-Poison Lapis' = 127
'Illness Lapis' = 128
'Anti-Illness Lapis' = 129
'Delusion Lapis' = 130
'Anti-Delusion Lapis' = 131
'Bad Luck Lapis' = 132
'Anti Bad Luck Lapis' = 133
'Dull Lapis' = 134
'Anti Dull Lapis' = 135
'Dying Lapis' = 136
'Anti-Dying Lapis' = 137
'Death Lapis' = 138
'Anti-Death Lapis' = 139
'Perfect Lapis LV1' = 140
'Mail Lapis LV1' = 141
'Angel Lapis LV1' = 142
'Archon Lapis' = 144
'Spell Lapis' = 145
'Blaze-light Lapis' = 146
'Water-light Lapis' = 147
'Earth-panic Lapis' = 148
'Wind-scroll Lapis' = 149
'Paint Lapis Lv6' = 151
'Freezing Lapis Lv6' = 152
'Blindside Lapis Lv6' = 153
'Silent Lapis Lv6' = 154
'Crawl Lapis Lv6' = 155
'Panic Lapis Lv6' = 156
'Curse Lapis Lv6' = 157
'Slowmo Lapis Lv6' = 158
'Toxin Lapis Lv6' = 159
'Disease Lapis Lv6' = 160
'Confusion Lapis Lv6' = 161
'Jinx Lapis Lv6' = 162
'Slumber Lapis Lv6' = 163
'Test Lapis1' = 181
'Test Lapis2' = 182
'Test Lapis3' = 183
'Test Lapis4' = 184
'Test Lapis5' = 185
'Test Lapis6' = 186
'Test Lapis7' = 187
'Test Lapis8' = 188
'Test Lapis9' = 189
'Rasyo Lapis' = 191
'Rasio Lapis' = 192
'Decd Lapis' = 193
'Decdsy Lapis' = 194
'Act Lapis' = 195
'Loact Lapis' = 196
'Inter Lapis' = 197
'Interser Lapis' = 198
'Adi Lapis' = 199
'Adio Lapis' = 200
'Roser Lapis' = 201
'Rosers Lapis' = 202
'Dual Craft Lapis Lv1' = 203
'Dual Craft Lapis Lv2' = 204
'Dual Craft Lapis Lv3' = 205
'Dual Craft Lapis Lv4' = 206
'Dual Shrewd LapisLv1' = 207
'Dual Shrewd Lapis Lv2' = 208
'Dual Shrewd Lapis Lv3' = 209
'Dual Shrewd Lapis Lv4' = 210
'Dual Safe Lapis Lv1' = 211
'Dual Safe Lapis Lv2' = 212
'Dual Safe Lapis Lv3' = 213
'Dual Safe Lapis Lv4' = 214
'Dual Mystic Lapis Lv1' = 215
'Dual Mystic Lapis Lv2' = 216
'Dual Mystic Lapis Lv3' = 217
'Dual Mystic Lapis Lv4' = 218
'Dual Wise Lapis Lv1' = 219
'Dual Wise Lapis Lv2' = 220
'Dual Wise Lapis Lv3' = 221
'Dual Wise Lapis Lv4' = 222
'Dual Fortune Lapis Lv1' = 223
'Dual Fortune Lapis Lv2' = 224
'Dual Fortune Lapis Lv3' = 225
'Dual Fortune Lapis Lv4' = 226
'STR Helmet Lapis' = 227
'DEX Helmet Lapis' = 228
'REC Helmet Lapis' = 229
'INT Helmet Lapis' = 230
'WIS Helmet Lapis' = 231
'LUC Helmet Lapis' = 232
'Heartforce Lapis' = 246
'Bullforce Lapis' = 247
'Wizardforce Lapis' = 248
'Perfect Lapis Lv3' = 251

---

Basically you open : PS_GameData > CharItems.dbo

Best way is to query the character ID, can be found in CHAR.dbo
Find the item and if lets lets say a pair of noble boots, (1 socket/slot)

We are going to make some sonics(lvl2) for this example, in Gem1 you would put the number of the lapis (can be found above) 'Sonic Lapis Lv2' = 107

So quickly once more over we go: SQL Server > PS_GameData > CharItems.dbo and CHAR.dbo (Find the character, with CharID) Find the ITEM (Use the Type/TypeID to find) and in Gem1 put 107

I'm not sure if there is a linking hammer or something what gives you a deffinate link.. havn't found anything yet. With GM Links you can put any lapis in any item so you could put a goddess sword with 6 "Max Craft Lapis" in it..

good work ty YGM:)

problem with the monsters they will not attack, someone has the solution?

Help please! All accounts are set up as ADM. This after typing the command / adminopen.
And also, if I create an account, it can be accessed by any password you type.

Sorry for bad English.

my server with this problem in the login and password, I put my login and
enter it with any password

Sorry for bad English. :)

The lazy people. All answers already are given earlier.

Quote:

---

Originally Posted by Twilight

My progress on correction Ep4. Passive skills are corrected. Who that has received greater? The Others only are engaged Ep3... So is easier for you?

---

Hey, I have been unable to get Ep4 skills working. I inserted all the records into the DB, and it looks like the Table structure has not changed at all, but they did not work. Do some changes need to be made to ps_game.exe?

TO EVERYONE:
I think we r going to hit a brick wall unless we:
a) Reverse Engineer the "ps_game.exe" and create our our Game Server executable. Disconnect created a packet sniffer prior to packets being encrypted. If we work out all the packet data, we can program our own "ps_game.exe". Then the Server software we use can be a little more legitimate. :P
-OR-
b) The Original Poster of thread posts the new Ep4 Software. But somehow I don't think that's going to happen anytime soon.

I would like to gather a team of all the very experienced hackers to achieve these goals. Some of the private Servers have been keeping there info secret. I suggest to them this:

Let's all work TOGETHER until we can get the Server software fully compatible to Ep4. If we don't we will all remain in the shadow of the official versions, and we will only attract a few hardcore fans over to our Servers by luring them with insane XP and other bonuses.

I propose we create an IRC Channel so we can all discuss with each other our goals and objectives, and how we will go about this cumbersome task. Need I remind you all that you have to be experienced programmers if you aren't don't bother joining in the hopes that we will help you set-up your own Server because you will only slow us down and hinder our progress.

irc://freenode/gamehackers

ep4 :D
good luck with your job with ep4 :)

i'm working at the launcher right now :)

hey any one have a game.exe with gamegaurd
for the englis client
or the chinese gameguard.des file?

help my problem

my server with this problem in the login and password, I put my login and
enter it with any password

Sorry for bad English. :)

I have followed all the isntructions in this forum, but still can not get the services to start. All will start with exception of Service and all will crash in a few minutes.

Code:

---

PS_DBAGENT_charsave
//PS_DBAGENT__charsave log start (DBAgent01)
//PS_DBAGENT__charsave log start (DBAgent01)

---

Code:

---

PS_DBAGENT_system.log
2009-05-28 18:19:54 PS_DBAGENT__system log start (DBAgent01)
2009-05-28 18:20:11 DB gamedata connect error
2009-05-28 18:20:11 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-28 18:20:11 DBKillCountSave db alloc failed
2009-05-28 18:20:11 SAVE kill count ERROR
2009-05-28 18:20:11 CKeepObeliskMgr::DBSave db alloc failed
2009-05-28 18:20:11 SAVE g_KeepObeliskMgr ERROR
2009-05-28 18:20:11 GuildMgrSave::DBSave db alloc failed
2009-05-28 18:20:11 SAVE g_GuildMgrSave ERROR
2009-05-28 18:20:11 PS_DBAGENT__system log end (DBAgent01)
2009-05-28 18:20:11 3 1 SService::ServiceCtrlDispatcher(): service shutdown

---

Code:

---

PS_GAME_systemlog
2009-05-28 18:19:57 PS_GAME__system log start (Game01)
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/sorp1
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/croco1
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/croco2
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/Troll1
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/Spink1
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/GoldenPig
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/Sorp3
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/SorpNamed1
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/SorpNamed2
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/Sorp2
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/CrocoNamed1
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/CrocoNamed2
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/CrocoNamed3
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/OrcNamed1
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/OrcNamed2
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/OrcNamed3
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/TrollNamed1
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/Deinos
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/Parridalis
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/Alcarian
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/ZinAlcaria
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/Belizabeth
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/Kirhiross
2009-05-28 18:19:58 Loaded Behavior In Factory : data/ai/CrypticOne
2009-05-28 18:20:15 DB gamedef connect error
2009-05-28 18:20:15 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-28 18:20:15 Call save all waiting...
2009-05-28 18:20:15 Call save all failed dbagent disconnected(user count = 0)...
2009-05-28 18:20:15 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0
2009-05-28 18:20:15 Save MobID=1317829
2009-05-28 18:20:15 PS_GAME__system log end (Game01)
2009-05-28 18:20:15 3 1 SService::ServiceCtrlDispatcher(): service shutdown

---

Code:

---

PS_GAMELOG_system.log
2009-05-28 18:19:52 PS_GAMELOG__system log start (GameLog01)
2009-05-28 18:20:09 DB gamelog connect error
2009-05-28 18:20:09 init db error
2009-05-28 18:20:09 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-28 18:20:09 PS_GAMELOG__system log end (GameLog01)
2009-05-28 18:20:09 3 1 SService::ServiceCtrlDispatcher(): service shutdown

---

Code:

---

PS_LOGIN_system.log
2009-05-28 18:19:47 PS_LOGIN__system log start (Login01)
2009-05-28 18:20:04 DB userdata connect error, id=Shaiya, pass=sywballen
2009-05-28 18:20:04 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-28 18:20:04 PS_LOGIN__system log end (Login01)
2009-05-28 18:20:04 3 1 SService::ServiceCtrlDispatcher(): service shutdown

---

Code:

---

PS_SESSION_system.log
2009-05-28 18:19:49 PS_SESSION__system log start (Session)
2009-05-28 18:19:50 userlog connect failed
2009-05-28 18:19:50 initserver() failed
2009-05-28 18:19:50 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-28 18:19:50 PS_SESSION__system log end (Session)
2009-05-28 18:19:50 3 1 SService::ServiceCtrlDispatcher(): service shutdown

---

Code:

---

PS_USERLOG_system.log
2009-05-28 18:19:47 PS_USERLOG__system log start (UserLog)
2009-05-28 18:20:04 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserLog, User=Shaiya, Pass=sywballen
2009-05-28 18:20:04 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2009-05-28 18:20:04 PS_USERLOG__system log end (UserLog)
2009-05-28 18:20:04 3 1 SService::ServiceCtrlDispatcher(): service shutdown

---

This is running on Win XP Pro SP3 with SQL Server 2000 SP4.

Please let me know if you have any ideas.

MMachor, it is not connecting to the Game Data Database. Check that you have run the linked Game Server query and you can connect fine. Also that the MS DTC Service is running.

db pass: sywballen? sywballen default pass. Replace the password and update.

Thanks for the help. I've not got the server up and running. Found it to be a combination of the password being stored wrong and also the local ip for the databases needed to be put to the PC Name.

ok all good i can get tho this steep http://i527.photobucket.com/albums/c...Tavoserver.jpg

But when i choose my server And click "OK" it discconects and send me this error
http://i527.photobucket.com/albums/c...hack/Error.jpg

Already been cheking some other post and still cant find the solution, maybe u knwo whats happening 0_0