Register for your free account! | Forgot your password?

You last visited: Today at 03:49

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Release] ShCMS v2 (+GM Tool v3)

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 902
[Release] ShCMS v2 (+GM Tool v3)

ShCMS is ready-to-use and easy to understand shaiya website



Today I release you the final public release of ShCMS v2, presented here.

Online demo:





Features:
  • Home page with slider
  • SEO Urls
  • News system with likes & comments
  • Shoutbox with emojis
  • Private Message system & welcome message sent to new players
  • Built-in forum, with section, editions, pages and a nice SCEditor as text editor
  • Anti SQL injections & anti-XSS security
  • Ticket System & Automatic staff page
  • Drop Finder V3 (updated using PDO::SQLSRV)
  • Abrassive Ranking (updated using PDO::SQLSRV)
  • Boss Countdown with auto refresh
  • Vote 4 AP
  • Last In-Game /notice "hello"
  • Account Profiles & Character display
  • GM Tool V3: Updated using PDO::SQLSRV, translated in english, and full fixed
  • Game character as forum user
  • PHP Game PVP Rank parser


  • PAID Version: Web Mall
  • PAID Version: Paypal to AP
  • PAID Version: PHP Game Icon Parser
  • PAID Version: Custom desgin & footer


Gallery:
Gallery 1

Requirement:
  • PHP 5 / PHP 7
  • MSSQL PHP Drviers (3.2 / 4.0)
  • Short tags = ON (php.ini)
  • SQL Server 2016 (I think that you can downgrade the db if you know how to, as I made the website using SQL Server 2008 R2 before updating the db)
  • This in your httpd.conf: (and add mod_rewrite)
    Code:
    <Directory "c:/Apache24/htdocs">
    # BEGIN ShCMS v2
    RewriteEngine On
    RewriteBase /
    RewriteRule ^index\.php$ - [L]
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule . /index.php [L]
    # END ShCMS v2
    </Directory>


Price (PAID Version):
Here



Download (PAID version FOR FREE NOW):



How to setup (so easy)

Quote:
Originally Posted by Trayne01 View Post
Step 1: Copy/Paste the Apache24 floder in your C:/
Step 2: Run the needed .bat files in Apache24/bin to setup apache services
Step 3: Run the SQL code that I posted here (or attach my db if you are using SQL SRV 2016+)
Step 4: Edit the config php files with your SQL user

Contact:

E*PVP: Trayne01
Skype: trayne01
Email:
And this thread


I will soon upload a small php doc, so you can build your own PHP Pages & Classes if you know a bit about PHP, and understand what I wrote without a single "//comment".

PS: I hope that this release will increase the global security level of our shaiya website a bit, and sure, the final user & admin experience.



The 10th July 2018 : I release you today the paid version for free. Enjoy It ! But pelase keep in mind that I am working a new CMS, that will be released as part of the next "Open source server" release



Trayne01 is offline  
Thanks
25 Users
Old   #2
 
elite*gold: 0
Join Date: May 2009
Posts: 50
Received Thanks: 35
Wow, thanks! Great release


Garrett_Thief is offline  
Old   #3
 
elite*gold: 0
Join Date: Oct 2009
Posts: 56
Received Thanks: 478
Open Connections - Security Issue

This CMS has a open connections that remain open at all times. It is highly recommended that closing is performed by adding the following lines to ...

/core/core.inc.php

just above "ob_start();"

Code:
// Close active SQL connections
$conn=null; // PDO
sqlsrv_close($dbConn); // Standard
* NOTE
For more information on this function please review the resource guide at

It is also a good idea to free results with sqlsrv_free_stmt($stmt); after each set of results is used and no longer needed to help eliminate SQL Server's over consumption of local resources because this result data is cached.
BodySalvage is offline  
Thanks
3 Users
Old   #4
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 902
As I am using PDO, the correct way to close a database connection would be:
PHP Code:
$conn null
But PHP will automatically close the connection when the page loading ends.


