• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

[Share] 5jms from bK2483 Edited from me.

Initiate Mage
Joined
Mar 14, 2008
Messages
1
Reaction score
0
Re: 5jms from bK2483 Edited from me.

how to customize my server status...??


my server is offline but the server status in CP is online..

is there a guide to change it?? help me ... thnx
 
Initiate Mage
Joined
Oct 1, 2008
Messages
4
Reaction score
0
Re: 5jms from bK2483 Edited from me.

Sir If My Sql User and Pass is Windows authincation(dunnu spelling) what should i put?
 
Newbie Spellweaver
Joined
Mar 3, 2006
Messages
8
Reaction score
0
Re: 5jms from bK2483 Edited from me.

Thank you very mouch

It's Work
 
Newbie Spellweaver
Joined
Mar 22, 2008
Messages
45
Reaction score
0
Re: 5jms from bK2483 Edited from me.

how about for the topup.php sir the one that using code how to make it work?
 
Experienced Elementalist
Joined
Apr 8, 2008
Messages
298
Reaction score
26
Re: 5jms from bK2483 Edited from me.

i succesfully installed your rancp but my only problem is registration converting the password to md5 encrypt its doesn't work. its not encrypt even its set to md5 encryption.

i also try this bodyid2 varchar(50) null its doesn't work. plz help me on this.....
 
Experienced Elementalist
Joined
Apr 8, 2008
Messages
298
Reaction score
26
Re: 5jms from bK2483 Edited from me.

Thanx for this rancp but i have one problem i hope you can help me and i cant find in any thread the answer....... I successfully install this rancp with one problem the password is not converted to md5 encryption and i cant find the trigger thats been posted here.. On how to convert the password to md5.
The settings in admincp is yes to md5 encrypt....... I was unable to upload ss due to upload error...


here is the bk2483 rancp edited by me.

this rancp is for ep3 mix ep4 server!

files :

rancp file :
update 23-11-2008
ranshop db for sql 2k :
ranshop db for sql 2k5 :
my own php file for abyss web server :

guide :

new installation

***remember to use abyss or xampp.
***remember!!! You must use the sir ianz ranshop db to make your itemshop/item mall working.

1.) extract the rancp file and put your in your webserver htdoc directory
2.) name the folder to rancp or any name you want.
2.) now go to
3.) just follow step by step.

step 1 - choose mssql or odbc (choose mssql, odbc is not configured yet)
step 2 - now put the correct info. And example shown below.

Code:
local host : 127.0.0.1 (leave as it is)
Code:
[b]*sql server host : Computername\sqlexpress (change computername to yours or put your server ip for sql 2000)[/b]
[b]database user : Sa[/b]
[b]database password : 1234 (change to your pass)[/b]
[b]*ran online database : Ranuser (leave as it is)[/b]

step 3 - enter the infos
step 4 - same

once your done installing it then go here

then you done.

after that, you must deleted the install folder.

if you get this error "web database loading failed! Error #118" then

add this column to your ranuser.dbo.web.

reset_stat, varchar(50) , null
reset_skill, varchar(50) , null
reset_quest, varchar(50) , null

or use this sql script run or execute

Code:
use [ranuser]
Code:
[b]alter table web add reset_stat varchar(50) null[/b]
[b]alter table web add reset_skill varchar(50) null[/b]
[b]alter table web add reset_quest varchar(50) null[/b]

if your having registration problems be sure to add this column to your fulluserinfo table

bodyid2, varchar(50) null

or run the query below

Code:
use [ranuser]
Code:
[b]alter table fulluserinfo add bodyid2 varchar(50) null[/b]

make new table on ranuser and name it to topup
add column name
- code varchar 20 no null
- codevalue int 4 null

itemshop instruction
set productnum to identity = yes.
(see this picture for example)
View attachment 62392

**im sorry, at the copyright bar, i already change to my copyright because i just copy my rancp to share to you all...
you can change if you wan.
credit to :
- bk2483 - rancp
- mike915 - help to fix itemshop
- ianz - ran db
 
Experienced Elementalist
Joined
Apr 8, 2008
Messages
298
Reaction score
26
Re: 5jms from bK2483 Edited from me.

we have same problem admin log-in works but normal doesn't work. registration is successful but when you check it on sql user info it doesnt convert the password to md5 maybe thats the reason why we cant log in in normal.....

is it normal that I can't login there? You said its a beta I don't know if its normal when I click login the page refreshs but nothing happens at all (I mean on normal log in, admin log in works)

besides its not tamper data protected
 
Newbie Spellweaver
Joined
Feb 14, 2009
Messages
95
Reaction score
0
Re: 5jms from bK2483 Edited from me.

when i login
it said:

Connection with SQL Server failed! Error #119
 
Experienced Elementalist
Joined
Apr 8, 2008
Messages
298
Reaction score
26
Re: 5jms from bK2483 Edited from me.

Here is the bK2483 RANCP edited by me.

This RANCP is For EP3 Mix EP4 server!

Files :

RANCP File :
Update 23-11-2008
RanShop db for SQL 2k :
RanShop db for SQL 2k5 :
My Own PHP File for Abyss Web Server :

Guide :

New Installation

