[Release] Ruby Design for PServerCMS Website

Page 3 of 4 12 3 4
02/09/2019 17:34 m1xawy#31
@updated links
02/13/2019 07:27 theminkman#32
Thanks for this design, I am now adding item stats / item blues for PServerCMS free version
[Only registered and activated users can see links. Click Here To Register...]
02/14/2019 04:00 m1xawy#33
Quote:
Originally Posted by theminkman View Post
Thanks for this design, I am now adding item stats / item blues for PServerCMS free version
[Only registered and activated users can see links. Click Here To Register...]
very good man i like its
09/22/2019 23:50 Raymond*#34
NICE!
09/26/2019 13:40 m1xawy#35
Quote:
Originally Posted by Raymond* View Post
NICE!
thanks
09/29/2019 15:45 Raymond*#36
Awesome brother.
10/01/2019 00:10 develmax#37
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
10/01/2019 00:36 XxGhostSpiriTxX#38
Quote:
Originally Posted by develmax View Post
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' )
10/01/2019 00:57 develmax#39
Quote:
Originally Posted by esteve458 View Post
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.
10/01/2019 15:14 m1xawy#40
Quote:
Originally Posted by develmax View Post
iam trying to use this theme
use the official pservercms files its working fine without errors.
10/03/2019 10:29 develmax#41
Quote:
Originally Posted by m1xawy View Post
use the official pservercms files its working fine without errors.
can't you share the procedures with me please ?
10/04/2019 17:48 m1xawy#42
Quote:
Originally Posted by develmax View Post
can't you share the procedures with me please ?
deleted
10/05/2019 13:00 KoKsPfLaNzE#43
Quote:
Originally Posted by m1xawy View Post
just make thanks : )

Code:
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
Code:
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
Code:
CREATE TABLE [dbo].[_UniqueRanking](
    [CharID] [int] NOT NULL,
	[CodeName128] [varchar](128) NOT NULL,
    [points] [int] NOT NULL
) ON [PRIMARY]

GO
Code:
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....
10/05/2019 13:16 bimbum*#44
Quote:
Originally Posted by KoKsPfLaNzE View Post
can you please delete my stuff....
i wonder why in some games mentioned that it coded by m1xawy while its yours
ex
[Only registered and activated users can see links. Click Here To Register...]
10/05/2019 13:52 KoKsPfLaNzE#45
Quote:
Originally Posted by bimbum* View Post
i wonder why in some games mentioned that it coded by m1xawy while its yours
ex
[Only registered and activated users can see links. Click Here To Register...]
looks like he still sell it, to new ppl.

just dos [Only registered and activated users can see links. Click Here To Register...] to kill most pages
Page 3 of 4 12 3 4