[Help]Character Name Locations is Database

10/24/2010 02:17 King_Arthur#1
I am looking for a little help from the community on my [Only registered and activated users can see links. Click Here To Register...]. A previously requested feature was to be able to change names from within the program. I could have done this in the past, but I wanted to do it right and this requires a little help.

I need the location to every reference to a character's name, that way when a character name change is done through the panel, all references are updated. Everyone can pitch in what they know, and I don't expect just one person to give them all (unless one of you uber owners already made a list in some notepad file on your computer ;)) This will be helpful to me as I don't have an active database where all features of the database would be updated.

I would like them is this format:

cq_user.name

I'll start here and update as entries are added:

Table Field
cq_ad_log user_name
cq_addresslist link_name
cq_announce name
cq_donation_dynasort_rec user_name
cq_dyna_rank_rec user_name
cq_enemy enemyname
cq_eudemon ori_owner_name
cq_family create_name
cq_family leader_name
cq_friend friendname
cq_gm_checkpunish user_name
cq_item forgename
cq_leaveword send_name
cq_leaveword user_name
cq_partner partner_name
cq_pk_bonus hunter_name
cq_pk_bonus target_name
cq_pk_item hunter_name
cq_pk_item target_name
cq_suspicion_log user_name
cq_syndicate leader_name
cq_tutor tutor_name
cq_tutor user_name
cq_tutor_contributions student_name
cq_tutor_contributions2 student_name
cq_user name
10/24/2010 03:14 karnyge#2
I know you said you didnt want only one person to do it all, but i was somewhat bored - enjoy.

I am not really sure if any of this will help, but here goes-

account - name
cq_addresslist - link_name ?
cq_gm_punish - user_name
cq_ad_log - user_name
cq_ad_queue - user_name
cq_advert_log - user_name
cq_advert_queue - user_name
cq_announce - name
cq_auction_system - forgename
cq_donation_dynasort_rec - user_name
cq_dynamap - name ?
cq_enemy - enemyname
cq_eudemon - ori_owner_name
cq_leaveword -user_name
cq_mercenary -user_name
cq_partner -partner_name
cq_pk_item - target_name and hunter_name
cq_suspicion_log - user_name
cq_tutor - user_name and tutor_name
cq_tutor_contributions - student_name
cq_tutor_contributions2 - student_name

As for updating or not, I am not sure which ones. All i was looking for was character names and what tables they are found in. Sorry i couldnt be more helpful.
The two with a question mark, ?, I dont know what they are but have included them anyway.
10/24/2010 03:42 funhacker#3
you have missed out some of the legion ones in case you forgot. But names for some are client side sadly :(

I would look it over and send them all to you but just like you I don't have a database set up on my computer at the moment.
10/29/2010 02:58 King_Arthur#4
Ok so after going through karnyge's list (thanks even though a lot of tables were misspelled :p) I decided on copying my test db, truncating it, and searching for all occurrences of "name" and using that. Anything that didn't look like it needed to be added was left out, so this is what I will be working with. If anyone else thinks there is something to add just post.
10/29/2010 07:30 ~WARNING~#5
ill take a look at my database and post any that u guys missed.