Trayne01 is offline  
Thanks
1 User
Old   #5
 
elite*gold: 0
Join Date: Oct 2011
Posts: 140
Received Thanks: 5
Would this ShCMS Also work under an Linux Server with Nginx & PHP7.1 with an Remote Connetion to the Database?
Axiades is offline  
Old   #6
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 902
Quote:
Originally Posted by Axiades View Post
Would this ShCMS Also work under an Linux Server with Nginx & PHP7.1 with an Remote Connetion to the Database?

Yes of course, but:

I'm not sure that MSSQL Drivers for PHP 7.1 are already released. I am still using PHP 7.0 for now (with MSSQL PHP Drivers 4.0).

And you would have to rewrite this apache rule for Nginx

Quote:
Originally Posted by Trayne01 View Post
Code:
<Directory "c:/Apache24/htdocs">
# BEGIN ShCMS v2
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
# END ShCMS v2
</Directory>
Good luck!
Trayne01 is offline  
Old   #7
 
elite*gold: 0
Join Date: Oct 2011
Posts: 140
Received Thanks: 5
Quote:
Originally Posted by Trayne01 View Post
Yes of course, but:

I'm not sure that MSSQL Drivers for PHP 7.1 are already released. I am still using PHP 7.0 for now (with MSSQL PHP Drivers 4.0).

And you would have to rewrite this apache rule for Nginx



Good luck!
Nice Thanks for This ^^

Last Question.

The Database is an EP5.x database.
Can i Use my Own EP4.5 Database?
Axiades is offline  
Old   #8
 
elite*gold: 0
Join Date: Oct 2014
Posts: 222
Received Thanks: 106
Quote:
Originally Posted by Axiades View Post
Nice Thanks for This ^^

Last Question.

The Database is an EP5.x database.
Can i Use my Own EP4.5 Database?

ofc you can just read all the db table and other thing from the htdocs files
ShaiyaDead is offline  
Thanks
1 User
Old   #9
 
elite*gold: 0
Join Date: Mar 2017
Posts: 16
Received Thanks: 2
Can you please tell me where I can change the re-positioning of the site? Is going straight to
Bacкa is online now  
Old   #10
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 902
Hello Backa,

Quote:
Originally Posted by Bacкa View Post
Can you please tell me where I can change the re-positioning of the site? Is going straight to
You have to open C:/Apache24/htdocs/core/core.inc.php

and then delete all lines between;
Quote:
//HTTPS PART//

...


//CMS CONFIG FILE//
At the begining of the file.

Or replace shaiya.eu by your domain if you want to force the use of SSL.
Trayne01 is offline  
Thanks
1 User
Old   #11
 
elite*gold: 0
Join Date: Feb 2014
Posts: 109
Received Thanks: 11
does this cms actually works with sql server 2008 r2?
white95260 is offline  
Old   #12
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 902
Quote:
Originally Posted by white95260 View Post
does this cms actually works with sql server 2008 r2?
Yes, but you'll have to run this query to create the Website database :


PHP Code:
removed 
The fixed query is here: [Release] ShCMS v2 (+GM Tool v3)
Trayne01 is offline  
Old   #13
 
elite*gold: 0
Join Date: Feb 2014
Posts: 109
Received Thanks: 11
Thanks you, but I'm getting a error when I try to run your query.

