[???]PLZ READ BEFOR POSTING

[[GM]Recover]

i would like to say i am sick and tired of these topic being repeated over and over
so here it is
Help with Query's


help with PHP with Query's


Now u want to start a Pserver follow banes guide on this might help


You looking for a Client use this almighty tool becuase you are tolazy to search



Also like to add Wamp server

now u need to add this add on

How to update wamp server after u installed it

hope i covered everything there
also use the 32 bit version

Map.ini editing it specifically for OI and GRB

PSM_Client\Bin\Data----->Map.ini---->Map 50 (GRB); CreateTime = (0, 15, 1)
0=Sunday,1=Monday,2=Tuesday,3=Wednesday,4=Thursday ,5=Friday,6=Staurdat
15= Time to start
PSM_Client\Bin\Data----->Map.ini---->Map 64 (OI);
MapType = F PvP map etc just look around
CreateTime = (0, 21, 24)(1, 21, 24)(2, 21, 24)(3, 21, 24)(4, 21, 24)(5, 21, 24)(6, 21, 24)
ExpireTime = 24
RebirthMapPos1 = 47, 509.47, 7.3, 1525.32 Light Spawn Point
RebirthMapPos2 = 47, 1404.15, 10.3, 308.92 Fury Spawn Point
Time is in 24 hour time
e.g
(Day,Time Start, Duration)


Good intentions of the post Bucky, but just to add a few things...

MSSQL Queries
- Used for getting information.
Example:

SELECT * FROM PS_GameData.dbo.Chars WHERE CharName='Tyler'

Would show all the data in the table, of the characters named Tyler.
- Used for updating/changing tables without opening the table itself.
Example:

UPDATE PS_GameData.dbo.Chars SET CharName='Imaloser' WHERE CharName='Tyler'

Would update the name of the character Tyler with Imaloser
- Used to remove information from tables. ALWAYS INCLUDE THE WHERE CLAUSE UNLESS YOU WANT ALL THE INFORMATION IN THE TABLE GONE.
Example:

DELETE FROM PS_GameData.dbo.Chars WHERE CharName='Tyler' AND Level=15

This would delete all entries of a Character named Tyler who is level 15. Not all level 15s, or not all characters named Tyler.

Actually... for learning SQL, just start , and read all the chapters / practice them then take the .

PHP Installation
If you use IIS (Internet Information Services) like I do, you need 2 things to make this easy. First, the PHP 5.2.17 ZIP Binaries from . Then you need the PHP Manager for IIS 7 from . Once you have those, register your extracted .zip folder of PHP to somewhere, such as C:\, and register it in IIS in the PHP Manager. Then go to extensions and enable php_mssql.dll. If you don't have it, you'll need to find/download it. Just google that one, there's tons of copies of it.

After you enable it, restart it to make sure everything works, though it should just be enabled without restart. Now to test to make sure everything works, make a simple PHP file (test.php ?) and put something like this inside.

<?php
if (function_exists('mssql_connect')) {
    echo "MSSQL functions are available.<br />\n";
} else {
    echo "MSSQL functions are not available.<br />\n";
}
?>

If it works, then brava, you were successful. If not, go back and double check. Use google to search for your error. I promise you, it's there. I searched on google to get it set up myself.

Useful PHP Functions
Well, a lot of PHP funtions are useful to you, but I'll show a few you should use. Also, I'd suggest learning SQL first, or at least before you learn the mssql functions of PHP.

Examples:

$User='Tyler';

Setting the $User variable to Tyler
- Used to connect to your database
Example:

mssql_connect('127.0.0.1', 'Shaiya', 'Shaiya123');

Pretty simple, would connect to your database, to allow queries to be ran.
- Used to run queries on the database.
Example:

mssql_query("UPDATE PS_UserData.dbo.Users_Master SET Point=(Point+{$Point}) WHERE UserID='{$User}'");

Would add the value of $Point onto the user stored in $User

