Register for your free account! | Forgot your password?

You last visited: Today at 17:16

  • 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 01/31/2010, 14:20   #2
 
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 887
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 01/31/2010, 14:32   #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 02/08/2010, 01:27   #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 02/08/2010, 06:57   #5
 
elite*gold: 0
Join Date: Oct 2007
Posts: 680
Received Thanks: 811
Your problem has been fixed by Crues magical powers. (: yw.


cruey is offline  
Reply



« where to get newest patch | [Question] What is *.c3 »

Similar Threads
Database (help) :(
01/26/2010 - Dekaron Private Server - 5 Replies
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 there to stop such attacks. i was looking for a comand like mysql_escape_string() mysql_real_escape_string()
Database
01/06/2010 - Metin2 PServer - Discussions / Questions - 12 Replies
Hey liebe Com!!! kann mir eienr nen link schicken für die metin2 database wäre echt nett :handsdown::handsdown:
DataBase
10/16/2009 - Metin2 PServer - Discussions / Questions - 11 Replies
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 downzuloaden?? Sorry das ich jetzt ein neues Thema erstellt habe , aber ich kamm wirklich nicht weiter.
new database
10/16/2009 - Metin2 PServer - Discussions / Questions - 7 Replies
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 hätte sie gerne doch ich finde nichts ordentliches mit der sufu und google. wenn sie jemand noch hat pls pn me. mfg greivel
Help me with database.
07/13/2009 - CO2 PServer - Discussions / Questions - 5 Replies
: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 me with this problem.TY:)



All times are GMT +1. The time now is 17:16.


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

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