IonutRO

1 minute ago, ReDraco said:

But... is by @ IonutRO

 

Hello! He is right, the design was made by @ TuoraArts

Quote

horse_skill_point,,t_choosed

You could just check the query step by step.

        if($sqlQry) {
			//send email
        }
        else {
          echo'<p class="meldung">Registrierung fehlgeschlagen: Der Account existiert bereits.</p>';
        }

Basically, if the insertion fails, it will always show that the account already exists. Error cases are not treated. Maybe one of the columns that are not included in the query does not have a default value. 

8 minutes ago, vinkogyorgy said:

thanks again! just one question, the registration page has no blank page how did this happen?

 

I think that GD library is not enabled. Check this: https://stackoverflow.com/questions/2283199/enabling-installing-gd-extension-without-gd

Just now, vinkogyorgy said:

thank you very much!

It works perfectly, I just can't log in to webadmin. Can you help me with that too?

In database (I think that you use navicat) got to account -> account and at the row of your account, set the value 9 on the column named "web_admin".

Just now, vinkogyorgy said:

very kind of you to reply so quickly, but this is sha1 I see. Or am I mistaken?

function getHashPassword($password)
    {
        $hash = "*".sha1(sha1($password, true));
        return strtoupper($hash);
    }

That is the equivalent of mysql PASSWORD() function. If you use sha1, just update it:

function getHashPassword($password)
{
    return sha1($password);
}

5 minutes ago, vinkogyorgy said:

Dear Support!

Your cms system is really great, but my mysql uses sha1 password, how can I change it to store sha1 password instead of md5 on the registration page?

Thank you in advance for your answer!

Hi! Just go in include/functions/basic.php and edit getHashPassword function.

Update v2.12

• Fixed XSS injection in donation list and player search, thanks to Xniveres.
• Rewrote the checks at Vote4Coins. It is completely solved.
• Remove extra files and unused functions. Fixed performance issues in existing functions.
• Fixed a serious issue on the admin side: in old versions, language/module/theme links were in the form, so they could be changed by someone with admin rights to upload any zip file to the site.
• Introduced default values for the columns that are created in the account during the first installation.
• Removed the query that excluded banned players. The method was a very bad poor, and on a server with a lot of players it would use a lot of mysql.
• Rewrote the function that checks for updates in administration. Now it is checked only once a day, so the official Metin2CMS website is no longer accessed.
• Fixed captcha, the problem was occurring when the site was not on the main domain.
• Now the character deletion code is a number.
• Updated PHPMailer and PCLZip libraries.
• Added a new language: Arabic.

Congratulations! I'm glad you were able to provide an update to the community. Good work!

25 minutes ago, Brayan said:

This Metin2CMS have issues in index.php and he need for sure some Developer to have a look what's the problem to fix it.

What about index.php? And also, on register part, you need to have default values for all columns in account.account, or just allow them NULL.

1 hour ago, Eter789 said:

How we can download the list of items, 

with code and name in different languages?

Thanks in advance

4 hours ago, ByLost said:

 

The idea is not to click on anything. It already enters directly, and to remove this option, it would be deleting the text file generated at the client root.

Sorry, I missed the point where you want to enter directly, without going through the login and character selection phase.  

You can start with the structure of the login saver system. When you log in, you save your username and password in some variables in winreg. Likewise, when you select the character, you save something unique for identification, such as name or id.

And, after all this, when you open the client, you check if you have something saved in that variable, if so, you fill them in the user and password fields, and simply in python simulate pressing the login button. If the login was successful, wait for the characters to load, and then check if you have stored one, if so, select it.

Update[19.05.2021]:

• Several objects have been added.  (4929 items)
• The site has been slightly optimized.

Just set default values to all columns in account.account or allow them NULL.

Try just to save only what is important in log tables...

There may be several reasons... Do you have ssl on your site?

Wrong names in input values, in the php cehck you have:

$_POST ['title'] ; $_POST ['content']

But in the html part you have:

<input type="text" size="40" maxlength="200" name="titel" />
<textarea style="resize: none;" rows="5" cols="40" name="inhalt">

The names must match.

Ok, but did you try to show the error at the attempting connection in the site? ...

7 hours ago, ASIKOO said:

 Dead Download Link 

 Moved Topic 

 

If someone has the archive of this topic, can you send it to us? Thank you!

 

6 minutes ago, Mustang said:

Hi Ionut,

 

 

in your code " return result it generates a syserr

 

1016 10:14:05861 :: TypeError 1016 10:14:05861 :: : 1016 10:14:05861 :: an integer is required

 

maybe in this way, he can't return 2 values ?

You also need to rewrite the code where you call GET_ACCESSORY_MATERIAL_VNUM(), in this moment is expected only one int number. In the new function, will return an array with 2 int numbers.

You can't just return in the first loop, a return means that the function did the job, and has an result, anythink after return will not be used. One example about what can you do:

def GET_ACCESSORY_MATERIAL_VNUM(vnum, subType):
	ret = vnum
	item_base = (vnum / 10) * 10

	result = [None, None]

	for info in JewelAccessoryInfos:
		if item.ARMOR_WRIST == subType:
			if info[1] == item_base:
				result[0] = info[0]
		elif item.ARMOR_NECK == subType:
			if info[2] == item_base:
				result[0] = info[0]
		elif item.ARMOR_EAR == subType:
			if info[3] == item_base:
				result[0] = info[0]

	for info2 in JewelAccessoryInfos2:
		if item.ARMOR_WRIST == subType:
			if info2[1] == item_base:
				result[1] = info2[0]
		elif item.ARMOR_NECK == subType:
			if info2[2] == item_base:
				result[1] = info2[0]
		elif item.ARMOR_EAR == subType:
			if info2[3] == item_base:
				result[1] = info2[0]
    
	return result #will be [info[0], info2[0]]

7 minutes ago, Defacer35 said:

Hello, it's possible i think but problem is i dont know how to exactly do it.

 

I just want the delete useless tables, like this ones ;

 

 

Thanks for the advices.

 

Best Regards.

These are tables provided by websites, you don't need them, only if your homepage use them, you can delete them by select them -> right click -> delete. 

It is impossible to have no more ids........