Once you get those two down, you should study PHP projects already posted in the development section of this forum. Like Abrasive's register/pass change, my email registration, or Zargon's PHP scripts. Zargon/Abrasive's are how I learned at first.

As for people installing a website on the same machine you have Skype on, you need to tell Skype to not use port 80, here's how:
Just uncheck that box, click save and restart Skype.
Now plz give credits to tyler on this post
you think i missed something Post it and i will look into that


PS: dont post anything about shaiya NOVA
Ok guys you think you want to open a server read this make SURE you read this
I will be updating this when i get time
Name already In use

USE [PS_GameData]
GO
drop procedure [dbo].[usp_Save_Char_Item_Add_E]
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


/****** 개체: 저장 프로시저 dbo.usp_Save_Char_Item_Add_E ******/


CREATE Proc usp_Save_Char_Item_Add_E

@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality int,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '', 
@Count tinyint,
@MaketimeZ varchar(50),
@Maketype char(1)

AS
DECLARE @Maketime as datetime
SELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120)
--SET NOCOUNT ON

IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END

INSERT INTO CharItems
(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4, 
gem5, gem6, craftname, [count], maketime, maketype)
VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4, 
@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)

IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

--SET NOCOUNT OFF



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

Run that in a new query and execute.

Game.exes
EP3--
EP4--
EP4.5--
EP5--


Hmm.. Oh! Converting MSSQL based PHP files to ODBC!

Either google it, go to and look up the functions, or compare the following two files, and play spot the differences!

MSSQL:

ODBC:

Credits to Tyler for this last section

Guild Fix

Use PS_gamedata

drop table [dbo].[Guilds]

CREATE TABLE [dbo].[Guilds] (
	[RowID] [int] IDENTITY (1, 1) NOT NULL ,
	[GuildID] [int] NOT NULL ,
	[GuildName] [varchar] (30) COLLATE Latin1_General_CI_AS NOT NULL ,
	[MasterUserID] [varchar] (18) COLLATE Latin1_General_CI_AS NOT NULL ,
	[MasterCharID] [int] NOT NULL ,
	[MasterName] [varchar] (30) COLLATE Latin1_General_CI_AS NOT NULL ,
	[Country] [tinyint] NOT NULL ,
	[TotalCount] [smallint] NOT NULL ,
	[GuildPoint] [int] NOT NULL ,
	[Del] [tinyint] DEFAULT (0) ,
	[CreateDate] [datetime] (getdate())  ,
	[DeleteDate] [datetime] (getdate()) 
) ON [PRIMARY]

Friends Fix

 USE PS_GameData
drop table [dbo].[FriendChars];

CREATE TABLE [dbo].[FriendChars] (
	[RowID] [int] IDENTITY (1, 1) NOT NULL ,
	[CharID] [int] NOT NULL ,
	[FriendID] [int] NOT NULL ,
	[FriendName] [varchar] (30) COLLATE Latin1_General_CI_AS NOT NULL ,
	[Family] [tinyint] NOT NULL ,
	[Grow] [tinyint] NOT NULL ,
	[Job] [tinyint] NOT NULL ,
	[Memo] [varchar] (50) COLLATE Latin1_General_CI_AS NULL ,
	[Refuse] [tinyint] NULL ,
	[CreateDate] [datetime] NULL ,
	[RefuseDate] [datetime] NULL 
) ON [PRIMARY]

[Svinseladden]

i get this error: could not execute meny item (internal error).[exeption] could not perform service action: the server has not been started.

i did a local installment in my vps server. is that the right way?

at first it didnt go online. need a restart mabe?

[[GM]Recover]

make sure PORT 80 is not in use skype does it do

[RebeccaBlack]

Good intentions of the post Bucky, but just to add a few things...

MSSQL Queries
- Used for getting information.
Example:

SELECT * FROM PS_GameData.dbo.Chars WHERE CharName='Tyler'

