[Help] DTWeb 2.0 Release erro Jewels Bank

[kallixtho]

can someone help me with this error in Jewels Bank error occurs when add chaos in Jewels Bank?

 

[dota-sdso]

can someone help me with this error in Jewels Bank error occurs when add chaos in Jewels Bank?

Obviously someone tried to debug something and forgot to remove the notes after.

 

[kallixtho]

can you tell me how I solve this error

 

[dota-sdso]

Which version are you using?

 

[kallixtho]

DTweb 2.0 (r00tme v1.18)

 

[dota-sdso]

Try version 1.19... I do not remember what was the difference between the two, but it could help.

But someone, as I said, tried to debug something as this array message should not appear there. Try with a new installation.

 

[kallixtho]

DTweb 2.0 (r00tme v1.19) Fixed Jewels Bank Error
I have an error asking for this TABLE [dbo]. [Market]

do I have to create 2 tables TABLE [dbo]. [Market] + TABLE [dbo]. [DTWeb_Market] or modify the table of the file you are requesting?

TABLE [dbo]. [DTWeb_Market] <=== table creates

 

[dota-sdso]

@kallixtho, Look which module request that "Market" table and replace the query to "DTWeb_Market". Don't rename the SQL tables they should be named with DT on the front. Edit only the query inside the PHP module script that looks for Market instead of DTWeb_Market or you will break the rest that works properly.

 

[kallixtho]

hello r00tme sorry for the inconvenience but you could help me with this error Status: Online 18295d 23h 2m 52s.

website

 

[dota-sdso]

I don't remember such information on the character information page, is it something else that you have added?. My common sense tells me that it reads from [DisConnectTM] column in [MEMB_STAT]. You probably have old records there, just delete them. This table column record will get updated once you logout the game.


PS. 18295 days are like 50 years, the game is 15 years old so that does not make any sense. This function is either broken or reads something else than the suggested column value.

 

[kallixtho]

http://flags.fmcdn.net/data/flags/normal/ this offline site has another way of placing the flag of the countries of destination of the players in the ranking?

 

[dota-sdso]

You can download all flags from here, for example -> https://flagpedia.net/download and unrar the content in /imgs/flags/ folder.

Then go to /mod/rankings/ , open rank-characters.php and find the line:

$flags = "<img width='20px' height='15px'src='http://flags.fmcdn.net/data/flags/normal/". strtolower(geoip_country_code_by_addr(geo_data(), $select_ip['IP'])).".png'/> ";

and replace it with:

$flags = "<img width='20px' height='15px'src='/imgs/flags/". strtolower(geoip_country_code_by_addr(geo_data(), $select_ip['IP'])).".png'/> ";

This is just an example of how it can be done. Don't take it literally but as a reference.

 

[kallixtho]

r00tme thanks for the help on the flags.

 

[kallixtho]

HELLO r00tme how do I prevent from creating 2 equal accounts one with lowercase letters and the other with uppercase letter?

 

[ivowe3]

HELLO r00tme how do I prevent from creating 2 equal accounts one with lowercase letters and the other with uppercase letter?

Easiest fix is:
In file getname.php dir inc replace this:

$sql="SELECT * FROM MEMB_INFO WHERE memb___id='".$name."'";

with this:

$name = strtoupper($name);
    $sql="SELECT * FROM MEMB_INFO WHERE UPPER(memb___id)=UPPER('".$name."')";

And in file modules_funcs.php in dir inc add this after line 575:

$acc =  strtoupper($acc);

line 575(do not remove):

$acc = clean_post($_POST['account']);

and
replace this:

mssql_query("SELECT memb___id FROM MEMB_INFO WHERE UPPER(memb___id)='". $acc ."' OR mail_addr='". $mail ."'")

with this:

mssql_query("SELECT memb___id FROM MEMB_INFO WHERE UPPER(memb___id)=UPPER('". $acc ."') OR mail_addr='". $mail ."'")

 

[dota-sdso]

Great solution from my friend @ivowe3, I am wondering how he had the time and desire to take a look into the code and give you so precise workout. The other option is to re-design the memb___id column to be case sensitive, then the SQL will recognise those two accounts as different ones.

Following this article https://www.webucator.com/how-to/how-check-case-sensitivity-sql-server.cfm

In general, you have to use collation with prefix "CS" instead of "CI" where CS stands for case sensitive.

 

[kallixtho]

ivowe3 and r00tme thanks for taking a few minutes of your time to help me

 

[kallixtho]

hello r00tme to this error with SQL 2008 you can help me again.


Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: localhost in C:\xampp\htdocs\configs\config.php on line 528
Couldn't connect to SQL Server!

 

[dota-sdso]

Credentials, server name/ instance or wrong database name is the problem

 

[kallixtho]

the error was in $ sql host = 'Your Computer Name'; online website

Link website Online