Revox Project By RevolutionTeam

[ThunderNikk]

OK 77 is where it is executing the query and the execute is causing the error.

See the line before it? It is defining the query.

See the variables? $dbname and $table

Now you have to look elsewhere in the files for where those values were defined...

Or at least know what you put into the databases for the cash shop to run off from and that might give you an idea where the cash shop table is that it is editing.

[spaaamy]

************
problem with login solved - shame on me!!!
i used "set open.game_external 1" instead of "set game.open_external 1"

************



hey there.

i have a working 9.52 server just for friends, all fine...untill yesterday
as i read few posts before, the store should be working there also.

i'm running the server on a synology ds918+
- sql express 2019 in docker
- win 7pro for severfiles and mysql on a virtual machine
- vpn-server

things i've done for the store:
- executed sql
- importet the mysql-files to xampp
- installed odbc-drivers(v17) and php-extensions (php 7.4)
- i can login to the admin panel ->
-- i can add items
- i cant open the store by browser -> -> "Please Open inside Client!" <- its not really important for me

but my problem is, no client can connect anymore.
sometimes there is a message inside auth server window "invalid message form ip:xxxx (random id and numbers)"

inside sql in the RevoSite-table-dbo.maintenance the 1 for live is set.

things i've change inside my gameserver.opt:
- S:game.url_list:guild.url....

my gameserver.opt:

 Spoiler

S:app.name:GameServer
N:auth.server_idx:1
S:auth.server_name:TortusAlive
#S:auth.server_name:Under maintenance
S:db.c.name:Arcadia
S:db.c._password:
S:db.c.account:rappelz
S:db.c.server:192.168.0.100
S:db.user._password:
S:db.user.account:rappelz
S:db.user.name:Telecaster
S:db.user.server:192.168.0.100
N:game.AdultServer:00
S:game.allowed_special_char:@.
S:console._password:
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
N:game.cash_usable_server:1
F:game.chaos_drop_rate:1.000000
#N:game.ela_count:40
#F:game.exp_rate:30
F:game.exp_rate:1.015
F:game.gold_drop_rate:49
F:game.mod:0.200000
#F:game.item_drop_rate:32
F:game.item_drop_rate:10
#N:game.local_flag:8192
N:game.local_flag:4
N:io.use_message_statistics:0
N:game.pcbang_bonus_server:0
F:game.premium_pcbang_bonus_rate:1.000000
F:game.premium_pcbang_chaos_bonus_rate:0.100000
N:game.max_level:200
N:game.PKServer:1
F:game.pvp_damage_rate_for_player:0.01
F:game.pvp_damage_rate_for_summon:0.035
N:game.use_auto_trap:0
N:game.use_auto_jail:0
N:game.use_delete_security:0
N:game.use_guild_donation_point:0
N:game.use_play_point:0
N:game.use_security:0
N:CodePage:1256
N:game.ServiceServer:1
S:game.guild_icon_base_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.resource:Resource
S:game.server_screenshot_url:
N:game.update.version:17
S:game.url_list:guild.url:|
N:game.version:20180117