Would show all the data in the table, of the characters named Tyler.
- Used for updating/changing tables without opening the table itself.
Example:

UPDATE PS_GameData.dbo.Chars SET CharName='Imaloser' WHERE CharName='Tyler'

Would update the name of the character Tyler with Imaloser
- Used to remove information from tables. ALWAYS INCLUDE THE WHERE CLAUSE UNLESS YOU WANT ALL THE INFORMATION IN THE TABLE GONE.
Example:

DELETE FROM PS_GameData.dbo.Chars WHERE CharName='Tyler' AND Level=15

This would delete all entries of a Character named Tyler who is level 15. Not all level 15s, or not all characters named Tyler.

Actually... for learning SQL, just start , and read all the chapters / practice them then take the .

PHP Installation
If you use IIS (Internet Information Services) like I do, you need 2 things to make this easy. First, the PHP 5.2.17 ZIP Binaries from . Then you need the PHP Manager for IIS 7 from . Once you have those, register your extracted .zip folder of PHP to somewhere, such as C:\, and register it in IIS in the PHP Manager. Then go to extensions and enable php_mssql.dll. If you don't have it, you'll need to find/download it. Just google that one, there's tons of copies of it.

After you enable it, restart it to make sure everything works, though it should just be enabled without restart. Now to test to make sure everything works, make a simple PHP file (test.php ?) and put something like this inside.

<?php
if (function_exists('mssql_connect')) {
    echo "MSSQL functions are available.<br />\n";
} else {
    echo "MSSQL functions are not available.<br />\n";
}
?>

If it works, then brava, you were successful. If not, go back and double check. Use google to search for your error. I promise you, it's there. I searched on google to get it set up myself.

Useful PHP Functions
Well, a lot of PHP funtions are useful to you, but I'll show a few you should use. Also, I'd suggest learning SQL first, or at least before you learn the mssql functions of PHP.

Examples:

$User='Tyler';

Setting the $User variable to Tyler
- Used to connect to your database
Example:

mssql_connect('127.0.0.1', 'Shaiya', 'Shaiya123');

Pretty simple, would connect to your database, to allow queries to be ran.
- Used to run queries on the database.
Example:

mssql_query("UPDATE PS_UserData.dbo.Users_Master SET Point=(Point+{$Point}) WHERE UserID='{$User}'");

Would add the value of $Point onto the user stored in $User

Once you get those two down, you should study PHP projects already posted in the development section of this forum. Like Abrasive's register/pass change, my email registration, or Zargon's PHP scripts. Zargon/Abrasive's are how I learned at first.

As for people installing a website on the same machine you have Skype on, you need to tell Skype to not use port 80, here's how:
Just uncheck that box, click save and restart Skype.

[[GM]Recover]

thanks tyler will add it to first post
credits given

[Svinseladden]

Originally Posted by tnelis

Good intentions of the post Bucky, but just to add a few things...

MSSQL Queries
- Used for getting information.
Example:

SELECT * FROM PS_GameData.dbo.Chars WHERE CharName='Tyler'

Would show all the data in the table, of the characters named Tyler.
- Used for updating/changing tables without opening the table itself.
Example:

UPDATE PS_GameData.dbo.Chars SET CharName='Imaloser' WHERE CharName='Tyler'

Would update the name of the character Tyler with Imaloser
- Used to remove information from tables. ALWAYS INCLUDE THE WHERE CLAUSE UNLESS YOU WANT ALL THE INFORMATION IN THE TABLE GONE.
Example:

DELETE FROM PS_GameData.dbo.Chars WHERE CharName='Tyler' AND Level=15

This would delete all entries of a Character named Tyler who is level 15. Not all level 15s, or not all characters named Tyler.

Actually... for learning SQL, just start , and read all the chapters / practice them then take the .

