Hello Guys. i had some free time so i decided to download free templates from the internet and Recode them for the Community.
Website Features :
1-: Secured.
2-: News (Read,Comment,Load From DB).
3-: Control Panel (Change password,Email,Teleport Char,Restore Deleted Char,AddSilks(works only if you're using the username "b1qb0ss" or you can change it from pages/addsilks.php)
4-: ForgotPassword (Restore Password by Username,Email)
5-: Downloads (edit links from inc/config.php also db conn)
6-: Logout
7-: Server Status / Online Players
8-: Top 10 players (including Char Img, Online/Off, Guild, Gold, SP, Race, Rank(GM GA Normal))
9-: Donate Page (No Buttons Just ItemName , Price)
10-: PSD Logo To Add YourServer Name :)
Let's see Some Pics :
Home (News)
------------------------------------------
Register
------------------------------------------
Downloads
------------------------------------------
Ranking
------------------------------------------
PlayerProfile
------------------------------------------
UserPanel
No More Pictures
here's what you will have todo a small Procedure when the Player Logs In it will Set The value (Online) in Table _Char to 1 When The Player Logs Off it will Back to 0 i didn't tried this but you should give it a try
Execute This Query
Code:
ALTER TABLE TB_User
ADD dec_pass varchar(50) NULL
ALTER TABLE SRO_VT_SHARD.._Char
ADD Online varchar(1) NULL
it will add a column called dec_pass to The TB_User Table it will contain the UserPassword / Decrypted we will use it when the player request his PW by Forgot Password
and the Online will be used for the player Profile (if you dont want it you can simply remove it from Pages/characterteleport.php and Pages/profile.php)
as i mentioned the Templates is not mine i got it from the internet :) it contains background PSD in theme/images/bg.psd
Download time
Fixed Version
https://files.fm/u/keczwszt
news_comments Table
Code:
USE [SRO_VT_ACCOUNT]
GO
/****** Object: Table [dbo].[news_comments] Script Date: 3/30/2015 7:50:05 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[news_comments](
[id] [int] IDENTITY(1,1) NOT NULL,
[newsid] [int] NOT NULL,
[writer] [varchar](50) NULL,
[comment] [varchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
i'll release more websites as soon as possible :)
if you're going to Copy this Thread to Another Forum atleast give Credits :) thank you and
Have Fun.