[Release] Ruby Design for PServerCMS Website

[m1xawy]

@updated links

[theminkman]

Thanks for this design, I am now adding item stats / item blues for PServerCMS free version

[m1xawy]

Originally Posted by theminkman

Thanks for this design, I am now adding item stats / item blues for PServerCMS free version

very good man i like its

[Raymond*]

NICE!

[m1xawy]

Originally Posted by Raymond*

NICE!

thanks

[Raymond*]

Awesome brother.

[develmax]

iam trying to use this theme
Uncaught PDOException: SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'Support'. in C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\doct rine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOStatem ent.php:117\nStack trace:\n#0 C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\doct rine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOStatem ent.php(117): PDOStatement->execute(NULL)\n#1 C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\doct rine\\dbal\\lib\\Doctrine\\DBAL\\Statement.php(153 ): Doctrine\\DBAL\\Driver\\PDOStatement->execute(NULL)\n#2 C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\koks pflanze\\game-backend\\src\\Entity\\SRO\\Log\\Repository\\Online Offline.php(53): Doctrine\\DBAL\\Statement->execute()\n#3 C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\koks pflanze\\game-backend\\src\\DataService\\SRO.php(244): GameBackend\\Entity\\SRO\\Log\\Repository\\OnlineO ffline->getOnlineSupportNumber()\n#4 C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\koks pflanze\\p-server-core\\src\\Service\\PlayerHistory.php(59): GameBackend\\DataService\\SRO->getOnlineSupportNumber()\n#5 C:\\Apac in C:\\Apache24\\htdocs\\pserverCMSFull\\module\\Ruby \\config/../view/layout/layout.twig on line 152

[XxGhostSpiriTxX]

Originally Posted by develmax

iam trying to use this theme
Uncaught PDOException: SQLSTATE[42S22]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'Support'. in C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\doct rine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOStatem ent.php:117\nStack trace:\n#0 C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\doct rine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOStatem ent.php(117): PDOStatement->execute(NULL)\n#1 C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\doct rine\\dbal\\lib\\Doctrine\\DBAL\\Statement.php(153 ): Doctrine\\DBAL\\Driver\\PDOStatement->execute(NULL)\n#2 C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\koks pflanze\\game-backend\\src\\Entity\\SRO\\Log\\Repository\\Online Offline.php(53): Doctrine\\DBAL\\Statement->execute()\n#3 C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\koks pflanze\\game-backend\\src\\DataService\\SRO.php(244): GameBackend\\Entity\\SRO\\Log\\Repository\\OnlineO ffline->getOnlineSupportNumber()\n#4 C:\\Apache24\\htdocs\\pserverCMSFull\\vendor\\koks pflanze\\p-server-core\\src\\Service\\PlayerHistory.php(59): GameBackend\\DataService\\SRO->getOnlineSupportNumber()\n#5 C:\\Apac in C:\\Apache24\\htdocs\\pserverCMSFull\\module\\Ruby \\config/../view/layout/layout.twig on line 152

this table or column does not exist in your db ( Invalid column name 'Support' )

[develmax]

Originally Posted by esteve458

this table or column does not exist in your db ( Invalid column name 'Support' )

NEW ERROR AT RANKING PAGE
An error occurred
An error occurred during execution; please try again later.

[m1xawy]

Originally Posted by develmax

iam trying to use this theme

use the official pservercms files its working fine without errors.

[develmax]

Originally Posted by m1xawy

use the official pservercms files its working fine without errors.

can't you share the procedures with me please ?

[m1xawy]

Originally Posted by develmax

can't you share the procedures with me please ?

deleted

[KoKsPfLaNzE]

Originally Posted by m1xawy

just make thanks : )

CREATE TABLE [dbo].[_UniqueInfo](
	[CodeName128] [varchar](128) NOT NULL,
	[Name] [varchar](128) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[CodeName128] 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

CREATE TABLE [dbo].[_UniqueKillList](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[CharID] [int] NOT NULL,
	[CodeName128] [varchar](128) NOT NULL,
	[time] [datetime] NOT NULL,
 CONSTRAINT [PK___UniqueK__3214EC27198BD5AA] PRIMARY KEY CLUSTERED 
(
	[ID] 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].[_UniqueKillList] ADD  CONSTRAINT [DF__UniqueKillList_time]  DEFAULT (getdate()) FOR [time]
GO

CREATE TABLE [dbo].[_UniqueRanking](
    [CharID] [int] NOT NULL,
	[CodeName128] [varchar](128) NOT NULL,
    [points] [int] NOT NULL
) ON [PRIMARY]

GO

IF (@EventID = 6)
    BEGIN
        UPDATE [SRO_VT_SHARD].[dbo]._Char 
            set ItemPoints = (
            SELECT
            ISNULL((sum(ISNULL(Binding.nOptValue, 0)) + sum(ISNULL(OptLevel, 0))), 0) as ItemPoints
            FROM [SRO_VT_SHARD].[dbo].[_Inventory] as inventory WITH (NOLOCK)
            join [SRO_VT_SHARD].[dbo]._Items as Items WITH (NOLOCK) on Items.ID64  = inventory.ItemID
            join [SRO_VT_SHARD].[dbo]._RefObjCommon as Common on Items.RefItemId  = Common.ID
            left join [SRO_VT_SHARD].[dbo]._BindingOptionWithItem as Binding WITH (NOLOCK) on Binding.nItemDBID = Items.ID64
            where
                inventory.slot < 13 and
                inventory.slot != 8 and
                inventory.slot != 7 and
                inventory.CharID = _Char.CharID
        ) WHERE _Char.CharID = @CharID

        Declare @GuildID int;
        SELECT @GuildID = GuildID FROM [SRO_VT_SHARD].[dbo]._Char WITH (NOLOCK) WHERE _Char.CharID = @CharID

        IF (@GuildID > 0)
        BEGIN
            UPDATE [SRO_VT_SHARD].[dbo]._Guild 
              set ItemPoints = (
              SELECT
                SUM(Char.ItemPoints) as ItemPoints
                FROM [SRO_VT_SHARD].[dbo]._Char as Char WITH (NOLOCK)
                where
                    Char.GuildID = _Guild.ID
            ) WHERE _Guild.ID = @GuildID
        END
End

can you please delete my stuff....

[bimbum*]

Originally Posted by KoKsPfLaNzE

can you please delete my stuff....

i wonder why in some games mentioned that it coded by m1xawy while its yours
ex

[KoKsPfLaNzE]

Originally Posted by bimbum*

i wonder why in some games mentioned that it coded by m1xawy while its yours
ex

looks like he still sell it, to new ppl.

just dos to kill most pages