PHP Installation
If you use IIS (Internet Information Services) like I do, you need 2 things to make this easy. First, the PHP 5.2.17 ZIP Binaries from . Then you need the PHP Manager for IIS 7 from . Once you have those, register your extracted .zip folder of PHP to somewhere, such as C:\, and register it in IIS in the PHP Manager. Then go to extensions and enable php_mssql.dll. If you don't have it, you'll need to find/download it. Just google that one, there's tons of copies of it.

After you enable it, restart it to make sure everything works, though it should just be enabled without restart. Now to test to make sure everything works, make a simple PHP file (test.php ?) and put something like this inside.

<?php
if (function_exists('mssql_connect')) {
    echo "MSSQL functions are available.<br />\n";
} else {
    echo "MSSQL functions are not available.<br />\n";
}
?>

If it works, then brava, you were successful. If not, go back and double check. Use google to search for your error. I promise you, it's there. I searched on google to get it set up myself.

Useful PHP Functions
Well, a lot of PHP funtions are useful to you, but I'll show a few you should use. Also, I'd suggest learning SQL first, or at least before you learn the mssql functions of PHP.

Examples:

$User='Tyler';

Setting the $User variable to Tyler
- Used to connect to your database
Example:

mssql_connect('127.0.0.1', 'Shaiya', 'Shaiya123');

Pretty simple, would connect to your database, to allow queries to be ran.
- Used to run queries on the database.
Example:

mssql_query("UPDATE PS_UserData.dbo.Users_Master SET Point=(Point+{$Point}) WHERE UserID='{$User}'");

Would add the value of $Point onto the user stored in $User

Once you get those two down, you should study PHP projects already posted in the development section of this forum. Like Abrasive's register/pass change, my email registration, or Zargon's PHP scripts. Zargon/Abrasive's are how I learned at first.

As for people installing a website on the same machine you have Skype on, you need to tell Skype to not use port 80, here's how:
Just uncheck that box, click save and restart Skype.

i'm noob i know. i finaly have the php installed on my ssi7.5 server.

i have the noob question of a sentury ... now what? LOL i know. i learned sql give me a litle cred hahaha.

i have the register stuff i have the files. my server is not connected with the site. becouse the site is e free one. is it posible to make this work?

what do i have where and how can i edit php files?

got to lern and i lern when i do it. but when i have no idea on where to start i'm kind of stuck..

[RebeccaBlack]

Originally Posted by Svinseladden

i'm noob i know. i finaly have the php installed on my ssi7.5 server.

i have the noob question of a sentury ... now what? LOL i know. i learned sql give me a litle cred hahaha.

i have the register stuff i have the files. my server is not connected with the site. becouse the site is e free one. is it posible to make this work?

what do i have where and how can i edit php files?

got to lern and i lern when i do it. but when i have no idea on where to start i'm kind of stuck..

Noob no, just starting to learn. :P

You say the site is a free one, but it has PHP? If it has the full functionality of PHP, then yes, it'll work. You'll have to leave port 1433 open on your db server however.

Editing a PHP file is simple. PHP is simple a .txt file basically. Just open it in notepad. If I were you, I'd download , and use that to edit them, as it has made editing php files MUCH easier, for me at least.

[Bаne]

Wow this guide is getting big good job bucky!! and Tyler ._. .......

Oh and this was my 1K post

[RebeccaBlack]

This should be used for every question before it's to be asked. <.<

[[GM]Recover]

Originally Posted by [GM]Bane

Wow this guide is getting big good job bucky!! and Tyler ._. .......

Oh and this was my 1K post

woot gratz on your 1k post if you think anything else needs to be added plz post it i am willing to add it

[[GM]Recover]

BUMB

[[GM]Recover]

#updated
+BUMP

[[GM]Recover]

#Updated
Bump

[RebeccaBlack]

Originally Posted by Shaiyatoplist

Game.exes
EP4--
EP4.5--
EP5--
atm thats the main 1's i will hopefully find the Ep3 1 soon

My server is run off EP4 game.exe, plus there are the game.exes you should use on the forums

[[GM]Recover]

thanks i will fix it ASAP