Jump to content
×
×
  • Create New...
  • 0

fish_log has no real colum name


Gl0bal

Question

  • Premium

Hey today I noticed, that some log tables has no real colum names.

For example the fish_log table looks like that:

CcZ7N1H.png

Does anybody here has a better fish_log than I?

It's is nearly imposible to work with this.

 

 

Sorry for my bad english :(

 

Regards

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0
  • Premium
Query("INSERT INTO fish_log%s VALUES(NOW(), %u, %d, %u, %d, %u, %u, %u)",
			get_table_postfix(),
			dwPID,
			prob_idx,
			fish_id,
			fish_level,
			dwMiliseconds,
			dwVnum,
			dwValue);

Set your column name to the right.

1 -> datatime

2 -> player_id

3 -> prob_idx

4 -> fish_id

5 -> fish_level

6 -> miliseconds (unix timestamp)

7 -> vnum

8 -> value

  • Love 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.