- Joined
- Oct 14, 2008
- Messages
- 1,277
- Reaction score
- 249
I fixed it with Xampp php 7.3
Now the problem is with the credit configuration that always says: There was an error getting the credits value.
PS: If add manually my memb___id in the MEMB_CREDITS table, then i can use it without problem. I can't even use the credit manager to add credits to my account, everything is set perfectly.
EDIT: THAT'S HOW I TEMPORARY FIXED IT!
RUN THIS QUERY:
PHP:
USE [MuOnline]
GO
/****** Object: Trigger [dbo].[Features] Script Date: 10/02/2012 05:52:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[FixWebsiteCredits] ON [dbo].[MEMB_CREDITS]
FOR INSERT, UPDATE, DELETE
AS
begin
INSERT INTO MEMB_CREDITS(memb___id)
SELECT t1.memb___id
FROM MEMB_INFO t1
WHERE NOT EXISTS(SELECT memb___id
FROM MEMB_CREDITS t2
WHERE t2.memb___id = t1.memb___id)
end
Last edited: