Help with adminpanel [Sapphire flyff]

07/29/2015 18:10 laitila#1

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

[Only registered and activated users can see links. Click Here To Register...]

Does anyone know which files to configure?

07/29/2015 18:21 -Venom'#2

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

lik this:
[Only registered and activated users can see links. Click Here To Register...]

Sorry for my bad English

07/29/2015 18:34 .HeyEyay.#3

xinc_config.php

Spoiler

07/29/2015 20:29 laitila#4

Thanks to both of you!

I ran in into a new problem though

[Only registered and activated users can see links. Click Here To Register...]

does any one know how to fix this?

07/29/2015 20:31 -Venom'#5

Quote:

Originally Posted by laitila

Thanks to both of you!

I ran in into a new problem though

[Only registered and activated users can see links. Click Here To Register...]

does any one know how to fix this?

Edit the datetime in your Website Config

dbDatetime in Config:
Make it so :

Code:

Y-m-d H:i:s

07/29/2015 20:42 laitila#6

like that?
[Only registered and activated users can see links. Click Here To Register...]

Still doesn't work :/

07/29/2015 21:21 ╠ KαѕαιNσHαиα ╣#7

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?

07/29/2015 21:35 laitila#8

Quote:

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

07/29/2015 21:38 ╠ KαѕαιNσHαиα ╣#9

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.