[Release] PServerCMS a Website for your PServer

[XerK..]

I try to use Donation page and it does not work direct silk.

Any Developer can help me here.

[KoKsPfLaNzE]

Originally Posted by XerK..

I try to use Donation page and it does not work direct silk.

Any Developer can help me here.

did you checked the donate log, in the admin panel, there yo ucan see if donate goes wrong.

[XerK..]

Originally Posted by KoKsPfLaNzE

did you checked the donate log, in the admin panel, there yo ucan see if donate goes wrong.

I used your guide as well you set, I do not understand this problem from where.

[Devsome]

As I told you, "signature is empty, please check your config"

[Trappist]

any new update or feature ?

[KoKsPfLaNzE]

Originally Posted by KoKsPfLaNzE

NEW Module


Features:

- DonateStats, donate level, to get more coins each donate
- DailyCashCounter, if a day limit reached, each new donate get more coins, until 0:00


Update:


- drop zf2
- added phpunit 6 support, removed phpunit 4 support
- added entry max length 65.535 chars
- added php 7.1 in travis


- added amount of members in a guild
- cs parts
- added `AbstractRankingPaginator`


- added guild leader function in guild details
- added amount of members in guild, like in p-server-ranking
- added space in navigation name, for the ranking pages


- added favicon
- jquery update 3.2.1
- added link to cms in content section
- added markdown parser for update module section
- user-panel like search, little basic version


- added better example images
- added PaymentNotifyCoins in PaymentNotify, for DonateAction Module
- cs fix in Mail service
- added getAlreadyGivenCoins method
- jquery update 3.2.1
- added space for navigation, "Top Player", "Top Guild"
- captcha fields set to autocomplete off
- message "A record matching the input was found" changed to "already in use"

just that old part and some internal updates in twig handling and some zend parts

[Harmomix2007]

Can someone explain to me how I do the Cron jobs for the cms under windows after instructions does it not for some reason

[KoKsPfLaNzE]

added certificate_num generation, maybe someone can test it and give feedback if it work correctly.

just add in the composer.json following in the "require" section

PHP Code:

"kokspflanze/game-backend": "dev-feature/csro-r as 0.9" 


so it can look like

PHP Code:

  "require": {
    "zendframework/Zend-developer-tools": "^1.1",
    "kokspflanze/p-server-cms": "^1.0.1",
    "kokspflanze/game-backend": "dev-feature/csro-r as 0.9"
  } 


also added sofortüberweisung as payment provider in dev section, which will go live next week.

[KoKsPfLaNzE]

Payment update

- added as new payment provider
- added new report in request to provide a better logging
- added throwable handling in payment notify
- added controller for sofort payment, for a basic use case

[ZeonNETWORK]

after the latest updates
i get this at top player or character profile

An exception occurred while executing 'SELECT t0_.UserJID AS UserJID_0 FROM _BlockedUser t0_ WHERE t0_.timeEnd >= ? GROUP BY t0_.UserJID' with params ["2017-08-15 18:18:49.889588"]:

SQLSTATE[22007]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Conversion failed when converting date and/or time from character string.

i restored the previous version it works fine!
notice: _BlockedUser table has no data

[KoKsPfLaNzE]

Originally Posted by ZeonNETWORK

after the latest updates
i get this at top player or character profile

An exception occurred while executing 'SELECT t0_.UserJID AS UserJID_0 FROM _BlockedUser t0_ WHERE t0_.timeEnd >= ? GROUP BY t0_.UserJID' with params ["2017-08-15 18:18:49.889588"]:

SQLSTATE[22007]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Conversion failed when converting date and/or time from character string.

i restored the previous version it works fine!
notice: _BlockedUser table has no data

can you tell me which versions, you test?

just the p-server-modules or did you restore older doctrine version too?

or its maybe possible to send me a dump of this account db?

[ZeonNETWORK]

i can't define its version, but i always pack the entire pserverCMS folder before i attempt to update and the latest working backup @ 18 June

the account db is the same with everyone else never changed its just for testing purpose
maybe you mean the columns?

 Spoiler

USE [SRO_VT_ACCOUNT]
GO

/****** Object: Table [dbo].[_BlockedUser] Script Date: 8/15/2017 6:52:30 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_BlockedUser](
[UserJID] [int] NOT NULL,
[UserID] [varchar](128) NOT NULL,
[Type] [tinyint] NOT NULL,
[SerialNo] [int] NOT NULL,
[timeBegin] [datetime] NOT NULL,
[timeEnd] [datetime] NOT NULL,
CONSTRAINT [PK__BlockedUser__1] PRIMARY KEY CLUSTERED
(
[UserJID] ASC,
[Type] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

maybe like you mentioned it's a doctrine issue?

[KoKsPfLaNzE]

Originally Posted by ZeonNETWORK

i can't define its version, but i always pack the entire pserverCMS folder before i attempt to update and the latest working backup @ 18 June

the account db is the same with everyone else never changed its just for testing purpose
maybe you mean the columns?

 Spoiler

USE [SRO_VT_ACCOUNT]
GO

/****** Object: Table [dbo].[_BlockedUser] Script Date: 8/15/2017 6:52:30 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_BlockedUser](
[UserJID] [int] NOT NULL,
[UserID] [varchar](128) NOT NULL,
[Type] [tinyint] NOT NULL,
[SerialNo] [int] NOT NULL,
[timeBegin] [datetime] NOT NULL,
[timeEnd] [datetime] NOT NULL,
CONSTRAINT [PK__BlockedUser__1] PRIMARY KEY CLUSTERED
(
[UserJID] ASC,
[Type] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

maybe like you mentioned it's a doctrine issue?

i think i found it, it is just a windows problem in doctrine with the timestamp generation

can you please test it with dev-master version of gamebackend?

[ZeonNETWORK]

wait a sec it's not doctrine!!
at the moment i used the latest update with the older GameBackend and it worked!!

[KoKsPfLaNzE]

Originally Posted by ZeonNETWORK

wait a sec it's not doctrine!!
at the moment i used the latest update with the older GameBackend and it worked!!

in one of the last versions of doctrine they fixed a bug in a subselect case, before they do that, i added a own doctrine driver, thats why it works on older version.

i removed that fix in last release to use the normal driver, but we see a new problem with the timestamp.

so again overwrite it but just the timestamp, hope it works=)