***Remember to use Abyss or Xampp.
***Remember!!! You must use the Sir IaNz RanShop db to make your itemshop/item mall working.

1.) Extract the RANCP File and put your in your webserver htdoc directory
2.) Name the folder to rancp or any name you want.
2.) Now go to
3.) Just Follow step by step.

Step 1 - Choose Mssql or ODBC (Choose Mssql, ODBC is not configured yet)
Step 2 - Now put the correct info. And example shown below.

Code:
Local Host : 127.0.0.1 (Leave As it is)
Code:
[B]*SQL Server Host : COMPUTERNAME\SQLEXPRESS (Change COMPUTERNAME to yours or put your Server IP for SQL 2000)[/B]
[B]Database User : sa[/B]
[B]Database Password : 1234 (Change to your pass)[/B]
[B]*Ran Online Database : RanUser (Leave As it is)[/B]

Step 3 - Enter the Infos
Step 4 - Same

Once your done installing it then go here

Then You Done.

After that, you must deleted the install folder.

If you get this error "Web database loading failed! Error #118" then

Add this column to your RanUser.dbo.Web.

reset_stat, varchar(50) , NULL
reset_skill, varchar(50) , NULL
reset_quest, varchar(50) , NULL

or Use this sql script run or execute

Code:
Use [RanUser]
Code:
[B]alter table Web add reset_stat varchar(50) null[/B]
[B]alter table Web add reset_skill varchar(50) null[/B]
[B]alter table Web add reset_quest varchar(50) null[/B]

If your having registration problems be sure to add this column to your FullUserInfo table

BodyID2, varchar(50) NULL

or run the query below

Code:
Use [RanUser]
Code:
[B]alter table FullUserInfo add BodyID2 varchar(50) NULL[/B]

Make new table on RanUser and name it to TopUp
add Column name
- Code Varchar 20 No Null
- CodeValue Int 4 Null

ITEMSHOP INSTRUCTION
Set ProductNUm to identity = yes.
(See this picture for example)
View attachment 62392

**Im sorry, at the copyright bar, i already change to my copyright because i just copy my rancp to share to you all...
you can change if you wan.
Credit to :
- bK2483 - RANCP
- mike915 - Help to fix itemshop
- IaNz - RAN db


how to change the identity setting of itemimage to yes it seems theres no option even i type on the cplumn nothings happen, btw, why i cant log-in in control panel with normal password i must used md5 hash to log-in in cp......
 
Newbie Spellweaver
Joined
Nov 30, 2006
Messages
98
Reaction score
0
Re: 5jms from bK2483 Edited from me.

can anyone share the working gold2ep or the stats2ep because the one shared has many bugs like able to exchange even without character. and can convert but the money or the stats of the player will be negative when exchanging. and also able to exchange even if the char is online that can cause bug.
 
Junior Spellweaver
Joined
Aug 2, 2009
Messages
155
Reaction score
13
Re: 5jms from bK2483 Edited from me.

Error #122
Loading php_gd2.dll Falied!
Please Enable php_gd2.dll in ur php.ini

help me!! please
 
Newbie Spellweaver
Joined
Apr 12, 2009
Messages
17
Reaction score
0
Re: Sir error

Error #122
Loading php_gd2.dll Falied!
Please Enable php_gd2.dll in ur php.ini



guys pls help to this error...
 
Newbie Spellweaver
Joined
May 31, 2008
Messages
26
Reaction score
0
Re: 5jms from bK2483 Edited from me.

when i go 2 this link

Nothing Happen (its not working?)
 
Newbie Spellweaver
Joined
Sep 6, 2010
Messages
18
Reaction score
0
Re: 5jms from bK2483 Edited from me.

HELP NAMN PO OK NAMN PO YUNG SA SESSION SERVER KAPAG INOOPEN KO NA SYA SAKA YUNG LAUNCHER PAG OPEN KO NAKAKA CONNECT NAMN KASU NGA LANG SA CLIENT HND PA NATATAPOS MAG LOADING ETO NA LUMALABAS OH:

FILE:D\BATTLERAN\Battleran\Data\Glogic\comment.ini.SECTION:itemdef,KEY:ITEMTYPE,It was wrong size of input data
 
Newbie Spellweaver
Joined
Oct 5, 2008
Messages
26
Reaction score
0
Re: 5jms from bK2483 Edited from me.

@asakd01
1. check the config.php settings
2. check your web server (xammp or abyss) if is running


@friend2jeff
post in English and your problem it seems to be comment.ini incompatible with your server and client side.
 
Last edited:
Junior Spellweaver
Joined
May 29, 2009
Messages
187
Reaction score
6
Re: 5jms from bK2483 Edited from me.

@ramispo:
ERROR#122
Error #122Loading php_gd2.dll Falied!
Please Enable php_gd2.dll in ur php.ini


how to fix this sir? ;php_gd2.dll
jst remove this ;
in ur php.ini
then ur done
 
Newbie Spellweaver
Joined
Dec 13, 2009
Messages
79
Reaction score
1
sir where can i find RanUser.dbo.Web ?
I have an error "Connection with SQL Server failed! Error #119" .huhuhu .can someone help me with this ? .
 
Back
Top