Quote:
Msg 911, Level 16, State 1, Line 10
Database 'Website' does not exist. Make sure that the name is entered correctly.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'Chat' in the database.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 911, Level 16, State 1, Line 3
Database 'Website' does not exist. Make sure that the name is entered correctly.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'Comments' in the database.
Msg 911, Level 16, State 1, Line 3
Database 'Website' does not exist. Make sure that the name is entered correctly.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'ForumSections' in the database.
Msg 911, Level 16, State 1, Line 3
Database 'Website' does not exist. Make sure that the name is entered correctly.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'ForumThreads' in the database.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 911, Level 16, State 1, Line 3
Database 'Website' does not exist. Make sure that the name is entered correctly.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'ForumViews' in the database.
Msg 911, Level 16, State 1, Line 3
Database 'Website' does not exist. Make sure that the name is entered correctly.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'Likes' in the database.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 911, Level 16, State 1, Line 3
Database 'Website' does not exist. Make sure that the name is entered correctly.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'News' in the database.
Msg 911, Level 16, State 1, Line 3
Database 'Website' does not exist. Make sure that the name is entered correctly.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'PlayerPM' in the database.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 911, Level 16, State 1, Line 3
Database 'Website' does not exist. Make sure that the name is entered correctly.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'Users_Vote' in the database.
white95260 is offline  
Old   #14
 
elite*gold: 0
Join Date: Feb 2015
Posts: 464
Received Thanks: 902
I fixed it, It was my fault:

PHP Code:
/***********************************/
/**** Object:  ShCMS v2 SQL SETUP ****/
/** Script Date: 22/05/2017 05:21am ***/
/***** Author:     Trayne01 ******** **/
/***************************************/

USE master
GO
DROP DATABASE Website
GO
CREATE DATABASE Website
GO


USE [Website]
GO