S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
S:io.ip_address:192.168.0.151
#S:io.ip_address:54.38.164.109
N:io.port:34391
T:game.enhance_fail_type:2
S:io.user_count_ip_mask:192.168.0.151
S:log.ip:192.168.0.151
S:log.working:1
S:io.upload.ip:192.168.0.151
S:io.upload.port:4617
S:upload.server_name:RevolutionUpload
N:game.disable_trade:0
N:game.disable_booth:0
N:db.user.thread:4
N:console.port:44452
T:game.min_global_chat_usable_level:80
S:console.allow_ip:192.168.0.151
N:game.PKPenaltyLevel:10
N:game.use_account_authority_db:1
N:game.use_time_based_event_db:0
N:game.term_for_time_based_event_db:0
N:game.use_time_based_event_script:0
N:game.term_for_time_based_event_script:0
N:game.item_expert_cube :1
N:game.item_expert_grade:0
N:game.gold_drop_base:5000
F:game.gold_drop_percent:0.75
N:game.min_speed:1
N:game.amplify_level:0
N:game.amplify_hp:0
N:game.exception_arabic:0
N:game.exception_921:0
F:game.card_drop_rate:1.0
N:game.enhance_chance:1
N:game.enhance_chance_min:1
N:game.enhance_chance_max:10
N:game.enhance_destroy_level:8
F:game.quest_bonus_rate:4.0
N:game.quest_bonus_level:130.0
N:game.HardcoreServer:0
N:game.check_area:0
F:game.party_exp_rate_0:25
F:game.party_exp_rate_1:25
F:game.party_exp_rate_2:27
F:game.party_exp_rate_3:29
F:game.party_exp_rate_4:29
F:game.party_exp_rate_5:30
F:game.party_exp_rate_6:30
N:game.party_exp_penalty_level:5
N:game.summon_exp_penalty_level:10
F:game.killed_drop:0.03
I:game.crime_state:1
I:game.crime_party:1
F:game.killed_exp_percentage:1.0
F:game.kill_immoral_percentage:1.0
F:game.monster_regen_boss:5
F:game.monster_regen:5
N:game.max_characters_per_account:12
T:game.log.working:1
T:log.chat.working:1
N:game.ignore_client_binary:0
N:game.security_solution_type:0

there is a url-replacement in this spoiler.
here the line:

S:game.url_list:guild.url:|http://guilds.rappelz.ae/gicons/|guild_test_download.url|gicons/|web_download|guilds.rappelz.ae|web_download_port|0|shop.url|http://192.168.0.151:80/shop|ghelp_url|http://help.gamepower7.com/help/help-page/help-page.html|guild_icon_upload.ip|192.168.0.151|guild_icon_upload.port|4615

my authserver.opt:

 Spoiler

S:app.name:AuthServer
S:auth.allowed_special_char:@.
N:auth.check_adult_server:0
N:auth.max_client_per_ip:9999
N:auth.max_daily_client_per_ip:9999999
N:auth.user_rate_mod:20
#N:auth.version:201507080
S:io.ip_address:192.168.0.100
S:db.auth._password:
S:db.auth.account:rappelz
S db.auth.port:1433
S:db.auth.md5_key:2011
S:db.auth.name:Auth
S:db.auth.server:192.168.0.100
N:io.auth.port:9881
S:db.billing.account:rappelz
S:db.billing.name:BILLING
S:db.billing.server:192.168.0.100
N:db.auth.use_md5:1
N:db.auth.use_md5_for_security_no:1
N:game.user_limit_server_001:400
S:log.ip:192.168.0.151
N:billing.allow_login_without_billing:0
N:billing.check_server_keep_alive_timeout:0
N:billing.server_keep_alive_interval:6000
N:billing.server_keep_alive_timeout:3000
N:billing.use:0
N:billing.user_keep_alive_interval:60000
N:billing.user_keep_alive_timeout:3000

my login.bat:

 Spoiler

RappelzCmdLauncher.exe SFrame.exe /auth_ip:192.168.0.151 /auth_port:9881 /use_nprotect:0 /allow_double_exec:1 /network.max_msg_process:1 /help_url_w:611 /help_url_h:625 /locale:ASCII /country:US /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631 /network.max_msg_process:1 /gift

maybe somebody can help.

thanks in advance

(the nerd in me did backups before... )

[iononline]

Work. thank

[AbdulazizRD]

Originally Posted by PetTrainer

Hi Guys,

i need a little help... when i open the Admin site i become a error ...

 Spoiler

PHP Fatal error: Uncaught Error: Class 'querydb' not found in .........\Store\Admin\index.php:12
Stack trace:
#0 {main}
thrown in ........\Store\Admin\index.php on line 12

that's at line 12 in index.php:

 Spoiler

$Database = new querydb();

whats the Problem ?

Is there anyone who knows the solution to this problem?

[Ghost Informatics]

Originally Posted by AbdulazizRD

Is there anyone who knows the solution to this problem?

