[Help] DTWeb 2.0 Release erro Jewels Bank

kallixtho

New Member
Joined
Apr 10, 2019
Messages
19
Reaction score
2
can someone help me with this error in Jewels Bank error occurs when add chaos in Jewels Bank?
 

Attachments

  • imagem.JPG
    imagem.JPG
    163.9 KB · Views: 60

dota-sdso

Well-Known Member
Joined
Apr 30, 2014
Messages
590
Reaction score
822
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

New Member
Joined
Apr 10, 2019
Messages
19
Reaction score
2
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

Well-Known Member
Joined
Apr 30, 2014
Messages
590
Reaction score
822
@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

New Member
Joined
Apr 10, 2019
Messages
19
Reaction score
2
hello r00tme sorry for the inconvenience but you could help me with this error Status: Online 18295d 23h 2m 52s.

website

JNHDS3z.jpg
 
Last edited:

dota-sdso

Well-Known Member
Joined
Apr 30, 2014
Messages
590
Reaction score
822
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.
 
Last edited:
  • Love
Reactions: kallixtho

dota-sdso

Well-Known Member
Joined
Apr 30, 2014
Messages
590
Reaction score
822
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:

PHP:
$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:

PHP:
$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.
 
  • Love
Reactions: kallixtho

kallixtho

New Member
Joined
Apr 10, 2019
Messages
19
Reaction score
2
HELLO r00tme how do I prevent from creating 2 equal accounts one with lowercase letters and the other with uppercase letter?
imagem22.JPG
 
Last edited:

ivowe3

Wiki
Joined
Apr 1, 2009
Messages
1,218
Reaction score
1,280
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:
Code:
$sql="SELECT * FROM MEMB_INFO WHERE memb___id='".$name."'";
with this:
Code:
$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:
Code:
$acc =  strtoupper($acc);
line 575(do not remove):
Code:
$acc = clean_post($_POST['account']);
and
replace this:
Code:
mssql_query("SELECT memb___id FROM MEMB_INFO WHERE UPPER(memb___id)='". $acc ."' OR mail_addr='". $mail ."'")
with this:
Code:
mssql_query("SELECT memb___id FROM MEMB_INFO WHERE UPPER(memb___id)=UPPER('". $acc ."') OR mail_addr='". $mail ."'")
 

dota-sdso

Well-Known Member
Joined
Apr 30, 2014
Messages
590
Reaction score
822
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

New Member
Joined
Apr 10, 2019
Messages
19
Reaction score
2
ivowe3 and r00tme thanks for taking a few minutes of your time to help me

acc.JPG
 

kallixtho

New Member
Joined
Apr 10, 2019
Messages
19
Reaction score
2
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

Well-Known Member
Joined
Apr 30, 2014
Messages
590
Reaction score
822
Credentials, server name/ instance or wrong database name is the problem
 

Similar threads