Register for your free account! | Forgot your password?

You last visited: Today at 09:30

  • Please register to post and access all features, it's quick, easy and FREE!

 

HELP with database

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Dec 2009
Posts: 220
Received Thanks: 59
HELP with database

Hy, i delete my char,pets von database and afterwards I create the same again.

Nevertheless I have still the same Item of pieces in the Inventory and/or the weapons of the old Char. Which cq_…. is where one it to delete can?

I have Problem with dyna_medal_rank.

I donate for King, but the symbol apart from the names is not indicated.

and why i have a green name when i have my equitment completely?

where can i change this

ty for help



chathouse is offline  
Old   #2
 
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 885
The first one is a quicky:
Quote:
Originally Posted by rexes13 View Post
Run this script in your database...
Code:
DELETE from my2.cq_user;
DELETE from my2.cq_eudemon;
DELETE from my2.cq_item;
DELETE from my2.account;
DELETE from my2.cq_castle;
DELETE from my2.cq_castleitem;
DELETE from my2.cq_castlemap;
DELETE from my2.cq_enemy;
DELETE from my2.e_money;
DELETE from my2.cq_donation_dynasort_rec;
DELETE from my2.cq_friend;
DELETE from my2.cq_ad_log;
DELETE from my2.cq_announce;
DELETE from my2.cq_deluser;
DELETE from my2.cq_dyna_rank_rec;
DELETE from my2.cq_family;
DELETE from my2.cq_flower;
DELETE from my2.cq_magic;
DELETE from my2.cq_partner;
DELETE from my2.cq_pk_bonus;
DELETE from my2.cq_shortcut_key;
DELETE from my2.cq_special_status;
DELETE from my2.cq_statistic;
DELETE from my2.cq_synattr;
DELETE from my2.cq_syndicate;
DELETE from my2.cq_trade;
DELETE from my2.cq_tutor;
DELETE from my2.cq_tutor_contributions;


King_Arthur is offline  
Thanks
1 User
Old   #3
 
elite*gold: 0
Join Date: Dec 2009
Posts: 220
Received Thanks: 59
Quote:
Originally Posted by King_Arthur View Post
The first one is a quicky:

nope I do not want to delete the tables completely there functioned nothing at all more.

The creation items if the user registered is in cq_item
That I found out and I emptied now. Now I have nevertheless the next problem. which it me with cq_eudemon.

The Char does not add whom the Pet thus belonged and/or which names of the Pets not.

I have with to provide one chars only 2 eggs in more hatcher which I not use cannot. And there is error in it.

I wanted only an ID reconciliation. more cq_user, cq_eudemon, cq_items with Truncate

ahh sry i delete only contents of the tables.

It thanks functioned now again without problems times. Which I see with the first view.
chathouse is offline  
Old   #4
 
elite*gold: 0
Join Date: Apr 2008
Posts: 19
Received Thanks: 2
ok i used the code above but still have castles and nobility ranks how do i del them

ok i restared the server and no ranks now but still got castles make i wanna del them
and also i noticed that when i 2nd evolve my euds they dont start at id number 1 its at like 2870 sum? ne one no how to reset them


XxTopsyKrettxX is offline  
Old   #5
 
elite*gold: 0
Join Date: Oct 2007
Posts: 680
Received Thanks: 804
Your problem has been fixed by Crues magical powers. (: yw.


cruey is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Database (help) :(
Hello Dudes I got a Problem , my Character database was Droped by a SQL Injection (i think) and i dont want open anymore cuz it is not command...
5 Replies - Dekaron Private Server
Database
Hey liebe Com!!! kann mir eienr nen link schicken für die metin2 database wäre echt nett :handsdown::handsdown:
12 Replies - Metin2 PServer - Discussions / Questions
DataBase
Hallo Leuts Ich habe ein Problem, ich suche schon seite einem Tag und finde die DB nicht. Und meine frage ist : hat einer einen LInk um die db...
11 Replies - Metin2 PServer - Discussions / Questions
new database
N'abend also ich habe da mal eine frage. Es war ja mal so dass die clubmt2 datenbank mal "gehackt" worden ist und zum download bereit stand. ich...
7 Replies - Metin2 PServer - Discussions / Questions
Help me with database.
:handsdown:I can't register my friends on my server because> database doesn't work?To say simple i can't create a new account. Someone please help...
5 Replies - CO2 PServer - Discussions / Questions



All times are GMT +1. The time now is 09:30.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.