[???]PLZ READ BEFOR POSTING

Page 1 of 2

06/07/2011 15:36 [GM]Recover#1

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
[Only registered and activated users can see links. Click Here To Register...]

help with PHP with Query's
[Only registered and activated users can see links. Click Here To Register...]

Now u want to start a Pserver follow banes guide on this might help
[Only registered and activated users can see links. Click Here To Register...]

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

[Only registered and activated users can see links. Click Here To Register...]

Also like to add Wamp server
[Only registered and activated users can see links. Click Here To Register...]
now u need to add this add on
[Only registered and activated users can see links. Click Here To Register...]
How to update wamp server after u installed it
[Only registered and activated users can see links. Click Here To Register...]
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
[Only registered and activated users can see links. Click Here To Register...] - Used for getting information.
Example:

Code:

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

Would show all the data in the table, of the characters named Tyler.
[Only registered and activated users can see links. Click Here To Register...] - Used for updating/changing tables without opening the table itself.
Example:

Code:

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

Would update the name of the character Tyler with Imaloser
[Only registered and activated users can see links. Click Here To Register...] - Used to remove information from tables. ALWAYS INCLUDE THE WHERE CLAUSE UNLESS YOU WANT ALL THE INFORMATION IN THE TABLE GONE.
Example:

Code:

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 [Only registered and activated users can see links. Click Here To Register...], and read all the chapters / practice them then take the [Only registered and activated users can see links. Click Here To Register...]. :cool:

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 [Only registered and activated users can see links. Click Here To Register...]. Then you need the PHP Manager for IIS 7 from [Only registered and activated users can see links. Click Here To Register...]. 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.

Code:

<?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.
[Only registered and activated users can see links. Click Here To Register...]
Examples:

Code:

$User='Tyler';

Setting the $User variable to Tyler
[Only registered and activated users can see links. Click Here To Register...] - Used to connect to your database
Example:

Code:

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

Pretty simple, would connect to your database, to allow queries to be ran.
[Only registered and activated users can see links. Click Here To Register...] - Used to run queries on the database.
Example:

Code:

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: [Only registered and activated users can see links. Click Here To Register...]
Just uncheck that box, click save and restart Skype.
Now plz give credits to tyler on this post [Only registered and activated users can see links. Click Here To Register...]
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 [Only registered and activated users can see links. Click Here To Register...]
I will be updating this when i get time
Name already In use

Code:

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-- [Only registered and activated users can see links. Click Here To Register...]
EP4-- [Only registered and activated users can see links. Click Here To Register...]
EP4.5-- [Only registered and activated users can see links. Click Here To Register...]
EP5-- [Only registered and activated users can see links. Click Here To Register...]

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

Either google it, go to [Only registered and activated users can see links. Click Here To Register...] and look up the functions, or compare the following two files, and play spot the differences!

MSSQL:
[Only registered and activated users can see links. Click Here To Register...]
ODBC:
[Only registered and activated users can see links. Click Here To Register...]
Credits to Tyler for this last section

Guild Fix

Code:

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

Code:

 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]

06/07/2011 17:06 Svinseladden#2

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?

06/08/2011 00:04 [GM]Recover#3

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

06/08/2011 06:38 RebeccaBlack#4

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

MSSQL Queries
[Only registered and activated users can see links. Click Here To Register...] - Used for getting information.
Example:

Code:

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

Code:

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

Code:

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

Code:

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

Code:

$User='Tyler';

Setting the $User variable to Tyler
[Only registered and activated users can see links. Click Here To Register...] - Used to connect to your database
Example:

Code:

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

Code:

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

06/08/2011 07:33 [GM]Recover#5

thanks tyler will add it to first post
credits given

06/08/2011 10:24 Svinseladden#6

Quote:
Originally Posted by tnelis
Good intentions of the post Bucky, but just to add a few things...

MSSQL Queries
[Only registered and activated users can see links. Click Here To Register...] - Used for getting information.
Example:
Code:
SELECT * FROM PS_GameData.dbo.Chars WHERE CharName='Tyler'
Would show all the data in the table, of the characters named Tyler.
[Only registered and activated users can see links. Click Here To Register...] - Used for updating/changing tables without opening the table itself.
Example:
Code:
UPDATE PS_GameData.dbo.Chars SET CharName='Imaloser' WHERE CharName='Tyler'
Would update the name of the character Tyler with Imaloser
[Only registered and activated users can see links. Click Here To Register...] - Used to remove information from tables. ALWAYS INCLUDE THE WHERE CLAUSE UNLESS YOU WANT ALL THE INFORMATION IN THE TABLE GONE.
Example:
Code:
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 [Only registered and activated users can see links. Click Here To Register...], and read all the chapters / practice them then take the [Only registered and activated users can see links. Click Here To Register...]. :cool:

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 [Only registered and activated users can see links. Click Here To Register...]. Then you need the PHP Manager for IIS 7 from [Only registered and activated users can see links. Click Here To Register...]. 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.
Code:
<?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.
[Only registered and activated users can see links. Click Here To Register...]
Examples:
Code:
$User='Tyler';
Setting the $User variable to Tyler
[Only registered and activated users can see links. Click Here To Register...] - Used to connect to your database
Example:
Code:
mssql_connect('127.0.0.1', 'Shaiya', 'Shaiya123');
Pretty simple, would connect to your database, to allow queries to be ran.
[Only registered and activated users can see links. Click Here To Register...] - Used to run queries on the database.
Example:
Code:
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: [Only registered and activated users can see links. Click Here To Register...]
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..

06/10/2011 22:33 RebeccaBlack#7

Quote:

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 [Only registered and activated users can see links. Click Here To Register...], and use that to edit them, as it has made editing php files MUCH easier, for me at least.

06/12/2011 16:43 Bаne#8

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

Oh and this was my 1K post :awesome:

06/18/2011 04:05 RebeccaBlack#9

[Only registered and activated users can see links. Click Here To Register...]

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

06/18/2011 06:01 [GM]Recover#10

Quote:

Originally Posted by [GM]Bane

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

Oh and this was my 1K post :awesome:

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

06/21/2011 13:13 [GM]Recover#11

BUMB

06/24/2011 10:10 [GM]Recover#12

#updated
+BUMP

07/11/2011 01:56 [GM]Recover#13

#Updated
Bump

07/11/2011 07:58 RebeccaBlack#14

Quote:

Originally Posted by Shaiyatoplist

Game.exes
EP4-- [Only registered and activated users can see links. Click Here To Register...]
EP4.5-- [Only registered and activated users can see links. Click Here To Register...]
EP5-- [Only registered and activated users can see links. Click Here To Register...]
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

07/11/2011 08:25 [GM]Recover#15

thanks i will fix it ASAP

Page 1 of 2