|
You last visited: Today at 10:19
Advertisement
[Release] Fixing the ShopMall
Discussion on [Release] Fixing the ShopMall within the Shaiya PServer Guides & Releases forum part of the Shaiya Private Server category.
02/18/2013, 14:34
|
#31
|
elite*gold: 0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
|
Code:
Msg 208, Level 16, State 6, Procedure usp_Read_User_CashPoint_NCash, Line 17
Invalid object name 'dbo.usp_Read_User_CashPoint_NCash'.
Code:
Msg 208, Level 16, State 6, Procedure usp_Save_User_BuyPointItems_NCash, Line 7
Invalid object name 'dbo.usp_Save_User_BuyPointItems_NCash'.
I have a problem When buy AP items in IM after relog and Items is gone
|
|
|
02/18/2013, 14:43
|
#32
|
elite*gold: 92
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
|
This fix is really Old. ( 11-26-2010, 20:40 )
What server files are you using?
|
|
|
02/18/2013, 17:01
|
#33
|
elite*gold: 0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
|
Quote:
Originally Posted by peripher
This fix is really Old. ( 11-26-2010, 20:40 )
What server files are you using?
|
This files:
Quote:
Yes i use this and this :
And :
Code:
if exists(select *
from master..sysservers
where isremote=1 and srvname='game')
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123'
if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_NCASH')
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123'
if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB')
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123'
if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB01')
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123'
And:
Code:
/* Add linked servers */
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_DEFINEDB')
BEGIN
EXEC sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc out', @optvalue='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_NCASH')
BEGIN
EXEC sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='PS_NCASH', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_NCASH', @optname='rpc out', @optvalue='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB')
BEGIN
EXEC sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='PS_USERDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB', @optname='rpc out', @optvalue='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_GAMEDB01')
BEGIN
EXEC sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc out', @optvalue='true';
IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB01')
BEGIN
EXEC sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123';
END
exec sp_serveroption @server='PS_USERDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB01', @optname='rpc out', @optvalue='true';
And:
But my server is still without AP
Can buy but items but all gone after relog. And when i add AP points in User_Masters "1000" is in DB but in game 0 is.
DB_agent:
Code:
2013-02-18 16:43:58 PS_DBAGENT__system log start (DBAgent01)
Module list:
D:\ShaiyaServer\PSM_Client\Bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57
2013-02-18 16:44:02 ### Connect[3492] : Game[?][0x00CC1C68], Addr=127.0.0.1, DBJobEnd=1
2013-02-18 16:44:02 ### Connect[3492] : Game[?][0x00D27E28], Addr=127.0.0.1, DBJobEnd=2
2013-02-18 16:44:02 ### DB_SYSTEM_CONNECT[6184] :Game[1][0x00CC1C68], Name=Game01, Addr=127.0.0.1
2013-02-18 16:44:02 Error Packet : 0x209, CConnection::PacketSystemConnect
2013-02-18 16:48:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'usp_Read_User_CashPoint_UsersMaster'., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)
2013-02-18 16:48:20 ReloadPoint 2009 Test qerr=-1, {? = call [usp_Read_User_CashPoint_UsersMaster](?,1)}
PS_Game:
Code:
2013-02-18 16:43:58 PS_GAME__system log start (Game01) [KR]
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/sorp1
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/croco1
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/croco2
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/Troll1
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/Spink1
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/GoldenPig
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/Sorp3
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/SorpNamed1
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/SorpNamed2
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/Sorp2
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/CrocoNamed1
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/CrocoNamed2
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/CrocoNamed3
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/OrcNamed1
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/OrcNamed2
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/OrcNamed3
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/TrollNamed1
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/Deinos
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/Parridalis
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/Alcarian
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/ZinAlcaria
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/Belizabeth
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/Kirhiross
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/CrypticOne
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/Haruhion
2013-02-18 16:43:58 Loaded Behavior In Factory : data/ai/Freezing
2013-02-18 16:44:00 RandomOption Error : ItemID=40155, byServer=9, Wis=0
2013-02-18 16:44:02 connect mgr 912
2013-02-18 16:44:02 connect dbagent 916
2013-02-18 16:44:02 connect dbagent2 920
2013-02-18 16:44:02 connect gamelog 936
2013-02-18 16:44:02 Market End -----------------------
2013-02-18 16:44:03 Load Shaiya.SData 4
2013-02-18 16:44:19 <Console input> /nprotectoff
2013-02-18 16:44:19 <Console output> cmd NProtect off ok
PS_GAMELOG:
Code:
2013-02-18 16:43:58 PS_GAMELOG__system log start (GameLog01)
Module list:
D:\ShaiyaServer\PSM_Client\Bin\ps_gameLog.exe, loaded at 0x00400000 - 10/10/18 16:33:52
2013-02-18 16:44:02 connect game
2013-02-18 16:44:58 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '240117991329448740000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)
2013-02-18 16:44:58 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'exp',1,80,'', 61123,1404464959,14914, -240117991329448740000000000000000000000.000000,0.000000,0.000000, '2000-00-00 00:00:00' ,107, 0,1778384896,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '0.0.0.0','money=117440515, bank=1560284416, cash=150998018','level=0,skp=2304,stp=32512','s=0,d=15361,i=0,w=0,r=0,l=0'
2013-02-18 16:44:58 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '240117991329448740000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)
2013-02-18 16:44:58 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'exp',1,80,'', 61123,1404464959,14914, -240117991329448740000000000000000000000.000000,0.000000,0.000000, '2000-00-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Enter',NULL,NULL,NULL
2013-02-18 16:45:43 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2013-02-18 16:45:43 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'exp',1,0,'', 61123,1404464959,27458, 0.000000,154747227277155400000000000.000000,-12122860544.000000, '2020-12-00 00:06:06' ,113, 7310298023558668660,1951604852,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'one','PointItem','0,0,0,0,0,0 (Option:)','2000-00-00 00:00:00'
2013-02-18 16:46:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2013-02-18 16:46:05 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'exp',1,1300716121,'M', 61123,1404464959,34114, -3177935154446336.000000,0.000000,0.000000, '2026-08-00 00:00:00' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'money=117440515, bank=1560284416, cash=150998018','level=0,skp=2304,stp=15360','s=55552,d=7407,i=0,w=0,r=0,l=0'
2013-02-18 16:46:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2013-02-18 16:46:05 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'exp',1,1300716121,'M', 61123,1404464959,34114, -3177935154446336.000000,0.000000,0.000000, '2026-08-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Leave',NULL,NULL,NULL
2013-02-18 16:47:07 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '240117991329448740000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)
2013-02-18 16:47:07 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'exp',1,80,'', 61123,1404464959,50754, -240117991329448740000000000000000000000.000000,0.000000,0.000000, '2000-00-00 00:00:00' ,107, 0,1778384896,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, '165.7.72.140','money=117440515, bank=1560284416, cash=150998018','level=7323,skp=2304,stp=32512','s=0,d=15361,i=0,w=0,r=30821,l=112'
2013-02-18 16:47:07 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]The number '240117991329448740000000000000000000000.000000' is out of the range for numeric representation (maximum precision 38)., SQL STATE: 22003, NATIVE ERROR: 1007 (0x3EF)
2013-02-18 16:47:07 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'exp',1,80,'', 61123,1404464959,50754, -240117991329448740000000000000000000000.000000,0.000000,0.000000, '2000-00-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Enter',NULL,NULL,NULL
2013-02-18 16:48:40 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2013-02-18 16:48:40 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'exp',1,-1941438464,'›HŚ›HŚ<', 61985,1404464959,10306, -3177935422881792.000000,-0.000000,0.000000, '2026-08-00 00:00:00' ,108, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL, 'money=117440515, bank=1560284416, cash=150998018','level=783,skp=2304,stp=15360','s=55552,d=7407,i=0,w=256,r=60,l=76'
2013-02-18 16:48:40 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type int to tinyint., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2013-02-18 16:48:40 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'exp',1,-1941438464,'›HŚ›HŚ<', 61985,1404464959,10306, -3177935422881792.000000,-0.000000,0.000000, '2026-08-00 00:00:00' ,232, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Leave',NULL,NULL,NULL
|
|
|
02/19/2013, 02:44
|
#34
|
elite*gold: 92
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
|
2013-02-18 16:48:20 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'usp_Read_User_CashPoint_UsersMaster'., SQL STATE: 42000, NATIVE ERROR: 2812 (0xAFC)
This procedure is missing.
Using new database files should fix it too.
|
|
|
02/19/2013, 13:44
|
#35
|
elite*gold: 0
Join Date: Oct 2012
Posts: 89
Received Thanks: 4
|
Ok thanks, but I can save the file PS_gamedefs ? I want to have ep 4,5
|
|
|
|
|
Similar Threads
|
i need npc shopmall with...
09/13/2010 - CO2 Private Server - 5 Replies
hello all
i need npc who sell armors for all char but we can wear it in germant place
http://img818.imageshack.us/img818/2536/shopandga rment.jpg
|
[Release] Fixing SaveVoid (CoEmu v2)
09/23/2009 - CO2 PServer Guides & Releases - 12 Replies
Extremely easy to fix:
go to Database.cs and serach for SaveCharacter them just change this:
" WHERE `CharID` = " + Client.ID
to this:
" WHERE `CharID` = " + Client.ID + ""
|
[Release]Fix the ShopMall in Coemu Source
07/16/2009 - CO2 PServer Guides & Releases - 14 Replies
Okay, Best Code...
Look Imag's
http://www.elitepvpers.com/forum/attachment.php?at tachmentid=23183&stc=1&d=1243402494
http://www.elitepvpers.com/forum/attachment.php?at tachmentid=23184&stc=1&d=1243402494
http://www.elitepvpers.com/forum/attachment.php?at tachmentid=23185&stc=1&d=1243402494
|
Need Help on ShopMall
05/28/2009 - CO2 Private Server - 0 Replies
Guys How do I activate the Shopmall item coz most of it not working
Pls Help me
Thanks
|
[RELEASE]Fixing Guild Conducter Bug
04/05/2009 - CO2 PServer Guides & Releases - 1 Replies
this is for 5017 Sources
search for
if (CurrentNPC < 618 && CurrentNPC > 613)
at the npc do part and replae it with
if (CurrentNPC < 618 && CurrentNPC > 613)
if (Control == 1)
{
if (MyChar.Silvers >= 500)
{
MyChar.Teleport(1038, 350, 339);
|
All times are GMT +2. The time now is 10:19.
|
|