Register for your free account! | Forgot your password?

You last visited: Today at 12:09

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

Advertisement



[Release] ShCMS v2 (+GM Tool v3)

Discussion on [Release] ShCMS v2 (+GM Tool v3) within the Shaiya PServer Guides & Releases forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
Trayne01's Avatar
 
elite*gold: 0
Join Date: Feb 2015
Posts: 473
Received Thanks: 1,093
[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 .

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):



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 (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:
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
36 Users
Old 05/16/2017, 13:34   #2
 
Garrett_Thief's Avatar
 
elite*gold: 0
Join Date: May 2009
Posts: 50
Received Thanks: 42
Wow, thanks! Great release
Garrett_Thief is offline  
Old 05/17/2017, 20:49   #3
 
BodySalvage's Avatar
 
elite*gold: 0
Join Date: Oct 2009
Posts: 56
Received Thanks: 500
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 05/17/2017, 22:10   #4
 
Trayne01's Avatar
 
elite*gold: 0
Join Date: Feb 2015
Posts: 473
Received Thanks: 1,093
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 05/18/2017, 19:09   #5
 
elite*gold: 0
Join Date: Oct 2011
Posts: 160
Received Thanks: 6
Would this ShCMS Also work under an Linux Server with Nginx & PHP7.1 with an Remote Connetion to the Database?
Axiades is offline  
Old 05/18/2017, 23:22   #6
 
Trayne01's Avatar
 
elite*gold: 0
Join Date: Feb 2015
Posts: 473
Received Thanks: 1,093
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 05/19/2017, 19:03   #7
 
elite*gold: 0
Join Date: Oct 2011
Posts: 160
Received Thanks: 6
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 05/19/2017, 19:08   #8
 
ShaiyaDead's Avatar
 
elite*gold: 0
Join Date: Oct 2014
Posts: 233
Received Thanks: 127
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 05/22/2017, 00:12   #9
 
elite*gold: 0
Join Date: Mar 2017
Posts: 33
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 offline  
Old 05/22/2017, 00:27   #10
 
Trayne01's Avatar
 
elite*gold: 0
Join Date: Feb 2015
Posts: 473
Received Thanks: 1,093
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 05/22/2017, 03:49   #11
 
elite*gold: 0
Join Date: Feb 2014
Posts: 110
Received Thanks: 11
does this cms actually works with sql server 2008 r2?
white95260 is offline  
Old 05/22/2017, 05:24   #12
 
Trayne01's Avatar
 
elite*gold: 0
Join Date: Feb 2015
Posts: 473
Received Thanks: 1,093
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:
Trayne01 is offline  
Old 05/22/2017, 12:54   #13
 
elite*gold: 0
Join Date: Feb 2014
Posts: 110
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 05/22/2017, 16:07   #14
 
Trayne01's Avatar
 
elite*gold: 0
Join Date: Feb 2015
Posts: 473
Received Thanks: 1,093
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
2 Users
Old 05/22/2017, 16:40   #15
 
elite*gold: 0
Join Date: Feb 2014
Posts: 110
Received Thanks: 11
Thanks really much, worked now.
white95260 is offline  
Thanks
1 User
Reply


Similar Threads Similar Threads
ShCMS v3 (ready-to-use shaiya website)
12/07/2018 - Shaiya Trading - 5 Replies
ShCMS is ready-to-use and easy to understand shaiya website Online demo: https://www.shaiya.eu Features:
[Tool]SRO Taxi Tool V1[Tool]
04/05/2010 - SRO Hacks, Bots, Cheats & Exploits - 19 Replies
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 cool and it got virus so i made my own one. ScreenShot:



All times are GMT +1. The time now is 12:09.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.