Revox Project By RevolutionTeam

[Ghost Informatics]

Introduction

After a lot of requests about Rappelz cashshop We decided to make a public one free to use by everyone .

Revox Project is a shop written by our team with PHP,SQLSRV,MySQL Also we used free bootstrap templates from google.

The shop come with Admin Portal (you can delete it) also it work from inside the game only , You need to install MySQL server (I will not go into details)
also you need to install PHP with SQLSRV Drivers .

Note* The shop works only with our databases that released with 9.4 files i wont help any one or answer anyone who not using our Databases because it wont work at all .




The Intallation
First you need to excute this SQL Query in your SQLServer to make the shop smp

http://room.rappelz.ae/Files/smp.txt

After setting the MySQL server you need to open the SQL folder that included with the Shop archive and excute the sql files inside the MySQL server using Navicat , Then You need to edit the Config.php and the Admin/Config.php, Put all your correct MySQL & SQLserver connection information.

• When you add a new item the item goes to the MySQL database,
• When the player buy a new item the item will go to the BILLING database,
• The point table is inside the Auth database ,

Also we used the ajax inside the admin portal so you can select items easily what you need to do is just write the first 3 words from the item or player name .
Inside the images folder you'll find jpg archive file you need to extract it because this is the icons folder.
All the charge functions are working and tested everything is tested many times , You can add auto charge by paypal (when the player pay the point will come Automatically to his account).

When you add a new item the shop will ask you for a description if you left it empty the shop will import the details from the stringresource table
also there's a random item option in the admin portal this option will allow you to add offer with random rate for example God Mother Fairy's Bottle if you bought the offer you will get a random number 200 or 500 or 1000 you can select the counts from the Admin portal.

The shop is fully clean from any bugs but if you found anything wrong let me know so i can fix it .

Also the shop is contain our copyrights , We worked for a days to provide this shop for you for free but you can buy one from any Amateur programmer for more than 100$ without copyrights but all what we asks for is don't delete the copyrights.

If you didn't know how to set up the iis drivers check this post ~HERE~

Some Screens from the shop

 Spoiler

Download

Download on GitHub

https://github.com/ham999dy/Revox-Project

[Wael™]

omg xD Ghost you are the best
i send you a msg take a look at it
thx <3

[Min@to]

OMG
Thank's a Lot for providing the files for the Shop...

***///\\\***

Hello,
if u try to execute this SQL Query in your SQLServer to make the shop smp and get that Problem :

u need just to Add " GO " After this line :

PHP Code:

use [Telecaster] 


now u'r problem is Fixed :

i Get that message :

PHP Code:

Msg 2714, Level 16, State 3, Procedure shop_login, Line 7
There is already an object named 'shop_login' in the database. 


'cuz i'm already Executed SQLQuery...

Cy@

[Ghost Informatics]

Originally Posted by Min@to

OMG
Thank's a Lot for providing the files for the Shop...

***///\\\***

Hello,
if u try to execute this SQL Query in your SQLServer to make the shop smp and get that Problem :

u need just to Add " GO " After this line :

PHP Code:

use [Telecaster] 


now u'r problem is Fixed :

i Get that message :

PHP Code:

Msg 2714, Level 16, State 3, Procedure shop_login, Line 7
There is already an object named 'shop_login' in the database. 


'cuz i'm already Executed SQLQuery...

Cy@

It's simple , Just replace the CREATE with ALTER so it will be like this

ALTER procedure [dbo].[shop_login]


and do it one time only.

[Min@to]

i try it the Store into my localhost but i get that Message : [200]The System has some error, Please contact with Administrator!

N.B : I'm using the Db's from u'r Files 9.4

[Ghost Informatics]

Originally Posted by Min@to

i try it the Store into my localhost but i get that Message : [200]The System has some error, Please contact with Administrator!

N.B : I'm using the Db's from u'r Files 9.4

Open your config and set the error display to true , And make sure that you have installed the sqlsrv drivers also make sure your connection information for the sql server & MySQL is correct after you set the display errors to true let me know the result

[Min@to]

Originally Posted by Ghost Informatics

Open your config and set the error display to true , And make sure that you have installed the sqlsrv drivers also make sure your connection information for the sql server & MySQL is correct after you set the display errors to true let me know the result

I did what u say but it's Still the same :/

IMG's :

[Ghost Informatics]

Originally Posted by Min@to

I did what u say but it's Still the same :/

IMG's :

http://i.epvpimg.com/UL1Naab.png

http://i.epvpimg.com/Msw7bab.png

http://i.epvpimg.com/HN2lgab.png

I know your problem, you need to turn on the PDO MySQLi and PDO SQLSRV

[Min@to]

Originally Posted by Ghost Informatics

I know your problem, you need to turn on the PDO MySQLi and PDO SQLSRV

How can i turn it on ?!!

[Ghost Informatics]

Originally Posted by Min@to

How can i turn it on ?!!

You need to download the DLL drivers if your php version is 7 for example you need php_pdo_mysqli_*.dll for php 7 and php_pdo_sqlsrv_*.dll for php7

this links maybe help you

https://docs.microsoft.com/en-us/sql...php-sql-driver

https://stackoverflow.com/questions/...erv-on-windows

Working with PDO extensions on IIS | IIS Aid

[アルカード]

thanks for your release,keep it going!!! <3

[InkDevil]

#Added to Collection-Thread in "Server File" Section...because I'm unsure where else it would fit better. (guess nobody would search in "scripts")
Anyway, looks nice

[Min@to]

Originally Posted by Ghost Informatics

You need to download the DLL drivers if your php version is 7 for example you need php_pdo_mysqli_*.dll for php 7 and php_pdo_sqlsrv_*.dll for php7

this links maybe help you

Ghost Thank's a lot, Now everything is working perfectly :

Again thank you

**//\\**

i have one more question : how can i add the store to the client...

[ThunderNikk]

It is a setting in your gameserver.opt

S game.url_list:guild_icon_upload.ip|10.71.1.2|guild_icon_upload.port|4615|guild.url|http://10.71.1.2:80/|guild_test_download.url|gicons/|web_download|10.71.1.2|web_download_port|0|shop.url|http://10.71.1.2:80/item_shop/

Make sure to set it for your stuff.

I'm still stuck on the PHP driver stuff not working for me yet

[thefear511]

Originally Posted by Min@to

Ghost Thank's a lot, Now everything is working perfectly :

Again thank you

**//\\**

i have one more question : how can i add the store to the client...

change the link of cash shop in gameserver.opt to the desired cash shop.