Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Mod. Rancp for ep4

Joined
Feb 16, 2007
Messages
30
Reaction score
2
this is my modified rancp for episode 4 server
original cp of cmed and some ragezoner script

NOTE: this ran cp is not tested online

--------------------------------------------
DOWNLOAD RANCP FOR EP4
--------------------------------------------



for ep3 user please download
the attachment below

--------------------------------------------
SCREENSHOTS
--------------------------------------------






--------------------------------------------
here are some feature inside:
--------------------------------------------

USER SECTION

CHANGE TO NEW CLASS <--- by: austhistikated
TOPUP <----------------- by: jolin
SCHOOL CHANGE <--------- by: I3663I
WIPE INVENTORY <-------- by: delzondamk2
STAT RESET <------------ by: lucian0127
REBORN <---------------- by: bk2483

ADMIN SECTION

VIEW CODES <------------ by: reinfrooze
CODE GENERATOR <-------- by: reinfrooze
ITEM MAp <-------------- by: lucian0127
ADD ITEM <-------------- by: lucian0127
DELETE ITEM <----------- by: lucian0127
STATUS <--------------------- by: sicksand
and others.

-------------------------------------------
DATABASE SETUP
-------------------------------------------
NOTE: you dont have to add or edit if you
already have this in your database.

------[step 1]------------------------------
Create a new table at your RanUser database :
Name : TopUp
Columns :
Code, VarChar(20) No NULLs
CodeValue, int NULLs
------[step 2]------------------------------
Add itemList in your ShopItemMap table
put Binding value of 1
then save
------[step 3]------------------------------
Add this ChaReborn to ChaInfo
Column Name: ChaReborn
Type: int
Default Value: 0
NO NULLS
--------------------------------------------

im not a php coder, i just love to "butingting" everything
if you found your script here please pm me and i will
add your name to credits...
 

Attachments

You must be registered for see attachments list
Last edited:
Elite Diviner
Joined
Nov 10, 2007
Messages
407
Reaction score
3
This is working fine in my abyss but i encountered an error when i used my xampp

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\ran\function.php on line 40
 
Upvote 0
Exploring The World
Joined
Apr 21, 2008
Messages
452
Reaction score
54
how to use the admin pannel of this cp...and how can make top code of this cp?...
 
Upvote 0
Joined
Feb 16, 2007
Messages
30
Reaction score
2
This is working fine in my abyss but i encountered an error when i used my xampp

Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\ran\function.php on line 40

have you try to uninstall your abyss, php, and zend ?. cause xampp have their own php4 and zend. maybe thats the reason why you cant connect to sql

@LabTech

just login as gm account
 
Upvote 0
Elite Diviner
Joined
Nov 10, 2007
Messages
407
Reaction score
3
@LabTech

make a new table under RanUser and name it as TopUp. now right click the dbo.TopUp and select design. on the first row, put Code, varchar(20), NO NULLS respectively and on the second row, put CodeValue, int, ALLOW NULLS

@delzondamk2

I already fixed it bro. Thanks

BTW how can I put a restriction to the admin panel? For example, only accounts with usertype 32 can access it while accounts below it will not. This is to restrict my game moderator from accessing it and to avoid top up issues
 
Upvote 0
Exploring The World
Joined
Apr 21, 2008
Messages
452
Reaction score
54
how to make top up code via this cp..and how to acces the admin panel?..
 
Upvote 0
Joined
Feb 16, 2007
Messages
30
Reaction score
2
how to make top up code via this cp..and how to acces the admin panel?..

if you login as GM account = user type 19 or above you can acces the admin section by clicking the ADMIN ONLY button in the lower part of homepage inside the admin section VIEW CODES there you can see the EP-CODE if you dont have EP-CODES click the GENERATE CODES and generate your EP there. then go back to VIEW CODES, copy the codes, go back to homepage, click TOPUP NOW, enter username, enter the codes you copied and holla!!

BTW you can change the usertype 19 to what ever user type you want just locate this in your viewcode.php

if($UserType>19){

19 means 19 is the minimum you can hange it to 30, 31 etc...
 
Upvote 0
Exploring The World
Joined
Apr 21, 2008
Messages
452
Reaction score
54
what is this error?when i go to admin panel this error comes out

this erro comes out at view code

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'TopUp'. (severity 16) in C:\xampp\htdocs\ran\page\viewcodes.php on line 143

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\ran\page\viewcodes.php on line 143

Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\ran\page\viewcodes.php on line 145

and this error comes in itemlist

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'ItemList'. (severity 16) in C:\xampp\htdocs\ran\page\imapping.php on line 150

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'ItemList'. (severity 16) in C:\xampp\htdocs\ran\page\imapping.php on line 150

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\ran\page\imapping.php on line 150

Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\ran\page\imapping.php on line 152

how to fix that error...can you help me

and is this sql injection protected?...
 
Upvote 0
Joined
Feb 16, 2007
Messages
30
Reaction score
2
what is this error?when i go to admin panel this error comes out

this erro comes out at view code

Warning: mssql_query() [function.mssql-query]: message: Invalid object name 'TopUp'. (severity 16) in C:\xampp\htdocs\ran\page\viewcodes.php on line 143

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\ran\page\viewcodes.php on line 143

Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\ran\page\viewcodes.php on line 145

and this error comes in itemlist

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'ItemList'. (severity 16) in C:\xampp\htdocs\ran\page\imapping.php on line 150

Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'ItemList'. (severity 16) in C:\xampp\htdocs\ran\page\imapping.php on line 150

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\ran\page\imapping.php on line 150

Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in C:\xampp\htdocs\ran\page\imapping.php on line 152

how to fix that error...can you help me

and is this sql injection protected?...

did you replace you DB's and your webserver? if not just follow this step and your done

-------------------------------------------
DATABASE SETUP
-------------------------------------------
NOTE: you dont have to add or edit if you
already have this in your database.

------[step 1]------------------------------
Create a new table at your RanUser database :
Name : TopUp
Columns :
Code, VarChar(20) No NULLs
CodeValue, int NULLs
------[step 2]------------------------------
Add itemList in your ShopItemMap table
put Binding value of 1
then save
------[step 3]------------------------------
Add this ChaReborn to ChaInfo
Column Name: ChaReborn
Type: int
Default Value: 0
NO NULLS
--------------------------------------------
 
Upvote 0
Back
Top