dlgjoin.cpp

visual C++ mysql Connect Source

// DlgJoin.cpp : implementation file
//

#include "stdafx.h"
#include "Sample.h"
#include "DlgJoin.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDlgJoin dialog


CDlgJoin::CDlgJoin(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgJoin::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDlgJoin)
	m_strID = _T("");
	m_strPassword = _T("");
	m_strPassword2 = _T("");
	m_strRec = _T("");
	//}}AFX_DATA_INIT
}


void CDlgJoin::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgJoin)
	DDX_Control(pDX, IDC_REC, m_Rec);
	DDX_Control(pDX, IDC_PASSWORD2, m_Password2);
	DDX_Control(pDX, IDC_PASSWORD, m_Password);
	DDX_Control(pDX, IDC_ID, m_ID);
	DDX_Text(pDX, IDC_ID, m_strID);
	DDX_Text(pDX, IDC_PASSWORD, m_strPassword);
	DDX_Text(pDX, IDC_PASSWORD2, m_strPassword2);
	DDX_Text(pDX, IDC_REC, m_strRec);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDlgJoin, CDialog)
	//{{AFX_MSG_MAP(CDlgJoin)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgJoin message handlers

BOOL CDlgJoin::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDlgJoin::OnOK() 
{
	// 付瘤阜 锅龋绰 Admin 拌沥俊 历厘邓聪促
	// 付瘤阜 锅龋绰 LINE 侥喊磊肺 荤侩邓聪促
	
	UpdateData();
	
	// 鞘荐 涝仿亲格 id
	if(m_strID.GetLength() <= 0)
	{
		MessageBox("ID甫 涝仿窍绞矫坷", "Error", MB_OK|MB_ICONERROR);
		m_ID.SetFocus();
		return;
	}

	// 鞘荐 涝仿亲格 pw
	if(m_strPassword.GetLength() <= 0)
	{	
		MessageBox("Password甫 涝仿窍绞矫坷", "Error", MB_OK|MB_ICONERROR);
		m_Password.SetFocus();
		return;
	}

	// ..
	if(m_strPassword2.GetLength() <= 0)
	{	
		MessageBox("Password 犬牢鄂阑 涝仿窍绞矫坷", "Error", MB_OK|MB_ICONERROR);
		m_Password2.SetFocus();
		return;
	}

	if(strcmp(m_strPassword.GetBuffer(0), m_strPassword2.GetBuffer(0)) != 0)
	{
		MessageBox("Password啊 撇赋聪促", "Error", MB_OK|MB_ICONERROR);
		m_Rec.SetFocus();
		return;
	}

	if(m_strID.GetLength() > 8)
	{
		MessageBox("ID啊 8磊 捞惑涝聪促", "Error", MB_OK|MB_ICONERROR);
		m_ID.SetFocus();
		return;
	}

	if(m_strPassword.GetLength() > 15)
	{	
		MessageBox("Password啊 15磊 捞惑涝聪促", "Error", MB_OK|MB_ICONERROR);
		m_Password.SetFocus();
		return;
	}

	if(m_strRec.GetLength() > 8)
	{
		MessageBox("眠玫牢ID啊 8磊 捞惑涝聪促", "Error", MB_OK|MB_ICONERROR);
		m_Rec.SetFocus();
		return;
	}

	char Query[128];
	ZeroMemory(&Query[0], sizeof(Query));

	// ID 吝汗八荤
	sprintf(Query, "SELECT * FROM %s WHERE %s='%s'", TABLE, ID, m_strID.GetBuffer(0));
	if(mysql_query(&g_MySQL, Query))
	{
		MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
		return;
	}
	else
	{
		MYSQL_RES *result = mysql_store_result(&g_MySQL);

        if(result)
        {
			if(result->row_count) // 乐促搁
			{
				MessageBox("吝汗等 酒捞叼涝聪促", "Error", MB_OK|MB_ICONERROR);
				m_ID.SetFocus();
				return;
			}
		}
	}

	DWORD i;
	DWORD ln=0, Lastln=0; // 烙矫 付瘤阜 锅龋 历厘傍埃
	BYTE lv=0; // 烙矫 饭骇 历厘傍埃
	if(m_strRec != "")	// 啊涝磊啊 眠玫牢阑 涝仿沁促
	{
		// 眠玫牢狼 粮犁犬牢
		ZeroMemory(&Query[0], sizeof(Query));
		sprintf(Query, "SELECT * FROM %s WHERE %s='%s'", TABLE, ID, m_strRec.GetBuffer(0));
		if(mysql_query(&g_MySQL, Query))
		{
			MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
			return;
		}
		else
		{
			MYSQL_RES *result = mysql_store_result(&g_MySQL);

			if(result)
			{
				MYSQL_ROW row;
				if(result->row_count)
				{
					// 眠玫牢捞 粮犁茄促
					row = mysql_fetch_row(result);
					// 眠玫牢狼 饭骇 掘扁
					lv = atoi(row[3]); // lv;
					// 眠玫牢狼 扼牢 逞滚 掘扁
					ln = atoi(row[4]); // row[4] == line number;
				}
			}
			else
			{
				MessageBox("眠玫牢捞 粮犁窍瘤 臼嚼聪促", "Error", MB_OK|MB_ICONERROR);
				return;
			}
		}

		// 付瘤阜 逞滚 历厘
		ZeroMemory(&Query[0], sizeof(Query));
		sprintf(Query, "SELECT * FROM %s WHERE %s='%s'", TABLE, ID, ADMINISTRATOR_ID);
		if(mysql_query(&g_MySQL, Query))
		{
			MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
			return;
		}
		else
		{
			MYSQL_RES *result = mysql_store_result(&g_MySQL);
			if(result)
			{
				MYSQL_ROW row;
				if(result->row_count)
				{
					row = mysql_fetch_row(result);
					Lastln = atoi(row[4]);
				}
			}
			else
			{
				MessageBox("包府磊 拌沥捞 粮犁窍瘤 臼嚼聪促", "Error", MB_OK|MB_ICONERROR);
				return;
			}
		}

		// 眠玫牢狼 饭骇捞 1捞搁, 啊涝磊绰 2技措
		if(lv == 1)
		{
			// 货肺款 扼牢逞滚 惯鞭, 殿废
			// 2技措 殿废
			ZeroMemory(&Query[0], sizeof(Query));
			sprintf(Query, "INSERT INTO %s VALUES('%s','%s','%s',%d,%d)",
				TABLE, m_strID.GetBuffer(0), m_strPassword.GetBuffer(0),
				m_strRec.GetBuffer(0), ++lv, ++Lastln);
				if(mysql_query(&g_MySQL, Query))
				{
					MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
					return;
				}

				// 包府磊 拌沥 诀单捞飘
				ZeroMemory(&Query[0], sizeof(Query));
				sprintf(Query, "UPDATE %s SET %s=%d WHERE %s='%s'",
					TABLE, LAST_NUMBER, Lastln, ID, ADMINISTRATOR_ID);
				if(mysql_query(&g_MySQL, Query))
				{
					MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
					return;
				}
		}
		else if(lv < 4)	// 4窜拌焊促 累促搁 pass
		{
			// 眠玫牢捞 乐绊 5窜拌啊 酒囱 啊涝磊
			ZeroMemory(&Query[0], sizeof(Query));
						
			// 炼累 绝捞 殿废
			sprintf(Query, "INSERT INTO %s VALUES('%s','%s','%s',%d,%d)",
				TABLE, m_strID.GetBuffer(0), m_strPassword.GetBuffer(0),
				m_strRec.GetBuffer(0), ++lv, ln);
					
			if(mysql_query(&g_MySQL, Query))
			{
				MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
				return;
			}
		}
		else
		{
			// 2窜拌何磐 盒府 1窜拌究 棵覆
			// 扼牢逞滚 八祸
			ZeroMemory(&Query[0], sizeof(Query));
			sprintf(Query, "SELECT * FROM %s WHERE %s=%d ORDER BY %s", 
					TABLE, LAST_NUMBER, ln, LEVEL);
			if(mysql_query(&g_MySQL, Query))
			{
				MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
				return;
			}
		
			MYSQL_RES *result = mysql_store_result(&g_MySQL);
			if(result)
			{
				MYSQL_ROW row;
				for(i=0; i<result->row_count; i++)
				{
					row = mysql_fetch_row(result);
					BYTE tlv = atoi(row[3]);
					if(tlv != 1) // 1技措啊 酒聪绊
					if(strcmp(ADMINISTRATOR_ID, row[0]) != 0) // 绢靛刮 拌沥捞 酒聪搁
					{
						if(tlv == 2) // 2技措搁
						{
							ZeroMemory(&Query[0], sizeof(Query));
							sprintf(Query, "UPDATE %s SET %s=NULL, %s=%d, %s=%d WHERE %s='%s'", 
								TABLE, RECOMMENDER, 
								LEVEL, --tlv, 
								LAST_NUMBER, ++Lastln, 
								ID, row[0]);
							if(mysql_query(&g_MySQL, Query))
							{
								MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
								return;
							}
						}
						else if(tlv == 3)
						{
							ZeroMemory(&Query[0], sizeof(Query));
							sprintf(Query, "UPDATE %s SET %s=%d, %s=%d WHERE %s='%s'", 
								TABLE, LEVEL, --tlv, LAST_NUMBER, ++Lastln, ID, row[0]);
							if(mysql_query(&g_MySQL, Query))
							{
								MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
								return;
							}
						}
						else
						{
							// 唱狼 眠玫牢狼 沥焊 掘扁
							ZeroMemory(&Query[0], sizeof(Query));
							sprintf(Query, "SELECT * FROM %s WHERE %s='%s'", 
								TABLE, ID, row[2]);
							if(mysql_query(&g_MySQL, Query))
							{
								MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
								return;
							}
							else
							{
								MYSQL_RES *result2 = mysql_store_result(&g_MySQL);
								if(result2)
								{
									MYSQL_ROW row2;
									row2 = mysql_fetch_row(result2);

									DWORD Num = atoi(row2[4]);
									ZeroMemory(&Query[0], sizeof(Query));
									sprintf(Query, "UPDATE %s SET %s=%d, %s=%d WHERE %s='%s'", 
											TABLE, LEVEL, --tlv, LAST_NUMBER, Num, ID, row[0]);
									if(mysql_query(&g_MySQL, Query))
									{
										MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
										return;
									}

									// 货肺款 啊涝磊 眠啊
									ZeroMemory(&Query[0], sizeof(Query));
									sprintf(Query, "INSERT INTO %s VALUES('%s','%s','%s',%d,%d)",
										TABLE, m_strID.GetBuffer(0), m_strPassword.GetBuffer(0),
										m_strRec.GetBuffer(0), 4, Num);
									if(mysql_query(&g_MySQL, Query))
									{
										MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
										return;
									}
								}
							}
						}

						// 包府磊 拌沥 诀单捞飘
						ZeroMemory(&Query[0], sizeof(Query));
						sprintf(Query, "UPDATE %s SET %s=%d WHERE %s='%s'",
							TABLE, LAST_NUMBER, Lastln, ID, ADMINISTRATOR_ID);
						if(mysql_query(&g_MySQL, Query))
						{
							MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
							return;
						}
					}
				}
			}
		}
	}
	else
	{
		// 眠玫牢 涝仿窍瘤 臼澜
		ZeroMemory(&Query[0], sizeof(Query));
		sprintf(Query, "SELECT * FROM %s WHERE %s='%s'",
			TABLE, ID, ADMINISTRATOR_ID);
		if(mysql_query(&g_MySQL, Query))
		{
			MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
			return;
		}
		else
		{
			MYSQL_RES *result = mysql_store_result(&g_MySQL);

			if(result)
			{
				MYSQL_ROW row;
				if(result->row_count)
				{
					row = mysql_fetch_row(result);
					// 绢靛刮 拌沥俊辑 Last Line Number甫 掘澜
					ln = atoi(row[4]);

					// 眠玫牢 绝绰 啊涝磊(1技措, 春 扼牢)
					ZeroMemory(&Query[0], sizeof(Query));
					sprintf(Query, "INSERT INTO %s VALUES('%s','%s',NULL,%d,%d)",
						TABLE, m_strID.GetBuffer(0), m_strPassword.GetBuffer(0), 1, ++ln);
					if(mysql_query(&g_MySQL, Query))
					{
						MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
						return;
					}

					// 绢靛刮 拌沥 诀单捞飘
					ZeroMemory(&Query[0], sizeof(Query));	
					sprintf(Query, "UPDATE %s SET %s=%d WHERE %s='%s'",
						TABLE, LAST_NUMBER, ln, ID, ADMINISTRATOR_ID);
					if(mysql_query(&g_MySQL, Query))
					{
						MessageBox("Query 傈价 角菩", "Error", MB_OK|MB_ICONERROR);
						return;
					}
				}
				else
				{
					MessageBox("包府磊 拌沥捞 粮犁窍瘤 臼嚼聪促", "Error", MB_OK|MB_ICONERROR);
					return;
				}
			}
		}
	}
	
	CDialog::OnOK();
}