Help with adminpanel [Sapphire flyff]

[laitila]

Alright so i use the sapphire flyff website, but i have no idea how to use the adminpanel i only get this message




Does anyone know which files to configure?

[-Venom']

set the Auth in your Database to "Z" an set your name in the Website Config.

lik this:


Sorry for my bad English

[.HeyEyay.]

xinc_config.php

 Spoiler

$_CONFIG['allg_svr_admins'] = array('account ID','Lucky'); // Adminaccounts, (Zugriff auf Admin/GM-Panel, Website trotz Wartungsmodus betretbar, [...])

[laitila]

Thanks to both of you!

I ran in into a new problem though



does any one know how to fix this?

[-Venom']

Originally Posted by laitila

Thanks to both of you!

I ran in into a new problem though



does any one know how to fix this?

Edit the datetime in your Website Config

dbDatetime in Config:
Make it so :

Y-m-d H:i:s

[laitila]

like that?


Still doesn't work :/

[╠ KαѕαιNσHαиα ╣]

Which version of the website are you using?

v2.2 or with Cronjobs? Because them differs.

If you are using the version I translated to English (which is v2.2), the meaning of the error is:
The query has encountered a problem or error and so it fails to insert the item into the database.
So probably issues with your database.

Have you properly edited the configuration file: /includes/xinc_config.php about your DB infos?

[laitila]

Originally Posted by ╠ KαѕαιNσHαиα ╣

Which version of the website are you using?

v2.2 or with Cronjobs? Because them differs.

If you are using the version I translated to English (which is v2.2), the meaning of the error is:
The query has encountered a problem or error and so it fails to insert the item into the database.
So probably issues with your database.

Have you properly edited the configuration file: /includes/xinc_config.php about your DB infos?

2.2 Yes! anychance u can teamview and check my databases?

thanks for helping

[╠ KαѕαιNσHαиα ╣]

I usually don't do that for free, as I offer professional services.
However since your issue seems to be pretty fast solving, I might give a fast check.

PM me your TW details.

--EDIT--

#Issue solved

In case anyone experiencing the same problem, this is how you fix it:

- Open \sites\shop.php
- Go to line: 127
- Edit the following 3 lines to appear like this:

PHP Code:

if(isset($_POST['shopBuyItem'])) {
    $get_date = date('Y-m-d H:i:s');
        if( @odbc_exec($odbc_connect, $strUpdateBalance) 


- Go to line: 147
- Edit the line to look like this one:

PHP Code:

\''. $get_date .'\' 


- Go to line: 160
- Edit the following 3 lines to appear like this:

PHP Code:

elseif(isset($_POST['shopGiftItem'])) {
    $get_date = date('Y-m-d H:i:s');
    if( @odbc_exec($odbc_connect, $strUpdateBalance) 


- Go to line: 184
- Edit the line to look like this one:

PHP Code:

\''. $get_date .'\' 


- Done.

What was the issue?

The original format date string/obtain
Was passing an invalid date format for MSSQL database.