Another full PHP website package

[FragFrog]

As many of you shall know by now do I every now and again also make a PHP page. These included a stats adder and a PHP based reset reward script. Now it is time I believe to release a more complete package. This has just about everything you'll ever need for a good PHP based website, with about 10 never before by me released pages (though no doubt the better coders out here already made some of them available).

I will warn you right here that this is NOT as easy to use as for example john_d's package. I don't have the PHP skills nor the time to create admin-userinterfaces for editing a newspost for example, meaning you'll actually have to edit the php files yourself. Its fairly easy, even for someone with no website skills whatsoever (in fact, it might even inspire you to go code yourself ;)), but don't complain I didn't warn you later :icon6:

Links:

http://members.home.nl/matthijsdorst/Website.rar

Recent Screenshot


With that said and done, I'll now save myself a lot'a time by pasting the contents of the included read_me_first.txt:



============ FragFrog's MU WebCenter ===============
Welcome to FrogMu's WebCenter, originally based on
IO*'s files, editted and modified by FragFrog
============ FragFrog's Mu WebCenter ===============


----------------- Installation Notes ----------------

1. Configuration file: config.php

This part should speak pretty much for itself. Enter
the username used by your SQL server and the password
you've entered for it. Default username is 'sa', but
I strongly suggest you create a new weblogin for the
SQL server - they WILL attack it. IP adres is the
IP adres of the SQL server, default is 127.0.0.1
COPY THIS FILE TO THE 3 RESET REWARD FOLDERS:
WING, WEAPON AND ARMOR!


2. The resets counter

Open the SQL manager. Go to your MuOnline database,
select tables, rightmousebutton and click
'New Table...' Add the following columns:

"Name", data type "nvarchar"
"Armor", data type "int"
"Weapon", data type "int"
"Wing", data type "int"
"Ring", data type "int"
"Pendant", data type "int"
"Shield", data type "int"
"Resets", data type "int"

Then click the 'Table and Index properties'
button, topleft next to the 'save' button.
Enter "Resets" as a table name. See also:
[ame="http://forum.ragezone.com/showthread.php?t=42917"]RaGEZONE - MMORPG server development forums[/ame]


3. Small individual settings:

3.1: modify links.php with correct download links
for your patch, IP adres, and e-mail adres.
3.2: update data.php with the correct info for
your server
3.3: change the GM mail adres in the event.php
file to your GM's mail adres.
3.4: edit the index.php file to have your servers
name in the title and description used by
search engines.
3.5: edit the news.php file to match your servers
latest news and updates.

4. Forum setup

please refer to the installation guide as can be
found on http://www.phpbb.com for more information
on setting up the forum.


------------------- Security info -------------------

Website is "secured" by john_d's SQL injection
detector. This is NOT 100% save! Always remember
not to give the weblogin rights to delete anything
or you probably will get hacked!


-------------------- Features -----------------------

1. Web-based reset reward system

The webbased reset reward system allows for users
to manually reset themself and get an increasingly
good item in return. Currently only the armor and
wing reset advance in options, meaning someone with
2 resets can get a wing with 2 options, someone
with 3 resets gets wing with 3 options, etc. Also
the total reset number is stored for top player
lists.


2. Functional ban system

The ban function allows for anyone with a GM
character to easily ban users. All they have to do
is enter their username, their GM character,
password and ofcourse the characters name who must
be banned and make it so...


3. PK clear function

PK clear is getting rather expensive now, since it
will cost users more and more for each PK clear.
Eventually this value can rise to over 100M zen!


4. Save stat points adder

Thats correct, a good 100% guarranteed save stats
point add script, completely written and debugged
by me - have been running this baby for over 4
months on my server and NEVER had anyone abuse it!


5. Active server status

keep your users informed of who's online, what are
the newest characters created, what are the highest
scoring guilds and even some direct info on the
server hardware - all only 1 click away from the
main page!


6. phpBB forum included

all you have to do is follow their instructions
(wich basicly say: create a database in your
SQL server named 'Forum' and run the installer)
and you too have a fully functional phpBB forum!


7. basic usefull info

included are a whole lot of event pages, server
data pages and rules that are pretty common for
any private server, even including client download
location and a basic installation guide - all can
be edited simply to match your own serverdata!


--------------------- Credits -----------------------

Creator: FragFrog
Part of some scripts: IO*
Artwork: Nathalie
SQL protector: john_d
Forum: the phpBB team
Inspiration: RageZone

[MentaL]

[Mitzi]

awesome webby and u added some great features over there
specialy the items that u get after the reset

Thanks. =)

[TakaShi^^]

^^Nice Website^^ u are becoming a website designer too ^^ Well Done !!!!!

[FragFrog]

only 1 config.php - but I suggest you check your webserver if you get a 'page cannot be displayed' error, since if you extract the index.php file and you link to that it should always at least give you some more detailed errors :)

[FragFrog]

admin ID and pass is the username and password of your SQL server, and extracting all the files in your webservers directory should be enough to at least show the main page. I have no experience with phpnuke, so I'm affraid you'll have to configure that yourself.

Also, for a good guide on setting up your webserver you can refer to http://forum.ragezone.com/showthread.php?t=32865

[FragFrog]

make sure you followed my guide on how to create an extra table called 'Reset', or it won't work :)

Also, you'll have to copy that config.php file to the 3 reset option folders (wing, armor and weapon), sorry, forgot to mention that. My bad :icon6:

[xtasy]

wow dis seems complicated >.<"

[Ambuhed]

FragFrog

hi brother
Can u make a php equal that but with normal reset script pliz?
i need and i dont know script php

i think isnt only me needing that

Thanks

[xtasy]

LoLs but can u ryt down da steps for me??


im a noob at dis >.<"

[FragFrog]

xtasy: I already did.. first, get your webserver running (follow the link I gave on how to do that, http://forum.ragezone.com/showthread.php?t=32865), then simply follow the installation guide :)

I admin this is a bit more difficult then some other packages. I also warned you for that directly in the beginning. If you have experience running a website, this should be a piece'a cake, if not, I strongly suggest you follow my installation notes to the letter.

If you're not sure how to edit things: use notepad. Leave the IP's as they are, 127.0.0.1 will do just fine. The SQL username, admin login, etc, are all the same, and by default 'sa' so you won't have to change anything for that, just the password wich you should have entered during installation of the SQL server.

[Ambuhed]

FragFrog

on total accounts i think is better u on the table Account Name and put something like censored a -
dont let it have the accounts name.

:P

[Ambuhed]

xtasy for u make your website for your server u need know php scripting
dont think on that lool

good luck

[xtasy]

lol wtf is dat??

[FragFrog]

Hmmm.. well, thats the beauty of this package: all you have to do is remove the <a href='accounts.php'> part in the news.php file and its gone... ;)

But I for one don't think it'll matter much... :)

[xtasy]

is dere a place where i can learn php scripting?

[Ambuhed]

hmm ok but can u do for me a script for the reset without rewards?
i need a with reset normal receiving points for reset and needing money to reset

that isnt only me needing i think pliz

make that...

[FragFrog]

is dere a place where i can learn php scripting?

You don't really need to.. I learned everything I did right here on the forum.. by looking at other people's packages.. And to get this website to work you don't even need to know how to... :)

[mati_jg]

FragFroh can u change reset method. i dont know php and i need "normal" reset method: simply reset char without extra items :)

[FragFrog]

ok, extract this package into your main directory, should give you reset without rewards - haven't tested it myself yet though!

TakaShi^^: I suggest you first try to get your webserver running following the guides here, this thread is only for questions concerning this specific package :)

[TakaShi^^]

Ok SImple Just FOllow Tis Guide Below by daemon_px