Did you modify anything in the shop files?

I will apply some fixes and updates to the shop this month. follow the Github repo.

[AbdulazizRD]

Originally Posted by Ghost Informatics

Did you modify anything in the shop files?

I will apply some fixes and updates to the shop this month. follow the Github repo.

Thanks Ghost

i Love You

[oODeadYouOo]

Originally Posted by ilyaslord36

anoter error when i buying a item give this error

In case anyone is looking for an answer to the above error. I will redirect you to the following path so you can have a chance to find out what is wrong. For me the path is E:\xampp\htdocs\shop\include\player.php.

Good luck.


Translated with Deepl.com

[harmbasi]

Hi everyone, I finally got the shop to load but it doesn't load correctly. See image. What am I missing?

[ThunderNikk]

I am not really sure but according to your image you may want to take a look at the index.php line 13

[harmbasi]

Originally Posted by ThunderNikk

I am not really sure but according to your image you may want to take a look at the index.php line 13

How about the formatting as well. It's all black. Also only a few items load in the shop (which work and can be bought and imported into game). Mostly its just blank.

[ThunderNikk]

As much as I know about websites if your website fails to read a file correctly because of a line error it stops reading it right there. It doesn't say there's and error and then continue reading the rest of it to finish the formatting of the site. Error and its over.

As far as adding items I think you have to add your own items to it. There are a few by default but you need to add the rest of what you want.

[Ghost Informatics]

Originally Posted by harmbasi

Hi everyone, I finally got the shop to load but it doesn't load correctly. See image. What am I missing?

Please provide us with this information so we can help you:

1. Your PHP version.
2. MySQL version.
3. SQLServer version.
4. Which server file repack are you using?

Please note - we recommend you to use :

• PHP version 7.2 with PDO Driver.
• You need to install the SMP to your database to make the shop works ()
• Please read this .

[harmbasi]

Thanks for the help. I have it up and running. There are visual issues but I can work around those. The colours were causing issues so I just modified the background images to make it work. For anyone else, you have to clear the cache in Internet Explorer if you change the images or it loads the old files.

Only thing left for me is, within the category when you have your items. If I have more than 6 items, it just pushes that below the footer, instead of creating a scroll bar or a 2nd page. Does anyone have tips on how to have the page automatically create a 2nd page or scroll bar once the page is full.

I looked through the viewer files but couldn't figure it out.

Thanks,

[ilyaslord36]

How i can remove 2 borders 1px frame inside interface of store.
And how to link the store with number of pages
Page 1.2.3.4.5
Plz help me

[harmbasi]

Originally Posted by ilyaslord36

How i can remove 2 borders 1px frame inside interface of store.
And how to link the store with number of pages
Page 1.2.3.4.5
Plz help me

I was looking for something similar but didn't get anywhere. I found my own solution. I ended up adding a scroll bar instead of page numbers.

To do this, you need to modify the index.tpl file in the viewer folder for the screen you are trying to edit.

Find this code in the index.tpl, it's close to the top.

    <aside id="left">
        <article>
            <ul id="left_menu">
                <li><a href="<?= URL ?>?go=supplies&type=general_supplies"><img src="img/bullet.png">General Supplies</a><p></p></li>
                <li><a href="<?= URL ?>?go=supplies&type=general_summon"><img src="img/bullet.png">Summon Supplies</a><p></p></li>
            </ul>
        </article>                   
    </aside>
    <div id="bodyOrignal">
        <div class="row">

Change "<div id="bodyOriginal"> to:

    <aside id="left">
        <article>
            <ul id="left_menu">
                <li><a href="<?= URL ?>?go=supplies&type=general_supplies"><img src="img/bullet.png">General Supplies</a><p></p></li>
                <li><a href="<?= URL ?>?go=supplies&type=general_summon"><img src="img/bullet.png">Summon Supplies</a><p></p></li>
            </ul>
        </article>                   
    </aside>
    <div id="bodyOrignal" style="width: 530px;height: 420px; overflow: scroll;>
        <div class="row">

This is the result in game: