deos anyone know what the Event table deos? my db is clean, but the dbsev.exe calls for it, and theres a few SP that also call for it too...
Mod: I dont know where this belongs if i posted in the wrong section please move it to where it belogs thanks.
side note - Im looking for someone who can help with my server, and odds are if i like you, ill give you a DB file that no one has but only me and a few old school devs.... and from my understanding when i got the DB that it was the original db that int uses... (2007)
http://forum.ragezone.com/f315/list-dbserver-sql-queries-524196/
the table its self
Mod: I dont know where this belongs if i posted in the wrong section please move it to where it belogs thanks.
side note - Im looking for someone who can help with my server, and odds are if i like you, ill give you a DB file that no one has but only me and a few old school devs.... and from my understanding when i got the DB that it was the original db that int uses... (2007)
http://forum.ragezone.com/f315/list-dbserver-sql-queries-524196/
PHP:
//no clue
SELECT [Type], [nF1] FROM Event WHERE [PID] = %d
UPDATE Event SET nF1=%d WHERE PID=%d AND Type=%d
INSERT INTO Event VALUES (%d,%d,%d)the table its self
PHP:
USE [KalOnline]GO
/****** Object: Table [dbo].[Event] Script Date: 07/12/2013 13:36:34 ******/SET ANSI_NULLS ONGO
SET QUOTED_IDENTIFIER ONGO
CREATE TABLE [dbo].[Event]( [PID] [int] NOT NULL, [Type] [tinyint] NOT NULL, [nF1] [int] NOT NULL, CONSTRAINT [PK_Event] PRIMARY KEY CLUSTERED ( [PID] ASC, [Type] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Event] ADD CONSTRAINT [DF_Event_byF1] DEFAULT ((0)) FOR [nF1]GO
