[Share] EP4 ServerFiles Unrestricted CFG

Help Login Error For Agent.exe


DB:{call user_verify('SoraMaster','EEDAA69B5E6967930C8','192.168.0.6',0,0,'','12',?)}
DB:42000, NativeError:8144, [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function user_verify has too many arguments specified.

Quote:

---

Originally Posted by IsamaII

Help Login Error For Agent.exe


DB:{call user_verify('SoraMaster','EEDAA69B5E6967930C8','192.168.0.6',0,0,'','12',?)}
DB:42000, NativeError:8144, [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function user_verify has too many arguments specified.

---

what you think i'm trying to do now ?
did you read all post below ?

Quote:

---

Originally Posted by magenik

There an example of all New stored procedure and table requested by Agent server

our actual DB is 50% build with those info
actually i already did 85% of build new DB but it's take me time
and as you know time is money in our world lol

Code:

---

SELECT %s FROM PetInfo where (PetNum=%d)
SELECT %s FROM ChaInfo where (ChaNum=%d)
{call daum_user_verify('%s','%s','%s','%s','%s',%d,%d,?)}
{call excite_user_verify('%s','%s',%d,%d,?)}
{call user_verify('%s','%s','%s',%d,%d,'%s','%s',?)}
{call thai_user_verify('%s','%s','%s',%d,%d,?)}
{call daum_user_passcheck('%s','%s',?)}
{call terra_user_passcheck('%s','%s',?)}
 
{call gsp_user_verify('%s','%s',%d,%d,?)}
SELECT UserID, UserIP, LoginDate FROM UserTemp WHERE GUID = '%s'
 
call terra_user_verify('%s','X','X','X','%s',%d,%d,?)}
SELECT LoginID FROM TempUser WHERE TKeyUser = '%s'
{call sp_LogItemRandom_Insert(%d,%d,%d,%d,%d,%d,%I64d,%d,%d,%d,%d,%d,%d,%d,%d,?)}
{call sp_LogPetAction_Insert(%d,%d,%d,%d,%d,?)}
{call sp_LogAction_Insert(%d,%d,%d,%d,%d,%d,%d,%d)}
INSERT INTO LogAppeal (SGNum, ChaNum, ApNote) VALUES (%d, %d)
{call InsertLogHackProgram(%d,%d,%d,%d,%d,'%s',?)}
{call sp_LogSms_Insert(%d,'',%d,'%s','%s',?)}
{call UpdateChaFriendSms(%d,'%s',?)}
 
CreatePet
{call sp_InsertPet('%s',%d,%d,%d,%d,%d,%d,%d,%d,?)}
 
ExchangePet
{call sp_UpdatePetChaNum(%d,%d,?)}
 
SetPetColor
{call sp_UpdatePetColor(%d,%d,?)}
 
SetPetStyle
{call sp_UpdatePetStyle(%d,%d,?)}
 
SetPetFull
{call sp_UpdatePetFull(%d,%d,?)}
 
DeletePet
{call sp_DeletePet(%d,?)}
 
SetPetInven
{call sp_UpdatePetInven(%d,%d,%d,%d,%d,%d,%d,?)}
 
SetPetSkill
{call sp_GetPetFull(%u,?)}
 
RestorePet
{call sp_RestorePet(%u,%d,?)}
 
RenamePet
{call sp_RenamePet(%d,'%s',?)}
 
szPetName==NULL
 
SELECT PetName, PetChaNum, PetType, PetMID, PetSID, PetCardMID, PetCardSID, PetStyle, PetColor, PetFull FROM PetInfo WHERE PetNum=%u
 
And PetChaNum=%u
 
GetPet
pPet==NULL
 
UPDATE PetInfo SET PetInfo.PetPutOnItems=? WHERE (PetNum=...)
 
PetInfo.PetPutOnItems
 
GetPetInven
SELECT PetInvenMID, PetInvenSID, PetInvenAvailable  FROM PetInven WHERE PetNum=%u AND PetInvenType=%d ORDER BY PetInvenNum
 
GetPetSkill
SELECT PetNum, PetName, PetType, PetCardMID, PetCardSID From PetInfo Where PetChaNum=%d And PetDeleted=1
 
UPDATE ChaInfo SET ChaStartMap=%d, ChaStartGate=%d, ChaPosX=%f, ChaPosY=%f, ChaPosZ=%f, ChaSaveMap=%d, ChaSavePosX=%f, ChaSavePosY=%f,
 
ChaSavePosZ=%f, ChaReturnMap=%d, ChaReturnPosX=%f, ChaReturnPosY=%f, ChaReturnPosZ=%f WHERE ChaNum=%u
 
UPDATE ChaInfo SET ChaInfo.ChaQuest=? WHERE (ChaNum=%u)
 
UPDATE ChaInfo SET ChaInfo.ChaPutOnItems=? WHERE (ChaNum=%u)
 
UPDATE ChaInfo SET ChaInfo.ChaActionSlot=? WHERE (ChaNum=%u)
 
UPDATE ChaInfo SET ChaInfo.ChaSkillSlot=? WHERE (ChaNum=%u)
 
UPDATE ChaInfo SET ChaBright=%d, ChaLevel=%u, ChaMoney=%I64d, ChaDex=%u, ChaIntel=%u, ChaSchool=%u, ChaHair=%u, ChaFace=%u,
 
ChaLiving=%d, ChaStrong=%u, ChaPower=%u, ChaSpirit=%u, ChaStrength=%u, ChaStRemain=%u, ChaAttackP=%u, ChaDefenseP=%u, ChaFightA=%u,
 
ChaShootA=%u, ChaExp=%I64d, ChaSkillPoint=%u, ChaHP=%u, ChaMP=%u, ChaSP=%u, ChaPK=%u, ChaStartMap=%u, ChaStartGate=%u, ChaPosX=%f,
 
ChaPosY=%f, ChaPosZ=%f, ChaSaveMap=%d, ChaSavePosX=%f, ChaSavePosY=%f, ChaSavePosZ=%f, ChaReturnMap=%d, ChaReturnPosX=%f,
 
ChaReturnPosY=%f, ChaReturnPosZ=%f, ChaGuName='%s' WHERE ChaNum=%u
 
{call sp_create_guild(%u,'%s',?)}
 
{call sp_delete_guild(%u,%u,?)}
 
{call sp_update_guild_rank(%u,%u,?)}
 
UPDATE GuildInfo SET GuExpireTime='%s' WHERE GuNum=%u
 
UPDATE GuildInfo SET GuAllianceSec='%s' WHERE GuNum=%u
 
UPDATE GuildInfo SET GuAllianceDis='%s' WHERE GuNum=%u
 
{call sp_add_guild_member(%u,%u,?)}
 
UPDATE GuildInfo SET GuMarkImage=? WHERE (GuNum=%u)
 
UPDATE GuildInfo SET GuMarkVer=%u WHERE GuNum=%u
 
SELECT GuNum FROM ChaInfo WHERE ChaNum=%u
 
Update GuildInfo Set GuIncomeMoney=%I64d WHERE GuNum=%u  [SetClubIncomeMoney llMoney Must be large than zero]
 
SELECT GuIncomeMoney From GuildInfo WHERE GuNum=%u  [GetClubIncomeMoney dwClub is must large than zero]
 
Update GuildInfo Set GuMoney=%I64d WHERE GuNum=%u  [SetClubMoney llMoney Must be large than zero]
 
SELECT GuMoney From GuildInfo WHERE GuNum=%u  [GetClubMoney dwClub is must large than zero]
 
UPDATE GuildInfo SET GuStorage=? WHERE (GuNum=%u)
 
UPDATE ChaInfo SET GuPosition=%u WHERE GuNum=%u AND ChaNum=%u
 
Update GuildInfo WITH (UPDLOCK) Set GuDeputy=%u WHERE GuNum=%u
 
{call sp_add_guild_region(%u,%u,%f,?)}
 
{call sp_delete_guild_region(%u,%u,?)}

---

it's not all but you have those requiert for pet system and more

---

Add ??????

Quote:

---

Originally Posted by acclain

mirror link for EP4 DB posted by namuk

MSSQL-EP4(RanGame1-RanUser).rar

i tested it, it does contained the new tables that some of our members discussed before, i dunno if namuk added the tables himself, or it is an actual EP4 DB.. but great job namuk..

now i just need a working glogic for both client and server.. any luck with comment.ini? ^^

---

That sql is made by me,i am trying to finish it 100%

:busted_co

guys do u have ur eyes??

i am requesting that u upload the old database cuz i lost it on my computer.. but no one in u guys response.......??whats that? u guys makin me a f0ckin dumb here huh!?

u can not help i said i lost it on my computer..so dats why i am requesting u guys 2 upload that here.

Quote:

---

Originally Posted by edilon09

guys do u have ur eyes??

i am requesting that u upload the old database cuz i lost it on my computer.. but no one in u guys response.......??whats that? u guys makin me a f0ckin dumb here huh!?

u can not help i said i lost it on my computer..so dats why i am requesting u guys 2 upload that here.

---

why no one response ?
it's because yourself you didn't open your eyes for see that you have a search button on forum

just type database and you will found many database then just take the one you want

c'mon men i did that and u know what i know that the sticky has it b4 but now link is dead ok?? thats why??

so cmon magenik dont tell here that i can not open my eyes and click the search button ok?? bcuz i know how to read stickies... im just requesting it here bcuz even the link there are all dead...so cmon give me a link to that section....if u can provide me one i am a f0ckin dumb ok??

Quote:

---

Originally Posted by edilon09

guys do u have ur eyes??

i am requesting that u upload the old database cuz i lost it on my computer.. but no one in u guys response.......??whats that? u guys makin me a f0ckin dumb here huh!?

u can not help i said i lost it on my computer..so dats why i am requesting u guys 2 upload that here.

---

search for it noobs. :v:

@namuk i tried your database and its just the same . . . but thanks for the upload of your database

minren can u upload ur old databses?? i mean the old rangame1,ranlog,ranshop, and ranuser?? plss.. all links here are dead ..i lost it on my computer....plss upload it here

here the full procedure from Agent server

[CODE]INFO:m_pMyRossoEncrypto
!2

how to fix the comment.ini error on the field server please.....

get a correct Glogic ==

help me how to solve this problem please...

@edilon
you are barking at the wrong tree. don't use foul language when you're asking for assistance.

Quote:

---

Originally Posted by edilon09

help me how to solve this problem please...

---

help me on this plsss

@Edilon
this is not a help thread. You are not helping us to fix the episode 4 server.
Please stop asking too much. instead learn how to read older threads & think how to fix your problems.

jhayzhon why?? u think sir t68 started this as a developing thread? i know it is being started as he share here..!!so go on ur developing thread ur so boastful men....


EDITED:

and jhayzon i know how to read...but i did not find any person here post like that of my problem...i will not post it here if somebody already did ok?? and i know that you also did not know how to fix that prob huh!....boast

isn't ran korea an ep4 client?

@edilon
i'll let mr. smarkies do the rest here.

@vainhausten
I think we can only use china client because the server files are from china.

Quote:

---

Originally Posted by minren

@namuk i tried your database and its just the same . . . but thanks for the upload of your database

---

I think it is not the database problem....
But,if you can open the server, i think that pet is available:busted_co

Quote:

---

gsp_odbc_response_time
gsp_odbc_pool_size
gsp_odbc_database
gsp_odbc_pass
gsp_odbc_user
gsp_odbc_name

terra_odbc_response_time
terra_odbc_pool_size
terra_odbc_database
terra_odbc_pass
terra_odbc_user
terra_odbc_name

shop_odbc_response_time
shop_odbc_pool_size
shop_odbc_database
shop_odbc_pass
shop_odbc_user
shop_odbc_name

log_odbc_response_time
log_odbc_pool_size
log_odbc_database
log_odbc_pass
log_odbc_user
log_odbc_name

board_odbc_response_time
board_odbc_pool_size
board_odbc_database
board_odbc_pass
board_odbc_user
board_odbc_name

game_odbc_response_time
game_odbc_pool_size
game_odbc_database
game_odbc_pass
game_odbc_user
game_odbc_name

user_odbc_response_time
user_odbc_pool_size
user_odbc_database
user_odbc_pass
user_odbc_user
user_odbc_name

game_db_response_time
game_db_pool_size
game_db_database
game_db_pass
game_db_user
game_db_name

user_db_response_time
user_db_pool_size
user_db_database
user_db_pass
user_db_user
user_db_name

---

i think we need to put these text in cfgs,

@namuk

thanks for the Db i will try these, ill report these files if has an error.

@thetsuya
u mean we need create odbc for terra,gsp and broad????

I think we don't need to create it because the server don't report any problem about terra, gsp & board.

gunzran already successed to run offline server with these files but of course they're not telling how, how predictable
This is what happens when you share something, and I knew it from the start but well, at least I had the good will to help