Ok guys, I'm doing this step by step, while I'm installing Appserv 2.4.0 (get it at Appserv ,this pack comes with Apache, PHP and MySQL.
In this guide I'm not using MySQL, as IO* PHP MU Web Center is designed to work with Microsoft SQL Server, and if people have trouble using it as it is, i wonder if I'd go around asking to change scripts.
Let's move on:

1. Installing Apache webserver & PHP Support:
Just follow on-screen instructions regarding where to Install, in the Setup Type, choose Custom.
Untick phpMyAdmin And MYSQL
Note: DUN UNTICK Apache and PHP.

Next, type in your server name: something like www.mydomain.com or just leave it as localhost.
If localhost is chosen, the webserver will work only locally.
Remember that you can't just come up with a servername, it has to be registered and working DNS.
You can get free DNS with "auto" update for dynamic IPs from http://www.no-ip.com or http://www.no-ip.com/ (I won't give any help on this, read the sites FAQ's).
Type in the server admin e-mail (probably it's your's), and the port where it sould be listening for conections. If possible, just leave it 80.
------------------- my config for this dialog ------------------------
server name: e-daemon.gotdns.org
server admin email: services.admin@e-daemon.gotdns.org
port: 80
----------------------------------------------------------------------------
Click next, and setup will finish.On the last dialog, let it start apache. No need to start MySQL, as it hasn't been installed.
Now, if you type your chosen server name (localhost or whatever) in your web browser, you'll get a wellcome page from AppServ.
- !!!!!!!!!!!!!!! Your webserver is now running !!!!!!!!!!!!!!!!!!
////////////////////////////////////**********************\\\\\\\\\\\\\\\\\\\\\\\\\\\\ \\\\
2. Configure PHP so it works with SQL (No more "Line 9 error")
I think this is where most people get in trouble, but that's just because they haven't read IO* readme that goes with the webpage files.
Let's open the php.ini file (it's in your windows dir - for me it's "C:\WINNT\php.ini" ). Use notepad to open it, disable word wrap, so you can check line numbers on the status bar.
*In line 576, where it reads
;extension=php_mssql.dll
take the leading ";"
Save the file, close, and restart Apache (If you haven't done it allready, bring up apache monitor - it's in your start menu\AppServ\Apache Control Server - it's easyer to stop/start apache this way).

Now you can extract the files from Website(FragFrog)New Package(Extract to C:appserv/www/here
3. Configure Webcenter and/or your SQL server so they work with each other
After extracting the files, let's open config.php in notepad.

===================In Config.PhP=================

<?php
//=========== FragFrog's MU WebCenter ===============
// Welcome to FrogMu's WebCenter, originally based on
// IO*'s files and editted and modified by FragFrog
//=========== FragFrog's Mu WebCenter ================

//============== USER EDITABLE AREA ===================
// Enter the username to connect to the db
$dbuser = "sa";

// Enter the password for the SQL Server
$dbpasswd = "";====>Change Tis to ur PassWord

//Admin Login
$alogin = ""; ===>U can use sa

//Admin Password
$apass = ""; ===>Change Tis to ur PassWord

========================================================
In Order to View it,It Should be as Example http://lala.no-ip.org/Website/
Change Lala.no-ip.org to ur dns name ^^ Ok after tis Done ^^

1)Open opties_reset.php And Change tis Lines

<center>
<a href='http://fragfrog.mine.nu/armor/reset.php'>ARMOR</a> &nbsp;
<a href='http://fragfrog.mine.nu/wing/reset.php'>WINGS</a> &nbsp;
<a href='http://fragfrog.mine.nu/weapon/reset.php'>WEAPON</a> &nbsp;
</center>

TO

<center>
<a href='http://youripaddress/armor/reset.php'>ARMOR</a> &nbsp;
<a href='http://youripaddress/wing/reset.php'>WINGS</a> &nbsp;
<a href='http://youripaddress/weapon/reset.php'>WEAPON</a> &nbsp;
</center>

2nd thing:Please copy config.php after u have edited it and paste in Weapon Folder,Wing Folder and Armour Folder which look like tis ===>Website\weapon,Website\wing,Website\armor
=========================================================
So I Should Look Like this

[U]Weapon Config.php[/U](C:\AppServ\www\Website\weapon)

// Enter the IP or DSN of the database server to connect to
// Change to your server IP (if remote only) works with DNS
$dbhost = "127.0.0.1";

// Enter the username to connect to the db
$dbuser = "sa";

// Enter the password for the SQL Server
$dbpasswd = "password";

//Admin Login
$alogin = "Admin";

//Admin Password
$apass = "password";

//Database Name
$db = 'MuOnline';

//Host. IP If working remotely
$host = '127.0.0.1';

$ip = "127.0.0.1";

$regsubmit = "regform.submit()";
$msconnect=mssql_connect("$host","$alogin","$apass");
$msdb=mssql_select_db("$db",$msconnect);


?>

-------------------------------------------------------------------------------------------------------
Armour Config.php(C:\AppServ\www\Website\armor)

// Enter the IP or DSN of the database server to connect to
// Change to your server IP (if remote only) works with DNS
$dbhost = "127.0.0.1";

// Enter the username to connect to the db
$dbuser = "sa";

// Enter the password for the SQL Server
$dbpasswd = "passwordhere";

//Admin Login
$alogin = "Admin";

//Admin Password
$apass = "passwordhere";

//Database Name
$db = 'MuOnline';

//Host. IP If working remotely
$host = '127.0.0.1';

$ip = "127.0.0.1";

$regsubmit = "regform.submit()";
$msconnect=mssql_connect("$host","$alogin","$apass");
$msdb=mssql_select_db("$db",$msconnect);


?>
==========================================================
Wing Config.php(C:\AppServ\www\Website\wing)

// Enter the IP or DSN of the database server to connect to
// Change to your server IP (if remote only) works with DNS
$dbhost = "127.0.0.1";

// Enter the username to connect to the db
$dbuser = "sa";

// Enter the password for the SQL Server
$dbpasswd = "passwordhere";

//Admin Login
$alogin = "Admin";

//Admin Password
$apass = "passwordhere";

//Database Name
$db = 'MuOnline';

//Host. IP If working remotely
$host = '127.0.0.1';

$ip = "127.0.0.1";

$regsubmit = "regform.submit()";
$msconnect=mssql_connect("$host","$alogin","$apass");
$msdb=mssql_select_db("$db",$msconnect);


?>

Forum Setup

If u wan simple forum go tis http://bb.hostaforumfree.com/new_forum.php

it easy and fast =)
=========================================================
All Credit Go to FragFroG

[FragFrog]

Wow, thanks TakaShi^^, I kind'a presumed everyone already had a working webserver.. ;)

[TakaShi^^]

Well,I love ur script very much with nice background,wat i wan to know about the script is
tat how do i change the resolutions to 800time 600 i cant see the lower part of it T_T

[Gelfdon]

Simplest way open ure index.php in a text editor and find this line <body scroll=no>, take out that scroll=no and that will bring back the scroll bar so u can scroll down the screen.

[Ambuhed]

fragfrog sorry but the package without reward dont add extra points and dont ask for money to reset.
can u make that to us?a package adding extra points and asking for money to reset?

[FragFrog]

For info on how to install your forum: http://www.phpbb.com/support/tutorials/

Concerning alternate reset pages: I suggest you search trough my code for the PK clear page (pk_clear_done.php if I remember correctly) on how to ask money for it, and the stats adder page for how to give stat points. Its all a simple matter of combining :)