/****** Object:  Table [dbo].[Chat]    Script Date: 5/21/2017 8:03:10 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE 
[dbo].[Chat](
    [
Row] [intIDENTITY(1,1NOT NULL,
    [
message] [nvarchar](maxNOT NULL,
    [
time] [varchar](200NOT NULL,
    [
grade] [varchar](200NULL,
    [
user_uid] [intNOT NULL
ON [PRIMARYTEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE 
[dbo].[ChatADD  CONSTRAINT [DF_Chat_time]  DEFAULT (getdate()) FOR [time]
GO


USE [Website]
GO

/****** Object:  Table [dbo].[Comments]    Script Date: 5/21/2017 8:03:04 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE 
[dbo].[Comments](
    [
NewID] [intNULL,
    [
Comment] [varchar](maxNULL,
    [
UserUID] [intNULL,
    [
CommentDate] [varchar](32NULL,
    [
CommentID] [intIDENTITY(1,1NOT NULL
ON [PRIMARYTEXTIMAGE_ON [PRIMARY]

GO


USE [Website]
GO

/****** Object:  Table [dbo].[ForumSections]    Script Date: 5/21/2017 8:02:58 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE 
[dbo].[ForumSections](
    [
ID] [intIDENTITY(1,1NOT NULL,
    [
Title] [varchar](50NULL,
    [
Description] [varchar](maxNULL,
    [
DisplayOrder] [intNULL,
    [
ParentID] [intNULL,
    [
IsParentCat] [bitNULL,
    [
IconURL] [varchar](maxNULL,
    [
IsPublic] [bitNULL
ON [PRIMARYTEXTIMAGE_ON [PRIMARY]

GO


USE [Website]
GO

/****** Object:  Table [dbo].[ForumThreads]    Script Date: 5/21/2017 8:02:51 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE 
[dbo].[ForumThreads](
    [
ID] [intIDENTITY(1,1NOT NULL,
    [
Title] [varchar](50NOT NULL,
    [
Content] [varchar](maxNOT NULL,
    [
PosterUID] [intNOT NULL,
    [
View] [intNOT NULL,
    [
SectionID] [intNOT NULL,
    [
PostDate] [datetimeNOT NULL,
    [
UpdateDate] [datetimeNULL,
    [
IsFirstPost] [bitNOT NULL,
    [
ReplyToID] [intNOT NULL,
    [
IconURL] [varchar](maxNULL,
    [
LastReplyDate] [datetimeNULL,
    [
AttachedURL] [varchar](maxNULL,
    [
IsLocked] [bitNULL,
    [
IsSticky] [bitNULL
ON [PRIMARYTEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE 
[dbo].[ForumThreadsADD  CONSTRAINT [DF_ForumThreads_View]  DEFAULT ((0)) FOR [View]
GO

USE [Website]
GO

/****** Object:  Table [dbo].[Users_Vote]    Script Date: 7/12/2017 8:07:23 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE 
[dbo].[Users_Vote](
    [
id] [intIDENTITY(1,1NOT NULL,
    [
UserID] [varchar](50NULL,
    [
ip] [varchar](50NULL,
    [
date] [varchar](50NULL,
    [
site] [varchar](50NULL
ON [PRIMARY]

GO

USE [Website]
GO

/****** Object:  Table [dbo].[PlayerPM]    Script Date: 7/12/2017 8:08:52 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE 
[dbo].[PlayerPM](
    [
ID] [intIDENTITY(1,1NOT NULL,
    [
Title] [varchar](50NOT NULL,
    [
Message] [varchar](maxNOT NULL,
    [
IsNew] [bitNOT NULL,
    [
PosterUID] [intNOT NULL,
    [
DestUID] [intNOT NULL,
    [
Date] [datetimeNOT NULL,
    [
ForceIsNew] [bitNOT NULL
ON [PRIMARYTEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE 
[dbo].[PlayerPMADD  CONSTRAINT [DF_PlayerPM_IsNew]  DEFAULT ((1)) FOR [IsNew]
GO

ALTER TABLE 
[dbo].[PlayerPMADD  CONSTRAINT [DF_PlayerPM_Date]  DEFAULT (getdate()) FOR [Date]
GO

ALTER TABLE 
[dbo].[PlayerPMADD  CONSTRAINT [DF_PlayerPM_ForceIsNew]  DEFAULT ((0)) FOR [ForceIsNew]
GO

USE [Website]
GO

/****** Object:  Table [dbo].[News]    Script Date: 7/12/2017 8:09:04 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE 
[dbo].[News](
    [
Row] [intIDENTITY(1,1NOT NULL,
    [
Title] [varchar](maxNULL,
    [
Text] [varchar](maxNULL,
    [
GM_ID] [varchar](100NULL,
    [
Date] [varchar](100NULL,
    [
IsDraft] [intNULL
ON [PRIMARYTEXTIMAGE_ON [PRIMARY]

GO

USE [Website]
GO

/****** Object:  Table [dbo].[Likes]    Script Date: 7/12/2017 8:09:18 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE 
[dbo].[Likes](
    [
NewID] [intNULL,
    [
UserUID] [intNULL,
    [
LikeDate] [datetimeNULL
ON [PRIMARY]

GO

ALTER TABLE 
[dbo].[LikesADD  CONSTRAINT [DF_Likes_LikeDate]  DEFAULT (getdate()) FOR [LikeDate]
GO


USE [Website]
GO

/****** Object:  Table [dbo].[ForumViews]    Script Date: 7/12/2017 8:09:46 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE 
[dbo].[ForumViews](
    [
ThreadID] [intNULL,
    [
UserIP] [varchar](64NULL,
    [
UserUID] [intNULL,
    [
Date] [nchar](10NULL
ON [PRIMARY]

GO 
Trayne01 is offline  
Thanks
1 User
Old   #15
 
elite*gold: 0
Join Date: Feb 2014
Posts: 109
Received Thanks: 11
Thanks really much, worked now.


white95260 is offline  
Thanks
1 User
Reply



« Previous Thread | Next Thread »

Similar Threads
ShCMS v3 (ready-to-use shaiya website)
ShCMS is ready-to-use and easy to understand shaiya website Online demo: https://www.shaiya.eu Features:
4 Replies - Shaiya Trading
[Tool]SRO Taxi Tool V1[Tool]
SRO Taxi Tool V1 Hello all, This is my First Post / Thread. I made a SRO Taxi Tool. I have seen some SRO Taxi Tool. I saw one that was very...
19 Replies - SRO Hacks, Bots, Cheats & Exploits



All times are GMT +2. The time now is 03:49.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.