Yes some maps cannot have monsters, ex city =) and other ...Quote:
Originally Posted by seryi
for open map 60 see attach...
Printable View
Yes some maps cannot have monsters, ex city =) and other ...Quote:
Originally Posted by seryi
for open map 60 see attach...
my character is invisible inthe map, how to fix? tnx
you character is GM.. and when you login by default you are invisible and can't be attackedQuote:
Originally Posted by nhed57
/char off - visible
/attack off - monsters can attack you
oops... Double shot =)Quote:
Originally Posted by nhed57
u char - Admin for visible use gm command /char off
Never use a command /adminopen - all players = GM
Use values (16,***48,64,80) Status in table Users_Master.
About this we wrote on the previous pages
btw i try Guild Fix that was posted earlier.. but it doesn't work for me
Friends fix work.. it save in DB.. guilds nope =)
stop server...Quote:
Originally Posted by seryi
use Query Analyzer...
select PS_GameData..
open sql file and run..
start server...
All errors in:
PSM_Client\Bin\Log
PS: if errors create guilds.. i change collate
attach
i have problem about LoginStatus.
it LoginStatus=1 everytimes althoung the Character had been logout
Row LoginStatus as tinyint and set default=0
My SP ::
usp_Read_Chars_Detail2_R
AndCode:CREATE Proc usp_Read_Chars_Detail2_R
@CharID int
AS
SET NOCOUNT ON
DECLARE @UserUID int
DECLARE @Money bigint
DECLARE @GuildID int
DECLARE @GuildLevel tinyint
DECLARE @UID varchar (18)
DECLARE @Event1 tinyint
DECLARE @Event2 tinyint
SET @Money = 0
SET @UserUID = (SELECT UserUID FROM Chars WHERE CharID = @CharID)
SET @GuildID = (SELECT GuildID FROM GuildChars WHERE CharID = @CharID AND Del = 0)
IF(@UserUID IS NOT NULL)
BEGIN
SET @Money = 0
END
ELSE
BEGIN
SET @Money = 0
END
IF(@GuildID IS NOT NULL)
BEGIN
SET @GuildLevel = (SELECT GuildLevel FROM GuildChars WHERE CharID = @CharID AND Del = 0)
END
ELSE
BEGIN
SET @GuildID = 0
SET @GuildLevel = 0
END
SELECT @Event1=Event1, @Event2=Event2 FROM CharEvents WHERE CharID=@CharID
SELECT UserUID, CharID, CharName, Slot, Family, Grow, Hair, Face, [Size], Job, Sex, [Level],
StatPoint AS DistPoint, SkillPoint, [Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, PosZ, Hg, Vg, Cg, Og, Ig, Del,K1, K2, K3, K4,@Money AS StoredMoney, @GuildID AS GuildID, @GuildLevel AS GuildLevel,
KillLevel,
DeadLevel,
@Event1, @Event2,
DATEPART(yyyy, LeaveDate) AS LeaveDate_YYYY,
DATEPART(mm, LeaveDate) AS LeaveDate_MM,
DATEPART(dd, LeaveDate) AS LeaveDate_DD,
DATEPART(hh, LeaveDate) AS LeaveDate_HH,
DATEPART(mi, LeaveDate) AS LeaveDate_MI,
DATEPART(ss, LeaveDate) AS LeaveDate_SS
FROM Chars WHERE CharID = @CharID
UPDATE Chars SET JoinDate=GETDATE(), LoginStatus = 1 WHERE CharID=@CharID
SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID
UPDATE CHARS SET LoginStatus = 0 WHERE (CharID<>@CharID) AND (UserID=@UID)
SET NOCOUNT OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
usp_Save_Char_LeaveDate_R
Code:drop procedure [dbo].[usp_Save_Char_LeaveDate_R];
CREATE Proc usp_Save_Char_LeaveDate_R
@CharID int
AS
DECLARE @UID varchar (18)
SET NOCOUNT ON
SELECT @UID=UserID FROM CHARS WHERE CharID=@CharID
UPDATE Chars SET LeaveDate=GETDATE() , LoginStatus = 0 WHERE UserID=@UID
SET NOCOUNT OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Script PHP
How to solve thsi problem ?:/:PHP Code:<?
$myServer = "IPadd";
$myUser = "dbuser";
$myPass = "dbpw";
$myDB = "PS_GameData";
$conn=mssql_connect($myServer,$myUser,$myPass);
if (!$conn){exit("Connection Failed: " . $conn);}
$selected = mssql_select_db($myDB, $conn) or die("Couldn't open database $myDB");
$resultx0=mssql_query("SELECT COUNT(LoginStatus) AS Online FROM CHARS WHERE (LoginStatus = 1)") or die;
$row0 = mssql_fetch_array($resultx0);
//text format
//echo "Humans:" . $row0[0];
//echo "<br>Elves:" . $row1[0];
//echo "<br>Vail:" . $row2[0];
//echo "<br>Nordein:" . $row3[0];
//echo "<br>Total:" . $row4[0];
//table format
echo '<body leftmargin=0 topmargin=0><TABLE width=100 height=40 border=0 cellspacing=0 bordercolor=#FFFF00 align=center';
echo '<body leftmargin=0 topmargin=0><table width="100" height="40" border="0" cellspacing="0" bordercolor="#dfe1db" align="center" >';
echo '<TR><TD colspan=1 height=5 bgcolor=#99CCFF align=center><font size=2 color=000000 face=Tahoma>User Online: ' . $row0[0] . '</font></TD></TR>';
echo '</TABLE></body>';
?>
Need change(enter) new(other) Character or exit from gameQuote:
Originally Posted by plemaster
PS:
PHP - Bless script I did not add in archive, but I think it very simply and you can create.
My test script:
I've got a little problem.I've bought some plain gear from NPC and I can't equip it.It says: "Status isn't enough" so i cant equip that item.What do i have to do?
How to add or edit portal in a map ? If the portal isn't working ? Can we make it work ? And how ?
I think the problem in svmap file, but when i edit svmap using svmap editor i only see NPC and Mobs coordinates.
What options i need to put in Maps.ini file to make a map become Guild Ranking Battle map, cuz when i add that map in Maps.ini as same as others, everyone can enter it at anytime and when killing mobs it return no guild points ?? Also how to start Guild Ranking Battle event and how to end it. The same problems in Guild Office map, everyone can enter it and they no need to have a guild.
My Guild Warehouse have problems, when someone put items in it, the item display in the warehouse but not store in the database. Cuz of that those items disappear after relog. I check logs but there was no error ???
And one more, my guild have enough etin and guild points to upgrade guild NPCs, but when the leader of the Guild trying to upgrade, system says "failed to upgrade". Why ? And how to solve it ?
I'm asking to much today, but these were really big problems, if anyone can help me i will appreciate that very much.
Thanks in advanced.
yeah thx I find error but it was not table... it was procedures... I chnage 3-4 and now it work.. but last with Update_GuildPointRank.. I set TotalRank to accept NULL.. now it work fine.. need to test and create another guild :)Quote:
Originally Posted by Twilight
btw all guild errors was in procedures
Cannot insert the value NULL into column.....
Does this server work with No-IP ?
If it work, list of Ports need to forward ?
1433 - for sqlQuote:
Originally Posted by lightritual
game ports
30800
30810
30900
30901
30911
30912
40900
solved the "Status isnt enough" error, now i got another problem:
I just died with an UM char without res rune and i wonder how can i restore it.I opened dbo.CHARS and changed the UMreset value from False to True, but it wont reset the car.What do i have to do?
I forwarded all the ports and change all 127.0.0.1 in my Server Manager to my No-IPQuote:
Originally Posted by seryi
ex: example.myvnc.com
Then I reopen Server Manager, all are red X.
What's the problem ?
Or can you more details in how to make a server with No-IP
Thanks